What We Do

Database programmers.
Web developers. Trusted partners.

Our clients depend on us to dive deep into their business issues, re-imagine processes, elucidate strategies, and be totally transparent about costs. They count on us to build reliable systems using the industry’s most bulletproof software. And they fully appreciate that we’re practical innovators who only recommend new technologies when we’re certain they can provide long-term value.

Home

Teck Resources

Need: Track thousands of tasks needed to run a lead and zinc mine properly.
Solution: SiteLine, a comprehensive web application that mine personnel use to make sure things get done.
Technologies used: ASP, SQL Server, Access

J Street Technology developed and implemented an EHS management system for Teck Resources, a Canadian mining company with worldwide operations. J Street successfully implemented the SiteLine browser-based Intranet system with a SQL Server backend at Red Dog Mine, located in Northwest Alaska above the Arctic Circle. Red Dog is the largest zinc mine in the world, and achieved ISO 14001 certification with the help of SiteLine. SiteLine has since been installed at several other Teck operations in the US and Canada.

Project slideshow

SiteLine is a comprehensive environmental, health and safety (EHS) management system. Supervisors and other personnel who have routine access to computers are provided access to My SiteLine for active day-to-day EHS management activities and reporting. <p>The Tag In/Out feature was designed to handle the shifting of environmental roles and responsibilities within a busy operation. Even for facilities that do not operate in shifts or where roles do not frequently change, the application allows operations personnel to designate and empower their alternates when away on weekends, business trips or vacations.</p>Its features provide the ability to:<ul><li>Assign specific roles and responsibilities to alternate personnel within an organization to ensure environmental compliance and EHS conformance requirements do not go unattended.</li><li>Tag in or out and make yourself active in primary and alternate roles as needed.</li><li>Tag in or out personnel who substitute in your primary role (alternates) and change their status between active and standby.</li><li>Provide an indication of training status for your primary role, your alternate roles, and the people that are designated as your alternates.</li><li>Quickly ascertain or ensure whether personnel in their primary and alternate roles meet basic competency requirements to appropriately fulfill those roles and responsibilities.</li></ul> <p>The Task component of SiteLine provides a powerful data-driven compliance and task management tool that operates at all levels within an organization.</p>Its features provide the ability to:<ul><li>Store within a central repository all current and historical legal and other requirements applicable to an organization.</li><li>Convey simple assignments to personnel at all levels within an organization based on detailed and complex compliance and conformance requirements.</li><li>Improve flexibility by generating a single assignment for multiple regulatory requirements requiring the same activity, or multiple assignments for a single regulatory requirement.</li><li>Provide a summary of tasks assignments by individual, which indicate priority and due dates and provide the necessary detail for their completion. Assignments are based on the role(s) the individual is currently responsible for.</li><li>Generate Environmental Worksheets (Compliance Matrices) that provide detailed work instructions at all levels within an operation/organization by individual role, supervisor, or Work Area.</li><li>Focus and change the format and content of the Environmental Worksheets using detailed selection filters, if desired.</li><li>Fully prioritize critical task assignments (monitored, recurring, and informational tasks).</li><li>Integrate with an ISO 14001 conformant document control package (QualTrax or SharePoint) that provides immediate access to controlled documents (operational controls and SOPs).</li><li>Track completion of critical tasks monitored by the operation at the supervisor and top management levels.</li><li>Escalate and communicate overdue task assignments to increasingly higher levels of senior management when not completed on time.</li><li>Integrate with task assignments for managing significant aspects and environmental management plans.</li></ul> <p>The Task Command Center provides a robust database administration tool to input, manage, and maintain compliance and task data for use by SiteLine.</p>Its features provide the ability to:<ul><li>Input information for new regulatory drivers (e.g. permits, regulations, ISO requirements, etc.).</li><li>Copy and edit existing drivers and all associated information down to the assignment level.</li><li>Search or drill-down on any data within the system and quickly make changes or additions, as necessary.</li></ul> <p>The Corrective Action Program component includes the ability to report environmental incidents, as well as health and safety incidents.</p>Its features provide the ability to:<ul><li>Initiate a new incident report for environmental incidents including spills, non-compliance, EHS non-conformance, and wildlife issues.</li><li>Initiate a new incident report for health and safety incidents including injury, fire, damage, and other safety issues.</li><li>Route incident reports to senior management for review.</li><li>Email incident reports to top management for general awareness.</li><li>Route reviewed incident reports to qualified assessors to determine the severity of the incident, review and modify the incident reports (if necessary), and route to corrective action, if warranted.</li><li>Track agency reporting requirements and communication logs for incidents that require them (such as spills).</li><li>Document and track formal corrective action and root cause analysis.</li><li>Document the development of preventive action plans with specific task assignments and due dates that are tracked in conjunction with compliance and EHS conformance tasks.</li><li>Search for recent or historical incidents.</li><li>Review the status of open incidents requiring the user's attention.</li><li>Identify incidents with higher priorities due to approaching critical review and reporting deadlines.</li></ul> <p>The Corrective Action Program Command Center provides a tool to manage incidents, corrective action plans, preventive action plans, and allows the user to generate reports for current and historical events.</p>Its features provide the ability to:<ul><li>Generate and print summary reports for Environmental and Health & Safety related incidents.</li><li>Create a new Incident or review recent or historical incidents.</li><li>View a summary of recent incidents.</li><li>Generate a comprehensive listing of all incidents with the ability to drill down on individual incidents to ascertain specific details and print reports.</li><li>View a summary of Preventive Action Tasks developed as a result of root cause analyses for each incident or for all incidents.</li><li>Sort the listing of incidents and preventive action tasks based on key parameters to perform a big-picture review of incidents and preventive actions.</li><li>Identify incidents with priorities due to approaching critical review and reporting deadlines.</li></ul> <p>The Audit Command Center provides a tool to manage resolution of compliance and EHS non-conformance audit findings.</p>The features of this application provide the ability to:<ul><li>Enter specific information from individual audits and all associated audit findings.</li><li>Enter Corrective or Preventive Action Plan tasks for one or more audit findings that can be tracked to completion using the robust features of the SiteLine Task component.</li><li>Review and monitor the status of corrective and preventive action tasks.</li><li>Using a variety of built-in filters, generate reports of previous audits to identify pertinent details, associated findings, and action plans for review and printing.</li><li>Modify and maintain audit protocols.</li></ul> <p>The Training component of SiteLine provides the ability to enter and track training requirements for personnel at all levels within an organization based on individual role competencies and their related training modules.</p>The features of this application provide the ability to:<ul><li>Show current or expired training modules for people and their associated roles.</li><li>Show training modules that will be expiring soon, facilitating pro-active scheduling of training sessions.</li><li>Identify and view training requirements for other roles within the organization.</li><li>Generate a training record report for yourself or ascertain the training status for personnel or roles that report to you.</li><li>Track additional personal training requirements beyond those required for a person’s current roles, to use for career planning or personal growth.</li></ul> <p>The Training Command Center is a robust application that provides the ability to manage and maintain training requirements from a single location.</p>The features of this application provide the ability to:<ul><li>Determine the status of training and the training requirements for roles, personnel, operational units, and competencies at all levels within an organization.</li><li>Develop a training history report for roles, personnel, operational units and competencies.</li><li>Identify training requirements by roles and by people within the organization.</li><li>Enter training results for personnel by competency and module.</li><li>Manage and maintain training requirements assigned to each role.</li><li>Add, manage, and maintain training competencies and modules within your training curriculum.</li></ul> <p>The SiteLine Command Center is an administrative tool to manage and maintain critical functions of SiteLine. It provides the ability to assign personnel one or more roles within the application and it controls access to the various components of SiteLine. The function of SiteLine is highly dependent upon the accurate assignment of roles to personnel within the organization. Roles are defined as Primary or alternate. All personnel are required to have or share a primary role.</p>The features of this application provide the ability to:<ul><li>Create, edit, or remove roles and people within SiteLine.</li><li>Assign personnel to roles and likewise assign roles to personnel.</li><li>Specify Exclusive Roles to ensure that one (and only one) person is active in that role at any given time.</li><li>Provide or deny access to the various command centers used to set up and manage their corresponding areas.</li><li>Identify error situations which would allow personnel to exist in the system without assigned roles, or roles to exist within the system without assigned personnel.</li><li>Create or modify specific information or status for all personnel within the organization including email addresses used by the other components of SiteLine.</li></ul> <p>The SiteLine Administration Tool is an Access client-server database application to manage and maintain many system values, lookup tables and status codes for SiteLine. It provides the ability for selected personnel to maintain and configure virtually every aspect of SiteLine.</p>The Administration Tool provides the ability to:<ul><li>Create, edit, or remove values in virtually all lookup tables and drop-down lists, without programming.</li><li>Specify system level values such as file paths, QualTrax or SharePoint system links, email addresses, and system preferences.</li><li>Run reports to show “broken links” to documents that are no longer found at the specified location.</li></ul> <p>The SiteLine Training Tool is a database application to manage complex scenarios for training users in the proper usage of SiteLine. Since so much of SiteLine is time and date sensitive, the Training Tool provides a “time machine” ability to shift all timed activities forward or backward relative to the current system date.</p>The Training Tool provides the ability to:<ul><li>Activate or deactivate Tasks across the entire SiteLine database, so that training scenarios are realistic without needing to add or delete task data.</li><li>Quickly initialize all dated items (Tasks, Training Results, etc.) in SiteLine to dates appropriate for the current date.</li><li>Time-shift all dated items forward or backward in time. This provides the ability to “accelerate time” for the entire SiteLine system so that multiple days can be simulated during one training session.</li></ul>