PSRECDEFN

index back

Record Definition


  • Related language record: PSRECDEFNLANG
  • Parent record of PSINDEXDEFN PSRECDDLPARM PSRECFIELD PSRECFIELDDB PSRECQRYSECRECS PTINDEXDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name
    FIELDCOUNTNumber(4,0)SMALLINT NOT NULLField Count
    INDEXCOUNTNumber(2,0)SMALLINT NOT NULLIndex Count
    DDLCOUNTNumber(3,0)SMALLINT NOT NULLNumber of DDL Override Parms
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    AUDITRECNAMECharacter(15)VARCHAR2(15) NOT NULLAudit Record Name

    Prompt Table: PSRECDEFN

    RECUSENumber(5,0)INTEGER NOT NULLRecord Use. Audit Option bit values
    1=Add
    2=Change
    4=Delete
    8=Selective
    RECTYPENumber(1,0)SMALLINT NOT NULLRecord Type
    SETCNTRLFLDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Node User Key Field Name

    Prompt Table: PSDBFIELD

    RELLANGRECNAMECharacter(15)VARCHAR2(15) NOT NULLRelated Language Record Name

    Prompt Table: PSRECDEFN

    OPTDELRECNAMECharacter(15)VARCHAR2(15) NOT NULLOptimization Del Record Name

    Prompt Table: PSRECDEFN

    RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
    PARENTRECNAMECharacter(15)VARCHAR2(15) NOT NULLParent Record Name

    Prompt Table: PSRECDEFN

    QRYSECRECNAMECharacter(15)VARCHAR2(15) NOT NULLQuery Security Record Name

    Prompt Table: PSRECDEFN

    SQLTABLENAMECharacter(18)VARCHAR2(18) NOT NULLSQL Table Name
    BUILDSEQNONumber(5,0)INTEGER NOT NULLSequence Number for build.
    OPTTRIGFLAGCharacter(1)VARCHAR2(1) NOT NULLOptimization Triggers?

    Default: N

    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    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.
    SYSTEMIDFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLSystem ID Field Name
    TIMESTAMPFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLRow Level TimeStamp Field Name
    AUXFLAGMASKNumber(10,0)DECIMAL(10) NOT NULLAuxiliary 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)
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19