PSPGQRYPROMPT

index back

Pivot Grid Prompt record


  • Related language record: PSPGQRYPROMPLNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTPG_PGRIDNAMECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Name (see PSPGCORE).
    PTPG_VIEWNAMECharacter(40)VARCHAR2(40) NOT NULLView Name
    USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID

    Default: -

    PTPG_UNIQPROMPFLDCharacter(30)VARCHAR2(30) NOT NULLUnique Prompt Name
    PTPG_QRYPROMPNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Prompt Name
    PTPG_QRYPROMPRECCharacter(30)VARCHAR2(30) NOT NULLPrompt Record
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    PTPG_QRYPROMPTVALCharacter(30)VARCHAR2(30) NOT NULLQuery Prompt Values

    Prompt Table: %EDITTABLE2

    PTPG_PRMPTXLATVALCharacter(100)VARCHAR2(100) NOT NULLTranslate Value
    PTPG_FORMATTYPENumber(3,0)SMALLINT NOT NULLFormat Type
    PTPG_VISIBLEPRMPTCharacter(1)VARCHAR2(1) NOT NULLVisible Prompt
    N=No
    Y=Yes

    Default: Y

    PTPG_DISPPROMPTVALCharacter(1)VARCHAR2(1) NOT NULLDisplay Prompt Value
    N=No
    Y=Yes

    Default: N

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