WRK_WFS2_TAO

#	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
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 Y/N Table Edit Default Value: N
7	SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Scheduling Organizational Group Code
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
9	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID
10	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
11	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.
12	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.
13	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.
14	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.
15	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
16	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift
17	NEW_PRM_WRKDAY	Character(10)	VARCHAR2(10) NOT NULL	New primary workday assignment; the primary user for this is Global Payroll using the Manage Schedules event. Prompt Table: %EDITTABLE
18	CHNG_ALT	Character(1)	VARCHAR2(1) NOT NULL	field to indicate whether or not to change GP alternate workday assignment Y/N Table Edit Default Value: N
19	CHNG_ALT_WRKDAY	Character(10)	VARCHAR2(10) NOT NULL	new GP alt workday assignment Prompt Table: %EDITTABLE