Table Detail Report

CDI_IMPORT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cerner Document Imaging Import Type
Definition: This table defines the types of requests to import Document Imaging documents to the system.
Table Type: REFERENCE





Column Detail - CDI_IMPORT_TYPE


Column Name Type Null? Definition
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.
BATCH_PRIORITY_NBR DOUBLE Y 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_IMPORT_TYPE_ID DOUBLE N Unique generated number that identifies a single row on the CDI_IMPORT_TYPE table.
CONTENT_TYPE_NAME VARCHAR(60) Y CAMM content type name, if input type is XML files.
DEFAULT_BATCH_CLASS_NAME VARCHAR(32) Y The default name of the batch class.
DESTINATION_FOLDER_NAME VARCHAR(255) Y The destination folder name for files to import.
DOMAIN_NAME VARCHAR(20) Y The name of the domain this import type is for.
EMAIL_ADDRESSES_TEXT VARCHAR(500) Y A comma separated list of email addresses that will be notified of errors. In detail, this email address list is used for notifications if an error occurs in processing a feed.
IMPORT_TYPE_NAME VARCHAR(50) Y The name of a type of request for importing documents into the system.
INPUT_DIRECTORY_NAME VARCHAR(255) Y The source folder name for files to import.
INPUT_MASK_TEXT VARCHAR(10) Y A mask used to filter which files get imported by this import request type.
INPUT_TYPE_FLAG DOUBLE Y Type of input. (0 = text files, 1 = parse file names, 2 = XML files, 3 = filing and bursting)
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.
OVERLAY_FORM_NAME VARCHAR(50) N The name of a form that text or images can be overlayed to provide context to the data.
PARSE_DELIMITER_TEXT VARCHAR(5) Y The delimiter used to separate field values in the file name of the file being imported.
PARSE_FIELDS_TEXT VARCHAR(2000) Y The fields in the file name of the file being imported.
PURGE_AGE_HRS DOUBLE N The age (in hours) of the source files before they are purged.
REPORT_TYPE_IDENT VARCHAR(255) Y Identifies the report type associated with this type of import request.
TIME_ZONE VARCHAR(100) Y The default time zone for this import type.
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_IMPORT_TYPE


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




Parent Column in CDI_IMPORT_TYPE (PK) Child Table Name Child Column Name
Children: CDI_IMPORT_TYPE_ID CDI_IMPORT_JOB CDI_IMPORT_TYPE_ID
CDI_IMPORT_TYPE_SERVICE_R CDI_IMPORT_TYPE_ID


CDI_IMPORT_TYPE_SERVICE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cerner Document Imaging Import Type Service Relationship
Definition: Stores import type and service instance relationships.
Table Type: REFERENCE





Column Detail - CDI_IMPORT_TYPE_SERVICE_R


Column Name Type Null? Definition
CDI_IMPORT_TYPE_ID DOUBLE Y Unique number that identifies an import type.
CDI_IMPORT_TYPE_SERVICE_R_ID DOUBLE N Unique generated number that identifies a single row on the CDI_IMPORT_TYPE_SERVICE_R table.
CDI_SERVICE_INSTANCE_ID DOUBLE Y Unique number that identifies a service instance.
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_IMPORT_TYPE_SERVICE_R


Child Column in CDI_IMPORT_TYPE_SERVICE_R(FK) Parent Table Name Parent Column Name
Parents: CDI_IMPORT_TYPE_ID CDI_IMPORT_TYPE CDI_IMPORT_TYPE_ID
CDI_SERVICE_INSTANCE_ID CDI_SERVICE_INSTANCE CDI_SERVICE_INSTANCE_ID


CDI_LOGICAL_DOMAIN_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Logical Domain Configuration
Definition: Document Imaging logical domain-specific configuration.
Table Type: REFERENCE





Column Detail - CDI_LOGICAL_DOMAIN_CONFIG


Column Name Type Null? Definition
ALIAS_CONTRIB_SRC_CD DOUBLE N Specifies the contributor source to use when resolving document type aliases for this domain.
CDI_LOGICAL_DOMAIN_CONFIG_ID DOUBLE N Unique generated number that identifies a single row on the CDI_LOGICAL_DOMAIN_CONFIG table.
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_LOGICAL_DOMAIN_CONFIG


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


CDI_MIGRATED_FAILED



Column Section Top of Page


Table-level Detail

Description: cdi_migrated_failed
Definition: This table contains identifier of objects that failed to migrate from CAMM 6 to CAMM 7
Table Type: ACTIVITY





Column Detail - CDI_MIGRATED_FAILED


Column Name Type Null? Definition
CDI_MIGRATED_FAILED_ID DOUBLE N Unique generated number that identifies a single row on the cdi_migrated_failed table.
FAILED_TS DATETIME(6) Y The timestamp that the object was attempted to be migrated
FROM_LOCATION VARCHAR(128) Y The intended source url
OBJECT_IDENT VARCHAR(128) Y The CAMM object identifier of the CAMM object that failed to migrate
REASON_TEXT VARCHAR(4000) Y The reason for the failure
TO_LOCATION VARCHAR(128) Y The intended destination url


CDI_MIGRATION



Column Section Top of Page


Table-level Detail

Description: cdi_migration
Definition: This table contains identifiers of objects that need to be migrated from CAMM 6 to CAMM 7 as well as its status (ready, migrated, deleted)
Table Type: ACTIVITY





Column Detail - CDI_MIGRATION


Column Name Type Null? Definition
AX_APPID DOUBLE Y The applicationxtender application ID that corresponded to this CAMM Archive object identifier. This is used to track where to restart the migration fill if it is stopped.
AX_OBJECTID DOUBLE Y The applicationxtender object ID that corresponded to this CAMM Archive object identifier. This is used to track where to restart the migration fill if it is stopped.
AX_PAGE DOUBLE Y The applicationxtender page ID that corresponds to this CAMM Archive object identifier. This is used to track where to restart the migration fill if it is stopped.
AX_PATHID DOUBLE Y The path id in ApplicationXtender that was used to create this row.
BLOB_HANDLE VARCHAR(255) Y Allows system engineer running migrations to more easily correlate documents failing migration to affected patients, if a document should fail to migrate. In support of Cures All Patient Export PN 10531824, requirement for CAMM 7 for all-patient export.
CDI_MIGRATION_ID DOUBLE N Unique generated number that identifies a single row on the cdi_migration table.
DELETED_ID DOUBLE Y Indicates if an object identified by the object_ident column has been deleted from CAMM. A null value indicates that this object has not been deleted. If the object has been deleted from CAMM, this must match the value of the cdi_migration_ID column. This column is designed so that in the case that the application must restart, the application can quickly find its position in the deleting queue.
DELETED_TS DATETIME(6) Y Indicates when this object was deleted from CAMM 6. This is used for troubleshooting purposes.
ENQUEUED_TS DATETIME(6) Y Indicates when this object was enqueued in this table to be migrated. This is used for troubleshooting purposes.
FROM_LOCATION VARCHAR(128) Y The base URL of the CAMM 6 archive that the object was copied from.
MIGRATED_ID DOUBLE Y Indicates if an object identified by the object_ident column has been migrated from CAMM 6 to CAMM 7. A null value indicates that this object has not been migrated. If the object has been migrated from CAMM 6 to CAMM 7, this must match the value of the cdi_migration_ID column. This column is designed so that in the case that the application must restart, the application can quickly find its position in the migrating queue.
MIGRATED_TS DATETIME(6) Y Indicates when this object was migrated from CAMM 6 to CAMM 7. This is used for troubleshooting purposes.
OBJECT_IDENT VARCHAR(128) Y The unique identifier that identifies this object.
STATUS_FLAG DOUBLE N Indicates the status of the migration. The Migration status could have one of the following values:0 - Ready to migrate1 - Successfully migrated2 - Failure migrating3 - Successfully deleted
TO_LOCATION VARCHAR(128) Y The base URL of the CAMM 7 archive that the object was copied to.