PSRECFIELDDB

(SQL Table)
 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 PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSDBFIELD

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

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSDBFIELD

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

    Prompt Table: PSDBFIELD

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

    Prompt Table: PSRECDEFN

    9 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
    10 USEEDIT2 Number(10,0) DECIMAL(10) NOT NULL More Field Use and Edit Flags
    11 SUBRECORD Character(1) VARCHAR2(1) NOT NULL Sub Record
    12 SUBRECVER Number(10,0) DECIMAL(10) NOT NULL Sub Record Version
    13 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name
    14 DEFGUICONTROL Number(2,0) SMALLINT NOT NULL Default GUI Control

    Default Value: 99

    15 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    16 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.
    17 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.
    18 TIMEZONEUSE Number(2,0) SMALLINT NOT NULL Time Zone Use

    Default Value: 0

    19 TIMEZONEFIELDNAME Character(18) VARCHAR2(18) NOT NULL Time Zone Field Name
    20 RELTMDTFIELDNAME Character(18) VARCHAR2(18) NOT NULL Related Time Date Field Name
    21 CURRCTLUSE Number(3,0) SMALLINT NOT NULL Currency Control Use