HR_Position2_Extra (HRPOS022)

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

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

Display Name: HR_Position2_Extra
Physical Name: HRPOS022
Technical Name: HR_Position2_Extra

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1POSITIONCODE_I SearchPosition CodeSTR6_Payroll_CodeString86
2DATES_I_1 SearchDates[1]DTDate48
3DATES_I_2 SearchDates[2]DTDate48
4DATES_I_3 SearchDates[3]DTDate48
5DATES_I_4 SearchDates[4]DTDate48
6DATES_I_5 SearchDates[5]DTDate48
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.

Leave a Reply

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