APPOINTMENT OLD Table
*Old Personnel Data in CYBORG* - Contains all the employee appointments and related information for appointments that are old/not current today. A record of personnel actions, including salary reviews, terminations, hires, transfers, etc.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_AMOUNT |
The total dollar amount paid for the duration of an appointment. Generally used for non-tenure academic appointments. |
NUMBER |
15.2 |
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 |
FTE_SALARY |
A full time salary equivalent for a part time appointment: fte salary=(actual annual salary/actual percent work effort) x full time work effort. Example: A person's actual annual salary is $25,000 with a percentage of work effort of 80%. This person's fte salary would be $31,250. |
NUMBER |
8 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HOURLY_RATE |
Hourly wage for this appointment. |
NUMBER |
38 |
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 |
The salary for this appointment. |
NUMBER |
38 |
SALARY_GRADE |
Used by Personnel to obtain salary range minimum and maximum values for a position. |
VARCHAR2 |
30 |
SALARY_PERCENT_CHANGE |
The increase percent for the last time an employee had a salary increase. |
NUMBER |
4 |
SALARY_RANGE_MAX |
The maxiimum salary allocated for this appointment. |
NUMBER |
11 |
SALARY_RANGE_MIN |
The minimum salary allocated for this appointment. |
NUMBER |
11 |
SALARY_REVIEW_CATEGORY |
The employee classification. Examples are: Administrative Staff, Sponsored Research Staff, Support Staff, etc. |
VARCHAR2 |
30 |
SPONSOR_NAME |
In the PROJECT and SPONSOR tables, identifies the sponsor, associated with a particular sponsor code, providing funding for a sponsored research project. In the personnel APPOINTMENT tables, identifies the sponsor providing financial support for a Fellow; this field is not currently populated by Human Resources. |
VARCHAR2 |
60 |
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 |