EMPLIDSTRMTERM_PASTTRM_VW(SQL View) |
Index Back |
|---|---|
Past Term View |
| SELECT b.emplid , b.strm , a.term_begin_dt , b.acad_year FROM PS_STDNT_CAR_TERM b , ps_term_tbl a WHERE a.term_begin_dt <= %CurrentDateIn AND a.term_end_dt = ( SELECT MAX(c.term_end_dt) FROM ps_term_tbl c WHERE c.institution = a.institution AND c.acad_career = a.acad_career AND c.strm = a.strm) AND a.acad_career = b.billing_career AND a.institution = b.institution AND a.strm = b.strm |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 3 | TERM_BEGIN_DT | Date(10) | DATE | Term Begin Date |
| 4 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |