INSTITUTIONSTRMSSR_APTSYM_TRVW(SQL View) |
Index Back |
|---|---|
APT Sync Search View for Term |
| SELECT DISTINCT t.institution , t.strm , te.descr FROM PS_SSR_APT_SYN_TRK t ,ps_term_val_tbl te WHERE te.strm = t.strm UNION SELECT DISTINCT r.institution , r.strm , te.descr FROM ps_ssr_aptsyrq_dtl r ,ps_term_val_tbl te WHERE te.strm = r.strm |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |