Table Detail Report

CV_STEP_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV Step Scheduling
Definition: Stores scheduling and performing information for procedural steps in CV workflow.
Table Type: ACTIVITY





Column Detail - CV_STEP_SCHED


Column Name Type Null? Definition
ARRIVE_DT_TM DATETIME Y Date/Time patient arrived for the step
ARRIVE_IND DOUBLE N Indicates that patient has arrived for the step.
CV_PROC_ID DOUBLE N ID of procedure which contains this step
CV_STEP_ID DOUBLE N FK from the CV_STEP table.
CV_STEP_SCHED_ID DOUBLE N Primary key internally generated.
PERF_LOC_CD DOUBLE N ** OBSOLETE - NO LONGER USED**The exam room (service resource) the step is scheduled to be performed
PERF_PHYS_ID DOUBLE N ** OBSOLETE - NO LONGER USED**ID of primary personnel who performed the step
PERF_START_DT_TM DATETIME Y ** OBSOLETE - NO LONGER USED**The date/time that the step was started
PERF_STOP_DT_TM DATETIME Y ** OBSOLETE - NO LONGER USED**The date/time the step was stopped
SCHED_LOC_CD DOUBLE N The exam room (service resource) the step is scheduled to be performed
SCHED_PHYS_ID DOUBLE N ID of primary personnel scheduled to perform the step
SCHED_START_DT_TM DATETIME Y The date/time that the step is scheduled to start
SCHED_STOP_DT_TM DATETIME Y The date/time the step is scheduled to be completed
TASK_ASSAY_CD DOUBLE N Foreign key to cv_step_ref. Designates which reference step is being scheduled. An extension from Discreet Task Assay.
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_SCHED


Child Column in CV_STEP_SCHED(FK) Parent Table Name Parent Column Name
Parents: CV_PROC_ID CV_PROC CV_PROC_ID
CV_STEP_ID CV_STEP CV_STEP_ID
SCHED_PHYS_ID PRSNL PERSON_ID
SCHED_LOC_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


CV_STRING_TRANSLATION



Column Section Top of Page


Table-level Detail

Description: String Translation
Definition: Stores mapping between strings and corresponding cerner values.
Table Type: REFERENCE





Column Detail - CV_STRING_TRANSLATION


Column Name Type Null? Definition
CERNER_VAL VARCHAR(250) N Cerner value for string information.
CONTRIBUTOR_CD DOUBLE N Name of the source contributor.
CONTRIBUTOR_VAL VARCHAR(250) N Contributor value for string information.
CV_STRING_TRANSLATION_ID DOUBLE N Unique generated number that identifies a single row on the CV_STRING_TRANSLATION table.
FIELD_TYPE_CD DOUBLE N Type of string information. It can Medication or Provider information.
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_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference table that stores information about fields in a dataset.
Definition: Reference table
Table Type: REFERENCE





Column Detail - CV_XREF


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.
AUDIT_FLAG DOUBLE Y The flag that determines if a field is included in the minimum dataset (MDS). 0 = no; 1 = yes; 2 = other
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.
CERN_SOURCE_FIELD_NAME CHAR(30) Y The name of the table attribute (column) as defined in Cerner source table
CERN_SOURCE_TABLE_NAME CHAR(30) Y The source table name for Cerner.
COLLECT_START_DT_TM DATETIME Y The date and time to start collection of the registry field.
COLLECT_STOP_DT_TM DATETIME Y The date and time to stop collection of the registry field.
DATASET_ID DOUBLE N Foreign Key for this 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.
DISPLAY_FIELD_IND DOUBLE Y Not used
ELEMENT_NBR DOUBLE Y Registry defined ordering number for the element.
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 Error Text for the Field to be displayed in Audit and/or Error Log
EVENT_CD DOUBLE N Matching event code, if applicable.
EVENT_TYPE_CD DOUBLE N Set of codes that help to distingush between different eventsColumn
FIELD_TYPE_CD DOUBLE N The code describes the data type the field belongs
GROUP_TYPE_CD DOUBLE N Categorizes different types of event according to "ACC" grouping e.g. history,presentation etc.
REGISTRY_FIELD_NAME VARCHAR(100) N Name of the Registry Field.
REQD_FLAG DOUBLE Y This sets the log level .
SUB_EVENT_TYPE_CD DOUBLE N These are set of codes that identifies event types
TASK_ASSAY_CD DOUBLE N The task Assay code of the clinical event. There is a cdf_meaning associated with the "task_assay_cd" . This allows the value of an event to be retrieved from the code_value table.
UPDT_APP DOUBLE Y 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 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.
WARNING_TEXT_ID DOUBLE N The Warning Message to be displayed in Audit or Error Log
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.
XREF_INTERNAL_NAME VARCHAR(100) Y The internal name used to store the value for XREF_INTERNAL_NAME.



Relationship Detail - CV_XREF


Child Column in CV_XREF(FK) Parent Table Name Parent Column Name
Parents: DATASET_ID CV_DATASET DATASET_ID
ERROR_TEXT_ID LONG_TEXT LONG_TEXT_ID
WARNING_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in CV_XREF (PK) Child Table Name Child Column Name
Children: XREF_ID CV_XREF_FIELD XREF_ID
CV_XREF_VALIDATION XREF_ID


CV_XREF_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: CV XREF FIELD
Definition: This is the XREF field for each field on the output file
Table Type: REFERENCE





Column Detail - CV_XREF_FIELD


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.
DATASET_ID DOUBLE N Foreign Key. This is the unique identifier for CV_DATASET table
DISPLAY_NAME VARCHAR(40) Y Names shown on the screen.
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 containing this fieldColumn
FORMAT CHAR(18) Y FormatColumn
LENGTH DOUBLE Y LengthColumn
POSITION DOUBLE Y POSITIONColumn
START_POS DOUBLE Y Start PositionColumn
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.
XREF_FIELD_ID DOUBLE N This is the value of the unique primary identifier of the cv_xref_field table. It is an internal system assigned number
XREF_ID DOUBLE N Foreign Key . The xref_id is the unique identifier to cv_xref table.



Relationship Detail - CV_XREF_FIELD


Child Column in CV_XREF_FIELD(FK) Parent Table Name Parent Column Name
Parents: DATASET_ID CV_DATASET DATASET_ID
FILE_ID CV_DATASET_FILE FILE_ID
XREF_ID CV_XREF XREF_ID


CV_XREF_VALIDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Xref Validation table
Definition: THE Xref Validation table
Table Type: REFERENCE





Column Detail - CV_XREF_VALIDATION


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.
CHILD_RESPONSE_ID DOUBLE N Child Response idColumn
CHILD_XREF_ID DOUBLE N Child Xref idColumn
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.
OFFSET_NBR DOUBLE Y Used to get the offset for the Parent or the Child depending on the Relationship flag. For dates it is expressed in days
REQD_FLAG DOUBLE Y Sets the log level
RESPONSE_ID DOUBLE N Foreign Key . It the unique identifier to cv_response table
RLTNSHIP_FLAG DOUBLE Y Relationship FlagColumn
UPDT_APP DOUBLE Y 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 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.
XREF_ID DOUBLE N Foreign Key to this table. Xref_id is the unique row identifier for Cv_xref table
XREF_VALIDATION_ID DOUBLE N This is the value of the unique primary identifier of the cv_xref_validation. It is an internal system assigned number



Relationship Detail - CV_XREF_VALIDATION


Child Column in CV_XREF_VALIDATION(FK) Parent Table Name Parent Column Name
Parents: RESPONSE_ID CV_RESPONSE RESPONSE_ID
XREF_ID CV_XREF XREF_ID