Program Information Exchange - For Flat-File
- Nicolette delMuro
- Ian Christopher (Deactivated)
- Chandra Shekhar
This page contains a specification for the NSPA Scholarship Program Information Data Exchange for Flat-File specification.
Notes & Implementation Guidelines
Simple & Extended Representations
Specifications are provided for a Simple Flat-File and an Extended Flat-File.
The Simple Flat-File is suitable for review and editing by humans. The fields present are those with common-language definitions and the data entry options are simple.
The Extended Flat-File is suitable for expert human data entry and machine-to-machine transfer. Some fields can contain multiple values, other fields have constraints or require reference to external value lists, and so forth.
The specification table below shows which fields are part of the Simple vs. Extended specifications.
Both specifications are currently v1.0.
General Notes
Only two fields are required: the Program Name and Organization Name.
A transformation from the flat-file to the NSPA Data Standard loses no information. However, similar to many flat-file representations of complex data models, a transformation from the complex NSPA Data Standard (say, JSON data file) may lose information. This is because not all fields are present in the Flat-File specification, and many repeating elements in the JSON are not easily mapped to a workable flat-file format.
Spec & Schema Mapping
The specification below shows whether an element is included in the Simple or Extended Flat-File, as well as a mapping to the appropriate element in the NSPA Scholarship Program Data Standard.
Â
Column Name | Element Mapping | Part of | Part of Extended? | Required? | General Type | Text Length |
|---|---|---|---|---|---|---|
Program Reference ID | ProgramReferenceID | Yes | Yes | Â | Text | 256 |
Program Name | ProgramName | Yes | Yes | Yes | Text | 100 |
Organization Name | ProgramOrganization.OrganizationName | Yes | Yes | Yes | Text | 100 |
Program Self-Description | ProgramSelfDescription | Yes | Yes | Â | Multi-Line Text | 4000 |
Award Amount | ScholarshipMaximumAward | Yes | Yes | Â | Integer | Â |
Minimum Award | ScholarshipMinimumAward | Yes | Yes | Â | Integer | Â |
Number of Awards | NumberOfScholarshipsAwarded | Yes | Yes | Â | Integer | Â |
Minimum GPA | EligibilityCriteria.Academics.AcademicEligibility | Yes | Yes | Â | Decimal | Â |
Maximum GPA | EligibilityCriteria.Academics.AcademicEligibility | Â | Yes | Â | Decimal | Â |
Open Date | OpenDate | Yes | Yes | Â | Date | Â |
Close Date | CloseDate | Yes | Yes | Â | Date | Â |
Award Announcement Date | AnnouncementDate | Yes | Yes | Â | Date | Â |
Program URL | ProgramURL | Yes | Yes | Â | Text | 512 |
Application URL | ApplicationURL | Yes | Yes | Â | Text | 512 |
Application Type | Metadata-Only | Yes | Yes | Â | Option List | 256 |
Is Need-Based | IsNeedBased | Yes | Yes | Â | Option List | 24 |
Is Merit-Based | IsMeritBased | Yes | Yes | Â | Option List | 24 |
Is Contest | IsContest | Yes | Yes | Â | Option List | 24 |
Minimum Overall SAT | EligibilityCriteria.Academics.AcademicEligibility | Yes | Yes | Â | Integer | Â |
Minimum SAT Math | EligibilityCriteria.Academics.AcademicEligibility | Â | Yes | Â | Integer | Â |
Minimum SAT Evidence-Based Reading and Writing | EligibilityCriteria.Academics.AcademicEligibility | Â | Yes | Â | Integer | Â |
Minimum Class Rank Percentage | EligibilityCriteria.Academics.AcademicEligibility | Yes | Yes | Â | Decimal | Â |
Minimum ACT Composite | EligibilityCriteria.Academics.AcademicEligibility | Yes | Yes | Â | Integer | Â |
Maximum Class Rank Percentage | EligibilityCriteria.Academics.AcademicEligibility | Â | Yes | Â | Decimal | Â |
Activity | EligibilityCriteria.Activity | Â | Yes | Â | Option List + Free Text | 512 |
Citizenship Status | EligibilityCriteria.CitizenshipStatuses | Â | Yes | Â | Option List | 512 |
Current Grade Level | EligibilityCriteria.CurrentGradeLevel | Â | Yes | Â | Option List | 512 |
College Type | EligibilityCriteria.CollegePlans.CollegeType | Â | Yes | Â | Option List | 512 |
College Category | EligibilityCriteria.CollegePlans.CollegeCategory | Â | Yes | Â | Option List | 512 |
Current School NCES Codes | EligibilityCriteria.CurrentSchool.School.NCESCode | Â | Yes | Â | Text | 512 |
Current School CEEB Codes | EligibilityCriteria.CurrentSchool.School.CEEBCode | Â | Yes | Â | Text | 512 |
College Attendance NCES Codes | EligibilityCriteria.CollegePlan.College.NCESCode | Â | Yes | Â | Text | 512 |
College Attendance CEEB Codes | EligibilityCriteria.CollegePlan.College.CEEBCode | Â | Yes | Â | Text | 512 |
Graduation Status NCES Codes | EligibilityCriteria.Graduation.AlmaMater.NCESCode | Â | Yes | Â | Text | 512 |
Graduation Status CEEB Codes | EligibilityCriteria.Graduation.AlmaMater.CEEBCode | Â | Yes | Â | Text | 512 |
Degree Seeking | EligibilityCriteria.DegreeSeeking | Â | Yes | Â | Option List | 512 |
Full-Time Student | EligibilityCriteria.EnrollmentStatus | Yes | Yes | Â | Text | 24 |
Gender | EligibilityCriteria.Demographics | Â | Yes | Â | Option List | 512 |
Race | EligibilityCriteria.Demographics | Â | Yes | Â | Option List | 512 |
LGBTQ+ | EligibilityCriteria.Demographics | Â | Yes | Â | Option List + Free Text | 512 |
Minimum Age | EligibilityCriteria.Age.MinimumAgeRequirement | Â | Yes | Â | Integer | Â |
Maximum Age | EligibilityCriteria.Age.MaximumAgeRequirement | Â | Yes | Â | Integer | Â |
Maximum AGI | EligibilityCriteria.FinancialInformation.FinancialEligibility.Amount | Yes | Yes | Â | Integer | Â |
Maximum EFC | EligibilityCriteria.FinancialInformation.FinancialEligibility.Amount | Yes | Yes | Â | Integer | Â |
City | EligibilityCriteria.Locations.Location.City | Â | Yes | Â | Text | 512 |
County | EligibilityCriteria.Locations.Location.County | Â | Yes | Â | Text | 512 |
State | EligibilityCriteria.Locations.Location.State | Â | Yes | Â | Text (From Option List) | 512 |
Country | EligibilityCriteria.Locations.Location.Country | Â | Yes | Â | Text | Â |
Award Duration Type | AwardDuration.AwardDurationType | Â | Yes | Â | Option List | 512 |
Duration Years | AwardDuration.DurationYears | Â | Yes | Â | Integer | Â |
Application Restriction | EligibilityCriteria.ApplicationRestriction.ApplicationRestriction | Â | Yes | Â | Option List | 512 |
Listing Flags | NoteworthyApplicationCharacteristics.ListingFlags.ListingFlag | Â | Yes | Â | Option List | 512 |
Â