| Reporting View | Description | Key & Frequency | Recommended Search Columns |
| ACTIVITY
| Contains all of the activity and leadership combinations recorded for the person by the institution, including academic period related activities when the person was a student as well as subsequent activities stored for an alumnus of the institution.One row per person per activity and leadership role or per activity and academic period.| ENTITY_UID | | |
ADDRESS
| Contains all addresses for an entity, person, institution, or organization. Please note, these addresses may be active or inactive. When reporting using the ADDRESS reporting view check the ADDRESS_END_DATE and/or the ADDRESS_STATUS_IND, if the report requires an active address.One row per entity per address type per address number per address start date and address end date.ADDRESS_TYPE
ENTITY_UID, ADDRESS_TYPE, ADDRESS_START_DATE, ADDRESS_END_DATE, ADDRESS_STATUS_IND, PREFERRED_ADDRESS_IND | | |
ADDRESS_BY_RULE
| Contains an addresses for an entity/person, institution, or organization per the address hierarchy display rules defined as an ADDRESS_RULE that defines the hierarchy of address types to be used to select a single active address for a specified reporting purpose.One row per entity per address type per address number per address rule.ENTITY_UID, ADDRESS_TYPE, PREFERRED_ADDRESS_IND
ADDRESS_TYPE | | |
ADDRESS_CURRENT
| Contains all active addresses for an entity/person, institution, or organization.One row per entity per address type per address sequence number.ADDRESS_TYPE
ENTITY_UID, ADDRESS_TYPE, PREFERRED_ADDRESS_IND | | |
ADDRESS_PREFERRED
| Contains all preferred addresses and the associated primary active telephone data for an entity/person, institution, or organization.One row per entity per address type per address sequence number.ENTITY_UID, PHONE_TYPE, PHONE_SEQ_NUMBER
ENTITY_UID, PHONE_PRIMARY_IND, PHONE_SEQ_NUMBER
ADDRESS_TYPE
ENTITY_UID, ADDRESS_TYPE | | |
ALTERNATIVE_ID
| Contains alternative IDs for person or organization that may be used to cross reference Banner data with data from other internal or external systems.One row per entity per alternative ID. Per alternative ID type| ENTITY_UID, ALTERNATIVE_ID, ATERNATIVE_ID_TYPE | | |
CALENDAR_DATE_HIERARCHY
| Contains information about the calendar date.One row per calendar date.| CALENDAR_DATE | | |
CERTIFICATION
| Contains data related to a person's certifications.One row per person per certification.| PERSON_UID | | |
CERTIFICATION_SLOT
| Uses data from the CERTIFICATION view, displays up to 3 sets of data pertaining to certifications in order of ascending certification date.One row per person.PERSON_UID
ACTIVITY_DATE | | |
COMBINED_ACADEMIC_OUTCOME
| Contains an overall list of all the degrees, awards, certificates, etc for the person as awarded by this institution or through an external institution educational experience. These academic outcomes will not be duplicated for the person, institution, degree and major or program recorded on the individual records.Multiple rows per person per outcome_number.PERSON_UID, OUTCOME_NUMBER
STUDENT_LEVEL
ACADEMIC_PERIOD_GRADUATION
PROGRAM, MAJOR, PERSON_UID
COLLEGE, DEPARTMENT, PERSON_UID
PERSON_UID, INSTITUTION
PERSON_UID, INSTITUTION, DEGREE
DEGREE, PERSON_UID | | |
COMMUNICATION
| Contains all mailing/communication data for a person.One row per person per communication.PERSON_UID, ACADEMIC_PERIOD
SYSTEM, COMMUNICATION_SOURCE | | |
COMMUNICATION_SLOT
| Uses data from the COMMUNICATION reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of MAIL and a delivered or institution defined internal code. Delivered internal codes of RECRLETR (not like 'ALUM%') may be used independently by the institution.One row per person per profile code per communication rule.PERSON_UID, PROFILE_CODE, COMMUNICATION_RULE
ACTIVITY_DATE | | |
CONTACT
| Contains all of the contacts an inquirer has had with the institution.One row per person per contact type per contact date.PERSON_UID
CONTACT_TYPE, PERSON_UID | | |
CONTACT_SLOT
| Uses data from the CONTACT reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of CONTACTS and a delivered or institution defined internal code. Delivered internal codes of ADMSCTYP, RECRCTYP may be used independently by the institution.One row per person per profile code per contact rule.PERSON_UID, PROFILE_CODE, CONTACT_RULE
ACTIVITY_DATE | | |
CROSS_REFERENCE_SLOT
| Uses data from the RELATIONSHIP reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of CROSS REFERENCE and a delivered or institution defined internal code. Delivered internal codes of ALUMXREF may be used independently by the institution.One row per entity per profile code per cross reference rule.ENTITY_UID, PROFILE_CODE, CROSS_REFERENCE_RULE
ACTIVITY_DATE | | |
CURRENT_EMPLOYMENT
| Contains the person's current employment information collected either as an alumnus or as a employment applicant.One row per person per employer.PERSON_UID
EMPLOYER_UID | | |
EMPLOYMENT_HISTORY
| Contains data related to a person's employment history. This is employment experiences captured external to any position and jobs held at this institution. Data may include details for an employment applicant, for an alumnus or an admissions applicant.One row per person per employer.PERSON_UID
EMPLOYER_UID | | |
EVENT
| Contains all data for a scheduled event.One row per event. | | |
EVENT_INVITEE
| Contains records pertaining to invitees.One row per person_uid, per function_code and per event_identification.| EVENT_IDENTIFICATION, FUNCTION_CODE, INVITEE_UID | | |
GEOGRAPHIC_REGION
| Contains data about the geographic regions associated with the addresses of an entity.One row per entity per address type per address number per geographic region per geographic division.ENTITY_UID, ADDRESS_TYPE, GEOGRAPHIC_REGION, GEOGRAPHIC_DIVISION
GEOGRAPHIC_REGION
GEOGRAPHIC_DIVISION | | |
GEOGRAPHIC_REGION_INSTITUTION
| Contains the geographic regions and geographic divisions defined that are associated with the address of the background institution.One row per institution per geographic region per geographic division.INSTITUTION
GEOGRAPHIC_REGION
GEOGRAPHIC_DIVISION | | |
HOLD
| Contains all of the holds (restrictions) for a person or organization.One row per person/organization per hold per hold from date and hold to date.PERSON_UID, HOLD
HOLD | | |
HOLD_SLOT
| Uses data from the HOLD reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of HOLDS and a delivered or institution defined internal code. Delivered internal codes of (STDNHOLD or RESDHOLD or ARHOLD or GRDCHGHOLD) may be used independently by the institution.One row per person per profile code per hold rule.PERSON_UID, PROFILE_CODE, HOLD_RULE
ACTIVITY_DATE | | |
INSTITUTION
| Contains all data that is common to institutions across administrative models and products.One row per institution.| INSTITUTION | | |
INSTITUTION_CHARACTERISTIC
| Contains institution characteristics associated with the institution within a calendar year.One row per institution per calendar year per institution characteristic.INSTITUTION
CALENDAR_YEAR
INST_CHARACTERISTIC | | |
INSTITUTION_DEMOGRAPHIC
| Contains calendar year demographic data and statistical information associated with a background institution that may be used for reporting and comparing admission prospects and students.One row per institution per calendar year.INSTITUTION
CALENDAR_YEAR | | |
INST_CHARACTERISTIC_SLOT
| Uses data from the INSTITUTION_CHARACTERISTIC reporting view. Displays up to 10 sets of values based on the defined display rule(s) with an internal group of INST and a delivered or institution defined internal code. Delivered internal codes of COMMINST may be used independently by the institution.One row per institution per calendar year per profile code per characteristic rule.INSTITUTION, CALENDAR_YEAR, PROFILE_CODE, CHARACTERISTIC_RULE
ACTIVITY_DATE | | |
INTEREST
| Contains any interests associated with a person.One row per person per source per interest.PERSON_UID, INTEREST, SOURCE
INTEREST | | |
INTEREST_SLOT
| Uses data from the INTEREST reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of INTERESTS and a delivered or institution defined internal code. Delivered internal codes of ADMSINTS, RECRINTS, or ADVINTS may be used independently by the institution.One row per person per profile code per interest rule.PERSON_UID, PROFILE_CODE, INTEREST_RULE
ACTIVITY_DATE | | |
INTERNET_ADDRESS
| Contains all internet addresses for an entity; person or organization. These internet addresses may be active or inactive. When reporting using the INTERNET_ADDRESS reporting view check the INTERNET_ADDRESS_STATUS if the report requires active internet addresses.One row per entity per internet address type per internet address.ENTITY_UID, INTERNET_ADDRESS_TYPE, INTERNET_ADDRESS_STATUS
INTERNET_ADDRESS_TYPE, INTERNET_ADDRESS_STATUS | | |
INTERNET_ADDRESS_CURRENT
| Contains all active internet addresses for an entity; person or organization.One row per entity per internet address type per internet address.ENTITY_UID, INTERNET_ADDRESS_TYPE
INTERNET_ADDRESS_TYPE | | |
MAIL
| Contains information pertaining to mailings made to constituents or organizational constituents.One row per entity per mail.| ENTITY_UID | | |
MAIL_SLOT
| Uses data from the MAIL reporting view. Displays up to 4 sets of values based on the defined display rule(s) with an internal group of MAIL and a delivered or institution defined internal code. Delivered internal codes of (ALUMMAIL or like ALUM%) may be used independently by the institution.One row per entity per profile code per mail rule.ENTITY_UID, PROFILE_CODE, MAIL_RULE
ACTIVITY_DATE | | |
MEDICAL_INFORMATION
| Contains the detailed medical data for a person who has a disability.One row per person per disability.MEDICAL_TYPE
PERSON_UID, ACADEMIC_PERIOD, DISABILITY
DISABILITY
DISABILITY_SERVICES
PERSON_UID, MEDICAL_TYPE | | |
MEDICAL_INFORMATION_SLOT
| Uses data from the MEDICAL_INFORMATION reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of MEDICAL and a delivered or institution defined internal code. Delivered internal codes of STDNMEDI may be used independently by the institution.One row per person per profile code per medical rule.PERSON_UID, PROFILE_CODE, MEDICAL_RULE
ACTIVITY_DATE | | |
ORGANIZATION_ENTITY
| 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.One row per entity. ENTITY_UID
ENTITY_UID, PHONE_TYPE
ADDRESS_TYPE
ENTITY_UID, ADDRESS_TYPE | | |
ORGANIZATION_ENTITY_ADDRESS
| Contains information used to add an address to a report or print an address label using an institution defined selection hierarchy for the address types possible for the organization entity. All organizations and companies that are active will be selected for this reporting view unless they do not have any of the address types lised in the hierarchy will not have a record with that ADDRESS_RULE value.One row per entity per address rule.| ENTITY_UID | | |
PAST_EMPLOYMENT_SLOT
| Uses data from the EMPLOYMENT_HISTORY view, displays up to 4 sets of data pertaining to previous employers in order of descending start date.One row per person.PERSON_UID
ACTIVITY_DATE | | |
PERSON
| Contains demographic data common to a person across the ODS data model and the institution enterprise. The data is specific to a person independent of whether that person is a student, faculty member, or employee, alumnus, etc. Data reflects only the most current information; changes are not tracked in the ODS.One row per person.PERSON_UID
ADDRESS_TYPE
PHONE_TYPE | | |
PERSON_ADDRESS
| Contains information used to add an address to a report or print an address label using an institution defined selection hierarchy for the address types possible for the person. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. Persons that do not have any of the address types lised in the hierarchy will not have a record with that ADDRESS_RULE value.One row per person per address rule.| PERSON_UID | | |
PERSON_DETAIL
| Contains demographic data common to a person across the ODS data model and the institution enterprise. The data is specific to a person independent of whether that person is a student, faculty member, or employee, alumnus, etc. Data reflects only the most current information; changes are not tracked in the ODS.One row per person.| PERSON_UID | | |
PERSON_INTERNATIONAL
| Contains international student information, as well as information regarding their visa and passport as recorded in the ERP system.One row per person.| PERSON_UID | | |
PERSON_SENSITIVE
| Contains person data that is considered sensitive information that can be secured and accessed only by authorized staff.One row per person.| PERSON_UID | | |
PERSON_SENSITIVE_RACE
| Contains information pertaining to the race(s) of the person.One row per person per race. | | |
PERSON_SENSITIVE_RACE_SLOT
| Uses data from the PERSON_SENSITIVE_RACE view. Displays up to 5 sets of values based on the defined display rules(s) with an internal group of RACE and a delivered or institution defined internal code. Delivered internal codes of COMMRACE may be used independently by the institution. One row per person per profile code per race rule.PERSON_UID, PROFILE_CODE, RACE_RULE
ACTIVITY_DATE | | |
PERSON_VETERAN
| Contains information on persons who are veterans as indicated in the ERP system.One row per person.| PERSON_UID | | |
PREVIOUS_DEGREE
| Contains previous education degrees, majors, minors, concentration and other degree information. There will be multiple records for a person and institution if more than one degree was awarded or sought at that institution.One row per person per institution per degree.PERSON_UID, INSTITUTION, DEGREE
FIRST_MAJOR, DEGREE, PERSON_UID | | |
PREVIOUS_EDUCATION
| Contains the data related to all secondary and post-secondary institutions a person has attended. The data will be a single row per institution attended with the earliest start and latest end date if attended more than one time and the highest degree awarded or the latest degree sought. Use the PREVIOUS_DEGREE or PREVIOUS_EDUCATION_ATTENDANCE if you need to report all data recorded for this person and institution. This data will pull together data from multiple source database tables. This data may be used as admission criteria or when predicting success factors.One row per person per institution.PERSON_UID, INSTITUTION, POST_SECONDARY_DEGREE
POST_SECONDARY_MAJOR1, POST_SECONDARY_DEGREE, PERSON_UID | | |
PREVIOUS_EDUCATION_ATTENDANCE
| Contains all transfer records and their associated attendance periods. There will be multiple records for a person and institution if more than one attendance start and end was recorded.One row per entity per institution per attendance periodPERSON_UID, INSTITUTION, POST_SECONDARY_DEGREE
POST_SECONDARY_MAJOR1, POST_SECONDARY_DEGREE, PERSON_UID | | |
PREVIOUS_EDUCATION_SLOT
| Uses data from the PREVIOUS_EDUCATION view, displays up to 3 sets of data pertaining to previous education in order of descending Attendance To Date, then Transacript Received Date with nulls last.One row per person.PERSON_UID
ACTIVITY_DATE | | |
RELATIONSHIP
| Contains data that specifies the relationship between a person or organization and another person or organization.One row per entity per relation source or related cross reference per related entity.ENTITY_UID
ENTITY_UID,RELATED_UID
ENTITY_UID,RELATED_CROSS_REFERENCE
ENTITY_UID,MARRIAGE_STATUS_IND | | |
SALUTATION
| Contains all salutations.One row per person per salutation type.ENTITY_UID
ENTITY_UID, SALUTATION_TYPE | | |
SECONDARY_SCHOOL_SUBJECT
| Contains the data associated with the classes taken by pre-students in high school. Typically these classes are used when processing an application.One row per person per institution per subject.| PERSON_UID, INSTITUTION, SUBJECT | | |
SKILL
| Contains data related to a person's skills.One row per person per skill.| PERSON_UID | | |
SKILL_SLOT
| Uses data from the SKILL reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of SKIL and a delivered or institution defined internal code. Delivered internal codes of PAYRSKIL may be used independently by the institution.One row per person per profile code per skill rule.PERSON_UID, PROFILE_CODE, SKILL_RULE
ACTIVITY_DATE | | |
TELEPHONE
| Contains all telephone data for an entity/person, organization or institution.One row per entity per phone type per phone sequence number.ENTITY_UID
ENTITY_UID, PHONE_TYPE, PHONE_SEQ_NUMBER
ENTITY_UID, PHONE_PRIMARY_IND, PHONE_SEQ_NUMBER | | |
TELEPHONE_CURRENT
| Contains the most current active telephone by telephone type for an entity/person, institution, or organization.One row per entity per active phone type.ENTITY_UID, PHONE_TYPE, PHONE_SEQ_NUMBER
ENTITY_UID, PHONE_PRIMARY_IND, PHONE_SEQ_NUMBER | | |
TEST
| Contains data about test scores for a person.One row per person per test type per test date.PERSON_UID, TEST
TEST | | |
TEST_SLOT
| Uses data from the TEST reporting view. Displays up to 7 sets of values based on the defined display rule(s) with an internal group of TEST and a delivered or institution defined internal code. Delivered internal codes of (FAPLTEST or ADMSTEST or ACTC or SATM or SATV) may be used independently by the institution.One row per person per profile code per test rule.PERSON_UID, PROFILE_CODE, TEST_RULE
ACTIVITY_DATE | | |
VALIDATION
| This view contains a number of the source system's validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.Mulitple rows per table name, qualifier, value, status, effective date, and next change date.TABLE_NAME,VALUE
TABLE_NAME, QUALIFIER, VALUE | | |
VISA
| Contains information pertaining to visas.One row per person per visa type per visa number.| PERSON_UID | | |
VISA_CURRENT
| Contains current visa information.One row per person per visa type per visa number.| PERSON_UID | | |
YEAR_TYPE_DEFINITION
| Contains the necessary information that ties each academic/aid period to a type of reporting year. This allows reporting by a type of year and provides the institution with a year map.One row per year type per year code.YEAR_TYPE, YEAR_CODE, AID_PERIOD
YEAR_TYPE, YEAR_CODE, ACADEMIC_PERIOD
YEAR_TYPE, ACADEMIC_PERIOD, YEAR_CODE | | |