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 TypeLength
1POSITIONCODE_I SearchPosition CodeSTR6_Payroll_CodeString6
2REPORTSTO_I SearchReports ToSTR6_Payroll_CodeString6
3CHANGEDATE_I SearchChange DateDTDate8
4USERID SearchUser IDSTR15_User_IDString15
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_IInteger0
6STAND_I SearchStandGB_IInteger0
7WALK_I SearchWalkGB_IInteger0
8HEIGHT_I SearchHeightSTR4_IString4
9BALANCEGB_I SearchBalance GBGBInteger0
10BENDGB_I SearchBend GBGBInteger0
11CLIMBGB_I SearchClimb GBGBInteger0
12CRAWLGB_I SearchCrawl GBGBInteger0
13CROUCHGB_I SearchCrouch GBGBInteger0
14KNEELGB_I SearchKneel GBGBInteger0
15PUSHGB_I SearchPush GBGBInteger0
16REACHGB_I SearchReach GBGBInteger0
17SQUATGB_I SearchSquat GBGBInteger0
18CARRYGB_I_1 SearchCarry GB[1]GBInteger0
19CARRYGB_I_2 SearchCarry GB[2]GBInteger0
20CARRYGB_I_3 SearchCarry GB[3]GBInteger0
21CARRYGB_I_4 SearchCarry GB[4]GBInteger0
22CARRYGB_I_5 SearchCarry GB[5]GBInteger0
23CARRYGB_I_6 SearchCarry GB[6]GBInteger0
24LIFTGB_I_1 SearchLift GB[1]GBInteger0
25LIFTGB_I_2 SearchLift GB[2]GBInteger0
26LIFTGB_I_3 SearchLift GB[3]GBInteger0
27LIFTGB_I_4 SearchLift GB[4]GBInteger0
28LIFTGB_I_5 SearchLift GB[5]GBInteger0
29LIFTGB_I_6 SearchLift GB[6]GBInteger0
30RFOOTGB_I SearchRFoot GBGBInteger0
31LFOOTGB_I SearchLFoot GBGBInteger0
32RHANDGB_I_1 SearchRHand GB[1]GBInteger0
33RHANDGB_I_2 SearchRHand GB[2]GBInteger0
34RHANDGB_I_3 SearchRHand GB[3]GBInteger0
35LHANDGB_I_1 SearchLHand GB[1]GBInteger0
36LHANDGB_I_2 SearchLHand GB[2]GBInteger0
37LHANDGB_I_3 SearchLHand GB[3]GBInteger0
38DANGERGB_I_1 SearchDanger GB[1]GBInteger0
39DANGERGB_I_2 SearchDanger GB[2]GBInteger0
40DANGERGB_I_3 SearchDanger GB[3]GBInteger0
41DANGERGB_I_4 SearchDanger GB[4]GBInteger0
42DANGERGB_I_5 SearchDanger GB[5]GBInteger0
43CMNTS1_I SearchCmnts1STR30_I0String30
44CMNTS2_I SearchCmnts2STR30_I0String30
45CMNTS3_I SearchCmnts3STR30_I0String30
46CMNTS4_I SearchCmnts4STR30_I0String30
47CMNTS5_I SearchCmnts5STR30_I0String30
48EMPREPRESENT_I SearchEmployer RepresentativeSTR30_I0String30
49TITLE0_I SearchTitle0STR20String20
50IDATE_I SearchIDateDTDate8
51JOBPURPOSE_I SearchJob PurposeTXT1000Text1000
52DEX_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.

Leave a Reply

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