Data included in Export People and Assessments

The following 89 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
  9. SortDate – field used for sorting by date
  10. FolderId – PI folder id
  11. FolderPath – PI folder path
  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.CompletedDateTime
  45. Cognitive.Assessment.SentDate
  46. Cognitive.Assessment.State
  47. Cognitive.Assessment.AdministeredBy
  48. Cognitive.Assessment.AdministeredByPersonId – internal PI identifier
  49. Cognitive.PendingAssessment.Id
  50. Cognitive.PendingAssessment.SentDate
  51. Cognitive.PendingAssessment.AdministeredBy
  52. Cognitive.PendingAssessment.AdministeredByPersonId – internal PI identifier
  53. ReferencePattern.ASigma
  54. ReferencePattern.BSigma
  55. ReferencePattern.CSigma
  56. ReferencePattern.DSigma
  57. Behavioral.Assessment.Score.Self.ASigma
  58. Behavioral.Assessment.Score.Self.BSigma
  59. Behavioral.Assessment.Score.Self.CSigma
  60. Behavioral.Assessment.Score.Self.DSigma
  61. Behavioral.Assessment.Score.Self.ESigma
  62. Behavioral.Assessment.Score.Self.MScore
  63. Behavioral.Assessment.Score.SelfConcept.ASigma
  64. Behavioral.Assessment.Score.SelfConcept.BSigma
  65. Behavioral.Assessment.Score.SelfConcept.CSigma
  66. Behavioral.Assessment.Score.SelfConcept.DSigma
  67. Behavioral.Assessment.Score.SelfConcept.MScore
  68. Behavioral.Assessment.Score.Synthesis.ASigma
  69. Behavioral.Assessment.Score.Synthesis.BSigma
  70. Behavioral.Assessment.Score.Synthesis.CSigma
  71. Behavioral.Assessment.Score.Synthesis.DSigma
  72. Behavioral.Assessment.Score.Synthesis.ESigma
  73. Behavioral.Assessment.Score.Synthesis.MScore
  74. Behavioral.Assessment.ScoreAlt.Self.ASigma
  75. Behavioral.Assessment.ScoreAlt.Self.BSigma
  76. Behavioral.Assessment.ScoreAlt.Self.CSigma
  77. Behavioral.Assessment.ScoreAlt.Self.DSigma
  78. Behavioral.Assessment.ScoreAlt.Self.ESigma
  79. Behavioral.Assessment.ScoreAlt.Self.MScore
  80. Job.BehavioralTarget.ASigma
  81. Job.BehavioralTarget.BSigma
  82. Job.BehavioralTarget.CSigma
  83. Job.BehavioralTarget.DSigma
  84. Job.BehavioralTarget.ASigmaRangeLow
  85. Job.BehavioralTarget.ASigmaRangeHigh
  86. Job.BehavioralTarget.BSigmaRangeLow
  87. Job.BehavioralTarget.BSigmaRangeHigh
  88. Job.BehavioralTarget.CSigmaRangeLow
  89. Job.BehavioralTarget.CSigmaRangeHigh