Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse APPOINTMENT LIMITED Table


*Old Personnel Data in CYBORG* - Contains current appointment data without salary information for all employees. A record of personnel actions, including salary reviews, terminations, hires, transfers, etc.


Field Name

Description

Data Type

Length

APPOINTMENT_END_DATE

This field is used in several HR tables. In HR_PERSON_EMPLOYEE and HR_PERSON_EMPLOYEE_LIMITED, it is the latest last date or expected last date of the person's appointments. If there are no appointment records for the person in SAP HR, this date is set to LAST_TERM_DATE (termination date). In HR_APPOINTMENT_DETAIL and HR_APPT_TX_DETAIL, it is the end date of an uninterrupted appointment to a specific MIT position. Changes to the appointment, such as salary increases, one-time payments, changes in effort etc. do not affect this date, but are reflected in appointment transactions: APPT_TX_BEGIN_DATE and APPT_TX_END_DATE in HR_APPT_TX_DETAIL.
In GRADUATE_AWARD_APPOINTMENT, this is the end date of an assigned graduate appointment/award.

DATE

8

APPOINTMENT_START_DATE

The start date of an appointment to a specific MIT position. (See also TRANSACTION_START_DATE: Changes to a parrticular appointment, such as salary increases, leaves, change in effort, etc. are reflected by TRANSACTION_START_DATES and TRANSACTION_END_DATES).
In GRADUATE_AWARD_APPOINTMENT, this is the begin date for an assigned graduate appointment/award (ie. a RA, TA, or FE).

DATE

8

APPOINTMENT_TYPE

In the various APPOINTMENT tables (ie, MIT Employees): For Faculty, identifies whether they have a 9-, 10-, 11-, or 12-month appointment. This information is used to position faculty members with their peers in salary reviews; also determines whether they are eligible to receive summer salary (1, 2, or 3 months). For other MIT employees, specifies whether the appointment is Regular, Term (= has a specified end date), Temporary (normally of more than 2 and less than 12 months duration), or Summer only. In the GRADUATE AWARD tables, specifies the type of Graduate Student Appointment: RA, TA, etc. In the KRB_PERSON table, indicates whether the appointment is Primary or Secondary.

VARCHAR2

30

DEPARTMENT_ID

The 6-digit Institute-assigned identification number of a department, school, center, or lab. (Equivalent to the Profit Center ID in financial reports, but without the initial uppercase P.)

VARCHAR2

6

DEPARTMENT_NAME

The name of the department, school, center, or lab.

VARCHAR2

50

DOL_JOB_GROUP

Department of Labor job group classification. Because this field defines groups of jobs, head count reports can vary depending on Institute or DOL job group.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

IS_ADMINISTRATIVE_STAFF

The indicator that the person is a member of the administrative staff (YES, NO).

VARCHAR2

5

IS_FACULTY

The indicator that the person is a member of the faculty (YES, NO).

VARCHAR2

5

IS_GRADUATE_STUDENT_STAFF

The indicator that the person is a graduate student (YES, NO).

VARCHAR2

5

IS_MEDICAL_STAFF

The indicator that the person is a member of the medical staff (YES, NO).

VARCHAR2

5

IS_OTHER_ACADEMIC_GROUP

The indicator that the person is a member of the Other Academic group of employees (YES, NO).

VARCHAR2

5

IS_SERVICE_STAFF

The indicator that the person is a member of the service staff (YES, NO).

VARCHAR2

5

IS_SPONSORED_RESEARCH_STAFF

The indicator that the person is a member of the research staff (YES, NO).

VARCHAR2

5

IS_SUPPORT_STAFF

The indicator that the person is a member of the Support staff (YES, NO).

VARCHAR2

5

JOB_CHANGE_TYPE

The type of change to a person's appointment. Examples : hires, salary increases, department transfers, leaves and terminations.

VARCHAR2

20

JOB_CODE

The classification code. For support and administrative staff, the value of the job code may indicate the relative position of the job in relation to others in the category. Tied to the job code are 30 or so attributes that identify or help select the particular job for inclusion or exclusion. Attribute examples are employment category, affirmative action, union code, etc.

VARCHAR2

6

JOB_TITLE

In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office.

VARCHAR2

50

LEVEL_1

Levels 1 through 5 are used to group jobs at equivalent levels for reporting purposes, at increasing levels of detail, beginning with two groups in Level 1 (Academic and Non-Academic) down essentially to individual job titles in Levels 4 and 5. An example of the increasing grain of each level: Level 1: NonAcademic; Level 2: Sponsored Research Staff; Level 3: Technical; Level 4: Principals; Level 5: Principal Research Associate.

VARCHAR2

100

LEVEL_2

Levels 1 through 5 are used to group jobs at equivalent levels for reporting purposes, at increasing levels of detail, beginning with two groups in Level 1 (Academic and Non-Academic) down essentially to individual job titles in Levels 4 and 5. An example of the increasing grain of each level: Level 1: NonAcademic; Level 2: Sponsored Research Staff; Level 3: Technical; Level 4: Principals; Level 5: Principal Research Associate.

VARCHAR2

100

LEVEL_3

Levels 1 through 5 are used to group jobs at equivalent levels for reporting purposes, at increasing levels of detail, beginning with two groups in Level 1 (Academic and Non-Academic) down essentially to individual job titles in Levels 4 and 5. An example of the increasing grain of each level: Level 1: NonAcademic; Level 2: Sponsored Research Staff; Level 3: Technical; Level 4: Principals; Level 5: Principal Research Associate.

VARCHAR2

100

LEVEL_4

Levels 1 through 5 are used to group jobs at equivalent levels for reporting purposes, at increasing levels of detail, beginning with two groups in Level 1 (Academic and Non-Academic) down essentially to individual job titles in Levels 4 and 5. An example of the increasing grain of each level: Level 1: NonAcademic; Level 2: Sponsored Research Staff; Level 3: Technical; Level 4: Principals; Level 5: Principal Research Associate.

VARCHAR2

100

LEVEL_5

Levels 1 through 5 are used to group jobs at equivalent levels for reporting purposes, at increasing levels of detail, beginning with two groups in Level 1 (Academic and Non-Academic) down essentially to individual job titles in Levels 4 and 5. An example of the increasing grain of each level: Level 1: NonAcademic; Level 2: Sponsored Research Staff; Level 3: Technical; Level 4: Principals; Level 5: Principal Research Associate.

VARCHAR2

100

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

PERCENT_EFFORT

Percentage of work effort. Examples: For faculty, academic and administrative staff, 100% represents full time effort. For Support and Service staff, 100% represents a 35, 37.5, or 40 hour work week.

NUMBER

4

PREFERRED_JOB_TITLE

The title describes duties of an individual who holds a standard Institute position, but whose duties are specific enough to warrant a more descriptive title, or who has been hired to perform duties that are more accurately titled using this field.

VARCHAR2

51

PRIMARY_SECONDARY_INDICATOR

Indicates whether the appointment is the person's primary appointment ("Primary") or is a secondary appointment ("Additional Appt").

VARCHAR2

30

RANK_TYPE

A description of the rank code, e.g. Rank I for faculty, Rank III for Academic Administrative Staff, etc., used to determine a person's employment and salary review categories.

VARCHAR2

50

SALARY_REVIEW_CATEGORY

The employee classification. Examples are: Administrative Staff, Sponsored Research Staff, Support Staff, etc.

VARCHAR2

30

TRANSACTION_END_DATE

The end date or last day of a personnel transaction. Examples of transactions include salary increases, transfers, leaves, terminations, etc.

DATE

8

TRANSACTION_START_DATE

The effective date or first day of a personnel transaction. Examples of transactions include salary increases, transfers, leaves, terminations, etc.

DATE

8

UNION_JOB_CODE

The identification number of the union of which the employee is a member.

VARCHAR2

30

WORK_HOURS

The number of hours per week for this appoinment.

NUMBER

17.2