Prime Contracts by Contractor Size of Business

File Name: ksize

Description: This report provides a listing of all open prime contracts by the ORG Code and Size of Business specified by the user on the prompt screen. The primary sort is Cage, and then within Cage by PIIN-SPIIN. Users can further tailor the query data by ACO, Buying Activity, Section, Part, or any combination of these fields.

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.

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.

PART

Required

Picklist

Contract Administration Report (CAR) Part Number Codes assigned to the PIIN-SPIIN displayed.

ACO

Optional

Text

The code which identifies the Administrative Contracting Officer assigned to the contract.

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

Size of Business

ty contrr cd

The code entered in the prompt that distinguishes a company's relative size.

Part

car partno

The Contract Administration Report Part Number Code that was entered in the prompt.

Buying Activity

buyg acty cd

The Buying Activity code of the office issuing the contract that was entered in the prompt.

ORG

org cd

The CAO's organization code.

ACO

aco code

The code which identifies the Administrative Contracting Officer assigned to the contract.

CAGE

cage

Commercial and Government Entity. A code assigned by the Government to an entity conducting business with or within the Government.

Contractor

contr/payee name

The official name of the entity supplying goods and services to the Government.

PIIN

piin

The first 13 digits of the contract number.

SPIIN

spiin

A number used in conjunction with the basic PIIN to identify the contract. This number is referred to as the call/order, or delivery order, under a Blanket Purchase Agreement (BPA), Basic Ordering Agreement (BOA), or Indefinite Delivery-Type (IDT) contract.

Sec

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.

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.

Unliquidated Progress Payments

unlq dv pp

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

Totals

N/A

Total count of contracts and total amount of Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments for the report.

Report Sample:

Prime Contracts by Contractor Size of Business

ORG:
'All'
SIZE OF BUSINESS: 'All'
SECTION: 'All'
PART: 'B'
ACO: XS4   BUYING ACTIVITY:
Date: 1999-08-13
ORG ACO CAGE Contractor PIIN SPIIN Sec Contract Obligation Contract Unliquidated Unliquidated Progress Payments
SF XS4 017N4 ALLIEDSIGNAL INC SP0440 97 MZ212   2 $60,407.00 $0.00 $0.00
N00383 96 G001D 5006 1 $49,925.00 $49,925.00 $0.00
SP0440 97 MND39   1 $49,075.00 $49,075.00 $0.00
SP0440 97 MNF46   1 $63,250.00 $63,250.00 $0.00
F09603 96 M2254   1 $15,000.00 $15,000.00 $0.00
F09603 98 M0366   1 $22,295.00 $22,295.00 $0.00
SP0440 97 MNB77   1 $37,200.00 $37,200.00 $0.00
F34601 96 M0486   2 $21,000.00 $18,900.00 $0.00
F09603 97 M1191   1 $8,469.00 $8,469.00 $0.00
F09603 97 M1491   1 $4,039.00 $4,039.00 $0.00
Totals: 10 $330,660.00 $268,153.00 $0.00

10 rows returned.

Elapsed time: .35 seconds.

SELECT DISTINCT piin, unliq_pp_amount, unliq_con_amount, obligated_amount, current_sts, spiin, prime_name, prime_cage, aco_code, admin_by_cao, td_piin FROM contracts WHERE current_sts < '5' AND assignment_cd = 'P' AND NVL(aco_code,'X') LIKE DECODE('XS4',NULL,'%','XS4%') AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND car_partno IN ('B') ORDER BY admin_by_cao, aco_code, prime_cage, td_piin, current_sts, obligated_amount, unliq_con_amount, unliq_pp_amount

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT