RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Common Reporting View Reports

SGHE 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
ADDRESS_COUNT Count of current active addresses for this person or entity. NUMBER

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

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. VARCHAR2(255)

NA

NA

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

NA

NA

CARRIER_ROUTE Address carrier route. VARCHAR2(4)

NA

NA

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

SOBSBGI

SOBSBGI_CITY

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

SORBCNT

SORBCNT_NAME

CONTACT_PHONE_NUMBER_COMBINED Complete telephone number recorded for the background institution (secondary or post secondary institution) contact person. VARCHAR2(14)

CALCULATION

SORBCNT_PHONE_AREA||SORBCNT_PHONE_NUMBER||SORBCNT_PHONE_EXT

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)

FUNCTION

GOKODSF.F_GET_DESC

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

SORBCNT

SORBCNT_PTYP_CODE

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

NA

NA

COUNTY County for this address. VARCHAR2(63)

SOBSBGI

SOBSBGI_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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 Preferred email address. VARCHAR2(63)

NA

NA

EMAIL_TYPE Type of email address recorded. VARCHAR2(63)

NA

NA

EMAIL_TYPE_DESC Email address type description. VARCHAR2(255)

NA

NA

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 Enrollment planning service description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVSTAT

STVSTAT_IPEDS_CDE

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

STVSBGI

STVSBGI_FICE

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

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

INSTITUTION Source/background institution code. VARCHAR2(63)

SOBSBGI

SOBSBGI_SBGI_CODE

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. VARCHAR2(255)

CALCULATION

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

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

NA

NA

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

NA

NA

NAME Source/background institution name. VARCHAR2(63)

STVSBGI

STVSBGI_DESC

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

SOBSBGI

SOBSBGI_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

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 Three character International Standards Organization (ISO) Code associated with the nation code. VARCHAR2(63)

STVNATN

STVNATN_SCOD_CODE_ISO

PHONE_COUNT Count of phone records. NUMBER

FUNCTION

MSKFUNC.F_COUNT_TELEPHONES

PHONE_DESC Telephone number type description. VARCHAR2(255)

STVTELE

STVTELE_DESC

PHONE_NUMBER_COMBINED All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension. VARCHAR2(14)

NA

NA

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

NA

NA

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

NA

NA

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

SOBSBGI

SOBSBGI_ZIP

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

NA

NA

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

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 or province associated with this address. VARCHAR2(63)

SOBSBGI

SOBSBGI_STAT_CODE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(63)

SOBSBGI

SOBSBGI_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(63)

SOBSBGI

SOBSBGI_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(63)

SOBSBGI

SOBSBGI_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(63)

NA

NA



Ver: 3.1