S_Header_Ex

TABLE S_Header_Ex

Many of these fields are also accessible through an older view called simple S_Header. The difference is the way translations are handled. S_Header only provides access to untranslated assessments whereas S_Header_Ex introduced the additional fields to indicate the language and translation status of the assessment. Notice also that S_Header_Ex.Lang is also part of the table’s primary key and that queries using the assessment ID (mid/lid) and revision alone will not necessarily return unique records.

Primary Key: Session_MID int NOT NULL

Primary Key: Session_LID int NOT NULL

Primary Key: Revision int NOT NULL

Session_Name varchar(200) NOT NULL

Author varchar(200)

Created_Date datetime NOT NULL

Editor varchar(200) NOT NULL

Modified_Date datetime NOT NULL

Version varchar(6) NOT NULL

Save_Answers bit NOT NULL

Set to 1 if results will be recorded for this assessment.

Save_Answer_Data bit

Set to 1 if answers will be recorded for this assessment.

Open_Session bit NOT NULL

Session_Password varchar(80)

Session_Timed bit NOT NULL

Time_Limit int

Template_Name varchar(200) NOT NULL

When_Feedback smallint NOT NULL

End_Feedback smallint

Exclude_Unscored bit

Permit_External_Call bit

Monitored smallint

Lock_Session bit NOT NULL

Assessment_Type smallint

Metadata_ID int

Course_ID int

Run_From smallint

Anonymous bit

Secure bit

SAYG_Option smallint

SAYG_Timer int

Description varchar(1020)

Base bit NOT NULL

Primary Key: Lang varchar(10) NOT NULL

Source_Lang varchar(10) NOT NULL

Translation_Status int NOT NULL

Base_Revision int

ASSESSMENT_ID bigint computed NOT NULL