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.

 GROUP_ID
 

 DEPT_CODE
 SCHOOL
 STUDY_TYPE

    CT_STUDENT  
    CT_SCHOOL
    CT_STUDY
 

CT_DEPT Table - Data Element Index . Tables and Data Elements . Career Tracker Home . Data Warehouse Home