SCH_MNG_SCH_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	SCH_PRIM_ALT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether this is the employee's Primary or Alternate SChedule A=Alternate P=Primary Default Value: P
4	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
6	CHNG_PRIMARY	Character(1)	VARCHAR2(1) NOT NULL	field to indicate whether or not to change global payroll primary workday assignment A=Additional Shift for day D=Delete Shifts for Day R=Replacement Shift for Day Default Value: R
7	SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Scheduling Organizational Group Code Prompt Table: SCH_GROUP_TBL
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_TL_01
9	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID Prompt Table: SCH_WRKDAY_TBL
10	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID Prompt Table: SCH_SHIFT_TBL
11	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
12	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.
13	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.
14	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.
15	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.
16	START_DTTM	DateTime(26)	TIMESTAMP	Start Date/Time
17	END_DTTM	DateTime(26)	TIMESTAMP	Shift End Date/Time
18	SCHED_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Schedule Source indicates the source of Time Reporter Detail Schedule information. E=Enterprise Learning Management I=Third Party Import L=Long Term Schedule O=On-Line Change
19	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift