SCH_SHIFT_TBL

#	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	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	END_EFFDT	Date(10)	DATE	End Effdt
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: SCH_SHIFT_TBL.DESCR
7	SCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Shift Type E=Elapsed F=Flex P=Punch Default Value: P
8	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
9	START_TIME	Time(15)	TIMESTAMP	Shift Start Time
10	END_TIME	Time(15)	TIMESTAMP	Shift End Time
11	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.
12	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
13	STRT_STOP_DIFF	Number(5,2)	DECIMAL(4,2) NOT NULL	Start Stop Time Duration
14	FLEX_START_TIME	Time(15)	TIMESTAMP	Flex Start Time identifies the earliest time that a Time Reporter working a Flex shift may consider to be the beginning of the shift.
15	FLEX_END_TIME	Time(15)	TIMESTAMP	Flex End Time identifies the latest time that a Time Reporter working a Flex shift may consider to be the end of the shift.
16	FLEX_WK_HRS	Number(3,0)	SMALLINT NOT NULL	Flex Weekly Hours identifies the number of hours expected to be worked and compensated for during one week on the flex shift.
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	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift Y/N Table Edit Default Value: N
22	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
23	TIME_RPTG_TMPLT	Character(10)	VARCHAR2(10) NOT NULL	Time Reporting Template ID Prompt Table: SCH_TR_TMPT_VW
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.