INSTITUTIONPrompt Table: INSTITUTION_TBL
SAD_UC_INSTSAD_UC_PCODE_VW(SQL View) |
Index Back |
|---|---|
Provider Code ViewProvider Code View |
| SELECT A.INSTITUTION, A.SAD_UC_INST, A.SAD_UC_INSTLNAME FROM PS_SAD_UC_INST A WHERE A.SAD_UC_ACRDINST = 'Y' OR EXISTS (SELECT 'X' FROM PS_SAD_UC_CONFIG B WHERE B.INSTITUTION = A.INSTITUTION AND B.SAD_UC_INST = A.SAD_UC_INST) |
| # | 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 | SAD_UC_INST |
Character(3) | VARCHAR2(3) NOT NULL | Provider Code |
| 3 | SAD_UC_INSTLNAME | Character(100) | VARCHAR2(100) NOT NULL | Institution Long Name |