COMP_APPLICATION_USER Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home

COMP_APPLICATION_USER Table

Explanation
The COMP_APPLICATION_USER table contains information about users of the PennWorks application.

Common Uses
Determining who has access to PennWorks.

USER_ID

USER_HOME_ORG
USER_ID
USER_NAME
USER_PENNKEY
USER_PENN_ID

COMP_APPLICATION_USER_GROUP (DWCOMP)
EMPLOYEE_GENERAL (DWADMIN)

Cautions

• COMP_APPLICATION_USER 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; be sure to check the Disabled_Date column to see whether the user record has been deactivated.

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

COMP_APPLICATION_USER Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home