GP_PYE_STAT_VW(SQL View) |
Index Back |
---|---|
PRC+SEG STAT viewThis record displays payee status information from the GP_PYE_PRC_STAT and GP_PYE_SEG_STAT |
SELECT A.EMPLID , B.PRC_ORD_TS ,' ' , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.RSLT_SEG_NUM , B.PYE_PRC_IND , A.PYE_CALC_STAT , B.SEL_STAT , B.RUN_TYPE , B.PAY_ENTITY , A.GP_CALC_TS FROM PS_GP_PYE_SEG_STAT A , PS_GP_PYE_PRC_STAT B WHERE A.EMPLID = B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.ORIG_CAL_RUN_ID=B.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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
6 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
7 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
8 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
9 | 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 |
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 | 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 |
12 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
13 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
14 | GP_CALC_TS | DateTime(26) | TIMESTAMP | Indicates when something (a segment) was calculated |