This table contains the institution identifiers and the type of institution as related to the test. The types of institutions are Attending District, Attending School, Resident District, Resident school, Participating District and Participating School.

use StudentCentered
go

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

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

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

/*==============================================================*/
/* Table: EventInst */
/*==============================================================*/
create table dbo.EventInst (
ID int not null,
SMFConfig_ID int null,
UnqTstEvent_ID int null,
InstID int not null,
InstTyp_ID int not null,
PrvdInstNm varchar(40) 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 EventInst_PK primary key nonclustered (ID)
on LargeIDX
)
on LargeTBL
go

/*==============================================================*/
/* Index: UnqTstEvent_FK */
/*==============================================================*/
create index UnqTstEvent_FK on dbo.EventInst (
UnqTstEvent_ID,
SMFConfig_ID
)
on LargeIDX
go

/*==============================================================*/
/* Index: InstTyp_FK */
/*==============================================================*/
create index InstTyp_FK on dbo.EventInst (
InstTyp_ID
)
on LargeIDX
go

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

ID assigned and maintained by the Institution database.

The type of institution the reported identifier is acting as. There are several types we presently load such as: Attending District, Attending School, Resident District, Resident School, Participating District and Participating School. This is a foreign key from the MstrCd table where the Institution Type Identifiers are stored.

This is the name at the time the data was loaded to StudentCentered for the given Institution Identifier from the Institution database.

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.