SCH_DEFN_DTL

#	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	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 Default Value: 1
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	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	DAYNUM	Number(3,0)	SMALLINT NOT NULL	Day Number Default Value: 1
6	SHIFTNUM	Number(2,0)	SMALLINT NOT NULL	Shift Sequence Number Default Value: 1
7	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID Prompt Table: SCH_WRKDAY_TBL
8	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID Prompt Table: %EDITTABLE7
9	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
10	START_TIME	Time(15)	TIMESTAMP	Shift Start Time
11	END_TIME	Time(15)	TIMESTAMP	Shift End Time
12	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.
13	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
14	STRT_STOP_DIFF	Number(5,2)	DECIMAL(4,2) NOT NULL	Start Stop Time Duration
15	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.
16	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.
17	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.
18	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.
19	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift Y/N Table Edit Default Value: N
20	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
21	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.
22	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.