The Standard Message Format File table is a record of the file that a test event was loaded into StudentCenteredStaging through. The details of the file submitted are contained within the table.

use StudentCentered
go

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

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

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

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

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

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

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

/*==============================================================*/
/* Table: SMFFile */
/*==============================================================*/
create table dbo.SMFFile (
ID int not null,
RcvdFileNm varchar(255) not null,
FileCrtDt datetime not null default getdate(),
UploadDt datetime not null,
SavedFileNm varchar(255) null,
EmailAddr varchar(255) null,
SbmtIPAddr varchar(15) null,
StatFg char(1) null,
PrcDt datetime null,
CmpltdDt datetime null,
UpdtID varchar(18) null,
UpdtDt datetime null,
CrtrID varchar(18) null,
CrtDt datetime null,
Cmnt varchar(255) null,
LoadSeq_ID int null,
LoadDt datetime null,
constraint SMFFile_PK primary key nonclustered (ID)
on SMFIDX
)
on SMFTBL
go

/*==============================================================*/
/* Index: RcvdFileNm_IDX */
/*==============================================================*/
create index RcvdFileNm_IDX on dbo.SMFFile (
RcvdFileNm
)
on SMFIDX
go

/*==============================================================*/
/* Index: EmailAddr_IDX */
/*==============================================================*/
create index EmailAddr_IDX on dbo.SMFFile (
EmailAddr
)
on SMFIDX
go

/*==============================================================*/
/* Index: CrtrID_IDX */
/*==============================================================*/
create index CrtrID_IDX on dbo.SMFFile (
CrtrID
)
on SMFIDX
go

/*==============================================================*/
/* Index: CrtDt_IDX */
/*==============================================================*/
create index CrtDt_IDX on dbo.SMFFile (
CrtDt
)
on SMFIDX
go

/*==============================================================*/
/* Index: UpdtID_IDX */
/*==============================================================*/
create index UpdtID_IDX on dbo.SMFFile (
UpdtID
)
on SMFIDX
go

/*==============================================================*/
/* Index: UpdtDt_IDX */
/*==============================================================*/
create index UpdtDt_IDX on dbo.SMFFile (
UpdtDt
)
on SMFIDX
go

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

Name of the file submitted.

Date the file was created on ODE's site.

Date file was uploaded to ODE.

Versioned name of the file submitted. In some cases the same file is submitted over and over, so a version is added to the file name to keep them separated.

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

IP address of the machine used to submit the file.

Status of the file to indicate if the file has been posted or in what phase of processing the file was in when it was loaded into StudentCentered.

Date that the file started processing.

Date the file completed processing.

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.

Comments about the file submitted.

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

The date the data was loaded into StudentCentered.