Academic Data Import

Academic data is term-level data about students that can be used to track student progress in an academic program, assign appropriate Student Learning & Licensure activities, and aggregate/disaggregate their performance data in reports. The information used to populate these fields may be available within your student information system, and should be updated on a regular (either yearly or each term) basis. This article outlines the academic data fields that can be imported into Student Learning & Licensure.


Academic Data Fields

User ID

  • Explanation: Defines which user this data belongs
  • Field Type and Length: Defined options
  • Sample file column: N/A
  • Import Status: Required

Term Code

  • Explanation: Defines which term the data is relevant
  • Field Type and Length: Defined options
  • Sample file column: N/A
  • Import Status: Required

Cumulative GPA

  • Explanation: Student's cumulative GPA
    • Accepted Values:
      • Whole numbers or decimals
  • Field Type and Length: Defined options
  • Sample file column: N/A
  • Import Status: Optional

Term GPA

  • Explanation: Student's GPA for term listed in column B
    • Accepted Values:
      • Whole numbers or decimals
  • Field Type and Length: No decimal limit
  • Sample file column: N/A
  • Import Status: Optional

Attending Status

  • Explanation: Defines if user is a full-time student
    • Accepted Values:
      • Part-time = "PTE"
      • Full-time = "FTE"
  • Sample file column: N/A
  • Import Status: Optional

Primary Major

  • Explanation: Defines user's primary major
  • Field Type and Length: Alphanumeric, 50
  • Sample file column: N/A
  • Import Status: Optional

Primary Major Concentration

  • Explanation: Defines user's primary major concentration
  • Field Type and Length: Alphanumeric, 50
  • Sample file column: N/A
  • Import Status: Optional

Additional Major

  • Explanation: Defines user's additional major or second major
  • Field Type and Length: Alphanumeric, 50
  • Sample file column: N/A
  • Import Status: Optional

Additional Major Concentration

  • Explanation: Defines user's additional major concentration or second major concentration
  • Field Type and Length: Alphanumeric, 50
  • Sample file column: N/A
  • Import Status: Optional

Minor

  • Explanation: Defines user's minor
  • Field Type and Length: Alphanumeric, 50
  • Sample file column: N/A
  • Import Status: Optional

Earned Credit Hours

  • Explanation: Student's cumulative credit hours at time of term listed in column B
    • Accepted Values:
      • Whole numbers or decimals
  • Field Type and Length: No decimal limit
  • Sample file column: N/A
  • Import Status: Optional

This article has outlined the various academic data fields and their specifications for import into Student Learning & Licensure. Regularly updating this information ensures accurate student tracking and reporting. For more details on how to troubleshoot common import errors, refer to Troubleshooting import errors.

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

How to Contact Support
There are many ways to reach out! Click the icon above for our support options.
Watermark Academy
Click the icon above to access the Watermark Academy for consultation, training, and implementation companion courses.
Customer Community
Can’t find the answer? Ask fellow users how they’re making the most of Watermark in our Community!