Penn Computing

University of Pennsylvania
Penn Computing << go backback
V_INSTITUTION Table . Pennant Student Records Home . Data Warehouse Home

V_INSTITUTION Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Activity_Date

Indexed - no
Format - Date
May be Null? Y

Last date the record was entered or updated in the source. Source field: STVSBGI_ACTIVITY_DATE

Custom_Id

Indexed - yes
Format - Number
May be Null? Y

Custom ID. Source field: UP_ST_UP_S_BANNER_LONG_DESC.ID

Institution_Code

Indexed - yes
Format - Varchar2(6)
May be Null? Y

Code for the high school, college, university, or other academic institution. Source field: STVSBGI_CODE.

Institution_Desc

Indexed - no
Format - Varchar2(30)
May be Null? Y

Descriptive text title of the Institution code. Source field: STBSBGI_DESC.

Institution_Desc_Long

Indexed - no
Format - Varchar2(150)
May be Null? Y

Custom long descriptive text of the institution code. Source: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC

Institution_Source

Indexed - no
Format - Varchar2(1)
May be Null? Y

Source field: STVSBGI_SRCE_IND

Institution_Type

Indexed - no
Format - Varchar2(1)
May be Null? Y

Source field: STVSBGI_TYPE_IND

Inst_Addr_City

Indexed - no
Format - Varchar2(50)
May be Null? Y

The city of the source institutions address. Source field: SOBSBGI_CITY.

Inst_Addr_Cy

Indexed - no
Format - Varchar2(5)
May be Null? Y

The US county code of the source institutions address. May be null, as county information is not generally collected. Source field: SOBSBGI_CNTY_CODE.

Inst_Addr_Line1

Indexed - no
Format - Varchar2(75)
May be Null? Y

The first line of the source institutions address. Source field: SOBSBGI_STREET_LINE1

Inst_Addr_Line2

Indexed - no
Format - Varchar2(75)
May be Null? Y

The second line of the source institutions address. Source field: SOBSBGI_STREET_LINE2

Inst_Addr_Line3

Indexed - no
Format - Varchar2(75)
May be Null? Y

The third line of the source institutions address. Source field: SOBSBGI_STREET_LINE3

Inst_Addr_Line4

Indexed - no
Format - Varchar2(75)
May be Null? Y

The fourth line of the source institutions address. Source field: SOBSBGI_STREET_LINE4

Inst_Addr_Nation

Indexed - no
Format - Varchar2(5)
May be Null? Y

The country (nation) code of the source institutions address. Source field: SOBSBGI_NATN_CODE.

Inst_Addr_State

Indexed - no
Format - Varchar2(3)
May be Null? Y

The state code of the source instituions address. Source field: SOBSBGI_STAT_CODE.

Inst_Addr_Zip

Indexed - no
Format - Varchar2(60)
May be Null? Y

The postal code of the source institutions address. Source field: SOBSBGI_ZIP

Long_Desc_End_Term

Indexed - no
Format - Varchar2(6)
May be Null? Y

The latest term the long description for the code is in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.END_TERM

Long_Desc_Start_Term

Indexed - no
Format - Varchar2(6)
May be Null? Y

The earliest term the long description for the code was in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.START_TERM.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date this table in the warehouse was last refreshed.

V_Institution_Pk

Indexed - yes
Format - Varchar2(70)
May be Null? N

Internal warehouse primary key; Concatenation of the Institution_code, long_desc_start_term, and the custom_id.

V_INSTITUTION Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania