PSPGMODEL

index back

Pivot Grid Model Record


  • Related language record: PSPGMODELLANG
  • PeopleSoft Field Name Field Type Column Type Description
    PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).
    PTPG_DSUNIQUEFLD Character(30) VARCHAR2(30) NOT NULL Unique Heading
    PTPG_DSCOLUMN Character(254) VARCHAR2(254) NOT NULL Data Source Columns
    PTPG_DSCOLUMNALIAS Character(254) VARCHAR2(254) NOT NULL Column Label
    PTPG_QRYCOLUMN Character(30) VARCHAR2(30) NOT NULL Query Columns
    PTPG_TOTALNAME Character(30) VARCHAR2(30) NOT NULL Total Name
    PTPG_FORMAT Character(15) VARCHAR2(15) NOT NULL Field Format
    PTPG_AGGREGATE Character(3) VARCHAR2(3) NOT NULL Aggregate Functions
    AVG=Average
    CNT=Count
    MAX=Maximum
    MIN=Minimum
    NON=None
    SUM=Sum
    PTPG_AXISINFO Character(4) VARCHAR2(4) NOT NULL Axis Information
    COL=Column Axis
    ROW=Row Axis
    PTPG_COLMNTYPE Character(4) VARCHAR2(4) NOT NULL Column Type
    DIM=Axis
    DISO=Display
    VAL=Value
    PTPG_TOTAL Character(3) VARCHAR2(3) NOT NULL Total Name

    Y/N Table Edit

    PTPG_TRANSLATEOPT Character(1) VARCHAR2(1) NOT NULL Translate Option
    1=No Xlat
    2=Xlat Short
    3=Xlat Long
    N=No
    Y=Yes

    Default: 1

    PTPG_FORMATTYPE Number(3,0) SMALLINT NOT NULL Format Type
    SETID Character(5) VARCHAR2(5) NOT NULL SetID
    SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    PTPG_TREE_EFFDT Date(10) DATE Effective Date
    TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: PSTREENODEPVW

    PTPG_CURR_CTL_FLD Character(30) VARCHAR2(30) NOT NULL Currency Control Field
    PTPG_SHOWCURR_SYM Character(1) VARCHAR2(1) NOT NULL Show Currency Symbol

    Y/N Table Edit

    Default: N

    PTPG_SHOW1000_SEP Character(1) VARCHAR2(1) NOT NULL Display 1000 Separator

    Y/N Table Edit

    Default: N

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