PSPGMODEL(SQL Table) |
Index Back |
|---|---|
Pivot Grid Model Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTPG_PGRIDNAME |
Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Name (see PSPGCORE). |
| 2 | PTPG_DSUNIQUEFLD |
Character(254) | VARCHAR2(254) NOT NULL | Unique Heading |
| 3 | PTPG_DSCOLUMN | Character(254) | VARCHAR2(254) NOT NULL | Data Source Columns |
| 4 | PTPG_DSCOLUMNALIAS | Character(254) | VARCHAR2(254) NOT NULL | Column Label |
| 5 | PTPG_AGGR_ALIAS | Character(254) | VARCHAR2(254) NOT NULL | Aggregate Label |
| 6 | PTPG_QRYCOLUMN | Character(30) | VARCHAR2(30) NOT NULL | Query Columns |
| 7 | PTPG_TOTALNAME | Character(30) | VARCHAR2(30) NOT NULL | Total Name |
| 8 | PTPG_FORMAT | Character(15) | VARCHAR2(15) NOT NULL | Field Format |
| 9 | PTPG_AGGREGATE | Character(3) | VARCHAR2(3) NOT NULL |
Aggregate Functions
AVG=Average CDI=Count Distinct CNT=Count MAX=Maximum MIN=Minimum NON=None SUM=Sum |
| 10 | PTPG_AXISINFO | Character(4) | VARCHAR2(4) NOT NULL |
Axis Information
COL=Column Axis ROW=Row Axis |
| 11 | PTPG_COLMNTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Column Type
DIM=Axis DISO=Display VAL=Value |
| 12 | PTPG_TOTAL | Character(3) | VARCHAR2(3) NOT NULL |
Total Name
Y/N Table Edit |
| 13 | PTPG_TRANSLATEOPT | Character(1) | VARCHAR2(1) NOT NULL |
Translate Option
1=No Xlat 2=Xlat Short 3=Xlat Long N=No Y=Yes Default Value: 1 |
| 14 | PTPG_FORMATTYPE | Number(3,0) | SMALLINT NOT NULL | Format Type |
| 15 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 16 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 17 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 18 | PTPG_TREE_EFFDT | Date(10) | DATE | Effective Date |
| 19 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: PSTREENODEPVW |
| 20 | PTPG_CURR_CTL_FLD | Character(30) | VARCHAR2(30) NOT NULL | Currency Control Field |
| 21 | PTPG_SHOWCURR_SYM | Character(1) | VARCHAR2(1) NOT NULL |
Show Currency Symbol
Y/N Table Edit Default Value: N |
| 22 | PTPG_SHOW1000_SEP | Character(1) | VARCHAR2(1) NOT NULL |
Display 1000 Separator
Y/N Table Edit Default Value: N |
| 23 | PTPG_ISEDITABLEFIL | Character(1) | VARCHAR2(1) NOT NULL |
Editable Facet (Only Fluid)
N=No Y=Yes Default Value: N |