107751
Menu
ALAN plan database
Description
Start dateBetween 1st January 1996 and 31st December 1996Date qualifiercircaDescriptionALAN was an internal Microsoft Access Database for managing data relating to the primary plan series held by the City of Sydney Archives. It was named after the last plan custodian who created the database. The database was most likely developed by the City Planning Department and provided to the City Archives in 1996, when the Archives took over care and custody of all building plans. Series controlled included CRS126 City Building Application Plans. Metadata fields included Series, Container, GRR Container, Item Number, Item Title, Year, and fields indicating if an item was Oversize, Rolled, Flat, Microfilmed, Digititized and/or Fragile. Whilst this data was largely replicated in the BOS database, the data from ALAN was transferred to the CAMPAS system due to its more frequent updating and greater reliability. Version history1996Vendor (product)Microsoft 1996-2018Vendor (support)Microsoft 1996-2018ReportsSearch results could generate a basic report. The database itself could also be exported to a Microsoft Excel file. No other relevant reporting functions existed.Retention requirements (notes)The data held in the ALAN Database is permanent retention and was migrated to the CAMPAS system.Method of containing dataData was maintained by City Archives staff within the database. Location of systemOn premise
Access
Public access noteData from the ALAN database was largely but not completely, replicated in the BOS database. Public access was therefore facilitated through BOS. All requests for data exclusively held in ALAN would be handled by City Archives staff.Public access statusOpen to public access
Relationships
OrganisationSydney City Council
Registration
ALAN plan database [SS-0006]. City of Sydney Recollect - UAT, accessed 04 Aug 2025, https://cosauat.recollect.net.au/nodes/view/107751