Description
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_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_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. | | |