SAD_UC_SCHTMPVW(SQL View) |
Index Back |
|---|---|
Search for School Type Mapping |
| SELECT A.institution , A.sad_uc_schooltype , B.SAD_UC_SCHOOLTEXT , A.EXT_ORG_TYPE , A.PROPRIETORSHIP , A.LS_SCHOOL_TYPE , A.EXT_CAREER FROM %Table(SAD_UC_SCHTYPMP) A , %Table(SAD_UC_SCHTYP) B WHERE A.SAD_UC_SCHOOLTYPE = B.SAD_UC_SCHOOLTYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | SAD_UC_SCHOOLTYPE |
Character(12) | VARCHAR2(12) NOT NULL |
UCAS School Type
Prompt Table: SAD_UC_SCHTYP |
| 3 | SAD_UC_SCHOOLTEXT | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 4 | EXT_ORG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Organization Type
Prompt Table: SCC_ORG_TYP_TBL |
| 5 | PROPRIETORSHIP | Character(4) | VARCHAR2(4) NOT NULL |
Proprietorship
OTHR=Other PRIV=Private PUBL=Public RELG=Religious |
| 6 | LS_SCHOOL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
School Type
Prompt Table: LS_SCHL_TYP_TBL |
| 7 | EXT_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
External Career
GRAD=Graduate HS=High School LAW=Law MED=Medical UGRD=Undergraduate |