Crosswalk of Reports
7
FPDS-NG
Crosswalk of Reports
Business Objectsto Informatica
Prepared by:
Global Computer Enterprises, Inc.
10780 Parkridge Blvd., Suite 300
Reston, VA20191
DRAFT
November 30, 2006
1
FPDS-NG – Crosswalk-Business object reports to Informatica Reports
Version History
Date / Version Number / Change Summary / Changed By03/16/2006 / 1.0 / Initial Version / Padma Parakala
03/26/2006 / 1.0 / General edits and revisions / Nancy Gunsauls
11/30/2007 / 1.1 / Completed the crosswalk between Informatica and Business objects / Deborah Blackwell
FPDS-NG – Crosswalk-Business object reports to Informatica Reports
Table of Contents
1Introduction
2List of Business objectS (BO) reports
3CROSSWALK FROM New informatica reports to existing business object reports
List of Tables
Table 1 - List of Business Objects Reports
Table 2 Informatica to Business Objects Report Mapping
1Introduction
FPDS-NG is pleased to announce that the conversion of standard report to Informatica is complete. Currently, FPDS-NG has both Business Objects (BO) reports and Informatica reports. Informatica is the reporting tool that will replace the Business Objects reporting tool starting from November 30, 2007.
The enhanced functionality of the Informatica reporting tool will reduce the number of reports required in FPDS-NG. The drill down functionality allows users to start with a government wide report, drill down to the Department, Agency, Region, Contracting office and more until the lowest detail level is reached. The additional capability of being able to drill down in multiple dimensions will further reduce the number of reports required.
2Scope
This document describes the crosswalk from Business objects (BO) reports and Informatica deployed on FPDS-NG.
3List of Business objectS (BO) reports
Table 1 lists the standard Business Objects reports in FPDS-NG.
Table 1 - List of Business Objects Reports
Business Object (BO) reports / Description ofBO Reports
- All Categories of Small Business Awards by Agency
- All Categories of Small Business Awards by Department
- Awards to HUBZone Small Business by Agency
- Awards to HUBZone Small Business by Department
- List Of Awards With Veteran Owned Contractors Report
- Awards to 8(a) Contractors by Agency
7. Awards to 8(a) Contractors by Department / This report displays the details of Awards and IDVs in the approved status and given to contractors that are classified as 8(a) contractors for the given Department and Date range (based on the Date Signed).
8. Awards Funded by Agencies / This report displays awards funded by the same or other agencies for a given Contracting Agency and Effective Date range.
9. Buy American Report / This report displays the awards under the different manufacturing categories by department for a given time frame (based on effective date).
10. Competition Summary Report by Agency - Action Dollars Over $25,000 / This report displays actions and total dollar amounts for different extent competed categories for a given agency and specified date range.
11. Competition Summary Report by Dept-Action Dollars over $25,000 / This report displays actions and total dollar amounts for different extent competed categories for a given department and a specified date range.
12. Competitive Procurement Activity Report by Agency / This report displays extent competed, solicitation procedures, type set asides, evaluated preferences, research types; statutory exceptions to fair opportunity and reason not competed types and their award types for a specified date range and Agency.
13. Competitive Procurement Activity Report by Department. / This report displays extent competed, solicitation procedures, type set asides, evaluated preferences, research types, statutory exceptions to fair opportunity and reason not competed types and their award types for a specified date range and Department
14. Summary Statistics for Entire State-Country
Bottom of Form
Top of Form / This report provides a wide range of summary data information for awards in an approved state as well as the total actions (number of records) and dollars for a selected state or country by date signed
14.Contract High Dollar Report by Agency / Report displays key information about Awards in an approved status for the selected Agency, Region, Contracting Office, and Date range (based on the Date Signed).
15. Contract High Dollar Report by Department / This report displays key information about Awards in an approved status for the selected Department and Date range (based on the Date Signed).
16. Contract Life Cycle Report by Number / This report lists all transactions for one contract number and is displayed by organization.
17. Register Report by Agency / This report lists information about Awards and IDVs in an approved status for the selected agency, region and contracting officewithin a specified date range. The detail information is sorted by vendor name.
18. Register Report by Department / This report lists information about Awards and IDV's in an approved status for the selected department within the specified date range. The detail information is sorted by vendor name.
19. Record Entry Summary Report by Agency / This report displays summary information about Awards and IDVs in an approved status for the selected agency, region and contracting officewithin specified date range.
20. Record Entry Summary Report by Department / This report displays summary information about Awards and IDVs in an approved status for the selected Departmentand date range. The report displays only actions that have Modification Number "0".
21. Purchase Card Report by Agency / This report displays the contract details based on the user's selection for "Purchase Card used as a Method of Payment" for a given Agency, Region and Contracting Office and date range. The date range is based on Effective Date
22. Purchase Card Report by Department
Top of Form / This report displays the contract details based on the user's selection for "Purchase Card used as a Method of Payment" for all agencies for a given Department and date range. The date range is based on Effective Date
23. Contracting Office Report by Agency / This report displays contracting offices for a given agency grouped by end date.
24. Contracting Office Report by Department / This report displays contracting offices for a given department grouped by agency and end date.
25. Vendor Socio-Economic Categories by Agency / This report displays the contract details for a given Agency, Region and Contracting Office and date range. The date range is based on Effective Date. Both Awards and IDVs are displayed. Only contracts where one or more of the vendor socio economic indicator is set to ‘Y’ are displayed. Total Actions and Total Dollars Obligated does not include contracts where all socio economic indicators are set to 'N'
26. Vendor Summary by State and Congressional District / This report displays the total actions and total dollars obligated for Vendors under the two groups of Socio Economic Categories, for a given Agency, Region, Contracting Office, State, Congressional District, and date range.
27. List Of Users Never Logged In / This Report displays the list of users who have never logged into the system. A blank field indicates that data hasn't been entered into the system.
28. List of Users by Agency / This Report displays the list of users who are in the system for the given Agency as active or inactive users
29. List of Users by Department / This Report displays the list of users who are in the system for the given Department as active or inactive users.
30. Last Login Date For Users / This Report displays the last login date for each user under the given agency. A blank login date indicates that the user has never logged into the system.
31. Draft-Error Status Report / This report displays the Draft Awards/IDVs, Error Awards/IDVs for a given Agency.
32. Quality Assurance Report – Non Sequential Modifications / This report displays all Awards with missing sequential modification numbers by Department, Agency, Contracting Office and date range.
33. Performance Statistics for Agencies / This report lists performance statistics for all agencies and sub-agencies in a department. "Actions" is the total of unique identifiers reported.
34. Performance Statistics for Contracting Office / This report lists performance statistics for all agencies and sub-agencies in a department. "Actions" is the total of unique identifiers reported.
35. Potential Duplicate Awards - Audit Report / This report displays all potential duplicate awards for the selected agency and date signed range using the following columns to calculate if there is a possible match:
-Agency ID
-Contracting Office Code
-Contracting Office Agency ID
-Date Signed
-Effective Date
-Dollars Obligated
-Current Contract Value
-Ultimate Contract Value
-Award Type
-DUNS Number
36. Performance Based Service Acquisition Report / This report displays the actions and dollars obligated for the performance based service acquisitions for a given date range. This report displays figures for the data before FY2005.
37. Performance Based Service Acquisition Report - FY2005 / This report displays the actions and dollars obligated for the performance based service acquisitions for a given date range. This report applies to date ranges for FY2005 and above
38. Performance Based Service Acquisition Report by Agency / This report displays the actions and dollars obligated for the performance based service acquisitions for a given Agency and date range. This report displays figures for the data before FY2005.
39. Performance Based Service Acquisition Report by Agency - FY2005 / This report displays the actions and dollars obligated for the performance based service acquisitions for a given Agency and date range. This report applies to date ranges for FY2005 and above.
40. Performance Based Service Acquisition Report by Department / This report displays the actions and dollars obligated for the performance based service acquisitions for a given Department and date range. This report displays figures for the data before FY2005.
41. Performance Based Service Acquisition Report by Department - FY2005 / This report displays the actions and dollars obligated for the performance based service acquisitions for a given Department and date range. This report applies to date ranges for FY2005 and above
42. NAICS Summary / This report displays the actions (number of records) and total dollars obligated by NAICS (North American Industry Classification System) Code.
43. NAICS by State-Country Report by Agency / This report displays the total actions and total dollars obligated for a given Agency, Region, and Contracting Office, Country, State, and NAICS.
44. NAICS by State-Country Report by Department / This report displays the total actions and total dollars obligated for a given Department, Agency, Country, State, and NAICS
45. Other Services and Construction-By Service Category / This Report Lists the Actions and Dollars for Other Services and Construction, for a given Department, Agency, Contracting Office and date range.
46. Product or Service Search by Department / This report displays Award and IDV details based on the Product or Service Codes (PSC Codes) for a given Department, PSC Code, and date range.
47. Product or Service Search by Agency / This report displays Award and IDV details based on the Product or Service Codes (PSC Codes) for a given Contracting Agency, Region, Contracting Office Code, PSC Code, and date range.
48. Products And Services Purchased In The State-Country / This report displays all of the products and services purchased in the selected state, ordered by the Dollars Obligated.
49. Top 25 NAICS by Agency / This report displays the actions and dollars obligated of awards in an approved status for the Top 25 NAICS Codes based on the Contracting Agency Code. This report also displays several categories of socio-economic data for a selected Agency, Region, Contracting Office, and date signed range. The data is displayed at the Agency, Region, and Contracting Office levels.
50. Top 25 NAICS by Department / This report displays the actions and dollars obligated of awards in an approved status for the Top 25 NAICS Codes based on the Department ID. This report also displays several categories of socio-economic data for a selected department within a specified date range.
51. Research and Development Report by Agency / This report displays the Actions and Dollars for various R & D categories (PSC Codes starting with A) for a given Agency, Region, Contracting Office, and Date range (based on the Date Signed).
52. Research and Development Report by Department / This report displays the Actions and Dollars for various R & D categories (PSC Codes starting with A) for a given Department and Date range (based on the Date Signed).
53. Supplies and Equipment / This report lists the actions and dollars for Supplies and Equipments, for a given Department, Agency, Contracting Office and date range.
54. List of Agencies Awarding Work in State-Country / This report lists all the agencies awarding work in the selected state for a given date range.
55. List Of Counties In The State Where Work Performed / This report displays the list of counties where work was performed for a given state and date range.
56. SF 279 - SF 281 Comparison / This report displays data exclusively for SF281 data, grouped by Department ID.
57. SCAR Report by Department / This report displays the SF279/SF281 comparison data for the specified Department and fiscal year, quarter range.
58. Socio-Economic Accomplishments by Agency / This report displays the various categories of small business awards in an approved status for a given Agency, Region, Contracting Office and date signed range.
59. Socio-Economic Accomplishments by Department / This report displays the various categories of small business awards in an approved status for a given department and date signed range.
60. Socio-Economic Accomplishments for National Interest Contracts / This report provides total actions and dollar amounts for the federal government departments for awards in final status for the selected "National Interest Action" name and date signed range for various socio economic categories.
61. Socio-Economic Categories by State-Country by Agency / This report displays the total actions and total dollars obligated for each socioeconomic indicator for a given Agency, Region, Contracting Office, Country and State.
62. Socio-Economic Categories by State-Country by Department / This report displays the total actions and total dollars obligated for each socioeconomic indicator for a given Department, Agency, Country, and State.
63. Type of Business by Agency / The report displays awards and IDVs in final status for the specified agency, region code, contracting office id and specified date range. The total actions and dollars obligated correspond to the following vendor socio economic categories and business size determination: Other Than Small Business Concerns, All Small Business Concerns, Small Disadvantaged Business Concerns, Historically Black Colleges or Universities, Minority Institutions, 8 (a) Concerns, Women Owned Business Concerns, HUBZone Concerns, Service Disabled Veterans Small Businesses Concerns, Veteran Owned Small Businesses Concerns, JWOD Non-profit Concerns. Small Business Set Asides: Awards with contractors that have Type of Set Aside selected as
-Small Business Set-Aside
-Small Business Set-Aside Partial
64. Type of Business by Department / The report displays awards and IDVs in final status for all agencies under the specified department and specified date range. The total actions and dollars obligated correspond to the vendor socio economic categories and business size determination mentioned in #33:
65. Contractor Report / This report displays the place of performance and dollars obligated information for a given Agency, Region and Contracting Office range.
66. Place of Performance Report / This report displays the vendor and Place of Performance Information for a given Agency, Region and Contracting Office.
Awards in the final status are displayed.
67. Federal Contract Actions and Dollars By Executive Department Report / This report displays the number of federal contract actions and sum of dollars obligated for a specified executive department and fiscal year quarter date range. Both SF279 and SF281 data are consolidated in this report.
68. Federal Procurement Report by Agency / This report provides a wide range of summary data information for awards in an approved state as well as the total actions (number of records) and dollars for all Contracting Offices in a selected Agency and selected date signed range.
69. Federal Procurement Report by Department / This report provides a wide range of summary data information for awards in an approved state as well as the total actions (number of records) and dollars by Department for the selected Department and date signed range.
70. FederalProcurementState Summary by Agency / This report displays the Federal Procurement State Summary Data for a given Agency within a specified date range.
71. FederalProcurementState Summary by Department / This report displays the Federal Procurement State Summary Data for a given Department within a specified date range.
72. National Interest Actions and Dollars / This report displays the actions and the dollar amount of awards and IDVs in an approved state for the selected date range for all Federal departments.
73. Contract Originator Report by Agency / This report displays the awards and IDVs created during the specified date range (based on the prepared date) by users who belong to the given agency.
74. Contract Originator Report by Department / This report displays the awards and IDVs created during the specified date range (based on the prepared date) by users who belong to the given department.
75. Small Business Goaling Report by Department (funding office) / This report displays the Goaling data for Small Businesses by Department. This report will also display the data at the Agency and Region levels
1