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