Page tree
Skip to end of metadata
Go to start of metadata

This Page explains the different database prefixes used LMS. You can also use this Browsing DB-Tables using PRD to view the different table,  view and Stored Procedure available in your staging instance.

To make it easier to identify the different tables in the SuccessFactors database, each table starts with a prefix that identifies the primary functionality of the table.

PA_: The PA tables hold all of the Application data that is stored in the database. This is the primary table type that is used when creating custom reports.
PH_ The PH tables are comprised of all the History information that is generated when a record is added, edited, or deleted in the application. Audit reports can be created using the information stored in these tables.
PS_: All of the System configurations, search selectors, notifications, approval processes, etc. are stored in the PS tables. Normally this group of tables is not used in custom report writing.
PV_: To make it easier to create specific reports, SuccessFactors has created a group of virtual tables know as Views. A view is similar to a real database table
but it does not actually store any data. A view references one or more existing tables in the database and is generated dynamically. For example, custom user data is stored in multiple tables and requires a complex query to retrieve the data. The PV_AP_STUD_USER view can be used to retrieve the same data but the query to retrieve the information is much shorter.
PX_: When using a connector to import data from an HR system into SuccessFactors, the data is temporarily stored in the PX tables before it is moved to the PA tables. The PX tables also store any system customizations that a client has implemented. These tables are not used in custom reports.

You can download the latest Data Dictionary on the SAP Help Portal. You will need to select the Data Dictionary and Database Changes.


Link: http://wiki.scn.sap.com/wiki/x/3I3SFw

1 Comment

  1. Note 2326249 has all details around data dictionary and data model.