Special Education data extension from feedback

Issue #660 resolved

Ghislain Hachey created an issue 2019-06-18

After demonstrating the new special education support here is the new requested data from FSM/RMI.

1) Add new column called "Exiting". This columns should have the drop-down values (needs a lkpSpEdExit):

GHS (Graduated with regular high school diploma)
RC (Received a certificate)
RMA (Reached maximum age)
D (Died/Deceased)
MKC (Moved, known to be continuing)
DROPOUT (Dropped out)
TRAN (Transferred to regular education)
GRADALTDPL (Graduated with an alternate diploma)

2) Add new column called "Has IEP". This column will have choices "Yes" or "No".

3) Add new column called "Has SBA Accommodation" (with variants in vocab called “Has MISAT Accomodation” in RMI and “Has NMCT Accommodation” in FSM). This column will have choices "Yes" or "No".

4) Add new column called "Type of Accommodation" (needs a lookup) lkpSpEdAccommodation). This column can turn red to become required when user selects yes to above 3). Use all following in dropdown

No Accommodations
Alternate Assessment
Sign-Language Interpreter
Braille
Human Reader
Scribe
Separate setting
Extended time
Frequent breaks
Other
Sign-Language Interpreter, separate setting
Sign-Language Interpreter, separate setting, extended time
Sign-Language Interpreter, separate setting, extended time, frequent breaks
Sign-Language Interpreter, scribe, separate setting
Sign-Language Interpreter, scribe, separate setting, extended time
Sign-Language Interpreter, scribe, separate setting, extended time, frequent breaks
Braille, separate setting
Braille, separate setting, extended time
Braille, separate setting, extended time, frequent breaks
Braille, scribe, separate setting
Braille, scribe, separate setting, extended time
Braille, scribe, separate setting, extended time, frequent breaks
Human reader, separate setting
Human reader, separate setting, extended time
Human reader, separate setting, extended time, frequent breaks
Human reader, scribe, separate setting
Human reader, scribe, separate setting, extended time
Human reader, scribe, separate setting, extended time, frequent breaks
Separate setting, extended time
Separate setting, extended time, frequent breaks
Extended time, frequent breaks

‌

Comments (10)

Ghislain Hachey reporter
5) Add new column “Assessment Type”. Use all following in dropdown:
- Alternate Assessment/Alternative Achievement Standard”
- NMCT without Accomodation
- NMCT with Accomodation
- 2019-06-28T03:43:45+00:00
Ghislain Hachey reporter
Some of the above feedback comes from RMI, some from FSM. Need to discuss a flexible way to include this in the workbook without having to maintain several workbooks and still aim for a single configurable workbook.
- 2020-03-08T05:04:01+00:00
Ghislain Hachey reporter
- edited description
- 2020-08-27T07:26:58+00:00
Ghislain Hachey reporter
- marked as critical
- 2020-08-27T07:27:11+00:00
Ghislain Hachey reporter
- edited description
- 2020-08-28T04:57:07+00:00

Ghislain Hachey reporter

For FSM

‌

USE [MIEMIS-TEST]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lkpSpEdExits](
    [codeCode] [nvarchar](10) NOT NULL,
    [codeDescription] [nvarchar](100) NULL,
    [codeSeq] [int] NULL,
    [codeDescriptionL1] [nvarchar](200) NULL,
    [codeDescriptionL2] [nvarchar](200) NULL,
    [pCreateUser] [nvarchar](50) NULL,
    [pCreateDateTime] [datetime] NULL,
    [pEditUser] [nvarchar](50) NULL,
    [pEditDateTime] [datetime] NULL,
    [pRowversion] [timestamp] NULL
CONSTRAINT [aaaaalkpSpEdExits_PK] PRIMARY KEY NONCLUSTERED 
(
    [codeCode] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Types of exit from the education system by SpEd student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lkpSpEdExits'
GO

CREATE TABLE [dbo].[lkpSpEdAccommodations](
    [codeCode] [nvarchar](10) NOT NULL,
    [codeDescription] [nvarchar](100) NULL,
    [codeSeq] [int] NULL,
    [codeDescriptionL1] [nvarchar](200) NULL,
    [codeDescriptionL2] [nvarchar](200) NULL,
    [pCreateUser] [nvarchar](50) NULL,
    [pCreateDateTime] [datetime] NULL,
    [pEditUser] [nvarchar](50) NULL,
    [pEditDateTime] [datetime] NULL,
    [pRowversion] [timestamp] NULL
CONSTRAINT [aaaaalkpSpEdAccommodations_PK] PRIMARY KEY NONCLUSTERED 
(
    [codeCode] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Types of accommodation available to SpEd students when doing the standards based assessments.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lkpSpEdAccommodations'
GO

CREATE TABLE [dbo].[lkpSpEdAssessmentTypes](
    [codeCode] [nvarchar](10) NOT NULL,
    [codeDescription] [nvarchar](100) NULL,
    [codeSeq] [int] NULL,
    [codeDescriptionL1] [nvarchar](200) NULL,
    [codeDescriptionL2] [nvarchar](200) NULL,
    [pCreateUser] [nvarchar](50) NULL,
    [pCreateDateTime] [datetime] NULL,
    [pEditUser] [nvarchar](50) NULL,
    [pEditDateTime] [datetime] NULL,
    [pRowversion] [timestamp] NULL
CONSTRAINT [aaaaalkpSpEdAssessmentTypes_PK] PRIMARY KEY NONCLUSTERED 
(
    [codeCode] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Types of assessment available to SpEd students when doing the standards based assessments.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lkpSpEdAssessmentTypes'
GO

INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('GHS','Graduated with regular high school diploma',10,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('RC','Received a certificate',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('RMA','Reached maximum age',30,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('D','Died/Deceased',40,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('MKC','Moved, known to be continuing',50,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('DROPOUT','Dropped out',60,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('TRAN','Transferred to regular education',70,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('GRADALTDPL','Graduated with an alternate diploma',80,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');

INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('NA','No Accommodations',10,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('AA','Alternate Assessment',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLI','Sign-Language Interpreter',30,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('B','Braille',40,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HR','Human Reader',50,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('S','Scribe',60,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SS','Separate setting',70,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('ET','Extended time',80,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('FB','Frequent breaks',90,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('O','Other',100,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISS','Sign-Language Interpreter, separate setting',110,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSET','Sign-Language Interpreter, separate setting, extended time',120,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSETBF','Sign-Language Interpreter, separate setting, extended time, frequent breaks',130,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSS','Sign-Language Interpreter, scribe, separate setting',140,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSSET','Sign-Language Interpreter, scribe, separate setting, extended time',150,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSSETFB','Sign-Language Interpreter, scribe, separate setting, extended time, frequent breaks',160,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSS','Braille, separate setting',170,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSET','Braille, separate setting, extended time',180,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSETFB','Braille, separate setting, extended time, frequent breaks',190,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSS','Braille, scribe, separate setting',200,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSSET','Braille, scribe, separate setting, extended time',210,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSSETFB','Braille, scribe, separate setting, extended time, frequent breaks',220,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSS','Human reader, separate setting',230,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSET','Human reader, separate setting, extended time',240,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSETFB','Human reader, separate setting, extended time, frequent breaks',250,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSS','Human reader, scribe, separate setting',260,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSSET','Human reader, scribe, separate setting, extended time',270,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSSETFB','Human reader, scribe, separate setting, extended time, frequent breaks',280,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SSET','Separate setting, extended time',290,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SSETFB','Separate setting, extended time, frequent breaks',300,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('ETFB','Extended time, frequent breaks',310,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');

INSERT INTO [dbo].[lkpSpEdAssessmentTypes] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('AAAAS','Alternate Assessment/Alternative Achievement Standard',10,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAssessmentTypes] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('NMCTA','NMCT without Accomodation',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAssessmentTypes] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('NMCTWA','NMCT with Accomodation',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');

‌

2020-08-28T05:31:24+00:00

Ghislain Hachey reporter

And almost identical for RMI. (only differences of the lkpSpEdAssessmentTypes

‌

USE [MIEMIS-TEST]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lkpSpEdExits](
    [codeCode] [nvarchar](10) NOT NULL,
    [codeDescription] [nvarchar](100) NULL,
    [codeSeq] [int] NULL,
    [codeDescriptionL1] [nvarchar](200) NULL,
    [codeDescriptionL2] [nvarchar](200) NULL,
    [pCreateUser] [nvarchar](50) NULL,
    [pCreateDateTime] [datetime] NULL,
    [pEditUser] [nvarchar](50) NULL,
    [pEditDateTime] [datetime] NULL,
    [pRowversion] [timestamp] NULL
CONSTRAINT [aaaaalkpSpEdExits_PK] PRIMARY KEY NONCLUSTERED 
(
    [codeCode] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Types of exit from the education system by SpEd student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lkpSpEdExits'
GO

CREATE TABLE [dbo].[lkpSpEdAccommodations](
    [codeCode] [nvarchar](10) NOT NULL,
    [codeDescription] [nvarchar](100) NULL,
    [codeSeq] [int] NULL,
    [codeDescriptionL1] [nvarchar](200) NULL,
    [codeDescriptionL2] [nvarchar](200) NULL,
    [pCreateUser] [nvarchar](50) NULL,
    [pCreateDateTime] [datetime] NULL,
    [pEditUser] [nvarchar](50) NULL,
    [pEditDateTime] [datetime] NULL,
    [pRowversion] [timestamp] NULL
CONSTRAINT [aaaaalkpSpEdAccommodations_PK] PRIMARY KEY NONCLUSTERED 
(
    [codeCode] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Types of accommodation available to SpEd students when doing the standards based assessments.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lkpSpEdAccommodations'
GO

CREATE TABLE [dbo].[lkpSpEdAssessmentTypes](
    [codeCode] [nvarchar](10) NOT NULL,
    [codeDescription] [nvarchar](100) NULL,
    [codeSeq] [int] NULL,
    [codeDescriptionL1] [nvarchar](200) NULL,
    [codeDescriptionL2] [nvarchar](200) NULL,
    [pCreateUser] [nvarchar](50) NULL,
    [pCreateDateTime] [datetime] NULL,
    [pEditUser] [nvarchar](50) NULL,
    [pEditDateTime] [datetime] NULL,
    [pRowversion] [timestamp] NULL
CONSTRAINT [aaaaalkpSpEdAssessmentTypes_PK] PRIMARY KEY NONCLUSTERED 
(
    [codeCode] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Types of assessment available to SpEd students when doing the standards based assessments.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lkpSpEdAssessmentTypes'
GO

INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('GHS','Graduated with regular high school diploma',10,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('RC','Received a certificate',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('RMA','Reached maximum age',30,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('D','Died/Deceased',40,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('MKC','Moved, known to be continuing',50,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('DROPOUT','Dropped out',60,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('TRAN','Transferred to regular education',70,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdExits] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('GRADALTDPL','Graduated with an alternate diploma',80,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');

INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('NA','No Accommodations',10,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('AA','Alternate Assessment',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLI','Sign-Language Interpreter',30,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('B','Braille',40,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HR','Human Reader',50,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('S','Scribe',60,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SS','Separate setting',70,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('ET','Extended time',80,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('FB','Frequent breaks',90,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('O','Other',100,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISS','Sign-Language Interpreter, separate setting',110,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSET','Sign-Language Interpreter, separate setting, extended time',120,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSETBF','Sign-Language Interpreter, separate setting, extended time, frequent breaks',130,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSS','Sign-Language Interpreter, scribe, separate setting',140,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSSET','Sign-Language Interpreter, scribe, separate setting, extended time',150,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SLISSSETFB','Sign-Language Interpreter, scribe, separate setting, extended time, frequent breaks',160,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSS','Braille, separate setting',170,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSET','Braille, separate setting, extended time',180,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSETFB','Braille, separate setting, extended time, frequent breaks',190,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSS','Braille, scribe, separate setting',200,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSSET','Braille, scribe, separate setting, extended time',210,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('BSSSETFB','Braille, scribe, separate setting, extended time, frequent breaks',220,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSS','Human reader, separate setting',230,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSET','Human reader, separate setting, extended time',240,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSETFB','Human reader, separate setting, extended time, frequent breaks',250,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSS','Human reader, scribe, separate setting',260,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSSET','Human reader, scribe, separate setting, extended time',270,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('HRSSSETFB','Human reader, scribe, separate setting, extended time, frequent breaks',280,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SSET','Separate setting, extended time',290,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('SSETFB','Separate setting, extended time, frequent breaks',300,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAccommodations] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('ETFB','Extended time, frequent breaks',310,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');

INSERT INTO [dbo].[lkpSpEdAssessmentTypes] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('AAAAS','Alternate Assessment/Alternative Achievement Standard',10,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAssessmentTypes] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('MISATA','MISAT without Accomodation',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');
INSERT INTO [dbo].[lkpSpEdAssessmentTypes] ([codeCode],[codeDescription],[codeSeq],[pCreateUser],[pCreateDateTime],[pEditUser],[pEditDateTime]) VALUES ('MISATWA','MISAT with Accomodation',20,'ghachey@nuzusys.com','2020-08-28 13:27:31.390','ghachey@nuzusys.com','2020-08-28 10:27:31.390');

‌

2020-08-28T05:33:11+00:00

Brian Lewis repo owner
- changed status to open
- 2020-09-06T22:11:53+00:00
Brian Lewis repo owner
related commits:

a8f6f8c f012ad3 c299d25 a70488e

‌
- 2020-09-07T22:46:03+00:00
Brian Lewis repo owner
- changed status to resolved
feat(census): updated census workbook

Resolves ~~#684~~ ~~#799~~ ~~#924~~ ~~#606~~ ~~#968~~ ~~#969~~ ~~#939~~ ~~#798~~ ~~#660~~

→ <<cset babf8e18c3e4>>
- 2020-09-07T23:19:47+00:00
Log in to comment

Assignee: –

Type: enhancement

Priority: critical

Status: resolved

Votes: 0

Watchers: 1