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 |