PY_MOD_PGARN_VW

(SQL View)
 Index Back

Payroll Garnishment

This record contains detail Garnishment information resulting from the Payroll Calculation Process at the pay line level.

SELECT distinct A.PY_MOD_OPRID , A.PY_MOD_EMPLID , 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 FROM PS_MODEL_PAY_GARN A

  • Parent record: PAY_CHECK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_MOD_OPRID Character(30) VARCHAR2(30) NOT NULL PayCheck Modeler User Id
    2 PY_MOD_EMPLID Character(11) VARCHAR2(11) NOT NULL PayCheck Modeler Employee ID
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    5 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    7 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    8 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    9 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check 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