Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PERSONNEL ACTION DETAIL Table


The history of Personnel Actions in HR


Field Name

Description

Data Type

Length

EMPLOYMENT_STATUS

Identifies the most recent status of an employee, eg, Active, Leave, Retiree, Terminated, Deceased. NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record.

VARCHAR2

30

EMPLOYMENT_STATUS_CODE

Code to identify the status.

VARCHAR2

1

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

PERSONNEL_ACTION_END_DATE

Personnel action end date.

DATE

8

PERSONNEL_ACTION_START_DATE

XXX

DATE

8

PERSONNEL_ACTION_TYPE_KEY

Key field used to join to the PERSONNEL_ACTION_TYPE table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

PERSONNEL_KEY

Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

SAP_STATUS

Identifies the status within SAP, active for people being paid, withdrawn from ex-employees and ex-people (deceased). NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record.

VARCHAR2

30

SAP_STATUS_CODE

Number assignment to SAP status.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8