Support/Subcontract Administration CAR Summary

File Name: carsumsa

Description: This report provides a listing of all support and subcontract totals by delegated function. The primary sort is Part, and then within Part by Section, Assignment Code, and delegated function. Users can further tailor the query data by CAGE, ACO, Buying Activity, Part, or any combination of these prompts.

This report provides Subtotals and Grand Totals.

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 C

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

Part

car partno

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

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.

Asgn Code

asgnm cd

The code that depicts the level of administration.

Type Assignment

ty contr cd

Defines the kind of effort being issued or requested.

Functional Limitation

func lmtn

The functional limitation name or ‘Multiple Functions’.

Count

N/A

The count of contracts for the respective Functional Limitation.

Part Totals

N/A

The count of contracts for the respective Part.

Report Totals

N/A

The count of contracts for the report.

 

Report Sample:

Support/Subcontract Administration CAR Summary


SIZE OF BUSINESS: 'All'
ORG:
'All'
ACO:    CAGE: 017N4   SECTION:    PART:
Date: 1999-08-13
Part Section Asgn Code Type Assignment Functional Limitation Count
A 1 S Support 6: ACO Only 1
T Subcontract 1: Quality Only 4
Part Totals: 5
C 1 S Support 2: Production Only 2
4: Property Only 10
T Subcontract 1: Quality Only 19
2: Production Only 3
4: Property Only 18
Part Totals: 52
Report Totals: 57

7 rows returned.

Elapsed time: .43 seconds.

SELECT car_partno, current_sts, assignment_cd, funcdesc(functional_limits,piin), count(distinct piin) num_con FROM contracts WHERE assignment_cd in ('S','T') AND current_sts in ('1','5')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 car_partno, current_sts, assignment_cd,funcdesc(functional_limits,piin)

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT