{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Audit Form","Vehicle audit list","SCAR","Waiver"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Audit Form","index":0,"n_rows":170,"n_cols":14,"rows_kept":170,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["Company",null,null,null,null,"Explanatory note:"]
["Location",null,null,null,null,"Please note that all relevant requirements must be adhered to, to successfully obtain a TSR 2017 certification. "]
["Contact Name",null,null,null,null,"The following three options are available when conducting your audit  "]
["AUDITOR(s)"]
["Audit Date",null,null,null,null,"Yes = Requirements fully in place with no discrepancies"]
["Phone No.",null,null,null,null,"No = Not all the Requirements in place and does not meet the requirements"]
["Fax No.",null,null,null,null,"Not Applicable (N/A) = this can be due to either the option choice or based on the risk assessment"]
["Email"]
["Certification ",null,null,null,null,"In all cases evidence must be shown or given especially if considering a N/A item or requesting a Waiver "]
["Result"]
[]
[]
[null,"TAPA TSR 2017 POLICY AND PROTOCOLS REQUIRED FOR ALL 3 LEVELS",null,null,null,null,null,null,null,null,null,null,"Yes","PASS: Meets or Exceeds Overall Requirements"]
["SECTION A"," 'MANAGEMENT SUPPORT AND RESPONSIBILITIES' PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation",null,null,null,null,null,"No","FAIL: Does not meet Overall Requirements"]
[null,"Security Management",null,null,null,null,null,null,null,null,null,null,"N/A"]
["A.1","The LSP (Logistics Service Provider) must have a formally appointed person responsible for supply chain security who is also responsible for monitoring the TSR programme.","P","P","P"]
[null,"Policy and Procedures"]
["A.2","The LSP must have a written corporate supply chain security policy (Security Policy) in place and adopted by management","P","P","P"]
["A.3","Specific procedures for the handling of high value theft targeted (HVTT) cargo must be in place, and in alignment with TSR procedures","P","P","P"]
["A.4","The specific HVTT and TSR procedures are also applicable to the LSP / Applicant subcontractors and must be reflected in a formal agreement between all parties.","P","P","P"]
[null,"Investigations and Lea Contacts"]
["A.5","The LSP / Applicant must document a written and implemented policy, which is shared with Buyers, to ensure that all freight losses are investigated. This shall include, but not be limited to, notifying Buyer of suspected or known thefts and within 24 hours. The Buyer, or appointed agent will receive full cooperation in the investigation.","P","P","P"]
["A.6","The LSP/Applicant must maintain a list of critical law enforcement agencies (LEA) contacts within its routes and must document a procedure, for both its main office and for drivers, on how to contact and coordinate with law enforcement when a theft event occurs.  ","P","P","P"]
[null,"Collection and Delivery Records"]
["A.7","The LSP/ Applicant must maintain records of all collections and proof of deliveries, for a period of not less than two years that can be accessed when investigation of loss is necessary.","P","P","P"]
[null,"Risk Analyses and Secure parking"]
["A.8","The LSP/Applicant must risk assess routes and stops at least annually to ensure that the safest routes are chosen to minimize passage through, or stops in, high-risk areas.  This information must be provided to the Buyer if requested.","P","P","P"]
["A.9","The LSP / Applicant must have a policy in place to identify and implement the use of secure parking locations for loaded trucks, as specified in TSR levels 1,2 and 3.","P","P","P"]
["SECTION B ","TRAINING PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[null,"Security Training"]
["B.1","The LSP/Applicant must have a program in place to train their workforce in security which, at a minimum, shall include threat awareness, robbery response, vehicle checking, recognition of developing threats, use of secure parking, appropriate responses to threatening events, and communication with police and management.  The training must occur every 2 years","P","P","P"]
[]
["B.2","The LSP/Applicant must have a program in place for staff to include training, appropriate use of tracking devices and other security equipment, and alarm protocols as mentioned in section C \nOR \nhave a contract in place with a recognized service provider requiring same.","P","P","P"]
["SECTION C","TRACKING AND TRACING PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[null,"Response to Alerts and Systems Failure"]
["C.1","Response protocols for alerts must be reviewed at least annually and contact details kept current. Protocols must include specific responses, including protocols for responding to tracking system failure","P","P","P"]
[null,"Response protocols"]
["C.2","Response protocols must include communications with law enforcement, advice for driver, allocations of resources to the site of the event as needed, and protection of any cargo that remains and is vulnerable.","P","P","P"]
["SECTION D","ON ROUTE  PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[null,"Escalation procedures"]
["D.1","The LSP/Applicant must have documented procedures in place to protect HVTT cargo in case of security incidents, driver illness, vehicle breakdown, strikes, detours, accidents, bad weather or refusal to accept delivery.","P","P","P"]
["SECTION E","Workforce Integrity: Applicable for TSR Certification and TTSP Recognition","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
["E.1","The LSP/Applicant must have a screening / vetting process that includes at a minimum, past employment and criminal history checks. Screening / vetting applies to all applicants, including employees and contractors. The LSP/Applicant will also require an equivalent process be applied at contracting companies supplying TAS workers.","P","P","P"]
["E.2","TAS worker is required to sign declaration that they have no current criminal convictions and will comply with LSP/Applicant security procedures. ","P","P","P"]
["E.3","LSP/Applicant will have agreements in place to have required information supplied by the agency and/or subcontractor providing TAS workers, or shall conduct such screening themselves. Screening must include criminal history check and employment checks.","P","P","P"]
["E.4","Procedure for dealing with LSP/Applicant /workforce’s false declaration pre & post hiring. ","P","P","P"]
[null,"Termination or Rehiring of Workforce\nNote:  Termination includes both voluntary and involuntary separations—terminated and resigned members of workforce."]
["E.5","Recover physical assets from terminated workforce to include company IDs, access badges, keys, equipment, or sensitive information.  Documented procedure required.","P","P","P"]
["E.6","Protect Buyer’s data: Terminate access to physical or electronic systems that contain Buyer’s data (inventory or schedules).  Documented procedure required.","P","P","P"]
["E.7","Workforce checklist in place for verification","P","P","P"]
["E.8","Re-hiring: Procedures are in place to prevent LSP/Applicant from re-hiring workforce if denial / termination criteria are still valid.                 \nNote:  Records are reviewed prior to re-hiring (Ex: background of previously terminated personnel or – rejected applicants (previously denied employment).","P","P","P"]
[]
["Practices ","All Sections Appliocable for TSR Certification or TTSP Recognition"]
["SECTION 1"]
[1,"Physical Security","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[1.1000000000000001,"Truck Security"]
["1.1.1","Driver procedures require that truck doors are locked during transit","P","P","P"]
["1.1.2","Truck door keys restricted to driver and LSP/ Applicant management.","P","P","P"]
[1.2,"Trailer Security"]
["1.2.1","High quality stainless steel security locking devices such as built-in locks OR mobile heavy weight locking devices with integral locks fixed to all truck/trailer doors (no chains, cables, light-weight bars, removable bolts, etc.) and utilized during the entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat for not less than ten minutes with hand tools.","P"]
["1.2.2","High quality stainless steel security locks either firmly fixed to all truck/trailer doors OR use of high quality chains, bars, padlocks etc. and utilized during the entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat with hand tools",null,"P"]
["1.2.3","Doors secured in line with LSP/ Applicant own internal policy.",null,null,"P"]
["1.2.4","Only hard sided trailers utilized","P","P"]
["1.2.5","Soft sided trailers as a minimum ",null,null,"P"]
["1.2.6","Tamper evident seals, are used on all direct, non-stop shipments. Seals shall be certified to ISO 17712 (I, S or H classification) \nOR \nElectronic locks fitted utilizing secure seal controls for locking and unlocking. Requiring remote unlocking or driver having access to unlock codes in real time and not prior to collection/delivery events.\n","P","P"]
["1.2.7","Trailer immobilization device in place when trailer is dropped (kingpin, landing gear lock or brake line lock)",null,"P","P"]
["SECTION 2"]
[2,"Tracking Technology and Alarms","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[2.1,"Two Way Communication Systems"]
["2.1.1","Two-way, real time voice communication system present during entire journey","P","P","P"]
["2.1.2","Two-way real time communication system monitored 24/7 by LSP’s/Applicant’s office or 3rd party monitoring center","P","P"]
[2.2000000000000002,"Tracking And Tracing Systems"]
["2.2.1","LSP/Applicant must have detailed and documented protocol in place to track trailers and tractors, both tethered and as separate vehicles, including 24/7 monitoring, the ability to geofence routes and parking locations and documented response protocols for handling emergencies","P"]
["2.2.2","LSP/Applicant must have detailed and documented protocol in place to track tractors, the ability to geofence routes and parking locations and documented response protocols for handling emergencies",null," P "]
["2.2.3","When tractor and trailer can be separated; a tracking device must be installed in a covert location in both the tractor and trailer and, where available, must be capable of utilizing at least two methods of signaling such as 3G, or SMS/GPRS using GSM or CDMA and must be equipped with at least one covert antenna.\n\nNote: In countries where two different forms of signaling are not available, the LSP/Applicant must document this to the auditor.\n","P"]
["2.2.4","A tracking device must be installed in a covert location in the tractor and, where available, must be capable of utilizing at least two methods of signaling such as 3G, or SMS/GPRS using GSM or CDMA and must be equipped with at least one covert antenna\n\nNote: In countries where two different forms of signaling are not available, the LSP/Applicant must document this to the auditor.",null,"      P"]
["2.2.5","A tracking device is installed providing remotely stored archival information relating to the position of all FTL (full truckload, Supplier dedicated) trucks.",null,null,"P"]
["2.2.6","Standard \"reporting interval\" for tracking units in both the tractor and the trailer must be not less than one report every five minutes. \nNote:  If the tractor and trailer are tethered and an effective untethered alert system is in place, only one of the units must meet this \"reporting\" rate standard.","P"]
["2.2.7","Standard \"reporting interval\" for tracking unit in the tractor must be not less than one report every thirty minutes.          ",null,"P"]
["2.2.8","The tracking devices in the trailer and the tractor must report events to include untethering (unhooking) of the trailer, device tampering, truck stoppage, tracker battery status and trailer door opening.               ","P"]
["2.2.9","The trailer and tractor tracking devices must be equipped with a battery back-up capable of maintaining the signaling capacity of the tracker for not less than 24 hours at a \"reporting\" rate of not less than one \"reporting\" every five minutes while the trailer is untethered.     ","P"]
["2.2.10","Monitoring center must be able to control, over the air, the \"reporting\" rate for devices in both tractor and trailer","P"]
["2.2.11","LSP/Applicant must have detailed and documented protocol in place to check, prior to departure, the function and battery life of all tracking devices to be utilized","P"]
[2.2999999999999998,"Tractor Alarm System"]
["2.3.1","Manually activated silent alarm (panic button) present in reach of driver and able to send signal to the LSP's/Applicant’s home base or third party monitoring center","P","P"]
["2.3.2","Local audible alarm if unauthorized entry to tractor cab occurs","P"]
["2.3.3","Procedures in place, tested and reviewed at least every six months","P","P"]
[2.4," Trailer Door Alarms"]
["2.4.1","Unauthorized opening of trailer doors sends signal to monitoring centre","P"]
["2.4.2","Procedures in place, tested and reviewed at least every six months","P"]
[2.5,"Tacking Device Failures"]
["2.5.1","The tracking system must alert if the tracking device fails or GPS signal is lost","P"]
["2.5.2","Procedures in place, tested and reviewed at least every six months, for responses to failure of tracking device.  ","P"]
[2.6,"Satellite Navigation Systems (Route Planner and Route Planning)"]
["2.6.1"," Satellite navigation system installed (route planner) recognizing detours, traffic jams, etc. to avoid unnecessary stops or delays. LSP’s/Applicant’s dispatch must confirm all route changes.","P","P","P"]
["2.6.2"," Coverage maps of the tracking technology to be utilized must be validated at least every six months to avoid or minimize travel through known \"black spots”","P"]
["2.6.3"," Coverage maps to be consulted and documented as part of route planning risk assessment","P"]
["2.6.4","Route planners must develop responses to events which occur within \"black spots”","P"]
["SECTION"]
[3,"Security Procedures","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[3.1,"Scheduled Routing"]
["3.1.1","The LSP / Applicant has planned routes.","P","P","P"]
["3.1.2","The LSP / Applicant has planned stops.","P","P"]
["3.1.3","If requested by Buyer, LSP/Applicant must report Ad Hoc changes to routes and stops or delays due to unexpected events.","P"]
[3.2,"Vehicle Maintenance Program"]
["3.2.1","  The LSP/Applicant must document vehicle maintenance programs in accordance with manufacturer's specifications","P","P","P"]
[3.3,"Unscheduled Breaks"]
["3.3.1","If the driver(s) must leave the vehicle (i.e.  Non-scheduled stop, medical emergency, accident or breakdown), the driver(s) must notify dispatch, lock all doors and engage all security devices.  The tracking monitoring center must also be notified and the truck and/or shipment live monitored constantly until it is able to return to transit.  In case of an extended unplanned stop, the LSP/Applicant must have a protocol in place to provide protection for the shipment.","P"]
["3.3.2","If driver must leave truck and trailer , all doors must be locked and alarms (where fitted) must be activated",null,"P","P"]
[3.4," Secure Parking"]
["3.4.1","The driver's manual/instructions must list approved and prohibited parking facilities, stopping places","P","P","P"]
["3.4.2","Trucks in use under TSR 1 must never be left unattended unless at a pre-approved (with Buyer) defined secure parking area with fences, lights, guards, access control and CCTV. ","P"]
[3.5," Unauthorized Persons"]
["3.5.1","No unauthorized parties allowed in truck or trailer. The LSP/Applicant must have policies and procedures in place to prevent unauthorized parties from being present in truck or trailer (i.e. hitchhikers, friends, non-driving relatives, children, etc.)","P","P","P"]
[3.6,"Management Of Security Equipment"]
["3.6.1","The LSP/Applicant must have documented and implemented procedures in place for management and control of seals, trailer (container) door locks, pin locks, and other security equipment.","P","P","P"]
[3.7," Key Management"]
["3.7.1","The LSP/Applicant must have documented and implemented procedures in place for the secure management of keys for trucks, pad-locks, kingpin locks etc.","P","P","P"]
[3.8,"Collection And Delivery Training"]
["3.8.1","The LSP / Applicant to provide training on collection and delivery procedures for the drivers to prevent deception and fraud.","P","P","P"]
[3.9,"Pre-Departure Checks Vehicle"]
["3.9.1","The LSP/Applicant must document pre-departure checks that ensure road worthiness of the vehicle in accordance with local regulations. For LTL (multiple stops) routes, these checks are required only at first departure, or daily for multiple-day trips","P","P","P"]
["3.9.2","Exceptions noted during the pre-departure check must be reported to LSP/Applicant home base and any delay or diversion resulting from the exceptions must be consistent with TSR Standards. Procedures must be part of driver's manual/written instructions.  ","P","P","P"]
["3.10","Pre-Departure Checks Driver"]
["3.10.1","The LSP/Applicant must document procedures to ensure provision of drivers and equipment capable of moving the load to its first scheduled stop without preventable interruption (e.g. fuel, meal stops, planned repairs, regulated driving times, etc.)","P","P","P"]
[3.11,"TSR Vehicle Register"]
["3.11.1","Vehicles to be utilized under the TSR must be listed in the LSP's/Applicant’s TSR Vehicle Register. There is no specific format for the Register, however, it must include at least the following information: Tractor identification information, trailer identification information, TSR level, date(s) of audits and self-assessments, any exceptions, corrections, date of correction","P","P","P"]
["SECTION "]
[4,"Drivers' Security Training ","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[4.0999999999999996,"Security Training"]
["4.1.1","Security Threat Awareness training program conducted with drivers and documented in driver records. This training, as a minimum, shall include threat awareness, robbery response, vehicle checking, and recognition of developing threats, use of secure parking, appropriate responses to threatening events and communication with police and management. This training must take place at least every 2 years.","P","P","P"]
["SECTION"]
[5,"Freight Handover Process","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[5.0999999999999996,"Box and pallet Integrity Verified Upon Receipt & Delivery"]
["5.1.1","The LSP/Applicant must have documented procedures verifying box and pallet counts before loading and after discharge.  Documentation verifying these procedures must be retained for not less than two years.      ","P","P","P"]
[5.2,"Proof of shipping and receiving records "]
["5.2.1","All cargo must be verified against shipping documents and manifests to ensure proper marking, weights, counts, and specific handling instructions (as applicable).","P","P","P"]
["5.2.2","Documents must be legible, complete and accurate, including (where appropriate) time, date, driver signature and printed name, signatures of shipping and receiving personnel, shipment details, and any special instructions.","P","P","P"]
["5.2.3","The LSP/Applicant must maintain records of all collections and proofs of delivery for a period of not less than two years that can be accessed if investigation of loss is required.  ","P","P","P"]
["5.2.4","Access to shipping documents and information on Buyer’s assets controlled, monitored and recorded, based on \"need to know\".","P","P","P"]
["5.2.5","Shipping documents safeguarded until destruction","P","P","P"]
["5.2.6","Information (shipping documentation) security awareness training provided to workforce having access to information.","P","P","P"]
[5.3,"Driver to be present for loading and unloading"]
["5.3.1","Unless prohibited by shipper or receiver policies, the LSP/Applicant policy must document that drivers must be present for loading and unloading to confirm piece count.  If shipper or receiver policies prohibit this practice, those policies must be available for audit","P","P","P"]
[5.4," Pre-alert in place"]
["5.4.1","Where Buyer requires, pre-alert process applied to inbound and/or outbound shipments. Pre-alert details must be agreed by Buyer and LSP/Applicant.  \nSuggested details include: departure time, expected arrival time, trucking company, driver name, license plate details, shipment info (piece count, weight, bill-of-lading number, etc.) and trailer seal numbers","P","P","P"]
["SECTION "]
[6,"LSP/Applicant Self Assessment","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[6.1," Self-Assessment of Vehicle Before Being Added to the TSR Vehicle Register"]
["6.1.1","The LSP/Applicant must have documented evidence that all vehicles (trucks & trailers) in the TSR Vehicle Register have been assessed and are meeting the requirements of the TAPA TSR 2017 practice section relating to the physical aspect of the vehicles (refer to Sections 1 and 2)  ","P","P","P"]
[6.2,"On Going Assessment to Ensure Compliance to the TSR Section 6"]
["6.2.1","The LSP/Applicant must have documented evidence that all subsequent self-assessments by the LSP/Applicant (fixed or rolling program - covering all vehicles in the TSR Vehicle Register) are self-re-assessed at least once every 12 months by the LSP/Applicant and associated records retained for audit purposes.  ","P","P","P"]
["SECTION","Section 7 is Optional; i.e., Not Mandatory"]
[7,"Buyer Cargo Track and Trace Requirements \nThese are Buyer requested and/or the LSP/Applicant provided enhancements that can be incorporated into TSR Levels 1-3 as an optional extra.  This option does not exclude use of any mandatory requirements (Practice Requirements, Sections 1-6) that are needed to meet TSR Certification requirements.  ","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[7.1,"Buyer Option for Portable Tracking of Cargo"]
["7.1.1","Portable Tracking Devices must be capable of sending tracking information to a monitoring center"]
["7.1.2","A protocol must be in place to place the Portable Tracking Device and the device must be tested before leaving to assure its function and battery status"]
["7.1.3","The location of the Portable Tracking Device may be placed embedded in cargo or placed internally or externally on the trailer depending upon the type of cargo. A protocol must be in place to define this practice  "]
["7.1.4","Portable Tracking Devices can be monitored \"live” or \"alarm\" driven. Which option to utilize is to be decided between the Buyer and LSP/Applicant."]
["7.1.5","The monitoring center must demonstrate a comprehensive response protocol for any and all alerts generated by the Portable Tracking Device, including route deviations, unapproved or unexpected movement, loss of signal due to location or jamming, reduced or lost battery power, or a theft notification from the LSP/Applicant.  "]
["7.1.6","Response protocols must include a documented process for the engagement of law enforcement, a clear understanding of the law enforcement resources available and how to work with them, and a follow-up protocol to assist law enforcement throughout the investigation of any loss, including the sharing of tracking information.  Simply notifying law enforcement of the loss is not acceptable"]
["7.1.7","The Portable Tracking Device must demonstrate at least two of the following: geofencing, start-stop monitoring, alerts for no-stop zones, and critical waypoints.     "]
["7.1.8","The frequency of signal from the Portable Tracking Device should be determined by the Buyer, but with a minimum of 1 report per hour."]

{"sheet":"Vehicle audit list","index":1,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,5,5,14]]}
[null,"Choose the relevant TSR Level: "]
[]
[]
[]
[]
[null,null,null,null,null,"Vehicles audit list (Vehicle Registration number)"]
[1,"Physical Security","Level 1","Level 2","Level 3"]
[1.1000000000000001,"Truck Security"]
["1.1.1","Driver procedures require that truck doors are locked during transit","P","P","P"]
["1.1.2","Truck door keys restricted to driver and LSP/ Applicant management.","P","P","P"]
["1.1.3","Auditory alarm if unauthorized entry to tractor cab occurs ","P"]
[1.2,"Trailer Security"]
["1.2.1","High quality stainless steel security locking devices such as built-in locks OR mobile heavy weight locking devices with integral locks fixed to all truck/trailer doors (no chains, cables, light-weight bars, removable bolts, etc.) and utilized during the entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat for not less than ten minutes with hand tools.","P"]
["1.2.2","High quality stainless steel security locks either firmly fixed to all truck/trailer doors OR use of high quality chains, bars, padlocks etc. and utilized during the entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat with hand tools",null,"P"]
["1.2.3","Doors secured in line with LSP/ Applicant own internal policy.",null,null,"P"]
["1.2.4","Only hard sided trailers utilized","P","P"]
["1.2.5","Soft sided trailers as a minimum ",null,null,"P"]
["1.2.6","Tamper evident seals, are used on all direct, non-stop shipments. Seals shall be certified to ISO 17712 (I, S or H classification) \nOR \nElectronic locks fitted utilizing secure seal controls for locking and unlocking. Requiring remote unlocking or driver having access to unlock codes in real time and not prior to collection/delivery events.\n","P","P"]
["1.2.7","Trailer immobilization device in place when trailer is dropped (kingpin, landing gear lock or brake line lock)",null,"P","P"]
["SECTION 2"]
[2,"Tracking Technology and Alarms","Level 1","Level 2","Level 3"]
[2.1,"Two Way Communication Systems"]
["2.1.1","Two-way, real time voice communication system present during entire journey","P","P","P"]
["2.1.2","Two-way real time communication system monitored 24/7 by LSP’s/Applicant’s office or 3rd party monitoring center","P","P"]
[2.2000000000000002,"Tracking And Tracing Systems"]
["2.2.1","LSP/Applicant must have detailed and documented protocol in place to track trailers and tractors, both tethered and as separate vehicles, including 24/7 monitoring, the ability to geofence routes and parking locations and documented response protocols for handling emergencies","P"]
["2.2.2","LSP/Applicant must have detailed and documented protocol in place to track tractors, the ability to geofence routes and parking locations and documented response protocols for handling emergencies",null," P "]
["2.2.3","When tractor and trailer can be separated; a tracking device must be installed in a covert location in both the tractor and trailer and, where available, must be capable of utilizing at least two methods of signaling such as 3G, or SMS/GPRS using GSM or CDMA and must be equipped with at least one covert antenna.\n\nNote: In countries where two different forms of signaling are not available, the LSP/Applicant must document this to the auditor.\n","P"]
["2.2.4","A tracking device must be installed in a covert location in the tractor and, where available, must be capable of utilizing at least two methods of signaling such as 3G, or SMS/GPRS using GSM or CDMA and must be equipped with at least one covert antenna\n\nNote: In countries where two different forms of signaling are not available, the LSP/Applicant must document this to the auditor.",null,"      P"]
["2.2.5","A tracking device is installed providing remotely stored archival information relating to the position of all FTL (full truckload, Supplier dedicated) trucks.",null,null,"P"]
["2.2.6","Standard \"reporting interval\" for tracking units in both the tractor and the trailer must be not less than one report every five minutes. \nNote:  If the tractor and trailer are tethered and an effective untethered alert system is in place, only one of the units must meet this \"reporting\" rate standard.","P"]
["2.2.7","Standard \"reporting interval\" for tracking unit in the tractor must be not less than one report every thirty minutes.          ",null,"P"]
["2.2.8","The tracking devices in the trailer and the tractor must report events to include untethering (unhooking) of the trailer, device tampering, truck stoppage, tracker battery status and trailer door opening.               ","P"]
["2.2.9","The trailer and tractor tracking devices must be equipped with a battery back-up capable of maintaining the signaling capacity of the tracker for not less than 24 hours at a \"reporting\" rate of not less than one \"reporting\" every five minutes while the trailer is untethered.     ","P"]
["2.2.10","Monitoring center must be able to control, over the air, the \"reporting\" rate for devices in both tractor and trailer","P"]
["2.2.11","LSP/Applicant must have detailed and documented protocol in place to check, prior to departure, the function and battery life of all tracking devices to be utilized","P"]
[2.2999999999999998,"Tractor Alarm System"]
["2.3.1","Manually activated silent alarm (panic button) present in reach of driver and able to send signal to the LSP's/Applicant’s home base or third party monitoring center","P","P"]
["2.3.2","Local audible alarm if unauthorized entry to tractor cab occurs","P"]
["2.3.3","Procedures in place, tested and reviewed at least every six months","P","P"]
[2.4," Trailer Door Alarms"]
["2.4.1","Unauthorized opening of trailer doors sends signal to monitoring centre","P"]
["2.4.2","Procedures in place, tested and reviewed at least every six months","P"]
[2.5,"Tacking Device Failures"]
["2.5.1","The tracking system must alert if the tracking device fails or GPS signal is lost","P"]
["2.5.2","Procedures in place, tested and reviewed at least every six months, for responses to failure of tracking device.  ","P"]
[2.6,"Satellite Navigation Systems (Route Planner and Route Planning)"]
["2.6.1"," Satellite navigation system installed (route planner) recognizing detours, traffic jams, etc. to avoid unnecessary stops or delays. LSP’s/Applicant’s dispatch must confirm all route changes.","P","P","P"]
["2.6.2"," Coverage maps of the tracking technology to be utilized must be validated at least every six months to avoid or minimize travel through known \"black spots”","P"]
["2.6.3"," Coverage maps to be consulted and documented as part of route planning risk assessment","P"]
["2.6.4","Route planners must develop responses to events which occur within \"black spots”","P"]

{"sheet":"SCAR","index":2,"n_rows":72,"n_cols":2,"rows_kept":72,"cut":false,"hidden":false,"merged":[[11,1,11,8],[0,0,0,8],[1,0,1,8],[2,2,2,8],[3,2,3,8],[4,2,4,8],[5,2,5,8],[6,2,6,8],[7,0,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[23,1,23,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,8],[35,1,35,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[47,1,47,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[59,1,59,8],[48,1,48,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[56,1,56,8],[57,1,57,8],[58,1,58,8],[71,1,71,8],[60,1,60,8],[61,1,61,8],[62,1,62,8],[63,1,63,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[67,1,67,8],[68,1,68,8],[69,1,69,8],[70,1,70,8]]}
["Security Corrective Action Requirements"]
[]
[null,"SCAR #"]
[null,"AUDITORS:"]
[null,"ADDRESS:"]
[null,"LOCATION AUDITED:"]
[null,"DATE:"]
["MAJOR FINDINGS"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]
["TAPA Requirements: "]
["Finding:"]
["Corrective Action (CA):"]
["CA Validation:"]

{"sheet":"Waiver","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}