Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

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

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