Attachment_010_SEMA_Appendix_F_PWS

W58RG-15-R-0045 APPENDIX F TO SEMA PWS

Fixed Wing Fleet Information Tracker (FFIT)

Contractor training for FFIT shall be accomplished at a location determined by the Contractor.

Location should be sufficient to comfortably allow for 25 participants (20 contractor and up to 5 Government representatives), have screen available to support training presentation, internet connectivity for 25 computer drops, and 20 computers needed by the contractor to accomplish training (Government will provide 5 Government representative computers). Government will provide one time training to a class not to exceed 20 contractor key and training personnel over a 5 day period (40 hours). Government provided familiarization/orientation training is designed to provide overall knowledge/information on: database functional capabilities, required data to be entered for maintenance and supply actions, and reports available and reports that support the logistics metrics. Immediately following contract award the Contractor shall contact the Government to establish and being exchange of technical information needed by both the Government and the Contractor.

Training Government provided familiarization/orientation training is designed to provide overall knowledge/information on: database functional capabilities, required data to be entered for maintenance and supply actions, and reports available and reports that support the logistics metrics. The types and forms of data to be entered will be detailed during the provided familiarization/orientation training. Government provided familiarization/orientation training is based on a train the trainer approach with subsequent training to the personnel entering data to be provided by the contractor. Upon completion of the familiarization/orientation training, the contractor shall then be required to provide internal initial and subsequent recurring familiarization/orientation training for their personnel on an as needed, as required basis.

Training will be scenario driven and provide for an End to End training of specific task within a scenario with emphasis on FW requirements.

FFIT Access Access to FFIT will be controlled by the FW FFIT System Administrator. The following is a System Access Request (SAR) that shall be submitted after contract award and prior to training.

FFIT System Access Request

Administration.

The designated FW Government Administrator will process all requests for access and submit the request through the proper channels for approval.

Authorization.

The FW PO, System Support Division and Security Office, will grant authorized access and the use of the FFIT database as required. Submit FFIT access requests by email to the POCs listed below. An Access Request form is located below this document. The Access Request must be completed and specify the need and purpose for access. An electronic copy of the Access Request form may be obtained from the POC specified below. The level of access required will be determined by the PO, Logistics and the Security Office, based on the need and purpose for access. All approved requests will be processed through the FW Logistics and the Security Office and kept on file by the FFIT Database Administrator. Once an Access Request is processed and access has been granted, an email will be sent to the requestor from the administrator with a temporary “Password” and login instructions. Contact information is available in the table below.

Organization Point of Contact Email Telephone

Number Fixed Wing Steve Clark steven.d.clark36.civ@mail.mil (256) 955-0070 Fixed Wing Steve Locascio steven.m.locascio.ctr@mail.mil (256) 955-3297

Access.

Access to the FFIT website is granted to authorized users who have a recognized need-to-know and are limited to specific defined, documented, and approved applications and levels of access rights and privileges. Individual access to the database will be controlled by Internet ID and password protection. Protection will be provided by the use of Cold Fusion application software.

Passwords are case-sensitive and must contain at least 10 characters, using a mix of uppercase letters, lower case letters, #’s and special characters. Only the database administrator can recreate passwords in the event that they are forgotten.

In order to access the FFIT site on the Internet, each user must be authorized by the database administrator. After being granted authorization, the user must login each time the database is accessed. Do not allow others to use your “User ID” and “Password” to access the database. As the user accesses the database, a log, which includes the user’s ID, is created for each page visited.

Fixed Wing Fleet Information Tracker (FFIT) System Access Request (SAR) Form

USER NAME INCLUDING MIDDLE NAME: DATE

OFFICE SYMBOL (GOV)/COMPANY NAME (KTR):

EMAIL: OFFICE PHONE:

SECURITY CLEARANCE: DATE GRANTED:

SECURITY OFFICER: PHONE:

PURPOSE/TYPE OF SUPPORT TO LDMS (include LDMS Govt. POC):

I hereby request a login to enter the FFIT. I understand a User ID and Password will be assigned for me. I also understand that I will be required to complete a Terms Of Service For Repair Center – SAAS Edition before I am authorized access. I also understand that I AM RESPONSIBLE FOR THE PROTECTION OF THIS ACCOUNT AND WILL NOT DIVULGE MY ACCOUNT INFORMATION TO ANY PERSON. I understand I should report to the FFIT System Administrator, any problem I may encounter in the use of my account or any misuse of account information by other persons, which may occur in my presence.

When I no longer require the need for access to FFIT, I WILL PERSONALLY contact the System Administrator to terminate my login ID.

USER SIGNATURE DATE

DO NOT WRITE BELOW THIS LINE

SYSTEM SUPPORT DIVISION

APPROVAL:

NAME: Don Chaney

OFFICE SYMBOL:

SFAE-AV-FW

PHONE:

(256) 842-8102

I verify that the above named individual (government /contractor ) meets the requirement to have access to FFIT.

I further agree to notify the System Administrator when support from this individual ceases.

SIGNATURE: DATE:

APPROVING OFFICIAL

ACCESS TO FFIT IS Approved Disapproved . USER HAS ACCESS TO FOLLOWING RIGHTS:

General: Active Track Admin Query Allow Personalization

Report: View

Inventory: View Update Create Delete Admin

Inventory Stock: Receive Issue WSL

Configuration: View Update Create Delete FSR Insert

Contact: View Update Create Delete

Maintenance: View Update Create Delete Status View Close

Maintenance Accounting: View Update

Maintenance Analysis: View Update

Modification: View Update Create Delete

Shipping: View Update Create Delete

Visibility: View Update Create Delete

Reliability: View Update Close Admin

RepairEDI: View Update

Visibility Live Fire: View Update Create Delete

NAME: DATE: Expiration

FFIT ADMINISTRATOR

General overview of FFIT

FFIT is a Government provided data base that will be populated by the contractor and contain Government Owned Data. FFIT will provide a near real-time web based data. FFIT will have the ability to query various data elements and mine data. FFIT allows for monitoring and access to:

Maintenance planning and management (Aircraft and Support Equipment) Supply support As-Managed/As-Maintained aircraft configurations Readiness data/system status Asset visibility Measure and monitor contractor performance relative to performance metrics

FFIT is based upon RepairData (http://www.repairdata.com/) and will be operating in a “.mil” environment and operating under a military Certificate of Networthiness (CERT#201417964). FFIT is delivered as a web service, which means that no proprietary software shall be installed on contractor computers. Contractor shall have an Internet connection and a browser to operate.

The following represents the full capabilities of the RepairData Program along with information from the RepairData website are for information purposes only. The training as described above will provide for specific entries, actions need to maintain the database.

FFIT contains standard logistics and information management processes for all aspects of operational systems, including:

» asset visibility, control, and distribution » equipment configuration, upgrade, and maintenance » inventory shipping, tracking, receiving, and reporting » legacy configuration control, calibration status, and failure analysis » well-designed on line reporting supporting all operational aspects

FFIT will provide messaging services ensuring that notifications about maintenance actions, inventory levels, and received materials are instantly available to the contractor.

Maintenance The Maintenance core module of FFIT provides near real-time and legacy maintenance management.

The module performs creation, deletion, update, and reporting of maintenance actions, data and repair time collection, failure analysis and logistic analysis of each maintenance action.

This module automatically provides updates to System status when a major system has a maintenance action either opened or closed. This module also provides automatic updates to the “As-Managed/As- Maintained” Configuration when one serialized configuration tracked item is removed during maintenance and another is installed in its place.

An Item is tracked on the System Status screen. The system status is updated to reflect that it is having maintenance with a one click reference to the maintenance record, modifications required and reliability failure analysis.

Some of the information tracked:

» Maintenance Action Number » Initial Condition Code » Acceptance Test Performed » Item and Serial Number » Acceptance Test Tech, Date/Time » Revision or Date Code http://www.repairdata.com/

» Current Status » Acceptance Test Man Hours » Open And Failure Date » Failure Description » Material Used in Maintenance » Initial Inspection » QA Notes » NHA Item and Serial Number » Inspection Tech, Date/Time » QA Witness, Date/Time » Warranty?

» Inspection Man Hours » QA Man Hours » ETM In and Out » Maintenance Performed » New Revision or Item Number » Maintenance Analysis Notes » Maintenance Tech, Date/Time » Final Condition Code » Categorization of Maintenance Action » Maintenance Man Hours

Asset Visibility/System Status The Asset Visibility/ System Status core module of FFIT provides near real-time and legacy system status management. The module performs creation, deletion, update, and reporting of high visibility systems or subsystems. Current status, of Full, Partial, or Non Mission capable for each item, latest ETM, current location, and last event are documented.

This information provides the start clock for ETM or date to aid calculations for demonstrated reliability and maintainability functions. Warranty decisions can be based also on similar data.

If the item being tracked on the System Status screen has either a shipment or a maintenance action, the system status is updated to reflect that it is being shipped or worked on with a one click reference to the shipment or maintenance record.

Some of the information tracked:

» Item and Serial Number » Date Fielded » Event and Date » System Code » Fielding Location » Current ETM » Current Location » Contract » Fielding ETM » Notes » Date Sold » Fielding Notes

Stock Control and Distribution The Stock Control and Distribution module of FFIT provides near real-time and legacy inventory management.

The module performs creation, deletion, update, and reporting of item number / CAGE combination with multiple warehouse inventory control and availability status.

The module consists of core information on the item number / CAGE combination and optional inventory control screens.

When using FFIT, it is tightly integrated in the supply chain management of issuing material in response to requisitions or inducting material received from the Soldier.

This module supports basic information on the item number/CAGE combination.

Some of the information tracked:

» Total Stock » Unit Of Issue » Case Pack » Back Order Qty » Unit Of Measure » Weight » Min/max Stock » Qty

» NSN

» CAGE

» Safety Stock Level » Transaction History » Is Item Reparable?

» Reorder Point » Average Cost Of Line Items » Is Item Configuration Item?

» On Order Qty » Alternate Item Number(s) » Is Item Serialized?

» Order Date » Alternate Item Number » Cost » Level of Repair » Lead time » Alternate Item Number Lead Time Each item number/CAGE combination may have multiple inductions into inventory from purchase orders, contracts, and spares orders. Each induction is tracked separately.

Information tracked:

» Date Received » Line Item Cost

» BIN

» Contract » Vendor CAGE » Condition Code

» CLIN

» Color » Serial Number » Purchase Order » Size » Line Item In Stock Qty » Received Warehouse Location

Shipping, Receiving and In-Transit Shipment Tracking The Shipping, Receiving and In-Transit Shipment Tracking optional module of FFIT provides near real-time and legacy material movement management.

The module performs creation, deletion, update, and reporting of shipping actions, shipment and receiving data collection, and in transit shipment tracking of each shipment action.

RepairCenter has automated the links to AirBorne Express, UPS, FedEx, DHL, Emery WorldWide, and the United States Postal Service. Once the contractor has created a shipment tracking record, direct access to the shippers Internet web site will provide the current tracking information.

As-Managed/As-Maintained Configuration The As-Managed/As-Maintained Configuration module of FFIT provides near real-time and legacy configuration management.

The module performs creation, deletion, update, and reporting of entire systems configuration, sub-systems, and individual track items.

The material that is installed during maintenance automates configuration tracking. If the item installed is configuration tracked, its next higher assembly in the configuration module is found and updated when the maintenance action is closed.

History screens are available to view a tracked item as configuration changes occurred to it.

Configuration events that are documented with each change can be that a baseline was created, modification by maintenance action, replacement by maintenance action, or user created event. These events are traceable back to the document number where applicable.

The As-Managed/As-Maintained screens are custom built and information will be provided during the FFIT training.

Calibration Status The Calibration Status optional module of FFIT provides near real-time and legacy calibration status management.

The module performs creation, deletion, update, and reporting of calibration status actions, assignment of interval, assignment to calibration items.

Once the calibration status task has been established, you will then assign the calibration item in the same fashion as you do when creating modification effectivity.

Multiple calibration tasks can be created and assign to same or different items.

Once the task is activated, the start clock set, the system will interrogate every day and will send an e-mail stating a calibration task is due within the next X days.

The advance notification days are controlled with an entry by the administrator in the Preferences screen.

Preventative Maintenance The Preventative Maintenance optional module of FFIT provides near real-time and legacy preventative maintenance management.

The module performs creation, deletion, update, and reporting of preventative maintenance actions, assignment of interval, assignment to preventative maintenance items.

Once the preventative maintenance task has been established, you will then assign preventative maintenance item in the same fashion as you do when creating modification effectivity. Multiple task can be created and assign to same or different items.

Once the task is activated, the start clock set, the system will interrogate every day and will send an e-mail stating a preventative maintenance task is due within the next X days.

The advance notification days are controlled by an entry by the administrator in the Preferences screen.

The Modification Track and Status optional module of RepairCenter provides real-time and legacy maintenance management. The module performs creation, deletion, update, and reporting of modification information.

This module also enables an optional Maintenance Data collection screen of Modifications required.

When a maintenance action is opened against an item that has outstanding modifications, the user is notified immediately.

The user, from within the maintenance action, can then navigate to the modification and make a determination of its immediate requirement, or if time allows for the modification based on the current requirement for the failed item.

If the modification is incorporated, it is then completed on the maintenance action and closed out in the Modification Tracking Status with a reference to the maintenance action.

Some of the information tracked:

» Modification Number » Is Modification Allowed?

» Labor » Charge Numbers » Title » Verified? With Name » Labor Charge Descriptions » Authorizing Document » Validated? With Name » Documented Effectivity by SN » Configuration Item Being Modified » Approved? With Name » Retrofit Priority » Mod Class » Submitted By » Estimated Start and Stop Dates » Mod Type » Engineering POC » Modification Writer » Identification Of Changes/Effects on Product Configuration Documentation, Logistics and Operations » Baseline Affected (Functional, Allocated, Product) » Estimated Modification Time at O, I, D, or other levels » Contract Number

Due In For Maintenance (DIFM) The Due In For Maintenance (DIFM) optional module of FFIT provides near real-time and legacy DIFM management.

When issuing a reparable item and not receiving the same type failed item in return allows you to open a DIFM tracking document. The document number is generated against the entity that is receiving the replacement item.

This allows for monitoring of items owed to you and will help prevent issuing too many assets to an entity when they are not returning failed assets.

The module performs creation, deletion, update, view/filter/find and reporting of DIFMs. Requires RepairCenter and Inventory Stock/Warehouse option.