DIMENSION_IDA=Account
C=Country
P=Currency Partition
S=Standard
T=Time
Y=Type
Default Value: S
N=None
P=Prefix
S=Suffix
Default Value: P
DIMENSION(SQL Table) |
Index Back |
|---|---|
Dimension |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL | Dimension/Measure/Attribute |
| 2 | DIMENSION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Dimension Type
A=Account C=Country P=Currency Partition S=Standard T=Time Y=Type Default Value: S |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BLANK_MEMBER | Character(30) | VARCHAR2(30) NOT NULL | Blank Member |
| 5 | LABEL_DECOR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Label Prefix/Suffix
N=None P=Prefix S=Suffix Default Value: P |