|
Column
|
Description
|
|
fact_table
|
name of the fact table
|
|
fact_display_value
|
display value of the fact table
|
|
fact_description
|
description of the fact table
|
|
fact_type
|
a character value indicating the fact type
D - detail
R - rollup / combined
S - kpi
P - detail partitioned
Q - rollup partitioned
else unknown
|
|
column_name
|
column name
|
|
business_name
|
business name chosen for the column
|
|
description
|
description of the fact column
|
|
data_type
|
data type of the fact column
|
|
source_table
|
source table of the fact table
|
|
source_column
|
source column of the dimension column
|
|
nulls_allowed
|
flag indicating whether or not nulls are allowed
|
|
numeric
|
flag indicating whether or not the column is numeric
|
|
additive
|
flag indicating whether or not the column is additive
|
|
attribute
|
flag indicating whether or not the column is an attribute
|
|
format
|
the fact column format
|
|
column_order
|
the fact column order
|