MTD 112-060A User Manual

104/02/09TitleProvisioning and Other Tools (POT) 9 March 2010Roger Gillman, Team ITSS

1004/02/09TitleGetting StartedCOTS/NDI Program• Use product information provided from Supplier/OEM.– Parts Ordering Lists – User Manual– Other electro

1104/02/09TitleGetting StartedProduct Improvement• Use Original product data as baseline for improvement changes.– MIL-STD-1388-2B database– LSAR-036/

1204/02/09TitlepowerLOG Imports• Comma Separated Variable (CSV)• LSAR-036 A/B files• 1552/PMR files

1304/02/09TitleExcel (CSV ms-dos) File Import• With some alterations, Spreadsheet data can be imported directly into powerLOG-J.-1 REFNUMHACAGE CAGECD

1404/02/09TitleCSV File ImportBasic CSV (ms-dos) columnar dataPLISNOHG LSACONXB INDCODHG ITNAMEHA REFNUMHA CAGECDXH REFNCCHA REFNVCHA ESSCODHG SHLIFEH

1504/02/09TitleCSV File ImportColumn data automatically maps to a table and data element if a match to a data name/title is found as the column name i

1604/02/09TitleCSV File ImportField Values are used to create “constant” data entries, e.g., EIAC, ALC, LCN-Type.Enter values forData elementshere.

1704/02/09TitleCSV File ImportLCN Structure tab.

1804/02/09TitleCSV File Import• LCNs can be created from a field value entry (One LCN Only), imported data column, or hierarchical data relationships.

1904/02/09TitleCSV File ImportTable Data Import View.Review thedepth of tablesdata created.Review attributesto be imported.Review LCNsGenerated.

204/02/09TitleOUTLINE• Why Provision?• Provisioning Data in powerLOG-J• Importing Data• Provisioning Utilities and Data Generation• Provisioning Revie

2004/02/09TitleCSV File ImportPost Import Updates and Review• Review record PLISN/LCN counts with csvworksheet rows.(Includes Header Row)

2104/02/09TitleCSV File ImportPost Import Updates and Review(Cont)• Create XC PCCN/UOC if necessary.• Map LCNs to UOC (PCCN/UOC tab to UOC-HO work are

2204/02/09TitleCSV File ImportCSV Template• Applies to Columns, Field Chooser, and LCN creation options.•Makes it easy to re-import the same spreadshe

2304/02/09TitleCSV File ImportProvisioning Data Import MappingHG HG-F HG HA HA-K HA-KPLISN LCN Prov IC Item Name Reference No CAGE TARGET SOURCE PLISN

2404/02/09TitleCSV File ImportProvisioning Data Import Mapping (cont)HG HG HG Maint Replace Rates-Mod HA HA HAPPL List Qty Assy MRR-1 MRR-2 MRR Mod Sp

2504/02/09TitleCSV File ImportProvisioning Data Import Mapping (cont)HK-F HK-K* HK-K* HK-M HK HL HJ-K HJTMC Figure No Item No TM-FGC Qty-Fig Prov Nome

2604/02/09TitleMerging CSV datainto powerLOGUse an Ad-Hoc Query to select the parent keys for the csv data that you want to merge. (In this example, i

2704/02/09TitleMerging CSV datainto powerLOGHighlight all the data and perform a “CTRL C” Then open up excel, place the cursor in the first cell and

2804/02/09TitleMerging CSV datainto powerLOGAdd a row for column headers and new columns for HK table RPSTL data and as a minimum add the new keys and

2904/02/09TitleMerging CSV datainto powerLOGInsert data by repeating the copying a row of data, DO NOT ALTER THE HG TABLE KEYS, and add the changed HK

304/02/09TitleWhy Provision?Bridging the gap from InitialFielding to Lifetime Sustainment• The process of provisioning is critical to assure initial s

3004/02/09TitleMerging CSV datainto powerLOGConvert the excel file to csv, then import.

3104/02/09TitleMerging CSV datainto powerLOGMap Columns and add Field constants (EIAC-ALC-LCN type.)

3204/02/09TitleMerging CSV datainto powerLOGPreview import data and Import.When doing a CSV import don’t believe this. ALWAYS VERIFY

3304/02/09TitleMerging CSV datainto powerLOGUse Multi-Record Editor to review results

3404/02/09TitleCSV File ImportProvisioning Specific Data ImportLessons Learned• DO NOT create a column for UOC in the csv data. This will cause each

3504/02/09TitleCSV File ImportPitfalls to a Successful csv import(The Fine Print)• A CSV file may alter data in a way that changes the data value. Su

3604/02/09TitleCSV File ImportPitfalls to a Successful csv import (cont)• Hidden or unseen characters in powerLOG keys can wreak havoc with file struc

3704/02/09TitlePMR/1552 and LSAR-036 ImportsPMR/1552 File 036 File

3804/02/09TitlePMR/1552 and LSAR-036 Imports1552 File• Also Imports PMR F to M (less K) format data• Imports ICAPS basic 1552 A-E format dataLSAR-036

3904/02/09TitlePMR/1552 and LSAR-036 ImportsPMR/1552 File LSAR-036DARCOM-Form 1731 (A-E are 1552) Layout

404/02/09TitleBut Really, why Provision?• Contract requirement (you’ve got to).– Provisioning List(s)• Documentation for supporting organization to de

4004/02/09Title1552 and 036A/B• Differences are not obvious to the untrained eye.– 1552 -01A Reference Number is 16 positions (with an overflow), for

4104/02/09TitlePTD Files Import• Things to check when something goes terribly wrong.– Hiccups in the import file, e.g., a page break, space or blank t

4204/02/09TitlePTD Files Import• When something goes terribly wrong (Continued).– When all else fails, play “high-low” with the data file.• Divide the

4304/02/09TitleImporting LSAR-036 ChangeDataPowerLOG can import change only 036 data also known as an LSAR-036 Wrap-around.• New LCNs in the changed f

4404/02/09TitleProvisioning Utilities andData Generation• PLISN Utilities• Pre-Made Database Alterations• LSAR-152 PLISN Assignment• LSAR-032– Federal

4504/02/09TitlePLISN UtilitiesTo Clean up NHA PLISN relationships, assign provisioning control data, and calculate QPEI.

4604/02/09TitlePre-Made Database AlterationsProvides standard updates to the database based on the specified conditions.

4704/02/09TitlePre-Made Database Alterations• Example: Set blank MRR Modifier to 111111

4804/02/09TitleLSAR-152 PLISN Assignment Reassignment• Uses LCN logic/structure as basis – Checks for breaks in top-down breakdown structureCheck thes

4904/02/09TitleLSAR-152 PLISN Assignment Reassignment• Uses LCN logic/structure as basis – If no break in structure for basic (ALC – OO breakdown), gr

504/02/09TitleWhere is Provisioning Data?

5004/02/09TitleLSAR-032Provisioning ScreeningTwo Paths in PowerLOG to submit screening requestsRDE xml Standard LSR textChoo

5104/02/09TitleLSAR-032 Export FilesRDE export xml vs. “LSR” text<?xml version="1.0" encoding="UTF-8"?><RDEProvision

5204/02/09TitleFIXR (RDE) ImportFIXR URL: http://www.dlis.dla.mil/FIXR/For Portal online Registrations LSAR-032 RDE xmlProvisioning ScreeningSubmittal

5304/02/09TitleFIXR (RDE) Import• File is returned as [PCCN]_RESPONSE.xml• After choosing the powerLOG RDE IMPORT, the following import summary screen

5404/02/09TitleFIXR (RDE) ImportThe second screen contains line by line selections• If a screened Reference Number returns multiple NSN matches, then

5504/02/09TitleFIXR (RDE) ImportIf “Import Key Change of HA Reference Number and CAGE” option is chosen, then the screen below appears when obsolete (

5604/02/09TitleFIXR (RDE) ImportA report is produced documenting the key field changes.Original powerLOGCAGE/Reference NumberRNCC/RNVCAlways5/9New pow

5704/02/09TitleFIXR (RDE) ImportForty-three Importable Data ElementsDATA ELEMENT POWERLOG FIELD (DED) DLIS TAG - DRN1 National Item Identification Num

5804/02/09TitleFIXR (RDE) ImportImportable Data Elements (continued)DATA ELEMENT POWERLOG FIELD (DED) DLIS TAG - DRN24 Intermediate container Quantity

5904/02/09TitleData CalculationsCompute MRR-1/2 Based on Task Frequency

604/02/09TitleBut Really, where is Provisioning Data?• H Provisioning Data tables– **HA Part Identification – 31 elements - Start Work Area of CAGE/Re

6004/02/09TitleData CalculationsMaintenance Replacement Rate FormulaNMRRI = Σ TFi * QTY per TASKii-1Where:N = number of H function tasks (for assembly

6104/02/09TitleData Calculations• Compute Quantity per End Item – Two approaches– Utility- PLISN– LSAR-036 option (cannot narrow PLISN selection)• Thr

6204/02/09TitleData CalculationsOption 1 Calculation (most common)N MQPEI = Σ [ Σ QPAj ] ii=1 j=1Where:N = Number of applications

6304/02/09TitleData CalculationsOption 1 QPEI ExampleFor each applicationOf a CAGE/Reference NumberMultiply UpQuantity perAssemblyThen Add acrossEach

6404/02/09TitleProvisioning Review• PLISN view/PLISN Tree Error Report• LSAR-126 LCN/PCCN Tree • LSAR-080 Bill of Materials• LSAR-068 Task Code/SMR Co

6504/02/09TitleProvisioning ReviewPLISN view/PLISN Tree Error Report

6604/02/09TitleProvisioning ReviewLSAR-126 LCN/PCCN Tree

6704/02/09TitleProvisioning ReviewLSAR-080 Bill of MaterialsReview UOCs mapped to Assembly andComponents here

6804/02/09TitleProvisioning ReviewLSAR-080 Bill of MaterialsError ListError Code 1. If an item is SMR coded, with "Z" or "B" in t

6904/02/09TitleProvisioning ReviewLSAR-068 Task Code to SMR VerificationCompare TaskAnd SMR codes Third position.CI Table work area

704/02/09TitleHere’s the Provisioning Data?

7004/02/09TitleProvisioning ReviewMulti-Record Editor Templates

7104/02/09TitleProvisioning ReviewMulti-Record Editor Templates Continued

7204/02/09TitleProvisioning ReviewMulti-Record Editor Templates• For data entry, can be set to match the requirements of the Contract/Program.– Specif

7304/02/09TitleProvisioning ReviewPLISN Detailed Data checkCombined H Table Work AreaAll H tables availableScroll bar rather Than tab for HA-HG tables

7404/02/09TitleProvisioning ReviewLMP Edits• Range from basic data checks – is the data present to cross-data integrity – MTD-RTD-RCT subfields and SM

7504/02/09TitleProvisioning ReviewPowerLOG Edits (LMP)

7604/02/09TitleProvisioning ReviewProvisioning Edits (LMP)

7704/02/09TitleProvisioning Product Reports• LSAR-036 PTD– html and text versions– Full File and Change Only data• LSAR-151 Provisioning Parts List In

7804/02/09TitleLSAR-036 Format

7904/02/09TitleLSAR-036Report Selection and StatisticsOptions AvailablePCCN (required)UOCs (Required)PTD List (Required)List, Test, Live RunPLISN Rang

804/02/09TitleGetting StartedData Sources• Type of program – sources of information are the keys to how to add/update PTD.– A Full Developmental Progr

8004/02/09TitleLSAR-036Report Data with card/position locator

8104/02/09TitleLSAR-036Report Data with Data Header Option

8204/02/09TitleLSAR-036 FormatDeliverable Text File data[PCCN].036

8304/02/09TitleLSAR-036 FormatDelivered Provisioning Data• LSAR-036 “Live Run” Option• PTD Baseline generated.• Text file created.Also Recommend: Per

8404/02/09TitleKey and Associated DataKEY DATA H TABLE 036 CARD/ BLOCK ASSOCIATED DATA H TABLE 036 CARD/ BLOCKCAGEAdditional Reference NumberHB A02/

8504/02/09TitleLSAR-036 Change TransactionsProvisioning Baseline File

8604/02/09TitleLSAR-036 Change TransactionsChange Only Transaction Rules(Or Don’t attempt to do this on your own)a. Several data elements are combine

8704/02/09TitleLSAR-036 Change TransactionsChange Only Transaction Rules (Cont)e. There are no "reserved" Additional Reference Numbers (ARN

8804/02/09TitleLSAR-036 Change TransactionsChange Only Transaction Rules (Cont)i. If multiple, subordinate key data are contained within another key,

8904/02/09TitleLSAR-036 Change TransactionsReport Data Image Text File

904/02/09TitleGetting StartedFull Development Program• Use hierarchical structure and LCNs of previous development phases.– Import/reuse powerLOG-J/GE

9004/02/09TitleLSAR-151 PPL IndexPLISN and Reference Numbers index

9104/02/09TitleProvisioning and CSV dataGuides are available from LOGSA

9204/02/09Title

9304/02/09TitleBACKUPS

9404/02/09TitleLMP EditsStandard Edits usedLMP Edits used by TACOM and CECOMCECOM TACOM LMP Default CECOM TACOM LMP Default010010010339339020020020350

9504/02/09TitleOpen ProvisioningpowerLOG System ChangesChange No. CHANGE TITLEPLJ-851 LSAR-036 Selection Output Field Filter Tab PLJ-891 LSAR-036 J ca