GP_PRCXSTRM1_VW (SQL View)	Index Back
PrcStat by Stream and Sel Stat PrcStat by Stream and Sel Stat

GP_PRCXSTRM1_VW

(SQL View)

PrcStat by Stream and Sel Stat

SELECT P.CAL_RUN_ID ,S.STRM_NUM ,P.SEL_STAT ,COUNT(*) FROM PS_GP_PYE_PRC_STAT P ,PS_GP_CAL_RUN R ,PS_GP_STRM S WHERE P.CAL_RUN_ID = R.CAL_RUN_ID AND R.PROCESS_STRM_IND = 'Y' AND P.EMPLID BETWEEN S.EMPLID_FROM AND S.EMPLID_TO AND S.STRM_NUM > 0 GROUP BY P.CAL_RUN_ID, S.STRM_NUM, P.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 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

3 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

4 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	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
3	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
4	GP_AGGR_COUNT	Number(9,1)	DECIMAL(8,1) NOT NULL	field used to present processing statistics