Description
AS_ACADEMIC_HISTORY_EVENT
| Contains data pertaining to a student's academic history events.One row per person | | |
AS_ACADEMIC_OUTCOME
| Source composite view contains information associated with each academic outcome tracked by the institution. Information is displayed as one row per outcome award, degree or certificate, etc. | | |
AS_ACADEMIC_STANDING
| Source composite view contains any academic status values assigned to a student for the term in which they were assigned. | | |
AS_ACTIVE_TERMS
| Source composite view contains all students and the terms in which they have activity. This includes academic periods with a new base student record, enrollment activity, academic history, transfer activity, graduation, a cohort entry, sports participation, student attributes, student activities, student work experience, financial aid application or awards, and accounts receivable detail or student contracts. | | |
AS_ADMINISTRATOR
| Source composite view contains information about all the persons who will rate admission applicants. | | |
AS_ADMISSIONS_APPLICATION
| Source composite view contains information specific to each different application submitted by the applicant. | | |
AS_ADMISSIONS_ATTRIBUTE
| Source composite view contains information that identifies special characteristics associated with the applicant for tracking and special reporting. | | |
AS_ADMISSIONS_COHORT
| Source composite view contains information that identifies the applicant with a particular group for tracking and reporting purposes. | | |
AS_ADMISSIONS_DECISION
| Source composite view contains all of the admissions decisions recorded for each admission application. | | |
AS_ADMISSIONS_RATING
| Source composite view contains all administrator ratings recorded for the applicant as a part of the admission evaluation processing. | | |
AS_ADMISSIONS_REQUIREMENT
| Source composite view contains all application requirements for each application and whether or not the document or process has been completed for this application. | | |
AS_ADMISSIONS_SOURCE
| Source composite view contains information that identifies the reason or source responsible for the applicant submitting the admission application. | | |
AS_ADVISOR
| Source composite view contains all current advisors associated with a student. | | |
AS_COURSE_ATTRIBUTE
| Source composite view contains all of the course degree attributes associated with the course catalog entry for the academic period. | | |
AS_COURSE_CATALOG
| Source composite view contains all of the informational details recorded for the subject or course at a specific time frame or academic period. | | |
AS_COURSE_COREQ
| Source composite view contains all of the course catalog entries that are required to be taken in the same academic period as the key subject or course. | | |
AS_COURSE_LEVEL
| Source composite view contains all of the levels for which credit can be earned for this subject or course. Included may be undergraduate, graduate, post graduate, etc. | | |
AS_COURSE_OFFERING
| Source composite view contains all sections or schedule offerings for a specific academic period. | | |
AS_COURSE_OFFERING_FEES
| Source composite view contains all of the fees that will be charged when a student registers for this section. This may include a flat fee for the section or an amount charge per each credit registered for this course.One record per academic term per detail code per fee assessment type per level code. | | |
AS_COURSE_PREREQ
| Source composite view contains all of the course catalog entries that are required to be taken in a prior academic period as the key subject or course. | | |
AS_COURSE_SCHEDULE
| Source composite view contains all of the instructional or delivery methods approved for this course or subject. | | |
AS_COURSE_SUPPLEMENTAL
| Source composite view contains additional information about the course that may have the specific purpose to accommodate reporting requirements of the institution. | | |
AS_CURRICULUM
| Source composite view contains all active, inactive, current, and and non-current curricula for all students identified in recruiting, admissions, student and academic outcome. | | |
AS_CURRICULUM_FOS
| Source composite view contains all active and current curricula for all students identified in recruiting, admissions, and academic outcome as well as all active and current fields of study for Major, Minor, and Concentrations. | | |
AS_ENROLLMENT
| Source composite view contains the academic period based fields needed to support the creation of the Student and Academic Study reporting views. | | |
AS_ENROLLMENT_HISTORY
| Source composite view contains the academic period based fields needed to support the creation of the Student and Academic Study reporting views. | | |
AS_FACULTY
| Source composite view contains all the information required to identify a member of academic staff or an instructor at the institution. | | |
AS_FACULTY_ATTRIBUTE
| Source composite view contains information that identifies special characteristics associated with the faculty member for tracking and special reporting. | | |
AS_FACULTY_CONTRACT
| Source composite view contains all information for an academic period regarding the faculty contracts for that time frame. | | |
AS_FACULTY_DEPARTMENT_COLLEGE
| Source composite view contains all of the college and departmental associations for the faculty member in this academic period. | | |
AS_FIELD_OF_STUDY
| Source composite view contains all active, inactive, current, and and non-current fields of study for all students identified in recruiting, admissions, student and academic outcome. | | |
AS_GENERAL_STUDENT
| Source composite view contains information associated with each program/curriculum for a student. A student may have as many academic study or program records as permitted by the institution ERP system. | | |
AS_GPA_LEVEL
| Source composite view contains student's GPA values as stored by type of student levels. | | |
AS_GPA_TERM
| Source composite view contains student's GPA values as stored by student academic periods attended. | | |
AS_INSTRUCTIONAL_ASSIGNMENT
| Source composite view contains all the instructors and the teaching assignments they have for the academic period. | | |
AS_LEARNER_CURRICULUM_FOS
| Source composite view contains all active and current curricula for all students identified in the Student module as well as all active and current fields of study for Major, Minor, and Concentrations. | | |
AS_MEAL_ASSIGNMENT
| Source composite view contains all meal plan information. | | |
AS_MEETING_TIME
| Source composite view contains all the meeting time records for each section or schedule offering by academic period. | | |
AS_NONINSTRUCTIONAL_ASSIGNMENT
| Source composite view contains all the instructors and all non teaching assignments they have for the academic period. Include may be assignments like administrator, department chair, coach, etc. | | |
AS_OFFERING_COREQ
| Source composite view contains all of the co requisite subjects or course for a section or schedule offering that must be taken in the same academic period. | | |
AS_OFFERING_GRADE_MODE
| Source composite view contains all of the different grading modes available for the section. Included may be standard, pass/fail, audit or visitor grading, etc. | | |
AS_OFFERING_GRADE_TYPE
| Contains grade options or types of grades available for this schedule offering (section). This data will be either a specific grade type specified for the section or one or more values permited for the course identification from the course catalog. | | |
AS_OFFERING_PREREQ
| Source composite view contains all of the prerequisite subjects or course for a section or schedule offering that must be completed prior to this academic period. | | |
AS_OUTCOME_HONOR_DEPT
| Source composite view contains the outcome departmental honors recorded for a specific academic outcome. | | |
AS_OUTCOME_HONOR_INST
| Source composite view contains the outcome institutional honors recorded for a specific academic outcome. | | |
AS_PHONE_ASSIGNMENT
| Source composite view contains all telephone assignment information. | | |
AS_PRE_STUDENT
| Source composite view contains information on the person who has inquired or applied to be a student or has become a student at the institution. Included is secondary and post secondary information. | | |
AS_RECRUITMENT_ATTRIBUTE
| Source composite view contains information that identifies special characteristics associated with the person who has asked for information on the institution. Attributes are to be used for tracking and special reporting. | | |
AS_RECRUITMENT_COHORT
| Source composite view contains information that identifies the inquirer with a particular group for tracking and reporting purposes. | | |
AS_RECRUITMENT_INFORMATION
| Source composite view contains recruiting information for a person. | | |
AS_RECRUITMENT_LEARNED
| Identifies the recruiting learned information for a person.One row per person per academic year per sequence number per learned code. | | |
AS_RECRUITMENT_SOURCE
| Source composite view contains the first recruitment source listed for the person. | | |
AS_ROOM_ASSIGNMENT
| Source composite view contains room assignments. | | |
AS_SCHEDULE_ATTRIBUTE
| Contains attribute information on the course schedule. | | |
AS_SPORT
| Source composite view contains all sports associated with a student. | | |
AS_STUDENT_ACTIVITY
| Source composite view contains one row for each activity listed for the student. | | |
AS_STUDENT_ATTRIBUTE
| Source composite view contains the student attributes associated with the student record. | | |
AS_STUDENT_COHORT
| Source composite view contains all student cohort information. | | |
AS_STUDENT_COURSE_ATTRIBUTE
| Source composite view contains course attribute information that indicates which courses may be used to satisfy outcome requirements. | | |
AS_STUDENT_COURSE_ATTR_TRANS
| Source composite view contains course attribute information that indicates which courses may be used to satisfy outcome requirements. This may be for institutional or for transfer subjects completed by the student. | | |
AS_STUDENT_COURSE_GRADE_CHG
| Source composite view contains information about the grade or grades assigned to the student for this course. | | |
AS_STUDENT_COURSE_HISTORY
| Source composite view contains information about the courses taken by a student. It tracks registered, graded and transfer courses. | | |
AS_STUDENT_COURSE_IN_PROGRESS
| Source composite view contains information about the courses taken by a student. It tracks registered, graded and transfer courses. | | |
AS_STUDENT_COURSE_REG_AUDIT
| Contains audit information for all student registration activity. | | |
AS_STUDENT_COURSE_TRANSFER
| Source composite view contains information about the courses taken by a student. It tracks registered, graded and transfer courses. | | |
AS_STUDENT_WORK_EXPERIENCE
| Source composite table contains cooperative education information about the student population. | | |
AS_TRANSCRIPT_LEVEL_COMMENT
| Transcript Comments by LevelOne row per person uid per level per comment sequence number. | | |
AS_TRANSCRIPT_TERM_COMMENT
| Transcript Comments by TermOne row per person uid per level per academic period per comment sequence number. | | |
AS_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. | | |