The name of score reporting categories (SRC) are stored here related to the subject and test year to which they belong. There is also a Cd column which contains the ordinal position of the SRC within the received data for detail SRC's and for summary SRC's the type of summary (S = Survey Total, T = Total).

use StudentCentered
go

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

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

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

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

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

/*==============================================================*/
/* Table: Ctgry */
/*==============================================================*/
create table dbo.Ctgry (
ID int not null,
Nm varchar(100) not null,
Cd varchar(10) null,
SbjctCd char(2) null,
TstYr varchar(4) null,
EffDt datetime not null default getdate(),
CrtrID varchar(18) not null default suser_sname(),
CrtDt datetime not null default getdate(),
UpdtID varchar(18) not null default suser_sname(),
UpdtDt datetime not null default getdate(),
EndDt datetime null,
constraint Ctgry_PK primary key nonclustered (ID)
on SmallIDX
)
on SmallTBL
go

/*==============================================================*/
/* Index: Nm_IDX */
/*==============================================================*/
create index Nm_IDX on dbo.Ctgry (
Nm
)
on SmallIDX
go

/*==============================================================*/
/* Index: Cd_IDX */
/*==============================================================*/
create index Cd_IDX on dbo.Ctgry (
Cd
)
on SmallIDX
go

/*==============================================================*/
/* Index: EffDt_IDX */
/*==============================================================*/
create index EffDt_IDX on dbo.Ctgry (
EffDt
)
on SmallIDX
go

/*==============================================================*/
/* Index: EndDt_IDX */
/*==============================================================*/
create index EndDt_IDX on dbo.Ctgry (
EndDt
)
on SmallIDX
go

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

The name of the category (aka Score Reporting Category).

The order in which the columns containing scores and related information appear in the test results from the vendor.

A two digit abbeviation for the test subject.

Year the test was offered.

The date that this row of data becomes effective.

The user identification of the person or process that created the record.

The date the source row of data was created.

The user identification of the person or process that last updated the record.

The date of the last update.

The date that this row of data ceases to be effective.