PAREGISTER FILE
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
UPDATED BY
TR04.1 TR120 TR121 TR20.1 TR20.2 TR20.3
TR22.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REG-COMPANY Numeric 4 TR120 TR121
Compnay Contains the company number. TR20.1 TR20.2
TR20.3 TR22.1
REG-EMPLOYEE Numeric 9 TR120 TR121
Employee Contains the employee number. TR20.1 TR20.2
TR20.3 TR22.1
REG-COURSE Alpha 10 TR120 TR121
Course Code Contains the course code. TR20.1 TR20.2
TR20.3 TR22.1
REG-SESSION Numeric 5 TR120 TR121
Session Contains the session number. TR20.1 TR20.2
TR20.3 TR22.1
REG-START-DATE Numeric 8 (yyyymmdd) TR120 TR121
Session Start Date Contains the session start date. TR20.1 TR20.2
TR20.3 TR22.1
REG-NOTIFICATION Alpha 1 TR04.1 TR120
Notification Contains a program-generated flag that TR121 TR20.1
indicates what type of letter to send. TR20.2 TR20.3
R = Registration in a Course
C = Cancellation of a Course
W = Wait Listed for a Course
X = Cancellation of a registration
REG-REG-STATUS Alpha 1 TR04.1 TR120
Registration Status Indicates the employee's registration TR121 TR20.1
status. TR20.2 TR20.3
C = Confirmed; Default value. TR22.1
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
REG-WAITLIST-DATE Numeric 8 (yyyymmdd) TR04.1 TR120
Wait List Date Contains the date the employee is TR121 TR20.1
placed on the wait list. TR20.2 TR20.3
REG-WAITLIST-TIME Numeric 6 (hhmmss) TR04.1 TR120
Wait List Time Contains the time the employee is TR121 TR20.1
placed on the wait list. TR20.2 TR20.3
REG-REG-DATE Numeric 8 (yyyymmdd) TR04.1 TR120
Registration Date Contains the date the employee's TR121 TR20.1
registration is confirmed. TR20.2 TR20.3
REG-CONFIRM-ACT-DT Numeric 8 (yyyymmdd) TR04.1 TR120
Confirmation Date Contains a date that triggers the TR121 TR20.1
program to send out a registration TR20.2 TR20.3
confirmation notice.
REG-REQ-FLAG Alpha 1 TR120 TR121
Required Indicates whether the course is TR20.1 TR20.2
required. TR20.3
1 = Required
2 = Not Required
REG-OVERRIDE-FLAG Alpha 1 TR120 TR121
Override Indicates whether the employee was TR20.1 TR20.2
registered using TR20.3 (Session TR20.3
Registration Override).
Y = Yes
Blank = No
N = No
REG-APPROVAL-FLAG Alpha 1 TR120 TR121
Approval Indicates whether course approval has TR20.1 TR20.2
been provided. TR20.3
Y = Yes
N = No
REG-OBJ-ID Numeric 12 TR120 TR121
Object This is the object identifier. It is TR20.1 TR20.2
Identification used to relate commitments or posted TR20.3 TR22.1
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.
REG-DATE-STAMP Numeric 8 (yyyymmdd) TR04.1 TR120
Date Stamp This field contains the server date TR121 TR20.1
(month, date, and year) of the last TR20.2 TR20.3
change to this record.
REG-TIME-STAMP Numeric 6 (hhmmss) TR04.1 TR120
Time Stamp Contains the server time (hour, minute, TR121 TR20.1
and second) when the record was last TR20.2 TR20.3
changed.
REG-USER-ID Alpha 10 (Lower Case) TR04.1 TR120
User ID Name Contains the user ID of the person who TR121 TR20.1
last changed this record. TR20.2 TR20.3
PAREGISTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REGSET1 COURSE TR04.1 TR120
SESSION TR121 TR20.1
START-DATE TR20.2 TR20.3
COMPANY TR200 TR22.1
EMPLOYEE TR220 TR221
REGSET2 COMPANY KeyChange
EMPLOYEE
COURSE
SESSION
START-DATE
REGSET3 OBJ-ID
COMPANY
EMPLOYEE
REGSET4 COURSE KeyChange, Subset TR04.1 TR120
SESSION Where (REG-STATUS = "W" ) TR121 TR20.1
START-DATE TR20.2 TR20.3
WAITLIST-DATE
WAITLIST-TIME
COMPANY
EMPLOYEE
REGSET5 COURSE KeyChange, Subset TR04.1 TR120
SESSION Where (REG-STATUS = "W" ) TR121 TR20.1
START-DATE TR20.2 TR20.3
REQ-FLAG
WAITLIST-DATE
WAITLIST-TIME
COMPANY
EMPLOYEE
REGSET6 COURSE KeyChange TR04.1 TR120
COMPANY TR121 TR20.1
EMPLOYEE TR20.2 TR20.3
REG-STATUS
SESSION
START-DATE
PAREGISTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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 RELATED
NAME 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
|