PSPGCHARTOPT

 index back

Pivot Grid Chart Options Rec


  • Related language record: PSPGCHARTOPTLNG

    • 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
    PTPG_CHART_TYPE Character(4) VARCHAR2(4) NOT NULL Type
    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_TITLE Character(30) VARCHAR2(30) NOT NULL Title
    PTPG_XAXIS_LABEL Character(254) VARCHAR2(254) NOT NULL X-Axis Label
    PTPG_XAXIS_ANGLE Number(3,0) SMALLINT NOT NULL X-Axis Label Angle
    PTPG_YAXIS_LABEL Character(254) VARCHAR2(254) NOT NULL Y-Axis Label
    PTPG_YAXIS_ANGLE Number(3,0) SMALLINT NOT NULL Y-Axis Label Angle
    PTPG_YAXIS_FORMAT Character(3) VARCHAR2(3) NOT NULL Y-Axis Date Format
    COL=Data in Separate Columns
    ROW=Data in Rows
    PTPG_CHART_HEIGHT Number(4,0) SMALLINT NOT NULL Height
    PTPG_CHART_WIDTH Number(4,0) SMALLINT NOT NULL Width
    PTPG_EXPLODEDPIE Number(1,0) SMALLINT NOT NULL Exploded Pie

    Default: 0

    PTPG_CHPRECISION Number(3,0) SMALLINT NOT NULL Precision Decimals

    Default: 0

    PTPG_3DROT_ANGLE Number(3,0) SMALLINT NOT NULL 3D Rotation Angle
    PTPG_CHART_COLOR Character(4) VARCHAR2(4) NOT NULL Chart Color
    -1=Default
    0=Black
    1=Blue
    10=Red
    11=White
    12=Yellow
    13=Red-Orange
    14=Yellow-Green
    15=Blue-Violet
    16=Purple
    17=Yellow-Orange
    2=Cyan
    3=Dark Gray
    4=Gray
    5=Green
    6=Light Gray
    7=Magenta
    8=Orange
    9=Pink
    PTPG_CHART_LEGEND Character(4) VARCHAR2(4) NOT NULL Legend
    -1=None
    0=Left
    1=Right
    2=Top
    3=Bottom
    PTPG_FOOTER_ID Character(30) VARCHAR2(30) NOT NULL Footer ID
    PTPG_HEADER_ID Character(30) VARCHAR2(30) NOT NULL Header ID
    PTPG_CHRT_SUBTITLE Character(100) VARCHAR2(100) NOT NULL Subtitle
    PTPG_CHRT_FOOTER Character(100) VARCHAR2(100) NOT NULL Footer
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20