SCH_MNG_SCH_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	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
6	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
7	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
8	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
9	SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Scheduling Organizational Group Code Prompt Table: SCH_GROUP_TBL
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_TL_01
11	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID Prompt Table: SCH_WRKDAY_TBL
12	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID Prompt Table: SCH_SHIFT_TBL
13	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
14	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.
15	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.
16	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.
17	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.
18	START_DTTM	DateTime(26)	TIMESTAMP	Start Date/Time
19	END_DTTM	DateTime(26)	TIMESTAMP	Shift End Date/Time
20	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
21	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift