SAE_GRD_REQP_VW(SQL View) |
Index Back |
|---|
| SELECT A.INSTITUTION , A.STRM , A.CLASS_NBR FROM PS_CLASS_TBL A , PS_TERM_TBL B , PS_CLASS_ASSOC C WHERE A.STRM = B.STRM AND A.ACAD_CAREER = B.ACAD_CAREER AND A.INSTITUTION = B.INSTITUTION AND A.CRSE_ID = C.CRSE_ID AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND A.STRM = C.STRM AND A.SESSION_CODE = C.SESSION_CODE AND A.ASSOCIATED_CLASS = C.ASSOCIATED_CLASS AND A.SSR_COMPONENT = C.SSR_COMPONENT |
| # | 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 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |