UPG_HP_01_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
7	POSITION_POOL_ID	Character(3)	VARCHAR2(3) NOT NULL	Position Pool ID
8	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
10	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
11	BUDGET_DATA	Character(50)	VARCHAR2(50) NOT NULL	Budget Data
12	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
13	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
14	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
15	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
16	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
17	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
18	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
19	TAX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Tax Balance Class
20	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
21	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4