Table Detail Report

EEM_LOG_BLOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Joins single row on the eem_log table to multiple rows on the long_blob table.
Definition: eem log blob
Table Type: ACTIVITY





Column Detail - EEM_LOG_BLOB


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
COMP_SIZE DOUBLE N size of structure after compression
EEM_LOG_ID DOUBLE N ID of corresponding row on EEM_LOG table.
END_EFFECTIVE_DT_TM DATETIME Y 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.
LOG_FLAG DOUBLE N log flag - 0 - Encoding 1 1 - Encoding 3
LONG_BLOB_ID DOUBLE N ID of the corresponding row on the long_blob table.
ORIG_SIZE DOUBLE N original size of the structure before compression
SEQ_NBR DOUBLE N The order that the row falls in relation to other rows w/ the same log_id and long_blob_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 - EEM_LOG_BLOB


Child Column in EEM_LOG_BLOB(FK) Parent Table Name Parent Column Name
Parents: EEM_LOG_ID EEM_LOG LOG_ID
LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID


EEM_MOH_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MOH Detail Table
Definition: This table will be the summary table for the MOH transactions.
Table Type: ACTIVITY





Column Detail - EEM_MOH_DETAIL


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
BIRTH_DT_ISO VARCHAR(10) Y The patient's birth date as returned by the moh. Stored in ISO-8601 extended date format.
BIRTH_DT_TM DATETIME Y Patient's birth date as returned from the MOH. ***Obsolete column ***
BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.***Obsolete column ***
DATA_FLAG DOUBLE N Indicates the status of the data within the transaction (not of the transaction itself). 0 - pending/unknown, 1 - eligible, 2 - denied, 3 - returned/unknown or ambiguous, 4 - error, 5 - template, 6 - person is eligible but card is invalid.
END_EFFECTIVE_DT_TM DATETIME Y 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.
EXPIRY_DT_TM DATETIME Y The expiry date of the patient's health card as returned from the MOH.
FIRST_NAME VARCHAR(20) Y Patient's first name as returned from the MOH.
GENDER_CD DOUBLE N Patient's gender as returned from the MOH.
HEALTH_CARD VARCHAR(10) Y Patient's health card number as provided to the MOH.
INTERCHANGE_ID DOUBLE N Interchange id of the transaction that this detail data came from.
LAST_NAME VARCHAR(30) Y Patient's last name as returned from the MOH.
LOCATION_CD DOUBLE N The location from which the MOH Health Card Validation took place.
PAYER_ID DOUBLE N The identifier of the organization that is the payer of the transaction also known as the carrier organization.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROFILE_ID DOUBLE N The profile id used in the transaction.
REPLY_DT_TM DATETIME Y Date and Time the response was received.
RESPONSE_CD DOUBLE N The codified response to the Health Card Validation request from the MOH.
SECOND_NAME VARCHAR(20) Y Patient's second name as returned from the MOH.
SENDER_PRSNL_ID DOUBLE N The identifier of the personnel that initiated the Health Card Validation transaction.
SENT_DT_TM DATETIME N Date and Time the Transaction was sent.
TRACK1 VARCHAR(79) Y Magnetic stripe track 1 information as provided to the MOH.
TRACK2 VARCHAR(40) Y Magnetic stripe track 2 information as provided to the MOH.
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.
VERSION_CODE VARCHAR(2) Y Patient's version code as provided to the MOH.



Relationship Detail - EEM_MOH_DETAIL


Child Column in EEM_MOH_DETAIL(FK) Parent Table Name Parent Column Name
Parents: GENDER_CD CODE_VALUE CODE_VALUE
RESPONSE_CD CODE_VALUE CODE_VALUE
PROFILE_ID EEM_PROFILE PROFILE_ID
LOCATION_CD LOCATION LOCATION_CD
PAYER_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
SENDER_PRSNL_ID PRSNL PERSON_ID


EEM_NEWBORN_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Record Newborn Transaction Summary
Definition: A record represents summary of transaction data
Table Type: ACTIVITY





Column Detail - EEM_NEWBORN_DETAIL


Column Name Type Null? Definition
BIRTH_DT_TM DATETIME Y Patient Birth date and time
BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FIRST_NAME VARCHAR(100) Y Patient First Name
GENDER_CD DOUBLE N Patient Gender
INTERCHANGE_ID DOUBLE N Unique Identifier for this table
LAST_NAME VARCHAR(100) Y Patient Last Name
NOK_PHN VARCHAR(200) Y Next of Kin's personal health number
NOK_RELTN_CD DOUBLE N Next of Kin Relation Code
PAYER_ID DOUBLE N Key to Organization table
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PHN VARCHAR(200) Y Personal Health Number (Person alias)
PROFILE_ID DOUBLE N Key to EEM_PROFILE
REPLY_DT_TM DATETIME Y Reply Date and Time
SENDER_PRSNL_ID DOUBLE N Transaction sender Identifier
SENT_DT_TM DATETIME N Transaction sent date and time
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_NEWBORN_DETAIL


Child Column in EEM_NEWBORN_DETAIL(FK) Parent Table Name Parent Column Name
Parents: GENDER_CD CODE_VALUE CODE_VALUE
PROFILE_ID EEM_PROFILE PROFILE_ID
PAYER_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
SENDER_PRSNL_ID PRSNL PERSON_ID


EEM_NOTIFICATION_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Notification Detail
Definition: The EEM_NOTIFICATION_DETAIL table stores data for admission notification transactions. Will be used by clients to create work lists or reports on admission notifications.
Table Type: ACTIVITY





Column Detail - EEM_NOTIFICATION_DETAIL


Column Name Type Null? Definition
EEM_NOTIFICATION_DETAIL_ID DOUBLE N The unique primary key of this table. It is internally generated by Cerner.
ENCNTR_ID DOUBLE N Identifier of the encounter associated to the admission.
HEALTH_PLAN_ID DOUBLE N Identifier of the patient's health plan
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.
PAYER_ID DOUBLE N The identifier of the organization that is the payer of the transaction. Also known as the carrier organization.
REPLY_DT_TM DATETIME Y The date and time the transaction was returned.
SENT_DT_TM DATETIME N The date and time the transaction was sent outbound.
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 - EEM_NOTIFICATION_DETAIL


Child Column in EEM_NOTIFICATION_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PAYER_ID ORGANIZATION ORGANIZATION_ID


EEM_RX_ELIG_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Prescription Eligibility Detail
Definition: The EEM_RX_ELIG_DETAIL table stores summary data for prescription eligibility transactions.
Table Type: ACTIVITY





Column Detail - EEM_RX_ELIG_DETAIL


Column Name Type Null? Definition
BIN VARCHAR(50) Y Bank Identification Number used as additional identification for the patient from the inbound message. This a primary identifier to drive billing of a claim.
CARDHOLDER_IDENT VARCHAR(50) Y The prescription plan ID that is on the prescription plan card.
CARDHOLDER_NAME VARCHAR(80) Y Cardholder's last name, first name from the inbound message.
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.
COPAY_LIST_KEY VARCHAR(50) Y Co-pay code is a key to the formulary and benefits data for a pharmacy benefits manager from the inbound message.
COVERAGE_LIST_KEY VARCHAR(50) Y Coverage code is a key to the formulary and benefits data for a pharmacy benefits manager from the inbound message.
DATA_EXPIRE_DT_TM DATETIME Y Date and time that the data expires.
EEM_RX_ELIG_DETAIL_ID DOUBLE N Primary identifier of EEM_RX_ELIG_DETAIL table.
ENCNTR_ID DOUBLE N Identifier of the encounter tied to this transaction.
FORMULARY_ALT_LIST_KEY VARCHAR(50) Y Alternate formulary code is a key to the formulary and benefits data for a pharmacy benefits manager from the inbound message.
FORMULARY_LIST_KEY VARCHAR(50) Y Formulary code is a key to the formulary and benefits data for a pharmacy benefits manager from the inbound message.
GROUP_IDENT VARCHAR(50) Y Group Identification number from the inbound message.
GROUP_NAME VARCHAR(80) Y Group name from the inbound message.
HEALTH_PLAN_ID DOUBLE N Unique identifier of the health plan used with this transaction.
IB_ADDRESS_LINE_1 VARCHAR(55) Y Person's address line 1 from the inbound message.
IB_ADDRESS_LINE_2 VARCHAR(55) Y Person's address line 2 from the inbound message.
IB_BIRTH_DT_TM_TXT VARCHAR(10) Y Person's birth date and time from the inbound message.
IB_CITY VARCHAR(30) Y Person's city from the inbound message.
IB_FIRST_NAME VARCHAR(35) Y Person's given first name from the inbound message.
IB_GENDER_CD DOUBLE N Person's gender that from the inbound message.
IB_LAST_NAME VARCHAR(60) Y Person's given last name from the inbound message.
IB_MIDDLE_NAME VARCHAR(25) Y Person's given middle name from the inbound message.
IB_NAME_SUFFIX VARCHAR(10) Y Person's given name suffix from the inbound message.
IB_PAT_CHANGE_IND DOUBLE N This captures the change indicator field from the inbound eligibility response for the patient. If set, the payer's version of the patient's demographics data is different from what was sent outbound.
IB_POSTAL_CODE VARCHAR(15) Y Person's postal Code (Zip Code) from the inbound message.
IB_SSN VARCHAR(30) Y Person's Social Security Number from the inbound message.
IB_STATE VARCHAR(2) Y Person's state from the inbound message.
INTERCHANGE_CONTROL_NBR_IDENT VARCHAR(9) Y A control number assigned by the interchange sender as a means to identify a transaction from the sender's system.
INTERCHANGE_ID DOUBLE N Primary identifier for a transaction.
OB_BIRTH_DT_TM_TXT VARCHAR(35) Y Person's birth date and time from the outbound message.
OB_FIRST_NAME VARCHAR(35) Y Person's given first name from the outbound message.
OB_GENDER_CD DOUBLE N Person's gender from the outbound message.
OB_LAST_NAME VARCHAR(60) Y Person's given last name from the outbound message.
OB_MIDDLE_NAME VARCHAR(25) Y Person's given middle name from the outbound message.
OB_POSTAL_CODE VARCHAR(15) Y Person's postal Code (Zip Code) from the outbound message.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PATIENT_UNIT_NUMBER VARCHAR(50) Y Identification number that can be used in conjunction with the member id for better identifying dependents or non-uniquely identifiable members of a plan.
PBM_MEMBER_IDENT VARCHAR(80) Y Identifier used by the payer to uniquely identify the person.
PBM_ORGANIZATION_ID DOUBLE N Unique identifier of the carrier organization used with this transaction.
PERSON_ID DOUBLE N Identifier of the person for who this transaction was sent.
PLAN_ADMIN_IDENT VARCHAR(80) Y This further identifies the plan administrator within the contributor system.
PLAN_ADMIN_NAME VARCHAR(60) Y Name of the prescription health plan administrator or payer.
PRESCRIBER_PRSNL_ID DOUBLE N The unique identifier of the patient's prescribing provider.
PRESCRIPTION_PLAN_IDENT VARCHAR(50) Y Prescription health plan identification number from the inbound message.
PRESCRIPTION_PLAN_NAME VARCHAR(80) Y Prescription health plan name from the inbound message.
PROCESS_CONTROL_NUMBER VARCHAR(80) Y The Processor Control Number (PCN) is a secondary identifier to the BIN that may be used in routing of pharmacy transactions. A PBM/processor/plan may choose to differentiate different plans/benefit packages with the use of unique PCNs. The PCN is defined by the PBM/processor.
REPLY_DT_TM DATETIME Y Date and time the transaction was returned.
RX_HIST_VERSION_CD DOUBLE N Defines the specification version to be utilized for the transaction to request a person's prescription history.
SENDER_PRSNL_ID DOUBLE N Unique identifier of the person who is the sender of the transaction.
SENT_DT_TM DATETIME N Date and time the transaction was sent outbound.
SEQUENCE DOUBLE N Used to locate the proper ST to SE loop when looking up the original inbound message via the long_blob table.
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_ELIG_DETAIL


Child Column in EEM_RX_ELIG_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PBM_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PRESCRIBER_PRSNL_ID PRSNL PERSON_ID
SENDER_PRSNL_ID PRSNL PERSON_ID




Parent Column in EEM_RX_ELIG_DETAIL (PK) Child Table Name Child Column Name
Children: EEM_RX_ELIG_DETAIL_ID EEM_ELIG_SVC_DETAIL EEM_RX_ELIG_DETAIL_ID
EEM_RX_MED_HIST_DETAIL EEM_RX_ELIG_DETAIL_ID