Table Detail Report

EEM_NETWORK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Provider Networks
Definition: Attributes for a provider Network
Table Type: REFERENCE





Column Detail - EEM_NETWORK


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.
DESCRIPTION VARCHAR(200) Y Description of Network
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.
LONG_TEXT_ID DOUBLE N Long Text Id of the Comment for a Network
MNEMONIC VARCHAR(100) N Network mnemonic
MNEMONIC_KEY VARCHAR(100) N Mnemonic Key field
MNEMONIC_KEY_A_NLS VARCHAR(400) Y MNEMONIC_KEY_A_NLS column
MNEMONIC_KEY_NLS VARCHAR(202) Y International version of mnemonic key
NETWORK_ID DOUBLE N Primary Key.
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_NETWORK


Child Column in EEM_NETWORK(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in EEM_NETWORK (PK) Child Table Name Child Column Name
Children: NETWORK_ID EEM_ENTITY_NTWK_RELTN NETWORK_ID
EEM_NTWK_PRSNL_RELTN NETWORK_ID
EEM_PRSNL_LOC_RELTN NETWORK_ID


EEM_NTWK_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Network Personnel Relation
Definition: A row represents providers relationship to a network.
Table Type: REFERENCE





Column Detail - EEM_NTWK_PRSNL_RELTN


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.
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.
LONG_TEXT_ID DOUBLE N Comment to accompany relation row.
NETWORK_ID DOUBLE N Network Id
NTWK_PRSNL_RELTN_ID DOUBLE N The unique primary key of this table.
PRSNL_ID DOUBLE N Id of the Prsnl ID in the network.
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_NTWK_PRSNL_RELTN


Child Column in EEM_NTWK_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: NETWORK_ID EEM_NETWORK NETWORK_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID


EEM_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM profile.
Definition: EEM profile table
Table Type: REFERENCE





Column Detail - EEM_PROFILE


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.
ALLOW_FUTURE_IND DOUBLE N Allow future indicator (yes (1) or No (0))
ALLOW_HISTORIC_IND DOUBLE N Allow historic indicator (yes (1) or No (0))
ALLOW_PROCEDURE_LVL_IND DOUBLE N Allow Procedure level indicator (yes (1) or No (0))
ALLOW_SERVICE_TYPE_LVL_IND DOUBLE N Allow service type level indicator (yes (1) or No (0))
AUTOMATION_FLAG DOUBLE N The type of automation used.
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.
CONTACT VARCHAR(100) Y Contact.
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_DURATION DOUBLE N Duration, in number of seconds, in which data should remain available.
DATA_DURATION_FLAG DOUBLE N The type of data duration. 0 - Message not returned, 1 - Message returned (eligible), 1 - Message returned (not eligible), 3 - Message returned (Unknown or non-eligibility message), 4 - Message returned (error), 5 - Message template.
DEFAULT_SVC_TYPE_CD DOUBLE N The default service type.
DEP_UNIQ_ID_CD DOUBLE N Indicates if this profile has dependents that are uniquely identifiable -No HL23
DESCRIPTION VARCHAR(100) Y Description of profile.
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.
GS_APP_RECEIVERS_CODE VARCHAR(15) Y Data to be placed in the outbound field.. GS-03
GS_APP_SENDERS_CODE VARCHAR(15) Y Data to be placed in the outbound field.. GS-02
HEALTH_PLAN_ID DOUBLE N The ID of the health plan associated with the profile.
INFOSOURCE_COMM_NUM1 VARCHAR(80) Y Requester's first communication number for contacting the requester.
INFOSOURCE_COMM_NUM1_CD DOUBLE N Requester's first communication number qualifier code for the requester (email, fax, phone).
INFOSOURCE_COMM_NUM2 VARCHAR(80) Y Requester's second communication number for contacting the requester.
INFOSOURCE_COMM_NUM2_CD DOUBLE N Requester's second communication number qualifier code for the requester (email, fax, phone, extension).
INFOSOURCE_COMM_NUM3 VARCHAR(80) Y Requester's third communication number for contacting the requester.
INFOSOURCE_COMM_NUM3_CD DOUBLE N Requester's third communication number qualifier code for the requester (email, fax, phone, extension).
INFOSOURCE_CONTACT_NAME VARCHAR(60) Y Requester's contact Name for the requester of the authorization transaction.
INFOSOURCE_ENTITY_ID_CD DOUBLE N Data to be placed in the outbound field.. NM1-01.
INFOSOURCE_ENTITY_TYPE_CD DOUBLE N Data to be placed in the outbound field.. NM1-02.
INFOSOURCE_ID_CD DOUBLE N Data to be placed in the outbound field.. NM1-08.
INFOSOURCE_NAME_FIRST VARCHAR(35) Y Data to be placed in the outbound field.. HL-20 -> NM1-04 (If NM1-02 has a "1").
INFOSOURCE_NAME_LAST_ORG VARCHAR(60) Y Data to be placed in the outbound field.. NM1-03.
INFOSOURCE_NAME_MIDDLE VARCHAR(25) Y Data to be placed in the outbound field.. NM1-05.
INFOSOURCE_NAME_SUFFIX VARCHAR(10) Y Data to be placed in the outbound field.. NM1-07.
INFOSOURCE_PRIMARY_IDEN VARCHAR(80) Y Data to be placed in the outbound field.. NM1-09 (Qualified by NM1-08).
INITIAL_DELAY DOUBLE N The number of seconds to wait before any polling should take place.
ISA_ACK_REQUESTED_CD DOUBLE N Data to be placed in the outbound field.. ISA-14.
ISA_AUTHOR_INFORMATION VARCHAR(10) Y Data to be placed in the outbound field.. ISA-02.
ISA_AUTHOR_INFO_QUAL_CD DOUBLE N ISA-01
ISA_INTERCHG_REC_IDEN VARCHAR(15) Y Data to be placed in the outbound field.. ISA-08.
ISA_INTERCHG_REC_ID_QUAL_CD DOUBLE N Data to be placed in the outbound field.. ISA-07.
ISA_INTERCHG_SENDER_IDEN VARCHAR(15) Y Data to be placed in the outbound field. ISA-06.
ISA_INTERCHG_SENDER_ID_QUAL_CD DOUBLE N Data to be placed in the outbound field.. ISA-05
ISA_SECURITY_INFORMATION VARCHAR(10) Y Data to be placed in the outbound field.. ISA-04.
ISA_SECURITY_INFO_QUAL_CD DOUBLE N Data to be placed in the outbound field.ISA-03.
MAX_DELAY DOUBLE N The maximum number of seconds to wait before timing out transactions.
MAX_RESUBMIT_DURATION DOUBLE N The maximum re-submit duration defines the length of time after a transaction was first submitted and the last time the transaction service should attempt a resubmit if necessary.
MOH_FACILITY VARCHAR(30) Y Ministry issues values for facility identification
MOH_LOCAL_DEVICE VARCHAR(30) Y Identifies where the transaction came from a facility (e.g., Emergency Department
MOH_LOCAL_USER VARCHAR(30) Y Contains the client's authorization ID.
MOH_PROVIDER VARCHAR(30) Y Ministry issued values for provider identification.
MOH_TRANSACTION VARCHAR(30) Y RPVR0500 followed by a space
MOH_USER VARCHAR(30) Y Authorization issues by the ministry
PASSWORD VARCHAR(40) Y Foreign system password.
PAYOR_ID DOUBLE N Organization ID of payor.
POLL_DELAY DOUBLE N Number of seconds to wait between polls.
POLL_DURATION DOUBLE N Number of seconds an incomplete transaction is available for polling.
PROFILE_ID DOUBLE N The primary ID of this table.
PROXY_FLAG DOUBLE N Indicates whether data is proxy hosted. 0 - Not proxy hosted, 1 - Proxy hosted.
RP_COMM_NUM1 VARCHAR(256) Y First communication number for contacting the requester.
RP_COMM_NUM1_CD DOUBLE N First communication number qualifier code for the requester (email, fax, phone).
RP_COMM_NUM2 VARCHAR(256) Y Second communication NUMBER FOR contacting the requester.
RP_COMM_NUM2_CD DOUBLE N Second communication NUMBER qualifier code FOR the requester (email, fax, phone, extension).
RP_COMM_NUM3 VARCHAR(256) Y Third communication NUMBER FOR contacting the requester.
RP_COMM_NUM3_CD DOUBLE N Third communication NUMBER qualifier code FOR the requester (email, fax, phone, extension).
RP_CONTACT_NAME VARCHAR(60) Y Contact Name for the requester of the authorization transaction.
RP_N3_ADDR1 VARCHAR(55) Y N3 segment address 1 (2100B N3-01).
RP_N3_ADDR2 VARCHAR(55) Y N3 segment address 2 (2100B N3-02).
RP_N4_CITY VARCHAR(30) Y N4 segment city (2100B N4-01).
RP_N4_COUNTRY_CODE VARCHAR(3) Y N4 segment country code (2100B N4-04).
RP_N4_POSTAL_CODE VARCHAR(15) Y N4 segment postal code (2100B N4-03).
RP_N4_STATE_PROV_CD DOUBLE N N4 segment state/provential code (2100B N4-02).
RP_NM1_ENTITY_ID_CD DOUBLE N NM1-segment entity id code set (2100B NM1-01).
RP_NM1_ENTITY_TYPE_QUAL_CD DOUBLE N NM1-segment entity type qual code set (2100B NM1-02).
RP_NM1_IDEN VARCHAR(80) Y NM1 segment identification.
RP_NM1_IDEN_CD DOUBLE N NM1 segment identification code value (2100B NM1-09).
RP_NM1_NAME_FIRST VARCHAR(35) Y NM1 segment First Name (2100B NM1-04).
RP_NM1_NAME_LAST_ORG VARCHAR(60) Y NM1 segment last or organization Name (2100B NM1-03).
RP_NM1_NAME_MIDDLE VARCHAR(25) Y NM1 segment middle Name (2100B NM1-05).
RP_NM1_NAME_SUFFIX VARCHAR(10) Y NM1 segment suffix (2100B NM1-07).
RP_PRV_PROV_CD DOUBLE N PRV segment provider code value (2100B PRV-01).
RP_PRV_REF_ID VARCHAR(50) Y PRV segment reference identification code value (2100B PRV-02).
RP_PRV_REF_ID_QUAL_CD DOUBLE N PRV segment reference identification qual code value (2100B PRV-03).
RP_REF_CARRIER_REF_NUM VARCHAR(50) Y The carrier assigned reference NUMBER IS additional reference identification FOR the TRANSACTION requester.
RP_REF_CONTRACT_NUM VARCHAR(50) Y The REF segment contract number.
RP_REF_CONTRACT_NUM_DESC VARCHAR(80) Y The description of the REF segment contract number.
RP_REF_ELECT_DEV_PIN_NUM VARCHAR(50) Y The pin number REF electronic device.
RP_REF_ELECT_DEV_PIN_NUM_DESC VARCHAR(80) Y The description of the REF electronic device pin number.
RP_REF_EMPLOYER_ID_NUM VARCHAR(50) Y The employer id NUMBER IS additional reference identification FOR the TRANSACTION requester.
RP_REF_FACILITY_ID_NUM VARCHAR(50) Y The number of the REF segment facility.
RP_REF_FACILITY_ID_NUM_DESC VARCHAR(80) Y The description of the REF segment facility id number.
RP_REF_FAC_NETWK_ID_NUM VARCHAR(50) Y The number of the REF segment facility network.
RP_REF_FAC_NETWK_ID_NUM_DESC VARCHAR(80) Y The description of the REF segment facility network.
RP_REF_FED_TAXPAYER_NUM VARCHAR(50) Y The federal taxpayer number of the REF segment.
RP_REF_FED_TAXPAYER_NUM_DESC VARCHAR(80) Y The description of the REF segment federal taxpayer number.
RP_REF_HCFA_NAT_PROV_NUM VARCHAR(50) Y The number of the REF segment HCFA national provider.
RP_REF_HCFA_NAT_PROV_NUM_DESC VARCHAR(80) Y The description of the REF segment HCFA national provider number.
RP_REF_MEDICAID_PRV_NUM VARCHAR(50) Y The number of the REF segment Medicaid provider.
RP_REF_MEDICAID_PRV_NUM_DESC VARCHAR(80) Y The description of the REF segment Medicaid provider number.
RP_REF_MEDICARE_PRV_NUM VARCHAR(50) Y The number of the REF segment Medicare provider.
RP_REF_MEDICARE_PRV_NUM_DESC VARCHAR(80) Y The description of the REF segment Medicare provider number.
RP_REF_PERS_ID_NUM VARCHAR(50) Y The ID of the REF segment personal.
RP_REF_PERS_ID_NUM_DESC VARCHAR(80) Y The description of the REF segment personal identification number.
RP_REF_PRIOR_ID_NUM VARCHAR(50) Y The ID of the REF segment prior.
RP_REF_PRIOR_ID_NUM_DESC VARCHAR(80) Y The description of the REF segment prior number.
RP_REF_PRV_PLN_NW_ID_NUM VARCHAR(50) Y The ID of the REF segment provider plan network.
RP_REF_PRV_PLN_NW_ID_NUM_DESC VARCHAR(80) Y The description of the REF segment provider plan network identification number.
RP_REF_PRV_SITE_NUM VARCHAR(50) Y The provider site number to be used in the REF segment within the Information Source loop.
RP_REF_PRV_UPIN_NUM VARCHAR(50) Y The provider UPIN NUMBER IS additional reference identification FOR the TRANSACTION requester.
RP_REF_SSN VARCHAR(50) Y The REF segment social security number.
RP_REF_SSN_DESC VARCHAR(80) Y The REF segment social security number description.
RP_REF_STATE_LIC_NUM VARCHAR(50) Y The REF segment State license number.
RP_REF_STATE_LIC_NUM_DESC VARCHAR(80) Y The description of the REF segment State license number.
RP_REF_SUBMITTER_ID_NUM VARCHAR(50) Y The ID of the REF segment submitter.
RP_REF_SUBMITTER_ID_NUM_DESC VARCHAR(80) Y The description of the REF segment submitter ID number.
RP_REF_USER_ID VARCHAR(50) Y The ID of the REF segment user.
RP_REF_USER_ID_DESC VARCHAR(80) Y The description of the REF segment user ID.
TRANSACTION_CD DOUBLE N The type of transaction supported by this profile.
TRANS_TYPE_FLAG DOUBLE N The type of transaction. 0 - Single transaction submission only, 1 - Single or batch transaction submission.
TRANS_VERSION_CD DOUBLE N A codified attribute to define the transaction version supported
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.
USERNAME VARCHAR(40) Y User name for foreign system.



Relationship Detail - EEM_PROFILE


Child Column in EEM_PROFILE(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PAYOR_ID ORGANIZATION ORGANIZATION_ID




Parent Column in EEM_PROFILE (PK) Child Table Name Child Column Name
Children: PROFILE_ID EEM_ADDRESS_DETAIL PROFILE_ID
EEM_AUTH_DETAIL PROFILE_ID
EEM_COVERAGE_DETAIL PROFILE_ID
EEM_DEMOG_DETAIL PROFILE_ID
EEM_ELIG_DETAIL PROFILE_ID
EEM_LOG PROFILE_ID
EEM_MOH_DETAIL PROFILE_ID
EEM_NEWBORN_DETAIL PROFILE_ID
EEM_PROFILE_INPUT PROFILE_ID
EEM_PROFILE_LOCATION PROFILE_ID
EEM_PROFILE_OUTPUT PROFILE_ID
EEM_PROFILE_POPULATE PROFILE_ID
EEM_PROFILE_PRSNL PROFILE_ID
EEM_PROFILE_REPORT PROFILE_ID
EEM_PROFILE_SCENARIO PROFILE_ID
EEM_TRANSACTION PROFILE_ID


EEM_PROFILE_INPUT



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM profile input.
Definition: EEM profile input.
Table Type: REFERENCE





Column Detail - EEM_PROFILE_INPUT


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.
ELEMENT_CD DOUBLE N Element type code.
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.
INPUT_ID DOUBLE N Input ID.
LENGTH DOUBLE Y Length.
MASK VARCHAR(100) Y Mask.
PROFILE_ID DOUBLE N Profile ID.
SCENARIO DOUBLE Y Scenario sequence
SEARCH_CRITERIA_CD DOUBLE N Search Criteria
SEQUENCE DOUBLE N Sequence.
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_PROFILE_INPUT


Child Column in EEM_PROFILE_INPUT(FK) Parent Table Name Parent Column Name
Parents: PROFILE_ID EEM_PROFILE PROFILE_ID


EEM_PROFILE_LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Profile Location
Definition: This table is used to store profile information that varies by location.
Table Type: REFERENCE





Column Detail - EEM_PROFILE_LOCATION


Column Name Type Null? Definition
EEM_PROFILE_LOCATION_ID DOUBLE N Unique generated number that identifies a single row on the EEM_PROFILE_LOCATION table.
FACILITY_IDENT VARCHAR(15) Y Third party assigned identifier for a facility.
LOCATION_CD DOUBLE N Location identifier for which the profile information is being stored.
PROFILE_ID DOUBLE N The ID of the profile associated to the location.
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_IDENT VARCHAR(15) Y Third party assigned identifier for a user.



Relationship Detail - EEM_PROFILE_LOCATION


Child Column in EEM_PROFILE_LOCATION(FK) Parent Table Name Parent Column Name
Parents: PROFILE_ID EEM_PROFILE PROFILE_ID
LOCATION_CD LOCATION LOCATION_CD