GP_RUNCTL_SQR04(SQL Table) |
Index Back |
|---|---|
Messages ReportThis record defines the Process scheduler Request Parameters for Payroll Messages Report. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_RUN_SRCH |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL |
EMPLID (first for a range)
Prompt Table: GP_PYE_STAT2_VW |
| 6 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL |
EmplID To
Prompt Table: GP_PYE_STAT2_VW |
| 7 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYE_STAT3_VW |
| 8 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GP_PYE_STAT4_VW |
| 9 | GROUP_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Group List ID
Prompt Table: GP_GRP_LIST_VW |
| 10 | PYE_CALC_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Calculation Status: field indicates the processing status of a segment (payment)
00=Identified 02=Calculation Error 03=Calculation Error - Bypassed 04=Calculation Error - By Rule 11=No Segment Created 50=Calculation Successful 55=Frozen For Further Calc 70=Finalized 75=Finalized - With Banking |
| 11 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: GP_MSGSETRUN_VW |
| 12 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: GP_MSGBYRUN_VW |
| 13 | GP_MSG_SEVERITY | Character(1) | VARCHAR2(1) NOT NULL |
Message Severity. Shows the severity of a message after a calculation. Stored in GP_MESSAGES
E=Error W=Warning |