IMS Data Dictionary

Back to Table List

Table NameAEPLF
Long NamePlans
DescriptionOne child can have many different plans generated on his/her behalf. This file captures unique information about each individual plan (e.g. IEP, IFSP).
PrefixPL

Field Name Length Type Description Comments
pl_chid 15 char Child ID Key Field - links to child file
pl_appdate 8 datetime Plan Approval Date
pl_confdte 8 datetime Conference Date
pl_consdte 8 datetime Parental Consent Date
pl_initdte 8 datetime Plan Initiation Date
pl_consent 1 bit Parental Consent (T/F)
pl_peridte 8 datetime Review Date
pl_plmtdte 8 datetime End Date
pl_revtype 4 char Review Type
pl_enddate 8 datetime Projected Plan Completion Date
pl_udate 8 datetime Record Updated (Date)
pl_utime 8 char Record Updated (Time)
pl_uid 9 char Record Updated (User ID)
pl_staff 10 char Staff ID
pl_comment 254 char Comments
pl_planid 10 char Plan ID
pl_meettyp 1 char Meeting Type
pl_type 1 char Plan Type
pl_eyse 1 char Extended Year Special Education Status
pl_dwa 10 char District Wide Assessment
pl_lre 3 char % of Time not in Regular Education
pl_year 9 char School Year
pl_bi 1 bit Behavior Y/N
pl_comm 1 bit Communication Y/N
pl_braille 1 bit Braille Y/N
pl_at 1 bit Assistive Technology Y/N
pl_english 1 bit Limited English Y/N
pl_health 1 bit Health Y/N
pl_medyn 1 char Medicaid Consent Y/N
pl_meddt 8 datetime Medicaid Consent Date
pl_reevaldate 8 datetime