Table Detail Report

CDI_PENDING_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Pending Batch
Definition: This table represents a CPDI Batch within the batch capture process and contains information about the batch.
Table Type: ACTIVITY





Column Detail - CDI_PENDING_BATCH


Column Name Type Null? Definition
BATCH_CREATE_DT_TM DATETIME N Date the CDI Batch was created.
BATCH_NAME VARCHAR(255) N The name of the CDI Batch.
BATCH_PRIORITY_NBR DOUBLE N Specifies the priority of the batch. Batches are sorted and processed in priority order. Suggested values are 1 = High, 5 = Medium and 10 = Low.
CDI_AC_BATCHCLASS_ID DOUBLE N Foreign key to the CDI_AC_BATCHCLASS table.
CDI_PENDING_BATCH_ID DOUBLE N The unique primary key of this table.
EXTERNAL_BATCH_IDENT DOUBLE N Batch identifier from the external system.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
ORGANIZATION_ID DOUBLE N Used for filtering in cer_batchindexing at the user level.
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_PENDING_BATCH


Child Column in CDI_PENDING_BATCH(FK) Parent Table Name Parent Column Name
Parents: CDI_AC_BATCHCLASS_ID CDI_AC_BATCHCLASS CDI_AC_BATCHCLASS_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in CDI_PENDING_BATCH (PK) Child Table Name Child Column Name
Children: CDI_PENDING_BATCH_ID CDI_PENDING_DOCUMENT CDI_PENDING_BATCH_ID


CDI_PENDING_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Pending Document
Definition: This table represents a CPDI Document within the batch capture process and contains information about the document in the 3rd party imaging system. While a document is pending validation, values shall be as sent from external feeds and may not be consistent with each other (eg, encntr_id or person_id values may be invalid).
Table Type: ACTIVITY





Column Detail - CDI_PENDING_DOCUMENT


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.
AX_APP_IDENT DOUBLE N Identifier for the AX (3rd party) application in which the document is stored.
AX_DOC_IDENT DOUBLE N Document identifier within the AX (3rd party) system.
BIRTH_DT_TM DATETIME Y Birth date of the patient this document should be attached to. Used in batch indexing to help identify the correct patient.
BLOB_HANDLE VARCHAR(128) N Globally unique identifier for the document in the external system. Multiple rows with the same Blob Handle represent different versions of the document. Only the most recent row should be active.
CAPTURE_LOC_NAME VARCHAR(50) Y Location where the document was scanned.
CDI_FORM_ID DOUBLE N Foreign Key to the CDI_FORM table. The ID of the form the document is associated to.
CDI_PENDING_BATCH_ID DOUBLE N Foreign key to the CDI_PENDING_BATCH table.
CDI_PENDING_DOCUMENT_ID DOUBLE N The unique primary key of this table. It is internally generated by Cerner.
CONTRIBUTOR_SYSTEM_ALIAS VARCHAR(50) Y Alias for contributor_system_cd for documents from external feeds.
DOC_TYPE_ALIAS VARCHAR(255) Y Alias for the document type for this document. Used in batch indexing to help identify the correct document type.
DOC_TYPE_NAME VARCHAR(50) Y Display value for the document type for this document. Used in batch indexing to help identify the correct document type.
DOC_UPDT_DT_TM DATETIME Y For documents from external feeds, (external system) time the document was last updated.
ENCNTR_ID DOUBLE N Identifies the encounter the document should be attached to. (Not necessarily a foreign key; may be invalid prior to validation.)
EVENT_CD DOUBLE N Specifies the code value of the document type for this document.The code set for this column can be either 72 or 26820. The codeset value will be stored in column EVENT_CODESET.
EVENT_CODESET DOUBLE N Identifies the codeset for the event_cd field. Codeset 72 is used for clinical document, 26820 for non-clinical.
INDEX_LOCATION_VC DOUBLE Y Specifies the document's location within the batch indexing process, for active document rows in locations to be indexed. See PROCESS_LOCATION_FLAG for definition of valid flag values.
LOCATION_CD DOUBLE N Pending document location code.
PAGE_CNT DOUBLE N Specifies the number of pages in the document.
PARENT_ENTITY_ID DOUBLE N Identifier in the table specified by the parent_entity_name field: the parent the document should be attached to. (Not necessarily a foreign key; may be invalid prior to validation.)
PARENT_ENTITY_NAME VARCHAR(30) N Identifies the table representing the parent this document should be attached to.
PARENT_LEVEL_FLAG DOUBLE N Specifies the parent level for the document (0=default, 1=person level, 2=encounter level).
PATIENT_NAME VARCHAR(100) Y Name of the patient this document should be attached to. Used in batch indexing to help identify the correct patient.
PERFORMING_PROVIDER_ALIAS VARCHAR(200) Y Organization Doctor Number alias specifying the provider who performed this document.
PERFORMING_PROVIDER_ID DOUBLE N ID of the provider who performed this document.
PERSON_ID DOUBLE N Identifies the person the document should be attached to. (Not necessarily a foreign key; may be invalid prior to validation.)
PROCESS_LOCATION_FLAG DOUBLE N Specifies the document's location within the batch indexing process. 0=Complete, 1=Batch Indexing, 2=Manual Indexing, 3=Pharmacy, 4=Deleted, 5=Registration, 6 = Work Queue, 7 - Non-Clinical Batch Indexing, 8 - Non-Clinical Manual Indexing.
REFERENCE_NBR_TEXT VARCHAR(100) Y With contributor system, uniquely identifies a document from an external feed.
RESULT_STATUS_ALIAS VARCHAR(50) Y Alias for the documents result status code.
RESULT_STATUS_CD DOUBLE N Code value for the documents results status.
RX_PRIORITY_TEXT VARCHAR(40) Y Priority value for pharmacy images.
SCAN_DT_TM DATETIME Y Date and time specifying when the document was scanned.
SERVICE_DT_TM DATETIME Y Date and time specifying when the document was performed.
SOURCE_FLAG DOUBLE N Specifies the source of the document (0 = Batch Capture; 1 = Millennium Registration; 2 = 3rd Party Registration).
STATUS_FLAG DOUBLE N Indicates the status of the document. 0 - Pending, 1- In Progress, 2 - Complete.
SUBJECT_TEXT VARCHAR(255) Y Subject for this document.
SUBMIT_DT_TM DATETIME Y Specifies the date the document was submitted to the current processing location.
TRACKING_NBR_TEXT VARCHAR(50) Y External tracking number for this document.
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_PENDING_DOCUMENT


Child Column in CDI_PENDING_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_ID CDI_FORM CDI_FORM_ID
CDI_PENDING_BATCH_ID CDI_PENDING_BATCH CDI_PENDING_BATCH_ID
LOCATION_CD LOCATION LOCATION_CD
PERFORMING_PROVIDER_ID PRSNL PERSON_ID




Parent Column in CDI_PENDING_DOCUMENT (PK) Child Table Name Child Column Name
Children: CDI_PENDING_DOCUMENT_ID CDI_DOC_DYN_METADATA CDI_PENDING_DOCUMENT_ID
CDI_DOC_ENTITY_RELTN CDI_PENDING_DOCUMENT_ID
CDI_TRANS_LOG CDI_PENDING_DOCUMENT_ID


CDI_PURGE_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cerner Document Imaging Purge Document
Definition: Stores information about documents that require deletion and the status of previous deletion attempts
Table Type: ACTIVITY





Column Detail - CDI_PURGE_DOCUMENT


Column Name Type Null? Definition
BLOB_HANDLE VARCHAR(128) N Globally unique identifier for the document in the external system.
CDI_PURGE_DOCUMENT_ID DOUBLE N PRIMARY KEY
FAILURE_CNT DOUBLE N A count of how many prior failed attempts there have been to delete this document.
IN_PROGRESS_IND DOUBLE N Indicates if this document is in the process of being deleted.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
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_PURGE_DOCUMENT


Child Column in CDI_PURGE_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


CDI_REJECT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Reject Log
Definition: This table contains documents rejected by CPDI batch versioning.
Table Type: ACTIVITY





Column Detail - CDI_REJECT_LOG


Column Name Type Null? Definition
CDI_REJECT_LOG_ID DOUBLE N The unique identifier for this table.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
MATCH_EVENT_ID DOUBLE N The event id of the matching clinical event. It is a foreign key to the clinical_event table.
MATCH_STATUS_CD DOUBLE N The status code of the matching clinical event.
MATCH_UPDT_DT_TM DATETIME Y The update date and time of the matching clinical event.
REFERENCE_NBR VARCHAR(100) Y The reference number of hte rejected document.
REJECT_BIRTH_DT_TM DATETIME Y The birth date specified for the rejected document.
REJECT_DOC_TYPE VARCHAR(50) Y The document type specified for the rejected document.
REJECT_DT_TM DATETIME Y The date and time the document was rejected.
REJECT_FIN VARCHAR(200) Y The FIN number alias specified for the rejected document.
REJECT_MRN VARCHAR(200) Y The MRN alias specified for the rejected document.
REJECT_PATIENT_NAME VARCHAR(100) Y The patient name specified for the rejected document.
REJECT_PROVIDER VARCHAR(200) Y The provider specified for the rejected document.
REJECT_SERVICE_DT_TM DATETIME Y The service date and time specified for the rejected document.
REJECT_STATUS VARCHAR(255) Y The status specified for the rejected document.
REJECT_SUBJECT VARCHAR(255) Y The subject specified for the rejected document.
REJECT_UPDT_DT_TM DATETIME Y The update date specified for the rejected document.
REJECT_USER_ID DOUBLE N The identifier of the user who manually rejected the document.
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_REJECT_LOG


Child Column in CDI_REJECT_LOG(FK) Parent Table Name Parent Column Name
Parents: REJECT_USER_ID PRSNL PERSON_ID


CDI_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Rule
Definition: Defines a rule used to determine if the associated parent entity matches another entity's metadata.
Table Type: REFERENCE





Column Detail - CDI_RULE


Column Name Type Null? Definition
CDI_RULE_ID DOUBLE N Unique generated number that identifies a single row on the CDI_RULE table.
PARENT_ENTITY_ID DOUBLE N This field contains the identifier for the parent table row.
PARENT_ENTITY_NAME VARCHAR(30) N This field contains the name of table that this cdi_rule row is associated to.
REQUIRED_IND DOUBLE N Indicates if the parent entity matching this rule should be considered required.
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_RULE




Parent Column in CDI_RULE (PK) Child Table Name Child Column Name
Children: CDI_RULE_ID CDI_RULE_CRITERIA CDI_RULE_ID