WORK_RESTR_FRA (SQL Table)	Index Back
EE Injury-Work Restrictions Use WORK_RESTRICTN to identify any work restrictions that apply to an employee or non-employee (i.e., contractor) as a result of injury or illness. For example, if the person has a back injury, a work restriction might be to avoid heavy lifting. This data is part of the Health and Safety module.

WORK_RESTR_FRA

(SQL Table)

EE Injury-Work Restrictions

Use WORK_RESTRICTN to identify any work restrictions that apply to an employee or non-employee (i.e., contractor) as a result of injury or illness. For example, if the person has a back injury, a work restriction might be to avoid heavy lifting. This data is part of the Health and Safety module.

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 EXAM_DT Date(10) DATE Exam Date

3 EXAM_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Type of Exam
ANN=Annual
BIE=Biennal
DOT=Department of Transport
DRG=Drug Screening
EXP=Exposure
FFD=Fit for Duty
GEN=General Health
HTB=Inspection for Tuberculosis
LRH=Labor-Related Health
NEW=New Hire
OTP=Pre-Overseas Transfer
OTT=Post-Overseas Transfer
PRE=Pre-Employment
PSV=Periodic Surveillance
TUB=Tuberculosis

4 WORK_RESTRICT_CD Character(3) VARCHAR2(3) NOT NULL Work Restriction Code
Prompt Table: WORK_RESTRN_TBL

5 RESTRICT_FROM_DT Date(10) DATE Restriction From Date

6 RESTRICT_TO_DT Date(10) DATE Restriction To Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EXAM_DT	Date(10)	DATE	Exam Date
3	EXAM_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Type of Exam ANN=Annual BIE=Biennal DOT=Department of Transport DRG=Drug Screening EXP=Exposure FFD=Fit for Duty GEN=General Health HTB=Inspection for Tuberculosis LRH=Labor-Related Health NEW=New Hire OTP=Pre-Overseas Transfer OTT=Post-Overseas Transfer PRE=Pre-Employment PSV=Periodic Surveillance TUB=Tuberculosis
4	WORK_RESTRICT_CD	Character(3)	VARCHAR2(3) NOT NULL	Work Restriction Code Prompt Table: WORK_RESTRN_TBL
5	RESTRICT_FROM_DT	Date(10)	DATE	Restriction From Date
6	RESTRICT_TO_DT	Date(10)	DATE	Restriction To Date