GP_TLSTRM_VW (SQL View)	Index Back
View of GP_STRM Consider using the GP STRM table directly as prompt view instead of this view

GP_TLSTRM_VW

Consider using the GP STRM table directly as prompt view instead of this view

SELECT DISTINCT A.STRM_NUM FROM PS_GP_STRM A WHERE A.STRM_NUM > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number