|
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 TR201
UPDATED BY
TR04.1 TR120 TR121 TR20.1 TR20.2 TR20.3
TR22.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REG-COMPANY Numeric 4 TR120 TR121
Element: Compnay Contains the company number. TR20.1 TR20.2
TR20.3 TR22.1
REG-EMPLOYEE Numeric 9 TR120 TR121
Element: Employee Contains the employee number. TR20.1 TR20.2
TR20.3 TR22.1
REG-COURSE Alpha 10 TR120 TR121
Element: Course Code Contains the course code. TR20.1 TR20.2
TR20.3 TR22.1
REG-SESSION Numeric 5 TR120 TR121
Element: Session Contains the session number. TR20.1 TR20.2
TR20.3 TR22.1
REG-START-DATE Numeric 8 (yyyymmdd) TR120 TR121
Element: Session Start Contains the session start date. TR20.1 TR20.2
TR20.3 TR22.1
REG-NOTIFICATION Alpha 1 TR04.1 TR120
Element: 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
Element: Registration SIndicates 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
Element: Wait List DateContains 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
Element: Wait List TimeContains the time the employee is TR121 TR20.1
placed on the wait list. TR20.2 TR20.3
REG-REG-DATE Numeric 8 (yyyymmdd) TR120 TR121
Element: Registration DContains the date the employee's TR20.1 TR20.2
registration is confirmed. TR20.3
REG-CONFIRM-ACT-DT Numeric 8 (yyyymmdd) TR04.1 TR120
Element: Confirmation DContains 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
Element: 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
Element: 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
Element: 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
Element: Obj Id This is the object identifier. It is TR20.1 TR20.2
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) TR120 TR121
Element: Date Stamp This field contains the server date TR20.1 TR20.2
(month, date, and year) of the last TR20.3
change to this record.
REG-TIME-STAMP Numeric 6 (hhmmss) TR120 TR121
Element: Time Stamp Contains the server time (hour, minute, TR20.1 TR20.2
and second) when the record was last TR20.3
changed.
REG-USER-ID Alpha 10 (Lower Case) TR120 TR121
Element: User TR20.1 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 HR11.1 PA115
EMPLOYEE
COURSE
SESSION
START-DATE
REGSET3 OBJ-ID TR201
COMPANY
EMPLOYEE
REGSET4 COURSE KeyChange, Subset TR120 TR121
SESSION Where (REG-STATUS = "W" ) TR20.1 TR20.2
START-DATE TR20.3
WAITLIST-DATE
WAITLIST-TIME
COMPANY
EMPLOYEE
REGSET5 COURSE KeyChange, Subset TR120 TR121
SESSION Where (REG-STATUS = "W" ) TR20.1 TR20.2
START-DATE TR20.3
REQ-FLAG
WAITLIST-DATE
WAITLIST-TIME
COMPANY
EMPLOYEE
REGSET6 COURSE KeyChange TR120 TR121
COMPANY TR20.1 TR20.2
EMPLOYEE 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
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 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
|