MODFIED_WRK_TBL (SQL Table)	Index Back
Modified Work Codes Use MODFIED_WRK_TBL to record work and workplace modifications your company makes to accommodate employees' special rehabilitation needs after an injury or illness. For example, modified work might include no overtime, or four-hour shifts, or no bright lights. This data is an edit table used in the Health and Safety module.

MODFIED_WRK_TBL

(SQL Table)

Modified Work Codes

Use MODFIED_WRK_TBL to record work and workplace modifications your company makes to accommodate employees' special rehabilitation needs after an injury or illness. For example, modified work might include no overtime, or four-hour shifts, or no bright lights. This data is an edit table used in the Health and Safety module.

Related Language Record: MODFIED_WRK_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL

2 MODIFIED_WORK_CD Character(3) VARCHAR2(3) NOT NULL Modified Work Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL
2	MODIFIED_WORK_CD	Character(3)	VARCHAR2(3) NOT NULL	Modified Work Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description