Use the Course Search (SCASRCH) page to search for all courses (either by subject and course or subject alone) that are active for a specified date range.
This allows administrative users to have non-term search capabilities. The date ranges entered are compared to the term start and end dates defined in the Term Code Validation (STVTERM) page. This term is then used to retrieve all course records based on the effective term range of the course as contained in the SCBCRKY and SCBCRSE tables.
On STVTERM:
| Term | Start Date | End Date |
|---|---|---|
| 200610 | 01-SEP-2005 | 31-DEC-2005 |
| 200620 | 01-JAN-2006 | 15-APR-2006 |
On SCBCRSE:
| From Term | To Term | Subject | Course |
|---|---|---|---|
| 200510 | 200620 | ENGL | 100 |
| 200620 | 200630 | ENGL | 101 |
| 200710 | 999999 | ENGL | 101 |
On SCASRCH, in the Key block:
| Subject | Course | Start Date | End Date (inclusive) |
|---|---|---|---|
| ENGL | 01-DEC-2005 | 31-JAN-2006 |
This data filter would return the first two records (or all records where the search start and end dates are between the term start and end dates).
On SCASRCH, in the Key block:
| Subject | Course | Start Date | End Date (inclusive) |
|---|---|---|---|
| ENGL | 101 | 01-DEC-2005 | 31-JAN-2006 |
This data filter would return the ENGL 101 record with the effective term of 200620 (or all records where the search start and end dates are between the term start and end dates).
On SCASRCH, in the Key block:
| Subject | Course | Start Date | End Date (inclusive) |
|---|---|---|---|
| ENGL | 101 | 01-DEC-2005 |
This data filter would not return any records.