PAY_NA_DED_D_VW

(SQL View)
 Index Back

Deduction Distribution

NA Payroll Distribution - Deduction Liability

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.SEPCHK , A.BENEFIT_RCD_NBR , A.PLAN_TYPE , A.BENEFIT_PLAN , A.DEDCD , A.DED_CLASS , A.DED_SLSTX_CLASS , A.PY_LIABEXPFLG , A.ERNCD , A.ACCT_CD , B.BUSINESS_UNIT , B.EMPLID , B.EMPL_RCD , B.DEPTID , B.POSITION_NBR , B.JOBCODE , A.ACCOUNT , A.DED_CUR FROM PS_PAY_NA_DED_S_VW A , PS_PAY_NA_EARNINGS B WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND A.PAY_END_DT = B.PAY_END_DT AND A.OFF_CYCLE = B.OFF_CYCLE AND A.PAGE_NUM = B.PAGE_NUM AND A.LINE_NUM = B.LINE_NUM AND A.ADDL_NBR = B.ADDL_NBR AND A.SEPCHK = B.SEPCHK AND A.ERNCD = B.ERNCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
8 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
9 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
10 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.
11 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
12 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

Prompt Table: BEN_PROG_BENDED

13 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
14 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
15 PY_LIABEXPFLG Character(1) VARCHAR2(1) NOT NULL Liability / Expense Flag
E=GL Expense
L=GL Liability
R=GL Employer's Liability
16 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
17 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_TBL

18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
19 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
20 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
22 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
23 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
24 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
25 DED_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Deduction