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

GP_PYEPRCSTC_VW

(SQL View)

Prc Stats by Sel Stat

Calendar Statistics Aggregate view use to display SEL_STAT total.

SELECT A.CAL_RUN_ID , A.CAL_ID , A.GP_PAYGROUP , %Substring(A.GP_CS_STATUS ,1,1) , A.XLATLONGNAME , SUM(A.GP_AGGR_COUNT) FROM PS_GP_CS_STAT_STG A WHERE A.USER_KEY1 = 'SEL_STAT' GROUP BY A.CAL_RUN_ID , A.CAL_ID , A.GP_PAYGROUP , A.GP_CS_STATUS , A.XLATLONGNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

4 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

5 SEL_STAT_CS Character(30) VARCHAR2(30) 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.

6 GP_AGGR_COUNT Number(9,1) DECIMAL(8,1) 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	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
4	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
5	SEL_STAT_CS	Character(30)	VARCHAR2(30) 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.
6	GP_AGGR_COUNT	Number(9,1)	DECIMAL(8,1) NOT NULL	field used to present processing statistics