As such, this dataset is useless for obtaining information about University employees. Rather, its utility is as a dataset whose temporal characteristics (e.g. period duration, correlation of period start and end dates, number of changes over time to columns other than the primary key) closely reflect an actual enterprise. This dataset might be useful in testing temporal queries and performing empirical analyses of novel temporal storage structures and access methods.
This data set consists of seven tables.
In the following, for each table we give the name of each column, its semantics and whether it has been altered to remove confidential information. Care has been taken to preserve primary key and referential integrity constraints, and to retain the temporal behavior of the original dataset, while removing all confidential information.
| SSN | A unique nine character code identifying an employee. | changed |
| LAST_NAME | The employee's last name. | changed |
| FIRST_NAME | The employee's first name. | changed |
| BIRTH_DATE | The employee's birth date. | |
| GENDER | A code identifying the gender of the employee. | changed |
| ETHNICITY | A one character code indicating the ethnic origin of the employee. | changed |
| CAMPUS_PHONE | The telephone number where the employee can be reached during business hours. | changed |
| CAMPUS_PHONE_AREA_CODE | The telephone area code of the place of work of the employee. | |
| BUILDING_NO | The code indicating what building the employee's office is located. | changed |
| ROOM_NO | The room number of the employee's office. | changed |
| PO_BOX | The post office box number of the employee's office address. | changed |
| STATE | The employee's mailing address state. | |
| ZIP | The employee's mailing address zip code. | |
| STATUS_BEGIN_DATE | The official date of the employee's most current correction/rehire or termination status and the start dates for the leave of absences. | |
| STATUS_END_DATE | This date is used for employees on leave-of-absence or who have been terminated. | |
| EMPLM_STATUS | A one character code indicating the current state of an employee`s affiliation with the University. | |
| EMPLM_TYPE | A single character code indicating the current employment category of the employee. | |
| DEPT_PAY_CHECK | The department having primary responsibility for the employee. | |
| ANNUAL_SALARY | The annualized amount expected to be paid to the employee during the current fiscal year. | changed |
| PAY_CYCLE_CODE | Indicates if an employee has opted for scheduled work/non-work periods. | |
| COUNTRY_ORIGIN | The country to which the employee is a citizen of. | changed |
| FTE | Indicating whether the employee is a full-time employee or not. It gives the number of hours worked by the employee. | |
| EVALUATION_DATE | When the employee was evaluated. | |
| DEGREE_YEAR | Calendar year of the highest degree. | |
| HIGHEST_DEGREE | Name of the degree corresponding to the highest degree. | |
| MARITAL_STATUS | The marital_status as reported by an employee. | |
| PAY_CHANGE_REASONS | Codes indicating the reason for the pay change of an employee. | |
| PROMOTION_DATE | The date when the employee received a promotion. | |
| PAY_CHANGE_DATE | When the pay was changed. | |
| EFF_TERMINATION_DATE | Effective Termination Date. |
| SSN | A unique nine character code identifying an employee. | changed |
| PCN | A six character number identifying the position. | changed |
| START_DATE | The effective start date of the assignment. | |
| END_DATE | The effective end date of the assignment. | |
| PAY_HOURLY_RATE | The rate of pay expressed as an amount per hour for each position held by the employee. | changed |
| INCUM_FTE | The percentage of full-time hours the employee will devote to a position. | |
| OBJECT_CODE | The code indicating the category of distribution of the pay associated with the position. | |
| TRACKING_CODE | Tracking code. |
| PCN | A six character code identifying the position. | changed |
| DEPT_ROSTER | The number of the department that owns the position. | changed |
| POSITION_TYPE | The code indicating the category of the position. | |
| PAY_SCHEDULE | The code indicating whether the position is salaried or waged. | |
| PAY_TERM | The code indicating whether the position is an academic or fiscal term position. | |
| JOB_TITLE_CODE1 | The code indicating the primary job code title of a position. | changed |
| JOB_TITLE_CODE2 | The code indicating the primary job code title of a position. | changed |
| JOB_TITLE_CODE3 | The code indicating the primary job code title of a position. | changed |
| JOB_TITLE_CODE4 | The code indicating the primary job code title of a position. | changed |
| JOB_TITLE_CODE5 | The code indicating the primary job code title of a position. | changed |
| POSITION_AUTH_FTE | This is the total FTE authorized for a position. | |
| STATUS | The code indicating the status of the position. | |
| ERE_CODE | The code indicating the standard ERE percentage that is charged each payperiod to accounts funding the position. | |
| OBJ_CODE | The code indicating the category for distribution of the pay associated with the position. | |
| START_DATE | This is the date when the position was established. |
| PCN | A six character number identifying a position. | changed |
| JOB_TITLE_CODE | The unique numeric code identifying a job title. | changed |
| SEQUENCE_NO | Sequence number. |
| JOB_TITLE_CODE | The unique numeric code identifying a job title. | changed |
| JOB_TITLE | The descriptive name for the job_title. | changed |
| PAY_GRADE | A two character code identifying the level at which a position is compensated. | |
| ACCEL_PAY_GRADE | Thenumber indicating that the job title is paid at a rate higher than the rate of its assigned paygrade. | |
| CLASS | A code assigned to job_titles identifying the job grouping to which they belong. | |
| EXEMPT_CODE | A code indicating whether a job title is exempt or non-exempt from overtime hours. | |
| AFFRMV_ACTION_CODE | A code for classifying job titles. | |
| STATUS | The code indicating whether the status of the job title is active or frozen. |
Any software made available via TIMECENTER
is provided "as is" and without any express or implied warranties, including,
without limitation, the implied warranty of merchantability and fitness
for a particular purpose.
The TIMECENTER icon combines two "arrows." These "arrows" are letters in the so-called Rune alphabet used one millennium ago by the Vikings, as well as by their predecessors and successors. The Rune alphabet (second phase) has 16 letters, all of which have angular shapes and lack horizontal lines because the primary storage medium was wood. Runes my also be found on jewelry, tools, and weapons and were perceived by many as having magic, hidden powers.
The two Rune arrows in the icon denote "T" and "C", respectively.
Jose Alvin G. Gendrano - Created the files for loading the data into Oracle, performed some of the sanitation, and prepared the final CD version. (jag@cs.arizona.edu)
Rachana R. Shah - Sanitized the data, wrote the HTML, worked on the CD-ROM authoring. (rachana@cs.arizona.edu)
Richard T. Snodgrass - Obtained the original data files and directed the project. (rts@cs.arizona.edu)
Jian Yang - Designed the label for the CD-ROM and create the CD-ROM. (yangjian@cs.arizona.edu)
Aug. 30, 1998 (Last Update)