PY_IC_PI_GBL_VW

(SQL View)
 Index Back

Garnishment Balance

MTD, QTD & YTD garnishment balances.

SELECT A.EMPLID , A.COMPANY , A.BALANCE_ID , A.BALANCE_YEAR , A.BALANCE_QTR , A.BALANCE_PERIOD , A.PLAN_TYPE , A.BENEFIT_PLAN , A.DEDCD , A.DED_CLASS , A.GARNID , A.DED_YTD , A.DED_GARN_YTD , A.DED_CFEE_YTD , A.DED_PFEE_YTD FROM PS_GARN_BALANCE A

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
    4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
    5 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter
    6 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period
    7 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.
    8 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
    9 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
    10 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
    11 GARNID Character(6) VARCHAR2(6) NOT NULL Garnish ID
    12 DED_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance YTD
    13 DED_GARN_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Garnish Balance YTD
    14 DED_CFEE_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Ded Company Fee Balance YTD
    15 DED_PFEE_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Ded Payee Fee Balance YTD