PSCUBDIMLIST(SQL Table) |
Index Back |
---|---|
Cube Outline Dimensions |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CUB_OUTLINEID | Character(30) | VARCHAR2(30) NOT NULL | Outline Name (see PSCUBOUTLINE). |
2 | CUB_DIMENSIONID | Character(30) | VARCHAR2(30) NOT NULL | Dimension Name (see PSCUBDIMENSION). |
3 | CUB_UNIQUECOL | Character(1) | VARCHAR2(1) NOT NULL |
Unique Members
Y/N Table Edit Default Value: N |
4 | CUB_STORAGEASO | Character(1) | VARCHAR2(1) NOT NULL |
ASO Storage Type
D=Dynamic H=Hierarchies S=Stored |
5 | CUB_STORAGEBSO | Character(1) | VARCHAR2(1) NOT NULL |
BSO Storage Type
D=Dense S=Sparse |