PAREGISTER – Registration Information

System
Personnel (PA)
Prefix
REG
Primary key
COURSE, SESSION, START-DATE, COMPANY, EMPLOYEE
Fields
18
Updated by
10 programs
Referenced by
4 programs

PAREGISTER is the Registration Information table in Lawson Personnel (prefix REG). It is indexed by COURSE, SESSION, START-DATE, COMPANY, EMPLOYEE (REGSET1); alternate indexes: REGSET2, REGSET3, REGSET4, REGSET5 and REGSET6. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAMODOPT, PAEMPLOYEE, PAPREPROPT and PASESSION and 1:M to PACOURSE, PAEMPTRACK, PAPREREQ, PAINSTSES and PATRNHIST. It is updated by HR11.1, PA115, TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3 and 2 more and referenced by TR200, TR201, TR220 and TR221. The table has 18 fields, 6 indexes and 11 documented relations.

About PAREGISTER

Contains names and registration dates of employees registered into sessions. The Registration Information file accesses the Prerequisite Options file for prerequisite information. When a completion status and date is entered in TR22.1 (Session Completion), the employee's name and registration information is removed from the Registration Information file and added to the Training History file. Employees with a status of Absent, Canceled, or Wait List remain in this file until the registration is deleted on TR20.1 (Session Registration). TR20.1 and TR22.1 are the primary programs that update this file. TR20.1 adds records to the file. TR22.1 removes records.

Fields (18)

Column = COBOL field name without the REG- 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
#REG-COMPANY PK
COMPANY		Numeric 4Contains the company number.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
#REG-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
#REG-COURSE PK
COURSE		Alpha 10Contains the course code.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
#REG-SESSION PK
SESSION		Numeric 5Contains the session number.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
#REG-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the session start date.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
#REG-NOTIFICATION
NOTIFICATION		Alpha 1Contains a program-generated flag that indicates what type of letter to send.
  • R Registration in a Course
  • C Cancellation of a Course
  • W Wait Listed for a Course
  • X Cancellation of a registration
TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-REG-STATUS SET6
REG_STATUS		Alpha 1Indicates the employee's registration status.
  • C Confirmed; Default value.
  • W Wait Listed
  • X Canceled
  • A Absent
  • F Complete with Competencies
  • N Complete With No Competencies
  • S Partial With Competencies
  • P Partial With No Competencies
TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
#REG-WAITLIST-DATE SET4 SET5
WAITLIST_DATE		Numeric 8 (yyyymmdd)Contains the date the employee is placed on the wait list.TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-WAITLIST-TIME SET4 SET5
WAITLIST_TIME		Numeric 6 (hhmmss)Contains the time the employee is placed on the wait list.TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-REG-DATE
REG_DATE		Numeric 8 (yyyymmdd)Contains the date the employee's registration is confirmed.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-CONFIRM-ACT-DT
CONFIRM_ACT_DT		Numeric 8 (yyyymmdd)Contains a date that triggers the program to send out a registration confirmation notice.TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-REQ-FLAG SET5
REQ_FLAG		Alpha 1Indicates whether the course is required.
  • 1 Required
  • 2 Not Required
TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-OVERRIDE-FLAG
OVERRIDE_FLAG		Alpha 1Indicates whether the employee was registered using TR20.3 (Session Registration Override).
  • Y Yes
  • Blank No
  • N No
TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-APPROVAL-FLAG
APPROVAL_FLAG		Alpha 1Indicates whether course approval has been provided.
  • Y Yes
  • N No
TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-OBJ-ID SET3
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
#REG-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
#REG-USER-ID
USER_ID		Alpha 10 (Lower Case)—TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4

Indexes (6)

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
REGSET1
  1. COURSE
  2. SESSION
  3. START-DATE
  4. COMPANY
  5. EMPLOYEE
PrimaryTR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR200 +3 more
REGSET2
  1. COMPANY
  2. EMPLOYEE
  3. COURSE
  4. SESSION
  5. START-DATE
KeyChangeHR11.1, PA115, TR20.4
REGSET3
  1. OBJ-ID
  2. COMPANY
  3. EMPLOYEE
TR201
REGSET4
  1. COURSE
  2. SESSION
  3. START-DATE
  4. WAITLIST-DATE
  5. WAITLIST-TIME
  6. COMPANY
  7. EMPLOYEE
KeyChange, SubsetWhere (REG-STATUS = "W")TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
REGSET5
  1. COURSE
  2. SESSION
  3. START-DATE
  4. REQ-FLAG
  5. WAITLIST-DATE
  6. WAITLIST-TIME
  7. COMPANY
  8. EMPLOYEE
KeyChange, SubsetWhere (REG-STATUS = "W")TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
REGSET6
  1. COURSE
  2. COMPANY
  3. EMPLOYEE
  4. REG-STATUS
  5. SESSION
  6. START-DATE
KeyChangeTR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
REG-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
REG-COMPANY→EMP-COMPANY
REG-EMPLOYEE→EMP-EMPLOYEE
OptionsPAMODOPTNot Required
"1"→MOD-KEY
PaemployeePAEMPLOYEERequired
REG-COMPANY→PEM-COMPANY
REG-EMPLOYEE→PEM-EMPLOYEE
Prereq OptionsPAPREPROPTNot Required
REG-COURSE→PQO-COURSE
SessionPASESSIONRequired
REG-COURSE→SES-COURSE
REG-SESSION→SES-SESSION
REG-START-DATE→SES-START-DATE

One to many (5) — child tables

RelationTableRulesConditionField map
CoursePACOURSE
REG-COURSE→CRS-COURSE
—→CRS-EFFECTIVE-DATE
EmptrackPAEMPTRACK
REG-COMPANY→ETR-COMPANY
REG-EMPLOYEE→ETR-EMPLOYEE
—→ETR-TYPE
—→ETR-TRACK
PrerequisitesPAPREREQ
REG-COURSE→RQS-COURSE
—→RQS-PREREQ-TYPE
—→RQS-PREREQUISITE
—→RQS-COMPANY
Session InstrPAINSTSES
REG-COURSE→ISE-COURSE
REG-SESSION→ISE-SESSION
REG-START-DATE→ISE-START-DATE
—→ISE-INSTR-TYPE
—→ISE-INSTRUCT
TrainingPATRNHIST
REG-COMPANY→TRH-COMPANY
REG-EMPLOYEE→TRH-EMPLOYEE
REG-COURSE→TRH-COURSE
—→TRH-DATE-COMPLETED

Programs

Updated by (10)

Referenced by (4)