SSR_CLSCAP_TMVW

(SQL View)
Index Back

Class Tbl, Mtg, & Fac View


SELECT distinct institution , strm FROM PS_TERM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 STRM Character(4) VARCHAR2(4) NOT NULL Term

Default Value: OPR_DEF_TBL_CS.STRM

Prompt Table: TERM_VAL_TBL