index back

Record Field Without Subrecs

This record is an exact copy of PSRECFIELD. It is used to store only actual Record/Field combinations. No subrecords are stored. This table is not kept in sync with PSRECFIELD. It is loaded during the sysaudit for performance reasons.

  • Parent record: PSRECDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    RECNAME_PARENT Character(15) VARCHAR2(15) NOT NULL 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.
    FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    DEFRECNAME Character(15) VARCHAR2(15) NOT NULL Default Record Name

    Prompt Table: PSRECDEFN

    DEFFIELDNAME Character(18) VARCHAR2(18) NOT NULL Default Field Name

    Prompt Table: PSDBFIELD

    CURCTLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Currency Control Field Name

    Prompt Table: PSDBFIELD

    EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

    Prompt Table: PSRECDEFN

    USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
    USEEDIT2 Number(10,0) DECIMAL(10) NOT NULL More Field Use and Edit Flags
    SUBRECORD Character(1) VARCHAR2(1) NOT NULL Sub Record
    SUBRECVER Number(10,0) DECIMAL(10) NOT NULL Sub Record Version
    SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name

    Default: 99

    LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default: 0

    TIMEZONEFIELDNAME Character(18) VARCHAR2(18) NOT NULL Time Zone Field Name
    RELTMDTFIELDNAME Character(18) VARCHAR2(18) NOT NULL Related Time Date Field Name
    CURRCTLUSE Number(3,0) SMALLINT NOT NULL Currency Control Use
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20