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.ENTITY_UID
ENTITY_UID,ADDRESS_TYPE,ADDRESS_START_DATE,ADDRESS_END_DATE,ADDRESS_STATUS_IND
ADDRESS_BY_RULE
Contains all addresses for an entity/person, institution, or organization per the display rules.One address per entity per address type per address number per address rule.ENTITY_UID
ENTITY_UID, ADDRESS_TYPE
ADDRESS_CURRENT
Contains all active addresses for an entity/person, institution, or organization.One address per entity per address type per address sequence number.ENTITY_UID
ENTITY_UID, ADDRESS_TYPE
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
ENTITY_UID, ADDRESS_TYPE
CALENDAR_DATE_HIERARCHY
Contains information about the calendar date.One row per 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.One row 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
DEGREE
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, CROSS_REFERENCE_RULE
ACTIVITY_DATE
CURRENT_EMPLOYMENT
Contains the person's current employement information.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 record per person_uid, per function_code and per event_identification.
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 CHARACTER and an institution defined internal code. Delivered sample internal code of INSTCHAR may be used or additional internal codes may be defined by the institution.One row per institution per calendar year.INSTITUTION
ACTIVITY_DATE
INTEREST
Contains any interests associated with a person.One row per person per interest.PERSON_UID, INTEREST
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 or RECRINTS 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.
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.
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.PERSON_UID, ACADEMIC_PERIOD, DISABILITY
DISABILITY
DISABILITY_SERVICES
MEDICAL_TYPE
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
ENTITY_UID, ADDRESS_TYPE
ORGANIZATION_ENTITY_ADDRESS
Contains information used to add a mailing address to a report or print a mailing label. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. All organizations and companies that are active will be selected for this reporting view.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 a mailing address to a report or print a mailing label. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. 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
Contains information pertaining to the race(s) of the person.One row per person.PERSON_UID
ACTIVITY_DATE
PERSON_VETERAN
Contains information on persons' who are veterans as indicated in the ERP system.One row per person.PERSON_UID
PREVIOUS_EDUCATION
Contains the data related to all secondary and post-secondary institutions a person has attended. 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 periodsOne row per entity per institution per attendance period
PREVIOUS_EDUCATION_SLOT
Uses data from the PREVIOUS_EDUCATION view, displays up to 3 sets of data pertaining to previous education in order of ascending degree date.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 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
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 systems' 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 visa's.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
FUNCTION
GEBFUNC
GERATTD
GERFCON
GOBINTL
GOREMAL
GORPGEO
GORPRAC
GORRACE
GORSGEO
GORVISA
GTVCELG
GTVCURR
GTVDICD
GTVEMAL
GTVEMPH
GTVFEES
GTVFSTA
GTVFUNC
GTVINSM
GTVLETR
GTVLFST
GTVMENU
GTVMTYP
GTVNTYP
GTVPURP
GTVRRAC
GTVRSVP
GTVSCHS
GTVSYSI
GURIDEN
GURMAIL
GXVBANK
GXVDIRD
MGRSDAX
MULTIPLE
NA


Ver: 8.0