AssessmentSnapshot & BlockSnapshot¶
- TABLE AssessmentSnapshot¶
Contains information about assessment snapshots
- Primary Key: AssessmentSnapshot_ID int NOT NULL¶
The unique ID of the snapshot is automatically allocated.
- Assessment_ID bigint NOT NULL¶
The full ID of the assessment (combined MID and LID). See
S_Header_Ex.Session_MID
for details.
- Lang varchar(10) NOT NULL¶
The language of the assessment. See
S_Header_Ex.Lang
- Name nvarchar(200) NOT NULL¶
A human-readable descriptive name for this snapshot.
- Revision int NOT NULL¶
The revision of the assessment. See
S_Header_Ex.Revision
. The snapshot stores all the information it needs to deliver and assessment in this table (and the associatedBlockSnapshots
). As a result, it doesn’t matter if the assessment that was used to create the snapshot is later revised or deleted. Bear in mind that the Revision is also part of the primary key in S_Header_Ex.
- Created_Date datetime NOT NULL¶
Timestamp recording creation time of snapshot.
- Modified_Date datetime NOT NULL¶
Timestamp recording modification time snapshot
- Expires_Date datetime¶
Optional timestamp recording expiry time of snapshot.
- Data varbinary(max) NOT NULL¶
Binary data used to describe the snapshot. You can obtain a full XML representation of the snapshot using the
deliveryodata.AssessmentSnapshotsData
feed.
- TABLE BlockSnapshot¶
Each AssessmentSnapshot is comprised of some information about the assessment as a whole and a set of associated blocks. The blocks are stored separately because, in many cases, they are not subject to randomization and so are therefore common to all snapshots of the assessment.
- Primary Key: BlockSnapshot_ID uniqueidentifier NOT NULL¶
- Created_Date datetime NOT NULL¶
- Data varbinary(max) NOT NULL¶
Binary data used to describe this block within a snapshot. You can obtain a full XML representation of the snapshot using the
deliveryodata.AssessmentSnapshotsData
feed.
- TABLE BlocksInAssessmentSnapshot¶
Stores the list of blocks for each snapshot. The Order field is used to allow an ordered list of BlockSnapshots to be associated with a single AssessmentSnapshot.
- Primary Key: AssessmentSnapshot_ID int NOT NULL¶
- Primary Key: BlockSnapshot_ID uniqueidentifier NOT NULL¶
- Order int NOT NULL¶