Processed DD Form 250s Summary

File Name: shippros

Description: This report provides statistical information relative to the number of DD 250s processed during the date range specified by the user. The data shown is Org, Acceptance Site, and Count of Processed DD 250s. Grand totals are provided for the report. Users should note that shipment data only resides in MOCAS for 14 days after the contract has been closed at which time all line items, schedules and shipments are purged from MOCAS and consequently SDW also. Therefore it is impossible to get a valid count for anything past 14 days past the day the query is run.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

BEGIN DATE

Required

Text

The begin date to be selected.

END DATE

Required

Text

The end date to be selected.

ORG

Required

Picklist

The CAO’s organization code.

 

Report Fields:

Field Name

MOCAS Name

Description

Org

 

The CAO’s organization code.

Accept Site

acpt site

An indicator as to where Government acceptance has/will occur. The code (S-Source, D-Destination) is taken from the processed DD 250 record.

Line item Count

N/A

The number of line items per acceptance site.

DD 250 count

N/A

The number of DD250s per acceptance site.

ORG Subtotals

N/A

The individual totals for each ORG.

Report Totals

N/A

Total number of DD250s for the report

 

Report Sample:

Processed DD Form 250s Summary

BEGIN DATE: 1998-01-01   END DATE: 1999-08-13
ORG:
'JF', 'SE'
Date: 1999-08-13

ORG
Accept
Site
Line Item
Count
DD 250
Count
JF A 1 1
JF D 12 8
JF S 144 142
ORG Totals: 157 151
SE A 3 2
SE D 9 8
SE S 212 191
ORG Totals: 224 201
REPORT TOTALS:
A 4 3
D 21 16
S 356 333
Total 381 352

381 rows returned.

Elapsed time: 1.5 seconds.

SELECT admin_by_cao, piin||spiin||ship_no,piin||spiin||ship_no||line_item_id, acceptance_site FROM shipments WHERE chain_cd = 'P' AND ship_no <> 'FIRSTART' AND (proc_dt >= TO_DATE('1998-01-01','YYYY-MM-DD') AND proc_dt <= TO_DATE('1999-08-13','YYYY-MM-DD')) AND admin_by_cao in ('JF', 'SE') ORDER BY admin_by_cao, acceptance_site,piin,spiin,ship_no,line_item_id

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT