PA_HST_PAY_DED (SQL Table)	Index Back
Historical Payroll Data This is an employee table containing Historical Payroll Data. This is copied directly from the Payroll tables and retained within Pension. A separate record will be created for each deduction code and deduction class per emplooyee.

PA_HST_PAY_DED

(SQL Table)

Historical Payroll Data

This is an employee table containing Historical Payroll Data. This is copied directly from the Payroll tables and retained within Pension. A separate record will be created for each deduction code and deduction class per emplooyee.

Parent record: PAY_CHECK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
Prompt Table: PAY_CALENDAR

4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
Y/N Table Edit

5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr

6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.

8 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.

9 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: BEN_PROG_BENPLN

10 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Prompt Table: BEN_PROG_BENDED

11 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

12 DED_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Deduction

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
5	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
6	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
7	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
8	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.
9	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: BEN_PROG_BENPLN
10	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: BEN_PROG_BENDED
11	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
12	DED_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Deduction