Table Detail Report

EEM_DEMOG_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Query Demographics Transaction Summary
Definition: A row represents summary of transaction data
Table Type: ACTIVITY





Column Detail - EEM_DEMOG_DETAIL


Column Name Type Null? Definition
BIRTH_DT_TM DATETIME Y The birth date and time of the person for which the transaction was submitted. If not populated, refer to birth_dt_tm_txt.
BIRTH_DT_TM_TXT VARCHAR(30) Y The birth date and time in ISO date format "YYYY-MM-DDThh:mm:ss.sTZD".
BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FIRST_NAME VARCHAR(200) Y Patient First Name
GENDER_CD DOUBLE N Patient Gender
INTERCHANGE_ID DOUBLE N Unique Identifier for this table
LAST_NAME VARCHAR(200) Y Patient Last Name
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)
PHN_ALIAS_POOL_CD DOUBLE N The alias pool code of personal health number alias.
PHN_ALIAS_TYPE_CD DOUBLE N The alias type code used to define the type of alias used a personal health number.
PROFILE_ID DOUBLE N The identifier of the profile used for the transaction. A profile contains reference data for outbound messages and is used to define required data to submit the transaction.
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_DEMOG_DETAIL


Child Column in EEM_DEMOG_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_ELIG_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Eligibility Detail
Definition: Discrete Data for the Eligibility Transaction.
Table Type: ACTIVITY





Column Detail - EEM_ELIG_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.
DATA_FLAG DOUBLE N Indicates the status of the data w/in the transaction (not of the transaction itself). 0 - Error, 1 - Eligible, 2 - Denied, 3 - Unknown.
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.
HEALTH_PLAN_ID DOUBLE N The health plan used for this transaction.
IB_EMPLOYEE_ID_NUM VARCHAR(30) Y The employee identification Number as indicated by the inbound transaction.
IB_IDEN_CARD_NUM VARCHAR(50) Y The identification card number as indicated by the inbound transaction.
IB_INS_POL_NUM VARCHAR(50) Y The insurance policy number as indicated by the inbound transaction.
IB_ISSUE_NUM VARCHAR(50) Y The issue number as indicated by the inbound transaction.
IB_MEDICAID_RECPNT_ID_NUM VARCHAR(50) Y The Medicaid recipient identification number as indicated by the inbound transaction.
IB_MED_REC_ID_NUM VARCHAR(50) Y The medical record identification number as indicated by the inbound transaction.
IB_PAT_BIRTH_DT_TM VARCHAR(35) Y The patient birth date as indicated by the inbound transaction.
IB_PAT_FIRST_NAME VARCHAR(35) Y The patient's first name as indicated by the inbound transaction.
IB_PAT_LAST_NAME VARCHAR(60) Y The patient's last name as indicated by the inbound transaction.
IB_PAT_SSN VARCHAR(30) Y The patient's social security number as indicated by the inbound transaction.
IB_PLAN_NETWK_ID_NUM VARCHAR(50) Y The plan network identification number as indicated by the inbound transaction.
IB_PRIOR_ID_NUM VARCHAR(50) Y The prior identification number as indicated by the inbound transaction.
IB_SUB_BIRTH_DT_TM VARCHAR(35) Y The subscriber's birth date as indicated by the inbound transaction.
IB_SUB_FIRST_NAME VARCHAR(35) Y The subscriber's first name as indicated by the inbound transaction.
IB_SUB_GROUP_NUM VARCHAR(50) Y The subscriber's group number as indicated by the inbound transaction.
IB_SUB_GROUP_OR_POLICY_NUM VARCHAR(50) Y The subscriber's group or policy number as indicated by the inbound transaction.
IB_SUB_LAST_NAME VARCHAR(60) Y The subscriber's last name as indicated by the inbound transaction.
IB_SUB_MEMBER_ID VARCHAR(80) Y The subscriber's member identification number as indicated by the inbound transaction.
IB_SUB_POLICY_NUM VARCHAR(50) Y The subscriber's policy number as indicated by the inbound transaction.
IB_SUB_SSN VARCHAR(30) Y The subscriber's social security number as indicated by the inbound transaction.
INFO_SRC_PRIMARY_IDEN VARCHAR(80) Y The value filled in the info_src_primary_iden field on the outbound transaction (aka: payer iden)
INTERCHANGE_ID DOUBLE N Interchange id of the transaction that this detail data came from.
OB_BEG_SERVICE_DATE VARCHAR(12) N This is the start time on the out bound 270 message for requesting a patient?s eligibility status. In conjunction with the service end date, it is used to check for eligibility through a range of days. If no end date is populated, then eligibility status is checked for the date stored in the begin date.
OB_END_SERVICE_DATE VARCHAR(12) N This is the end time on the out bound 270 message for requesting a patient?s eligibility status. In conjunction with the service begin date, it is used to check for eligibility through a range of days. If no end date is populated, then eligibility status is checked for the date stored in the begin date.
OB_PAT_BIRTH_DT_TM VARCHAR(35) Y The patient's birth date as indicated by the outbound transaction.
OB_PAT_FIRST_NAME VARCHAR(35) Y The patient's first name as indicated by the outbound transaction.
OB_PAT_LAST_NAME VARCHAR(60) Y The patient's last name as indicated by the outbound transaction.
OB_PAT_SSN VARCHAR(30) Y The patient's social security number as indicated by the outbound transaction.
OB_SUB_BIRTH_DT_TM VARCHAR(35) Y The subscriber's birth date as indicated by the outbound transaction.
OB_SUB_FIRST_NAME VARCHAR(35) Y The subscriber's first name as indicated by the outbound transaction.
OB_SUB_GROUP_NUM VARCHAR(50) Y The subscriber's group number as indicated by the outbound transaction.
OB_SUB_GROUP_OR_POLICY_NUM VARCHAR(50) Y The subscriber's group number as indicated by the outbound transaction.
OB_SUB_LAST_NAME VARCHAR(60) Y The subscriber's last name as indicated by the outbound transaction.
OB_SUB_MEMBER_ID VARCHAR(80) Y The subscriber's member id as indicated by the outbound transaction.
OB_SUB_POLICY_NUM VARCHAR(50) Y The subscriber's policy number as indicated by the outbound transaction.
OB_SUB_SSN VARCHAR(30) Y The subscriber's social security number as indicated by the outbound transaction.
PAT_PERSON_ID DOUBLE N Cerner person id of the patient
PAYOR_ID DOUBLE N Cerner's payor ID
PROFILE_ID DOUBLE N The profile ID used in the transaction
REPLY_DT_TM DATETIME Y The date and time that the transaction's reply came back.
SENDER_PRSNL_ID DOUBLE N The person ID of the person that sent the transaction.
SENT_DT_TM DATETIME N The date and time that the transaction was sent.
SUB_PERSON_ID DOUBLE N The person id of the Subscriber
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_ELIG_DETAIL


Child Column in EEM_ELIG_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PROFILE_ID EEM_PROFILE PROFILE_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PAYOR_ID ORGANIZATION ORGANIZATION_ID
PAT_PERSON_ID PERSON PERSON_ID
SUB_PERSON_ID PERSON PERSON_ID
SENDER_PRSNL_ID PRSNL PERSON_ID


EEM_ELIG_SVC_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Eligibility Service Details
Definition: EEM Eligibility Service Details table
Table Type: ACTIVITY





Column Detail - EEM_ELIG_SVC_DETAIL


Column Name Type Null? Definition
EEM_ELIG_SVC_DETAIL_ID DOUBLE N Primary identifier for EEM_ELIG_SVC_DETAIL
EEM_RX_ELIG_DETAIL_ID DOUBLE N Primary identifier for EEM_RX_ELIG_DETAIL
ELIGIBILITY_STATUS_CD DOUBLE N Denotes if a service is eligible or not eligible
INTERCHANGE_ID DOUBLE N Primary identifier for a transaction
SERVICE_TYPE_CD DOUBLE N Defines the type of service for eligibility or benefit details
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_ELIG_SVC_DETAIL


Child Column in EEM_ELIG_SVC_DETAIL(FK) Parent Table Name Parent Column Name
Parents: EEM_RX_ELIG_DETAIL_ID EEM_RX_ELIG_DETAIL EEM_RX_ELIG_DETAIL_ID
INTERCHANGE_ID EEM_TRANSACTION TRANSACTION_ID


EEM_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM job
Definition: This table defines pending jobs that need to be processed at a later time
Table Type: ACTIVITY





Column Detail - EEM_JOB


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.
EEM_JOB_ID DOUBLE N The unique primary key of this table.
HEALTH_PLAN_ID DOUBLE N This is only used by transactions that are tied to a health plan when the health plan is known before submitting the transaction. It is a unique identifier from the health_plan table.
JOB_STATE_CD DOUBLE N The job state is used to track where a job is in its life cycle. Jobs are created for transactions that are to be processed at a later time. A job is created in a pending state and may move to the other states as it is processed.
PAYER_ID DOUBLE N This is only used by transactions sent to a payer. A payer is known as a carrier organization. It is a unique identifier from the organization table.
TEMPLATE_INTERCHANGE_ID DOUBLE N Unique identifier for the transaction template
TRANSACTION_CD DOUBLE N The transaction code is used to define the type of transaction for which the job was created.
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_JOB


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




Parent Column in EEM_JOB (PK) Child Table Name Child Column Name
Children: EEM_JOB_ID EEM_BATCH_JOB EEM_JOB_ID
EEM_TRANSACTION EEM_JOB_ID


EEM_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM transaction log.
Definition: EEM transactions are logged here.
Table Type: ACTIVITY





Column Detail - EEM_LOG


Column Name Type Null? Definition
ACTION_CD DOUBLE N The Action that happened when this row was logged.
ACTION_MEANING VARCHAR(12) Y The meaning of the code value in the action_cd column.
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.
CACHED_IND DOUBLE N Indicates if the interchange ID used in the Tx is the same as a previous transaction.
DATA_DT_TM DATETIME N Data date and time.
DATA_FLAG DOUBLE N Data flag.
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.
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.
LOG_ID DOUBLE N Log ID.
LONG_TEXT_ID DOUBLE N Primary Key to LONG_TEXT_REFERENCE table. OBSOLETE, this column is no longer used.
MODIFY_REASON_CD DOUBLE N Reason for manually modifying the transactions data status.
POLL_DT_TM DATETIME N Poll date and time.
POLL_RESPONSE_IND DOUBLE N Indicates if data was returned or not on a POLL action.
PROFILE_ID DOUBLE N The profile associated to this log.
PROXY_FLAG DOUBLE N Proxy flag.
REPLY_STATUS_CD DOUBLE N Indicates if the reply action is a PENDING or a RECEIVED type.
REPLY_STATUS_MEANING VARCHAR(12) Y Indicates if the reply action is a PENDING or a RECEIVED type.
TRANS_DATA_MOD_CD DOUBLE N Describes the status of a transaction message as determined by a user's review of the message.
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.
USER_ID DOUBLE N User ID.



Relationship Detail - EEM_LOG


Child Column in EEM_LOG(FK) Parent Table Name Parent Column Name
Parents: PROFILE_ID EEM_PROFILE PROFILE_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in EEM_LOG (PK) Child Table Name Child Column Name
Children: LOG_ID EEM_LOG_BLOB EEM_LOG_ID