INJ_ILL_STMT (SQL Table)	Index Back
H&S - Injury Ill Statement This is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJ_ILL_STMT to record the Injured Person's Statement

INJ_ILL_STMT

(SQL Table)

H&S - Injury Ill Statement

This is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJ_ILL_STMT to record the Injured Person's Statement

Related Language Record: INJ_ILL_STM_LNG

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

5 HS_STATEMENT Long Character CLOB Statement

#	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	NON_EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	Non-Employee ID
5	HS_STATEMENT	Long Character	CLOB	Statement