HP_COL_DEFN_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HP_RPT_COLDEFN_CD	Character(5)	VARCHAR2(5) NOT NULL	This field identifies the report definition set that the report based on to cumulate gross wages and fringe benefits.
2	HP_COLUMN_ID	Character(1)	VARCHAR2(1) NOT NULL	This field identifies user-defined report column. A=Column A B=Column B C=Column C D=Column D E=Column E F=Column F
3	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
4	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.
5	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
6	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
7	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
8	DED_SLSTX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Type B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax
9	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_NM_USA_VW
10	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
11	TAX_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Tax Balance Class Prompt Table: PY_TAX_CLASS
12	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province Prompt Table: PROVINCE_NM_VW
13	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CP2=CPP Second Additional Employee CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer CR2=CPP Second Additional 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) QP2=QPP Second Additional Employee QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer QR2=QPP Second Additional Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4