X_IR_ZTC_QUERY

X_IR_ZTC_QUERY

Query Information

Query Name

X_IR_ZTC_QUERY

Contributing Institution

District Office

Contributing Analyst

Marc Grabiel

Maintenance/Upkeep Required

None known

Query Entry Last Updated

3/26/2021

Query Search Fields

Term

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

Query Fields of Interest

Course ID

* Only if interested in recreating Class Nbr

Offer Nbr

Identifies College

Term

Identifies Term – used in Join

Session

* Only if interested in recreating Class Nbr

Section

* Only if interested in recreating Class Nbr

Seq No

Identifies which textbook material it is listed in the source textbook query

Status

Identifies if this material is Required or not. In order to be ZTC it must be Required

Title

Shows the title of the textbook material. All ZTC sections must have “THIS COURSE USES DIGITAL COURSE MATERIALS” listed.

Author

Identifies author of textbook material. All ZTC sections must have “NO COST”.

Subject

Identifies Subject

Catalog

Identifies Catnum

Class Nbr

Identifies Classnbr – used in Join

Campus

Identifies College

Information about Query

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

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