Case Study

Physical Security LLC.

THE CLIENT

Physical Security Logo

Physical Security LLC.

THE SERVICES

Track & Trace

Executive Summary

Physical Security LLC, or PS, is a contract glazing company operating from the Birmingham, Alabama metropolitan area. They fabricate, assemble and glaze curtain wall for installation in high-rise, healthcare, commercial, mixed use and institutional buildings alike. Their glass exteriors can be seen on structures across the country including the Sears Tower, NCIS Headquarters, Raleigh-Durham Airport, and the Pentagon. Despite being considered a small business, owner managed and operated, Physical Security’s manufacturing facility spans 120,000 square feet with millions of dollars in product.

Challenges

As this operation only grows larger, PS sought a solution to track their assemblies with details such as the silicone manufacturer, and the serialized batch of silicone being used in every assembly that’s to be installed in a building. Further, for warranty reasons, each unit had to have this specific data recorded at the time of assembly in case there is an issue post-assembly, and potentially even years after the project has ended.

Jason Bush, an IT Manager at PS, requested we configure a service so that each unit can have information attached at each point in their production process. The units would be given a unique QR code when first arriving on the assembly line. From there, the assets would be tagged with their specific manufacturing information such as project number, glass manufacturer & details, silicon manufacturer & details, and unit ID. This information follows and timestamps each unit from the assembly, shipping, storage, and ending with the installation.

The greater benefit would come from a programmatic solution to easily store, share, and edit this data to different levels of the production process through installation. Jason presented us with the challenge of needing to be able to save unique historical data for any given QR code.

codeREADr Solution

After being tasked with implementing such an upgrade to our software, codeREADr created Table Builder. This curated service allows the client to build parent tables with child table views. It enables authorized app-users to scan a barcode and answer data-collection prompts as fields within defined tables.

For the company’s needs, this meant enabling their tracking process to simply include all relevant data attached to a unique QR code. Their Table Builder service validates against a master database of assets tagged with QR stickers. When an asset is brought to the assembly line, it is scanned via their PS codeREADr system and the user is prompted to input the first set of information key to the company’s warranty process.

From here, the QR code builds upon an attached record of data and that can be added to or edited as needed. The resulting information tagged to the code is stored neatly in a table that can be accessed from an online web view and/or downloaded as a file for review.

Yes/no questions and short answer entry fields prompt the users along the way to share with Jason’s team everything they may need to create a robust log for warranty use. As the assets move from their manufacturing facility to installation, users can access only what is relevant to their step in the process. For some, answers from prior steps are both visible and editable while for others, they can only view the data relating to the prior steps
in production before adding their own quality assurance pieces.

PS Window Diagram

Results

After delivering our new Table Builder service to Jason, the time spent in administrative processes has been greatly reduced. Prior to implementing codeREADr services, every unit would be documented with assembly and warranty information using hard copies and sometimes multiple electronic spreadsheets. After assembly, the related warranty information that is specific to each unit would have to be recorded for every unit.

“This real-time entry of warranty and quality control information using only the mobile phones our employees keep in their pocket accomplished Physical Security’s main goal for codeREADr,” noted Jason. “The ability to access the data from a custom web portal as well as the rapid entry is huge from an IT perspective. I am not having to maintain scanners, and the related data storage nor do I have to worry about user intervention.” On the job site, this same information being captured can be utilized for even greater utility. Users on the job site scan the assembled units prior to being installed on the building
facade. This records a highly accurate timestamp of the physical installation for each unit. If needed, project management can pull reports giving detailed
information of exactly what has been installed to give them real-time job progress.

Not only Jason but all of PS has been overwhelmingly satisfied with the solution codeREADr has produced for them.

Being in IT for nearly 25 years, I have dealt with many software vendors and support teams. These guys have the support and diligence to rival any large vendor and are to be commended. On first contact, codeREADr welcomed us to an extended trial of their product. I play tested with their product and sample apps, and quickly noticed the potential to give us what we were looking to achieve. Admittingly, I was unaware of the abilities and capabilities of QR codes. In the beginning, it was obvious I was wanting a little more out of their product than currently implemented. There were quite a few discussions of what we were looking to achieve, our current processes, and how the final product should appear to my users. They took on the task and provided a usable product in a timely manner as well as supporting us with ‘tweaks’ to our code as needed. In the end, codeREADr was able to customize a very slick and easy to use solution that has more than accomplished our initial goals.

Jason Bush, IT Manager, Physical Security LLC