PTNVSQRYPROMPTS

index back

Nvision Query Prompts table


PeopleSoft Field Name Field Type Column Type Description
BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
BNDNAME Character(30) VARCHAR2(30) NOT NULL Query Bind Name
BNDVALUE Long Character CLOB Bind Value
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19