PSCPQBIND

(SQL Table)
 Index Back

Query Prompt

  • Related Language Record: PSCPQBINDLANG

  • Parent record: PSCPQDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 CPQNAME Character(30) VARCHAR2(30) NOT NULL Composite Query
    3 BNDNAME Character(30) VARCHAR2(30) NOT NULL Query Bind Name
    4 BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
    5 CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
    6 QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
    7 HDGTYPE Number(1,0) SMALLINT NOT NULL Heading Type
    8 HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading
    9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    10 LENGTH Number(5,0) INTEGER NOT NULL Length
    11 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    12 FORMAT Number(2,0) SMALLINT NOT NULL Field Format
    0=
  • If Fieldtype=0 (Character) then Upper Case
  • If Fieldtype=6 (DateTime) then HH:MM
    1=Name
    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)
    5=
    6=Mixed Case
    7=Raw/Binary
    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)
    • 13 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
    14 USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
    15 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference