PAY_NA_DED_S_VW

(SQL View)
 Index Back

NA Payroll Dist Ded

NA Payroll Distribution - Deduction Liability View on deduction totals.

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 , A.ACCOUNT , SUM(A.DED_CUR) FROM PS_PAY_NA_DED_DIST A WHERE A.PY_LIABEXPFLG IN ('L','R') GROUP BY 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 , A.ACCOUNT

# 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
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

Prompt Table: BEN_PROG_BENPLN

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 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
19 DED_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Deduction