UPG_JOB_DT_TMP

#	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 Rcd Nbr
3	EFFDT	Date(10)	DATE	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
6	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
7	HIRE_DT	Date(10)	DATE	First Start Date
8	LAST_HIRE_DT	Date(10)	DATE	Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
9	TERMINATION_DT	Date(10)	DATE	Termination Date
10	ASGN_START_DT	Date(10)	DATE	Start date of the specific EMPL_RCD assignment. This is different from the Person's Hire date.
11	ASGN_END_DT	Date(10)	DATE	End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.
12	LST_ASGN_START_DT	Date(10)	DATE	Lastest start date of the specific EMPL_RCD assignment. This is different from the Person's organizational instance Last Hire Date.
13	LDW_OVR	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether the user has overridden the Last Date Worked - ON THIS JOB_DATES row. It will only be set to 'Y' on the row where the date is entered, it will be 'N' on the later rows. This allows us to identify which JOB_DATES row is the row where the Date was either set or updated without having to look at the previous row. If the LDW = ( EFFDT - 1 ) or the LDW_OVR is 'Y', then this is the row where the LDW was set - and therefore can be corrected.
14	LAST_DATE_WORKED	Date(10)	DATE	Last Date Worked
15	EXPECTED_RETURN_DT	Date(10)	DATE	Expected Return Date