Table Detail Report

OMF_STUDY_GROUP_ITEM



Column Section Top of Page


Table-level Detail

Description: OMF STUDY GROUP ITEM
Definition: Holds the IDs that make up the study group.
Table Type: REFERENCE





Column Detail - OMF_STUDY_GROUP_ITEM


Column Name Type Null? Definition
ENTITY_ID DOUBLE Y ID that we are storing - e.g. person_id, encntr_id, etc.
PARENT_ENTITY_NAME VARCHAR(255) Y Name of table that entity_id is from.
SG_ID DOUBLE N Parent study group.
SG_ITEM_ID DOUBLE N Unique identifier.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


OMF_STUDY_GROUP_TYPE



Column Section Top of Page


Table-level Detail

Description: Holds study group types such as PHYSICIAN, PATIENT, etc.
Definition: Study group types.
Table Type: REFERENCE





Column Detail - OMF_STUDY_GROUP_TYPE


Column Name Type Null? Definition
DESCRIPTION VARCHAR(255) Y Description of what this study group type is used for.
DISPLAY_FUNCTION VARCHAR(255) Y Function which can be used to re-display the ID - e.g. omf_get_pers_full for PATIENT and PHYSICIAN.
PARENT_ENTITY_NAME VARCHAR(255) Y Parent table for IDs that will be stored in this study group.
SG_TYPE VARCHAR(50) N Study group type.
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_USER_USAGE_ST



Column Section Top of Page


Table-level Detail

Description: OMF USER USAGE ST
Definition: Tracks PowerVision view usages per user and grid.
Table Type: ACTIVITY





Column Detail - OMF_USER_USAGE_ST


Column Name Type Null? Definition
GRID_CD DOUBLE N Grid which was viewed (cdf_meaning = 'GRID'). Other codesets can be used besides 14265 depending on the team defining the value.
LAST_VIEW_DT_TM DATETIME Y Date and Time this grid was last viewed for the user_id.
SV_TEMPL_NAME VARCHAR(255) Y Saved view or Template name used in creating a 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.
USER_ID DOUBLE N User which view the grid.
VIEW_CNT DOUBLE Y Number of times the user view the grid.


OMF_VIEWERS



Column Section Top of Page


Table-level Detail

Description: OMF VIEWERS
Definition: (PowerVision-style) viewers which uses the OMF core .dlls to retrieve data.
Table Type: REFERENCE





Column Detail - OMF_VIEWERS


Column Name Type Null? Definition
HAS_PROP_IND DOUBLE Y Does this viewer have a display properties screen? E.g. to define whether it's a pie chart vs. a bar chart; or where to put what data elements.
INST_STR VARCHAR(255) Y Instantiation string the OMF .dlls need to use to be able to call this viewer at run time.
OBJ_DESC VARCHAR(255) Y Description/name of the viewer.
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 Type of viewer that can be displayed. E.g a PowerVision grid/graph MDI, an advance data visualization tool, Risk Mgr viewer, IQHealth viewer, etc.


OMF_VIEWER_STYLE



Column Section Top of Page


Table-level Detail

Description: Holds viewer 'styles' which would hold, e.g., a graph style of 3D bar chart...
Definition: Holds viewer 'styles' which would hold, e.g., a graph style of 3D bar chart with a blue background; title of ....
Table Type: REFERENCE





Column Detail - OMF_VIEWER_STYLE


Column Name Type Null? Definition
DEFAULT_IND DOUBLE Y Indicates whether this style is the default value for the item_type.
NAME VARCHAR(255) Y User defined name of the viewer style.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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.
VAL1 VARCHAR(255) Y Generic string column.
VAL2 VARCHAR(255) Y Generic string column.
VAL3 VARCHAR(255) Y Generic string column.
VAL4 VARCHAR(255) Y Generic string column.
VAL5 VARCHAR(255) Y Generic string column.
VIEWER_STYLE_ID DOUBLE N Unique identifier.
VIEW_TYPE DOUBLE N Type of viewer this style is meant for.