Table Detail Report
CDI_TRANS_MOD_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | cdi rans mod detail |
Definition: | This table tracks details for CPDI image modifications. |
Table Type: | ACTIVITY |
Column Detail - CDI_TRANS_MOD_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_SEQUENCE | DOUBLE | N | Action sequence column |
ACTION_TYPE_FLAG | DOUBLE | N | Description of the modification. (1=rotate, 2=delete, 3=add, 4=reorder, 5=cut, 6=copy, 7=annotate, 8=rollback, 9=add version, 10=ocr (optical character recognition), 11=modify text), 12 - resume checkout. |
CDI_TRANS_LOG_ID | DOUBLE | N | ID of the parent cdi_trans_log row. |
CDI_TRANS_MOD_DETAIL_ID | DOUBLE | N | Unique ID for each image modification detail. |
END_PAGE | DOUBLE | N | Last page of the document affected. |
POSITION | DOUBLE | N | New position of the pages in the document for reorder action. |
START_PAGE | DOUBLE | N | First page of the document affected. |
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_TRANS_MOD_DETAIL
Child Column in CDI_TRANS_MOD_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CDI_TRANS_LOG_ID | CDI_TRANS_LOG | CDI_TRANS_LOG_ID |
CDI_USER_FILTER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CDI User Filter |
Definition: | This table stores user defined filters that can be applied to filter the document list within the Document Library. |
Table Type: | REFERENCE |
Column Detail - CDI_USER_FILTER
Column Name | Type | Null? | Definition |
---|---|---|---|
BEGIN_DT_TM | DATETIME | N | Specifies the beginning date when filtering documents by date range (date range must be zero). |
CDI_USER_FILTER_ID | DOUBLE | N | The unique primary key of this table. It is internally generated by Millennium. |
DATE_RANGE_MONTHS | DOUBLE | N | Specifies the number of months worth of data should be displayed. If this field is set to zero the begin and end date range will be used instead. |
DOCUMENT_COUNT | DOUBLE | N | Specifies the maximum number of documents to be displayed. |
END_DT_TM | DATETIME | N | Specifies the end date when filtering documents by date range (date range must be zero). |
FILTER_NAME | VARCHAR(100) | N | The name of the filter. |
PERSON_ID | DOUBLE | N | Identifies the user this filter belongs 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. |
Relationship Detail - CDI_USER_FILTER
Child Column in CDI_USER_FILTER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
CDI_WORK_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CDI Work Item |
Definition: | This table represents a CPDI Work Item within the routing and queuing process. |
Table Type: | ACTIVITY |
Column Detail - CDI_WORK_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
AUTO_DIAL_IND | DOUBLE | N | Indicates whether or not this workitem is an auto dial. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CATEGORY_CD | DOUBLE | N | The generic category of the work item. Category is a generic concept that allows clients to define their own list of descriptors for a work item. Clients might have their own configurable codeset so it is documented as 0, |
CDI_WORK_ITEM_ID | DOUBLE | N | The unique primary key of this table. It is internally assigned. |
CLARIFY_REASON_CD | DOUBLE | N | The code value for the reason the work item was put in a clarify status. |
COMMENT_ID | DOUBLE | N | The link to the row on the long_text table which includes comments associated to the image. |
CREATE_DT_TM | DATETIME | N | The date and time the work item was added into the system. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
ORDERING_PROVIDER_ID | DOUBLE | N | Person ID from the PRSNL table. |
OWNER_PRSNL_ID | DOUBLE | N | The personnel identifier for the person who has ownership of the work item. If valued, this field means this person has the work item locked. |
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_work_item row is associated to. |
PREV_CDI_WORK_ITEM_ID | DOUBLE | N | Identifier of the currently effective row based off the begin/end effective date/time values |
PRIORITY_CD | DOUBLE | N | The priority of the work item. |
SCH_EVENT_ID | DOUBLE | N | The unique identifier for the requested/scheduled appointment. |
STATUS_CD | DOUBLE | N | The status of the work item. |
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_WORK_ITEM
Child Column in CDI_WORK_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREV_CDI_WORK_ITEM_ID | CDI_WORK_ITEM | CDI_WORK_ITEM_ID |
COMMENT_ID | LONG_TEXT | LONG_TEXT_ID | |
ORDERING_PROVIDER_ID | PRSNL | PERSON_ID | |
OWNER_PRSNL_ID | PRSNL | PERSON_ID | |
SCH_EVENT_ID | SCH_EVENT | SCH_EVENT_ID |
Parent Column in CDI_WORK_ITEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CDI_WORK_ITEM_ID | CDI_WORK_ITEM | PREV_CDI_WORK_ITEM_ID |
CDI_WORK_ITEM_ACTION | CDI_WORK_ITEM_ID | ||
CDI_WORK_ITEM_ATTRIBUTE | CDI_WORK_ITEM_ID | ||
CDI_WORK_QUEUE_ITEM_RELTN | CDI_WORK_ITEM_ID |
CDI_WORK_ITEM_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Work Item Action |
Definition: | This table records actions taken while processing a work item. |
Table Type: | ACTIVITY |
Column Detail - CDI_WORK_ITEM_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | N | The date & time of the action represented by this row. |
ACTION_PRSNL_ID | DOUBLE | N | The personnel ID of the user performing the action represented by this row. |
ACTION_TYPE_FLAG | DOUBLE | N | Flag indicating what type of action was performed. 0 - Patient Contact, 1 - Fax Out |
CDI_WORK_ITEM_ACTION_ID | DOUBLE | N | Unique generated number that identifies a single row on the CDI_WORK_ITEM_ACTION table. |
CDI_WORK_ITEM_ID | DOUBLE | N | Foreign key to the work item table. |
COMMENT_CD | DOUBLE | N | Specifies any predefined comment selected by the user for this action. |
FOLLOW_UP_DT_TM | DATETIME | Y | The date & time of the follow up action represented by this row. |
LONG_TEXT_ID | DOUBLE | N | Foreign key to the long_text table where the user entered comments are stored. |
OUTPUTCTX_HANDLE_ID | DOUBLE | N | Identifies the output context for outbound fax actions (foreign key to the outputctx 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_WORK_ITEM_ACTION
Child Column in CDI_WORK_ITEM_ACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CDI_WORK_ITEM_ID | CDI_WORK_ITEM | CDI_WORK_ITEM_ID |
LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
OUTPUTCTX_HANDLE_ID | OUTPUTCTX | HANDLE_ID | |
ACTION_PRSNL_ID | PRSNL | PERSON_ID |
CDI_WORK_ITEM_ATTRIBUTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CDI Work Item Attribute |
Definition: | Values for attributes of a CDI Work Item. |
Table Type: | ACTIVITY |
Column Detail - CDI_WORK_ITEM_ATTRIBUTE
Column Name | Type | Null? | Definition |
---|---|---|---|
ATTRIBUTE_CD | DOUBLE | N | Defines the type of attribute. |
ATTR_VALUE_CD | DOUBLE | N | Contains the code value for this attribute (codeset is configurable). |
ATTR_VALUE_TXT | VARCHAR(1024) | N | Contains the text value for this attribute. |
CDI_WORK_ITEM_ATTRIBUTE_ID | DOUBLE | N | Unique generated number that identifies a single row on the CDI_WORK_ITEM_ATTRIBUTE table. |
CDI_WORK_ITEM_ID | DOUBLE | N | The work item that this attribute applies to. |
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_WORK_ITEM_ATTRIBUTE
Child Column in CDI_WORK_ITEM_ATTRIBUTE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CDI_WORK_ITEM_ID | CDI_WORK_ITEM | CDI_WORK_ITEM_ID |