SQL table to query the HCM staging area identity store
I'm pretty new to IDM and need help please.
I'm trying to locate which table view in SQL would give me the manager details brought from HCM into the HCM staging area identity store.
I was advised that this information would be in the SAP_MASTER IS but I'm confused as I only have 2 IDs - one productive & the other the HCM staging area
Please could you give me some info on this.
IDM 7.2 SP9
Database - SQL
Tero Virta replied
The manager in IdM is a reference between two IdM records, the mx_manager in SAP Master Id Store would contain MSKEY of the manager record.
HCM doesn't know what is the MSKEY of manager in IdM (as MSKEY is autonumber) so you get the Personnel Number of Manager to Staging Id Store in order for you to build the reference between the manager and subordinate records in IdM.