GP_PYEPRCSST_VW (SQL View)	Index Back
Prc Stats by Sel Stat Calendar Statistics Aggregate view use to display SEL_STAT total.

GP_PYEPRCSST_VW

(SQL View)

Prc Stats by Sel Stat

Calendar Statistics Aggregate view use to display SEL_STAT total.

SELECT A.CAL_RUN_ID , A.SEL_STAT , COUNT(*) FROM PS_GP_PYE_PRC_STAT A GROUP BY A.CAL_RUN_ID , A.SEL_STAT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 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

3 GP_AGGR_COUNT Number(7,0) INTEGER NOT NULL field used to present processing statistics

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	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
3	GP_AGGR_COUNT	Number(7,0)	INTEGER NOT NULL	field used to present processing statistics