Contractor Demographic

File Name: contdemo

Description: This report provides statistical summary data (number of contracts, total obligated and unliquidated dollars) by State and CAGE within the Org selected. The data shown is State, City, Cage, Contractor Name, Contract Count, Total Contract Obligation, and Total Contract Unliquidated. Totals are shown at State level. The report is in State, City, and then CAGE sequence. Users can tailor their report by Section, Department Code, ACO Code, and Buying Activity.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

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.

DEPT CODE

Required

Picklist

A code used for Service Agency designation.

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

Section

car secno

The Contract Administration Report Section entered in the prompt field.

Dept Code

dept cd

The Service Agency designation code entered in the prompt field.

Buying Activity

buyg acty cd

The Buying Activity code entered in the prompt field.

Org

org cd

The CAO's organization code

ST

address line

Name of the state where contractor is located.

City

address line

Name of city where contractor is located.

Cage

cage

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

Contractor Name

contractor name

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

ACO

aco code

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

Contract Count

N/A

The count of contracts.

Total Contract Obligation

N/A

The total of the dollars that have been committed to a specific effort.

Total Contract Unliquidated

N/A

The total of the remaining dollar obligation on the contract.

Totals

N/A

The total amount of a value calculated in the report.

 

Report Sample:

Contractor Demographic

ORG:
'LP', 'NC'
SECTION: 'All'
DEPT CODE: 'All'
BUYING ACTIVITY:   ACO:
Date: 1999-08-25
ORG ST City CAGE Contractor Name ACO Contract
Count
Total Contract
Obligation
Total Contract
Unliquidated
LP TX ABILENE 6R600 LOCKHEED FORT WORTH CO A64 2 $307,738.00 $37,210.00
A67 1 $18,187.00 $.00
CAGE 6R600 Totals: $325,925.00 $37,210.00
FORT WORTH 81755 LOCKHEED MARTIN CORP A64 284 $16,134,695,861.37 $2,509,325,893.92
A65 61 $208,964,881.00 $5,948,059.41
A66 823 $24,512,041,213.57 $655,130,635.04
A67 1,365 $2,379,883,404.32 $285,139,310.73
A69 858 $32,755,899.86 $6,065,435.40
CAGE 81755 Totals: $43,268,341,260.12 $3,461,609,334.50
TX - TEXAS Totals: 2   3,394 $43,268,667,185.12 $3,461,646,544.50
NC NV LAS VEGAS 1GX03 LINMARR ASSOCIATES INC   1 $.00 $.00
NV - NEVADA Totals: 1   1 $.00 $.00

8 rows returned.

Elapsed time: 3.07 seconds.

SELECT t2.admin_by_cao, t1.state, t1.city, t1.cage, t1.contractor_name,t2.aco_code, count (t2.td_piin), sum (t2.obligated_amount), sum (t2.unliq_con_amount),t3.table_in_the_clear_entry FROM contractors t1, contracts t2, tb0221 t3 WHERE (t1.moc_id = t2.moc_id and t1.cage = t2.prime_cage) AND t1.state = t3.table_key(+) AND t2.assignment_cd = 'P' AND NVL(t2.aco_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(t2.buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND admin_by_cao in ('LP', 'NC') AND current_sts < '5' GROUP BY t2.admin_by_cao, t1.state, t1.city, t1.cage, t1.contractor_name, t2.aco_code, t3.table_in_the_clear_entry ORDER BY t2.admin_by_cao, t1.state, t1.city, t1.cage, t1.contractor_name, t2.aco_code, t3.table_in_the_clear_entry

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT