PTPG_PGRIDNAMEPTPG_VIEWNAMEUSERIDPTPG_FLR_SEQNOLANGUAGE_CDPSPGVIEWOPTLANG(SQL Table) |
Index Back |
|---|---|
Pivot Grid View Options RLR |
| # | 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_VIEWNAME |
Character(40) | VARCHAR2(40) NOT NULL | View Name |
| 3 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 4 | PTPG_FLR_SEQNO |
Number(4,0) | SMALLINT NOT NULL | Filter Sequence Number |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | PTPG_ROWS_GRID | Character(254) | VARCHAR2(254) NOT NULL | Row Fields |
| 7 | PTPG_CLMNS_GRID | Character(254) | VARCHAR2(254) NOT NULL | Column Fields |
| 8 | PTPG_FLRS_GRID | Character(254) | VARCHAR2(254) NOT NULL | Filter Fields |
| 9 | PTPG_FLRS_GRID_EX | Long Character(1333) | VARCHAR2(1333) | Grid Filters |
| 10 | PTPVG_VIEWDESCR | Character(254) | VARCHAR2(254) NOT NULL | View Description |
| 11 | PTPG_XFIELD_CHART | Character(254) | VARCHAR2(254) NOT NULL | X Axis Fields |
| 12 | PTPG_YFIELD_CHART | Character(254) | VARCHAR2(254) NOT NULL | Y Axis Fields |
| 13 | PTPG_FLRS_CHART | Character(254) | VARCHAR2(254) NOT NULL | Filter Fields |
| 14 | PTPG_SERIES_CHART | Character(254) | VARCHAR2(254) NOT NULL | Series Field |
| 15 | PTPG_OLAY_CHART | Character(254) | VARCHAR2(254) NOT NULL | Overlay Field |
| 16 | PTPG_PRIMARYFILTER | Character(254) | VARCHAR2(254) NOT NULL | Primary Filter |