The event indicator table stores several indicators related to the test. The raw source values for the indicators are related to detailed descriptions of what the values are for and what they mean in the master codes (MstrCd and ValidMstrCd) tables. The groupings for indicators are Exception, Program Participation, Social Economic, Demographic and Test Conditions (stored in the IndGrp_ID column). The IndTyp_ID is the indicator type such as the Indian Education Flag. The IndMng_ID describes the meaning of the coded value for the indicator stored in the IndVal column.. Together these columns describe the meanings of the indicators for the test.

use StudentCentered
go

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

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

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

/*==============================================================*/
/* Table: EventInd */
/*==============================================================*/
create table dbo.EventInd (
ID int not null,
SMFConfig_ID int null,
UnqTstEvent_ID int null,
IndSeq int not null,
IndGrp_ID int not null,
IndTyp_ID int not null,
IndMng_ID int null,
IndVal varchar(4) not 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 EventInd_PK primary key nonclustered (ID)
on LargeIDX
)
on LargeTBL
go

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

/*==============================================================*/
/* Index: IndTyp_FK */
/*==============================================================*/
create index IndTyp_FK on dbo.EventInd (
IndTyp_ID
)
on LargeIDX
go

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

This colum indicates the numeric order the indcator was posted in from the source record.

Indicators may be grouped together using this identifier. This is a foreign key to the MstrCd table where the indicator groups are stored. The groups are: Demographic, Exemption, Program Participation, Social Economic and Test Conditions.

The specific indicator type may be determined using this identifier. This is a foreign key to the MstrCd table where the indicator types are stored. There are several types, essentially one for every column of indicator data loaded. Some examples of the represented types are: AmerIndAlsknNtvEthnicFg, AppealTyp, AsianPacIslndrEthnicFg, ...

For every indicator there are a series of values that may be present to determine what is meant by the indicator. In most cases this is a simple yes / no (Y or N) but other indicators have many values. This is a foreign key to the ValidMstrCd table where the meaning of the specific value given is stored.

This is the coded value given used to determine the meaning of the response given for an indicator.

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.