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. |