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 |