index back

Record Definition

  • Related language record: PSRECDEFNLANG
  • PeopleSoft Field Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
    FIELDCOUNT Number(4,0) SMALLINT NOT NULL Field Count
    INDEXCOUNT Number(2,0) SMALLINT NOT NULL Index Count
    DDLCOUNT Number(3,0) SMALLINT NOT NULL Number of DDL Override Parms
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    AUDITRECNAME Character(15) VARCHAR2(15) NOT NULL Audit Record Name

    Prompt Table: PSRECDEFN

    RECUSE Number(5,0) INTEGER NOT NULL Record Use. Audit Option bit values
    RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
    0=SQL Table
    1=SQL View
    2=Derived Work/Record
    5=Dynamic View
    6=Query View
    7=Temporary Table
    SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name

    Prompt Table: PSDBFIELD

    RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name

    Prompt Table: PSRECDEFN

    OPTDELRECNAME Character(15) VARCHAR2(15) NOT NULL Optimization Del Record Name

    Prompt Table: PSRECDEFN

    RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name

    Prompt Table: PSRECDEFN

    QRYSECRECNAME Character(15) VARCHAR2(15) NOT NULL Query Security Record Name

    Prompt Table: PSRECDEFN

    SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name
    BUILDSEQNO Number(5,0) INTEGER NOT NULL Sequence Number for build.
    OPTTRIGFLAG Character(1) VARCHAR2(1) NOT NULL Optimization Triggers?

    Default: N

    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    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.
    SYSTEMIDFIELDNAME Character(18) VARCHAR2(18) NOT NULL System ID Field Name
    TIMESTAMPFIELDNAME Character(18) VARCHAR2(18) NOT NULL Row Level TimeStamp Field Name
    AUXFLAGMASK Number(10,0) DECIMAL(10) NOT NULL Auxiliary Flag Mask bit values
    65536=Tools Table
    131072=Managed Tools Table
    262144=In use, but not yet sure what it does!
    524288=Server -> User (Down Sync)
    1048576=User -> Server (Up Sync)
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20