SELECT 
	'00000405' AS CompanyCode, 
	'21112' AS Contract,
	SUBSTRING(e.UniquePublicIdentifier, 1, 3) + SUBSTRING(e.UniquePublicIdentifier, 5, 2) + SUBSTRING(e.UniquePublicIdentifier, 8, 4) AS SSNo, 
	tc.EmployeeName, 
	DATEADD(dd, 6, tc.TimeCardDateTime) AS PayDate, 
	ISNULL(tcw.Amount, 0.00) AS Amount
FROM         
	livedb.dbo.PpTimeCardComputedWithholdings tcw 
	INNER JOIN livedb.dbo.PpTimeCards tc ON tcw.TimeCardID = tc.TimeCardID 
	INNER JOIN livedb.dbo.PpEmployees e ON tc.EmployeeID = e.EmployeeID
WHERE     
	tcw.WithholdingID = '10' AND DATEADD(dd, 6, tc.TimeCardDateTime) = @PayDate
ORDER BY 
	tc.EmployeeName