Student Records Data Mart

With the Student Records Data Mart you can review and manage items such as enrollment and registration metrics, count of student and faculty by registered courses, available courses for catalog building and schedule building, graduation rates and student career fulfillment of requirements, student academic standing, and faculty and student profiles.

Enrollment reports include areas such as monitoring average class sizes, prerequisites not being met, grade distributions, and graduation eligibility. Reports in this category include aggregated statistical reports with year-to-year comparisons in several subject areas.

With the Student Records Data Mart you can answer questions such as:

What are the enrollment metrics for this term?
Can I get the Student Retention and Graduation rates year over year by Cohort, Gender and Ethnicity?
What is average GPA by Institution, Career and Program?
What is average time to graduate by Institution, Career and Program?
What classes are scheduled for this term?
Can I track and analyze the workload of the faculty?
What are the Class enrollment details?
What are the honors/awards details for the enrolled students?

Academic Program Activation and Management Business Process

Student Records Data Mart is related to the Academic Program Activation and Management business process. This business process includes Course Catalog, Class Scheduling, Student Career Term records and Enrollment business processes. These processes fulfill the institutions need to track course delivery, student participation through enrollments to those classes. The Academic Program activation and Management processes help manage class size, a student's enrollment in a class and track the resulting grades from the class.

Student Records Data Mart Delivered Fact Tables

The following table describes the delivered Student Records Data Mart fact tables.

Note: In the table, the Helps Answer column includes examples of the type of answers a fact table can provide; it does not contain the complete list of answers.

Fact Name	Fact Record Name	PeopleSoft Source	Description	Helps Answer
Academic Program Detail	F_ACAD_PROG_DTL	PS_ACAD_PROG	Contains information about an individual program action entry for a particular student for a given academic program. This fact table contains all students that enrolled, matriculated, withdrew, or completed an academic career/program at an institution. There is one row of data per student (person) surrogate ID, student career number, program surrogate ID, effective date/sequence and program action surrogate ID. The table is not keyed by term. Institution and career are indirectly part of the key since they are derived from the Academic Program dimension through the Academic Program Surrogate ID.	Number of active students in a program by institution, career, or program. Number of students that are active in more than one program, by institution or campus. Number of students with transfer status who were transferred during a specific time period.
Academic Plan Summary	F_ACADPLAN_SUMM	PS_ACAD_PROG PS_ACAD_PLAN	Contains student summary entry for a given academic plan and related academic program. Each row of this table contains the most current information about an individual student and a particular academic plan. This fact table also contains all students that enrolled, matriculated, withdrew, or completed the academic career/program and plan in the institution, The table is not keyed by term. Institution, career and program are indirectly part of the key since they are derived from the Academic Plan dimension. There is one row of data per student (person) academic plan surrogate ID, and student career number. Records are updated frequently, whenever the student program status is changed, such as activated, admitted, discontinued or completed.	Number of enrollments by program/plan. Number of drop-outs. Number of students in different program action and program action reasons, by career, program, or plan. Number of students that completed the program/plan. Number of students that cancelled the program/plan.
Class Enrollment	F_CLASS_ENRLMT	PS_TERM_TBL PS_STDNT_ENRL	Contains information about student class enrollment, such as class enrollment status, units taken, units in progress, grades, grade points, and units earned. There is one row of data per Term, Session, Person (Student), Class and Class Number. Institution and career are indirectly part of the key since they are derived from the Session dimension table (SESSION_SID is populated from PS_D_SESSION based on the unique combination of Institution, Career, Term and Session).	Number of students enrolled in a class. Number of dropout for a specific class. Number of students that passed or failed a class. Class roster for a particular department.
Class Instructor	F_CLASS_INSTRCT	PS_INSTR_TERM_DTL PS_INSTRUCTOR_TERM	Contains information on instructor workload such as classes/class sections taught by instructor, instruction mode, instructor role, location, campus, facility and also indicates the assignment percentage. There is one row of data per instructor (person), instructor assignment sequence, term and session. Institution and career are indirectly part of the key since they are derived from the Session dimension. Note: The assumption is that you use instructor workload process in the Campus Solutions application.	Total FTE per instructor. Workload by instructor. Instructors with a workload that exceeds 90%.
Class Meeting Pattern	F_CLASS_MTG_PAT	PS_CLASS_TBL PS_CLASS_MTG_PAT PS_CLASS_INSTR	Contains schedule information for a course including start and end dates, days of the week, and times. The data represents the superset of all classes offered, regardless of any student enrollment. This fact table enables you to analyze class meeting pattern and instructor information (when that information is available for the class). If the information regarding meeting pattern and instructor does not exist, it will also show a row for the class, and the class meeting pattern number and instructor assignment sequence will be set to zero. There is one row of data per Session Surrogate ID, Course Surrogate ID, Class Section Code, Class Meeting Number, and instructor assignment number. Institution, Career, and Term are indirectly part of the key since they are derived from the Session Surrogate ID, as well as by Course ID and Course offer number that are derived from the Course Surrogate ID.	Number of courses taught, by subject. Average number of instructors, by course and specific subject. Classes taught on Friday afternoon.
Degrees and Honors	F_DEGREES	PS_ACAD_DEGR PS_ACAD_DEGR_HONS PS_ACAD_DEGR_PLAN PS_ACAD_DEGR_SPLN	Provides analysis of student degrees as well as related honors. It provides measures on degrees and honors conferred by student, term, institution, career, program, academic plan, academic sub plan, and so forth. There is one row of data per student, degree number, honors number, plan and subplan.	Number of students graduating with honors by term/institution/career. Number of those students who are athletes. Honors awarded by major.
Enrollment Requests	F_ENRL_REQ	PS_ENRL_REQ_DETAIL PS_ENRL_REQ_HEADER	Provides analysis of student enrollment requests. This table enables you to analyze enrollment request metrics by student, academic career, institution, term, status, action, reason, an so forth. This table can provides insight into the classes that are more popular, which classes have the longest waitlists, substitute classes, an so forth. There is one row of data per person, career, institution, term, enrollment request ID, enrollment request header status and enroll request sequence number.	Number of classes a student enrolled or attempted to enroll for a given term. Popular classes, by enrollment and student. Popular instructors by enrollment and student. Number of units by student a for a given term. Classes with a high number of repeat attempts by students. Substitute classes requested if students cannot enroll in a particular class. Students enrolled in a class without having met the class prerequisite.
Institution Summary	F_INST_SUMM	PS_X_INST_SUMM (from PS_ACAD_PLAN and PS_F_ACAD_PLAN_SUMM) PS_R_STDNT_COHORT (from PS_STDNT_ATTR_DTL)	Contains information about the retention and graduation counts of an institution. Each row has calculated metrics for every academic program, admit year, admit term, admit type, student gender, ethnicity, and student cohort. This table is an aggregate fact and each row in the table has calculated measures for every academic plan, admit term, admit type, student gender, and ethnicity. This table is designed to store data that corresponds to a list of Academic Careers (Parameter), Full time or Part time academic load (Parameter) for different actions and action reasons (like discontinuation of the course to join armed forces) (Parameter).	Institution 4-year retention rate by cohort, gender and ethnicity. Institution 4-year graduation rate by cohort, gender and ethnicity. Graduation and student trends.
Term Enrollment	F_TERM_ENRLMT	PS_STDNT_CAR_TERM PS_TERM_TBL	Provides term statistics and cumulative statistics by term, student, institution and career. This fact also provides measures such as units in progress, GPA, number of courses, and so forth. Institution and career are indirectly part of the key since they are derived from the Term surrogate ID. There is one row of data per term surrogate ID and student.	Top student academic standings. Number of units in progress versus passed, by institution, career, program, or plan. Average number of courses a student takes per term, by career, program, or plan. Number of units a student is enrolled in. Number of full time and part time students, by term, institution, campus, or primary program. Number of students taking GPA units. Enrollment analysis, by primary program and plan, term, institution, campus, career, and program.

Fact Name

Fact Record Name

PeopleSoft Source

Description

Helps Answer

Academic Program Detail

F_ACAD_PROG_DTL

PS_ACAD_PROG

Contains information about an individual program action entry for a particular student for a given academic program.

This fact table contains all students that enrolled, matriculated, withdrew, or completed an academic career/program at an institution.

There is one row of data per student (person) surrogate ID, student career number, program surrogate ID, effective date/sequence and program action surrogate ID.

The table is not keyed by term. Institution and career are indirectly part of the key since they are derived from the Academic Program dimension through the Academic Program Surrogate ID.

Number of active students in a program by institution, career, or program.

Number of students that are active in more than one program, by institution or campus.

Number of students with transfer status who were transferred during a specific time period.

Academic Plan Summary

F_ACADPLAN_SUMM

PS_ACAD_PROG

PS_ACAD_PLAN

Contains student summary entry for a given academic plan and related academic program.

Each row of this table contains the most current information about an individual student and a particular academic plan. This fact table also contains all students that enrolled, matriculated, withdrew, or completed the academic career/program and plan in the institution,

The table is not keyed by term. Institution, career and program are indirectly part of the key since they are derived from the Academic Plan dimension.

There is one row of data per student (person) academic plan surrogate ID, and student career number.

Records are updated frequently, whenever the student program status is changed, such as activated, admitted, discontinued or completed.

Number of enrollments by program/plan.

Number of drop-outs.

Number of students in different program action and program action reasons, by career, program, or plan.

Number of students that completed the program/plan.

Number of students that cancelled the program/plan.

Class Enrollment

F_CLASS_ENRLMT

PS_TERM_TBL

PS_STDNT_ENRL

Contains information about student class enrollment, such as class enrollment status, units taken, units in progress, grades, grade points, and units earned.

There is one row of data per Term, Session, Person (Student), Class and Class Number.

Institution and career are indirectly part of the key since they are derived from the Session dimension table (SESSION_SID is populated from PS_D_SESSION based on the unique combination of Institution, Career, Term and Session).

Number of students enrolled in a class.

Number of dropout for a specific class.

Number of students that passed or failed a class.

Class roster for a particular department.

Class Instructor

F_CLASS_INSTRCT

PS_INSTR_TERM_DTL

PS_INSTRUCTOR_TERM

Contains information on instructor workload such as classes/class sections taught by instructor, instruction mode, instructor role, location, campus, facility and also indicates the assignment percentage.

There is one row of data per instructor (person), instructor assignment sequence, term and session.

Institution and career are indirectly part of the key since they are derived from the Session dimension.

Note: The assumption is that you use instructor workload process in the Campus Solutions application.

Total FTE per instructor.

Workload by instructor.

Instructors with a workload that exceeds 90%.

Class Meeting Pattern

F_CLASS_MTG_PAT

PS_CLASS_TBL

PS_CLASS_MTG_PAT

PS_CLASS_INSTR

Contains schedule information for a course including start and end dates, days of the week, and times. The data represents the superset of all classes offered, regardless of any student enrollment.

This fact table enables you to analyze class meeting pattern and instructor information (when that information is available for the class). If the information regarding meeting pattern and instructor does not exist, it will also show a row for the class, and the class meeting pattern number and instructor assignment sequence will be set to zero.

There is one row of data per Session Surrogate ID, Course Surrogate ID, Class Section Code, Class Meeting Number, and instructor assignment number.

Institution, Career, and Term are indirectly part of the key since they are derived from the Session Surrogate ID, as well as by Course ID and Course offer number that are derived from the Course Surrogate ID.

Number of courses taught, by subject.

Average number of instructors, by course and specific subject.

Classes taught on Friday afternoon.

Degrees and Honors

F_DEGREES

PS_ACAD_DEGR

PS_ACAD_DEGR_HONS

PS_ACAD_DEGR_PLAN

PS_ACAD_DEGR_SPLN

Provides analysis of student degrees as well as related honors. It provides measures on degrees and honors conferred by student, term, institution, career, program, academic plan, academic sub plan, and so forth.

There is one row of data per student, degree number, honors number, plan and subplan.

Number of students graduating with honors by term/institution/career. Number of those students who are athletes.

Honors awarded by major.

Enrollment Requests

F_ENRL_REQ

PS_ENRL_REQ_DETAIL

PS_ENRL_REQ_HEADER

Provides analysis of student enrollment requests. This table enables you to analyze enrollment request metrics by student, academic career, institution, term, status, action, reason, an so forth.

This table can provides insight into the classes that are more popular, which classes have the longest waitlists, substitute classes, an so forth.

There is one row of data per person, career, institution, term, enrollment request ID, enrollment request header status and enroll request sequence number.

Number of classes a student enrolled or attempted to enroll for a given term.

Popular classes, by enrollment and student.

Popular instructors by enrollment and student.

Number of units by student a for a given term.

Classes with a high number of repeat attempts by students.

Substitute classes requested if students cannot enroll in a particular class.

Students enrolled in a class without having met the class prerequisite.

Institution Summary

F_INST_SUMM

PS_X_INST_SUMM (from PS_ACAD_PLAN and PS_F_ACAD_PLAN_SUMM)

PS_R_STDNT_COHORT (from PS_STDNT_ATTR_DTL)

Contains information about the retention and graduation counts of an institution. Each row has calculated metrics for every academic program, admit year, admit term, admit type, student gender, ethnicity, and student cohort.

This table is an aggregate fact and each row in the table has calculated measures for every academic plan, admit term, admit type, student gender, and ethnicity.

This table is designed to store data that corresponds to a list of Academic Careers (Parameter), Full time or Part time academic load (Parameter) for different actions and action reasons (like discontinuation of the course to join armed forces) (Parameter).

Institution 4-year retention rate by cohort, gender and ethnicity.

Institution 4-year graduation rate by cohort, gender and ethnicity.

Graduation and student trends.

Term Enrollment

F_TERM_ENRLMT

PS_STDNT_CAR_TERM

PS_TERM_TBL

Provides term statistics and cumulative statistics by term, student, institution and career. This fact also provides measures such as units in progress, GPA, number of courses, and so forth.

Institution and career are indirectly part of the key since they are derived from the Term surrogate ID.

There is one row of data per term surrogate ID and student.

Top student academic standings.

Number of units in progress versus passed, by institution, career, program, or plan.

Average number of courses a student takes per term, by career, program, or plan.

Number of units a student is enrolled in.

Number of full time and part time students, by term, institution, campus, or primary program.

Number of students taking GPA units.

Enrollment analysis, by primary program and plan, term, institution, campus, career, and program.

Student Records Data Mart Delivered Dimension Tables

The following table describes the delivered Student Records Data Mart dimension tables.

Dimension Name	Dimension Record Name	Description
Academic Group	D_ACAD_GRP	Defines all the academic groups of an institution.
Academic Organization	D_ACAD_ORG	Defines the organizational entities in an academic organization.
Academic Standing	D_ACAD_STNDNG	Contains a list of all the academic standings of an Institution.
Class	D_CLASS	Stores course information such as course ID and section, location, and academic group.
Course	D_CRSE	Defines all the course offerings for an Institution.
Degree	D_DEG	Contains the list of degrees conferred by the institution.
Degree Honors	D_DEG_HONORS	Defines the degree honor codes.
Degree Status	D_DEG_STAT	Indicates the status of the degree.
Enrollment Action	D_ENRL_ACTION	Contains a list of enrollment request actions such as enroll, drop, add grade, drop grade, and change wait-list position.
Enrollment Detail Status	D_ENRL_DTL_STAT	Contains a list of enrollment detail statuses, such as pending, submitted, and successful.
Enrollment Header Status	D_ENRL_HDR_STAT	Contains a list of enrollment header statuses such as pending, submitted, and successful.
Enrollment Message	D_ENRL_MSG_LOG	Contains a list of enrollment messages such as class full and minimum requirements not met.
Enrollment Reason	D_ENRL_RSN	Contains a list of enrollment request reasons such as student withdrawal, term cancellation, and student request drop.
Enrollment Status	D_ENRLMT_STAT	Contains a list of enrollment statuses.
Ethnic Group	D_ETHNIC_GRP	Contains a list of all the ethnic groups.
Facility	D_FCLTY	Defines the facilities in various campuses of an Institution.
Gender	D_GNDR	Provides student gender detail.
Grade	D_GRADE	Defines the valid grade codes.
Instruction Mode	D_INSTRCTN_MODE	Defines all the course mode of instructions, such as distant and classroom.
Instructor Load	D_INSTRCTR_LOAD	Denotes whether an instructor is full-time or part-time.
Instructor Class Role	D_INSTRCTR_ROLE	Defines the different roles that can be played by an faculty/instructor.
Repeat	D_REPEAT	Contains a list of all the course repeat codes.
Session	D_SESSION	Contains a list of all the academic sessions of a term.
SSR Component	D_SSR_COMP	Defines all the SSR components; for example it can specify the section of a course.
Student Cohort	D_STDNT_COHORT	Contains a list of all the student cohorts (student attributes) of an Institution.
Student Group	D_STDNT_GRP	Contains a list of all the student groups of an Institution.
Relate Academic Subplan (Relationship Table)	R_ACAD_SPLAN	Represents the relationship between an academic plan to its subplans.
Relate Award (Relationship Table)	R_AWD	Represents the relationship between a student to the awards he/she has received.
Relate Degree Honors (Relationship Table)	R_DEG_HONORS	Represents the relationship between a student degree to the honors he/she has received.
Enrollment Request Message (Relationship Table)	R_ENRL_MSG_LOG	Links the one to many relationship between the Enrollment Request (F_ENRL_REQ) fact and the Enrollment Message (D_ENRL_MSG_LOG) dimension.