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.