This is a control table used to manage the processing for data related to a specific subject and year combination.

use StudentCentered
go

if exists (select 1
from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.UnqTstEvent') and o.name = 'FK_UNQTSTEV_REFERENCE_SMFCONFI')
alter table dbo.UnqTstEvent
drop constraint FK_UNQTSTEV_REFERENCE_SMFCONFI
go

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

/*==============================================================*/
/* Table: SMFConfig */
/*==============================================================*/
create table dbo.SMFConfig (
ID int not null,
Descr varchar(254) null,
SMFFmtYr varchar(11) null,
constraint SMFConfig_PK primary key nonclustered (ID)
on SMFIDX
)
on SMFTBL
go

Unique ID assigned and maintained by the StudentCenteredStaging database for the SMFConfig table.

A text description of the related subject and year.

The abbreviated subject followed by the starting school year, a hyphen and the ending school year. Example: MA2004-2005