EIS Employee CUBE Documentation - Employee Survey.

Owned by Michael Harvey (Deactivated)
Mar 13, 2019
2 min read

Dimensions.


Cube NameDimension Unique NameDescription
Employee SurveyData Last Refreshed DateData last refresh date for Employee Survey Cubes
Employee SurveyDomainEIS Employee Domain - Contains information related to employees at the University
Employee SurveyContract Month
Employee SurveyContract Period
Employee SurveyDate Hire
Employee SurveyDate Hire Original
Employee SurveyDegree Highest Held
Employee SurveyDegree Highest Institution
Employee SurveyDegree Highest Year
Employee SurveyDegree Level Source
Employee SurveyEmployee Appointment CIP
Employee SurveyEmployee Leave Status
Employee SurveyEmployee Payplan
Employee SurveyEmployeeAppointmentDetailsKeySystem Key - Not available to users but used internally within the cubes
Employee SurveyFlag Academic
Employee SurveyFlag Adjunct
Employee SurveyFlag Faculty
Employee SurveyFlag Faculty Ranked
Employee SurveyFlag Faculty Visiting
Employee SurveyFlag Full Time
Employee SurveyFlag Graduate Asst
Employee SurveyFlag Instructional Faculty
Employee SurveyFlag Medical
Employee SurveyFlag New Hires
Employee SurveyFlag Primary Record
Employee SurveyFlag Research
Employee SurveyFlag Terminal Degree
Employee SurveyFlag Unique Record
Employee SurveyOrg Unit Dep Cost Based
Employee SurveyOrg Unit Dep Cost Based Tenure
Employee SurveyPerson Admin Code
Employee SurveyPerson Appt Status
Employee SurveyPerson Class Code
Employee SurveyPerson Marital Status
Employee SurveyPerson Rank
Employee SurveyPerson Tenure
Employee SurveyPerson Tenure CIP
Employee SurveyPosition Number
Employee SurveyDate Person Birth
Employee SurveyEmployeeDemographicsKeySystem Key - Not available to users but used internally within the cubes
Employee SurveyPerson Citizenship Status
Employee SurveyPerson Gender
Employee SurveyPerson Name
Employee SurveyPerson Name First
Employee SurveyPerson Name Last
Employee SurveyPerson Name Middle
Employee SurveyPerson Race
Employee SurveyPerson Race IPEDS
Employee SurveyPID Employee
Employee SurveyEmployee Unit College Hierarchy
Employee SurveyEmployee Unit Department Hierarchy
Employee SurveyOrg Unit Campus
Employee SurveyOrg Unit College
Employee SurveyOrg Unit Department
Employee SurveyOrg Unit Dept Cost Based
Employee SurveyMeasures
Employee SurveyFaculty Level
Employee SurveyFlag Survey Faculty OSUAAUP
Employee SurveyFlag Survey Staff IPEDS
Employee SurveySurveyGroupsKey
Employee SurveyFlag Fall
Employee SurveyTerm Academic Year Hierarchy
Employee SurveyTerm Calendar Year Hierarchy
Employee SurveyTerm Title
Employee SurveyTime Unit Term
Employee SurveyYear Academic
Employee SurveyYear Calendar
Employee SurveyYear Stu Fin Aid


FACTS/MEASURES.

Cube NameMeasure NameMeasure_DescriptionEXPRESSION
Employee SurveyFTE Employee AppointmentFTE Employee Appointment 
Employee SurveySalary Employee AppointmentSalary Employee Appointment 
Employee SurveySalary Ben BaseSalary Ben Base 
Employee SurveySalary Pay PeriodSalary Pay Period 
Employee SurveyEmployee CountCount of individual instances of appointment for each employee. 
Employee SurveyEmployee Distinct CountDistinct count of employees by person irrespective of number of appointments