GARN_DE_DEFN

(SQL Table)
 Index Back

Garnishment Dspable Earns Defn

Rule for defining earnings subject to garnishment, including exemptions.

  • Related Language Record: GARN_DE_DEF_LNG

  • Parent Record Of GARN_DE_DED

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GARN_DE_DEFNID Character(10) VARCHAR2(10) NOT NULL Garnishment DE Definition ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 MAINT_RESPONSBLTY Character(1) VARCHAR2(1) NOT NULL Maintenance Responsibility
    C=Customer
    P=PeopleSoft

    Default Value: C

    5 DECALC_SUBTR_FTX Character(1) VARCHAR2(1) NOT NULL Subtract Federal Tax

    Y/N Table Edit

    Default Value: Y

    6 DECALC_SUBTR_STX Character(1) VARCHAR2(1) NOT NULL Subtract State Tax

    Y/N Table Edit

    Default Value: Y

    7 DECALC_SUBTR_LTX Character(1) VARCHAR2(1) NOT NULL Subtract Local Tax

    Y/N Table Edit

    Default Value: Y

    8 DECALC_SUBTR_CSP Character(1) VARCHAR2(1) NOT NULL Subtract Child Support

    Y/N Table Edit

    Default Value: N

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 TAX_BEN_IND Character(1) VARCHAR2(1) NOT NULL Taxable Benefits
    E=Exclude
    I=Include

    Default Value: I

    11 DESCRLONG Long Character CLOB Long Description