Record Naming Convention

This is the naming convention (prefixes/suffixes) recommeded by PeopleSoft in PeopleBooks for Record objects. Make sure you use the appropriate suffix based on the record type to be consistent with this convention.

Prefixes

Prefix Description
AUDIT_ Identifies record definitions that store audit information for other records.
DERIVED_ Identifies shared record definitions (across an application module or group) that have fields for PeopleCode events.
FUNCLIB_ Identifies record definitions that contain written PeopleCode functions, as opposed to built-in functions. You can include these records in the component and call them as functions. These self-developed functions are generally located in FieldFormula events, and the records are usually derived.
R_ Identifies work record definitions for Structured Query Report reports. The remainder of the record name consists of the program or report ID.
WEBLIB_ Identifies record definitions that store internet scripts. Internet scripts are generally located in FieldFormula PeopleCode events. You must grant access in the Security component for a WEBLIB record with an internet script before it can be run in a PeopleCode program.

Suffixes

Suffix Description
_DVW Identifies a dynamic view.
_TBL Identifies an edit or prompt table that contains data that is used for validation, as opposed to data that is maintained by the application. Prompt tables store commonly used values. They include, but are not limited to, control tables, which store company-wide values. For example, the location table (LOCATION_TBL) stores values for all operating locations in which your company does business; the country table (COUNTRY_TBL) stores values for all valid countries. Note this is the convention for setup tables - transaction tables do not normally have the underscore _TBL suffix.
_QVW Identifies a query view.
_SBR Identifies subrecords.
_VW Identifies a record definition that is physically implemented by defining a SQL view.
_WL Identifies the record as a worklist record definition.
_WRK Identifies derived work records.
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License