SCH_CLND_WRK (SQL Table)	Index Back
Schedule Calendar Build WrkTb This Table is used in Schedule Calendar Build as a Work Table to load the Already built Schedule Calendar.

SCH_CLND_WRK

(SQL Table)

Schedule Calendar Build WrkTb

This Table is used in Schedule Calendar Build as a Work Table to load the Already built Schedule Calendar.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 WRKDAY_ID Character(10) VARCHAR2(10) NOT NULL Workday ID

4 DUR_OUT_DTTM DateTime(26) TIMESTAMP Work day Out Punch Date and Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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).
2	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
3	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID
4	DUR_OUT_DTTM	DateTime(26)	TIMESTAMP	Work day Out Punch Date and Time