DMS/FI CONTRACT AWARDS [588]

HOME : Support : Dialog Search Aids : Bluesheets	Add RSS \| What is RSS?
View Bluesheets by \| Database Name \| File Number \| Subject \| OneSearch Categories \| Search Options \|

	588
DMS/FI Contract Awards
ONTAP^Ž DMS/FI Contract Awards (File 289)

Last Loaded on Web: Thursday, May 01, 2008

Last Update To Bluesheet: March 29, 2006

Bluesheet Contents PDF version

File Description	Database Content	DIALINDEX/OneSearch Categories	Basic Index	Rank	Rates
Subject Coverage	Document Types Indexed	Contact	Additional Indexes	Map
Tips	Geographic Coverage	Terms and Conditions	Limit	Report Options
Dialog File Data	Special Features	Sample Record	Sort	Predefined Format Options

File Description [top]

DMS/FI Contract Awards, produced by Forecast International/DMS, is a comprehensive file of all nonclassified U.S. government prime contract actions of $25,000 or more. Major civilian and military agencies covered are the Department of Defense, NASA, the Army, the Navy, the Air Force, the Department of Transportation, the Department of Energy, and the General Services Administration. Payments relating to all business activities of U.S. government agencies are included. These payments are used to analyze government expenditures on a comprehensive level. In addition to providing access to individual awards, the database also features a specialized REPORT option, CROSSTAB, that allows compilation and analysis of data for groups of awards or records.

The DMS/FI Contract Awards database is based on information purchased from the U.S. Federal Procurement Data Center (FPDC). Most government agencies are required by law to report contract payments to the FPDC. These data are processed to correct inconsistencies and add supplementary information. All information is obtained from open, unclassified sources.

Tips [top]

USE FILE 588

to find military contracts of $25,000 or more.

USE S CONTRACT(W)TYPE

to isolate contracts awarded to particular types of contractors:

S CONTRACT(W)TYPE AND SMALL(W)BUSINESS S CONTRACT(W)TYPE AND SMALL(W)DISADVANT?(W)BUSINESS S CONTRACT(W)TYPE AND SHELTERED(W)WORKSHOP S CONTRACT(W)TYPE AND LARGE(W)BUSINESS S CONTRACT(W)TYPE AND FOREIGN(W)CONTRACTOR

Subject Coverage [top]

Subject breakdown of the payments is based on the Federal Supply classification codes. Prior to FY 1989, Some supply classifications such as agriculture, social services, and subsistence items were not included. Each record contains:

Awarding agency
Company receiving the contract payment
Contract number
Contract payment amount
Date of the award
Federal Supply classification codes
Other identifying data
Place of performance
Terms of contract
Agency location
Product
Weapon
Service/Defense program involved
SIC Codes

Dialog File Data [top]

Dates Covered:	DoD: FY1981 to 2003; Non-DoD: FY1983 to 2003 (File 588) DoD: FY1981 to the present; Non-DoD: FY1983 to the present (File 289)
File Size:	7,666,308 records as of Q4 2003 (File 588) 188,000 records (File 289)
Update Frequency:	Closed (data produced for each quarter year by the U.S. government database updating dependent on government release date and Forecast International/DMS's processing time) from 50,000 to 100,000 records per update

Database Content [top]

Bibliographic Records

Document Types Indexed [top]

Government Documents

Geographic Coverage [top]

US Only

Geographic Restrictions [top]

None

Special Features [top]

ERA Available
REPORT Available
MAP Available
CROSSTAB REPORT Available

DialIndex/OneSearch Categories [top]

ACRONYM	CATEGORY NAME
GOVTPROC	Business Opportunities, Procurement, and Contracts

Contact [top]

DMS/FI Contract Awards is produced by Forecast International/DMS. Questions concerning file content should be directed to:

Forecast International/DMS
Customer Services/Data Group
22 Commerce Road
Newtown, CT 06470

Telephone:	203-426-0800 (Ask for Data Group)
Fax:	203-426-4262

Terms and Conditions [top]

ONTAP is a registered trademark of Thomson Reuters.

For Dialog's Redistribution and Archive Policy, enter HELP ERA online.

Database copyrighted by Forecast International/DMS. Data may only be distributed internally within user's organization unless authorized by Forecast International/DMS.

Dialog Standard Terms & Conditions apply.

SAMPLE RECORD [top]

	`DIALOG(R)File 588:DMS/FI Contract Awards`
	`(c) 1996 Forecast Intl/DMS Inc. All rts. reserv.`
	`2424266`
/CO,CO=	`Company: EATON CONSOLIDATED CONTROLS`
CY=,ST=	`BETHEL, CT`
CU=,CN=	`FAIRFIELD COUNTY USA`
DN=	`DUNS: 00-116-3708`

CA=,AR=	`Contract Payment Amount: $60,000 Range: 1`
ND=	`Contract Number: DAAJ0989C0781`
CD=,FY=,FQ=	`Contract Date: 890601 Fiscal Year: 89 Fiscal Quarter:`
	`89Q3`
TC=,FM=	`Contract Type: PRODUCTION Foreign Military Sale: NO`

/AG,AG=,SV=	`Agency: USA AVIATION SYSTEMS CMD Service: ARMY`
/AL,AL=	`Agency Location: ST. LOUIS, MO 09038`
PN=,PC=,/DE	`Product: SWITCHES (5930)`
WP=	`Weapon: CH-47 CHINOOK`

/AB	`PARENT CONSDLIDATED CONTROLS CORP; MOD NO 1473; COMPL 90/07; SIC`
	`3613; CLAIMENT (A1C) OTHER AIRCRAFT EQUIPMENT; PC 5930; CONT NO`
	`DAAJ0989C0781; ACTION New definitive contract; CONT TYPE FFP;`
	`Post-CICA; SOLIC PROC Unique source; CONTR TYPE Large business;`
	`PREF PROG No preference or not listed; CBDSYN A`

	`CROSSTAB REPORT`

	`REPORT NAME`
	`CROSSTAB for automatic calculation of totals for contract amounts`
	`or number of records.`

	`EXAMPLE`
	`REPORT S1/XTAB FOR CA ROW CO COL FY ROWTOTAL RANK 25 TITLE`

	`REPORT Sn/CROSSTAB FOR -- ROW -- COLUMN -- <options>`
	`(#) (##) (1) (2) (3)`
	`(#) Only non-SORTed sets should be used.`
	`The set may contain a maximum of 30,000 records.`
	`(##)CROSSTAB may be abbreviated XTAB.`
	`(1) CA is used to indicate that the contract amounts should be`
	`totaled.`
	`COUNTS is used to indicate that the number of records should`
	`be totaled.`
	`(2) The field code for the data to define the ROW(s) in the table`
	`(the left-most column in the table). One or two codes may be`
	`used; however, the RANK option may be used only with a single`
	`ROW code.`
	`ROWs will be sorted alphabetically unless RANK is used.`
	`(3) COLUMN (abbreviated COL). The field code for the data`
	`to define the remaining COLUMN(s) of the table. The standard`
	`width of the table is 80 characters, with a maximum of 4 col-`
	`umns. If appropriate, the width may be set to a maximum of 132`
	`characters, representing up to 8 columns.`
	`<options>:`
	`ROWTOTAL may be added to the command line to specify that totals`
	`should be included for each row.`
	`TITLE may be added to the command line to ask for a prompt for a`
	`report title of not more than 80 characters.`
	`RANK nnn or RANK ALL may be added to the command line to rank the`
	`row data in the far right column in descending order. If a`
	`number is specified, the remainder will be aggregated as`
	`"All other". May be used only with a single ROW field code.`
	`DELIM or FIXED may be added to the command line to indicate a`
	`particular post-processing format as the output.`
	`EXAMPLE:`
	`To create a report with an appropriate title, which calculates`
	`the contract amounts of the contracts awarded by NASA during 1986-`
	`1988 and which ranks top 25 recipients, the following report is`
	`retrieved:`
	`?SELECT SV=NASA AND FY=86:88`
	`39140 SV=NASA`
	`610770 FY=86 : FY=88`
	`S1 15983 SV=NASA AND FY=86:88`
	`?SET V 0`
	`Lines per Page set to 0`
	`?SET H 132`
	`CHARACTERS PER LINE SET TO 132`

	`?REPORT S1/XTAB FOR CA ROW CO COL FY ROWTOTAL RANK 25 TITLE`

	`Enter title of up to 80 characters`
	`TOP 25 NASA CONTRACTORS`

	`Processed 500 records`
	`Processed 1000 records (. . .)`

	`Processed 15500 records`
	`Align paper; press ENTER`

	`Top 25 NASA Contractors`

	`Contract Amount (000s)`
	`By Fiscal Year`

	`Company Name 86 87 88 Row Total`
	`================== =========== =========== =========== ==========`
	`ROCKWELL INTL 1,395,460 1,610,087 328,035 3,333,582`
	`CALIFORNIA INSTIT 893,641 1,007,758 229,268 2,130,667`
	`(. . .) _ RAYTHEON CO 33,087 32,382 6,563 72,032`
	`----------- ----------- -----------`
	`>>Ranktotal 6,328,899 5,786,735 1,289,223 13,348,341`

	`>>All Others 1,537,480 1,569,446 241,415 3,348,341`
	`=========== =========== =========== ==========`
	`>>Grandtotal 7,866,379 7,356,181 1,530,638 16,753,198`

	`Menu CROSSTAB: To be prompted for the command elements, simply enter`
	`REPORT Sn/XTAB.`

BASIC INDEX [top]

SEARCH SUFFIX	DISPLAY CODE	REPORT (FIELD LENGTH)	FIELD NAME	INDEXING	SELECT EXAMPLES
None	None	None	All Basic Index Fields	Word	S EATON
/AB	AB	None	Abstract	Word	S UNIQUE(W)SOURCE/AB
/AG	AG	AG (32)	Agency¹	Word	S AVIATION(W)SYSTEMS/AG
/AL	AL	AL (42)	Agency Location	Word	S ST(W)LOUIS/AL
/CO	CO	CO (37)	Company Name^1,2	Word	S EATON(W)CONSOL?/CO
/DE	DE	None	Description (Product Name, Weapon)	Word	S SWITCHES/DE

¹Searchable in the Basic Index and in the Additional Indexes.

²Records prior to FY1989 contain parent company in CO field; from FY1989 forward, CO field contains the actual contracting company, division, or subsidiary, with parent company name included in the Abstract (AB) field.

ADDITIONAL INDEXES [top]

SEARCH PREFIX	DISPLAY CODE	REPORT (FIELD LENGTH)	FIELD NAME	INDEXING	SELECT EXAMPLES
AG=	AG	AG (32)	Agency¹	Phrase	S AG=USA AVIATION SYS?
AL=	AL	AL (42)	Agency Location	Phrase	S AL=ST. LOUIS?
None	AN	AN (11)	DIALOG Accession Number
AR=	AR	None	Amount Range	Phrase	S AR=1
CA=	CA	CA (13)	Contract Amount³	Numeric	S CA=50,000:100,000
CD=	CD	CD (10)	Contract Date	Phrase	S CD=890601
CN=	CN	CN (17)	Country Name	Phrase	S CN=USA
CO=	CO	CO (37)	Company Name^1,2	Phrase	S CO=EATON CONSOL?
CU=	CU	CU (17)	County	Phrase	S CU=FAIRFIELD
CY=	CY	CY (22)	City	Phrase	S CY=BETHEL
DN=	DN	DN (11)	D-U-N-S Number	Phrase	S DM=00-116-3708
FM=	FM	FM (10)	Foreign Military Sales	Phrase	S FM=NO
FQ=	FQ	FQ (9)	Fiscal Quarter	Phrase	S FQ=1999Q3
FY=	FY	FY (7)	Fiscal Year	Phrase	S FY=1999
NO=	NO	NO (21)	Contract Number	Phrase	S NO=N00123-87-D-0364 S NO=DAAJ0989C0781
PC=	PC	PC (9)	Product Code (Federal Supply Classification Code)	Phrase	S PC=5930
PN=	PN	PN (36)	Product Name	Phrase	S PN=SWITCHES
None	SO	None	Source Information⁴
ST=	ST	ST (7)	State	Phrase	S ST=CT
SV=	SV	SV (18)	Service/Program	Phrase	S SV=ARMY
TC=	TC	TC (22)	Type of Contract	Phrase	S TC=PRODUCTION
UD=	None	None	Update⁵	Phrase	S UD=9999
WP=	WP	WP (30)	Weapon	Phrase	S WP=CH-47?
ZP=	ZP	ZP (7)	Zip Code⁶	Phrase	S ZP=93011

³A maximum of 10 digits is entered for the highest number in a range search (e.g., CA=10000000:9999999999).

⁴Includes Agency, Agency Location, Contract Date, and Contract Number.

⁵Not available in File 289.

⁶Available for records prior to FY1989 only.

LIMIT [top]

SUFFIX	FIELD NAME	EXAMPLES
Sets and terms may be limited by Basic Index suffixes, i.e., /AB, /AG, /AL, /CO, /DE (e.g., S S6/DE), as well as by the features listed below:
/	DIALOG Accession Number	S S1/1436399-9999999
/DEF	Defense Agencies	S S5/DEF
/FMS	Foreign Military Sale	S S7/FMS
/NONDEF	Non-Defense Agencies	S S3/NONDEF
/NONFMS	Non-Foreign Military Sale	S S3/NONFMS

SORT [top]

SORTABLE FIELDS	EXAMPLES
AG, AL, AR, CA, CD, CN, CO, CU, CY, DN, FQ, FY, NO, PC, PN, ST, SV, TC, WP, ZP	SORT S6/ALL/CA,D PRINT S3/5/1-24/CO

RANK [top]

RANK FIELDS	EXAMPLES
All phrase- and numeric-indexed fields in the Additional Indexes can be ranked.	RANK CO

MAP [top]

MAP FIELDS	EXAMPLES
DN	MAP DN TEMP S3/1-10

REPORT OPTIONS [top]


Output can be displayed in table format. REPORT codes with field lengths in parentheses are listed in the Search Options tables. Default table width is 72 characters; use SET H 132 to set maximum table width.	REPORT S1/CO,SA,SV/1-20

CROSSTAB REPORTS [top]


The CROSSTAB preformatted report provides the capability to build a report of contract amounts by agency and service with row and column totals. Select the product code or service branch and enter the CROSSTAB command.	REPORT S2/CROSSTAB

USER-DEFINED FORMAT OPTIONS [top]


Display codes listed in the Search Options tables can be used to customize output	TYPE S4/CO,SV/1-5

PREDEFINED FORMAT OPTIONS [top]

NO.	DIALOGWEB FORMAT	RECORD CONTENT
1	--	DIALOG Accession Number
2	--	Full Record except Abstract
3	Medium	Company Name, Contract Number, Amount and Date, Product Name and Code, and Agency
4	--	Abstract Only
5	Long	Full Record
6	--	Agency, Product Name and Code, and Weapon
7	--	Contract Number, Amount, Date and Type, Foreign Military Sale, and Abstract
8	Short	Company Name and Address
9	Full	Full Record

DIRECT RECORD ACCESS [top]

FIELD NAME	EXAMPLES
DIALOG Accession Number	TYPE 1570955/5 DISPLAY 0003975/AG,CO,SV PRINT

Rates [top]

Rates For File: ONTAP^Ž DMS/FI Contract Awards[289]
Cost per DialUnit:                 $0.00
Cost per minute:                   $0.00
Report Elements                    $0.00
LOB Reports                        $0.00
SHARE Reports                      $0.00
CROSSTAB Report Records            $0.00
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $0.00    $0.00
     3    $0.00    $0.00
     4    $0.00    $0.00
     5    $0.00    $0.00
     6    $0.00    $0.00
     7    $0.00    $0.00
     8    $0.00    $0.00
     9    $0.00    $0.00
KWIC95    $0.00       NA

REDIST/COPY Multiplier Table:
      Range      Multiplier
        1-2       1.00
       3-25       1.50
     26-100       3.00
    101-200       4.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

ARCHIVE Multiplier Table:

      Range      Multiplier
       1-25       1.50
     26-200       3.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

Rates For File: DMS/FI Contract Awards[588]
Cost per DialUnit:                 $5.25
Cost per minute:                   $0.73
Report Elements                    $0.05
LOB Reports                        $0.00
SHARE Reports                      $0.00
CROSSTAB Report Records            $0.05
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $0.94    $0.94
     3    $0.94    $0.94
     4    $0.94    $0.94
     5    $0.94    $0.94
     6    $0.28    $0.28
     7    $0.94    $0.94
     8    $0.28    $0.28
     9    $0.94    $0.94
KWIC95    $0.00       NA
KWIC96    $0.00       NA
REDIST/COPY Multiplier Table:

      Range      Multiplier
        1-2       1.00
       3-25       1.50
     26-100       3.00
    101-200       4.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

ARCHIVE Multiplier Table:

      Range      Multiplier
       1-25       1.50
     26-200       3.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00
------------

Note: The minimum charge for a CROSSTAB preformatted REPORT is $25.00.

[top]