HR_Train_Employee (HR2TRA04)

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

Display Name: HR_Train_Employee
Physical Name: HR2TRA04
Technical Name: HR_Train_Employee

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPID_I	Emp ID	STR15_Employee_ID_I	String	15
2	EMPID_I	Emp ID	STR15_Employee_ID	String	15
3	COURSEID_I	Course ID	STR6_U0	String	6
4	ICLASSID_I	IClass ID	STR6_U0	String	6
5	CB_I	CB	CB	Boolean	0
6	DATE1	Date	DT6	Date	6
7	STR20DUMMY_I	STR20 Dummy	STR20	String	20
8	CHANGEDATE_I	Change Date	DT	Date	8
9	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['HR_Train_Employee'].USERID AS 'HR_Train_Employee-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM HR2TRA04 AS ['HR_Train_Employee'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['HR_Train_Employee'].USERID = ['Users Master'].USERID
10	NOTESINDEX_I	Notes Index	DOLLAR	Currency	0
11	DEX_ROW_ID		int	int	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.