Penn Computing

University of Pennsylvania
Penn Computing << go backback
COMP_APPLICATION_GROUP Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home

COMP_APPLICATION_GROUP Table

Explanation
The COMP_APPLICATION_GROUP table contains information about user groups for the PennWorks application.

Common Uses
Determining the various user groups, or system roles, available in PennWorks.

Primary Key Indexed Data Elements Related Tables
GROUP_ID
GROUP_ID
GROUP_NAME
COMP_APPLICATION_USER_GROUP (DWCOMP)

Cautions

  • COMP_APPLICATION_GROUP is available only to Access Administrators, and can be used to find information about user groups referenced in COMP_APPLICATION_USER_GROUP.
  • Both currently active and disabled records are available in COMP_APPLICATION_GROUP; be sure to check the Disabled_Date column to see whether the group record has been deactivated.
  • The COMP_APPLICATION_GROUP table is stored in the DWCOMP schema in the Data Warehouse.
COMP_APPLICATION_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