GPGB_EE_M_DTL

(SQL Table)
Index Back

Payslip EE Message detail

Modified by Jo Maye 27/7/2001 (JMAYE) for Oracle fix. Changed the message field to GPGB_PSLIP_MESS from DESCRLONG.

  • Parent record: GPGB_EE_MESS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 GPGB_PSLIP_ID Character(6) VARCHAR2(6) NOT NULL Payslip ID

    Prompt Table: GPGB_PSLIP_HDR

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
    6 GPGB_PSLIP_MESS Character(254) VARCHAR2(254) NOT NULL New field created by Jo Maye 27/7/2001 for Oracle Payslip fix (JMAYE)