HTC711-13-R-D001.pdf

AMENDMENT OF SOLICITATION/MODIFICATION OF CONTRACT

Except as provided herein, all terms 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)

30-105-04EXCEPTION TO SF 30

APPROVED BY OIRM 11-84

STANDARD FORM 30 (Rev. 10-83) Prescribed by GSA

FAR (48 CFR) 53.243

see Continuation of Block 14.

1. CONTRACT ID CODE PAGE OF PAGES

J 1 77

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

16C. DATE SIGNED

BY

16B. UNITED STATES OF AMERICA15C. DATE SIGNED15B. CONTRACTOR/OFFEROR

(Signature of Contracting Officer)(Signature of person authorized to sign)

8. NAME AND ADDRESS OF CONTRACTOR (No., Street, County, State and Zip Code) X HTC711-13-R-D001

X 9B. DATED (SEE ITEM 11)

20-Dec-2012

10B. DATED (SEE ITEM 13)

9A. AMENDMENT OF SOLICITATION NO.

11. THIS ITEM ONLY APPLIES TO AMENDMENTS OF SOLICITATIONS

X The above numbered solicitation is amended as set forth in Item 14. The hour and date specified for receipt of Offer is extended, X 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 ACKNOWLEDGMENT TO BE RECEIVED AT THE PLACE DESIGNATED FOR THE RECEIPT OF OFFERS PRIOR TO THE HOUR AND DATE SPECIFIED 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.

12. 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 ORDER 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.)

10A. MOD. OF CONTRACT/ORDER NO.

U0001

2. AMENDMENT/MODIFICATION NO. 5. PROJECT NO.(If applicable)

6. ISSUED BY

3. EFFECTIVE DATE

11-Jan-2013

CODE

USTRANSCOM-AQ - HTC711

508 SCOTT DR

SCOTT AFB IL 62225-5357

HTC711 7. ADMINISTERED BY (If other than item 6)

4. REQUISITION/PURCHASE REQ. NO.

CODE

See Item 6

FACILITY CODECODE

EMAIL:TEL:

HTC711-13-R-D001

SECTION SF 30 BLOCK 14 CONTINUATION PAGE

The following items are applicable to this modification:

CONTINUATION OF BLOCK 14

Amendment 0001 is issued to make the following changes: As a result of the amendment the proposal due date has not been extended (see block #11)

1. RFP, Section B, CLIN structure. Change CLIN 0003 and 0006 from FFP to LH

2. RFP, Section B, CLIN Structure. Add subparagraphs to CLIN descriptions

3. RFP, Section C, PWS. See tracked changes throughout the document.

4. RFP, Section C, PWS, Appendix B. See clarifications to estimated workload data.

5. RFP, Section L-1(b) added use of non-Government advisors

6. RFP, Section L, Instructions to Offerors. See changes to page limits.

7. RFP, Section L, Instructions to Offerors, paragraph L-4(d). See clarification to include all priced optional tasks in price proposal with the exception of CLINS 2005,2006,3005,3006,4005,4006,5005 and 5006.

8. RFP, Section M(b) as revised.

9. RFP, Attachment 4 – See revised Staffing and Pricing.

10. RFP, Attachment 5 – Included performance areas for past performance criteria which were inadvertently left off of the RFP.

POC for this amendment is Deborah K Crisp, deborah.crisp@ustranscom.mil.

SUMMARY OF CHANGES

SECTION B - SUPPLIES OR SERVICES AND PRICES

CLIN 0001

The CLIN extended description has changed from TRDM IT Services, User Interface Development and Web ServicesParagraphs 1.1.2.2, 1.1.2.4.1, 1.1.2.5, 1.1.2.6CDS Capital FundsPeriod of Performance: 1 April 2013 - 30 September 2013 to TRDM IT Services, User Interface Development and Web ServicesParagraphs 1.1.2.2 (including sub paragraphs 1.1.2.2.1 thru 1.1.2.2.9), 1.1.2.4.1 (including sub paragraphs 1.1.2.4.1.1 thru 1.1.2.4.1.8), 1.1.2.5 (including sub paragraphs 1.1.2.5.1 and 1.1.2.5.2), 1.1.2.6 (including sub paragraphs 1.1.2.6.1 thru 1.1.2.6.4)CDS Capital FundsPeriod of Performance: 1 April 2013 - 30 September 2013.

CLIN 0002

The CLIN extended description has changed from TRDM Database Management, System Admin SupportPWS Paragraphs 1.1.1, 1.1.1.3.1, 1.1.1.3.2, 1.1.1.3.3, 1.1.2.1, 1.1.2.3, 1.1.2.4.2, 1.1.2.7, 1.1.2.8 and 1.1.2.9CDS Operations FundsPeriod of Performance: 1 April 2013

- 30 September 2013 to TRDM Database Management, System Admin SupportPWS Paragraphs

1.1.1 (including sub paragraphs 1.1.1.1 thru 1.1.1.3.3), 1.1.2.1 (including sub paragraphs

1.1.2.1.1 thru 1.1.2.1.7), 1.1.2.3 (including sub paragraphs 1.1.2.3.1 thru 1.1.2.3.4), 1.1.2.4.2, 1.1.2.7, 1.1.2.8 (including sub paragraphs 1.1.2.8.1 thru 1.1.2.8.6.6), 1.1.2.9 (including sub paragraphs 1.1.2.9.1 thru 1.1.2.9.2.2)CDS Operations FundsPeriod of Performance: 1 April 2013 - 30 September 2013.

CLIN 0003

The contract type has changed from FFP to LH.

The CLIN extended description has changed from Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2, 1.2.2.3.4, 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5, 1.2.2.6.3, 1.2.2.6.4, 1.2.2.7 and 1.2.2.10OSD RDT&E FundsPeriod of Performance: 1 April 2013 - 30 September 2013 to Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs

1.2.2.2 (including sub paragraphs 1.2.2.2.1 thru 1.2.2.2.4), 1.2.2.3.4 (including sub paragraphs

1.2.2.3.4.1 thru 1.2.2.3.4.9), 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4 (including sub paragraphs 1.2.2.6.4.1 thru 1.2.2.6.4.7), 1.2.2.7, 1.2.2.10 (including sub paragraphs 1.2.2.10.1 and 1.2.2.10.2)OSD RDT&E FundsPeriod of Performance: 1 April 2013 - 30 September 2013.

The pricing detail quantity has decreased by 5.00 from 6.00 to 1.00.

The unit of issue has changed from Months to Lot.

ITEM NO SUPPLIES/SERVICES ESTIMATED

QUANTITY

UNIT UNIT PRICE AMOUNT

0003 1 Lot Labor (RDT&E)

LH

Task 2, DAIS System Design, Configuration Management, Database Management and Web Services

PWS Paragraphs 1.2.2.2 (including sub paragraphs 1.2.2.2.1 thru 1.2.2.2.4),

1.2.2.3.4 (including sub paragraphs 1.2.2.3.4.1 thru 1.2.2.3.4.9), 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4 (including sub paragraphs 1.2.2.6.4.1 thru 1.2.2.6.4.7), 1.2.2.7, 1.2.2.10 (including sub paragraphs 1.2.2.10.1 and 1.2.2.10.2)

OSD RDT&E Funds

Period of Performance: 1 April 2013 - 30 September 2013

FOB: Destination

SIGNAL CODE: A

TOT ESTIMATED PRICE

CEILING PRICE

CLIN 0004

The CLIN extended description has changed from DAIS Test and Evaluation, Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1, 1.2.2.3.4, 1.2.2.4, 1.2.2.4.6, 1.2.2.6.1.1, 1.2.2.6.5, 1.2.2.8 and 1.2.2.9OSD O&M FundsPeriod of Performance: 1 April 2013 - 30 September 2013 to DAIS Test and Evaluation, Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1 (including sub paragraphs 1.2.1.1 thru 1.2.1.2.3), 1.2.2.4 (except 1.2.2.4.3 and 1.2.2.4.5 which are listed under CLIN 003), 1.2.2.6.1.1,

1.2.2.6.5 (including sub paragraphs 1.2.2.6.5.1 and 1.2.2.6.5.2), 1.2.2.8 (including sub paragraphs 1.2.2.8.1 thru 1.2.2.8.8), 1.2.2.9 (including sub paragraphs 1.2.2.9.1 thru 1.2.2.9.5.4)OSD O&M FundsPeriod of Performance: 1 April 2013 - 30 September 2013.

CLIN 0005

The CLIN extended description has changed from TRDM Transition SupportTask One, PWS Paragraphs 1.1.2.10.1 and 1.1.2.10.2CDS Capital FundsPeriod of Performance: 1 April 2013 - 30 September 2013 to TRDM Transition SupportTask One, PWS Paragraphs

1.1.2.10 (including sub paragraphs 1.1.2.10.1 thru 1.1.2.10.2.5)CDS Capital FundsPeriod of

Performance: 1 April 2013 - 30 September 2013.

CLIN 0006

The CLIN extended description has changed from DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11OSD RDT&E FundsPeriod of Performance: 1 April 2013 - 30 September 2013 to DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11 (including sub paragraphs 1.2.2.11.1 thru 1.2.2.11.2)OSD RDT&E FundsPeriod of Performance: 1 April 2013 - 30 September 2013.

UNIT UNIT PRICE AMOUNT

0006 1 Lot Labor (Optional Task Three)

LH

DAIS Transition Support

Task Three, PWS Paragraph 1.2.2.11 (including sub paragraphs 1.2.2.11.1 thru 1.2.2.11.2)

Period of Performance: 1 April 2013 - 30 September 2013

CLIN 1001

Development and Web ServicesParagraphs 1.1.2.2, 1.1.2.4.1, 1.1.2.5, 1.1.2.6CDS Capital FundsPeriod of Performance: 1 October 2013 - 30 September 2014 to TRDM IT Services, User Interface Development and Web ServicesParagraphs 1.1.2.2 (including sub paragraphs 1.1.2.2.1 thru 1.1.2.2.9), 1.1.2.4.1 (including sub paragraphs 1.1.2.4.1.1 thru 1.1.2.4.1.8), 1.1.2.5 thru 1.1.2.6.4)CDS Capital FundsPeriod of Performance: 1 October 2013 - 30 September 2014.

CLIN 1002

System Admin SupportPWS Paragraphs 1.1.1, 1.1.1.3.1, 1.1.1.3.2, 1.1.1.3.3, 1.1.2.1, 1.1.2.3, 1.1.2.4.2, 1.1.2.7, 1.1.2.8 and 1.1.2.9CDS Operations FundsPeriod of Performance: 1 October 2013 - 30 September 2014 to TRDM Database Management, System Admin SupportPWS Paragraphs 1.1.1 (including sub paragraphs 1.1.1.1 thru 1.1.1.3.3), 1.1.2.1 (including sub paragraphs 1.1.2.1.1 thru 1.1.2.1.7), 1.1.2.3 (including sub paragraphs 1.1.2.3.1 thru 1.1.2.3.4), 1.1.2.4.2, 1.1.2.7, 1.1.2.8 (including sub paragraphs 1.1.2.8.1 thru 1.1.2.8.6.6), 1.1.2.9 (including sub paragraphs 1.1.2.9.1 thru 1.1.2.9.2.2)CDS Operations FundsPeriod of Performance: 1 October 2013 - 30 September 2014.

CLIN 1003

The CLIN extended description has changed from Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2, 1.2.2.3.4, 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5, 1.2.2.6.3, 1.2.2.6.4, 1.2.2.7 and 1.2.2.10OSD RDT&E FundsPeriod of Performance: 1 October 2013 - 30 September 2014 to 530612Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2 (including sub paragraphs 1.2.2.2.1 thru 1.2.2.2.4), 1.2.2.3.4 (including sub paragraphs 1.2.2.3.4.1 thru 1.2.2.3.4.9), 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5 (including sub paragraphs

1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4 (including sub paragraphs 1.2.2.6.4.1 thru 1.2.2.6.4.7), 1.2.2.7, 1.2.2.10 (including sub paragraphs 1.2.2.10.1 and 1.2.2.10.2)OSD RDT&E FundsPeriod of Performance:

1 October 2013 - 30 September 2014.

The pricing detail quantity has decreased by 11.00 from 12.00 to 1.00.

UNIT UNIT PRICE AMOUNT

1003 1 Lot OPTION Labor (RDT&E)

LH

530612Task 2, DAIS System Design, Configuration Management, Database Management and Web Services

1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4

Period of Performance: 1 October 2013 - 30 September 2014

CLIN 1004

Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1, 1.2.2.3.4, 1.2.2.4, 1.2.2.4.6, 1.2.2.6.1.1, 1.2.2.6.5, 1.2.2.8 and 1.2.2.9OSD O&M FundsPeriod of Performance: 1 October 2013 - 30 September 2014 to DAIS Test and Evaluation, Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1 (including sub paragraphs 1.2.1.1 thru 1.2.1.2.3), 1.2.2.4 (except 1.2.2.4.3 and 1.2.2.4.5 which are listed under CLIN 003), 1.2.2.6.1.1,

1.2.2.6.5 (including sub paragraphs 1.2.2.6.5.1 and 1.2.2.6.5.2), 1.2.2.8 (including sub

1.2.2.9.5.4)OSD O&M FundsPeriod of Performance: 1 October 2013 - 30 September 2014.

CLIN 1005

One, PWS Paragraphs 1.1.2.10.1 and 1.1.2.10.2CDS Capital FundsPeriod of Performance: 1 October 2013 - 30 September 2014 to TRDM Transition SupportTask One, PWS Paragraphs

Performance: 1 October 2013 - 30 September 2014.

The cost constraint NSP has been deleted.

CLIN 1006

The CLIN extended description has changed from DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11OSD RDT&E FundsPeriod of Performance: 1 October 2013 - 30 September 2014 to DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11 (including sub paragraphs 1.2.2.11.1 thru 1.2.2.11.2)OSD RDT&E FundsPeriod of Performance: 1 October 2013 - 30 September 2014.

The pricing detail quantity has decreased by 11.00 from 12.00 to 1.00.

The cost constraint NSP has been deleted.

UNIT UNIT PRICE AMOUNT

1006 1 Lot OPTION Labor (Optional Task Three)

Period of Performance: 1 October 2013 - 30 September 2014

CLIN 2001

Development and Web ServicesParagraphs 1.1.2.2, 1.1.2.4.1, 1.1.2.5, 1.1.2.6CDS Capital FundsPeriod of Performance: 1 October 2014 - 30 September 2015 to TRDM IT Services, User Interface Development and Web ServicesParagraphs 1.1.2.2 (including sub paragraphs 1.1.2.2.1 thru 1.1.2.2.9), 1.1.2.4.1 (including sub paragraphs 1.1.2.4.1.1 thru 1.1.2.4.1.8), 1.1.2.5 thru 1.1.2.6.4)CDS Capital FundsPeriod of Performance: 1 October 2014 - 30 September 2015.

CLIN 2002

System Admin SupportPWS Paragraphs 1.1.1, 1.1.1.3.1, 1.1.1.3.2, 1.1.1.3.3, 1.1.2.1, 1.1.2.3, 1.1.2.4.2, 1.1.2.7, 1.1.2.8 and 1.1.2.9CDS Operations FundsPeriod of Performance: 1 October 2014 - 30 September 2015 to TRDM Database Management, System Admin SupportPWS Paragraphs 1.1.1 (including sub paragraphs 1.1.1.1 thru 1.1.1.3.3), 1.1.2.1 (including sub paragraphs 1.1.2.1.1 thru 1.1.2.1.7), 1.1.2.3 (including sub paragraphs 1.1.2.3.1 thru 1.1.2.3.4), 1.1.2.4.2, 1.1.2.7, 1.1.2.8 (including sub paragraphs 1.1.2.8.1 thru 1.1.2.8.6.6), 1.1.2.9 (including

October 2014 - 30 September 2015.

CLIN 2003

The CLIN extended description has changed from Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2, 1.2.2.3.4, 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5, 1.2.2.6.3, 1.2.2.6.4, 1.2.2.7 and 1.2.2.10OSD RDT&E FundsPeriod of Performance: 1 October 2014 - 30 September 2015 to Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs

1.2.2.2 (including sub paragraphs 1.2.2.2.1 thru 1.2.2.2.4), 1.2.2.3.4 (including sub paragraphs

1.2.2.3.4.1 thru 1.2.2.3.4.9), 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4 (including sub paragraphs 1.2.2.6.4.1 thru 1.2.2.6.4.7), 1.2.2.7, 1.2.2.10 (including sub paragraphs 1.2.2.10.1 and 1.2.2.10.2)OSD RDT&E FundsPeriod of Performance: 1 October 2014 - 30 September 2015.

UNIT UNIT PRICE AMOUNT

2003 1 Lot OPTION Labor (RDT&E)

LH

1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4

Period of Performance: 1 October 2014 - 30 September 2015

CLIN 2004

Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1, 1.2.2.3.4, 1.2.2.4, 1.2.2.4.6, 1.2.2.6.1.1, 1.2.2.6.5, 1.2.2.8 and 1.2.2.9OSD O&M FundsPeriod of Performance: 1 October 2014 - 30 September 2015 to DAIS Test and Evaluation, Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1 (including sub paragraphs 1.2.1.1 thru 1.2.1.2.3), 1.2.2.4 (except 1.2.2.4.3 and 1.2.2.4.5 which are listed under CLIN 003), 1.2.2.6.1.1,

1.2.2.6.5 (including sub paragraphs 1.2.2.6.5.1 and 1.2.2.6.5.2), 1.2.2.8 (including sub

1.2.2.9.5.4)OSD O&M FundsPeriod of Performance: 1 October 2014 - 30 September 2015.

CLIN 2005

One, PWS Paragraphs 1.1.2.10.1 and 1.1.2.10.2CDS Capital FundsPeriod of Performance: 1 October 2014 - 30 September 2015 to TRDM Transition SupportTask One, PWS Paragraphs

Performance: 1 October 2014 - 30 September 2015.

CLIN 2006

The CLIN extended description has changed from DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11OSD RDT&E FundsPeriod of Performance: 1 October 2014 - 30 September 2015 to DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11 (including sub paragraphs 1.2.2.11.1 thru 1.2.2.11.2)OSD RDT&E FundsPeriod of Performance: 1 October 2014 - 30 September 2015.

UNIT UNIT PRICE AMOUNT

2006 1 Lot OPTION Labor (Optional Task Three)

Period of Performance: 1 October 2014 - 30 September 2015

CLIN 3001

Development and Web ServicesParagraphs 1.1.2.2, 1.1.2.4.1, 1.1.2.5, 1.1.2.6CDS Capital FundsPeriod of Performance: 1 October 2015 - 30 September 2016 to TRDM IT Services, User Interface Development and Web ServicesParagraphs 1.1.2.2 (including sub paragraphs 1.1.2.2.1 thru 1.1.2.2.9), 1.1.2.4.1 (including sub paragraphs 1.1.2.4.1.1 thru 1.1.2.4.1.8), 1.1.2.5 thru 1.1.2.6.4)CDS Capital FundsPeriod of Performance: 1 October 2015 - 30 September 2016.

CLIN 3002

System Admin SupportPWS Paragraphs 1.1.1, 1.1.1.3.1, 1.1.1.3.2, 1.1.1.3.3, 1.1.2.1, 1.1.2.3, 1.1.2.4.2, 1.1.2.7, 1.1.2.8 and 1.1.2.9CDS Operations FundsPeriod of Performance: 1 October 2015 - 30 September 2016 to TRDM Database Management, System Admin SupportPWS Paragraphs 1.1.1 (including sub paragraphs 1.1.1.1 thru 1.1.1.3.3), 1.1.2.1 (including sub paragraphs 1.1.2.1.1 thru 1.1.2.1.7), 1.1.2.3 (including sub paragraphs 1.1.2.3.1 thru 1.1.2.3.4), 1.1.2.4.2, 1.1.2.7, 1.1.2.8 (including sub paragraphs 1.1.2.8.1 thru 1.1.2.8.6.6), 1.1.2.9 (including

October 2015 - 30 September 2016.

CLIN 3003

The CLIN extended description has changed from Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2, 1.2.2.3.4, 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5, 1.2.2.6.3, 1.2.2.6.4, 1.2.2.7 and 1.2.2.10OSD RDT&E FundsPeriod of Performance: 1 October 2015 - 30 September 2016 to Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs

1.2.2.2 (including sub paragraphs 1.2.2.2.1 thru 1.2.2.2.4), 1.2.2.3.4 (including sub paragraphs

1.2.2.3.4.1 thru 1.2.2.3.4.9), 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4 (including sub paragraphs 1.2.2.6.4.1 thru 1.2.2.6.4.7), 1.2.2.7, 1.2.2.10 (including sub paragraphs 1.2.2.10.1 and 1.2.2.10.2)OSD RDT&E FundsPeriod of Performance: 1 October 2015 - 30 September 2016.

UNIT UNIT PRICE AMOUNT

3003 1 Lot OPTION Labor (RDT&E)

LH

1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4

Period of Performance: 1 October 2015 - 30 September 2016

CLIN 3004

Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1, 1.2.2.3.4, 1.2.2.4, 1.2.2.4.6, 1.2.2.6.1.1, 1.2.2.6.5, 1.2.2.8 and 1.2.2.9OSD O&M FundsPeriod of Performance: 1 October 2015 - 30 September 2016 to DAIS Test and Evaluation, Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1 (including sub paragraphs 1.2.1.1 thru 1.2.1.2.3), 1.2.2.4 (except 1.2.2.4.3 and 1.2.2.4.5 which are listed under CLIN 003), 1.2.2.6.1.1,

1.2.2.6.5 (including sub paragraphs 1.2.2.6.5.1 and 1.2.2.6.5.2), 1.2.2.8 (including sub

1.2.2.9.5.4)OSD O&M FundsPeriod of Performance: 1 October 2015 - 30 September 2016.

CLIN 3005

One, PWS Paragraphs 1.1.2.10.1 and 1.1.2.10.2CDS Capital FundsPeriod of Performance: 1 October 2015 - 30 September 2016 to TRDM Transition SupportTask One, PWS Paragraphs

Performance: 1 October 2015 - 30 September 2016.

CLIN 3006

The CLIN extended description has changed from DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11OSD RDT&E FundsPeriod of Performance: 1 October 2015 - 30 September 2016 to DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11 (including sub paragraphs 1.2.2.11.1 thru 1.2.2.11.2)OSD RDT&E FundsPeriod of Performance: 1 October 2015 - 30 September 2016.

UNIT UNIT PRICE AMOUNT

3006 1 Lot OPTION Labor (Optional Task Three)

Period of Performance: 1 October 2015 - 30 September 2016

CLIN 4001

Development and Web ServicesParagraphs 1.1.2.2, 1.1.2.4.1, 1.1.2.5, 1.1.2.6CDS Capital FundsPeriod of Performance: 1 October 2016 - 30 September 2017 to TRDM IT Services, User Interface Development and Web ServicesParagraphs 1.1.2.2 (including sub paragraphs 1.1.2.2.1 thru 1.1.2.2.9), 1.1.2.4.1 (including sub paragraphs 1.1.2.4.1.1 thru 1.1.2.4.1.8), 1.1.2.5 thru 1.1.2.6.4)CDS Capital FundsPeriod of Performance: 1 October 2016 - 30 September 2017.

CLIN 4002

System Admin SupportPWS Paragraphs 1.1.1, 1.1.1.3.1, 1.1.1.3.2, 1.1.1.3.3, 1.1.2.1, 1.1.2.3, 1.1.2.4.2, 1.1.2.7, 1.1.2.8 and 1.1.2.9CDS Operations FundsPeriod of Performance: 1 October 2016 - 30 September 2017 to TRDM Database Management, System Admin SupportPWS Paragraphs 1.1.1 (including sub paragraphs 1.1.1.1 thru 1.1.1.3.3), 1.1.2.1 (including sub paragraphs 1.1.2.1.1 thru 1.1.2.1.7), 1.1.2.3 (including sub paragraphs 1.1.2.3.1 thru 1.1.2.3.4), 1.1.2.4.2, 1.1.2.7, 1.1.2.8 (including sub paragraphs 1.1.2.8.1 thru 1.1.2.8.6.6), 1.1.2.9 (including

October 2016 - 30 September 2017.

CLIN 4003

The CLIN extended description has changed from Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2, 1.2.2.3.4, 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5, 1.2.2.6.3, 1.2.2.6.4, 1.2.2.7 and 1.2.2.10OSD RDT&E FundsPeriod of Performance: 1 October 2016 - 30 September 2017 to Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs

1.2.2.2 (including sub paragraphs 1.2.2.2.1 thru 1.2.2.2.4), 1.2.2.3.4 (including sub paragraphs

1.2.2.3.4.1 thru 1.2.2.3.4.9), 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4 (including sub paragraphs 1.2.2.6.4.1 thru 1.2.2.6.4.7), 1.2.2.7, 1.2.2.10 (including sub paragraphs 1.2.2.10.1 and 1.2.2.10.2)OSD RDT&E FundsPeriod of Performance: 1 October 2016 - 30 September 2017.

UNIT UNIT PRICE AMOUNT

4003 1 Lot OPTION Labor (RDT&E)

LH

1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4

Period of Performance: 1 October 2016 - 30 September 2017

CLIN 4004

Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1, 1.2.2.3.4, 1.2.2.4, 1.2.2.4.6, 1.2.2.6.1.1, 1.2.2.6.5, 1.2.2.8 and 1.2.2.9OSD O&M FundsPeriod of Performance: 1 October 2016 - 30 September 2017 to DAIS Test and Evaluation, Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1 (including sub paragraphs 1.2.1.1 thru 1.2.1.2.3), 1.2.2.4 (except 1.2.2.4.3 and 1.2.2.4.5 which are listed under CLIN 003), 1.2.2.6.1.1,

1.2.2.6.5 (including sub paragraphs 1.2.2.6.5.1 and 1.2.2.6.5.2), 1.2.2.8 (including sub

1.2.2.9.5.4)OSD O&M FundsPeriod of Performance: 1 October 2016 - 30 September 2017.

CLIN 4005

One, PWS Paragraphs 1.1.2.10.1 and 1.1.2.10.2CDS Capital FundsPeriod of Performance: 1 October 2016 - 30 September 2017 to TRDM Transition SupportTask One, PWS Paragraphs

Performance: 1 October 2016 - 30 September 2017.

CLIN 4006

The CLIN extended description has changed from DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11OSD RDT&E FundsPeriod of Performance: 1 October 2016 - 30 September 2017 to DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11 (including sub paragraphs 1.2.2.11.1 thru 1.2.2.11.2)OSD RDT&E FundsPeriod of Performance: 1 October 2016 - 30 September 2017.

UNIT UNIT PRICE AMOUNT

4006 1 Lot OPTION Labor (Optional Task Three)

Period of Performance: 1 October 2016 - 30 September 2017

CLIN 5001

Development and Web ServicesParagraphs 1.1.2.2, 1.1.2.4.1, 1.1.2.5, 1.1.2.6CDS Capital FundsPeriod of Performance: 1 October 2017 - 31 March 2018 to TRDM IT Services, User Interface Development and Web ServicesParagraphs 1.1.2.2 (including sub paragraphs 1.1.2.2.1 thru 1.1.2.2.9), 1.1.2.4.1 (including sub paragraphs 1.1.2.4.1.1 thru 1.1.2.4.1.8), 1.1.2.5 thru 1.1.2.6.4)CDS Capital FundsPeriod of Performance: 1 October 2017 - 31 March 2018.

CLIN 5002

System Admin SupportPWS Paragraphs 1.1.1, 1.1.1.3.1, 1.1.1.3.2, 1.1.1.3.3, 1.1.2.1, 1.1.2.3, 1.1.2.4.2, 1.1.2.7, 1.1.2.8 and 1.1.2.9CDS Operations FundsPeriod of Performance: 1 October 2017 - 31 March 2018 to TRDM Database Management, System Admin SupportPWS Paragraphs 1.1.1 (including sub paragraphs 1.1.1.1 thru 1.1.1.3.3), 1.1.2.1 (including sub paragraphs 1.1.2.1.1 thru 1.1.2.1.7), 1.1.2.3 (including sub paragraphs 1.1.2.3.1 thru 1.1.2.3.4), 1.1.2.4.2, 1.1.2.7, 1.1.2.8 (including sub paragraphs 1.1.2.8.1 thru 1.1.2.8.6.6), 1.1.2.9 (including

October 2017 - 31 March 2018.

CLIN 5003

The CLIN extended description has changed from Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2, 1.2.2.3.4, 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5, 1.2.2.6.3, 1.2.2.6.4, 1.2.2.7 and 1.2.2.10OSD RDT&E FundsPeriod of Performance: 1 October 2017 - 31 March 2018 to Task 2, DAIS System Design, Configuration Management, Database Management and Web Services PWS Paragraphs 1.2.2.2 (including sub paragraphs 1.2.2.2.1 thru 1.2.2.2.4), 1.2.2.3.4 (including sub paragraphs

1.2.2.3.4.1 thru 1.2.2.3.4.9), 1.2.2.4.3, 1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4 (including sub paragraphs 1.2.2.6.4.1 thru 1.2.2.6.4.7), 1.2.2.7, 1.2.2.10 (including sub paragraphs 1.2.2.10.1 and 1.2.2.10.2)OSD RDT&E FundsPeriod of Performance: 1 October 2017 - 31 March 2018.

UNIT UNIT PRICE AMOUNT

5003 1 Lot OPTION Labor (RDT&E)

LH

1.2.2.4.5, 1.2.2.5 (including sub paragraphs 1.2.2.5.1 thru 1.2.2.5.8), 1.2.2.6.3 (including sub paragraphs 1.2.2.6.3.1, 1.2.2.6.3.2, and 1.2.2.6.3.4), 1.2.2.6.4

Period of Performance: 1 October 2017 - 31 March 2018

CLIN 5004

Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1, 1.2.2.3.4, 1.2.2.4, 1.2.2.4.6, 1.2.2.6.1.1, 1.2.2.6.5, 1.2.2.8 and 1.2.2.9OSD O&M FundsPeriod of Performance: 1 October 2017 - 31 March 2018 to DAIS Test and Evaluation, Operations, Life Cycle Management, SecurityTask 2, PWS Paragraphs 1.2.1 (including sub paragraphs 1.2.1.1 thru 1.2.1.2.3), 1.2.2.4 (except 1.2.2.4.3 and 1.2.2.4.5 which are listed under CLIN 003), 1.2.2.6.1.1,

1.2.2.6.5 (including sub paragraphs 1.2.2.6.5.1 and 1.2.2.6.5.2), 1.2.2.8 (including sub

1.2.2.9.5.4)OSD O&M FundsPeriod of Performance: 1 October 2017 - 31 March 2018.

CLIN 5005

One, PWS Paragraphs 1.1.2.10.1 and 1.1.2.10.2CDS Capital FundsPeriod of Performance: 1 October 2017 - 31 March 2018 to TRDM Transition SupportTask One, PWS Paragraphs 1.1.2.10 (including sub paragraphs 1.1.2.10.1 thru 1.1.2.10.2.5)CDS Capital FundsPeriod of Performance:

1 October 2017 - 31 March 2018.

CLIN 5006

The CLIN extended description has changed from DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11OSD RDT&E FundsPeriod of Performance: 1 October 2017 - 31 March 2018 to DAIS Transition SupportTask Three, PWS Paragraph 1.2.2.11 (including sub paragraphs 1.2.2.11.1 thru 1.2.2.11.2)OSD RDT&E FundsPeriod of Performance: 1 October 2017 - 31 March 2018.

UNIT UNIT PRICE AMOUNT

5006 1 Lot OPTION Labor (Optional Task Three)

Period of Performance: 1 October 2017 - 31 March 2018

SECTION C - DESCRIPTIONS AND SPECIFICATIONS

The following have been modified:

PERFORMANCE WORK STATEMENT

USTRANSCOM REFERENCE DATA MANAGEMENT

and

I&E DATA ANALYTICS AND INTEGRATION SUPPORT PLATFORM

SUPPORT TO

UNITED STATES TRANSPORTATION COMMAND

COMMAND, CONTROL, COMMUNICATIONS AND COMPUTER SYSTEMS DIRECTORATE

PERFORMANCE WORK STATEMENT (PWS)

10 Jan 2013

1. Background

TRDM is the USTRANSCOM tool used to manage enterprise reference data. The tool is managed by the Government and maintained and modernized, as necessary, by the Contractor. TRDM includes data from the former Table Management Distribution System (TMDS), which managed Air Mobility Command (AMC) reference data.

The majority of this data has since transitioned to TRDM and remaining tables and interfaces associated with TMDS are being migrated to TRDM. The reference data management process is consistent with the Information Reference Model (IRM) manual as published by USTRANSCOM/J6. The TRDM Program Management Office (PMO) is responsible for providing and interpreting USTRANSCOM policy as it applies to TRDM.

This contract will combine the maintenance of the reference tables, design and implementation of new capabilities, to include the expansion of the Real Property Unique Identifier Registry (RPUIR) capability to become the information management system, dubbed the Data Analytics and Integration Support (DAIS) platform, supporting OSD (I&E) Business Enterprise Integration office Real Property Inventory Reporting (RPIR) and Enterprise Energy Information Management (EEIM) requirements.

In FY2003, the Installations & Environment (I&E) Domain partnered with the Military Services, Defense Agencies, and other Business Management Modernization Program (BMMP) Business Mission Areas (BMAs) to transform or reengineer business processes for the accountability of real property. The goal was, and still is, the availability of reliable, timely, and useful real property asset information to support functional analysis and decision making as well as financial reporting. Inter-Agency and Cross-Service work groups were established to identify the data elements and to analyze and resolve process issues. The results were approved in January 2005 as the RPIR document. The long term goal is to expand the current functions of the RPUIR by incorporating the full Real Property Information Model (RPIM). Real Property Unique Identifiers (RPUIDs) will continue to be implemented for the nearly 1 million global site and real property assets and the DAIS system will continue to act as the centralized data source for RPUIDs both for initial assignment of new RPUIDs and for lookup of existing RPUIDs.

The DUSD (I&E) convened a working group to standardize energy information and business processes utilizing existing enterprise information to the extent possible. The standard data elements that the working group developed became the EEIM model. As incorporated within the DAIS System, EEIM will provide net-centric energy data access services and an energy data warehouse that will provide a consolidated view of timely, reliable energy information for use in measuring, managing and reporting DoD energy consumption, conservation, and renewable energy production information. DoD’s facility energy vision is to use integrated processes and a standard data structure to collect facility energy consumption, renewable energy generation, and energy efficiency project data.

This integrated information structure will facilitate trend analysis, performance comparison, and efficiency improvement across facilities and DoD Components.

The Contractor shall provide continuing on-site support services contributing directly to the management of reference data for USTRANSCOM, its Transportation Component Commands: AMC, Military Sealift Command (MSC), Military Surface Deployment and Distribution Command (SDDC), and other Department of Defense (DoD) communities. DoD is subject to extensive energy reporting requirements that impose a growing burden on DoD personnel to collect, analyze, package, and transmit energy data. DoD currently does not have standardized enterprise facility energy information, nor does it have enterprise-wide information technology systems to support facility energy management. This lack of standardization requires energy managers and other personnel to manually collect, transform, and reformat data to meet separate data calls. This highly inefficient atmosphere leaves energy managers with little time to manage facility energy consumption, or to focus on ways to improve facility energy efficiency.

1.1. TRDM

The scope of TRDM requires the Contractor to perform specialized systems engineering and technical support of TRDM and distribution of the TRDM-maintained data. TRDM provides a single source of enterprise reference data

Deleted: 27 Nov

Deleted: 2012 for enhancing command and control (C2), transportation, logistics, deployment, and financial systems’ reference data management and functional data collection. The Contractor is required to perform requirements analysis, functional data collection, command reference data management to support data validation across system interfaces, reference data distribution implementation, fielding, planning, integrated release scheduling, system interoperability testing (SIT) support, integrated test plan documentation, and reference data distribution.

TRDM consists of approximately 2,500 database tables, with data from over 800 Government and commercial reference data sources. TRDM has a system presence on both the classified and unclassified networks. The data is stored within an Oracle platform. Web users may access data through a custom user interface. There are currently over 2,700 TRDM users and approximately 50 unique system interfaces with an average of 4 new systems interfacing with TRDM yearly. There are approximately 250 requirements for reference data generated annually;

each requirement may include one or more sub-requirements. Requirements include requests to manage new reference data, requests for changes to existing reference data, and requests for new or updated views, filters, or web services to deliver data. In accordance with FAR Part 27.401-1 and DFARS 227-7103, DFARS Part 252.227-7013 and 252.227-7014, the Government acquires unlimited rights in all technical data and computer software developed by the contractor pursuant to this contract. No portion of this PWS should be considered or interpreted as being funded except exclusively by the Government. All systems and component parts shall be delivered to the Government with correspondant “unlimited” data rights.

1.1.1. Contract Management

1.1.1.1. This task consists of functional activities relating to administration and management of this effort. The Contractor shall provide program management of Contractor personnel performing tasks in this order. The Contractor shall designate a principal point of contact for technical issues. A DRAFT contract management plan shall be provided to the Government fifteen (15) business days after the award of the contract with the final version being provided to the Contracting Officer Representative (COR) fifteen (15) business days after Government approval of the DRAFT.

Deliverable: DRAFT Contract Management Plan delivered to COR fifteen (15) business days after contract award with the final version being provided to the Contracting Officer Representative (COR) fifteen (15) business days after Government approval of the DRAFT.

1.1.1.2. The Contractor shall schedule and attend weekly progress reviews with the COR and provide verbal updates on the status of projects being worked.

1.1.1.3. Status Reports.

1.1.1.3.1. Monthly Cost/Status and Resource Utilization Reports.

The Contractor shall provide the COR with a monthly cost/status summary and resource utilization report, separate from In Progress Review (IPR) materials that details the specifics of the work performed. This cost/status summary and resource utilization report should be delivered to the COR no later than the 10th day of the following month for the previous month’s activities. The monthly cost/status report shall summarize costs, status, progress, and recommendations for project areas being undertaken under this contract. Status reports will provide specific labor hours/costs by major project areas.

Deliverable: Monthly Cost/Status and Resource Utilization Report delivered to the COR no later than the 10th day of the following month.

1.1.1.3.2. Weekly Activities Report (WAR).

The Contractor shall provide a WAR detailing significant events to the COR. Significant events may include cost, schedule, or performance impacts in meeting the requirements of the tasks in this PWS. This report will be given to the COR by 1200 every Wednesday in a Word document format via email.

Deliverable: WAR provided to COR by 1200 every Wednesday in a Word document format via email.

1.1.1.3.3. In Progress Review (IPR).

The Contractor shall meet with the Functional manager/COR semi-annually to discuss any problems with current tasks, assignment of future tasks, and to get Government decisions or guidance necessary to facilitate or improve existing processes. The Contractor shall deliver IPR minutes, with a copy of the presentation slides. The slides must also be presented to the COR no later than three (3) business days prior to the IPR. At a minimum, the minutes shall reflect a record of activity, decisions made, date, location, and attendees. IPR minutes will be delivered to the COR within five (5) business days after the IPR.

Deliverable: Semi-annual IPR Slides three (3) business days prior to IPR and meeting minutes five (5) business days after IPR.

1.1.2. TRDM Information Technology (IT) Services.

1.1.2.1. TRDM-Database Management.

1.1.2.1.1. The Contractor shall be responsible for the administration and maintenance of the TRDM database on both the classified and unclassified networks and work with designated USTRANSCOM/J6 support organizations.

The Contractor shall monitor the database performance to proactively identify and resolve performance issues. The Contractor shall ensure appropriate auditing functions are enabled to capture all pertinent information regarding all database transactions. The Contractor shall update and maintain all necessary documentation for the administration and management of the reference data repository.

1.1.2.1.2. The Contractor shall provide and maintain logical and physical database models in support of this effort.

Deliverable: Provide updates to the logical and physical database models to the COR.

1.1.2.1.3. The Contractor shall be responsible for the generation of the associated architecture products to support the Information Support Plan (ISP) or Tailored ISP (TISP) and DoD Information Assurance Certification and Accreditation Process (DIACAP) process. These products will require updates throughout the duration of the contract period as system changes occur. The Contractor shall assist with the mapping of reference data to any conceptual business models and enterprise-level logical data models.

Deliverable: Provide and update the ISP and TISP, along with required architecture documentation relating to the DIACAP process.

1.1.2.1.4. The database and operating system shall incorporate appropriate security mechanisms that allow for the assignment of permissions and roles to control database access. The Contractor shall be responsible for the setup and administration of USERIDs, passwords, permissions, and roles (and/or other appropriate security techniques) assigned to users of the repository. The Contractor shall be responsible to ensure the appropriate backup and recovery techniques are in place to protect and secure the reference data. All personnel working on this task shall be Information Assurance Workforce Improvement Program (IAWIP) level IAT-II (or better) compliant.

1.1.2.1.5. In addition, the Contractor shall maintain the database to provide read only capabilities, such as Open Database Connectivity (ODBC), or similar functionality for access to the data.

1.1.2.1.6. The Contractor shall maintain the ability to pull metrics of which customers are using which tables and the frequency of use.

1.1.2.1.7. All data identified for the DoD Metadata Repository (DMR) shall have clearly-defined metadata and shall be Extensible Mark Up Language (XML)-tagged. This data shall be uploaded and maintained in the DoD Metadata and XML Registries to support the DoD Net-Centric Data Strategy for visibility, understanding, and discovery of data. The Contractor shall perform these duties in conjunction with DoD Net-Centric goals

Deleted: at contract award and as requested thereafter.

(http://metadata.dod.mil/mdr/ns/ces/techguide/net_centric_data_strategy_ncds_goals.html) and the USTRANSCOM Corporate Services Vision (CSV).

1.1.2.2. TRDM – Reference Data Collection and Data Loads

The Contractor shall perform actions necessary to support the expansion of the reference data management program within USTRANSCOM supporting the collection and management of authoritative and derived reference data.

When new or additional reference data is added to the TRDM database, data tables/fields must be modeled, developed, and implemented. This is an ongoing effort as new reference data is constantly being identified to manage for TRDM.

1.1.2.2.1. The Contractor shall work with the functional community and appropriate data vendors to identify and define potential reference data sources that could be consumed by TRDM and redistributed to the enterprise.

1.1.2.2.2. The Contractor shall communicate with organizations and points of contact outside of DoD to obtain essential USTRANSCOM reference data (examples are: DTEB.org and CalPoly.edu).

1.1.2.2.3. The Contractor shall model the table structures for new reference data and provide the model to the Enterprise Data Office (EDO).

1.1.2.2.4. Once coordinated, the Contractor will work with the authoritative source to define the method of obtaining the data within TRDM and design the appropriate interface to consume the data and populate the database.

1.1.2.2.5. The Contractor shall create tables populated with commercial and Government reference data, maintain the data and make updates to the data. Authoritative data shall be managed by the data stewards per agreements made with each authoritative source as to the frequency of updates for reference data.

1.1.2.2.6. The Contractor shall provide technical data stewards to initially acquire and perform any required data analysis in support of reference data updates, to include active participation in the USTRANSCOM data forums as requested by the COR.

1.1.2.2.7. The Contractor shall notify the TCC data offices via email of new data offerings as it becomes available.

1.1.2.2.8. The Contractor shall forward reference table changes to the TCC data offices and the change request submitter via email.

1.1.2.2.9. The Contractor shall support critical exercises (e.g. Terminal Fury, Dragon Reach, etc.) by preparing specific table updates for distribution, while ensuring interface partners and TRDM users are not impacted by these exercises. These exercises occur on a quarterly basis.

1.1.2.3. TRDM – Data Maintenance

1.1.2.3.1. The Contractor shall provide data stewards to maintain correctness and currency of the reference data.

The repository currently contains over 2,500 tables each of which has associated data and meta-data which must be updated as defined by the functional community. The Contractor shall work with data sources to ensure this data is current and accurate. Currently, TRDM has over 800 Government and commercial data sources.

1.1.2.3.2. The Contractor shall track the use of data labeled as limited distribution and ensure that the data is not being distributed to more than the allotted number of users or systems. In the event the data is being distributed to more than the allotted number of users, the Contractor shall notify the COR for further review.

1.1.2.3.3. The Contractor shall migrate the approximately 500 remaining legacy TMDS tables from the legacy database to the current TRDM database. This effort will involve the modeling, creation, and population of these tables within TRDM.

Formatted: Font: Times New Roman

Formatted: Font: Times New Roman

This work under paragraph 1.1.2.3.3 is expected to be completed in FY13 and further maintenance of these tables will fall under duties described in Section 1.1.2.3.1.

1.1.2.3.4. The Contractor shall comply with existing IA procedures to manually move data back and forth between unclassified and classified sources. The Contractor shall ensure that data is maintained, updated, and synchronized in both the classified and unclassified versions of TRDM.

1.1.2.4. TRDM - User Interface Development

1.1.2.4.1. The Contractor shall maintain the web site for the TRDM data using tools that meet DoD requirements, and develop web capabilities to include, but not limited to additional views, queries, capabilities, and functionality as detailed below.

Deliverable: Source code for the TRDM website on CD/DVD media to be provided annually to the COR NLT 30 September of each year for the life of the contract.

1.1.2.4.1.1. The Contractor shall perform actions necessary to ensure the repository and associated products comply with the USTRANSCOM data policy.

1.1.2.4.1.2. The Contractor shall ensure appropriate DoD security mechanisms are in place to protect the reference data.

1.1.2.4.1.3. The Contractor shall maintain, add, change, and delete necessary views or displays of data on the TRDM web-based interface.

1.1.2.4.1.4. The Contractor shall maintain an inquiry capability for users to pull and filter all reference data via the TRDM web interface. The Contractor shall build additional search capabilities as requested by the customer and discovery of all reference data via the TRDM website along with the ability for the consumer to extract the requested data in a variety of formats. The Contractor shall support the Government in defining terms and conditions that define the extract formats for use by consumers.

1.1.2.4.1.5. The Contractor shall update and build data views and filters to accommodate general customer needs.

1.1.2.4.1.6. The Contractor shall maintain the capability to identify and calculate the total number of users accessing TRDM data via the web interface and any email subscribers to TRDM tables.

1.1.2.4.1.7. The Contractor shall ensure all necessary disclaimer and copyright warnings are appropriately displayed on the TRDM website.

1.1.2.4.1.8. The Contractor shall build and maintain the capability for web users to submit new requirements for data changes, additions, updates, etc. directly on the web interface. Once submitted, the Contractor shall forward these requirements to the Program Manager’s Office where they will flow through the normal Requirements Review Board (RRB) process.

1.1.2.4.2. The Contractor shall create and maintain a user guide for the TRDM web interface detailing basic functionality such us searching, navigating, subscribing, data stewardship, etc. A draft user guide will be delivered to the Government in a PDF format by 30 Sep 2013. Once approved by the Government, this user guide will be updated thereafter as significant changes are made to the web interface.

Deliverable: Draft TRDM Web Interface User’s Guide in PDF format delivered to the Government by 30 Sep 2013 and maintained as necessary thereafter.

1.1.2.5. TRDM – Data Distribution

Formatted: Font: Times New Roman

Deleted: .

Deleted:

1.1.2.5.1. The Contractor shall maintain the data distribution application that will be used in conjunction with the user interface application to direct users’ changes to the appropriate systems. Expansion of distribution beyond current distribution may include sending reference data updates, as required, to other systems. The Contractor shall maintain and update a Relational Database Management System (RDBMS) that contains all managed reference tables and information associated with those tables. Reference table data must be viewable and downloadable for DoD and Government users using the security measures currently in place by USTRANSCOM (i.e. Common Access Card (CAC) login, Public Key Infrastructure (PKI) enabled).

1.1.2.5.2. The Contractor shall work with other systems’ Contractor representatives with operational expertise to perform an in-depth requirements analysis. This analysis will lead to a technically achievable interface to present operational and technical alternatives to the COR for discussion and decisions. The Contractor shall assist in defining and documenting the pertinent data elements, data flow, and business and implementation rules necessary to assure a compatible interface between these two systems based on the interface requirements. Upon COR approval of interface solutions, the Contractor shall perform the implementation through the software development, testing, and fielding cycle. Based on individual program requirements, multiple test baselines will require support.

Additionally, as each interface is fielded, new requirements and/or changes to the approved solution will occur.

Changes to these solutions must also be tracked through the fielding and maintenance cycle. Updates to these documents and changes to existing interface structures should be noted in the WAR. Existing interface documentation is reviewed annually or as needed if changes are made throughout the year. There are approximately thirty (30) existing interface agreements in place and the program anticipates a requirement of an additional average of five (5) new interfacing systems each year.

Deliverable: Create or update interface documentation to be delivered to the COR as necessary.

1.1.2.6. TRDM – Web Services.

1.1.2.6.1. The Contractor shall build and maintain web services to distribute reference data. These web services shall be built using tools and methodology that is consistent with the USTRANSCOM Enterprise Architecture as…