UPG_CNTRACT_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	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	HP_CONTRACT_NUM	Number(7,0)	INTEGER NOT NULL	Contract Number
5	CONTRACT_BEGIN_DT	Date(10)	DATE	Contract Begin Date
6	CONTRACT_END_DT	Date(10)	DATE	Contract End Date
7	PAYMENT_BEGIN_DT	Date(10)	DATE	Payment Begin Date
8	PAYMENT_END_DT	Date(10)	DATE	Payment End Date
9	HP_TRACK_ACTUALS	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if Actual Earnings need to be tracked for a contract pay employee
10	HP_WORKDAYS	Number(3,0)	SMALLINT NOT NULL	Stores actual work days for contract period
11	HP_USE_HOL_SCHD	Character(1)	VARCHAR2(1) NOT NULL	To specify if Holiday Schedule is referenced
12	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
13	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
14	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
15	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
16	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
17	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule
18	FREQ_ANNUAL_FACTOR	Number(12,7)	DECIMAL(11,7) NOT NULL	Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.
19	UPG_FREQ_ANN_FACT	Number(12,7)	DECIMAL(11,7) NOT NULL	Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.
20	WORK_SCHEDULE	Character(7)	VARCHAR2(7) NOT NULL	Work Schedule
21	HP_HOL_SCHD	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule
22	ERNCD_CNTRCT_REG	Character(3)	VARCHAR2(3) NOT NULL	Contract Regular Earnings
23	ERNCD_PD_NOT_ERN	Character(3)	VARCHAR2(3) NOT NULL	Paid Not Earned Erncd
24	ERNCD_ERN_NOT_PD	Character(3)	VARCHAR2(3) NOT NULL	Earned and Not Paid Erncd
25	UPG_CNTRCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Active C=Complete F=Future
26	UPG_LAST_CNFRM_DT	Date(10)	DATE	Last confirmed pay end date
27	HP_DAILY_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Contract Employee's Daily Hours