Table Detail Report

TASK_ACTIVITY_ASSIGN_MSG_H



Column Section Relationship Section Top of Page


Table-level Detail

Description: Task Activity Assignment Message History
Definition: Storese every add and update of messages on the task activity assignment table.
Table Type: ACTIVITY





Column Detail - TASK_ACTIVITY_ASSIGN_MSG_H


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.
ASSIGN_EMAIL_INFO_ID DOUBLE N The id of the email_info row containing information about the email recipient.
ASSIGN_PERSON_ID DOUBLE N The recipient of the message if the task is assigned to an Iqhealth consumer.
ASSIGN_PRSNL_GROUP_ID DOUBLE N The prsnl_group_id, from the prsnl_group table, that identifies which group the message is assigned.
ASSIGN_PRSNL_ID DOUBLE N The ID of the person to whom the task is assigned.
BEG_EFF_DT_TM DATETIME Y The beginning date/time that the assignment is effective.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
COPY_TYPE_FLAG DOUBLE Y A flag to determine how a user was copied on a message. Zero indicates they were in the "To:" field. One indicates they were in the "CC:" field.0
END_EFF_DT_TM DATETIME Y The ending date/time that the assignment is/was effective.
EVENT_PRSNL_ID DOUBLE N Uniquely identifies a logical event prsnl row. There may be more than one row with the same event_prsnl_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
INSERT_DT_TM DATETIME N The date and time the row was originally inserted.
INTENDED_RECIPIENT_GROUP_ID DOUBLE N The identifier of a group of intended recipient(s). This field will be non-zero for a task that was routed to a pool instead of the intended recipient(s) due to pool rule(s) existing for the intended recipient(s). The intended recipients of the task are stored on task_intended_recipient.
MSG_TEXT_ID DOUBLE N Text of message
PROXY_PRSNL_ID DOUBLE N The ID of the person to whom has proxy to the task. SEQUENCE NAME: PERSON_ONLY_SEQ
REMIND_DT_TM DATETIME Y The date and time for which Reminders will display in the Inbox.
REPLY_ALLOWED_IND DOUBLE N Indicates whether the task assignment may be replied to by the recipient to which it was assigned (0-reply not allowed, 1-reply allowed). This only applies to tasks with a task type of PHONE MSG.
SCHEDULED_DT_TM DATETIME Y The date and time for which tasks will become overdue in the Inbox.
TASK_ACTIVITY_ASSIGN_ID DOUBLE N A unique identifier for the assignment record,
TASK_ACTIVITY_ASSIGN_MSG_H_ID DOUBLE N Unique generated number that identifies a single row on the TASK_ACTIVITY_ASSIGN_MSG_H table.
TASK_ID DOUBLE N A unique identifier for the task that was assigned.
TASK_STATUS_CD DOUBLE N This field identifies the status of the task
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 - TASK_ACTIVITY_ASSIGN_MSG_H


Child Column in TASK_ACTIVITY_ASSIGN_MSG_H(FK) Parent Table Name Parent Column Name
Parents: ASSIGN_EMAIL_INFO_ID EMAIL_INFO EMAIL_INFO_ID
ASSIGN_PERSON_ID PERSON PERSON_ID
ASSIGN_PRSNL_ID PRSNL PERSON_ID
ASSIGN_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


TASK_ACTIVITY_MSG_H



Column Section Relationship Section Top of Page


Table-level Detail

Description: Task Activity Message History
Definition: Stores every modification made on messaging tasks.
Table Type: ACTIVITY





Column Detail - TASK_ACTIVITY_MSG_H


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.
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 Y 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.
BROADCAST_MESSAGE_UUID VARCHAR(255) Y Identifier associated to a broadcast message. This identifier would be used by message center messaging to roll up display of a broadcast message to a single item instead of seeing multiple same messages per patient recipient of the broadcast message.
CALLER_CONTACT_TXT VARCHAR(255) Y A free text field used in message center messaging to contain the contact information for the caller of an office message. Usually the phone number but may contain the best method to reach the patient such as by text message or patient's email.
CALLER_NAME VARCHAR(255) Y A free text field used in message center messaging to contain the name of the caller for a phone message. Usually a patient but may also be a patient's proxy (guardian / parent / advocate).
COMMENTS VARCHAR(255) Y Stores the comments for documents displayed in the Inbox. This also stores the caller name and phone number for phone messages displayed in the inbox.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CONVERSATION_ID DOUBLE N The task_id of the initial task in a conversation thread.
EMAIL_MESSAGE_IDENT VARCHAR(255) Y A globally unique identifier of an email message per RFC 2822. Generated when a messaging task is sent as an email.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_CD DOUBLE N This field identifies the bost basic representation of the information that will be documented against the task. Ex: Setting this field to the event code for Phone_Msg would identify the document as a phone message.
EVENT_ID DOUBLE N The event_id, from the clinical event table, that generated that task.
IB_RX_REQ_PERSON_DEMOG_ID DOUBLE N The identifier to the table containing patient demographics provided from a foreign system.
INSERT_DT_TM DATETIME N The date and time the row was originally inserted.
MSG_SENDER_EMAIL_INFO_ID DOUBLE N The id of the EMAIL_INFO row containing information about the email sender. For email senders (inbound email from external), the name data captured from the email is a name string.
MSG_SENDER_ID DOUBLE N The person_id, from the prsnl table, that identifies who sent the message.
MSG_SENDER_PERSON_ID DOUBLE N The Person Id of the message sender when the message originated from an Iqhealth consumer.
MSG_SENDER_PRSNL_GROUP_ID DOUBLE N The prsnl_group_id, from the prsnl_group table, that identifies which group sent the message.
MSG_SUBJECT VARCHAR(255) Y The subject line that relates to the message text (used for display purposes by InBox).
MSG_SUBJECT_CD DOUBLE N Defines a coded message subject for phone message tasks.
MSG_TEXT_ID DOUBLE N The text of the message (used by Inbox).
ORDER_ID DOUBLE N The order_id, from the orders table, that generated the task.
ORIG_POOL_TASK_ID DOUBLE N Task_id of the previous message to which this message is a reply or forward. Used in logic that requires information from the previous task such as when/if a reply is sent back from the individual inbox to the pool, the orig_pool_task_id is used to determine which pool member will be assigned to the message.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REFERENCE_TASK_ID DOUBLE N The unique identifier for the order task, from the order task reference database.
REMIND_DT_TM DATETIME Y The date and time for which Reminders will display in the Inbox.
RESPONSIBLE_PRSNL_ID DOUBLE Y The primary use of this identifier is to allow ability of message senders to indicate the responsible physician upon whos behalf the communication is being sent or replied from.
RESULT_SET_ID DOUBLE N The unique identifier for the set of clinical events that completed the task. This field will reference the CE_RESULT_SET_LINK table and will be derived from the RESULT_SET_SEQ sequence.
SCHEDULED_DT_TM DATETIME Y The date and time that the task was scheduled to occur. For unscheduled tasks, this field will be NULL. For Inbox tasks, this is the date and time the task will become overdue.
SEND_EVENT_VALID_FROM_DT_TM DATETIME Y The version of the event that existed at time of message send
STAT_IND DOUBLE Y An indicator to identify whether the order associate with this task is considered stat.
TASK_ACTIVITY_CD DOUBLE N The task_activity_cd, from the task_activity codeset, that identifies what activity this task can have placed upon it (i.e. chart, review, sign, etc.).
TASK_ACTIVITY_MSG_H_ID DOUBLE N Unique generated number that identifies a single row on the TASK_ACTIVITY_MSG_H table.
TASK_CREATE_DT_TM DATETIME Y The date and time the task_activity row was created.
TASK_DT_TM DATETIME Y The date and time the task was originated.
TASK_ID DOUBLE N A unique, generated number that is used to identify an individual task
TASK_STATUS_CD DOUBLE N The task_status_cd, from the task status codeset, that identifies what status the task us in (i.e. completed, overdue, etc.).
TASK_SUBTYPE_CD DOUBLE N CODE SET:6034; Defines the sub type of a task that allows more granular views of reminder tasks. Example: the field is used for Care management tasks with a task type cd of reminders. ;The field is also used for RxChange tasks with a sub type of Match, Suspect Match and No Match.
TASK_TYPE_CD DOUBLE N The task_type_cd, from the task type codeset, that identifies what group this tasks belongs to (i.e. lab, radiology, pat care, etc.)
TASK_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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 - TASK_ACTIVITY_MSG_H


Child Column in TASK_ACTIVITY_MSG_H(FK) Parent Table Name Parent Column Name
Parents: MSG_SENDER_EMAIL_INFO_ID EMAIL_INFO EMAIL_INFO_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
IB_RX_REQ_PERSON_DEMOG_ID IB_RX_REQ_PERSON_DEMOG IB_RX_REQ_PERSON_DEMOG_ID
ORDER_ID ORDERS ORDER_ID
MSG_SENDER_PERSON_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
RESPONSIBLE_PRSNL_ID PRSNL PERSON_ID
MSG_SENDER_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


TASK_CHARTING_AGENT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference task and task charting agent relationship.
Definition: The table is used to store the relationship between reference tasks and their associated charting agents.
Table Type: REFERENCE





Column Detail - TASK_CHARTING_AGENT_R


Column Name Type Null? Definition
CHARTING_AGENT_CD DOUBLE N Code value represents the different types of charting agents. For example, PowerForms, PowerNotes, APACHE. Component such as Task List may use this value to decide which charting agent to load when a task is charted. code set 255090
CHARTING_AGENT_ENTITY_ID DOUBLE N The numeric value to identify which form or template to be used for a given charting agent when a task is charted. This field is used when the form or template has a unique numeric identifier. It should be used in conjunction with charting_agent_entity_name.
CHARTING_AGENT_ENTITY_NAME VARCHAR(255) Y The table name where the charting agent id is located. For example, "DCP_FORMS_REF". This field is used when the form or template has a unique numeric identifier; otherwise, it should be empty. It should be used in conjunction with charting_agent_entity_id.
CHARTING_AGENT_IDENTIFIER VARCHAR(255) Y The reference string to identify which form or template to be used for a given charting agent when a task is charted. This field is used when the form or template does not have a unique numeric identifier.
REFERENCE_TASK_ID DOUBLE N ID of the reference task to which the charting agent is associated with.
TASK_CHARTING_AGENT_R_ID DOUBLE N Unique identifier.
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 - TASK_CHARTING_AGENT_R


Child Column in TASK_CHARTING_AGENT_R(FK) Parent Table Name Parent Column Name
Parents: REFERENCE_TASK_ID ORDER_TASK REFERENCE_TASK_ID


TASK_INTENDED_RECIPIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Task Intended Recipient
Definition: Table stores the intended recipient(s) of a task when the task is routed (due to rule) to a different recipient.
Table Type: ACTIVITY





Column Detail - TASK_INTENDED_RECIPIENT


Column Name Type Null? Definition
INTENDED_RECIPIENT_GROUP_ID DOUBLE N The identifier of a group of intended recipient(s). This field will be non-zero for every row except the zero row. Each value indicates that the task that was routed to a pool instead of the intended recipient(s) due to pool rule(s) existing for the intended recipient(s). The routed pool recipient of the task is stored on task_activity_assignment row.
PRSNL_ID DOUBLE N Identifier of the personnel, from the prsnl table, that is the intended recipient of a task that was routed instead to a pool.
TASK_INTENDED_RECIPIENT_ID DOUBLE N Unique generated number that identifies a single row on the task_intended_recipient table.
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 - TASK_INTENDED_RECIPIENT


Child Column in TASK_INTENDED_RECIPIENT(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
INTENDED_RECIPIENT_GROUP_ID TASK_ACTIVITY_ASSIGNMENT TASK_ACTIVITY_ASSIGN_ID


TASK_PUBLISH_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Task Publish Queue
Definition: Stores information about failed attempts for publishing message notifications to IQHealth.
Table Type: ACTIVITY





Column Detail - TASK_PUBLISH_QUEUE


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N The time at which the message was created.
REMIND_DT_TM DATETIME Y The time at which a reminder becomes available.
TASK_ACTIVITY_ASSIGN_ID DOUBLE N The task_activity_assignment row that this queue item pertains to.
TASK_PUBLISH_QUEUE_ID DOUBLE N Unique, generated number that identifies a single row on the TASK_PUBLISH_QUEUE table.
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 - TASK_PUBLISH_QUEUE


Child Column in TASK_PUBLISH_QUEUE(FK) Parent Table Name Parent Column Name
Parents: TASK_ACTIVITY_ASSIGN_ID TASK_ACTIVITY_ASSIGNMENT TASK_ACTIVITY_ASSIGN_ID