Table Detail Report
OMF_VIEW_INDICATOR
Column Section | Top of Page |
Table-level Detail
Description: | Indicators (typically columns) related to a view in omf_view. |
Definition: | Indicators (typically columns) related to a view in omf_view which are filter_only indicators or indicators which have non-required joins in a view(_cd). |
Table Type: | REFERENCE |
Column Detail - OMF_VIEW_INDICATOR
Column Name | Type | Null? | Definition |
---|---|---|---|
INDICATOR_CD | DOUBLE | N | Indicator code value. Other codesets can be used besides 14265 depending on the team defining the value. |
REQUIRED_FILTER_IND | DOUBLE | Y | Indicates whether a filter is required for this indicator. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VIEW_CD | DOUBLE | N | View code value. Other codesets can be used besides 14265 depending on the team defining the value. |
VIEW_STR_SEQ1 | DOUBLE | Y | Indicates the from/where clause required for this indicator. |
VIEW_STR_SEQ2 | DOUBLE | Y | Indicates the from/where clause required for this indicator. |
VIEW_STR_SEQ3 | DOUBLE | Y | Indicates the from/where clause required for this indicator. |
WEIGHT_COLUMN_STR | VARCHAR(255) | Y | Column name with table abbreviation attached. Used to point filter weight calculations to a parent table in the PowerVision View. in star schema, this would typically be the foreign key on the fact table. |
OMF_VIEW_TYPE_GRID_R
Column Section | Top of Page |
Table-level Detail
Description: | View type/Grid code relationships for non-PowerVision and PV SA Editor apps. |
Definition: | For non-PowerVision/PV SA Editor application it will tell whether a grid_cd should run under a view_type. E.g. Risk Mgr subject areas only should be run under Risk Mgr (view_type = 2) |
Table Type: | REFERENCE |
Column Detail - OMF_VIEW_TYPE_GRID_R
Column Name | Type | Null? | Definition |
---|---|---|---|
GRID_CD | DOUBLE | N | Subject Area. Other codesets can be used besides 14265 depending on the team defining the value. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VIEW_TYPE | DOUBLE | N | View Type - e.g. 2 = Risk Manager; 1 = PowerVision grid/graph. |
OMF_VO_INDICATOR_GROUP
Column Section | Top of Page |
Table-level Detail
Description: | OMF View Option Indicator Group. |
Definition: | OMF view option indicator group |
Table Type: | REFERENCE |
Column Detail - OMF_VO_INDICATOR_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_INDICATOR_CD | DOUBLE | N | Child indicator code value. Other codesets can be used besides 14265 depending on the team defining the value. |
PARENT_INDICATOR_CD | DOUBLE | N | Parent indicator code. Other codesets can be used besides 14265 depending on the team defining thevalue. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VO_DISPLAY_SEQ | DOUBLE | N | VO display seq |
OMF_VO_TYPE
Column Section | Top of Page |
Table-level Detail
Description: | OMF View options types. |
Definition: | Top level information about PowerVision view options to be displayed |
Table Type: | REFERENCE |
Column Detail - OMF_VO_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
ABSTRACT_TABLE_NAME | VARCHAR(50) | Y | The name of the table from which the view engine will pull abstract data demographics info. |
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | The contributing source code |
MIN_PARAMS | DOUBLE | Y | Minimum number of options which must be chosen for this view option type. Not currently used. |
MULTIPLE_IND | DOUBLE | Y | Indicates whether more than one option may be chosen. Not currently used. |
TITLE | VARCHAR(100) | Y | Title to be displayed on the view option folder in PowerVision. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VO_ABSTRACT_FLAG | DOUBLE | Y | Determines if this data element is an abstract dimension or abstract fact. |
VO_INDICATOR_CD | DOUBLE | N | Generic indicator code value which this set of view option belongs to. Other codesets can be used besides 14265 depending on the team defining the value. |
VO_TYPE_CD | DOUBLE | N | Set of view options which may be chosen to appear on a grid. It is possible to use one of these for multiple grids. Other codesets can be used besides 14210 depending on the team defining the value. |
VO_TYPE_SEQ | DOUBLE | N | Sequence. For 'non-related' facts/dimensions there will only be 1 here. For 'related' facts/dimensions such as those involving event ranges there will be 2. |
OMF_VO_TYPE_DISPLAY
Column Section | Top of Page |
Table-level Detail
Description: | OMF View Option Type Display. |
Definition: | Contains the indicators and their ordering for a view option type. |
Table Type: | REFERENCE |
Column Detail - OMF_VO_TYPE_DISPLAY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
FILTER_ONLY_IND | DOUBLE | Y | Not currently used. |
REQUIRED_FILTER_IND | DOUBLE | Y | Not currently used. |
REQUIRED_IND | DOUBLE | Y | Not currently used. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VO_DISPLAY | VARCHAR(100) | Y | Text to display for this view option. |
VO_DISPLAY_SEQ | DOUBLE | N | Order to display this view option. |
VO_INDICATOR_CD | DOUBLE | N | Generic indicator code value of view option for vo_type_seq = 2. Other codesets can be used besides 14265 depending on the team defining the value. |
VO_TYPE_CD | DOUBLE | N | The group of view option indicators which this information applies to. Other codesets can be used besides 14210 depending on the team defining the value. |
VO_TYPE_SEQ | DOUBLE | N | Sequence which this information applies to. |