Archive_HR_Termination_V2 (TEA24230)

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

Display Name: Archive_HR_Termination_V2
Physical Name: TEA24230
Technical Name: Archive_HR_Termination_V2

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	String	STR15_Employee_ID_I	15
2	TERMINATIONDATE_I	Termination Date	Date	DT	8
3	TERMINATED_I	Terminated	Boolean	CB	0
4	TERMSETUPCODE_I	Termination Setup Code	String	STR30_I0	30
5	TERMSETUPNAME_I	Termination Setup Name	String	STR30_I0	30
6	DATEIN_I	Date In	Date	DT	8
7	DATEOUT_I	Date Out	Date	DT	8
8	CLOSEDBY_I	Closed By	String	STR30	30
9	DATEOFLASTCHANGE_I	Date OF Last Change	Date	DT	8
10	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Archive_HR_Termination_V2'].USERID AS 'Archive_HR_Termination_V2-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM TEA24230 AS ['Archive_HR_Termination_V2'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Archive_HR_Termination_V2'].USERID = ['Users Master'].USERID
11	EXITINTERVIEWDATE_I	Exit Interview Date	Date	DT	8
12	REHIRE_I	Rehire	Boolean	CB_Rehire	0
13	NOTESINDEX_I	Notes Index	Currency	DOLLAR	0
14	NOTESINDEX2_I	Notes Index2	Currency	DOLLAR	0