MNG_SCH_TRACK

#	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	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
4	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
5	SCH_CHG_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Schedule Change Actions C=Copy R=Replace S=Swap
6	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
7	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
8	SCH_TARGET_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Schedule Target EmplId
9	SCH_TARGET_EMPLRCD	Number(3,0)	SMALLINT NOT NULL	Schedule Target EmplRcd
10	DATETIME_CREATED	DateTime(26)	TIMESTAMP	DateTime Created