Table Detail Report
HM_EXPECT_SCHED_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HM EXPECT SCHED HIST |
Definition: | This is a history table for the HM_EXPECT_SCHED table. |
Table Type: | REFERENCE |
Column Detail - HM_EXPECT_SCHED_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_SCHED_HIST_ID | DOUBLE | N | THE Logical PRIMARY KEY for this table (defined as an AK) |
EXPECT_SCHED_ID | DOUBLE | N | ID on the EXPECT_SCHED table that indicates which schedule this series belongs to. |
EXPECT_SCHED_LOC_CD | DOUBLE | N | This is the facility code at which the schedule is valid. If the SCHED_LEVEL_FLAG indicates that the schedule is either a base schedule or a person-level schedule, this field is ignored. |
EXPECT_SCHED_MEANING | VARCHAR(250) | Y | This is a meaning field that is unique to the schedule. Cerner standard schedules have a meaning that begins with "CERNER" and client defined schedules are prohibited from utilizing that prefix meaning. |
EXPECT_SCHED_NAME | VARCHAR(250) | Y | This is the name of the health expectation schedule. Some examples are the ACIP and AAP immunization schedules, healthy 18 - 45 year old males, etc. This field will be used when displaying the name of the schedule. |
EXPECT_SCHED_TYPE_FLAG | DOUBLE | N | This is the type of schedule (Health Expectation = 0, Childhood Immunization = 1, Adult Immunization = 2). |
ON_TIME_START_AGE | DOUBLE | N | This field will be used to indicate the age at which the first step in this series must be completed to indicate that the schedule has started on time. |
SCHED_LEVEL_FLAG | DOUBLE | N | This flag indicates what level this schedule is at (0 = Base Schedule, 1 = Location Schedule, 2 = Person-Level Schedule) |
SCHED_STATUS_IND | DOUBLE | N | This indicates the status of the row on the HM_EXPECT_SCHED table. |
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_SCHED_HIST
Child Column in HM_EXPECT_SCHED_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXPECT_SCHED_ID | HM_EXPECT_SCHED | EXPECT_SCHED_ID |
HM_EXPECT_SERIES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HM EXPECT SERIES |
Definition: | This is a listing of all the Health Expectation series in the schedules. |
Table Type: | REFERENCE |
Column Detail - HM_EXPECT_SERIES
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. |
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_SCHED_ID | DOUBLE | N | ID on the HM_EXPECT_SCHED table that indicates which schedule this series belongs to. |
EXPECT_SERIES_ID | DOUBLE | N | This will be the table's primary key. It will be used to uniquely identify a series. |
EXPECT_SERIES_NAME | VARCHAR(250) | Y | This is the name for the series. |
FIRST_STEP_AGE | DOUBLE | N | This is the age (in days) of the patient when the first step of any series in the schedule is to be administered. |
LAST_ACTION_SEQ | DOUBLE | N | This corresponds to the latest action sequence number on the Expectation Series History table for this schedule. |
PRIORITY_MEANING | VARCHAR(12) | Y | A CDF Meaning from code set 30283 that indicates the priority of the series. |
RULE_ASSOCIATED_IND | DOUBLE | N | This field is used to indicate whether a rule is associated with this series. If this value is 1, this series only applies if it is returned by discern as qualified, if it is 0, it is always qualified. |
SERIES_MEANING | VARCHAR(250) | Y | This is a meaning field that uniquely identifies a series. Multiple series can have the same meaning, but that is only for the purpose of associating the same series with multiple schedules. Cerner standard series have a meaning that begins with "CERNER" and client defined series are prohibited from utilizing that meaning prefix. |
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_SERIES
Child Column in HM_EXPECT_SERIES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXPECT_SCHED_ID | HM_EXPECT_SCHED | EXPECT_SCHED_ID |
Parent Column in HM_EXPECT_SERIES (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EXPECT_SERIES_ID | HM_EXPECT | EXPECT_SERIES_ID |
HM_EXPECT_SERIES_HIST | EXPECT_SERIES_ID |
HM_EXPECT_SERIES_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This is a history table for the EXPECT_SERIES table. |
Definition: | This is a history table for the HM_EXPECT_SERIES table. |
Table Type: | REFERENCE |
Column Detail - HM_EXPECT_SERIES_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_SCHED_ID | DOUBLE | N | ID on the HM_EXPECT_SCHED that indicates which schedule this series belongs to. |
EXPECT_SERIES_HIST_ID | DOUBLE | N | Logical Primary Key for this table (AK) |
EXPECT_SERIES_ID | DOUBLE | N | ID on the EXPECT_SERIES table that indicates which series this record corresponds to. |
EXPECT_SERIES_NAME | VARCHAR(250) | Y | This is the name for the series. |
FIRST_STEP_AGE | DOUBLE | N | This is the age (in days) of the patient when the first step of this series is to be administered. |
PRIORITY_MEANING | VARCHAR(12) | Y | A CDF Meaning from code set 30283 that indicates the priority of the series. |
RULE_ASSOCIATED_IND | DOUBLE | N | This field is used to indicate whether a rule is associated with this series. If this value is 1, this series only applies if it is returned by discern as qualified, if it is 0, it is always qualified. |
SERIES_MEANING | VARCHAR(250) | Y | This is a meaning field that uniquely identifies a series. Multiple series can have the same meaning, but that is only for the purpose of associating the same series with multiple schedules. Cerner standard series have a meaning that begins with "CERNER" and client defined series are prohibited from utilizing that meaning prefix. |
SERIES_STATUS_IND | DOUBLE | N | This indicates the status of the row on the HM_EXPECT_SERIES table. |
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_SERIES_HIST
Child Column in HM_EXPECT_SERIES_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXPECT_SERIES_ID | HM_EXPECT_SERIES | EXPECT_SERIES_ID |
HM_EXPECT_SOURCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Health Maintenance Expectation Source |
Definition: | Stores the identifing information of the source of evaluation for an expectation |
Table Type: | REFERENCE |
Column Detail - HM_EXPECT_SOURCE
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. |
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. |
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. |
EXPECT_ID | DOUBLE | N | Identifier of the Expectation to which this source identifier belongs |
HM_EXPECT_SOURCE_ID | DOUBLE | N | PRIMARY KEY |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
SOURCE_DOUBLE_IDENT | DOUBLE | N | The Identifier of the source of evaluation for the expectation. This is a double value |
SOURCE_TEXT_IDENT | VARCHAR(2000) | N | The character Identifier of the source of evaluation for the expectation. |
SOURCE_TYPE_FLAG | DOUBLE | N | The type of the source. This type could indicate that the source of evaluation is Immunization Based, or Cloud based, etc.1 = Travel Immunization2 = HealtheRegistry Measure3 = Preventative Service3 |
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 - HM_EXPECT_SOURCE
Child Column in HM_EXPECT_SOURCE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXPECT_ID | HM_EXPECT | EXPECT_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
HM_EXPECT_STEP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This is a listing of all the Health Expectation Steps. |
Definition: | This is a listing of all the Health Expectation Steps in the expectation listed in the HM_EXPECT table. |
Table Type: | REFERENCE |
Column Detail - HM_EXPECT_STEP
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. |
AUDIENCE_FLAG | DOUBLE | N | This is a flag indicating who the intended audience is. The valid values are Everyone (0), Nurses (1), or Physicians (2). This field will not be used to enforce security, instead, it will be used as a display filter. For example, a physician can choose to show all expectation steps (0, 1, and 2) or just Physician steps (0 and 2). Physicians and Nurses = 3. |
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. |
DUE_DURATION | DOUBLE | N | This field indicates the amount of time (in days) that the step will be due. After that interval of time passes, the step is considered over due. |
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_TIME_OF_YEAR | DOUBLE | N | A step can have a period of the year for which it is valid. This is the end of that time. |
EXPECT_ID | DOUBLE | N | ID on the HM_EXPECT table that indicates which expectation this step belongs to.. |
EXPECT_STEP_ID | DOUBLE | N | This will be the table's primary key. It will be used to uniquely identify an expectation step. |
EXPECT_STEP_NAME | VARCHAR(250) | Y | This is the name for the expectation step. |
LAST_ACTION_SEQ | DOUBLE | N | This corresponds to the latest action sequence number on the Expectation Step History table for this expectation. |
MAX_INTERVAL_TO_COUNT | DOUBLE | N | This field specifies a maximum interval, past which, the next step does not count toward the entire series. |
MIN_AGE | DOUBLE | N | The minimum age (in days) at which this expectation step can be satisfied. |
MIN_INTERVAL_TO_ADMIN | DOUBLE | N | The interval (in days) between when this expectation step was satisfied and when the next expectation step can be safely administered. |
MIN_INTERVAL_TO_COUNT | DOUBLE | N | The interval (in days) between when this expectation step was satisfied and when the next expectation step can count. |
NEAR_DUE_DURATION | DOUBLE | N | This field indicates the amount of time (in days) that the step will be near due. After that interval of time hs passed the step is considered due. |
RECOMMENDED_INTERVAL | DOUBLE | N | The interval (in days) between when this expectation step was satisfied and when the next expectation step should be recommended. |
SKIP_AGE | DOUBLE | N | The age (in days) at which this dose should be skipped. If 0, this dose should never be skipped. |
START_TIME_OF_YEAR | DOUBLE | N | A step can have a period of the year for which it is valid. This is the start of that time. |
STEP_MEANING | VARCHAR(250) | Y | This is a meaning field that identifies a step. Multiple steps can have the same meaning due to the same step being in multiple expectations. Cerner standard steps have a meaning that begins with "CERNER" and client defined expectations are prohibited from utilizing that meaning prefix. |
STEP_NBR | DOUBLE | N | This is the index of the step with relation to other steps in the 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. |
VALID_RECOMMEND_END_AGE | DOUBLE | N | A step can have an age range for which it is recommended. This field represents the end of that interval. |
VALID_RECOMMEND_START_AGE | DOUBLE | N | A step can have an age range for which it is recommended. This field represents the start of that interval. |
Relationship Detail - HM_EXPECT_STEP
Child Column in HM_EXPECT_STEP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXPECT_ID | HM_EXPECT | EXPECT_ID |
Parent Column in HM_EXPECT_STEP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EXPECT_STEP_ID | HM_EXPECT_STEP_HIST | EXPECT_STEP_ID |
HM_RECOMMENDATION | STEP_ID |