PSRECDEFN

Return to Index

This table contains one row for each record defined in PeopleSoft.  Sub-records are not expanded

PSRECDEFNDBA_TABLES / DBA_VIEWSDescription of PeopleTools Column
PeopleSoft Field NameCorresponding Oracle Column Name
RECNAME Unique name of record within PeopleSoft (see SQLTABLENAME).
FIELDCOUNT Number of fields on a record before expanding any sub-records; this does not therefore equate to the number of columns on a table.
INDEXCOUNT Number of keys on a record, including those implied by the PeopleTools record key definition. Note that views can also have PeopleTools keys, because PeopleSoft will query a record by its primary key, although it is not possible to build an index on a view.
DDLCOUNT Number of DDL override parameters specified.
VERSION Version Number (OBJECTTYPE = 'RDM',  also on PSLOCK)

Internal PeopleTools version for controlling caching of object. 

AUDITRECNAME Name of audit record. The PIA will write audit information about this record to the audit record.

Prompt Table: PSRECDEFN

RECUSE One of the following audit options:
  • 1 = Add
  • 2 = Change
  • 4 = Delete
  • 8 = Selective
RECTYPE see table
SETCNTRLFLD Multi-company row-level security feature

Prompt Table: PSDBFIELD

RELLANGRECNAME Related language record that contains translated values.

Prompt Table: PSRECDEFN

OPTDELRECNAME Optimisation delete record (new in PeopleTools 8.4).

Prompt Table: PSRECDEFN

RECDESCR Short description of record.
PARENTRECNAME Name of parent record for use in Query utility.

Prompt Table: PSRECDEFN

QRYSECRECNAME Name of query security record.

Prompt Table: PSRECDEFN

DDLSPACENAMETABLESPACE_NAMEIn PeopleTools 8.1x, this column specifies the tablespace in which the table is to be built.
In PeopleTools 8.4x, the tablespace is stored on PSRECTBLSPC instead, and this column has been dropped.
SQLTABLENAMETABLE_NAME or VIEW_NAMEName of any table or view that is built in the database. If this column is blank, the table name will be “PS_” followed by the RECNAME
DBA_TABLES.TABLE_NAME = DECODE(PSRECDEFN.SQLTABLENAME, ' ', 'PS_'||PSRECDEFN.RECNAME, PSRECDEFN.SQLTABLENAME)
BUILDSEQNO Controls the order in which objects are built by the Application Designer. For instance, a view must be built before a view that references it, so the referencing view will have a higher build sequence number than the referenced view.
OPTTRIGFLAG Set to Y if a trigger is to be built to maintain the system ID field (new in PeopleTools 8.4).

Default: N

OBJECTOWNERID Short code indicating the functional area that owns the record. There are over 250 codes, and the translations are on PSXLATITEM. For example:
  • PPT: PeopleTools
  • HCR: HR Core Objects
  • HG: Global Payroll Core Application
LASTUPDDTTM Specifies the date and time of the last update to an entry. This field is maintained by Application Designer.
LASTUPDOPRID Specifies the User ID of the last developer who alter this record. This field is maintained by Application Designer.
SYSTEMIDFIELDNAME Field on record to be updated by database trigger with sequence number obtained from record PSSYSTEMID (new in PeopleTools 8.4).
TIMESTAMPFIELDNAME Field on record to be updated by database trigger with a timestamp (new in PeopleTools 8.4).
AUXFLAGMASK Auxiliary flag mask (new in PeopleTools 8.4) - see table
DESCRLONG Long description of record.

Author: David Kurtz

Return to Index

© David Kurtz  Last updated 18 June 2015