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 |