Table Detail Report

PERSON_PRSNL_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table records info about prsnl viewing results or similar activities.
Definition: This table records info about prsnl viewing results or similar activities. Both PowerChart and ProVide track activity between users and patients.
Table Type: ACTIVITY





Column Detail - PERSON_PRSNL_ACTIVITY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
COMPUTER_NAME VARCHAR(100) Y This is an optional field that could be filled out when doing chart access or view access logging to track which computer was being used at the time.
COMP_CAPTION VARCHAR(100) Y This is an optional field that could be filled out to track component access via PowerChart/ProVide. It is not used at this time.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PPA_CNT DOUBLE Y Contains the number of times this row has been updated.
PPA_COMMENT VARCHAR(256) Y This is an option field that could be used with logging to store additional information about why the access had taken place.
PPA_FIRST_DT_TM DATETIME N Contains the date and time that this row was originally stamped with.
PPA_FIRST_TZ DOUBLE Y Contains the time zone that this row was originally stamped with.
PPA_ID DOUBLE N The unique identifier of a row on this table.
PPA_LAST_DT_TM DATETIME Y The last time that this row got 'stamped' for activity.
PPA_LAST_TZ DOUBLE Y Contains the time zone for the last time that this row got "stamped" for activity.
PPA_TYPE_CD DOUBLE N The code value representing the person prsnl activity type, i.e. RESULTS REVIEW
PPR_CD DOUBLE Y This is an optional field that will be filled out for chart access and view access logging with the ppr_cd that was active at the time of the access.
PRSNL_ID DOUBLE N Contains the person_id for the user or provider that the row is written for.
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.
VIEW_CAPTION VARCHAR(100) Y This is an optional field that will be used with view access logging to contain the caption of the view that was accessed.



Relationship Detail - PERSON_PRSNL_ACTIVITY


Child Column in PERSON_PRSNL_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


PREDEFINED_PREFS



Column Section Top of Page


Table-level Detail

Description: This table contains predefined preference views for the Powe
Definition: This table contains predefined preference views for the PowerChart application. It is structured so that any application can use it.
Table Type: REFERENCE





Column Detail - PREDEFINED_PREFS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
NAME VARCHAR(32) Y The name or description of the predefined view.
PREDEFINED_PREFS_ID DOUBLE N The unique identifier of a row on this table.
PREDEFINED_TYPE_MEANING VARCHAR(12) Y The meaning of the type of predefined view that the row represents, i.e. DEMOGS, VISITDEMOGS.
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.


PRIVILEGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PRIVILEGE
Definition: This table contains a privilege that is being tied to a user, position or ppr.
Table Type: REFERENCE





Column Detail - PRIVILEGE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
LOG_GROUPING_CD DOUBLE N The privileges tool needs a way to associate exception groups to a privilege. Exception groups are currently stored on the logical_grouping and log_group_entry table. In order to keep track of this 1 to 1 relationship, we need to add the primary key of the logical_grouping table as a foreign key of the privilege table.
PRIVILEGE_CD DOUBLE N The code value representing the privilege.
PRIVILEGE_ID DOUBLE N The unique identifier of a row on this table.
PRIV_LOC_RELTN_ID DOUBLE N The row on the privilege location relationship table that this privilege is tied to.
PRIV_VALUE_CD DOUBLE N The code value representing the granted access to this privilege, i.e. YES, NO, INCLUDE, EXCLUDE
RESTR_METHOD_CD DOUBLE N The code value representing the restriction method for this privilege, i.e. MASK or HIDE.
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 - PRIVILEGE


Child Column in PRIVILEGE(FK) Parent Table Name Parent Column Name
Parents: LOG_GROUPING_CD LOGICAL_GROUPING LOG_GROUPING_CD
PRIV_LOC_RELTN_ID PRIV_LOC_RELTN PRIV_LOC_RELTN_ID




Parent Column in PRIVILEGE (PK) Child Table Name Child Column Name
Children: PRIVILEGE_ID ACTIVITY_PRIVILEGE_RELTN PRIVILEGE_ID
PRIVILEGE_DELETION PRIVILEGE_ID
PRIVILEGE_EXCEPTION PRIVILEGE_ID
PRIV_GROUP_RELTN PRIVILEGE_ID


PRIVILEGE_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Privilege Definition
Definition: This table defines the template for each definition.
Table Type: REFERENCE





Column Detail - PRIVILEGE_DEF


Column Name Type Null? Definition
DEFAULT_GRANTED_IND DOUBLE N Indicates whether the default value is granted for this privilege if no activity privilege or legacy privilege values are set.
EXCLUDE_IND DOUBLE N Indicates whether this privilege can be set to "yes, except for" (exclude).
INCLUDE_IND DOUBLE N Indicates whether this privilege can be set to "no, except for" (include).
LOCATION_PERSON_IND DOUBLE N Indicates whether this privilege can be set for a person at a specific location.
LOCATION_POSITION_IND DOUBLE N Indicates whether this privilege can be set for a position at a specific location.
LOCATION_PPR_IND DOUBLE N Indicates whether this privilege can be set for a person patient relationship at a specific location.
NO_IND DOUBLE N Indicates whether this privilege can be set to"no" (denied).
PERSON_IND DOUBLE N Indicates whether this privilege can be set for a person.
POSITION_IND DOUBLE N Indicates whether this privilege can be set for a position.
PPR_IND DOUBLE N Indicates whether this privilege can be set for a person patient relationship.
PRIVILEGE_CD DOUBLE N Privilege code of the privilege that is being defined .
PRIVILEGE_DEF_ID DOUBLE N Primary key for the privilege definition table.
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.
YES_IND DOUBLE N Indicates whether this privilege can be set to "yes" (granted).



Relationship Detail - PRIVILEGE_DEF


Child Column in PRIVILEGE_DEF(FK) Parent Table Name Parent Column Name
Parents: PRIVILEGE_CD CODE_VALUE CODE_VALUE




Parent Column in PRIVILEGE_DEF (PK) Child Table Name Child Column Name
Children: PRIVILEGE_DEF_ID PRIVILEGE_EXCEPTION_DEF PRIVILEGE_DEF_ID


PRIVILEGE_DELETION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Privilege_Deletion
Definition: This table is used to track deletion events in the privilege model.
Table Type: ACTIVITY





Column Detail - PRIVILEGE_DELETION


Column Name Type Null? Definition
ACTIVITY_PRIVILEGE_DEF_ID DOUBLE N Activity_privilege_definition identifier associated with the privilege.
LOCATION_CD DOUBLE N Location code value associated with the privilege.
LOG_GROUPING_CD DOUBLE N Logical_grouping identifier whose associated log_group_entry row(s) were deleted.Logical_grouping identifier whose associated log_group_entry row(s) were deleted.(LOGICAL_GROUPING.LOG_GROUPING_CD)CODE_SET = 0
PERSON_ID DOUBLE N Person id associated with the privilege.
POSITION_CD DOUBLE N Position code value associated with the privilege.
PPR_CD DOUBLE N Person-provider relationship code value associated with the privilege. Code Set 331 or 333.
PRIVILEGE_CD DOUBLE N Privilege code value associated with the privilege.
PRIVILEGE_DELETION_ID DOUBLE N The unique identifier of a row on this table.
PRIVILEGE_ID DOUBLE N Identifier of the privilege that was deleted or whose exception(s) were deleted. Based on which privilege component was actually deleted, this id may or may not still exist in the privilege table
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 - PRIVILEGE_DELETION


Child Column in PRIVILEGE_DELETION(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_PRIVILEGE_DEF_ID ACTIVITY_PRIVILEGE_DEFINITION ACTIVITY_PRIVILEGE_DEF_ID
PERSON_ID PERSON PERSON_ID
PRIVILEGE_ID PRIVILEGE PRIVILEGE_ID