DW_KEYELEMENT_TYPEA=Attribute
D=Dimension
M=Measure
DIMENSION_KEYFACT_MAP_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DW_KEY |
Number(10,0) | DECIMAL(10) NOT NULL | Key |
| 2 | ELEMENT_TYPE |
Character(6) | VARCHAR2(6) NOT NULL |
Element Type
A=Attribute D=Dimension M=Measure |
| 3 | DIMENSION_KEY |
Number(10,0) | DECIMAL(10) NOT NULL | Dimension Key |
| 4 | COLUMN_ID | Character(30) | VARCHAR2(30) NOT NULL | Column Name |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | ROLLED_LEVEL | Number(3,0) | SMALLINT NOT NULL | Rolled Level |