Table Detail Report

CDI_ARCHIVE_FOLDER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CPDI Archive Folder Relation
Definition: Relates content management folders to archive configurations.
Table Type: REFERENCE





Column Detail - CDI_ARCHIVE_FOLDER_RELTN


Column Name Type Null? Definition
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.
CDI_ARCHIVE_FOLDER_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the CDI_ARCHIVE_FOLDER_RELTN table.
CDI_ARCHIVE_ID DOUBLE N Foreign key to the CDI_ARCHIVE table.
CDI_CM_FOLDER_ID DOUBLE N Foreign key to the CDI_CM_FOLDER 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.
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.



Relationship Detail - CDI_ARCHIVE_FOLDER_RELTN


Child Column in CDI_ARCHIVE_FOLDER_RELTN(FK) Parent Table Name Parent Column Name
Parents: CDI_ARCHIVE_ID CDI_ARCHIVE CDI_ARCHIVE_ID
CDI_CM_FOLDER_ID CDI_CM_FOLDER CDI_CM_FOLDER_ID


CDI_AXLIC_USAGE



Column Section Top of Page


Table-level Detail

Description: CDI AX License Usage
Definition: This table contains AX license usage information captured at various intervals. This data will be used for reporting purposes.
Table Type: ACTIVITY





Column Detail - CDI_AXLIC_USAGE


Column Name Type Null? Definition
CDI_AXLIC_USAGE_ID DOUBLE N The Cerner generated unique primary key of this table.
LICENSES_IN_USE_NBR DOUBLE N The total number of licenses in use at the time of the collection.
LICENSE_DT_TM DATETIME N The date and time the license usage information was collected.
LICENSE_GROUP_NM VARCHAR(128) N The name of the license group.
LICENSE_TYPE_FLAG DOUBLE N The type of license. 0 - AX License, 2 - ERMX License, 6 - WFX License, 7 - WX License.
TOTAL_LICENSES_NBR DOUBLE N The total number of licenses available in the group.
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.


CDI_BATCH_OTG_SIGN



Column Section Top of Page


Table-level Detail

Description: CDI_BATCH_OTG_SIGN
Definition: The CDI_BATCH_OTG_SIGN table contains rows representing "Completed Sign" clinical events stored as OTG documents. The status_cd for a row in the table changes as the document represented by the row is processed.
Table Type: ACTIVITY





Column Detail - CDI_BATCH_OTG_SIGN


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y Date & Time action was achieved.
ACTION_PRSNL_ID DOUBLE N Personnel ID of person who carried out the action.
ACTION_STATUS_CD DOUBLE N Resultant status of the action. Valid status are: cancelled; completed; requested; deleted; refused.
ACTION_TYPE_CD DOUBLE N Type of action. Valid types are: author/creator; transcribe; cancel; verify; correct; review; sign; cosign; modify.
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.
BLOB_EVENT_ID DOUBLE N Foreign key to the event table.
BLOB_HANDLE VARCHAR(255) Y Handle to remote blob
CDI_BATCH_OTG_SIGN_ID DOUBLE N Unique identifier generated for each row of data.
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.
EVENT_CD DOUBLE N It is the code that identifies the most basic unit of the storage, i.e. RBC, discharge summary, image.
EVENT_ID DOUBLE N Provides a mechanism for logical grouping of events. i.e. supergroup and group tests. Same as event_id if current row is the highest level parent.
EVENT_PRSNL_ID DOUBLE N Uniquely identifies a logical event prsnl row. There may be more than one row with the same event_prsnl_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
RESULT_STATUS_CD DOUBLE N Result status code. Valid values: authenticated, unauthenticated, unknown, cancelled, pending, in lab, active, modified, superseded, transcribed, not done.
STATUS_CD DOUBLE N Tracks the status of the process of signifying that the document tied to an event has been signed (i.e., a signature annotation has been affixed to the document). The status will reflect the most recent status of the document when processing was attempted. (PENDING, INPROCESS, OPENED, COMPLETE, INERROR)
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.


CDI_BATCH_SUMMARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Batch Summary
Definition: The CDI Batch Summary table
Table Type: ACTIVITY





Column Detail - CDI_BATCH_SUMMARY


Column Name Type Null? Definition
AC_QC_TIME DOUBLE Y Time (in seconds) the batch spend in the Ascent Capture QC module.
AC_REC_TIME DOUBLE Y Time (in seconds) the batch spend in the Ascent Capture Recognition module.
AC_REL_CNT DOUBLE Y Number of documents in the batch released from Ascent Capture.
AC_REL_DT_TM DATETIME Y Date and time the batch was released from Ascent Capture.
AC_REL_TIME DOUBLE Y Time (in seconds) the batch spend in the Ascent Capture Release module.
AC_SCAN_TIME DOUBLE Y Time (in seconds) the batch spend in the Ascent Capture Scan module.
AC_VALID_TIME DOUBLE Y Time (in seconds) the batch spend in the Ascent Capture Validation module.
AC_VERIFY_TIME DOUBLE Y Time (in seconds) the batch spend in the Ascent Capture Verification module.
AUTO_COMP_CNT DOUBLE Y Total number of documents that were processed through the auto index queue.
CDI_AC_BATCH_ID DOUBLE N AC Batch Identifier. Foreign key back to parent table CDI_AC_BATCH
CDI_BATCH_SUMMARY_ID DOUBLE N Primary key for this table.
COMBINED_CNT DOUBLE Y Number of documents combined away.
COMPLETE_CNT DOUBLE Y Number of complete documents in the batch.
CREATE_DT_TM DATETIME Y The date/time this entry was created.
CUR_AUTO_CNT DOUBLE Y Number of documents from the batch in the auto index queue.
CUR_MAN_CNT DOUBLE Y Number of documents from the batch in the manual index queue.
ECP_CNT DOUBLE Y Number of cover pages removed.
EXTERNAL_BATCH_IDENT DOUBLE N External batch identifier value
MAN_COMP_CNT DOUBLE Y Total number of documents that were processed through the manual index queue.
MAN_CREATE_CNT DOUBLE Y Number of documents created in the manual index queue.
MAN_DEL_CNT DOUBLE Y Number of documents deleted in the manual index queue.
PHARMACY_CNT DOUBLE N Number of documents from the bacth currently in the pharmacy queue.
PHARMACY_COMP_CNT DOUBLE N Total number of documents from the batch that have been completed in the pharmacy queue
PHARMACY_DEL_CNT DOUBLE N Number of documents from the batch deleted in the pharmacy queue
PREP_COMP_CNT DOUBLE Y Number of documents processed through the batch preparation queue.
TOT_AUTO_TIME DOUBLE Y Total time all documents spent in the auto index queue (in Sec). Divide by AUTO_COMP_CNT to get average time spent in the queue.
TOT_MAN_TIME DOUBLE Y Total time all documents spent in the manual index queue (in sec). Divide by AUTO_COMP_CNT to get average time spent in the queue.
TOT_PHARMACY_TIME DOUBLE N Total time all documents from the batch spent in the pharmacy queue. Divide by pharmacy_comp_cnt for the average time.
TOT_PREP_TIME DOUBLE Y Total time all documents spent in the batch preparation queue (in Sec). Divide by AUTO_COMP_CNT to get average time spent in the queue.
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.
WQM_CREATE_CNT DOUBLE N Number of documents created in Work Queue Management.
WQM_DEL_CNT DOUBLE N Number of documents deleted in Work Queue Management.



Relationship Detail - CDI_BATCH_SUMMARY


Child Column in CDI_BATCH_SUMMARY(FK) Parent Table Name Parent Column Name
Parents: CDI_AC_BATCH_ID CDI_AC_BATCH CDI_AC_BATCH_ID


CDI_CLIPBOARD



Column Section Relationship Section Top of Page


Table-level Detail

Description: cdi clipboard
Definition: This table acts as a clipboard for copying pages of a CDI document and pasting in a new/different document.
Table Type: ACTIVITY





Column Detail - CDI_CLIPBOARD


Column Name Type Null? Definition
ANNO_FILE VARCHAR(255) N Annotation filename for the copied page.
CDI_CLIPBOARD_ID DOUBLE N Unique ID for each copied page.
COPY_DT_TM DATETIME N Date and time the page was copied.
COPY_USER_ID DOUBLE N User who copied the page.
MEDIA_OBJECT_ANNO_IDENT VARCHAR(255) N MOM identifier for clipboard annotation file.
MEDIA_OBJECT_FILE_IDENT VARCHAR(255) N MOM identifier for clipboard image file.
OBJECT_FILE VARCHAR(255) N Object filename for the copied page.
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 - CDI_CLIPBOARD


Child Column in CDI_CLIPBOARD(FK) Parent Table Name Parent Column Name
Parents: COPY_USER_ID PRSNL PERSON_ID