Table Detail Report
EEM_ABN_CHECK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM ABN Check |
Definition: | This table is used to log all ABN checks performed. |
Table Type: | ACTIVITY |
Column Detail - EEM_ABN_CHECK
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_CHECK_ID | DOUBLE | N | The unique primary key of this table. |
ABN_STATE_CD | DOUBLE | N | The state of the ABN. For example: Checked, Signed, Printed, Not Signed, etc. |
ABN_STATE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the ABN State Code. |
ABN_TRACKING_ID | DOUBLE | N | The ID associated to the row in this table that is the tracking identifier for this ABN check. |
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. |
BIRTH_DT_TM | DATETIME | Y | The date of birth. |
BIRTH_TZ | DOUBLE | Y | Time zone associated with the corresponding BIRTH_DT_TM column. |
CHECK_SEQ | DOUBLE | N | The sequence of the check. |
DIAG_NOMEN_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. |
DIAG_SOURCE_IDENT | VARCHAR(50) | N | The identifier of the diagnosis source. |
DIAG_VOCAB_CD | DOUBLE | N | The code value for the source vocabulary for the diagnosis. |
DIAG_VOCAB_MEANING | VARCHAR(12) | Y | A text representation of the meaning for DIAG_VOCAB_CD. |
DUP_CHECK_IND | DOUBLE | N | Indicates if there is duplicate checking. |
DUP_KEY | VARCHAR(255) | Y | Duplicate Key column |
EDI_TRANSACTION_IDENT | VARCHAR(50) | Y | Unique identifier provided by transaction services to uniquely identify a call to transaction services for medical necessity check. |
EEM_FILE_ID | DOUBLE | N | The ID of the row in EEM_FILE related to this ABN check. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
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. |
EST_SERVICE_IND | DOUBLE | N | An indicator for estimated service. |
FINANCIAL_CLASS_CD | DOUBLE | N | The financial classification used for a given encounter. Examples may include Worker's Comp, Self Pay, etc. |
GENDER_CD | DOUBLE | N | Specifies the gender. |
GENDER_MEANING | VARCHAR(12) | Y | A textual representation of the gender. |
HEALTH_PLAN_ID | DOUBLE | N | This is the value of the unique primary identifier of the health plan table. It is an internal system assigned number. |
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. |
INPATIENT_IND | DOUBLE | N | Indicates if the check is for an inpatient or not. |
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. |
PARENT1_ID | DOUBLE | N | Id of table 1 the ABN check is associated to. |
PARENT1_TABLE | VARCHAR(30) | Y | The name of the parent 1 table the ABN check is associated to. |
PARENT2_ID | DOUBLE | N | The Id of the parent 2 table the ABN check is associated to. |
PARENT2_TABLE | VARCHAR(30) | Y | The name of the parent 2 table the ABN check is associated to. |
PARENT3_ID | DOUBLE | N | The Id of the parent 3 table the ABN check is associated to. |
PARENT3_TABLE | VARCHAR(30) | Y | The name of the parent 3 table the ABN check is associated to. |
PARENT_MNEMONIC | VARCHAR(100) | Y | A mnemonic for the parent the ABN check is associated to. |
PAYER_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PROC_DISPLAY_ID | DOUBLE | N | Identifier where the procedure display is linked to (appt_synonym_cd/synonym_id) |
PROC_DISPLAY_TABLE | VARCHAR(30) | Y | Identifies the table where the procedure display is linked to (CODE_VALUE/ORDER_CATALOG_SYNONYM) |
PROC_GROUP_DISPLAY_ID | DOUBLE | N | The Id of the procedure group display associated to the ABN check. |
PROC_GROUP_DISPLAY_TABLE | VARCHAR(30) | Y | The table name associated with the procedure group display. E.G. CODE_VALUE, etc. |
PROC_GROUP_PARENT_ID | DOUBLE | N | The Id of the procedure group parent. |
PROC_GROUP_PARENT_TABLE | VARCHAR(30) | Y | The table name of the procedure group parent. |
PROC_NOMEN_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. |
PROC_PARENT_ID | DOUBLE | N | Identifier where then procedures are linked to (appt_type_cd/catalog_cd) |
PROC_PARENT_TABLE | VARCHAR(30) | Y | Identifies the table where the procedures are linked to (i.e. CODE_VALUE) |
PROC_SOURCE_IDENT | VARCHAR(50) | N | The identifier of the procedure source. |
PROC_VOCAB_CD | DOUBLE | N | The source vocabulary for the procedure. |
PROC_VOCAB_MEANING | VARCHAR(12) | Y | The textual representation of the PROC_VOCAB_CD. |
SERVICE_DT_TM | DATETIME | Y | The service date and time for the ABN check. |
SPONSOR_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. |
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. |
USE_SERVICE_IND | DOUBLE | N | Use Service Date and Time Indicator |
Relationship Detail - EEM_ABN_CHECK
Child Column in EEM_ABN_CHECK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ABN_STATE_CD | CODE_VALUE | CODE_VALUE |
GENDER_CD | CODE_VALUE | CODE_VALUE | |
HIGH_STATUS_CD | CODE_VALUE | CODE_VALUE | |
MED_STATUS_CD | CODE_VALUE | CODE_VALUE | |
PROC_VOCAB_CD | CODE_VALUE | CODE_VALUE | |
ABN_TRACKING_ID | EEM_ABN_CHECK | ABN_CHECK_ID | |
EEM_FILE_ID | EEM_FILE | EEM_FILE_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID | |
LOCATION_CD | LOCATION | LOCATION_CD | |
DIAG_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PROC_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PAYER_ID | ORGANIZATION | ORGANIZATION_ID | |
SPONSOR_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in EEM_ABN_CHECK (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ABN_CHECK_ID | EEM_ABN_ACTION | ABN_CHECK_ID |
EEM_ABN_CHECK | ABN_TRACKING_ID | ||
EEM_ABN_DIAG | ABN_CHECK_ID | ||
EEM_ABN_INDEX | ABN_CHECK_ID | ||
EEM_ABN_LOW | ABN_CHECK_ID | ||
EEM_ABN_MOD | ABN_CHECK_ID |
EEM_ABN_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Hold additional attributes for an ABN code pair |
Definition: | EEM ABN Data |
Table Type: | REFERENCE |
Column Detail - EEM_ABN_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_ATTR_ID | DOUBLE | N | ABN Attribute 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. |
ATTR_TYPE_CD | DOUBLE | N | Attribute Type Code |
ATTR_TYPE_MEANING | VARCHAR(12) | Y | Attribute Type Meaning |
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_IDENTIFIER | VARCHAR(50) | Y | This field contains the begin SOURCE_IDENTIFIER for a range of NOMENCLATURE values. |
BEG_SEQ | DOUBLE | N | Denote the first import sequence to contain the record |
COMP_TYPE_CD | DOUBLE | N | Comparison Type Code |
COMP_TYPE_MEANING | VARCHAR(12) | Y | Comparison Type Meaning |
DATA_TYPE_CD | DOUBLE | N | A unique identifier for the Data Type Code. |
DATA_TYPE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the Data Type. |
DATE_VALUE | DATETIME | Y | Date/Time Value |
DOUBLE_VALUE | DOUBLE | Y | Double Value (any numerical value) |
EEM_FILE_ID | DOUBLE | N | EEM Content File Identifier value |
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_IDENTIFIER | VARCHAR(50) | Y | This field contains the ;last SOURCE_IDENTIFIER for a range of NOMENCLATURE values. |
END_SEQ | DOUBLE | N | Denote the last content file to contain the record. |
KEY_FIELD | DOUBLE | N | This field provides a link between the code pair in EEM_ABN_RULE and the additional attributes stored in EEM_ABN_DATA. |
LONG_TEXT_ID | DOUBLE | N | Id of long text row containing note |
PARENT_ID | DOUBLE | N | Parent Identifier |
PARENT_MEANING | VARCHAR(12) | Y | Parent Meaning |
PARENT_TABLE | VARCHAR(30) | Y | Parent Table |
SEQ_NBR | DOUBLE | N | Determines the order among the children of a group. |
STRING_VALUE | VARCHAR(255) | Y | String Value |
UNITS_CD | DOUBLE | N | Denotes the Units of Measure |
UNITS_MEANING | VARCHAR(12) | Y | Denotes the Units of Measure |
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. |
VOCABULARY_CD | DOUBLE | N | Nomenclature Vocabulary Code |
VOCABULARY_MEANING | VARCHAR(12) | Y | Nomenclature Vocabulary Meaning |
Relationship Detail - EEM_ABN_DATA
Child Column in EEM_ABN_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ATTR_TYPE_CD | CODE_VALUE | CODE_VALUE |
COMP_TYPE_CD | CODE_VALUE | CODE_VALUE | |
DATA_TYPE_CD | CODE_VALUE | CODE_VALUE | |
UNITS_CD | CODE_VALUE | CODE_VALUE | |
VOCABULARY_CD | CODE_VALUE | CODE_VALUE | |
EEM_FILE_ID | EEM_FILE | EEM_FILE_ID | |
LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
EEM_ABN_DIAG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table is used to log the secondary diagnosis used for an ABN check. |
Definition: | EEM ABN Diagnosis |
Table Type: | ACTIVITY |
Column Detail - EEM_ABN_DIAG
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. |
DIAG_NOMEN_ID | DOUBLE | N | Diagnosis Nomenclature Identifier |
DIAG_SEQ_NBR | DOUBLE | N | Diagnosis Sequence Number |
DIAG_SOURCE_IDENT | VARCHAR(50) | N | Diagnosis Source Identifier |
DIAG_VOCAB_CD | DOUBLE | N | Diagnosis Vocabulary Code |
DIAG_VOCAB_MEANING | VARCHAR(12) | Y | Diagnosis Vocabulary Meaning |
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. |
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_DIAG
Child Column in EEM_ABN_DIAG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIAG_VOCAB_CD | CODE_VALUE | CODE_VALUE |
ABN_CHECK_ID | EEM_ABN_CHECK | ABN_CHECK_ID | |
DIAG_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID |
EEM_ABN_FORM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table is used to denote any ABN form that was printed |
Definition: | EEM ABN Form |
Table Type: | ACTIVITY |
Column Detail - EEM_ABN_FORM
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_FORM_ID | DOUBLE | N | ABN Form 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_REPORT_ID | DOUBLE | N | EEM Report 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. |
FILE_NAME | VARCHAR(255) | Y | File Name |
NBR_COPIES | DOUBLE | N | Requested Number of Copies |
OFFLINE_FORM_IND | DOUBLE | N | Offline Form Indicator |
OUTPUT_DEST_ID | DOUBLE | N | Output Destination Identifier |
SUFFIX | VARCHAR(50) | Y | Suffix |
TO_PRSNL_ID | DOUBLE | N | Personnel Identifier |
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_ABN_FORM
Child Column in EEM_ABN_FORM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ABN_FORM_ID | EEM_ABN_ACTION | ABN_ACTION_ID |
OUTPUT_DEST_ID | OUTPUT_DEST | OUTPUT_DEST_CD | |
TO_PRSNL_ID | PRSNL | PERSON_ID | |
EEM_REPORT_ID | SCH_REPORT | SCH_REPORT_ID |
Parent Column in EEM_ABN_FORM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ABN_FORM_ID | EEM_ABN_ACTION | ABN_FORM_ID |
EEM_ABN_INDEX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM_ABN_INDEX |
Definition: | This table is used to log the LMRP responses to an ABN check |
Table Type: | ACTIVITY |
Column Detail - EEM_ABN_INDEX
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_CHECK_ID | DOUBLE | N | ABN Check Identifier. A FK back tot he 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. |
HIGH_STATUS_CD | DOUBLE | N | High Status Code |
HIGH_STATUS_MEANING | VARCHAR(12) | Y | High Status Meaning |
INDEX_SEQ_NBR | DOUBLE | N | A sequence number. Part of the primary key of this table. |
KEY_FIELD | DOUBLE | N | Key Field |
MED_STATUS_CD | DOUBLE | N | Medium Status Code |
MED_STATUS_MEANING | VARCHAR(12) | Y | Medium Status 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_INDEX
Child Column in EEM_ABN_INDEX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HIGH_STATUS_CD | CODE_VALUE | CODE_VALUE |
MED_STATUS_CD | CODE_VALUE | CODE_VALUE | |
ABN_CHECK_ID | EEM_ABN_CHECK | ABN_CHECK_ID |