HR_ADA_MSTR (HR2ADA01)

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

Product: Human Resources (414)
Series:

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 CodeStringSTR6_Payroll_Code6
2REPORTSTO_I SearchReports ToStringSTR6_Payroll_Code6
3CHANGEDATE_I SearchChange DateDateDT8
4USERID SearchUser IDStringSTR15_User_ID15
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 SearchSitIntegerGB_I0
6STAND_I SearchStandIntegerGB_I0
7WALK_I SearchWalkIntegerGB_I0
8HEIGHT_I SearchHeightStringSTR4_I4
9BALANCEGB_I SearchBalance GBIntegerGB0
10BENDGB_I SearchBend GBIntegerGB0
11CLIMBGB_I SearchClimb GBIntegerGB0
12CRAWLGB_I SearchCrawl GBIntegerGB0
13CROUCHGB_I SearchCrouch GBIntegerGB0
14KNEELGB_I SearchKneel GBIntegerGB0
15PUSHGB_I SearchPush GBIntegerGB0
16REACHGB_I SearchReach GBIntegerGB0
17SQUATGB_I SearchSquat GBIntegerGB0
18CARRYGB_I_1 SearchCarry GB[1]IntegerGB0
19CARRYGB_I_2 SearchCarry GB[2]IntegerGB0
20CARRYGB_I_3 SearchCarry GB[3]IntegerGB0
21CARRYGB_I_4 SearchCarry GB[4]IntegerGB0
22CARRYGB_I_5 SearchCarry GB[5]IntegerGB0
23CARRYGB_I_6 SearchCarry GB[6]IntegerGB0
24LIFTGB_I_1 SearchLift GB[1]IntegerGB0
25LIFTGB_I_2 SearchLift GB[2]IntegerGB0
26LIFTGB_I_3 SearchLift GB[3]IntegerGB0
27LIFTGB_I_4 SearchLift GB[4]IntegerGB0
28LIFTGB_I_5 SearchLift GB[5]IntegerGB0
29LIFTGB_I_6 SearchLift GB[6]IntegerGB0
30RFOOTGB_I SearchRFoot GBIntegerGB0
31LFOOTGB_I SearchLFoot GBIntegerGB0
32RHANDGB_I_1 SearchRHand GB[1]IntegerGB0
33RHANDGB_I_2 SearchRHand GB[2]IntegerGB0
34RHANDGB_I_3 SearchRHand GB[3]IntegerGB0
35LHANDGB_I_1 SearchLHand GB[1]IntegerGB0
36LHANDGB_I_2 SearchLHand GB[2]IntegerGB0
37LHANDGB_I_3 SearchLHand GB[3]IntegerGB0
38DANGERGB_I_1 SearchDanger GB[1]IntegerGB0
39DANGERGB_I_2 SearchDanger GB[2]IntegerGB0
40DANGERGB_I_3 SearchDanger GB[3]IntegerGB0
41DANGERGB_I_4 SearchDanger GB[4]IntegerGB0
42DANGERGB_I_5 SearchDanger GB[5]IntegerGB0
43CMNTS1_I SearchCmnts1StringSTR30_I030
44CMNTS2_I SearchCmnts2StringSTR30_I030
45CMNTS3_I SearchCmnts3StringSTR30_I030
46CMNTS4_I SearchCmnts4StringSTR30_I030
47CMNTS5_I SearchCmnts5StringSTR30_I030
48EMPREPRESENT_I SearchEmployer RepresentativeStringSTR30_I030
49TITLE0_I SearchTitle0StringSTR2020
50IDATE_I SearchIDateDateDT8
51JOBPURPOSE_I SearchJob PurposeTextTXT10001000

Leave a Reply

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