PSPGMODEL

index back

Pivot Grid Model Record


  • Related language record: PSPGMODELLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTPG_PGRIDNAMECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Name (see PSPGCORE).
    PTPG_DSUNIQUEFLDCharacter(30)VARCHAR2(30) NOT NULLUnique Heading
    PTPG_DSCOLUMNCharacter(254)VARCHAR2(254) NOT NULLData Source Columns
    PTPG_DSCOLUMNALIASCharacter(254)VARCHAR2(254) NOT NULLColumn Label
    PTPG_QRYCOLUMNCharacter(30)VARCHAR2(30) NOT NULLQuery Columns
    PTPG_TOTALNAMECharacter(30)VARCHAR2(30) NOT NULLTotal Name
    PTPG_FORMATCharacter(15)VARCHAR2(15) NOT NULLField Format
    PTPG_AGGREGATECharacter(3)VARCHAR2(3) NOT NULLAggregate Functions
    AVG=Average
    CNT=Count
    MAX=Maximum
    MIN=Minimum
    NON=None
    SUM=Sum
    PTPG_AXISINFOCharacter(4)VARCHAR2(4) NOT NULLAxis Information
    COL=Column Axis
    ROW=Row Axis
    PTPG_COLMNTYPECharacter(4)VARCHAR2(4) NOT NULLColumn Type
    DIM=Axis
    DISO=Display
    VAL=Value
    PTPG_TOTALCharacter(3)VARCHAR2(3) NOT NULLTotal Name

    Y/N Table Edit

    PTPG_TRANSLATEOPTCharacter(1)VARCHAR2(1) NOT NULLTranslate Option
    1=No Xlat
    2=Xlat Short
    3=Xlat Long
    N=No
    Y=Yes

    Default: 1

    PTPG_FORMATTYPENumber(3,0)SMALLINT NOT NULLFormat Type
    SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
    SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
    TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
    PTPG_TREE_EFFDTDate(10)DATEEffective Date
    TREE_NODECharacter(20)VARCHAR2(20) NOT NULLNode name

    Prompt Table: PSTREENODEPVW

    PTPG_CURR_CTL_FLDCharacter(30)VARCHAR2(30) NOT NULLCurrency Control Field
    PTPG_SHOWCURR_SYMCharacter(1)VARCHAR2(1) NOT NULLShow Currency Symbol

    Y/N Table Edit

    Default: N

    PTPG_SHOW1000_SEPCharacter(1)VARCHAR2(1) NOT NULLDisplay 1000 Separator

    Y/N Table Edit

    Default: N

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