Primary Administration CAR Summary Report Section 2, Overage

File Name: carsump2

Description: This report provides a count of physically completed Prime contracts, by type, which were not closed within the time period allowed by FAR. The primary sort is Type of Contract. Users can further tailor the query data by ACO and 2 Position Buying Activity (found in DFAR Appendix G), Part and Cage.

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.

CAGE

Optional

Text

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

ACO

Optional

Text

Identifies the Administrative Contracting Officer assigned to the contract.

PART A OR B

Optional

Text

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

BUYING ACTIVITY (2 Pos)

Optional

Text

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

 

Report Fields:

Field Name

MOCAS Name

Description

Section

car sec no

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

Type

ty contr cd

The specific type of contract pricing provision.

Count

N/A

The count of contracts for the respective Size of Business.

Size of Business

ty contrr cd

A code that designates a company's relative size.

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 disbursement have been made.

Unliquidated Progress Payments

unlq dv pp

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

Report Totals

N/A

The count of contracts, totals for Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments for the report.

 

Report Sample:

Primary Administration CAR Summary Report

Section 2, Overaged


SIZE OF BUSINESS: 'All'
ORG:
'All'
ACO:   CAGE: 017N4   SECTION:    PART:
Date: 1999-08-13
Section Type Size of Business Count Contract Obligation Contract Unliquidated Unliquidated Progress Payments
2 COST-INCENTIVE C 26 $135,605,505.79 $1,186,012.72 $110,087.46
FF/P B 5 $84,738.00 $1,517.00 $0.00
C 159 $558,118,018.10 $1,737,822.73 -$1,536,323.80
OTHER B 8 $0.00 $0.00 $0.00
C 6 $32,166,901.95 $2,000.24 $0.00
Report Totals: 204 $725,975,163.84 $2,927,352.69 -$1,426,236.34

5 rows returned.

Elapsed time: .28 seconds.

SELECT current_sts, contract_type_name, size_of_business, count(*) num_con, SUM(obligated_amount) obligated_amount, SUM(unliq_con_amount) unliq_con_amount, SUM(unliq_pp_amount) unliq_pp_amount FROM contracts WHERE assignment_cd = 'P' AND current_sts = '2' AND overage_dt < sysdate AND NVL(car_partno,'X') LIKE DECODE('',NULL,'%','%') AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('017N4',NULL,'%',LPAD('017N4',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') GROUP BY contract_type_name, current_sts, size_of_business ORDER BY current_sts ASC

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT