Prime Contract Workload by Zip Code

File Name: primez

Description: This report provides a listing of all contractors and contract totals within a specific ORG code and Business Size selected by the user on the prompt screen. The primary sort is ORG Code, Zip Code, and Cage Code. Users can further tailor the query data by ACO, Buying Activity, and Section, or any combination of these fields.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO’s organization code.

SIZE OF BUSINESS

Required

Picklist

A code that distinguishes a company’s relative size.

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.

SECTION

Optional

Text

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

 

Report Fields:

Field Name

MOCAS Name

Description

ORG

org cd

The CAO’s organization code.

Zip Code

address line

The zip code of the contractor’s facility.

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.

Number of Contracts

N/A

Total number of procurement instruments.

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.

Zip Code Totals

N/A

Total number of contracts and associated dollar values for each Zip Code.

Grand Totals

N/A

Total number of contracts and associated dollar values for the report.

 

Report Sample:

Prime Contract Workload by Zip Code


SIZE OF BUSINESS: 'L','M','U'
ORG:
'All'
SECTION: 'All'
ACO:    BUYING ACTIVITY:
Date: 1999-08-13
ORG Zip Code ACO CAGE Contractor Number of
Contracts
Contract Obligation Contract Unliquidated Unliquidated Progress
Payments
JF 45401 J5B 8R659 CARVER SUPPLY INC 2 $0.00 $0.00 $0.00
JN1 07232 ELECTRO-LINE INC 1 $0.00 $0.00 $0.00
          Zip Code Totals: 3 $0.00 $0.00 $0.00
JF 45431-2301 JK1 60668 K ELECTRONICS INC 1 $483.00 $16.10 $0.00
          Zip Code Totals: 1 $483.00 $16.10 $0.00
SE 07631 SAA 55070 LUCAS AEROSPACE INC 1 $0.00 $0.00 $0.00
          Zip Code Totals: 1 $0.00 $0.00 $0.00
WF 03299 XU6 93830 OSCAR'S ROACH MOTEL 1 $10,000.00 $10,000.00 $0.00
          Zip Code Totals: 1 $10,000.00 $10,000.00 $0.00
WF 32291 XU6 03928 COURTNEY'S PLACE 1 $0.00 $0.00 $0.00
          Zip Code Totals: 1 $0.00 $0.00 $0.00
WF 33333 XU6 0A789 RETEST INC. 1 $0.00 $0.00 $0.00
          Zip Code Totals: 1 $0.00 $0.00 $0.00
Grand Totals: 8 $10,483.00 $10,016.10 $0.00

7 rows returned.

Elapsed time: .37 seconds.

SELECT admin_by_cao, zip, aco_code, prime_cage, prime_name, 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 NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(buying_activity_cd, 'X') LIKE DECODE('',NULL,'%','%') AND NVL(size_of_business,' ') in ('L','M','U') GROUP BY admin_by_cao,zip,aco_code,prime_cage,prime_name

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT