INJURY_ILL_ACT (SQL Table)	Index Back
Injury/Ill - Unsafe Act 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 INJURY_ILL_ACT to record details about the unsafe acts the injured worker performed

INJURY_ILL_ACT

(SQL Table)

Injury/Ill - Unsafe Act

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 INJURY_ILL_ACT to record details about the unsafe acts the injured worker performed

Parent record: INJURY_ILL_VW

# 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 Record

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

5 UNSAFE_ACT_CD Character(5) VARCHAR2(5) NOT NULL Unsafe Act Performed
Prompt Table: UNSAFE_ACT_TBL

6 PRIMARY_INJURY Character(1) VARCHAR2(1) NOT NULL Primary Injury
Y/N Table Edit
Default Value: N

#	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 Record
4	NON_EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	Non-Employee ID
5	UNSAFE_ACT_CD	Character(5)	VARCHAR2(5) NOT NULL	Unsafe Act Performed Prompt Table: UNSAFE_ACT_TBL
6	PRIMARY_INJURY	Character(1)	VARCHAR2(1) NOT NULL	Primary Injury Y/N Table Edit Default Value: N