S_AL_STU_SpecEdProfile_X (ver 20.8.2.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 |