Created by Corina C Larsen, last modified by Miki Yanagi on May 12, 2022
The tables below are used across all functional areas using Student Data which includes Financial Aid, Admissions and Enrollment. Click on the table to see the fields used.
- ACAD_LEVEL_TBL - Academic Level Table
- ACAD_ORG_TBL - Academic Organization Table
- ACAD_PLAN - Student Academic Plan Table
- ACAD_PLAN_TBL - Academic Plan Table
- ACAD_PROG - Student Academic Program
- ACAD_PROG_TBL - Academic Program Table
- ACAD_SUBPLAN - Student Academic Subplan Table
- ACAD_SUBPLN_TBL - Academic Sub Plan Table
- ADDRESSES - Address Type
- ADDRESS_TYP_TBL - Address Type Table
- ADM_APPL_CMP - Adm Application Componet
- ADM_APPL_DATA - Admission Application Data
- ADM_APPL_PROG - Admission Applicant Program
- ADM_APPL_VW - Adm Application View
- CIP_CODE_TBL - CIP Codes
- CLASS_ATTRIBUTE - Class Attribute Table
- CLASS_INSTR - Class Instructor Table
- CLASS_MTG_PAT - Class Meeting Pattern Table
- CLASS_TBL - Class Table
- CLASS_TBL_SE_VW- Class Table Student Enrl View
- CRSE_ATTR_TBL - Course Print Attribute Table
- CRSE_ATTR_VALUE - Course Attribute Value Tbl
- CRSE_CATALOG - Course Catalog Data
- CRSE_OFFER - Course Catalog Offerings
- DEGREE_TBL
- DIVERS_ETHNIC - Ethnic Diversity
- ETHNIC_GRP_TBL - Ethnic Group Table
- ETHNICITY_DTL - Ethnicity Detail
- EXT_ORG_TBL_ADM - External Org Admissions
- EXT_DEGREE - External Degrees
- FACILITY_TBL - Facility Table
- ISIR_COMPUTED - Computed Data from INAS/DOE
- ISIR_CONTROL - ISIR Internals/Control Data
- ISIR_PARENT - Fed Parent Application Data
- ISIR_STUDENT - Fed Student Application Data
- ITEM_LINE_SF
- ITEM_SF - Item Record
- ITEM_TYPE_FA - FA Item Type Table
- ITEM_TYPE_FA_VW - Item Type Search Record for FA
- LOCATION_TBL - Company Site Locations
- PERSON_NAME - Current Primary Name View (CS)
- PERSONAL_DATA - PERSONAL_DATA for Rpting
- PERSONAL_DTSAVW - SA Personal Data View
- RELATION_VW - Relationships View
- RELATIONSHIPS - Relationships
- RESIDENCY_OFF - Official Residency Data
- RL_STDNT_ROOM - ResLife - Student Room Assignm
- SA_TCMP_REL_TBL - Test Component Relationships
- SCC_CITIZEN_QVW - Citizenship Query View & CITIZENSHIP - EE/Dependent Citizenship
- SCC_EMAIL_QVW - Email Address Query View & EMAIL_ADDRESSES - Email Addresses
- SCC_PERDATA_QVW - PERSONAL_DATA Query View
- SCC_PERS_BIOG - Gender ID Record
- SCC_PERS_PH_QVW- Phone Numbers Query View
- SF_ACCTG_LN - SF Accounting Line
- STDNT_AWARDS - Student Awards
- STDNT_AWD_PER - Student Award PeriodTable
- STDNT_AWRD_ACTV - Student Award Activity
- STDNT_AWRD_DISB - Student Award Disbursements
- STDNT_CAR_TERM - Student Career Term Table
- STDNT_ENRL - Student Enrollment Table
- STDNT_EQUTN_VAR - Student Equation Variables
- STDNT_GROUP_TBL - Student Group TBL
- STDNT_GRPS - Student Groups
- STDNT_GRPS_HIST - Student Groups History
- STDNT_TEST_COMP - Student Test Components
- SUBJECT_TBL - Subject Table
- TERM_TBL - Term Definition Table
- TERM_VAL_TBL - Term Value Table
- TRNS_OTHR_DTL - Student Other Credit Detail
- UM_AGGR_LOAN_VW
- UM_APPL_EXT_VW - Applicant Reporting Extract
- UM_APPL_EXTRACT - Applicant Reporting Extract
- UM_CLSS_SCH_FCL - Class Schedule and Facility Vw
- UM_CNS_RPT_VW
- UM_COHORT_TBL - Student Cohort
- UM_D_APPL_PG_VW - Admission Applicant Program
- UM_DEGREES_COMP
- UM_DLY_RPT_VW
- UM_D_MIN_TERMS
- UM_D_STD_ENR_VW - Student Enrollment Table
- UM_FERPA_VW
- UM_FGLALLJOB_VW
- UM_FGLEMPL_ACVW
- UM_FGLEMPLOY_VW - Human Resources employee data flat file (CS)
- UM_FIN_AID
- UM_FIN_AID_DTVW
- UM_FLAT_ADVISOR
- UM_FLAT_CMPT_VW
- UM_FLAT_PRGPLAN
- UM_FLT_PRGPLN
- UM_GRAD_APPL_HD
- UM_GRAD_APPL_VW - Student Acad Prog Prompt Vw
- UM_HOME_INST_VW
- UM_ITYP_FA_VW - FA view of Item Types
- UM_LOCATION_DTL - Distance Education Locations
- UM_NAMES_PRF_VW
- UM_NAMES_VW - Person Names Query View
- UM_NEBHE_SETUP
- UM_NEBHE_STATE
- UM_NEBHE_ST_TBL
- UM_ORIG_ADDR_VW
- UM_PRAXCUR_DTL
- UM_PRGPLAN_CENS & UM_PRGPLAN_STRM
- UM_RETENTION_FS
- UM_SAT_CONCORD
- UM_SFA_VA_BENES - SFA VA Benefits Certification
- UM_STD_ENR_CENS - Student Course Census Table
- UM_STD_ENR_C_VW - Student Enrollment Table
- UM_STDNT_COHORT - Student Cohort
- UM_STUD_CENSUS - Student Reporting Extract Arch
- UM_STUD_CENS_VW - Student Reporting Extract
- UM_STUD_EXTRACT - Student Reporting Extract
- UM_STUD_EXT_ARC - Student Reporting Extract Arch
- UM_STUD_EXT_VW - Student Reporting Extract
- UM_TEST_SCORE_V
- UM_TRIBE_TBL - UM Tribe Table
- Financial Aid Tables
- Recommended Tables for Reporting in CS
- Retention related tables and views
- UM_RETENT_FS_IN - Non continuous Fall & Spring
You may also be interested in
Recommended Tables for Reporting in CS
Click the link above for a listing of the most frequently used tables