GP_SEGXSTRM2_VW (SQL View)	Index Back
Segs by stream and seg status Calendar Statistics Aggregate view use to display PYE_CALC_STAT total.

GP_SEGXSTRM2_VW

(SQL View)

Segs by stream and seg status

Calendar Statistics Aggregate view use to display PYE_CALC_STAT total.

SELECT A.CAL_RUN_ID , B.STRM_NUM , A.SEG_STATUS , COUNT(*) FROM PS_GP_PYE_SEG_STAT A , PS_GP_CAL_RUN R , PS_GP_STRM B WHERE A.CAL_RUN_ID = R.CAL_RUN_ID AND R.PROCESS_STRM_IND = 'Y' AND A.EMPLID BETWEEN B.EMPLID_FROM AND B.EMPLID_TO AND B.STRM_NUM > 0 GROUP BY A.cal_run_id, B.STRM_NUM, A.SEG_STATUS

# 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 SEG_STATUS Character(2) VARCHAR2(2) NOT NULL Segment Status
00=Active in Segment
01=Inactive in Segment

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	SEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Segment Status 00=Active in Segment 01=Inactive in Segment
4	GP_AGGR_COUNT	Number(9,1)	DECIMAL(8,1) NOT NULL	field used to present processing statistics