Contractor Information Summary - Active Workload

File Name: sktrcnts

Description: This report provides a summary of performance for a particular contractor for active workload (Section 1 contracts). Totals are provided at Cage and CAO level. Users can tailor the report by Buying Activity, Department Code, and IS/CMA.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

CAGE

Required

Text

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

ORG

Required

Picklist

The CAO’s organization code.

BUYING ACTIVITY (2 POS)

Optional

Text

The 2-position code of the office issuing the contract.

DEPT CODE

Optional

Text

A code used for Service Agency designation.

IS

Optional

Text

A locally assigned code identifying a specific individual to whom the contract is assigned for surveillance.

 

Report Fields:

Field Name

MOCAS Name

Description

Cage

cage

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

Contractor Name

contr/payee name

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

Open Contrs

N/A

The number of active contracts applicable to a particular contractor.

Dlqt Cntrs Crnt Sch

N/A

The number of active contracts that are delinquent to the current deliverable schedule date.

Dlqt Cntrs Kr Rsp Sch

N/A

The number of active contracts that are delinquent to the original deliverable schedule date.

% Delqt Crnt Sch

N/A

Percent of contracts that are delinquent to current deliverable schedule date.

% Delqt Kr Rsp Sch

N/A

Percent of contracts that are delinquent to the original deliverable schedule date.

Open L/I

N/A

The count of active line items.

Dlqt L/I Crnt Sch

N/A

The total number of line items that are delinquent to the current deliverable schedule date.

Dlqts L/I Kr Rsp Sch

N/A

The total number of line items that are delinquent to the original schedule date.

Cage Totals

N/A

Totals for the individual fields.

Report Totals

N/A

Totals of the individual totals combined.

 

Report Sample:

Contractor Information Summary - Active Workload

CAGE: 017N4
ORG:
'All'
BUYING ACTIVITY: TZ   DEPT CODE:    IS CODE:
Date: 1999-08-04

CAGE

Contractor Name
  Open
Contrs
Dlqt Cntrs
Crnt Sch
Dlqt Cntrs
Kr Rsp Sch
% Delqt
Crnt Sch
% Delqt
Kr Rsp Sch
Open
L/I
Dlqt L/I
Crnt Sch
Dlqt L/I
Kr Rsp Sch
017N4 ALLIEDSIGNAL INC BILATERAL ORDERS 11 10 10 90.91% 90.91% 13 11 11
UNILATERAL ORDERS 4 3 3 75.00% 75.00% 4 3 3
Report Totals: 15 13 13 86.67% 86.67% 17 14 14

2 rows returned.

Elapsed time: 1.42 seconds.

SELECT prime_cage, prime_name, decode(unilateral_ind, 'U', 'UNILATERAL ORDERS', 'BILATERAL ORDERS'), row_type, sum(value) FROM active_workload_summary WHERE prime_cage = LPAD('017N4',6,' ') AND dept_cd like '%' AND NVL(isp_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(buying_activity_cd,'X') LIKE DECODE('TZ',NULL,'%','TZ%') GROUP BY prime_cage, prime_name, unilateral_ind, row_type ORDER BY prime_cage, prime_name, unilateral_ind DESC, row_type

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT