GP_RTO_MCU_WRK(SQL Table) |
Index Back |
---|---|
Payee Process Stat rto copylimited "copy" of Payee Process Status used as temporary table in the Identify process for retroactively reinstating Manual Payments, Corrections and Unscheduled payments. [MCU] |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
5 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
6 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
7 | PRC_ORD_TS | DateTime(26) | TIMESTAMP | Process Order Timestamp |
8 | PRIOR_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Version Number |
9 | PRIOR_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Revision Number |
10 | SEL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Indicates status of the selected payee in a Calendar Group
As they are identified payees are pulled in either as Active or Inactive based on the EMPL_STATUS.
The system or the user can remove a payee either permanently or temporarily for various reasons. These are indicated by the status values other than Active and Inactive.
A=Active C=Cancelled I=Inactive S=System Suspend U=User Suspend |
11 | SEL_RSN | Character(2) | VARCHAR2(2) NOT NULL |
Selection Reason: Indicates why a payee was picked up and processed in a given calendar
01=On Payee List - Active 02=On Payee List - Inactive 03=Active and has PI 04=Active and has Rto Trgr 05=Active in Paygroup 06=Inactive and has PI 07=Inactive and has Rto Trgr 08=Inactive and has Rto Adj 09=Inactive and has Trgt Rto Adj 0A=Calendar Override - Active 0B=Calendar Override - Inactive 20=Absence Forecast |
12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
13 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
14 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
15 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
16 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
17 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
18 | PYMT_DT | Date(10) | DATE | Payment Date |
19 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
20 | RTO_PRC_ID | Character(10) | VARCHAR2(10) NOT NULL | Retro Process Definition ID |
21 | CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation B=All Calculations P=Payroll Calculation |
22 | RTO_MTHD_CHG_DT | Date(10) | DATE | Retro Method Change Date |
23 | GP_TX_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance.
XLAT values are assigned to support batch processing order
A=Advance M=Manual Payment R=Correction U=Additional Payment |
24 | GP_CORR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies type of correction requested (in offcycle). See Translate values for set of types
N=Normal retro R=Replacement V=Reversal - Normal retro W=Reversal - Replacement Y=Year end adjustment |
25 | GP_NO_REG_RES_IND | Character(1) | VARCHAR2(1) NOT NULL | Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle |
26 | PIN_ELEM_GRP_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number for Element Group |