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 |