CUB_OUTLINEIDQRYNAMEHEADING0=No Mapping
1=Dimension Map
2=Measure Map
Default Value: 0
PSCUBOUTQRYCOL(SQL Table) |
Index Back |
|---|---|
Cube Query Dimension Columns |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CUB_OUTLINEID |
Character(30) | VARCHAR2(30) NOT NULL | Outline Name (see PSCUBOUTLINE). |
| 2 | QRYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 3 | HEADING |
Character(30) | VARCHAR2(30) NOT NULL | Field Heading |
| 4 | CUB_DIMENSIONID | Character(30) | VARCHAR2(30) NOT NULL | Dimension Name (see PSCUBDIMENSION). |
| 5 | CUB_MAPTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Dimension Map Type
0=No Mapping 1=Dimension Map 2=Measure Map Default Value: 0 |