Support/Subcontract Management Information Summary Report

File Name: mngerps2

Description: This report provides a statistical summary report of all open support/subcontracts by Service. Although columns are present on the report for obligated and unliquidated dollars, they normally should be blank as support/subcontracts have no money associated with them. Dollar entries in these fields indicate a problem that needs to be researched. Users can further tailor the query data by size of business, ACO, Buying Activity, CAGE or Part.

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.

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 C

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

N/A

Total number of procurement instruments.

Support

N/A

Support Contract - Number of support delegation contracts an organization has for administration.

Sub Contracts

N/A

Number of subcontracts an organization has for administration.

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.

Grand Totals

N/A

Total of individual totals combined.

Selected Criteria

N/A

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

Qty Open Contracts on Hand $0-$5,000

N/A

The number of open contracts (Section < 5) where the Obligated Contract Amount is between $0-$5,000.

Qty Open Contracts on Hand $5,001-$100K

N/A

The number of open contracts (Section < 5) where the Obligated Contract Amount is between $5,001-$100K

Qty Open Contracts on Hand $100,001-$1M

N/A

The number of open contracts (Section < 5 ) where the Obligated Contract Amount is between $100,001-$1M

Qty Open Contracts on Hand $1,000,000-$10M

N/A

The number of open contracts (Section < 5 ) where the Obligated Contract Amount is between $1,000,000-$10M

Qty Open Contracts on Hand $10,000,001 & over

N/A

The number of open contracts (Section <5) where the Obligated Contract Amount is $10,000,001 and over.

 

Report Sample:

Support/Subcontracts Management Information Summary Report

SIZE OF BUSINESS: 'All'
ORG:
'All'
ACO:   CAGE:   BUYING ACTIVITY:   PART:
Date: 1999-08-13
Department Name Contracts Support Subcontract Contract Obligation Contract Unliquidated
AIR FORCE 5 4 1 $0.00 $0.00
DLA 2 1 1 $0.00 $0.00
MDA 32 0 32 $0.00 $0.00
NASA 7 0 7 $0.00 $0.00
NAVY 6 3 3 $2,796.14 $2,796.14
OTHER 50 39 11 $0.00 $0.00
Grand Totals: 102 47 55 $2,796.14 $2,796.14
Qty Open Contracts on Hand:

$0-$5,000: 102
$5,001-$100K: 0
$100,001-$1M: 0
$1,000,001-$10M: 0
$10,000,001 & over: 0
 

6 rows returned.

Elapsed time: .5 seconds.

SELECT dept_name, assignment_cd, obligated_amount, unliq_con_amount FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND assignment_cd in ('S', 'T') AND current_sts < '5' AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND car_partno like '%' ORDER BY dept_name, assignment_cd

 

Back to Contract Administration Menu


HOME | QUERY MENU | USERS GUIDE | ABOUT