HP_PY_DED_SPNVW

(SQL View)
 Index Back

Payroll Deduction Fund Dist

This table contains deduction information created during the payroll calculation/distribution process. A separate record will be created for each deduction code and deduction class per employee, account code, and accounting period.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.PLAN_TYPE , A.BENEFIT_PLAN , A.DEDCD , A.DED_CLASS , A.DED_SLSTX_CLASS , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.ACCT_CD , A.BUDGET_DATA , A.ACCOUNT , A.EARNS_END_DT , A.DED_CUR , A.DEPTID , A.POSITION_POOL_ID , A.JOBCODE , A.POSITION_NBR , A.EMPL_RCD , A.HP_RETDIST_SEQ_NO , A.CURRENCY_CD , A.REVERSED , A.HP_RETDIST_STATUS , A.HP_RDIST_REV_SEQ , A.HP_RDIST_GL_INFACE , A.HP_RETDIST_PAY_DT , A.DEFAULT_FUND_OPTN , A.HP_DISTRIB_OVRRIDE FROM PS_PAY_DED_DIST A WHERE HP_RETDIST_STATUS = '0'

  • Parent record: PAY_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_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
    13 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

    Prompt Table: ACCT_FY_VW

    14 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Accounting Period

    Prompt Table: ACCT_PERIOD_VW

    15 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_CA_VW

    16 BUDGET_DATA Character(50) VARCHAR2(50) NOT NULL Budget Data
    17 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    18 EARNS_END_DT Date(10) DATE Earnings End Date
    19 DED_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Deduction
    20 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: BUD_DEPT_EFF_VW
    Set Control Field: BUSINESS_UNIT

    21 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID
    22 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    23 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    24 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    25 HP_RETDIST_SEQ_NO Number(5,0) INTEGER NOT NULL Retro Distrubution process sequence number
    26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    27 REVERSED Character(1) VARCHAR2(1) NOT NULL Reversed

    Y/N Table Edit

    Default Value: N

    28 HP_RETDIST_STATUS Character(1) VARCHAR2(1) NOT NULL Indicates the status of retro distribution on the current distribution record
    0=Not changed
    D=Reversing Entry
    R=Redistributed
    29 HP_RDIST_REV_SEQ Number(5,0) INTEGER NOT NULL Pointer to set of data that repalces the current set of data, used by retro distribution
    30 HP_RDIST_GL_INFACE Character(1) VARCHAR2(1) NOT NULL Retroactive Distribution run for GL Interface
    31 HP_RETDIST_PAY_DT Date(10) DATE Retro Dist Pay End Date
    32 DEFAULT_FUND_OPTN Character(1) VARCHAR2(1) NOT NULL Default Funding Source Option
    A=Distrib over Actual Earnings
    E=Earnings Funding Source
    N=No Defaults
    S=Specified Defaults
    33 HP_DISTRIB_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Actuals Distribution overriden at the Actuals Distribution Panel