Reporting View Target: INSTITUTION

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: INSTITUTION

Description Contains all data that is common to institutions across administrative models and products.
Key & Frequency One row per institution.
Recommended Search Columns INSTITUTION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADDRESS_COUNT Address Count Count of current active addresses for this person or entity. NUMBER
FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

ADDRESS_TYPE Address Type Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
NA

NA

ADDRESS_TYPE_DESC Address Type Description Address type description. VARCHAR2(255)
NA

NA

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CARRIER_ROUTE Carrier Route Address carrier route. VARCHAR2(4)
NA

NA

CITY City Address city, town or municipality. VARCHAR2(63)
SOBSBGI

SOBSBGI_CITY

CONTACT_NAME Contact Name Name of the contact at the source/background institution. VARCHAR2(255)
SORBCNT

SORBCNT_NAME

CONTACT_PHONE_NUMBER_COMBINED Contact Phone Number Combined Complete telephone number recorded for the background institution (secondary or post secondary institution) contact person. VARCHAR2(63)
CALCULATION

SORBCNT_PHONE_AREA||SORBCNT_PHONE_NUMBER||SORBCNT_PHONE_EXT

CONTACT_POSITION_DESC Contact Position Description Source contact person type description (for example, high school principal, guidance counselor, dean of college, etc.) associated with the contact person type code. VARCHAR2(255)
STVPTYP

STVPTYP_DESC

CONTACT_POSITION_TYPE Contact Position Type Position held by contact person at the source/background institution. VARCHAR2(63)
SORBCNT

SORBCNT_PTYP_CODE

CORRECTION_DIGIT Correction Digit Correction digit associated with the address for bar code mailing. NUMBER
NA

NA

COUNTY County County for this address. VARCHAR2(63)
SOBSBGI

SOBSBGI_CNTY_CODE

COUNTY_DESC County Description County name for the address. VARCHAR2(255)
STVCNTY

STVCNTY_DESC

DELIVERY_POINT Delivery Point Delivery point associated with the address for barcode mailings. NUMBER
NA

NA

EDI_CAPABLE Edi Capable Indicates whether the institution is capable of receiving electronic data transfer and receipt of transcripts. VARCHAR2(1)
STVSBGI

STVSBGI_EDI_CAPABLE

EMAIL_ADDRESS Email Address Preferred email address. VARCHAR2(63)
NA

NA

EMAIL_TYPE Email Type Type of email address recorded. VARCHAR2(63)
NA

NA

EMAIL_TYPE_DESC Email Type Description Email address type description. VARCHAR2(255)
NA

NA

ENRL_PLANNING_SERVICE Enrl Planning Service Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research. VARCHAR2(63)
FUNCTION

F_EPSCCODE

ENRL_PLANNING_SERVICE_CODE Enrl Planning Service Code Enrollment planning service description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

FEDERAL_REPORTING_CODE Federal Reporting Code Government determined code for the reporting state/province codes. VARCHAR2(63)
STVSTAT

STVSTAT_IPEDS_CDE

FICE_CODE Fice Code Institution FICE code assigned for electronic data transfer or EDI. VARCHAR2(63)
STVSBGI

STVSBGI_FICE

GEOGRAPHIC_REGION_COUNT Geographic Region Count Count of geographic regions associated with an address record. NUMBER
FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

INSTITUTION Institution Source/background institution code. VARCHAR2(63)
SOBSBGI

SOBSBGI_SBGI_CODE

INSTITUTION_TYPE Institution Type Identifies a type for the source/background institution to be used for reporting. VARCHAR2(63)
STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC Institution Type Description Institution type description. VARCHAR2(255)
CALCULATION

DECODE(STVSBGI_TYPE_IND,'C','COLLEGE','H','HIGHSCHOOL','S','SOURCE-ONLY',NULL)

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Name Source/background institution name. VARCHAR2(63)
STVSBGI

STVSBGI_DESC

NATION Nation Nation/country code of the institution's preferred address. VARCHAR2(63)
SOBSBGI

SOBSBGI_NATN_CODE

NATION_DESC Nation Description Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

NATION_EDI_EQUIVALENT Nation Edi Equivalent EDI equivalent code used for electronic transfer of country information. This might be used on transcripts for the person, vendor invoice, etc. VARCHAR2(63)
STVNATN

STVNATN_EDI_EQUIV

NATION_ISO_CODE Nation ISO Code Three character International Standards Organization (ISO) Code associated with the nation code. VARCHAR2(63)
STVNATN

STVNATN_SCOD_CODE_ISO

PHONE_COUNT Phone Count Count of phone records. NUMBER
FUNCTION

MSKFUNC.F_COUNT_TELEPHONES

PHONE_DESC Phone Description Telephone number type description. VARCHAR2(255)
STVTELE

STVTELE_DESC

PHONE_NUMBER_COMBINED Phone Number Combined All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension. VARCHAR2(63)
NA

NA

PHONE_TYPE Phone Type Telephone type code associated with the institution's preferred telephone number. VARCHAR2(63)
NA

NA

PHONE_UNLIST_IND Phone Unlist Indicator Specifies if the phone number is to be unlisted. VARCHAR2(1)
NA

NA

POSTAL_CODE Postal Code Postal code of the institution's preferred address. VARCHAR2(63)
SOBSBGI

SOBSBGI_ZIP

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

SOURCE_IND Source Indicator Indicates whether the secondary or post secondary institution may be recorded as a recruiting or applicant source. VARCHAR2(1)
STVSBGI

STVSBGI_SRCE_IND

STATE_EDI_EQUIVALENT State Edi Equivalent EDI equivalent code used for electronic transfer of state or province information. This might be used on transcripts for the person, vendor invoice, etc. VARCHAR2(63)
STVSTAT

STVSTAT_EDI_EQUIV

STATE_PROVINCE State Province State or province associated with this address. VARCHAR2(63)
SOBSBGI

SOBSBGI_STAT_CODE

STATE_PROVINCE_DESC State Province Description State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(255)
SOBSBGI

SOBSBGI_STREET_LINE1

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(255)
SOBSBGI

SOBSBGI_STREET_LINE2

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(255)
SOBSBGI

SOBSBGI_STREET_LINE3

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Contains all data that is common to institutions across administrative models and products.
Key & Frequency	One row per institution.
Recommended Search Columns	INSTITUTION

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_COUNT	Address Count	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADDRESS_TYPE	Address Type	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	NA	NA
ADDRESS_TYPE_DESC	Address Type Description	Address type description.	VARCHAR2(255)	NA	NA
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CARRIER_ROUTE	Carrier Route	Address carrier route.	VARCHAR2(4)	NA	NA
CITY	City	Address city, town or municipality.	VARCHAR2(63)	SOBSBGI	SOBSBGI_CITY
CONTACT_NAME	Contact Name	Name of the contact at the source/background institution.	VARCHAR2(255)	SORBCNT	SORBCNT_NAME
CONTACT_PHONE_NUMBER_COMBINED	Contact Phone Number Combined	Complete telephone number recorded for the background institution (secondary or post secondary institution) contact person.	VARCHAR2(63)	CALCULATION	SORBCNT_PHONE_AREA\|\|SORBCNT_PHONE_NUMBER\|\|SORBCNT_PHONE_EXT
CONTACT_POSITION_DESC	Contact Position Description	Source contact person type description (for example, high school principal, guidance counselor, dean of college, etc.) associated with the contact person type code.	VARCHAR2(255)	STVPTYP	STVPTYP_DESC
CONTACT_POSITION_TYPE	Contact Position Type	Position held by contact person at the source/background institution.	VARCHAR2(63)	SORBCNT	SORBCNT_PTYP_CODE
CORRECTION_DIGIT	Correction Digit	Correction digit associated with the address for bar code mailing.	NUMBER	NA	NA
COUNTY	County	County for this address.	VARCHAR2(63)	SOBSBGI	SOBSBGI_CNTY_CODE
COUNTY_DESC	County Description	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
DELIVERY_POINT	Delivery Point	Delivery point associated with the address for barcode mailings.	NUMBER	NA	NA
EDI_CAPABLE	Edi Capable	Indicates whether the institution is capable of receiving electronic data transfer and receipt of transcripts.	VARCHAR2(1)	STVSBGI	STVSBGI_EDI_CAPABLE
EMAIL_ADDRESS	Email Address	Preferred email address.	VARCHAR2(63)	NA	NA
EMAIL_TYPE	Email Type	Type of email address recorded.	VARCHAR2(63)	NA	NA
EMAIL_TYPE_DESC	Email Type Description	Email address type description.	VARCHAR2(255)	NA	NA
ENRL_PLANNING_SERVICE	Enrl Planning Service	Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research.	VARCHAR2(63)	FUNCTION	F_EPSCCODE
ENRL_PLANNING_SERVICE_CODE	Enrl Planning Service Code	Enrollment planning service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
FEDERAL_REPORTING_CODE	Federal Reporting Code	Government determined code for the reporting state/province codes.	VARCHAR2(63)	STVSTAT	STVSTAT_IPEDS_CDE
FICE_CODE	Fice Code	Institution FICE code assigned for electronic data transfer or EDI.	VARCHAR2(63)	STVSBGI	STVSBGI_FICE
GEOGRAPHIC_REGION_COUNT	Geographic Region Count	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
INSTITUTION	Institution	Source/background institution code.	VARCHAR2(63)	SOBSBGI	SOBSBGI_SBGI_CODE
INSTITUTION_TYPE	Institution Type	Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(63)	STVSBGI	STVSBGI_TYPE_IND
INSTITUTION_TYPE_DESC	Institution Type Description	Institution type description.	VARCHAR2(255)	CALCULATION	DECODE(STVSBGI_TYPE_IND,'C','COLLEGE','H','HIGHSCHOOL','S','SOURCE-ONLY',NULL)
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Source/background institution name.	VARCHAR2(63)	STVSBGI	STVSBGI_DESC
NATION	Nation	Nation/country code of the institution's preferred address.	VARCHAR2(63)	SOBSBGI	SOBSBGI_NATN_CODE
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_EDI_EQUIVALENT	Nation Edi Equivalent	EDI equivalent code used for electronic transfer of country information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(63)	STVNATN	STVNATN_EDI_EQUIV
NATION_ISO_CODE	Nation ISO Code	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(63)	STVNATN	STVNATN_SCOD_CODE_ISO
PHONE_COUNT	Phone Count	Count of phone records.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES
PHONE_DESC	Phone Description	Telephone number type description.	VARCHAR2(255)	STVTELE	STVTELE_DESC
PHONE_NUMBER_COMBINED	Phone Number Combined	All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.	VARCHAR2(63)	NA	NA
PHONE_TYPE	Phone Type	Telephone type code associated with the institution's preferred telephone number.	VARCHAR2(63)	NA	NA
PHONE_UNLIST_IND	Phone Unlist Indicator	Specifies if the phone number is to be unlisted.	VARCHAR2(1)	NA	NA
POSTAL_CODE	Postal Code	Postal code of the institution's preferred address.	VARCHAR2(63)	SOBSBGI	SOBSBGI_ZIP
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SOURCE_IND	Source Indicator	Indicates whether the secondary or post secondary institution may be recorded as a recruiting or applicant source.	VARCHAR2(1)	STVSBGI	STVSBGI_SRCE_IND
STATE_EDI_EQUIVALENT	State Edi Equivalent	EDI equivalent code used for electronic transfer of state or province information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(63)	STVSTAT	STVSTAT_EDI_EQUIV
STATE_PROVINCE	State Province	State or province associated with this address.	VARCHAR2(63)	SOBSBGI	SOBSBGI_STAT_CODE
STATE_PROVINCE_DESC	State Province Description	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)	SOBSBGI	SOBSBGI_STREET_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)	SOBSBGI	SOBSBGI_STREET_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)	SOBSBGI	SOBSBGI_STREET_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)	NA	NA