CREATE VIEW dbo.ALCActivitiesView
AS
SELECT
	tasks.TaskID,
	tasks.HierarchyElementId AS DMA,
	'LONG NAME' AS DMALongName,
	'DZ Short Name' AS DZ,
	'DZ Long Name' AS DZLongName,
	'NMA Short Name' AS NMA,
	'NMA Long Name' AS NMALongName,
	'OA Short Name' AS OA,
	'OA Long Name' AS OALongName,
	'John' AS TechnicianName,
	'Smith' AS TechnicianSurname,
	'ACT-06' AS ActivityCode,
	'Full Sweep' AS ActivityDescription,
	CASE WHEN tasks.IsCompleted = 1 THEN 1 ELSE NULL END AS EligibleReason,  -- (Enum)
	CASE WHEN tasks.IsCompleted = 1 THEN GETDATE() ELSE NULL END AS DateMadeEligible,
	tasks.StartDate as StartDate,
	tasks.EndDate as EndDate,
	tasks.IsCompleted as IsCompleted,
	tasks.IsPackDeployed as IsPackDeployed,
	tasks.ActualDuration as HoursWorked,
	10 as LoggersDeployed,
	20 as LoggersInAlarm,
	30 as PointsOfInterest,
	40 as BMsFound,
	50 as OthersFound
FROM ActiveLeakageControlTasks AS tasks
GO