APR Department Ben Accrual TEMP (APR_APR70530)

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

Display Name: APR Department Ben Accrual TEMP
Physical Name: APR_APR70530
Technical Name: APR_DepartmentBenAccrual_TEMP

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['APR Department Ben Accrual TEMP'].USERID AS 'APR Department Ben Accrual TEMP-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM APR_APR70530 AS ['APR Department Ben Accrual TEMP'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['APR Department Ben Accrual TEMP'].USERID = ['Users Master'].USERID
2	CHEKNMBR	Check Number	String	STR20_Document_Number	20
3	DEPRTMNT	Department	String	STR6_Payroll_Code	6
4	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
5	BENADJDATE	Ben Adj Date	Date	DT	8
6	VACTMACC	Vacation Time Accrued	Currency	DLR6_S2	6
7	SKTMACCR	Sick Time Accrued	Currency	DLR6_S2	6
8	APR_VacationTimeTaken	APR Vacation Time Taken	Currency	DLR6_S2	6
9	APR_SickTimeTaken	APR Sick Time Taken	Currency	DLR6_S2	6
10	APR_VacTimeAccrueYTD	APR Vacation Time Accrued YTD	Currency	DLR6_S2	6
11	APR_VacationTimeTakenYTD	APR Vacation Time Taken YTD	Currency	DLR6_S2	6
12	APR_SickTimeAccruedYTD	APR Sick Time Accrued YTD	Currency	DLR6_S2	6
13	APR_SickTimeTakenYTD	APR Sick Time Taken YTD	Currency	DLR6_S2	6
14	VACAVLBL	Vacation Available	Long Integer	LI6_S2	6
15	SIKTIMAV	Sick Time Available	Long Integer	LI6_S2	6
16	ID_Vacation_Hours_Pendin	ID Vacation Hours Pending	Currency	DLR11_S2	11
17	ID_Sick_Hours_Pending	ID Sick Hours Pending	Currency	DLR11_S2	11