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

GP_CS_PRCSST_VW

(SQL View)

Prc Stats by Sel Stat

Calendar Statistics Aggregate view use to display SEL_STAT total.

SELECT A.CAL_RUN_ID , %Substring(A.GP_CS_STATUS ,1 ,1) , A.XLATLONGNAME , A.CALC_TYPE , 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.GP_CS_STATUS , A.XLATLONGNAME , A.CALC_TYPE

# 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 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.

4 CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation
B=All Calculations
P=Payroll Calculation

5 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	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	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.
4	CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Process Type. Identifies a run as either absence run or payroll run A=Absence Calculation B=All Calculations P=Payroll Calculation
5	GP_AGGR_COUNT	Number(9,1)	DECIMAL(8,1) NOT NULL	field used to present processing statistics