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

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 Definition Database Data Type Source Name Source Column Local Source Local Target
ADDRESS_COUNT Count of current active addresses for this person or entity. NUMBER

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

NO

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

NA

NA

NO

NO
ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)

NA

NA

NO

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

NA

NA

NO

NO
CARRIER_ROUTE Address carrier route. VARCHAR2(4)

NA

NA

NO

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

SOBSBGI

SOBSBGI_CITY

NO

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

SORBCNT

SORBCNT_NAME

NO

NO
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

NO

NO
CONTACT_POSITION_DESC 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

NO

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

SORBCNT

SORBCNT_PTYP_CODE

NO

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

NA

NA

NO

NO
COUNTY County for this address. VARCHAR2(63)

SOBSBGI

SOBSBGI_CNTY_CODE

NO

NO
COUNTY_DESC County name for the address. VARCHAR2(255)

STVCNTY

STVCNTY_DESC

NO

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

NA

NA

NO

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

STVSBGI

STVSBGI_EDI_CAPABLE

NO

NO
EMAIL_ADDRESS Preferred email address. VARCHAR2(63)

NA

NA

NO

NO
EMAIL_TYPE Type of email address recorded. VARCHAR2(63)

NA

NA

NO

NO
EMAIL_TYPE_DESC Email address type description. VARCHAR2(255)

NA

NA

NO

NO
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

NO

NO
ENRL_PLANNING_SERVICE_CODE Enrollment planning service description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
FEDERAL_REPORTING_CODE Government determined code for the reporting state/province codes. VARCHAR2(63)

STVSTAT

STVSTAT_IPEDS_CDE

NO

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

STVSBGI

STVSBGI_FICE

NO

NO
GEOGRAPHIC_REGION_COUNT Count of geographic regions associated with an address record. NUMBER

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

NO

NO
INSTITUTION Source/background institution code. VARCHAR2(63)

SOBSBGI

SOBSBGI_SBGI_CODE

NO

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

STVSBGI

STVSBGI_TYPE_IND

NO

NO
INSTITUTION_TYPE_DESC Institution type description. VARCHAR2(255)

CALCULATION

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

NO

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

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NAME Source/background institution name. VARCHAR2(63)

STVSBGI

STVSBGI_DESC

NO

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

SOBSBGI

SOBSBGI_NATN_CODE

NO

NO
NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

NO

NO
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

NO

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

STVNATN

STVNATN_SCOD_CODE_ISO

NO

NO
PHONE_COUNT Count of phone records. NUMBER

FUNCTION

MSKFUNC.F_COUNT_TELEPHONES

NO

NO
PHONE_DESC Telephone number type description. VARCHAR2(255)

STVTELE

STVTELE_DESC

NO

NO
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

NO

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

NA

NA

NO

NO
PHONE_UNLIST_IND Specifies if the phone number is to be unlisted. VARCHAR2(1)

NA

NA

NO

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

SOBSBGI

SOBSBGI_ZIP

NO

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

NA

NA

NO

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

STVSBGI

STVSBGI_SRCE_IND

NO

NO
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

NO

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

SOBSBGI

SOBSBGI_STAT_CODE

NO

NO
STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
STREET_LINE1 First line of the address. VARCHAR2(255)

SOBSBGI

SOBSBGI_STREET_LINE1

NO

NO
STREET_LINE2 Second line of the address. VARCHAR2(255)

SOBSBGI

SOBSBGI_STREET_LINE2

NO

NO
STREET_LINE3 Third line of the address. VARCHAR2(255)

SOBSBGI

SOBSBGI_STREET_LINE3

NO

NO
STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

NO

NO


Ver: 9.2