Courses
Contains information about each course, including dates, frequency, CEUs, and contact person. The CEU updates TR22.1 (Session Completion). A course record remains in the Courses file as long as there is at least one session for the course in the Sessions file. TR01.1 (Courses) is the primary program that updates this file.
REFERENCED BY
TR01.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
CRS-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||||||||||
CRS-EFFECTIVE-DATE Element: Effective Date | Numeric 8 (yyyymmdd) Contains the date the course is effective. |
|
||||||||||
CRS-SHORT-CRS-DESC Element: Course Name | Alpha 30 (Lower Case) Contains the course name. |
|
||||||||||
CRS-COURSE-DESC Element: Course Description | Alpha 60 (Lower Case) Contains the course description. |
|
||||||||||
CRS-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the course ending date. |
|
||||||||||
CRS-FREQ Element: Fequency | Alpha 1 Indicates how often the course is offered. 0 = Daily 1 = Weekly 2 = Bi-Weekly 3 = Monthly 4 = Bi-Monthly 5 = Semi-Monthly 6 = Quarterly 7 = Annually 8 = Bi-Annually 9 = Semi-Annually |
|
||||||||||
CRS-DURATION-UNITS Length/Unit of Measure | Signed 5.2 Contains the course duration. |
|
||||||||||
CRS-DURATION-MEAS Element: Length | Alpha 1 Contains unit in which the course duration is measured. H = Hours D = Days W = Weeks M = Months Q = Quarters S = Semesters |
|
||||||||||
CRS-CEU-AWARDED Element: CEUs Awarded | Signed 5.2 Contains the number of Continuing Education Units awarded after course completion. |
|
||||||||||
CRS-CEU-SOURCE Element: CEU Source | Alpha 10 Contains the source of the Continuing Education Units awarded for course completion. |
|
||||||||||
CRS-COURSE-TYPE Element: Course Type | Alpha 10 Contains the course type. |
|
||||||||||
CRS-COURSE-CAT Element: Course Category | Alpha 10 Contains the course category. |
|
||||||||||
CRS-APPROVAL-FLAG Element: Approval | Alpha 1 Indicates whether approval is required to register for the course. Y = Yes N = No; Default value. |
|
||||||||||
CRS-FIRST-NAME Element: First Name | Alpha 15 (Lower Case) Contains the first name of the contact person. |
|
||||||||||
CRS-MIDDLE-INIT Element: Middle Initial | Alpha 1 Contains the middle initial of the contact person. |
|
||||||||||
CRS-LAST-NAME Element: Last Name | Alpha 30 (Lower Case) Contains the last name of the contact person. |
|
||||||||||
CRS-SHORT-NAME Element: Name | Derived Contains the short name of the contact person. |
|
||||||||||
CRS-WK-PHONE-CNTRY Work Telephone Country | Alpha 6 Contains the country code of the contact person's work telephone number. |
|
||||||||||
CRS-WK-PHONE-NBR Element: Work Telephone | Alpha 15 Contains the contact person's work telephone number. |
|
||||||||||
CRS-WK-PHONE-EXT Work Telephone Extension | Alpha 5 Contains the extension for the contact person's work telephone number. |
|
||||||||||
CRS-EMAIL-USR-NAME Internal E-mail Address | Alpha 30 (Lower Case) Contains the contact person's internal E-mail address. |
|
||||||||||
CRS-EMAIL-DOM-NAME Internet E-mail Address | Alpha 30 (Lower Case) Contains the contact person's internet E-mail address. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CRSSET1 |
COURSE EFFECTIVE-DATE |
|
| ||||||||||||||||||||||||||||
CRSSET2 |
COURSE EFFECTIVE-DATE* |
|
|||||||||||||||||||||||||||||
CRSSET3 |
COURSE-CAT COURSE EFFECTIVE-DATE* |
|
|||||||||||||||||||||||||||||
CRSSET4 |
SHORT-CRS-DESC COURSE EFFECTIVE-DATE* |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Course Cat | PCODES |
Not Required
| ||||||||||||
Course Type | PCODES |
Not Required
| ||||||||||||
Prereq Options | PAPREPROPT |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Attributes | PAATTRIB |
| |||||||||||||||
Cost | PACOST |
| |||||||||||||||
Instructor | PAINSCOURS |
| |||||||||||||||
Prereq Cs | PAPREREQ |
| |||||||||||||||
Prereq Eg | PAPREREQ |
| |||||||||||||||
Prereq Sk | PAPREREQ |
| |||||||||||||||
Prereq Sv | PAPREREQ |
| |||||||||||||||
Prereqs | PAPREREQ |
| |||||||||||||||
Register | PAREGISTER |
Delete Restricted
| |||||||||||||||
Ses Cost | PASCOST |
| |||||||||||||||
Session | PASESSION |
Delete Restricted
| |||||||||||||||
Track | PATRACKDTL |
| |||||||||||||||
Training | PATRNHIST |
|
All trademarks and registered trademarks are the property of their
respective owners.