Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Dimensions.

Cube NameDimension Unique NameDescription
PersonContract MonthShows the number of months in the appointment contract period
PersonContract PeriodShows 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
PersonEmployee PayplanIdentifies 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.
PersonEmployee Payplan Rank GroupCustom group showing payplan and ranks
PersonFaculty Level
PersonFlag AdjunctIdentifies if an appointment is an Adjunct
PersonFlag FacultyIdentifies if an appointment is a Faculty
PersonFlag Faculty RankedIdentifies if an appointment is a ranked faculty 
PersonFlag Faculty Tenure Or Tenure EarningIdentifies if an appointment is a faculty member who is either already Tenured or is on a Tenure Track
PersonFlag Faculty TenuredIdentifies if an appointment is a tenured faculty
PersonFlag Faculty VisitingIdentifies if an appointment is a visiting faculty
PersonFlag Faculty09 MonthIdentifies if an appointment is a faculty member on a 9 month contract
PersonFlag Faculty12 MonthIdentifies if an appointmen is a faculty member on a 12 month /annual contract
PersonFlag Full TimeIdentifies full time appointments
PersonFlag Graduate AsstIdentifies if an appointment is a Graduate Assistant
PersonFlag In UnitIdentifies in-unit appointments
PersonFlag Instructional FacultyIdentifies if an appointment is an instructional faculty
PersonFlag Primary Inst RshIdentifies if an appointment is primarily involved in an  instructional or research capacity
PersonFlag Primary RecordIdentifies the primary record of appointment for employees who have multiple appointments
PersonFlag Research FacultyIdentifies if the appointment is a faculty member who is primarily involved in a research capacity
PersonFlag Teaching CoursesIdentifies if the appointment is involved with teaching courses
PersonFlag Terminal DegreeIdentifies if the highest degree associated with the employee appointment is a terminal degree
PersonOrg Unit Dep Cost BasedKey Field
PersonPerson Admin CodeIdentifies the administrative code associated with the appointment in GEMS
PersonPerson Appt StatusIdentifies the status of the appointment in GEMS
PersonPerson Class CodeJob Code known as Classification or Class Code. Each classification or job title is assigned a unique four-digit, numerical Job Code.
PersonPerson NameName
PersonPerson RankRank
PersonPerson Rank SortRank Sort Order
PersonPID EmployeeUID of employee
PersonPrimary Contract PeriodIndicates the contract period to which the employee is appointed
PersonFaculty Group BudgetCustom Group
PersonFaculty Group DetailCustom Group
PersonFaculty Group RankCustom Group
PersonFaculty Group Rank DetailCustom Group
PersonFaculty Group TenureCustom Group
PersonFaculty LevelCustom Group
PersonFaculty Level SortCustom Group
PersonFaculty Level TitleCustom Group
PersonGroup Employees CompactCustom Group
PersonGroup Inst Cost Faculty PositionCustom Group
PersonGroup Inst Cost Inst StaffCustom Group
PersonGroup Inst Cost Ten EarnCustom Group
PersonGroup Instructional StaffCustom Group
PersonFlag FallIdentifies Fall Terms
PersonFlag Fall SpringIdentifies Spring or Fall Term
PersonFlag Summer FallIdentifies Fall or Summer Term
PersonTermTerm
PersonTerm Academic Year HierarchyShows hierarchy of academic year terms. Each academic year comprises of Summer, Fall and the following Spring
PersonTerm Calendar Year HierarchyShows hierarchy of calendar year terms. Each calendar year comprises of Spring , Summer &  Fall of the particular year
PersonTerm TitleTerm Title
PersonYear AcademicAcademic Year
PersonYear CalendarCalendar Year
PersonYear Stu Fin AidFinancial Aid Year - Comprises of Fall, following Spring and following Summer term 
PersonFlag Org Unit AcademicIdentifies an academic unit
PersonOrg College HierarchyOrganizational hierarchy showing campus and all the colleges under that campus
PersonOrg Department HierarchyOrganizational hierarchy showing campus and all the colleges under that campus and further all departments under each college
PersonOrg Unit CampusCampus
PersonOrg Unit Campus Budget Report CodeCampus used for budget reporting
PersonOrg Unit CollegeCampus Sort
PersonOrg Unit DepartmentCollege
PersonOrg Unit Dept CIPDepartment
PersonOrg Unit Dept Cost BasedKey Field

...