PSPGQRYPROMPT

(SQL Table)
 Index Back

Pivot Grid Prompt record

  • Related Language Record: PSPGQRYPROMPLNG

    • # 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

    Default Value: N

    14 PTPG_SHOWOPERATOR Character(1) VARCHAR2(1) NOT NULL Show Operator
    N=No
    Y=Yes

    Default Value: N