Archive_HR_Employee_Extra (AEX10130)

azurecurveProductsHuman Resources (414)3rd PartyArchive_HR_Employee_Extra (AEX10130)

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

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

Display Name: Archive_HR_Employee_Extra
Physical Name: AEX10130
Technical Name: Archive_HR_Employee_Extra

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString1615
2DATE1_I SearchDate1DTDate48
3DATE2_I SearchDate2DTDate48
4DATE3_I SearchDate3DTDate48
5DATE4_I SearchDate4DTDate48
6DATE5_I SearchDate5DTDate48
7STRINGS_I_1 SearchStrings[1]STR30_I0String3230
8STRINGS_I_2 SearchStrings[2]STR30_I0String3230
9STRINGS_I_3 SearchStrings[3]STR30_I0String3230
10STRINGS_I_4 SearchStrings[4]STR30_I0String3230
11STRINGS_I_5 SearchStrings[5]STR30_I0String3230
12NUMERICEXTRA_1 SearchNumericExtra[1]LI5_NoFormatLong Integer45
13NUMERICEXTRA_2 SearchNumericExtra[2]LI5_NoFormatLong Integer45
14NUMERICEXTRA_3 SearchNumericExtra[3]LI5_NoFormatLong Integer45
15NUMERICEXTRA_4 SearchNumericExtra[4]LI5_NoFormatLong Integer45
16NUMERICEXTRA_5 SearchNumericExtra[5]LI5_NoFormatLong Integer45
17DOLLARS_I_1 SearchDollars[1]DLR14Currency1014
18DOLLARS_I_2 SearchDollars[2]DLR14Currency1014
19DOLLARS_I_3 SearchDollars[3]DLR14Currency1014
20DOLLARS_I_4 SearchDollars[4]DLR14Currency1014
21DOLLARS_I_5 SearchDollars[5]DLR14Currency1014
22CHECKBOXES_I_1 SearchCheckboxes[1]CBBoolean20
23CHECKBOXES_I_2 SearchCheckboxes[2]CBBoolean20
24CHECKBOXES_I_3 SearchCheckboxes[3]CBBoolean20
25CHECKBOXES_I_4 SearchCheckboxes[4]CBBoolean20
26CHECKBOXES_I_5 SearchCheckboxes[5]CBBoolean20
27NOTESINDEX_I SearchNotes IndexDOLLARCurrency100
28CHANGEBY_I SearchChange BySTR15_User_IDString1615
29CHANGEDATE_I SearchChange DateDTDate48
30DEX_ROW_ID Searchintint1010

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 PartyArchive_HR_Employee_Extra (AEX10130)

Leave a Reply

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