SAD_UC_SCHTYPMP

(SQL Table)
Index Back

School Type Mapping

# 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_SCHTYPVW

3 PROPRIETORSHIP Character(4) VARCHAR2(4) NOT NULL Proprietorship
OTHR=Other
PRIV=Private
PUBL=Public
RELG=Religious
4 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

Prompt Table: SCC_ORG_TYP_TBL

5 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

Prompt Table: LS_SCHL_TYP_TBL

6 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time