EHW Injury and Illness Detail Header (EHW20100)

azurecurveProductsEmployee Health and Wellness (4955)3rd PartyEHW Injury and Illness Detail Header (EHW20100)

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

Product: Employee Health and Wellness (4955)
Series:

Display Name: EHW Injury and Illness Detail Header
Physical Name: EHW20100
Technical Name: EHW_Case_HDR

Group Display Name: Employee Health & Wellness
Group Technical Name: EHW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2EHW_Case_Number SearchEHW Case NumberStringSTR1010
3EHW_Source_ID SearchEHW Source IDStringSTR15_Employee_ID15
4CHANGEBY_I SearchChange ByStringSTR15_User_ID15
5CHANGEDATE_I SearchChange DateDateDT8
6NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['EHW Injury and Illness Detail Header'].NOTEINDX AS 'EHW Injury and Illness Detail Header-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EHW20100 AS ['EHW Injury and Illness Detail Header']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['EHW Injury and Illness Detail Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX
azurecurveProductsEmployee Health and Wellness (4955)3rd PartyEHW Injury and Illness Detail Header (EHW20100)

Leave a Reply

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