EEM_ADDRESS_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Update Address Transaction Summary
Definition: A row represents summary of transaction data.
Table Type: ACTIVITY





Column Detail - EEM_ADDRESS_DETAIL


Column Name Type Null? Definition
ADDRESS_GUESS_IND DOUBLE N Ministry Address Guess Indicator
INTERCHANGE_ID DOUBLE N This is the record number for interchange.
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 Profile ID.
REPLY_DT_TM DATETIME Y Date and Time the response was received
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.
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.
VALID_ADDRESS_IND DOUBLE N Valid Address Indicator



Relationship Detail - EEM_ADDRESS_DETAIL


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


EEM_AUTH_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Authorization Detail
Definition: The EEM_AUTH_DETAIL table stores detailed information pertaining to a single X12 278 Service Review transaction submitted as it was submitted for a given patient.
Table Type: ACTIVITY





Column Detail - EEM_AUTH_DETAIL


Column Name Type Null? Definition
DEP_NAME_FIRST VARCHAR(35) Y This is the first name of the dependent as submitted on the outbound 278 transaction if the patient is not the subscriber. If the patient is the subscriber, this attribute will not be populated.
DEP_NAME_LAST VARCHAR(60) Y This is the last name of the dependent as submitted on the outbound 278 transaction if the patient is not the subscriber. If the patient is the subscriber, this attribute will not be populated.
DEP_PERSON_ID DOUBLE N This is the person identifier of the dependent used for submitting the outbound 278 transaction if the patient is not the subscriber. If the patient is the subscriber, this attribute will not be populated.
ENCOUNTER_ID DOUBLE N The ID of the encounter associated with this transaction.
HEALTH_PLAN_ID DOUBLE N The ID of the health plan associated with the payer for the transaction.
INTERCHANGE_ID DOUBLE N A unique transaction identifier.
PAYER_ID DOUBLE N UNIQUE identifier OF the organization that IS the payer/UMO FOR the TRANSACTION
PROFILE_ID DOUBLE N UNIQUE identifier FOR the TRANSACTION PROFILE
REPLY_DT_TM DATETIME Y This IS the DATE AND TIME the TRANSACTION was last received
SENDER_PRSNL_ID DOUBLE N UNIQUE identifier OF the person who IS the sender OF the TRANSACTION
SENT_DT_TM DATETIME N This IS the DATE AND TIME the TRANSACTION was originally sent
SUB_MEMBER_IDEN VARCHAR(80) Y This is the subscriber's member identifier for their health plan as submitted on the outbound 278 transaction.
SUB_NAME_FIRST VARCHAR(35) Y The subscriber?s first name
SUB_NAME_LAST VARCHAR(60) Y The subscriber?s last name
SUB_PERSON_ID DOUBLE N UNIQUE identifier OF the person who IS 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_AUTH_DETAIL


Child Column in EEM_AUTH_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PROFILE_ID EEM_PROFILE PROFILE_ID
ENCOUNTER_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PAYER_ID ORGANIZATION ORGANIZATION_ID
DEP_PERSON_ID PERSON PERSON_ID
SUB_PERSON_ID PERSON PERSON_ID
SENDER_PRSNL_ID PRSNL PERSON_ID


EEM_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM batch
Definition: EEM_BATCH tracks each batch job submitted
Table Type: ACTIVITY





Column Detail - EEM_BATCH


Column Name Type Null? Definition
EEM_BATCH_ID DOUBLE N eem batch identifier
HEALTH_PLAN_ID DOUBLE N Unique identifier of a health plan for the health_plan table
PAYER_ID DOUBLE N payer identifier
SUBMIT_DT_TM DATETIME N The date and time for which the bill record is submitted to a payer.
TRANSACTION_CD DOUBLE N transaction code
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_BATCH


Child Column in EEM_BATCH(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_BATCH (PK) Child Table Name Child Column Name
Children: EEM_BATCH_ID EEM_BATCH_JOB EEM_BATCH_ID
EEM_TRANSACTION EEM_BATCH_ID


EEM_BATCH_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: eem batch job
Definition: eem batch job table
Table Type: ACTIVITY





Column Detail - EEM_BATCH_JOB


Column Name Type Null? Definition
EEM_BATCH_ID DOUBLE N eem batch identifier
EEM_BATCH_JOB_ID DOUBLE N eem batch job identifier
EEM_JOB_ID DOUBLE N eem job 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.
SEQUENCE DOUBLE N Sequence.
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_BATCH_JOB


Child Column in EEM_BATCH_JOB(FK) Parent Table Name Parent Column Name
Parents: EEM_BATCH_ID EEM_BATCH EEM_BATCH_ID
EEM_JOB_ID EEM_JOB EEM_JOB_ID


EEM_COVERAGE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - EEM_COVERAGE_DETAIL


Column Name Type Null? Definition
ELIGIBLE_FLAG DOUBLE N Indicates the status of the data w/in the transaction (not of the transaction itself). 0 - Error (response never came back) 1 - Eligible 2 - Denied 3 - Unknown (response was back but not filled/cannot determine
FIRST_NAME VARCHAR(200) Y Patient First Name
INTERCHANGE_ID DOUBLE N Interchange id of the transaction that this detail data came from.
LAST_NAME VARCHAR(200) Y 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)
PROFILE_ID DOUBLE N Profile ID.
REPLY_DT_TM DATETIME Y The date and time that the transaction's reply came back.
SENDER_PRSNL_ID DOUBLE N Sender Personnel Identifier
SENT_DT_TM DATETIME N The date and time that the transaction was sent.
TERM_DT_TM DATETIME Y Patient termination date/time
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_COVERAGE_DETAIL


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