STRMPrompt Table: TERM_VAL_TBL
EMPLIDPrompt Table: PEOPLE_SRCH
Prompt Table: INSTITUTION_TBL
SSR_FCSCCL_SSVW(SQL View) |
Index Back |
|---|---|
Instructor Class ViewThe Instructor Class View contains by instructor ID and term all the sections that that instructor teaches for the specified term. |
| SELECT DISTINCT A.STRM ,A.EMPLID ,F.LAST_NAME_SRCH ,F.FIRST_NAME_SRCH ,F.NAME ,B.TERM_BEGIN_DT ,A.CRSE_ID ,D.SUBJECT ,D.CATALOG_NBR ,B.TERM_BEGIN_DT ,B.TERM_END_DT ,D.INSTITUTION ,G.DESCR ,B.DESCR ,E.DESCR FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CLASS_TBL D , PS_INSTITUTION_TBL E , PS_HCR_PERSON_NM_I F , PS_CRSE_CATALOG G WHERE A.CRSE_ID = D.CRSE_ID AND A.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND A.STRM = D.STRM AND A.SESSION_CODE = D.SESSION_CODE AND A.CLASS_SECTION = D.CLASS_SECTION AND D.INSTITUTION = B.INSTITUTION AND D.STRM = B.STRM AND D.ACAD_CAREER = B.ACAD_CAREER AND E.INSTITUTION = D.INSTITUTION AND %EffdtCheck(INSTITUTION_TBL E1, E, B.TERM_BEGIN_DT) AND E.EFF_STATUS = 'A' AND A.EMPLID = F.EMPLID AND G.CRSE_ID = D.CRSE_ID AND G.EFFDT = ( SELECT MAX(G1.EFFDT) FROM PS_CRSE_CATALOG G1 WHERE G1.CRSE_ID = G.CRSE_ID AND G1.EFFDT <= B.TERM_BEGIN_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 4 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 8 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 9 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 10 | TERM_BEGIN_DT | Date(10) | DATE | Term Begin Date |
| 11 | TERM_END_DT | Date(10) | DATE | Term Ending Date |
| 12 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | TERM_DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Term |
| 15 | INSTITUTION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Institution |