Table Detail Report
OMF_PVI_ATTRIB
Column Section | Top of Page |
Table-level Detail
Description: | OMF PVI ATTRIB |
Definition: | Component/viewer style attributes. |
Table Type: | REFERENCE |
Column Detail - OMF_PVI_ATTRIB
Column Name | Type | Null? | Definition |
---|---|---|---|
ATTRIB_ID | DOUBLE | N | Unique id for this component/viewer style attribute. |
ATTRIB_TYPE | VARCHAR(255) | Y | The 'name' of the attribute you are saving. E.g for a graph this could be 'Chart Style' or 'Title' |
COMPONENT_ID | DOUBLE | Y | Parent component or viewer style. |
OMF_PV_ITEM_ID | DOUBLE | Y | PowerVision saved view, template, or filter 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. |
VAL1 | VARCHAR(255) | Y | Generic column to hold attribute's value. |
VAL2 | VARCHAR(255) | Y | Generic column to hold attribute's value. |
VAL3 | VARCHAR(255) | Y | Generic column to hold attribute's value. |
VAL4 | VARCHAR(255) | Y | Generic column to hold attribute's value. |
VAL5 | VARCHAR(255) | Y | Generic column to hold attribute's value. |
OMF_PVI_ATT_VALUE
Column Section | Top of Page |
Table-level Detail
Description: | OMF PVI ATT VALUE |
Definition: | Holds lower level attribute values for PowerVision components and viewer styles. |
Table Type: | REFERENCE |
Column Detail - OMF_PVI_ATT_VALUE
Column Name | Type | Null? | Definition |
---|---|---|---|
ATTRIB_ID | DOUBLE | Y | Id of parent attribute. |
COMPONENT_ID | DOUBLE | Y | Id of parent PowerVision component. |
OMF_PV_ITEM_ID | DOUBLE | Y | Id of the parent PowerVision saved view or template. |
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 to hold values. |
VAL2 | VARCHAR(255) | Y | Generic string to hold values. |
VAL3 | VARCHAR(255) | Y | Generic string to hold values. |
VAL4 | VARCHAR(255) | Y | Generic string to hold values. |
VAL5 | VARCHAR(255) | Y | Generic string to hold values. |
VALUE_ID | DOUBLE | N | Unique id for this table. |
VALUE_TYPE | VARCHAR(255) | Y | Description of the type of value that is being stored. |
OMF_PVI_COMPONENT
Column Section | Top of Page |
Table-level Detail
Description: | OMF PVI COMPONENT |
Definition: | PowerVision components like grids and graphs. |
Table Type: | REFERENCE |
Column Detail - OMF_PVI_COMPONENT
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPONENT_ID | DOUBLE | N | Unique identifier of this component. |
NAME | VARCHAR(255) | Y | Name of the component |
OMF_PV_ITEM_ID | DOUBLE | Y | Parent PowerVision Saved View or Template. |
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 to store information. |
VAL2 | VARCHAR(255) | Y | Generic string to store information. |
VAL3 | VARCHAR(255) | Y | Generic string to store information. |
VAL4 | VARCHAR(255) | Y | Generic string to store information. |
VAL5 | VARCHAR(255) | Y | Generic string to store information. |
OMF_PVI_FILTER
Column Section | Top of Page |
Table-level Detail
Description: | PowerVision Filter information. |
Definition: | PowerVision Filter information. |
Table Type: | REFERENCE |
Column Detail - OMF_PVI_FILTER
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_NUM_ID | DOUBLE | Y | ID used in filtering - could be code_values, person_id's, encounter_id's, etc. |
BEG_PARENT_ENTITY_NAME | VARCHAR(255) | Y | Parent entity name for beg_num_id. |
BEG_VALUE | VARCHAR(255) | Y | Beginning string value - when not using an ID. |
END_NUM_ID | DOUBLE | Y | ID used in filtering - could be code_values, person_id's, encounter_id's, etc. - end of range; not used now. |
END_PARENT_ENTITY_NAME | VARCHAR(255) | Y | Parent entity name for end_num_id. |
END_VALUE | VARCHAR(255) | Y | Ending string value - when not using an ID. |
INDICATOR_CD | DOUBLE | N | Code value of the omf_indicator row that PowerVision is filtering on. Other codesets can be used besides 14265 depending on the team defining the value. |
OMF_PV_ITEM_ID | DOUBLE | N | Parent PowerVision Saved View or Filter. |
OPERAND | VARCHAR(255) | Y | Operand to use in filtering - e.g. != or = |
RVAL1 | VARCHAR(255) | Y | Result value1 used for clinical event filtering. |
RVAL2 | VARCHAR(255) | Y | Result value2 used for clinical event filtering. |
RVAL3 | VARCHAR(255) | Y | Result value3 used for clinical event filtering. |
RVAL4 | VARCHAR(255) | Y | Result value4 used for clinical event filtering. |
RVAL5 | VARCHAR(255) | Y | Result value5 used for clinical event filtering. |
SRVAL1 | VARCHAR(255) | Y | Sub result value1 used for microbiology filtering. |
SRVAL2 | VARCHAR(255) | Y | Sub result value2 used for microbiology filtering. |
SRVAL3 | VARCHAR(255) | Y | Sub result value3 used for microbiology filtering. |
SRVAL4 | VARCHAR(255) | Y | Sub result value4 used for microbiology filtering. |
SRVAL5 | VARCHAR(255) | Y | Sub result value5 used for microbiology filtering. |
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 filtering value - used by clinical event filtering currently. |
VAL2 | VARCHAR(255) | Y | Generic filtering value - used by clinical event filtering currently. |
VAL3 | VARCHAR(255) | Y | Generic filtering value - used by clinical event filtering currently. |
VAL4 | VARCHAR(255) | Y | Generic filtering value - used by clinical event filtering currently. |
VAL5 | VARCHAR(255) | Y | Generic filtering value - used by clinical event filtering currently. |
VALUE_TYPE_FLAG | DOUBLE | Y | Type of filter being stored. |
OMF_PVI_FOLDERS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OMF PVI FOLDERS |
Definition: | PowerVision Saved View, Filter and Template folders. |
Table Type: | REFERENCE |
Column Detail - OMF_PVI_FOLDERS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
FOLDER_ID | DOUBLE | N | Unique identifier of the folder. |
FOLDER_NAME | VARCHAR(255) | N | Name of folder. |
GRID_CD | DOUBLE | Y | Subject area that this folder is a part of. Not filled out for saved views only, e.g., for filter or template folders. Other codesets can be used besides 14265 depending on the team defining the value. |
GROUP_CD | DOUBLE | N | The user group that the folder is associated with. From user-defined codeset 13124 |
ITEM_TYPE_FLAG | DOUBLE | N | Type of item this folder holds. |
PARENT_ID | DOUBLE | N | ID of parent folder. |
PRSNL_GROUP_ID | DOUBLE | N | The group that this folder belongs to. |
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 | Person who owns this folder. |
Relationship Detail - OMF_PVI_FOLDERS
Child Column in OMF_PVI_FOLDERS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |