Contains data about all awards sought and/or earned by a student. Details include program of academic study, majors, degree GPA, total credits earned, institutional and departmental honors, etc. The GOVERNMENT_ACADEMIC_OUTCOME reporting view may be used to report on only those outcomes that were awarded.

Uses data from the ACADEMIC_OUTCOME reporting view. Displays up to 3 sets of values based on the student level. Currently, there are no associated display rules so the three most recent academic outcomes will be displayed.

Contains data for each curriculum/program the student is considered active. A student will have one record for each different academic study recorded for the person. All current and active curriculum records for an academic period will have a separate reporting row for ease of reporting. The field of study associated with the active curriculum will be included for up to four majors, each potentially having up to three associated concentrations. The curriculum may also display up to four associated minors. The student's primary curriculum for the academic period will be flagged with the PRIMARY_PROGRAM_IND set to Y.

One row per person per academic period with student activity per curriculum.

Contains data for each curriculum/program, the student is considered active and permitted to enroll for the academic period. A student will have one record for each different academic study recorded for the person. All current and active curriculum records for an academic period will have a separate reporting row for ease of reporting. The field of study associated with the active curriculum will be included for up to four majors, each potentially having up to three associated concentrations. The curriculum may also display up to four associated minors. The student's primary curriculum for the academic period will be flagged with the PRIMARY_PROGRAM_IND set to Y.

One row per person per academic period per curriculum per defined term code.

Contains data about items or other documents required from the applicant before the institution considers their application complete and ready for admission consideration. Details include the most recent request date and the requirement received date.

One row per person per academic period per application number per requirement.

Contains data for a student audit on block credits and courses needed, block credits and courses required, block credits and courses counted, and block gpa as well as information about the block itself. Percentages for credits or courses completed by block and ranges that various counts or percentages fall into.

Contains student audit course results and details for courses counted, courses needed, fall-through courses counted, insufficient courses counted and over-the-limit courses. If courses are needed, they are identified as may take, must take, or can't take. If courses are counted, then their equivalent course details are displayed such as grade, transfer or repeat course information. Also contains courses and credits required for the requirement rule associate with the course.

Contains student audit non-course results and details for non-courses counted, courses needed,and fall-through courses counted. If non-courses are needed, they are identified as may take, must take, or can't take. If non-courses are counted, then their equivalent non-course details are displayed.

Contains data about attributes associated with a course or offering. These attributes are used to identify characteristics of the course. For example, first year, second year, writing skill, science lab, computer skill, etc.

One row per subject and course number per academic period per course attribute.

Uses data from the COURSE_ATTRIBUTE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of ATTRIBUTES and a delivered defined internal code of CRSEATTR.

Contains details for a subject (course) offered as part of the instruction in an academic study program. Details tracked will be specific to each academic period for which the subject could be offered. Academic periods will end when the course has an end academic period or when the status associated with the subject makes it not available to be scheduled.

One row per subject and course number per academic period in which the course was active.

Contains data about the type of credit that can be earned for a course. For example, the levels might be Undergraduate, Graduate, Credit, Apprenticeship, etc. This would permit the reporting of which student level transcripts this course can appear.

One row per subject and course number per academic period per course level.

Contains detail data about a section (schedule offering) of a course (subject and course number) when it has associated section-based or course-based specific fees for a specific academic period. Details include whether the fee is a flat fee or an amount per credit for the course and if any curriculum values were used in the rule to assess this fee.

One record per academic term per course offering per detail code per sequence number.

Contains data about a course identification (subject and course number) for the prerequisite that must be taken in a previous academic period as the subject and course number for which this is recorded. Details include whether it may alternatively be taken in the same academic period.

One row per subject and course number per academic period per course identification for the prerequisite.

Contains data about a course identification (subject and course number) for the prerequisite that must be taken in a previous academic period as the subject and course number for this record. Details include whether it may alternatively be taken in the same academic period. Data will be presented combining all prerequisite conditions into a single text string opposed to the individual rows in the COURSE_PREREQ.

One row per subject and course number per academic period per course identification (subject and course number).

Uses data from the COURSE_SCHEDULE reporting view. Displays up to 4 sets of values based on the defined display rule(s) with an internal group of SCHEDULE TYPE and a delivered or institution defined internal code. Delivered internal codes of CRSESCHD may be used independently by the institution.

One row per subject and course number per academic period per profile code per schedule rule.

Contains enrollment data for those persons with registration activity in an academic period. Note the persons permitted to register who may or may not have a row in ENROLLMENT can be obtained using the STUDENT reporting view. All active and permitted to register persons who have program or curriculum will have a row in the ACADEMIC STUDY reporting view.

Contains student withdrawal data for persons who enrolled for the academic period but has withdrawn or been administratively withdrawn from the institution. This reporting view may be used to report how much of an academic period the person attended. Persons who have an enrollment withdrawal record will have a record in the ENROLLMENT and the ACADEMIC STUDY reporting views.

Contains detail information from the student administration area for the academic staff member. The staff members assignments can be viewed and reported using the INSTRUCTIONAL ASSIGNMENT and NON INSTRUCTIONAL ASSIGNMENT reporting views.

Uses data from the FACULTY_ATTRIBUTE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of ATTRIBUTES and a delivered internal code of FACLATTR.

Contains institution organization associated with the instructor or academic staff member by academic period. The details will include all college and department associations along with indication of the home administrative college and or department, and the percentage responsibility for the home organization.

One row per person per academic period per college and or department combination.

Contains detail data for each faculty feedback issue or recommendation recorded for the feedback session whether faculty feedback was mandatory or optional for the student courses. This reporting view shows all feedback issues and recommendations recorded within the feedback session and maybe used by itself or with other reporting views to report the feedback and other student attributes.

One row per feedback session per academic period per course reference number per person

Contains informational data about the faculty feedback session rules and the student estimated grade and comment entered by the faculty member of the feedback session. This data may be combined with the faculty feedback detail regarding all issues or recommendations recorded the instructor to obtain complete mandatory and optional input for student registered for the academic period in a student course.

One row per academic period per course reference number per feedback session per person

Contains the common data required for government reporting on the number of academic outcomes completed for the time frame. Contains only the academic period and person who have completed an academic study (award, degree, certificate, etc.). This reporting view may be joined with other reporting views for external and or internal report requirements.

One row per person per academic period per outcome number per address rule.

Contains the common data required for government reporting on application statistics for a time frame. Contains only the academic period and person who have applied to the institution with all details regarding that application. This reporting view may be joined with other reporting views for external and or internal report requirements.

One row per person per academic period per application number per curriculum per test rule.

Contains common data on course registration used for government reporting. Details are included for the courses (subjects) that are registered or in progress (where the course has a course registration 'count in enrolled' set to Yes) for the academic period reported. It may be joined with other reporting views required for external or internal reporting requirements.

Contains data for enrolled students required for government reporting. Details are included only for those persons who have a row in ENROLLMENT for the academic period reported. This reporting view can be joined with other reporting views to meet external or internal reporting requirements. The curriculum may also display up to four associated minors. The student's primary curriculum for the academic period will be flagged with the PRIMARY_PROGRAM_IND set to Y.

One row per person per academic period per student level per program number per reportable cohort per active cohort.

Contains detail data for any type of student GPA (grade point average) or Average. Details include all the data required to calculate different types of GPAs. The current data loaded includes only overall level (undergraduate, graduate), academic period GPA information.

One row per person per GPA time indicator (identifies time based (academic period) or not time based (other to be defined by institution)) per GPA group (cumulative or academic period) per academic study area student level per GPA type (institution, transfer or overall).

Contains all instructor assignments for scheduled offerings of a course (subject) for the academic period or faculty contract time frame. Details include faculty human resource position and job suffix, percent responsibility, etc. These details can be used with the no instructional assignments to determine the faculty members total workload.

One row per person per academic period per course reference number per meeting time combination or session indicator (category on the database table)

Uses data from the INSTRUCTIONAL ASSIGNMENT reporting view. Displays up to 3 sets of values when more than one instructor is assigned to a course reference number. Currently there are no associated display rules.

One row per course reference number per academic period per instructor assigned.

Uses data from the MEETING TIME reporting view. Displays up to 10 sets of values when more than one meeting time exists for a course reference number. Details include the meeting dates, days, times, building and room number. Currently there are no associated display rules.

Uses data from the NONINSTRUCT_ASSIGN reporting view. Displays up to 6 sets of values based on the defined display rule(s) with an internal group of FACULTY ASSIGNMENTS and a delivered or institution defined internal code. Delivered internal codes of FACLNIST may be used independently by the institution.

One row per person (instructor) per academic period per profile period per assignment rule.

Contains detail data about the non-teaching assignments for an instructor that are used in calculating the instructor's workload. These details can be used with the instructional assignments to determine the faculty members total workload.

One row per person per academic period per profile code per non instructional 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 permitted for the course identification from the course catalog.

One row per academic period per course reference number per grade type.

Contains data about a section that either uses the data defined for the course identification (subject and course number) or overridden for this course reference number as the set of prerequisite that must be satisfied prior to registering for this schedule offering (section). Details include whether it may alternatively be taken in the same academic period.

One row per academic period per course reference number per prerequisite course identification.

Contains detail information about the registration plan templates that may have been used to create a list of academic periods and courses to be taken in each in sequence of academic periods for the student level and program or degree.

One row per academic period per plan sequence number key per plan course key

Contains detail data for persons who are current active students at the institution. For example, persons who are either an applicant or a prospect of the institution. They will have one pre student record even if they have multiple inquiry records and/or applications. Details included in the pre student view will include last secondary and last post secondary institution attended when appropriate. It will also include a count of test scores recorded in the system for the person.

Uses data from the ADMISSIONS_REQUIREMENT reporting view. Displays up to 7 sets of values based on the defined display rule(s) with an internal group of CHECK LIST and a delivered or institution defined internal code. Delivered internal codes of ADMSCHKL may be used independently by the institution.

One row per person per application number per profile code per requirement rule.

Contains data on all room assignments made to institution residence halls and other tracked housing facilities. Details are included for student academic period assignments as well as specialized room assignments for a conference or a day, etc.

Contains data about attributes associated with a schedule offering. These attributes are used to identify characteristics of the section or offering. For example, first year, second year, writing skill, science lab, computer skill, etc.

One row per academic period per course reference number and schedule attribute.

Contains data regarding persons who are involved in official institution sports activities and need to be tracked within the system. For example, the NCAA details required for reporting on students participating in the sport are accessed using this reporting view.

Uses data from the SPORT reporting view. Displays up to 5 sets of values based on the sport activities recorded for the academic period. There are currently no sequence rules available for this repeating view.

Contains data for the student for the academic period that will not be different when the person is admitted to more than one academic study within the timeframe. Includes indicators reflecting student current status in several important groupings to make reporting groups easier for the reporting user. Details include whether the current student status at the institution will permit the student to enroll or if the student is a new admit in the academic period.

Contains data about activities associated with a person within a time frame. Details include other codes that permit the activities to be grouped different ways for reporting purposes like activity type and activity category.

Uses data from the STUDENT_ATTRIBUTE reporting view. Displays up to 10 values based on the defined display rule(s) with an internal group of STUDENT ATTRIBUTE and a delivered or institution defined internal code. Delivered internal code of STDNATTR may be used by the institution.

One row per person per academic period per profile code per attribute rule.

Uses data from the STUDENT_COHORT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of COHORT and a delivered or institution defined internal code. Delivered internal codes of STDNCHRT may be used independently by the institution.

One row per person per academic period per profile code per cohort rule.

Contains detail data for student courses recorded in the system. Courses taken by the student may be registered (in progress course), graded (institutional history), and transferred (transfer credit granted) courses. This reporting view shows all courses associated with the student in a single reporting view. Indicators permit the report user to identify groupings of courses for selected reporting needs.

Contains data about the student course attributes associated with a subject and course number completed by the person. Reporting requirements for these student course attributes include grouping the courses to complete specific academic completion requirements and reporting on those.

One row per person per academic period per course reference number per course attribute.

Uses data from the STUDENT_COURSE_ATTRIBUTE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of ATTRIBUTES and a delivered internal code of HISTATTR.

One row per person per academic period per course reference number per profile code.

Contains all details and history of the grade changes for the subject or course completed by the student. Data includes the grade change reason and date so that analytical and statistical reporting on grades can be done.

One row per person per academic period per course reference number per final grade sequence number.

Contains data for the student for the academic period that will not be different when the person is admitted to more than one academic study within the timeframe. Includes indicators reflecting student current status in several important groupings to make reporting groups easier for the reporting user. Details include whether the current student status at the institution will permit the student to enroll or if the student is a new admit in the academic period.

Contains detail data for a each course a student completed at another institution for which this institution is granted equivalent course credit. This reporting view will contain the details as recorded on the received transfer institution transcript as well as the institution equivalent course for which the student is receiving credit. This reporting will show one row for each Transfer Course Detail Repeating Table (SHRTRCE) and Transfer Course Equivalent Repeating Table (SHRTRCE) combination. Therefore they may be more than one row per entry on either the transfere course or the equivalent course. This reporting view should not be used in combination with the STUDENT_COURSE reporting view which will have one row per each Transfer Course Equivalent Repeating Table row.

One row per person per academic period per transferred course per equivalent course

Contains details of any student work experience completed as a portion of their academic study. This will include but not be limited to cooperative education, internship, apprenticeship, sandwich courses and detail information regarding each experience.

One row per person per student level per academic period per work experience employer.