| View Name: | ds_modeling_columns |
| View Number: | 5965 |
| Group: | Analytics |
| Description: | A view to the flat columns for modeling purposes. Used in the java code: DataSetOverviewSaveSB.java |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | se_session | objid | Internal record number of se_session | 3 (UNIQUE) |
| anls_objid | dm_analysis | objid | Internal record number of dm_analysis | |
| obj_objid | anls_object | objid | Internal record number of anls_object | |
| object_name | anls_object | name | Name of the object | |
| cols_objid | obj_column | objid | Internal record number of obj_column | |
| physical_name | obj_column | name | Name of the column | |
| description | obj_column | description | Column description | |
| bus_area | obj_column | category | Category or business area e.g. billing |
| Join From | Join To |
|---|---|
| (se_session).session2dm_analysis | (dm_analysis).dm_analysis2se_session |
| (dm_analysis).anls_modeling2anls_object | (anls_object).anls_modeling2dm_analysis |
| (obj_column).columns2anls_object | (anls_object).anls_object2obj_column |
| ds_modeling_columns | |||