HR_OHSCSV_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OSHA_ESTABL_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Establishment Description
3	COMPANY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Company Descr
4	OSHA_ADDRESS	Character(165)	VARCHAR2(165) NOT NULL	OSHA Address
5	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
6	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
7	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
8	NAICS	Character(6)	VARCHAR2(6) NOT NULL	North Amer Ind Class Sys
9	OSHA_INDUSTRY_DESC	Character(120)	VARCHAR2(120) NOT NULL	OSHA- Industry Description
10	OSHA_EST_SIZE	Number(1,0)	SMALLINT NOT NULL	OSHA - Establishment Size
11	ESTAB_TYP	Character(2)	VARCHAR2(2) NOT NULL	Establishment Type. IT=Tax Establishment LA=Labor Ins Establishment SC=Social Ins Establishment
12	YEAR	Character(4)	VARCHAR2(4) NOT NULL	Character field to represent a year
13	TOTAL_EE_COUNT	Number(12,3)	DECIMAL(11,3) NOT NULL	Total Number of Employees
14	TOTAL_EE_HRS	Number(11,2)	DECIMAL(10,2) NOT NULL	Total Employee Hours
15	OSHA_INJ_ILLNESS	Number(1,0)	SMALLINT NOT NULL	OSHA- Injury Illness
16	OSHA_EST_NO_DEATH	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - Fatality
17	OSHA_DAFW_CASES	Number(10,0)	DECIMAL(10) NOT NULL	OSHA Days Away from cases
18	OSHA_DJTR_CASES	Number(10,0)	DECIMAL(10) NOT NULL	OSHA cases with job transfer or restriction
19	OSHA_OTHER_CASES	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - Other cases
20	OSHA_DAFW_DAYS	Number(10,0)	DECIMAL(10) NOT NULL	OSHA Days away from work
21	OSHA_DJTR_DAYS	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - days of job transfer or restriction
22	OSHA_INJURIES	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - Total Injuries
23	OSHA_SKIN_DISORDER	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - Skin Disorder
24	OSHA_RES_CONDITION	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - Respiratory conditions
25	OSHA_POISONINGS	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - Poisonings
26	OSHA_HEARING_LOSS	Number(10,0)	DECIMAL(10) NOT NULL	OSHA-Total number of hearing loss
27	OSHA_OTHER_ILLNESS	Number(10,0)	DECIMAL(10) NOT NULL	OSHA - Other illness
28	OSHA_CH_REASON	Character(100)	VARCHAR2(100) NOT NULL	OSHA Change Reason
29	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID