The Event table is the core of the test. There should be one active (non end dated) record in this table for each test taken.

use StudentCentered
go

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

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

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

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

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

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

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

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

/*==============================================================*/
/* Table: Event */
/*==============================================================*/
create table dbo.Event (
ID int not null,
SMFConfig_ID int not null,
UnqTstEvent_ID int not null,
SMFBlock_ID int null,
UpdtID varchar(18) null,
UpdtDt datetime null,
CrtrID varchar(18) null,
CrtDt datetime null,
EffDt datetime not null default getdate(),
EndDt datetime null,
DistDupFg char(1) null,
SchlDupFg char(1) null,
SSIDChar varchar(10) null,
SSIDBigInt bigint null,
ChkDigitStdntID int null,
DistStdntID varchar(10) null,
LNm varchar(50) null,
FNm varchar(40) null,
MI varchar(3) null,
Gnrtn varchar(4) null,
Gndr char(1) null,
BirthDt datetime null,
BirthDtTxt varchar(8) null,
DistSPED char(1) null,
XtdEd1PctFg char(1) null,
StayInSchl char(1) null,
StayInDist char(1) null,
EthnicCd char(1) null,
AppealFg char(1) null,
RescoreFg char(1) null,
Tst_ID int not null,
AcdmYr varchar(4) null,
TstYr varchar(4) null,
SbjctCd char(2) null,
TstDt varchar(6) null,
TstDtTxt varchar(6) null,
TstValidFg char(1) null,
LexileScore varchar(8) null,
SrtTstTyp char(1) null,
ChlngFg char(1) null,
CalcAdmnCd char(1) null,
AttndDistInstID varchar(4) null,
AttndSchlInstID varchar(4) null,
ParticDistInstID varchar(4) null,
ParticSchlInstID varchar(4) null,
ResdDistInstID varchar(4) null,
ResdSchlInstID varchar(4) null,
TrgtAssistFg char(1) null,
SSIDBestScore char(1) null,
YrPctileRank int null,
AYPDistPartic char(1) null,
AYPDistPrfrm char(1) null,
AYPSchlPartic char(1) null,
AYPSchlPrfrm char(1) null,
GrpRptDistPartic char(1) null,
GrpRptDistPrfrm char(1) null,
GrpRptSchlPartic char(1) null,
GrpRptSchlPrfrm char(1) null,
RCDistPartic char(1) null,
RCDistPrfrm char(1) null,
RCSchlPartic char(1) null,
RCSchlPrfrm char(1) null,
LoadSeq_ID int null,
LoadDt datetime null,
AcmdtnCd char(1) null,
constraint EventClsRm_PK primary key nonclustered (ID)
on LargeIDX
)
on LargeTBL
go

/*==============================================================*/
/* Index: SMFFile_IDX */
/*==============================================================*/
create index SMFFile_IDX on dbo.Event (
SMFBlock_ID
)
on LargeIDX
go

/*==============================================================*/
/* Index: RecNum_IDX */
/*==============================================================*/
create index RecNum_IDX on dbo.Event (
)
on LargeIDX
go

/*==============================================================*/
/* Index: Tst_FK */
/*==============================================================*/
create index Tst_FK on dbo.Event (
Tst_ID
)
on LargeIDX
go

/*==============================================================*/
/* Index: SSID_IDX */
/*==============================================================*/
create index SSID_IDX on dbo.Event (
ChkDigitStdntID
)
on LargeIDX
go

/*==============================================================*/
/* Index: DistInstIDStdntID_IDX */
/*==============================================================*/
create index DistInstIDStdntID_IDX on dbo.Event (
DistStdntID
)
on LargeIDX
go

/*==============================================================*/
/* Index: StdntNm_IDX */
/*==============================================================*/
create index StdntNm_IDX on dbo.Event (
LNm,
FNm,
BirthDt
)
on LargeIDX
go

/*==============================================================*/
/* Index: EnrlGrade_IDX */
/*==============================================================*/
create index EnrlGrade_IDX on dbo.Event (

)
on LargeIDX
go

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

Foreign key from the Standard Message Format Configuration (SMFConfig) table. This key represents a subject and year combination.

Foreign key from the Unique Test Event (UnqTstEvent) table. This identifier is used to locate all versions of a given test in tables throughout the StudentCentered database.

Foreign key from the Standard Message Format Block (SMFBlock) table. This key identifies a unit of work that was processed together that is owned by a district.

The user identification of the person or process that last updated the record in StudentCenteredStaging.

The date of the last update to the source row of data from StudentCenteredStaging.

The user identification of the person or process that created the record in StudentCenteredStaging.

The date the source row of data was created in StudentCenteredStaging.

The date that this row of data becomes effective in StudentCentered.

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

Flag when set to 'D' to indicate a delete for a duplicate record.

Flag when set to 'D' to indicate a delete for a duplicate record.

A character version of the Check Digit Student Identifier (ChkDigitStdntID).

A big integer version of the Check Digit Student Identifier (ChkDigitStdntID).

An integer version of the Check Digit Student Identifier (ChkDigitStdntID).

An externally assigned district student ID maintained and assigned by school districts.

Student's Last name as submitted for the test event.

Student's First name as submitted for the test event.

Student's Middle name as submitted for the test event.

Student's Generation as submitted for the test event.

Student's Gender as submitted for the test event.

Student's date ot birth in date format, as submitted for the test event.

Student's date of birth as character(8).

The student is served by a district special education program and is in a resource room for at least 40% of the time

Indicates that the district chose for a record to count as "not proficient" for the purposes of AYP so that the district would keep below the 1% cap

The student was in the school for at least 1/2 of the school year

The student was in the district for at least 1/2 of the school year

Resolved ethnicity based on the individual ethnicity codes

Whether the test was re-scored based on an appeal by a district

Indicates if the record has been rescored.
'R' = Record rescored
' ' = Record not rescored

Foreign key from the Test (Tst) table. This key identifies the test taken by the student.

The last two digits of the beginning school year followed by the last two digits of the ending school year (ie 0102). May also be known as the acedemic year.

The last two digits of the beginning school year followed by the last two digits of the ending school year (ie 0102) within which the test was administered.

A two digit code indicating the subject for the test.
MA=math, RL= reading, SC=Science, SS=Social Science, WR=Writing, PS=Problem Solving, XR=Extended Reading, XM=Extended Math, XW=Extended Writing, CE= CLARS Elementry, CE= CLARS Secondary.

Required and filled as MMYYYY
(added by DWALL)

The date the test was taken in character format.

Test attemptedness based on number of items attempted. Set to N = 15 attempted, (12 in grade 3). Set to Y = 16 (13 in grade 3).

The associated lexile score for reading tests completed

Mode of test administration

Identifies an offgrade challenge (ie. L= Lower, H= Higher)

Indicates absencens modification or rationnale for virtual records

Attending District Institution ID maintained by the Institutions database.

The school in which the student attended

The district in which the student was enrolled on the first school day in May

The school in which the student was enrolled on the first school day in May

The resident district in which the student was enrolled at the time the test was administered

The resident school in which the student was enrolled at the time the test was administered

Student enrolled in Targeted Assistance program

Highest score for a student (across districts)

Year of percentile rank used in computation.

Record is included in the denominator of district AYP participation and may also be in the numerator.

Record is included in the denominator of district AYP performance and may also be in the numerator if meets.

Record is included in the denominator of school AYP participation and may also be in the numerator.

Record is included in the denominator of school AYP performance and may also be in the numerator if meets.

Record is included in the denominator of the district public reports participation and may also be in the numerator

Record is included in the denominator of district group performance and may also be in the numerator if meets.

Record is included in the denominator of school public report participation and may also be in the numerator.

Record is included in the denominator of school group performance and may also be in the numerator if meets.

Record is included in the denominator of district Report Card participation and may also be in the numerator.

Record is included in the denominator of the district Report Card performance, may also be in the numerator if meets.

Record is included in the denominator of school Report Card participation and may also be in the numerator.

Record is included in the denominator of the school Report Card performance, may also be in the numerator if meets.

Foreign key from the Load Sequence (LoadSeq) table. Each load receives a unique identifier.

The date the data was loaded into StudentCentered.

Describes the accommodations given to the student for the test.