Appendix A - Validation Tables |
|
USTUR health physics database |
 Index |
A.10 vChemForm
Table A.10 vChemForm: Chemical Form of contaminants |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| ChemForm | Text | Chemical form of the radionuclide(s). Primary key. | Yes | |
| ChemForm_Code | Auto Number | unique index for each chemical form: used for sorting data | Yes | |
| Element | Text | Element of interest: used for searching and sorting. | Yes | |
| ______________________________________________________________________________ a The field name in vChemForm. These fields do not appear directly on the forms. |
||||
Table A.11 vContaminationMode: Contamination categories |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Modality | Text | Type of contamination (Personal, Clothing, Workspace). | Yes | |
| ______________________________________________________________________________ a The field name in vContaminationMode. This field does not appear directly on the forms. |
||||
Table A.12 vExternalMonPeriod: Monitoring Period |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| MonitorPeriod | Text | The period for which external dosimetry data is being reported (short form). | Yes | |
| Description | Text | A longer definition of individual Monitoring Period categories. | Yes | |
| Sort | Number | Number used to order monitoring period entries in dropdown menus. | Yes | |
| ______________________________________________________________________________ a The field name in vExternalQuantity. These fields do not appear directly on the forms. |
||||
Table A.13 vExternalQuantity: External 'dose' quantity |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Dose_Quantity | Text | Type of external radiation quantity (Dose Equivalent, Exposure, or Absorbed Dose) | Yes | |
| ______________________________________________________________________________ a The field name in vExternalQuantity. This field does not appear directly on the forms. |
||||
Table A.14 vExternalType: Type of external dosimetry measurement. |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Type_Short | Text | Abbreviated Type of external radiation measurement. Primary key. | Yes | |
| Type_Description | Text | Type of external radiation measurement (written out). | Yes | |
| Record_No | Text | Recored number used to sort Type entries. | Yes | |
| ______________________________________________________________________________ a The field name in vExternalType. These fields do not appear directly on the forms. |
||||
Table A.15 vHealthPhysType: Used by tbl_HealthPhysics to categorize different types of health physics data. |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| HP_Type | Text | Abbreviated Health Physics Type. Primary key. | Yes | |
| Description | Text | Health Physics Type (written out). | Yes | |
| ______________________________________________________________________________ a The field name in vHealthPhysType. HP_Type exists on the health physics forms for internal purposes, but it is not visible to the user. |
||||
Table A.16 vIncidentIndicator: Indicator that an incident (possible intake) occurred |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Incident_Indicator | Text | Indicator that an incident (possible intake) occurred. Primary Key. | Yes | |
| Sort | Number | Number used to order entries in dropdown menu. | Yes | |
| ______________________________________________________________________________ a The field name in vIncidentIndicator. These fields do not exist on the forms. |
||||
Table A.17 vInequality: inequality symbols used with measurement values (i.e. < 10,000 dpm) |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Inequality | Text | Inequality symbol (>, <, >=, <=, =) used in conjunction with a measurement. Primary Key. | Yes | |
| Description | Text | Description of the inequality symbol (written out). | Yes | |
| ______________________________________________________________________________ a The field name in vInequality. These fields do not exist on the forms. |
||||
Table A.18 vIntakeTypes: Modes of intake |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Int_Type | Text | Mode of intake. | Yes | |
| ______________________________________________________________________________ a The field name in vIntakeTypes. This field does not exist on the forms. |
||||
Table A.19 vInVitroMedium: Type of in vitro analysis |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Medium | Text | Type of in vitro Analysis (i.e. Urine, Blood, Nasal Smear) | Yes | |
| ______________________________________________________________________________ a The field name in vInVitroMedium. This field does not exist on the forms. |
||||
Table A.20 vInVitroSamType: urinalysis or fecal analysis sample collection type |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Sample_Type | Text | sample collection type (i.e. 24-hr, timed, volume). Primary key. | Yes | |
| Description | Text | Description of sample type (written out) | Yes | |
| Sort_Order | Number | integer used to sort sample types for display on forms. | Yes | |
| ______________________________________________________________________________ a The field name in vInVitroSamType. These fields do not exist on the forms. |
||||
Table A.21 vInVivoLocation: location where in vivo measurement was counted |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Body_Location | Text | Location where in vivo measurement was counted. | Yes | |
| ______________________________________________________________________________ a The field name in vInVivoLocation. This field does not exist on the forms. |
||||
Table A.22 vRadMixture: radioactive agent mixtures |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Abbreviation | Text | Abbreviated description of the radionuclide(s) or type(s) or radiation. Primary key. | Yes | |
| RadMixtureID | Auto Number | A unique identification number that corresponds to a specific radionuclide mixture (number is auto assigned). | Yes | |
| Description | Text | Radionuclide(s) or radiation type(s) in the mixture. | Yes | |
| ______________________________________________________________________________ a The field name in vRadMixture. The Description field is labeled "Primary Contaminant(s)" or "Contaminant(s)" on the health physics forms. |
||||
Table A.23 vRadMixtureDetail: Junction table between vRadMixture and vRadNuclides to create the many-to-many relationship between individual radionuclides and mixtures |
||||
| Field Namea | Data Type | Description | Data Source |
Required |
| Abbreviation | Text | Abbreviated description of the radionuclide(s) or type(s) or radiation. Primary key (taken with Radionuclide). | vRadMixture | Yes |
| Radionuclide | Text | Individual radionuclides. Primary key (taken with Abbreviation). | vRadNuclides | Yes |
| MixtureID | Number | An identification number that corresponds to a specific radionuclide mixture. | vRadMixture | Yes |
| ______________________________________________________________________________ a The field name in vRadMixtureDetail. These fields do not exist on the forms. |
||||
Table A.24 vRadNuclides: Individual radionuclides and their half-lives. Radionuclides are listed with the element and the mass number in separate fields. |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| RadNuclide | Text | Unique radionuclides in the format Am-241 or types of radiation (i.e. x-ray, beta, neutron). Primary key. | Yes | |
| Element | Text | The element abbreviation (i.e. Am) or types of radiation (i.e. x-ray, beta, neutron). | Yes | |
| IsotopeOrEnergy | Text | The isotope number (i.e. 241) or energy (i.e. 35 keV) | Yes | |
| HalfLife | Number | Half-life of the radionuclide | No | |
| HalfLifeUnit | Text | Unit that half-life is expressed in. | No | |
| SpecificActivity | Number | Specific activity of a radionuclide expressed in Ci/g. Source: J.E. Martin. Physics for Radioation Protection. New York: John Wiley & Sons Inc. 2000. | ||
| ______________________________________________________________________________ a The field name in vRadNuclides. These fields do not exist on the forms. |
||||
Table A.25 vTreatChelator: chelator administered to registrant |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Chelator | Text | Chelating agent administered to registrant. | Yes | |
| Sort | Number | Number used to order chelating agents in dropdown menu. | Yes | |
| ______________________________________________________________________________ a The field name in vTreatChelator. This field does not exist on the forms. |
||||
Table A.26 vTreatMode: mode of chelation agent administration |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Modality | Text | Modality | Yes | |
| Description | Text | Modality written out longhand. | Yes | |
| ______________________________________________________________________________ a The field name in vTreatMode. This field does not exist on the forms. |
||||
Table A.27 vTreatType: type of treatment administered to registrant |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Treatment | Text | Type of treatment administered to registrant. | Yes | |
| ______________________________________________________________________________ a The field name in vTreatType. This field does not exist on the forms. |
||||
Table A.28 vUnit: units and conversion factors used to obtain standardized units. |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Initial_Unit | Text | Abbreviated unit (i.e. dpm or Bq). Primary key (taken with Unit_Type and Unit_Set). | Yes | |
| Description | Text | Unit spelled out (i.e. disintegrations per minute or Becquerel) | Yes | |
| Record_No | Auto Number | Used to order records | Yes | |
| Sort_No | Number | number used to sort records | Yes | |
| Unit_Type | Text | Quantity type (i.e. activity or mass). Primary key (taken with Initial_Unit and Unit_Set). | Yes | |
| Unit_Set | Text | 1 = Standard Unit set (standard activity unit = pCi; concentration = pCi/mL); 2 = secondary unit set (concentration = pCi/cc; contamination: standard activity unit = dpm); 3 = tertiary unit set (concentration = pCi/g). Primary key (taken with Initial_Unit and Unit_Type). | Yes | |
| Conversion_Rule | Text | Unit conversions needed to convert the initial unit into the standardized Unit (written out). | Yes | |
| Multiplicative_Factor | Number | A single conversion factor: [Standardized_Unit] = [Multiplicative_Factor]*[Initial_Unit] | Yes | |
| Standardized_Unit | Text | Standardized unit used (i.e. the standard mass unit is gram) | Yes | |
| ______________________________________________________________________________ a The field name in vUnit. These fields do not exist on the forms. |
||||
Table A.29 vWorksitePeriod: time period that was assessed. |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Period | Text | Time period that was assessed (i.e. annual, committed, etc.). Primary key. | Yes | |
| Record_No | Auto Number | Record number, used to sort [Period] entries | Yes | |
| ______________________________________________________________________________ a The field name in vWorksitePeriod. These fields do not exist on the forms. |
||||
Table A.30 vWorksiteQuantity: Type of worksite assessment. |
||||
| Field Namea | Data Type | Description | Data Source | Required |
| Quantity | Text | Type of worksite assessment (i.e. Dose, Burden, Intake, etc.). Primary key. | Yes | |
| Description | Text | Type of worksite assessment (written out). | Yes | |
| Record_No | Auto Number | Record number, used to sort [Quantity] data. | Yes | |
| ______________________________________________________________________________ a The field name in vWorksiteQuantity. These fields do not exist on the forms. |
||||
This page was last updated on May 22, 2008. usturwebmaster@tricity.wsu.edu