INSTITUTIONPrompt Table: TERM_VAL_TBL
Prompt Table: TERM_VAL_TBL
SSR_APTSY_TRRVW(SQL View) |
Index Back |
|---|---|
APT Sync View of Term range |
| SELECT DISTINCT i.institution , CASE WHEN r.strm_from > ' ' THEN r.strm_from ELSE '0000' END AS strm_from , CASE WHEN r.strm_to > ' ' THEN r.strm_to ELSE '9999' END AS strm_to FROM ps_institution_tbl i LEFT OUTER JOIN PS_SSR_APT_SYN_TRM r ON i.institution = r.institution WHERE i.effdt = ( SELECT MAX(i2.effdt) FROM ps_institution_tbl i2 WHERE i2.institution = i.institution AND i2.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | STRM_FROM | Character(4) | VARCHAR2(4) NOT NULL |
From Term
Prompt Table: TERM_VAL_TBL |
| 3 | STRM_TO | Character(4) | VARCHAR2(4) NOT NULL |
To Term
Prompt Table: TERM_VAL_TBL |