X_CM_TPRP_CLASS_ATTRIBUTES

Owned by irp
Jan 31, 2022
2 min read

Query Information

Query Name

X_CM_TPRP_CLASS_ATTRIBUTES

Contributing Institution

District Office

Contributing Analyst

Marc Grabiel

Maintenance/Upkeep Required

None known

Query Entry Last Updated

1/31/2022

Query Search Fields

Term (Optional)

Term as in SDCCD_IRD (e.g. 2207, 2213, etc)

Campus (Optional)

Credit College Institution (CITY, MESA, or MIRA)

TPRP Type (Optional)

Credit by Exam TPRP Course Attribute Value (TPHS or TPCE)

Query Fields of Interest

Crse Attr

Identifies Course Attribute (should always be TPRP)

TPRP Type (CrsAtr Val)

Identifies Course Attribute Value (TPHS – High School process, TPCE – SDCCE process)

Class Nbr

Classnbr (CS008) – used in Join

Campus

Create College Institution (CS017)

Term

Identifies Term – used in Join

Subject

Subject (CS006)

Catalog

Catnum (CS007)

Class Stat

Classstat (CS010)

Tot Enrl

Enrlcur (CS014) – Number of students currently enrolled (aka earned credit)

Information about Query

What it does:

This query provides section-level data for Credit for Prior Learning received through our Credit by Exam processes. Only courses that have the Course Attribute TPRP added to them appear.

Joins Needed

Please perform a join with Course section via:

Course_Section.Term to X_CM_TPRP_CLASS_ATTRIBUTES.Term

Course_Section.Classnbr to X_CM_ TPRP_CLASS_ATTRIBUTES.Class_Nbr

Source Table in Campus Solutions

CLASS_ATTRIBUTE

 

Filter by CRSE_ATTR = TPRP

Validation:

Marc validated this query to ensure that it served its original intent (list of sections with each TPRP Course Attribute Value).

Additional Resources:

Credit by Exam webpage:

https://www.sdccd.edu/about/departments-and-offices/instructional-services-division/workforce-and-economic-development/cte-transitions-credit-by-exam/index.aspx

Known Issues, Related Details, and Other Notes

  • Sections for credits earned through High School processes (TPHS) are created before a term starts. Credits through SDCCE are currently created on an as needed basis.

  • As of 1/31/2022, certain credit courses from SDCCE processes could not add the TPRP Course Attribute: CBTE 101, CBTE 120, ARTG 125, MULT 100, CACM 101. This is currently being explored so the steps needed to add them is complete.

  • Feel free to reach out to Marc if you have any questions.