Table Detail Report

FSIESO_QUE_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CQM_FSIESO_QUE table details
Definition: This table holds referential identifiers for events in the CQM_FSIESO_QUE table.
Table Type: ACTIVITY





Column Detail - FSIESO_QUE_DETAILS


Column Name Type Null? Definition
PARENT_ATTRIBUTE_TXT VARCHAR(100) Y The value of the Parent Entity when the associated Parent Entity ID is a String value or the Parent Entity is a Column and the column value is alphanumeric.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the phone row is related (i.e., person_id, organization_id, etc.)
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this phone row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.)
QUEUE_ID DOUBLE N This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number.
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 - FSIESO_QUE_DETAILS


Child Column in FSIESO_QUE_DETAILS(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_FSIESO_QUE QUEUE_ID


HOLD_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Hold Queue
Definition: This table references ESO events that are held from going outbound from HNAM. Entries on this table directly reference the outbound events on the CQM_FSIESO_QUE table. Entries are deleted from this table in run time, as hold release conditions are met.
Table Type: ACTIVITY





Column Detail - HOLD_QUEUE


Column Name Type Null? Definition
ENCNTR_COMBINE_IND DOUBLE Y This element will be set to 1 when the that the encntr_id was combined and communication to the FSI Hold Release failed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
HOLD_QUEUE_ID DOUBLE N This is the value of the unique primary identifier of the hold_queue table. It is an internal system assigned number.
HOLD_RULE_ID DOUBLE N This is the value of the unique primary identifier of the hold_rule table. It is an internal system assigned number.
LGTMT_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the LEGITIMATE_RELATIONSHIP table. It is an internal system assigned number. This column is obsolete because the parent table, LEGITIMATE RELATIONSHIP is obsolete.
ORDER_ID DOUBLE N This is the value of the unique primary identifier of the orders table. It is an internal system assigned number.
PERSON_COMBINE_IND DOUBLE Y This element will be set to 1 when the that the person_id was combined and communication to the FSI Hold Release failed.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
QUEUE_ID DOUBLE N This is the value of the unique primary identifier of the cqm_fsieso_que table. It is an internal system assigned number.
SCH_EVENT_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
TRIGGER_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener trigger table (CQM_FSIESO_TR_1). It is an internal system assigned number.
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 - HOLD_QUEUE


Child Column in HOLD_QUEUE(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_FSIESO_QUE QUEUE_ID
TRIGGER_ID CQM_FSIESO_TR_1 TRIGGER_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
HOLD_RULE_ID HOLD_RULE HOLD_RULE_ID
PERSON_ID PERSON PERSON_ID




Parent Column in HOLD_QUEUE (PK) Child Table Name Child Column Name
Children: HOLD_QUEUE_ID HOLD_QUEUE_CONDITION HOLD_QUEUE_ID


HOLD_QUEUE_CONDITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Hold Queue Conditions
Definition: The table contains the release conditions associated with the hold event.
Table Type: ACTIVITY





Column Detail - HOLD_QUEUE_CONDITION


Column Name Type Null? Definition
HOLD_QUEUE_ID DOUBLE N This is the value of the unique primary identifier of the hold_queue table. It is an internal system assigned number.
SEQ_NUM DOUBLE N The element identifies the seq_num on the HOLD_RULE_CONDITION table. By using the hold_queue_id, join to the hold_queue to obtain the hold_rule_id. Use the hold_rule_id/seq_num combination to find the exact hold_rule_condition.
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 - HOLD_QUEUE_CONDITION


Child Column in HOLD_QUEUE_CONDITION(FK) Parent Table Name Parent Column Name
Parents: HOLD_QUEUE_ID HOLD_QUEUE HOLD_QUEUE_ID


HOLD_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Hold Rule
Definition: The table identifies the events that eligable or not eligable for hold and the hold processing rules associated with those events.
Table Type: REFERENCE





Column Detail - HOLD_RULE


Column Name Type Null? Definition
ACTION_CONTRIB_SYS_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.
ACTIVE_IND DOUBLE N 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.
ACTIVITY_TYPE_CD DOUBLE N A grouping mechanism within catalog type code.
CATALOG_CD DOUBLE N Coded value which specifies how the event is stored in and retrieved from the event table's sub-tables. For example, Catalog_CDs identify events as numeric results, textual results, calculations, medications, etc.
CLASS VARCHAR(15) Y Identifies the ESO server processing class of the transaction.
DESCRIPTION VARCHAR(30) Y This fields allows the User to customize the identification of the particular hold rule row.
ENCNTR_FIRST_EVENT_FLAG DOUBLE N This element masks for PM outbound events that specify encntr_first_event_ind. Typically ADT events with A01, A04, or A05 types may utilize this mask.
ENCNTR_TYPE_CD DOUBLE N Encounter type is used to categorize patients into inpatient and outpatient groups.
EVENT_CD DOUBLE N Coded value which specifies how the event is stored in and retrieved from the event table's sub-tables. For example, Event_CDs identify events as numeric results, textual results, calculations, medications, etc.
EVENT_CLASS_CD DOUBLE N Coded value which specifies how the event is stored in and retrieved from the event table's sub-tables. For example, Event_Class_CDs identify events as numeric results, textual results, calculations, medications, etc.
HOLD_RULE_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
INTERFACE_TYPE_CD DOUBLE N This field creates at relation from the particular ESO trigger combination to a interface type. Multiple ESO triggers can be associated to a single interface type.
MESSAGE_VERSION_CD DOUBLE N Version of the message
ORDER_ACTION_CD DOUBLE N Code value to identify the action that was performed.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PERSON_FIRST_EVENT_FLAG DOUBLE N This element masks for PM outbound events that specify personr_first_event_ind. Typically ADT events with A01, A04, A05, or A28 types may utilize this mask.
RULE_ACTION_CD DOUBLE N This element specifies the processing rules to follow when the hold_rule identifies matches an outbound event.
SUBTYPE VARCHAR(15) Y Identifies the ESO server processing subtype of the transaction.
TYPE VARCHAR(15) Y Identifies the ESO server processing type of the transaction.
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 - HOLD_RULE




Parent Column in HOLD_RULE (PK) Child Table Name Child Column Name
Children: HOLD_RULE_ID HOLD_QUEUE HOLD_RULE_ID
HOLD_RULE_CONDITION HOLD_RULE_ID


HOLD_RULE_CONDITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Hold Rule Conditions
Definition: This table identifies the hold release conditions related to a hold rule.
Table Type: REFERENCE





Column Detail - HOLD_RULE_CONDITION


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.
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of person identifiers (I.e., numbers). The alias pool code also determines the accept/display format for the unique set of identifiers.
ASSIGN_AUTHORITY_SYS_CD DOUBLE N This field identifies whether the ESI Server received a Person_Alias that was configured for Hold.
HOLD_RULE_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
OP_ACTIVITY_FLAG DOUBLE N This element identifies the type the hold release condition by PERSON, ENCOUNTER, ORDER, or SCH_EVENT type.
PARENT_ENTITY_NAME VARCHAR(32) Y The value of the primary identifier of the table to which the phone row is related (i.e., person_id, organization_id, etc.)
SEQ_NUM DOUBLE N This element identifies the sequence of the hold release condition in relation to the Hold Rule ID.
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 - HOLD_RULE_CONDITION


Child Column in HOLD_RULE_CONDITION(FK) Parent Table Name Parent Column Name
Parents: HOLD_RULE_ID HOLD_RULE HOLD_RULE_ID