What is the CC AGEC Table?
This table is a specialized view table of CC DEGREE. It contains AGEC data for recipients from community colleges in Arizona by term and college where the AGEC was received. Terms include Fall, Spring, and Summer semesters.
What is the key (unique identifier for a row) for this table?
Unique records are determined by Semester, Arizona Unitid, ASSIST Student ID, AGEC Code and AGEC Date. In other words, there is one record per AGEC, per AGEC date, per student per semester per community college.
Why would you use this table?
If you are a community college, you could join this table with the UV ENROLLMENT table on the ASSIST Student ID field. Then put a limit on the CC AGEC table’s Arizona Unitid of your institution’s code and a minimum function on the UV ENROLLMENT table’s Semester field to get the first semester a student attended a university after receiving an AGEC at your institution.
Notes on using this table:
1. In this table, Arizona Unitid refers ONLY to community colleges.
2. In this table, Semester refers ONLY to Fall, Spring, and Summer.
3. Students may NOT be officially enrolled during the semester an AGEC is awarded.
4. Students may be awarded MORE than one AGEC during a semester.
5. Students may be awarded more than one AGEC with the SAME CIP code.
