GP_RUN_STRM1_VW

(SQL View)
Index Back

Calendar Run Stream View

Used to display Calendar Run ID Statistics.

SELECT R.CAL_RUN_ID ,R.STRM_NUM ,S.EMPLID_FROM ,S.EMPLID_TO FROM PS_GP_CAL_RUN_STRM R , PS_GP_STRM S WHERE R.STRM_NUM = S.STRM_NUM

# 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 EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL EMPLID (first for a range)
4 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL EmplID To