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 |