Contractor Information Detail - Active Workload

File Name: ktrcnts

Description: This report provides workload information for a given CAGE on contracts which are active and under production surveillance where production is not complete (No R8 Production Complete Remark). The data shown is Buying Activity, DoDAAC, PIIN, SPIIN, Production Surveillance Code, Bilateral or Unilateral Indicator, NSN, and a stratification of the number of delinquent line items by Age ranges. The report is sorted in PIIN-SPIIN sequence. Users can tailor the request by ORG, Buying Activity, Dept 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

Buying Activity

buyg acty cd

The 2 position code of the office issuing the contract.

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 referenced to as the call/order, or delivery order, under a Blanket Purchase Agreement (BPA), Basic Ordering Agreement (BOA), or Indefinite Delivery Type (IDT) contract.

Prod Surv

prod surv cd

Production Surveillance Code assigned for the level of surveillance

Bi/Uni

N/A

An indicator as to whether the contract/purchase order is a bilateral (B) or unilateral (U) document.

Nsn

nsn

National Stock Number

0-30

N/A

Number of items delinquent from 0 to 30 days.

31-60

N/A

Number of items delinquent from 31 to 60 days.

61-90

N/A

Number of items delinquent from 61 to 90 days.

OV - 90

N/A

Number of items delinquent over 90 days.

 

Report Sample:

Contractor Information Detail - Active Workload

CAGE: 017N4
ORG:
'All'
BUYING ACTIVITY: TZ  DEPT CODE:
IS:
Date: 1999-08-04
Buying
Activity
PIIN SPIIN Prod
Surv
Bi/
Uni
Nsn 0-30 31-60 61-90 OV-90
SC0500 DLA500 85 MME02   2 U 5315006850556 0 0 0 1
SC0500 N00383 88 GB403 TZ05 2            
SC0500 SP0500 95 MD215   2 U 5340011785919 0 0 0 1
SC0500 N00383 96 G001D TZ07 2   5355005227181 0 0 0 1
SC0500 N00383 96 G001D TZ16 2   5355005365020 0 0 0 2
SC0500 N00383 96 G001D TZ18 2   3110005543820 0 0 0 1
SC0500 N00383 96 G001D TZ21 2   5365008846578 0 0 0 1
SC0500 N00383 96 G001D TZ23 2   5355005227180 0 0 0 1
SC0500 N00383 96 G001D TZ25 2   5365009286043 0 0 0 1
SC0500 N00383 96 G001D TZ26 2   5355000745281 0 0 0 1
SC0500 SP0500 95 MDG54   2 U 5365013715993 0 0 0 1
SC0500 SP0500 94 MGN72   2 U 5340012843226 0 0 0 1
SP0500 N00383 96 G001D TZ20 2   5355005227180 0 0 0 1
SP0500 N00383 96 G001D TZ22 2   5355005365020 0 0 0 1
SP0500 N00383 96 G001D TZ24 2   5305003678494 0 0 0 1

15 rows returned.

Elapsed time: 8.63 seconds.

SELECT t1.issued_by, t1.piin, t1.spiin, t1.prod_surv_cd, t1.unilateral_ind, t2.nsn, t2.days_30, t2.days_60, t2.days_90, t2.over_90 FROM contracts t1, active_workload_detail t2 WHERE t1.current_sts = '1' AND t1.pins_agmt_id = t2.pins_agmt_id(+) and t1.primary_flag = 'Y' AND t1.prime_cage LIKE DECODE('017N4', NULL, '%',LPAD('017N4',6,' ')) AND dept_cd like '%' AND NVL(isp_code,'X') LIKE DECODE('',NULL,'%','%') AND t1.prod_surv_cd in ('1','2','3','6') AND NVL(substr(t1.r8_rmks,2,19),'X') <> ('PRODUCTION COMPLETE') AND NVL(t1.buying_activity_cd,'X') LIKE DECODE('TZ',NULL,'%','TZ%') ORDER BY t1.issued_by,t1.td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT