Detailed Contract Delinquency Report

File Name: dtl_dlq

Description: This report provides a listing of all contracts in Section 1, Production Surveillance 1 & 2, with corresponding line items and schedules considered delinquent. Satisfied or estimated schedules, or contracts with R8 Production Complete Remark are excluded from this report. The data shown is the cage code, contractor name, ACO, IS/CMA Code (Industrial Specialist/Contract Management Assistant/Engineer/Quality Assurance individual assigned the contract), contract number, line item, quantity on order, scheduled quantity, scheduled quantity shipped, current delivery schedule date, production surveillance code, weapons code and the number of days delinquent. The primary selection is the Delinquency Date, then Org. The report is in Cage sequence. Users can further tailor the query by selecting Cage, ACO, Buying Activity (2 digit) and IS/CMA code.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

DELINQUENCY DATE

Required

Date

The date on which performance under a contract schedule comes overdue.

ORG

Required

Picklist

The CAOs 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.

BUYING ACTIVITY (2 Pos)

Optional

Text

The 2 position Buying Activity code of the office issuing the contract.

IS/CMA CODE

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

ORG

org cd

The CAOs organization code.

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.

ACO

aco code

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

IS/CMA Code

indus spclst cd

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

FDD

kr resp fdd

The contract final delivery date.

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

CLIN

clin elin

The Contract Line Item Number identifies each supply or service recorded in the database. The number will appear once for each separate item, even if multiple schedules apply.

CLIN Order Qty

N/A

Order quantity for a given line item.

Sched Qty

dlvy sched qty

Quantity of product or services that has a firm or estimated (E) schedule.

Sched Qty Shpd

qty shpd ft

Schedule Quantity Shipped - The total quantity shipped against the schedule.

Ship Qty

qty shipped

The number of items which have been shipped which apply to the schedule

Dlvy Sched Dt

dlvy sched dt

Delivery Schedule Date - The Contractual Date for delivery. When the date is estimated, it will be followed by an E.

Prod Surv

prod surv cd

Production Surveillance Code assigned for the level of surveillance.

# Days Delq

N/A

The number of days the schedule is delinquent.

 

Report Sample:

Detailed Contract Delinquency Report

DELINQUENCY DATE: 1999-08-26
ORG:
'All'
ACO: XR3    CAGE:
BUYING ACTIVITY:     IS/CMA CODE: WI0
Date: 1999-08-26

ORG
IS/CMA
Code

CAGE

Contractor

ACO

FDD

PIIN

SPIIN
Prod
Surv
CLIN CLIN
Order Qty
Ship
Qty
Sched
Qty
Sched
Qty Shpd

Dlvy Sched Dt

# Days
Delq
SF WI0 017N4 ALLIEDSIGNAL INC XR3 1997-03-14 N00383 91 GM613 TY02 2 0001AA 30 0 30 0 1996-10-15 1,045
0001AB 30 0 30 0 1996-11-14 1,015
0001AC 30 0 30 0 1996-12-14 985
0001AD 30 0 30 0 1997-01-13 955
0001AE 30 0 30 0 1997-02-12 925
0001AF 4 0 4 0 1997-03-14 895
1998-12-28 N00383 96 G001D 5019 2 0001AA 6 0 6 0 1998-12-28 241
0001AB 8 0 8 0 1998-12-28 241
1999-03-19E N00383 96 G001D 5025 2 0001AA 61 0 61 0 1999-03-19 160
0001AB 18 0 18 0 1999-03-19 160
0001AC 9 0 9 0 1999-03-19 160
0001AD 26 0 26 0 1999-03-19 160
1998-12-12E F34601 96 D0354 0011 2 0001AB 10 0 10 0 1998-12-12 257
0019AB 6 0 6 0 1998-12-12 257
0020AB 4 3 4 3 1998-12-12 257

15 rows returned.

Elapsed time: 1.71 seconds.

SELECT t1.admin_by_cao, t1.isp_code, t3.prime_cage, t3.prime_name, t3.aco_code, t1.final_schedule_dt, t3.piin, t3.spiin, t1.prod_surv_cd, t3.line_item_id, t3.purchase_qty, t3.shipped_qty, t2.dlvy_sched_qty, t2.sched_qty_shipped, t2.dlvy_sched_dt, t3.service_completion_dt, t2.line_item_id, t1.final_schedule_est_ind, t2.final_schedule_dt, t2.final_schedule_est_ind FROM schedules t2, line_items t3, contracts t1 WHERE NVL(t1.aco_code,'X') LIKE DECODE('XR3',NULL,'%','XR3%') AND t1.prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(t1.buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND NVL(t2.dlvy_sched_dt, t3.service_completion_dt) <= TO_DATE('1999-08-26','YYYY-MM-DD') AND NVL(t1.isp_code, 'X') LIKE DECODE('WI0',NULL,'%','WI0%') AND t1.pins_agmt_id = t3.pins_agmt_id AND t1.primary_flag = 'Y' AND t1.current_sts = '1' AND t1.prod_surv_cd < '3' AND (substr(t1.r8_rmks,'1','5')<> 'FPROD' OR t1.r8_rmks IS NULL) AND (t3.equal_item_ind <> '1' or t3.equal_item_ind IS NULL) AND NVL(t2.sched_qty_shipped,t3.shipped_qty) < NVL(t2.dlvy_sched_qty,'1') AND (t3.qty_variance_under IS NULL OR NVL(t2.dlvy_sched_qty,'1') > 0) AND (t3.qty_variance_under IS NULL OR t3.qty_variance_under < (NVL(t2.dlvy_sched_qty, '0') - NVL(t2.sched_qty_shipped,'0')) / DECODE(NVL(t2.dlvy_sched_qty, '0'),'0','1',t2.dlvy_sched_qty)) AND t3.pins_agmt_id = t2.pins_agmt_id(+) AND t3.line_item_id = t2.line_item_id(+) ORDER BY t1.admin_by_cao, t1.isp_code, t3.prime_cage, t3.prime_name, t3.aco_code, t3.td_piin, t1.final_schedule_dt, t3.line_item_id, t2.dlvy_sched_dt

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT