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