SAP Knowledge Base Article - Public

3375924 - How To check User Status Via Data inspector

Symptom

How To check User Status Via Data inspector

These statuses appear in the Data Inspector for table USERS_SYSINFO Solution provided

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

Environment

SAP SuccessFactors HCM Suite

Cause

   
   
   
   
   
   
   
   
   

Resolution

How to check User Status via Data Inspector

In the following steps, you will use Data Inspector to check the User Status of the employees with UserID containing admin, from the raw data generated in the tool.

  1. Navigate to Data Inspector using Action Search.
  2. On the Entity dropdown list, select the entity Table_USERS_SYSINFO.
  3. On the Define Filter Criteria, select +Add Filter Criteria, and include these details: User Sys ID Contains admin.
  4. Select Show Data. If the option is greyed out, click anywhere on the page and the button should be editable.
  5. From the results, review the Valid column, which shows the status. The valid values are:
    • t = Active
    • f = Inactive
    • T = active_external
    • F = inactive_external
    • e = active_external_suite
    • d = inactive_external_suite
    • x = Purged
    • v = Vacant

Example: Check User Status

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

  Valid value and Summary of User Status Codes in SAP SuccessFactors

  • Code

    Meaning

    Context

    t

    Active

    Standard active internal user

    f

    Inactive

    Standard inactive user

    T

    active_external

    External user (e.g., Recruiting/ONB 1.0)

    F

    inactive_external

    Inactive external user

    e

    active_external_suite

    External user for suite apps (e.g., ONB 2.0)

    d

    inactive_external_suite

    Inactive suite external user

    v

    Vacant

    Vacant position (no user assigned)

    x

    Purged

    User has been purged (GDPR, manual)

 

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

Q) Where can I get information on this from the Guide?

 A) Guide: SAP SuccessFactors API Reference Guide (OData V2)                                                                                                                                                               

      Chapter: The following statuses are available for users:

  • t (active): Active users.
  • f (inactive): Inactive users.
  • T (active_external): Active external users for 360 Review.
  • F (inactive_external): Inactive external users for 360 Review.
  • e (active_external_suite): Active Learning and Onboarding users.
  • d (inactive_external_suite): Inactive Learning and Onboarding users.

You can use either keys or values to filter the results of a query. The keys are case-sensitive but the values aren’t. See Querying Different Types of Users for examples

See Also

  • 3508283 How To Check All Of An Employee's Employments - Data Inspector

  • 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.

  • 2392076 - User Permanent or Hard Purge feature

Keywords

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) , LOD-SF-OBD , Onboarding , LOD-SF-LMS , Learning Management System , LOD-SF-PLT-DRM , Data Retention Management , LOD-SF-EC-DRM , Data Retention Management - (DRM & DRTM) EC Data Only , How To

Product

SAP SuccessFactors HXM Core 2305