HS_SS_INJRY_DAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: HS_SS_INCDT_DAT.EMPLID Prompt Table: PERSON
2	ACTION_DT_SS	Date(10)	DATE NOT NULL	Transaction Date Default Value: HS_SS_INCDT_DAT.ACTION_DT_SS
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: HS_SS_INCDT_DAT.EFFSEQ
4	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number Default Value: HS_SS_INCDT_DAT.INCIDENT_NBR
5	HS_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID for Health and Safety Prompt Table: HS_PER_ORG_ASGN
6	HS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Employment Record Number for Health and Safety Default Value: 0
7	NON_EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	Non-Employee ID Prompt Table: NE_INCIDNT_SRCH
8	INJURY_ILLNESS	Character(1)	VARCHAR2(1) NOT NULL	Primarily Injury/Illness D=Death L=Illness N=Injury Default Value: N
9	HS_SS_INJ_ILL	Character(2)	VARCHAR2(2) NOT NULL	Field used in self service to capture whether the incident resulted in jnjury or illness or neither. 10=No Injury/Illness 20=Injury 30=Illness Default Value: 10
10	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_HANDS_VW
11	REPORTABLE_CASE	Character(1)	VARCHAR2(1) NOT NULL	Reportable Case Y/N Table Edit Default Value: N
12	DT_REPORTED	Date(10)	DATE	Date Reported
13	TM_REPORTED	Time(15)	TIMESTAMP	Time Reported
14	HS_TIMEZONE1	Character(9)	VARCHAR2(9) NOT NULL	Health and Safety Time Zone Field 1 Prompt Table: PSTIMEZONE
15	INJURY_TREATMENT	Character(1)	VARCHAR2(1) NOT NULL	Injury Treatment 1=Medical Treatment 2=First Aid 3=Not Required 4=Hospitalized Default Value: 3
16	EMPLOYER_OBJECT_SW	Character(1)	VARCHAR2(1) NOT NULL	Employer Objects to Statement Y/N Table Edit Default Value: N
17	WITNESS_CONFIRM_SW	Character(1)	VARCHAR2(1) NOT NULL	Witness Confirms Statement Y/N Table Edit Default Value: N
18	OCC_ILLNESS_CD	Character(6)	VARCHAR2(6) NOT NULL	Occupational Illness Prompt Table: HS_SS_ILL_VW Set Control Field: REG_REGION
19	BODY_PART_CD	Character(5)	VARCHAR2(5) NOT NULL	Body Part Code Prompt Table: HS_SS_BP_VW Set Control Field: REG_REGION
20	SIDE_OF_BODY	Character(1)	VARCHAR2(1) NOT NULL	Side of Body B=Back F=Front L=Left R=Right
21	INJURY_NATURE_CD	Character(5)	VARCHAR2(5) NOT NULL	Nature of Injury Prompt Table: HS_SS_NOI_VW Set Control Field: REG_REGION
22	INJURY_SOURCE_CD	Character(5)	VARCHAR2(5) NOT NULL	Source of Injury Prompt Table: HS_SS_SOI_VW Set Control Field: REG_REGION
23	ACCIDENT_TYPE_CD	Character(5)	VARCHAR2(5) NOT NULL	Accident Type Prompt Table: HS_SS_AT_VW Set Control Field: REG_REGION
24	UNSAFE_ACT_CD	Character(5)	VARCHAR2(5) NOT NULL	Unsafe Act Performed Prompt Table: UNSAFE_ACT_TBL
25	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
26	CASE_NBR_USA	Character(5)	VARCHAR2(5) NOT NULL	Case Number
27	ILLNESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Illness Type 1=Occupational Skin Disease 2=Dust Disease of the Lungs 3=Toxic Agent Respiratory Cond. 4=Toxic Poisoning 5=Physical Agents Disorder 6=Repeated Trauma Disorder 7=Other Occupational Illness 8=Not Applicable
28	DT_FILED_USA	Date(10)	DATE	Date Filed
29	OSHA_200_DESCR	Character(60)	VARCHAR2(60) NOT NULL	Log Comments
30	PRIVACY_CASE	Character(1)	VARCHAR2(1) NOT NULL	Privacy Case Y/N Table Edit Default Value: N
31	FURTHER_INQUIRY	Character(1)	VARCHAR2(1) NOT NULL	Further Inquiry Y/N Table Edit
32	LAST_WORKED_TM	Time(15)	TIMESTAMP	Time last worked
33	RETURN_TM	Time(15)	TIMESTAMP	Return Time
34	EMPL_RETURN_WORK	Character(1)	VARCHAR2(1) NOT NULL	Employee Return To Work Y/N Table Edit Default Value: N
35	WORK_RELATED	Character(1)	VARCHAR2(1) NOT NULL	Work-Related Y/N Table Edit Default Value: N
36	COMMENTS	Long Character	CLOB	Comment