Skip to main content
Skip table of contents

S_AL_STU_SpecEdProfile_X (ver 23.5.1.0)

This is an extension of the Students table and is used for reporting Special Programs data to the state ODS.

Column Name

Version

Data Type

Description

ALAltAssPart

20.8.2.0

Varchar2(4)

Alabama Alternate Assessment Participation

AnRevDueDate

20.8.2.0

Date

Annual Review Due Date

CaseManager

20.8.2.0

Varchar2(50)

Case Manager

ConReevalRcdDate

20.8.2.0

Date

Date Consent for Reevaluation Received

ConReevalSentDate

20.8.2.0

Date

Notice of Consent For Reevaluation Date

ConsInitEval

20.8.2.0

Varchar2(100)

Consent for Initial Evaluation

CountryOfOrigin

20.8.2.0

Varchar2(50)

Country of Origin

CourOfStudy

20.8.2.0

Varchar2(4)

Student in a middle school course of study

CurrentEvaluationDate

20.8.2.0

Date

Current Evaluation Date

CurrentIEPEndDate

20.8.2.0

Date

IEP To Date

CurrentIEPStartDate

20.8.2.0

Date

IEP From Date

DateConsentReceived

20.8.2.0

Date

504 form field -  WNC Field 'ResponseDate' 'Written Notice/Consent'

District

20.8.2.0

Varchar2(100)

District Name

DistrictID

20.8.2.0

Varchar2(15)

District number

EIIEPOtherRsn

20.8.2.0

Varchar2(50)

Reason for Late (or no) IEP development - Other Delays

EIIEPParentRsn

20.8.2.0

Varchar2(50)

Reason for Late (or no) IEP development - Parent Delays

EIIEPRange

20.8.2.0

Varchar2(50)

If NO, range of days IEP developed after 3rd birthday

EIIntEligibilityDate

20.8.2.0

Date

Date of Initial Eligibility Determination (EI Only)

EIIntIEPDate

20.8.2.0

Date

Date of Initial IEP Meeting (EI Only):

EILess90Days

20.8.2.0

Varchar2(4)

Eligible for EI services (under part C) less than 90 days

EINoticeDate

20.8.2.0

Date

Date letter of Notification from EI Received

EIOtherDelay

20.8.2.0

Varchar2(50)

Reason for Late (or no) Eligibility Determination - Other Delays

EIParentDelay

20.8.2.0

Varchar2(50)

Reason for Late (or no) Eligibility Determination - Parent Delays

EIRangeofDays

20.8.2.0

Varchar2(10)

If NO, Range of Days Eligibility Determined After 3rd Birthday

EIReferralDate

20.8.2.0

Date

Date of Referral Signature from EI

EligBy3

20.8.2.0

Varchar2(4)

Eligibility Determined Prior to 3rd Birthday

EligMeetDueDate

20.8.2.0

Date

Next Eligibility Meeting Due Date:

EligServices

20.8.2.0

Varchar2(4)

Determined Eligible for Services

Eligwithin30Days

20.8.2.0

Varchar2(4)

Eligibility within 30 Days from Completion Date of All Evaluations

ELLimitedFormalSchooling

20.8.2.0

Varchar2(4)

Limited Formal Schooling (SLIFE)

ELNoFormalSchooling

20.8.2.0

Varchar2(4)

No Formal Schooling (SIFE)

ELProgramEntryDate

20.8.2.0

Date

EL Program Entry Date

ELProgramExitDate

20.8.2.0

Date

EL Program Exit Date

ELStatus

20.8.2.0

Varchar2(50)

EL Status

ELWaivedTitleIIIServices

20.8.2.0

Varchar2(100)

EL Waived Title III Services

EvalCompleteDate

20.8.2.0

Date

Final Completion Date of ALL Evaluations

EvalDelayRea

20.8.2.0

Varchar2(100)

Reason For Late Evaluation

Evalin60Days

20.8.2.0

Varchar2(4)

Evaluations Completed within 60 Days

ExcessDays

20.8.2.0

Varchar2(10)

Range of Days In Excess

ExitExceptionality

20.8.2.0

Varchar2(50)

Exiting Exceptionality

FBABIPDate

20.8.2.0

Date

FBA/BIP Meeting Date

Firstname

20.8.2.0

Varchar2(30)

Student First Name

Five04Eligibility

20.8.2.0

Varchar2(50)

Student is eligible under Section 504

GConDenied

20.8.2.0

Varchar2(4)

Gifted Consent Denied

GEligDate

20.8.2.0

Date

Gifted Eligibility Date

GEligibility

20.8.2.0

Varchar2(4)

Gifted Eligible

GEPFromGrade

20.8.2.0

Varchar2(10)

GEP from Grade

GEPToGrade

20.8.2.0

Varchar2(10)

GEP to Grade

GiftedTeacher

20.8.2.0

Varchar2(50)

Gifted Teacher

GPartStatus

20.8.2.0

Varchar2(50)

Gifted Participation Status

GPartStatusOther

20.8.2.0

Varchar2(50)

Gifted Participation Status Other

GPassScreen

20.8.2.0

Varchar2(4)

Gifted Passed Screening

GPsyTestDate

20.8.2.0

Date

Psychological Test Date

Graduationmonth

20.8.2.0

Varchar2(10)

Anticipated Date of Exit - Month

GraduationPath

20.8.2.0

Varchar2(150)

Graduation Pathway

GraduationYear

20.8.2.0

Varchar2(10)

Anticipated Date of Exit - Year

GRefDate

20.8.2.0

Date

Gifted Referral Date

GRefSource

20.8.2.0

Varchar2(50)

Gifted Referral Source

GroupInstrPlanReviewDate

20.8.2.0

Date

Review Date of Group Instruction Plan

GroupInstrPlanStartDate

20.8.2.0

Date

Date of Group Instructional Plan

Gstatus

20.8.2.0

Varchar2(50)

Referral for Gifted Services  Form Field

GstatusOther

20.8.2.0

Varchar2(50)

Referral for Gifted Services - Other   Form Field

GTeamDtoPar

20.8.2.0

Date


GTimeDelays

20.8.2.0

Varchar2(50)

Timeline Delays

GTrackCom

20.8.2.0

Varchar2(100)

Tracking Log Comments

HearScrDate

20.8.2.0

Date

Hearing Screening Date

HearScrResults

20.8.2.0

String

Hearing Screening Results

IEPAnnualReviewDueDate

20.8.2.0

Date

IEP Annual Review Due Date

IEPBy3rdBthday

20.8.2.0

Varchar2(4)

IEP developed and Implemented by 3rd birthday

IEPSignDate

20.8.2.0

Date

IEP Signature Date

IndividualInstrPlanDate

20.8.2.0

Date

Date of Individual Instructional Plan

InitExceptionality

20.8.2.0

Varchar2(50)

Initial Exceptionality

InitialEligibilityDate

20.8.2.0

Date

Initial Eligibility Date

InStateTransfer

20.8.2.0

Varchar2(4)

In-State Transfer

IntConServicesRcdDate

20.8.2.0

Date

Consent for the Provision of Services

IntIEPDate

20.8.2.0

Date

Date of Initial IEP

InvMeetDate

20.8.2.0

Date

Notice and Invitation to a Meeting

IS_ELL

20.8.2.0

Varchar2(4)

EL Check box

Lastname

20.8.2.0

Varchar2(30)

Student Last Name

LRECode

20.8.2.0

Varchar2(255)

LRE

MDRDate

20.8.2.0

Date

Manifestation Determination Review

MedConDate

20.8.2.0

Date

Medicaid Consent Date

MedNotDate

20.8.2.0

Date

Medicaid Notification Date

Middlename

20.8.2.0

Varchar2(30)

Student Middle Name

MostRecEligDate

20.8.2.0

Date

Date of Most Recent Eligibility Determination

NotEligibleDate

20.8.2.0

Date

No Longer Eligible Date

OthAgen

20.8.2.0

Varchar2(4)

Other Agency Invited with prior Consent

OutofStateTransfer

20.8.2.0

Varchar2(4)

Out-of-State Transfer

ParentLetIntEntrLetDate

20.8.2.0

Date

Date Parent Letter for Intervention

ParentLetIntExitLetDate

20.8.2.0

Date

Intervention Exit Date

PreServBegDate

20.8.2.0

Date

Preschool Services Begin Date (3-5 yrs. old)

PreServBegDate

20.8.2.0

Date

Preschool Services Begin Date (3-5 yrs. old)

ProgCred

20.8.2.0

Varchar2(4)

Program Credits to be Earned

PSEligible

20.8.2.0

Varchar2(4)

Determined Eligible for Services - EI to PS

ReevaluationDueDate

20.8.2.0

Date

Reevaluation Due Date

ReferralDate

20.8.2.0

Date

Referral Date

ReferralType

20.8.2.0

Varchar2(50)

Type of Referral

ReferralType

20.8.2.0

Varchar2(50)

Type of Referral

ReviewDate

20.8.2.0

Date

Review Date

RevIniEvalConsDate

20.8.2.0

Date

Date of Revocation of Consent/Initial Evaluation

School 

20.8.2.0

Varchar2(100)

School name

SchoolID

20.8.2.0

Varchar2(15)

School code

Section504AntReview

20.8.2.0

Date

Date of Anticipated Review

Section504EligMeetingDate

20.8.2.0

Date

Date of Section 504 Eligibility Meeting

Section504ExitDate

20.8.2.0

Date

Date Exited Section 504

Section504ExitReason

20.8.2.0

Varchar2(50)

Reason Exited Section 504

Section504MeetingDate

20.8.2.0

Date

Date of Section 504 Accommodation Plan

Section504ReEval

20.8.2.0

Varchar2(50)

Re-Evaluation Date

Section504StartDate

20.8.2.0

Date

Section 504 Start Date

Section504ToIEPTransition

20.8.2.0

Date

Date Transitioned to IEP

SignConsInitEval

20.8.2.0

Date

Date Signed Notice and Consent for Evaluation Received

SpecialEducationExitDate

20.8.2.0

Date

Special Education Exit Date

SpecialEducationExitReas

20.8.2.0

Varchar2(50)

Special Education Exit Reason

SpEdRightsDate

20.8.2.0

Date

Special Education Rights

StateID

20.8.2.0

Varchar2(30)

State ID

Status

20.8.2.0

Varchar2(8)

Status

StuInv

20.8.2.0

Varchar2(4)

Student Invited

Tier3InstrPlanDate

20.8.2.0

Date

Date of Tier 3 Plan

TranRightsDate

20.8.2.0

Date

Transfer of Rights

TransAsses

20.8.2.0

Varchar2(4)

Transition Assessment

TransGoals

20.8.2.0

Varchar2(4)

Transition Goals

TransitionEIDate

20.8.2.0

Date

Date of Transition Meeting

Transportation

20.8.2.0

Varchar2(4)

Transportation Related

TransServ

20.8.2.0

Varchar2(4)

Transition Services

VisScrDate

20.8.2.0

Date

Vision Screening Date

VisScrResults

20.8.2.0

Varchar2(50)

Vision Screening Results

WritAgrReevalDueDate

20.8.2.0

Date

Written Agreement - The next reevaluation for continued eligibility determination is due

EIELIGDELAY

23.5.1.0

VARCHAR2(50)

Reason for late or no eligibility determination

EIIEPDELAY

23.5.1.0

VARCHAR2(50)

Reason for late or no IEP determination

USENTRYDATE

23.5.1.0

DATE

US Entry Date

JavaScript errors detected

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

If this problem persists, please contact our support.