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 |