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