13R0007PPV-G_Amendment_0004.pdf

AMENDMENT OF SOLICITATION/MODIFICATION OF CONTRACT

1. CONTRACT ID CODE PAGE OF PAGES

1 14

3. EFFECTIVE DATE

November 15, 2013

4. REQUISITION/PURCHASE REQ. NO.

N/A

5. PROJECT NO. (If applicable)

6. ISSUED BY

DEFENSE LOGISTICS AGENCY TROOP SUPPORT

DIRECTORATE OF MEDICAL MATERIEL

700 ROBBINS AVENUE

PHILADELPHIA, PA 19111

DLA TS-FSB (Patricia Kniffin/215-737-5097)

CODE SPM2DX

7. ADMINISTERED BY (If other than Item 6)

CODE

8. NAME AND ADDRESS OF CONTRACTOR (No., street, county, State and ZIP Code

9A. AMENDMENT OF SOLICITATION NO.

SPM2DP-13-R-0007

X 9B. DATED (SEE ITEM 11)

September 19, 2013

10A. MODIFICATION OF CONTRACT/ORDER NO

10B. DATED (SEE ITEM 13)

CODE

FACILITY CODE

11. THIS ITEM ONLY APPLIES TO AMENDMENTS OF SOLICITATIONS

The above numbered solicitation is amended as set forth in item 14. The hour and date specified for receipt of Offers is extended, is not extended.

Offer must acknowledge receipt of this amendment prior to the hour and date specified in the solicitation or as amended, by one of the following methods:

(a) By completing Items 8 and 15, and returning __ 1__ copies of the amendment; (b) By acknowledging receipt of this amendment on each copy of the offer submitted; or (c) By separate letter or telegram which includes a reference to the solicitation and amendment numbers. FAILURE OF YOUR ACKNOWLEDGEMENT TO BE RECEIVED AT THE PLACE DESIGNATED FOR THE RECEIPT OF OFFERS PRIOR TO THE HOUR AND DATE SPECIFIEC MAY RESULT IN REJECTION OF YOUR OFFER. If by virtue of this amendment you desire to change an offer already submitted, such change may be made by telegram or letter, provided each telegram or letter makes reference to the solicitation and this amendment, and is received prior to the opening hour and date specified.

Accounting and Appropriation Data (If required)

13. THIS ITEM APPLIES ONLY TO MODIFICATIONS OF CONTRACTS/ORDERS,

IT MODIFIES THE CONTRACT/ORDER NO. AS DESCRIBED IN ITEM 14.

A. THIS CHANGE IS ISSUED PURSUANT TO: (Specify authority). THE CHANGES SET FORTH IN ITEM 14 ARE MADE IN THE CONTRACT ORDER NO. IN ITEM 10A.

B. THE ABOVE NUMBERED CONTRACT/ORDER IS MODIFIED TO REFLECT THE ADMINISTRATIVE CHANGES (such as changes in paying office, appropriation date, etc.) SET FORTH IN ITEM 14, PURSUANT TO THE AUTHORITY OF FAR 43.103(b).

C. THIS SUPPLEMENTAL AGREEMENT IS ENTERED INTO PURSUANT TO AUTHORITY OF:

D. Other (Specify type of modification and authority)

E. IMPORTANT: Contractor is not, is required to sign this document and return __ copies to the issuing office.

14. DESCRIPTION OF AMENDMENT/MODIFICATION (Organized by UCF section headings, including solicitation/contract subject matter where feasible)

See Attached Pages

Each offeror must acknowledge receipt of this amendment no later than 25 November 2013, 1:00 P.M. EST.

Except as provided herein, all items and conditions of the document referenced in Item 9A or 10A, as heretofore changed, remains unchanged and in full force and effect.

15A. NAME AND TITLE OF SIGNER (Type or Print)

16A. NAME AND TITLE OF CONTRACTING OFFICER (Type or print)

PATRICIA KNIFFIN

Contracting Officer

15B. CONTRACTOR/OFFEROR

(Signature of person authorized to sign)

15C DATE SIGNED 16B. UNITED STATES OF AMERICA

BY ___________________________________________________

(Signature of Contracting Officer)

16C. DATE SIGNED

STANDARD FORM 30 (REV. 10-83)

Prescribed by GSA

FAR (48 CFR) 53.243

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

Amendment 0004

Solicitation SPM2DP-13-R-0007

Referenced Solicitation is amended as follows:

1. Clarification to last statement of Amendment 0002 (page 6) which reads:

“The WRM depth and breadth spreadsheet is available online at:

https://www.medical.dla.mil/Portal/PrimeVendor/PvPharm/PharmPVOverview.aspx”

All PPV-G Usage Data links on DMMonline

(https://www.medical.dla.mil/Portal/PrimeVendor/PvPharm/PharmPVOverview.as

px) have been updated and are available (see below).

Offerors are required to utilize the spreadsheet(s) for the line items that they intend to offer on.

Offerors need to fill out and submit the applicable spreadsheet(s) per instructions in

SPM2DP-13-R-0007.

Attachment 1-PPV-G Lines 0001-0003 Day to Day

Attachment 2-PPV-G Lines 0001-0003 WRM

Attachment 3-PPV-G Line 0004 DP - OGA

Attachment 4-PPV-G Line 0005 Upper Prairie

Attachment 5-PPV-G Line 0006 Back-Up Supplier

Vendors must submit two (2) hard copies and one (1) Electronic copy of both their revised Tab B (Distribution Fee) and their revised Technical Proposal.

2. Statement of Work, Section 2.B (p. 37). Delete paragraph 3.d.

3. Statement of Work, Section 2.E.8.e). ii) (p. 45). Under the first bullet insert “NDC” after “of the quantity.”

4. Statement of Work, Section 2.E.8.e) Delete from the last paragraph (before “Note”)

“Uniform Resource Locators (URLs) and replace with “addresses).

5. Statement of Work, Section 2.F.5.a.i. (p. 49). Delete from the first sentence

“contractually bound to ship” and replace with “contractually required to fill.”

6. Clarification of question #35 from Amendment 0001 – Statement of Work, Section

3.B.7 (p. 59). Insert the following after the last sentence “In the event an item is affected https://www.medical.dla.mil/Portal/PrimeVendor/PvPharm/PharmPVOverview.aspx

Solicitation No. SPM2DP-13-R-0007 Amendment 0004 by retro-pricing changes after delivery, each retro-pricing change will be addressed on a case by case basis by the Price Adjudication Team.

7. Clarification of question # 36 (a) from Amendment 0001 - Statement of Work, Section

3.B.8 (p. 59).

Answer: The Government will determine what is a significant increase on a case by case basis. There are a myriad of factors involved in this determination. A few examples, but not limited to are, original cost of the product, critical need of the medicine, original cost of the product, generics equivalent available and different course of available treatment.

8. Clarification (see Amendment 0002) - Statement of Work, Section 3.B.14 (p. 60).

Delete paragraph 14 including subparagraphs a. and b.

9. Statement of Work, Section 3.B.15 (p. 60). Insert the following after the first sentence

“See Statement of Work, Section 2.B.E.8 ‘Receipt of Orders for Schedule II Controlled

Substances’.

10. Refer to Amendment 0001:

Statement of Work, Section 3.B. (p. 60). Insert the following:

“16. According to Title 21 CFR, Part 1305 – Orders for Schedule I and II Controlled

Substances Subpart B – DEA Form 222, Section 1305.13, paragraph (f) “DEA Forms 222 submitted by registered procurement officers of the Defense Supply Center of the Defense

Logistics Agency for delivery to armed services establishments within the United States may be shipped to locations other than the location printed on the DEA Form 222, and in partial shipments at different times not to exceed six months from the date of the order, as designated by the procurement officer when submitting the order.”

11. Clarification (see Amendment 0002) - Statement of Work, Section 3.C.3.b, Correction - the page number is p.61. Insert the following at letter ‘b’:

“For refrigerated products, refer to Section 9.C. Cold Chain Requirements. Cold

Please note that temperature monitors are required for all cold chain shipments (CONUS and OCONUS). Cold chain requirements can be viewed on the DMMonline website at:

https://www.medical.dla.mil/Portal/Pharmaceutical/PharmOverview.aspx”

12. Statement of Work, Section 6.A (p. 70), delete all of A (including the Note) and replace with the following:

DLA Troop Support offers national contracts for returning pharmaceuticals and certain related waste materials that may arise due to un-returnable pharmaceuticals. The

DoD Pharmaceutical Reverse Distribution program is comprised of contacts with multiple Reverse Distribution (RD) vendors for CONUS and OCONUS returns services.

OCONUS Controlled Substance materials, Schedules II through V, are not authorized for https://www.medical.dla.mil/Portal/Pharmaceutical/PharmOverview.aspx

Solicitation No. SPM2DP-13-R-0007 Amendment 0004 returns. All valid contracts have a base ordering period of 15 months, with three term options of 15 months each, for a potential maximum contract term of 60 months or five years. The PPV contracting Officer will notify the PPV Contractor which RD vendor was awarded the task order to service the CONUS and OCONUS facilities for each branch of service. No Reverse Distribution contractor shall provide services without a task order agreement signed by DLA Contracting Officer. The Contracting Officer will sign one task order per contract period (base period and each option period) for the

CONUS customers and one for the OCONUS customers of each individual branch of

Service (Army, Navy, Air Force, Coast Guard, Designated Providers and Other

Government Agencies).

For additional information (contract numbers, modifications, etc.), the Pharmaceutical

Reverse Distribution website is listed below:

https://www.Medical.dla.mil/Portal/PrimeVendor/PVPharm/ReverseDistribution.aspx

Note: Although each customer of the PPV program is required to utilize a RD to remove their expired and unneeded pharmaceuticals, utilization of the DLA-awarded

Pharmaceutical Reverse Distribution contracts is not mandatory. If an individual customer makes the decision to not use the RD vendor selected for their branch of

Service under the task order issued by DLA, that customer may contract with a RD provider under their own local contract. PPVs shall not process credits from a Reverse

Distribution vendor into a customer’s credit account, or make payments to a Reverse

Distribution vendor from a customer’s credit account, unless either (1) the vendor is the contractor selected for the customer under the task order issued by DLA Troop Support, or (2) the PPV has received authorization from DLA Troop Support Medical to do so, based on receiving a valid contract between that customer and a Reverse Distribution vendor.

13. Statement of Work, Section 10.B. (p.80) Paragraph 2.a.

Delete the third sentence “All files must be…” and replace it with “Full catalog files must be delivered as a set of files either based on customer or Distribution

Center by 12 Midnight EST the same calendar day the DAPA/FSS files are received by the PPV.”

Delete the fourth sentence “If there are no updates for that day, a file containing only header data must be sent to indicate there are no updates.”

Delete the last sentence “An end of day file is also required to ensure the number of files sent, are the number of files received” and replace it with “An end of day file is required to be sent as the last file to ensure the number of files sent, are the number of files received. It is requested that the end of day file be sent at least five minutes after the last catalog file is sent to ensure the end of day file does not arrive prior to any of the catalog files.”

https://www.medical.dla.mil/Portal/PrimeVendor/PVPharm/ReverseDistribution.aspx

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

14. Statement of Work, Section 10.B. (p.80) Delete the language at Paragraph 2.d. and replace it with the following:

“Upon Implementation of this contract, the PPV will send to DLA Troop Support

Medical an entire copy of its Master Catalog to include those items that are covered on your Regional DAPA offering as well as under a Contracted DAPA, FSS or other

Government approved pricing vehicles. Subsequently, the PPV(s) organization must send its Master Catalog files on a daily basis to DLA Troop Support Medical as the

PPV(s) assimilates updates from the DAPA/FSS product and pricing data files or adds new items to your Regional DAPA offering that prompt a change to your Master

Catalog.”

15. Statement of Work, Section 10.B. (p.80) Delete the last sentence from Paragraph 2.f.

and replace it with the following:

“The Pricing Agreement Relationship file must be a full file of all pricing agreement holders indicating whether or not a business relationship has been established with the PPV. After initial submission, this file is required to be sent whenever a change occurs. In this case, a full file shall be sent to replace the file currently in possession of

DLA Troop Support Medical which reflects all changes.”

Statement of Work, Section 10.B. (p.80) Add paragraph g. “DLA Troop Support Medical requires that the PPVs submit a Distribution Center file as part of their submission. After initial submission, this file is required to be sent whenever a change occurs. In this case, a full file shall be sent to replace the file currently in possession of DLA Troop Support-

Medical which reflects all changes.”

16. Statement of Work, Section 10.B. paragraph 3 (pp. 80-81) replace the following:

I. PPV Distribution Center DoDAAC lookup file

II. Item and Pricing Catalogs, one for each Master DoDAAC

III. Pricing Agreement Relationship file

IV. Daily upload complete indicator file

With:

I. Distribution Center File

II. Distribution Center DoDAAC File

III. Distribution Center Item File

IV. Item and Pricing Catalogs, one for each Master DoDAAC

V. Pricing Agreement Relationship file

VI. Incentive Agreement Pricing File (Only used when Submitting Item and

Pricing Catalogs by Distribution Center)

VII. Daily upload complete indicator file

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

17. Statement of Work, Section 10.B.3. Replace paragraphs I through IV (pp. 81-88) with the following:

“I. Distribution Center File

A. File Format

i. Pipe-delimited ASCII text with column headers.

B. File Naming Convention

File Name Description Frequency

PV_CODE_DIST_CENTER_mmddyyyy.txt PV_CODE is the PPV’s 4 digit code assigned by

DLA Troop Support Medical

This file contains the PPV’s

Distribution Center information.

Initial load and when updated.

C. File Layout

ID

Data Element

Data

Type Data Description

Mandatory /Optional

1 DIST_CENTER_ID VARCHAR2

(15 Char) Distribution Center ID Mandatory

2 DIST_CENTER_NM VARCHAR2

(80 Char) Distribution Center Name Mandatory

3 DIST_CENTER_CONTACT_NM VARCHAR2

(40 Char)

DC_CONTACT_NAME Mandatory

4 DIST_CENTER_PHONE_NUM VARCHAR2

(20 Char)

DC_PHONE_NUMBER Mandatory

5 DIST_CENTER_ADDRESS VARCHAR2

(1024 Char)

DC_ADDRESS Mandatory

6 DIST_CENTER_CITY_NM VARCHAR2

(36 Char)

DC_CITY Mandatory

7 DIST_CENTER_STATE_CD VARCHAR2

(2 Char)

DC_STATE Mandatory

8 DIST_CENTER_POSTAL_CD VARCHAR2

(10 Char)

DC_ZIPCODE Mandatory

9 DEA_NUM VARCHAR2

(9 Char)

DEA_NUMBER Mandatory

10 CREATE_DT DATE File Create Date (MMDDYYYY) Mandatory

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

II. Distribution Center DoDAAC File

PV_CODE_DC_DODAAC.txt PV_CODE is the PPV’s 4 digit code assigned by DLA Troop Support Medical

This file contains a cross reference of the

PPV’s Distribution Centers to the Master

DoDAACs they support.

Initial and when updated.

Data

Type Data Description

Mandatory/Option al

1 DIST_CENTER_ID VARCHAR2

(15 Char) Distribution Center ID Mandatory

2 DODAAC VARCHAR2

(6 Char)

Department of Defense Activity

Address Code (DoDAAC) assigned to the ordering account.

Mandatory

3 CUSTOMER_ID VARCHER2

(30 Char)

A unique key that identifies the customer.

Mandatory

4 JIT_PV_ACCOUNT_NUM VARCHAR2

(30 Char)

The PPV assigned customer account number for “JIT”

Delivery Method.

Mandatory

5 DROP_SHIP_PV_ACCOUNT_NU

M

VARCHAR2

(30 Char)

The PPV assigned customer account number for “Drop Ship”.

Mandatory

6 CREDIT_PV_ACCOUNT_NUM VARCHAR2

(30 Char)

The PPV assigned customer account number for Credit

Orders.

Mandatory

7 CREATE_DT DATE File Create Date (MMDDYYYY) Mandatory

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

III. Distribution Center Item File

PV_CODE_DC_ITEM.txt PV_CODE is the PPV’s 4 digit code assigned by DLA Troop Support Medical

This file contains a cross reference of the

PPV’s Distribution Centers to the items they distribute.

Daily.

Data

Type Data Description

Mandatory/Optiona l

1 DIST_CENTER_ID VARCHAR2

(15 Char) Distribution Center ID Mandatory

2 PVON VARCHAR2

(30 Char)

PPV Part Number assigned to the product.

Mandatory

3 PV_SNAPSHOT_DT DATE Date of DAPA catalog used to generate this file. (MMDDYYYY)

Mandatory

4 VELOCITY_CD VARCHAR2

(1 Char)

A code defining volatility of demand at the Distribution

Center.

Optional

5 DMD_FORECAST_30_DAY VARCHAR2

(15 Char)

30-Day Demand Forecast in

Base Unit of Packaging (UOP)

Optional

6 DMD_FORECAST_60_DAY VARCHAR2

(15 Char)

60- Day Demand Forecast in

Base Unit of Packaging (UOP)

Optional

7 CREATE_DT DATE File Create Date (MMDDYYYY) Mandatory

IV. Item and Pricing Catalog File (one for each Master DoDAAC)

File Name Description

PV_CODE_DODAAC_mmddyyyy.txt PV_CODE is the PPV’s 4 digit code assigned by DLA Troop Support Medical DoDAAC shall be the Master DoDAAC.

This file contains the products and best price available to a

Master DoDAAC. The header record (H1) includes the Master

DoDAAC and the Distribution Center that supports the Master

DoDAAC. The detail records (D1) contain the product and price information

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

Header

Data Element

Data

Type Data Description

Mandatory /Optional

1 RECORD_ID VARCHAR

2 (2 Char)

Constant ‘H1’ Mandatory

2 DODAAC VARCHAR

2 (6 Char)

The Department of Defense Activity

Address Code (DoDAAC) assigned to the ordering account.

Mandatory

3 DIST_CENTER_ID VARCHAR

2 (15 Char) The Distribution Center ID that supports the DODAAC.

Mandatory

4 PV_SNAPSHOT_DT DATE Date of DAPA catalog used to generate this file. (MMDDYYYY)

5 CREATE_DT DATE File Create Date (MMDDYYYY) Mandatory

Detail

Note: Data elements in bold font identify the logical key data elements that identify a unique product and pricing record.

Data

Type Data Description

Mandatory /Optional

1 RECORD_ID VARCHAR

2 (2 Char)

Constant ‘D1’ Mandatory

2 PVON VARCHAR

2 (30 Char)

PPV Part Number assigned to the product.

Mandatory

3 PRIMARY_PVON_IND VARCHAR

2 (1 Char)

Indicates whether the PVON is the primary PVON.

Mandatory

4 NDC VARCHAR

2 (11 Char)

National Drug Code assigned to the product.

Mandatory

5 UPC VARCHAR

2 (12 Char)

Universal Product Code assigned to the product.

Optional

6 PRICING_AGREEMENT_NUM VARCHAR

2 (30 Char)

Distribution and Pricing Agreement

(DAPA) Number

Mandatory

7 SUPPLIER_NM VARCHAR

2 (40 Char)

DAPA Holder Company Name Mandatory

8 DAPA_PRICE_EFF_DT DATE DAPA Number Price Effective Date

(MMDDYYYY)

Optional

9 DAPA_PRICE_EXP_DT DATE DAPA Number Price Expiration Date

(MMDDYYYY)

Optional

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

Data

Type Data Description

Mandatory /Optional

10 PV_PRICE_EFF_DT DATE PPV Price Effective Date (MMDDYYYY) Mandatory

11 PV_PRICE_EXP_DT DATE PPV Price Expiration Date

(MMDDYYYY)

Mandatory

12 ITEM_SHORT_DESC_TX VARCHAR

2 (80 Char)

The short description of the product. Mandatory

13 ITEM_LONG_DESC_TX VARCHAR

2 (900

Char)

The long description of the product. Mandatory

14 PV_MANUFACTURER_NM VARCHAR

2 (40 Char)

The manufacturer name according to the PPV.

Mandatory

15 PV_MANUFACTURER_PART_NUM VARCHAR

2 (32 Char)

The manufacturer part number according to the PPV.

Mandatory

16 DAPA_MANUFACTURER_NM VARCHAR

2 (40 Char)

The manufacturer name received from the DAPA Product Catalog file.

Mandatory for DAPA/FSS

Pricing Agreements, Optional for Regional

Pricing Agreements.

17 DAPA_MANUFACTURER_PART_NUM VARCHAR

2 (20 Char)

The manufacturer part number received from the DAPA Product Catalog file

Mandatory for DAPA/FSS

Pricing Agreements, Optional for Regional

Pricing Agreements.

18 AVAILABILITY_IND VARCHAR

2 (1 Char)

Indicates whether the item is currently available. (‘Y’ - Yes or ‘N’ – No)

Mandatory

19 REASON_CD VARCHAR

2 (2 Char)

Only populated if AVAILABILITY_IND is set to ‘N’, else null. It provides the reason the item is not available. The actual codes will be mutually defined between the PPV and DLA Troop Support Medical prior to the initial file submission.

Examples:

Allocated by Manufacturer - The item is in short supply and is being allocated by the manufacturer.

Unavailable by Manufacturer - The item is currently not available from the manufacturer.

DC discontinued - The item has been discontinued by the DC.

Manufacturer Discontinued - The item has been discontinued by the manufacturer.

Inactive (New Item) - The item is new and is not yet available for sale.

Unavailable by Manufacturer - The manufacturer is unable to meet the demand for the item. The item is temporarily unavailable.

Do Not Stock – The item is a non-stocked item.

Optional (Mandatory when

AVAILABILITY_IND = ‘N’.

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

Data

Type Data Description

Mandatory /Optional

20 DROP_SHIP_ONLY_IND VARCHAR

2 (1 Char)

Indicates that the product is only available through Drop Shipment. (‘Y’-

Yes or ‘N - No)

Mandatory

21 DROP_SHIP_FEE_IND VARCHAR

2 (1 Char)

Indicates if there is a fee incurred when

DROP_SHIP_ONLY_IND = ‘Y.’ (‘Y’-

Yes or ‘N - No)

Optional (Mandatory when

DROP_SHIP_ONLY_IND

= ‘Y’)

22 GREEN_PRODUCT_IND VARCHAR

2 (1 Char)

Indicates whether the product is environmentally friendly. (‘Y’- Yes, ‘N’ -

No, or ‘U’ - Unknown)

Mandatory

23 HAZARDOUS_MATERIAL_IND VARCHAR

2 (1 Char)

Indicates whether the product is hazardous. (‘Y’- Yes, ‘N’ - No, or ‘U’ -

Unknown)*

Mandatory

24 LATEX_FREE_IND VARCHAR

2 (1 Char)

Latex Free Indicator – Indicates that the product does not contain latex. (‘Y’-

Yes, ‘N’ - No, or ‘U’ - Unknown)

Mandatory

25 COLD_CHAIN_MGMT_IND VARCHAR

2 (1 Char)

Indicates whether the product requires cold chain handling. (‘Y’- Yes, ‘N’ - No, or ‘U’ - Unknown)

Mandatory

26 COLD_CHAIN_MGMT_CD VARCHAR

2 (1 Char)

Indicates whether the product requires refrigeration (R) or frozen (F) storage when cold COLD_CHAIN_MGMT_IND

= ‘Y’.

Optional (Mandatory when

COLD_CHAIN_MGMT_IN

D = ‘Y’).

27 CONTROLLED_ITEM_IND VARCHAR

2 (1 Char)

Indicates whether the product is a controlled substance. (‘Y’- Yes, ‘N’ - No, or ‘U’ - Unknown)

Mandatory

28 DEA_CD VARCHAR

2 (1 Char)

DEA Schedule Number (indicate 1, 2, 3, 4, 5 or 6)

Optional

29 BASE_UOM_CD VARCHAR

2 (2 Char)

“ANSI” Base Unit of Measure Code –

The smallest physical practical unit of measure within the BASE_UOP_CD.

Examples: OZ, ML, EA, GR

Optional (Mandatory when

ITEM_SIZE_UOM_CD is not provided)

30 BASE_UOM_QTY VARCHAR

2 (13 Char)

Base Unit of Measure Quantity – The number of BASE_UOM_CD units in the

BASE_UOP_CD.

Optional (Mandatory when

BASE_UOM_CD is provided)

31 ITEM_SIZE_UOM_CD VARCHAR

2 (2 Char)

ANSI” Item Size Unit of Measure Code

– The smallest physical practical unit of measure for the product. Examples: ML, GM

Optional (Mandatory when

BASE_UOM_CD is not provide)

32 ITEM_SIZE_QTY VARCHAR

2 (13 Char)

Item Size Quantity – The number of

ITEM_SIZE_UOM_CD units in the

ITEM_SIZE_UOM_CD. Examples:

10X10, 25X1, 12X12X5

Optional (Mandatory when

ITEM_SIZE_UOM_CD is provided)

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

Data

Type Data Description

Mandatory /Optional

33 ITEM_STRENGTH_TX VARCHAR

2 (20 Char)

Describes the unit of measure configuration of the

ITEM_STRENGTH_QTY. Examples:

MG/5ML, STRIP, 12.5MG

Optional

34 ITEM_STRENGTH_QTY VARCHAR

2 (13 Char)

Item Strength Quantity – The number of

ITEM_SIZE_STRENGTH_TX units in the ITEM_SIZE_UOM_CD.

Optional

35 ITEM_FORM_CD VARCHAR

2 (6 Char)

A code describing the physical form of the product. Examples: TAB, SYR, LIQ, VL, PTCH

Optional

36 ITEM_DISPENSE_QTY VARCHAR

2 (6 Char)

The number of ITEM_FORM_CD units in which the item is dispensed.

Optional

37 BASE_UOP_CD VARCHAR

2 (2 Char)

“ANSI” Base Unit of Pack Code – The smallest packaging configuration within the PACK_UOM_CD. Examples: BT, EA, VI, TB, SZ

Mandatory

38 PACK_UOM_CD VARCHAR

2 (2 Char)

“ANSI” Packaging Unit of Measure

Code – The saleable packaging configuration of the product. Examples:

BX, EA, BT, KT, VI, CS, CA

Mandatory

39 PACK_UOM_QTY VARCHAR

2 (13 Char)

The number of BASE_UOP_CD units in the PACK_UOM_CD.

Mandatory

40 PACK_PRICE_AMT VARCHAR

2 (14 Char)

The price of the PACK_UOM_CD. Mandatory

41 FET_AMT VARCHAR

2 (14 Char)

The Federal Excise Tax amount applied to the product.

Optional (Mandatory when the product is subject to the FET)

42 PACK_CUBE_VOL VARCHAR

2 (2 Char)

The cube of the PACK_UOM_CD. Mandatory

43 PACK_CUBE_UOM_CD VARCHAR

2 (2 Char)

The “ANSI” unit of measure of the

PACK_CUBE_VOL.

Mandatory

44 PACK_GROSS_WT VARCHAR

2 (2 Char)

The gross weight of the

PACK_UOM_CD.

Mandatory

45 PACK_GROSS_WT_UOM_CD VARCHAR

2 (2 Char)

The “ANSI’ unit of measure of the

PACK_GROSS_WT.

Mandatory

46 PACK_HEIGHT_DM VARCHAR

2 (2 Char)

The height dimension of the

PACK_UOM_CD.

Mandatory

47 PACK_HEIGHT_UOM_CD VARCHAR

2 (2 Char)

The “ANSI” unit of measure of the

PACK_HEIGHT_DM.

Mandatory

48 PACK_LENGTH_DM VARCHAR

2 (2 Char)

The length dimension of the

PACK_UOM_CD.

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

Data

Type Data Description

Mandatory /Optional

49 PACK_LENGTH_UOM_CD VARCHAR

2 (2 Char)

The “ANSI” unit of measure of the

PACK_LENGTH_DM.

Mandatory

50 PACK_WIDTH_DM VARCHAR

2 (2 Char)

The width dimension of the

PACK_UOM_CD.

Mandatory

51 PACK_WIDTH_UOM_CD VARCHAR

2 (2 Char)

The “ANSI” unit of measure of the

PACK_WIDTH_DM

*It is the intent of the Government to add an additional field called “Hazardous Material Type” to indicate the category or type of hazardous material for transportation purposes.

V. Pricing Agreement Relationship File

PV_CODE_PA_REL_mmddyyyy.txt

PV_CODE is the PPV’s 4 digit code assigned by

DLA Troop Support Medical

PPV’s Pricing Agreement

Relationship list.

Initial load and when updated.

Data

Type Data Description

Mandatory

/Optional

1 PRICING_AGREEMENT_NUM VARCHAR2

(30 Char)

Distribution and Pricing Agreement

(DAPA) Number Mandatory

2 SUPPLIER_NM VARCHAR2

(40 Char) DAPA Holder Company Name. Mandatory

3 REASON_CD VARCHAR2

(2 Char)

‘CA’ - No customer demand for this DAPA holders items to date.

‘PA’ - Currently in discussions with this vendor.

‘NA’ - Irreconcilable differences in DAPA holders and PPV's business terms.

Mandatory

4 CREATE_DT DATE File Create Date (MMDDYYYY)

Solicitation No. SPM2DP-13-R-0007 Amendment 0004

VI. Incentive Agreement Pricing File

PV_CODE_INCENTIVE_PRICE_mmddyyyy.txt PV_CODE is the PPV’s 4 digit code assigned by DLA Troop Support Medical

Contains the customer DoDAACs, incentive price, and incentive Pricing Agreement information.

Daily

Data Type

Data Description Mandatory /Optional

1 DODAAC VARCHAR

2 (6 Char)

The customer’s Department of Defense Activity Address Code (DoDAAC).

Mandatory

2 PVON VARCHAR

2 (30 Char)

PPV Part Number assigned to the product.

Mandatory

3 NDC VARCHAR

2 (11 Char)

National Drug Code assigned to the Product.

Mandatory

4 PRICING_AGREEMENT_NUM VARCHAR

2 (30 Char)

Distribution and Pricing Agreement (DAPA) Number

Mandatory

5 INCENTIVE_PRICE_AMT VARCHAR

2 (14 Char)

The incentive price being offered to the customer for the PVON.

Mandatory

6 PV_PRICE_EFF_DT DATE PPV Price Effective Date

(MMDDYYYY)

Mandatory

7 PV_PRICE_EXP_DT DATE PPV Price Expiration Date

(MMDDYYYY)

Mandatory

8 PV_SNAPSHOT_DT DATE Date of DAPA catalog used to generate this file. (MMDDYYYY)

9 CREATE_DT DATE File Create Date (MMDDYYYY) Mandatory

18. Statement of Work, Section 12.B.16. (P. 108). Delete from the first sentence the

“Deferred Procurement” and replace it with the “Delayed Delivery Order.”

NOTE: Offerors are permitted to revise proposals as long as the revisions are submitted by the extended closing date of November 25, 2013, 1:00 P.M. EST.