HR_ADA_MSTR (HR2ADA01)

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

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

Display Name: HR_ADA_MSTR
Physical Name: HR2ADA01
Technical Name: HR_ADA_MSTR

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
2REPORTSTO_I SearchReports ToSTR6_Payroll_CodeString86
3CHANGEDATE_I SearchChange DateDTDate48
4USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['HR_ADA_MSTR'].USERID AS 'HR_ADA_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       HR2ADA01 AS ['HR_ADA_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['HR_ADA_MSTR'].USERID = ['Users Master'].USERID
5SIT_I SearchSitGB_IInteger20
6STAND_I SearchStandGB_IInteger20
7WALK_I SearchWalkGB_IInteger20
8HEIGHT_I SearchHeightSTR4_IString64
9BALANCEGB_I SearchBalance GBGBInteger20
10BENDGB_I SearchBend GBGBInteger20
11CLIMBGB_I SearchClimb GBGBInteger20
12CRAWLGB_I SearchCrawl GBGBInteger20
13CROUCHGB_I SearchCrouch GBGBInteger20
14KNEELGB_I SearchKneel GBGBInteger20
15PUSHGB_I SearchPush GBGBInteger20
16REACHGB_I SearchReach GBGBInteger20
17SQUATGB_I SearchSquat GBGBInteger20
18CARRYGB_I_1 SearchCarry GB[1]GBInteger20
19CARRYGB_I_2 SearchCarry GB[2]GBInteger20
20CARRYGB_I_3 SearchCarry GB[3]GBInteger20
21CARRYGB_I_4 SearchCarry GB[4]GBInteger20
22CARRYGB_I_5 SearchCarry GB[5]GBInteger20
23CARRYGB_I_6 SearchCarry GB[6]GBInteger20
24LIFTGB_I_1 SearchLift GB[1]GBInteger20
25LIFTGB_I_2 SearchLift GB[2]GBInteger20
26LIFTGB_I_3 SearchLift GB[3]GBInteger20
27LIFTGB_I_4 SearchLift GB[4]GBInteger20
28LIFTGB_I_5 SearchLift GB[5]GBInteger20
29LIFTGB_I_6 SearchLift GB[6]GBInteger20
30RFOOTGB_I SearchRFoot GBGBInteger20
31LFOOTGB_I SearchLFoot GBGBInteger20
32RHANDGB_I_1 SearchRHand GB[1]GBInteger20
33RHANDGB_I_2 SearchRHand GB[2]GBInteger20
34RHANDGB_I_3 SearchRHand GB[3]GBInteger20
35LHANDGB_I_1 SearchLHand GB[1]GBInteger20
36LHANDGB_I_2 SearchLHand GB[2]GBInteger20
37LHANDGB_I_3 SearchLHand GB[3]GBInteger20
38DANGERGB_I_1 SearchDanger GB[1]GBInteger20
39DANGERGB_I_2 SearchDanger GB[2]GBInteger20
40DANGERGB_I_3 SearchDanger GB[3]GBInteger20
41DANGERGB_I_4 SearchDanger GB[4]GBInteger20
42DANGERGB_I_5 SearchDanger GB[5]GBInteger20
43CMNTS1_I SearchCmnts1STR30_I0String3230
44CMNTS2_I SearchCmnts2STR30_I0String3230
45CMNTS3_I SearchCmnts3STR30_I0String3230
46CMNTS4_I SearchCmnts4STR30_I0String3230
47CMNTS5_I SearchCmnts5STR30_I0String3230
48EMPREPRESENT_I SearchEmployer RepresentativeSTR30_I0String3230
49TITLE0_I SearchTitle0STR20String2220
50IDATE_I SearchIDateDTDate48
51JOBPURPOSE_I SearchJob PurposeTXT1000Text21000
52DEX_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 *