OHS501UK_TMP2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NON_EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	Non-Employee ID
4	INCIDENT_DT	Date(10)	DATE	Incident Date
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
7	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
8	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
9	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
10	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
11	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
12	STATE_DESCR1	Character(30)	VARCHAR2(30) NOT NULL	State Description
13	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
14	COUNTRY_DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Country Description
15	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
16	BIRTHDATE	Date(10)	DATE	Date of Birth
17	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
18	JOBTITLE	Character(30)	VARCHAR2(30) NOT NULL	Job Title
19	SCHEME_TYPE_CD_UK	Character(2)	VARCHAR2(2) NOT NULL	Scheme Type TS=Training Scheme WE=Work Experience
20	EXT_SCHEME_DESCR	Character(30)	VARCHAR2(30) NOT NULL	External Scheme Description
21	SELF_EMPL_SW_UK	Character(1)	VARCHAR2(1) NOT NULL	Self-Employed
22	MEM_PUBLIC_SW_UK	Character(1)	VARCHAR2(1) NOT NULL	Member Of Public
23	EMPLOYER	Character(30)	VARCHAR2(30) NOT NULL	Employer
24	INJURIES	Character(100)	VARCHAR2(100) NOT NULL	Nature Of Injuries
25	BODY_PARTS	Character(100)	VARCHAR2(100) NOT NULL	Body Parts
26	INCIDENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Incident Type A=Accident B=Industrial Accident C=Contamination D=Industrial Accident (Official) E=Exposure H=Hazardous Condition I=Incident L=Illness N=Injury O=Dangerous Occurrence P=Unsafe Practice S=Safety Violation V=Vehicle/Equipment Accident
27	FATALITY_SW	Character(1)	VARCHAR2(1) NOT NULL	Fatal Injuries Sustained
28	AWAY_FROM_WORKDAYS	Number(4,0)	SMALLINT NOT NULL	Days Away From Work
29	HOSPITAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Patient Taken To Hospital
30	UNCONSCIOUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Patient Fell Unconscious
31	RESUSCITATION_SW	Character(1)	VARCHAR2(1) NOT NULL	Resuscitation Required
32	HOSPITAL_24_SW_UK	Character(1)	VARCHAR2(1) NOT NULL	Hospitalised for over 24 hours
33	ACCIDENT_TYPE_CD	Character(5)	VARCHAR2(5) NOT NULL	Accident Type
34	FALL_HEIGHT_UK	Number(5,1)	DECIMAL(4,1) NOT NULL	Height of Fall
35	DANGER_OCC_CD	Character(4)	VARCHAR2(4) NOT NULL	Dangerous Occurrence Code
36	OCC_ILLNESS_CD	Character(6)	VARCHAR2(6) NOT NULL	Occupational Illness
37	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
38	OCC_ILL_DIAG_DT_UK	Date(10)	DATE	Occ. Illness Diagnosis Date
39	PHYSICIAN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Physician Name
40	MEDICAL_FAC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Medical Facility Name
41	ADDRESS1_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 1 Other
42	ADDRESS2_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 2 Other
43	ADDRESS3_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 3 Other
44	ADDRESS4_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 4 Other
45	CITY_OTHER	Character(30)	VARCHAR2(30) NOT NULL	City Other
46	COUNTY_OTHER	Character(30)	VARCHAR2(30) NOT NULL	County Other
47	STATE_DESCR2	Character(30)	VARCHAR2(30) NOT NULL	State Description
48	POSTAL_OTHER	Character(12)	VARCHAR2(12) NOT NULL	Postal Other
49	COUNTRY_DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Country Description
50	COMMENTS	Long Character	CLOB	Comment