RETURN TO ODS META DATA REPORTS LIST


Student Reporting View Meta Data Reports

Target Reports:

Reporting ViewDescriptionKey & FrequencyRecommended Search Columns
ACADEMIC_OUTCOME
Contains data about all awards sought and/or earned by a student. Details includes 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.One row per person per outcome number.PERSON_UID,┐OUTCOME_NUMBER
STATUS,┐STUDENT_LEVEL
ACADEMIC_PERIOD_GRADUATION
PROGRAM,┐MAJOR,┐PERSON_UID
COLLEGE,┐DEPARTMENT,┐PERSON_UID
ACADEMIC_OUTCOME_SLOT
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.One row per person per student level.PERSON_UID,┐STUDENT_LEVEL
ACTIVITY_DATE
ACADEMIC_STUDY
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.PERSON_UID
PERSON_UID,┐ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_STANDING_END,┐ACADEMIC_PERIOD
ACADEMIC_PERIOD,┐STUDENT_CLASSIFICATION_BOAP
PERSON_UID,┐STUDENT_LEVEL,┐ACADEMIC_PERIOD
STUDENT_CLASSIFICATION,┐STUDENT_LEVEL,┐ACADEMIC_PERIOD
ACADEMIC_PERIOD,┐STUDENT_LEVEL
STUDENT_LEVEL
PERSON_UID,┐ACADEMIC_PERIOD,┐PRIMARY_PROGRAM_IND,┐PROGRAM_NUMBER
ACADEMIC_PERIOD,┐PRIMARY_PROGRAM_IND
ADMINISTRATOR
Contains data for person who have been identified with an administrator role. The administrator role may be to rate an applicant for admissions on different admission criteria.One row per administrator per person per academic period per application or recruit number.PERSON_UID
ADMINISTRATOR_UID
ADMISSIONS_APPLICATION
Contains data specific to an application to study at the institution submitted by the person. Multiple academic years and or academic periods are available for comparison reporting.One row per person per academic period per application number. ACADEMIC_PERIOD
PERSON_UID
PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACADEMIC_PERIOD, PERSON_UID
ACADEMIC_PERIOD, STUDENT_LEVEL, PROGRAM
ADMISSIONS_ATTRIBUTE
Contains data that is a characteristic for the admissions applicant to be tracked for the application number in the academic period.One row per person per academic period per application number per attribute.ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
ADMISSIONS_ATTRIBUTE, ACADEMIC_PERIOD
ADMISSIONS_COHORT
Contains data that identifies the applicant as a member of a group to be tracked within the system with their anticipated start and end academic period. This information is used for special reporting.One row per person per application number per academic period per cohort.ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
COHORT, ACADEMIC_PERIOD
ADMISSIONS_DECISION
Contains data for all admission decisions recorded for the application. Data Includes decision, description, sequence of entry and effective date of decision.One row per person per academic period per application number per decision number per decision.ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
DECISION, ACADEMIC_PERIOD
PERSON_UID
ADMISSIONS_DECISION_SLOT
Uses data from the ADMISSIONS_DECISION reporting view. Displays up to 5 sets of values based on the last decisions recorded for the academic period and application number.One row per person per academic period per application number.PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACTIVITY_DATE
ADMISSIONS_RATING
Contains data about the ratings recorded for an admissions application as determined by the administrator assigned to evaluate the application.One row per person per academic period per application number per rating.ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
PERSON_UID
ADMISSIONS_REQUIREMENT
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 dateOne row per person per academic period per application number per requirement.ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
ACADEMIC_PERIOD, REQUIREMENT
ADMISSIONS_SOURCE
Contains all the sources or ways that the applicant heard about the institution and primary source the application was submitted.One row per person per academic period per application number per institution (or source).ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
INSTITUTION, ACADEMIC_PERIOD
ADMISSIONS_SOURCE_SLOT
Uses data from the ADMISSIONS_SOURCE reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of SOURCE and a delivered or institution defined internal code. Delivered internal codes of ADMSSRCE may be used independently by the institution.One row per person per profile code per admissions source rule.PERSON_UID, PROFILE_CODE, ACADEMIC_PERIOD, APPLICATION_NUMBER, ADMISSIONS_SOURCE_RULE
ACTIVITY_DATE
ADVISOR
Contains data about the advisors assigned to a person. Details include advisor type description and the primary advisor identification.One row per person per academic period per advisor.ACADEMIC_PERIOD
PERSON_UID
ADVISOR_SLOT
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.One row per person per academic period.PERSON_UID
PERSON_UID, ACADEMIC_PERIOD
ACTIVITY_DATE
COURSE_ATTRIBUTE
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.ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
COURSE_ATTRIBUTE
COURSE_ATT_SLOT
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 or institution defined internal code. Delivered internal codes of CRSEATTR may be used independently by the institution.One row per subject and course number per profile code per attribute rule.SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD, PROFILE_CODE, ATTRIBUTE_RULE
ACTIVITY_DATE
COURSE_CATALOG
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.SUBJECT, COURSE_NUMBER
ACADEMIC_PERIOD
COURSE_COREQ
Contains data about a course identification (subject and course number) for the corequisite that must be taken in the same academic period as the subject and course number for which this record.One row per subject and course number per academic period per course identification for the corequisite.ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
SUBJECT_COREQ, COURSE_NUMBER_COREQ
COURSE_LEVEL
Contains data about the type of credit 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.ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
COURSE_LEVEL
COURSE_LEVEL_SLOT
Uses data from the COURSE_LEVEL reporting view. Displays up to 4 sets of values based on the course levels recorded for the course identification for the academic period.One row per course identification per academic period.SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD
ACTIVITY_DATE
COURSE_PREREQ
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.ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
COURSE_PREREQ_COMBINED
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 individula rows in teh COURSE_PREREQ.One row per subject and course number per academic period per course identification (subject and course number).ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
COURSE_SCHEDULE
Contains details of the offering delivery type (lecture, lab, internet, etc) and its weight in calculating the instructor's work load.One row per subject and course number per academic period per schedule.ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
SCHEDULE
COURSE_SCHEDULE_SLOT
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 adacemic period per profile code per schedule rule.SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD, PROFILE_CODE, SCHEDULE_RULE
ACTIVITY_DATE
ENROLLMENT
Contains enrollment data for those persons with registration activity in an academic period. Note the persons permitted register who may or may not have a row in ENROLLMENT can be obtained using the STUDENT reportiing view. All active and permited to register persons will have program or curriculum will have a row in the ACADEMIC STUDY reporting view.One row per person per academic period enrolled.PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_STANDING_END, ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_CLASSIFICATION_BOAP
STUDENT_CLASSIFICATION, ACADEMIC_PERIOD
FACULTY
Contains detail information from the student administration arena for the academic staff member. The staff members assignments can be viewed and reported using the INSTRUCTIONAL ASSIGNMENT and NON INSTRUCTIONAL ASSIGNMENT reporting view.One row per faculty member per academic period.PERSON_UID
CONTRACT_RULE
PERSON_UID, HOME_COLLEGE, HOME_DEPARTMENT
ACADEMIC_PERIOD
FACULTY_ATTRIBUTE
Contains the faculty attributes (instution assigned reporting values) associated with an insturctor or academic staff member. The attributes can be used to group faculty for reporting.One row per person per academic period per faculty attribute.ACADEMIC_PERIOD
PERSON_UID
FACULTY_ATTRIBUTE
FACULTY_ATT_SLOT
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 or institution defined internal code. Delivered internal codes of FACLATTR may be used independently by the institution.One row per person per academic period per profile code per attribute rule.PERSON_UID, ACADEMIC_PERIOD, PROFILE_CODE, ATTRIBUTE_RULE
ACTIVITY_DATE
FACULTY_DEPARTMENT_COLLEGE
Contains institution organization association with the instructor or academic staff member by academic period. The details will include all college and department associates along with indication of the 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.ACADEMIC_PERIOD
PERSON_UID
FIELD_OF_STUDY
Audit trail of all fields of study assigned to a curricula for a student or learner.One row per occurrence of field of study per curricula per student or learner.
GOVERNMENT_ACADEMIC_OUTCOME
Contains the common data required for government reporting on the number of academic outcomes completed for the time frame. Contain 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.PERSON_UID, ACADEMIC_PERIOD
PERSON_UID, COHORT_RULE
ACADEMIC_PERIOD
PERSON_UID, STUDENT_LEVEL, ACADEMIC_PERIOD
STUDENT_LEVEL, ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_LEVEL
PERSON_UID, OUTCOME_NUMBER
PROGRAM, MAJOR, PERSON_UID
COLLEGE, DEPARTMENT, PERSON_UID
GOVERNMENT_ADMISSIONS
Contains the common data required for government reporting on application statistics for a time frame. Contain only the academic period and person who have 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.PERSON_UID, TEST_RULE
ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACADEMIC_PERIOD, PERSON_UID
ACADEMIC_PERIOD, STUDENT_LEVEL, PROGRAM
ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
COHORT, ACADEMIC_PERIOD
GOVERNMENT_COURSE
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 is count in enrolled and not be deducted from the counts) for the academic period reported. It may be joined with other reporting views required for external or internal reporting requirements.One row per person per academic period per course reference number.ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID
PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID, ACADEMIC_PERIOD, COURSE_LEVEL
PERSON_UID, COURSE_IDENTIFICATION
PERSON_UID, ACADEMIC_PERIOD, COURSE_IDENTIFICATION
PERSON_UID, COURSE_COLLEGE, COURSE_DEPARTMENT
COURSE_IDENTIFICATION, ACADEMIC_PERIOD
COURSE_COLLEGE, COURSE_DEPARTMENT, COURSE_IDENTIFICATION, ACADEMIC_PERIOD
COURSE_DEPARTMENT, ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
GOVERNMENT_STUDENT
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 with other reporting views to meet external or internal reporting requirements.One row per person per academic period.PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_CLASSIFICATION_BOAP
PERSON_UID, STUDENT_LEVEL, ACADEMIC_PERIOD
STUDENT_CLASSIFICATION, STUDENT_LEVEL, ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_LEVEL
STUDENT_LEVEL
PERSON_UID, ACADEMIC_PERIOD, PRIMARY_PROGRAM_IND
ACADEMIC_PERIOD, PRIMARY_PROGRAM_IND
PERSON_UID, COHORT
GPA
Contains detail data for any type of student grade point average (GPA) 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 (time based or not) per GPA group (cummulative or period) per academic study area (level) per GPA type (institution or transfer) per academic period.PERSON_UID, ACADEMIC_STUDY_VALUE, GPA_TIME_IND, ACADEMIC_PERIOD, GPA_GROUPING, GPA_TYPE
PERSON_UID, ACADEMIC_STUDY_VALUE, ACADEMIC_PERIOD, GPA_TYPE
GPA_TIME_IND, GPA_GROUPING, ACADEMIC_STUDY_AREA, ACADEMIC_STUDY_VALUE
GPA_BY_LEVEL
Contains grade point average or average details for a person by student level of academic study. Details include the component data used to calculate the GPA..One row per person per academic study area (level).PERSON_UID, ACADEMIC_STUDY_VALUE, ACADEMIC_PERIOD, GPA_TYPE
ACADEMIC_STUDY_VALUE
GPA_BY_TERM
Contains grade point average or average details for a person by academic period. Details include the component data used to calculate the GPA..One row per person per academic period.PERSON_UID, ACADEMIC_STUDY_VALUE, ACADEMIC_PERIOD, GPA_TYPE
ACADEMIC_STUDY_VALUE
INSTRUCTIONAL_ASSIGNMENT
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.PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
INSTRUCT_ASSIGN_SLOT
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.COURSE_REFERENCE_NUMBER, ACADEMIC_PERIOD
ACTIVITY_DATE
MEAL_ASSIGNMENT
Contains details for all meal plan assignments made for the person.One row per person per academic period per meal plan assigned.PERSON_UID, ACADEMIC_PERIOD
MEETING_TIME
Contains details for the section meeting dates, days, times, buildings and rooms.One row per course reference number per academic period per meeting time combination.ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, BEGIN_TIME, MONDAY_IND, TUESDAY_IND, WEDNESDAY_IND, THURSDAY_IND, FRIDAY_IND, SATURDAY_IND, SUNDAY_IND
SUBJECT, COURSE_NUMBER
MEETING_TIME_SLOT
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.One row per course reference number per academic period.ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
ACTIVITY_DATE
NONINSTRUCT_ASSIGN_SLOT
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.PERSON_UID, ACADEMIC_PERIOD, PROFILE_CODE
ACTIVITY_DATE
NON_INSTRUCTIONAL_ASSIGNMENT
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 non instructional type.PERSON_UID, ACADEMIC_PERIOD
OFFERING_COREQ
Contains course reference number section specific corequisite data for two or more subject and course numbers that must be taken in the same academic period.One row per academic period per course reference number per course reference number corequisite.ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
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.One row per academic period per course reference number per grade type.SUBJECT, COURSE_NUMBER
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
OFFERING_PREREQ
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.ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
OUTCOME_DEPARTMENTAL_HONOR
Contains details regarding honors granted by a department to a person for a qualifying academic outcome (award, degree, certificate, etc.).One per person per outcome number per honor.PERSON_UID, OUTCOME_NUMBER
OUTCOME_HONOR
Contains details regarding honors granted either by the institution or by a department of the institution to a person for a qualifying academic outcome (award, degree, certificate, etc.).One per person per outcome number per honor.PERSON_UID, OUTCOME_NUMBER
HONOR_IND
OUTCOME_INSTITUTIONAL_HONOR
Contains details regarding honors granted by the institution to a person for a qualifying academic outcome (award, degree, certificate, etc.).One per person per outcome number per honor.PERSON_UID, OUTCOME_NUMBER
PHONE_ASSIGNMENT
Contains details when a telephone assignment is made by assigning a phone rate to at person..One row per person per academic period per phone rate.PERSON_UID, ACADEMIC_YEAR, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD
PRE_STUDENT
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 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.One row per person.PERSON_UID
RECRUITMENT_ATTRIBUTE
Contains characteristics to be tracked within the system for the recruit. Data tracked will assist in grouping the recruits for reporting purposes.One row per person per academic period per recruit number per recruiting attribute.ACADEMIC_PERIOD, PERSON_UID, RECRUIT_NUMBER
RECRUITING_ATTRIBUTE, ACADEMIC_PERIOD
RECRUITMENT_COHORT
Contains data that identifies a recruit as a member of a group to be tracked within the system. The cohorts are used primarily to identify a group to be tracked for reporting.One row per person per academic period per recruit number per cohort.ACADEMIC_PERIOD, PERSON_UID, RECRUIT_NUMBER
COHORT, ACADEMIC_PERIOD
RECRUITMENT_INFORMATION
Contains data for all inquiries made by persons considering or planning to study at the institution. Details include the type of contact, dates and academic study or program of interest, etc.One row per person per academic period per recruit number.ACADEMIC_PERIOD, PERSON_UID, RECRUIT_NUMBER
COLLEGE
MAJOR
RATE
PERSON_UID
RECRUITMENT_SOURCE
Contains the institution (agency or organization) that was the major influence on the recruit to contact the institution to request information.One row per person per academic period per recruit number per institution (source).ACADEMIC_PERIOD, PERSON_UID, RECRUIT_NUMBER
PERSON_UID
RECRUITMENT_SOURCE_SLOT
Uses data from the RECRUITMENT_SOURCE reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of SOURCE and a delivered or institution defined internal code. Delivered internal codes of RECRSRCE may be used independently by the institution.One row per person per recruit number per profile code per recruitment source rule.PERSON_UID, ACADEMIC_PERIOD, RECRUIT_NUMBER, PROFILE_CODE, RECRUITMENT_SOURCE_RULE
ACTIVITY_DATE
REQUIREMENT_SLOT
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.PERSON_UID, PROFILE_CODE, REQUIREMENT_RULE
ACTIVITY_DATE
ROOM_ASSIGNMENT
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.One row per person per academic period per building and room number.PERSON_UID, ACADEMIC_YEAR, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD
SCHEDULE_ATTRIBUTE
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.SCHEDULE_ATTRIBUTE, ACADEMIC_PERIOD
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
SCHEDULE_OFFERING
Contains detail data for a section (schedule offering) of a subject or course within a specific time period like an academic period.One row per course reference number per academic period and sub academic period.SUBJECT, COURSE_NUMBER
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
SPORT
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.One row per person per academic period per activity.PERSON_UID, ACADEMIC_PERIOD, ACTIVITY
SPORT_SLOT
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.One row per person per academic period.PERSON_UID, ACADEMIC_PERIOD
ACTIVITY_DATE
STUDENT
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.One row per person per academic period.PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_CLASSIFICATION_BOAP
STUDENT_CLASSIFICATION, ACADEMIC_PERIOD
STUDENT_ACTIVITY
Contains data about activities associated with a person within a time frame. Details include other codes that permit the activites to be grouped different ways for reporting purposes like activity type and activity category.One row per person per academic period per activity.PERSON_UID
STUDENT_ATTRIBUTE
Contains characteristics to be tracked within the system for the student. Data tracked will assist in grouping the students for reporting purposes.One row per person per academic period per student attribute.ACADEMIC_PERIOD
PERSON_UID, STUDENT_ATTRIBUTE
STUDENT_COHORT
Contains data that identifies thestudent as a member of a group to be tracked within the system with their anticipated start and end academic period. This information is used for special reporting.One row per person per academic period per cohort.ACADEMIC_PERIOD
PERSON_UID, COHORT
STUDENT_COHORT_SLOT
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.PERSON_UID, PROFILE_CODE, ACADEMIC_PERIOD, COHORT_RULE
ACTIVITY_DATE
STUDENT_COURSE
Contains detail data for student courses recorded in the system. Courses taken by the studen maybe registered (in progress course), graded (institutional history), and transfered (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.One row per person per academic period per course reference number.PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, IN_PROGRESS_COURSE_IND
PERSON_UID, TRANSFER_COURSE_IND
PERSON_UID, ACADEMIC_PERIOD, INSTITUTION_COURSE_IND
ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD, COURSE_LEVEL
PERSON_UID, COURSE_IDENTIFICATION
PERSON_UID, ACADEMIC_PERIOD, COURSE_IDENTIFICATION
COURSE_IDENTIFICATION, ACADEMIC_PERIOD
GRADE_VALUE, ACADEMIC_PERIOD
STUDENT_COURSE_ATTRIBUTE
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.PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID, COURSE_REFERENCE_NUMBER
PERSON_UID, SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD
STUDENT_COURSE_ATT_SLOT
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 or institution defined internal code. Delivered internal codes of HISTATTR may be used independently by the institution.One row per person per academic period per course reference number per profile code per attribute rule.PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, PROFILE_CODE, ATTRIBUTE_RULE
ACTIVITY_DATE
STUDENT_COURSE_GRADE_CHANGE
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.PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, FINAL_GRADE_SEQUENCE_NUMBER
GRADE_CHANGE_REASON
FINAL_GRADE
GRADE_COMMENT
STUDENT_COURSE_REG_AUDIT
Contains audit information for all student registration activity.One row per sequence number per course request number per student per academic period.ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID
PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, SEQUENCE_NUMBER
STUDENT_WORK_EXPERIENCE
Contains details of any student work experienc 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.PERSON_UID, ACADEMIC_PERIOD, STUDENT_LEVEL
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER

Source Reports:

SABSUPL
SARAATT
SARADAP
SARAPPD
SARCHKL
SARCHRT
SARRRAT
SARRSRC
SCBCRSE
SCBDESC
SCBSUPP
SCRATTR
SCRCORQ
SCRGMOD
SCRLEVL
SCRRTST
SCRSCHD
SFBETRM
SFRAREG
SFRSTCA
SFRSTCR
SFRTHST
SGBSTDN
SGRADVR
SGRCHRT
SGRCOOP
SGRDISA
SGRSACT
SGRSATT
SGRSPRT
SGRVETN
SHBDIPL
SHRATTC
SHRATTR
SHRDGDH
SHRDGIH
SHRDGMR
SHREGPA
SHRGPAC
SHRGPAL
SHRGRDE
SHRLGPA
SHRTATC
SHRTATT
SHRTCKG
SHRTCKL
SHRTCKN
SHRTGPA
SHRTRCE
SHRTRCR
SHRTRIT
SHRTTRM
SIBFACD
SIBINST
SIRASGN
SIRATTR
SIRDPCL
SIRICNT
SIRNIST
SLBBLDG
SLBEVNT
SLBRDEF
SLBRMAP
SLRBCAT
SLRMASG
SLRPASG
SLRRASG
SOBCACT
SOBSBGI
SORAINF
SORAPPT
SORBACD
SORBCHR
SORBCNT
SORBDMO
SORCONT
SORDEGR
SORHSBJ
SORHSCH
SORINTS
SORLCUR
SORLFOS
SORMAJR
SORPCOL
SORTEST
SPBPERS
SPRADDR
SPRHOLD
SPRIDEN
SPRMEDI
SPRTELE
SRBRECR
SRRCHRT
SRRLEND
SRRRATT
SRRRSRC
SSBDESC
SSBOVRR
SSBSECT
SSRATTR
SSRCORQ
SSRMEET
SSRRTST
SSRSYLN
STVACCG
STVACTC
STVACYR
STVASRC
STVASTD
STVATYP
STVCACT
STVCAMP
STVCAST
STVCHRT
STVCITZ
STVCLAS
STVCNTY
STVCOLL
STVCOPC
STVCSTS
STVDEGC
STVDEGS
STVEMPL
STVESTS
STVETCT
STVETHN
STVEXAM
STVGEOD
STVGEOR
STVGMOD
STVHLDD
STVLEVL
STVLMOD
STVMAJR
STVNATN
STVNIST
STVPREV
STVRESD
STVRGRE
STVRSLT
STVSBGI
STVSCHD
STVSITE
STVSTAT
STVSTST
STVSUBJ
STVTELE
STVTERM
STVTMST
STVWRSN


Ver: 3.1