EHW Employee Code Master (EHW20200)

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

Display Name: EHW Employee Code Master
Physical Name: EHW20200
Technical Name: EHW_Employee_Code_MSTR

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	EHW_Code	EHW Code	String	STR6_U	6
3	EHW_Date_Entered	EHW Date Entered	Date	DT	8
4	EHW_Date_Renewed	EHW Date Renewed	Date	DT	8
5	EHW_Result_Code	EHW Result Code	String	STR6_U	6
6	CHANGEBY_I	Change By	String	STR15_User_ID	15
7	CHANGEDATE_I	Change Date	Date	DT	8
8	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['EHW Employee Code Master'].NOTEINDX AS 'EHW Employee Code Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM EHW20200 AS ['EHW Employee Code Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['EHW Employee Code Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
9	INACTIVE	Inactive	Boolean	CB_Inactive	0
10	EHW_Discount	EHW Discount	Currency	DLR11_$S2	14