Queries for Departments and Locations

posted Jun 26, 2017, 11:04 AM by Peyri Herrera
M_DEPARTMENTS - Departments by District
This is a list of all of your Departments in HCM. Query returns Set ID, Department ID, Effective Date, Status, Description, and Short Description.

M_DEPARTMENTS - Departments by District


M_LOCATIONS - Locations by District
This is a list of all of your Locations in HCM. Query returns Set ID, Location, Effective Date, Status, Description, and Short Description. NOTE: Locations are not linked or tied to Departments in the system.

M_LOCATIONS - Locations by District


M_HR_EMP_LOCATION - Employee and location descr
Use this query to view your employees’ positions, locations, and departments. Query returns Employee ID, Empl Record, Last Name, First Name, Position #, Position Description, Position Department ID, Location #, Location Description, and Department ID. NOTE: Position Department ID comes from Position Data; Department ID comes from Job Data.

M_HR_EMP_LOCATION - Employee and location descr