Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_DEPT Table - Data Element Index . Tables and Data Elements . Career Tracker Home . Data Warehouse Home

CT_DEPT Table

(gradadm.ct_dept)

Explanation
Defines group access levels (Group_IDs) for Student data in the Career Tracker application.

GROUP_ID is either "All", SRS School code, or the combination of SRS School code concatenated with DEPT(SRS Major).

DEPT is either "All" or SRS Major. eg) All schools||All majors, Single School || All majors, Single school || Single major

Common Uses
Lookup user access group definitions.

Primary Key Indexed Data Elements Related Tables
 GROUP_ID
 DEPT_CODE
 SCHOOL
 STUDY_TYPE
    CT_STUDENT  
    CT_SCHOOL
    CT_STUDY
 

Cautions
CT_DEPT Table - Data Element Index . Tables and Data Elements . Career Tracker 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