...
What it does: | This query identifies sections that are Zero Textbook Cost (ZTC) sections in a single term. They should have the “No Cost Textbook” symbol in the online and printed catalog. In order to meet ZTC criteria (and get labeled ZTC) the following conditions must be met: - There are no materials that are required with a cost - The Author must show, “NO COST” - The Title must show, “THIS COURSE USES DIGITAL COURSE MATERIALS” This query has been designed to provide a single row per section that can be joined to the Course Section table and used as a flag for ZTC sections. If you want to include multiple terms you must manually combine each query result into one file. |
Joins Needed | Please perform a join with Course section via: Course_Section.Term +- to X_IR_ZTC_QUERY.Term Course_Section.Classnbr +- to X_IR_ZTC_QUERY.Class_Nbr |
Source Table in Campus Solutions | SSR_CLS_TXB_DTL – Class Reservee However, you must do some processing of this source table for it to work appropriately as it includes all text materials listed. |
Validation: | Marc validated several of the sections that appeared in this query as ZTC with the online catalog from the student view. For every course identified here he saw it matched. Marc did not have information at the time about Credit College Learning Community practices and the way ZTC sections for those groups of classes must be further investigated, particularly once LCMP and LCOM is added to our Datamart. |
Additional Resources: | None |
...