'1' as PIN, 
	'1' as NUMORGID, 
	'1' as EMPLOYMENTSTARTDATE, 
	'1' as EMPLOYMENTENDDATE ,
	C0.REGULATIVECODE as 'Table',
	C0.REGULATIVENAME as Table_Name,
	C1.PAYSCALECODE as 'Payscale_Code',
	C1.PAYSCALENAME as 'Payscale_Name',
	convert (varchar, LN.Line) + ' ' + LN.NAME as 'Rate_Line',
	Cl.Col as 'Seniority_Column',
	C0.CURRENCYCODE as 'Currency',
	Isnull(TRY_CONVERT(Decimal(10,2),C1R.Rate),0.00) as [Rate],
	CASE when (C1R.Formula is NULL or C1R.Formula = '') then convert (Decimal(10,2), '0.00')
		ELSE TRY_CONVERT(Decimal(10,2),C1R.Rate)
	END Formula