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.