GARN_OPERANDS

(SQL Table)
 Index Back

Garnishment Operands

Operands for custom garnishment rules.

  • Parent record: GARN_RULE_TBL

    • # 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: STATE_NAMES_VW

    2 GARN_RULE_ID Character(10) VARCHAR2(10) NOT NULL Garnish Rule ID

    Prompt Table: GARN_RULE_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GARN_STEP Number(3,0) SMALLINT NOT NULL Garnishment rule formula step.
    5 GARN_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Garnishment Calculation Type.
    A=Amt Available for Garnishment
    D=DE for Rule
    E=Exemption

    Default Value: D

    6 GARN_ELEMENT1 Character(2) VARCHAR2(2) NOT NULL Garnishment rule formula element1.

    Default Value: N

    Prompt Table: %EDITTABLE

    7 GARN_ELEMENT2 Character(2) VARCHAR2(2) NOT NULL Garnishment rule formula element2.

    Default Value: N

    Prompt Table: %EDITTABLE2

    8 GARN_OPERATOR Character(1) VARCHAR2(1) NOT NULL Garnishment rule formula operator.
    *=Multiply by
    +=Plus
    -=Minus
    /=Divided by
    N=N/A

    Default Value: N

    9 GARN_AMOUNT1 Signed Number(10,2) DECIMAL(8,2) NOT NULL Garnishment Amount.
    10 GARN_AMOUNT2 Signed Number(10,2) DECIMAL(8,2) NOT NULL Garnishment Amount.
    11 GARN_PERCENT1 Number(6,2) DECIMAL(5,2) NOT NULL Garnishment percent1.
    12 GARN_PERCENT2 Number(6,2) DECIMAL(5,2) NOT NULL Garnishment percent2.
    13 GARN_STEP1 Number(3,0) SMALLINT NOT NULL Garnishment rule formula step.
    14 GARN_STEP2 Number(3,0) SMALLINT NOT NULL Garnishment rule formula step.
    15 GARN_CONDITION Character(1) VARCHAR2(1) NOT NULL Garnishment rule formula condition.
    G=Greater of Element 1 and 2
    L=Less of Element 1 and 2
    M=Min/Max Check
    N=None
    Z=If negative, set to zero.

    Default Value: N