The computer based data table holds some information that is related to online test events such as the number of items returned, attempted, correct and omitted as well as test start and end dates.

use StudentCentered
go

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

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

/*==============================================================*/
/* Table: CmptrBasedData */
/*==============================================================*/
create table dbo.CmptrBasedData (
ID int not null,
SMFConfig_ID int not null,
UnqTstEvent_ID int not null,
NbrItemAtmpt tinyint null,
TstStrtDt datetime null,
TstEndDt datetime null,
CrtDt datetime not null default getdate(),
EffDt datetime not null default getdate(),
EndDt datetime null,
LoadSeq_ID int null,
LoadDt datetime null,
constraint CmptrBasedData_PK primary key nonclustered (ID)
on LargeIDX
)
on LargeTBL
go

/*==============================================================*/
/* Index: ExtrnlEventID_IDX */
/*==============================================================*/
create index ExtrnlEventID_IDX on dbo.CmptrBasedData (

)
on LargeIDX
go

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

Number of test event items attempted.

The Start date and time for a test event.

The End date and time for a test event.

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.