GPBR_TRCT_CODES

(SQL Table)
 Index Back

Legal Codes for TRCT

Legal Codes for TRCT

  • Related Language Record: GPBR_TRCT_C_LNG

  • Parent record: GPBR_TRCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    2 GPBR_LEGAL_CODE Character(7) VARCHAR2(7) NOT NULL Legal Code
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 GPBR_CODE_TYPE Character(1) VARCHAR2(1) NOT NULL TRCT Code Type
    1=1-Earning
    2=2-Deduction

    Default Value: 1

    5 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N

    6 GPBR_PIN_VAR_NUM Number(8,0) INTEGER NOT NULL Alimony Percentage BRA

    Prompt Table: GPBR_PIN_NU1_VW

    7 GPBR_PAR1_TYPE Character(2) VARCHAR2(2) NOT NULL Parameter Type
    10=Unit
    20=Variable
    30=User Field 2
    40=Amount
    50=Percent
    60=User Field 1

    Default Value: 10

    8 GPBR_PIN_VA2_NUM Number(8,0) INTEGER NOT NULL Alimony Percentage BRA

    Prompt Table: GPBR_PIN_NU2_VW

    9 GPBR_PAR2_TYPE Character(2) VARCHAR2(2) NOT NULL Parameter Type
    10=Unit
    20=Variable
    30=User Field 2
    40=Amount
    50=Percent
    60=User Field 1

    Default Value: 10

    10 GPBR_PIN_VA3_NUM Number(8,0) INTEGER NOT NULL Alimony Percentage BRA

    Prompt Table: GPBR_PIN_NU3_VW

    11 GPBR_PAR3_TYPE Character(2) VARCHAR2(2) NOT NULL Parameter Type
    10=Unit
    20=Variable
    30=User Field 2
    40=Amount
    50=Percent
    60=User Field 1

    Default Value: 10