Attachment_14_-_DoD_EMALL_Process_Improvement_Guide.pdf

PDF 1 MB Posted

Attached to
Non Fire-Resistant Combat Shirt Federal contract opportunity
Solicitation number
FA8054-16-R-0001
Issued by
Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

Attachment 14 - DoD EMALL Process Improvement Guide

View the file

Other files for this federal contract opportunity

Other files attached to Non Fire-Resistant Combat Shirt, newest first.
File Type Posted
Amendment_2_-_Non-FR_Combat_Shirt.pdf PDF
Questions_from_Prospective_Offerors.docx DOCX document
Questions_from_Prospective_Offerors.docx DOCX document
Questions_from_Prospective_Offerors.docx DOCX document
Questions_from_Prospective_Offerors.docx DOCX document
Attachment_15_-_Vendor_Questions_and_Answers.docx DOCX document
Amendment_1_-_Non-FR_Combat_Shirt.pdf PDF
Exhibit_A002_-_Appendix_B_Qtrly_Reporting_Req_Def.pdf PDF
Exhibit_A001_-_Appendix_A_Qtrly_Report_Matrix.xlsx XLSX spreadsheet
Attachment_1_-_Non-FR_Combat_Shirt_Salient_Characteristics.pdf PDF
Exhibit_B001_-_Appendix_A_PMR_Content_ _Guidelines.pdf PDF
Attachment_9_-_Test_Table_Type_C_Material.pdf PDF
FA8054-16-R-0001_(Non-FR_Combat_Shirt_Solicitation).pdf PDF
Exhibit_B_-_CDRL_-_PMR.pdf PDF
Attachment_7_-_Test_Table_Type_A_Material.pdf PDF
Attachment_8_-_Test_Table_Type_B_Material.pdf PDF
Attachment_3_-_Base_Shipping_Locations.xlsx XLSX spreadsheet
Exhibit_A_-_CDRL_Reporting.pdf PDF
Attachment_2_-_Non-FR_Combat_Shirt_Pricing_Worksheet.xlsx XLSX spreadsheet
Attachment_13_-_DoD_EMALL_Contractor_Registration.pdf PDF
Attachment_6_-__Requirements_Acceptability_Chklist.xlsx XLSX spreadsheet
Attachment_12_-_DoD_EMALL_Supplier_Registration_CAC-PKI.pdf PDF
Attachment_11_-_DoD_EMALL_Supplier_Info_Package.pdf PDF
Attachment_10_-_Test_Table_Type_D_Material.pdf PDF
Show all 24

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

[ v 14.4.1 ]

August

BML-10-003, FPDS-NG

Award interface for the Federal Procurement Data System – Next Generation

Job Aid

Prepared by

2 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Contents 1 Overview – Federal Procurement Data System

1.1 Requirements for FPDS Reporting

1.2 FPDS Data Elements: Auto-Population and Checkout

1.3 Award Transmission to DLA Transaction Services

1.4 Completing FPDS Information in Checkout

1.4.1 FPDS Award Questions

1.4.2 FPDS Award Options

1.5 FPDS Console

1.5.1 Resending FPDS Award XML

1.6 FPDS Award XML Page

1.6.1 Editing FPDS Award XML

2 FPDS Award Document

2.1 Award Mappings for DOD EMALL

2.2 Unused or Null FPDS Data Elements

3 Appendix: Award XML Example

3 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Formatting Key for the DOD EMALL User Interface (UI)

UI Element Example

NAVIGATION MENU “Select SEARCH from the SHOP menu.”

HYPERLINK “Click CART SUMMARY to view your current cart.”

Page Name or Panel

“The Checkout Summary page displays supplier orders requiring FPDS awards.”

Field Name “Select the Contracting Agency Code associated to your organization .”

BUTTON or SCREEN

TAB

“Click COMPLETE SELECTED to update FPDS Awards for the selected supplier orders.”

Icon “Click the icon to display help text.”

4 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1 Overview – Federal Procurement Data System

The Federal Procurement Data System-Next Generation (FPDS-NG) is an enterprise reporting system that provides visibility into procurement activities and contracts across government agencies. The intent is to equip government and the public at-large with tools to understand how tax dollars are spent and how they may be better utilized.

The Office of the Secretary of Defense (OSD) has mandated that DOD EMALL comply with FPDS initiatives by reporting its commercial order data. The FPDS reporting interface was implemented on DOD EMALL in March 2013 as part of version 13.2.1. Since that release, DOD EMALL has captured and stored FPDS data for qualifying supplier orders to be sent once DOD EMALL has passed the FPDS-NG certification process.

Many changes have been made since the initial implementation of FPDS-NG, including:

Updates to FPDS reporting criteria

Updates to the Award XML data mapping

Addition of the FPDS Console

Addition of the FPDS Award XML - Edit capability

This guide represents FPDS-NG functionality as of DOD EMALL version 14.4.1 scheduled for August 2014.

1.1 Requirements for FPDS Reporting

FPDS awards are XML files sent to FPDS-NG for qualifying supplier orders. Within Checkout, a cart may contain one or more supplier orders depending on the number of unique contracts the line items were selected from. Among those, one or more may require reporting to FPDS.

As of DOD EMALL version 14.4.1, supplier orders meeting all of the following criteria must have a corresponding FPDS award:

Contains no DLA-managed line items (DLA managed = Items with no LTA ID or an LTA ID that begins with "SP")

Payment Method is Government Purchase Card

Department of the user placing the order is "Department of Defense" (excluding National Geospatial Intelligence Agency users)

FPDS reporting does not apply to MILSTRIP orders. FPDS awards are generated for all qualifying supplier orders regardless of the order amount.

1.2 FPDS Data Elements: Auto-Population and Checkout

FPDS awards are comprised of many distinct data elements (see Award Mappings for DOD EMALL).

Most of the data elements are auto-populated using mapped values drawn from the DOD EMALL orders database.

5 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

The following data elements, however, require user input to satisfy the FPDS award requirements:

Major Program

Contingency, Humanitarian, or Peacekeeping Operation

National Interest Action

Product or Service Code (conditional)

Performance Based Service Acquisition

Program/Funding Agency Code

Contracting Office Code

Treasury Account Symbol Agency Identifier

Main Account Code

Sub Account Code

To address these data elements, users are required to complete an FPDS web form for qualifying orders as part of the Checkout process. User responses are subsequently used to augment the auto-populated FPDS data upon order placement.

1.3 Award Transmission to DLA Transaction Services

FPDS awards are generated and sent to DLA Transaction Services as part of DOD EMALL post-order processing. Award documents are transmitted as XML over SFTP. The awards use a proprietary SOAP (Simple Object Access Protocol) format, which allows DLA Transaction Services to subsequently relay the awards onto FPDS.

FPDS uses identifiers called Service Originator IDs to identify awards generated by DOD EMALL. Upon upload in FPDS, award documents from DOD EMALL will reference one of five Service Originator IDs derived from the user’s Program/Funding Agency Code.

User Program/Funding Agency Code Service Originator Sent to FPDS

1700 - DEPT OF THE NAVY SYSORIG.EMALL@SA1700.NAVY

2100 - DEPT OF THE ARMY SYSORIG.EMALL@SA2100.ARMY

5700 - DEPT OF THE AIR FORCE SYSORIG.EMALL@SA5700.AF

97AS - DEFENSE LOGISTICS AGENCY SYSORIG.EMALL@SA97AS.DLA

All other Program/Funding Agency Codes SYSORIG.EMALL@SA97XX.ODA

1.4 Completing FPDS Information in Checkout

This section describes how to complete the FPDS Information requested during checkout for qualifying supplier orders.

6 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1. After completing a cart requiring FPDS reporting (see Requirements for FPDS Reporting), the FPDS Information panel is displayed, similar to the following:

The FPDS Information panel displays the following information per supplier order:

Supplier: Supplier name associated with the order.

Order Number: Supplier order identifier.

FPDS Award: Indicates whether the FPDS award form is completed for the associated order.

2. Select one or more supplier order(s) to complete.

Users can select to complete the supplier orders individually or in bulk. Select the checkbox next to the FPDS Award column heading to automatically select all supplier orders in the checkout cart.

FPDS award forms should be completed individually if any selected supplier orders require different responses.

FPDS Information will not display for users paying with MILSTRIP, Non-Standard GPC, Corporate Credit Card, or State Purchase Card.

7 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

3. Click COMPLETE SELECTED.

The Edit FPDS Award page is displayed, similar to the following:

If completing the award questions for a single supplier order, the following information is displayed at the top of the page:

Supplier

LTA ID

Supplier Order ID

Order Total

Item Description

Mfr. Part #

Document Number

Qty

Unit Price

[Line Item Total] Price

If completing the award questions for more than one supplier order, a message is displayed at the top of the page, similar to the following:

8 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1.4.1 FPDS Award Questions

4. Answer the following questions listed under Award Questions as they pertain to the selected supplier order(s).

Question Notes

Is this in support of a Major Program? Select from the following options:

Yes

No

If "Yes" is selected, enter the name of the Major Program.

Is this being ordered in support of a

Contingency, Humanitarian, or

Peacekeeping operation?

Select from the following options:

A = Contingency operation as defined in 10 U.S.C. 101(a)(13)

B = Humanitarian or peacekeeping operation as defined in 10

U.S.C 2302(8)

X = A or B does not apply

Is this part of a National Interest Action? Select from the following options:

NONE None

H05K Hurricane Katrina 2005

H05O Hurricane Ophelia 2005

H05R Hurricane Rita 2005

H05W Hurricane Wilma 2005

H08G Hurricane Gustav 2008

H08I Hurricane Ike 2008

H06E Hurricane Ernesto 2006

O12F Operation Enduring Freedom (OEF)

Select a Product/Service Code: Select a Product or Service Code (PSC). Note that the list is only displayed if the line item in the supplier order with the highest dollar amount does not have a default PSC (meaning the PSC item attribute is populated).

When completing multiple FPDS Awards at the same time and not all of the supplier orders have a default PSC, the selected

Product/Service Code is applied to only those supplier orders with no default PSC.

9 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Question Notes

Is this a Performance-Based Service

Acquisition?

Select from the following options:

Y = Yes

N = No

X = Does not apply

Note that "X" is forced under either of the following conditions:

The Product or Service Code selected by the user on the FPDS

Questionnaire begins with a numeric character.

There is only one supplier order and the default PSC for that order begins with a numeric character.

10 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1.4.2 FPDS Award Options

5. Make a selection for each of the following FPDS Award Options:

Option Notes

Program/Funding Agency Code Select a DOD Program/Funding Agency Code:

1700 DEPT OF THE NAVY

5700 DEPT OF THE AIR FORCE

97AS DEFENSE LOGISTICS AGENCY

9748 DEFENSE HUMAN RESOURCES ACTIVITY

9761 DEFENSE THREAT REDUCTION AGENCY (DTRA)

9763 DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA)

9771 DEFENSE MICROELECTRONICS ACTIVITY (DMEA)

9773 VIRGINIA CONTRACTING AGENCY

9776 USTRANSCOM HTC711 USTRANSCOM-AQ

97AB NATIONAL GEOSPATIAL-INTELLIGENCE AGENCY (NGA)

97AE DEFENSE ADVANCED RESEARCH PROJECTS AGENCY

(DARPA)

97AK DEFENSE INFORMATION SYSTEMS AGENCY (DISA)

97AT DEFENSE SECURITY COOPERATION AGENCY

97AV DEFENSE SECURITY SERVICE

97AZ DEFENSE COMMISSARY AGENCY (DECA)

97BZ DEFENSE FINANCE AND ACCOUNTING SERVICE (DFAS)

97DH DEFENSE HEALTH AGENCY (DHA)

97F1 DEFENSE MEDIA ACTIVITY (DMA)

97F2 DEPT OF DEFENSE EDUCATION ACTIVITY (DODEA)

97F5 WASHINGTON HEADQUARTERS SERVICES (WHS)

97F7 JOINT IMPROVISED EXPLOSIVE DEVICE DEFEAT

ORGANIZATION (JIEDDO)

97HW UNIFORMED SERVICES UNIVERSITY OF THE HEALTH

SCIENCES (USUHS)

97JC MISSILE DEFENSE AGENCY (MDA)

97ZS U.S. SPECIAL OPERATIONS COMMAND (USSOCOM)

Contracting Office Codes Select a Contracting Office Code. The list of Contracting Office

Codes is restricted to those that are valid for the selected

Program/Funding Agency Code.

Treasury Account Symbol Agency

Identifier

Select the Treasury Account Symbol Agency Identifier for your organization.

11 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Option Notes

Account Code Select the Account Code for your organization's Treasury

Account Symbol. The list of codes is restricted to those that are valid for the selected Treasury Account Symbol Agency

Identifier.

6. Select the Save FPDS-NG Options to Express Settings checkbox to auto-populate the FPDS-NG Options for future orders.

FPDS Options saved to the user’s Express Settings are retained in the database only;

they are not displayed in User Profile.

7. Click SUBMIT.

The FPDS Award status for the completed supplier orders is now marked "COMPLETE", similar to the following:

8. Click PLACE ORDER.

Prior to placing the order, users may reselect the completed FPDS award and click COMPLETE SELECTED to edit previous responses. However, once the order is placed the award can only be modified via the FPDS Award XML - Edit page.

DOD EMALL generates the FPDS award document as part of order processing. User responses are propagated in the award.xml, accordingly.

12 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1.5 FPDS Console

The FPDS Console displays all qualifying supplier orders that have successfully completed the Queue FPDS Awards post order processing step.

The FPDS CONSOLE tab is available under ORDERS | DOD EMALL ORDERS.

Only DOD EMALL users with the following Administrator Functions can access the FPDS Console:

Order Admins

DOD EMALL Staff Admin

The FPDS Console allows Administrators to search for orders and resend the Award XML, either individually or in bulk.

13 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Orders can be filtered using the following Search Criteria:

Purchase order ID

Supplier order ID

LTA ID

Orderer account name

Order date range

Last sent date range

The supplier orders displayed in the list are organized around the same information used for the search criteria. The following table provides a summary of the information displayed for each supplier order.

Column Description

Purchase Order ID Purchase Order ID for the Supplier Order. Click the ID to display the Purchase Order

Details page.

Supplier Order ID Supplier Order ID. Click the ID to edit the Award XML for the supplier order (see Editing FPDS Award XML).

LTA ID The Long Term Agreement (LTA) ID (contract number) of the supplier.

Order Date/Time The date/time the supplier order was placed on DOD EMALL.

Last Sent Date/Time The last date/time the FPDS Award XML was sent to FPDS.

Resend Allows user to resend the Award XML. Click the RESEND link to send the Award XML for only the Supplier Order ID referenced on that line. To send multiple supplier orders, select the checkboxes for multiple rows and then click the RESEND button that appears below the column.

The results in the list can be sorted using any of the column headings. By default, the results are sorted by last sent date/time with the most recently sent appearing at the top.

14 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1.5.1 Resending FPDS Award XML

This section explains how to resend Award XML for one or more supplier orders.

To resend the FPDS Award XML:

1. Enter the search criteria necessary to look up the supplier order(s) and then click SUBMIT.

The supplier orders displayed in the list are restricted to only those matching the search criteria.

2. (Conditional) To resend a single FPDS Award, click the RESEND link on the row containing the supplier order, similar to the following:

3. (Conditional) To resend multiple FPDS Awards, select the Resend checkbox for each supplier order you wish to resend and then click the RESEND button, as shown in the following example.

To select all supplier orders on the page, click the checkbox in the Resend column heading.

The number of search results displayed on the page can be changed from 10 to 25, 50, 75, or 100 using the Show <#> entries dropdown list.

15 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1.6 FPDS Award XML Page

The FPDS Award XML page, shown in the following example, allows Order Admins and DOD EMALL Staff Admins to make edits to the Award XML before resending it to FPDS.

The following information is displayed for the FPDS Award XML file:

Field Description

Last Edited By: DOD EMALL User ID of the orderer or the Admin who last edited the Award

XML.

Last Modification Method The method in which the Award XML was last modified:

GENERATED - Indicates the Award XML was automatically generated by

DOD EMALL as part of post order processing.

MANUAL - Indicates the Award XML was last edited manually via the Award

XML edit functionality provided on the FPDS Award XML - Edit page.

Supplier Order ID The ID of the Supplier Order for which the data in the Award XML represents.

LTA ID The Long Term Agreement (LTA) ID (contract number) of the supplier.

Last Update Date The last date/time the FPDS Award XML was sent to FPDS.

Only the most recently submitted version of the award XML file is displayed. Previous versions are stored in the database but are not available in the UI.

16 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1.6.1 Editing FPDS Award XML

This section explains how to access and edit the FPDS Award XML using the web-based text editor.

The FPDS Award XML page is accessible from the FPDS Console.

To access the FPDS Award XML page:

Click the Supplier Order ID link of the Award you want to edit, similar to the following example:

To edit the FPDS Award XML:

1. Click anywhere inside the text editor and begin editing.

Both the content (values) and XML markup (tags) can be edited.

2. When you are finished, click SUBMIT.

A message, similar to the following, is displayed if the file was successfully updated and transmitted to DLATS.

A message, similar to the following, is displayed if the file was not successfully updated and transmitted.

Edits resulting in modified award syntax or structure will not validate. It may be helpful to click CANCEL when this occurs and start again.

17 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Create Versus Update

By default, all Award XML files from DOD EMALL are sent to DLA Transaction Services (DLATS) as

"Create" award types. This instructs FPDS-NG to create a new award because one does not already exist. Create should always be used when an Award file is being sent for the first time, which is why it is the default award type on DOD EMALL.

However, it may be necessary to send an "Update" award type if a previously sent Award XML file results in an Award at FPDS-NG being created in error status.

Award files that were created in "error" status can be identified by the presence of the following Info

Message in the email responses received back from FPS-NG.

Info code: 8605

Element Name:

Info Message: The 'Award' is in 'Error' status.

When this occurs, it is important to (1) determine the cause of the error, (2) edit the FPDS Award XML to address the cause, and (3) change the Award Type from "Create" to "Update".

To change the Award Type from Create to Update:

1. Use the text editor to change the opening "award type" tag in the Award XML from:

<m:create xmlns:m="urn:FPDS.BusinessServices.DataCollection.contracts.Award">

TO:

<m:update xmlns:m="urn:FPDS.BusinessServices.DataCollection.contracts.Award">

2. Change the closing "award type" tag in the Award XML from:

</m:create>

TO:

</m:update>

3. Click SUBMIT and check the response from FPDS-NG to verify the update was successful.

18 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

2 FPDS Award Document

2.1 Award Mappings for DOD EMALL

The following table documents data elements required for FPDS award documents (.xml) and the values DOD EMALL provides for each.

Element

Element Name XML Tag Name DOD EMALL Data Mapping Special Conditions

1A Procurement Instrument

Identifier

PIID Supplier order ID

1C Referenced PIID PIID under referencedIDVID LTA ID

1F Agency ID agencyID Four-character Program/Funding Agency

Code

FPDS Question captured in Checkout

2A Date Signed signedDate Date order is placed (YYYY-MM-DD hh:mm:ss)

2B Effective Date effectiveDate Date order is placed (YYYY-MM-DD

2C Current Completion Date currentCompletionDate Estimated delivery date (YYYY-MM-DD

Calculated from the order date using the highest Days ARO value in the order

2D Ultimate Completion Date ultimateCompletionDate Estimated delivery date (YYYY-MM-DD hh:mm:ss)

Calculated from the order date using the highest Days ARO value in the order

19 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Element

Element Name XML Tag Name DOD EMALL Data Mapping Special Conditions

3A Base and All Options Value baseAndAllOptionsValue Supplier order total

3B Base and Exercised Options

Value baseAndExercisedOptionsValue Supplier order total

3C Action Obligation obligatedAmount Supplier order total

4A Contracting Agency Code contractingOfficeAgencyID Four-character Program/Funding Agency

Code

FPDS Setting captured in Checkout

4B Contracting Office Code contractingOfficeID Contracting Office Code FPDS Setting captured in Checkout

4C Program/Funding Agency

Code fundingRequestingAgencyID Contracting Agency Code Same value as 4A

4D Program/Funding Office Code fundingRequestingOfficeID Contracting Office Code Same value as 4B

4F Foreign Funding foreignFunding "X"

5J Fee Paid for Use of IDV feePaidForUseOfService "00000000000000000.00"

6A Type of Contract typeOfContractPricing "J"

6B Undefinitized Action undefinitizedAction "X"

6F Performance Based Service

Acquisition performanceBasedServiceContract Performance Based Service Acquisition FPDS Question captured in Checkout

6G Major Program majorProgramCode Major Program FPDS Question captured in Checkout

Leave blank if Major Program is null

20 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Element Name XML Tag Name DOD EMALL Data Mapping Special Conditions

6H Contingency, Humanitarian, or Peacekeeping Operation contingencyHumanitarianPeacekeepingOp eration

Contingency, Humanitarian, or

Peacekeeping Operation

FPDS Question captured in Checkout

6J Cost or Pricing Data costOrPricingData "N"

6K Contract Financing contractFinancing "Z"

6M Description of Requirement descriptionOfContractRequirements Item Name References the line item with the highest line item total. Add prefix

"IGF::OT::IGF" and a trailing space if referenced line item is a service

("IGF::OT::IGF <itemName>")

6N Purchase Card as Payment

Method purchaseCardAsPaymentMethod "Y"

6Q Number of Actions numberOfActions "1"

6R National Interest Action nationalInterestActionCode National Interest Action FPDS Question captured in Checkout

6SC Treasury Account Symbol

Agency Identifier agencyIdentifier Positions 2-3 of the Treasury Account

Symbol (as published in the TREASURY

FINANCIAL MANUAL)

FPDS Question captured in Checkout

6SG Main Account Code mainAccountCode Positions 5-8 of the Treasury Account

Symbol (as published in the TREASURY

FINANCIAL MANUAL)

FPDS Question captured in Checkout

6SH Sub Account Code subAccountCode Positions 10-12 of the Treasury Account

Symbol, if defined ( as published in the

TREASURY FINANCIAL MANUAL)

FPDS Question captured in Checkout

21 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Element Name XML Tag Name DOD EMALL Data Mapping Special Conditions

7E Interagency Contracting

Authority interagencyContractingAuthority "X"

8A Product or Service Code productOrServiceCode Product/Service Code FPDS Question captured in Checkout

8B Program, System, or

Equipment Code systemEquipmentCode "000"

8F DOD Claimant Program Code claimantProgramCode "S1" if 8A begins with an alpha character

"C9E" if 8A does not begin with an alpha character

8H Information Technology

Commercial Item Category informationTechnologyCommercialItemCa tegory

"Z"

8J Government Furnished

Equipment/Property

GFE-GFP "N"

8K EPA Designated Products useOfEPADesignatedProducts "A" IF supplier order contains one or more items with an ENAC attribute

"E" IF supplier order contains NO items with an ENAC attribute

8L Recovered Material Clauses recoveredMaterialClauses "A" IF 8K is "A"

"C" IF 8K is "E"

8M Sea Transportation seaTransportation "U"

8N Contract Bundling contractBundlingType "D"

8P Consolidated Contract consolidatedContract "N"

22 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Element Name XML Tag Name DOD EMALL Data Mapping Special Conditions

9C Principal Place of

Performance countryCode Supplier country OR "United States" if

Supplier Country is null stateCode Two-digit State Code if countryCode is

"USA"

9E Country of Origin countryOfOrigin Supplier country OR "United States" if

Supplier Country is null

9H Place of Manufacture placeOfManufacture "C" if 8A starts with an alpha character

"D" if 8A does not start with an alpha character AND 9E = "USA"

"E" if 8A does not start with an alpha character AND 9E ≠ "USA"

9K Zip Code - Place of

Performance placeOfPerformanceZipCode Supplier Postal Code OR

User's Registration Postal Code if Supplier

Postal Code is null OR

"00000" if Supplier and User Registration

Postal Codes are null

10A Extent Competed extentCompeted "F" if the supplier order total is less than or equal to $150,000

"G" if the supplier order total is greater than $150,000

10C Other than Full/Open

Competition reasonNotCompeted "SP2" IF 10A is "G"

Leave blank IF 10A is "F"

10D Number of Offers Received numberOfOffersReceived "3"

23 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Element Name XML Tag Name DOD EMALL Data Mapping Special Conditions

10R Fair Opportunity/Limited

Sources statutoryExceptionToFairOpportunity "FAIR"

10U Local Area Set Aside localAreaSetAside "N"

12B Award Type contractActionType "C"

24 | P a g e F P D S | D O D E M A L L v 1 3 . 2 . 1

2.2 Unused or Null FPDS Data Elements

The following data elements defined by the FPDS Data Dictionary either contain "Null" values or are NOT included in the award documents (.xml) produced by DOD EMALL. These data elements either do not apply to GPC orders or are propagated by contract data in FPDS-NG.

Element # Element Name State

1B Modification Number Not sent

1D Transaction Number Not sent

1E Solicitation Number Null

1H Referenced IDV Agency Identifier Null

2E Indefinite Delivery Vehicle Date to Order Not sent

2F Date/Time Stamp Accepted Not sent

5A Web Site URL Not sent

5B Who Can Use Not sent

5C Maximum Order Limit Not sent

5D Fee for Use of Service Not sent

5E Fixed Fee Value Not sent

5F Fee Range Lower Value Not sent

5G Fee Range Upper Value Not sent

5H Ordering Procedure Not sent

5K Email Address Not sent

6C Multi Year Contract Null

6D Type of IDC Not sent

6E Multiple or Single Award IDV Not sent

6L Cost Accounting Standards Clause Not sent

6SA Treasury Account Symbol Agency Identifier Null

6SB Allocation Transfer Agency Identifier Null

6SD Beginning Period Of Availability Null

25 | P a g e F P D S | D O D E M A L L v 1 3 . 2 . 1

Element # Element Name State

6SE Ending Period Of Availability Null

6SF Availability Type Code Null

6SI Initiative Null

7A Clinger-Cohen Act Planning Compliance Not sent

7B Walsh Healey Act Not Sent

7C Service Contract Act Not Sent

7D Davis Bacon Act Not Sent

7F Other Statutory Authority Null

8G NAICS Null

8Q Domestic/Foreign Entity Null

9A DUNS Number Not sent

9C principalPlaceOfPerformance/locationCode Null

9D Principal Place of Performance Name Not sent

9G Congressional District Null

9J CCR Exception Not sent

10A Extent Competed Null

10C Other than Full/Open Competition Null

10H Commercial Item Acquisition Procedures Not sent

10J Commercial Item Test Program Not sent

10K Small Business Competitiveness Demonstration Program Not sent

10L A76 (Fair Act) Action Not sent

10M Solicitation Procedures Null

10N Type Set Aside Null

10P Evaluated Preference Null

10Q Research Null

10S FedBizOpps Not sent

26 | P a g e F P D S | D O D E M A L L v 1 3 . 2 . 1

11A Contracting Officer Determination of Business Size Not sent

11B Subcontracting Plan Not sent

11C Price Evaluation Adjustment/Preference Percent Difference Null

12A IDV Type Not sent

12C Reason for Modification Null

13I US Local Government Not sent

13IA City Local Government Not sent

13IB County Local Government Not sent

13IC Inter-Municipal Local Government Not sent

13ID Local Government Owned Not sent

13IE Municipality Local Government Not sent

13IF School District Local Government Not sent

13IG Township Local Government Not sent

13J US State Government Not sent

13K US Federal Government Not sent

13KA Federal Agency Not sent

13KB Federally Funded Research and Development Corp Not sent

13L US Tribal Government Not sent

13LA Foreign Government Not sent

13LB Community Developed Corporation Owned Firm Not sent

13LC Labor Surplus Area Firm Not sent

13LD Corporate Entity, Not Tax Exempt Not sent

13LE Corporate Entity, Tax Exempt Not sent

13LF Partnership or Limited Liability Partnership Not sent

13LG Sole Proprietorship Not sent

13LH Small Agricultural Cooperative Not sent

27 | P a g e F P D S | D O D E M A L L v 1 3 . 2 . 1

13LI International Organization Not sent

13LJ US Government Entity Not sent

13M Emerging Small Business Not sent

13N 8(a) Program Participant Not sent

13NA SBA Certified 8(a) Joint Venture Not sent

13NB DoT Certified Disadvantaged Business Enterprise Not sent

13NC Self Certified Small Disadvantaged Business Not sent

13O Historically Underutilized Business Zone (HUBZone) Firm Not sent

13P Small Disadvantaged Business Not sent

13Q The AbilityOne Program Not sent

13R Historically Black College or University Not sent

13RA 1862 Land Grant College Not sent

13RB 1890 Land Grant College Not sent

13RC 1994 Land Grant College Not sent

13S Minority Institution Not sent

13SA Private University or College Not sent

13SB School of Forestry Not sent

13SC State Controlled Institution of Higher Learning Not sent

13SD Tribal College Not sent

13SE Veterinary College Not sent

13T Educational Institution Not sent

13SF Alaskan Native Servicing Institution Not sent

13TB Community Development Corporation Not sent

13SG Native Hawaiian Servicing Institution Not sent

13TD Domestic Shelter Not sent

13TE Manufacturer of Goods Not sent

28 | P a g e F P D S | D O D E M A L L v 1 3 . 2 . 1

13VV Hospital Flag Not sent

13TH Veterinary Hospital Not sent

13TI Hispanic Servicing Institution Not sent

13TJ Foundation Not sent

13U Woman Owned Business Not sent

13UA Minority Owned Business Not sent

13UB Women Owned Small Business Not sent

13UC Economically Disadvantaged Women Owned Small Business Not sent

13UD Joint Venture Women Owned Small Business Not sent

13UE Joint Venture Economically Disadvantaged Women Owned Small Business Not sent

13V Veteran Owned Business Not sent

13W Service Disabled Veteran Owned Business Not sent

13X Contracts Not sent

13XA Grants Not sent

13XB Receives Contracts and Grants Not sent

13XC Airport Authority Not sent

13XD Council of Governments Not sent

13XE Housing Authorities Public/Tribal Not sent

13XF Interstate Entity Not sent

13XG Planning Commission Not sent

13XH Port Authority Not sent

13XI Transit Authority Not sent

13XJ Subchapter S Corporation Not sent

13XK Limited Liability Corporation Not sent

13XL Foreign Owned and Located Not sent

13Y American Indian Owned Business Not sent

29 | P a g e F P D S | D O D E M A L L v 1 3 . 2 . 1

13YA Alaskan Native Owned Corporation or Firm Not sent

13YB Indian Tribe (Federally Recognized) Not sent

13YC Native Hawaiian Owned Organization or Firm Not sent

13YD Tribally Owned Firm Not sent

13Z Asian-Pacific American Owned Business Not sent

13AA Black American Owned Business Not sent

13BB Hispanic American Owned Business Not sent

13CC Native American Owned Business Not sent

13DD Subcontinent Asian (Asian-Indian) American Owned Business Not sent

13DE Other Minority Owned Business Not sent

13EA For Profit Organization Not sent

13EE Nonprofit Organization Not sent

13EF Other Not for Profit Organization Not sent

13GG Vendor Name Not sent

13HH Vendor Doing As Business Name Not sent

13JJ Vendor Address Line 1 Not sent

13KK Vendor Address Line 2 Not sent

13LL Vendor Address Line 3 Not sent

13MM Vendor Address City Not sent

13NN Vendor Address State Not sent

13PP Vendor Zip Code Not sent

13QQ Vendor Country Code Not sent

13RR Vendor Phone Number Not sent

13SS Vendor Fax Number Not sent

30 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

3 Appendix: Award XML Example

31 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

Example: Award.xml (cont . . .)

32 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

33 | P a g e F P D S | D O D E M A L L v 1 4 . 4 . 1

1 Overview – Federal Procurement Data System
1.1 Requirements for FPDS Reporting
1.2 FPDS Data Elements: Auto-Population
1.3 Award Transmission to DLA Transactio
1.4 Completing FPDS Information in Check
1.5 FPDS Console
1.6 FPDS Award XML Page
2.1 Award Mappings for DOD EMALL
2.2 Unused or Null FPDS Data Elements

File details come from the government source that posted it. Updated .