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