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 |