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