Atch13_15_Sample_Tasks.pdf

For the best experience, open this PDF portfolio in

Acrobat X or Adobe Reader X, or later.

Get Adobe Reader Now!

http://www.adobe.com/go/reader

ATTACHMENT 13

SAMPLE TASK #1

DATA ARCHITECTURE AND INTERFACE PLAN

DIRECTIONS:

In accordance with PWS requirement 3.1.h and skill levels 3.2.a, 3.2.d, and 3.2 f, convert this sample task data into a data architecture and interface plan for 107 Field Assistance Requests that include the following:

1. Define applicable system interface type(s)

2. Define database schema requirements with appropriate relationships between data items using Teamcenter’s management tool, including parent/child relationships based on that data provided.

3. Determine WSMT data extraction requirements and Teamcenter data import formatting

4. Identify Teamcenter architecture requirements (assume needed objects, attributes, workflows, etc. do not already exist)

5. Define the Teamcenter deployment process(s) for getting new Teamcenter architecture items into a production environment

6. Determine needed process(s) to ensure all the WSMT data (107s) is synchronized at the end of the task.

Raw Data Items:

A-10 PLM Environment Diagram

ADES (Files: PLM Data Exchange Specification 12-A10DOC-002 rev F.pdf and PLM

Data Exchange Specification 12-A10DOC-002 Appendix Table Fv0.5.xls)

WSMT 107 database schema (File: 107 Database Schema.xlss)

WSMT 107 data extract (File: 107 Data Extract.xlsx)

PRODTESTDEV

A-10 PLM Environment

ATTACHMENT 14

SAMPLE TASK #2

DATA IMPORT AND VALIDATION PLAN

In accordance with PWS requirement 3.1.k and skill levels 3.2.e, 3.2.l, and 3.2.o, convert this sample task data into a data import and validation plan for CCB data that includes the following:

1. Description of needed ADES change requirements

2. Define process(s) for updating Teamcenter database schema in a Production environment

3. Provide a data import format example file

4. Define data validation process(s)

Raw data items:

Data Exchange Specification 12-A10DOC-002 Appendix Table Fv0.5.xlsx)

WSMT CCB database schema (File: CCB Database Schema.xlsx)

WSMT CCB data extract (File: CCB Data Extract.xlsx)

ATTACHMENT 15

SAMPLE TASK #3

SERIAL NUMBER AND UNIT CONFIGURATION TRACKING PLAN

In accordance with PWS requirement 3.1.i and skill levels 3.2.b, 3.2.c, and 3.2.i, convert this sample task data into a serial number and unit configuration tracking plan that includes the following:

1. Description of unit configuration data to be tracked

2. Determination of which Teamcenter module(s) to be used (assume all are available) and any industry best-practices or concerns with this approach

3. Process(s) to establish all unit configurations (assume a subset of 10 aircraft)

4. Data migration process and import sequencing for historical data

5. Teamcenter process(s) for applying flight hours and modification to a specific serial number (configuration) moving forward

Raw data items:

Data Exchange Specification 12-A10DOC-002 Appendix Table Fv0.5.xlsx)

Serial Number Tracking Data (File: Serial Numbers and Events.xlsx)

TCTO Modifications (File: TCTO Data Extract.xlsx)

Flight Hours (File: Fleet Hours.xlsx)