OMF_ACTION_PRODUCT



Column Section Top of Page


Table-level Detail

Description: OMF ACTION PRODUCT
Definition: Lists OMF products which are interested when a given action occurs.
Table Type: REFERENCE





Column Detail - OMF_ACTION_PRODUCT


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.
LOG_ID_TYPE_CD DOUBLE N Log id type code value (e.g. for VERIFY, ORDER, etc.)
PRODUCT_CD DOUBLE N Product code value (e.g. SM COMPLETE)
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_APP_CTX_DAY_ST



Column Section Top of Page


Table-level Detail

Description: OMF Application Context Day summary table.
Definition: Holds daily statistics of information going into the application_context table.
Table Type: ACTIVITY





Column Detail - OMF_APP_CTX_DAY_ST


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N Number of the application which was run.
FREQUENCY DOUBLE Y Number of times logged out successfully.
LOG_INS DOUBLE Y # of times the application was started by the user.
MINUTES DOUBLE Y # of minutes connect for the day.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
START_DAY DATETIME N Day on which the app originally connected.


OMF_APP_CTX_MONTH_ST



Column Section Top of Page


Table-level Detail

Description: Monthly statistics of data stored on the application_context table.
Definition: OMF Application Context Monthly summary table
Table Type: ACTIVITY





Column Detail - OMF_APP_CTX_MONTH_ST


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N Application number from the application table.
FREQUENCY DOUBLE Y # of times successfully logged out.
LOG_INS DOUBLE Y # of times the user started the application.
MINUTES DOUBLE Y # of minutes connected.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
START_MONTH DATETIME N Month when app was started.


OMF_DASHBOARD



Column Section Top of Page


Table-level Detail

Description: This is the top level dashboard table, it stores all of the basic info.
Definition: Primary table for omf dashboards
Table Type: ACTIVITY





Column Detail - OMF_DASHBOARD


Column Name Type Null? Definition
DISTRIBUTED_IND DOUBLE Y Indicator whether the dashboard is distributed
NAME VARCHAR(50) N The Textual name of the dashboard
OMF_DASHBOARD_ID DOUBLE N Table key, unique identifier created by omf_seq
PATH VARCHAR(250) Y Contains the network path to the dashboard
PREV_DASHBOARD_ID DOUBLE N Contains a reference to the previous version of the dashboard, used to remove the previous version once the new version is distributed.
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.
VERSION DOUBLE N Contains the current version number for a dashboard


OMF_DASHBOARD_VIEWS



Column Section Top of Page


Table-level Detail

Description: Dashboard view information.
Definition: OMF_DASHBOARD_VIEWS
Table Type: ACTIVITY





Column Detail - OMF_DASHBOARD_VIEWS


Column Name Type Null? Definition
DRILL_DOWN_CD DOUBLE N DRILL_DOWN_CD
OMF_DASHBOARD_ID DOUBLE N Unique identifier for the omf_dashboard table
OMF_PV_ITEM_ID DOUBLE N OMF_PV_ITEM_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.