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 |