Facebook pixel Data Stewardship | Pepperdine University | Pepperdine Community

Data Stewardship

Archived Data Dictionary

Click a letter to go directly to that letter's list of glossary items.

A

(back to top)

 

B

(back to top)

 

C

 

(back to top)

 

D

(back to top)

 

E

(back to top)

 

F

(back to top)

 

G

(back to top)

 

H

  •  HRS

(back to top)

 

I

(back to top)

 

J

 

(back to top)

 

K

 

(back to top)

 

L

 

(back to top)

 

M

(back to top)

 

N

(back to top)

 

O

(back to top)

 

P

(back to top)

 

Q

 

(back to top)

 

R

(back to top)

 

S

(back to top)

 

T

(back to top)

 

U

(back to top)

 

V

 

(back to top)

 

W

(back to top)

 

X

 

(back to top)

 

Y

 

(back to top)

 

Z

 

(back to top)

 

Academic Career (ua)
Academic Career is a part of the PeopleSoft Academic Structure. It is a grouping of academic work within a level of study. This also refers to a grouping of all academic work undertaken by a student that is grouped into a single student record (transcript). A diagram showing the academic structure is available here. To learn more about the academic structure please watch this video.

(back to top)

 

Academic Level (Seaver Undergraduate Only) (ua)
The classification of a student based on the total number of earned units for their academic program. This is currently only available for Seaver undergraduates. The academic level is defined as follows.

Freshman: 0-29 earned units

Sophomore: 30-59 earned units

Junior: 60-89 earned units

Senior: 90 or more earned units

(back to top)

 

Academic Load
The classification of a student based on the total number of credit hours for all courses taken during a specified semester/term.

(back to top)

 

Academic Plan (ua)

Academic Plan is part of the PeopleSoft Academic Structure. It is a course of study (i.e. major, minor, or specialization) that a student is pursuing and may earn a degree in. It is within an academic program or an academic career. A diagram showing the academic structure is available here.

(back to top)

 

Academic Program (ua)

Academic Program is part of the PeopleSoft Academic Structure. It is the program to which a student applies to and is admitted to, and from which the student graduates. A diagram showing the academic structure is available here.

(back to top)

 

Actively Enrolled (ua)

A student is Actively Enrolled if the student is Program Officially Enrolled, and remains enrolled in at least one class and has not withdrawn from it.

From PeopleSoft table PS_STDNT_ENRL, there is at least one class where STDNT_ENRL_STATUS = 'E' AND ENRL_STATUS_REASON <> ('WDRW') (Withdrawn).

(back to top)

Admit Term
The term a person applies for at a school.

(back to top)

Admit Type

A code to give Admissions additional flexibility in identifying sub-populations. Used by Admissions to identify the entering status of an applicant at the time of admission (eg. FR=Freshman, FT=Freshman Transfer, GRA=Graduate Student, TRN=Transfer, NON=Non Degree).

(back to top)

 

Admitted Count (ua)

The number of applications with a current program status of admitted (AD), pre-matriculated (PM), or active (AC).

(back to top)

 

% Admitted Enrolled (ua)
Percentage of admitted applicants who enrolled in at least one course.

(back to top)

 

% Admitted Matriculated (ua)
Percentage of admitted applicants who were matriculated.

(back to top)

 

Age Band (ua)

The range of ages for the selected students.

(back to top)


Alumni/Alumna/Alumnus
A former student who completed at least 12 units of course work at Pepperdine.

(back to top)
 
Applicant
A person who completed an admission application at any of Pepperdine's schools and programs.

(back to top)

 

Application Count (ua)
The count of distinct applications.

(back to top)

 

% Applied Admitted (ua)
Percentage of applicants who were admitted.

(back to top

 

% Applied Enrolled (ua)
Percentage of applicants who enrolled in at least one course.

(back to top)

 

% Applied Matriculated (ua)
Percentage of applicants who were matriculated.

(back to top)

 

Avg Grad GPA

Average Official High School GPA of all enrolled first time freshman students entering for a particular admit term.

(back to top)

Business Intelligence (BI)
An umbrella term for the processes and tools used for turning data into information that can be used in making decisions. Originally the term referred primarily to reporting, but today business intelligence also encompasses: ad hoc querying, online analytical processing, data mining, forecasting, and other decision support systems. Elements of a business intelligence system are: understanding customer needs and then gathering, analyzing and providing access to data. Used commercially, the term refers to software used to analyze and present data.
See About Business Intelligence for more information.

(back to top)
 

Cancelled Count (ua)
Number of applications that have received a program status of Cancelled (CN).

(back to top)


Church of Christ
A field indicating whether a student signifies themselves with a religious preference of Church of Christ.

(back to top)

 

Citizenship (ua)
The citizenship status of a student.

Alien Permanent, Alien Temporary, Canadian Citizen, Employment Visa, Native, Naturalized, Not Indicated, Other, Permanent Resident or Unknown

(back to top)

 

Credits Attempted

Total number of units taken for students who are enrolled in class.

PS_STDNT_ENRL.UNT_TAKEN if PS_STDNT_ENRL.STDNT_ENRL_STATUS = 'E', 0 otherwise

(back to top)

Data Mart
A set of data designed and constructed for decision support purposes reflecting the design principles of a data warehouse provided to serve the needs of a homogenous user group.

(back to top)

 

% Deferred (ua)
Percentage of applicants whose application was deferred.

(back to top)

 

Deferred Count (ua)
Number of applications that have received a program action of Defer Decision (DDEF) or Defer Enrollment (DEFR).

(back to top)

 

% Denied (ua)
Percentage of applicants whose application was denied.

(back to top

 

Denied Count (ua)
Count of applications that received a program action of Deny (DENY).

(back to top)

 

Dimensions
A "dimension", in terms of data analysis, is the "by" portion of a statement. For example, if you were analyzing the number of students by campus, by college, by major concentration, by credit hours, by gender, each of these qualifiers would represent a dimension. The cube allows for analyzing the data in this multi-dimensional way. The primary functions of dimensions are threefold: to provide filtering, grouping and labeling.

(back to top)


Division - Degree Major
The administrative unit that the student's conferred major is categorized into. (eg: Natural Science, Religion, Fine Arts)

(back to top)

 

Division Dept

PeopleSoft Student Admin terminology Academic Program.

(back to top)

 

Enrolled Count (ua)

Count of students with the specified admit term, who have a program status of Active (AC), have been term activated in the specified admit term, and whose Units In Progress and Units Audited are greater than 0.

(back to top)

 

Enroll Term

The term a student is enrolled in at least one course.

(back to top)

 

Entrance Grade Point Average (GPA)

Grade Point Average when entering into a program or school.

(back to top)

 

Enterprise Resource Planning (ERP)

Enterprise Resource Planning (ERP) is the name that describes a single vendor software suite that integrates Business and Finance, Human Resources and Payroll, and Student Systems applications for use across the enterprise.

See About WaveNet for more information about Pepperdine University's ERP system.

(back to top)

 

Ethnicity (ua)

The ethnicity a student signifies himself/herself as.

American Indian or Alaskan Native, Asian, Black, Hispanic, Mexican American, Pacific Islander/Hawaiian, Puerto Rican, Unknown and/or White

A student can identify himself/herself as one race or multiple races. For those students with multiple races, only one race is chosen. The order for choosing a single race is as follows:

  1. Race(s) where PRIMARY_INDICATOR = 'Y'
  2. "Hispanic" values (i.e. ETHNIC_GRP_CD = 03 - Hispanic)
  3. By alphabetical order of ETHNIC_GRP_CD

01 - White
02 - Black
03 - Hispanic
04 - Asian
05 - American Indian or Alaskan Native
06 - Pacific Islander/Hawaiian
07 - Puerto Rican
08 - Mexican American
09 - Unknown

(back to top)

 

Extract, Transform and Load (ETL)

A set of software applications that can be programmed to read and copy data from source computer files into a data staging area for further work (extract), modify, clean or reorganize the data (transform) and move it into an Enterprise Data Warehouse in either a bulk or an incremental fashion (load).

(back to top)

 

FERPA

FERPA, or the Family Educational Rights and Privacy Act of 1974, is a part of the Educational Amendments of 1974, P.L. 93-380 that became effective November 19, 1974. A number of amendments were signed into law on December 31, 1974 and draft guidelines were issued by HEW on January 6, 1975. This act provides that federal funding will be withheld from any higher educational institution which denies a student the right to inspect and challenge the content of the student's cumulative record. In addition, the act imposes substantial restrictions upon access by others to a student's record without the student's written consent.

See the U.S. Dept of Ed for more information.

(back to top)

 

Gender (ua)

Male or Female.

(back to top)

 

Graduate Management Admission Test (GMAT)

GMAT is a standardized, computer-based assessment managed by the Graduate Management Admission Council (GMAC). According to GMAC the goal of the GMAT is to help business schools select qualified applicants. GMAT structure and scoring information is available on the GMAT website.

(back to top)

 

GMAT Analytical Writing Assessment (ANLY)

Test section, analytical writing assessment, focusing an analysis of an argument, with 1 topic question.

(back to top)

 

GMAT Quantitative Section (QUAN)

Test section, Quantitative, data sufficiency problem solving, with 37 questions.

(back to top)

 

GMAT TOT

Total scores for Analytical Writing Assessment, Quantitative and Verbal sections of GMAT

(back to top)

 

GMAT Verbal (VERB)

Test section, Verbal, Reading comprehension, critical reasoning, and sentence correction, with 41 questions.

(back to top)

 

Grad Count

Number of students from selected admit term who graduated as of the date of the last run of the cube.

(back to top)

 

Grad Count %

Percentage of enrolled first time freshman in a particular admit term (student count) who graduated (= Grad Count by Yrs to Grad / Total Student Count).

(back to top)

 

Grade Point Average (GPA)

The semester grade point average (GPA) is the sum of all grade points earned in a semester or term divided by all credit hours attempted for letter grade. Credit hours in courses in which marks of I, W, WM, WP or WW were assigned are excluded. The cumulative grade point average is the average of all grades earned at Pepperdine.

(back to top)

 

GRE

The Graduate Record Examination (GRE) is administered by the Educational Testing Service. The GRE is a test score that is required by the Graduate School of Education and Psychology for application.

(back to top)

 

GRE Analytical Reasoning - ANLYR

GRE Test Component used prior to October 1, 2002. The score range is 200-800. "ANLYR" code used by PeopleSoft to signify scores recorded prior to October 1, 2002.

(back to top)

 

GRE Analytical Writing - ANLY

GRE Test Component used after October 1, 2002. The score range is 0-6. "ANLY" code used by PeopleSoft to signify scores recorded after October 1, 2002.

(back to top)

 

GRE Principles and Practice of Engineering (PE)

The GRE Principles and Practice of Engineering (PE) exam. The PE Exam is created and scored by the National Council of Examiners for Engineering and Surveying (NCEES).*

(back to top)

 

GRE Quantitative (QUAN)

GRE Test Component used prior to August 1, 2011. The score range is 200-800. "QUAN" code used by PeopleSoft to signify scores recorded prior to October 1, 2002.

(back to top)

 

GRE Quantitative (QUANT)

GRE Test Component used after August 1, 2011. The score range is 130-170. "QUANT" code used by PeopleSoft to signify scores recorded after October 1, 2002.

(back to top)

 

GRE Verbal (VERB)

GRE Test Component used prior to August 1, 2011. The score range is 200-800. "VERB" code used by PeopleSoft to signify scores recorded prior to October 1, 2002.

(back to top)

 

GRE Verbal (VERBL)

GRE Test Component used after August 1, 2011. The score range is 130-170. "VERBL" code used by PeopleSoft to signify scores recorded after October 1, 2002.

(back to top)

 

GRE Writing (WRIT)

Insert definition here.

(back to top)

 

GRE TOT

Insert definition here.

(back to top)

 

IPEDS Ethnicity

See IPEDS Ethnicity

(back to top)

 

IPEDS Load

IPEDS Load : Refers to students' part-time or full-time status.

(back to top)

 

Major

PeopleSoft Student Admin terminology Academic Plan.

(back to top)

 

Matriculated Count (ua)

Number of applications with a current program action of Active (AC).

(back to top)

 

Matriculated Student

A matriculated student is one who has applied and has been officially accepted to the university through an admission process and is considered to be pursuing a degree or an academic certificate which appears on the official transcript. The matriculated student will be considered active in a particular academic program.

Students are generally matriculated into their programs prior to their Admit Term in order to allow for enrollment in that term.

(back to top)

 

Measures
A "measure" or "fact" is simply the item being counted by the cube. For example, the "number of students" is the measure or fact being analyzed by the cube.

(back to top)

 

Need Based Student

A student whose expected family contribution (EFC from the ISIR) is less than their cost of attendance.

(back to top)

 

Officially Enrolled
Count of students for the specified term(s), who have a program status of Active (AC), have been term activated in the specified term, and who are enrolled in at least one class. This count also includes students who may have withdrawn from classes. Includes Actively Enrolled or Withdrawn with Enrollment counts.

From table ps_stdnt_enrl, status = 'E' (Enrolled).

(back to top)

 

OLAP Cube

OLAP is an acronym for Online Analytical Processing. A "cube" or data cube is an advanced tool for data analysis that provides fast and easy data manipulation from multiple perspectives. The cube provides a visual representation of a three-dimensional data structure. However, the true nature of a data cube is multi-dimensional; it is not limited to three dimensions.

A "dimension", in terms of data analysis, is the "by" portion of a statement. For example, if you were analyzing the number of students by campus, by college, by major concentration, by credit hours, by gender, each of these qualifiers would represent a dimension. The cube allows for analyzing the data in this multi-dimensional way.

A "measure" or "fact" is simply the item being counted by the cube. Using the previous example, the "number of students" is the measure or fact being analyzed by the cube.

(back to top)

 

PeopleSoft

PeopleSoft is the Enterprise Resource Planning (ERP) system selected by Pepperdine University to integrate and manage its student, financial and human resources systems applications.

PeopleSoft Finance (FSM) was implemented in 2006
PeopleSoft Portal (WaveNet) was implemented in 2006
PeopleSoft HR (HCM) was implemented in 2007
PeopleSoft Student Administration (CS) was implemented in 2008

See About WaveNet for more information about Pepperdine University's PeopleSoft ERP system.

(back to top)

 

Pre-Matriculant Count (ua)

Number of applications with a current program status of prematriculant (PM). The applicant is assumed to have an application (AP) then been admitted (AD), prior to this prematriculant status. Generally the status of prematriculant signifies an applicant who has paid a deposit. The status of prematriculant (PM) does not necessarily apply to all applicants.

(back to top)

 

Program Active Units Taken Term (ua)

The number of units taken for classes in which students remain enrolled in.

From PeopleSoft table PS_STDNT_ENRL, STDNT_ENRL_STATUS = 'E' AND ENRL_STATUS_REASON IN ('ENRL','EWAT').

(back to top)

 

Program Officially Enrolled Count (ua)

A count of students for the specified term(s) who:

  1. Have a program status of Active (AC) at or before the start of the term;
  2. Have been term activated in the specified term(s); and
  3. Are enrolled in at least one class (STDNT_ENRL_STATUS = 'E'), regardless of whether they remained enrolled in the class or withdrew from it.

(back to top)

 

Program Primacy Indicator (ua)

An indicator specifying whether a program is Primary or Secondary. All students will have a primary program. Only dual degree students will have a primary and secondary program. The Primary Program for a student is the program for which the student was last term activated for.

(back to top)

 

Program Status (ua)

The status of a student within their academic program for the selected term. If the status changes various times for a student, the most recent status within the term (i.e. the status with the most recent date on or before the term end date) will be pulled into the report.

(back to top)

 

Program Withdrawn Units Taken Term (ua)

The number of units taken for classes in which students withdrew from.

From PeopleSoft table PS_STDNT_ENRL, STDNT_ENRL_STATUS = 'E' AND ENRL_STATUS_REASON IN ('WDRW').

(back to top)

 

Religious Preference (ua)

The religious preference a student signifies himself/herself with.

(back to top)

 

School (ua)

Associated to the five schools of Pepperdine (GSBM, GSEP, SOL, SPP or Seaver).

(back to top)

 

Service Indicators (ua)

PeopleSoft Service Indicators enables each school to provide or limit access to services at the University for students. Service Indicators can be negative (i.e. holds that prevent a students from registering for classes or obtaining their transcripts) or positive (i.e. classifications of students - international students, NCAA athletes, dual degree students, employees, etc.). All service indicators must be maintained by the office/school assigning the indicator to the student's record in PeopleSoft.

(back to top)

 

SIS

Pepperdine University's student information system from 1986-2008.

(back to top)

 

Slice and Dice

The capability to quickly and easily view data along multiple dimensions. The most commonly utilized feature of OLAP applications.

(back to top)

 

Structured Query Language (SQL)

Structured Query Language (SQL) is the internationally accepted standard for relational systems, covering not only query but also data definition, manipulation, security and some aspects of referential integrity. Oracle, 1998.

(back to top)

 

Student

A matriculated student who is enrolled for a Pepperdine course in a specified term where the credit hours are greater than 0. The enrolled student will not have a 'W' (withdraw) grade or have dropped from the course at the time of the report. They can either be matriculated in a degree or non-degree program.

(back to top)

 

Student Attributes (ua)

Characteristics assigned to students based on their academic career and academic program. There are various student attributes, but the most commonly used attributes are Location (SITE) and Preferred Location (LOCP).

Location (SITE): Attribute used by Graziadio and GSEP to indicate the location where a student attends classes each term.

Preferred Location (LOCP): Attribute used by Graziadio to indicate a student's preferred class location. Graziadio generally uses this field for class schedule planning.

Student Location (LOC): In Summer 2013, Graziadio stopped using the LOC attribute.

(back to top)

 

Student Count (measure)

Aggregate number of enrolled students based on chosen dimension.

(back to top)

 

Student Groups (ua)

PeopleSoft Student Groups enables each school to track students based on a group or classification they belong to (i.e. Faculty/Staff, Athlete, International Program participant, GSBM cohorts, etc.). PeopleSoft Student Groups are often used to help in registration and assignment of student tuition within the PeopleSoft Campus Solutions system. All student groups must be maintained by the office/school assigning the group to the student's record in PeopleSoft.

(back to top)

 

Term (ua)

There are three terms within the Pepperdine academic year, consisting of one or more sessions. In general, the Fall term goes from August-December, the Spring term goes from January-April/May, Summer term goes from April/May-August. Prior to 2008, a Winter term was also used to signify the first week in January. However, after 2008, these two weeks are designated as a session within the Spring term.

(back to top)

 

Term Activation (ua)

The process of activating a student for a term which allows for:

  1. Enrollment into classes;
  2. Posting transfer credit; and
  3. Tuition calculation.

(back to top)

 

Term Enrolled Indicator (ua)

An indicator providing the enrollment status of a student for the selected term(s). A student can be classified as Actively Enrolled or Withdrawn with Enrollment.

A student is Actively Enrolled if the student is Program Officially Enrolled, and remains enrolled in at least one class and has not withdrawn from it.

From PeopleSoft table PS_STDNT_ENRL, there is at least one class where STDNT_ENRL_STATUS = 'E' AND ENRL_STATUS_REASON <> ('WDRW') (Withdrawn).

A student is Withdrawn with Enrollment if the student is Program Officially Enrolled, and withdrew from all classes.

From PeopleSoft table PS_STDNT_ENRL, all classes have STDNT_ENRL_STATUS = 'E' AND ENRL_STATUS_REASON IN ('WDRW') (Withdrawn).

(back to top)

 

Unmet Need

Need based students who also have an "unmet need" amount > $0.  The unmet need students are students that are eligible for need based aid but their financial aid award does not include as much need based aid as the FAFSA says they are eligible for.

(back to top)

 

% Withdrawn (ua)

Percentage of applicants whose application was withdrawn.

(back to top)

 

Withdrawn Count (ua)

Count of applications that have received a program action of Administrative Withdrawal (WADM) or Applicant Withdrawal (WAPP).

(back to top)

 

Waitlisted Count (ua)

Number of applications with a current program status of Waitlisted (WT) and a program action of Data Change (DATA), Defer Decision (DDEF), Plan Change (PLNC), Waitlist, (WT), or Waitlist Offer (WAOF).

(back to top)

 

Withdrawn with Enrollment (ua)

A student is Withdrawn with Enrollment if the student is Program Officially Enrolled, and withdrew from all classes.

From PeopleSoft table PS_STDNT_ENRL, all classes have STDNT_ENRL_STATUS = 'E' AND ENRL_STATUS_REASON IN ('WDRW') (Withdrawn).

(back to top)