Prime Contracts Received Management Information Summary Report

File Name: mngdrpr2

Description: This report provides a statistical summary report of all prime contracts received during a user specified date range and the obligated and unliquidated dollars associated with these contracts. The data is grouped by Service. Users can further tailor the query data by size of business, ACO, Buying Activity, CAGE, or PART.

Note: Contracts are only retained in SDW for 7 months after they are closed.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

SIZE OF BUSINESS

Required

Picklist

A code that distinguishes a company’s relative size.

ORG

Required

Picklist

The CAO’s organization code.

BEGIN DATE

Required

Interval

The begin date to be selected.

END DATE

Required

Interval

The end date to be selected.

ACO

Optional

Text

The code which identifies the Administrative Contracting Officer assigned to the contract.

CAGE

Optional

Text

A unique code assigned by the Government to an entity conducting business with or within the Government.

BUYING ACTIVITY (2 Pos)

Optional

Text

The 2 position Buying Activity code of the office issuing the contract.

PART A OR B

Optional

Text

Contract Administration Report Part Codes assigned to the PIIN-SPIIN displayed.

 

Report Fields:

Field Name

MOCAS Name

Description

Department Name

dept name

A name identifying a Service Agency.

Contracts Received

N/A

The number of contracts received during a specific time period.

Contract Obligation

obligated amount

The dollar amount stated at a contract or call/order level, by appropriation, that a Government agency will eventually disburse.

Contract Unliquidated

unlq dv cont

The total remaining dollar obligation on a contract, call/order after disbursements have been made.

Beginning Date

N/A

The beginning date range input by the user in the prompt field.

Ending Date

N/A

The ending date range input by the user.

Selected Criteria

N/A

The query criteria as determined by the data entered into the prompt fields by the user.

FFP Contracts Rec’d ($0 - $100,000)

N/A

Firm Fixed Price Contracts Received with a dollar value less than or equal to $100,000

 

FFP Contracts Rec’d ($100,000 and higher)

N/A

Firm Fixed Price Contracts Received with a dollar value greater than or equal to $100,000

Other Contracts Rec’d ($0 - $100,000)

N/A

Contracts Received with a dollar value less than or equal to $100,000 which are other than fixed price.

Other Contracts Rec’d ($100,000 and higher)

N/A

Firm Fixed Price Contracts Received with a dollar value of $100,000 and higher which are other than fixed price.

 

Report Sample:

Prime Contracts Received Management Information Summary Report

SIZE OF BUSINESS: 'All'
ORG:
'All'
BEGIN DATE: 1998-01-01  END DATE: 1999-08-13
ACO:   CAGE:   BUYING ACTIVITY:   PART:
Date: 1999-08-13
Department Name Contracts Received Contract Obligation Contract Unliquidated
AIR FORCE 64 $42,990,916.85 $40,186,128.29
ARMY 60 $15,640,006.93 $15,513,308.59
DLA 616 $16,214,641.35 $15,489,538.82
DNA 24 $2,000.00 $2,000.00
MDA 2 $1,668.00 $1,668.00
NAVY 106 $18,224,363.25 $16,529,211.36
Grand Totals: 872 $93,073,596.38 $87,721,855.06

FFP Contracts Rec´d ($0-$100,000): 715
FFP Contracts Rec´d ($100,000 and higher): 86
Other Contracts Rec´d ($0-$100,000): 39
Other Contracts Rec´d ($100,000 and higher): 32
Grand Totals: 872
 

6 rows returned.

Elapsed time: 1.36 seconds.

SELECT decode(contract_type, 'J', 'Fixed Price', 'K', 'Fixed Price', 'Other') contract_type, obligated_amount FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND assignment_cd = 'P' AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND buying_activity_cd LIKE DECODE('',NULL,'%','%') AND received_dt >= TO_DATE('1998-01-01','YYYY-MM-DD') AND received_dt <= TO_DATE('1999-08-13','YYYY-MM-DD')AND car_partno like '%'

 

Back to Contract Administration Menu


HOME | QUERY MENU | USERS GUIDE | ABOUT