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.