EMPLIDSRC_CAREERSRC_INSTITUTIONSRC_TERMSRC_CLASS_NBRLANGUAGE_CDSTDNT_ENR2_TCLN(SQL View) |
Index Back |
|---|---|
Student Enrl Prompt for TCView used by the Transfer Credit module to get enrollment data from the STDNT_ENRL that is being transferred internally. It renames most of the key fields to differentiate them from the transfer destination fields. |
| SELECT a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.STRM , a.CLASS_NBR , d.LANGUAGE_CD , c.DESCRSHORT , d.DESCR FROM PS_STDNT_ENRL a , PS_CLASS_TBL b , PS_TERM_TBL_LANG c , PS_CLASS_TBL_LANG d WHERE a.INSTITUTION = b.INSTITUTION AND a.STRM = b.STRM AND a.CLASS_NBR = b.CLASS_NBR AND a.STRM = c.STRM AND a.ACAD_CAREER = c.ACAD_CAREER AND b.CRSE_ID = d.CRSE_ID AND b.CRSE_OFFER_NBR = d.CRSE_OFFER_NBR AND b.STRM = d.STRM AND b.SESSION_CODE = d.SESSION_CODE AND b.CLASS_SECTION = d.CLASS_SECTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SRC_CAREER |
Character(4) | VARCHAR2(4) NOT NULL | Source Career |
| 3 | SRC_INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Source Institution |
| 4 | SRC_TERM |
Character(4) | VARCHAR2(4) NOT NULL | Source Term |
| 5 | SRC_CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Source Class |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |