Attachment F- List of Fields in the Current Solution.xlsx

This document is a data field specification sheet for a Gifted and Talented (GT) Application Software system being procured by the State of South Carolina. The file outlines the complete database structure and field definitions for the current GT identification and tracking solution, which manages student information across multiple dimensions of gifted program identification and enrollment.

The system maintains comprehensive student demographic data including PowerSchool ID, state ID, name, guardian information, address, contact details, and enrollment information. The database tracks multiple assessment categories: five aptitude assessments (with composite, verbal, non-verbal, and quantitative scores), up to nine achievement assessments (measuring ELA/Reading and Math performance), GPA data, PTA (Primary and Intermediate) assessment results, and a three-dimensional assessment component. Additionally, the system records gifted and talented program status, serving models, and program enrollment dates. The application includes specialized tracking for identification across four arts disciplines: dance, drama, music, and visual arts, with each discipline capturing referral information, screener names, screening dates, status, and serving models. Each field is defined with specific data types (character, date, logical, or numeric) and character width specifications to support data integration, reporting, and student progress monitoring throughout the gifted and talented identification and service delivery process.