GPFR_PS_SCH_TMP (SQL Table)	Index Back
GPFR_PYSL_AE Schedule GPFR_PYSL_AE Schedule

GPFR_PS_SCH_TMP

(SQL Table)

GPFR_PYSL_AE Schedule

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 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).

4 ROTATION_ID Character(10) VARCHAR2(10) NOT NULL Rotation ID

5 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

6 SCHED_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Scheduled Work Hours

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	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).
4	ROTATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Rotation ID
5	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
6	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours