EXT_ORG_IDPrompt Table: EXT_ORG_TBL
SAD_UC_SCHSRCVW(SQL View) |
Index Back |
|---|
| SELECT ext_org_id , sad_uc_school , sad_uc_schoolname , sad_uc_schooltype , sad_uc_country FROM %Table(SAD_UC_SCHOOL) WHERE sad_uc_school <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | SAD_UC_SCHOOL | Character(10) | VARCHAR2(10) NOT NULL | UCAS School |
| 3 | SAD_UC_SCHOOLNAME | Character(100) | VARCHAR2(100) NOT NULL | School Name |
| 4 | SAD_UC_SCHOOLTYPE | Character(12) | VARCHAR2(12) NOT NULL | School Type |
| 5 | SAD_UC_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country Code |