PSRECDEFN

(SQL Table)
 Index Back

Record Definition

  • Related Language Record: PSRECDEFNLANG

  • Parent Record Of LOAD_SQL_SBR_VW PSINDEXDEFN PSRECDDLPARM PSRECFIELD PSRECFIELDDB PSRECQRYSECRECS TR_PSREC_PAR_VW

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

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSDBFIELD

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

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSRECDEFN

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

    Default Value: N

    18 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    19 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.
    20 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.
    21 SYSTEMIDFIELDNAME Character(18) VARCHAR2(18) NOT NULL System ID Field Name
    22 TIMESTAMPFIELDNAME Character(18) VARCHAR2(18) NOT NULL Row Level TimeStamp Field Name
    23 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)
    4194304=Global Temporary Table
    24 DESCRLONG Long Character CLOB Long Description