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_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_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. ![]() |
Announcements > PeopleSoft Announcements >