Table Detail Report

OMF_DEMO_BUILDER_ST



Column Section Top of Page


Table-level Detail

Description: OMF Demo Builder Summary Table
Definition: This table holds data for the OMF/PowerVision application and is populated by the OMF Demo Builder application. The data is used for on the fly views to represent client specific data.
Table Type: ACTIVITY





Column Detail - OMF_DEMO_BUILDER_ST


Column Name Type Null? Definition
DIMENSION1 VARCHAR(40) Y First Dimension of the PowerVision view defined by View_ID.
DIMENSION10 VARCHAR(40) Y Dimension 10 of the PowerVision view defined by View_ID.
DIMENSION11 VARCHAR(40) Y Dimension 11 of the PowerVision view defined by View_ID.
DIMENSION12 VARCHAR(40) Y Dimension 12 of the PowerVision view defined by View_ID.
DIMENSION13 VARCHAR(40) Y Dimension 13 of the PowerVision view defined by View_ID.
DIMENSION14 VARCHAR(40) Y Dimension 14 of the PowerVision view defined by View_ID.
DIMENSION15 VARCHAR(40) Y Dimension 15 of the PowerVision view defined by View_ID.
DIMENSION16 VARCHAR(40) Y Dimension 16 of the PowerVision view defined by View_ID.
DIMENSION17 VARCHAR(40) Y Dimension 17 of the PowerVision view defined by View_ID.
DIMENSION18 VARCHAR(40) Y Dimension 18 of the PowerVision view defined by View_ID.
DIMENSION19 VARCHAR(40) Y Dimension 19 of the PowerVision view defined by View_ID.
DIMENSION2 VARCHAR(40) Y Dimension 2 of the PowerVision view defined by View_ID.
DIMENSION20 VARCHAR(40) Y Dimension 20 of the PowerVision view defined by View_ID.
DIMENSION21 VARCHAR(40) Y Dimension 21 of the PowerVision view defined by View_ID.
DIMENSION22 VARCHAR(40) Y Dimension 22 of the PowerVision view defined by View_ID.
DIMENSION23 VARCHAR(40) Y Dimension 23 of the PowerVision view defined by View_ID.
DIMENSION24 VARCHAR(40) Y Dimension 24 of the PowerVision view defined by View_ID.
DIMENSION25 VARCHAR(40) Y Dimension 25 of the PowerVision view defined by View_ID.
DIMENSION3 VARCHAR(40) Y Dimension 3 of the PowerVision view defined by View_ID.
DIMENSION4 VARCHAR(40) Y Dimension 4 of the PowerVision view defined by View_ID.
DIMENSION5 VARCHAR(40) Y Dimension 5 of the PowerVision view defined by View_ID.
DIMENSION6 VARCHAR(40) Y Dimension 6 of the PowerVision view defined by View_ID.
DIMENSION7 VARCHAR(40) Y Dimension 7 of the PowerVision view defined by View_ID.
DIMENSION8 VARCHAR(40) Y Dimension 8 of the PowerVision view defined by View_ID.
DIMENSION9 VARCHAR(40) Y Dimension 9 of the PowerVision view defined by View_ID.
FACT1 DOUBLE Y Fact 1 of the PowerVision view defined by View_ID.
FACT10 DOUBLE Y Fact 10 of the PowerVision view defined by View_ID.
FACT11 DOUBLE Y Fact 11 of the PowerVision view defined by View_ID.
FACT12 DOUBLE Y Fact 12 of the PowerVision view defined by View_ID.
FACT13 DOUBLE Y Fact 13 of the PowerVision view defined by View_ID.
FACT14 DOUBLE Y Fact 14 of the PowerVision view defined by View_ID.
FACT15 DOUBLE Y Fact 15 of the PowerVision view defined by View_ID.
FACT16 DOUBLE Y Fact 16 of the PowerVision view defined by View_ID.
FACT17 DOUBLE Y Fact 17 of the PowerVision view defined by View_ID.
FACT18 DOUBLE Y Fact 18 of the PowerVision view defined by View_ID.
FACT19 DOUBLE Y Fact 19 of the PowerVision view defined by View_ID.
FACT2 DOUBLE Y Fact 2 of the PowerVision view defined by View_ID.
FACT20 DOUBLE Y Fact 20 of the PowerVision view defined by View_ID.
FACT21 DOUBLE Y Fact 21 of the PowerVision view defined by View_ID.
FACT22 DOUBLE Y Fact 22 of the PowerVision view defined by View_ID.
FACT23 DOUBLE Y Fact 23 of the PowerVision view defined by View_ID.
FACT24 DOUBLE Y Fact 24 of the PowerVision view defined by View_ID.
FACT25 DOUBLE Y Fact 25 of the PowerVision view defined by View_ID.
FACT3 DOUBLE Y Fact 3 of the PowerVision view defined by View_ID.
FACT4 DOUBLE Y Fact 4 of the PowerVision view defined by View_ID.
FACT5 DOUBLE Y Fact 5 of the PowerVision view defined by View_ID.
FACT6 DOUBLE Y Fact 6 of the PowerVision view defined by View_ID.
FACT7 DOUBLE Y Fact 7 of the PowerVision view defined by View_ID.
FACT8 DOUBLE Y Fact 8 of the PowerVision view defined by View_ID.
FACT9 DOUBLE Y Fact 9 of the PowerVision view defined by View_ID.
VIEW_ID_STR VARCHAR(10) Y Combination of the View Name and Grid Name used to uniquely define a group of rows to show in this PowerVision view.


OMF_FILTER_INDICATOR_ST



Column Section Top of Page


Table-level Detail

Description: OMF filter usage table
Definition: Stores number of times a given indicator was used as part of a filter
Table Type: ACTIVITY





Column Detail - OMF_FILTER_INDICATOR_ST


Column Name Type Null? Definition
FILTER_CNT DOUBLE Y Number of times the indicator was used in a filter
FILTER_NAME VARCHAR(255) Y Name of filter used when creating the view.
GRID_CD DOUBLE N PowerVision View which was filtered by the indicator. Other codesets can be used besides 14265 depending on the team defining the value.
INDICATOR_CD DOUBLE N Indicator which was used in a filter. Other codesets can be used besides 14265 depending on the team defining the value.
LAST_FILTER_DT_TM DATETIME Y Last time this indicator was used as a filter for the view
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.


OMF_FISCAL_CALENDAR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the fiscal date data from the OMF general ledger interface.
Definition: omf_fiscal_calendar
Table Type: REFERENCE





Column Detail - OMF_FISCAL_CALENDAR


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.
BEG_DT_NBR DOUBLE Y beg_dt_nbr
BEG_DT_TM DATETIME Y Begin Date and Time value
END_DT_NBR DOUBLE Y end_dt_nbr
END_DT_TM DATETIME Y end_dt_tm
FISCAL_PER DOUBLE Y fiscal_per
FISCAL_PER_YR VARCHAR(10) Y fiscal_per_yr
FISCAL_QTR DOUBLE Y fiscal_qtr
FISCAL_QTR_YR VARCHAR(10) Y fiscal_qtr_yr
FISCAL_YR DOUBLE Y fiscal_yr
INTERVAL_TYPE_CD DOUBLE N interval_type_cd
INTERVAL_VALUE DOUBLE Y interval_value
NBR_PERIODS DOUBLE Y nbr_periods
OMF_FISCAL_CALENDAR_ID DOUBLE N The unique identifier for the omf_fiscal_calendar table.
PREV_OMF_FISCAL_CALENDAR_ID DOUBLE N prev_omf_Fiscal_calendar_id
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.



Relationship Detail - OMF_FISCAL_CALENDAR




Parent Column in OMF_FISCAL_CALENDAR (PK) Child Table Name Child Column Name
Children: OMF_FISCAL_CALENDAR_ID OMF_ACC_FACT OMF_FISCAL_DATE_ID
OMF_ACR_FACT OMF_FISCAL_DATE_ID
OMF_BLS_FACT OMF_FISCAL_DATE_ID
OMF_ICS_BDGT OMF_FISCAL_DATE_ID
OMF_ICS_FACT OMF_FISCAL_DATE_ID


OMF_PV_DATA_XLATE



Column Section Top of Page


Table-level Detail

Description: translates column headers in imported data to summary table
Definition: translates column headers in column headings in the imported data to summary table columns, also contains attributes for each field in the imported data
Table Type: REFERENCE





Column Detail - OMF_PV_DATA_XLATE


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(40) Y The name of the column header in the imported CSV
DATE_IND DOUBLE Y Set to 1 if the imported data is a date.
FILTER_IND DOUBLE Y Indicates whether this column is filterable.
PD_GRID_CD DOUBLE N Uniquely defines the grid
PK_IND DOUBLE Y Indicates whether this column is part of the logical primary key for update/insert logic.
ST_COLUMN_NAME VARCHAR(40) N The name of the column in OMF_PV_DATA_ST where this column will be stored.
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.


OMF_PV_DIMENSIONS



Column Section Top of Page


Table-level Detail

Description: Contains IDs for filterable columns
Definition: Contains IDs for filterable columns. Used to store the display values for strings that will be used as filters.
Table Type: ACTIVITY





Column Detail - OMF_PV_DIMENSIONS


Column Name Type Null? Definition
DISPLAY VARCHAR(80) Y Contains the text that should be displayed for this dimension
OMF_ID DOUBLE N Unique number for this string value. This is what will be stored in the OMF_PV_DATA_ST table in one of the NUM columns.
PD_GRID_CD DOUBLE Y Defines the grid that this data is used for.
ST_COLUMN_NAME VARCHAR(40) Y This is the summary table column where this data will be stored.