GP_SEGXSTRM1_VW

(SQL View)
Index Back

Segs by stream and calc stat

Calendar Statistics Aggregate view use to display PYE_CALC_STAT total.

SELECT A.CAL_RUN_ID , B.STRM_NUM , A.PYE_CALC_STAT , 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.PYE_CALC_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 PYE_CALC_STAT Character(2) VARCHAR2(2) NOT NULL Calculation Status: field indicates the processing status of a segment (payment)
00=Identified
02=Calculation Error
03=Calculation Error - Bypassed
04=Calculation Error - By Rule
11=No Segment Created
50=Calculation Successful
55=Frozen For Further Calc
70=Finalized
75=Finalized - With Banking
4 GP_AGGR_COUNT Number(7,0) INTEGER NOT NULL field used to present processing statistics