HP_COL_DEFN_DTL (SQL Table)	Index Back
User defined report col detail Gross and Fringe Report - Setup table that stores the detail each user defined report column.

HP_COL_DEFN_DTL

(SQL Table)

User defined report col detail

Gross and Fringe Report - Setup table that stores the detail each user defined report column.

# 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(1) VARCHAR2(1) NOT NULL Tax Balance 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)
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

#	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(1)	VARCHAR2(1) NOT NULL	Tax Balance 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) 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