Contract Kind Summary

File Name: kinddisp

Description: This report provides a listing of all prime (Assignment Code P) contracts in Sections 1-4 sorted by Contract Kind. The data shown is ORG code, CAGE, Contractor, PIIN, SPIIN, ACO, Buying Activity, Contract Obligation, and Contract Unliquidated. The primary selection is by ORG code, Section, and Dept Code.

The report is in Cage, Kind and PIIN/SPIIN sequence. Users can further tailor the query by Buying Activity, ACO, CAGE and Paying Office. This report is available as a summary report which list statistics as well as a detail report which provides individual contract information

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO organizational code.

SECTION

Required

Picklist

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

DEPT CODE

Required

Picklist

A code used for Service Agency designation.

BUYING ACTIVITY (2 Pos)

Required

Picklist

The 2-position code of the office issuing the contract.

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.

PAYING OFFICE

Optional

Text

The DoD Activity Address Code (DODAAC) of the payment office cited on the contract.

 

Report Fields:

Field Name

MOCAS Name

Description

Org

org cd

The CAO organizational code that was entered in the prompt field.

Section

car secno

The Contract Administration Report Section Number that was entered in the prompt field.

Dept Code

dept cd

The service agency designation that was entered in the prompt field.

ACO

aco cd

The Administrative Contracting Officer that was entered in the prompt field.

Cage

cage

The code assigned to an entity conducting business with the Government that was entered in the prompt field.

Kind

contract purpose

The kind of Contract Code reflects the basic intent of the contract, such as procurement of supplies, services, or research.

Contract Count

N/A

The total number of contracts.

Contract Obligation

obligated amount

The dollars that have been committed to a specific contract.

Contract Unliquidated

unliq dv cont

The total remaining dollar obligation on a contract after disbursements have been made.

Unliquidated Progress Payments

unliq dv pp

The total unrecouped progress payments made to the contractor or subcontractor.

Buying Activity

buyg act cd

The 2-position code of the office issuing the contract.

Report Totals

N/A

Total of individual totals combined.

 

Report Sample:

Contract Kind Summary

ORG:
'JF'
SECTION: '4'
DEPT CODE: 'F'
BUYING ACTIVITY:   ACO:   CAGE:   PAYING OFFICE:
Date: 1999-08-03
Kind Contract
Count
Contract
Obligation
Contract
Unliquidated
Unliquidated
Progress Payments
Buying Activity: Q7
2 - RESEARCH AND DEVELOPEMENT CONTRACTS 1 $2,035,068.63 $2,035.33 $0.00
6 - SERVICE CONTRACTS 1 $3,450,498.68 $50,000.01 $0.00
Buying Activity: SG
2 - RESEARCH AND DEVELOPEMENT CONTRACTS 2 $5,844,117.00 -$95,958.00 $0.00
6 - SERVICE CONTRACTS 1 $266,575.00 $100.48 $0.00
Report Totals: 5 $11,596,259.31 -$43,822.18 $0.00

4 rows returned.

Elapsed time: .29 seconds.

SELECT t1.contract_purpose, t1.buying_activity_cd, count (t1.td_piin), sum (t1.obligated_amount), sum (t1.unliq_con_amount), sum (t1.unliq_pp_amount), t2.table_in_the_clear_entry FROM contracts t1, tb0003 t2 WHERE t1.contract_purpose = t2.table_key(+) AND t1.assignment_cd = 'P' AND NVL(t1.paying_office,'X') LIKE DECODE('',NULL,'%','%') AND NVL(t1.aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(t1.buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND admin_by_cao in ('JF') AND current_sts in ('4') AND dept_cd in ('F') GROUP BY t1.buying_activity_cd, t1.contract_purpose, t2.table_in_the_clear_entry ORDER BY t1.buying_activity_cd, t1.contract_purpose, t2.table_in_the_clear_entry

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT