Attachment 6_Transactional Data Report.xlsx

Instructions

Every PACTS III Contract Holder must submit this report by the due date and in accordance with the instructions below.

• Complete cells outlined in red. Cells outlined in black will automatically populate.

• Do not change the format of the template or the formulas within the template (e.g. do not change column headers or the order of columns)

• Save the file name in this format:

TDR [MONTH_YEAR] [CONTRACT NUMBER] [COMPANY NAME]

• Awards of any and all orders that were issued during this reporting period should be included, regardless of delivery or invoice status.

• Please read the data field notes and definitions for guidance.

70SBUR21D00000023

XYZ Company 1/1/2021 - 1/31/2021

Award Vehicle The DHS designated name of the award vehicle. This field has been pre-populated in the template.

Contract Number (IDVPIID) This is the DHS issued contract number for the PACTS III contract. This number can be found on the contract form, SF 1449, item no. 2. Choose the correct number from the drop down list.

IDVPIID is a term used in the Federal Procurement Data System. It refers to the Indefinite Delivery Vehicle Procurement Instrument Identifier, i.e. the contract number. Example: 70SBUR21D00000023

Note: This number should be the same for this field for all line items. There are no spaces or dashes within the award number.

Socio-Economic Category This field should include the socio-economic track within which the company received a contract award. In a SF 1449, see item no. 10. This field will populate after choosing contract number.

Vendor Name This field should include the company name as reflected on your contract award document. The data in this field should be consistent throughout your data report. This field will populate after choosing contract number.

Unique Entity Identifier (UEI) Unique Entity Identifier (UEI) number. This field will populate after choosing contract number.

Order Number (Award PIID) This is the order number issued by the specific ordering Component. This should be a unique number and differs from the Contract Number. If a SF 1449 form is used, see item no. 4. Purchase card transactions should include the last four digits of the purchase card instead of an order number. Example: 70FA5021F00000118 Note: This number should be unique for every order. Every agency may have a slightly different numbering format. There are no spaces or dashes within the order number

NAICS Code The North American Industry Classification System (NAICS) code associated with the IDIQ contract award. This field will populate after choosing a contract number.

Contract Type Pricing structure of order. A hybrid contract type is a combination of the other three contract types. In a SF 1449, see item no. 20. Choose from drop down list. FFP: Firm Fixed Price LH: Labor Hour TM: Time-and-Material Hybrid

Department The name of the Department who issued the order. This field has been pre-populated in the template. These contracts are authorized for use only by the Department of Homeland Security.

Component or Office Choose the name of the specific component or office of the issuing agency/ Department from the drop down list. For a SF1449, see item no. 9 or 15. CIS: U.S. Citizenship and Immigration Service CISA: Cybersecurity and Infrastructure Security Agency CBP: U.S. Customs and Border Protection HQ: DHS Headquarters, including Management Directorate, Ops, CWMD, I&A, and S&T FEMA: Federal Emergency Management Agency FLETC: Federal Law Enforcement Training Centers ICE: U.S. Immigration and Customs Enforcement TSA: Transportation Security Administration USCG: United States Coast Guard USSS: United States Secret Service

Date of Award Date the order is effective. For a SF1449, see item no. 3. Purchase card orders should use the order date. Date Format: MM/DD/YYYY

Note: Please do not include the time

Start Date Period of Performance start date. For a SF1449, see item no. 20. Credit card orders should include order date, which in most cases, will be both the initial award date and the start date. Date Format: MM/DD/YYYY

Note: Please do not include the time

End Date Period of Performance end date. For a SF1449, see item no. 20. For Credit Card orders: if the End Date (government received date) is greater than the Start Date + 15 days, provide a tracking receipt that shows the Delivery date. Date Format: MM/DD/YYYY

Note: Please do not include the time

Award Amount The total award amount, inclusive of all option quantities and periods of performance. For a SF1449, see item no. 20. Base plus option line item dollar amounts. Do not enter CLIN dollar amounts in this column. Accounting format

Discounts per Order The total discounts for the order. This is the difference between the commercial price and the DHS order price for the entire order. This should be the aggregate of the discounts for each line item. Accounting format

PACTS III Products and Services Tab

Service Description Description of the specific item or service provided.

Only list items for which funds have been obligated in the award document. Unexercised options should be not be reported. Options will be reported as modifications when they are exercised in the month that the modification occurs, which may be weeks or years after original award. This is a free text field.

Example: "Program Management Operations"

NOTE: Specific line item data should be reported in this field. If an order is structured in such a way that multiple services are consolidated or bundled into one CLIN for the order, the contractor should list those services individually as separate services in this report, to the extent practicable.

Example:

Task Order:

CLIN 0001 Administrative Support

TDR Format:

Row 1: Program and Site Management Row 2: Program Management

Modification Number (if applicable) Indicate the modification number for the order, if applicable. Modifications should be recorded when additional quantities or services are funded in the reporting period. Example: P00001

Total Obligation Amount The funding obligated by all components during the reporting period. This value is automatically calculated.

Monthly Discount Amount The total value of discounts received in all orders awarded during the reporting period. This value is automatically calculated.

Total Number of Orders The total number of orders awarded during the reporting period. This value is automatically calculated.

Discounts to Date on Contract The total value of discounts received in all orders since the initial contract award. Accounting format

DRAFT

PACTS III Order Information PACTS III Transactional Data Report

Data Element Descriptions *Refer to the instructions for each of the data elements in the report template. If you have questions on any data element, please contact the solution manager. Please do not make assumptions on completing any data element or field.

*Formatting Requirements:

• Provide this report in .xls or .csv format

• Do not change the format of the template (e.g. do not change column headers or the order of columns)

• Save the file name in this format: MSMR [DATE] [CONTRACT NUMBER] [COMPANY NAME] *Reporting Period: TBD

* Do not change any formulas for any column highlighted in red without obtaining prior approval from PACTS III Category Manager at DHS SSO

Award Vehicle Contract Number (IDVPIID) Socio- Economic Category Vendor Name Pennel, Amanda: Definition:

This field should include the company name as reflected on your contract award document. The data in this field should be consistent throughout your data report.

Note: Please do not use abbreviations or acronyms unless that is reflected in your company name on your contract award document. UEI Pennel, Amanda: Definition:

Enter the official DUNS number.

Pennel, Amanda: Definition:

This field should reflect the name of the agency who issued the order.

This field has been pre-populated in the template. These contracts are authorized for use only by the Department of Homeland Security. Component Order/Award Date Pennel, Amanda: Definition:

Date the order is effective. For a SF1449, see item no. 3. For an OF347, see item no. 1.

Date Format: MM/DD/YYYY

[Contract Number] [Contractor Name] [Reporting Period]

DRAFT

PACTS III Products and Services Award Vehicle Contract Number (IDVPIID) Order Number (Award PIID) Vendor Name Department Quantity of Units Sold Commercial Unit Price DHS Order Unit Price Unit of Measure Total Unit Price Service Description Award Date UEI Socio- Economic Category Modification Number (if applicable) Pennel, Amanda: Definition:

Indicate the modification number for the order if applicable. NAICS Code Component Per Item Discount Extended Item Discount Total Baseline Price Pennel, Amanda: Definition:

The baseline price per unit (column L) multiplied by the quantity of item sold (column N). Savings Achieved (Baseline - Award) Pennel, Amanda:

Do not edit any formulas or information contained in columns R and S.

Pennel, Amanda: Definition:

Summary

DRAFT

Vendor Information