Primary Administration CAR Summary Report

File Name: carsump1

Description: This report provides a statistical summary of all open Prime contracts by Section and Type. The primary sort is by Section and Type. Users can further tailor the query data by ACO, Part A or B, Buying Activity, or any combination of these prompts.

At the end of each section, there should be section totals reflected for the following data fields: Count, Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments.

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

The code which 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.

Size of Business

ty contrr cd

A code that designates a company's relative size.

Count

N/A

The count of contract for the respective Size of Business.

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

Unliquidated Progress Payments

unlq dv pp

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

Section Totals

N/A

The count of contracts, totals for Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments for the respective Section indicated.

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


SIZE OF BUSINESS: 'B','C'
ORG:
'JF'
ACO:    CAGE:   BUYING ACTIVITY:   PART:
Date: 1999-08-13
Section Type Size of Business Count Contract Obligation Contract Unliquidated Unliquidated Progress Payments
1 COST-INCENTIVE B 53 $29,054,931.73 $2,327,666.89 $0.00
C 61 $118,944,153.62 $14,166,454.66 $0.00
FF/P B 457 $45,755,749.26 $44,699,785.71 -$2,295,000.00
C 287 $93,599,711.71 $5,480,609.98 -$856,486.79
OTHER B 26 $2,287,641.52 $87,636.22 $0.00
C 11 $10,859,510.00 $10,859,510.00 -$8,666,450.00
Section Totals: 895 $300,501,697.84 $77,621,663.46 -$11,817,936.79
2 COST-INCENTIVE B 1 $2,799,541.00 $23,154.37 $0.00
C 36 $85,249,737.17 $2,697,851.93 -$1,000.00
F/P ESCALATION B 2 $10,130.85 $0.00 $0.00
FF/P B 45 $55,068.47 $171.13 $0.00
C 18 $52,746.58 $40,090.00 $0.00
Section Totals: 102 $88,167,224.07 $2,761,267.43 -$1,000.00
4 COST-INCENTIVE C 4 $8,145,760.63 -$93,822.19 $0.00
FF/P B 5 $83,505.78 $2,043.33 $0.00
C 2 $2,466.30 $1,533.17 $0.00
Section Totals: 11 $8,231,732.71 -$90,245.69 $0.00
Report Totals: 1,008 $396,900,654.62 $80,292,685.20 -$11,818,936.79

14 rows returned.

Elapsed time: .6 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 <= '5' AND admin_by_cao in ('JF') AND NVL(car_partno,'X') LIKE DECODE('',NULL,'%','%') AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND NVL(size_of_business,' ') in ('B','C') 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