PSSQLDEFN

(SQL Table)
 Index Back

SQL Object Defn

This record is the parent of PSSQLTEXTDEFN. It holds SQL object definitions, and these objects are used widely in PeopleTools. Only rows where SQLTYPE = 2 correspond to USER_VIEWS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 2 SQLTYPE Character(1) VARCHAR2(1) NOT NULL SQL Object type
  • 0=SQL Object referenced from elsewhere
  • 1=Application Engine Step
  • 2=SQL View
  • 5=Queries for DDDAUDIT and SYSAUDIT
  • 6= Application Engine Step XSLT
    • 3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    4 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.
    5 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.
    6 ENABLEEFFDT Character(1) VARCHAR2(1) NOT NULL Enable effective dating
    7 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier