INSTITUTIONSSR_ITEM_IDSUBJECTSSR_CG_SUBJ_VW(SQL View) |
Index Back |
|---|---|
Course Group Subject View |
| SELECT GRP.INSTITUTION , GRP.SSR_ITEM_ID , DTL.SUBJECT FROM PS_SSR_CRS_GRP_DTL DTL , PS_SSR_AIR_H_CGRP GRP WHERE DTL.INSTITUTION = GRP.INSTITUTION AND %EffdtCheck(SSR_AIR_H_CGRP GRP_ED, GRP, %CurrentDateIn) AND DTL.SSR_CRS_GRP_ID = GRP.SSR_CRS_GRP_ID AND %EffdtCheck(SSR_CRS_GRP_DTL DTL_ED, DTL, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_ITEM_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |
| 3 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL | Subject Area |