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