EEM_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table is used to track actions performed on various objects
Definition: EEM Action
Table Type: ACTIVITY





Column Detail - EEM_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Action Date and Time
ACTION_MEANING VARCHAR(12) N A 12-char description corresponding to the Action Code.
ACTION_PRSNL_ID DOUBLE N Action Personnel Identifier
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.
EEM_ACTION_CD DOUBLE N This field denotes the action performed
EEM_ACTION_ID DOUBLE N A system-generated unique identifier
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.
PARENT1_ID DOUBLE N First Parent Identifier
PARENT1_TABLE VARCHAR(32) Y First Parent Table
PARENT2_ID DOUBLE N Parent2 Identifier
PARENT2_TABLE VARCHAR(32) Y Parent2 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.



Relationship Detail - EEM_ACTION


Child Column in EEM_ACTION(FK) Parent Table Name Parent Column Name
Parents: EEM_ACTION_CD CODE_VALUE CODE_VALUE
ACTION_PRSNL_ID PRSNL PERSON_ID




Parent Column in EEM_ACTION (PK) Child Table Name Child Column Name
Children: EEM_ACTION_ID EEM_ABN_ACTION FORM_ACTION_ID


EEM_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table is used to store comments (by text type/sub type) for various objects
Definition: EEM Comment
Table Type: ACTIVITY





Column Detail - EEM_COMMENT


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.
EEM_COMMENT_ID DOUBLE N A system-generated unique number corresponding to the comment
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.
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) N Parent Table
SUB_TEXT_CD DOUBLE N Sub Text Code
SUB_TEXT_MEANING VARCHAR(12) Y Sub Text Meaning
TEXT_ID DOUBLE N Long Text Identifier
TEXT_TYPE_CD DOUBLE N Text Type Code
TEXT_TYPE_MEANING VARCHAR(12) N Text Type Meaning
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_COMMENT


Child Column in EEM_COMMENT(FK) Parent Table Name Parent Column Name
Parents: SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE
TEXT_ID LONG_TEXT LONG_TEXT_ID


EEM_ENTITY_NTWK_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Entity Network Relation
Definition: Network association to an entity ( Health Plan or Health Plan/Sponsor)
Table Type: REFERENCE





Column Detail - EEM_ENTITY_NTWK_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.
ENTITY_NTWK_RELTN_ID DOUBLE N Unique Id
LONG_TEXT_ID DOUBLE N Stores the long text identifier
NETWORK_ID DOUBLE N Key to EEM_NETWORK
PARENT_ENTITY_ID DOUBLE N Key to HEALTH_PLAN/ORG_PLAN_RELTN
PARENT_ENTITY_NAME VARCHAR(32) N Health Plan (HEALTH_PLAN) or Sponsor (ORG_PLAN_RELTN)
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_ENTITY_NTWK_RELTN


Child Column in EEM_ENTITY_NTWK_RELTN(FK) Parent Table Name Parent Column Name
Parents: NETWORK_ID EEM_NETWORK NETWORK_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


EEM_ENTITY_PROV_TAX_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Relation from provider to provider taxonomy
Definition: Provider to taxonomy relationship
Table Type: REFERENCE





Column Detail - EEM_ENTITY_PROV_TAX_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.
EEM_ENTITY_PROV_TAX_RELTN_ID DOUBLE N Surrogate Key Identifier.
EEM_PROV_TAX_RELTN_ID DOUBLE N Foreign key to the EEM_PROV_TAX_RELTN 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.
LONG_TEXT_ID DOUBLE N Long Text Id for comments
PARENT_ENTITY_ID DOUBLE N Relation from Provider (physician/org/service resource) to provider_taxonomy Id.
PARENT_ENTITY_NAME VARCHAR(32) Y Relation from Provider (physician/org/service resource) to provider_taxonomy.
SEQ_NBR DOUBLE N For future use.
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_ENTITY_PROV_TAX_RELTN


Child Column in EEM_ENTITY_PROV_TAX_RELTN(FK) Parent Table Name Parent Column Name
Parents: EEM_PROV_TAX_RELTN_ID EEM_PROV_TAX_RELTN EEM_PROV_TAX_RELTN_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


EEM_FILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ABN Data File
Definition: ABN Data Files
Table Type: REFERENCE





Column Detail - EEM_FILE


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.
CHECK_SEQ DOUBLE N This field denotes the current content version used for ABN code pair checking.
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.
DESCRIPTION VARCHAR(200) Y A long description used for documentation.
EEM_FILE_ID DOUBLE N This is a unique identifier for the ABN data file
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.
IMPORT_SEQ DOUBLE N This field denotes the last content version that was imported for the file.
INFO_TEXT_ID DOUBLE N The identifier of the information-only text associated with the record.
INPATIENT_IND DOUBLE N Denotes if the context of the Data File apply to Inpatient
MNEMONIC VARCHAR(100) N A 100-character string used for identification and selection.
MNEMONIC_KEY VARCHAR(100) N The MNEMONIC in uppercase with the non-alphanumeric characters removed.
MNEMONIC_KEY_A_NLS VARCHAR(400) Y MNEMONIC_KEY_A_NLS column
MNEMONIC_KEY_NLS VARCHAR(202) Y A native sort version of the MNEMONIC_KEY FIELD.
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_FILE


Child Column in EEM_FILE(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CODE_VALUE CODE_VALUE
INFO_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in EEM_FILE (PK) Child Table Name Child Column Name
Children: EEM_FILE_ID EEM_ABN_CHECK EEM_FILE_ID
EEM_ABN_DATA EEM_FILE_ID
EEM_ABN_RULE EEM_FILE_ID
EEM_FILE_ACTION EEM_FILE_ID
EEM_FILE_CHECK EEM_FILE_ID
EEM_FILE_RELTN EEM_FILE_ID
EEM_IMPORT_DATA EEM_FILE_ID