Penn Computing

University of Pennsylvania
Penn Computing << go backback
COMP_APPLICATION_USER_GROUP Table - Data Element Index   Tables and Data Elements   Infrastructure 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.

Primary Key Indexed Data Elements Related Tables
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   Infrastructure Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania