MODEL_PAY_MSGS

(SQL Table)
Index Back

Payroll Errors (Messages)

This record contains payroll error messages created by payroll calculation process.

  • Parent record: PAY_LINE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_MOD_OPRID Character(30) VARCHAR2(30) NOT NULL PayCheck Modeler User Id

    Prompt Table: OPRID_VW2

    2 PY_MOD_EMPLID Character(11) VARCHAR2(11) NOT NULL PayCheck Modeler Employee ID

    Prompt Table: PERSON_NAME

    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

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

    Prompt Table: PAY_CALENDAR

    6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    Default Value: Y

    7 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    8 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    9 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    10 MSGID Character(6) VARCHAR2(6) NOT NULL Message ID
    11 MSGDATA1 Character(30) VARCHAR2(30) NOT NULL Message Data
    12 MSGDATA2 Character(30) VARCHAR2(30) NOT NULL Message Data
    13 MSGDATA3 Character(30) VARCHAR2(30) NOT NULL Message Data
    14 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

    Prompt Table: PAY_RUN_TBL

    15 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance