Table Detail Report

CV_MED_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV Medication Order relationship
Definition: Relates CV_PROC to ORDER (Pharmacy - Medication Orders)
Table Type: ACTIVITY





Column Detail - CV_MED_R


Column Name Type Null? Definition
CV_MED_R_ID DOUBLE N PRIMARY KEY
CV_PROC_ID DOUBLE N Procedure_ID of the Cardiovascular procedure from CV_PROC table for which a medication order has been placed
EVENT_ID DOUBLE N Event_ID for the action performed on the Pharmacy order from CLINICAL_EVENT table.
MED_REF_LOG_EVENT_VALUE DOUBLE N Medication Reference Event Value
PHARM_ORDER_ID DOUBLE N Order_ID of the pharmacy order from ORDERS table
STATUS_TXT VARCHAR(30) N The state indicates the point at which a failure occurred or a successful completion. The possible states: 0 - NOT STARTED 1 - IN PROCESS 2 - ORDER 3 - CLINICAL EVENT 4 - CHARGE 5 - COMPLETED
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_MED_R


Child Column in CV_MED_R(FK) Parent Table Name Parent Column Name
Parents: CV_PROC_ID CV_PROC CV_PROC_ID
PHARM_ORDER_ID ORDERS ORDER_ID


CV_NORMALCY_CLASSIFICATION



Column Section Top of Page


Table-level Detail

Description: Normalcy Classification
Definition: Stores the mapping between the ECG Classification Statements and Normalcy Indicator
Table Type: REFERENCE





Column Detail - CV_NORMALCY_CLASSIFICATION


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.
ACTIVITY_SUBTYPE_CD DOUBLE N Used to determine for what modality (Activity sub type) the corresponding interpretation would be used to calculate the normalcy
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CLASSIFICATION_STATEMENT VARCHAR(400) N System generated/Cardiologist provided interpretation of the study
CV_NORMALCY_CLASSIFICATION_ID DOUBLE N Primary Key
END_EFFECTIVE_DT_TM DATETIME N 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.
NORMALCY_INDICATOR_CD DOUBLE N States whether the result is normal, critical or abnormal.
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.


CV_OMF_INDICATOR



Column Section Top of Page


Table-level Detail

Description: Stores CDF_Meaning and Indicator_cd It is a reference table.
Definition: Stores CDF_Meaning and Indicator_cd.
Table Type: REFERENCE





Column Detail - CV_OMF_INDICATOR


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.
CDF_MEANING CHAR(12) Y The actual string value for the cdf meaning.Column
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.
INDICATOR_CD DOUBLE N Indicator's code value. cdf_meaning=INDICATOR, display = "indicator"Column
TASK_ASSAY_CD DOUBLE N The task Assay code of the clinical event. There is a cdf_meaning associated with the "task_assay_cd" . This allows the value of an event to be retrieved from the code_value table.
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.


CV_OPERATOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV OPERATOR
Definition: Reference table containing supported operators for algorithm calculations
Table Type: REFERENCE





Column Detail - CV_OPERATOR


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.
DESCRIPTION_2 VARCHAR(20) Y A description of the function of the operatorColumn
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.
LONG_TEXT_ID DOUBLE N Foreign key. CCL parser() function text.Column
NBR_OPERANDS DOUBLE Y The number of operands the operator requiresColumn
OPERATOR VARCHAR(20) N The operator (e.g. +, - )Column
OPERATOR_ID DOUBLE N Primary key for the table.Column
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_OPERATOR


Child Column in CV_OPERATOR(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


CV_ORDER_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV Order Category
Definition: Categories for orders viewed in cv patient profile
Table Type: REFERENCE





Column Detail - CV_ORDER_CATEGORY


Column Name Type Null? Definition
CATEGORY_LIMIT DOUBLE N Default number of orders displayed for category
CATEGORY_NAME VARCHAR(40) N Category name created by the user
COLLATION_SEQ DOUBLE N Sequence in which order category can be ordered
CV_ORDER_CATEGORY_ID DOUBLE N Primary key, unique identifier for the category
SECTION_ENUM DOUBLE N Indicates that the category or Section for the type of order (historical, current, etc.)
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




Parent Column in CV_ORDER_CATEGORY (PK) Child Table Name Child Column Name
Children: CV_ORDER_CATEGORY_ID CV_ORDER_CATEGORY_R CV_ORDER_CATEGORY_ID