GPUS_GRN_STRUL

(SQL Table)
 Index Back

State Exemption Rules

State Exemption Rules table

  • Related Language Record: GPUS_GRNSRL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPUS_LAWSRC Character(6) VARCHAR2(6) NOT NULL GPUS_LAWSRC

    Prompt Table: GPUS_STATE_VW

    2 GPUS_RULEID Character(30) VARCHAR2(30) NOT NULL GPUS_RULEID

    Prompt Table: GPUS_RUL_VW

    3 GPUS_GRN_TYPE Character(4) VARCHAR2(4) NOT NULL GPUS_GARNTYPE
    10=Child Support
    20=Dependent Support
    30=Spousal Support
    40=Tax Levy
    50=Creditor Garnishment
    60=Student Loan
    70=Chapter 13 Bankruptcy
    80=AWG - Wage Garnishment
    90=Wage Assignment
    4 GPUS_PIN_DEID_NUM Number(8,0) INTEGER NOT NULL Disposable Earning AC PIN Number

    Prompt Table: GPUS_DE_VW

    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data