{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["changes","Instructions","Audit References","Requester Information","TI Request Parameters","Requester 3911s","TI Requests","TI Request Additional Info","Lookup Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":6,"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":"changes","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["PDG Trace - TI Request"]
["Change Log"]
[]
["Template Version","Date","Changes","Notes"]
["v2.0.0"," ","Initial publication of Trace Request."]

{"sheet":"Instructions","index":1,"n_rows":71,"n_cols":2,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["PDG Trace - TI Request"]
["Instructions"]
["How to use this template."]
["TI Request Template Version Number","02.00.00"]
[]
[null,"PDG makes no representations or warranties regarding the accuracy, completeness, or suitability of the information contained in this template. This template is provided “as is” without any guarantees or warranties of any kind, either express or implied. Users are advised to independently evaluate and verify the information before relying on it for any purpose. PDG shall not be held liable for any errors, omissions, or any outcomes resulting from the use of this template.\n\nAll intellectual property rights in and to this template document are owned by PDG. Users are granted a limited, non-exclusive, non-transferable license to use this template for business purposes only. Any unauthorized use or reproduction of this template, in whole or in part, is strictly prohibited."]
[]
[null,"Overview"]
[null,"This workbook facilitates pharmaceutical companies in managing DSCSA compliance by organizing traceability requests. It contains multiple interconnected worksheets to handle transaction information (TI), requester details, audit references, and lookup tables."]
[]
[null,"This guide aims to ensure you use the workbook efficiently and accurately for DSCSA compliance management. If you encounter any issues, refer to the Instructions sheet or consult your DSCSA administrator. "]
[]
[null,"Contents of the Workbook"]
[null,"1. changes"]
[null,"Logs changes made to the workbook versions."]
[null,"Use this sheet to track modifications or updates."]
[null,"No user input required."]
[null,"2. Instructions"]
[null,"Provides detailed guidance on how to use the workbook."]
[null,"Review this section before making entries."]
[null,"No user input required."]
[null,"3. Audit References"]
[null,"Contains fields to record essential audit trail information."]
[null,"Use this section to reference audits related to requests."]
[null,"Ensure accurate and complete records for audits."]
[null,"4. Requester Information"]
[null,"Collects details about the individual or organization making the trace request."]
[null,"Fields include requester name, contact information, and organization."]
[null,"How to fill:"]
[null,"1.                  Enter your full name."]
[null,"2.                  Provide your contact email and phone number."]
[null,"3.                  Enter the requesting organization and role (if applicable)."]
[null,"1. TI Request Parameters"]
[null,"Captures parameters for the transaction information (TI) being requested."]
[null,"Includes product identification, lot numbers, and transaction dates."]
[null,"How to fill:"]
[null,"1.      Enter the product identifier (e.g., NDC or GTIN)."]
[null,"2.      Provide the lot number and expiration date, if available."]
[null,"3.      Specify the transaction dates for which information is needed."]
[null,"2. TI Request Additional Info"]
[null,"This sheet contains optional fields for supplemental data to support the TI request."]
[null,"Use this section to add comments or context about the trace request."]
[null,"3. TI Requests"]
[null,"Main section where detailed TI requests are compiled."]
[null,"This includes specific product trace requests and their statuses."]
[null,"How to fill:"]
[null,"1.      Enter each individual TI request on a new row."]
[null,"2.      Provide the requested information based on product and transaction parameters."]
[null,"3.      Track the status (Pending, Completed, etc.)."]
[null,"4. Lookup Tables"]
[null,"Contains predefined values for easy data entry (e.g., product codes, organization names)."]
[null,"These tables help ensure consistency across the workbook. Review the available lookup values to avoid errors in entries."]
[]
[null,"How to Use the Workbook"]
[null,"1. Review Instructions:"]
[null,"Begin with the Instructions sheet to familiarize yourself with the workbook's structure and entry requirements."]
[null,"2. Enter Requester Information:"]
[null,"Fill out your contact details and organization information in the Requester Information sheet."]
[null,"3. Add Transaction Parameters:"]
[null,"Input key parameters such as product identifiers and transaction dates in the TI Request Parameters sheet."]
[null,"4. Provide Additional Information (Optional):"]
[null,"Use the TI Request Additional Info sheet for any extra context."]
[null,"5. Track Requests:"]
[null,"Enter your TI requests in the TI Requests sheet and monitor their progress."]
[null,"6. Utilize Lookup Tables:"]
[null,"Use the Lookup Tables for predefined values to ensure accurate data input."]
[]
[null,"Tips for Effective Use"]
[null,"Consistency is Key: Use the Lookup Tables whenever possible to avoid typos and ensure uniform data entry."]
[null,"Update Status Regularly: Keep the status of each request up to date in the TI Requests sheet."]
[null,"Track Changes: Refer to the changes sheet for a history of modifications to the workbook."]

{"sheet":"Audit References","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["PDG Trace - TI Request"]
["TI Request Audit References"]
[]
["Trace Request Template Version:","01.00.00"]
[]
["TI Request ID*:",null,"Use a Universally Unique ID "]
[]
["TI Request Investigation ID:",null,"Use a Universally Unique ID "]
[]
["TI Request Timestamp*:"]

{"sheet":"Requester Information","index":3,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["PDG Trace - TI Request"]
["Requesting Party"]
[]
[]
["Contact Information:"]
[]
["Person or Department Name*:"]
[]
["Organization Name*:"]
[]
["Phone*:"]
[]
["Email*:"]
[]
["Requester GLN:"]
[]
["Callback Address*:"]
[]
["Email Callback Address:"]
[]
["API Callback Address:"]

{"sheet":"TI Request Parameters","index":4,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["PDG Trace - TI Request"]
["TI Request Parameters"]
[]
[]
["Response Type Requested*:"]
[]
["Investigation Reason Attestation*:"]
[]
["Investigation Circumstances*:"]
[]
["On Behalf of Authority:"]
[]
["Request is on Behalf of Authority:",false]
[]
["Authority Information:"]
[]
["Person or Department Name*:"]
[]
["Organization Name*:"]
[]
["Email*:"]
[]
["Phone*:"]
[]
["Recall Information:"]
["Recall Depth:"]
["Recall Request Level:"]

{"sheet":"Requester 3911s","index":5,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["PDG Trace - TI Request"]
["Known 3911s associated with the requested products"]
[]
[3911]

{"sheet":"TI Requests","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4]]}
["PDG Trace Request Template"]
["TI Requests"]
[]
[null,"Product ID (GTIN or NDC)",null,"Serial or Lot"]
["Request Line Number","GTIN","NDC","Serial Number","Lot Number","Additional Information"]
[1]
[{"$f":"A6+1","v":2}]
[{"$f":"A7+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]

{"sheet":"TI Request Additional Info","index":7,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["PDG Trace - TI Request"]
["Additional Information","(provide links or attach additional documents)"]
[]
[]
["Document Links"]
[]
[]
[]
["Attached Document Names:"]

{"sheet":"Lookup Tables","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["PDG Trace Request Template"]
["Lookup Tables"]
[]
[null,"Response Type List",null,"Investigation Reason Attestation List"]
[null,"Transaction Information",null,"Suspect Product Investigation"]
[null,"All Known Owners",null,"Illegitimate Product Investigation"]
[null,"Last Known Owner",null,"Recalled Product Investigation"]
[null,null,null,"Compliance Audit"]
[null,null,null,"Health Authority Inspection"]