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 flag 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
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