The Standard Message Format Block table is a record of the submission of data for a particular district either through online editing or via file submission. The details of the block, who submitted it and so forth are contained in this table.

use StudentCentered
go

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

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

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

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

/*==============================================================*/
/* Table: SMFBlock */
/*==============================================================*/
create table dbo.SMFBlock (
ID int not null,
SMFFile_ID int not null,
SMFConfig_ID int not null,
OwnerInstID int null,
PrcDt datetime null,
SbmtTyp char(1) null,
EmailAddr varchar(255) null,
EffDt datetime not null default getdate(),
EndDt datetime null,
LoadSeq_ID int null,
LoadDt datetime null,
constraint SMFBlock_PK primary key nonclustered (ID)
on SMFIDX
)
on SMFTBL
go

/*==============================================================*/
/* Index: OwnerInstID_IDX */
/*==============================================================*/
create index OwnerInstID_IDX on dbo.SMFBlock (
OwnerInstID
)
on SMFIDX
go

/*==============================================================*/
/* Index: SMFConfig_FK */
/*==============================================================*/
create index SMFConfig_FK on dbo.SMFBlock (
SMFConfig_ID
)
on SMFIDX
go

/*==============================================================*/
/* Index: SMFFile_FK */
/*==============================================================*/
create index SMFFile_FK on dbo.SMFBlock (
SMFFile_ID
)
on SMFIDX
go

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

Foreign key to the SMFFile table.

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

District Institution identifier that is the owner of the block.

Date that the block started processing.

Indicates the submission type as coming from a vendor or from a district.

Email address of the user who submitted the data from their central login application user record.

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.