Appendix_B_-_Data_Library_and_Sample_Report_Formats_v2.pdf

KITS REPORTS

DATA DICTIONARY

ID DEFINITION

1, 2, 3, 4, ETC

Unique ID number for every Kit Part ID sent to any post (database-generated auto-number)

KIT DEFINITION

EMUK, MCM-A, ETC IDENTIFIES THE NAME OF THE KIT

KIT SERIAL NUMBER DEFINITION

EMUK-# IDENTIFIES UNIQUE KIT SERIAL NUMBER ASSIGNED TO KIT

KIT PART ID DEFINITION

[KIT NAME]-####

example:

EMUK-0001

IDENTIFIES EACH LINE ITEM IN THE KIT WITH A UNIQUE ID #.

NOTE: Substitution items will share the same KIT PART ID

NOMENCLATURE DEFINITION

NARRATIVE DESCRIPTION OF ITEM

example:

DISPOSABLE SCALPELS, NO. 10

INDUSTRY/MANUFACTURER DESCRIPTION OF ITEM

SUBSTITUTION CODE DEFINITION

A PRIMARY ITEM

B

PRE-APPROVED AS A SUBSTITUTION ITEM AND MAY BE USED TO

SUBSTITUTE PRIMARY ITEM WITHOUT PERMISSION

C

MAY SUBSTITUTE WITH THIS ITEM WITHOUT PERMISSION ONLY IF

PRIMARY ITEM IS UNAVAILABLE, AND IN ORDER OF SUBSTITUTION

PRECEDENCE

D

MAY SUBSTITUTE WITH THIS ITEM ONLY WITH CONTRACTING OFFICER

APPROVAL, AND IN ORDER OF SUBSTITUTION PRECEDENCE

REPLACEMENT PRECEDENT DEFINITION

1, 2, 3, 4, ETC NUMBER DESCRIBING ORDER OF PRECEDENCE FOR SUBSTITUTION

SUBSYSTEM DEFINITION

[KIT NAME]-[SUBSYSTEM]

example:

EMUK-MEDICAL RUCK

AS APPLICABLE, PRESCRIBES A SPECIFIC SUB-COMPONENT WITHIN THE

KIT WHERE MULTIPLE KIT PART IDS MIGHT BE LOCATED

LOCATION DEFINITION

[KIT NAME]-[SUBSYSTEM]-[LOCATION]

example:

EMUK-MEDICAL RUCK-POCKET A

AS APPLICABLE, SUBSYSTEMS WITH MULTIPLE POCKETS,

COMPARTMENTS, ETC, SHOULD BE LABELED AND IDENTIFIED

MANUFACTURER DEFINITION

NAME OF MANUFACTURER OF PART

example:

NORTH AMERICAN RESCUE

NAME OF MANUFACTURER OF PART

MANUFACTURER ID # DEFINITION

MFG ID #

example

Pelican 0450 Mobile Tool Chest with Drawers

THE MFG-ASSIGNED IDENTIFICATION NUMBER OR CODE FOR THE PART

MANUFACTURER ID # DEFINITION

NSN #

example:

5140-01-584-4327

NATO STOCK # (IF AVAILABLE)

APPENDIX B: REPORTING FORMAT/GUIDELINES

NDC DEFINITION

NDC #

example

Transderm Scop

AS APPLICABLE, FDA NATIONAL DRUG CODE

LOT NUMBER DEFINITION

Medication Lot # example

Meridian Medical Antidote Treatment Nerve Agent Auto-Injector

MANUFACTURER ASSIGNED LOT NUMBER FOR MEDICATION

EXPIRATION DEFINITION

MM/DD/YYYY AS APPLICABLE, THE EXPIRATION DATE FOR MEDICATION

MANUFACTURER UNIT OF ISSUE DEFINITION

EA/BX/BT

GSA-DEFINED OR INDUSTRY STANDARD UNIT OF ISSUE CODE (EACH,

PACKAGE, BOX, BOTTLE, CARTON, ETC)

UNIT OF ISSUE QUANTITY, EACH DEFINITION

1,2,3,4,5, ETC

NUMBER OF INDIVIDUAL KIT PART END ITEMS ARE IN THE

MANUFACTURER-ISSUED UNIT OF ISSUE

KIT PART QUANTITY DEFINITION

1,2,3,4,5, ETC NUMBER OF KIT PART END ITEMS ARE IN THE PART ID

TOTAL COST DEFINITION

IDENTIFIES THE TOTAL COST OF THE INDIVIDUAL KIT PART ID AT THE

TIME IT WAS PURCHASED, TO INCLUDE COSTS ASSOCIATED WITH

ASSEMBLING

SHIPMENT ID NUMBER DEFINITION

# UNIQUE NUMERICAL ID NUMBER ASSIGNED TO EACH SHIPMENT

PART ID STATUS DEFINITION

ACTIVE

THE ITEM IS CURRENTLY PART OF THE KIT AND HAS NOT BEEN

REPLENISHED

HISTORICAL

THE ITEM HAS BEEN REPLENISHED AND/OR REPLACED SINCE INITIAL

FIELDING

4-FAH-1 ACTIVITY CODE DEFINITION

POST ACTIVITY CODE AS DESCRIBED IN 4-FAH-1 H-430

ONWARD SHIPMENT ADDRESS DEFINITION

SELF-EXPLANATORY

AN ADDRESS AFFIXED TO THE EXTERIOR OF THE BOX OR CRATE

CONTAINING KITS THAT IDENTIFIES THE ONWARD SHIPMENT

DESTINATION FOR THE DELIVERY ORDER

SHIPPING METHOD DEFINITION

FEDEX, USPS, FREIGHT IDENTIFIES THE METHOD USED TO SHIP THE REFERENCED SHIPMENT

SHIPPING METHOD TRACKING # DEFINITION

ASSIGNED BY CARRIER CARRIER-ASSIGNED TRACKING NUMBER FOR REFERENCED SHIPMENT

SHIPPING COST OF SHIPMENT ID DEFINITION

IDENTIFIES THE SHIPPING COSTS ASSOCIATED WITH THE REFERENCED

SHIPMENT ID #

DATE SHIPPED DEFINITION

MM/DD/YYYY DATE OF INITIAL SHIPMENT

DATE ARRIVED DEFINITION

MM/DD/YYYY DATE REFERENCED SHIPMENT ARRIVED AT DESTINATION

TASK/DELIVERY ORDER NUMBER DEFINITION

SELF EXPLANATORY IDENTIFIES THE TASK/DELIVERY ORDER NUMBER - MUST BE UNIQUE

TASK/DELIVERY ORDER DATE DEFINITION

MM/DD/YYYY DATE ORDER PLACED

CONTRACTING OFFICER DEFINITION

LAST NAME, FIRST NAME

NAME OF CONTRACTING OFFICER WHO PLACED THE TASK/DELIVERY

ORDER

FUND CITE DEFINITION

STANDARD DOS FUND CITE FUND CITE ASSOCIATED WITH TASK/DELIVERY ORDER

DELIVERY TERMS DEFINITION

TEXT NARRATIVE TEXT DESCRIBING ANY DELIVERY TERMS

MATERIALS COST DEFINITION

$ COST OF MATERIALS DELIVERED UNDER THE TASK/DELIVERY ORDER

SHIPPING COST DEFINITION

COST OF ALL SHIPPING COSTS ASSOCIATED WITH A SPECIFIC

TASK/DELIVERY ORDER

TOTAL COST DEFINITION

COMBINED MATERIALS AND SHIPPING COSTS ASSOCIATED WITH A

SPECIFIC TASK/DELIVERY ORDER

STANDARD KIT PACKING LIST

see data dictionary for definitions of fields

ID KIT

KIT SERIAL

NUMBER

KIT PART ID

NUMBER

NOMENCLAT

URE

REPLACEMEN

T CODE

REPLACEMEN

T PRECEDENT

SUBSYSTEM LOCATION

MANUFACTU

RER

MANUFACTU

RER ID #

NSN NDC LOT NUMBER EXPIRATION

MANUFACTU

RER UNIT OF

ISSUE

UNIT OF

ISSUE

QUANTITY,

PART

INDIVIDUAL

QUANTITY

TOTAL COST

SHIPMENT ID

4-FAH-1

ACTIVITY

CODE

PART ID

STATUS

1 EMUK BAGS EMUK-1

EMUK BAGS -

MEDIC /

TRAUMA

SHEET BAG

(CCRK) –

COYOTE

A 1

EMUK BAG -

HANGING

BAG

N/A

NORTH

AMERICAN

RESCUE

ITEM # 80-0069

6515-01-540-

N/A N/A N/A EA 1 1 $

EMBASSY DR,

CITY,

COUNTRY,

CODE

###### ACTIVE

STANDARD SHIPMENT REPORT

SHIPMENT

ID #

4-FAH-1

ACTIVITY

CODE

ONWARD

SHIPPING

ADDRESS

SHIPPING

METHOD

SHIPPING

METHOD

TRACKING

SHIPPING

COST OF

SHIPMENT

ID

DATE

SHIPPED

DATE

ARRIVED

KIT

KIT SERIAL

NUMBER

KIT PART

ID NUMBER

NOMENCL

ATURE

REPLACEM

ENT CODE

REPLACEM

ENT

PRECEDEN

T

SUBSYSTE

M

LOCATION

MANUFACT

URER

MANUFACT

URER ID #

NSN NDC

LOT

NUMBER

EXPIRATIO

N

MANUFACT

URER UNIT

OF ISSUE

UNIT OF

ISSUE

QUANTITY,

EACH

PART

INDIVIDUA

L

QUANTITY

TOTAL

COST OF

PART ID

EMBASSY

DR, CITY,

COUNTRY,

CODE

ABC

FREIGHT

MM/DD/YY

YY

MM/DD/YY

YY

EMUK

BAGS

EMUK-1

EMUK

BAGS - 0001

MEDIC /

TRAUMA

SHEET BAG

(CCRK) –

COYOTE

A 1

EMUK BAG -

HANGING

BAG

N/A

NORTH

AMERICAN

RESCUE

ITEM # 80-

6515-01-540-

N/A N/A N/A EA 1 1 $

MONTHLY INVENTORY REPORT

KIT

KIT SERIAL

NUMBER

KIT PART ID

NUMBER

NOMENCLATU

RE

REPLACEMEN

T CODE

REPLACEMENT

PRECEDENT

SUBSYSTEM LOCATION

MANUFACTUR

ER

MANUFACTUR

ER ID #

NSN NDC LOT NUMBER EXPIRATION

MANUFACTUR

ER UNIT OF

ISSUE

UNIT OF ISSUE

QUANTITY,

EACH

PART

INDIVIDUAL

QUANTITY

TOTAL COST SHIPMENT ID #

4-FAH-1

ACTIVITY

CODE

PART ID

STATUS

EMUK BAGS EMUK-1

EMUK BAGS -

MEDIC /

TRAUMA

SHEET BAG

(CCRK) –

COYOTE

A 1

EMUK BAG -

HANGING BAG

N/A

NORTH

AMERICAN

RESCUE

ITEM # 80-0069

6515-01-540-

N/A N/A N/A EA 1 1 $ ###### ######

* ACTIVE

ITEMS ONLY

ORDERING ACTIVITY REPORT

TASK/DELIVERY ORDER NUMBER TASK/DELIVERY ORDER DATE SHIPMENT ID # CONTRACTING OFFICER FUND CITE DELIVERY TERMS MATERIALS COST SHIPPING COST TOTAL COST

###### MM/YY/DDDD ###### LAST NAME, FIRST NAME 1900/2015/19___X0113000H/MED/6025/NA/5624/2122/NA/NA/016520/NA/NA NARRATIVE TEXT $ $ $