RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_INSTITUTION

Description Source composite view contains all data that is common to institutions across administrative models and products. It reflects only the most current data - it does not track changes.

Target Column Business Definition Database Data Type Source Name Source Column
ADDRESS_DESC Address type description. VARCHAR2(0)

NA

NA

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

NA

NA

CARRIER_ROUTE Address carrier route. VARCHAR2(0)

NA

NA

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

SOBSBGI

SOBSBGI_CITY

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

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(30)

FUNCTION

GOKODSF.F_GET_DESC

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

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(5)

SOBSBGI

SOBSBGI_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

NA

NA

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

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(0)

NA

NA

EMAIL_TYPE Type of email address recorded. VARCHAR2(0)

NA

NA

EMAIL_TYPE_DESC Email address type description. VARCHAR2(0)

NA

NA

EPS_CODE Enrollment planning service (EPS) marketing code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only). VARCHAR2(6)

FUNCTION

F_EPSCCODE

EPS_DESC Enrollment planning service description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

STVSBGI

STVSBGI_FICE

INSTITUTION Source/background institution code. VARCHAR2(6)

SOBSBGI

SOBSBGI_SBGI_CODE

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

STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC Description of the source/background institution type that identifies secondary schools, post secondary institutions and sources for prospects and applicants. VARCHAR2(30)

CALCULATION

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

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

NA

NA

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

NA

NA

NAME Source/background institution name. VARCHAR2(30)

STVSBGI

STVSBGI_DESC

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

SOBSBGI

SOBSBGI_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(30)

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(2)

STVNATN

STVNATN_EDI_EQUIV

NATION_SCOD_CODE_ISO International Standards Organization (ISO) Code associated with the nation code. VARCHAR2(3)

STVNATN

STVNATN_SCOD_CODE_ISO

PHONE_DESC Telephone number type description. VARCHAR2(0)

STVTELE

STVTELE_DESC

PHONE_NUMBER_COMBINED Preferred telephone number of the institution. VARCHAR2(0)

NA

NA

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

NA

NA

PHONE_UNLIST_IND Indicator that specifies if the phone number is to be unlisted. VARCHAR2(0)

NA

NA

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

SOBSBGI

SOBSBGI_ZIP

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(2)

STVSTAT

STVSTAT_EDI_EQUIV

STATE_IPEDS_CODE Identifies the state or province code for federal reporting. VARCHAR2(5)

STVSTAT

STVSTAT_IPEDS_CDE

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

SOBSBGI

SOBSBGI_STAT_CODE

STATE_PROVINCE_DESC State/province name. VARCHAR2(30)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(30)

SOBSBGI

SOBSBGI_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(30)

SOBSBGI

SOBSBGI_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(30)

SOBSBGI

SOBSBGI_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(0)

NA

NA

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

NA

NA



Ver: 3.1