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