M_EMPLOYEE_VS_USER query available

posted Dec 15, 2016, 3:04 PM by Peyri Herrera
NEW

An employee has an employee record and a user record in PeopleSoft. In HCM you can run the M_EMPLOYEE_VS_USER query for a list of Employee/User names and their Employee/User email addresses.
M_EMPLOYEE_VS_USER

Column A - Unit. This is your district #.

Column B - ID. This is the employee’s ID.

Column C - HR Status. “I” stands for inactive HR status. Some employees might have multiple employee records, of which there are both active (A) and inactive (I) ones.

Column D - Personal Info Name. This is the name that is entered at Main Menu > Workforce Administration > Personal Information > Personal Information. It should reflect the legal name.

Column E - Warrant Name. This is the warrant name entered at Main Menu > Workforce Administration > Personal Information > Biographical > Additional Names. On this screen you can enter an alternative warrant name if one is provided. NOTE: At conversion, if an employee existed in Legacy, the Warrant Name and SS Names were brought in on the Warrant Name screen. If you need to change an employee’s name, be sure to check the Warrant Name screen, too. If it is a brand new employee, you do not need to add it to the Warrant Name screen.

Column F - User Profile Name (CRC). This is the name on the PeopleSoft user account and is different than the employee record. Only the CRC can change the user profile name at this time (submit a HEAT ticket). When your district went live, the user names might have been loaded “Last First” or “First Middle Last” or “First Last.” This name displays on:
  • HCM: My Profile, My Personalizations, and Change Password screens. If you have the M_ABSENCE_APPROVER role, it will show up in the HCM Worklist. 
  • Finance: Requester and Buyer on all purchasing screens; Originator and Approver in workflow for all transactions; Finance Worklist. 
Column G - Personal Info Email. This is the email address that is entered at Main Menu > Workforce Administration > Personal Information > Personal Information. Some districts allow employees to update this in Employee Self-Service. The system sends messages to this email address for:
  • TB test email notifications 
  • Credentials email notifications 
  • For organizations that use Absence Requests: Absence Request email notifications are sent to the employee (requester) 
Column H - User Profile Email. This is the email address on the user account and is changed by you (user) in PeopleSoft ESS, Portal, or HCM from Main Menu > My (System) Profile. Additionally, the staff within your organization who handle your password resets can change the User email address from the Distributed User Profile screen that they access. The system sends messages to this email address for:
  • Workflow email notifications for approvals 
  • Password reset email with temporary password 
  • For organizations that use Absence Requests: Absence Request approval email notifications are sent to the manager (approver) 
For a printer-friendly version of this information, please download Employee Names vs User Names v1.0.pdf (2 pp.).