GP_PYE_STAT_VW

(SQL View)
Index Back

PRC+SEG STAT view

This 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