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 |