This table contains one row for each record defined in PeopleSoft. Sub-records are not expanded
| PSRECDEFN | DBA_TABLES / DBA_VIEWS | Description of PeopleTools Column |
|---|
| PeopleSoft Field Name | Corresponding 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 |
| DDLSPACENAME | TABLESPACE_NAME | In 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. |
| SQLTABLENAME | TABLE_NAME or VIEW_NAME | Name 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. |