Institutional Research Data Mart

Student Admission Application

PS_TF_ADM_APPL

PS_FF_ADM_APPL

Contains current information of student applications and provides information on applicants and their applications, and associated academic institutions, academic careers, programs, plans and subplans.

There is one row of data per applicant, Institution, Career, career number, application, program, plan and subplan.

The number of first time, first-year freshmen who applied and were admitted to my institution, by gender and by academic load.

The number of first time, first-year freshmen who enrolled, by gender and by academic load.

The percent of undergraduate applicants who submitted SAT or ACT scores.

The percent of first time, first year students with scores in specific ranges on SAT Critical reading, SAT Math and SAT Writing.

Completions

PS_TF_DEG_COMPLTN

PS_FF_DEG_COMPLTN

Contains information on 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 sub plan.

Number of students graduating with honors by term/institution/career.

Number of those students who are athletes, honors awarded by primary majors, secondary majors and so forth.

External Academic Summary

PS_TF_EXT_ACAD_SUM

PS_FF_EXT_ACAD_SUM

Contains information on the external academic information of prospects and applicants, and an external academic summary entry of a prospect/applicant for each particular external academic career at a particular external organization, derived with a particular summary type.

There is one row of data per person, external organization, external academic career, external data number (sequence number) and external summary type.

—

Student Retention, Persistence, and Graduation Rate Detail

PS_TF_RATE_DTL

PS_FF_RATE_DTL

Contains detailed student retention, persistence, and graduation information such as retention count, two year persistence count through seven year persistence count, and graduation count.

—

Student Retention, Persistence and Graduation Rate Detail (intermediate processing table)

PS_TF_RATE_DTL_PRC1

An intermediate processing table, PS_TF_RATE_DTL_PRC1 is used to load data from the factless fact table FF_STU_CAR_DTL. This table contains initial cohort and exclusion information for students, such as first time student flag, exclusion flag, initial cohort count, and exclusion count.

There is one row of data per student, institution, academic career, term, academic program, academic plan and academic sub plan.

—

Student Retention and Persistence Rate Summary

PS_TF_RATE_SUMM

PS_FF_RATE_SUMM

Contains summarized student retention and persistence information such as initial cohort count without exclusions, target cohort count, and adjusted initial cohort count.

—

Class Enrollment Snapshot

PS_TF_STDNT_ENRL

PS_FF_STDNT_ENRL

This fact table contains detailed student class enrollment information, such as class enrollment status, units taken, units in progress, grades, grade points, and units earned.

Data from this table is derived from the STDN_ENRL table.

There is one row of data per student, institution, academic career, term, class and class number.

Number of students enrolled in a class.

Number of dropout for a specific class.

Number of students that passed or failed a class.

Number of students enrolled by ethnicity, gender in a class.

Number of Graduate students enrolled by ethnicity, gender in a class.

Number of Graduate Degree seeking/Non Degree seeking students enrolled by ethnicity, gender in a class.

Detailed Student Program Stack Snapshot

PS_TF_STU_CAR_DTL

PS_FF_STU_CAR_DTL

This factless fact table provides all Program, Plans, and Subplans information that the student is enrolled for a given snapshot.

This factless fact also provides primary major plans and subplans, primary minor plans and subplans.

There is one row of data per student, institution, academic career, term, academic program, academic plan and academic subplan.

Number of First time students enrolled in a class.

Number of Degree/Certificate Seeking students enrolled in a class.

Aggregate Enrollment

PS_TF_ STU_ENRL_AGG

PS_FF_ STU_ENRL_AGG

Contains aggregated student enrollment information such as student credit hours, full time equivalent (FTE), cumulative number of credit hours taken toward the GPA, and number of class sections enrolled by student.

See End of Term Performance fact below.

End of Term Performance

PS_TF_STU_TRM_ENRL

PS_FF_STU_TRM_ENRL

Contains student enrollment information such as student credit hours, full time equivalent (FTE), cumulative number of credit hours taken toward the GPA, and number of class sections enrolled by student.

The full time equivalent (FTE) for a specific person, institution, career, or term.

The number of class sections enrolled by student.

Total student credit hours for a specific person, institution, career, or term.

External Test Scores

PS_TF_STU_TSTSCORE

PS_FF_STU_TSTSCORE

Contains information on all internal and external test scores of prospects and applicants, and contains every test score entry of a prospect/applicant for a particular test and the related components taken on a particular date, obtained from a particular data source.

There is one row of data per person, test component, test date and test data source.

The percent of undergraduate applicants who submitted SAT or ACT scores.

The number of applicants in the 25th and 75th percentile for different SAT and ACT test components.

The percent of students in the top tenth, top quarter, top half, bottom half, or bottom quarter.

Student Transfer Credit

PS_TF_TRNS_CREDIT

PS_FF_TRNS_CREDIT

Contains information on student transfer credit, transfer school, test credits, units taken, units transferred, transfer GPA, study agreement, and so forth.

—

Student Admission Application Material (Relationship table)

R_ADM_APP_MAT

(TRL_ADM_APP_MAT)

(FRL_ADM_APP_MAT)

Links Student Admission Application fact (F_ADM_APPL) with External Test Scores snapshot fact (F_STU_TSTSCORE) and External Academic Summary snapshot fact (F_EXT_ACAD_SUM).

This table must be loaded in order to link the aforementioned tables.

—

Athlete Participation

D_ATHL_PART

(TD_ ATHL_PART)

(FD_ ATHL_PART)

Contains information about athlete participation status, such as Active Participant, Recruited, and Not Recruited.

Athlete Sport

D_ATHL_SPORT

(TD_ ATHL_SPORT)

(FD_ ATHL_SPORT)

Contains available sports attributes, such as Baseball, Football, or Basketball.

Course Attributes

D_CRSE_ATTR

(TD_ CRSE_ATTR)

(FD_ CRSE_ATTR)

Contains course attributes.

Degree Checkout

D_DEGR_CHKOUT

(TD_ DEGR_CHKOUT)

(FD_ DEGR_CHKOUT)

Contains degree checkout status attributes, such as Approved, Denied, Awarded, and Pending.

Enrollment Requirement Source

D_ENR_REQ_SRC

(TD_ ENR_REQ_SRC)

(FD_ ENR_REQ_SRC)

Contains Enrollment Requirement Source attributes.

External School Type

D_EXT_SCHL_TYP

(TD_EXT_SCHL_TYP)

(FD_EXT_SCHL_TYP)

Stores various external school types such as Community College, Junior College, Vocational, University, and so forth.

Material Group

D_GEN_MATL_GRP

(TD_GEN_MATL_GRP)

(FD_GEN_MATL_GRP)

Defines material types into groups. For example, you can have one group of materials for undergraduate auditions, one for graduate test scores, and one for medical external courses.

Material Type

D_GEN_MATL_TYP

(TD_ GEN_MATL_TYP)

(FD_ GEN_MATL_TYP)

Stores various material types such as Audition, External Courses, Essay, Test Scores, Transcripts, Academic Summary, and so forth.

Grading Scheme

D_GRADE_SCH

(TD_ GRADE_SCH)

(FD_ GRADE_SCH)

Contains grading scheme attributes.

Student Housing Interest

D_HOUSNG_INTRST

(TD_HOUSNG_INRST)

(FD_HOUSNG_INRST)

Stores various housing interest types, such as Commuter, Off Campus Housing, On Campus Housing, and so forth.

Requirement Designation Grade

D_RQM_DESG_GRD

(TD_RQM_DESG_GRD)

(FD_RQM_DESG_GRD)

Contains the list of requirement designation grades associated with a course.

Requirement Designation

D_ RQMNT_DESIG

(TD_ RQMNT_DESIG)

(FD_ RQMNT_DESIG)

Contains the list of requirement designations associated with a course.

Student Attributes

D_STDNT_ATTR

(TD_ STDNT_ATTR)

(FD_ STDNT_ATTR)

Contains the list of student attributes by institution.

Transfer Credit Source Type

D_TRNFR_SRC_TYP

(TD_TRNFR_SRC_TYP)

(FD_TRNFR_SRC_TYP)

Stores the type of source from which you will be modeling transfer credit such as External, Internal and Manual.

Transcript Flag

D_TRNSCRPT_FLAG

(TD_TRNSCRPT_FLAG)

(FD_TRNSCRPT_FLAG)

Stores the various type of transcript flags such as Received, Desired, and so forth.

Transcript Level

D_TRNSCRIPT_LVL

(TD_TRNSCRIP_LVL)

(FD_TRNSCRIP_LVL)

Stores information about the transcript levels, such as Never Print, Print on Official, Print on Unofficial, Print on Student Life, Print on Degree Progress and so forth.

Transcript Status

D_TRNSCRPT_STAT

(TD_TRNSCRPT_STA)

(FD_TRNSCRPT_STA)

Stores the various transcript statuses, such as Mid-Year Report, Final, Incomplete, Work in Progress, and so forth.

Transcript Type

D_TRNSCRPT_TYPE

(TD_TRNSCRPT_TYP)

(FD_TRNSCRPT_TYP)

Stores the various types of transcripts for the institution such as official, unofficial, and so forth.

Transfer Credit Model Status

D_TRNS_MOD_STAT

(TD_TRNS_MOD_STA)

(FD_TRNS_MOD_STA)

Defines the status of the transfer credit model such as posted, unposted, evaluation, complete, submitted, and so forth.

Withdrawal Reason

D_WITHDRAW_RSN

(TD_WITHDRAW_RSN)

(FD_WITHDRAW_RSN)

Stores student withdrawal reason code, description, and related information.

Athlete Sport Participation (Relationship table)

R_ATHL_PART

(TRL_ ATHL_PART)

(FRL_ ATHL_PART)

Student Athlete sports with student participation status.

Class Attribute relate table (Relationship table)

R_CLASS_ATTR

(TRL_ CLASS_ATTR)

(FRL_ CLASS_ATTR)

Class with class attribute information.

Student Attribute relate table (Relationship table)

R_STDNT_ATTR

(TRL_ STDNT_ATTR)

(FRL_ STDNT_ATTR)

Contains information on the sport a student athlete plays and the participation status.