GARN_RULE_TBL

(SQL Table)
 Index Back

Garnishment Rules Definition

Defines most of the garnishment rules used by the U.S. federal government, U.S. states and localities, and Canadian provinces.

  • Related Language Record: GARN_RULE_LANG

  • Parent Record Of GARN_DE_EARN GARN_EXEMPT_TBL GARN_OPERANDS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATE_GARN_LAW Character(6) VARCHAR2(6) NOT NULL Garnish Law Source

    Prompt Table: %EDITTABLE

    2 GARN_RULE_ID Character(10) VARCHAR2(10) NOT NULL Garnish Rule ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

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

    Default Value: C

    6 GARN_DE_DEFNID Character(10) VARCHAR2(10) NOT NULL Garnishment DE Definition ID

    Prompt Table: GARN_DE_DEFN

    7 PY_GARN_RULE_COPY Character(1) VARCHAR2(1) NOT NULL Use another Rule ID to define the rules formula.

    Y/N Table Edit

    Default Value: N

    8 PY_GARN_LAW_FROM Character(6) VARCHAR2(6) NOT NULL Defines Law Source that will be used in cloning process or in referencing the rule whose formula is used in Calculation Formula page.

    Prompt Table: STATE_GRN_US_VW

    9 PY_GARN_RULE_FROM Character(10) VARCHAR2(10) NOT NULL Defines Garnishment Rule ID that will be used in cloning process or in referencing the rule whose formula is used in Calculation Formula page.

    Prompt Table: PY_GARN_RULE_VW

    10 EFFDT_FROM Date(10) DATE Effective Date From

    Prompt Table: PY_GARN_EFF_VW

    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 DESCRLONG Long Character CLOB Long Description