Payroll Employee History (UPR30700)

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

Display Name: Payroll Employee History
Physical Name: UPR30700
Technical Name: uprEmployeeHistory

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	CHANGEDATE_I	Change Date	Date	DT	8
3	TIME1	Time	Time	TM6	6
4	STRTDATE	Start Date	Date	DT	8
5	TERMINATIONDATE	TerminationDate	Date	DT	8
6	BENADJDATE	Ben Adj Date	Date	DT	8
7	LASTDAYWORKED_I	Last Day Worked	Date	DT	8
8	DEMPINAC	Date Employee Inactivated	Date	DT	8
9	CHANGEREASON_I	Change Reason	String	STR30_I	30
10	Reason_for_Change	Reason for Change	String	STR100	100
11	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Payroll Employee History'].NOTEINDX AS 'Payroll Employee History-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM UPR30700 AS ['Payroll Employee History'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Payroll Employee History'].NOTEINDX = ['Record Notes Master'].NOTEINDX