DED_MESSAGE

(SQL Table)
Index Back

Calculated Deduction Messages

This record contains the messages generated from the batch job to calculate deductions for the Payroll Interface Product.

  • Parent record: DED_LINE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    6 MSGID Character(6) VARCHAR2(6) NOT NULL Message ID
    7 MSGDATA1 Character(30) VARCHAR2(30) NOT NULL Message Data
    8 MSGDATA2 Character(30) VARCHAR2(30) NOT NULL Message Data
    9 MSGDATA3 Character(30) VARCHAR2(30) NOT NULL Message Data
    10 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

    Prompt Table: PAY_RUN_TBL