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. |