Table Detail Report

CDI_DOCUMENT_SUBTYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Document Subtype
Definition: This table contains configuration information for CPDI document subtypes. Each document type will have base configuration in CDI_DOCUMENT_TYPE; document subtypes (identified by alias) will have configuration stored in CDI_DOCUMENT_SUBTYPE.
Table Type: REFERENCE





Column Detail - CDI_DOCUMENT_SUBTYPE


Column Name Type Null? Definition
CDI_DOCUMENT_SUBTYPE_ID DOUBLE N Unique ID for the CPDI document subtype. An internally generated number.
CDI_DOCUMENT_TYPE_ID DOUBLE N Document type that this subtype corresponds to; Foreign key referencing CDI_DOCUMENT_TYPE primary key.
COMBINE_ALL_IND DOUBLE N Specifies whether or not to combine all documents of this document type within a batch.
COMBINE_IND DOUBLE N Specifies whether or not to combine consecutive documents of this document type.
CONTRIBUTOR_SOURCE_CD DOUBLE N Specifies the contributor source the alias is associated to
DEFAULT_DATE_OF_SERVICE_FLAG DOUBLE N The default date of service for a document type if not specified for a given document. 0 - No Default date/time, 1 - Admit date/time, 2 - Pre-admit date/time, 3 - Discharge date/time, 4 - Scan date/time, 5 - Index date/time, 6 - Arrive date/time, 7 - Estimated Arrive date/time.
DOCUMENT_TYPE_ALIAS VARCHAR(255) Y Alias for this document type's event code.
MAX_PAGE_CNT DOUBLE N Specifies the maximum number of pages allowed for the resulting document when combining documents.
SUBJECT VARCHAR(255) Y Default subject for a document type.
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_DOCUMENT_SUBTYPE


Child Column in CDI_DOCUMENT_SUBTYPE(FK) Parent Table Name Parent Column Name
Parents: CDI_DOCUMENT_TYPE_ID CDI_DOCUMENT_TYPE CDI_DOCUMENT_TYPE_ID




Parent Column in CDI_DOCUMENT_SUBTYPE (PK) Child Table Name Child Column Name
Children: CDI_DOCUMENT_SUBTYPE_ID CDI_FORM CDI_DOCUMENT_SUBTYPE_ID
CDI_FORM_ACTIVITY CDI_DOCUMENT_SUBTYPE_ID


CDI_DOCUMENT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Document Type
Definition: This table contains configuration information for CPDI document types.
Table Type: REFERENCE





Column Detail - CDI_DOCUMENT_TYPE


Column Name Type Null? Definition
CATEGORY_CD DOUBLE N Specifies the category this document type should be grouped in.
CDI_AC_BATCHCLASS_ID DOUBLE N Ascent Capture batch class this configuration applies to. If batch class ID is not specified, it applies to all batch classes that don't have a batch class-specific configuration.
CDI_DOCUMENT_TYPE_ID DOUBLE N The unique primary key of this table. It is internally generated by Cerner.
CODE_SET DOUBLE N Specifies the code set for the event_cd field.
COMBINE_ALL_IND DOUBLE N Specifies whether or not to combine all documents of this document type within a batch.
COMBINE_IND DOUBLE N Specifies whether or not to combine consecutive documents of this document type.
DEFAULT_DATE_OF_SERVICE_FLAG DOUBLE N The default date of service for a document type if not specified for a given document. 0 - No Default date/time, 1 - Admit date/time, 2 - Pre-admit date/time, 3 - Discharge date/time, 4 - Scan date/time, 5 - Index date/time, 6 - Arrive date/time, 7 - Estimated Arrive date/time.
DELETE_FIRST_IND DOUBLE N Specifies whether or not to delete the first page of document of this document type.
EVENT_CD DOUBLE N Event code that corresponds to the CPDI document type. can be multiple code sets. Associated code set is stored in column CODE_SET.
MAX_PAGE_CNT DOUBLE N Specifies the maximum number of pages allowed for the resulting document when combining documents.
SEND_TO_MANUAL_IND DOUBLE N Specifies whether documents of this type should be sent to the manual queue automatically for indexing.
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_DOCUMENT_TYPE


Child Column in CDI_DOCUMENT_TYPE(FK) Parent Table Name Parent Column Name
Parents: CDI_AC_BATCHCLASS_ID CDI_AC_BATCHCLASS CDI_AC_BATCHCLASS_ID




Parent Column in CDI_DOCUMENT_TYPE (PK) Child Table Name Child Column Name
Children: CDI_DOCUMENT_TYPE_ID CDI_DOCUMENT_SUBTYPE CDI_DOCUMENT_TYPE_ID


CDI_DOCUMENT_TYPE_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Document Type List
Definition: Stores document type selection applied to a position or user.
Table Type: REFERENCE





Column Detail - CDI_DOCUMENT_TYPE_LIST


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CDI_DOCUMENT_TYPE_LIST_ID DOUBLE N Unique generated number that identifies a single row on the CDI_DOCUMENT_TYPE_LIST table.
CODE_SET DOUBLE N Specifies which code set the EVENT_CD field is from. Can be from code set 72 (clinical document types) or 26820 (non-clinical document types).
EVENT_CD DOUBLE N Code value of the document type for this row. Can be from code set 72 (clinical document types) or 26820 (non-clinical document types). associated code set is stored in column code_set.
POSITION_CD DOUBLE N Position code to which this list belongs. Examples are DBA, ADMIN, PATIENT. 0 value indicates list belongs to prsnl identified by PRSNL_ID.
PRSNL_ID DOUBLE N Provider to which this list belongs. 0 value indicates list belongs to the position identified by POSITION_CD.
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_DOCUMENT_TYPE_LIST


Child Column in CDI_DOCUMENT_TYPE_LIST(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


CDI_DOC_DYN_METADATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Document Dynamic Metadata
Definition: This table contains the dynamic (client defined) metadata, such as person and encounter aliases, used to index CPDI images into Millennium. The dynamic nature of the table allows for clients to choose which aliases will be used during the batch indexing process to identify the document's parent.
Table Type: ACTIVITY





Column Detail - CDI_DOC_DYN_METADATA


Column Name Type Null? Definition
ALIAS_TYPE_CD DOUBLE N Specifies the alias type for this data. The code set for this field can vary. It is stored in column ALIAS_TYPE_CODESET.
ALIAS_TYPE_CODESET DOUBLE N Specifies the code set for the ALIAS_TYPE_CDcolumn.
CDI_DOC_DYN_METADATA_ID DOUBLE N The unique primary key for this table. It is internally assigned by Cerner.
CDI_PENDING_DOCUMENT_ID DOUBLE N The ID of the pending document that this metadata is associated with.
FIELD_VALUE VARCHAR(200) Y The value of the data for this alias.
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_DOC_DYN_METADATA


Child Column in CDI_DOC_DYN_METADATA(FK) Parent Table Name Parent Column Name
Parents: CDI_PENDING_DOCUMENT_ID CDI_PENDING_DOCUMENT CDI_PENDING_DOCUMENT_ID


CDI_DOC_ENTITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI_DOC_ENTITY_RELTN
Definition: Table that relates cdi_pending_document id's to parent entity data for a document.
Table Type: ACTIVITY





Column Detail - CDI_DOC_ENTITY_RELTN


Column Name Type Null? Definition
CDI_DOC_ENTITY_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the CDI_DOC_ENTITY_RELTN table.
CDI_PENDING_DOCUMENT_ID DOUBLE N ID for batch class as defined on the CDI_AC_BATCHCLASS_ID table.
PARENT_ENTITY_ALIAS VARCHAR(200) Y Parent Entity Alias for associated pending document. There may be cases where the ID is not available. For example, ACCESSION_ID may not be available on the document but the ACCESSION string is. The string is what would be stored in this column.
PARENT_ENTITY_ID DOUBLE N Parent Entity Id for associated pending document.
PARENT_ENTITY_NAME VARCHAR(30) Y Parent Entity Name for associated pending 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_DOC_ENTITY_RELTN


Child Column in CDI_DOC_ENTITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: CDI_PENDING_DOCUMENT_ID CDI_PENDING_DOCUMENT CDI_PENDING_DOCUMENT_ID