This table contains the meanings of the coded values given for a test event. For instance, if we were dealing with a Gender code of F, this table would indicate that for the specific year and subject the information is related to (established via SMFConfig_ID) that the coded value 'F' means Female.

use StudentCentered
go

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

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

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

/*==============================================================*/
/* Table: ValidMstrCd */
/*==============================================================*/
create table dbo.ValidMstrCd (
ID int not null,
MstrCd_ID int not null,
SMFConfig_ID int not null,
Cd varchar(10) not null,
Nm varchar(100) not null,
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(),
constraint ValidMstrCd_PK primary key nonclustered (ID)
on SmallIDX
)
on SmallTBL
go

/*==============================================================*/
/* Index: MstrCd_FK */
/*==============================================================*/
create index MstrCd_FK on dbo.ValidMstrCd (
MstrCd_ID
)
on SmallIDX
go

/*==============================================================*/
/* Index: SMFConfig_FK */
/*==============================================================*/
create index SMFConfig_FK on dbo.ValidMstrCd (
SMFConfig_ID
)
on SmallIDX
go

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

Foreign key to the MstrCd table.

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

Coded value for a related row from master codes (MstrCd).

Meaning for the coded value.

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.