PP_AUDIT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PowerPlan Audit Event
Definition: This table is used to log auditing event information for specific system events encountered through regular PowerPlans solution workflow.
Table Type: ACTIVITY





Column Detail - PP_AUDIT_EVENT


Column Name Type Null? Definition
APP_NBR DOUBLE N Application number that was used to trigger the event being audited
ENCNTR_ID DOUBLE N Unique identifier of the encounter affected by the event being audited
EVENT_DT_TM DATETIME N Date & time of the event occurrence
EVENT_ENTITY_ID DOUBLE N Unique identifier for the entity affected by the event being audited
EVENT_ENTITY_NAME VARCHAR(30) N Name of the database table used to store the entity affected by the event being audited
EVENT_ENUM DOUBLE N This is a logical flag. An asynchronous call to populate the table from the solution will also have an enumeration defined in the front end C++ code for the values in this field
EVENT_MESSAGE VARCHAR(255) N Free-text message used to provide additional context for the event.
EVENT_NAME VARCHAR(12) N Event name identifier, used to mark recurring events.
EVENT_TYPE VARCHAR(12) N Event type identifier. This field can be used to sort/group events together.
PERSON_ID DOUBLE N Unique identifier of the patient affected by the event being audited
PP_AUDIT_EVENT_ID DOUBLE N Unique Identifier. 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.
USER_ID DOUBLE N Unique identifier for the user who triggered the event being audited



Relationship Detail - PP_AUDIT_EVENT


Child Column in PP_AUDIT_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
USER_ID PRSNL PERSON_ID


PP_ERROR_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Plans Error Log
Definition: This table contains information regarding the failure of a power plan to sign.
Table Type: ACTIVITY





Column Detail - PP_ERROR_LOG


Column Name Type Null? Definition
ERROR_TYPE_FLAG DOUBLE N The type of failure that has occurred
LONG_TEXT_ID DOUBLE N The id of the long blob containing the error message
PATHWAY_ID DOUBLE N The phase for which the error occurred during processing
PP_ERROR_LOG_ID DOUBLE N Unique generated number that identifies a single row on the pp_error_log table.
PW_GROUP_NBR DOUBLE N The id of the power plan
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 - PP_ERROR_LOG


Child Column in PP_ERROR_LOG(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID