INJURY_ILL_DESC (SQL Table)	Index Back
WCB Injury/Illness Details 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_WCB to record details required by the Workmen's Compensation Board (WCB) about a person's injury or illness

INJURY_ILL_DESC

(SQL Table)

WCB Injury/Illness Details

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_WCB to record details required by the Workmen's Compensation Board (WCB) about a person's injury or illness

Parent record: INJURY_ILL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: PER_ORG_ASGN_VW

3 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID
Prompt Table: NE_INCIDNT_SRCH

4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
Prompt Table: INCIDENT_DATA

5 DESC_TYPE Character(1) VARCHAR2(1) NOT NULL Type / Description
A=Activities at time of Injury
B=Doubt injury is work related
D=Reason for Delay in reporting
E=Worker could return earlier
F=Previous defect or disability
J=Object to acceptance of claim
N=Reason FirstAid not Admin
P=Previous Pain in injury area
R=Activities NOT part of reg wk
S=Satisfied claim is legitimate
W=Activities NOT for wk purposes

6 INJURY_ILL_DESCR Long Character CLOB Injury / Illness Descriptions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: PER_ORG_ASGN_VW
3	NON_EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	Non-Employee ID Prompt Table: NE_INCIDNT_SRCH
4	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number Prompt Table: INCIDENT_DATA
5	DESC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type / Description A=Activities at time of Injury B=Doubt injury is work related D=Reason for Delay in reporting E=Worker could return earlier F=Previous defect or disability J=Object to acceptance of claim N=Reason FirstAid not Admin P=Previous Pain in injury area R=Activities NOT part of reg wk S=Satisfied claim is legitimate W=Activities NOT for wk purposes
6	INJURY_ILL_DESCR	Long Character	CLOB	Injury / Illness Descriptions