PAREGISTER

Registration Information

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.

REFERENCED BY
TR200 TR220 TR221 TR201


UPDATED BY
TR04.1 TR120 TR121 TR20.1 TR20.2 TR20.3
TR20.4 TR22.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REG-COMPANY
Element: Compnay		Numeric 4
Contains the company number.
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR22.1
REG-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR22.1
REG-COURSE
Element: Course Code		Alpha 10
Contains the course code.
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR22.1
REG-SESSION
Element: Session		Numeric 5
Contains the session number.
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR22.1
REG-START-DATE
Element: Session Start Date		Numeric 8 (yyyymmdd)
Contains the session start date.
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR22.1
REG-NOTIFICATION
Element: 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
Element: Registration 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
Element: Wait List 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
Element: Wait List 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
Element: Registration 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
Element: Confirmation Date		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
Element: Required		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
Element: Override		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
Element: Approval		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
Element: 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
Element: 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
Element: 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
Element: User		Alpha 10 (Lower Case)
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4


PAREGISTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REGSET1 COURSE
SESSION
START-DATE
COMPANY
EMPLOYEE
TR04.1 TR120
TR121 TR20.1
TR20.2 TR20.3
TR20.4 TR200
TR22.1 TR220
TR221
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


PAREGISTER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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


PAREGISTER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Thu Jun 09 02:25:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.