Follow

Definitions of Export Fields

Wondering what all of that data is in an export? Use the below table for definitions and example of each field.   

FieldName SQL DataType Definition Sample
mLevelUserID UNIQUEIDENTIFIER A unique identifier used within the mLevel platform to signify a single user's identity 77fb83b9-3fa3-4506-8bcb-44855e9565bc
DisplayName NVARCHAR The formatted user's name that is shown around the system in various leaderboards etc. Jose Chavez
FirstName NVARCHAR The user's first name Jose
LastName NVARCHAR The user's last name Chavez
CustUserName NVARCHAR The formatted username identifier specified by the customer f12323
UserEmail NVARCHAR The email address for the user, associated with their mLevel credentials jose.chavez@domain.net
MissionID UNIQUEIDENTIFIER A unique identifier used within the mLevel platform to signify a single mission fc9d5e38-6f29-4822-a186-1590695350fe
MissionName NVARCHAR The name given to the mission, by which it is referred. Smartphone Fun
GameTypeID INT The integer value used to identify games that belong to a particular class. (I.e. 1206 = Fast Lane) 1206
GameTypeDisplayName NVARCHAR The string representation of the GameTypeID, used to colloquially refer to particular classes of activities. Fast Lane
Plays INT The number of times a particular activity has been played 1
MaxPoints INT The maximum number of points achieved 53
AvgPoints INT The average number of points achieved 53
MinPoints INT Record of the lowest number of points achieved 53
MinKnowledgeAccuracy FLOAT Minimum knowledge accuracy earned 0.2380952
MaxKnowledgeAccuracy FLOAT Maximum knowledge accuracy earned 0.2380952
AvgKnowledgeAccuracy FLOAT Average knowledge accuracy taken across gameplays 0.2380952
MinKnowledgeScore INT Minimum score achieved playing this activity 5
MaxKnowledgeScore INT Maximum score achieved playing this activity 5
AvgKnowledgeScore INT Average score achieved playing this activity 5
AvgKnowledgeMaxScore INT Average number of questions that can be received for the game type 21
AvgPlayDuration INT Average span of time spent on this activity for a single play 210871
TotalPlayDuration INT Total span of time spent on this activity for a single play 210871
TotalDuration INT Total span of time spent on this activity including pauses. 212216
PointsPctChange INT The percentage difference in points achieved across multiple game plays 0
KnowledgeAccuracyPctChange INT The percentage difference in knowledge accuracy earned across multiple game plays 0
GameSetScoreID UNIQUEIDENTIFIER Unique identifier used to reference the score submitted for a particular bundle of topic questions and answers 393360a4-a94d-4743-9c9d-2ed5078c77f6
MissionIsActive BIT Bit flag used to signal whether or not the mission is active FALSE
GameID UNIQUEIDENTIFIER A unique identifier used within the mLevel platform to signify a single game instance 10d200e0-c68d-40dc-a369-0015772fc7ee
GameIsActive BIT Bit flat used to signal whether or not the game is active TRUE
DatePlayed DateTime The date on which the game was played 5/2/14 21:36
Score INT Score achieved on this gameplay (*will change to points) 45
Duration INT Total time spent answering questions during an activity (*will change to PlayDuration) 533442
Pauses INT Total number of times user paused the game while playing 4
PlayerGamePlayScoreRank INT Players relative position compared to other players, calculated by score. 15
TopicID UNIQUEIDENTIFIER A unique identifier used within the mLevel platform to reference the topic whose knowledge is being tested edb197c2-85b8-4f5a-8a12-2bd01a4f4148
TopicName NVARCHAR Colloquial name used to refer to and identify the topic whose knowledge is being tested Smartphone Fun
QuestionText NVARCHAR The literal wording of the question presented to the user This mLevel 2.0 addition is a help screen within each game activity.
Correct INT The number of times the question has been answered correctly 4
Incorrect INT The number of times the question has been answered incorrectly 6
PercentCorrect FLOAT the percent of the time the question is answered correctly 0.4
GameEventType NVARCHAR Refers to the generic structure of the game or the way questions are presented to the user via the game Comparison
GameEventFactID UNIQUEIDENTIFIER Unique identifier used to refere to a single event defined within the context of a particular game type c88dae03-91f4-450c-ab66-d70c8c227fda
TenantID UNIQUEIDENTIFIER Unique identifier used to refer back to the mLevel customer to which the current user belongs 127c9cd2-5dd4-4c13-bc34-4988497cffe5
ConcreteQuestionID UNIQUEIDENTIFIER Unique identifier referring back to a particular bundling of a question along with specific right and wrong answers 7affc274-eec5-4027-921a-0722388bc20f
AbstractQuestionID UNIQUEIDENTIFIER Unique identifier referring back to the question template used to generate a set of Concrete Questions 22e23457-f3d8-4f99-9922-43010efdfc94
AQTopicID UNIQUEIDENTIFIER Unique identifier referring back to the Topic associated with the question template. 90aec28a-754b-441a-96e0-18d6f41c28b9
AQTopic NVARCHAR The topic name for the topic associated with the question template Smartphone Fun
AQTopicItemID UNIQUEIDENTIFIER Unique identifier referring back to a single topic item associated with the question template edb197c2-85b8-4f5a-8a12-2bd01a4f4148
AQTopicItem NVARCHAR Text value for the topic item specified by AQTopicItemID iPhone
AQTopicAttributeID UNIQUEIDENTIFIER Unique identifier referring back to a single topic attribute associated with the question template 79c6f800-66e2-4c74-a973-90d2bf61a292
AQTopicAttribute NVARCHAR Text value for the topic attribute specified by AQTopicAttributeID color
AQTopicAttributeValueID UNIQUEIDENTIFIER Unique identifier referring back to a single topic attribute value associated with the question template 261c1480-42ad-4a3d-a683-7b0a52a55179
AQTopicAttributeValue NVARCHAR Text value for the topic attribute specified by AQTopicAttributeID white
CorrectAnswerID UNIQUEIDENTIFIER Unique identifier referring to the correct answer provided in the concrete question bundle 61441808-5350-4b7a-9587-f875be22e3fb
CATopicID UNIQUEIDENTIFIER Unique identifier referring back to the Topic associated with the correct answer. 90aec28a-754b-441a-96e0-18d6f41c28b9
CATopic NVARCHAR The topic name for the topic associated with the question template Smartphone Fun
CATopicItemID UNIQUEIDENTIFIER Unique identifier referring back to a single topic item associated with the correct answer edb197c2-85b8-4f5a-8a12-2bd01a4f4148
CATopicItem NVARCHAR Text value for the topic item specified by CATopicItemID iPhone
CATopicAttributeID UNIQUEIDENTIFIER Unique identifier referring back to a single topic attribute associated with the correct answer 79c6f800-66e2-4c74-a973-90d2bf61a292
CATopicAttribute NVARCHAR Text value for the topic attribute specified by CATopicAttributeID color
CATopicAttributeValueID UNIQUEIDENTIFIER Unique identifier referring back to a single topic attribute value associated with the correct answer 261c1480-42ad-4a3d-a683-7b0a52a55179
CATopicAttributeValue NVARCHAR Text value for the topic attribute specified by CATopicAttributeID white
AnswerAttempts INT The number of times an answer was attempted for the specific ConcreteQuestion 3
AnsweredOnAttempt INT The attempt on which the question was answered correctly. 3
PossibleAnswers INT The number of correct answers provided with the Concrete Question 2
EventTimeStamp DateTime The approximate time at which the event was fired. 4/21/14 21:36
UserActivityPoints INT The total points achieved in this gameplay 25
UserActivityDuration INT The time spent on this game play 53442
UserActivityPauses INT Total number of times the user paused the game 3
UserActivityStars INT Total stars user earned on this game play. 0.66666667
UserMasteryLevelCompletionPercentage FLOAT Percentage Mastery completion for mission upon completing current game play. 1.25
UserMissionStars INT Total stars user has earned for the mission to which this game belongs. 9
UserMissionPoints INT Total points user has earned across all games in mission. 45
UserMissionHighScoreDuration INT Total time spent playing the activity when user achieved high score 34543
UserMissionTotalPlayDuration INT Total time user spent playing this mission 25541
UserMissionMasteryAchieved BIT Bit flag indicating whether a user has successfully mastered the given mission TRUE
ActivityPointsFor1Star INT Number of points required for user to achieve one star for this game 22
ActivityPointsFor2Star INT Number of points required for user to achieve two stars for this game 44
ActivityPointsFor3Star INT Number of points required for user to achieve three stars for this game 66

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk