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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET4
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 SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CRSSET1
  1. COURSE
  2. EFFECTIVE-DATE
PrimaryTR01.1, TR02.1, TR02.2, TR03.1, TR08.1, TR09.1, TR11.1, TR12.1 +14 more
CRSSET2
  1. COURSE
  2. EFFECTIVE-DATE ↓
HS11.1, HS11.2, HS12.1, HS12.2, HS13.1, HS13.2, HS50.1, HS50.2 +22 more (list truncated in source)
CRSSET3
  1. COURSE-CAT
  2. COURSE
  3. 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)
CRSSET4
  1. SHORT-CRS-DESC
  2. COURSE
  3. EFFECTIVE-DATE ↓
KeyChange, SubsetWhere (SHORT-CRS-DESC != Spaces)—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PCODESPAPREPROPTPAATTRIBPACOSTPAINSCOURSPAPREREQPAREGISTERPASCOSTPASESSIONPATRACKDTLPATRNHISTPACOURSE

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 Required
CRS-COURSE→PQO-COURSE

One to many (13) — child tables

RelationTableRulesConditionField map
AttributesPAATTRIB
CRS-COURSE→TRB-COURSE
—→TRB-TYPE
—→TRB-CODE
CostPACOST
CRS-COURSE→CST-COURSE
—→CST-COST-TYPE
—→CST-COST-CAT
—→CST-EFFECTIVE-DATE
InstructorPAINSCOURS
CRS-COURSE→INC-COURSE
—→INC-INSTRUCT
Prereq CsPAPREREQ
CRS-COURSE→RQS-COURSE
"CS"→RQS-PREREQ-TYPE
—→RQS-PREREQUISITE
—→RQS-COMPANY
Prereq EgPAPREREQ
CRS-COURSE→RQS-COURSE
"EG"→RQS-PREREQ-TYPE
—→RQS-PREREQUISITE
—→RQS-COMPANY
Prereq SkPAPREREQ
CRS-COURSE→RQS-COURSE
"SK"→RQS-PREREQ-TYPE
—→RQS-PREREQUISITE
—→RQS-COMPANY
Prereq SvPAPREREQ
CRS-COURSE→RQS-COURSE
"SV"→RQS-PREREQ-TYPE
—→RQS-PREREQUISITE
—→RQS-COMPANY
PrereqsPAPREREQ
CRS-COURSE→RQS-COURSE
—→RQS-PREREQ-TYPE
—→RQS-PREREQUISITE
—→RQS-COMPANY
RegisterPAREGISTERDelete Restricted
CRS-COURSE→REG-COURSE
—→REG-SESSION
—→REG-START-DATE
—→REG-COMPANY
—→REG-EMPLOYEE
Ses CostPASCOST
CRS-COURSE→COS-COURSE
—→COS-SESSION
—→COS-START-DATE
—→COS-COST-TYPE
—→COS-COST-CAT
SessionPASESSIONDelete Restricted
CRS-COURSE→SES-COURSE
—→SES-SESSION
—→SES-START-DATE
TrackPATRACKDTL
CRS-COURSE→TKD-COURSE
—→TKD-TRACK
TrainingPATRNHIST
CRS-COURSE→TRH-COURSE
—→TRH-COMPANY
—→TRH-EMPLOYEE
—→TRH-DATE-COMPLETED

Programs

Updated by (1)

Referenced by (154)