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 |