Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Personnel


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

APPOINTMENT_OLD

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

Fact

Human Resources

SENSITIVE

As Needed

08-MAR-2006

APPOINTMENT_ALL

*Old Personnel Data in CYBORG* - Contains all employee appointments (current and old) and related information. A record of personnel actions, including salary reviews, terminations, hires, transfers, etc.

Fact

Human Resources

SENSITIVE

As Needed

08-MAR-2006

EMPLOYEE_LIMITED

*Old Personnel Data in CYBORG * - Contains employee data without home address information for all employees.

Dimension

Human Resources

SENSITIVE

As Needed

08-MAR-2006

EMPLOYEE

*Old Personnel Data in CYBORG * - Contains personal information about all employees.

Dimension

Human Resources

SENSITIVE

As Needed

08-MAR-2006

APPOINTMENT_LIMITED

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

Fact

Human Resources

SENSITIVE

As Needed

08-MAR-2006