Table Name | AEBLF |
Long Name | Building Profile |
Description | This 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. |
Prefix | BL |
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 |