COMP_APPLICATION_GROUP Table - Data Element Index   Tables and Data Elements   User Access Administration 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.

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   User Access Administration Home   Data Warehouse Home