PACOURSE

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
HS11.1 HS11.2 HS12.1 HS12.2 HS13.1 HS13.2
HS51.1 HS51.2 HS52.1 HS52.2 PA262 PA263
PA62.1 PA63.1 PA64.1 PA64.2 PA65.1 PA65.2


UPDATED BY
TR01.1 TR02.1 TR02.2 TR03.1 TR08.1 TR09.1
TR11.1 TR12.1 TR14.1 TR20.1 TR20.2 TR20.3
TR20.4 TR200 TR201 TR202 TR204 TR207
TR21.1 TR210 TR220 TR221 HS50.3 HS50.4
PA115 TR04.1 TR06.1 TR10.1 TR113 TR114
TR120 TR121 TR13.1 TR13.2 TR15.1 TR205
TR22.1 TR222 TR26.1 TR500 HR04.2 HR04.3
HR04.7 HR04.8 HR80.1 HR80.2 HR80.3 HR80.4
HR80.5 HR80.6 HR80.7 HR80.8 HR80.9 HR81.1
HR81.2 HR81.3 HR81.4 HR81.5 HR81.6 HR81.7
HR81.8 HR81.9 HR82.1 HR82.2 HR82.3 HR82.4
HR82.5 HR82.6 HR82.7 HR82.8 HR82.9 HR83.1
HR83.2 HR83.3 HR83.4 HR83.5 HR83.6 HR83.7
HR83.8 HR83.9 HR84.1 HR84.2 HR84.3 HR84.4
HR84.5 HR84.6 HR84.7 HR84.8 HR84.9 HR85.1
HR85.2 HR85.3 HR85.4 HR85.5 HR85.6 HR85.7
HR85.8 HR86.1 HR86.2 HR86.3 HR86.4 HR86.5
HR86.6 HR86.7 HR86.8 HR86.9 HR87.1 HR87.2
HR87.3 HR87.4 HR87.5 HR87.6 HR87.7 HR87.8
HR87.9 HR88.1 HR88.2 HR88.3 HR88.4 HR88.5
HR88.6 HR88.7 HR89.1 HR89.2 HR89.3 HR89.4
HR89.5 HR89.6 HR89.7 HR89.8 HR89.9 HR91.7
HR92.1 HR92.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRS-COURSE
Element: Course Code
Alpha 10
Contains the course code.
TR01.1
CRS-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
Contains the date the course is effective.
TR01.1
CRS-SHORT-CRS-DESC
Element: Course Name
Alpha 30 (Lower Case)
Contains the course name.
TR01.1 TR04.1
TR14.1 TR200
TR204 TR207
TR220 TR221
TR222
CRS-COURSE-DESC
Element: Course Description
Alpha 60 (Lower Case)
Contains the course description.
TR01.1
CRS-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the course ending date.
TR01.1
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
TR01.1
CRS-DURATION-UNITS
Length/Unit of
Measure
Signed 5.2
Contains the course duration.
TR01.1
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
TR01.1
CRS-CEU-AWARDED
Element: CEUs Awarded
Signed 5.2
Contains the number of Continuing Education Units awarded after course completion.
TR01.1
CRS-CEU-SOURCE
Element: CEU Source
Alpha 10
Contains the source of the Continuing Education Units awarded for course completion.
TR01.1
CRS-COURSE-TYPE
Element: Course Type
Alpha 10
Contains the course type.
TR01.1
CRS-COURSE-CAT
Element: Course Category
Alpha 10
Contains the course category.
TR01.1
CRS-APPROVAL-FLAG
Element: Approval
Alpha 1
Indicates whether approval is required to register for the course. Y = Yes N = No; Default value.
TR01.1
CRS-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Contains the first name of the contact person.
TR01.1
CRS-MIDDLE-INIT
Element: Middle Initial
Alpha 1
Contains the middle initial of the contact person.
TR01.1
CRS-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Contains the last name of the contact person.
TR01.1
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.
TR01.1
CRS-WK-PHONE-NBR
Element: Work Telephone
Alpha 15
Contains the contact person's work telephone number.
TR01.1
CRS-WK-PHONE-EXT
Work Telephone
Extension
Alpha 5
Contains the extension for the contact person's work telephone number.
TR01.1
CRS-EMAIL-USR-NAME
Internal E-mail
Address
Alpha 30 (Lower Case)
Contains the contact person's internal E-mail address.
TR01.1
CRS-EMAIL-DOM-NAME
Internet E-mail
Address
Alpha 30 (Lower Case)
Contains the contact person's internet E-mail address.
TR01.1


PACOURSE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRSSET1 COURSE
EFFECTIVE-DATE
TR01.1 TR02.1
TR02.2 TR03.1
TR08.1 TR09.1
TR11.1 TR12.1
TR14.1 TR20.1
TR20.2 TR20.3
TR20.4 TR200
TR201 TR202
TR204 TR207
TR21.1 TR210
TR220 TR221
CRSSET2 COURSE
EFFECTIVE-DATE*
...
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS50.3 HS50.4
HS51.1 HS51.2
HS52.1 HS52.2
PA115 PA262
PA263 PA62.1
PA63.1 PA64.1
PA64.2 PA65.1
PA65.2 TR01.1
TR02.1 TR02.2
TR03.1 TR04.1
TR06.1 TR09.1
CRSSET3 COURSE-CAT
COURSE
EFFECTIVE-DATE*
KeyChange, Subset
Where(COURSE-CAT !=Spaces)
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
CRSSET4 SHORT-CRS-DESC
COURSE
EFFECTIVE-DATE*
KeyChange, Subset
Where(SHORT-CRS-DESC !=Spaces)


PACOURSE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Course Cat PCODES Not Required
Valid When (CRS-COURSE-CAT !=Spaces )
"CC"->PCO-TYPE
CRS-COURSE-CAT->PCO-CODE
Course Type PCODES Not Required
Valid When CRS-COURSE-TYPE !=Spaces
"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
NAME
RELATED 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


File created: Wed Jun 08 20:50:23 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.