| Reporting View | Description | Key & Frequency | Recommended Search Columns |
| ACADEMIC_STUDY
|
ADDRESS_BY_RULE_MV
|
APRIGRP
| Personal Interest Group Table. | | |
ARGOS_STATS
| the statistics from Argos recording who ran what report when. | | |
CENCLS_COMBO
|
CIP_AREA
|
CONSTITUENT_ENTITY_MV
|
CONSTITUENT_MV
| PRIMARY_DONOR_CATEGORY
PERSON_UID
PREF_COLLEGE
LOST_ALUMNUS_IND
PRIMARY_DONOR_CATEGORY, LOST_ALUMNUS_IND
| | |
CURRMAJ
|
C_CONSTITUENT_ENTITY
| Freeze event table. Contains entire constituent population; i.e. persons and organizations. General information includes name details, primary contact for organizations, preferred address, telephone, birth date and deceased indicator, as applicable. All data in the view is caputured during the freeze event | | |
C_CONSTITUENT_ENTITY_MV
| Freeze event table. Contains entire constituent population; i.e. persons and organizations.
General information includes name details, primary contact for organizations, preferred address,
telephone, birth date and deceased indicator, as applicable. All data in the view is caputured during the freeze event. Related_UID, Spouse_Decease_Ind, Spouse_Name, and Spouse_ID are included | | |
DELAWARE_COST_FINAL
|
GENERAL_STUDENT
|
GOBTPAC
|
IPEDS_COURSE
|
IPEDS_DEMOGRAPHIC
|
LOV_CURRMAJ
|
LOV_GREEK_ORGANIZATION
|
MAJOR_BY_DEPT
|
MV_CAPABILITIES_TABLE
|
MV_REFRESH
| records the materialized view in beardata and the type of refresh done. | | |
PATH_TABLE
|
PERSONNEL_DESCRIPTORS
|
PHOENIX_STUDENTS
|
PTRCALN
| Payroll Calendar Rule Table | | |
RPRCIPC
| SMART Grant Qualified Course Code Table | | |
SGBUSER
| Student Institutional Reporting Requirements Table | | |
SGRSACT
| Student Activity Repeating Table | | |
SORTEST
| Student Test Score Repeating Table | | |
SP_SU_09_RSH
|
STUDENT_COURSE_MV
| FINAL_GRADE, ACADEMIC_PERIOD
PERSON_UID, COURSE_REFERENCE_NUMBER
ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD
PERSON_UID
COURSE_IDENTIFICATION
REPEAT_COURSE_IND
PERSON_UID, COURSE_IDENTIFICATION
REGISTRATION_STATUS, ACADEMIC_PERIOD
| | |
STUDENT_FREEZE_AUXILIARY
|
ZGRVETN
| Student attribute code for student veterans. | | |
Z_ADDRESS_BY_RULE
|
Z_ADMISSIONS_COUNSELOR
| List of admissions counselors and their region. | | |
Z_ADMISSIONS_HS_BY_REGION
| List of admissions high schools by region. | | |
Z_ADMISSIONS_REGION
| List of admissions regions. | | |
Z_ADVISOR_SLOT
| Modified version, orginal view did not include ADVISOR_UID or ADVISOR_ID.Uses data from the ADVISOR reporting view. Displays up to 2 sets of values based on the person advisor relationship and academic period. Currently there are no associated display rules. | | |
Z_ADVLETTER
|
Z_ADV_GIFT_RECEIPT
| Table to hold Advancement gift receipts before processing | | |
Z_ALUM_HARRIS_OLC_SYNC
| Temp table. Updated daily with pidms of alumi records that have been modified that day. | | |
Z_ARGOS_USER_MESSAGE
|
Z_BANNER_MODULES
| Contains the Banner modules and their descriptions. | | |
Z_CENCLS
| 4TH WEEK CENSUS - SUMMARY OF HOURS FOR EACH STUDENT FOR PREVIOUS SEMESTERS | | |
Z_CENSTDTS
| 4TH WEEK CENSUS - CURRENT AND APPLIED STUDENTS | | |
Z_CIPXREF
|
Z_COMPLETIONS_SLOT
| Contains all university granted degrees for a student; excluding certificates. One row per person_uid. Degrees awarded are displayed in slots and ordered by first received, level, and primary program indicator. | | |
Z_CONSTITUENT_ENTITY
|
Z_CONSTITUENT_ENTITY_MV
|
Z_CONSTITUENT_ENTITY_MV2
| ENTITY_UID
ENTITY_UID, ENTITY_IND, DECEASED_IND
ENTITY_UID, DECEASED_IND
ENTITY_IND, DECEASED_IND
ENTITY_IND
RELATED_UID
RELATED_UID, DECEASED_IND
| | |
Z_COUNTY_CODES
|
Z_CUPA_RAW
| Table contains raw data from the CUPA survey. This information should be imported by institutional research yearly after the Survey Results(contact Megan Schiller). | | |
Z_CURRENT_EMPLOYMENT
| Contains the persons current employement information. | | |
Z_DEGREES_GRANTED
|
Z_DEGREE_SLOT_OLD_TO_NEW
|
Z_DEGREE_SORT
|
Z_EDW_EVENTS
| List of EDW events that have or will be ran for a specific date. | | |
Z_EDW_EVENTS_RAN
|
Z_EDW_STAR_TYPE
| This table contains the EDW star names and their type whether operational or snapshot. | | |
Z_EMERGENCY_CONTACT
| Emergency Contact Repeating Table created from PROD.SATURN.SPREMRG | | |
Z_EXEMPTION_TOTALS_BY_TERM
|
Z_FISCAL_YR_TO_TERM
| Converts fiscal years into terms. | | |
Z_FTVFSYR
| Fiscal Year Validation Table | | |
Z_GEO_ORIGIN
|
Z_GEO_ORIGIN_MV
| PIDM
| | |
Z_GIFT_MV
| ENTITY_UID, DESG_VSE
FISCAL_YEAR, DECEASED_STATUS
GIFT_NUMBER
FISCAL_YEAR
GIFT_DATE
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, CAMPAIGN, DESIGNATION
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, CAMPAIGN
PLEDGE_NUMBER, ENTITY_UID, GIFT_NUMBER, CAMPAIGN
ENTRY_DATE
ENTITY_UID, GIFT_NUMBER
| | |
Z_GPA_CUTOFF_TABLE
|
Z_GRADSTUB
| Legacy graduated students | | |
Z_GRANT_CONTRACT_ACTIVITY
|
Z_GRANT_LEDGER
|
Z_HOUSEHOLD_GIVING
| Table give a person and there spouse life_total_giving. | | |
Z_KPI_CATEGORIES
| List of categories not in Banner. | | |
Z_KPI_DASHBOARD
| : Main Table loads KPI dashboard directly. This table is populated by the Z_KPI_DASHBOARD_PKG. | | |
Z_KPI_GROUPS
| Table provides desciptions for KPI dashboard groups. | | |
Z_KPI_KPIS
| This table provides header and description text to the KPI dashboard | | |
Z_KPI_MEASURES
|
Z_KPI_SUB_DATA
| This table contains data inputted by appropriate users usually the Office of Institutional Research. The reason for this table is to report information that we are currently not able to query in the ODSPROD database. It also contains KPI Targets and Trending Information. | | |
Z_LATE_DROPS
|
Z_LOV_ACADEMIC_PCT_RANGE
| Validation table for Admissions academic percentile ranges | | |
Z_LOV_ACT_RANGE
| Validation table for Admissions ACT ranges | | |
Z_LOV_AGE_RANGE
| Validation table for Admissions age range. | | |
Z_LOV_AID_YEAR_TO_TERM
| Conversion of Aid Year to Academic Periods. | | |
Z_LOV_FISCAL_YEAR
| List of values for fiscal year including begin date, end date. | | |
Z_LOV_FREEZE_EVENT
| Validation table for all freeze events. | | |
Z_LOV_GENDER
|
Z_LOV_GPA_RANGE
| Validation table Gender values | | |
Z_LOV_GRE_RANGE
| Validation table for Admissions GRE ranges | | |
Z_LOV_RACE_ETHNICITY
| Validation table for Admissions race/ethnicity. | | |
Z_LOV_STUDENT_POPULATION
| Validation table for Student Population as defined by Missouri State University. | | |
Z_LOV_YEAR_CONVERSION
| Converts years types to terms. | | |
Z_MAJOR_GPA
|
Z_MFVGRL1_MV
|
Z_MGT_ADDRESS_SLOT
|
Z_MO_COUNTY_REGION
|
Z_MST_TEST_SLOT_LATEST
|
Z_MSVHIERPHONE
|
Z_ODS_REFRESHES
| List of nightly refreshes ran on ODS | | |
Z_OIR_HR_CENSUS
| Contains OIR-generated roster of personnel captures in HR Census and reported to IPEDS. One row per person per year. | | |
Z_OPERATING_LEDGER
|
Z_OTC_ENROLLMENT
| OTC Enrollment for Cross-Enrollment Reporting | | |
Z_PAY_GRADE
|
Z_PHOENIX_GEO
| Phoenix geograhical origin at time of admission. | | |
Z_PIDMS_AMOUNT
|
Z_PIDMS_COUNT
|
Z_PIDMS_MAGZ
|
Z_PII_LVL_ONE
|
Z_PRAXIS_SCORES
| American Teacher Certification exam scores for student at Missouri State. | | |
Z_PRAXIS_SUB_SCORES
|
Z_PTRECLS
| Employee Class Rule Table | | |
Z_PTVJCTY
| Job Change Type Table | | |
Z_REG_RELS_INFO
|
Z_RETENTION
|
Z_SABSUPL
| Application Supplemental Information Base Table | | |
Z_SGRDSER
| Student Disability Service Support Table | | |
Z_SORBTAG
| Transfer Articulation General Data | | |
Z_SPRCMNT
| Person Comments Repeating Table | | |
Z_SSBXLST
| Cross List Enrollment Information Base Table | | |
Z_SSRXLST
| Cross List Section Repeating Table | | |
Z_STUDENT_COURSE
|
Z_STUDENT_GOBTPAC
| List of Student BearPass_ID, Name, BearPass_Login information | | |
Z_STVSSER
| Student Services Code Validation Table | | |
Z_STVTERM
| Term Code Validation Table | | |
Z_STVTESC
| Test Score Validation Table | | |
Z_TELEPHONE_BY_RULE
|
Z_TOP_COLLEGE
|
Z_TOTAL_ENROLLMENT_5_YEARS
|
Z_Z_CENCLS
|