EIS Workload CUBE Documentation - Person.

Dimensions.

Cube Name	Dimension Unique Name	Description
Person	Contract Month	Shows the number of months in the appointment contract period
Person	Contract Period	Shows the contract period for which the employee has been appointed. Values include 9M- 9 month, B & E- Biweekly, H - Hourly, I - 12 month , U1 - Sem 1 contract period, U2 - Sem 2 contract period, UA - Summer A , UB - Summer B, UC - Summer C
Person	Employee Payplan	Identifies the Pay Plan code which formally describes and governs the policy, methods, procedures, and salary schedule for compensating employees for work performed. Employees are eligible for benefits and deductions based on the salary administration plan code.
Person	Employee Payplan Rank Group	Custom group showing payplan and ranks
Person	Faculty Level
Person	Flag Adjunct	Identifies if an appointment is an Adjunct
Person	Flag Faculty	Identifies if an appointment is a Faculty
Person	Flag Faculty Ranked	Identifies if an appointment is a ranked faculty
Person	Flag Faculty Tenure Or Tenure Earning	Identifies if an appointment is a faculty member who is either already Tenured or is on a Tenure Track
Person	Flag Faculty Tenured	Identifies if an appointment is a tenured faculty
Person	Flag Faculty Visiting	Identifies if an appointment is a visiting faculty
Person	Flag Faculty09 Month	Identifies if an appointment is a faculty member on a 9 month contract
Person	Flag Faculty12 Month	Identifies if an appointmen is a faculty member on a 12 month /annual contract
Person	Flag Full Time	Identifies full time appointments
Person	Flag Graduate Asst	Identifies if an appointment is a Graduate Assistant
Person	Flag In Unit	Identifies in-unit appointments
Person	Flag Instructional Faculty	Identifies if an appointment is an instructional faculty
Person	Flag Primary Inst Rsh	Identifies if an appointment is primarily involved in an instructional or research capacity
Person	Flag Primary Record	Identifies the primary record of appointment for employees who have multiple appointments
Person	Flag Research Faculty	Identifies if the appointment is a faculty member who is primarily involved in a research capacity
Person	Flag Teaching Courses	Identifies if the appointment is involved with teaching courses
Person	Flag Terminal Degree	Identifies if the highest degree associated with the employee appointment is a terminal degree
Person	Org Unit Dep Cost Based	Key Field
Person	Person Admin Code	Identifies the administrative code associated with the appointment in GEMS
Person	Person Appt Status	Identifies the status of the appointment in GEMS
Person	Person Class Code	Job Code known as Classification or Class Code. Each classification or job title is assigned a unique four-digit, numerical Job Code.
Person	Person Name	Name
Person	Person Rank	Rank
Person	Person Rank Sort	Rank Sort Order
Person	PID Employee	UID of employee
Person	Primary Contract Period	Indicates the contract period to which the employee is appointed
Person	Faculty Group Budget	Custom Group
Person	Faculty Group Detail	Custom Group
Person	Faculty Group Rank	Custom Group
Person	Faculty Group Rank Detail	Custom Group
Person	Faculty Group Tenure	Custom Group
Person	Faculty Level	Custom Group
Person	Faculty Level Sort	Custom Group
Person	Faculty Level Title	Custom Group
Person	Group Employees Compact	Custom Group
Person	Group Inst Cost Faculty Position	Custom Group
Person	Group Inst Cost Inst Staff	Custom Group
Person	Group Inst Cost Ten Earn	Custom Group
Person	Group Instructional Staff	Custom Group
Person	Flag Fall	Identifies Fall Terms
Person	Flag Fall Spring	Identifies Spring or Fall Term
Person	Flag Summer Fall	Identifies Fall or Summer Term
Person	Term	Term
Person	Term Academic Year Hierarchy	Shows hierarchy of academic year terms. Each academic year comprises of Summer, Fall and the following Spring
Person	Term Calendar Year Hierarchy	Shows hierarchy of calendar year terms. Each calendar year comprises of Spring , Summer & Fall of the particular year
Person	Term Title	Term Title
Person	Year Academic	Academic Year
Person	Year Calendar	Calendar Year
Person	Year Stu Fin Aid	Financial Aid Year - Comprises of Fall, following Spring and following Summer term
Person	Flag Org Unit Academic	Identifies an academic unit
Person	Org College Hierarchy	Organizational hierarchy showing campus and all the colleges under that campus
Person	Org Department Hierarchy	Organizational hierarchy showing campus and all the colleges under that campus and further all departments under each college
Person	Org Unit Campus	Campus
Person	Org Unit Campus Budget Report Code	Campus used for budget reporting
Person	Org Unit College	Campus Sort
Person	Org Unit Department	College
Person	Org Unit Dept CIP	Department
Person	Org Unit Dept Cost Based	Key Field

FACTS/MEASURES.

Cube Name	Measure Name	Description
Person	FTE Employee	Full Time Equivalent (FTE) at which the employee is appointed
Person	Salary Total	Shows the total salary of the employee including base and benefits
Person	Salary Normalize9 Mth FT No Stipend	Salary that has been normalized to show the equivalent for a 9 month full time appointment excluding stipends
Person	Salary Compare Full Time	Salary prorated to a full time appointment in case the employee is a part time employee
Person	Salary Ben Base	Employee salary comprising of only base + benefits
Person	Salary Stipend Total	Stipends earned by employee
Person	Salary Primary Contract Period
Person	Salary Pay Period	Salary component for each payperiod including benefits and base but excluding stipends
Person	Salary Effort Rept Pay Period	Salary component for each payperiod including benefits and base but excluding stipends that is counted towards effort reporting
Person	Salary Term Appt Based	Salary component totals for each term
Person	FTE Term Appt Based	Total FTE for the term based on the appointment of the employee
Person	Workload Person FTE	FTE of appointment as counted towards their workload activities
Person	Workload Person Year	Person years as counted towards their workload activities
Person	Amount Activity Cost	Cost associated with the particular workload activity
Person	Workload Portion Of Section	Portion of section of workload as associated with the particular workload activity
Person	Credit Hours Gross Workload	Gross credit hours for a course activity
Person	Credit Hours Fundable Workload	Fundable credit hours for a course activity
Person	Credit Hours Doctoral Gross Effort	Gross credit hours for a doctoral course activity
Person	Credit Hours Doctoral Fundable Effort	Fundable credit hours for a doctoral course activity
Person	Salary Without Benefits EG	Salary portion without benefits as funded by an Education and General funding source
Person	Count Workload Person Distinct	Distinct count of employees
Person	Workload Person Year Dept Research	Person years associated with departmental research type activities
Person	Credit Hours Fundable Workload Grad	Fundable credit hours associated with a graduate level course activity
Person	Salary With Benefits Other	Total salary with benefits as funded by other funding sources
Person	FTE CG	FTE associated with appointment associated with a Contract and Grant funding source
Person	Workload Person Year Non Course	Person years associated with non course related activities
Person	Amount Activity Cost Dept Research	Cost associated with departmental research activities
Person	Salary Without Benefits Other	Total salary without benefits as funded by other funding sources
Person	Credit Hours Fundable Workload Under Grad	Fundable credit hours associated with undergraduate level course activities
Person	FTE EG	FTE associated with appointment associated with a Education and General funding source
Person	Workload Portion Of Section Organized	Portion of section of workload as associated with organized workload activity
Person	Salary With Benefits CG	Total salary without benefits as funded by C& G funding source
Person	Workload Person Year Course	Person years associated with courses activities
Person	Salary With Benefits EG	Total salary with benefits as funded by E&G funding source
Person	Salary Without Benefits CG	Total salary without benefits as funded by C&G funding source
Person	FTE Other	FTE associated with appointment associated with other funding source
Person	Amount Fiscal Year Exp Research	Research expenditure for the fiscal year
Person	Salary With Benefits Total	Total salary with benefits
Person	Salary Without Benefits Total	Total Salary without benefits