vrpt_TechnicianPositionHistory

Updated January 20, 2026 15:42

Field Name	Field Description	Data Type	FK Join
emp_code	Employment Type Code	nvarchar
emp_description	Employment Type Description	nvarchar
Id	Technician Position History Id	int
pos_code	Position Code	nvarchar
pos_description	Position Description	nvarchar
posh_basesalary	Technician Position History Base Salary	decimal
posh_comment	Technician Position History Comment	nvarchar
posh_createdDate	Record Creation Date	datetime
posh_creator_fk	User Id (Record Creator)	int	vr_users
posh_curr_fk	Currency Id	int	vrpt_Currency
posh_effectivedate	Technician Position History Effective Date	datetime
posh_emp_fk	Technician Position History Employment Type Id	int
posh_exch_date	Currency Exchange Date	datetime
posh_exch_fk	Currency Exchange Id	int
posh_modifiedDate	Last Modified Date	datetime
posh_modifier_fk	User Id (Record Modifier)	int	vr_users
posh_payrate	Technician Position History Payrate	decimal
posh_pk	Technician Position History Id	int
posh_pos_fk	Position Id	int	vr_Position
posh_wk_fk	Technician Id	int	vrpt_Technician