EI_ELIGIBLE_SERVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Eligible Information - for Medicare Eligible Services
Definition: This table will be used to track a person's medicare eligible preventative services.
Table Type: ACTIVITY





Column Detail - EI_ELIGIBLE_SERVICE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
EI_ELIGIBLE_SERVICE_ID DOUBLE N The Primary Key for the record
ELIGIBLE_DT_TM DATETIME N This field identifies the next time the person is eligible for a given service
ELIGIBLE_SRVC_CD DOUBLE N The CTP code (GCODE) that is returned from Medicare and converted to a CODE VALUE
FREQUENCY_OF_SERVICE_TXT VARCHAR(1000) Y This is a text field that describes how often an eligible service can be ordered for a patient
LAST_TRANSACTION_UPDATE_ID DOUBLE N the FK value from EI_INTERMEDHX_TRANSACTION(EI_INTERMEDHX_TRANSACTION_ID)
PERSON_ID DOUBLE N This is the value of a unique primary identifier of the person 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.



Relationship Detail - EI_ELIGIBLE_SERVICE


Child Column in EI_ELIGIBLE_SERVICE(FK) Parent Table Name Parent Column Name
Parents: LAST_TRANSACTION_UPDATE_ID EI_INTERMEDHX_TRANSACTION EI_INTERMEDHX_TRANSACTION_ID
PERSON_ID PERSON PERSON_ID


EI_INTERMEDHX_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Eligible Information - Medicare Transactions
Definition: This table will retain the associated transactions when retrieving the data from Medicare.
Table Type: ACTIVITY





Column Detail - EI_INTERMEDHX_TRANSACTION


Column Name Type Null? Definition
EI_INTERMEDHX_TRANSACTION_ID DOUBLE N The primary key of the record
ERROR_MESSAGE_DETAIL VARCHAR(1000) Y This is the value actual error message from the call to Medicare
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number
TRANSACTION_DT_TM DATETIME N This is the date time value of when the transaction was saved to the database
TRANSACTION_ERROR_FLAG DOUBLE N Error flag
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 - EI_INTERMEDHX_TRANSACTION


Child Column in EI_INTERMEDHX_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in EI_INTERMEDHX_TRANSACTION (PK) Child Table Name Child Column Name
Children: EI_INTERMEDHX_TRANSACTION_ID EI_ELIGIBLE_SERVICE LAST_TRANSACTION_UPDATE_ID


HM_EXPECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: HM Expect
Definition: This is a listing of all the Health Expectations in the series listed in the HM_EXPECT_SERIES table.
Table Type: REFERENCE





Column Detail - HM_EXPECT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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 N 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.
ALWAYS_COUNT_HIST_IND DOUBLE N Determines whether history is counted for an expectation
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.
EXPECT_ID DOUBLE N This will be the table's primary key. It will be used to uniquely identify an expectation.
EXPECT_MEANING VARCHAR(250) Y This is a meaning field that identifies an expectation. Multiple expectations can have the same meaning due to the same expectation being in multiple series or being identified as an "interval only" expectation. Cerner standard expectations have a meaning that begins with "CERNER" and client defined expectations are prohibited from utilizing that meaning prefix.
EXPECT_NAME VARCHAR(250) Y This is the name for the expectation.
EXPECT_SERIES_ID DOUBLE N ID on the HM_EXPECT_SERIES table that indicates which series this expectation belongs to.
INTERVAL_ONLY_IND DOUBLE N This is an indicator that tells if this expectation is supposed to be evaluated solely for the purpose of determining an interval, not for the purpose of administration.
LAST_ACTION_SEQ DOUBLE N This corresponds to the latest action sequence number on the Expectation History table for this expectation.
MAX_AGE DOUBLE N The maximum age (in days) at which this expectation is recommended.
SEQ_NBR DOUBLE N This is an order of priority among Expectations. If multiple expectations qualify, the sequence numbers will be evaluated by the system to choose the higher priority one.
STEP_COUNT DOUBLE N This is the number of steps in this expectation. If this field has a value of 0, the expectation is an "infinite" recurring expectation.
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 - HM_EXPECT


Child Column in HM_EXPECT(FK) Parent Table Name Parent Column Name
Parents: EXPECT_SERIES_ID HM_EXPECT_SERIES EXPECT_SERIES_ID




Parent Column in HM_EXPECT (PK) Child Table Name Child Column Name
Children: EXPECT_ID HM_EXPECT_FILTER EXPECT_ID
HM_EXPECT_HIST EXPECT_ID
HM_EXPECT_SAT EXPECT_ID
HM_EXPECT_SOURCE EXPECT_ID
HM_EXPECT_STEP EXPECT_ID
HM_RECOMMENDATION EXPECT_ID


HM_EXPECT_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: HM_EXPECT_FILTER
Definition: Health Maintenance Expectation Filter
Table Type: REFERENCE





Column Detail - HM_EXPECT_FILTER


Column Name Type Null? Definition
EXPECT_ID DOUBLE N The identifier of the Expectation to which this filter is associated. FK value from HM_EXPECT table.
FILTER_ENTITY_ID DOUBLE N The identifier of the Filter Entity. This will be the Primary Key on the table identified in the FILTER_ENTITY_NAME.
FILTER_ENTITY_NAME VARCHAR(30) N The Name of the Filter Entity. This will normally be the table from which the filter originated.
HM_EXPECT_FILTER_ID DOUBLE N PRIMARY KEY
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 - HM_EXPECT_FILTER


Child Column in HM_EXPECT_FILTER(FK) Parent Table Name Parent Column Name
Parents: EXPECT_ID HM_EXPECT EXPECT_ID


HM_EXPECT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: This is a history table for the EXPECTATION table.
Definition: This is a history table for the HM_EXPECT table.
Table Type: REFERENCE





Column Detail - HM_EXPECT_HIST


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N This is the date/time the action was performed.
ACTION_SEQ DOUBLE N This is the number of the action that was taken. It will be incremented each time a new action is performed.
ACTION_TYPE_FLAG DOUBLE N This is the action that was performed.
ACTIVE_IND DOUBLE N 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 N 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.
EXPECT_HIST_ID DOUBLE N Logical Primary Key for the table (AK)
EXPECT_ID DOUBLE N ID on the EXPECTATION table that indicates which expectation this record corresponds to.
EXPECT_MEANING VARCHAR(250) Y This is a meaning field that identifies an expectation. Multiple expectations can have the same meaning due to the same expectation being in multiple series or being identified as an "interval only" expectation. Cerner standard expectations have a meaning that begins with "CERNER " and client defined expectations are prohibited from utilizing that meaning prefix.
EXPECT_NAME VARCHAR(250) Y This is the name for the expectation.
EXPECT_SERIES_ID DOUBLE N ID on the HM_EXPECT_SERIES table that indicates which series this expectation belongs to.
EXPECT_STATUS_IND DOUBLE N This Indicates the status of the row on the HM_EXPECT table.
INTERVAL_ONLY_IND DOUBLE N This is an indicator that tells if this expectation is supposed to be evaluated solely for the purpose of determining an interval, not for the purpose of administration.
MAX_AGE DOUBLE N The maximum age (in days) at which this expectation is recommended.
SEQ_NBR DOUBLE N This is an order of priority among Expectations. If multiple expectations qualify, the sequence numbers will be evaluated by the system to choose the higher priority one.
STEP_COUNT DOUBLE N This is the number of steps in this expectation. If this field has a value of 0, the expectation is an "infinite" recurring expectation.
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 - HM_EXPECT_HIST


Child Column in HM_EXPECT_HIST(FK) Parent Table Name Parent Column Name
Parents: EXPECT_ID HM_EXPECT EXPECT_ID