ERN_PROGRAM_TBL

(SQL Table)
 Index Back

Earnings Prog Tbl Description

This record is the effective dated control record for the Earnings Code Definition Table. Also contains long and short descriptions for the earnings program.

  • Related Language Record: ERN_PROGRAM_LNG

  • Parent Record Of ERN_PG_DES2_LNG ERN_PROGRAM_DEF ERN_PROG_DESCR ERN_PROG_DESCR2 ERN_PROG_DSCLNG GVT_RTND_PP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ERN_PROGRAM Character(3) VARCHAR2(3) NOT NULL Earnings Program 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