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 |