3375924 - How To check User Status Via Data inspector

How To check User Status Via Data inspector

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HXM Suite

Check User Status

• Go to Data inspector
• Entity: Table_USERS_SYSINFO
• Define Filter Criteria
• Users Sys ID = 
• Check result and column Valid

View  Valid value :

• t = Active
• f = Inactive
• T = active_external
• F = inactive_external
• e = active_external_suite
• d = Inactive_external_suite
• x = Purged
• v = Vacant
  

 Also View

• VALID_INTERNAL_USER  ("t", true, false, false, true, false, false, false, "active")
•  INVALID_INTERNAL_USER  ("f", true, false, false, false, true, false, false, "inactive")
•  VALID_EXTERNAL_USER("T", false, true, false, true, false, false, false, "active_external")
•  INVALID_EXTERNAL_USER("F", false, true, false, false, true, false, false, "inactive_external")
•  VALID_EXTERNAL_USER_NON_MTR("e", false, false, true, true, false, false, false, "active_external_suite")
•  INERNAL_USERVALID_EXT_NON_MTR("d", false, false, true, false, true, false, false, "inactive_external_suite")
•  PURGED_USER("x", false, false, false, false, false, true, false, "purged")
•  VACANT_USER("v", false, false, false, false, false, false, true, "vacant")

Additional Information:

Q) Data Inspector tool's report column called 'revision type' what the values 0-1-2 stands 

A) it's the same as on Database or DB. 

• 0=insert
• 1=edit
• 2=delete

• 3319018 - How To Enable Feature Data Inspector
• 3058601 - How To Check Soft Purge or (Hard or Permanent Purge ) User
• 2545988 - How To Purge or Delete Users In SuccessFactors
• 2922739 - How to purge integrated external learners using DRM - SAP SuccessFactors Learning
• 3038172 - [Onboarding] DRTM Onboarding Purge
• 3050510 - [Onboarding] External User Data not visible when viewing reports in Integration Center - Onboarding/Offboarding
• 3290169 - How to find out userid from encrypted data of splunk(server) logs?
• 2786330 - Query on User entity returns blank values - Integration Center
• 2324204 - How to retrieve inactive employees via Integration Center?
• 3375924 - How To check User Status Via Data inspector
• 2584658 - How to Check if a User is an EC User using the Integration Center.

Data inspector, Entity, Table_USERS_SYSINFO, Define Filter Criteria , Users Sys ID, Valid, t , T, F, e, d, x, v ,  active, active_external , inactive , inactive_external  , active_external_suite , "purged, inactive_external_suite, vacant , VALID_INTERNAL_USER INVALID_INTERNAL_USER  ,   VALID_EXTERNAL_USER    INVALID_EXTERNAL_USER  VALID_EXTERNAL_USER_NON_MTR  ,   PURGED_USER,   VACANT_USER,   INERNAL_USERVALID_EXT_NON_MTR , KBA , LOD-SF-EC-EMP , Employment Information (Employment Details) , How To