index back

Query Prompt

  • Related language record: PSCPQBINDLANG
  • Parent record: PSCPQDEFN
  • 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
    BNDNAME Character(30) VARCHAR2(30) NOT NULL Query Bind Name
    BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
    CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
    QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
    HDGTYPE Number(1,0) SMALLINT NOT NULL Heading Type
    HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    LENGTH Number(5,0) INTEGER NOT NULL Length
    DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    FORMAT Number(2,0) SMALLINT NOT NULL Field Format
  • If Fieldtype=0 (Character) then Upper Case
  • If Fieldtype=6 (DateTime) then HH:MM
    2=Phone Number North American (mandatory length 12 characters)
    3=Zip/Postal Code North American (mandatory length 10 characters)
    4=US Social Security Number (mandatory length 9 characters)
    6=Mixed Case
    8=Numbers only
    9=SIN (mandatory length 9 characters)
    10=International Phone Number
    11=Zip/Postal Code International
    12=Time HH:MM:SS
    13=Time HH:MM:SS.999999
    14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)
  • EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
    USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
    USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20