EMAIL_INFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Email Information |
Definition: | Stores data about the email address to be used when sending email messages outbound or receiving email messages inbound. |
Table Type: | ACTIVITY |
Column Detail - EMAIL_INFO
Column Name | Type | Null? | Definition |
---|---|---|---|
EMAIL_ADDR | VARCHAR(320) | N | The Email Address that this row contains information for. |
EMAIL_INFO_ID | DOUBLE | N | Unique generated number that identifies a single row on the email_info table. |
FIRST_NAME | VARCHAR(100) | Y | The First Name of the person associated to the email address. |
FULL_NAME | VARCHAR(100) | Y | The name information associated to the email address. |
LAST_NAME | VARCHAR(100) | Y | The Last Name of the person associated to the email address. |
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 - EMAIL_INFO
Parent Column in EMAIL_INFO (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EMAIL_INFO_ID | MESSAGING_NOTIFY | ASSIGN_EMAIL_INFO_ID |
MESSAGING_NOTIFY | NOTIFY_EMAIL_INFO_ID | ||
TASK_ACTIVITY | MSG_SENDER_EMAIL_INFO_ID | ||
TASK_ACTIVITY_ASSIGNMENT | ASSIGN_EMAIL_INFO_ID | ||
TASK_ACTIVITY_ASSIGN_MSG_H | ASSIGN_EMAIL_INFO_ID | ||
TASK_ACTIVITY_MSG_H | MSG_SENDER_EMAIL_INFO_ID |
MESSAGING_OUT_OF_OFFICE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Messaging Out of Office |
Definition: | Used to tell whether a personnel or personnel group is in the office or out of the office. The existence of a row on this table indicates that the personnel or personnel group is out of the office. The non-existence of a row indicates that the personnel or personnel group is in the office. |
Table Type: | ACTIVITY |
Column Detail - MESSAGING_OUT_OF_OFFICE
Column Name | Type | Null? | Definition |
---|---|---|---|
MESSAGING_OUT_OF_OFFICE_ID | DOUBLE | N | Unique, generated number to identify a single row on the MESSAGING_OUT_OF_OFFICE table. |
PRSNL_GROUP_ID | DOUBLE | N | The personnel group that is out of the office. |
PRSNL_ID | DOUBLE | N | The personnel that is out of the office. |
RETURN_DT_TM | DATETIME | Y | The projected date and time that the personnel or personnel group will return to the office. |
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 - MESSAGING_OUT_OF_OFFICE
Child Column in MESSAGING_OUT_OF_OFFICE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_ID | PRSNL | PERSON_ID |
PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
TASK_ACTION
Column Section | Top of Page |
Table-level Detail
Description: | TASK ACTION |
Definition: | Values of the field in the task_activity table that had action performed on it. |
Table Type: | ACTIVITY |
Column Detail - TASK_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
RESCHEDULE_REASON_CD | DOUBLE | Y | Identifies that reason the task was rescheduled |
SCHEDULED_DT_TM | DATETIME | Y | The date and time that the task was scheduled to occur at the time the action was taken on the task. For unscheduled tasks, this field will be NULL |
TASK_ACTION_SEQ | DOUBLE | N | A unique, generated number that is used to identify and order the task action record. |
TASK_DT_TM | DATETIME | Y | The date and time an action was performed against this task. |
TASK_ID | DOUBLE | N | The task_id from the task_activity table. |
TASK_STATUS_CD | DOUBLE | Y | A codeset value that identifies the status of the task. |
TASK_STATUS_REASON_CD | DOUBLE | Y | The reason a task was put into the associated status. |
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. |
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. |
TASK_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Task Activity |
Definition: | Holds the values of the fields for a specific task created from the order server. |
Table Type: | ACTIVITY |
Column Detail - TASK_ACTIVITY
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). |
CARESET_ID | DOUBLE | N | The id of the associated CareSet. |
CATALOG_CD | DOUBLE | N | The catalog_code of the order that is related to the specified task. |
CATALOG_TYPE_CD | DOUBLE | N | The catalog_type_cd from the orders table. |
CHARTED_BY_AGENT_CD | DOUBLE | N | Code value for the charting agent that is used to chart the task. Code set 255090 |
CHARTED_BY_AGENT_IDENTIFIER | VARCHAR(255) | Y | The reference string to identify which form or template is used when the task is charted. |
CHARTING_CONTEXT_REFERENCE | VARCHAR(255) | Y | A reference string that is supplied by a charting agent at the time of initial documentation of a task. The charting agent may specify any string necessary to be stored such that combined with the charted_by_agent_identifier the charting agent can redisplay and modify the original documentation context for the task. |
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. |
CONFIDENTIAL_IND | DOUBLE | Y | An indicator to identify whether the task is confidential. |
CONTAINER_ID | DOUBLE | N | Identifies the specimen container associated with the task. |
CONTINUOUS_IND | DOUBLE | Y | An indicator to identify whether this task is part of a continuous order. |
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. |
DELIVERY_IND | DOUBLE | Y | An indicator to identify whether the task has been delivered. |
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_CLASS_CD | DOUBLE | N | The event class code. |
EVENT_ID | DOUBLE | N | The event_id, from the clinical event table, that generated that task. |
EXTERNAL_REFERENCE_NUMBER | VARCHAR(100) | N | This field uniquely identifies the task_activity row from an external system.. |
FORMAT_CD | DOUBLE | Y | Used to store the format of the message text. |
IB_RX_REQ_PERSON_DEMOG_ID | DOUBLE | N | The identifier to the table containing patient demographics provided from a foreign system. |
IV_IND | DOUBLE | Y | An indicator to identify whether this task is an IV. |
LINKED_ORDER_IND | DOUBLE | Y | An indicator to identify whether the order associated with this task is part of a linked order. |
LOCATION_CD | DOUBLE | N | The location_cd from the encounter table at the time of task creation. The field identifies the current permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed. |
LOC_BED_CD | DOUBLE | N | The location_cd from the encounter table defining the patients current bed. |
LOC_ROOM_CD | DOUBLE | N | The location_cd from the encounter table defining the patients current room. |
MED_ORDER_TYPE_CD | DOUBLE | N | This field is to identify how the task"s parent medication orderable was placed. |
MESSAGE_TXT | LONGTEXT | Y | Used to store the text for the message |
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. |
ORGANIZATION_ID | DOUBLE | Y | Identifier of the organization tied to this row. |
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. |
PERFORMED_PRSNL_ID | DOUBLE | N | Personnel id of the provider who charted this task. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PFT_QUEUE_ITEM_WF_HIST_ID | DOUBLE | Y | Uniquely identifies the queue item wf history row related to this task. |
PHYSICIAN_ORDER_IND | DOUBLE | Y | An indicator to identify whether the order associated with this task was ordered by a physician. |
READ_IND | DOUBLE | Y | An indicator to identify whether the task has been read. |
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. |
RESCHEDULE_IND | DOUBLE | Y | Determines whether or not the task has been rescheduled. |
RESCHEDULE_REASON_CD | DOUBLE | N | Identifies the reason the task was rescheduled. |
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. |
ROUTINE_IND | DOUBLE | Y | An indicator to identify whether the order associated with this task is considered routine. |
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 |
SOURCE_TAG | VARCHAR(255) | Y | A reference string that is supplied by the originator of the task for its identification. For example, a diagnosis may suggest a Pathway, where the suggestion is recorded as a task. The suggestion is generated by Discern rules. In this case, source_tag is the EKS module name from eks_module table for the Discern rule that generates the task. |
STAT_IND | DOUBLE | Y | An indicator to identify whether the order associate with this task is considered stat. |
SUGGESTED_ENTITY_ID | DOUBLE | N | The numeric value to identify the suggested or expected action. It should be used in conjunction with suggested_entity_name. For example, a diagnosis may suggest a Pathway, where the suggestion is recorded as a task. In this case, suggested_entity_id is pathway_catalog_id in pathway_catalog table. |
SUGGESTED_ENTITY_NAME | VARCHAR(32) | Y | The table name where the suggested entity id is located. This field can be used to record the suggested or expected action. It should be used in conjunction with suggested_entity_id. For example, a diagnosis may suggest a Pathway, where the suggestion is recorded as a task. In this case, suggested_entity_name is "PATHWAY_CATALOG". |
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_CLASS_CD | DOUBLE | N | The task_activity_class_cd, from the task_activity_class codeset, that identifies a sub task activity that this task can have placed upon it (i.e. paper doc). |
TASK_CLASS_CD | DOUBLE | N | The task_class_cd, from the task class codeset, that identifies which time parameter this task has been defined with (i.e. prn, scheduled, etc.). |
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_PRIORITY_CD | DOUBLE | N | If a task is associated with an order, it is the priority of the order. If the system decides to carry forward priority of the order to the task, this is the code value from order entry detail. Otherwise, it is set to 0. For example, when priority on the task is defaulted to category 3 (not STAT, not NOW) implicitly by the system, the value is set to 0. So tasks generated from orders without |
TASK_RTG_ID | DOUBLE | N | The ID of the task routing table row that describes to whom or where the task has been routed. |
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_STATUS_REASON_CD | DOUBLE | N | The reason that the task was put into its current status. |
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. |
TEMPLATE_TASK_FLAG | DOUBLE | Y | This field is used to determine if a task is part of a continuing order |
TPN_IND | DOUBLE | Y | An indicator to identify whether this task is a tpn. |
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
Child Column in TASK_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTAINER_ID | CONTAINER | CONTAINER_ID |
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 | |
CARESET_ID | ORDERS | ORDER_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
REFERENCE_TASK_ID | ORDER_TASK | REFERENCE_TASK_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
MSG_SENDER_PERSON_ID | PERSON | PERSON_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PFT_QUEUE_ITEM_WF_HIST_ID | PFT_QUEUE_ITEM_WF_HIST | PFT_QUEUE_ITEM_WF_HIST_ID | |
RESPONSIBLE_PRSNL_ID | PRSNL | PERSON_ID | |
MSG_SENDER_PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID | |
CONVERSATION_ID | TASK_ACTIVITY | TASK_ID | |
ORIG_POOL_TASK_ID | TASK_ACTIVITY | TASK_ID |
Parent Column in TASK_ACTIVITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TASK_ID | CODING_AUDIT | TASK_ID |
DCP_FORMS_ACTIVITY | TASK_ID | ||
ESI_LOG | TASK_ID | ||
MESSAGING_NOTIFY | TASK_ID | ||
RXS_ORDER_TASK_QUEUE | TASK_ID | ||
SA_FLUID_ADMIN | TASK_ID | ||
SA_MEDICATION_ADMIN | TASK_ID | ||
TASK_ACTIVITY | CONVERSATION_ID | ||
TASK_ACTIVITY | ORIG_POOL_TASK_ID | ||
TASK_ACTIVITY_ASSIGNMENT | TASK_ID | ||
TASK_RELTN | PREREQ_TASK_ID | ||
TASK_RELTN | TASK_ID | ||
TASK_SUBACTIVITY | TASK_ID |
TASK_ACTIVITY_ASSIGNMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TASK ACTIVITY ASSIGNMENT |
Definition: | Holds the value of the person or team a task is assigned to at a given time. |
Table Type: | ACTIVITY |
Column Detail - TASK_ACTIVITY_ASSIGNMENT
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. |
EXTERNAL_REFERENCE_NUMBER | VARCHAR(100) | N | This field uniquely identifies the task_activity row from an external system. |
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 |
NOTIFICATION_TYPE_CD | DOUBLE | Y | Specifies the most granular designation of what this message or notification is to the recipent. Removes the need for extra logic which used multiple other fields to determine the type. Uses code set 3406. |
PROXY_PRSNL_ID | DOUBLE | N | The ID of the person to whom has proxy to the task. SEQUENCE NAME: PERSON_ONLY_SEQ |
REJECTION_IND | DOUBLE | Y | Indicates whether the task assignment has been rejected by the person to whom it was assigned. |
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. |
SHOWUP_DT_TM | DATETIME | Y | The date the task will appear in the inbox. This is the date the task was created for most task types. This is the remind date for reminders. |
TASK_ACTIVITY_ASSIGN_ID | DOUBLE | N | A unique identifier for the assignment record, |
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_ASSIGNMENT
Child Column in TASK_ACTIVITY_ASSIGNMENT(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_ID | TASK_ACTIVITY | TASK_ID | |
INTENDED_RECIPIENT_GROUP_ID | TASK_ACTIVITY_ASSIGNMENT | TASK_ACTIVITY_ASSIGN_ID |
Parent Column in TASK_ACTIVITY_ASSIGNMENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TASK_ACTIVITY_ASSIGN_ID | TASK_ACTIVITY_ASSIGNMENT | INTENDED_RECIPIENT_GROUP_ID |
TASK_INTENDED_RECIPIENT | INTENDED_RECIPIENT_GROUP_ID | ||
TASK_PUBLISH_QUEUE | TASK_ACTIVITY_ASSIGN_ID |