Summary

Some tables and fields have been renamed for SQL platform compatibility reasons. In particular,

• Table names over 28 characters have been shortened.
• Table names that use words that are reserved SQL words (Level, Resource, Union, and Key) have been renamed. 'Position' table has not been renamed.
• Some fields that were poorly named for SQL use, such as Union field, were renamed.
• Fields that were over 30 characters long were renamed (in Company Settings table, and due to long table names)

Effects on your database

Grid layouts for renamed tables are lost.

Renamed tables

Key

Level

Resource

Union

CourseResource

CourseTypeResource

InternalCompanyPayrollRuleMku

HistoricalProportionalCosting

BackpayHistoricalAllowanceMku

AdvertisementClassificationRecruitment

CentreAdvertisementPlacement

CourseEmployeeLearningOutcome

ApplicantProfessionalMembership

EmployeeProfessionalMembership

PanelMemberRCApplicantQAssessment

RecruitmentCentreApplicantAction

RecruitmentCentreApplicantQQuestion

RecruitmentCentreApplicantTest

RecruitmentQRecruitmentQuestion

TrainingModuleAssessmentFactor