Table Detail Report

CV_DEVICE_LOCATION_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV DEVICE LOCATION REF
Definition: Stores the Device name which will be mapped to a location for which DBA has access to.
Table Type: REFERENCE





Column Detail - CV_DEVICE_LOCATION_REF


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.
CV_DEVICE_LOCATION_REF_ID DOUBLE N PRIMARY KEY
DEVICE_NAME VARCHAR(1000) N Name of the Cardiovascular device
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.



Relationship Detail - CV_DEVICE_LOCATION_REF




Parent Column in CV_DEVICE_LOCATION_REF (PK) Child Table Name Child Column Name
Children: CV_DEVICE_LOCATION_REF_ID CV_DEVICE_LOCATION_R CV_DEVICE_LOCATION_REF_ID


CV_DEV_ABSTR_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: CVNet Device Abstract Data
Definition: OMF Summary Table for the CVNet Device Abstract Data
Table Type: ACTIVITY





Column Detail - CV_DEV_ABSTR_DATA


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DEVICE_ID DOUBLE N This is the primary key identifier to the CV_DEVICE table and serves as a foreign key to the CV_DEV_ABSTR_DATA table.
DEV_ABSTR_DATA_ID DOUBLE N This is the primary key identifier to the CV_DEV_ABSTR_DATA table.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EVENT_CD DOUBLE N Event code that represents the clinical event for the OMF Clinical Report
EVENT_ID DOUBLE N Uniquely identifies a logical clinical event row. There may be more than one row with the same event_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field. This is an EVENT_ID value from the CLINICAL_EVENT table.
EVENT_TYPE_CD DOUBLE N Event type code defines the group of data this particular event belongs for example Lesion, PTCA, Case, etc.
GROUP_TYPE_CD DOUBLE N Related events are grouped based on their nature or location
NOMENCLATURE_ID DOUBLE N Stores the identifier (from the nomenclature table) that stores the text for the result.
RESULT_CD DOUBLE N This is the coded result. It is used to identify a particular patient response to a clinical event (instead of nomenclature id).
RESULT_DT_TM DATETIME Y The date and time that the result_value was set.
RESULT_ID DOUBLE N This is the identifier for the result. It depends on the field type, but at the moment we only use it for PERSON_ID when the result_val is a person name. (The usage in the other CV_*_ABSTR_DATA tables).
RESULT_SOURCE VARCHAR(32) Y This is the source table for the result.
RESULT_VAL VARCHAR(255) Y The value associated with the abstract event
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.



Relationship Detail - CV_DEV_ABSTR_DATA


Child Column in CV_DEV_ABSTR_DATA(FK) Parent Table Name Parent Column Name
Parents: DEVICE_ID CV_DEVICE DEVICE_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


CV_ED_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV_ED_REVIEW
Definition: Stores information about an ED physician's review of a cardiology order and the cardiologist's subsequent review
Table Type: ACTIVITY





Column Detail - CV_ED_REVIEW


Column Name Type Null? Definition
CV_ED_REVIEW_ID DOUBLE N Primary key
ORDER_ID DOUBLE N Order ID to which the record is associated
REQUESTOR_PRSNL_ID DOUBLE N The Provider who requested the review.
REQUEST_DT_TM DATETIME Y The date and time when the request was placed.
REVIEWER_PRSNL_ID DOUBLE N The Provider who reviewed the request.
REVIEW_DT_TM DATETIME Y The date and time when the request was reviewed.
REVIEW_STATUS_CD DOUBLE N A code representing the status of tghe review request
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.
VALID_UNTIL_DT_TM DATETIME Y Date/Time used for versioning the states of a review request for an order.



Relationship Detail - CV_ED_REVIEW


Child Column in CV_ED_REVIEW(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
REQUESTOR_PRSNL_ID PRSNL PERSON_ID
REVIEWER_PRSNL_ID PRSNL PERSON_ID


CV_LESION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CVNet Summary table for storing CVNet OMF Clinical and Management Report data
Definition: Lesion -Stores data that are lesion related.
Table Type: ACTIVITY





Column Detail - CV_LESION


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LESION_ID DOUBLE N This is the unique identifier for a row in the table.
NUM_LES_COMPL DOUBLE Y Number of lesion complicationsColumn
PARENT_EVENT_ID DOUBLE N The parent Event ID to identify the Devices as belonging to a single deviceColumn
PROCEDURE_ID DOUBLE N This is the foreign key .
UPDT_APP DOUBLE Y The application number of the process that does the updating
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_REQ DOUBLE Y The request number of the application that update the process .
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CV_LESION




Parent Column in CV_LESION (PK) Child Table Name Child Column Name
Children: LESION_ID CV_DEVICE LESION_ID
CV_LES_ABSTR_DATA LESION_ID


CV_LES_ABSTR_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: CVNet Summary table that stores clinical events for "Omf clinical reports"
Definition: CVNet Summary table that stores clinical events for "Omf clinical reports"
Table Type: ACTIVITY





Column Detail - CV_LES_ABSTR_DATA


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EVENT_CD DOUBLE N Event codes represent clinical events. Used in "CVNet Omf " Clinical reports
EVENT_ID DOUBLE N The Event Id Associated with the Clinical EventColumn
EVENT_TYPE_CD DOUBLE N Event type code: Describes the type of event e.g. lesionColumn
GROUP_TYPE_CD DOUBLE N Group Type Code. Related events are grouped based on their nature or location e.g. Inlab,out of lab
LESION_ID DOUBLE N Lesion Id : It is a foreign key to this table.
LES_ABSTR_DATA_ID DOUBLE N This is the primary key or unique identifier of a row in the table
NOMENCLATURE_ID DOUBLE N This is a foreign key to this table and is the unique identifier to the nomenclature table
RESULT_CD DOUBLE N Result Code: This is the coded resultColumn
RESULT_DT_TM DATETIME Y The date and time of the result value. The value is in "DATE" format.
RESULT_ID DOUBLE N The Result Id for the Lesion Abstract DataColumn
RESULT_SOURCE VARCHAR(32) Y The Source table name for the result_idColumn
RESULT_VAL VARCHAR(255) Y Result value: This is the value of the clinical eventsColumn
UPDT_APP DOUBLE Y The application number that updates a row
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_REQ DOUBLE Y The request number of the application that updates the row
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CV_LES_ABSTR_DATA


Child Column in CV_LES_ABSTR_DATA(FK) Parent Table Name Parent Column Name
Parents: LESION_ID CV_LESION LESION_ID