PSQRYBIND

index back

Query Prompt


  • Related language record: PSQRYBINDLANG
  • Parent record: PSQRYDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    BNDNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Bind Name
    BNDNUMNumber(3,0)SMALLINT NOT NULLBind Number
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    HDGTYPENumber(1,0)SMALLINT NOT NULLHeading Type
    HEADINGCharacter(30)VARCHAR2(30) NOT NULLField Heading
    FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
    LENGTHNumber(5,0)INTEGER NOT NULLLength
    DECIMALPOSNumber(2,0)SMALLINT NOT NULLDecimal Positions
    FORMATNumber(2,0)SMALLINT NOT NULLField 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)
  • EDITTABLECharacter(15)VARCHAR2(15) NOT NULLEdit Table
    USECOUNTNumber(3,0)SMALLINT NOT NULLUse Count
    USEEDITNumber(10,0)DECIMAL(10) NOT NULLField Use and Edit Flags- USEEDIT reference
    QRYREQUIREDPROMPTCharacter(1)VARCHAR2(1) NOT NULLOptional
    N=Optional
    Y=Required

    Default: Y

    QRYPROMPTDEFAULTCharacter(254)VARCHAR2(254) NOT NULLDefault Value
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19