PAY_NA_DED_E_VW

(SQL View)
 Index Back

NA Payroll Dist Ded Exp View

NA Payroll Distribution Deduction Expense View

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.BENEFIT_RCD_NBR , A.PLAN_TYPE , A.BENEFIT_PLAN , A.DEDCD , A.DED_CLASS , A.DED_SLSTX_CLASS , A.ACCT_CD , A.SEQNO , A.ADDL_NBR , A.ERNCD , A.DED_CUR , A.GARN_PRIORITY , A.GARNID , A.BOND_ID , A.BOND_OWNER_ID , A.BOND_OTH_REG_TYPE , A.BOND_OTH_REG_ID , A.BOND_LOG_SEQ FROM PS_PAY_NA_DED_DIST A WHERE A.PY_LIABEXPFLG = 'E'

# 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(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 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.
9 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.
10 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

Prompt Table: BEN_PROG_BENPLN

11 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

Prompt Table: BEN_PROG_BENDED

12 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
13 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
14 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_TBL

15 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
16 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
17 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
18 DED_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Deduction
19 GARN_PRIORITY Number(3,0) SMALLINT NOT NULL Garnishment priority.
20 GARNID Character(6) VARCHAR2(6) NOT NULL Garnishment id.
21 BOND_ID Character(3) VARCHAR2(3) NOT NULL Savings Bond ID
22 BOND_OWNER_ID Character(2) VARCHAR2(2) NOT NULL Bond Owner ID
23 BOND_OTH_REG_TYPE Character(1) VARCHAR2(1) NOT NULL Bond Other Registrant Type
B=Beneficiary
C=Co-Owner
N=No Other Bond Registrant
24 BOND_OTH_REG_ID Character(2) VARCHAR2(2) NOT NULL Bond Other Registrant ID
25 BOND_LOG_SEQ Number(3,0) SMALLINT NOT NULL Bond Activity Seq Nbr