PSQRYBIND

index back

Query Prompt


  • Related language record: PSQRYBINDLANG
  • Parent record: PSQRYDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    BNDNAME Character(30) VARCHAR2(30) NOT NULL Query Bind Name
    BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    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
    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)
  • 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
    QRYREQUIREDPROMPT Character(1) VARCHAR2(1) NOT NULL Optional
    N=Optional
    Y=Required

    Default: Y

    QRYPROMPTDEFAULT Character(254) VARCHAR2(254) NOT NULL Default Value
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19