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.

Field / column	Type	Description & values	Updated by
`REG-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
`REG-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
`REG-COURSE` PK COURSE	Alpha 10	Contains the course code.	TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR22.1
`REG-SESSION` PK SESSION	Numeric 5	Contains 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 1	Contains 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` REG_STATUS	Alpha 1	Indicates 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` 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` 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` REQ_FLAG	Alpha 1	Indicates 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 1	Indicates 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 1	Indicates whether course approval has been provided. `Y` Yes `N` No	TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
`REG-OBJ-ID` OBJ_ID	Numeric 12	This 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`REGSET1`	`COURSE`, `SESSION`, `START-DATE`, `COMPANY`, `EMPLOYEE`	Primary		TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR200 +3 more
`REGSET2`	`COMPANY`, `EMPLOYEE`, `COURSE`, `SESSION`, `START-DATE`	KeyChange		HR11.1, PA115, TR20.4
`REGSET3`	`OBJ-ID`, `COMPANY`, `EMPLOYEE`			TR201
`REGSET4`	`COURSE`, `SESSION`, `START-DATE`, `WAITLIST-DATE`, `WAITLIST-TIME`, `COMPANY`, `EMPLOYEE`	KeyChange, Subset	Where (REG-STATUS = "W")	TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
`REGSET5`	`COURSE`, `SESSION`, `START-DATE`, `REQ-FLAG`, `WAITLIST-DATE`, `WAITLIST-TIME`, `COMPANY`, `EMPLOYEE`	KeyChange, Subset	Where (REG-STATUS = "W")	TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
`REGSET6`	`COURSE`, `COMPANY`, `EMPLOYEE`, `REG-STATUS`, `SESSION`, `START-DATE`	KeyChange		TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`REG-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`REG-COMPANY` → `EMP-COMPANY`, `REG-EMPLOYEE` → `EMP-EMPLOYEE`
Options	PAMODOPT	Not Required	`"1"` → `MOD-KEY`
Paemployee	PAEMPLOYEE	Required	`REG-COMPANY` → `PEM-COMPANY`, `REG-EMPLOYEE` → `PEM-EMPLOYEE`
Prereq Options	PAPREPROPT	Not Required	`REG-COURSE` → `PQO-COURSE`
Session	PASESSION	Required	`REG-COURSE` → `SES-COURSE`, `REG-SESSION` → `SES-SESSION`, `REG-START-DATE` → `SES-START-DATE`

One to many (5) — child tables

Relation	Table	Field map
Course	PACOURSE	`REG-COURSE` → `CRS-COURSE`, → `CRS-EFFECTIVE-DATE`
Emptrack	PAEMPTRACK	`REG-COMPANY` → `ETR-COMPANY`, `REG-EMPLOYEE` → `ETR-EMPLOYEE`, → `ETR-TYPE`, → `ETR-TRACK`
Prerequisites	PAPREREQ	`REG-COURSE` → `RQS-COURSE`, → `RQS-PREREQ-TYPE`, → `RQS-PREREQUISITE`, → `RQS-COMPANY`
Session Instr	PAINSTSES	`REG-COURSE` → `ISE-COURSE`, `REG-SESSION` → `ISE-SESSION`, `REG-START-DATE` → `ISE-START-DATE`, → `ISE-INSTR-TYPE`, → `ISE-INSTRUCT`
Training	PATRNHIST	`REG-COMPANY` → `TRH-COMPANY`, `REG-EMPLOYEE` → `TRH-EMPLOYEE`, `REG-COURSE` → `TRH-COURSE`, → `TRH-DATE-COMPLETED`

Programs

Updated by (10)

HR11.1 Employee
PA115 Employee Purge
TR04.1 Session
TR120 Group Session Registration
TR121 Job Code Session Registration
TR20.1 Session Registration
TR20.2 Mass Registration
TR20.3 Session Registration Override
TR20.4 Employee Session Registration
TR22.1 Session Completion

Referenced by (4)

TR200 Notification Letter Extract
TR201 Course Profile
TR220 Session Roster
TR221 Session Wait List Listing