UPG_CONTPAY_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	HP_CONTRACT_NUM	Number(7,0)	INTEGER NOT NULL	Contract Number
4	HP_CONTRACT_EFFDT	Date(10)	DATE	Contract Effective date
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
6	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
7	CONTRACT_BEGIN_DT	Date(10)	DATE	Contract Begin Date
8	CONTRACT_END_DT	Date(10)	DATE	Contract End Date
9	PAYMENT_BEGIN_DT	Date(10)	DATE	Payment Begin Date
10	PAYMENT_END_DT	Date(10)	DATE	Payment End Date
11	HP_TRACK_ACTUALS	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if Actual Earnings need to be tracked for a contract pay employee
12	HP_WORKDAYS	Number(3,0)	SMALLINT NOT NULL	Stores actual work days for contract period
13	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
14	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
15	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
16	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
17	WORK_SCHEDULE	Character(7)	VARCHAR2(7) NOT NULL	Work Schedule
18	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule
19	HP_USE_HOL_SCHD	Character(1)	VARCHAR2(1) NOT NULL	To specify if Holiday Schedule is referenced
20	HP_HOL_SCHD	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule
21	ERNCD_CNTRCT_REG	Character(3)	VARCHAR2(3) NOT NULL	Contract Regular Earnings
22	HP_CARRY_OVER_CRG	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Contract Regular amount carry over from previous sequence
23	ERNCD_PD_NOT_ERN	Character(3)	VARCHAR2(3) NOT NULL	Paid Not Earned Erncd
24	HP_CARRY_OVER_PNE	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Paid not Earned amount carry over from previous sequence
25	ERNCD_ERN_NOT_PD	Character(3)	VARCHAR2(3) NOT NULL	Earned and Not Paid Erncd
26	HP_CARRY_OVER_ENP	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Earned not Paid amount carry over from previous sequence
27	HP_CARRY_OVER_WRK	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual worked amount carry over from previous sequence
28	UPG_CNTRCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Active C=Complete F=Future
29	UPG_LAST_CNFRM_DT	Date(10)	DATE	Last confirmed pay end date
30	HP_DAILY_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Contract Employee's Daily Hours