Norm Analysis

File Name: norm

Description: This report provides a listing of all contracts which are still coded as active, and are Production Surveillance Code 1, 2, or 6 and are 30 days or more past the Final Delivery Date and contain an R8 Production Complete Remark; or, contracts which contain an Undefinitized Final Delivery Date and a R8 Production Complete remark; or, contracts which are Production Surveillance code 7, 8, or 9 are not Assignment Code G (Payment Only) and are 30 days or more past the Final Delivery Date.

The purpose of this report is to provide a tool for the CAO team to research contracts which the system shows as active but appear to be physically complete. The CAO team should take necessary action to closeout these contracts.

Users can further tailor the query by ACO or IS/CMA.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

NORM ANALYSIS DATE (YYYY-MM-DD)

Required

Interval

The date the norm analysis report uses as its lower boundary for data collection.

ORG

Required

Picklist

The CAO’s organization code.

PART

Required

Picklist

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

ACO

Optional

Text

The code which identifies the Administrative Contracting Officer assigned to 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

ACO

aco code

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

IS/CMA Code

indus splct cd

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

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.

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.

FDD

finl dlvy sched dt

The contract final delivery date.

Contract Unliquidated

unlq dv cont

The total remaining dollar obligation on a contract, call/order after disbursements have been made.

R8 Remarks

r8 rmk

Identifies Production Complete information.

 

Report Sample:

Norm Analysis

NORM ANALYSIS DATE: 1999-08-11
ORG:
'All'
PART: 'All'
ACO: JP1   IS/CMA CODE:
Date: 1999-08-11

ACO
IS/CMA
Code

CAGE

Contractor

PIIN

SPIIN

FDD

Contract Unliquidated

R8 Remarks
JP1 WFO 7A884 SAGER ELECTRICAL SUPPLY CO SP0905 97 M2611   1997-08-20 $0.00 FPRODUCTION COMPLETE CANCELED 98009
WFO SP0960 94 M0412   1994-03-29 $10.70 FPRODUCTION COMPLETE SEC0001Z 94089
WFO SP0450 96 MSL33   1997-03-15 $0.00 FPRODUCTION COMPLETE CANCELED 97058
WFO SP0450 96 ML938   1996-12-28 $0.00 FPRODUCTION COMPLETE CANCELED 97057
WFO SP0935 97 M0281   1997-05-05 $0.00 FPRODUCTION COMPLETE CANCELED 97190
TOTALS: 5 $10.70

5 rows returned.

Elapsed time: .32 seconds.

SELECT aco_code, isp_code, prime_cage, prime_name, piin, spiin, td_piin, final_schedule_dt, final_schedule_est_ind, unliq_con_amount, r8_rmks FROM contracts WHERE ((final_schedule_dt is NOT NULL AND current_sts = '1' AND (final_schedule_dt_30 <= TO_DATE('1999-08-11', 'YYYY-MM-DD')) AND r8_rmks like 'FPROD%' AND prod_surv_cd not in ('7','8','9') AND assignment_cd <> 'G') OR (final_schedule_dt is NOT NULL AND current_sts = '1' AND (final_schedule_dt_30 <= TO_DATE('1999-08-11', 'YYYY-MM-DD')) AND prod_surv_cd in ('7', '8', '9') AND assignment_cd <> 'G')) AND NVL(isp_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(aco_code,'X') LIKE DECODE('JP1',NULL,'%','JP1%') ORDER BY aco_code, prime_cage, td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT