GP_PYE_RCLC_VW(SQL View) |
Index Back |
|---|---|
Temp payee recalc tableThe table is put in place for use in iterative Cancel processing to identify payees that will subsequently be recalculated and need data removed from all the result data tables |
| SELECT DISTINCT emplid , cal_run_id ,empl_rcd ,gp_paygroup ,cal_id ,orig_cal_run_id ,pye_calc_stat FROM PS_GP_PYE_RCLC_WRK |
| # | 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 | 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 |