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 NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    RECNAME_PARENTCharacter(15)VARCHAR2(15) NOT NULLParent 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.
    FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
    DEFRECNAMECharacter(15)VARCHAR2(15) NOT NULLDefault Record Name

    Prompt Table: PSRECDEFN

    DEFFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLDefault Field Name

    Prompt Table: PSDBFIELD

    CURCTLFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLCurrency Control Field Name

    Prompt Table: PSDBFIELD

    EDITTABLECharacter(15)VARCHAR2(15) NOT NULLEdit Table

    Prompt Table: PSRECDEFN

    USEEDITNumber(10,0)DECIMAL(10) NOT NULLField Use and Edit Flags- USEEDIT reference
    USEEDIT2Number(10,0)DECIMAL(10) NOT NULLMore Field Use and Edit Flags
    SUBRECORDCharacter(1)VARCHAR2(1) NOT NULLSub Record
    SUBRECVERNumber(10,0)DECIMAL(10) NOT NULLSub Record Version
    SETCNTRLFLDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Node User Key Field Name

    Default: 99

    LABEL_IDCharacter(18)VARCHAR2(18) NOT NULLLABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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

    TIMEZONEFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLTime Zone Field Name
    RELTMDTFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLRelated Time Date Field Name
    CURRCTLUSENumber(3,0)SMALLINT NOT NULLCurrency Control Use
    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19