Table Detail Report

HM_EXPECT_MOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table will store expectation series or steps that have been modified.
Definition: This table will be used to store expectation series or steps that have been modified (e.g. postponed, expired, or satisfied) for individual patients.
Table Type: ACTIVITY





Column Detail - HM_EXPECT_MOD


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.
COPY_TO_EXPECT_MOD_ID DOUBLE N The id of the expectation modifier row that this row has been copied to
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_MOD_ID DOUBLE N This will be the table's primary key. It will be used to uniquely identify an expectation satisfier.
EXPECT_SAT_ID DOUBLE N This will be used to uniquely identify an expectation satisfier.
LAST_ACTION_SEQ DOUBLE N This corresponds to the latest action sequence number on the Expectation Modifier History table for this modifier.
LONG_TEXT_ID DOUBLE N This is a link to an entry on the LONG_TEXT table. This will be used to store a comment for the modifier. If this field is 0, a comment was not entered.
MODIFIER_DT_TM DATETIME N If the TYPE_FLAG indicates this modifier is a Satisfy, this date will be the date on which the expectation was satisfied. If the TYPE_FLAG indicates it is a Postpone, this date will be the date to which the expectation is postponed to.
MODIFIER_REASON_CD DOUBLE N A code value from code set 30440 (Expire Reason), 30441 (Postpone Reason), 30442 (Refuse Reason), 30443 (Satisfy Reason) that indicates the reason for the action.
MODIFIER_TYPE_CD DOUBLE N A code value from code set 30281 that indicates the type of action.
ORGANIZATION_ID DOUBLE N Foreign Key from the ORGANIZATION table
PARENT_ENTITY_ID DOUBLE N This is an ID corresponding to the table listed in PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N This will correspond to either the EXPECT_SERIES, EXPECTATION, or EXPECT_STEP table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SAT_PRSNL_ID DOUBLE N This is a "Recorded On Behalf Of" field that allows the user who recorded the modifier to indicate who authorized the modifier.
STATUS_DT_TM DATETIME N This is the date that the action became effective.
STATUS_IND DOUBLE N STATUS INDICATORColumn
STATUS_PRSNL_ID DOUBLE N This is the user who took the action
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_MOD


Child Column in HM_EXPECT_MOD(FK) Parent Table Name Parent Column Name
Parents: COPY_TO_EXPECT_MOD_ID HM_EXPECT_MOD EXPECT_MOD_ID
EXPECT_SAT_ID HM_EXPECT_SAT EXPECT_SAT_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID




Parent Column in HM_EXPECT_MOD (PK) Child Table Name Child Column Name
Children: EXPECT_MOD_ID HM_EXPECT_MOD COPY_TO_EXPECT_MOD_ID
HM_EXPECT_MOD_HIST EXPECT_MOD_ID
HM_RECOMMENDATION_ACTION EXPECT_MOD_ID


HM_EXPECT_MOD_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: This is a history table for the EXPECT_MODIFIER table.
Definition: This is a history table for the HM_EXPECT_MODIFIER table.
Table Type: ACTIVITY





Column Detail - HM_EXPECT_MOD_HIST


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N ACTION DATE/TIMEColumn
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_MOD_ID DOUBLE N ID on the EXPECT_MODIFIER table that indicates which modifier this record corresponds to.
EXPECT_SAT_ID DOUBLE N This will be used to uniquely identify an expectation satisfier.
LONG_TEXT_ID DOUBLE N This is a link to an entry on the LONG_TEXT table. This will be used to store a comment for the modifier. If this field is 0, a comment was not entered.
MIGRATED_FLAG DOUBLE N Indicates whether the data has been analyzed for migration to the HM_RECOMMENDATION_ACTION table.0 = No; 1 = Yes; 2 = Ignored
MODIFIER_DT_TM DATETIME N If the TYPE_FLAG indicates this modifier is a Satisfy, this date will be the date on which the expectation was satisfied. If the TYPE_FLAG indicates it is a Postpone, this date will be the date to which the expectation is postponed to.
MODIFIER_REASON_CD DOUBLE N A code value from code set 30440 (Expire Reason), 30441 (Postpone Reason), 30442 (Refuse Reason), 30443 (Satisfy Reason) that indicates the reason for the action..
MODIFIER_TYPE_CD DOUBLE N A code value from code set 30281 that indicates the type of action.
ORGANIZATION_ID DOUBLE N Foreign key from the ORGANIZATION table.
PARENT_ENTITY_ID DOUBLE N This is an ID corresponding to the table listed in PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N This will correspond to either the EXPECT_SERIES, EXPECTATION, or EXPECT_STEP table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RECOMMENDATION_ACTION_ID DOUBLE N Foreign Key from the HM_RECOMMENDATION_ACTION table
SAT_PRSNL_ID DOUBLE N This is a "Recorded On Behalf Of" field that allows the user who recorded the modifier to indicate who authorized the modifier.
STATUS_DT_TM DATETIME N This is the date that the action became effective.
STATUS_IND DOUBLE N STATUS INDICATORColumn
STATUS_PRSNL_ID DOUBLE N This is the user who took the action
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_MOD_HIST


Child Column in HM_EXPECT_MOD_HIST(FK) Parent Table Name Parent Column Name
Parents: EXPECT_MOD_ID HM_EXPECT_MOD EXPECT_MOD_ID
EXPECT_SAT_ID HM_EXPECT_SAT EXPECT_SAT_ID
RECOMMENDATION_ACTION_ID HM_RECOMMENDATION_ACTION RECOMMENDATION_ACTION_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


HM_EXPECT_SAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This is a listing of all the Health Expectation Series and Step Satisfiers.
Definition: This is a listing of all the Health Expectation Series, Expectation, and Step Satisfiers.
Table Type: REFERENCE





Column Detail - HM_EXPECT_SAT


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.
ENTRY_ID DOUBLE N The ID of the entry type from ENTRY_NAME
ENTRY_NAME VARCHAR(30) N The table name corresponding to the ENTRY_ID source
ENTRY_NBR DOUBLE N OBSOLETE on Feature 144577 and subsequent. The entry ID for the specified entry type. This can be a PowerForm form identifier, a Clinical Note document identifier, an order identifier, or an order set identifier. In some cases, this may be the same as the Satisfier Id.
ENTRY_TYPE_CD DOUBLE N OBSOLETE on Feature 144577 and subsequent. A code value from code set that indicates the method of satisfier entry available from within the Health Maintenance View. Possible conversations are a PowerForm, Clinical Note, Scratch Pad, or EasyScript. Future design will also include PowerNote.
ENTRY_VALUE VARCHAR(255) Y This is a string identifier of the entry type identified by the ENTRY_TYPE_CD.
EXPECT_ID DOUBLE N ID on the EXPECTATION table that indicates which expectation this record corresponds to.
EXPECT_SAT_ID DOUBLE N This will be the table's primary key. It will be used to uniquely identify an expectation satisfier.
EXPECT_SAT_NAME VARCHAR(250) Y This is the name for the expectation satisfier.
LAST_ACTION_SEQ DOUBLE N This corresponds to the latest action sequence number on the Expectation Satisfier History table for this satisfier.
NOMENCLATURE_ID DOUBLE N Diagnosis to associate to this satisfier. Foreign key value from the NOMENCLATURE table
PARENT_ENTITY_ID DOUBLE N The ID of the satisfier type from parent_entity_name. It is 0 if the satisfier is manual or a clinical event.
PARENT_ENTITY_NAME VARCHAR(30) N The table name of the parent_entity_id source
PARENT_NBR DOUBLE N OBSOLETE on Feature 144577 and subsequent. This is the ID of the satisfier type identified by the PARENT_TYPE_FLAG. If the PARENT_TYPE_FLAG is 2 (indicating a manual satisfier), this field will be 0.
PARENT_TYPE_FLAG DOUBLE N OBSOLETE on Feature 144577 and subsequent. This is a flag indicating what type the satisfier is. It can be a clinical event (0), order or order set (1), or it can be a manual satisfier (2).
PARENT_VALUE VARCHAR(255) Y This is a string identifier of the satisfier type identified by the PARENT_TYPE_FLAG.
PENDING_DURATION DOUBLE N This is the duration after the satisfier is placed in which the expectation will be in a pending status. This field is only valid for order satisfiers. If the order permanently satisfies the step, this value will be 0.
SATISFIED_DURATION DOUBLE N This is the duration that a satisfier will satisfy an expectation. This value is only valid for expectations with an infinite number of steps.
SATISFIER_MEANING VARCHAR(250) Y This is a meaning field that identifies a satisfier. Multiple satisfiers can have the same meaning if they belong to different expectations. Cerner standard satisfiers have a meaning that begins with "CERNER" and client defined expectations are prohibited from utilizing that meaning prefix.
SEQ_NBR DOUBLE N This sequence number indicates the order in which the satisfiers should be displayed.
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_SAT


Child Column in HM_EXPECT_SAT(FK) Parent Table Name Parent Column Name
Parents: EXPECT_ID HM_EXPECT EXPECT_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID




Parent Column in HM_EXPECT_SAT (PK) Child Table Name Child Column Name
Children: EXPECT_SAT_ID HM_EXPECT_MOD EXPECT_SAT_ID
HM_EXPECT_MOD_HIST EXPECT_SAT_ID
HM_EXPECT_SAT_HIST EXPECT_SAT_ID
HM_RECOMMENDATION_ACTION EXPECT_SAT_ID


HM_EXPECT_SAT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: HM EXPECT SAT HIST
Definition: This is a history table for the HM_EXPECT_SATISFIER table.
Table Type: REFERENCE





Column Detail - HM_EXPECT_SAT_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.
ENTRY_ID DOUBLE N The ID of the entry type from entry_name
ENTRY_NAME VARCHAR(30) N The table name of the ENTRY_ID source
ENTRY_NBR DOUBLE N OBSOLETE on Feature 144577 and subsequent. The entry ID for the specified entry type. This can be a PowerForm form identifier, a Clinical Note document identifier, an order identifier, or an order set identifier. In some cases, this may be the same as the Satisfier Id.
ENTRY_TYPE_CD DOUBLE N OBSOLETE on Feature 144577 and subsequent. A code value from code set 30280 that indicates the method of satisfier entry available from within the Health Maintenance View. Possible conversations are a PowerForm, Clinical Note, Scratch Pad, or EasyScript. Future design will also include PowerNote.
ENTRY_VALUE VARCHAR(255) Y This is a string identifier of the entry type identified by the ENTRY_TYPE_CD.
EXPECT_ID DOUBLE N ID on the EXPECTATION table that indicates which expectation this step belongs to.
EXPECT_SAT_HIST_ID DOUBLE N Logical Primary Key for this table (AK)
EXPECT_SAT_ID DOUBLE N ID on the EXPECT_SATISFIER table that indicates which satisfier this record corresponds to.
EXPECT_SAT_NAME VARCHAR(250) Y This is the name for the expectation satisfier.
NOMENCLATURE_ID DOUBLE N Diagnosis to associate to this satisfier. Foreign Key from the Nomenclature table
PARENT_ENTITY_ID DOUBLE N The ID of the satisfier type from parent_entity_name. It is 0 if the satisfier is manual or a clinical event.
PARENT_ENTITY_NAME VARCHAR(30) N The table name of the PARENT_ENTITY_ID source
PARENT_NBR DOUBLE N OBSOLETE on Feature 144577 and subsequent. This is the ID of the satisfier type identified by the PARENT_TYPE_FLAG. If the PARENT_TYPE_FLAG is 2 (indicating a manual satisfier), this field will be 0.
PARENT_TYPE_FLAG DOUBLE N OBSOLETE on Feature 144577 and subsequent. This is a flag indicating what type the satisfier is. It can be a clinical event (0), order or order set (1), or it can be a manual satisfier (2).
PARENT_VALUE VARCHAR(255) Y This is a string identifier of the satisfier type identified by the PARENT_TYPE_FLAG.
PENDING_DURATION DOUBLE N This is the duration after the satisfier is placed in which the expectation will be in a pending status. This field is only valid for order satisfiers. If the order permanently satisfies the step, this value will be 0.
SATISFIED_DURATION DOUBLE N This is the duration that a satisfier will satisfy an expectation. This value is only valid for expectations with an infinite number of steps.
SATISFIER_MEANING VARCHAR(250) Y This is a meaning field that identifies a satisfier. Multiple satisfiers can have the same meaning if they belong to different expectations. Cerner standard satisfiers have a meaning that begins with "CERNER" and client defined expectations are prohibited from utilizing that meaning prefix.
SAT_STATUS_IND DOUBLE N Sat Status IndicatorColumn
SEQ_NBR DOUBLE N This sequence number indicates the order in which the satisfiers should be displayed.
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_SAT_HIST


Child Column in HM_EXPECT_SAT_HIST(FK) Parent Table Name Parent Column Name
Parents: EXPECT_SAT_ID HM_EXPECT_SAT EXPECT_SAT_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


HM_EXPECT_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: HM EXPECT SCHED
Definition: This is a listing of the HM_Health Expectation schedules.
Table Type: REFERENCE





Column Detail - HM_EXPECT_SCHED


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 This will be the table's primary key. It will be used to uniquely identify a schedule.
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).
LAST_ACTION_SEQ DOUBLE N This corresponds to the latest action sequence number on the Expectation Schedule History table for this schedule.
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)
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




Parent Column in HM_EXPECT_SCHED (PK) Child Table Name Child Column Name
Children: EXPECT_SCHED_ID HM_EXPECT_SCHED_HIST EXPECT_SCHED_ID
HM_EXPECT_SERIES EXPECT_SCHED_ID