MASTER DATA ACQUISITION USING EOTD Dr Salomon De

MASTER DATA ACQUISITIONUSING eOTDDr Salomon de JagerPiLogECCMA 10th Anniversary Conference27th to 29th October 2009Cataloging at Source - the last piece of the puzzlePilog Copy right 2009

Master Data Management QuadrantsPublic DomainClient DomainERP 1MMERP 2OtherStaging AreaStaging AreaData FlowMaster DataAcquisitionNon StandardizedExternal DataContentRefineryPilog Copy right 2009OPS AreaOPS AreaMaster DataManagementStandardsStandardizedExternal DataeProc

C@S – MDAIntegrated perational SystemAssetManagementVendor MasterItem CatalogueInventoryAsset RegisterLocation StructuresBills of MaterialsPiLog Master Data AcquisitionPilog Copy right 2009

Master Data Overview – From the Cradle to the GraveMaster Data Acquisition / Project PhaseUpload to ERPMaster Data Management / Operational ERP ocurementData ExtractionReceivingDocumentationLevel of entMaintenanceDesignPhase -Out18 monthsMax Level of EffortBest BusinessPracticeExistingPractice4 - 5 yearsPlant CommissioningHandoverPilog Copy right 2009Time20 years

Master Data Acquisition for ERPOperationBaseline Establishment and EquipmentLife Cycle Management PrinciplesPilog Copy right 2009

Managing the Acquisition of Master DataEquipment Baseline Creation and ManagementSourced from: Eng Design Specs, OEM Prescriptions, Design Drawings initionMaintenanceSignificant ItemIdentificationMaint & tem MasterCreationDriven By Operational Requirements – Data requirement statementsEquipment and Operations ManagementLong TermMaintenancePlanningOperationsplanning andexecutionShort TermPlans (WIP)BreakdownMaintenanceReporting &AnalysisProcurementManagementWIPExecutionPilog Copy right 2009Phase OutPlanningInventoryManagementHRManagement

Managing the Acquisition of Master DataEquipment Baseline Creation and ManagementSourced from: Eng Design Specs, OEM Prescriptions, Design Drawings initionMaintenanceSignificant ItemIdentificationMaint & tem MasterCreationDriven By Operational Requirements – Data Requirement StatementsEquipment and Operations ManagementOperationsplanning andexecutionLong ng &AnalysisProcurementManagementShort TermPlans (WIP)WIPExecutionPilog Copy right 2009Phase OutPlanningInventoryManagementHRManagement

Master DataEquipment Configuration ManagementPilog Copy right 2009

Structure TypesGeneric StructureSpecific StructureEnd Eqp No 1End Eqp No 2End Eqp No 3Top SYCEnd Eqp No 4TopSerSYCNo XNo XTopSerSYCSerNoTop SYC XL1 SYCL1 SYC Ser No XTop SYCL1 SYCL1 SYCL2 SYCL2 SYCL3 SYCL4 SYCL2 SYCL3 SYCL4 SYCL1 SYCL1 SYCL1SYCSerNo:nullL1SYCL1SYCSerNo: nullSerNo: nullSerSYCNo: nullL1SerSYCNo: nullSerSYCNo: nullL1L1SerNo: null L1SerNo: nullSerNo: nullL1SYCL1SYCSYCSer No: nullSer No:nullnullSYCL2 SYCL2 SYCL2 SYCSer No: L2L2 SYCL3 SYCL2SYCSYCSYCSYCSerNo: null L2SerNo: null L2SerNo: null L2SerNo: nullSerSYCNo: null L2SerSYCNo: null L2SerSYCNo: null L2SerSYCNo: nullL2SerNo: null L2SerNo: null L2SerNo: null L2SerNo: nullL2SYCSYCSYCSYCSer No: null Ser No: null Ser No: null Ser No: nullL3 SYCL3 SYCL3 SYCSYCSYCL3SYCSerNo: null L3SerNo: nullSerNo: null L3SerNo:nullSerNo:SerNo:nullL3 SYCL3 SYC nullL3 SYCSerNo: null L3SerNo: nullSerNo: null L3SYCSYCL3SYCnull Ser No: nullSer No:null Ser No:L4 SYCL4 SYCL4SYCSYCSerNo: null L4SerNo: nullSerSYCNo: null L4SerSYCNo: nullL4SerNo: null L4SerNo: nullL4SYCSYCSer No: null Ser No: nullPilog Copy right 2009

Generic StructurePilog Copy right 2009

Specific Structure – Available End EquipmentPilog Copy right 2009

Specific Structure – Selected End EquipmentPilog Copy right 2009

Specific Structure PopulationEquipment RegisterEqp NoEqp TypePart NoDescriptionCR 06-191CRANEPTNO 0123GW AK912 CraneEQP SNO 001CHASSIS0000660716CHASSIS ASSEMBLYEQP SNO 002POWERPACK000125004317POWER PACKEQP SNO 003ENGINE000125006431BASIC ENGINEEQP SNO 004SOLENOID VALVE000137004104SOLENOID VALVE,HOUSING AND AIRPIPEEQP SNO 005FUELPUMP000912004002FUELPUMP,MECHANICALEQP SNO 006INJPUMP000931008049INJECTION PUMPWITH ROLLERTAPPETSEQP SNO 007INJECTOR000931008075FUEL INJECTOREQP SNO EQP SNO 009POWERPACK007603010110POWER PACK, FUELSUPPLY SYSTEMEQP SNO 010POWERPACK007603010110POWERPACKCOOLING SYSTEMEQP SNO 011TURRET8800703010TURRETPilog Copy right 2009Specific StructureCR 06-191Prod XLL CompLL CompLL CompLL Comp LL Comp LL Comp LL Comp LL CompLL CompLL Comp LL CompLL Comp LL Comp

Structure and CI Associated InfoPhysical HardwareBreakdown StructureCATALOGINGPROCESSValid andPreferred PartNo’sAlternative PartNumbersGeneric EquipmentConfigurationStructureMaterial ItemMasterConfigurationStatus quipmentSpecificEquipmentConfigStructuresActual Utilization(Meter Feedback)Pilog Copy right ks

Master dataAsset ManagementPilog Copy right 2009

Asset ManagementVendorsMat sonnelAsset ssetUtilisationApplicationAssetTrackingAsset MeterUpdate/FeedbackConditionPilog Copy right 2009EXT LocationChangeAsset StatusChangeINT LocationChange

Asset Management – Equipment RegisterPilog Copy right 2009

MDAMaintenance ManagementPilog Copy right 2009

Maintenance Task Definition“Standard Maintenance Task”VerbsOEMInstructionsTask nce /ExpertiseStandardTasksProposedTasksRCMInherent Details:Std TaskAssociated InfoTaskInstructionsAssociatedDocumentsTradesPilog Copy right 2009 Standard Task Code Verb & Description TaskSchedule TypeResources Fix & StatutoryIndicators Task Type Estimated DurationSupport FrequencyEquipmentMaterial Schedule Type(FS, SS, ) Date From IndFacilities

Maintenance Task Resource Requirements“Standard Maintenance Task”VerbsOEMInstructionsTask nce /ExpertiseStandardTasksProposedTasksRCMStd TaskAssociated tedDocumentsTradesPilog Copy right 2009MaterialSupportEquipment

Standard Task Associated Information - MaterialsPilog Copy right 2009

Standard Task Associated Information - InstructionsPilog Copy right 2009

MDAMaterials/Inventory ManagementPilog Copy right 2009

Material Item MasterPilog Copy right 2009

Material Item Master – System/Eqp AssociationPilog Copy right 2009

MDADocument ManagementPilog Copy right 2009

Document Management Principles Document Registration Document NumberDocument Revision NumberDocument DescriptionDocument Type Document Indexing Topic Document Date Document phrases and words Document Publishing Document Breakdown StructuresDocument Imaging/File ManagementDocument AssociationsDocument ModificationPilog Copy right 2009

Document InterfacePilog Copy right 2009

ConclusionPilog Copy right 2009

Master Data Overview – 5 Golden Rules Never underestimate the power of quality data withintegrity. Data is a company Asset, treat it as such, control it,maintain it, repair it and govern it. Let the data work for you, do not become a slave of thedata. Do it right the first time. Do not bring the level of your systems and data down tothe User, bring the level of the User up to the systems andthe operational data.Pilog Copy right 2009

Asset Management Project Procurement Spares/Materials Management . L2 SYC Ser No: null L2 SYC Ser No: null L2 SYC Ser No: null L2 SYC Ser No: null L3 SYC Ser No: null L3 SYC Ser No: null L4 SYC Ser No: null L4 SYC Ser No: null