Data included in Export People and Assessments

The following 94 data columns are included in the MagicTools – for PI output when using Export Persons and their Assessment data to CSV 

  1. LastName
  2. FirstName
  3. MiddleName
  4. Email
  5. PersonType – Unknown, Candidate, Employee, Former Employee, Other
  6. ExternalPersonId – contains a value from an external system
  7. AssessmentUserId – internal PI identifier assigned for each person
  8. SortName – field used for sorting by name (Last First)
  9. SortDate – field used for sorting by date
  10. FolderId – PI folder id
  11. FolderPath – PI folder path including root folder and all intermediate folders
  12. UserId – PI user identifier, if present
  13. PersonCreatedTime
  14. Impression – rating of level of interest in a Candidate
  15. AssessmentInfo.LatestAssessmentCompletedDate
  16. AssessmentInfo.LatestAssessmentEmailSentDate
  17. ReferencePattern.PatternName
  18. ReferencePattern.BadgeUrl
  19. ReferencePattern.PatternNumber
  20. Behavioral.Assessment.Id
  21. Behavioral.Assessment.SentDate
  22. Behavioral.Assessment.CompletedDate
  23. Behavioral.Assessment.State – 10 = sent, 40 = complete, 50 = expired
  24. Behavioral.Assessment.AdministeredBy
  25. Behavioral.Assessment.AdministeredByPersonId – internal PI identifier
  26. Behavioral.Assessment.ScoreId
  27. Behavioral.OriginalAssessment.Id – internal PI identifier
  28. Behavioral.OriginalAssessment.ReferencePatternNumber
  29. Behavioral.OriginalAssessment.ReferencePatternName
  30. Behavioral.PendingAssessment.Id – internal PI identifier
  31. Behavioral.PendingAssessment.SendDate
  32. Behavioral.PendingAssessment.AdministeredBy
  33. Behavioral.PendingAssessment.AdministeredByPersonId – internal PI identifier
  34. Job.Name
  35. Job.FitScore.Combined
  36. Job.FitScore.Behavioral
  37. Job.FitScore.Cognitive
  38. Job.CognitiveTarget
  39. Job.JobId – internal PI identifier
  40. Job.LastModifiedDate
  41. Job.ModifiedByPersonId – internal PI identifier
  42. Cognitive.Assessment.Id – internal PI identifier
  43. Cognitive.Assessment.Score
  44. Cognitive.Assessment.Attempted – if optional Cognitive details requested
  45. Cognitive.Assessment.Correct – if optional Cognitive details requested
  46. Cognitive.Assessment.PercentileRank – if optional Cognitive details requested
  47. Cognitive.Assessment.CompletedDateTime
  48. Cognitive.Assessment.SentDate
  49. Cognitive.Assessment.State
  50. Cognitive.Assessment.AdministeredBy
  51. Cognitive.Assessment.AdministeredByPersonId – internal PI identifier
  52. Cognitive.PendingAssessment.Id
  53. Cognitive.PendingAssessment.SentDate
  54. Cognitive.PendingAssessment.AdministeredBy
  55. Cognitive.PendingAssessment.AdministeredByPersonId – internal PI identifier
  56. ReferencePattern.ASigma
  57. ReferencePattern.BSigma
  58. ReferencePattern.CSigma
  59. ReferencePattern.DSigma
  60. Behavioral.Assessment.Score.Self.ASigma
  61. Behavioral.Assessment.Score.Self.BSigma
  62. Behavioral.Assessment.Score.Self.CSigma
  63. Behavioral.Assessment.Score.Self.DSigma
  64. Behavioral.Assessment.Score.Self.ESigma
  65. Behavioral.Assessment.Score.Self.MScore
  66. Behavioral.Assessment.Score.SelfConcept.ASigma – if optional BA details requested
  67. Behavioral.Assessment.Score.SelfConcept.BSigma – if optional BA details requested
  68. Behavioral.Assessment.Score.SelfConcept.CSigma – if optional BA details requested
  69. Behavioral.Assessment.Score.SelfConcept.DSigma – if optional BA details requested
  70. Behavioral.Assessment.Score.SelfConcept.MScore – if optional BA details requested
  71. Behavioral.Assessment.Score.Synthesis.ASigma – if optional BA details requested
  72. Behavioral.Assessment.Score.Synthesis.BSigma – if optional BA details requested
  73. Behavioral.Assessment.Score.Synthesis.CSigma – if optional BA details requested
  74. Behavioral.Assessment.Score.Synthesis.DSigma – if optional BA details requested
  75. Behavioral.Assessment.Score.Synthesis.ESigma – if optional BA details requested
  76. Behavioral.Assessment.Score.Synthesis.MScore – if optional BA details requested
  77. Behavioral.Assessment.ScoreAlt.Self.ASigma
  78. Behavioral.Assessment.ScoreAlt.Self.BSigma
  79. Behavioral.Assessment.ScoreAlt.Self.CSigma
  80. Behavioral.Assessment.ScoreAlt.Self.DSigma
  81. Behavioral.Assessment.ScoreAlt.Self.ESigma
  82. Behavioral.Assessment.ScoreAlt.Self.MScore
  83. Job.BehavioralTarget.ASigma
  84. Job.BehavioralTarget.BSigma
  85. Job.BehavioralTarget.CSigma
  86. Job.BehavioralTarget.DSigma
  87. Job.BehavioralTarget.ASigmaRangeLow
  88. Job.BehavioralTarget.ASigmaRangeHigh
  89. Job.BehavioralTarget.BSigmaRangeLow
  90. Job.BehavioralTarget.BSigmaRangeHigh
  91. Job.BehavioralTarget.CSigmaRangeLow
  92. Job.BehavioralTarget.CSigmaRangeHigh
  93. Job.BehavioralTarget.DSigmaRangeLow
  94. Job.BehavioralTarget.DSigmaRangeHigh