Table Detail Report

CV_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference table that stores information about responses for fields in a dataset.
Definition: Reference table
Table Type: REFERENCE





Column Detail - CV_RESPONSE


Column Name Type Null? Definition
A1 VARCHAR(100) Y Dependent on field_type(a,s,d,n) a : source value or d : date format (months=M, days=D, years=Y, hours=H, minutes=m, seconds=S, hundreths=h) n : #digits s : then #digits
A2 VARCHAR(50) Y Dependent on field_type(a,s,d,n) a: destination value d: convert blank value to n: blank value to s : convert blank value to
A3 VARCHAR(50) Y Dependent on field_type(a,s,d,n) a: d: convert unknown value to n: convert unknown value to s: convert to upper flag
A4 VARCHAR(50) Y Dependent on field_type(a,s,d,n) a: d: n: minimum value s:
A5 VARCHAR(50) Y Dependent on field_type(a,s,d,n) a: d: n: maximum value s:
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.
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.
FIELD_TYPE VARCHAR(1) Y Type of Field
FIELD_TYPE_CD DOUBLE N Type of Field Code. For future use.
NOMENCLATURE_ID DOUBLE N Foreign Key. This is the primary indicator for the nomenclature table
RESPONSE_ID DOUBLE N Primary key for this table.
RESPONSE_INTERNAL_NAME VARCHAR(255) Y The internal name used to store the Response Internal name.
UPDT_APP DOUBLE Y The front end application used to change records.
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 used to update records.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
XREF_ID DOUBLE N Foreign Key for this table.



Relationship Detail - CV_RESPONSE




Parent Column in CV_RESPONSE (PK) Child Table Name Child Column Name
Children: RESPONSE_ID CV_XREF_VALIDATION RESPONSE_ID


CV_SMART_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV SMART configurations
Definition: Stores configurations required to launch the third-party SMART apps. This table holds the configuration for tenant, facility and vendor level. Lookup hierarchy and will be as follows : First look at the facility level if one not exists then at tenant level.
Table Type: REFERENCE





Column Detail - CV_SMART_CONFIG


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.
ALL_FACILITY_IND DOUBLE Y Set this indicator to apply SMART configuration to all the facility under the tenant.
BROWSER_TFLG VARCHAR(250) Y Contains the information about the browser on which SMART app will be launched. Currently supported values are IE_EDGE, IE_CHROMIUM.
CV_SMART_CONFIG_ID DOUBLE N PRIMARY KEY
FACILITY_CD DOUBLE Y Contains the facility for which SMART app is associated.
LAUNCH_URL VARCHAR(500) Y Contains the URL of the SMART app. Example : https://smart.cerner.com/smart//apps/?PAT_PersonId={patientID}&VIS_EncntrId={EncntrId}&USR_PersonId={USRID}&username={USERNAME}
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MIGRATION_IND DOUBLE Y Indicates the study migration is completed when client is upgraded to the vendor agnostic viewer integrations. With this indicator set all the older studies will be able to launch on the new viewers or through SMART app of the vendor.
PRODUCT_START_DT_TM DATETIME Y Contains the date time of the usage of the new product ECG 2.0
TENANT_KEY VARCHAR(250) Y Contains the tenant key for which SMART app is associated.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 Contains the vendor code for the SMART app configured;
VIEWER_TYPE_TFLG VARCHAR(30) Y ; Type of the viewer used to launch the study. (PDF / DICOM / WEBVIEWER)



Relationship Detail - CV_SMART_CONFIG


Child Column in CV_SMART_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


CV_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV Procedure Step
Definition: Stores the status and details of individual steps of a procedure
Table Type: ACTIVITY





Column Detail - CV_STEP


Column Name Type Null? Definition
CV_DOC_ID_STR VARCHAR(100) Y Reference identifier for the type of document resulting from the step, if the step is in one of the below mentioned statuses-- Completed, - Saved, - Unsigned, - Discontinued, - Signed, - ED Review, - Prelim Read, - Arrived
CV_DOC_TEMPLATE_ID DOUBLE N Template Identifier for the type of template that would be loaded for the document resulting from the step, if the step is in one of the below mentioned statuses- Completed, Saved, Unsigned, Discontinued, Signed, ED Review, Prelim Read, Arrived
CV_DOC_TYPE_CD DOUBLE N The kind of document associated with this step, if the step is in one of the below mentioned statuses- Completed, Saved, Unsigned, Discontinued, Signed, ED Review, Prelim Read, Arrived
CV_PROC_ID DOUBLE N Parent procedure of the step
CV_STEP_ID DOUBLE N Primary key. Uniquely identifies a procedure step instance.
CV_STEP_IND DOUBLE N Indicates Whether the Step is active or not. 0 for Active and 1 for Inactive.
EVENT_ID DOUBLE N Event_id from clinical_event corresponding to the step.
LOCK_PRSNL_ID DOUBLE N The person_id of the user currently holding the lock on changes to the step. 0.0 indicatess that no lock is held.
MODALITY_CD DOUBLE Y This column contains the Modality Code of the Study that is matched to a procedure for acquisition step (from code set 4002763)
NORMALCY_CD DOUBLE Y The critical indicator for the mutliple step procedure. Supports the storage of the normalcy at the step level. we have multi step procedures and each procedure step gets the criticality from the third parties.
PDF_DOC_IDENTIFIER VARCHAR(250) Y Contains the document identifier for the pdf store which is a MMF key.
PERF_LOC_CD DOUBLE N The location where the step was performed (primarily for procedural steps)
PERF_PROVIDER_ID DOUBLE N ID of the provider who was primarily responsible for performing the step
PERF_START_DT_TM DATETIME Y The date/time that the step was started.
PERF_STOP_DT_TM DATETIME Y The date/time that the step was stopped (completed or discontinued)
PRELIMINARY_AUTHOR_ID DOUBLE N Preliminary Author ID - Value from the PRSNL table (FK)
SEQUENCE DOUBLE N Step Sequence
STEP_STATUS_CD DOUBLE N Department status of the step
STUDY_DT_TM DATETIME Y Study date and time which is sent from vendor during match.
STUDY_IDENTIFIER VARCHAR(250) Y Contains the Study Identifier sent from vendor which can be used to identify the study.
TASK_ASSAY_CD DOUBLE N Code for the Discrete Task Assay
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_STEP


Child Column in CV_STEP(FK) Parent Table Name Parent Column Name
Parents: CV_PROC_ID CV_PROC CV_PROC_ID
TASK_ASSAY_CD CV_STEP_REF TASK_ASSAY_CD
CV_DOC_TEMPLATE_ID DD_REF_TEMPLATE DD_REF_TEMPLATE_ID
LOCK_PRSNL_ID PRSNL PERSON_ID
PERF_PROVIDER_ID PRSNL PERSON_ID
PRELIMINARY_AUTHOR_ID PRSNL PERSON_ID
PERF_LOC_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in CV_STEP (PK) Child Table Name Child Column Name
Children: CV_STEP_ID CV_STEP_PRSNL CV_STEP_ID
CV_STEP_SCHED CV_STEP_ID


CV_STEP_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV Procedure Step Personnel
Definition: Stores personnel related to a step
Table Type: ACTIVITY





Column Detail - CV_STEP_PRSNL


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y the action_dt_tm captures the date and time that the person interacted with the step.
ACTION_SEQUENCE DOUBLE N used to keep step personnel in a specific sequence (the order in which they were entered)
ACTION_TYPE_CD DOUBLE N the action_type_cd identifies which action the person performed upon the detail step. (ex. completed, started, removed)
CV_STEP_ID DOUBLE N Cv_step_id is a foreign key to the cv_step table. it indicates which step the personnel are tied to.
CV_STEP_PRSNL_ID DOUBLE N The primary key for this table.
STEP_PRSNL_ID DOUBLE N the step_prsnl_id is a foreign key to the prsnl table. it identifies the person that interacted with the step.
STEP_RELATION_CD DOUBLE N the step_relation_cd identifies the role that the person took when interacting with the step. (ex: tech, nurse, cardiologist, 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_STEP_PRSNL


Child Column in CV_STEP_PRSNL(FK) Parent Table Name Parent Column Name
Parents: CV_STEP_ID CV_STEP CV_STEP_ID
STEP_PRSNL_ID PRSNL PERSON_ID


CV_STEP_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV Procedure Step Reference
Definition: Reference data describing procedure steps
Table Type: REFERENCE





Column Detail - CV_STEP_REF


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N Activity subtype code of the step. Correlates to the modality
DOC_ID_STR VARCHAR(255) Y Reference identifier for the type of document resulting from the step
DOC_TEMPLATE_ID DOUBLE N Document's Template Identifier for the type of template that would be loaded for the document resulting from the step.
DOC_TYPE_CD DOUBLE N The kind of document associated with this step
PROC_STATUS_CD DOUBLE N Procedure status from CV_PROC
SCHEDULE_IND DOUBLE Y Indicates if step can be scheduled
STEP_LEVEL_FLAG DOUBLE N Determines if a step can be shared across procedures in a case
STEP_TYPE_CD DOUBLE N The role which this step plays in the workflow of its associated procedures (e.g., Final Report, Referral Letter)
STUDY_RELTN_FLAG DOUBLE Y Relationship of step to study. 0 = no relation, 1 = requires prior study(s) to have study_state=MV for the step to count as complete for proc_status_cd calculation
TASK_ASSAY_CD DOUBLE N Code for the discrete_task_assay which corresponds to this step.
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_STEP_REF


Child Column in CV_STEP_REF(FK) Parent Table Name Parent Column Name
Parents: DOC_TEMPLATE_ID DD_REF_TEMPLATE DD_REF_TEMPLATE_ID
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD




Parent Column in CV_STEP_REF (PK) Child Table Name Child Column Name
Children: TASK_ASSAY_CD CV_STEP TASK_ASSAY_CD