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