Appendix A - Primary Data Tables |
|
USTUR health physics database |
 Index |
 A.1 tbl_AirMonitoring |
A.6 tbl_InVitro |
| A.2 tbl_Contamination |
A.7 tbl_InVivo |
| A.3 tbl_External |
A.8 tbl_Treatment |
| A.4 tbl_HealthPhysics |
A.9 tbl_WorksiteAssessments |
| A.5 tbl_Incidents |
Table A.1 tbl_AirMonitoring Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (AirMonitorID_No) | Number | Unique record number that links Air Monitoring records to tbl_HealthPhysics. Primary key. | Yes | |
| C# (HP) (Case_No_AM) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Time Pulled (Time_Pulled) |
Date/ Time | Time that the air sample was removed from the air sampler (end of sampling period). | Yes | |
| Contaminant(s) (Contaminants_Abbrev) |
Text | Primary contaminant(s) i.e. radionuclide(s) or type of radiation. | vRadMixture | Yes |
| Location (Location) |
Text | Building where the air sample was collected (area, building, room). | No | |
| Sample Period (Reported_SamplePeriod) |
Number | Air Sampling period as reported in the hard file. | No | |
| Period Unit (Reported_SamplePeriod _Unit) |
Text | Unit that [Sample_Period] is reported in. | vUnit | No |
| AMAD (AMAD) |
Number | Activity Mean Aerodynamic Diameter in micrometers. | No | |
| Reported Concentration: Value (Reported_Conc) |
Number | Concentration of activity reported in the hard file. | No | |
| Reported Concentration: Uncert (Reported_Conc_Uncert) |
Number | Uncertainty associated with [Reported_Conc] as reported in the hard file. | No | |
| Reported Concentration: Unit (Reported_Conc_Unit) |
Text | Units used by both [Reported_Conc] and [Reported_Conc_Uncert]. | vUnit | No |
| Derived Values: Sample Period (Derived_SamplePeriod) |
Number | [Reported_SamplePeriod] converted to days. | No | |
| Derived Values: Conc (Derived_Conc) |
Number | [Reported_Conc] converted to pCi/cc or MPC. | No | |
| Derived Values: Uncert (Derived_Uncert) |
Number | Uncertainty associated with [Deriveded_Conc] in pCi/cc or MPC. | No | |
| Derived Values: Unit (Derived_Unit) |
Text | Standardized unit (pCi/cc or MPC) associated with [Derived_Conc] and [Derived_Uncert]. | No | |
| Comments (Comments) |
Memo | Narrative comments providing clarification and additional information. | No | |
| Source (Source) |
Text | Source of reported Air Monitoring data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_AirMonitoring and the display name on the corresponding form are listed (they refer to the same value). The tbl_AirMonitoring field name is in parentheses. |
||||
Table A.2 tbl_Contamination Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (ContamID_No) | Number | Unique record number that links Contamination records to tbl_HealthPhysics. Primary key. | Yes | |
| C# (C) (Case_No_C) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Modality (Modality) |
Text | Type of contamination (Personal, Clothing, Workspace). | vContamination Mode | Yes |
| Location (Location) |
Text | Specific location/item that was contaminated (i.e. left thumb, shoe, floor). | Yes | |
| Measurement Date/Time (Incident_Time) |
Date/ Time | Date and Time of Contamination incident. | Yes | |
| Contaminant(s) (Contaminants_Abbrev) |
Text | Primary contaminant(s) i.e. radionuclide(s) or type of radiation. | vRadMixture | Yes |
| Reported Results: Inequality (Inequality) |
Text | Inequality symbol (>, <, >=, <=, =) used in conjunction with [Reported_Activity]. | vInequality | Yes |
| Reported Results: Activity (Reported_Activity) |
Number | Activity reported in the hard file (entered in the units that appear in the hard file). | Yes | |
| Reported Results: Unit (Reported_Unit) |
Text | Units of [Reported_Activity]; units should be same as in the hard file. | vUnit | No |
| Derived Values: Activity (Derived_Activity) |
Number | [Reported_Activity] converted to either dpm or cpm. | No | |
| Derived Values: Unit (Derived_Unit) |
Text | Standardized unit (dpm or cpm) associated with [Reported_Activity]. | No | |
| Detector Used (DetectorType) |
Text | The type of detector used to measure contamination levels. | No | |
| Decontamination Results (Decon_Results) |
Text | Text describing decontamination results (i.e. decontaminated to <500 dpm). | No | |
| Decontamination Agents (Decon_Agents) |
Text | A list of decontamination agents used. | No | |
| Comments (Comments) |
Memo | Narrative Comments providing clarification and additional information. | No | |
| Source (Source) |
Text | Source of reported Contamination data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_Contamination and the display name on the corresponding form are listed (they refer to the same value). The tbl_Contamination field name is in parentheses. |
||||
Table A.3 tbl_External Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (ExternalID_No) | Number | Unique record number that links External records to tbl_Health Physics. Primary key. | Yes | |
| C# (Ext) (Case_No_Ex) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Primary Identifier (Type) |
Text | Type of external radiation measurement (i.e. gamma, whole body, skin, extremity, etc.). | vExternalType | Yes |
| Details (Details) |
Text | Additional information that clarifies [Type] (optional, any text can be entered). | No | |
| Monitoring Period (MonitorPeriod) |
Text | Period of time for which external dosimetry data is being reported: Interval, Annual Sum, Cumulative, Lifetime. | vExternalMonPeriod | Yes |
| Dose Quantity (Dose_Quantity) |
Text | Type of external radiation quantity (Dose Equivalent, Exposure, or Absorbed Dose). | vExternalQuantity | Yes |
| Date/Time: Start (Exp_StartDate) |
Date/ Time | Beginning of 'exposure' period ('Exposure' is used loosely here and refers to Exposure, Dose Equivalent, and Absorbed Dose). | No | |
| Date/Time: End (Exp_EndDate) |
Date/ Time | End of 'exposure' period ('Exposure' is used loosely here and refers to Exposure, Dose Equivalent, and Absorbed Dose). | Yes | |
| Reported Results: Value (Reported_Value) |
Number | External measurement value reported in the hard file (using same units as hard file). | No | |
| Reported Results: Uncert (Reported_Value_Uncert) |
Number | Uncertainty associated with [Reported_Value]. | No | |
| Reported Results: Unit (Reported_Value_Unit) |
Text | Unit used for both [Reported_Value] and [Reported_Value_Uncert]. | vUnit | No |
| Derived Values: Exposure Period (Exp_Period) |
Number | 'Exposure' period ('Exposure' is used loosely here and refers to Exposure, Dose Equivalent, and Absorbed Dose). | No | |
| Derived Values: Value (Derived_Value) |
Number | [Reported_Value] converted to standardized units (Exposure - R, Dose Equivalent - rem, Absorbed Dose - rad). | No | |
| Derived Values: Uncert (Derived_Value_Uncert) |
Number | Uncertainty associated with [Derived_Value]. | No | |
| Derived Values: Unit (Derived_Value_Unit) |
Text | Standardized unit used for [Derived_Value] and [Derived_Value_Uncert] (Exposure - R, Dose Equivalent - rem, Absorbed Dose - rad). | No | |
| Detector Type (Detector_Type) |
Text | Type of detector used for measurement. | No | |
| Comments (Comments) |
Memo | Narrative comments providing any clarification or additional information. | No | |
| Source (Source) |
Text | Source of reported External data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_External and the display name on the corresponding form are listed (they refer to the same value). The tbl_External field name is in parentheses. |
||||
Table A.4 tbl_HealthPhysics Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (HP_RecordNo) | Auto Number | Unique record number of each health physics entry. Primary key. | Yes | |
| (Case_No) | Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| (HP_Type) | Text | Health physics record type: indicates which of the eight healh physics tables contains record details. | vHealthPhysType | Yes |
| ______________________________________________________________________________ a Only the field name in tbl_HealthPhysics are listed. HP_RecordNo has several display names on the forms such as "Record_No" and "Rec #", but they are only visible in design view. |
||||
Table A.5 tbl_Incidents Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (IncidentID_No) | Number | Unique record number that links Incident records to tbl_HealthPhysics. Primary key. | Yes | |
| C# (I) (Case_No_In) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Incident Indicator (Indicator) |
Text | Indicator that an incident (possible intake) occurred. Used to categorize incidents. | vIncidentIndicator | Yes |
| Date/Time: Start (Time1) |
Date/ Time | Earlier time (from) in incident's time period. | No | |
| Date/Time: End (Time2) |
Date/ Time | Later time (to) in incident's time period. If only a single time is available/appropriate it is entered as Time2. | Yes | |
| Primary Contaminant (Contaminants_Abbrev) |
Text | Primary contaminant(s) i.e. radionuclide(s) or type of radiation. | vRadMixture | Yes |
| Location (Location) |
Text | Building where incident occurred (area, building, and/or room). | No | |
| Exposure Duration (Exp_Duration) |
Text | Duration of possible exposure. This may be a specific amount of time or something more general (i.e. chronic, acute) depending upon the available data. | No | |
| Chemical Form (ChemForm) |
Text | Chemical form of the primary contaminants(s). | vChemForm | No |
| Worksite Code (Worksite_Code) |
Text | Code used by worksite to describe or categorize the incident. | No | |
| Description (Description) |
Memo | Narrative description of the incident. | Yes | |
| Source (Source) |
Text | Source of reported Incident data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_Incidents and the display name on the corresponding form are listed (they refer to the same value). The tbl_Incidents field name is in parentheses. |
||||
Table A.6 tbl_InVitro Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (InVitroID_No) | Number | Unique record that links In Vitro records to tbl_HealthPhysics. Primary key. | Yes | |
| Internal Use (Case_No_Vit) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Medium (Medium) |
Text | Medium that was Analyzed (Urine, Feces, Blood, Nasal Smear, Oral Smear). | vInVitroMedium | Yes |
| Type (Sample_Type) |
Text | Type of sample collection/ normalization method (24-hr, Sim24, Timed, Pooled, Volume, Conc). | vInVitroSamType | Yes |
| Chelation (Chelation) |
Yes/No | Yes = sample was collected withing 7 days of administration of a chelating agent; No = sample was not collected within 7 days of chelation therapy. | No | |
| Collection Time: Start (Collection_StartTime) |
Date/ Time | Urine, Feces: Start time of collection period | No | |
| Collection Time: End (Collection_EndTime) |
Date/ Time | Urine, Feces: End time of collection period. Blood, Nasal/Oral smear: sample collection date. | Yes | |
| Contaminant(s) (Contaminants_Abbrev) |
Number | Primary contaminant(s) i.e. radionuclide(s) or type of radiation. | vRadMixture | Yes |
| Reported Net Activity: Value (Reported_NetAct) |
Number | Net activity reported in the hard file entered using the units that appear in the hard file. | No | |
| Reported Net Activity: Uncert (Reported_NetAct_Uncert) |
Number | Uncertainty associated with [Reported_NetAct]. | No | |
| Reported Net Activity: MDA (Reported_NetAct_MDA) |
Number | MDA associated with [Reported_NetAct]. | No | |
| Reported Net Activity: DL (Reported_NetAct_DL) |
Number | DL associated with [Reported_NetAct]. | No | |
| Reported Net Activity: Unit (Reported_NetAct_Units) |
Text | Units used by [Reported_NetAct], [Reported_NetAct_Uncert], [Reported_NetAct_MDA] and [Reported_NetAct_DL]. | vUnit | No |
| Reported <MDA (Reported_LessMDA) |
Yes/No | Yes = hard file reports that bioassay results were < Minimum Detectable Activity. | No | |
| Derived Activities: Activity: Value (Derived_NetAct) |
Number | [Reported_NetAct] converted in to units of pCi. | No | |
| Derived Activities: Activity: Uncert (Derived_NetAct_Uncert) |
Number | Uncertainty associated [Derived_NetAct] in units of pCi. | No | |
| Derived Activities: Activity: MDA (Derived_NetAct_MDA) |
Number | MDA associated with [Derived_NetAct] in units of pCi. | No | |
| Derived Activities: Activity: DL (Derived_NetAct_DL) |
Number | DL associated with [Deriveded_NetAct] converted into units of pCi. | No | |
| Effective Sample Period (Sample_Period) |
Number | Sample period for Urine and Fecal samples in units of Days (used in calculation of Excretion Rates). | No | |
| Override (Sample_Period_Override) |
Yes/No | No = sample period is calculated from the collection and start and end times, Yes = sample period has been manually entered by the user. | No | |
| Derived Activities: Excretion Rate: Value (Derived_Excretion) |
Number | Excretion rate in pCi/day. | No | |
| Derived Activities: Excretion Rate: Uncert (Derived_Excretion_Uncert) |
Number | Propogated uncertainty for [Derived_Excretion] in pCi/day. | No | |
| Derived Activities: Excretion Rate: MDA (Derived_Excretion_MDA) |
Number | MDA associated with [Derived_Excretion] in pCi/day. | No | |
| Derived Activities: Excretion Rate: (Derived_Excretion_DL) |
Number | DL associated with [Derived_Excretion] in pCi/day. | No | |
| Derived Activities: Total Blood Activity: Value (Derived_BloodAct) |
Number | Total Blood Activity in pCi calculated from [Derived_NetAct] and reference man's blood volume. | No | |
| Derived Activities: Total Blood Activity: Uncert (Derived_BloodAct_Uncert) |
Number | Propogated uncertainty for [Derived_BloodAct] in pCi. | No | |
| Derived Activities: Total Blood Activity: MDA (Derived_BloodAct_MDA) |
Number | MDA associated with [Derived_BloodAct] in pCi. | No | |
| Derived Activities: Total Blood Activity: DL (Derived_BloodAct_DL) |
Number | DL associated with [Derived_BloodAct] in pCi. | No | |
| Derived Activities: Nuclide Mass (Derived_NuclideMass) |
Number | The mass in ug of a radionuclide in an in vitro sample. | No | |
| Derived Activities: NuclideMass: Uncert (Derived_NuclideMass_Uncert) |
Number | Propogated uncertainty for [Derived_NuclideMass] in ug. | No | |
| Derived Activities: NuclideMass: MDA (Derived_NuclideMass_MDA) |
Number | MDA associated with [Derived_NuclideMass] in ug. | No | |
| Derived Activities: NuclideMass: DL (Derived_NuclideMass_DL |
Number | DL associated with [Derived_NuclideMass] in ug. | No | |
| Mass (wet): Collected: Value (Mass_Sample) |
Number | Total mass of Fecal Sample (collected mass) using same units as the hard file. | No | |
| Mass (wet): Collected: Unit (Mass_Sample_Unit) |
Text | Units of [Mass_Sample]. | vUnit | No |
| Mass (wet): Collected: Derived (Mass_Sample_Derived) |
Number | [Mass_Sample] converted into units of grams. | No | |
| Mass (wet): Analyzed: Value (Mass_Aliquot) |
Number | Mass of Fecal Analysis Aliquot (analyzed mass) using the same units as in the hard file. | No | |
| Mass (wet): Analyzed: Unit (Mass_Aliquot_Unit) |
Text | Units of [Mass_Aliquot]. | vUnit | No |
| Mass (wet): Analyzed: Derived (Mass_Aliquot_Derived) |
Number | [Mass_Aliquot] converted into units of grams. | No | |
| Volume: Collected: Value (Volume_Sample) |
Number | Total volume of Urine or Blood Sample (collected volume) using the same units as in the hard file. | No | |
| Volume: Collected: Unit (Volume_Sample_Unit) |
Text | Units of [Volume_Sample]. | vUnit | No |
| Volume: Collected: Derived (Volume_Sample_Derived) |
Number | [Volume_Sample] converted to units of mL. | No | |
| Volume: Analyzed: Value (Volume_Aliquot) |
Number | Volume of Urine Analysis Aliquot (analyzed volume) using the same units as in the hard file. | No | |
| Volume: Analyzed: Unit (Volume_Aliquot_Unit) |
Text | Units of [Volume_Aliquot]. | vUnit | No |
| Volume: Analyzed: Derived (Volume_Aliquot_Derived) |
Number | [Volume_Aliquot] converted to units of mL. | No | |
| Count Data: Start Time (Count_StartTime) |
Date/ Time | Date and time that count started. | No | |
| Count Data: End Time (Count_EndTime) |
Date/ Time | Date and time that count ended. | No | |
| Count Data: Length (Count_Length) |
Number | Length of count in minutes. | No | |
| Creatinine (Creatinine) |
Number | Amount of Creatinine in a urine sample (unit: grams). | No | |
| Laboratory (Laboratory) |
Text | Name of Analysis Laboratory. | No | |
| Comments (Comments) |
Memo | Narrative comments providing clarification and additional information. | No | |
| Source (Source) |
Text | Source of reported in vitro data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_Contamination and the display name on the corresponding form are listed (they refer to the same value). The tbl_Contamination field name is in parentheses. |
||||
Table A.7 tbl_InVivo Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (InVivoID_No) | Number | Unique record that links In Vivo records to tbl_HealthPhysics. Primary key. | Yes | |
| Internal Use (Case_No_Viv) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Monitoring Target (Body_Location) |
Text | Organ or part of body that the in vivo count was trying to measure. | vInVivoLocation | Yes |
| Detector Position (Details) |
Text | Position of detector on body (i.e. Skull, Pelvis, Tibia). | No | |
| Count Start Time (Count_StartTime) |
Date/ Time | Time that in vivo count was started. | Yes | |
| Contaminant(s) (Contaminants_Abbrev) |
Text | Primary contaminant(s) i.e. radionuclide(s) or type of radiation. | vRadMixture | Yes |
| Reported Results: Value (Reported_NetAct) |
Number | Net activity reported in the hard file entered using the units that appear in the hard file. | No | |
| Reported Results: Uncert (Reported_NetAct_Uncert) |
Number | Uncertainty associated with [Reported_NetAct]. | No | |
| Reported Results: MDA (Reported_NetAct_MDA) |
Number | MDA associated with [Reported_NetAct]. | No | |
| Reported Results: DL (Reported_NetAct_DL) |
Number | DL associated with [Reported_NetAct]. | No | |
| Reported Results: Unit (Reported_NetAct_Unit) |
Text | Units used by [Reported_NetAct], [Reported_NetAct_Uncert], [Reported_NetAct_MDA], and [Reported_NetAct_DL]. | vUnit | No |
| Reported <MDA (Reported_LessMDA) |
Yes/No | Yes = hard file reports that results were < Minimum Detectable Activity. | No | |
| Derived Values: Activity (Derived_NetAct) |
Number | [Reported_NetAct] converted in to units of pCi. | No | |
| Derived Values: Uncert (Derived_NetAct_Uncert) |
Number | Uncertainty associated with [Derived_NetAct] in units of pCi. | No | |
| Derived Values: MDA (Derived_NetAct_MDA) |
Number | MDA associated with [Derived_NetAct] in units of pCi. | No | |
| Derived Values: DL (Derived_NetAct_DL) |
Number | DL associated with [Derived_NetAct] in units of pCi. | No | |
| Derived Values: Unit (Derived_NetAct_Unit) |
Text | Unit associated with [Derived_Net Act]. Activity: pCi, Counts: cpm, Mass: ug. | No | |
| Count Length (Count_Length) |
Number | Length of in vivo count in minutes. | No | |
| Comments (Comments) |
Memo | Narrative comments providing any clarification or additional information. | No | |
| Laboratory (Laboratory) |
Text | Laboratory that performed the in vivo analysis. | No | |
| Source (Source) |
Text | Source of reported in vivo data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_InVitro and the display name on the corresponding form are listed (they refer to the same value). The tbl_InVitro field name is in parentheses. |
||||
Table A.8 tbl_Treatment Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (TreatmentID_No) | Number | Unique record that links Treatment records to tbl_HealthPhysics. Primary key. | Yes | |
| C# (Tr) (Case_No_Tr) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Treatment (Treatment) |
Text | Type of treatment: chleation, wound irrigation, wound excision. | vTreatType | Yes |
| Chelating Agent (Chelator) |
Text | Chelating agent that was administered to registrant. | vTreatChelator | Yes |
| Modality (Modality) |
Text | Mode by which chelation agent was administered (i.v. or oral). | vTreatMode | Yes |
| Date/Time (Time) |
Date/ Time | Treatment date/time. | Yes | |
| Dosage (Dosage) |
Number | Chelation dosage. | No | |
| Dosage Unit (Dosage_Unit) |
Text | Unit for [Dosage]. | vUnit | No |
| Activity Removed (Act_Removed) |
Number | Amount of activity removed in wound excision or wound irrigation. | No | |
| Activity Unit (Act_Removed_Unit) |
Text | Unit for [Activity_Removed]. | vUnit | No |
| Derived Values: Dosage (Derived_Dosage) |
Number | [Dosage] converted to standardized unit, gram. | No | |
| Derived Values: Activity Removed (Derived_ActRem) |
Number | [Act_Removed] converted to standardized unit, pCi. | No | |
| Comments (Comments) |
Memo | Narrative comments providing any clarification or additional information. | No | |
| Source (Source) |
Text | Source of reported Treatment data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_InVivo and the display name on the corresponding form are listed (they refer to the same value). The tbl_InVivo field name is in parentheses. |
||||
Table A.9 tbl_WorksiteAssessments Field Details |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| (AssessID_No) | Number | Unique record that links Work Site Assessments to tbl_HealthPhysics. Primary key. | Yes | |
| Internal Use (Case_No_WA) |
Text | Unique number of each registrant, assigned by USTUR. Must match a case number in ADMIN. | Yes | |
| Quantity (Quantity) |
Text | Type of work site assessment (i.e. Dose, Burden, Intake, etc.). | vWorksiteQuantity | Yes |
| Period Category (Period) |
Text | Time period that was assessed (i.e. annual, committed, etc.). | vWorksitePeriod | Yes |
| Organ/Details (Organ_Details) |
Text | Additional assessment details such as the organ that calculations were performed for (i.e. skeletal burden). Any text can be entered. | No | |
| Assessment Period: Start Date (Date1) |
Date/ Time | Earlier date (from) in the time period that was assessed. | No | |
| Assessment Period: End Date (Date2) |
Date/ Time | Later date (to) in the time period that was assessed. | Yes | |
| Primary Contaminant (Contaminants_Abbrev) |
Text | Primary contaminant(s) i.e. radionuclide(s) or type of radiation. | vRadMixture | Yes |
| Reported Estimates: Value (Reported_Value) |
Number | Assessment value (burden or dose) as reported in the hard file. | No | |
| Reported Estimates: Uncert (Reported_Value_Uncert) |
Number | Uncertainty associated with [Reported_Value]. | No | |
| Reported Estimates: Unit (Reported_Value_Unit) |
Text | Unit used by both [Reported_Value] and [Reported_Value_Uncert]. | vUnit | No |
| Derived Values: Value (Derived_Value) |
Number | [Reported_Value] converted to a standardized unit (burdens - pCi, absorbed dose - rad, other doses - rem). | No | |
| Derived Values: Uncert (Derived_Value_Uncert) |
Number | Uncertainty associated with [Derived_Value]. | No | |
| Derived Values: Unit (Derived_Value_Unit) |
Text | Standardized unit used by both [Derived_Value] and [Derived_Value_Uncert]. (burdens - pCi, absorbed dose - rad, other doses - rem). | vUnit | No |
| ICRP (ICRP) |
Text | The version(s) of ICRP that the work site assessment was based upon. | No | |
| Solubility Class (Solubility_Class) |
Text | ICRP 30 solubility class or ICRP 66 type that was assumed in calculations. | No | |
| AMAD (AMAD) |
Number | Activity Mean Aerodynamic Diameter assumed in calculations. | No | |
| Basis (Basis) |
Memo | Describes which measurements the assessment was based upon. | No | |
| Comments (Comments) |
Memo | Narrative comments providing clarification and additional information. | No | |
| Source (Source) |
Text | Source of reported Work Site Assessment data (date and name of document(s) in the hard file). | Yes | |
| Entry Date (Entry_Date) |
Date/ Time | Date that record was entered (automatically entered by Access). | Yes | |
| Initials (Initials) |
Text | Initials of person who entered the data record (automatically entered by Access). | Yes | |
| ______________________________________________________________________________ a Both the field name in tbl_WorksiteAssessments and the display name on the corresponding form are listed (they refer to the same value). The tbl_WorksiteAssessments field name is in parentheses. |
||||
This page was last updated on May 22, 2008. usturwebmaster@tricity.wsu.edu