| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| CanceledBy | Cancelled By Name | nvarchar | |
| class_AdditionalInfo | Class Additional Info | nvarchar | |
| class_closeDate | Class Close Date | datetime | |
| class_endDate | Class End Date | datetime | |
| class_estimateCost | Class Estimate Cost | decimal | |
| class_ID | Classs Unique Id | nvarchar | |
| class_interval | Class Interval | int | |
| class_interval_fk | Interval Id | int | |
| class_location | Class Location | nvarchar | |
| class_pk | Class Id | int | vrpt_ClassList |
| class_startDate | Class Start Date | datetime | |
| fullclass | Full Class | nvarchar | |
| Id | Training Assignment Id | int | |
| prg_description | Program Description | nvarchar | |
| prg_id | Program Record Id | nvarchar | |
| prg_pk | Training Program Id | int | vr_TrainingProgram |
| tassgn_canceledBy | Cancelled By | int | |
| tassgn_canceledDate | Cancelled Date | datetime | |
| tassgn_cancellationReason | Cancellation Reason | nvarchar | |
| tassgn_class_fk | Class Id | int | vrpt_ClassList |
| tassgn_closed | Indicates if the record is closed | bit | |
| tassgn_closedDate | Closed Date | datetime | |
| tassgn_createdDate | Record Creation Date | datetime | |
| tassgn_creator_fk | User Id (Record Creator) | int | vr_users |
| tassgn_endDate | End Date | datetime | |
| tassgn_expirationDate | Expiration Date | datetime | |
| tassgn_location | Location | nvarchar | |
| tassgn_modifiedDate | Last Modified Date | datetime | |
| tassgn_modifier_fk | User Id (Record Modifier) | int | vr_users |
| tassgn_pass | Pass | smallint | |
| tassgn_pk | Training Assignment Id | int | |
| tassgn_startDate | Start Date | datetime | |
| tassgn_treq_fk | Training Request Id | int | vrpt_trainingRequest |
| trainee_email | Trainee Email | nvarchar | |
| trainee_id | Trainee Record Id | nvarchar | |
| trainee_name | Trainee Name | nvarchar | |
| trainee_pk | Trainee Id | int | vrpt_Technician |
| trainer_name | Trainer Name | varchar |