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 |
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: |
A4 | VARCHAR(50) | Y | Dependent on field_type(a,s,d,n) a: |
A5 | VARCHAR(50) | Y | Dependent on field_type(a,s,d,n) a: |
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/ |
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 |