PSPGQRYPRMP_VW

 index back

SELECT A.PTPG_PGRIDNAME , A.PTPG_VIEWNAME , A.USERID , A.PTPG_UNIQPROMPFLD , A.PTPG_QRYPROMPNAME , A.PTPG_QRYPROMPREC , A.FIELDNAME , A.PTPG_QRYPROMPTVAL , A.PTPG_PRMPTXLATVAL , A.PTPG_FORMATTYPE , A.PTPG_VISIBLEPRMPT , A.PTPG_DISPPROMPTVAL , A.PTPG_SAEDTPROMPT , B.BNDNUM FROM PSPGQRYPROMPT A , PSQRYBIND B , PSPGSETTINGS C WHERE C.PTPG_PGRIDNAME = A.PTPG_PGRIDNAME AND C.PTPG_DSNAME = 'QRYNAME' AND B.QRYNAME = C.PTPG_DSVALUE AND B.BNDNAME = A.PTPG_UNIQPROMPFLD

PeopleSoft Field Name Field Type Column Type Description
PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).
PTPG_VIEWNAME Character(40) VARCHAR2(40) NOT NULL View Name
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Default: -

PTPG_UNIQPROMPFLD Character(30) VARCHAR2(30) NOT NULL Unique Prompt Name
PTPG_QRYPROMPNAME Character(30) VARCHAR2(30) NOT NULL Query Prompt Name
PTPG_QRYPROMPREC Character(30) VARCHAR2(30) NOT NULL Prompt Record
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
PTPG_QRYPROMPTVAL Character(30) VARCHAR2(30) NOT NULL Query Prompt Values

Prompt Table: %EDITTABLE2

PTPG_PRMPTXLATVAL Character(100) VARCHAR2(100) NOT NULL Translate Value
PTPG_FORMATTYPE Number(3,0) SMALLINT NOT NULL Format Type
PTPG_VISIBLEPRMPT Character(1) VARCHAR2(1) NOT NULL Visible Prompt
N=No
Y=Yes

Default: Y

PTPG_DISPPROMPTVAL Character(1) VARCHAR2(1) NOT NULL Display Prompt Value
N=No
Y=Yes

Default: N

PTPG_SAEDTPROMPT Character(1) VARCHAR2(1) NOT NULL Editable Prompt
BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20