GPFR_WORK_DAYS (SQL Table)	Index Back
Worked Days of the Week Worked Days of the Week by Schedule

GPFR_WORK_DAYS

(SQL Table)

Worked Days of the Week

Worked Days of the Week by Schedule

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_VLD_TL_01

2 SCHEDULE_ID Character(16) VARCHAR2(16) NOT NULL The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
Prompt Table: SCH_DEFN_TBL

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

4 GPFR_WORKED_DAYS Number(3,0) SMALLINT NOT NULL Worked days of the week

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_TL_01
2	SCHEDULE_ID	Character(16)	VARCHAR2(16) NOT NULL	The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition). Prompt Table: SCH_DEFN_TBL
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	GPFR_WORKED_DAYS	Number(3,0)	SMALLINT NOT NULL	Worked days of the week