This table contains the answer sheet and roster teacher name as well as the class grade. Only paper / pencil tests are loaded into this table.

use StudentCentered
go

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

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

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

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

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

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

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

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

/*==============================================================*/
/* Table: EventClsRm */
/*==============================================================*/
create table dbo.EventClsRm (
ID int not null,
SMFConfig_ID int null,
UnqTstEvent_ID int null,
InstID int null,
AnsShtTchrNm varchar(30) null,
AnsShtClsPrd char(2) null,
RstrTchrNm varchar(30) null,
RstrClsPrd char(2) null,
RptTchrNm varchar(30) null,
RptClsPrd char(2) null,
ClsGrd char(2) null,
UpdtID varchar(18) null,
UpdtDt datetime null,
CrtrID varchar(18) null,
CrtDt datetime null,
EffDt datetime not null default getdate(),
EndDt datetime null,
LoadSeq_ID int null,
LoadDt datetime null,
constraint EventClsRm_PK primary key nonclustered (ID)
on LargeIDX
)
on LargeTBL
go

/*==============================================================*/
/* Index: UnqTestEventEffDtEndDt_IDX */
/*==============================================================*/
create index UnqTestEventEffDtEndDt_IDX on dbo.EventClsRm (
UnqTstEvent_ID,
EffDt,
EndDt
)
on LargeIDX
go

/*==============================================================*/
/* Index: AnsShtTchrNmAnsShtClsPrd_IDX */
/*==============================================================*/
create index AnsShtTchrNmAnsShtClsPrd_IDX on dbo.EventClsRm (
AnsShtTchrNm,
AnsShtClsPrd
)
on LargeIDX
go

/*==============================================================*/
/* Index: RstrTchrNmRstrClsPrd_IDX */
/*==============================================================*/
create index RstrTchrNmRstrClsPrd_IDX on dbo.EventClsRm (
RstrTchrNm,
RstrClsPrd
)
on LargeIDX
go

/*==============================================================*/
/* Index: RptTchrNmRptClsPrd_IDX */
/*==============================================================*/
create index RptTchrNmRptClsPrd_IDX on dbo.EventClsRm (
RptTchrNm,
RptClsPrd
)
on LargeIDX
go

/*==============================================================*/
/* Index: UpdtDt_IDX */
/*==============================================================*/
create index UpdtDt_IDX on dbo.EventClsRm (
UpdtDt
)
on LargeIDX
go

/*==============================================================*/
/* Index: EffDt_IDX */
/*==============================================================*/
create index EffDt_IDX on dbo.EventClsRm (
EffDt
)
on LargeIDX
go

/*==============================================================*/
/* Index: EndDt_IDX */
/*==============================================================*/
create index EndDt_IDX on dbo.EventClsRm (
EndDt
)
on LargeIDX
go

Unique ID assigned and maintained by the database for the EventClsRm 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.

Institution identifier assigned and maintained by the Institution database for the Attending School.

Answer sheet teacher name used for distribution.

Answer sheet class period used for distribution.

Class roster teacher name for reporting.

Class roster period for reporting.

Report teacher name used for Writing and MathProblemSolving.

Report class period used for Writing and MathProblemSolving.

Classroom grade as reported on the classroom information sheet.

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.

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

The date the data was loaded into StudentCentered.