...
Report Column Name | Description | Source |
---|---|---|
Table-View Name | This field displays the name of the Data Warehouse table or view. | MM_TABLE_VIEW.TABLE_NAME |
Column Name | This field displays the name of the column in the Data Warehouse table or view. | MM_TABLE_COLUMN.COLUMN_NAME |
Col DAL | This field identifies the minimum DAL assigned to the column. | If the value in MM_TABLE_COLUMN_UPDATE.MIN_DAL is null then the value in MM_TABLE_VIEW_UPDATE.MIN_DAL is used, else the value in MM_TABLE_COLUMN_UPDATE.MIN_DAL is used. |
Datatype | This field identifies the column datatype. | MM_TABLE_COLUMN.COLUMN_DATATYPE |
Nullable | This field identifies whether or not the column value can be null. | MM_TABLE_COLUMN.NULLABLE |
Data Source | This field displays the source of the data in the column. | MM_TABLE_COLUMN_UPDATE.SOURCE |
Column Comments | This field displays the column comments. | MM_TABLE_COLUMN.COLUMN_COMMENT |
Additional Comments | This field displays the additional column comments. The difference between Column Comments and Additional Comments is the Column Comments were originally derived from the Oracle data dictionary. The Additional Comments were manually added to the MetaMart. | MM_TABLE_COLUMN_UPDATE.ADDL_COMMENT |