Support/Subcontracts Closed Management Information Summary Report

File Name: mngdrps4

Description: This report provides a statistical summary report of all support/subcontracts closed during a specified date range. 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. The report displays the information 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 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 Closed

N/A

The number of contracts closed during a specific time period.

Support

N/A

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

Subcontract

N/A

The number of subcontracts which have been delegated for administration (Assignment Code T).

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 con

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

Grand Totals

N/A

Total of individual totals combined.

 

Report Sample:

Support/Subcontracts Closed Management Information Summary Report

SIZE OF BUSINESS: 'All'
ORG: 'All'
BEGIN DATE: 1997-01-01  END DATE: 1999-08-02
ACO:   CAGE:   BUYING ACTIVITY:   PART:
Date: 1999-08-23
Department Name Contracts Closed Support Subcontract Contract Obligation Contract Unliquidated
AIR FORCE 64 0 64 $96,825,619.07 $17,611,218.11
ARMY 3 0 3 $1,877,604.62 $169,559.64
OTHER 3 3 0 $0.00 $0.00
Grand Totals: 70 3 67 $98,703,223.69 $17,780,777.75

3 rows returned.

Elapsed time: 1.17 seconds.

SELECT dept_name, td_piin, assignment_cd, obligated_amount, unliq_con_amount FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND (assignment_cd = 'T' OR assignment_cd = 'S') AND current_sts IN ('5','8','9') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND closed_dt >= TO_DATE('1997-01-01','YYYY-MM-DD') AND closed_dt <= TO_DATE('1999-08-02','YYYY-MM-DD')AND car_partno like '%' ORDER BY dept_name,assignment_cd

 

Back to Contract Administration Menu


HOME | QUERY MENU | USERS GUIDE | ABOUT