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 |