Table Detail Report
EEM_ABN_LINK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Enterprise Eligibility Management Advance Beneficiary Notice Link |
Definition: | Denormailization of EEM_ABN_CHECK table for reporting and quick access to price information for signed forms |
Table Type: | ACTIVITY |
Column Detail - EEM_ABN_LINK
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
EEM_ABN_LINK_ID | DOUBLE | N | Unique generated number that identifies a single row on the EEM_ABN_LINK table. |
ENCNTR_ID | DOUBLE | N | ID of the encounter the ABN check is attached to |
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. |
HEALTH_PLAN_ID | DOUBLE | N | The health plan id of the health plan that generated the price |
HIGH_STATUS_CD | DOUBLE | N | The high status code. Examples are form required or form not required. |
HIGH_STATUS_MEANING | VARCHAR(12) | Y | A textual representation of the high status. |
LOCATION_CD | DOUBLE | N | The location that the procedure was checked against. |
MED_STATUS_CD | DOUBLE | N | The medium status code for the abn check. For example, meets medical necessity, does not meet medical necessity, policy not defined, ambiguous, etc. |
MED_STATUS_MEANING | VARCHAR(12) | Y | A text representation of the meaning for med_status_cd. |
ORDER_ID | DOUBLE | N | ID of the order the ABN check is attached to |
ORDER_PRICE | DOUBLE | Y | A text representation of the price of the procedures not covered by Medicare |
PERSON_ID | DOUBLE | N | ID of the person the ABN check is attached to |
PROCEDURE_STRING | VARCHAR(255) | Y | A text representation of the price of the procedures on the check |
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. |
VERSION_DT_TM | DATETIME | N | The version date and time marks the date the record became historical. |
Relationship Detail - EEM_ABN_LINK
Child Column in EEM_ABN_LINK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID | |
LOCATION_CD | LOCATION | LOCATION_CD | |
ORDER_ID | ORDERS | ORDER_ID | |
PERSON_ID | PERSON | PERSON_ID |
EEM_ABN_LOW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM ABN LOW |
Definition: | This table is used to log the low-level status codes for an ABN Check |
Table Type: | ACTIVITY |
Column Detail - EEM_ABN_LOW
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_CHECK_ID | DOUBLE | N | The ABN check associated with the ABN action. A foreign key to the EEM_ABN_CHECK table. Part of the primary key of this table. |
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. |
INDEX_SEQ_NBR | DOUBLE | N | Index Sequence Number. Part of the primary key of this table. |
LOW_SEQ_NBR | DOUBLE | N | The low sequence number. Part of the primary key of this table. |
LOW_STATUS_CD | DOUBLE | N | EEM ABN Low-Level Codes. |
LOW_STATUS_DETAIL_TXT | VARCHAR(255) | N | The detail for the low status. |
LOW_STATUS_MEANING | VARCHAR(12) | Y | The code value CDF meaning for the LOW_STATUS_CD. |
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_ABN_LOW
Child Column in EEM_ABN_LOW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOW_STATUS_CD | CODE_VALUE | CODE_VALUE |
ABN_CHECK_ID | EEM_ABN_CHECK | ABN_CHECK_ID |
EEM_ABN_MOD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table is used to log the modifiers used for an ABN check |
Definition: | EEM ABN Modifiers |
Table Type: | ACTIVITY |
Column Detail - EEM_ABN_MOD
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_CHECK_ID | DOUBLE | N | ABN Check 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. |
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. |
MOD_NOMEN_ID | DOUBLE | N | Modifier Nomenclature Identifier |
MOD_SEQ_NBR | DOUBLE | N | Modifier Sequence Number |
MOD_SOURCE_IDENT | VARCHAR(50) | N | Modifier Source Identifier |
MOD_VOCAB_CD | DOUBLE | N | Modifier Vocabulary Code |
MOD_VOCAB_MEANING | VARCHAR(12) | Y | Modifier Vocabulary 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_ABN_MOD
Child Column in EEM_ABN_MOD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MOD_VOCAB_CD | CODE_VALUE | CODE_VALUE |
ABN_CHECK_ID | EEM_ABN_CHECK | ABN_CHECK_ID | |
MOD_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID |
EEM_ABN_RULE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM ABN RULE |
Definition: | ABN Code Pair Table |
Table Type: | REFERENCE |
Column Detail - EEM_ABN_RULE
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_RULE_ID | DOUBLE | N | The unique primary key of the table. |
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. |
BEG_SEQ | DOUBLE | N | Denotes the first import sequence where the records became active. |
DIAG_BEG_IDENT | VARCHAR(50) | N | The ICD9 are stored using ranges SOURCE_IDENTIFIERs. This corresponds to the SOURCE_IDENTIFIER on the NOMENCLATURE table. |
DIAG_END_IDENT | VARCHAR(50) | N | The ICD9 are stored using ranges SOURCE_IDENTIFIERs. This corresponds to the SOURCE_IDENTIFIER on the NOMENCLATURE table. |
DIAG_VOCABULARY_CD | DOUBLE | N | The external vocabulary or lexicon that contributed the string, e.g. ICD9, SNOMED, etc. |
EEM_FILE_ID | DOUBLE | N | ID of the EEM Content File associated to the rule. |
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. |
END_SEQ | DOUBLE | N | Denotes that last import sequence that contained the record. |
KEY_FIELD | DOUBLE | N | Key Field |
PROC_IDENT | VARCHAR(50) | N | The CPT4 are stored using SOURCE_IDENTIFIERs. This corresponds to the SOURCE_IDENTIFIER on the NOMENCLATURE table. |
PROC_VOCABULARY_CD | DOUBLE | N | The external vocabulary or lexicon that contributed the string, e.g. ICD9, SNOMED, etc. |
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_ABN_RULE
Child Column in EEM_ABN_RULE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIAG_VOCABULARY_CD | CODE_VALUE | CODE_VALUE |
PROC_VOCABULARY_CD | CODE_VALUE | CODE_VALUE | |
EEM_FILE_ID | EEM_FILE | EEM_FILE_ID |
EEM_BENEFIT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM Benefit |
Definition: | EEM Benefits |
Table Type: | REFERENCE |
Column Detail - EEM_BENEFIT
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. |
BENEFIT_TYPE_CD | DOUBLE | N | Benefit Type Code |
COST_PER_BED_DAY | DOUBLE | Y | Cost per bed day |
COST_PER_CASE | DOUBLE | Y | Cost per case |
DATA_TYPE_CD | DOUBLE | N | A unique identifier for the Data Type Code. |
DATE_VALUE | DATETIME | Y | Date Value |
DESCRIPTION | VARCHAR(200) | Y | A long description used for documentation. |
DOUBLE_VALUE | DOUBLE | N | Double Value |
EEM_BENEFIT_ID | DOUBLE | N | EEM Benefit 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. |
INFO_TEXT_ID | DOUBLE | N | Primary Key to LONG_TEXT_REFERENCE table |
LOCAL_RVU | DOUBLE | Y | Local Relative Value Unit stored against HRG |
LONG_TEXT_ID | DOUBLE | N | Primary Key to LONG_TEXT_REFERENCE table |
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. |
NATIONAL_RVU | DOUBLE | Y | National Relative Value Unit stored against HRG |
NBR_PAT_AGREED | DOUBLE | Y | Number of patients agreed |
RVU_AMNT | DOUBLE | Y | Relative Value Unit stored against HRG |
STRING_VALUE | VARCHAR(255) | Y | String Value |
UNITS_CD | DOUBLE | N | Units Of Measure 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. |
VARIANCE_LEVEL | DOUBLE | Y | Variance Level |
Relationship Detail - EEM_BENEFIT
Child Column in EEM_BENEFIT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BENEFIT_TYPE_CD | CODE_VALUE | CODE_VALUE |
DATA_TYPE_CD | CODE_VALUE | CODE_VALUE | |
UNITS_CD | CODE_VALUE | CODE_VALUE | |
INFO_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
Parent Column in EEM_BENEFIT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EEM_BENEFIT_ID | EEM_BENEFIT_ALLOC | EEM_BENEFIT_ID |
EEM_BENEFIT_QUAL | BENEFIT_ID | ||
EEM_BENEFIT_RELTN | EEM_BENEFIT_ID |