MODEL_PAY_MSGS(SQL Table) |
Index Back |
---|---|
Payroll Errors (Messages)This record contains payroll error messages created by payroll calculation process. |
# | 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 |