PSRECFIELDDB

Return to Index

This record is an exact copy of PSRECFIELD. It is used to store only actual Record/Field combinations. No sub-records are stored, instead they are expanded. This table is kept in sync with PSRECFIELD from PeopleTools 8.4x. It is loaded during the sysaudit for performance reasons.

  • Parent record: PSRECDEFN
  • PSRECFIELDDBA_TAB_COLUMNSDescription of PeopleTools Column
    PeopleSoft Field NameCorresponding Oracle Column Name
    RECNAMETABLE_NAMEUnique name of record within PeopleSoft (see PSRECDEFN.SQLTABLENAME).

    Prompt Table: PSRECDEFN

    FIELDNAMECOLUMN_NAMEColumn name or sub-record name
    RENAME_PARENT Parent Record.  If this comes from a sub-record, this column has the name of the sub-record, otherwise it has the same value as RECNAME
    FIELDNUMCOLUMN_IDSequence number of column in record
    DEFRECNAME Default value from DEFFIELDNAME on record DEFRECNAME.

    Prompt Table: PSRECDEFN

    DEFFIELDNAME Default value from DEFFIELDNAME on record DEFRECNAME.

    Prompt Table: PSDBFIELD

    CURCTLFIELDNAME Prompt Table: PSDBFIELD
    EDITTABLE Prompt table: a look-up table to provide a list of values and to validate entry.

    Prompt Table: PSRECDEFN

    USEEDIT see table
    USEEDIT2 New in PeopleTools 8.4.
    SUBRECORD Is this column is a sub-record? Y/N
    SUBRECORDVER  
    SETCNTRLFLD Tree Structure Node User Key Field Name
    DEFGUICONTROL Default Value: 99
    LABEL_ID LABEL_ID identifies uniqueness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    LASTUPDDTTM Timestamp of the last update.
    LASTUPDOPRID Operator (developer) who last updated this record.
    TIMEZONEUSE Default Value: 0
    TIMEZONEFIELDNAME  
    RELTMDTFIELDNAME  
    CURRCTLUSE  

    Author: David Kurtz

    Return to Index

    © David Kurtz  Last updated 01 August 2015