Suggested CAMS Tables
Accounts
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
Address | Address information | - |
CAMS_Faculty_View | Details about faculty | - |
CAMS_SROfferFacultyTeach_View | Assigns faculty to sections | - |
CAMS_SROffer_View | Section listings | - |
CAMS_Student_View | Details about students | - |
DropBag | Contains dropped student enrollment information | - |
Faculty_Address | Links faculty to address records | - |
FacultyPortal | Contains faculty portal log-ins | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
SRAcademic | Contains student enrollment information | - |
Student_Address | Links students to address records | - |
StudentPortal | Contains student portal log-ins | - |
TermCalendar | Defines academic terms | Use in term logic |
Organizational units
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
Glossary | Code definitions | - |
SRMaster | Course listings | - |
Academic terms
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
RegistrationSchedule | Sets web registration dates | May need to find earliest registration date for a given term if registration dates depend on student type. |
TermCalendar | Defines academic terms | - |
Courses
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
Glossary | Code definitions | - |
GPAGroup | Graduate/Undergraduate definitions | - |
SRMaster | Course listings | - |
Sections
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
CAMS_SROffer_View | Section listings | - |
CAMS_SROfferSchedule_View | Contains section schedule and location information | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
SRMaster | Course listings | - |
TermCalendar | Defines academic terms | Use in term logic |
Section attributes
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Other tables needed will depend on how your institution is using attributes.
Table | Description | Notes |
|---|---|---|
CAMS_SROffer_View | Section listings | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
TermCalendar | Defines academic terms | Use in term logic |
Instructors
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
Address | Address information | - |
CAMS_Faculty_View | Details about faculty | - |
CAMS_SROfferFacultyTeach_View | Assigns faculty to sections | - |
CAMS_SROfferSchedule_Faculty_View | Sort order | May be used to determine instructor role |
CAMS_SROffer_View | Section listings | - |
Faculty_Address | Links faculty to address records | - |
FacultyPortal | Contains faculty portal log-ins | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
TermCalendar | Defines academic terms | Use in term logic |
Enrollments
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
CAMS enrollment records typically require two unioned queries to capture the following situations: students who have enrolled in a section (stored on SRAcademic), students who have enrolled in and dropped a section (stored on DropBag), and students who have enrolled, dropped, and re-enrolled in a section (stored on both SRAcademic and DropBag). Both queries must use both tables to fully capture the latter case, comparing add and withdraw dates between the tables to select the most current record.
Table | Description | Notes |
|---|---|---|
Address | Address information | - |
CAMS_SROffer_View | Section listings | - |
CAMS_Student_View | Details about students | - |
DropBag | Contains dropped student enrollment information | May need to find most recent record for a given enrollment. |
Glossary | Code definitions | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
SRAcademic | Contains student enrollment information | May need to find most recent record for a given enrollment. |
Student_Address | Links students to address records | - |
StudentPortal | Contains student portal log-ins | - |
TermCalendar | Defines academic terms | Use in term logic |
Remove instructors
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
Address | Address information | - |
CAMS_Faculty_View | Details about faculty | - |
CAMS_SROfferFacultyTeach_View | Assigns faculty to sections | - |
CAMS_SROffer_View | Section listings | - |
Faculty_Address | Links faculty to address records | - |
FacultyPortal | Contains faculty portal log-ins | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
TermCalendar | Defines academic terms | Use in term logic |
Academic programs
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Table | Description | Notes |
|---|---|---|
AuditCourse | Links courses to audit groups | - |
AuditCourseGroup | Defines audit groups | - |
AuditGroupRequirement | Defined audit group requirements | - |
AuditProgram | Defines programs | - |
AuditRequirementProgram | Links requirement groups to programs | - |
DegreeNameRef | Defines degrees | - |
MajorMinor | Defines majors/minors | - |
SRMaster | Course listings | - |
Demographics
The tables and notes listed below are suggestions as individual CAMS implementations may vary.
Faculty
Table | Description | Notes |
|---|---|---|
Address | Address information | - |
CAMS_Faculty_View | Details about faculty | - |
CAMS_FacultyRank_View | Provides faculty ranking information | - |
CAMS_SROffer_View | Section listings | - |
CAMS_SROfferFacultyTeach_View | Assigns faculty to sections | - |
Faculty_Address | Links faculty to address records | - |
FacultyPortal | Contains faculty portal log-ins (may be used for external ID) | - |
Glossary | Code definitions | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
TermCalendar | Defines academic terms | Use in term logic |
Students
Table | Description | Notes |
|---|---|---|
Address | Address information | - |
CAMS_FinancialAidYear_View | Defines financial aid years | - |
CAMS_IPEDSEthnicity_View | Provides IPEDS ethnicity data | - |
CAMS_PellSchedule_View | Provides Pell data | - |
CAMS_SROffer_View | Section listings | - |
CAMS_Student_View | Details about students | - |
CAMS_StudentActivity_View | Additional student information (highly campus-specific) | - |
CAMS_StudentCumulativeGPA_View | Contains student GPAs | Need to find current or most recent term |
CAMS_StudentDemographics_View | Provides student demographic information | - |
CAMS_StudentEthnicity_View | Contains student ethnicity information | - |
CAMS_StudentExtraCurActivity_View | Contains student extracurricular participation | Need to find current or most recent term |
CAMS_StudentHighSchool_View | Provides student high school information | - |
CAMS_StudentProgram_View | Contains student programs | Need to find current or most recent term |
CAMS_StudentStatus_View | Provides student standing | Need to find current or most recent term |
CAMS_StudentTestScores_View | Student SAT/ACT scores | - |
DropBag | Contains dropped student enrollment information | - |
Glossary | Code definitions | - |
RegistrationSchedule | Sets web registration dates | Use in term logic. May need to find earliest registration date for a given term if registration dates depend on student type. |
SRAcademic | Contains student enrollment information | - |
Student_Address | Links students to address records | - |
StudentPortal | Contains student portal log-ins | - |
TermCalendar | Defines academic terms | Use in term logic |