Education and Skills
Introduction
All Education and Skills cards display information from the HR system. No modifications are allowed.
Courses
The Courses card displays educational courses taken along with their associated units shown on the Education and Skills (HREMES) page, Course Units tab. The Course fields map to the hr_crseunit and hr_hrcode tables in the database. Courses appear under the ALL COURSES sub-card which lists the total number of units for all courses displayed.
Course Title: Maps to Desc field (hr_crseunit.crse_desc)
Institution: Maps to Institute description field (hr_crseunit.instdesc)
Fiscal Year: Maps to Fiscal Year field (hr_crseunit.fiscalyr)
Date Completed: Maps to Course Dt field (hr_crseunit.crse_date)
Units: Maps to Units Accepted field (hr_crseunit.total_unit)
Credentials
The data for the Credential card is read from the credential module, hr_cntycred_mstr (HRCRCN). SSN is used instead of the ID to perform joins to the hr_empmstr (HREMEN) employee profile for the credential tables.
Credential Type Description (Heading): Pulled from hr_cdtptble.long_desc (HRTBCRTC).
Certificate Number: Pulled from hr_cntycred_mstr.document (HRCRCN).
Effective Begin date: Pulled from hr_cntycred_mstr.cred_beg (HRCRCN).
Effective end date: Pulled from hr_cntycred_mstr.cred_end (HRCRCN).
Endorsements: A sub-header where the values are displayed as a list and the description is pulled from hr_credtble.long_desc (HRTBCRMA).
Education
The Education card displays education history shown in the HR Education and Skills (HREMES) page, General tab. The Education fields map to the hr_educinfo table in the database.
Degree: Maps to Degree field (hr_educinfo.degree).
Institution: Maps to Institution description field (hr_educinfo.instdesc).
Graduation: Maps to Issue Date field (hr_educinfo.dateaward).
Major: Maps to Major field (hr_educinfo.major_cd).
Licenses and Certifications
The Licenses and Certifications card displays all licenses and certifications shown in the Education and Skills (HREMES) page, License/Certifications tab. The License and Certification fields map to the hr_licncert and hr_hrcode tables in the database.
License: Maps to License/Cert Type field (hr_licncert.licntype).
Expiration: Maps to Expiration Dt field (hr_licncert.expdate).
Skills
The Skills card displays skills related to education and experience shown in the Education and Skills (HREMES) page, Skills tab. The Skills fields map to the hr_empskill and hr_hrcode tables in the database.
Skill: Maps to Skill field (hr_empskill.skill).
Education: Maps to Educ field (hr_empskill.education).
Experience: Maps to Expr field (hr_empskill.experience).
Comments: Maps to Notes field (hr_empskill.skillnotes).
Tracking
The Tracking card displays all tracking items, current and expired, from the Tracking (HREMET), Supplemental Tracking tab. The Tracking fields map to the hr_emptrac table in the database. A tracking item contains the following fields:
Tracking Code and Description (Header): Entity Specific Codes where Code ID = TRACKING_CODE and the description is pulled from (HRTBCE).
Recorded Date: Maps to the Track Date field (hr_emptrac.track_date).
Expiration Date: Maps to the Expiration Date field (hr_emptrac.expr_date).
Training
The Training card displays training history shown in the Education and Skills (HREMES) page, Training tab. The Training fields map to the hr_emptrain and hr_hrcode tables in the database.
Training: Maps to Location field (hr_emptrain.train_loc).
Class Title: Maps to Training Cd field (hr_emptrain.train_type). Codes are defined in the HR Non-Entity Specific Codes (HRTBHR) page under the Code ID of TRAINING_TYPE.
Completion Date: Maps to Training Dt (hr_emptrain.train_date). If this field is empty, this label does not appear in EO.
Amount: Maps to Amount 1 field (hr_emptrain.amount1).
Tuition
The Tuition card displays educational courses taken along with their associated costs shown in the Education and Skills (HREMES) page, Tuition tab. The Tuition fields map to the hr_tuition and hr_hrcode tables in the database.
Course Title: Maps to Course Title (hr_tuition.course_ttl).
Institution: Maps to Education Institute (hr_tuition.ed_instit).
Date Completed: Maps to Course End Dt (hr_tuition.course_end).
Cost: Maps to Total Cost field (hr_tuition.total_cost).