GPBR_PAYSL_FORM

(SQL Table)
 Index Back

PaySlip Format

General Data PaySlip

  • Related Language Record: GPBR_PYSFRM_LNG

  • Parent Record Of GPBR_NRP_PYD_VW GPBR_NRP_PYE_VW GPBR_PAYSL_F_AC GPBR_PAYSL_F_DE GPBR_PAYSL_F_ER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 GPBR_PIN_PSLP1_NUM Number(8,0) INTEGER NOT NULL Total Earnings. Accumulator for Payslip

    Prompt Table: GP_ACCMLTR_SRCH

    7 GPBR_PIN_PSLP2_NUM Number(8,0) INTEGER NOT NULL Total Earnings. Accumulator for Payslip

    Prompt Table: GP_ACCMLTR_SRCH

    8 GPBR_PIN_PSLP3_NUM Number(8,0) INTEGER NOT NULL Net Pay. Accumulator for Payslip

    Prompt Table: GP_ACCMLTR_SRCH

    9 GPBR_EARN_IE Character(2) VARCHAR2(2) NOT NULL Earnings Include/Exclude
    10=Include
    20=Exclude

    Default Value: 10

    10 GPBR_DED_IE Character(2) VARCHAR2(2) NOT NULL Deduction Include/Exclude
    10=Include
    20=Exclude

    Default Value: 10

    11 GPBR_SELECT_ALL1 Character(1) VARCHAR2(1) NOT NULL Select All Elements

    Y/N Table Edit

    Default Value: N

    12 GPBR_SELECT_ALL2 Character(1) VARCHAR2(1) NOT NULL Select All

    Y/N Table Edit

    Default Value: N

    13 GPBR_PSLP1_LCODE Character(6) VARCHAR2(6) NOT NULL Legal Code

    Prompt Table: GPBR_TRCT_CODES

    14 GPBR_PSLP2_LCODE Character(6) VARCHAR2(6) NOT NULL Legal Code

    Prompt Table: GPBR_TRCT_CODES

    15 GPBR_PSLP3_LCODE Character(6) VARCHAR2(6) NOT NULL Legal Code

    Prompt Table: GPBR_TRCT_CODES