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


Common Composite View Meta Data Reports

Target Reports:

Composite ViewDescription
AA_INTEREST
Source composite view contains any general interests associated with the person.One row per person per interest.
AA_MAIL
Source composite view detailing all mailings a person or organization should receive and to what address type the mailing should be sent.
AA_PREVIOUS_EMPLOYMENT
Source composite view contains prior employment information for any person as stored in the advancement system.
AA_RELATIONSHIP
Source composite view contains all of the persons and organizations that have a relationship to another person or organization stored within the system, such as employers, spouses and children.
AA_SALUTATION
Source composite view contains all salutations associated with a person or organization.
AG_ALTERNATIVE_ID
Source composite view contains non Banner alternative IDs used to support cross reference of the Banner ID to another system identification. These may be other government IDs or alternative agency identification assigned to the person.One row per entity per alternative ID. Per alternative ID type
AG_COMMUNICATION
Source composite view contains person mailing/communication information.
AG_EVENT
Source composite view contains the data for a scheduled event being tracked in the system.
AG_EVENT_INVITEE
Contains records pertaining to invitees.
AG_GEOGRAPHIC_REGION
Source composite view contains the geographic regions for person addresses.
AG_GEOGRAPHIC_REGION_INST
Source composite view contains source institution and the geographic regions and geographic divisions associated with the institution.
AG_INTERNET_ADDRESS
Contains all internet addresses for an entity; person or organization. These internet addresses may be active or inactive.
AG_SDE_DATA
Source composite view contains the supplemental data in the system.
AG_VALIDATION
Source composite 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.
AP_PAST_EMPLOYMENT
Source composite view contains prior employment information for an employee or person applying for a position at the institution.
AP_SKILL
Source composite view contains skill information for an employee or person applying for a position at the institution.
AR_YEAR_TYPE_DEFINITION
Source composite view contains the year types and codes as well as what aid and academic periods are associated with each.
AS_ADDRESS
Source composite view contains all address information ether it is current or inactive for the person or organization entity.
AS_CONTACT
Source composite view contains all of the contacts made with a person and the institution.
AS_DISABILITY_INFORMATION
Contains the detailed medical data for a person who has a disability for each academic period.
AS_HOLD
Source composite view contains all active holds or restrictions to processing added to a student at the institution.
AS_INSTITUTION
Source composite view contains all data that is common to institutions across administrative models and products. It reflects only the most current data - it does not track changes.
AS_INSTITUTION_CHARACTERISTIC
Source composite view contains all institution characteristics associated within a calendar year to an institution.
AS_INSTITUTION_DEMOGRAPHIC
Source composite view contains the source background institution with associated demographic data.
AS_INTEREST
Source composite view contains any interests associated with the person.
AS_MEDICAL_INFORMATION
Source composite view contains the detail medical information for a person who has a recorded disability.
AS_ORGANIZATION_ENTITY
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.
AS_PERSON
Source composite view contains demographic data that is common to persons across administrative models and products. It reflects only the most current data - it does not track changes.
AS_PREVIOUS_DEGREE
Contains previous education degrees, majors, minors, concentration and other degree information.One row per person per institution per degree.
AS_PREVIOUS_EDUCATION_HSCH
Source composite view contains the information on secondary institutions the person attended.
AS_PREVIOUS_EDUCATION_PCOL
Source composite view contains information on post secondary institutions the person attended.
AS_RACE
Contains information pertaining to the race(s) of the person.One row per person per race.
AS_SECONDARY_SCHOOL_SUBJECT
Source composite view contains the data pertaining to classes taken by pre-students in secondary school.
AS_TELEPHONE
Source composite view contains all telephone data for the person or entity. Includes both active and inactive telephone details.
AS_TEST
Source composite view contains all person test scores recorded with in the institution ERP system.
AS_VISA
Source composite view contains data from the visa and international student data in the source system.
AS_YEAR_TYPE_DEFINITION
Source composite view contains the year types and codes as well as what aid and academic periods are associated with each.

Source Reports:

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


Ver: