Multiple_Positions_History (MPOSHIST)

azurecurveProductsHuman Resources (414)3rd PartyMultiple_Positions_History (MPOSHIST)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPOSHIST

Product: Human Resources (414)
Series: 3rd Party

Display Name: Multiple_Positions_History
Physical Name: MPOSHIST
Technical Name: Multiple_Positions_History

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString15
2CHANGEDATE_I SearchChange DateDTDate8
3CHANGETIME_I SearchChange TimeTMTime6
4CHANGEBY_I SearchChange BySTR15_User_IDString15
5POSITION_I SearchPositionSTR30_I0String30
6COMPANY_I SearchCompanySTR64_Company_NameString64
7DIVISION_I SearchDivisionSTR30String30
8DEPARTMENTNAME_I SearchDepartment NameSTR30_I0String30
9Effective_Date SearchEffective DateDTDate8
10SUPERVISOR SearchSupervisorSTR30String30
11LOCATION_I SearchLocationSTR30_I0String30
12FTE SearchFTEFTECurrency6
13REVISIONLEVEL_I SearchRevision LevelSTR12String12
14DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsHuman Resources (414)3rd PartyMultiple_Positions_History (MPOSHIST)

Leave a Reply

Your email address will not be published. Required fields are marked *