Table Detail Report

EEM_RX_MED_HIST_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Medication History Detail
Definition: The EEM_RX_MED_HIST_DETAIL table stores summary data for medication history transactions. We use the table to store information about transactions sent to and from 3rd parties. The information stored is data need for either processing the inbound transaction or for use when displaying summary data about the transaction in a client application.
Table Type: ACTIVITY





Column Detail - EEM_RX_MED_HIST_DETAIL


Column Name Type Null? Definition
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.
DATA_EXPIRE_DT_TM DATETIME Y Date and time that the transaction response data is considered to be expired.
EEM_RX_ELIG_DETAIL_ID DOUBLE N Primary identifier of EEM_RX_ELIG_DETAIL
EEM_RX_MED_HIST_DETAIL_ID DOUBLE N Primary identifier of EEM_RX_MED_HIST_DETAIL
HEALTH_PLAN_ID DOUBLE N Identifier of the health plan for which history was requested
INTERCHANGE_ID DOUBLE N Primary identifier for a transaction
ORGANIZATION_ID DOUBLE N Identifier of the carrier organization tied to the history request
ORIGIN_INTERCHANGE_ID DOUBLE N Unique identifier of the first transaction in the series that requested a patient's prescription history.
PERSON_ID DOUBLE N Identifier of the person for who this transaction was sent
REPLY_DT_TM DATETIME Y Date and time the transaction was returned
RESPONSE_CD DOUBLE N Code used to describe the status of the response transaction
SENT_DT_TM DATETIME Y Date and time the transaction was sent outbound
TRANS_DATA_CD DOUBLE N Describes the high level status of a transaction message based on the system's business rules. The message may be in a pending, error, or returned state.
TRANS_VENUE_TYPE_CD DOUBLE N Defines the type of transaction and the venue from where it was submitted.
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 - EEM_RX_MED_HIST_DETAIL


Child Column in EEM_RX_MED_HIST_DETAIL(FK) Parent Table Name Parent Column Name
Parents: EEM_RX_ELIG_DETAIL_ID EEM_RX_ELIG_DETAIL EEM_RX_ELIG_DETAIL_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


EEM_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM transaction.
Definition: EEM Transaction is the parent table for all EEM transactions. One row represents a single outbound and inbound transaction with high level summary data pertaining to it's status.
Table Type: ACTIVITY





Column Detail - EEM_TRANSACTION


Column Name Type Null? Definition
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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DATA_EXPIRE_DT_TM DATETIME N Date and time that the data expires.
DATA_FLAG DOUBLE N Describes the current state of the transaction. 0 - Pending/Unknown, 1 - Eligible/Verified, 2 - Not Eligible/Denied, 3 - Returned/Ambiguous, 4 - Error, 5 - Template, 6 - Eligible (invalid card).
DATA_SIZE DOUBLE N Size, in bytes, of the data blob.
EEM_BATCH_ID DOUBLE N obsolete column - creation of EEM_BATCH_JOB table renders this column no longer needed
EEM_JOB_ID DOUBLE N The identifier of the EEM job.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
HASH_KEY VARCHAR(60) N Hash key of all required inputs. Used to determine duplicate transactions.
INTERCHANGE_ID DOUBLE N Interchange ID. refers to interchange_id on the EEM_TRANSACTION table. That column is a unique index on the table not the PK.
INTERCHANGE_UUID VARCHAR(40) Y Contains the universally unique identifier for a transaction. This is an alias of the interchange_id column.
PARENT_ID DOUBLE N ID of the parent table.
PARENT_TABLE VARCHAR(32) N Table name of parent.
POLL_EXPIRE_DT_TM DATETIME N Date and time that polling should expire.
PROFILE_ID DOUBLE N The identifier of the profile used for the transaction. A profile contains reference data for outbound messages and is optional.
RECV_TIME DOUBLE Y Time in milliseconds that message was received. (starting from 1/1/1970)
SENT_TIME DOUBLE Y Time in milliseconds that message was sent. (starting from 1/1/1970)
TRANSACTION_CD DOUBLE N The type of transaction the row represents.
TRANSACTION_ID DOUBLE N Primary key of this table.
TRANSACTION_MEANING VARCHAR(12) Y The type of transaction the row represents.
TRANS_DATA_CD DOUBLE N Describes the status of a transaction message based on the system's business rules.
TRANS_DATA_MOD_CD DOUBLE N Describes the status of a transaction message as determined by a user's review of the message.
TRANS_STATUS_CD DOUBLE N This column can be used to check how far the transaction reached in case transactions are not working.
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 - EEM_TRANSACTION


Child Column in EEM_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: EEM_BATCH_ID EEM_BATCH EEM_BATCH_ID
EEM_JOB_ID EEM_JOB EEM_JOB_ID
PROFILE_ID EEM_PROFILE PROFILE_ID




Parent Column in EEM_TRANSACTION (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID AUTHORIZATION INTERCHANGE_ID
EEM_ELIG_SVC_DETAIL INTERCHANGE_ID


EEM_TRANS_DATA_ERROR



Column Section Top of Page


Table-level Detail

Description: EEM Transaction Data Error
Definition: This table is used to track transaction errors caused by missing required data.
Table Type: ACTIVITY





Column Detail - EEM_TRANS_DATA_ERROR


Column Name Type Null? Definition
DATA_ERROR_CD DOUBLE N Code used to capture the data element from the given transaction that is in error
EEM_TRANS_DATA_ERROR_ID DOUBLE N Primary identifier of EEM_TRANS_DATA_ERROR
INTERCHANGE_ID DOUBLE N Interchange ID. Refers to interchange_id on the EEM_TRANSACTION table. It is the Primary identifier for a transaction but is not the PK of the EEM_TRANSACTION 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.


EEM_TRANS_LOCK



Column Section Top of Page


Table-level Detail

Description: Trans Lock
Definition: The table stores summary data from the transaction.
Table Type: ACTIVITY





Column Detail - EEM_TRANS_LOCK


Column Name Type Null? Definition
EEM_TRANS_LOCK_ID DOUBLE N Trans lock identifier
ENTITY_ID DOUBLE N This is the value of the identifier for the lock.
ENTITY_LOCK_KEY_VALUE DOUBLE N value of the entity lock key
ENTITY_LOCK_NAME VARCHAR(32) Y Name of the lock type used by the entity lock server
ENTITY_NAME VARCHAR(32) Y name of the entity
INTERCHANGE_ID DOUBLE N Unique identifier for this table. It is a unique identifier from the eem_transaction table.
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.


EEM_TRANS_PARAM



Column Section Top of Page


Table-level Detail

Description: eem transaction parameter
Definition: eem transaction parameter
Table Type: ACTIVITY





Column Detail - EEM_TRANS_PARAM


Column Name Type Null? Definition
DATA_TYPE_CD DOUBLE N Data Type Code value
DOUBLE_VALUE DOUBLE N double value
DT_TM_VALUE DATETIME Y date and time value
EEM_TRANS_PARAM_ID DOUBLE N eem trans param identifier
INTERCHANGE_ID DOUBLE N Interchange ID. Refers to interchange_id on the EEM_TRANSACTION table. It is the Primary identifier for a transaction but is not the PK of the EEM_TRANSACTION table.
PARAMETER_CD DOUBLE N parameter code
STRING_VALUE VARCHAR(255) Y string value
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.