PACOURSE FILE
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
HR700 TR02.1 TR02.2 TR03.1 TR08.1 TR09.1
TR11.1 TR12.1 TR14.1 TR20.1 TR20.2 TR20.3
TR200 TR201 TR202 TR204 TR207 TR210
TR220 TR221 PA115 TR04.1 TR06.1 TR10.1
TR113 TR114 TR120 TR121 TR13.1 TR13.2
TR15.1 TR205 TR21.1 TR22.1 TR222 TR500
UPDATED BY
TR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRS-COURSE Alpha 10 TR01.1
Course Code Contains the course code.
CRS-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR01.1
Effective Date Contains the date the course is
effective.
CRS-SHORT-CRS-DESC Alpha 30 (Lower Case) TR01.1 TR04.1
Course Name Contains the course name. TR14.1 TR200
TR204 TR207
TR220 TR221
CRS-COURSE-DESC Alpha 60 (Lower Case) TR01.1
Course Description Contains the course description.
CRS-END-DATE Numeric 8 (yyyymmdd) TR01.1
End Date Contains the course ending date.
CRS-FREQ Alpha 1 TR01.1
Fequency 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 Signed 5.2 TR01.1
Length/Unit of Contains the course duration.
Measure
CRS-DURATION-MEAS Alpha 1 TR01.1
Length Contains unit in which the course
duration is measured.
H = Hours
D = Days
W = Weeks
M = Months
Q = Quarters
S = Semesters
CRS-CEU-AWARDED Signed 5.2 TR01.1
CEUs Awarded Contains the number of Continuing
Education Units awarded after course
completion.
CRS-CEU-SOURCE Alpha 10 TR01.1
CEU Source Contains the source of the Continuing
Education Units awarded for course
completion.
CRS-COURSE-TYPE Alpha 10 TR01.1
Course Type Contains the course type.
CRS-COURSE-CAT Alpha 10 TR01.1
Course Category Contains the course category.
CRS-APPROVAL-FLAG Alpha 1 TR01.1
Approval Indicates whether approval is required
to register for the course.
Y = Yes
N = No; Default value.
CRS-FIRST-NAME Alpha 15 (Lower Case) TR01.1
First Name Contains the first name of the contact
person.
CRS-MIDDLE-INIT Alpha 1 TR01.1
Middle Initial Contains the middle initial of the
contact person.
CRS-LAST-NAME Alpha 30 (Lower Case) TR01.1
Last Name Contains the last name of the contact
person.
CRS-SHORT-NAME Derived
Name Contains the short name of the contact
person.
CRS-WK-PHONE-CNTRY Alpha 6 TR01.1
Work Telephone Contains the country code of the
Country contact person's work telephone number.
CRS-WK-PHONE-NBR Alpha 15 TR01.1
Work Telephone Contains the contact person's work
telephone number.
CRS-WK-PHONE-EXT Alpha 5 TR01.1
Work Telephone Contains the extension for the contact
Extension person's work telephone number.
CRS-EMAIL-USR-NAME Alpha 30 (Lower Case) TR01.1
Internal E-mail Contains the contact person's internal
Address E-mail address.
CRS-EMAIL-DOM-NAME Alpha 30 (Lower Case) TR01.1
Internet E-mail Contains the contact person's internet
Address E-mail address.
PACOURSE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRSSET1 COURSE HR700 TR01.1
EFFECTIVE-DATE TR02.1 TR02.2
TR03.1 TR08.1
TR09.1 TR11.1
TR12.1 TR14.1
TR20.1 TR20.2
TR20.3 TR200
TR201 TR202
TR204 TR207
TR210 TR220
TR221
CRSSET2 COURSE PA115 TR01.1
EFFECTIVE-DATE* TR02.1 TR02.2
TR03.1 TR04.1
TR06.1 TR09.1
TR10.1 TR11.1
TR113 TR114
TR120 TR121
TR13.1 TR13.2
TR14.1 TR15.1
TR20.1 TR20.2
TR20.3 TR200
TR204 TR205
TR21.1 TR22.1
TR222 TR500
PACOURSE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course Cat PCODES Not Required
"CC" -> PCO-TYPE
CRS-COURSE-CAT -> PCO-CODE
Course Type PCODES Not Required
"CT" -> PCO-TYPE
CRS-COURSE-TYPE -> PCO-CODE
Prereq Options PAPREPROPT Not Required
CRS-COURSE -> PQO-COURSE
PACOURSE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attributes PAATTRIB
CRS-COURSE -> TRB-COURSE
TRB-TYPE
TRB-CODE
Cost PACOST
CRS-COURSE -> CST-COURSE
CST-COST-TYPE
CST-COST-CAT
CST-EFFECTIVE-DATE
Instructor PAINSCOURS
CRS-COURSE -> INC-COURSE
INC-INSTRUCT
Prereq Cs PAPREREQ
CRS-COURSE -> RQS-COURSE
"CS" -> RQS-PREREQ-TYPE
RQS-PREREQUISITE
RQS-COMPANY
Prereq Eg PAPREREQ
CRS-COURSE -> RQS-COURSE
"EG" -> RQS-PREREQ-TYPE
RQS-PREREQUISITE
RQS-COMPANY
Prereq Sk PAPREREQ
CRS-COURSE -> RQS-COURSE
"SK" -> RQS-PREREQ-TYPE
RQS-PREREQUISITE
RQS-COMPANY
Prereq Sv PAPREREQ
CRS-COURSE -> RQS-COURSE
"SV" -> RQS-PREREQ-TYPE
RQS-PREREQUISITE
RQS-COMPANY
Prereqs PAPREREQ
CRS-COURSE -> RQS-COURSE
RQS-PREREQ-TYPE
RQS-PREREQUISITE
RQS-COMPANY
Register PAREGISTER Delete Restricted
CRS-COURSE -> REG-COURSE
REG-SESSION
REG-START-DATE
REG-COMPANY
REG-EMPLOYEE
Ses Cost PASCOST
CRS-COURSE -> COS-COURSE
COS-SESSION
COS-START-DATE
COS-COST-TYPE
COS-COST-CAT
Session PASESSION Delete Restricted
CRS-COURSE -> SES-COURSE
SES-SESSION
SES-START-DATE
Track PATRACKDTL
CRS-COURSE -> TKD-COURSE
TKD-TRACK
Training PATRNHIST
CRS-COURSE -> TRH-COURSE
TRH-COMPANY
TRH-EMPLOYEE
TRH-DATE-COMPLETED
|