NOJIRA: Merged Faculty Interventions for Pull Request

1. CREATE TABLES TO HOLD INTERVENTIONS AND EARLY ALERT RELATIONAL LINKS TO INTERVENTIONS
--------------------------------------------------------------------------------------------------------------------------------------------------------
USE [ssp]
GO

/****** Object:  Table [dbo].[early_alert_intervention]    Script Date: 6/12/2014 12:26:16 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].early_alert_intervention(
	[id] [uniqueidentifier] NOT NULL,
	[name] [nvarchar](80) NOT NULL,
	[description] [nvarchar](max) NULL,
	[created_date] [datetime] NOT NULL,
	[modified_date] [datetime] NULL,
	[created_by] [uniqueidentifier] NOT NULL,
	[modified_by] [uniqueidentifier] NULL,
	[object_status] [int] NOT NULL,
	[sort_order] [smallint] NOT NULL,
 CONSTRAINT [PK_EARLY_ALERT_INTERVENTION] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[early_alert_intervention] ADD  CONSTRAINT [DF_early_alert_intervention_sort_order]  DEFAULT ((0)) FOR [sort_order]
GO

ALTER TABLE [dbo].[early_alert_intervention]  WITH CHECK ADD  CONSTRAINT [early_alert_intervention_created_by_person_id] FOREIGN KEY([created_by])
REFERENCES [dbo].[person] ([id])
GO

ALTER TABLE [dbo].[early_alert_intervention] CHECK CONSTRAINT [early_alert_intervention_created_by_person_id]
GO

ALTER TABLE [dbo].[early_alert_intervention]  WITH CHECK ADD  CONSTRAINT [early_alert_intervention_modified_by_person_id] FOREIGN KEY([modified_by])
REFERENCES [dbo].[person] ([id])
GO

ALTER TABLE [dbo].[early_alert_intervention] CHECK CONSTRAINT [early_alert_intervention_modified_by_person_id]
GO
--------------------------------------------------------------------------------------------------------------------------------------------------------
USE [ssp]
GO

/****** Object:  Table [dbo].[early_alert_early_alert_intervention]    Script Date: 6/16/2014 4:34:55 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[early_alert_early_alert_intervention](
	[early_alert_id] [uniqueidentifier] NOT NULL,
	[early_alert_intervention_id] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_EARLY_ALERT_EARLY_ALERT_INTERVENTION] PRIMARY KEY CLUSTERED 
(
	[early_alert_id] ASC,
	[early_alert_intervention_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[early_alert_early_alert_intervention]  WITH CHECK ADD  CONSTRAINT [early_alert_early_alert_intervention_early_alert_id] FOREIGN KEY([early_alert_id])
REFERENCES [dbo].[early_alert] ([id])
GO

ALTER TABLE [dbo].[early_alert_early_alert_intervention] CHECK CONSTRAINT [early_alert_early_alert_intervention_early_alert_id]
GO

ALTER TABLE [dbo].[early_alert_early_alert_intervention]  WITH CHECK ADD  CONSTRAINT [early_alert_early_alert_intervention_ids] FOREIGN KEY([early_alert_intervention_id])
REFERENCES [dbo].[early_alert_intervention] ([id])
GO

ALTER TABLE [dbo].[early_alert_early_alert_intervention] CHECK CONSTRAINT [early_alert_early_alert_intervention_ids]
GO
--------------------------------------------------------------------------------------------------------------------------------------------------------
Add a column called early_alert_intervention_other_description nvarchar(MAX) to end of early_alert table.

--------------------------------------------------------------------------------------------------------------------------------------------------------
2. CREATE ADD/MODIFY FILES BELOW TO HANDLE ADMIN DATA VIEWS:
--------------------------------------------------------------------------------------------------------------------------------------------------------
a.	ssp/src/main/webapp/app/store/admin/AdminTreeMenus.js 						"Add Faculty Interventions Data view to Admin Tool"
b.	ssp/src/main/webapp/app/controller/AdminViewController.js	 				"Add earlyAlertInterventionsAllStore data store to AdminViewController"
c.	ssp/src/main/webapp/app/model/reference/EarlyAlertIntervention.js				"Created NEW File EarlyAlertIntervention.js to extend AbstractReference model"
d.	ssp/src/main/webapp/app/store/reference/EarlyAlertInterventions.js				"Created NEW File EarlyAlertInterventions.js to extend AbstractReferences data store"
e.	ssp/src/main/webapp/app.js									"Added Ssp.store.reference.EarlyAlertInterventions, earlyAlertIntervention url path, earlyAlertDetailsInterventionsStore, earlyAlertInterventionsStore & earlyAlertInterventionsAllUnpagedStore"
f.	ssp/src/main/java/org/jasig/ssp/dao/reference/EarlyAlertInterventionDao.java			"Created EarlyAlertInterventionDao.java for Paging/Sorting/CRUD"
g.	ssp/src/main/java/org/jasig/ssp/factory/reference/EarlyAlertInterventionTOFactory.java		"Created EarlyAlertInterventionTOFactory.java transfer object factory for converting back and forth from EarlyAlertIntervention models"
h.	ssp/src/main/java/org/jasig/ssp/factory/reference/impl/EarlyAlertInterventionTOFactoryImpl.java	"Created EarlyAlertInterventionTOFactoryImpl.java"
i.	ssp/src/main/java/org/jasig/ssp/model/reference/EarlyAlertIntervention.java			"Created EarlyAlertIntervention.java"
j.	ssp/src/main/java/org/jasig/ssp/service/impl/EarlyAlertServiceImpl.java				"Added EarlyAlertInterventions Faculty Interventions to Early Alert"
k.	ssp/src/main/java/org/jasig/ssp/service/reference/EarlyAlertInterventionService.java		"Created EarlyAlertInterventionService.java"
l.	ssp/src/main/java/org/jasig/ssp/service/reference/impl/EarlyAlertInterventionServiceImpl.java	"Created EarlyAlertInterventionServiceImpl.java"
m.	ssp/src/main/java/org/jasig/ssp/transferobject/EarlyAlertTO.java				"Add EarlyAlertIntervention Faculty Intervention Transfer Object handlers"
n.	ssp/src/main/java/org/jasig/ssp/transferobject/reference/EarlyAlertInterventionTO.java		"Created EarlyAlertInterventionTO.java"
o.	ssp/src/main/java/org/jasig/ssp/web/api/reference/EarlyAlertInterventionController.java		"Created EarlyAlertInterventionController.java"
p.	ssp/src/main/webapp/all-classes.js								"Add EarlyAlertInterventions Faculty Interventions"
q.	ssp/src/main/webapp/app/controller/tool/earlyalert/EarlyAlertDetailsViewController.js		"Add Faculty Interventions functionality to EA Details Controller"
r.	ssp/src/main/webapp/app/controller/tool/earlyalert/EarlyAlertToolViewController.js		"Add Faculty Interventions functionality to EA Tool Controller"
s.	ssp/src/main/webapp/app/model/reference/EarlyAlertIntervention.js				"Created EarlyAlertIntervention.js for Faculty Interventions"
t.	ssp/src/main/webapp/app/model/tool/earlyalert/EarlyAlertResponseGrid.js				"Add Faculty Interventions fields to Response Grid"
u.	ssp/src/main/webapp/app/model/tool/earlyalert/PersonEarlyAlert.js				"Add Faculty Interventions fields to Person EA"
v. 	ssp/src/main/webapp/app/model/tool/earlyalert/PersonEarlyAlertTree.js				"Add Faculty Interventions fields to Person EA Tree"
w.	ssp/src/main/webapp/app/view/tools/earlyalert/EarlyAlertDetails.js				"Add Faculty Interventions data stores to EA Details"
x.	ssp/src/main/webapp/js/early-alert-form.js		(ADD FIELD VALIDATION HERE)		"Added Faculty Interventions to EA form"
y.	ssp/src/main/webapp/resources/css/early-alert.css						"Add Faculty Interventions Specific CSS"
z.	ssp/src/main/webapp/app/util/Constants.js							"Add Faculty Interventions Other Constant"
aa.	ssp/src/main/webapp/resources/css/report.css							"Add Faculty Interventions Specific CSS"
ab.	ssp/src/main/webapp/WEB-INF/jsp/ea-form.jsp							"Added Faculty Interventions to EA Form"
ac.	ssp/src/main/java/org/jasig/ssp/factory/impl/EarlyAlertTOFactoryImpl.java			"Add Faculty Interventions Transfer Object and references"
ad.	ssp/src/main/java/org/jasig/ssp/model/EarlyAlert.java						"Add Faculty Interventions to EA"
ae.	ssp/src/main/resources/i18n/messages.properties							"Add faculty.interventions field label to properties file"