IMS Data Dictionary

Back to Table List

Table NameAEBLF
Long NameBuilding Profile
DescriptionThis file contains one record for each combination of district and building referenced in the database. This file contains specific information which helps identify and describe each building. Information is collected from a variety of sources including certified student enrollment figures.
PrefixBL

Field Name Length Type Description Comments
bl_addr1 30 char Address Line 1
bl_addr2 30 char Address Line 2
bl_begtime 4 char Begin Time
bl_bldg 4 char Building Number
bl_city 20 char City
bl_contact 100 char Contact Person
bl_current 1 bit Building Active (T/F)
bl_dist 4 char District Number
bl_endtime 4 char End Time
bl_name 100 char Building Name
bl_phonalt 10 char Alternate Phone Number
bl_phonpri 10 char Primary Phone Number
bl_ptypalt 2 char Alternate Phone Number Type
bl_ptyppri 2 char Primary Phone Number Type
bl_public 2 char Public/Non-Public
bl_region 4 char Region Number
bl_state 2 char State
bl_udate 8 datetime Record Updated (Date)
bl_uid 9 char Record Updated (User ID)
bl_utime 8 char Record Updated (Time)
bl_van 3 char Van Route
bl_zip 5 char Zip Code
bl_zip4 4 char Zip Code (Extended)
bl_mpd 5 decimal Minutes Per Day
bl_sname 50 char Building Short Name
bl_esss 1 bit Eligible for Supplemental Support Services
bl_keyblf 10 char AEBLF KEY
bl_grades 20 char
bl_progyr 2 smallint
bl_type 4 char
bl_distbldg 8 char
bl_key 4 int
bl_factype 2 char
bl_IIP_RA 50 varchar