DM_ENTITY_ACTIVITY



Column Section Top of Page


Table-level Detail

Description: Holds information on activity in the database for "flagged" tables.
Definition: Activity data for various tables that need to be monitored. E.g. it will tell when a person, address, encounter row has been modified so that that data can be updated when a palm device is sync-ed with the database.
Table Type: ACTIVITY





Column Detail - DM_ENTITY_ACTIVITY


Column Name Type Null? Definition
ENTITY_ACTIVITY_ID DOUBLE N Unique, sequence generated id.
ENTITY_ACTIVITY_TYPE_CD DOUBLE N Activity type - such as last update. Helps programs monitoring this table know if this is an activity they are interested in.
PARENT_ENTITY_ID DOUBLE N Identifier from the parent_entity_name tables such as a person_id, encounter_id, address_id, etc.
PARENT_ENTITY_NAME VARCHAR(30) N Table which contains the parent_entity_id table in it's 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.


DM_ENTITY_ACTIVITY_TRIGGER



Column Section Top of Page


Table-level Detail

Description: List of trigger information which populate the dm_entity_activity table.
Definition: Holds information used to build the triggers (TRGDM__EA) that will populate the dm_entity_activity table.
Table Type: REFERENCE





Column Detail - DM_ENTITY_ACTIVITY_TRIGGER


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.
COLUMN_NAME VARCHAR(30) N Name of the column (usually the primary key) which is in the table in 'parent_name' used to determine if a row in dm_entity_activity should be inserted or updated. E.g. a trigger needing to be built on the Person table would have this column be 'person_id' and parent_name = 'person.
ENTITY_ACTIVITY_TYPE_CD DOUBLE N Activity type - such as last update. Helps programs monitoring the dm_entity_activity table know if this is an activity they are interested in.
PARENT_NAME VARCHAR(30) N Name of the table to be checked against the "pe_col_name" to see if the trigger should be fired. E.g. if "pe_col_name" = parent_entity_name and this is 'PERSON' then the trigger will have when clause of "When parent_entity_name = 'PERSON'". This is useful when monitoring tables like Address but you don't want to track all changes such as those to health plans.
PE_COL_NAME VARCHAR(30) Y If the table in "parent_name" has parent entity columns (like the Address table does) then this is filled out with the parent entity name column. E.g. for the Address and many other tables this is "parent_entity_name".
TABLE_NAME VARCHAR(30) N Name of the table which the trigger should be created on.
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.