PSPGCHARTOPTPER

index back

Pivot Grid Chart Options Rec


  • Related language record: PSPGCHTOPTPERLN
  • 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
    PTPG_CHART_TYPECharacter(4)VARCHAR2(4) NOT NULLType
    0=2D Bar Chart
    1=2D Stacked Bar Chart
    10=2D Horizontal Percent Chart
    11=3D Percent Bar Chart
    13=2D Horizontal Bar Chart
    14=Scatter Chart
    18=Bubble Chart
    2=2D Percent Bar Chart
    3=2D Stacked Horizontal Bar
    4=2D Line Chart
    5=2D Histogram Chart
    6=2D Pie Chart
    7=3D Bar Chart
    8=3D Stacked Bar Chart
    9=3D Pie Chart
    PTPG_CHART_TITLECharacter(30)VARCHAR2(30) NOT NULLTitle
    PTPG_XAXIS_LABELCharacter(254)VARCHAR2(254) NOT NULLX-Axis Label
    PTPG_XAXIS_ANGLENumber(3,0)SMALLINT NOT NULLX-Axis Label Angle
    PTPG_YAXIS_LABELCharacter(254)VARCHAR2(254) NOT NULLY-Axis Label
    PTPG_YAXIS_ANGLENumber(3,0)SMALLINT NOT NULLY-Axis Label Angle
    PTPG_CHART_HEIGHTNumber(4,0)SMALLINT NOT NULLHeight
    PTPG_CHART_WIDTHNumber(4,0)SMALLINT NOT NULLWidth
    PTPG_EXPLODEDPIENumber(1,0)SMALLINT NOT NULLExploded Pie

    Default: 0

    PTPG_CHPRECISIONNumber(3,0)SMALLINT NOT NULLPrecision Decimals

    Default: 0

    PTPG_3DROT_ANGLENumber(3,0)SMALLINT NOT NULL3D Rotation Angle
    PTPG_CHART_LEGENDCharacter(4)VARCHAR2(4) NOT NULLLegend
    -1=None
    0=Left
    1=Right
    2=Top
    3=Bottom
    PTPG_CHRT_SUBTITLECharacter(100)VARCHAR2(100) NOT NULLSubtitle
    PTPG_CHRT_FOOTERCharacter(100)VARCHAR2(100) NOT NULLFooter
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19