INSTITUTIONPrompt Table: INSTITUTION_TBL
LANGUAGE_CDSAA_IN_SET_FLLN(SQL View) |
Index Back |
|---|---|
Rel Lang for SAA_IN_SET_FLVWRelated Language for SAA_IN_SET_FLVW |
| SELECT S.INSTITUTION , L.LANGUAGE_CD , L.DESCR FROM PS_SAA_IN_SETUP_FL S , PS_INSTITUTION_TBL I , PS_INSTITUTION_LNG L WHERE I.INSTITUTION = S.INSTITUTION AND I.EFFDT = ( SELECT MAX(I2.EFFDT) FROM PS_INSTITUTION_TBL I2 WHERE I2.INSTITUTION = I.INSTITUTION AND I2.EFFDT <= S.EFFDT) AND I.EFF_STATUS = 'A' AND L.INSTITUTION = I.INSTITUTION AND L.EFFDT = I.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |