3589057 - Understanding the "LST_UPD_USR" Field in the PA_CATALOG_ITEM Table in SAP SuccessFactors Learning

• Querying the "LST_UPD_USR" field in the PA_CATALOG_ITEM table returns student users who do not have permissions to add items to the library.
• The expectation was that the "LST_UPD_USR" field would only display users who have updated learning items, classes, curriculum, programs, etc. in the library.

SAP SuccessFactors Learning

1. In Plateau Report Designer, run query to extract data from the "LST_UPD_USR" field in the PA_CATALOG_ITEM table.
2. Notice that the data includes student users who do not have permissions to add items to the library.

The "LST_UPD_USR" field in the PA_CATALOG_ITEM table records the user ID of the last user who made a modification to an item in the library.

This includes actions such as rating an item, which can be performed by student users. Therefore, student users can appear in the "LST_UPD_USR" field even though they do not have permissions to add items to the library.

• When querying the PA_CATALOG_ITEM table, be aware that it includes all users who have made modifications to an item in the library, not just those who have added items. To exclude student users from the results, modify the query to filter out records that contain "User-" in the "LST_UPD_USR" field.
• If the goal is to identify users who have added items to the library, consider using the PH_CATALOG_ITEM table and filtering for admin records with the 'ACTION' column set to 'I' (insert).

KBA 2379690 - Custom Report Development and Support - SAP SuccessFactors Learning for more information on creating custom reports.

SAP SuccessFactors Learning, PA_CATALOG_ITEM table, LST_UPD_USR field, student users, library permissions, custom reports, PH_CATALOG_ITEM table, query modification. , KBA , LOD-SF-LMS-CAT , Catalog , Problem