Table Detail Report
CV_ORDER_CATEGORY_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CV Order Category Reltn |
Definition: | Relates cv_order_category to order catalog |
Table Type: | REFERENCE |
Column Detail - CV_ORDER_CATEGORY_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | Order catalog type from Order Catalog (code_value) |
CV_ORDER_CATEGORY_ID | DOUBLE | N | Foreign Key identifying the CV Order Category |
CV_ORDER_CATEGORY_R_ID | DOUBLE | N | Primary Key |
DETAIL_TXT | VARCHAR(255) | Y | Text displayed in detail pane for orderables |
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_ORDER_CATEGORY_R
Child Column in CV_ORDER_CATEGORY_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CV_ORDER_CATEGORY_ID | CV_ORDER_CATEGORY | CV_ORDER_CATEGORY_ID |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
CV_PROC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CV Procedure |
Definition: | Activity table storing below the line information for CV orders |
Table Type: | ACTIVITY |
Column Detail - CV_PROC
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | VARCHAR(20) | N | From ACCESSION. Identifies an order or group of orders. This is an alpha-numeric field. |
ACCESSION_ID | DOUBLE | N | Foreign key to ACCESSION |
ACTION_DT_TM | DATETIME | Y | Date and time the action was done. |
ACTIVITY_SUBTYPE_CD | DOUBLE | N | The activity subtype of the associated order (e.g. Echo, Non-Invasive Vascular) |
CATALOG_CD | DOUBLE | N | Foreign key to ORDER_CATALOG. The internal code of the order catalog item. |
CV_PROC_ID | DOUBLE | N | Primary key for rows in this table. |
ED_REVIEW_IND | DOUBLE | N | This is used as a flag to say whether or not an interpretation was ED reviewed. |
ENCNTR_ID | DOUBLE | N | Foreign key to ENCOUNTER. Encounter during which the procedure took place. |
GROUP_EVENT_ID | DOUBLE | N | The event_id on clinical_event of the procedure grouper event. |
NORMALCY_CD | DOUBLE | N | States whether the result is normal, critical or abnormal |
ORDER_ID | DOUBLE | N | Foreign key to ORDERS |
ORDER_PHYSICIAN_ID | DOUBLE | N | Foreign key to PRSNL. The physician who ordered the procedure |
ORIG_ORDER_DT_TM | DATETIME | Y | The original order date and time for this order |
PERSON_ID | DOUBLE | N | Foreign key to PERSON. Person who is the subject of the procedure. |
PHYS_GROUP_ID | DOUBLE | N | Foreign Key from table PRSNL_GROUP |
PRIM_PHYSICIAN_ID | DOUBLE | N | Foreign key to PRSNL. The Primary physician for this person or procedure |
PRIORITY_CD | DOUBLE | N | Priority of the order |
PROC_INDICATOR | VARCHAR(12) | Y | Procedure Indicator - supporting HEMO availability and others when needed in the future |
PROC_STATUS_CD | DOUBLE | N | Department status for the procedure |
REASON_FOR_PROC | VARCHAR(255) | Y | Text comments - Reason for the procedure |
REFER_PHYSICIAN_ID | DOUBLE | N | Foreign key to PRSNL. The physician who referred the patient for the procedure |
REQUEST_DT_TM | DATETIME | Y | The time requested in the order for the start of the first procedural step |
SEQUENCE | DOUBLE | N | Ordinal position of procedure within case |
STRESS_ECG_STATUS_CD | DOUBLE | N | Status of Stress ECG portion of a procedure with Stress ECG steps. |
STUDY_STATE_CD | DOUBLE | Y | A code that Indicates the state of the Procedure with respect to Exam Complete |
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. |
Relationship Detail - CV_PROC
Child Column in CV_PROC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCESSION_ID | ACCESSION | ACCESSION_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
PERSON_ID | PERSON | PERSON_ID | |
ORDER_PHYSICIAN_ID | PRSNL | PERSON_ID | |
PRIM_PHYSICIAN_ID | PRSNL | PERSON_ID | |
REFER_PHYSICIAN_ID | PRSNL | PERSON_ID | |
PHYS_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
Parent Column in CV_PROC (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CV_PROC_ID | CV_MED_R | CV_PROC_ID |
CV_STEP | CV_PROC_ID | ||
CV_STEP_SCHED | CV_PROC_ID |
CV_PROCEDURE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CVNet Summary Table-Used in storing non clinical events for OMF Management rep |
Definition: | Cvnet Omf Summary table |
Table Type: | ACTIVITY |
Column Detail - CV_PROCEDURE
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. |
CV_CASE_ID | DOUBLE | N | This is a foreign key and it is the unique identifier to the Cv_Case table |
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. |
DEPT_CD | DOUBLE | N | Used for CVNet Management reporting. |
DOC_INLAB_DT_TM | DATETIME | Y | The date and time the attending physician shows up in the lab |
DOC_PREP_MIN | DOUBLE | Y | The time the physician prepares before the procedure in minutes |
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_TYPE_CD | DOUBLE | N | Event type code defines the group of data this particular event belongs for example Lesion,PTCA. Case. etc. |
LOS_ADM_PROC | DOUBLE | Y | Length of Stay From the time the patient was admitted to the time a procedure was performed. |
LOS_PROC_DISCH | DOUBLE | Y | Length of Stay from the begining of the Procedure to Discharge |
NUM_LESION | DOUBLE | Y | Numbers of lesions attempted |
NUM_PROC_COMPL | DOUBLE | Y | Numbers of Procedure complicationsColumn |
NUM_PROC_IND | DOUBLE | Y | Numbers of procedure indications. Used for calculating the numbers of procedure |
NURSE_ID | DOUBLE | N | Nurse identity. This is the person id of the attending nurse or staff. It is derived from the person table |
PAT_ADM_DT_TM | DATETIME | Y | Patient Admission Date and time. |
PAT_ADM_IND | DOUBLE | Y | Patient Admision IndicatorColumn |
PAT_DEATH_IND | DOUBLE | Y | Patient death indicator. This attributes assist in calculating the mortality rate in "OMF" |
PAT_DISCH_DT_TM | DATETIME | Y | The time and date a patient is discharged |
PAT_DISCH_IND | DOUBLE | Y | An indicator to shows that a patient has been discharged |
PAT_INLAB_DT_TM | DATETIME | Y | The date and time a patient was in the lab |
PAT_INLAB_MIN | DOUBLE | Y | The time a patient spent in the lab calculated in minutes. |
PAT_WAIT_MIN | DOUBLE | Y | Patient waiting time expressed in minutes |
PROCEDURE_ID | DOUBLE | N | This is the unique identifier of a row |
PROC_COMPLETE_IND | DOUBLE | Y | An indicator that flags the completion of a procedure This is used in calculating the numbers of completed procedures |
PROC_DUR_MIN | DOUBLE | Y | The time in minutes the procedure lasted |
PROC_END_DT_TM | DATETIME | Y | The date and time the procedure ended |
PROC_NAME_CD | DOUBLE | N | Name of procedure . |
PROC_PHYSIC_ID | DOUBLE | N | Procedure physician id. This is derived from the person table. It is the primary indicator of the person table |
PROC_START_DAY | DOUBLE | Y | Procedure Start day. The day of the week the procedure was started e.g. 1 = Monday |
PROC_START_DT_TM | DATETIME | Y | Procedure Start date and time. The date and time the procedure was started |
PROC_START_HOUR | DOUBLE | Y | Hour of the day the procedure was started e.g. 10.00 |
PROC_START_MNTH | DOUBLE | Y | The month of the year the procedure was started |
TOTAL_PROC_COMPL | DOUBLE | Y | Total numbers of procedure complicationsColumn |
UPDT_APP | DOUBLE | Y | Registered (assigned) application number for the process that inserted or updated the 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 | registered of assigned request number for the process that inserted or updated the row |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CV_PROCEDURE
Child Column in CV_PROCEDURE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CV_CASE_ID | CV_CASE | CV_CASE_ID |
Parent Column in CV_PROCEDURE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROCEDURE_ID | CV_PROC_ABSTR_DATA | PROCEDURE_ID |
CV_PROC_ABSTR_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CVNet Omf Summary Table. Stores clinical events that are related to procedure. |
Definition: | CVNet Procedure Abstract data |
Table Type: | ACTIVITY |
Column Detail - CV_PROC_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 | Clinical eventsColumn |
EVENT_ID | DOUBLE | N | Clinical Event IdColumn |
GROUP_TYPE_CD | DOUBLE | N | Group Type Code. Related events are grouped based on their nature or location |
NOMENCLATURE_ID | DOUBLE | N | Foreign Key. It is used in "CVNet OMF " Management reportingColumn |
PROCEDURE_ID | DOUBLE | N | Foreign key. It is the primary key in "Cv_procedure" table |
PROC_ABSTR_DATA_ID | DOUBLE | N | Primary Key : The unique identifier of a row. |
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. ) Used in CVNet Management report |
RESULT_DT_TM | DATETIME | Y | The date and time of the result value. Thie value stored here is in date format |
RESULT_ID | DOUBLE | N | The id of the resultColumn |
RESULT_SOURCE | VARCHAR(32) | Y | The source of the result_idColumn |
RESULT_VAL | VARCHAR(255) | Y | The value of an event code. |
UPDT_APP | DOUBLE | Y | The request number of the application that updates or insert the process |
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 | he request number of the application that updates the process. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CV_PROC_ABSTR_DATA
Child Column in CV_PROC_ABSTR_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROCEDURE_ID | CV_PROCEDURE | PROCEDURE_ID |
CV_PROC_HX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CV Procedure Historical orders table |
Definition: | Stores Cardiology Historical Orders details coming inbound to Cerner system. |
Table Type: | ACTIVITY |
Column Detail - CV_PROC_HX
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_SUBTYPE_CD | DOUBLE | N | Internal coded value for the activity subtype of the associated order (e.g. echo, non-invasive vascular) |
COMPLETED_DT_TM | DATETIME | Y | The Date and Time when the exam was performed. |
COMPLETED_LOCATION_CD | DOUBLE | N | The unique identifier for the exam room in which the exam was performed. |
COMPLETED_TZ | DOUBLE | Y | The Time zone associated with the corresponding dt_tm column. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CV_PROC_HX_ID | DOUBLE | N | PRIMARY KEY |
ENCNTR_ID | DOUBLE | N | The unique Millennium identifier of the patient from encounter encounter table. Foreign key to an ENCOUNTER table. |
ENTRY_MODE_CD | DOUBLE | Y | Code that is used to identify the method in which a result was entered |
EVENT_CD | DOUBLE | Y | Code value that represents the type of result/report. i.e. rbc, Cardiac cath, ECG 12-lead, etc.. |
EVENT_ID | DOUBLE | Y | Event Identifier for a parent row from clinical event which this record is associated to |
FRGN_SYS_ACCESSION_REFERENCE | VARCHAR(200) | Y | Accession number from the foreign system for the procedure. This is an alphanumeric field. |
FRGN_SYS_ORDER_REFERENCE | VARCHAR(200) | Y | The unique identifier defined in the foreign system for order. This is an alphanumeric field. |
FRGN_SYS_STUDY_REFERENCE | VARCHAR(255) | Y | Study Identifier from the foreign system for the procedure. This is an alphanumeric field. |
ORDER_CATALOG_CD | DOUBLE | N | Internal coded value for the order catalog item. Foreign key to ORDER_CATALOG table. |
ORDER_ID | DOUBLE | N | The unique Identifier for the Millennium Order. Foreign key to the ORDERS table. |
PDF_DOC_IDENTIFIER | VARCHAR(250) | Y | field to hold the document identifier for the pdf store which is a MMF key. Added to support Migration Project |
PERSON_ID | DOUBLE | N | The unique Millennium Identifier of the person from PERSON table whom the order is placed for. Foreign key to the PERSON table. |
REFERENCE_TXT | VARCHAR(100) | Y | The combination of the reference nbr and the contributor system code provides a unique identifier to the origin of the clinical event data for the record. |
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. |
VENDOR_CD | DOUBLE | Y | The code value of the contributing source of the STUDY . The vendor code from code set 73. |
Relationship Detail - CV_PROC_HX
Child Column in CV_PROC_HX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
ORDER_ID | ORDERS | ORDER_ID | |
PERSON_ID | PERSON | PERSON_ID |