CM3201J Course Catalog Extract
| Special Instructions | None | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Frequency | On-request | ||||||||||||||||
| Scheduling Restrictions | None | ||||||||||||||||
| Execution Time | Anytime (O, B, P or I) | ||||||||||||||||
| Job Completion Status | None | ||||||||||||||||
| Job Groups |
| ||||||||||||||||
| Job Dependency | None | ||||||||||||||||
| Operator Instructions | None | ||||||||||||||||
| Estimated Run Time | 30 minutes | ||||||||||||||||
| Recovery/Restart | This job is restartable. |
Parameters
| Parameter | Values |
|---|---|
| ADMIN-UNIT-LINE |
This is an optional parameter and is used to
select only certain administrative units from
the course catalog. Administrative unit may
be selected on the first position, the second
position, or both positions. A maximum of 12
ADMIN-UNITs may be entered, each separated by
a space.
Valid Entries: Blank = Extracts all ADMIN-UNITs ## = Extracts X# = Extracts records with the first position of ADMIN-UNIT equal to the variable "X" #X = Extracts records with the second position of ADMIN-UNIT equal to the variable "X" XX = Extracts records with both positions of ADMIN-UNIT equal to "XX" The following example selects records with the first position of ADMIN-UNIT equal to "A", the second position of ADMIN-UNIT equal to "Z" and the ADMIN-UNITs of C1 through C5: A# #Z C1 C2 C3 C4 C5 |
| CM3201-EFF-YRQ | This parameter is used to select courses that are active during the effective YRQ selected. |
| CM3201-SRT-OPT |
Sort Option 01 = MISC-SRT, TITLE, COURSE-ID (default) 02 = Title, Course ID |
| DEPT-DIV-LINE |
This optional parameter is used to select
only certain departments or divisions from
the course catalog. A maximum of 10
Department/Divisions may be entered, each
separated by a comma. e.g., ART H, ART |
| EXCLUD-STAT-4 | This is an optional parameter and will allow the job to exclude any records with the 4th position of SECT-STAT equal to the value entered in parameter (EXCLUD-STAT-4) (Will usually be set to default on a specific value) |
| EXCLUD-ZRO-SEC |
This is an optional parameter and is used to
exclude any Course-D records where summer,
fall, winter and spring sections are ALL = 0
Valid entries: Blank = Extract all Course-D records Y = Exclude any Course-D records where summer, fall, winter and spring sections are All = 0 |
Distribution:
SMS
Created: WED, JAN 04, 2012, 06:54 AM