FUN_STATISTIC_VALUES
This tables holds the value of an indivdual statistic.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FUN_STATISTIC_VALUES_PK |
STATISTIC_VALUE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| STATISTIC_VALUE_ID | NUMBER | 18 | Yes | STATISTIC_VALUE_ID | ||
| STATISTIC_DEFN_ID | NUMBER | 18 | Yes | COLUMN1 | ||
| STATISTIC_VALUE | VARCHAR2 | 120 | Yes | STATISTIC_VALUE | ||
| STATISTIC_GROUP_ID | NUMBER | 18 | Yes | STATISTIC_GROUP_ID | ||
| INITIAL_GROUP_ID | NUMBER | 18 | Yes | INITIAL_GROUP_ID | ||
| INFORMATION_TYPE | VARCHAR2 | 30 | INFORMATION_TYPE | Statistic Dimension (FUN_STATISTIC_VALUES_DF) | ||
| INFORMATION1 | VARCHAR2 | 120 | INFORMATION_TYPE1 | Statistic Dimension (FUN_STATISTIC_VALUES_DF) | ||
| INFORMATION2 | VARCHAR2 | 120 | INFORMATION_TYPE2 | |||
| INFORMATION3 | VARCHAR2 | 120 | INFORMATION_TYPE3 | |||
| INFORMATION4 | VARCHAR2 | 120 | INFORMATION_TYPE4 | |||
| INFORMATION5 | VARCHAR2 | 120 | INFORMATION_TYPE5 | |||
| INFORMATION6 | VARCHAR2 | 120 | INFORMATION_TYPE6 | |||
| INFORMATION7 | VARCHAR2 | 120 | INFORMATION_TYPE7 | |||
| INFORMATION8 | VARCHAR2 | 120 | INFORMATION_TYPE8 | |||
| INFORMATION9 | VARCHAR2 | 120 | INFORMATION_TYPE9 | |||
| INFORMATION10 | VARCHAR2 | 120 | INFORMATION_TYPE10 | |||
| INFORMATION11 | VARCHAR2 | 120 | INFORMATION_TYPE11 | |||
| INFORMATION12 | VARCHAR2 | 120 | INFORMATION_TYPE12 | |||
| INFORMATION13 | VARCHAR2 | 120 | INFORMATION_TYPE13 | |||
| INFORMATION14 | VARCHAR2 | 120 | INFORMATION_TYPE14 | |||
| INFORMATION15 | VARCHAR2 | 120 | INFOMRATION_TYPE15 | |||
| INFORMATION16 | VARCHAR2 | 120 | INFORMATION_TYPE16 | |||
| INFORMATION17 | VARCHAR2 | 120 | INFORMATION_TYPE17 | |||
| INFORMATION18 | VARCHAR2 | 120 | INFORMATION_TYPE18 | |||
| INFORMATION19 | VARCHAR2 | 120 | INFORMATION_TYPE19 | |||
| INFORMATION20 | VARCHAR2 | 120 | INFORMATION_TYPE20 | |||
| INFORMATION21 | NUMBER | 32 | INFORMATION_TYPE21 | |||
| INFORMATION22 | NUMBER | 32 | INFORMATION_TYPE22 | |||
| INFORMATION23 | NUMBER | 32 | INFORMATION_TYPE23 | |||
| INFORMATION24 | NUMBER | 32 | INFOMRATION_TYPE24 | |||
| INFORMATION25 | NUMBER | 32 | INFORMATION_TYPE25 | |||
| INFORMATION26 | DATE | INFOMRATION_TYPE26 | ||||
| INFORMATION27 | DATE | INFORMATION_TYPE27 | ||||
| INFORMATION28 | DATE | INFORMATION_TYPE28 | ||||
| INFORMATION29 | DATE | INFORMATION_TYPE29 | ||||
| INFORMATION30 | DATE | INFORMATION_TYPE30 |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_STATISTIC_VALUES_N1 | Non Unique | Default | STATISTIC_DEFN_ID, STATISTIC_GROUP_ID, INFORMATION_TYPE |
| FUN_STATISTIC_VALUES_PK | Unique | FUSION_TS_SEED | STATISTIC_VALUE_ID |