EMPLIDTERM_FUTTERM_VW(SQL View) |
Index Back |
|---|---|
Future Term View |
| select b.emplid, a.strm, a.term_begin_dt, a.acad_year from PS_STDNT_CAR_TERM b, ps_term_tbl a where a.term_begin_dt = (select max(c.term_begin_dt) from ps_term_tbl c where c.institution = a.institution and c.acad_career = b.acad_career and c.strm = a.strm) and a.term_end_dt >= %currentdatein 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 |