EHW Employee Code History (EHW30200)

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

Display Name: EHW Employee Code History
Physical Name: EHW30200
Technical Name: EHW_Employee_Code_HIST

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	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
4	EHW_Date_Entered	EHW Date Entered	Date	DT	8
5	EHW_Date_Renewed	EHW Date Renewed	Date	DT	8
6	EHW_Result_Code	EHW Result Code	String	STR6_U	6
7	CHANGEBY_I	Change By	String	STR15_User_ID	15
8	CHANGEDATE_I	Change Date	Date	DT	8
9	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['EHW Employee Code History'].NOTEINDX AS 'EHW Employee Code History-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM EHW30200 AS ['EHW Employee Code History'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['EHW Employee Code History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
10	INACTIVE	Inactive	Boolean	CB_Inactive	0
11	EHW_Discount	EHW Discount	Currency	DLR11_$S2	14