COMP_APPLICATION_USER_GROUP Table - Data Element Index   Tables and Data Elements   User Access Administration Home   Data Warehouse Home

COMP_APPLICATION_USER_GROUP Table

Explanation
The COMP_APPLICATION_USER_GROUP table contains information about users' membership in system groups in the PennWorks application.

Common Uses
Determining to which group(s), or system role(s), a PennWorks user belongs.

USER_GROUP_ID

GROUP_ID
USER_GROUP_ID
USER_HOME_ORG
USER_ID
USER_NAME

USER_PENN_ID

COMP_APPLICATION_USER (DWCOMP)
EMPLOYEE_GENERAL (DWADMIN)

Cautions

• COMP_APPLICATION_USER_GROUP is secured by center, and is available only to Access Administrators, for the center(s) in their area of responsibility. Access Administrators will be able to view records in this table for any individuals whose home school/center is in their area of responsibility.

• Both currently active and disabled records are available in COMP_APPLICATION_USER_GROUP; be sure to check the Disabled_Date column to see whether the user/group membership record has been deactivated.

• The COMP_APPLICATION_USER_GROUP table is stored in the DWCOMP schema in the Data Warehouse.

COMP_APPLICATION_USER_GROUP Table - Data Element Index   Tables and Data Elements   User Access Administration Home   Data Warehouse Home