APPOINTMENT BASIC Table

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.

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).

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_TITLE

The official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office.

VARCHAR2

50

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

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