This table is a collection of elements used to describe a group of tests offered for a specific subject and year. Each subject year has many offerings of different benchmarks, forms and so forth and this table is used to represent each of those distinct offerings.

use StudentCentered
go

if exists (select 1
from sysindexes
where id = object_id('dbo.Tst')
and name = 'TstGrade_IDX'
and indid > 0
and indid < 255)
drop index dbo.Tst.TstGrade_IDX
go

if exists (select 1
from sysindexes
where id = object_id('dbo.Tst')
and name = 'SbjctCd_IDX'
and indid > 0
and indid < 255)
drop index dbo.Tst.SbjctCd_IDX
go

if exists (select 1
from sysindexes
where id = object_id('dbo.Tst')
and name = 'AcdmYrSbjctCdTstGradeTstBnch_IDX'
and indid > 0
and indid < 255)
drop index dbo.Tst.AcdmYrSbjctCdTstGradeTstBnch_IDX
go

if exists (select 1
from sysobjects
where id = object_id('dbo.Tst')
and type = 'U')
drop table dbo.Tst
go

/*==============================================================*/
/* Table: Tst */
/*==============================================================*/
create table dbo.Tst (
ID int not null,
TstYr varchar(4) not null,
TstStrtDt datetime null,
TstEndDt datetime null,
SbjctCd char(2) not null,
TstGrd char(2) null,
TstGrdBnd varchar(5) null,
TstBnch char(2) null,
LangCd char(1) null,
Mode char(1) null,
EffDt datetime not null default getdate(),
UpdtDt datetime not null default getdate(),
EndDt datetime null,
constraint Tst_PK primary key nonclustered (ID)
on SmallIDX
)
on SmallTBL
go

/*==============================================================*/
/* Index: AcdmYrSbjctCdTstGradeTstBnch_IDX */
/*==============================================================*/
create index AcdmYrSbjctCdTstGradeTstBnch_IDX on dbo.Tst (
TstYr,
SbjctCd,
TstGrd,
TstBnch
)
on SmallIDX
go

/*==============================================================*/
/* Index: SbjctCd_IDX */
/*==============================================================*/
create index SbjctCd_IDX on dbo.Tst (
SbjctCd
)
on SmallIDX
go

/*==============================================================*/
/* Index: TstGrade_IDX */
/*==============================================================*/
create index TstGrade_IDX on dbo.Tst (
TstGrd
)
on SmallIDX
go

Unique ID assigned and maintained by the database for the Tst table.

Year the test was offered.

Date the test was issued for use.

Date the test ceased to be used.

A two digit abbeviation for the test subject.

Student's Test grade of enrollment.

The grade level form of the ELPA that the student took

The benchmark being tested.
Bench 1 = grade 3,
Bench 2 = grade 5,
Bench 3 = grade 8
Bench 4 = grades 9, 10, 11. G1, G2, G3, G4, G6 and G7, KG

The language in which the test was presented to a student

For Writing performance test only it indicates the mode of Writing for the selected Writing Topic. The valid values are currently N, E, P and I.

The date that this row of data becomes effective.

The date of the last update.

The date that this row of data ceases to be effective.