GPUS_NRP_SRL_VW

(SQL View)
 Index Back

State Exemption Rules

State Exemption Rules table

SELECT GPUS_LAWSRC , GPUS_RULEID , GPUS_GRN_TYPE , GPUS_PIN_DEID_NUM + 50000000 , DESCR60 , DESCR , DATA_TYPE_CD FROM PS_GPUS_GRN_STRUL

  • 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 CD
    N=Customer Data
    S=Sample Data
    Y=System Data