PACOURSE – Courses

System
Personnel (PA)
Prefix
CRS
Primary key
COURSE, EFFECTIVE-DATE
Fields
22
Updated by
1 program
Referenced by
154 programs

PACOURSE is the Courses table in Lawson Personnel (prefix CRS). It is indexed by COURSE, EFFECTIVE-DATE (CRSSET1); alternate indexes: CRSSET2, CRSSET3 and CRSSET4. It is related 1:1 to PCODES and PAPREPROPT and 1:M to PAATTRIB, PACOST, PAINSCOURS, PAPREREQ, PAREGISTER, PASCOST, PASESSION, PATRACKDTL and 1 more. It is updated by TR01.1 and referenced by HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 and 146 more. The table has 22 fields, 4 indexes and 16 documented relations.

About PACOURSE

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.

Fields (22)

Column = COBOL field name without the CRS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CRS-COURSE PK
COURSE		Alpha 10Contains the course code.TR01.1
CRS-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)Contains the date the course is effective.TR01.1
CRS-SHORT-CRS-DESC
SHORT_CRS_DESC		Alpha 30 (Lower Case)Contains the course name.TR01.1, TR04.1, TR14.1, TR200, TR204, TR207, TR220, TR221 +1 more
CRS-COURSE-DESC
COURSE_DESC		Alpha 60 (Lower Case)Contains the course description.TR01.1
CRS-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the course ending date.TR01.1
CRS-FREQ
FREQ		Alpha 1Indicates 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
DURATION_UNITS		Signed 5.2Contains the course duration.TR01.1
CRS-DURATION-MEAS
DURATION_MEAS		Alpha 1Contains 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
CEU_AWARDED		Signed 5.2Contains the number of Continuing Education Units awarded after course completion.TR01.1
CRS-CEU-SOURCE
CEU_SOURCE		Alpha 10Contains the source of the Continuing Education Units awarded for course completion.TR01.1
CRS-COURSE-TYPE
COURSE_TYPE		Alpha 10Contains the course type.TR01.1
CRS-COURSE-CAT
COURSE_CAT		Alpha 10Contains the course category.TR01.1
CRS-APPROVAL-FLAG
APPROVAL_FLAG		Alpha 1Indicates whether approval is required to register for the course.
  • Y Yes
  • N No; Default value.
TR01.1
CRS-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Contains the first name of the contact person.TR01.1
CRS-MIDDLE-INIT
MIDDLE_INIT		Alpha 1Contains the middle initial of the contact person.TR01.1
CRS-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Contains the last name of the contact person.TR01.1
CRS-SHORT-NAME
SHORT_NAME		DerivedContains the short name of the contact person.—
CRS-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Contains the country code of the contact person's work telephone number.TR01.1
CRS-WK-PHONE-NBR
WK_PHONE_NBR		Alpha 15Contains the contact person's work telephone number.TR01.1
CRS-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains the extension for the contact person's work telephone number.TR01.1
CRS-EMAIL-USR-NAME
EMAIL_USR_NAME		Alpha 30 (Lower Case)Contains the contact person's internal E-mail address.TR01.1
CRS-EMAIL-DOM-NAME
EMAIL_DOM_NAME		Alpha 30 (Lower Case)Contains the contact person's internet E-mail address.TR01.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CRSSET1COURSE, EFFECTIVE-DATEPrimaryTR01.1, TR02.1, TR02.2, TR03.1, TR08.1, TR09.1, TR11.1, TR12.1 +14 more
CRSSET2COURSE, EFFECTIVE-DATE*HS11.1, HS11.2, HS12.1, HS12.2, HS13.1, HS13.2, HS50.1, HS50.2 +22 more (list truncated in source)
CRSSET3COURSE-CAT, COURSE, EFFECTIVE-DATE*KeyChange, SubsetWhere (COURSE-CAT != Spaces)HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
CRSSET4SHORT-CRS-DESC, COURSE, EFFECTIVE-DATE*KeyChange, SubsetWhere (SHORT-CRS-DESC != Spaces)—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Course CatPCODESNot RequiredValid When (CRS-COURSE-CAT != Spaces)"CC" → PCO-TYPE, CRS-COURSE-CAT → PCO-CODE
Course TypePCODESNot RequiredValid When CRS-COURSE-TYPE != Spaces"CT" → PCO-TYPE, CRS-COURSE-TYPE → PCO-CODE
Prereq OptionsPAPREPROPTNot RequiredCRS-COURSE → PQO-COURSE

One to many (13) — child tables

RelationTableRulesConditionField map
AttributesPAATTRIBCRS-COURSE → TRB-COURSE, → TRB-TYPE, → TRB-CODE
CostPACOSTCRS-COURSE → CST-COURSE, → CST-COST-TYPE, → CST-COST-CAT, → CST-EFFECTIVE-DATE
InstructorPAINSCOURSCRS-COURSE → INC-COURSE, → INC-INSTRUCT
Prereq CsPAPREREQCRS-COURSE → RQS-COURSE, "CS" → RQS-PREREQ-TYPE, → RQS-PREREQUISITE, → RQS-COMPANY
Prereq EgPAPREREQCRS-COURSE → RQS-COURSE, "EG" → RQS-PREREQ-TYPE, → RQS-PREREQUISITE, → RQS-COMPANY
Prereq SkPAPREREQCRS-COURSE → RQS-COURSE, "SK" → RQS-PREREQ-TYPE, → RQS-PREREQUISITE, → RQS-COMPANY
Prereq SvPAPREREQCRS-COURSE → RQS-COURSE, "SV" → RQS-PREREQ-TYPE, → RQS-PREREQUISITE, → RQS-COMPANY
PrereqsPAPREREQCRS-COURSE → RQS-COURSE, → RQS-PREREQ-TYPE, → RQS-PREREQUISITE, → RQS-COMPANY
RegisterPAREGISTERDelete RestrictedCRS-COURSE → REG-COURSE, → REG-SESSION, → REG-START-DATE, → REG-COMPANY, → REG-EMPLOYEE
Ses CostPASCOSTCRS-COURSE → COS-COURSE, → COS-SESSION, → COS-START-DATE, → COS-COST-TYPE, → COS-COST-CAT
SessionPASESSIONDelete RestrictedCRS-COURSE → SES-COURSE, → SES-SESSION, → SES-START-DATE
TrackPATRACKDTLCRS-COURSE → TKD-COURSE, → TKD-TRACK
TrainingPATRNHISTCRS-COURSE → TRH-COURSE, → TRH-COMPANY, → TRH-EMPLOYEE, → TRH-DATE-COMPLETED

Programs

Updated by (1)

Referenced by (154)