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 TypeLength
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString15
2DATE1_I SearchDate1DTDate8
3DATE2_I SearchDate2DTDate8
4DATE3_I SearchDate3DTDate8
5DATE4_I SearchDate4DTDate8
6DATE5_I SearchDate5DTDate8
7STRINGS_I_1 SearchStrings[1]STR30_I0String30
8STRINGS_I_2 SearchStrings[2]STR30_I0String30
9STRINGS_I_3 SearchStrings[3]STR30_I0String30
10STRINGS_I_4 SearchStrings[4]STR30_I0String30
11STRINGS_I_5 SearchStrings[5]STR30_I0String30
12NUMERICEXTRA_1 SearchNumericExtra[1]LI5_NoFormatLong Integer5
13NUMERICEXTRA_2 SearchNumericExtra[2]LI5_NoFormatLong Integer5
14NUMERICEXTRA_3 SearchNumericExtra[3]LI5_NoFormatLong Integer5
15NUMERICEXTRA_4 SearchNumericExtra[4]LI5_NoFormatLong Integer5
16NUMERICEXTRA_5 SearchNumericExtra[5]LI5_NoFormatLong Integer5
17DOLLARS_I_1 SearchDollars[1]DLR14Currency14
18DOLLARS_I_2 SearchDollars[2]DLR14Currency14
19DOLLARS_I_3 SearchDollars[3]DLR14Currency14
20DOLLARS_I_4 SearchDollars[4]DLR14Currency14
21DOLLARS_I_5 SearchDollars[5]DLR14Currency14
22CHECKBOXES_I_1 SearchCheckboxes[1]CBBoolean0
23CHECKBOXES_I_2 SearchCheckboxes[2]CBBoolean0
24CHECKBOXES_I_3 SearchCheckboxes[3]CBBoolean0
25CHECKBOXES_I_4 SearchCheckboxes[4]CBBoolean0
26CHECKBOXES_I_5 SearchCheckboxes[5]CBBoolean0
27NOTESINDEX_I SearchNotes IndexDOLLARCurrency0
28CHANGEBY_I SearchChange BySTR15_User_IDString15
29CHANGEDATE_I SearchChange DateDTDate8
30DEX_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 PartyArchive_HR_Employee_Extra (AEX10130)

Leave a Reply

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