SCH_CLND_VW (SQL View)	Index Back
Schedule Calendar Table The Schedule Calendar table maintains the association of Schedule Workdays to the specific date that the workday begins on.

SCH_CLND_VW

(SQL View)

Schedule Calendar Table

The Schedule Calendar table maintains the association of Schedule Workdays to the specific date that the workday begins on.

SELECT S.SETID , S.SCH_ADHOC_IND , S.SCHEDULE_ID , R.ROTATION_ID , X.THE_DATE , D.SHIFTNUM , D.DAYNUM , D.WRKDAY_ID , D.SHIFT_ID , D.OFFDAY_IND , S.SCH_TYPE , D.START_TIME , D.END_TIME , D.END_OFFSET , D.TIMEZONE , D.SCHED_HRS , D.SCH_CONFIG1 , D.SCH_CONFIG2 , D.SCH_CONFIG3 , D.SCH_CONFIG4 , S.TASKGROUP , S.TIME_RPTG_TMPLT , S.SCH_DLS_OPT , D.SYNCID , D.LASTUPDDTTM FROM PS_SCH_DEFN_TBL S , PS_SCH_DEFN_ROTATN R , PS_TL_DATES_TBL X , PS_SCH_DEFN_DTL D WHERE R.SETID = S.SETID AND R.SCH_ADHOC_IND = S.SCH_ADHOC_IND AND R.SCHEDULE_ID = S.SCHEDULE_ID AND R.EFFDT = S.EFFDT AND X.THE_DATE BETWEEN S.EFFDT AND S.END_EFFDT AND D.SETID = S.SETID AND D.SCH_ADHOC_IND = S.SCH_ADHOC_IND AND D.SCHEDULE_ID = S.SCHEDULE_ID AND D.EFFDT = S.EFFDT AND D.DAYNUM = %DateDiff(S.EFFDT, X.THE_DATE) + R.ROTATION_START_DAY - 1 - %Truncate((%DateDiff(S.EFFDT, X.THE_DATE) + R.ROTATION_START_DAY - 1) / S.SCHEDULE_DAYS, 0) * S.SCHEDULE_DAYS + 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SCH_ADHOC_IND Character(1) VARCHAR2(1) NOT NULL This field is used on Schedule Definitions to indicate if a Schedule is Ad Hoc (i.e. belonging to a specific employee) or Common (used by many employees)
1=Common Schedule
2=Ad Hoc Primary Schedule
3=Ad Hoc Alternate Schedule

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 SHIFTNUM Number(2,0) SMALLINT NOT NULL Shift Sequence Number

7 DAYNUM Number(3,0) SMALLINT NOT NULL Day Number

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

9 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

10 OFFDAY_IND Character(1) VARCHAR2(1) NOT NULL Off Day Indicator
N=Work Shift
Y=Off Shift

11 SCH_TYPE Character(2) VARCHAR2(2) NOT NULL Shift Type
E=Elapsed
F=Flex
P=Punch

12 START_TIME Time(15) TIMESTAMP Interview Start Time

13 END_TIME Time(15) TIMESTAMP Interview End Time

14 END_OFFSET Signed Number(2,0) DECIMAL(1) NOT NULL Date Under Report Offset identifies the number of days following the start day of a shift to assign a specific punch to. If the punch lands on the same day as the start of the shift, the offset is zero. If it lands on the following day, then the offset is one and so on.

15 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

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

17 SCH_CONFIG1 Number(5,2) DECIMAL(4,2) NOT NULL Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.

18 SCH_CONFIG2 Number(5,2) DECIMAL(4,2) NOT NULL Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.

19 SCH_CONFIG3 Number(5,2) DECIMAL(4,2) NOT NULL Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.

20 SCH_CONFIG4 Number(5,2) DECIMAL(4,2) NOT NULL Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.

21 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

22 TIME_RPTG_TMPLT Character(10) VARCHAR2(10) NOT NULL Time Reporting Template ID

23 SCH_DLS_OPT Character(1) VARCHAR2(1) NOT NULL Daylight Savings Option. Used on Schedules to indicate the action to take when a Schedule may be affected by Daylight Savings - i.e. either starts and ends in different TimeZones, or on days when Daylight Savings starts or ends.
1=Fixed Duration
2=Fixed Time

24 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

25 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SCH_ADHOC_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used on Schedule Definitions to indicate if a Schedule is Ad Hoc (i.e. belonging to a specific employee) or Common (used by many employees) 1=Common Schedule 2=Ad Hoc Primary Schedule 3=Ad Hoc Alternate Schedule
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	SHIFTNUM	Number(2,0)	SMALLINT NOT NULL	Shift Sequence Number
7	DAYNUM	Number(3,0)	SMALLINT NOT NULL	Day Number
8	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID
9	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
10	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift
11	SCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Shift Type E=Elapsed F=Flex P=Punch
12	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
13	END_TIME	Time(15)	TIMESTAMP	Interview End Time
14	END_OFFSET	Signed Number(2,0)	DECIMAL(1) NOT NULL	Date Under Report Offset identifies the number of days following the start day of a shift to assign a specific punch to. If the punch lands on the same day as the start of the shift, the offset is zero. If it lands on the following day, then the offset is one and so on.
15	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
16	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
17	SCH_CONFIG1	Number(5,2)	DECIMAL(4,2) NOT NULL	Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.
18	SCH_CONFIG2	Number(5,2)	DECIMAL(4,2) NOT NULL	Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.
19	SCH_CONFIG3	Number(5,2)	DECIMAL(4,2) NOT NULL	Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.
20	SCH_CONFIG4	Number(5,2)	DECIMAL(4,2) NOT NULL	Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition.
21	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup
22	TIME_RPTG_TMPLT	Character(10)	VARCHAR2(10) NOT NULL	Time Reporting Template ID
23	SCH_DLS_OPT	Character(1)	VARCHAR2(1) NOT NULL	Daylight Savings Option. Used on Schedules to indicate the action to take when a Schedule may be affected by Daylight Savings - i.e. either starts and ends in different TimeZones, or on days when Daylight Savings starts or ends. 1=Fixed Duration 2=Fixed Time
24	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
25	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.