HRMS Employee Self Service displays the Training group in the Available field when you select Personnel in the Data Source field on the Select Fields tab of the View Builder.
The following table shows the fields available in the Training group, including the Courses Taken and Required Courses subgroups.
| Description | Field Name | Associated Database Column | Data Type |
|---|---|---|---|
| First Name | EmployeeFirstName | Ste.nemphist.firstname | String |
| Last Name | EmployeeLastName | Ste.nemphist.lastname | String |
| Company Code | CompanyCode | Ste.nemphist.company | String |
| Course Code | CourseCode | Ste.nemphist.course | String |
| Course Description | N/A | N/A | String |
| Course Type Code | CourseTypeCode | Ste.nemphist.coursetype | String |
| Course Type Description | N/A | N/A | String |
| Certification Code | CertificationCode | Ste.nemphist.certcode | String |
| Certification Description | N/A | N/A | String |
| Enrollment Status Code | EnrollmentStatusCode | Ste.nemphist.enrstat | String |
| Enrollment Status Description | N/A | N/A | String |
| Job Requirement Code | JobRequirementCode | Ste.nemphist.jobrelcode | String |
| Credits | Credits | Ste.nemphist.credits | System.Decimal |
| CEU | CEUs | Ste.nemphist.ceu | System.Decimal |
| Job Related | JobRelatedCourse | Ste.nemphist.jobrel | String |
| Grade | Grade | Ste.nemphist.grade | String |
| Start Date | StartDate | Ste.nemphist.startdate | System.DateTime |
| End Date | EndDate | Ste.nemphist.enddate | System.DateTime |
| Total Sessions | Duration | Ste.nemphist.duration | Int |
| Start Time | StartTime | Ste.nemphist.starttime | String |
| End Time | EndTime | Ste.nemphist.endtime | String |
| Hours | Hours | Ste.nemphist.hours | System.Decimal |
| Instructor Code | InstructorCode | Ste.nemphist.instrcode | String |
| Instructor Description | N/A | N/A | String |
| Days Required | DaysOfWeek | Ste.nemphist.daysofweek | String |
| Course Code | CourseCode | Ste.nemprequ.course | String |
| Course Description | N/A | N/A | String |
| Priority | Priority | Ste.nemprequ.priority | String |
| Company Code | CompanyCode | Ste.nemprequ.company | String |
| Employee ID | EmpID | Ste.nemprequ.empno | String |