IMS Data Dictionary

Back to Table List

Table NameAEAPF
Long NameAdjusted Programs
DescriptionThis file contains one record for each Adjusted Program Report generated. When circumstances exist that causes a child to be assigned to a class other than of the type recommended by the team, or if the child's assignment to a class causes certain criteria (class size, age span, disability) to go beyond acceptable limits, then it is necessary to file an adjusted program report for that child's placement. This file captures each instance of an adjusted program report.
PrefixAP

Field Name Length Type Description Comments
ap_attbldg 4 char Attending Building
ap_attdist 4 char Attending District
ap_chid 15 char Child ID Key Field - links to child file
ap_pgid 3 char Service ID
ap_pgseq 2 char Service Sequence Number
ap_begdt 8 datetime Begin Date
ap_begdate 8 datetime Begin Date
ap_stdate 8 datetime Service Start Date
ap_reason 16 text Description and Justification
ap_plan 16 text District Plan to Correct
ap_udate 8 datetime Record Updated (Date)
ap_utime 8 char Record Updated (Time)
ap_uid 9 char Record Updated (User ID)
ap_sizecb 1 bit Adjusted Assurance Due to Size (T/F)
ap_sizedte 8 datetime Correction Date - Size
ap_sizea1 2 char Adjusted Assurance Reason 1 - Size
ap_sizea2 2 char Adjusted Assurance Reason 2 - Size
ap_sizea3 2 char Adjusted Assurance Reason 3 - Size
ap_agecb 1 bit Adjusted Assurance Due to Age (T/F)
ap_agedte 8 datetime Correction Date - Age
ap_agea1 2 char Adjusted Assurance Reason 1 - Age
ap_agea2 2 char Adjusted Assurance Reason 2 - Age
ap_agea3 2 char Adjusted Assurance Reason 3 - Age
ap_pgmdcb 1 bit Adjusted Assurance Due to Program Model (T/F)
ap_pgmddte 8 datetime Correction Date - Program Model
ap_pgmda1 2 char Adjusted Assurance Reason 1 - Program Model
ap_pgmda2 2 char Adjusted Assurance Reason 2 - Program Model
ap_pgmda3 2 char Adjusted Assurance Reason 3 - Program Model
ap_disbcb 1 bit Adjusted Assurance Due to Disability (T/F)
ap_disbdte 8 datetime Correction Date - Disability
ap_disba1 2 char Adjusted Assurance Reason 1 - Disability
ap_disba2 2 char Adjusted Assurance Reason 2 - Disability
ap_disba3 2 char Adjusted Assurance Reason 3 - Disability
ap_old 5 decimal Oldest Class Members Age
ap_young 5 decimal Youngest Class Member
ap_span 5 decimal Age Span in Months
ap_size 5 decimal Class Size
ap_keyapf 10 char AEAPF KEY