PSPGQRYPROMPT

index back

Pivot Grid Prompt record


  • Related language record: PSPGQRYPROMPLNG
  • 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

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19