PSCPQDEFN

index back

CPQDM definition table

Composite Query - definition table

  • Related language record: PSCPQDEFN_LANG
  • Parent record of PSCPQBIND PSCPQDEFNDEL PSCPQDEFN_LANG PSCPQEXPR PSCPQPROP PSCPQSELECT
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    CPQNAME Character(30) VARCHAR2(30) NOT NULL Composite Query
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    PT_REPORT_STATUS Character(1) VARCHAR2(1) NOT NULL Report Status
    A=Active
    I=Inactive
    P=In Progress
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    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.
    REGISTERED_BY Character(30) VARCHAR2(30) NOT NULL Registered By
    REGISTERED_DTTM DateTime(26) TIMESTAMP Registered Date/Time
    SELCOUNT Number(2,0) SMALLINT NOT NULL Select Count
    EXPCOUNT Number(3,0) SMALLINT NOT NULL Expression Count
    BNDCOUNT Number(3,0) SMALLINT NOT NULL Bind Count
    QRYFOLDER Character(18) VARCHAR2(18) NOT NULL Query Folder
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19