Archive_HRP_Salary_History (AHPSLH01)

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

Display Name: Archive_HRP_Salary_History
Physical Name: AHPSLH01
Technical Name: Archive_HRP_Salary_History

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	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	PAYRCORD	Pay Record	String	STR6_Payroll_Code	6
3	EFFECTIVEDATE_I	Effective Date0	Date	DT	8
4	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
5	PAYRTAMT	Pay Rate Amount	Currency	DLR11_$S2	14
6	PAYUNIT	Pay Unit	String	STR25	25
7	PAYUNPER	Pay Unit Period	Integer	DDL_Pay_Periods	0
8	PAYPEROD	Pay Period	Integer	DDL_Pay_Periods	0
9	PAYPRPRD	Pay Per Period	Currency	DLR11_$S2	14
10	ANNUALSALARY_I	Annual Salary	Currency	DLR14_Salary	14
11	CHANGEREASON_I	Change Reason	String	STR30_I	30
12	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Archive_HRP_Salary_History'].USERID AS 'Archive_HRP_Salary_History-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM AHPSLH01 AS ['Archive_HRP_Salary_History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Archive_HRP_Salary_History'].USERID = ['Users Master'].USERID
13	CHANGEDATE_I	Change Date	Date	DT	8