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 |