Some useful SQLs for checking HDL data issues.

Summary

Some useful SQLs for checking HDL data issues.

Content

The below SQLs are useful while loading HDL and this might help beginners who wants check the DM for loaded Data.

To check the SourceSystemID for the supervisor record for the given assignment number:

SELECT A.SOURCE_SYSTEM_ID 
  FROM HRC_INTEGRATION_KEY_MAP A
  , PER_ASSIGNMENT_SUPERVISORS_F B 
  ,PER_ALL_ASSIGNMENTS_M C 
 WHERE C.ASSIGNMENT_NUMBER='E72-2'AND A.SURROGATE_ID=B.ASSIGNMENT_SUPERVISOR_ID 
   AND C.ASSIGNMENT_ID=B.ASSIGNMENT_ID; 
   

This table gives the detail of the SourceSystemIDs that are loaded through HDL or created via online