Attachment 5_Transactional Data Report_3rd Draft RFP.xlsx

Instructions

• 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:

PACTS3-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.

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.

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.

Functional Category This is the Functional Category associated with the PACTS III contract. This field is pre-populated and should not be edited. The field will remain hidden.

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. If an OF347 is used, the order number can be found in item no. 3. 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

Modification Number (if applicable) Indicate the modification number for the order, if applicable. Modifications should be reported when additional funds are obligated during the reporting period. Example: P00001

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 auto-populate based on the input within the "Contract Number" field. The field will remain hidden.

Unique Entity Identifier (UEI) Unique Entity Identifier (UEI) number. This field will auto-populate based on the input within the "Contract Number" field. The field will remain hidden.

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 auto-populate based on the input within the "Contract Number" field. The field will remain hidden.

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 The name of the specific component or office of the issuing agency. For a SF1449, see item no. 9 or 15. Do not use abbreviations or acronymns. Every transaction must list an associated Component. Below is a list of Component Names.

USCIS: 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: U.S. Coast Guard USSS: U.S. Secret Service

Order/Award Date Date the order is effective. For a SF1449, see item no. 3. For an OF347, see item no. 1 Date Format: MM/DD/YYYY

Note: Please do not include the time. This may or may not be the same as the start of period of performance for services.

Description of Deliverable Description of the specific item or service provided.

This is a free text field.

Example: "Task Order Project Manager in support of OpSec 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.

Award Price Per Unit The price awarded per unit for the line item of service. This price should not exceed the baseline price. If so, an explanation will be required.

Quantity of Item Sold The total number of units. Input in general numerical form (e.g. 10, 100, 10,000)

Unit of Measure Unit of measure that represents how the quantity of item sold is counted (e.g. each, lot, hour, year, pound, etc). Units should be spelled out, not abbreviated. For example, input "each' not "ea"

Total Awarded Price The award price per unit multiplied by the quantity of item sold This field will auto-populate based on previous inputs. Do not edit this field. It will remain hidden.

Total Baseline Price The baseline price per unit multiplied by the quantity of item sold This field will auto-populate based on previous inputs. Do not edit this field. It will remain hidden.

Contract Type The contract type for the specific order. FFP: Firm Fixed Price LH: Labor Hour TM: Time-and-Material Hybrid is a combination of other allowable contract types

Period of Performance Start Date Period of Performance start date. Date Format: MM/DD/YYYY

Note: Please do not include the time

Period of Performance End Date Period of Performance end date. This should reflect the period of performance covered by the obligated funds only. Do not include end date inclusive of unexercised options. Date Format: MM/DD/YYYY

Note: Please do not include the time

&"Times New Roman,Regular"&12Transactional Data Report Attachment 5

DRAFT

Example

$ 1,050,080.00 $ 1,057,600.00 $ 7,520.00 1%

Award Vehicle Pennel, Amanda: Pennel, Amanda:

The DHS designated name of the award vehicle. This field has been pre-populated with "PACTS III." Contract Number (IDVPIID) Pennel, Amanda: Defintion:

This is the DHS issued contract number for your PACTS III contract. This number can be found on the contract form, SF 1449, item no. 2.

IDVPIID is a term used in the Federal Procurement Data System. It refers to the Indefinite Delivery Vehicle Procurement Instrument Identifier, ie. the contract number.

Example: 70B04C19D00000023 Note: This number should be the same for this field for all line items. Functional Category Pennel, Amanda: Pennel, Amanda:

This is the Functional Category associated with the PACTS III contract. This is a pre-populated field that is hidden and should not be edited. Order Number (Award PIID) Pennel, Amanda: Definition:

This is the order number issued by the ordering agency for your PACTS III contract. This should be a unique number and differs from the Contract Number. If an SF 1449 form is used for the order, the order number can be found in item no. 4. If an OF347 is used, the order number can be found in item no. 3.

Example: 70FA5019F00000118 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. Modification Number (if applicable) Pennel, Amanda: Definition:

Indicate the modification number for the order if applicable. Modifications should be reported when additional funds are obligated during the reporting period. 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.

This field will auto-populate based on the input within the "Contract Number" field.

UEI

Pennel, Amanda: Definition:

This is the official Unique Entity Identifier (UEI) number.

This field will auto-populate based on the input within the "Contract Number" field. Socio- Economic Category Pennel, Amanda: Pennel, Amanda:

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 auto-populate based on the input within the "Contract Number" field. The field will remain hidden.

Department 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 or Office Pennel, Amanda: Definition:

This field should reflect the name of the component or office of the issuing agency/ Department.

Note: Please do not use abbreviations or acronymns. Every DHS transaction should have an associated component. If the component/office is unknown for other authorized agencies, leave the field blank. 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

Note: Please do not include the time. This may or may not be the same as the start of period of performance for services. Description of Deliverable Pennel, Amanda: Definition:

Description of item or service purchased

This is a free text field. Please input data without use of abbreviations.

Example: "Task Order Project Manager in support of OpSec 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. Baseline Price Per Unit (Contract Ceiling Price) Pennel, Amanda: Definition:

If there is a contract ceiling price per unit for this line of service, include it here. If this price is available, this is the baseline price to be used. Skip the field for column M. DO NOT include data in both Column L and Column M. Baseline Price Per Unit (Commercial List Price) Pennel, Amanda: Definition:

If a contract ceiling price is not available (column L) then include the commercial List price for the line item of service here. DO NOT include data in both Column L and Column M. Award Price Per Unit Pennel, Amanda: Definition:

The price awarded per unit for the specific line item of service. This price should NOT exceed the baseline price. Quantity of Item Sold Pennel, Amanda: Definition:

The total number of units. Unit of Measure Pennel, Amanda: Definition:

Unit of measure that represents how the quantity of item sold is counted (e.g. each, lot, hour, year, pound, etc).

Units should be spelled out, not abbreviated. For example, input "each' not "ea" Total Awarded Price Pennel, Amanda: Definition:

The award price per unit (column L) multiplied by the quantity of item sold (column M). Total Baseline Price Pennel, Amanda: Definition:

The baseline price per unit (either column J or column K) multipled by the quantity of item sold (column M). Contract Type Pennel, Amanda: Pennel, Amanda:

The contract type for the specific order.

FFP: Firm Fixed Price LH: Labor Hour TM: Time-and-Material Hybrid is a combination of other allowable contract types Period of Performance Start Date Pennel, Amanda: Pennel, Amanda:

Period of Performance start date. Period of Performance End Date Pennel, Amanda: Pennel, Amanda:

See the example below.

Transactional Data Report

DRAFT

Report

$ - 0 $ - 0 $ - 0 ERROR:#DIV/0!

Award Vehicle Pennel, Amanda: Pennel, Amanda:

The DHS designated name of the award vehicle. This field has been pre-populated with "PACTS III." Contract Number (IDVPIID) Pennel, Amanda: Defintion:

This is the DHS issued contract number for your PACTS III contract. This number can be found on the contract form, SF 1449, item no. 2.

IDVPIID is a term used in the Federal Procurement Data System. It refers to the Indefinite Delivery Vehicle Procurement Instrument Identifier, ie. the contract number.

Example: 70B04C19D00000023 Note: This number should be the same for this field for all line items. Functional Category Pennel, Amanda: Pennel, Amanda:

This is the Functional Category associated with the PACTS III contract. This is a pre-populated field that is hidden and should not be edited. Order Number (Award PIID) Pennel, Amanda: Definition:

This is the order number issued by the ordering agency for your PACTS III contract. This should be a unique number and differs from the Contract Number. If an SF 1449 form is used for the order, the order number can be found in item no. 4. If an OF347 is used, the order number can be found in item no. 3.

Example: 70FA5019F00000118 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. Modification Number (if applicable) Pennel, Amanda: Definition:

Indicate the modification number for the order if applicable. Modifications should be reported when additional funds are obligated during the reporting period. 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.

This field will auto-populate based on the input within the "Contract Number" field.

UEI

Pennel, Amanda: Definition:

This is the official Unique Entity Identifier (UEI) number.

This field will auto-populate based on the input within the "Contract Number" field. Socio- Economic Category Pennel, Amanda: Pennel, Amanda:

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 auto-populate based on the input within the "Contract Number" field. The field will remain hidden.

Department 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 or Office Pennel, Amanda: Definition:

This field should reflect the name of the component or office of the issuing agency/ Department.

Note: Please do not use abbreviations or acronymns. Every DHS transaction should have an associated component. If the component/office is unknown for other authorized agencies, leave the field blank. 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

Note: Please do not include the time. This may or may not be the same as the start of period of performance for services. Description of Deliverable Pennel, Amanda: Definition:

Description of item or service purchased

This is a free text field. Please input data without use of abbreviations.

Example: "Task Order Project Manager in support of OpSec 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. Baseline Price Per Unit (Contract Ceiling Price) Pennel, Amanda: Definition:

If there is a contract ceiling price per unit for this line of service, include it here. If this price is available, this is the baseline price to be used. Skip the field for column M. DO NOT include data in both Column L and Column M. Baseline Price Per Unit (Commercial List Price) Pennel, Amanda: Definition:

If a contract ceiling price is not available (column L) then include the commercial List price for the line item of service here. DO NOT include data in both Column L and Column M. Award Price Per Unit Pennel, Amanda: Definition:

The price awarded per unit for the specific line item of service. This price should NOT exceed the baseline price. Quantity of Item Sold Pennel, Amanda: Definition:

The total number of units. Unit of Measure Pennel, Amanda: Definition:

Unit of measure that represents how the quantity of item sold is counted (e.g. each, lot, hour, year, pound, etc).

Units should be spelled out, not abbreviated. For example, input "each' not "ea" Total Awarded Price Pennel, Amanda: Definition:

The award price per unit (column L) multiplied by the quantity of item sold (column M). Total Baseline Price Pennel, Amanda: Definition:

The baseline price per unit (either column J or column K) multipled by the quantity of item sold (column M). Contract Type Pennel, Amanda: Pennel, Amanda:

The contract type for the specific order.

FFP: Firm Fixed Price LH: Labor Hour TM: Time-and-Material Hybrid is a combination of other allowable contract types Period of Performance Start Date Pennel, Amanda: Pennel, Amanda:

Period of Performance start date. Period of Performance End Date Pennel, Amanda: Pennel, Amanda:

Transactional Data Report Attachment 5

DRAFT

Vendor Information

&"Times New Roman,Regular"&12Transactional Data Report

DRAFT

image1.png