Table Detail Report

CDI_RULE_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - CDI_RULE_CRITERIA


Column Name Type Null? Definition
CDI_RULE_CRITERIA_ID DOUBLE N Unique generated number that identifies a single row on the CDI_RULE_CRITERIA table.
CDI_RULE_ID DOUBLE N The rule that this criteria pertains to.
COMPARISON_FLAG DOUBLE N Indicates the type of comparison to perform. 0 - equals, 1 - less than, 2 - greater than, 3 - not equal, 4 - less than or equal, 5 - greater than or equal
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.
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.
VALUE_CD DOUBLE N the code value to compare against. code set will vary.
VALUE_DT_TM DATETIME Y Date value to compare against.
VALUE_ENTITY_ID DOUBLE Y This field contains the identifier for the parent table row.
VALUE_ENTITY_NAME VARCHAR(30) Y This field contains the name of table that this cdi_rule row is associated to.
VALUE_NBR DOUBLE N numeric value to compare against.
VALUE_TXT VARCHAR(100) N String value to compare against.
VARIABLE_CD DOUBLE N Identifies the variable (encounter data, etc.) that this criteria is evaluated against.



Relationship Detail - CDI_RULE_CRITERIA


Child Column in CDI_RULE_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: CDI_RULE_ID CDI_RULE CDI_RULE_ID


CDI_SCANNER



Column Section Top of Page


Table-level Detail

Description: cdi scanner
Definition: This table defines the network scanners available in the system.
Table Type: REFERENCE





Column Detail - CDI_SCANNER


Column Name Type Null? Definition
AUTO_CORRECT_IND DOUBLE N Indicates whether or not the scanner should automatically clean up the image.
BRIGHTNESS DOUBLE Y Default brightness level of the scanned image.
BUILDING_CD DOUBLE N Building in which the scanner is located.
CDI_SCANNER_ID DOUBLE N Unique identifier for each row (scanner) in the system.
CONTRAST_CD DOUBLE N Default contrast level of the scanned image.
DEPTH_CD DOUBLE N Default color depth used when scanning.
DUPLEX_IND DOUBLE N Indicates whether or not to scan in duplex.
FACILITY_CD DOUBLE N Facility in which the scanner is located.
JPEG_QUALITY DOUBLE Y Default quality for JPEG images. Valid values are 5 - 95. Higher number means higher quality, lower number means smaller file size.
NURSE_UNIT_CD DOUBLE N Nurse unit in which the scanner is located.
ORIENTATION DOUBLE N Default page orientation of document being scanned. 0 = Portrait; 1 = Landscape.
RESOLUTION_CD DOUBLE N Default resolution to be used when scanning.
ROOM_CD DOUBLE N Room in which the scanner is located.
SCANNER_DESCRIPTION VARCHAR(200) N Text description of the scanner.
SCANNER_IP_ADDRESS VARCHAR(15) N ip address of scanner
SCANNER_NAME VARCHAR(100) N Name of the scanner.
SCANNER_PATH VARCHAR(200) N Network path to be used for temporary image storage during scanning.
SIZE_CD DOUBLE N Default page size of document being scanned.
TIMEOUT DOUBLE N Number of minutes the system will wait for the user to scan a document prior to timing out.
TYPE_CD DOUBLE N Default file type the images will be scanned in from this device.
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_SERVICE_INSTANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cerner Document Imaging Service Instance
Definition: This table tracks installed/running CDI server instances
Table Type: REFERENCE





Column Detail - CDI_SERVICE_INSTANCE


Column Name Type Null? Definition
CDI_SERVICE_INSTANCE_ID DOUBLE N Unique generated number that identifies a single row on the CDI_SERVICE_INSTANCE table.
HOST_NAME VARCHAR(50) Y The services host machine name.
LOGICAL_DOMAIN_ID DOUBLE Y 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.
REGISTER_DT_TM DATETIME Y The last date and time that this service instance was executed.
SERVICE_NAME VARCHAR(50) Y The name of the service instance.
SERVICE_TYPE_FLAG DOUBLE Y Identifies this service instances service type.
SERVICE_USERNAME VARCHAR(50) Y The username of the user that the service is running under.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_SERVICE_INSTANCE


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




Parent Column in CDI_SERVICE_INSTANCE (PK) Child Table Name Child Column Name
Children: CDI_SERVICE_INSTANCE_ID CDI_IMPORT_TYPE_SERVICE_R CDI_SERVICE_INSTANCE_ID


CDI_SIGN_ANNO



Column Section Top of Page


Table-level Detail

Description: CDI Sign Annotation
Definition: This table contains information about signature annotations on CPDI images.
Table Type: ACTIVITY





Column Detail - CDI_SIGN_ANNO


Column Name Type Null? Definition
ANNO_VALID_IND DOUBLE N Indicates if the annotation is currently valid. Will be zero if the annotation has been removed.
CDI_SIGN_ANNO_ID DOUBLE N The unique ID of the signature annotation.
EVENT_PRSNL_ID DOUBLE N The ID of the signature row on the CE_EVENT_PRSNL table.
PAGE_NBR DOUBLE N The page number where the annotation is located within the 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.


CDI_TRANS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Transaction log.
Definition: This table holds the transaction rows of an indexed document submittal, failure, delete, and send to service for CDI applications and components.
Table Type: ACTIVITY





Column Detail - CDI_TRANS_LOG


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Date and time the action occurred.
ACTION_TYPE_FLAG DOUBLE N Description of the action. Submit = 0, Failed = 1, Send to service = 2, Delete =3, Modify = 4, Single document capture = 5, Receive = 6, Validate Manually = 7, Migrate = 8, Update Metadata = 9, Print = 10, Combine = 11, Split = 12, Copy = 13.
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_APPID DOUBLE N The Application Identification from the OTG database for this document.
AX_DOCID DOUBLE N The document Identification from the OTG database for this document.
BATCH_NAME VARCHAR(255) N Batch name from the document index.
BATCH_NAME_KEY VARCHAR(255) N Batch Name converted to upper case for case-insensitive indexed queries.
BLOB_HANDLE VARCHAR(255) Y Handle to the image stored in OTG DB.
BLOB_REF_ID DOUBLE N Foreign key to the BLOB_REFERENCE table.
BLOB_TYPE_FLAG DOUBLE N Indicates if image is a clinical event (0 - event id is valid), non-clinical event (1 - blob ref id is valid), or neither (2 - additional info store on ext table).
CDI_FORM_ID DOUBLE N Foreign key to the cdi_form table. Only populated if an action is performed on a patient form.
CDI_PENDING_DOCUMENT_ID DOUBLE N The ID of the pending document that the log row is related to.
CDI_QUEUE_CD DOUBLE N Queue the document was in prior to the transaction.
CDI_TRANS_LOG_ID DOUBLE N Unique identifier generated for each row of data.
COPY_CNT DOUBLE N The number of copies printed.
CREATE_DT_TM DATETIME N The date and time when the batch was created.
DEVICE_NAME VARCHAR(200) Y The name of the device that performed the action, such as the printer name.
DOCUMENT_TYPE_ALIAS VARCHAR(255) Y Alias for this document type's event code.
DOC_TYPE VARCHAR(50) Y Document type alias or value used to index the document.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_CD DOUBLE N Event code for the document.
EVENT_ID DOUBLE N Foreign key to the Clinical Event Table
EXTERNAL_BATCH_IDENT DOUBLE N The identifier of the external batch.
FINANCIAL_NBR VARCHAR(200) Y The enctr_nbr field from the document index. A financial_nbr in Cerner.
MAN_QUEUE_CAT_CD DOUBLE N Manual queue category code indicating high level reason doc sent to manual queue.
MAN_QUEUE_ERR_CD DOUBLE N Manual queue error code indicating specific error that send doc to manual queue.
MRN VARCHAR(200) Y The MRN from the document index.
PAGE_CNT DOUBLE N Number of pages in the document
PAGE_DELETED_CNT DOUBLE N Number of pages deleted in the document before transaction.
PARENT_ENTITY_ALIAS VARCHAR(200) N This field contains the parent alias that was used to index the associated document.
PARENT_ENTITY_ID DOUBLE N This field contrains the unique primary identifier for the row from the parent table identified in field parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(32) N This field contains the name of the table that this cdi_trans_log row is associated to.
PATIENT_NAME VARCHAR(255) Y The patient name index information from the document index.
PERF_PRSNL_ID DOUBLE N Personnel Id of the person that performed the document activity.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REASON_CD DOUBLE N Indicates the reason for the transaction.
SUBJECT VARCHAR(255) Y Free text subject of the document used in indexing.
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_TRANS_LOG


Child Column in CDI_TRANS_LOG(FK) Parent Table Name Parent Column Name
Parents: BLOB_REF_ID BLOB_REFERENCE BLOB_REF_ID
CDI_FORM_ID CDI_FORM CDI_FORM_ID
CDI_PENDING_DOCUMENT_ID CDI_PENDING_DOCUMENT CDI_PENDING_DOCUMENT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PERF_PRSNL_ID PRSNL PERSON_ID




Parent Column in CDI_TRANS_LOG (PK) Child Table Name Child Column Name
Children: CDI_TRANS_LOG_ID CDI_TRANS_MOD_DETAIL CDI_TRANS_LOG_ID