Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPRA0112
Product: Human Resources (414)
Series:
Display Name: Payroll Master Education - Archive
Physical Name: UPRA0112
Technical Name: Archive_uprMstrEducationSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID 
Employee ID String STR15_Employee_ID 15 2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 UNIVERSITY University String STR30 30 4 DEGREE Degree String STR30 30 5 MAJOR Major String STR30 30 6 GPA GPA String STR5_GPA 5 7 GPABASE GPA Base String STR3 3 8 GRADUATIONYEAR Graduation Year String STR4 4 9 YEARS Years String STR2 2 10 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Payroll Master Education - Archive'].NOTEINDX AS 'Payroll Master Education - Archive-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
UPRA0112 AS ['Payroll Master Education - Archive']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Payroll Master Education - Archive'].NOTEINDX = ['Record Notes Master'].NOTEINDX11 CHANGEBY_I Change By String STR15_User_ID 15 12 CHANGEDATE_I Change Date Date DT 8