PY_QC_RUN_IDPAGE_NUMLINE_NUMSEPCHKMSGIDMSGDATA1MSGDATA2MSGDATA3PY_MESSAGE_QC(SQL Table) |
Index Back |
|---|---|
Payroll Errors - Quick CalcThis record contains payroll error messages created by payroll quick calculation process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PY_QC_RUN_ID |
Character(95) | VARCHAR2(95) NOT NULL | Quick Calc Run ID |
| 2 | PAGE_NUM |
Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 3 | LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Line Nbr |
| 4 | SEPCHK |
Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 5 | MSGID |
Character(6) | VARCHAR2(6) NOT NULL | Message ID |
| 6 | MSGDATA1 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 7 | MSGDATA2 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 8 | MSGDATA3 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |