Table Detail Report

CV_COUNT_RESPONSE



Column Section Top of Page


Table-level Detail

Description: CV COUNT RESPONSE
Definition: This table reflects the value of each count
Table Type: REFERENCE





Column Detail - CV_COUNT_RESPONSE


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.
COUNT_ID DOUBLE N Foreign Key to this table.It is the primary identifier to CV_COUNT table
COUNT_RESPONSE_ID DOUBLE N This is the value of the unique primary identifier of the cv_count_response table. It is an internal system assigned number.
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.
LOGICAL_SYMBOL VARCHAR(5) Y Logical Symbols that indicates the type of operation e.g. >, =, <
RESPONSE_INTERNAL_NAME VARCHAR(50) Y The is a name stored internally for reference. It originates from cv_response table
RESULT_VAL VARCHAR(50) Y Result Value ofa clinical event.It is the same as that in the clinical event 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_DATASET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference table that stores names of datasets.
Definition: Reference table
Table Type: REFERENCE





Column Detail - CV_DATASET


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.
ALIAS_POOL_MEAN VARCHAR(12) Y Alias Pool Meaning from Alias Pool Code Set 263Column
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.
CASE_DATE_MEAN VARCHAR(12) Y Cdf_Meaning under code_set 25832. Used to indicate date meaning in certain dataset
DATASET_ID DOUBLE N The unique primary key that identifies a row.
DATASET_INTERNAL_NAME VARCHAR(50) N The name used by the system to store the record's name.
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.
DISPLAY_NAME VARCHAR(50) N The name that is displayed to the viewer.
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.
ERROR_TEXT_ID DOUBLE N The text that will be used to display when a field is in Error
UPDT_APP DOUBLE Y The front end application used to make changes to the record.
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 registered (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.
VALIDATION_SCRIPT VARCHAR(32) Y Validation script used by Dataset harvestColumn
WARNING_TEXT_ID DOUBLE N The Warning Text that will be used in the Audit and Error Log



Relationship Detail - CV_DATASET




Parent Column in CV_DATASET (PK) Child Table Name Child Column Name
Children: DATASET_ID CV_CASE_DATASET_R DATASET_ID
CV_DATASET_FILE DATASET_ID
CV_XREF DATASET_ID
CV_XREF_FIELD DATASET_ID


CV_DATASET_FILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV DATASET FILE
Definition: Table for listing the files required for the Harvest
Table Type: REFERENCE





Column Detail - CV_DATASET_FILE


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.
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 N 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 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.
COLUMN_NAME CHAR(30) Y Gives the column name of the table containing the partial name of the output file
DATASET_ID DOUBLE N This is a foreign key to this table. It is the unique identifier to CV_DATASET table
DELIMITER CHAR(1) Y The Character that defined the DelimiterColumn
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.
EXTENSION CHAR(3) Y The file name extensionColumn
FILE_ID DOUBLE N This is the value of the unique primary identifier of the cv_dataset_file table. It is an internal system assigned number
FILE_NBR DOUBLE Y The number of the file for the datasetColumn
FORMAT_STRING CHAR(18) Y The format for the stringColumn
NAME CHAR(30) Y The name of the fileColumn
TABLE_NAME CHAR(30) Y The table name containing the file nameColumn
UPDT_APP DOUBLE N The application number that is responsible for the row update.
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 N The registered (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_DATASET_FILE


Child Column in CV_DATASET_FILE(FK) Parent Table Name Parent Column Name
Parents: DATASET_ID CV_DATASET DATASET_ID




Parent Column in CV_DATASET_FILE (PK) Child Table Name Child Column Name
Children: FILE_ID CV_CASE_FILE_ROW FILE_ID
CV_XREF_FIELD FILE_ID


CV_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CVNet Devices
Definition: Stores Data related to CVNet Devices
Table Type: ACTIVITY





Column Detail - CV_DEVICE


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.
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 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.
CV_CASE_ID DOUBLE N This is the parent case in which the device was used.
DEVICE_ID DOUBLE N This is the unique identifier for a row in the CV_DEVICE table.
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.
LESION_ID DOUBLE N This is the parent lesion on which the device was used.
PARENT_EVENT_ID DOUBLE N The clinical event that is the parent field for the device (EVENT_ID column from CLINICAL_EVENT 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.



Relationship Detail - CV_DEVICE


Child Column in CV_DEVICE(FK) Parent Table Name Parent Column Name
Parents: CV_CASE_ID CV_CASE CV_CASE_ID
LESION_ID CV_LESION LESION_ID




Parent Column in CV_DEVICE (PK) Child Table Name Child Column Name
Children: DEVICE_ID CV_DEV_ABSTR_DATA DEVICE_ID


CV_DEVICE_LOCATION_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV DEVICE LOCATION RELATION
Definition: Stores the mappig between the Device name and Performing Location for which DBA has access to.
Table Type: ACTIVITY





Column Detail - CV_DEVICE_LOCATION_R


Column Name Type Null? Definition
ACTIVE_DEV_USER_IND DOUBLE N It represents the active row for a given device based on the logged in user.
CV_DEVICE_LOCATION_REF_ID DOUBLE N The Identifier of the Device Name - from the CV_DEVICE_LOCATION_REF table
CV_DEVICE_LOCATION_R_ID DOUBLE N PRIMARY KEY
DEFAULT_IND DOUBLE N Indicates if the device-performing location is set as a default.
PERFORMING_LOCATION_CD DOUBLE N Used to determine the code value associated in the codeset 220
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.
USER_ID DOUBLE N The Logged in user to powerchart who has Sign Privilege. This user id is different from updt_id.



Relationship Detail - CV_DEVICE_LOCATION_R


Child Column in CV_DEVICE_LOCATION_R(FK) Parent Table Name Parent Column Name
Parents: CV_DEVICE_LOCATION_REF_ID CV_DEVICE_LOCATION_REF CV_DEVICE_LOCATION_REF_ID
USER_ID PRSNL PERSON_ID