PSPGCPQPRMP_VW

(SQL View)
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 , PSCPQBIND B , PSPGSETTINGS C WHERE C.PTPG_PGRIDNAME = A.PTPG_PGRIDNAME AND C.PTPG_DSNAME = 'CQRYNAME' AND B.CPQNAME = C.PTPG_DSVALUE AND B.BNDNAME = A.PTPG_UNIQPROMPFLD

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

Default Value: -

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

Prompt Table: %EDITTABLE2

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

Default Value: Y

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

Default Value: N

13 PTPG_SAEDTPROMPT Character(1) VARCHAR2(1) NOT NULL Editable Prompt
14 BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number