GVT_CI_EXEP_TBL

(SQL Table)
 Index Back

CI Message Catalog

Stores Ci Exception messages generated while updating Core tables from federal tables on completion of a PAR transaction.

  • Parent record: PSMSGSETDEFN

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

    Default Value: NEW

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 GVT_CI_EXEP_SEQ Number(3,0) SMALLINT NOT NULL To store the sequence number for CI exceptions.
    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    8 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
    C=Cancel
    E=Error
    M=Message
    W=Warning

    Default Value: M

    9 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    10 MESSAGE_TEXT_WRK Character(250) VARCHAR2(250) NOT NULL Message Text
    11 DESCRLONG Long Character CLOB Long Description