文稿说明案例onstar-bdif pvn interface spec v

OnStarBDIFandProvisioningInterface©SunMicrosystems(China)Shirley Date SOSBDIFShi Date SOSProvisioningLi Date SunBDIFRevisionSummaryofmjorchangesAnnSunJunMaInitialJunModificationsaftermeetingwithProvisioningAddedprovision3.4.2Shipped_sentData3.4.3Scrap_sentData3.4.2Shipped_sentData3.4.3Scrap_sentData3.4EDI53.5CellularESNJunUpdatedafter2ndroundreviewwithProvisioningUpdatedschemaEDI5AddedPairedErrfeedUpdatedschemaEDI2UpdatedschemaCelluarESNJunUpdatedInterfaceList:sectionModifiedEDI5interfaces:sectionModifiedEDI2interfaces:sectionAddedActivatedfeedinterfaces:sectionModifiedCellular_ESNinterface:sectionModifiedExceptionHandlingapproach:sectionYongKongUpdatedActivatedSchemaUpdatedCellular_EsnfeeddescriptioninUpdatederrorhandlingruleinJunReadyforJunMobileNumberDeactivationNotificationschemachangetoadd‘status’to‘ImsiEsnPair’CorrectedUserEnrollmentParaelementJunUpdatedCarrierNotificationServiceImplementationWSDLfile(embedded)JunUpdated,,,JohnHungAddedsection3.8forProvisioningJMSdetailsandupdatedtheWSDLfileCarrierNotificationInterface.UpdatedstagingtablesinformationinsectionJunUpdatedqueuenaming3.4.4,JunUpdatedbdif_pvn_edi5.xsdtoaddxmlnamespaceJunUpdatedPVNstagingtablesschema3.6.3UpdatedSequenceNumberdefinitionnotesJohnUpdatedXSDforSHIPPED_SENTandSCRAP_SENTandAllowemptyrecordsetinSHIPPED_SENTandRemovedSTIDUniquenessRemovedtypesandenumerationsforPairedError,whicharefromtheoldEDI5flow.JunAddedpredefinedvaluesforFeedName,SourceID,etc.–,,,,,,JunRevertedthechangetoSHIPPED_SENT/SCRAP_SENTschematonotallowzerodatarecord–,,,RitaAddedvalidvaluesforstatus–AddedChinesedescriptionforEDIERRORCD–RitaUpdated2realtimeinterfacesaccordingtoCT’sinterfacewith3.1MDN/IMSIDeactivationReal-UpdatedminDeactivationAddedUpdated3.3UserEnrollmentReal-UpdateduserEnrollmentAddedUpdatednotifyUserEnrollmentResultAdded1realtimeinterfaceunitCancellation3.4MDN/IMSICancellationReal-AddedAddedAddedJunBDIF_PVN.wsdlsplitintotwowsdlfiles:BDIFPVNDisconnect.wsdl(section,RitaAddESN_SENTinterfaceAddCarrier_ESNUpdateActivatedNotificationinterface,addvendor_duns_numberinoutboundmessagetoindicatehardwaremanufacture.UpdateEDI5(shippedSent/scrapSent)interface,addvendor_duns_numberinoutboundmessagetoindicatehardwaremanufacture. Interface Inteface MDN/IMSIDeactivationReal-time MDN/IMSIActivationReal-time(outofscopeforR1) minActivation UserEnrollmentReal- userEnrollment MDN/IMSICancellationReal-time unitCancellation EDI5–ShippedMIN/ESNandScrapMIN/ESNfilesBatch EDI5ProcessFlow SHIPPED_SENT SCRAP_SENT BDIF_PVN_EDI5Interface(SHIPPED_ERR/SHIPPED_APP/SCRAP_APP/ OriginalEDI2–MarriedIMSI/ESNfileBatchFeed EDI2ProcessFlow ActivatedESN/MDN/IMSIfileBatchFeed DefinitionofPVNStaging notifyActivatedSentJMSMessage notifyActivatedReceivedJMSMessage Cellular_ESNDataFeed CellularESNData ProvisioningJMSModule Exception/ErrorHandling ErrorNotification ThisistheprimarydetailedrequirementsdescriptionofallinterfacesbetweenBDIFsystemandPVNsystem.ThisincludesBDIFownedinterfacesexposedtoPVNsystem,forwhichthisshouldberegardedastheprimarysource.ItalsolistsPVNownedinterfacesexposedtoBDIF,totheextentasunderstoodatthistime,forcontractualandreferencepurpose,butshouldnotberegardedastheprimarysourceofthatinformation.ThisshouldbereadandunderstoodbyallsystemstakeholderswithaninterestinthedetailedinterfacespecificationbetweenBDIFandPVN.Mostimportantly,thisincludesthosewhoarebuildingthesystemandthosewhowilluseittocarryouttheirbusinessresponsibilities.Theinterfacesspecificationoutlinedinthisdescribethedetailedtechnicalviewofcallinterface,elementsdefinition,error/exceptionhandlingetc.allpertinentinformationnecessaryforclientstousetheinterfaceeffectivelyandcorrectly.SeeDataSharingAgreement(DSA)andSystemRequirementSpecification(SRS)forthedetaileddatausage,sharingandsystemrequirements,usecasesandprojectscope.InterfaceData ESN/MDN/IMSIreal-timeESN/MDN/IMSIreal-timedeactivationordernotificationESN/MDN/IMSIreal-timedeactivationresultnotificationUserEnrollmentReal-UserESN/MDN/IMSIreal-timeUserEnrollmentordernotificationESN/MDN/IMSIreal-timeUserEnrollmentresultnotificationUnitCancellationReal-UserESN/MDN/IMSIreal-timeUnitCancellationordernotificationESN/MDN/IMSIreal-timeUnitCancellationresultnotificationMDN/IMSIActivationReal-ESN/MDN/IMSIreal-timeactivation(outofscopeforR1)ESN/MDN/IMSIreal-timeactivationnotification(outofscopeforR1)EDI5–ShippedMIN/ESNandScrapMIN/ESNfilesShippedfilesentdataScrapfilesentdataProcessresponseforShipped/Scrap:SHIPPEDERRmessagesentSHIPPED_APPmessagesentSCRAP_APPmessagesentSCRAP_ERRmessagesentOriginalEDIEncryptedPairedwithA-KeyfileActivatedESN/MDN/IMSIEncryptedPairedwithA-KeyfilewillbesenttoConti,afterPVNhasnotifiedBDIFthattheActivatedfeedisgood;theoriginalActivatedfilewillalsobesentalongsothatConticancrosscheckwiththeEncryptedfilecontentActivatedESN/MDN/IMSIACTIVATED_SENTLoadActivated_SentESN/MDN/IMSIfilefromChina intoPVSStagingNotifyPVNtheActivated_SentloadingisACTIVATED_ERRGenerateACTIVATED_ERRfilefromPVNStagingforChinaNotifyBDIFtheprocessingresultofActivated_SentStagingdata(BDIFdependsonthisnotificationtodecidewhethertoholdontheencryptedCellular_ESNCellularESNmessgeIntefaceThissectiondefinesthedatafeedinterfacesbetweenBDIFandPVNMDN/IMSIDeactivationReal-minDeactivationInterfaceInterfaceSOAPUsage2500usersperday,20concurrent1KperInterfaceDefinitionWSDLSchemaminDeactivationRequestminDeactivationResponseStatusCodes- Whatarethevalidstatuscodes?StatusMessage- Whatarethevalidstatusmessages?Jma:theresponsemessageschemahereisleftunchangedfromtheoriginaldesignfortwoKeeptheinterfacedesignascoherentasForfutureextensionpurpose,wheninterfacewith goesWebServiceseventuallyCurrentlythisresponsemessageisusedmainlyjustforacknowledgement.StatusCode–0(requestreceivedOK)StatusMessage–RequestReceived -WhatarethevalidCode? -WhatarethevalidmessageEAIExtResultSet–WhyisthereanJma:theBaseResultisusedtowraptheexternalresultreturnedfrom ,incurrentcase,itwouldbeempty.ElementElementDataMandatory/Identifiesthecurrenttransaction:“mdndeactpvn2ct”IdentifiestheSourceApplication:CountofTimestampofInputIdentifiesthe : MinDeactivationData Mandatory/Uniqueid,withfixedlength16,willbeusedtotracktherequest,generatedby接触流水号IDKeepthesameas受理工号extendpurposelater MDNFixedlengthData ElementMandatory/IdentifiesBDIFinstanceforthetransaction,forcorrelationpurposeBDIFreturnStatus0–Success;1–Status ProcessedrecordsTimestampofData ElementFaultFaultFaultFauFauInterfaceDefinitionnotifyEnrollmentDeactivationOrderInterfaceInterfaceSOAPUsage2500userperday,20concurrent1KperInterfaceDefinitionWSDLSchemaNotificationFaultElementElementDataMandatory/IdentifiestheuniqueBDIFid,whichshouldbeusedtotracktheoriginalresponsefromCTIdentifythe ,put ThetimewhengettheElementDataMandatory/Uniquerequestid,lenthisfixedto0–Success,1–errorcodeinthecaseoffailure,maxlengthisreasonoferror,maxlengthisOrdernumberfortherequestidentifiedbyrequestid,maxlengthis20OrderIdfortherequestidentifiedbyrequestid,maxlengthis32thetimewhenrequestwasacceptedby*BDIFshouldmakesurerequestIdcanreprensenttheoriginal ttoElementDataMandatory/0–Success1–ElementDataWebServiceFaultWebServiceFault WebService InterfaceDefinitionnotifyEnrollmentDeactivationResultInterfaceInterfaceSOAPUsage2500userperday,20concurrent1KperInterfaceDefinitionWSDLSchema(PVN:pleasechangethesubelementsoccurrencefromsingletomultiplicity,asalreadyreflectedinthediagrambelow):Eachdeactivationrequestmayreturndifferentstatus,somemaybesuccessfulandsomemaybefailure.Theycannotbegroupedtogether.Jma:Yestheycan,ineachpair,the‘ImsiEsnPair’and‘status’aregroupedasoneoccurrence,asalreadyupdatedbelow: eactivationNotificationFaultElementElementDataMandatory/IdentifiestheuniqueBDIFid,whichshouldbeusedtotracktheoriginalresponsefromCTIdentifythe ,put ThetimewhengettheElementDataMandatory/Uniquerequestid,lenthisfixedtoOrdernumberfortherequestidentifiedbyrequestid,maxlengthis20MobileDirectoryInternationalMobileSubscriberIdentificationTheMobileElectronicSerialNumber(ESN)fortheVehicleCommunicationPlatform0–Success,1–errorcodeinthecaseoffailure,maxlengthisreasonoferror,maxlengthisAcknowledgeResultNotificationElementDataMandatory/0–Success1–ElementDataWebServiceFaultWebServiceFault WebService InterfaceDefinition<CarrierNotificationServiceImplementation.wsdl>(seesectionMDN/IMSIActivationReal-time(outofscopeforminActivationInterfaceInterfaceSOAPUsage2500usersperday,20concurrent1KperInterfaceDefinitionWSDLSchemaminActivationRequestminActivationResponseElementElementDataIdentifiesthecurrenttransaction,equalsthenameoftheinterfacecallIdentifiestheSourceCountofTimestampofInputementData客户名证件类证件号客户类路设备号套餐名ESN号ImsiementDataIdentifiesBDIFinstancefortransaction,forcorrelationBDIFreturnStatusStatusProcessedrecordsTimestampofInterfaceDefinition<BDIF_PVN.wsdl>(seesectionInterfaceInterfaceSOAPUsage2500userperday,20concurrent1KperNotimplementedforreleaseInterfaceDefinitionWSDLSchemaMobileNumberActivationNotificationAcknowledgeMobileNumberActivationNotificationFaultElementTheMobileElectronicSerialNumber(ESN)fortheVehicleCommunicationPlatform(VCP).InternationalMobileSubscriberIdentificationMobileDirectoryWebServiceFaultWebServiceFaultFauWebServiceFauInterfaceDefinition<CarrierNotificationServiceInterface.wsdl>(seesectionUserEnrollmentReal-userEnrollmentInterfaceInterfaceSOAPUsage2500usersperday,20concurrent1KperInterfaceDefinitionWSDLSchemauserEnrollmentRequestuserEnrollmentResponseElementElementDataIdentifiesthecurrenttransaction:IdentifiestheSourceApplication:CountofTimestampofInputIdentifiesthe : UserEnrollmentData Mandatory/Uniqueid,withfixedlength16,willbeusedtotracktherequest,generatedby接触流水号IDKeepthesameas受理工号021Thiselementisforextendpurposelater MDNFixedlengthData ElementMandatory/IdentifiesBDIFinstanceforthetransaction,forcorrelationpurposeBDIFreturnStatus0–Success;1–Status ProcessedrecordsTimestampofData ElementFaultFaultFaultFauFauInterfaceDefinition<BDIF_PVN.wsdl>(seesectionRefertosectionnotifyEnrollmentDeactivationResultRefertosectionMDN/IMSICancellationReal-unitCancellationInterfaceInterfaceSOAPUsage2500usersperday,20concurrent1KperInterfaceDefinitionWSDLSchemaunitCancellationRequestunitCancellationResponseElementElementDataMandatory/Identifiesthecurrenttransaction:“unitcancelpvn2ct”IdentifiestheSourceApplication:CountofTimestampofInputIdentifiesthe : Data Mandatory/Uniqueid,withfixedlength16,willusedtotracktherequest,generatedby接触流水号IDKeepthesameas受理工号extendpurposelater MDNFixedlength“其他Data ElementMandatory/IdentifiesBDIFinstanceforthetransaction,forcorrelationpurposeBDIFreturnStatus0–Success;1–Status ProcessedrecordsTimestampofData ElementFaultFaultFaultFauFauInterfaceDefinitionnotifyUnitCancellationOrderInterfaceInterfaceSOAPUsage2500userperday,20concurrent1KperInterfaceDefinitionWSDLSchemaNotificationFaultElementElementDataMandatory/IdentifiestheuniqueBDIFid,whichshouldbeusedtotracktheoriginalresponsefromCTIdentifythe ,put ThetimewhengettheElementDataMandatory/Uniquerequestid,lenthisfixedto0–Success,1–errorcodeinthecaseoffailure,maxlengthisreasonoferror,maxlengthisOrdernumberfortherequestidentifiedbyrequestid,maxlengthis20OrderIdfortherequestidentifiedbyrequestid,maxlengthis32thetimewhenrequestwasacceptedbyElementDataMandatory/0–Success1–ElementDataWebServiceFaultWebServiceFault WebService InterfaceDefinition<CarrierNotificationServiceImplementation.wsdl>(seesectionnotifyUnitCancellationResultInterfaceInterfaceSOAPUsage2500userperday,20concurrent1KperInterfaceDefinitionWSDLSchemaUnitCancellationResultNotification eactivationNotificationFaultElementElementDataMandatory/IdentifiestheuniqueBDIFid,whichshouldbeusedtotracktheoriginalresponsefromCTIdentifythe ,put ThetimewhengettheElementDataMandatory/Uniquerequestid,lenthisfixedtoOrdernumberfortherequestidentifiedbyrequestid,maxlengthis20MobileDirectoryInternationalMobileSubscriberIdentificationTheMobileElectronicSerialNumber(ESN)fortheVehicleCommunicationPlatform0–Success,1–errorcodeinthecaseoffailure,maxlengthisreasonoferror,maxlengthisAcknowledgeResultNotificationElementDataMandatory/0–Success1–ElementDataWebServiceFaultWebServiceFault WebService InterfaceDefinition<CarrierNotificationServiceImplementation.wsdl>(seesectionEDI5–ShippedMIN/ESNandScrapMIN/ESNfilesBatchEDI5ProcessFlow1EDI-864ShippedMIN/ESN1EDI-8642EDI-9972EDI-997EDI-864EDI-8644EDI-9971EDI-864ScrapMIN/ESNprocess1EDI-8642EDI-2EDI-997EDI-86444EDI-997EDI-EDI-864ProvisioningsystemisresponsibleforEDI5datafeedsinterfaceofSHIPPED_SENTandBDIFsystemisresponsibleforEDI5datafeedsinterfaceofSHIPPED_APP,SHIPPED_ERR,SCRAP_APP,SCRAP_ERR. BDIFEDI5interfaceutilizesoneunifiedinterfacedefinition.SHIPPED_SENTInterfaceInterfaceUsageDaily2500InterfaceDefinitionSchemaShippedSentschemaElementShippedSentUniqueIDfortheNumbermustbeequaltonumberofshipsentDateTimeofthisEDISenderHardwaremanufature’sdunsShippedSentIMSI–Numericalwithalengthof14–ESN–NumericalwithalengthofMDN–NumericalwithalengthofStationID–Numericalupto15ReworkTagmaxlengthofTimestampofShippedDateTheIMSI,ESN,MDN,STIDmustbeuniqueperInterfaceDefinitionSCRAP_SENTInterfaceInterfaceUsageDaily2500InterfaceDefinitionSchemaScrapSentschemaElementScrapSentUniqueIDfortheNumbermustbeequaltonumberofshipsentDateTimeofthisEDISenderHardwaremanufature’sdunsScarpSentIMSI–Numericalwithalengthof14–ESN–NumericalwithalengthofMDN–NumericalwithalengthofStationID–Numericalupto15ReworkTagmaxlengthofTimestampofShippedDateTheIMSI,ESN,MDN,STIDmustbeuniqueperInterfaceDefinition<PleaserefertoBDIF_PVN_EDI5Interface(SHIPPED_ERR/SHIPPED_APP/SCRAP_APP/InterfaceInterfaceJMSusername/passwordUsageDaily2500InterfaceDefinitionXMLschemaElementCreationSEQUENCEMessageSequenceFEEDFeedNamerequired:FEEDFeedsource:FEEDF=Full,MessageCorrelationTheMobileElectronicSerialNumber(ESN)fortheVehicleCommunicationPlatform(VCP).InternationalMobileSubscriberIdentificationMobileDirectoryStationAuthenticationReworkErrorRECORDThecountofrecordsinthefileforthisHardwaremanufature’sdunsInterfaceDefinitionOriginalEDI2–MarriedIMSI/ESNfileBatchEDI2ProcessFlowEncryptedPairedwithA-KeyfilewillbesenttoConti,afterPVNhasnotifiedBDIFthattheActivatedfeedisgood.ActivatedESN/MDN/IMSIfileBatchInterfaceInterfaceUsageMonthlyProjectedthebatchtobe60KRecordsin5years,whichwillbe20MbytesinsizeBDIFwillloadtheActivateddataitreceivesfromintoPVNstagingtable,andnotifyPVNviaJMSmessagewhenloadisInterfacePVN_STAGEDatabaseThistablewillcontaintheheaderdescriptionforeachfeed.ThistablewillcontainthedataforeveryACTIVATEDandACTIVATEDERRORfeedThistablewillbealookuptableforthestatusDefinitionofPVNStagingPVNSTAGEUniqueSequenceNumberforeveryThisnumberissystemassignedfromanOracleSequenceSEQ_PVN_STAGE_META/ContIDUsedformessageTransactionTypeofthefeedValidvalues:ACTIVATED(whenBDIFstagesfeed)TTotalnumberofrecordsforeachfeed;ThisnumbershouldmatchtherowcountofthedataSENDERID:RECEIVERID:CreatedCreatedbyID:BDIF(whenBDIFstagesUpdatedbyPVNSTAGEUniqueSequenceNumberforeveryThisnumberissystemassignedfromanOracleSequenceSEQ_PVN_STAGE_ACTIVATEDOnerowcorrespondingtoeverydataOnerowcorrespondingtoeverydataOnerowcorrespondingtoeverydataOnerowcorrespondingtoeverydataValidEDIstatusfromshouldbe0(Accepted)whenBDIFfirststagesthefeedValidprocessingstatusfromshouldbe10(Staged)whenBDIFfirststagesthefeedForeignKeyassociatedwithCreatedbyID:BDIF(whenBDIFstagesCreatedUpdatedby0DataisDetailedEDI_STATUScodesdefinitiontobe0Datais1CannotlocateESNtheESN2CannotlocateIMSItheIMSI3CannotlocateMDNtheMDN4DuplicateIMSI5DuplicateESN6DuplicateMDN7Invalid8Invalid9InvalidInvalid无效Invalid无效CannotprocessdataPVNSTAGEPROCESSINGRECORDhasbeenRECORDhasbeenRECORDisbeingProvisioninghasbeenupdatedwithdatainthisrecordProvisioninghascompletedprocessingcycleonthisstagedrecordnotifyActivatedSentJMSMessageInterfaceInterfaceJMSUsageWhenBDIFhasdoneloadingthePVN_STAGE_ACTIVATEDstagingtable,BDIFwillnotifyPVNvianotifyActivatedSentInterfaceDefinitionXMLschemaElementFieldTypeoffeed,fromIDofthisnotificationNumberofrecordsintheSourceofDestinationofSequencenumberfromPVNSTAGEMessageCreationDateInterfaceInterfaceUsageMonthlyProjectedthebatchtobe60KRecordsin5years,whichwillbe20MbytesinsizeIncasethatthereisACTIVATED_ERR,BDIFwillreadfromstagingtable,generatetheACTIVATED_ERRfiletobesentto InterfaceThesamestagingtablePVN_STAGE_ACTIVATEDwillbenotifyActivatedReceivedJMSMessageInterfaceInterfaceJMSUsageAfterPVNhasprocessedtheActivatedrecordsinthestagingtable,therecouldbetwocases:IfPVNfindsanyerrorintheActivateddata,itwillmarktheerroneousrecordsasACTIVATED_ERRinthestagingtable,andnotifyBDIFvianotifyActivatedReceivedJMSmessage;BDIFwillholdontheencryptedPairedfileIfthedataisgood,itwillalsonotifyBDIFnotifyActivatedReceivedJMSmessage,BDIFwillthenforwardtheencryptedPairedfiletoContiInterfaceDefinitionXMLschemaElementementDataCreationdate,YYYY-MM-MessagesequenceForsuccesscondition,thesequencenumberisthesameofinboundsequencenumber.Forfailurecondition,thesequencenumberisthenewsequencenumber(whichisassociatedwithinboundfeedthroughBDIFmessageID)Feedname:Feedsource:Feedtype:CountofdetailHardwaremanufactury’sdunsDataResult––ErrorErrorExtensionResultExtensionementExtensionementExtensionementExtensionementInterfaceDefinitionCellular_ESNDataOnceBDIFhasreceivedActivatedReceivednotificationmessagefromProvisioning,BDIFcangeneratetheCELLULAR_ESNdatafeedforGVSbasedontheACTIVATEDdatafeed.NoadditionaldatafromProvisioningsystemisrequiredforgeneratingsuchfeed.CellularESNDataInterfaceInterfaceUsageMonthlyProjectedthebatchtobe60KRecordsin5years,whichwillbe20MbytesinsizeCurrentdesignisforPVNtosendtheActivateddataaftervalidationviaJMSmessage,butthiswillfacethesameproblemofActivatedfeed,sosuggesttoreadfromPVNstagingtableaswell.InterfaceDefinitionCellular_ESNfeedXMLschemaElementCreationSEQUENCESequenceFEEDFeedNamerequired:FEEDFeedsource:FEEDF=Full,TheMobileElectronicSerialNumber(ESN)fortheVehicleCommunicationPlatform(VCP).InternationalMobileSubscriberIdentificationMobileDirectoryDateRECORDThecountofthenumberofrecordsinthefileforthisplantInterfaceDefinitionOriginalEDI1–ESN_SENTfileBatchEDI1Process1EDI11EDI1Manual4BeforeautomaticinterfaceisreadyatCarrierSide,BDIFisresponsibleformanuallygenerateESN_ERRandtriggertheCARRIER_ESNinterfaceatProvisioning.4ESN_SENTStagingInterfaceInterfaceUsageMonthlyProjectedthebatchtobe60KRecordsin5years,whichwillbe20MbytesinsizeBDIFwillloadtheESNdatawithitsvendordunsnumberPVNstagingtable,andnotifyPVNviaJMSmessagewhentheloadisdone.InterfacePVN_STAGEDatabaseThistablewillcontaintheheaderdescriptionforeachfeed.ThistablewillcontainthedataforeveryESN_APPandESN_ERRfeedThistablewillbealookuptableforthestatusDefinitionofPVNStagingPVNSTAGEUniqueSequenceNumberforeveryThisnumberissystemassignedfromanOracleSequenceSEQ_PVN_STAGE_META/ContIDUsedformessageTransactionTypeofthefeedValidvalues:ACTIVATED(whenBDIFstagesfeed)ESN_SENT(whenBDIFstagesfeed)CARRIER_ESN(whenBDIFstagesfeed)TTotalnumberofrecordsforeachfeed;ThisnumbershouldmatchtherowcountofthedataSENDERID:RECEIVERID:CreatedCreatedbyID:BDIF(whenBDIFstagesUpdatedbyPVNSTAGEUniqueSequenceNumberforeveryThisnumberissystemassignedfromanOracleSequenceSEQ_PVN_STAGE_ESNOnerowcorrespondingtoeverydataTheblockidoriginallysentfromhardwaremanufactory,onlylogfortroubleshootingValidEDIstatusfromshouldbe0(Accepted)whenBDIFfirststagesthefeedSTATUSFROMCarrier. LeaveitasNULLinESN_SENTfeed.Validprocessingstatusfromshouldbe10(Staged)whenBDIFfirststagesthefeedForeignKeyassociatedwithCreatedbyID:BDIF(whenBDIFstagesCreatedUpdatedby0Datais5DuplicateESNwithinESN0Datais5DuplicateESNwithinESN8InvalidCannotprocessdataESNinuseandhaveanactiveESNRECORDhasbeenRECORDhasbeenRECORDisbeingProvisioninghasbeenupdatedwithdatainthisrecordProvisioninghascompletedprocessingcycleonthisstagedrecordnotifyEsnSentJMSMessageInterfaceInterfaceJMSUsageWhenBDIFhasdoneloadingthePVN_STAGE_ESNstagingtable,BDIFwillnotifyPVNvianotifyEsnSentJMSmessage.InterfaceDefinitionXMLschemaRefertoElementFieldTypeoffeed,fromIDofthisnotificationNumberofrecordsintheSourceofDestinationofSequencenumberfromMessageCreationDateinitiallystoredinPVN’sESN_ERRFileInterfaceInterfaceUsageMonthlyProjectedthebatchtobe60KRecordsin5years,whichwillbe20MbytesinsizeIncasethatthereisESN_ERR,BDIFwillreadfromPVNtable,generatetheESN_ERRfiletobesentbacktohardwareInterfaceThesamestagingtablePVN_STAGE_ESNwillbenotifyEsnReceivedJMSMessageInterfaceInterfaceJMSUsageAfterPVNhasprocessedtheEsnrecordsinthestagingtable,couldbetwoIfPVNfindsanyerrorintheEsndata,itwillmarktheerroneousrecordsasESN_ERRinthestagingtable,andnotifyBDIFvianotifyEsnReceivedJMSmessage;BDIFwillforwordESN_ERRtohardwaremanufacture,thevalidationofESN_SENTwillfollowall-nothingmechanism.Ifthedataisgood,itwillalsonotifyBDIFvianotifyEsnReceivedJMSmessage,BDIFwillthenforwardtheESNfiletoChina InterfaceDefinitionXMLschemaElementementDataCreationdate,YYYY-MM-MessagesequenceForsuccesscondition,thesequencenumberisthesameofinboundsequencenumber.Forfailurecondition,thesequencenumberisthenewsequencenumber(whichisassociatedwithinboundfeedthroughBDIFmessageID)string,thissequencenumberwillbeusedtoidentifythebatchofESN,whenreceive Feedname:Feedsource:Feedtype:CountofdetailHardwaremanufactury’sdunsDataResult––Incaseof1,ESN_ERRshouldbesentbacktohardwaremanufacture.ErrorErrorExtensionResultExtensionementExtensionementExtensionementExtensionementInterfaceDefinitionReferto<BDIF_PVN_notificationReceived.xsd>andCARRIER_ESNfileBatchESN_SENTStagingInterfaceCARRIERESNInterfaceUsageMonthlyProjectedthebatchtobe60KRecordsin5years,whichwillbe20MbytesinsizeBDIFwillloadtheESNdatafromcarrierESN_ERRORintoPVNstagingtable,andnotifyPVNviaJMSmessagewhentheloadisdone.PVNwilltreatalltheESNinthisfeedasinvalid.PVNwillthensentoutreceivedmessagewithhardwaremanufactureindicator,BDIFwillfurthergenerateandforwardESN_ERRtothespecifiedhardwareInterfacePVN_STAGEDatabaseThistablewillcontaintheheaderdescriptionforeachfeed.ThistablewillcontainthedataforESN_APP,ESN_ERR,CARRIER_ESN,andCARRIERESNERRfeedThistablewillbealookuptableforthestatusDefinitionofPVNStagingPVNSTAGEUniqueSequenceNumberforeveryThisnumberissystemassignedfromanOracleSequenceSEQ_PVN_STAGE_META/ContIDUsedformessageTransactionTypeofthefeedValidvalues:ACTIVATED(whenBDIFstagesfeed)ESN_SENT(whenBDIFstagesfeed)CARRIER_ESN(whenBDIFstagesfeed)TTotalnumberofrecordsforeachfeed;ThisnumbershouldmatchtherowcountofthedataSENDERID:RECEIVERID:CreatedCreatedbyID:BDIF(whenBDIFstagesUpdatedbyPVNSTAGEUniqueSequenceNumberforeveryThisnumberissystemassignedfromanOracleSequenceSEQ_PVN_STAGE_ESNOnerowcorrespondingtoeverydataTheblockidoriginallysentfromhardwaremanufactory,onlylogfortroubleshootingpurpose.LeaveitasNULLinthisfeed.ValidEDIstatusfromshouldbe0(Accepted)whenBDIFfirststagesthefeedSTATUSFROMCarrier.Provisioningdoesnotunderstandthisvalue,thiscolumnisforBDIFtogeneratefurtherESN_ERRtohardwaremanufacture.SincethevalidationforESN_SENTfollowsall-nothingmechanism,everyESNinthisfeedwillbeconsideredasValidprocessingstatusfromshouldbe10(Staged)whenBDIFfirststagesthefeedForeignKeyassociatedwithCreatedbyID:BDIF(whenBDIFstagesCreatedUpdatedby0Datais5DuplicateESN8InvalidESN,orESNisnotfoundinformerESN_SENTfeed0Datais5DuplicateESN8InvalidESN,orESNisnotfoundinformerESN_SENTfeedCannotprocessdataPVNSTAGEPROCESSINGRECORDhasbeenRECORDhasbeenRECORDisbeingProvisioninghasbeenupdatedwithdatainthisrecordProvisioninghascompletedprocessingcycleonthisstagedrecordnotifyEsnSentJMSMessageInterfaceInterfaceJMSUsageWhenBDIFhasdoneloadingthePVN_STAGE_ESNstagingtable,BDIFwillnotifyPVNvianotifyCarrierEsnJMSmessage.InterfaceDefinitionXMLschemaRefertoElementFieldTypeoffeed,fromIDofthisnotificationNumberofrecordsintheSourceofDestinationofSequencenumberfromMessageCreationDateCARRIER_ESN_ERRFileInterfaceInterfaceUsageMonthlyProjectedthebatchtobe60KRecordsin5years,whichwill20MbytesinIncasethatthereisCARRIER_ESN_ER