GPUS_GRN_PRORUL

(SQL Table)
 Index Back

GPUS_STPRORULE

GPUS_STPRORULE

  • Related Language Record: GPUS_GRNPRO_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_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
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GPUS_PIN_PROFM_NUM Number(8,0) INTEGER NOT NULL Proration Formula PIN Number

    Prompt Table: GPUS_GRNPRFM_VW

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCRLONG Long Character CLOB Long Description
    8 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data