TABLE_NAME|COLUMN_NAME|DATA_TYPE|DATA_LENGTH|FIELD_DESCRIPTION PERSONAL HEALTH SAMPLES|MINE_ID|VARCHAR2|7|The mine id where the sample was taken. Use mine_id to join to the Mines table for additional information. PERSONAL HEALTH SAMPLES|EVENT_NO|VARCHAR2|7|Unique number identifying inspection (event) related to the sampling. Primary key to join to the Inspections and table. PERSONAL HEALTH SAMPLES|SAMPLE_NO|VARCHAR2|18|Unique identifier for each sample. The format is yyyymmdd0ARNOseqSN: year, month, day, 0, AR Number, sequence number, subcomponent number. PERSONAL HEALTH SAMPLES|SAMPLE_DATE|DATE|10|Date the sample was taken. PERSONAL HEALTH SAMPLES|CONTAMINANT_CD|VARCHAR2|5|Code assigned to the substance or agent sampled. PERSONAL HEALTH SAMPLES|CONTAMINANT_CD_DESC|VARCHAR2|64|Description of the code assigned to the substance or agent sampled. PERSONAL HEALTH SAMPLES|CONCENTRATION|VARCHAR2|7|Concentration amount of substance or agent sampled. Format is ####.##. PERSONAL HEALTH SAMPLES|EXPOSURE_LIMIT|VARCHAR2|7|Permissable exposure limit for the contaminant being sampled. Format is ####.##. PERSONAL HEALTH SAMPLES|C_OVER_E|VARCHAR2|5|Results obtained by dividing concentration by the exposure limit and rounded to the nearest hundredth. Format is ##.##. PERSONAL HEALTH SAMPLES|PROTECTION_USED|VARCHAR2|1|Personal protective device or equipment used (Y) or not used (N) during sampling. In the historical records, (X) represents equipment used and (space) represents equipment not used. PERSONAL HEALTH SAMPLES|SAMPLING_INSTRUMENT_CD|VARCHAR2|2|Code indicating the sampling instrument used. PERSONAL HEALTH SAMPLES|SAMPLING_INSTRUMENT_DESC|VARCHAR2|32|Descriptions of the code indicating the sampling instrument used. PERSONAL HEALTH SAMPLES|SHORT_TERM_EXPOSURE|VARCHAR2|1|Short-term exposure (X) as distinguished from a full-shift sample (space or null). PERSONAL HEALTH SAMPLES|ACTION_TAKEN|VARCHAR2|1|Action as a result of analysis of sample. PERSONAL HEALTH SAMPLES|ACTION_TAKEN_DESC|VARCHAR2|26|C = Cit/Ord Issued; P = Infeasible controls; T = Cit/Ord Term; D = Overexp of 551/553, 555; E = Exceeds Pel but not PEL X error factor; L = Exposure limit exceeded; H = Noise exp exceeded (not PEL); etc. PERSONAL HEALTH SAMPLES|LOCATION_CD|VARCHAR2|2|Code that indicates the work area of the mine employee during sampling. PERSONAL HEALTH SAMPLES|LOCATION_CD_DESC|VARCHAR2|50|Description of the location code of the mine employee during sampling. PERSONAL HEALTH SAMPLES|JOB_CD|VARCHAR2|3|Code denoting the occupation of the mine employee sampled. PERSONAL HEALTH SAMPLES|JOB_CD_DESC|VARCHAR2|50|Description of the occupation of the mine employee sampled. PERSONAL HEALTH SAMPLES|CONTRACTOR_ID|VARCHAR2|10|Contractor ID if sampling was performed in the working area of a contractor operating at the mine.