Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_ORGANIZATION_ENTITY

Description Source composite view contains all data that is common to organizations 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

ALTERNATIVE_ID_COUNT Count of the number of alternative IDs recorded for this person or organization entity. NUMBER

GORADID

GORADID_ADDITIONAL_ID

CARRIER_ROUTE Address carrier route. VARCHAR2(0)

NA

NA

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

NA

NA

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

NA

NA

COUNTY County for this address. VARCHAR2(0)

NA

NA

COUNTY_DESC County name for the address. VARCHAR2(0)

NA

NA

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

EMAIL_ADDRESS Preferred email address. VARCHAR2(128)

GOREMAL

GOREMAL_EMAIL_ADDRESS

EMAIL_TYPE Type of email address recorded. VARCHAR2(4)

GOREMAL

GOREMAL_EMAL_CODE

EMAIL_TYPE_DESC Email address type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ENTITY_ACTIVITY_DATE Date record was inserted or updated. DATE

SPRIDEN

SPRIDEN_ACTIVITY_DATE

ENTITY_CREATE_DATA_ORIGIN Source process or system that created this record. VARCHAR2(30)

SPRIDEN

SPRIDEN_DATA_ORIGIN

ENTITY_CREATE_DATE Date that this record was created, either manually or through data load. DATE

SPRIDEN

SPRIDEN_CREATE_DATE

ENTITY_CREATE_USER ID of the person who created this record. VARCHAR2(30)

SPRIDEN

SPRIDEN_CREATE_USER

ENTITY_ORIGIN Source process or system that created or updated this record. VARCHAR2(30)

SPRIDEN

SPRIDEN_ORIGIN

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

SPRIDEN

SPRIDEN_PIDM

ENTITY_UPDATE_USER User who made the last updated to this record. VARCHAR2(30)

SPRIDEN

SPRIDEN_USER

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

NA

NA

EPS_DESC Enrollment planning service description. VARCHAR2(0)

NA

NA

GOVERNMENT_ID Identification assigned by the institution's home government when the tax id is from a different government. VARCHAR2(0)

NA

NA

ID_NUMBER Identification number assigned to the organization that is used externally for all communication. VARCHAR2(9)

SPRIDEN

SPRIDEN_ID

ID_NUMBER2 A second identification number assigned to the organization. VARCHAR2(0)

NA

NA

ID_NUMBER3 A third identification number assigned to the organization. VARCHAR2(0)

NA

NA

ID_SOURCE Name of the source system that provided the value in the ID_NUMBER field. VARCHAR2(0)

NA

NA

MAILING_NAME_ORGANIZATION Preferred name of the organization for mailing purposes. VARCHAR2(60)

SPRIDEN

SPRIDEN_LAST_NAME

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 Name of the organization. VARCHAR2(60)

SPRIDEN

SPRIDEN_LAST_NAME

NATION Nation/country code associated with the address. VARCHAR2(0)

NA

NA

NATION_DESC Address nation/country description. VARCHAR2(0)

NA

NA

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

NA

NA

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

NA

NA

PHONE_DESC Organization's preferred phone type description. VARCHAR2(0)

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

POSTAL_CODE Address postal code. VARCHAR2(0)

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

STATE_PROVINCE_DESC State/province name. VARCHAR2(0)

NA

NA

STREET_LINE1 First line of the address. VARCHAR2(0)

NA

NA

STREET_LINE2 Second line of the address. VARCHAR2(0)

NA

NA

STREET_LINE3 Third line of the address. VARCHAR2(0)

NA

NA

STREET_LINE4 Fourth line of the address. VARCHAR2(0)

NA

NA

TAX_ID Person's tax identification number assigned by their home federal government. VARCHAR2(15)

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: