GP_PYE_STAT1_VW(SQL View) |
Index Back |
|---|---|
View CAN+SUSP PRC STATsThis record displays payee status information from the GP_PYE_PRC_STATfor cancelled and suspended segments |
| SELECT EMPLID , PRC_ORD_TS , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , 0 , PYE_PRC_IND , ' ' , SEL_STAT , RUN_TYPE , PAY_ENTITY FROM PS_GP_PYE_PRC_STAT P WHERE NOT EXISTS ( SELECT 1 FROM PS_GP_PYE_SEG_STAT S WHERE P.EMPLID=S.EMPLID AND P.EMPL_RCD=S.EMPL_RCD AND P.CAL_RUN_ID=S.CAL_RUN_ID AND P.GP_PAYGROUP = S.GP_PAYGROUP AND P.CAL_ID=S.CAL_ID AND P.ORIG_CAL_RUN_ID=S.ORIG_CAL_RUN_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | PRC_ORD_TS | DateTime(26) | TIMESTAMP | Process Order Timestamp |
| 3 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | PYE_PRC_IND | Character(1) | VARCHAR2(1) NOT NULL |
Enables user to indicate type of (re) processing to be done on the results for any given payee within a processed calendar group
C=Cancel F=Freeze N=Normal R=Re-Calculate S=Suspend U=Uncancel W=Unfreeze |
| 9 | 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 |
| 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 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 12 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |