INSTITUTIONSTRMSUBJECTLANGUAGE_CDSSR_SRCHSUBJ_VL(SQL View) |
Index Back |
|---|---|
Rel Lang Adv Search SubjectsRelated Language for List of Subjects for Fluid SR Class Search Advanced Search |
| SELECT DISTINCT A.INSTITUTION , A.STRM , A.SUBJECT , BL.LANGUAGE_CD , BL.DESCRFORMAL FROM PS_CLASS_TBL A , PS_SUBJECT_TBL_LNG BL , PS_TERM_TBL C WHERE C.INSTITUTION = A.INSTITUTION AND C.ACAD_CAREER = A.ACAD_CAREER AND C.STRM = A.STRM AND BL.SUBJECT = A.SUBJECT AND BL.INSTITUTION = A.INSTITUTION AND BL.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_SUBJECT_TBL_LNG B2 WHERE B2.INSTITUTION = BL.INSTITUTION AND B2.SUBJECT = BL.SUBJECT AND B2.LANGUAGE_CD = BL.LANGUAGE_CD AND B2.EFFDT <= C.TERM_BEGIN_DT) |
| # | 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 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field |