EMPLIDINSTITUTIONPrompt Table: INSTITUTION_TBL
SSR_APT_INSTANCESSR_ITEM_IDLANGUAGE_CDSSR_APTAIR_HVWL(SQL View) |
Index Back |
|---|
| SELECT DISTINCT APT.EMPLID , AIR.INSTITUTION , APT.SSR_APT_INSTANCE , AIR.SSR_ITEM_ID , LN.LANGUAGE_CD , LN.DESCR50 FROM PS_SSR_AIR_HDR AIR , PS_SSR_APT_HDR APT , PS_TERM_TBL TERM , PS_SSR_AIR_HDR_LN LN WHERE TERM.INSTITUTION = APT.INSTITUTION AND TERM.ACAD_CAREER = APT.ACAD_CAREER AND TERM.STRM = APT.REQ_TERM AND AIR.INSTITUTION = APT.INSTITUTION AND AIR.INSTITUTION = LN.INSTITUTION AND AIR.SSR_ITEM_ID = LN.SSR_ITEM_ID AND AIR.EFFDT = LN.EFFDT AND AIR.EFFDT = ( SELECT MAX(AIR2.EFFDT) FROM PS_SSR_AIR_HDR AIR2 WHERE AIR2.INSTITUTION = AIR.INSTITUTION AND AIR2.SSR_ITEM_ID = AIR.SSR_ITEM_ID AND AIR2.EFFDT <= TERM.TERM_BEGIN_DT) AND AIR.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | SSR_APT_INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Academic Progress Tracker Instance Number |
| 4 | SSR_ITEM_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |