PSCONQRSRUNPRM

index back

BIP Run Pars for Con. Queries

BIP Run Control Parameters for scheduled reports based on Connected Queries datasource

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
CONQRSNAMECharacter(30)VARCHAR2(30) NOT NULLConnected Queries object name

Prompt Table: PSCONQRSDEFN
Set Control Field: CONQRSNAME

QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

Prompt Table: PSCONQRSMAP
Set Control Field: QRYNAMECHILD

BNDNUMNumber(3,0)SMALLINT NOT NULLBind Number
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
BNDNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Bind Name
BNDVALUELong CharacterCLOBBind Value
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19