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 |
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. |
|
||||||||
REG-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|
||||||||
REG-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||||||||
REG-SESSION Element: Session | Numeric 5 Contains the session number. |
|
||||||||
REG-START-DATE Element: Session Start Date | Numeric 8 (yyyymmdd) Contains the session start date. |
|
||||||||
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 |
|
||||||||
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 |
|
||||||||
REG-WAITLIST-DATE Element: Wait List Date | Numeric 8 (yyyymmdd) Contains the date the employee is placed on the wait list. |
|
||||||||
REG-WAITLIST-TIME Element: Wait List Time | Numeric 6 (hhmmss) Contains the time the employee is placed on the wait list. |
|
||||||||
REG-REG-DATE Element: Registration Date | Numeric 8 (yyyymmdd) Contains the date the employee's registration is confirmed. |
|
||||||||
REG-CONFIRM-ACT-DT Element: Confirmation Date | Numeric 8 (yyyymmdd) Contains a date that triggers the program to send out a registration confirmation notice. |
|
||||||||
REG-REQ-FLAG Element: Required | Alpha 1 Indicates whether the course is required. 1 = Required 2 = Not Required |
|
||||||||
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 |
|
||||||||
REG-APPROVAL-FLAG Element: Approval | Alpha 1 Indicates whether course approval has been provided. Y = Yes N = No |
|
||||||||
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. |
|
||||||||
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. |
|
||||||||
REG-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||
REG-USER-ID Element: User | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
REGSET1 |
COURSE SESSION START-DATE COMPANY EMPLOYEE |
|
| ||||||||||||||||||
REGSET2 |
COMPANY EMPLOYEE COURSE SESSION START-DATE |
|
| ||||||||||||||||||
REGSET3 |
OBJ-ID COMPANY EMPLOYEE |
|
| ||||||||||||||||||
REGSET4 |
COURSE SESSION START-DATE WAITLIST-DATE WAITLIST-TIME COMPANY EMPLOYEE |
|
| ||||||||||||||||||
REGSET5 |
COURSE SESSION START-DATE REQ-FLAG WAITLIST-DATE WAITLIST-TIME COMPANY EMPLOYEE |
|
| ||||||||||||||||||
REGSET6 |
COURSE COMPANY EMPLOYEE REG-STATUS SESSION START-DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||
Employee | EMPLOYEE |
Required
| |||||||||
Options | PAMODOPT |
Not Required
| |||||||||
Paemployee | PAEMPLOYEE |
Required
| |||||||||
Prereq Options | PAPREPROPT |
Not Required
| |||||||||
Session | PASESSION |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
| |||||||||||||||
Emptrack | PAEMPTRACK |
| |||||||||||||||
Prerequisites | PAPREREQ |
| |||||||||||||||
Session Instr | PAINSTSES |
| |||||||||||||||
Training | PATRNHIST |
|
All trademarks and registered trademarks are the property of their
respective owners.