Skip to main content
Skip table of contents

S_AK_STU_X (ver 14.1.0)

This is an extension of the Students table.

Column Name

Version

Data Type

Description

StudentsDCID

14.1.0

Number(10,0)

Primary Key

SHSEQ

14.1.0

Varchar2(10)

Identifying Code for Migrant Student System Exchange.

AA_Math

14.4.0

Varchar2(1)

Alternate Assessment for Math.

AA_Read

14.4.0

Varchar2(1)

Alternate Assessment for Reading.

AA_Science

14.4.0

Varchar2(1)

Alternate Assessment for Science.

AA_Writing

14.4.0

Varchar2(1)

Alternate Assessment for Writing.

academicOption 15.7.0  Varchar2(5) Academic option-APS eligible Students only. Migrated from [Students.ak_academicOption].
AccommodatedMath 15.7.0Varchar2(5)  Accommodated Math. Migrated from [Students.ak_AccommodatedMath].
AccommodatedReading15.7.0Varchar2(5) Accommodated Reading. Migrated from [Students.ak_AccommodatedReading].
AccommodatedScience15.7.0 Varchar2(5)Accommodated Science. Migrated from [Students.ak_AccommodatedScience].
AccommodatedWriting15.7.0Varchar2(5) Accommodated Writing. Migrated from [Students.ak_AccommodatedWriting].
ActiveDuty_PG 15.3.0 Varchar2(1) PartRate ActiveDuty.
ActiveDuty_PGOct1 16.9.6 Varchar2(1) Active Duty Parent/Guardian on Oct 1st.
AlternateAssessment 15.7.0 Varchar2(5) Alternate Assessment. Migrated from [Students.ak_AlternateAssessment].
ATI_LanguageArts 15.3.0    Number(10,0) PartRate ATILangArts.
ATI_Math 15.3.0    Number(10,0)  PartRate ATIMath.
ATI_Science15.3.0 Number(10,0) PartRate ATIScience.
CareerEligibility 15.7.0Varchar2(5) Career Performance Scholarship Eligibility. Migrated from [Students.ak_CareerEligibility].
CCRA15.10.0 Varchar2(5) State-Paid CCRA.
CCRA15.10.0 Varchar2(5) State-Paid CCRA.
CollegiateEligibility 15.7.0 Varchar2(5)  Collegiate Performance Scholarship Eligibility. Migrated from [Students.ak_CollegiateEligibility].
concentrator15.7.0 Varchar2(5)Concentrator. Migrated from [Students.ak_concentrator].
CurriculumMet15.7.0Varchar2(5)Performance Scholarship Curriculum Requirements Met. Migrated from [Students.ak_CurriculumMet].
disability_code15.7.0 Varchar2(5)Disability. Migrated from [Students.ak_disability_code].
disability_entry15.7.0 DateLast Disability Entry Date. Migrated from [Students.ak_disability_entry].
disability_exit15.7.0 DateLast Disability Exit Date. Migrated from [Students.ak_disability_exit].
displaced_homemaker15.7.0 Varchar2(5)Displaced Homemaker. Migrated from [Students.ak_displaced_homemaker].
dualEnrolled15.7.0Varchar2(5)Dual Enrollment. Migrated from [Students.ak_dualEnrolled].
econ15.7.0 Varchar2(5)Economically Disadvantaged. Migrated from [Students.ak_econ].
education_placement15.7.0Varchar2(5)Special Education Placement. Migrated from [Students.ak_education_placement].

ELPNotAssessed

14.6.0

Number(10,0)

ELP Not Assessed Reason.

ExcLAPart 15.3.0  Varchar2(1)  PartRate ExcLAPart.
ExcLAPerf 15.3.0   Varchar2(1)  PartRate ExcLAPerf.
FallOASISMembership14.12.0 Number(10,0) Fall Oasis Membership Override.
FAYSchool15.7.0Varchar2(5)FAY - School. Migrated from [Students.ak_FAYSchool].
FAY_District15.7.0Varchar2(5)FAY - District. Migrated from [Students.ak_FAY_District].
First9grade15.7.0 Varchar2(10)Student Initial Ninth Grade Entry Year. Migrated from [Students.ak_First9grade].
fte 15.7.0

Number(25,10)

Primary Enrollment FTE. Migrated from [Students.ak_fte].
FTE214.10.1Number(25,10)Secondary FTE for Dual Enrolled Students.

FYIExRPart

14.4.0

Varchar2(1)

FYI Exclusion from Reading Participation.

FYIExRPerf

14.4.0

Varchar2(1)

FYI Exclusion from Reading Performance.

FYIExWPart

14.4.0

Varchar2(1)

FYI Exclusion from Writing Participation.

FYIExWPerf

14.4.0

Varchar2(1)

FYI Exclusion from Writing Performance.

grad_date15.7.0DateActual Graduation Date. Migrated from [Students.ak_grad_date].
GroupName15.7.0Varchar2(30)Group Name. Migrated from [Students.ak_GroupName].
homeless15.7.0Varchar2(5)Homeless Student. Migrated from [Students.ak_homeless].
homeless_residence15.7.0 Varchar2(5)Homeless Student's Primary Nighttime Residence. Migrated from [Students.ak_homeless_residence].
iep_july15.7.0 Varchar2(5)IEP in Place on July 1. Migrated from [Students.ak_iep_july].
iep_oct15.7.0 Varchar2(5)October 1 Children with Disabilities Child Count. Migrated from [Students.ak_iep_oct].
immigrant15.7.0Varchar2(5)Immigrant Student. Migrated from [Students.ak_immigrant].
immigrant_entry15.7.0DateImmigrant Student - First U.S. School Entry Date. Migrated from [Students.ak_immigrant_entry].
intensive_funding15.7.0 Varchar2(5)Intensive Level of Funding. Migrated from [Students.ak_intensive_funding].
IsTitle1ACareerTech15.7.0 Varchar2(5)Title IA Targeted Assistance Services - Vocational/Career. Migrated from [Students.ak_IsTitle1ACareerTech].
IsTitle1AGuidance15.7.0Varchar2(5)Title IA Targeted Assistance Services - Supporting Guidance/Advocacy. Migrated from [Students.ak_IsTitle1AGuidance].
IsTitle1AHealthServices15.7.0 Varchar2(5)Title IA Targeted Assistance Services - Health, Dental, Eye Care.Migrated from [Students.ak_IsTitle1AHealthServices].
IsTitle1AMath15.7.0Varchar2(5)Title IA Targeted Assistance Services - Mathematics. Migrated from [Students.ak_IsTitle1AMath].
IsTitle1AOtherInstructional15.7.0Varchar2(5)Title IA Targeted Assistance Services - Other Instructional Services.Migrated from [Students.ak_IsTitle1AOtherInstructional].
IsTitle1AOtherSupport15.7.0 Varchar2(5)Title IA Targeted Assistance Services - Other Support Services.Migrated from [Students.ak_IsTitle1AOtherInstructional].
IsTitle1AReadingLa 15.7.0Varchar2(5)Title IA Targeted Assistance Services - Reading/Language Arts.Migrated from [Students.ak_IsTitle1AReadingLa].
IsTitle1AScience15.7.0Varchar2(5)Title IA Targeted Assistance Services - Science. Migrated from [Students.ak_IsTitle1AScience].
IsTitle1ASocStud15.7.0Varchar2(5)Title IA Targeted Assistance Services - Social Studies. Migrated from [Students.ak_IsTitle1ASocStud].
LAParticipation15.7.0Varchar2(5)FYI - Exclude from Language Arts Participation. Migrated from [Students.ak_LAParticipation].
LAPerformance15.7.0Varchar2(5)FYI - Exclude from Language Arts Performance. Migrated from [Students.ak_LAPerformance].
lep15.7.0Varchar2(5)LEP Student. Migrated from [Students.ak_lep].
LEPAccommodated15.7.0Varchar2(5)ak_LEPAccommodated. Migrated from [Students.ak_LEPAccommodated].
lep_entry15.7.0DateLast LEP Entry Date. Migrated from [Students.ak_lep_entry].
lep_exit15.7.0DateLast LEP Exit Date. Migrated from [Students.ak_lep_exit].
lep_former15.7.0Varchar2(5)Former LEP Student Academic Progress. Migrated from [Students.ak_lep_former].
lep_lang15.7.0Varchar2(5)Bilingual/LEP Language Type. Migrated from [Students.ak_lep_lang].
MAPerformance15.7.0Varchar2(5)Recently Arrived-LEP: Exclude from Mathematics Performance.Migrated from [Students.ak_MAPerformance].
migrant15.7.0Varchar2(5)Migrant (Title IC) Eligible. Migrated from [Students.ak_migrant].
MigrantOct116.9.6Varchar2(1)October 1 Migrant Ed Approved Count
OptOutAMYA 15.1.0 Boolean Opt Out Student from AMYA.
record_notes23.6.2.0Varchar2(500)Notes. Migrated from [Students.ak_record_notes].
Section50415.7.0 Varchar2(5)504 Plan Participant. Migrated from [Students.ak_504].
single_parent15.7.0Varchar2(5)Single Parent. Migrated from [Students.ak_single_parent].
SPEDOnly15.7.0Varchar2(5)SPED Student Only. Migrated from [Students.ak_SPEDOnly].
suffix15.7.0 Varchar2(15)Suffix. Migrated from [Students.ak_suffix].
tech_prep15.7.0Varchar2(5)Tech Prep 1. Migrated from [Students.ak_tech_prep].
tech_prep215.7.0Varchar2(5) Tech Prep 2. Migrated from [Students.ak_tech_prep2].
title_ia15.7.0Varchar2(5) Title IA Student. Migrated from [Students.ak_title_ia].
transfer_ge15.7.0Varchar2(5) Transfer to General Education. Migrated from [Students.ak_transfer_ge].
transfer_ge_date15.7.0DateTransfer to General Education Date. Migrated from [Students.ak_transfer_ge_date].

Unaccompanied

14.6.0

Varchar2(1)

Unaccompanied Homeless Youth.

Grade9_Algebra18.3.0Varchar2(1)Grade 9 Algebra student override for participation rate
RaEl22.3.2Varchar2(1)Recently Arrived English Learner
ATIoverride23.8.1.0Varchar(6)Teacher identification number override field



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.