SPE2DX14R0001_Amend0001.pdf

AMENDMENT OF SOLICITATION/MODIFICATION OF CONTRACT

1. CONTRACT ID CODE PAGE OF PAGES

1 11

3. EFFECTIVE DATE

13 March 2014

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 (Linda Grugan/215-737-2806)

CODE SPM200

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.

SPE2DX-14-R-0001

X 9B. DATED (SEE ITEM 11)

February 24, 2014

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 and return with its proposal on the proposal closing date of 10 April 2014, 3:00 PM 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) Linda Grugan 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

SPE2DX-14-R-0001Amend 0001

The following SOW requirements are deleted and/or inserted as follows:

Page 54 Para 2 Data File Transmission from PPV to DLA Troop Support.

DELETED: a. The PFPV will use the file formats below to communicate all catalog/pricing data to DLA Troop Support Medical. All files must delimit fields using the “pipe” character (ASCII 124). All files must be delivered as a set of files either based on customer or Distribution Center by 12 p.m. EST the day the files are sent. If there are no updates for that day, a file containing only header data must be sent to indicate there are no updates. An end of day file is also required to ensure the number of files sent, are the number of files received.

INSERT: a. The PFPV will use the file formats below to communicate all catalog/pricing data to DLA Troop Support Medical. 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.

DELETED: d. Upon Implementation of this contract, the PPV shall send to DLA Troop Support Medical an entire copy of its Medical Master Catalog, to include the DAPA/FSS product and pricing data that is supplied to the prime vendor by DLA Troop Support Medical, as well as any catalog and pricing data for “Regional” DAPA items.

Subsequently, the PPV shall send a daily “delta” (adds, changes and deletes) update file back to DLA Troop Support Medical as the PPV assimilates updates from the DAPA/FSS product and pricing data files or if the PPV adds new items under its Regional DAPA .

INSERT: d. Upon implementation of the contract, the PFPV will send to DLA Troop Support an entire copy of its Master Catalog to include those items that are covered on a PPV’s Regional DAPA offering as well as under a Contracted DAPA, FSS or other government approved pricing vehicles. Subsequently, the PFPV must send its Master Catalog files on a daily basis to DLA Troop Support Medical as the PFPV assimilates updates from the DAPA/FS product and pricing data files or adds new items to its Regional DAPA offering the prompts a change to their Master Catalog.

INSERT: g. DLA Troop Support Medical requires that PFPV 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.

PAGE 55 PARA 3.

Catalog and Pricing Data Requirements and Preferred Delivery method: The PPV shall provide the following data in a format agreed to by DLA Troop Support. The file structure below represents the data sent in a “Customer” format and is the Government’s preferred method of receiving this data. For each US Naval Fleet ordering customer supported by the PPV a Medical Master Catalog will be sent to communicate the items available to purchase, the pricing agreement, price, unit of measure and various other data elements as described below. The PPV must provide the data elements marked as “Mandatory.” The PPV is encouraged to provide the data elements marked as “Optional.” The PPV must provide the following files to deliver complete information to DLA Troop Support Medical:

DELETED: I. PPV Distribution Center DoDAAC lookup file

II. Medical Master Catalog, one for each Master DoDAAC III. Pricing Agreement Relationship file IV. Daily upload complete indicator file

INSERT: 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

PAGE 55 THROUGH 63

DELETE: Catalog & Pricing File Format 1-PPV Distribution Center DODAAC Look

Up through Format IV Daily Upload Complete Indicator File.

INSERT:

“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_mmd dyyyy.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 VARCH

AR2 (15

Char)

Distribution Center ID Mandatory

2 DIST_CENTER_NM VARCH

AR2 (80

Char)

Distribution Center Name Mandatory

3 DIST_CENTER_CONTACT

_NM

VARCH

AR2 (40

Char)

DC_CONTACT_NAME Mandatory

4 DIST_CENTER_PHONE_N

UM

VARCH

AR2 (20

Char)

DC_PHONE_NUMBER Mandatory

5 DIST_CENTER_ADDRESS VARCH

AR2

(1024

Char)

DC_ADDRESS Mandatory

6 DIST_CENTER_CITY_NM VARCH

AR2 (36

Char)

DC_CITY Mandatory

7 DIST_CENTER_STATE_CD VARCH

AR2 (2

Char)

DC_STATE Mandatory

8 DIST_CENTER_POSTAL_C

D

VARCH

AR2 (10

Char)

DC_ZIPCODE Mandatory

9 DEA_NUM VARCH

AR2 (9

Char)

DEA_NUMBER Mandatory

10 CREATE_DT DATE File Create Date

(MMDDYYYY)

Mandatory

II. Distribution Center DoDAAC File

A. File Format

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/Optional

1 DIST_CENTER_ID VARCHA

R2 (15

Char)

Distribution Center ID Mandatory

2 DODAAC VARCHA

R2 (6

Char)

Department of Defense

Activity Address Code

(DoDAAC) assigned to the ordering account.

Mandatory

3 CUSTOMER_ID VARCHE

R2 (30

Char)

A unique key that identifies the customer.

Mandatory

4 JIT_PV_ACCOUNT_NUM VARCHA

R2 (30

Char)

The PPV assigned customer account number for “JIT” Delivery

Method.

Mandatory

5 DROP_SHIP_PV_ACCOU

NT_NUM

VARCHA

R2 (30

Char)

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

Mandatory

6 CREDIT_PV_ACCOUNT_

NUM

VARCHA

R2 (30

Char)

The PPV assigned customer account number for Credit Orders.

Mandatory

7 CREATE_DT DATE File Create Date

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.

ID Data Element Data Type Data Description Mandatory/Optional

1 DIST_CENTER_ID VARCHA

R2 (15

Char)

Distribution Center ID Mandatory

2 PVON VARCHA

R2 (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 VARCHA

R2 (1

Char)

A code defining volatility of demand at the

Distribution Center.

Optional

5 DMD_FORECAST_30_

DAY

VARCHA

R2 (15

Char)

30-Day Demand Forecast in Base Unit of

Packaging (UOP)

Optional

6 DMD_FORECAST_60_

DAY

VARCHA

R2 (15

Char)

60- Day Demand

Forecast in Base Unit of

Packaging (UOP)

Optional

7 CREATE_DT DATE File Create Date

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

A. File Format

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

Header

Data Element

Data

Type Data Description

Mandatory

/Optional

1 RECORD_ID VARCH

AR2 (2

Char)

Constant ‘H1’ Mandatory

2 DODAAC VARCH

AR2 (6

Char)

The Department of Defense

Activity Address Code

(DoDAAC) assigned to the ordering account.

Mandatory

3 DIST_CENTER_ID VARCH

AR2 (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)

Mandatory

5 CREATE_DT DATE File Create Date

Detail

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

Data Element

Data

Type Data Description

Mandatory

/Optional

1 RECORD_ID VARCH

AR2 (2

Char)

Constant ‘D1’ Mandatory

2 PVON VARCH

AR2 (30

Char)

PPV Part Number assigned to the product.

Mandatory

3 PRIMARY_PVON_IND VARCH

AR2 (1

Char)

Indicates whether the PVON is the primary PVON.

Mandatory

4 NDC VARCH

AR2 (11

Char)

National Drug Code assigned to the product.

Mandatory

5 UPC VARCH

AR2 (12

Char)

Universal Product Code assigned to the product.

Optional

6 PRICING_AGREEMENT_NU

M

VARCH

AR2 (30

Char)

Distribution and Pricing

Agreement (DAPA) Number

Mandatory

7 SUPPLIER_NM VARCH

AR2 (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

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 VARCH

AR2 (80

Char)

The short description of the product.

Data Element

Data

Type Data Description

Mandatory

/Optional

13 ITEM_LONG_DESC_TX VARCH

AR2

(900

Char)

The long description of the product.

Mandatory

14 PV_MANUFACTURER_NM VARCH

AR2 (40

Char)

The manufacturer name according to the PPV.

Mandatory

15 PV_MANUFACTURER_PAR

T_NUM

VARCH

AR2 (32

Char)

The manufacturer part number according to the PPV.

Mandatory

16 DAPA_MANUFACTURER_N

M

VARCH

AR2 (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_P

ART_NUM

VARCH

AR2 (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 VARCH

AR2 (1

Char)

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

Data Element

Data

Type Data Description

Mandatory

/Optional

19 REASON_CD VARCH

AR2 (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_IN

D = ‘N’.

20 DROP_SHIP_ONLY_IND VARCH

AR2 (1

Char)

Indicates that the product is only available through Drop

Shipment. (‘Y’- Yes or ‘N -

No)

Mandatory

21 DROP_SHIP_FEE_IND VARCH

AR2 (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’)

Data Element

Data

Type Data Description

Mandatory

/Optional

22 GREEN_PRODUCT_IND VARCH

AR2 (1

Char)

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

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

Unknown)

Mandatory

23 HAZARDOUS_MATERIAL_I

ND

VARCH

AR2 (1

Char)

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

Mandatory

24 LATEX_FREE_IND VARCH

AR2 (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 VARCH

AR2 (1

Char)

Indicates whether the product requires cold chain handling.

(‘Y’- Yes, ‘N’ - No, or ‘U’ -

Unknown)

Mandatory

26 COLD_CHAIN_MGMT_CD VARCH

AR2 (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_MG

MT_IND = ‘Y’).

27 CONTROLLED_ITEM_IND VARCH

AR2 (1

Char)

Indicates whether the product is a controlled substance. (‘Y’-

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

Unknown)

Mandatory

28 DEA_CD VARCH

AR2 (1

Char)

DEA Schedule Number

(indicate 1, 2, 3, 4, 5 or 6)

Optional

29 BASE_UOM_CD VARCH

AR2 (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 VARCH

AR2 (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)

Data Element

Data

Type Data Description

Mandatory

/Optional

31 ITEM_SIZE_UOM_CD VARCH

AR2 (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 VARCH

AR2 (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)

33 ITEM_STRENGTH_TX VARCH

AR2 (20

Char)

Describes the unit of measure configuration of the

ITEM_STRENGTH_QTY.

Examples: MG/5ML, STRIP, 12.5MG

Optional

34 ITEM_STRENGTH_QTY VARCH

AR2 (13

Char)

Item Strength Quantity – The number of

ITEM_SIZE_STRENGTH_TX

units in the

ITEM_SIZE_UOM_CD.

Optional

35 ITEM_FORM_CD VARCH

AR2 (6

Char)

A code describing the physical form of the product. Examples:

TAB, SYR, LIQ, VL, PTCH

Optional

36 ITEM_DISPENSE_QTY VARCH

AR2 (6

Char)

The number of

ITEM_FORM_CD units in which the item is dispensed.

Optional

37 BASE_UOP_CD VARCH

AR2 (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 VARCH

AR2 (2

Char)

“ANSI” Packaging Unit of

Measure Code – The saleable packaging configuration of the product. Examples: BX, EA, BT, KT, VI, CS, CA

Data Element

Data

Type Data Description

Mandatory

/Optional

39 PACK_UOM_QTY VARCH

AR2 (13

Char)

The number of

BASE_UOP_CD units in the

PACK_UOM_CD.

Mandatory

40 PACK_PRICE_AMT VARCH

AR2 (14

Char)

The price of the

PACK_UOM_CD.

Mandatory

41 FET_AMT VARCH

AR2 (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 VARCH

AR2 (2

Char)

The cube of the

PACK_UOM_CD.

Mandatory

43 PACK_CUBE_UOM_CD VARCH

AR2 (2

Char)

The “ANSI” unit of measure of the PACK_CUBE_VOL.

Mandatory

44 PACK_GROSS_WT VARCH

AR2 (2

Char)

The gross weight of the

PACK_UOM_CD.

Mandatory

45 PACK_GROSS_WT_UOM_C

D

VARCH

AR2 (2

Char)

The “ANSI’ unit of measure of the PACK_GROSS_WT.

Mandatory

46 PACK_HEIGHT_DM VARCH

AR2 (2

Char)

The height dimension of the

PACK_UOM_CD.

Mandatory

47 PACK_HEIGHT_UOM_CD VARCH

AR2 (2

Char)

The “ANSI” unit of measure of the PACK_HEIGHT_DM.

Mandatory

48 PACK_LENGTH_DM VARCH

AR2 (2

Char)

The length dimension of the

PACK_UOM_CD.

Mandatory

49 PACK_LENGTH_UOM_CD VARCH

AR2 (2

Char)

The “ANSI” unit of measure of the PACK_LENGTH_DM.

Data Element

Data

Type Data Description

Mandatory

/Optional

50 PACK_WIDTH_DM VARCH

AR2 (2

Char)

The width dimension of the

PACK_UOM_CD.

Mandatory

51 PACK_WIDTH_UOM_CD VARCH

AR2 (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.

VI. Incentive Agreement Pricing File

PV_CODE_INCENTIVE_PRICE_mmd dyyyy.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 VARCH

AR2 (6

Char)

The customer’s Department of

Defense Activity Address Code

(DoDAAC).

Mandatory

2 PVON VARCH

AR2 (30

Char)

PPV Part Number assigned to the product.

Mandatory

3 NDC VARCH

AR2 (11

Char)

National Drug Code assigned to the Product.

Mandatory

4 PRICING_AGREEMENT_N

UM

VARCH

AR2 (30

Char)

Distribution and Pricing

Agreement (DAPA) Number

Mandatory

5 INCENTIVE_PRICE_AMT VARCH

AR2 (14

Char)

The incentive price being offered to the customer for the

PVON.

Data Element

Data

Type Data Description

Mandatory

/Optional

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)

Mandatory

9 CREATE_DT DATE File Create Date