Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ORGANIZATION_ENTITY

Description Contains all data that is common to organizations across administrative models and products. Also includes basic information about an entity, e.g., a third party paying a students charges, a company matching the gift of an alumnus, or a vendor supplying goods or services. The Organization table reflects only the most current data; it does not track changes.
Key & Frequency One row per entity.
Recommended Search Columns ENTITY_UID
ENTITY_UID, PHONE_TYPE
ENTITY_UID, ADDRESS_TYPE

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)

SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)

STVATYP

STVATYP_DESC

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)

SPRADDR

SPRADDR_CARRIER_ROUTE

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

SPRADDR

SPRADDR_CITY

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

SPRADDR

SPRADDR_CORRECTION_DIGIT

COUNTY County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_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

SPRADDR

SPRADDR_DELIVERY_POINT

EMAIL_ADDRESS Preferred email address. VARCHAR2(255)

GOREMAL

GOREMAL_EMAIL_ADDRESS

EMAIL_TYPE Type of email address recorded. VARCHAR2(63)

GOREMAL

GOREMAL_EMAL_CODE

EMAIL_TYPE_DESC Email address type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

SPRIDEN

SPRIDEN_PIDM

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

STVSTAT

STVSTAT_IPEDS_CDE

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

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

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

NA

NA

ID Organization's current identification number. VARCHAR2(9)

SPRIDEN

SPRIDEN_ID

ID2 A second identification number assigned to the organization. VARCHAR2(9)

NA

NA

ID3 A third identification number assigned to the organization. VARCHAR2(9)

NA

NA

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

NA

NA

MAILING_NAME_ORGANIZATION Mailing name of the organization. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

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

SPRIDEN

SPRIDEN_LAST_NAME

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

SPRADDR

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

STVNATN

STVNATN_EDI_EQUIV

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

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)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT

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

SPRTELE

SPRTELE_TELE_CODE

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

SPRTELE

SPRTELE_UNLIST_IND

POSTAL_CODE Address postal code. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

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

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

NA

NA

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

SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

TAX_ID Organization's identification assigned by their federal government for tax purposes. VARCHAR2(63)

NA

SPBPERS

NA

SPBPERS_SSN



Ver: 8.0