...
| Cube Name | Dimension Unique Name | Description |
|---|---|---|
| PersonActivity | Activity Type | Identfies the various types of workload activities |
| Activity | Activity Type Group | Grouping the workload activities by Course vs Instruction Related vs Non-Instruction Related vs Sponsored |
| Activity | Activity Type Hierarchy | Hierarchy showing the workload activity grouping along with the various activities associated with them |
| Activity | Activity Type Title | Workload activity title |
| Activity | Flag Org Unit Academic | Identifies if the workload activity unit is an academic unit |
| Activity | Org College Hierarchy | Organizational hierarchy showing campus and all the colleges under that campus |
| Activity | Org Department Hierarchy | Organizational hierarchy showing campus and all the colleges under that campus and further all departments under each college |
| Activity | Org Unit Campus | Campus that is funding the workload activity |
| Activity | Org Unit Campus Budget Report Code | Campus used for budget reporting |
| Activity | Org Unit College | College that is funding the workload activity |
| Activity | Org Unit Department | Department that is fundind the workload activity |
| Activity | Org Unit Dept CIP | Primary CIP associated with the department that is funding the workload activity |
| Activity | Org Unit Dept Cost Based | Key Field |
| Activity | Activity Org Unit | Key Field |
| Activity | Course CIP | Primary CIP associated with the course |
| Activity | Course CIP Title | Primary CIP title associated with the course |
| Activity | Course Delivery Method | A classification of a course based on the delivery of direct instruction. Full Distance Learning Course. Full Distance Learning Course - 100% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space, or both. All special course components (exams, internships, practica, clinicals, labs, etc) that cannot be completed online can be completed off-campus.Primarily Classroom Course - Primarily Classroom Course - Less than 50% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both. This designation can include activities that do not occur in a classroom (ie, labs, internships, practica, clinicals, labs, etc).Hybrid Course - 50-79% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both.Primarily Distance Learning Course - 80-99% of the direc |
| Activity | Course Enrollment | Total number of students enrolled in the course |
| Activity | Course Identifier | Course identifier in the format CoursePrefix CourseNumber CourseSection |
| Activity | Course Instruction Type | Identifies nature of the course as Individual vs Organized vs Other Or if it is non course |
| Activity | Course Instruction Type Level | Identifies the nature of the course section as Individual Dissertaion vs Other vs Thesis vs Organized OR if it’s a Non course |
| Activity | Course Level | Identifies the level of the course as Upper vs Lower vs Grad I vs Grad II |
| Activity | Course Level Group | Course level identified as undegraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000 |
| Activity | Course Level Group Sort | Sort order for course level group |
| Activity | Course Level Sort | Sort order for course level |
| Activity | Course Section Type | The means by which instruction is predominantly delivered for this course section as reported on the Student Data Course File. |
| Activity | Course Site | The official number or other identifier that serves to uniquely identify the site within the university. |
| Activity | Course Site Address | Address of the site where the course if offered. |
| Activity | Course Site County | County of the site where the course is being offered. |
| Activity | Flag Cost Share | Identifies if the activity is a Cost Share activity |
| Activity | Flag Course | Identifies if the activity is a course |
| Activity | Flag FKL | Identifies general education courses. Also called foundation of knowledge and learning courses. |
| Activity | Funding Source | A code to indicate the budget entity of the department offering the course section. |
| Activity | Term Activity | Term associated with the activity |
| Activity | Workload Activity ID | Key Field |
| Activity | Workload Activity Title | Workload Activity Title |
| Activity | Contract Month | Shows the number of months in the appointment contract period |
| Activity | 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 |
| Activity | 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. |
| Activity | Employee Payplan Rank Group | Custom group showing payplan and ranks |
| Activity | Faculty Level | |
| Activity | Flag Adjunct | Identifies if an appointment is an Adjunct |
| Activity | Flag Faculty | Identifies if an appointment is a Faculty |
| Activity | Flag Faculty Ranked | Identifies if an appointment is a ranked faculty |
| Activity | 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 |
| Activity | Flag Faculty Tenured | Identifies if an appointment is a tenured faculty |
| Activity | Flag Faculty Visiting | Identifies if an appointment is a visiting faculty |
| Activity | Flag Faculty09 Month | Identifies if an appointment is a faculty member on a 9 month contract |
| Activity | Flag Faculty12 Month | Identifies if an appointmen is a faculty member on a 12 month /annual contract |
| Activity | Flag Full Time | Identifies full time appointments |
| Activity | Flag Graduate Asst | Identifies if an appointment is a Graduate Assistant |
| Activity | Flag In Unit | Identifies in-unit appointments |
| Activity | Flag Instructional Faculty | Identifies if an appointment is an instructional faculty |
| Activity | Flag Primary Inst Rsh | Identifies if an appointment is primarily involved in an instructional or research capacity |
| Activity | Flag Primary Record | Identifies the primary record of appointment for employees who have multiple appointments |
| Activity | Flag Research Faculty | Identifies if the appointment is a faculty member who is primarily involved in a research capacity |
| Activity | Flag Teaching Courses | Identifies if the appointment is involved with teaching courses |
| Activity | Flag Terminal Degree | Identifies if the highest degree associated with the employee appointment is a terminal degree |
| Activity | Org Unit Dep Cost Based | Key Field |
| Activity | Person Admin Code | Identifies the administrative code associated with the appointment in GEMS |
| Activity | Person Appt Status | Identifies the status of the appointment in GEMS |
| Activity | 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. |
| Activity | Person Name | Name |
| Activity | Person Rank | Rank |
| Activity | Person Rank Sort | Rank Sort Order |
| Activity | PID Employee | UID of employee |
| Activity | Primary Contract Period | Indicates the contract period to which the employee is appointed |
| Activity | Faculty Group Budget | Custom Group |
| Activity | Faculty Group Detail | Custom Group |
| Activity | Faculty Group Rank | Custom Group |
| Activity | Faculty Group Rank Detail | Custom Group |
| Activity | Faculty Group Tenure | Custom Group |
| Activity | Faculty Level | Custom Group |
| Activity | Faculty Level Sort | Custom Group |
| Activity | Faculty Level Title | Custom Group |
| Activity | Group Employees Compact | Custom Group |
| Activity | Group Inst Cost Faculty Position | Custom Group |
| Activity | Group Inst Cost Inst Staff | Custom Group |
| Activity | Group Inst Cost Ten Earn | Custom Group |
| Activity | Group Instructional Staff | Custom Group |
| Activity | Flag Fall | Identifies Fall Terms |
| Activity | Flag Fall Spring | Identifies Spring or Fall Term |
| Activity | Flag Summer Fall | Identifies Fall or Summer Term |
| Activity | Term | Term |
| Activity | Term Academic Year Hierarchy | Shows hierarchy of academic year terms. Each academic year comprises of Summer, Fall and the following Spring |
| Activity | Term Calendar Year Hierarchy | Shows hierarchy of calendar year terms. Each calendar year comprises of Spring , Summer & Fall of the particular year |
| Activity | Term Title | Term Title |
| Activity | Year Academic | Academic Year |
| Activity | Year Calendar | Calendar Year |
| Activity | Year Stu Fin Aid | Financial Aid Year - Comprises of Fall, following Spring and following Summer term |
| Activity | Flag Org Unit Academic | Identifies an academic unit |
| Activity | Org College Hierarchy | Organizational hierarchy showing campus and all the colleges under that campus |
| Activity | Org Department Hierarchy | Organizational hierarchy showing campus and all the colleges under that campus and further all departments under each college |
| Activity | Org Unit Campus | Campus |
| Activity | Org Unit Campus Budget Report Code | Campus used for budget reporting |
| Activity | Org Unit College | Campus Sort |
| Activity | Org Unit Department | College |
| Activity | Org Unit Dept CIP | Department |
| Activity | Org Unit Dept Cost Based | Key Field |
FACTS/MEASURES.
| Cube Name | Measure Name | Description | ExpressionEXPRESSION | 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
|---|---|---|---|
| PersonActivity | Workload Activity 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 |
| FTE associated with the particular activity | |||
| Activity | Amount Activity Cost | Cost associated with the particular workload activity | |
| Activity | Workload Portion Of Section | Portion of section of workload as associated with the particular workload activity | |
| Activity | Workload Activity Person Year | Person years as counted towards the particular workload activity | |
| Activity | Credit Hours Gross Workload | Gross credit hours for a course activity | |
| Activity | Credit Hours Fundable Workload | Fundable credit hours for a course activity | |
| Activity | Credit Hours Doctoral Gross Effort | Gross credit hours for a doctoral course activity | |
| Activity | 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 |
| Activity | Count Workload | ||
| Activity | Distinct count of employees | Person | Workload Person Year Dept Research | Person years associated with departmental research type activities | Person
| Count of workload activities | |||
| Activity | Credit Hours | ||
| Grad2 Workload | Person | Salary With Benefits Total | Total salary with benefits | Person | Salary Without Benefits Total | Total Salary without benefits
| 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 |
| Credit hours towards Grad 2 type course activity | |||
| Activity | Credit Hours Grad1 Workload | Credit hours towards Grad 1 type course activity | |
| Activity | Workload Activity Count | Count of workload activities | |
| Activity | Count Employee Distinct | Distinct count of employees |