Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST


Common Reporting View Meta Data Reports

Target Reports:

Reporting ViewDescriptionKey & FrequencyRecommended 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 typeENTITY_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

Source Reports:

CALCULATION
CONSTANT
EXPRESSION
FTOBDLGT
FTTVAFFL
FTTVCURR
FTTVTLOC
FUNCTION
GEBFUNC
GERATTD
GERFCON
GOBEACC
GOBINTL
GORADID
GOREMAL
GORPGEO
GORPRAC
GORRACE
GORSGEO
GORVISA
GTVADID
GTVCELG
GTVCURR
GTVDICD
GTVEMAL
GTVEMPH
GTVFEES
GTVFSTA
GTVFUNC
GTVINSM
GTVLETR
GTVLFST
GTVMENU
GTVMTYP
GTVNTYP
GTVPURP
GTVRRAC
GTVRSVP
GTVSCHS
GTVSUBJ
GTVSYSI
GURIDEN
GURMAIL
GXVBANK
GXVDIRD
MGRSDAX
MGT_VALIDATION
MULTIPLE
NA
SORINTS
SPRADDR


Ver: 8.5