Table Detail Report
CV_CASE_FIELD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CV CASE FIELD |
Definition: | Table stored CV Case Related Field. |
Table Type: | ACTIVITY |
Column Detail - CV_CASE_FIELD
Column Name | Type | Null? | Definition |
---|---|---|---|
ABSTR_DATA_ID | DOUBLE | N | Primary key in cv_case_abstr_dataColumn |
ABSTR_DATA_NAME | VARCHAR(20) | Y | Table name: e.g. cv_case_abstr_data, etcColumn |
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. |
CASE_DATASET_R_ID | DOUBLE | N | Primary Key indicator.The unique primary key that identifies a row. |
CASE_FIELD_ID | DOUBLE | N | Primary Key indicator.The unique primary key that identifies a row. |
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. |
DEV_IDX | DOUBLE | Y | The Index of the Device to which this field is associated with |
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 unique identifier for a row in the cv_lesion table.Column |
LESION_IDX | DOUBLE | Y | The Index of the Lesion this Field is associated with. |
LONG_TEXT_ID | DOUBLE | N | The long text id in long_text table.Column |
PROCEDURE_ID | DOUBLE | N | This is the unique identifier of a row in cv_procedure.Column |
RESULT_VAL | VARCHAR(100) | Y | The result value of a clinical event |
STATUS_CD | DOUBLE | N | code value with code_set 25973 |
TRANSLATED_VAL | VARCHAR(100) | Y | Result ValueColumn |
UPDT_APP | DOUBLE | Y | The appication number of the application that updates the process |
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 | Update Reuest: The request number of the application that update the process. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
XREF_ID | DOUBLE | N | This is the value of the unique primary identifier of the cv_xref table. It is an internal system assigned number. |
Relationship Detail - CV_CASE_FIELD
Child Column in CV_CASE_FIELD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_DATASET_R_ID | CV_CASE_DATASET_R | CASE_DATASET_R_ID |
CV_CASE_FILE_ROW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CV CASE FILE ROW |
Definition: | CVNet table to store file related data |
Table Type: | ACTIVITY |
Column Detail - CV_CASE_FILE_ROW
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. |
CASE_DATASET_R_ID | DOUBLE | N | This is a foreign key in cv_case_file_row. It is a unique identifier and primary key in cv_case_dataset_r. |
CV_CASE_FILE_ROW_ID | DOUBLE | N | This is the value of the unique primary identifier of the cv_case_file_row 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. |
FILE_ID | DOUBLE | N | The File Id for this Case if it is documented in PowerFormsColumn |
LONG_TEXT_ID | DOUBLE | N | The long text id in long_text table.Column |
SEQ | DOUBLE | Y | sequence number for the long_text in case the length of the text exceeds the maximun of 32 kb in long text table. Default starts with 0. |
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. |
Relationship Detail - CV_CASE_FILE_ROW
Child Column in CV_CASE_FILE_ROW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_DATASET_R_ID | CV_CASE_DATASET_R | CASE_DATASET_R_ID |
FILE_ID | CV_DATASET_FILE | FILE_ID | |
LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
CV_COMPONENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CV COMPONENT |
Definition: | Reference table containing components of an algorithm and there atomic tokens. |
Table Type: | REFERENCE |
Column Detail - CV_COMPONENT
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. |
ALGORITHM_ID | DOUBLE | N | Foreign key for this tableColumn |
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. |
COMPONENT_ID | DOUBLE | N | The unique primary key that identifies a row. |
COMPONENT_TYPE_FLAG | DOUBLE | Y | 1 : component is used in validating an algorithm 2 : component is used in evaluating an algorithm 0 : component is used in both |
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. |
LONG_TEXT_ID | DOUBLE | N | Foreign key. The long_text row contains the textual, postfix notation for the component. |
MNEMONIC | VARCHAR(50) | Y | The component name, may be used in other components.Column |
MNEMONIC_KEY | VARCHAR(50) | N | The KEY of the mnemonic.Column |
MODIFIER | DOUBLE | Y | A value to multiply the result of a component by. A coefficient. If it's set to 0 or 1 it is ignored. |
PARENT_COMPONENT_ID | DOUBLE | N | Parent of this component. |
SOURCE_ID | DOUBLE | N | Some components consist of tokens that are found in the cv_xref or cv_response table, this is either it's xref_id or response_id, the source_name determines which. |
SOURCE_NAME | VARCHAR(30) | Y | Some components consist of tokens that are found in the cv_xref or cv_response table, this is either it's xref_id or response_id, the source_name determines which. |
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_COMPONENT
Child Column in CV_COMPONENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ALGORITHM_ID | CV_ALGORITHM | ALGORITHM_ID |
LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
CV_COUNT
Column Section | Top of Page |
Table-level Detail
Description: | This table reference the types of Counts to be performed e.g # of complications |
Definition: | This table reference the types of Counts to be performed e.g # of complications, # of Lesions etc. |
Table Type: | REFERENCE |
Column Detail - CV_COUNT
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_DESCRIPTION | VARCHAR(50) | Y | Descripes the types of different countsColumn |
COUNT_DESCRIPTION_KEY | VARCHAR(50) | Y | This descripes different types of count. It is capitalized and indexed for quick search routine |
COUNT_ID | DOUBLE | N | This is the value of the unique primary identifier of the cv_count 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. |
PARENT_ENTITY_NAME | VARCHAR(50) | Y | Name of the Parent tableColumn |
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_COUNT_DATA
Column Section | Top of Page |
Table-level Detail
Description: | Activity table that stores the facts (results) from cvnet omf data |
Definition: | Activity table that stores the facts (results) from cvnet omf data |
Table Type: | ACTIVITY |
Column Detail - CV_COUNT_DATA
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 | DOUBLE | N | Stores the value of different types of countColumn |
COUNT_DATA_ID | DOUBLE | N | This is the value of the unique primary identifier of the cv_count_data table. It is an internal system assigned number. |
COUNT_ID | DOUBLE | N | Foreign Key to this table. It is the unique identifier to cv_count table |
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. |
PARENT_ENTITY_ID | DOUBLE | N | This attributes identifies the primary key of the Parent tableColumn |
PARENT_ENTITY_NAME | VARCHAR(80) | Y | The name of Parent tableColumn |
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. |