This table is used to generate unique test event identifiers that are then used within the other tables related to the test event for the purpose of being able to bring alll the related data back together. Even if there are updates and a prior version of a test is end dated in favor of a new version of the record for any given part of a test, it will still be related to the same identifier created through this table.

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 sysindexes
where id = object_id('dbo.UnqTstEvent')
and name = 'PADMIDF7SrtTstTyp_IDX'
and indid > 0
and indid < 255)
drop index dbo.UnqTstEvent.PADMIDF7SrtTstTyp_IDX
go

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

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

/*==============================================================*/
/* Table: UnqTstEvent */
/*==============================================================*/
create table dbo.UnqTstEvent (
ID int not null,
SMFConfig_ID int not null,
PADMID varchar(13) not null,
SnapshotFg char(1) null,
PADMIDF7 int null,
SrtTstTyp char(1) null,
Tst_ID int null,
LoadSeq_ID int null,
LoadDt datetime null,
constraint UnqTstEvent_PK primary key nonclustered (ID, SMFConfig_ID)
on LargeIDX,
constraint UnqTstEvent_AK unique (ID)
)
on LargeTBL
go

/*==============================================================*/
/* Index: UnqPADMID_IDX */
/*==============================================================*/
create unique index UnqPADMID_IDX on dbo.UnqTstEvent (
PADMID
)
on LargeIDX
go

/*==============================================================*/
/* Index: PADMIDF7SrtTstTyp_IDX */
/*==============================================================*/
create index PADMIDF7SrtTstTyp_IDX on dbo.UnqTstEvent (
PADMIDF7,
SrtTstTyp
)
on LargeIDX
go

alter table dbo.UnqTstEvent
add constraint FK_UNQTSTEV_REFERENCE_SMFCONFI foreign key ()
references dbo.SMFConfig
go

Unique ID assigned and maintained by the database for the UnqTstEvent table.

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

Post Assessment Database Managment Identifier

Indicates where the source data came from. "S" = Staging Daily ISR, "P" = Preliminary Snapshot, "F" = Final Snapshot, "R" = Roll-Forward Snapshot.

First seven digits of the Post Assessment Database Managment Identifier also known as the Vtg_Test_Event_ID, VndrTstEvent_ID.

Mode of test administration

Foreign key from the Test Definition (Tst) table.

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

The date the data was loaded into StudentCentered.