System and method for software integration and factory deployment

Abstract
A software management database contains data structures supporting computer software provisioning for a range of CTO/BTO variations, language variations, region variations, and operating system variations.
Description
I. FIELD OF THE INVENTION

The present invention relates generally to systems and methods for software integration and factory deployment of the software.


II. BACKGROUND OF THE INVENTION

Producing consumer electronics and in particular computers that might incorporate, in addition to operating systems with various configurations and suites of applications, several subsystems, each in turn with their own software drivers, can be complicated. Not only must a bill of materials (BOM) be defined, managed, and conformed to, but product defects and corrective actions must also be managed in way that ensures corrective action can be known and taken across the globe.


Because of the complexity inherent in the above considerations, it can happen that more than a single management system might develop over time, complicating efforts to integrate knowledge and data. As recognized herein, it is desirable to have a management system that can integrate the knowledge and input of designers, engineers, software integrators, etc. in ways that reduce engineering lead times and provide ease of tracking defects and cures to the defects in a single, globally shared system within an enterprise, while providing an easy way to manage regional differentiation of software offerings, sharing information between business groups within the enterprise, and eliminating duplicative data maintenance.


For example, many computers are sold on a configure to order/build to order (CTO/BTO) basis. Each software part can have a multidimensional relationship with each stock keeping unit (SKU) that represents a product when region, language, various operating system versions, and platforms are factored in. Thus, each software part can potentially have dozens of version releases to accommodate all of these variables. As but one example of the complexity of providing CTO/BTO computers, one version of a “click to DVD” software may be used only on French Windows MCE SR series SKUs that are sold only in Quebec, but another version may be designed to work on any model using Windows XP Home Edition Spanish Version regardless of region.


As another example of complexity, consider that there are currently about ten Sony VAIO platforms worldwide, and each platform may contain multiple VAIO models with variations on CPU, RAM, HDD capacity, wireless (WLAN, WWAN, and Bluetooth), graphics chipset, etc. Several major regions that include an even greater number of languages in many different countries, along with plural operating system variations, may require support. Still further, each model of VAIO for each region/language/country/OS variation contains well over one hundred pieces of software, each of which may be a unique version for only that model, or may be used for multiple models of VAIO, giving an idea of the exponential scope of the relationship between software and computer models the database must be designed to support. In summary, the relationships between software parts and the platforms they are used on have become extremely complex, and with this critical recognition in mind, the invention herein is provided.


In addition, the present invention critically recognizes that the quality of the final product is important. As understood herein, each piece of software may contain defects, or when combined in an image with other software may cause defects to be generated.


SUMMARY OF THE INVENTION

As set forth further below, processes and tools are provided herein for quickly assessing the quality of a project by relating the defects to part releases, which are in turn related to projects. For example, if a major flaw is found in a particular release version of a part, this defect is related to the appropriate part release or releases so that the defect is instantly related to all the projects that use the particular part release. Given the complexity of the software BOMs, without the present invention this task would be difficult and time consuming to do manually.


Thus, preferred implementations of the present invention correlate the relationships between software parts, the platforms they are used on, and the quality of those parts.


A method is disclosed for managing computer production in an enterprise. The method includes receiving a block of software offerings, with each block being associated with at least one product series. A product series component structure is received that defines parts for a respective product series. Parts that are required for a product series are added to the block associated with the series, with parts being assigned to each software class and related software specification pair in a block based on the part or parts required for the pair to thereby define a design structure. The method includes establishing a software bill of materials (BOM) based on the design structure using a template and/or a snapshot.


In non-limiting implementations the method includes defining software offerings. A software offering includes at least one software class and at least one associated software specification. Software offerings are associated with respective product series to establish a configuration, with configurations cumulatively defining a configuration range that contains product offerings of the enterprise for all regions in which the enterprise does business. The method may include grouping classes into blocks. A block is associated with at least one product series.


The non-limiting method may also include defining which classes are dependent on each other, and defining which blocks are base blocks. Defects can be associated with related classes and corrective actions associated with respective defects.


If desired, the method can includes associating a respective installation file with each software offering. Each installation file may include a data file format version number, a version number of an installation data snapshot, an installation order for modules, data required for confirming successful installation, cyclic redundancy check (CRC) data for each binary file, path information for locating files in a file store, partition size information for recovery and customer partitions. Also, installation and recovery tools may use a list of software releases directly instead of microcode, which is used only for customer recovery, with microcode bit mappings being constrained to respective recovery media sets.


In another aspect, a software management database on a computer readable medium can contain data structures supporting computer software provisioning for a range of CTO/BTO variations, language variations, region variations, and operating system variations.


Non-limiting data structures may include bill of materials (BOM) entities containing information related to parent BOMs and child BOMs, if any. Each BOM entity can also include an engineering part ID, a software release ID, a major version ID, a group ID, a component ID, a planning parts ID, and a software series ID. A plan parts entity can also be provided that includes launch dates for software base releases, import dates for software bases indicating when the bases were imported into computers, and identifications for software bases.


Other non-limiting entities in the database may include component entities including launch dates for software base releases, import dates for software bases, identifications for software bases. Software release entities containing a base ID, a name, a file path, a launch date can also be provided, as can be software release status entities that include data representing status and name of a software release. Additional database entities may include: a group entity containing data representing a name and launch of a type, a series entity containing a software series ID, base ID, name, an indication of being active, a launch date, an import date, an engineering parts entity containing an engineering part ID, a base ID, a type ID, a name, a launch date, and indication of dependent parts, an engineering parts major revision entity containing information related to default use, an engineering part software release entity containing information on a related engineering part entity, a related engineering parts major revision entity, a related language code entity, and a language entity containing information related to a language name and a language code.


In another aspect, a computer-implemented system for creating bills of materials (BOMs) includes logic that can be executed by a computer and stored on a computer readable medium. The logic facilitates creation of BOMs using templates and/or snapshots. BOMs can be automatically generated based on part attributes and groups of parts, major versions, and releases. The logic can automatically check BOMs to reduce errors.


In still another aspect, a computer system executing logic stored on a computer readable medium enters, into a first database, first software data. The first software data includes operating systems and configure to order/build to order (CTO/BTO) options. The system transfers at least some of the first software data in the first database to a comprehensive global database, referred to herein colloquially as “ePic.” Second software data such as operating system updates, device drivers, and utilities is automatically adding to a bill of materials (BOM) through the comprehensive global database. Also, software along with metadata that describes the software can be checked into the comprehensive global database by users, and the BOM for a specific series/language/region can be frozen/locked and the process to create factory deliverables including software image, software modules, and data can then begin.


The database tracks defects and relates them to parts, stores test cases which are related to parts which in turn allows test strategies to be auto-generated.


The details of the present invention, both as to its structure and operation, can best be understood in reference to the accompanying drawings, in which like reference numerals refer to like parts, and in which:




BRIEF DESCRIPTION OF THE DRAWINGS


FIGS. 1-3 are diagrams of non-limiting software management phases;



FIG. 4 is a flow diagram of non-limiting overall software development, integration, and factory deployment processes;



FIG. 5 is a flow diagram of a non-limiting software planning process;



FIG. 6 is a flow diagram of a non-limiting bill of materials (BOM) creation process;



FIG. 7 is a flow diagram of a non-limiting software development process;



FIG. 8 is a flow diagram of a non-limiting software integration process;



FIG. 9 is a flow diagram of a non-limiting factory deployment process;



FIG. 10 is a flow diagram of aspects of a non-limiting factory deployment process;



FIG. 11 is a flow diagram of a non-limiting software installation process;



FIGS. 12-17 are non-limiting screen shots used for defect management and test case management purposes;



FIG. 18 is a diagram showing software inputs to the ePic database interface;



FIG. 18A is a flow chart of logic of downloading an image to a test system;



FIG. 19 is a flow chart showing how BOM snapshots are generated, automatically at least in part, and entered into ePic;



FIGS. 20 and 21 are consolidated diagrams showing the interaction between various entities in a non-limiting implementation;



FIG. 22 is a diagram showing various data entities in the ePic database and some of their attributes;



FIG. 23 is a map showing a non-limiting deployment regime;



FIG. 23A is a flow chart showing software integration logic;



FIG. 24 is a flow diagram showing a non-limiting factory deployment process; and



FIGS. 25-27 are further non-limiting defect-related screen shots.




DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT

In the present non-limiting implementation, only part of the software data is contained in a data store referred to below as “DB Hero”. Specifically, software data that is visible to customers (e.g., operating systems, configure to order/build to order (CTO/BTO) options, software highlighted on web sites, etc.) is entered into DB Hero. As set forth in the specification below, periodically, some of the data from DB Hero is pushed to a comprehensive global database referred to herein as ePic, including both stock keeping unit (SKU) data and software data.


Software data that is not as visible to customers (such as operating system updates, device drivers, utilities, etc.) are added to the bill of materials (BOM) through the comprehensive global database. Software is checked into the comprehensive global database by developers, vendors or engineers, along with metadata that describes the software for process tools. The BOM for a specific series/language/region is frozen/locked and the process to create the factory deliverables (software image, software modules, and data) can then be started. As set forth in the detailed specification below, various process tools and manual process can be used to create the factory deliverables, all of which use data stored in the comprehensive global database.


Additionally, the factory deliverables are tested and validated to meet quality standards. The factory deliverables, and the metadata that describes them, are then delivered to the factory to be used in mass production.


To better understand terms used herein, the range of potential software offerings for a given sales cycle is defined as a set of classes and specifications. The class structure captures how the various software items will be offered to the customer, and is a specific type of software. Specifications, on the other hand, are individual software items that are associated with classes. Thus, a specification is an option that the customer may choose within a class, and a class may have more than one specification while a specification is assigned to only one class. Software offerings (classes and specifications) are associated with individual series, with the resulting structure being called the “configuration range.” The configuration range for a SKU is a list of all the Classes (and specifications) that are offered for that SKU.


By way of non-limiting example only, a “class” might be “pre-installed office software”, and specifications within that class from which the customer can select might be “MS Office professional”, “MS Office Small Business”, “MS Office Basic”, and “MS Works.”


With the detailed description below it will be appreciated that the database herein supports software variations in CTO/BTO, language, region, and OS. In addition, this database, and the tools that use it, allow for the creation of CTO systems, based on individual customer orders, in the mass production process with every piece of software preinstalled and ready to use, allowing for a virtually infinite number software offerings to customers as opposed to a few pre-defined options.


Also, unnecessary duplicate data entry is eliminated, hardware components are automatically mapped to software releases, and developers can specify language and geographic region supported for each software release at the time of software check-in, with the correct release being assigned to each BOM automatically. Further, BOMs are created using templates and snapshots for efficiency. Moreover, BOMs are automatically generated based on part attributes to reduce effort, and groups of parts, major versions, and releases can be defined and reused. Automatic checking of the BOMs is provided to reduce errors. In addition, installation and recovery tools use a list of software releases directly instead of microcode, which is used only for customer recovery, with microcode bit mappings being constrained to each recovery media set that is defined. This solves the problem of limited microcode bits and makes the changing of a recovery key easier.


Below are details of one non-limiting implementation of present principles. FIG. 1 illustrates that the present methods may be undertaken by a computer system 10 including one or more enterprise computers 12, each potentially having its own monitor 14 which can display the screen shots described below. The enterprise computers 12 can be used by developers and software engineers to execute the invention. Thus, the logic and the databases herein (including the so-called “DBHero” database 16 and global database 18, referred to herein as “ePic”) may be distributed over plural computers if desired, and some of the method steps may be undertaken by human users of the enterprise computers 12 while other method steps can be undertaken automatically by logic resident on computer readable media in computers. The computer readable media can include but is not limited to RAM, ROM, floppy disks, hard disk drives, optical disk drives, solid state memory devices, etc.


Referring briefly to FIG. 19 out of turn, logic for creating BOMs is shown. Beginning at start state 20, a software developer or integrator selects a software series, discussed above, from a list of series. The series can include data on software that an end user ordinarily “sees”, e.g., operating systems and configure to order/build to order (CTO/BTO) software options.


A human language and/or geographic region is selected at state 24 and then based on the selected language and region, at state 26 a processor in one or more of the enterprise computers 12 shown in FIG. 1 can retrieve a list of component parts, including images and modules. These component parts typically include software the end user ordinarily does not “see” such as operating system updates, device drivers, and utilities.


The software integrator then selects the image or module to be built at state 28, and at state 30 a BOM snapshot from a list is selected for the part selected at state 28. In response, a processor in one or more of the enterprise computers 12 shown in FIG. 1 then downloads, at state 32, BOM items from a file store that may be resident in the global database 18 shown in FIG. 1 to create an image to be loaded onto a computer to be vended. The image is checked in to the global database 18 at state 34 and uploaded to the file store, from whence it may be downloaded in the factory and loaded onto a computer to be vended. The process ends at state 36.


A detailed description of a non-limiting implementation of the invention follows below.


0 Project Objectives


0.1 Goals






    • Enable a global software CTO process which can be used for all VAIO business styles (CTO, BTO, Retail).

    • Redesign the software process from design through manufacturing to be a global process.

    • Define a global modular software specification.

    • Define a global recovery specification.

    • Integrate the software and hardware design process.

    • Shorten lead-time to market.

    • Reduce engineering costs.

    • Shift engineering resources from maintenance roles to value-add development roles.

    • Maintain product quality in the new process.

    • Create a flexible process and system.

    • Automate tasks where appropriate to create greater accuracy and speed in activities.


      0.2 Critical To Quality

    • World-wide scalability.

    • Global access to system (including third parties).

    • Data portability.

    • Multi-language handling for software items.

    • Seamless interfaces to DB Hero.

    • Turn-key factory deployment.


      1 Dependencies and Assumptions


      1.1 Dependencies


      1.2 Assumptions

    • LangRegion Specifications (Specs) in DB Hero will be reused between series.

    • Software parts in DB Hero will be defined so that the “Part Name” and “Major Version” will be separate fields.

    • No language/region specific information will be entered for parts into DB Hero unless royalty/licensing requirements differ by language/region for the given software part.


      2 User Roles and Responsibilities

    • Product Planner
      • Determines the VAIO hardware and software offerings to be made to customers.

    • Program Manager
      • Works with product planners, sales and marketing, and engineering to produce a detailed product plan and offering strategy for each VAIO product series.

    • Software Developer
      • Develops software to be included in VAIO product offerings.
      • Prepares software so that it may be delivered to the factory for installation on products.

    • Software Integrator
      • Uses OPK (OEM Pre-installation Kit) in combination with build systems to prepare images.
      • Prepares data used in the factory to convert manufacturing bills of materials (BOMs) to a list of software items for installation.
      • Prepares data used to facilitate the software recovery by the customer in the event of a failure with their VAIO product.

    • Project Test Lead
      • Person in charge of preparing test cases and test strategies for a series and/or project (project would be Windows beta or VAIO mouse—this concept is not managed by ePic).
      • Assesses defects and devises test strategies to ensure they are fixed.

    • Test Lead
      • Tester in charge of an individual software release/component.
      • Maintain test cases as requirements change.
      • Resolves defects.

    • Tester
      • Tests software deliverables to ensure quality product.
      • Identifies and tracks defects.
      • Reports quality status.
      • Sometimes maintains test cases as requirements change.

    • Factory Engineer
      • Deploys the tools and software deliverables to the factory floor so that they may be automatically installed.
      • Collects data produced in the factory installation process and delivers it to a data warehouse.

    • Customer
      • Makes hardware and software choices when placing an order for a custom product.
      • Initiates the recovery process in the event of a system failure.
      • The customer does not interact with the SIFD system directly.

    • 3rd Party Developer
      • Checks current software releases.

    • 3rd Party Factory Engineer/QA Tester
      • Downloads or receives software deliverables and tools.


        3 Business Process


        3.1 Hardware Design





The Software Integration and Factory Deployment Project solution will operate within the context of the new design process specified as part of the DB Hero project. FIGS. 1 through 3 represent a non-limiting version of DB Hero process.



FIGS. 1-3 do not include software related tasks. One objective of the proposed invention is to integrate the software and hardware design processes.


3.2 Overall Software Process—Now referencing the non-limiting process outlined in FIG. 4.






    • 1. Software Planning and Design
      • a. Description
        • i. Program Managers and Product Planners define software offerings.
      • b. Inputs
        • i. Previous cycle's software offerings.
        • ii. New software offerings.
      • c. Outputs
        • i. Configuration (Config) Range and Component Structure.
      • d. System Interactions
        • i. Offering structure and planning parts are entered in DB Hero.
        • ii. Planning Parts and Component Structure are transferred to ePic.

    • 2. Software Development
      • a. Description
        • i. Register engineering parts and develop software.
      • b. Inputs
        • i. Software offerings.
        • ii. Planning parts from DB Hero.
      • c. Outputs
        • i. Software applications, drivers, documentation, and other software items.
      • d. System Interactions
        • i. Part registration and item check-in in ePic.

    • 3. Software Integration
      • a. Description
        • i. Define image BOMs, build images, define media sets (factory and recovery), and prepare factory deliverables.
      • b. Inputs
        • i. Software items checked-in by developers.
      • c. Outputs
        • i. Images, Modules, and Series Software BOM.
      • d. System Interactions
        • i. Register parts.
        • ii. Check image releases.
        • iii. Create series software BOM.
        • iv. Define recovery media.

    • 4. Release to Manufacturing
      • a. Description
        • i. Planner or Program Manager issues a RTM for a series/region.
      • b. Inputs
        • i. Series software BOM.
      • c. Outputs
        • i. Installation data file. RTM'ed image and module releases.
        • ii. RTM Notification.
      • d. System Interactions
        • i. RTM is issued in ePic.
        • ii. Installation data file is auto-generated in ePic.

    • 5. Download installation data, images, and modules to factory
      • a. Description
        • i. Factory engineer downloads required files from ePic or receives them by disk.
        • ii. Factory engineer deploys the files to manufacturing servers.
      • b. Inputs
        • i. Notification email of updated installation data.
      • c. Outputs
        • i. Factory has up to date BOM information and all required images and modules.
      • d. System Interactions
        • i. Factory engineer downloads or receives latest version of installation data file.
        • ii. If the factory receives files by network, the factory file store system automatically downloads required images and modules and removes obsolete files.
        • iii. If the factory receives files by disk, the factory engineers load the files manually into the local factory file store.


          3.3 Planning





The process outlined in the non-limiting diagram of FIG. 5 may be carried out in the DB Hero system. This process describes how the software and hardware design processes are integrated in DB Hero.


The process definitions are tailored to capture details relevant to SIFD only. Details of the hardware design process are not captured here.


This process describes how the software and hardware design processes are integrated in DB Hero.

    • 1. Define Series
      • a. Description
        • i. Hardware planners define the series code names and numbers for a given sales cycle.
      • b. Inputs
        • i. The list of new product series to be offered for a given sales cycle.
      • c. Outputs
        • i. Series prototype numbers.
        • ii. Series code-names.
      • d. System Interactions
        • i. Series information is entered into DB Hero.
    • 2. Identify Software Offerings
      • a. Description
        • i. The planner or program manager defines the software strategy for a given sales cycle. This strategy does not yet specify which software offerings will be made at a series level.
        • ii. Sony and 3rd party software offerings that may be carried over from a previous cycle are identified.
        • iii. New Sony and 3rd party software offerings are identified.
        • iv. Updates to existing specifications are made if required.
        • v. New specifications are added to classes if required.
      • b. Inputs
        • i. Previous cycle 3rd party vendor software items.
        • ii. Previous cycle Sony software items.
      • c. Outputs
        • i. The tentative list of 3rd party and Sony software offerings for the given sales cycle.
      • d. System Interactions
        • i. None.
    • 3. Define Classes and Specifications
      • a. Description
        • i. A “Class Definition Committee Meeting” is held multiple per year. The purpose of each meeting will be to define the software classes and their contents (specifications) to be used two sales cycles later. Hardware classes are defined separately.
        • ii. The range of potential software offerings is defined for the given sales cycles as a set of classes and specifications. Offerings for individual product series will not be defined at this point.
        • iii. The classes and specifications defined are global and commonly used across all regions. The class structure captures how the various software items will be offered to the customer.
        • iv. Specifications for individual software items, if known, are identified and associated with classes.
      • b. Inputs
        • i. Previously defined classes and specifications.
        • ii. New class definition ideas.
      • c. Outputs
        • i. Class Names.
        • ii. Specification Names (e.g. class contents).
        • iii. Class/Specification relationships.
      • d. System Interactions
        • i. A DB Hero administrator enters the classes into DB Hero. Users cannot input classes due to limitations of DB Hero Software.
        • ii. A Product Planner or Program Manager enters specification information and class/specification relationships into DB Hero.
    • 4. Define Planning Level Parts (e.g. royalties, catalogue, etc.)
      • a. Description
        • i. Software offerings are broken down into individual parts. Offerings which have varying royalty, licensing, or catalogue requirements must be broken up into discrete items.
        • ii. These parts will be associated with classes and specifications during the block definition process at a later time.
        • iii. These parts will later be used in ePic to help create SW BOMs.
      • b. Inputs
        • i. Software offerings.
        • ii. Royalty, licensing, and catalogue requirements.
      • c. Outputs
        • i. List of software Parts.
      • d. System Interactions
        • i. The parts identified are registered in DB Hero.
    • 5. Define Offerings Structure and Constraints
      • a. Description
        • i. Software offerings (classes and specifications) are associated with individual series. The resulting structure is called the Config Range. The Config Range is global in scope and contains all product offerings, both hardware (HW) and software (SW), for all regions.
        • ii. Constraints on the offering range are identified as necessary for engineering or business reasons. These constraints are also global in scope; they do not reflect regional constraints. Regional constraints will be implemented in regional CTO sales systems or implicitly included in fixed configurations defined from the Config Range.
      • b. Inputs
        • i. The software offerings (classes and specifications) identified for the given sales cycle.
      • c. Outputs
        • i. Offering strategy, structure, and constraints, series by series.
      • d. System Interactions
        • i. The classes selected are associated with a series and are entered in DB Hero resulting in the Config Range.
        • ii. Constraints are defined in DB Hero as rules against the Config Range.
    • 6. Define Block Structure
      • a. Description
        • i. Block structure definitions are used to generate the component structure. Users group classes into blocks and define which classes are dependent on each other and which blocks are “base blocks.”
      • b. Inputs
        • i. Config Range for each series.
      • c. Outputs
        • i. Block structure of the classes for a given series.
        • ii. Component Structure without parts.
      • d. System Interactions
        • i. The blocks defined are entered in DB Hero.
        • ii. Classes are associated with the blocks per the defined block structure in DB Hero.
        • iii. “Dependency” and “Base Block” flags are set as required.
    • 7. Confirm Component Structure
      • a. Description
        • i. Program Manager or Product Planners confirm components without parts whether these components are made in just proportion—without exaggeration or omission—for their region.
        • ii. Confirmation of components is done by each region.
      • b. Inputs
        • i. Component Structure without parts.
      • c. Outputs
        • i. Confirmation List.
      • d. System Interactions
        • i. None.


          Notes:
    • 1. DB Hero series can be made “cycle-less” by adding an additional class specifying product cycle or software revision for integrators to manage software offerings from series to series.


      3.4 Engineering Software BOM Creation—Now referencing the non-limiting process outlined in FIG. 6.
    • 1. Transfer Parts and Series info to ePic
      • a. Description
        • i. The parts and series defined DB Hero are transferred to ePic.
      • b. Inputs
        • i. Series and Parts registered in DB Hero.
      • c. Outputs
        • i. Series and Planning Parts registered in ePic.
      • d. System Interactions
        • i. Scheduled system process and/or user initiated process.
    • 2. Planning BOM Creation
      • a. Description
        • i. Parts required for each block are added to the block structure for a series. The parts are assigned to each class/specification pair in a block based on which parts are required for that option. This structure is called the “Design Structure.”
        • ii. When the Design Structure is complete, DB-Hero generates the Component BOM, e.g. Component Structure, for the series.
      • b. Inputs
        • i. Block Structure.
        • ii. Parts.
      • c. Outputs
        • i. Component Structure with parts.
      • d. System Interactions
        • i. Parts are associated with specs via a block/spec pivot table DB Hero.
    • 3. Define engineering image and module parts as required
      • a. Description
        • i. Developer or integrator defines engineering parts in ePic as required. ePic engineering parts can include many things, including images, modules, recovery media sets, documentation, etc.
        • ii. Developer defines technical attributes of each part. (See ePic attributes below for more details.)
        • iii. Developer optionally specifies the target series for this part. One or more target series may be specified.
        • iv. Developer specifies the languages to be supported by this part.
        • v. Developer specifies dependencies between this part and other parts.
        • vi. Developer provides installation instructions, including installation order.
        • vii. Once these parts have been fully registered in ePic, associated software releases for the standalone parts can be checked-in.
        • viii. Composite parts, e.g. images, multipart modules, and recovery media, will require BOMs to be created before automated building can begin.
      • b. Inputs
        • i. Information from hardware engineers, software engineers, and planners.
      • c. Outputs
        • i. List of parts with their associated attributes and target series/language information.
      • d. System Interactions
        • i. Parts, attributes, and target series/language information is entered into ePic via user interface.
    • 4. Associate planning level parts with engineering parts
      • a. Description
        • i. Developer/Integrator associates planning parts from DB Hero with one or more engineering parts defined in ePic.
        • ii. This activity is done for any planning parts that correspond to ePic engineering parts.
        • iii. These associations will be used later to generate the “Series Software BOM”.
      • b. Inputs
        • i. DB Hero part list (planning parts).
        • ii. Engineering parts as defined in ePic.
      • c. Outputs
        • i. Planning to engineering part associations.
      • d. System Interactions
        • i. The associations will be created via ePic user interface.
    • 5. Define image & module contents where required
      • a. Description
        • i. Developer/integrator creates individual image/module BOMs by defining relationships between parts. The Engineering Parts to be included in a given image or module are specified as the children of the top level part.
      • b. Inputs
        • i. Parts completely defined in ePic.
      • c. Outputs
        • i. Image/module BOMs.
      • d. System Interactions
        • i. Developer/Integrator creates BOM structures in ePic using functions specific to each part type, e.g., “Image Planner”, “Media Planner”, “Module Planner.”
    • 6. BOM Confirmation
      • a. Description
        • i. Program Managers or Product Planners confirm component structure.
        • ii. Confirmation of component structure is done by each region.
      • b. Inputs
        • i. Component Structure, including parts.
      • c. Outputs
        • i. Confirmation list or minutes of meeting.
      • d. System Interactions
        • i. None.
    • 7. Transfer Component BOM to ePic
      • a. Description
        • i. The component BOM for a given series is transferred to ePic.
      • b. Inputs
        • i. DB Hero Component BOM.
      • c. Outputs
        • i. Component BOM registered in ePic.
      • d. System Interactions
        • i. Scheduled system process and/or user initiated process.
    • 8. Create Series Software BOM
      • a. Description
        • i. The “Series Software BOM” is a detailed BOM containing all the software releases assigned to a given product series and their relationship to DB Hero Component part numbers. It represents all the software releases (image, module deliverables) that could be installed on a unit and not the software BOM for a specific configuration.
        • ii. This BOM is initially generated automatically based on the target information of engineering parts, engineering part associations with planning parts, and the DB Hero Component BOM. The user can then make changes before the BOM creation process is complete.
        • iii. This data will be combined with recovery and installation data to create an installation data file for the factory.
        • iv. After initial generation, this BOM may be manually modified in the system to manage exceptions/limitations of software releases that are not covered by basic assignment to series and languages or DB Hero constraints.
      • b. Inputs
        • i. Image/module target series information.
        • ii. Planning part/engineering part associations.
        • iii. DB Hero Component BOM.
      • c. Outputs
        • i. Series Software BOM.
      • d. System Interactions
        • i. User will create Series SW BOM using a wizard.
        • ii. Series Software BOM may be edited via ePic UI.


          3.5 Software Development—Now referencing the non-limiting process outlined in FIG. 7.
    • 1. Register DB Hero Part
      • See section 7.3, step 4.
    • 2. Transfer Parts to ePic
      • See section 7.4, step 1.
    • 3. Register Part (ePic)
      • See section 7.4, step 3.
    • 4. Associate Planning Parts with Engineering Parts
      • See section 7.4, step 4.
    • 5. Develop Software Module
      • a. Description
        • i. Software Developer codes software module.
      • b. Inputs
        • i. Part definition and technical attributes as specified in ePic.
      • c. Outputs
        • i. Packaged software module with all required installation scripts.
      • d. System Interactions
        • i. None.
    • 6. Check-in Software Module
      • a. Description
        • i. Developer checks-in a software build.
        • ii. Developer updates technical attributes as required. These attributes include installation details, supported languages and other technical information about the release.
        • iii. Developer logs release notes.
      • b. Inputs
        • i. Packaged software module with all required installation scripts.
      • c. Outputs
        • i. Module is stored in the ePic file store.
        • ii. Technical information and release notes stored in ePic.
      • d. System Interactions
        • i. The module check-in procedure will be initiated via ePic user interface or client utility.
        • ii. Files will be uploaded to a local file store, should they be available. If the files represent a module or application, they will be replicated automatically to other file stores. If files represent an image, they will not be replicated to other file stores unless other system users request the replication.


          3.6 Software Integration—Now referencing the non-limiting process outlined in FIG. 8.


ePic system interface can engage each regional build tool implementation.

    • 1. Extract Build Info
      • a. Description
        • i. Integrator initiates build process. Build tools gets build data from ePic to be used as input to the build tools.
      • b. Inputs
        • i. ePic image BOM and technical attributes.
      • c. Outputs
        • i. Build data formatted generically.
      • d. System Interactions
        • i. Each regional build system will interface with ePic to obtain image BOMs and software parts.
    • 2. Build Image
      • a. Description
        • i. Image is constructed using build tools.
      • b. Inputs
        • i. Build data extracted from ePic.
      • c. Outputs
        • i. Image files and additional data to be stored in ePic.
      • d. System Interactions
        • i. None.
    • 3. Check-in Image
      • a. Description
        • i. Integrator checks-in image files to ePic.
      • b. Inputs
        • i. Image files and additional data to be stored in ePic.
      • c. Outputs
        • i. Image files are store in the ePic file store and relevant data is updated.
      • d. System Interactions
        • i. Information required for check-in will be entered manually into ePic via UI or supplied by the build system via an interface to ePic.
        • ii. Image files are uploaded to local file store as part of check-in function.


          3.7 Test Management and Defect Tracking
          embedded image

          3.8 Factory Deployment


          3.8.1 Online Factory Deployment Process—Now referencing the non-limiting process outline in FIG. 9.
    • 1. Release to Manufacturing
      • a. Description
        • i. Program Manager releases a series to manufacturing. This is done at for a Series/LangRegion combination.
        • ii. The system performs a number of sanity checks:
          • 1. Ensure that all SW releases are Golden Master or Release Candidates.
          • 2. Ensure that releases exist in the system for the selected LangRegion.
      • b. Inputs
        • i. Series SW BOM.
      • c. Outputs
        • i. New snapshot of RTM'ed Series SW BOM.
      • d. System Interactions
        • i. PM issues RTM in ePic.
    • 2. Generate Installation Data File
      • a. Description
        • i. The system updates the Installation Data File for the RTM'ed releases.
      • b. Inputs
        • i. Series Software BOM.
        • ii. Software release attributes.
      • c. Outputs
        • i. Updated installation data file.
      • d. System Interactions
        • i. None. This is an automated ePic process.
    • 3. Notify Factory Engineers
      • a. Description
        • i. ePic notifies factories that installation data has been updated. Only factories that are affected should be notified.
      • b. Inputs
        • i. Changed Installation data file.
      • c. Outputs
        • i. Email notification message.
      • d. System Interactions
        • i. None. Automated ePic process.
    • 4. Download Installation Data File
      • a. Description
        • i. Factory Engineer downloads the installation data file from ePic.
      • b. Inputs
        • i. Notification email.
      • c. Outputs
        • i. Latest installation data file.
      • d. System Interactions
        • i. Initiate update of installation data file for the Series/LangRegion via file store function.
    • 5. Download Image and Module Files.
      • a. Description
        • i. The factory file store is updated with the latest image and module files.
      • b. Inputs
        • i. Installation data file.
      • c. Outputs
        • i. New required images and modules are downloaded to local file store.
        • ii. Obsolete images and modules are deleted from local file store.
      • d. System Interactions
        • i. Initiate update of image/module releases for the Series/LangRegion via file store function.
    • 6. Place order (NOTE: This step does not involve interaction with ePic. It is depicted here to show the order process relative to factory deployment for a CTO sales process).
      • a. Description
        • i. Customer places an order on a sales system.
      • b. Inputs
        • i. Customer CTO choices or Fixed SKU selection.
      • c. Outputs
        • i. Configuration as a list of DB Hero components.
      • d. System Interactions
        • i. Customer places order in sales system.
        • ii. Sales system or order management system passes order on to factory shop floor control system.
        • iii. Factory shop floor system delivers list of components to installation tools.
    • 7. Install Software
      • a. Description
        • i. The installation data file and list of components in a file for the configuration are provided as inputs to the installation tools.
        • ii. The installation tools automatically install required software. See section 7.9 for further details.
      • b. Inputs
        • i. Configuration of DB Hero component part list.
        • ii. Installation data file from ePic.
      • c. Outputs
        • i. Log data file.
      • d. System Interactions
        • i. Installation tools are executed via automated factory process.
        • ii. Log file must be collected to a central location (should be implemented in factory process).
    • 8. Deliver Log data to GARATA
      • a. Description
        • i. Log data file generated during the installation process is delivered to GARATA for loading into the database.
      • b. Inputs
        • i. Log file from installation process.
      • c. Outputs
        • i. Log file stored in GARATA or other data warehouse system.
      • d. System Interactions
        • i. Log file should be delivered to appropriate Sony server by FTP or other means.
        • ii. Files should be loaded into a database.


          3.8.2 Offline Factory Deployment Process is shown in FIG. 10.


          3.8.3 Running Change Process


This section describes how running changes would be issued using ePic. This is the VOA EPC process adapted to ePic functionality.


3.8.3.1.1 Purpose


To facilitate, review and implement any Engineering Processing Changes (EPC's) to projects after initial RTM has been issued.


3.8.3.1.2 Definitions


EPC-A: A running change in which existing software on the Series Software BOM RTM snapshot is patched in the manufacturing process. These are deployed as modules of type EPC. There are two types of EPC modules:

    • Temporary—Applied during imaging and “thrown away”. Not in HDD recovery partition.
    • Permanent—Applied during imaging and “kept”. Copied to the HDD Recovery Partition.


EPC-M: A running change in which a foundation image or module is added/changed/deleted to/from the RTM snapshot of a Series SW BOM.


3.8.3.1.3 Deliverables






    • EPC Notification—an automatic email triggered when a program manager re-issues an RTM.

    • EPC Executable—module checked-in to an ePic file store and distributed using online (network) or offline (media) delivery methods.

    • Updated Installation Data File (IDF).

    • Testing Result (Product Quality Group).

    • Testing Result, if applicable (Manufacturing Quality Group).

    • Date EPC was implemented (Manufacturing)—relevant data should be delivered to GARATA.


      3.8.3.1.4 Participants

    • Program Management Representative

    • Software Integration Representative

    • Quality Group Representative

    • Sustaining Group Representative

    • Application Champion or other applicable group representative

    • Manufacturing Representative


      3.8.3.1.5 Roles & Responsibility



  • 1. Program Manager—Initiates EPC request, facilitates the documentation, posting and announcement of EPC release. Issues RTM in ePic to release the IDF and images/modules.

  • 2. Software Integration Representative—Creates executable, checks in executable to ePic, announces release.

  • 3. Quality Group Representative—Tests and verifies EPC on applicable models.

  • 4. Manufacturing Representative—Tests and verifies EPC on applicable models, if applicable. Implements EPC and provides date of when EPC was implemented.


    3.8.3.1.6 Process

  • 1. Program Manager will email a software integration representative for an EPC request.
    • a. Email should appropriate documentation: issue(s), resolution, applicable models.

  • 2. Software Integrator will create EPC module or replacement image module. This may also be performed by the developer.
    • a. New release will be checked-in to ePic.
    • b. Appropriate changes will be made to the Series SW BOM template.
    • c. New snapshot of the Series SW BOM Template will be created and flagged as a release candidate (RC).
    • d. Quality group will be notified.

  • 3. Quality member tests software module.
    • a. Test strategies are updated.
    • b. Testing is performed and test results logged.
    • c. If testing fails Integrator is notified and steps from #2 repeated.
    • d. If testing is successful all interested parties are notified.

  • 4. Program manager issues an RTM for each applicable Series/LangRegion in ePic.
    • a. System sends running change notification to applicable persons.

  • 5. Installation data file and new release(s) are delivered to factory.
    • a. Online or offline factory deployment methods documented above are used to deploy EPC.

  • 6. If applicable, factory quality group tests new deliverables.
    • a. If testing fails, interested parties are notified and steps from #2 repeated.
    • b. If testing succeeds, interested parties are notified.

  • 7. Factory Engineer deploys new deliverables are deployed in production environment.
    • a. Data concerning which units have the EPC applied is collected (from installation tool log data) and delivered to persons responsible for loading data into GARATA.


      3.9 Installation



The installation process and tools will be common for all QA, Factory, and Recovery applications and is in reference by the non-limiting process of FIG. 11.

    • 1. Generate Software Release List
      • a. Description
        • i. The list of DB Hero component part numbers representing a configuration are converted into a list of software releases.
        • ii. This step can be skipped and process can begin from step 2 if a valid software release list has been generated by other means.
      • b. Inputs
        • i. Configuration (DB Hero component part list).
        • ii. Installation data file from ePic.
      • c. Outputs
        • i. List of software releases.
      • d. System Interactions
        • i. Installation tools function.
    • 2. Generate Recovery Key
      • a. Description
        • i. A list of software releases is used to generate a MCode.
      • b. Inputs
        • i. Software release list.
        • ii. Installation data file.
      • c. Outputs
        • i. Encrypted MCode.
      • d. System Interactions
        • i. Installation tools function.
    • 3. Write Recovery Key to DMI
      • a. Description
        • i. The Encrypted MCode is written to DMI.
      • b. Inputs
        • i. Encrypted MCode.
      • c. Outputs
        • i. MCode stored in DMI.
      • d. System Interactions
        • i. This is done using DMI writing tools.
    • 4. Partition Hard Drive
      • a. Description
        • i. The hard drive is partitioned according to data in the installation data file.
      • b. Inputs
        • i. Installation data file.
        • ii. Series and LangRegion.
      • c. Outputs
        • i. Hard drive is partitioned appropriately.
      • d. System Interactions
        • i. Installation tools output a list of partitions with sizes.
        • ii. Partition tools are used to partition the hard drive as part of factory process.
    • 5. Copy required file to recovery partition (HDD Recovery Only).
      • a. Description
        • i. If the series uses HDD Recovery partition, the recovery partition is prepared by the installation tools:
        • 1. The WinPE recovery partition is written to P1.
        • 2. Images modules and required data are copied to the recovery partition.
        • 3. Installation data file (or a portion of it) are copied to recovery partition.
      • b. Inputs
        • i. Software release list.
        • ii. Installation data file.
      • c. Outputs
        • i. Recovery partition is completely setup.
      • d. System Interactions
        • i. Installation tools function.
    • 6. Prepare Customer Partition(s)
      • a. Description
        • i. If the series uses HDD recovery, then the customer partitions are prepared by initiating the user recovery process in “unattended mode.”
        • ii. If HDD recovery is not used, the installation tools prepare customer partitions directly.
      • b. Inputs
        • i. Installation Data File.
        • ii. Software Release list.
      • c. Outputs
        • i. Customer partitions are prepared.
      • d. System Interactions
        • i. Installation tool function.
    • 7. Generate Log Data
      • a. Description
        • i. Data about the releases installed are stored in a file suitable for loading into GARATA or any other data warehouse.
      • b. Inputs
        • i. Data about installation activities.
        • ii. Information about the unit (S/N, service tag, MCode, etc).
      • c. Outputs
        • i. File containing log information.
      • d. System Interactions
        • i. Creation of the log file is an installation tools function.
        • ii. The log file must be collected and delivered to appropriate system as part of factory process.


          Within this process flow, three use cases for installation tools will be supported:
    • 1. Installation using a list of DB Hero component part numbers.
      • a. Convert list of component part numbers to list of software releases.
      • b. Generate MCode using list of software releases.
      • c. Install software.
    • 2. Installation using a MCode.
      • a. Generate list of software releases using MCode.
      • b. Install software.
    • 3. Installation using a list of releases.
      • a. Generate MCode (optional).
      • b. Install software.
    • Factory Installation will use method #1 only. For retail models the DB Hero component part number list can be prepared offline and distributed at RTM time.
    • Recovery Media Sets (RDVD's or Fulfillment Media) can use method #2.
    • HDD Recovery and recovery using customer created media can use method #3.
    • Test system preparation can use all three methods.


      3.10 Recovery


      3.10.1 Recovery Media Preparation
    • 1. Define recovery media engineering parts.
      • a. Description
        • i. Engineering parts for fulfillment recovery media are defined in ePic as “Recovery Media Sets.” Engineering parts for user created recovery media are not defined.
        • ii. NOTE: ePic need not be aware of specific recovery media types (SRCD, ARCD, etc.). This can be managed by recovery media creation tools. ePic also need not support media layout functions; eventually only RDVD's with a single set of recovery tools and factory distribution media need be supported.
      • b. Inputs
        • i. Series Software BOM snapshot.
        • ii. Additional Engineering parts required for recovery media.
        • iii. Media set specific information.
      • c. Outputs
        • i. Recovery media BOM in ePic.
      • d. System Interactions
        • i. User defines recovery media using “recovery media planner” in ePic.
    • 2. Generate MCode Specification.
      • a. Description
        • i. System calculates MCode Specification. An MCode Specification (or MCode Spec) is a set of bit/release relationships. More than one release can be assigned to one bit.
      • b. Inputs
        • i. Series Software BOM.
        • ii. Component/Release Mappings.
      • c. Outputs
        • i. MCode Specification.
      • d. System Interactions
        • i. Automated process with possible manual intervention.
    • 3. Create Recovery Media.
      • a. Description
        • i. Recovery Media (AKA, Fulfillment Media or RDVD's) are created using external tools.
        • ii. Tools use BOM's created in ePic.
        • iii. Optionally, media images can be checked into file store as a software release.
      • b. Inputs
        • i. Recovery Media BOM and attributes as defined in ePic.
      • c. Outputs
        • i. Physical Recovery Media.
        • ii. Optionally, media images.
      • d. System Interactions
        • i. Media creation tools interface with ePic to retrieve Recovery Media BOM and part attributes.
        • ii. Media images optionally checked-in to ePic file store.


          4 Interactions with other systems.


          4.1 Overview


ePic will interface with many systems and tools. This chapter summarizes those interfaces.

    • 1. DB Hero
      • a. DB Hero may be the global product data management system (PDM) for the VAIO business.
      • b. ePic can gather data from DB Hero to be used in BOM creation and factory deployment.
      • c. ePic can interface directly to DB Hero to retrieve needed data. No data need be fed back into ePic.
    • 2. Image/Module Build Tools
      • a. Tools used to build image (or module) releases and check them into the ePic file store.
      • b. ePic will export BOM data to these tools and provide functionality for checking in binary releases.
      • c. Data and functionality will be exposed to tools via an interface DLL.
    • 3. Test System Preparation Tools
      • a. Tools used to install software on systems to be used for testing.
      • b. ePic will expose BOM data for pre-integration testing and installation data files for post-integration testing.
      • c. Data and functionality will be exposed to tools via an interface DLL.
    • 4. Media creation Tools/Systems
      • a. Tools used to create recovery and factory media. Similar to image building tools.
      • b. ePic will export BOM data to these tools and provide functionality for checking in media image releases.
      • c. Data and functionality will be exposed to tools via an interface DLL.
    • 5. VELSUN
      • a. Global sustaining defect tracking system.
      • b. ePic will provide functionality for exporting defects to this system.
    • 6. VALSUN
      • a. Software development defect tracking system.
      • b. ePic will provide functionality for exporting defects to this system.
    • 7. ESG
      • a. VOE sustaining system.
      • b. ePic will export software parts and BOM data and defects to this system.
    • 8. OASIS
      • a. VOA tool to create MCode writing floppy disks.
      • b. Used by many Sony personnel to image systems with Recovery Media.
      • c. ePic will pass simple parameters to this system using an HTTP GET/POST request.


        4.2 A Project Peripheral Components


Several components external to the core ePic system will be developed by Neusoft, VOA, and VBD to facilitate these system interactions. Detailed requirements for these components are captured throughout chapter 9.

    • ePic Interface DLL
      • Win32 library.
      • Detailed requirements in chapter 9.14.
    • Installation Tools
      • Installation tools used in for testing, factory installation, and recovery media
      • Tools use the ePic installation data file, DB Hero component list, and/or software release list as inputs.
      • Tools output data suitable for import to GARATA.
    • Test System Preparation CD
      • WinPE based CD may be used to install software releases managed by ePic on test systems to be developed by SIT.
      • Current US implementation, called MINDS (Modular Installation Network Download System), adapted to meet requirements interacts with ePic using the ePic Interface DLL and utilize the Installation Tools.
    • MCode Encoder/Decoder DLL
      • Mcode encoding/decoding libraries adapted to work with ePic Installation Data Files by SIT.
      • This library used by both ePic and Installation Tools for all MCode encoding/decoding requirements.


In addition to the above components, build systems interface with ePic and use ePic data (see chapter 12). SIT's build system (Magellan) will interface with ePic using the ePic Interface DLL. SDNA will use the build system provided by VOA.


5 Requirements


5.1 Key Terms


The following terms are important for understanding requirements in this section. Additional terms are defined in chapter 13.

  • LangRegion: Term used to describe the combination of an ISO-639 language code with an ISO-3166-1 country code. (For example, “es_SP”, “es_MX”, “jp_JP”, “en_UK”, “en_US”, etc.). ePic and DB Hero will use LangRegion codes to define which language/region combo is to be supported by a software release.
  • Engineering Part: All software, documentation, and media sets are defined as “engineering parts” in ePic. Each engineering part can have many software releases associated with it.
  • Major Version: Attribute of an Engineering Part referring to the Major Version of a software item. Major Version is treated like an individual entity in ePic for certain functions.
  • Release: A release corresponds to a specific set of files and directories checked into ePic for a specific engineering part. Releases can satisfy one or more LangRegions.
  • Planning Part: ePic term for software parts defined in DB Hero.
  • Packaged Software: Software which has been packaged using WISE, Install Shield or some other installer technology (whether it was packaged by Sony or an ISV). Packaged Software is NOT the same as a module.
  • Foundation Image: Also known as “Base Image”. This is a set of files includes the OS and any software items (drivers, utilities, etc.) the integrator chooses to include. Recovery related components (PAC files, data files, etc.) are also considered a part of the Foundation Images.


    Module: Software packaged with WISE which is suitable for use by factory installation tools (the installation is silent/unattended; the installation can be verified by install tools; the module is BIOS locked; etc.). ePic will support three types of modules: “Module”, “X-Module”, or “EPC.” “Modules” install in a single configuration. “X-Modules” are can install different configurations depending on target system characteristics. “EPC's” (Engineering Process Changes) are used for patches or running changes.


    General


Requirements that apply to all aspects of the system are listed here.


5.1.1 Usability/Performance

IDDescriptionCommentsPriorityGEN-2.1All system data should be stored and presented indouble-byte characters.GEN-2.2All user interface prompts, command line tools, andNo internationalizationonline documentation will be in English only.of UI's!GEN-2.3System should perform adequately for users inremote regions so that work schedules are notimpacted by network speeds.GEN-2.3.1Page views via the Sony intranet shall take no morethan 10 seconds per view.GEN-2.3.2Uploads/downloads between file stores on the Sonyintranet should occur at a minimum rate of 450 MBper hour (1 Mbps).GEN-2.4Online user documentation should be available.


5.1.2 Availability

IDDescriptionCommentsPriorityGEN-3.1The main system (ePic) must be available to all Sonyusers 24 hours a day via intranet.GEN-3.2Manufacturing deliverables should be available to 3rdIf network delivery is available, it isparties.preferred, but an offline deliverymethod could also be used.GEN-3.2.1Only RTM'ed or Test RTM'ed items should memade available to 3rd party factories.GEN-3.2.3Pre-release deliverables may be distributed to 3rdparties (for example, for validation purposes). Suchdeliveries should be limited to only what is requiredto ensure efficient use of resources.GEN-3.3Release check-in functionality should be available toPer 2005-6-30 BRD feedback from3rd parties not on the Sony Network.VBD.


5.1.3 Support

IDDescriptionCommentsPriorityGEN-4.1Live support for the system mustbe available to all users 24 hours a day.


5.1.4 Security

IDDescriptionCommentsPriorityGEN-1.1Authentication policy as specified by SGS,The SGS operated“Common Authentication”system will be used forauthentication for all users.GEN-1.1.1System should be accessible only to named users.GEN-1.2Authorization policy.GEN-1.2.1System authorization will be role/resource based.See table in 9.2.4.1 for role to resource mappings.GEN-1.2.2Authorization of the web-based application will beperformed at a screen level.GEN-1.2.3Users can be assigned to one or more roles.GEN-1.2.43rd party users can only access data for series whichthey have been explicitly authorized to view.Requirements to berovided by SGS.


5.1.4.1 Role to Resource Mapping


Each instance of an entity can also have an “owner list”. Users with permissions to create/edit and entity can add other users to the owner list. Users on the owner list can edit that instance of the entity regardless of their assigned system role(s).

Role3rdProject TestFactoryPartyResource/FunctionPM/PlannerDeveloperIntegratorTesterTest Leadtext missing or illegible when filedEngineerUser*AdminBOM-1.1: Manage series information.XXXBOM-1.2: Manage planning parts.XXXXINT-1.12: Create/edit SKU's.XXXBOM-1.9: Create/edit sample SW BOMsXXX(release lists).BOM-1.3/DEV-1.1: Manage engineeringXXXparts.BOM-1.4: Manage images.XXBOM-1.6: Create series SW BOM.XXBOM-1.7: Set dependencies.XXXBOM-1.8: Create/edit groups.XXDEV-1.2: Check-in SW releases.XXXXMFG-1.1/MFG-1.2: Issue RTM/Test RTM.XXDownload installation data and binary data forXXXXXXXSW releases.Download latest DB Hero data into ePic.XXAdd users, set privileges.XManage 3rd party access.XSet champion of parts.XXMass edit entities.XCreate/edit Test Case.XXXCreate/edit Test System.XXXXCreate/edit Test Strategy.XXXEdit Test Case Result.XXCreate/Edit Defect (except for status andXXXXXXXXXresolution).Create/Edit Defect (set status and resolution,XXXXXXexcept for “fix-verified” resolution).Create/Edit Defect (all attributes).XXXXDefined MDA/Benchmark categories/keys forXtest cases.Edit miscellaneous IDF DataXX
    • Third party users can only view data for Series they have been authorized to view (see section 9.13.1, requirement ADM-1.3, “Manage 3rd party data access.”).
    • For VBD/SDNA, software project leaders (SPL's) will be assigned both the “PM/Planner” and “Developer” roles.


5.1.5 Legacy Data

IDDescriptionCommentsPriorityGEN-5.1For all groups who require any legacy data to beData will be manually entered to assist inloaded, legacy data will be manually entered andtraining users and quality testing.software releases manually checked-in.ePic schema is significantly different fromany existing systems. Data import may beimpractical.


5.2 Planning


These are requirements for the “high-level planning” functions implemented in DB Hero that impact SIFD. Only business rules or functional requirements which are necessary to ensure proper SIFD functionality are captured here.


5.2.1 Usage Requirements

IDDescriptionCommentsPriorityRegional differentiation of software offeringswill be managed in ePic.custom characterThis is generically solved by implementingcustom characterDB Hero “spec to component relationship”functionality (see section 9.6, INT-1.9).


5.2.2 Business Rules

IDDescriptionCommentsPriorityPLAN-2.1A special DB Hero ClassePic must use this(e.g., Product Cycle or SWto revise softwareRevision) must be introducedfrom cycle-to-cycle.into a Series Config Range inorder for the Series to be“cycle- less.”


5.3 Engineering Software BOM Creation


Requirements for the “low-level planning” functions and software BOM creation in ePic are listed here.


The following is a graphical representation of an ePic Engineering Part to help readers understand requirements:
embedded image


5.3.1 Usage Requirements

IDDescriptionCommentsPriorityBOM-1.1Manage series information.BOM-1.1.1A series can be designated as active or inactive to1indicate whether the series is EOL.BOM-1.1.2Product cycle (SP05, SU05, FA05) must not beSince many products can be in production1required to organize data in the system. Productfor many cycles, the active/inactivecycle will be an attribute of a series.designation will be used in place of productcycle.BOM-1.1.3Set series attributes.1BOM-1.2Manage planning parts.1BOM-1.2.1Associate engineering parts with planning parts.This information will be used to generate a1Associations can be made to part name or a part“Series Software BOM”.name and major version.BOM-1.3Manage engineering parts.1BOM-1.3.1Create/edit engineering part.1BOM-1.3.2Set part type. The following part types will beSee ePic attributes in section 10.4.1supported by ePic: 1. Foundation Image 2. P1 (recovery) Image 3. Monolithic Image 4. OS Setup 5. Application 6. Driver 7. Online Documents 8. OS Add-on 9. Module10. Internal Tools11. BIOS/Firmware12. Recovery Media Set13. Factory Media Set14. OtherBOM-1.3.3Set part attributes.See ePic attributes in section 10.4.1BOM-1.3.4Engineering parts can be composite parts, consistingThis applies to not just images, but modules1of several other parts, or a single standalone part.and other part types as well.BOM-1.3.5Engineering parts can be associated with planningMore fine grained associations are possible1parts (so that series associations can be made via theby editing the “Series Software BOMDB Hero Component BOM), or they can beTemplate.” LangRegion associations tomanually associated with individual product seriesreleases will be handled at module check-in(for example, manual association would be made fortime.hardware specific software items).BOM-1.3.5.1User may also specify “all series” so that the partSo if new series are added after this is set,1would be used for all active series existing in thethey would still pick up this part in theirsystem at any moment in time.BOMs.BOM-1.3.6The LangRegions to be supported by a part can be1specified at part creation time.BOM-1.3.7One or more software releases can be associated with1each part. Each software release can be associatedwith one or more LangRegions.BOM-1.3.8For each LangRegion, one of the associated releasesThe default release can be manually1can be flagged as “default.” The default release willoverridden after Series Software BOMbe used for “Series Software BOM” creation.Template generation (see BOM-1.6.2).BOM-1.3.9Electronic data files for printed documentation can bePer 2005-6-30 BRD feedback from VBD.1defined as engineering parts and stored in ePic. Noadditional functionality specific to these items isrequired.BOM-1.3.10Installation priority of the part can be specifiedSatisfies VBD QA WG requirements 1c.1relative to other part names/major versions asInstallation tools will calculate installation“BEFORE” or “AFTER.” The system will notorder for a set of modules at installationallow invalid installation order states (e.g., circulartime.installation order relationships) to be defined.BOM-1.3.11The Bios Lock ID (BLID) must uniquely identify aSatisfies VBD Factory Install WG1foundation image. This means that relationshipRequirement 1b.between BLID and FI will be one-to-one.BOM-1.3.12The user can specify whether parts are active or not.1If a user sets a part “inactive” then the system willignore/hide the part in any BOM creation activities.BOM-1.4Manage images/modules. Images and modules areTo be implemented as a “Part Registration”1engineering parts which can be final deliverables.wizard.BOM-1.4.1Set image/module type.1BOM-1.4.2Create/edit image/module BOM Template. EachComposite parts only.1composite engineering part has exactly one BOMTemplate.BOM-1.4.2.1Groups, Part Names, Part Major Versions, and/or1Releases can be added to BOM templates.BOM-1.4.2.2Auto generate image/module BOM using target1series attribute of parts and groups. User can editauto-generated BOM before it is saved.Perform Sanity checks:The first check is to alert users that items4Ensure items included in template must not bewhich are optional for a given series mightinstalled individually (use planning partbe included in the foundation image. Theassociations).system cannot know for sure from the DBEnsure dependencies are satisfied.Hero component structure, but it shouldindicate to the user that an eng. part hasplanning part associations.BOM-1.4.2.4Releases flagged as “disabled” cannot be added to aPer review with SDNA 2005-9-141BOM template.(corresponding attribute REL-025 added).BOM-1.4.3Snapshot BOM template (Freeze BOM).NOTE: This requirement applies to Series1SW BOM Templates in addition toimage/module BOM Templates.BOM-1.4.3.1A snapshot contains only software releases1(unspecified releases on the template will be set todefaults). Snapshots cannot be edited manually.BOM-1.4.3.2All part information at the time of snapshotting is1frozen in a snapshot. Changes made to the main dataafter snapshotting will not be reflected in thesnapshot.BOM-1.4.3.3BOM snapshots are exposed to build tools via the1build tool interface.BOM-1.4.3.4A BOM snapshot is retrievable as a file via ePic UI.1Dropped. Satisfied by ePic “group” conceptdescribed in BOM-1.8..BOM-1.6Create Series Software BOM.1BOM-1.6.1System will generate a “Series Software BOMSee requirement BOM-1.8 for definition of1Template”, which consists of the list of specific part“group”.names, major versions, groups and/or releasesassigned to a series, using DB Hero componentstructure, planning part associations with engineeringparts, and the properties of engineering parts. Thesystem will show default value for unspecified itemson the template.BOM-1.6.2Edit “Series Software BOM Template”. ReleasesThis function allows special release1can be edited manually.dependencies/incompatibilities to be handled.BOM-1.6.3The Series SW BOM will include mappings from oneSatisfies VBD QA WG requirement 1 g.1or more DB Hero components to one or more ePicsoftware releases. See section 9.6, requirement INT-1.10.BOM-1.6.4Once the Series SW BOM Template is complete, the1user can snapshot the template. A snapshot containsonly software releases (unspecified releases on thetemplate will be set to defaults). Snapshots cannot beedited manually.BOM-1.6.5All part information at the time of snapshotting is1frozen in a Series SW BOM snapshot. Changesmade to the main data after snapshotting will not bereflected in the snapshot.The system will indicate problems to the user when4displaying the Series SW BOM template. Problemscan be:Non-RC/GM releases.Target series information in conflict withplanning part association.Dependencies not satisfied.No default releases available for a part.No releases available for a givenlanguage.Dependencies are not satisfied.BOM-1.6.7The system should not allow an “inactive”Added per review with SDNA 2005-9-14.1part/release to be added to a series SW BOMtemplate.BOM-1.7Dependencies between engineering part namesSatisfies VBD QA WG requirements 1a and2and/or part name/major versions can be specified.1b.BOM-1.7.1Other parts can be selected and dependencies will be2specified as “DO NOT CARE”, “EXCLUDE”, or“REQUIRED.”BOM-1.7.2The system will not allow circular dependencies to be2defined.Satisfies VBD QA WG requirements 1 g.Dropped per review session with VBD 2005-9-15.BOM-1.8Create edit groups. Groups are user defined lists ofThis is an internal ePic concept intended to1engineering part names, major versions, releases, orallow users to define re-usable collections ofother groups.parts. This concept, if used properly, makesBOM creation more efficient.BOM-1.8.1Groups can be added to composite part BOMNote that groups are, for the most part,1templates. Changes made to group contents afterfunctionally equivalent to BOM templates.group assignment to a BOM template will bereflected on the BOM template.BOM-1.9Create edit test software BOM. A test softwarePer VBD review 2005-9-15: A facility for5BOM is a manually created list of software releasescreating and sharing test software BOMsfor a single configuration. The releases must bemust be available in the system.listed in proper order of installation (based onThis function will be used by bothinstallation priorities specified in the system).developers and testers. It is the only way tocreate a software BOM in the system beforea series software BOM has been prepared.A test software BOM is, by definition, asnapshot. BOM templating functions willnot be used for test BOMs.BOM-1.9.1User can search for and select part names, part5major versions, or releases to be added to a testBOM. System will select default release if user doesnot specify a specific release.BOM-1.9.2System should provide filtering capabilities to the5user for selecting items for the test BOM.BOM-1.9.3System should examine dependencies of the items5selected and automatically add releases to satisfythese dependencies.BOM-1.9.4User can download file containing the test BOM.5BOM-1.9.5User can save the test BOM in the system, BOM can5be given a name for later retrieval.


5.3.2 User Interface Requirements

IDDescriptionCommentsPriorityBOM-2.1Part Registration Wizard.Implements the Image1and Module Planners.BOM-2.1.1Set general part attributes.1BOM-2.1.2Set type specific part attributes.1BOM-2.1.3Set part dependencies and installation order.1BOM-2.1.4Associate with planning part/set target series.1BOM-2.1.5If part is a composite part, show BOM Template1creation interface (optional).BOM-2.1.6BOM snapshotting function (optional).1BOM-2.2Series Software BOM Builder (Wizard).1BOM-2.2.1System generates the series software BOM and1shows it to user with distinctive display of releasesthat fail sanity checks or are marked as special.BOM-2.2.2User can edit Series SW BOM.1BOM-2.2.3User can snapshot Series SW BOM.1BOM-2.2.4User can create Component/Release mappings (see1INT-1.10).BOM-2.3Entity Editor. Access to all attributes of an entity in1one place.BOM-2.3.1Screens must allow all attributes for each majorThe same functionality as1system entity to be edited one screen.the wizard is supplied foreach entity type.


5.3.3 Business Rules

IDDescriptionCommentsPriorityBOM-3.1Business Rule for Engineering Part CreationBOM-3.1.1A new part should only be created for a majorversion release of software. Major version is definedas specification change. Iterative releases within amajor release, to fix defects and such, are calledRelease Versions.BOM-3.1.2A part name should include the name of the partonly, in general terms. For example: AdobePremiere Professional, VAIO Zone, Sonic Stage.The major version number is an attribute of the part,and can be concatenated for UI and reportingpurposes. For example, a part can be created withthe Part Name of “Adobe Premiere Professional”and the major version number of “7.1”. The partbecomes the concatenation of the part name andmajor version number: “Adobe PremiereProfessional 7.1”..BOM-3.1.3Part names should not contain specific references toa series or CTO options. The following exampleswould not be acceptable: “Adobe Premiere 7.1 forIRX-3560” or “WinDVD 5.6 for Six ChannelSpeakers.”BOM-3.1.4Part names can only contain the characters: a-z, A-Z,Only pintable ASCII0-9, , -, or.characters (including space)should be allowed in part names.BOM-3.1.5Major Version Number is a text field, with the samecharacter restrictions.BOM-3.2Changes to DB Hero controlled entities must bemade in DB Hero only and then propagated to ePicvia interface. Entity attributes owned by DB Heromust, therefore, not be editable in ePic.


5.3.4 Interface Requirements

IDDescriptionCommentsPriorityBOM-4.1Load series master from DB Hero.1BOM-4.2Load parts master (planning parts) from DB Hero.1BOM-4.2.1Certain classes of hardware parts (HDD's, CPU's,Hardware parts are required for Test/Defect1etc.) should not be filtered from the master parts list.management system functions.If that is not possible, all hardware parts should beloaded and ePic should filter hardware parts fromUI.BOM-4.3Load component structure from DB Hero.1BOM-4.4Load updates to all previously loaded DB Hero data.1BOM-4.5DB Hero interface behavior rules:BOM-4.5.X applies to all DB Hero interface2requirements.BOM-4.5.1DB Hero BOM data can be manually loaded fromcustom character1into ePic (via ePic UI). Data updates should beperformed using the most efficient means available.BOM-4.5.2Pre DB Hero release BOM data can only be loadedOne button to update all DB Hero data for a2into ePic manually. Initial load of any BOM must beseries is ideal.manual.BOM-4.5.3After the DB Hero release, structure/part changesWithout ECNs manual load is the only2which generate an ECN are automaticallypossibility (except for series and parts,implemented in ePic. Revision history is not kept.whose masters are synced regularly).BOM-4.5.4ECNs can be requested by date range. ePic shouldUpdate period should be a configurable ePic2periodically request all ECNs since last updatesystem option.automatically.BOM-4.5.5Email and UI notifications will be produced forcustom character2software integrators for the following changes to DBHero BOMs:Any SW part (planning part) change oncomponent BOMs.Any changes (HW or SW) to componentsused in component/release mappings.Changes to Config Range/Line-up.BOM-4.5.6DB Hero data will be loaded into ePic at most onceIf users need up-to-date data, they can1per day, and at least once per week.initiate a manual transfer via ePic UI.


5.4 Software Development


ePic requirements to support developers who use the system are listed here.


The detailed format for software modules is documented separately in a “Modular Specification”.


5.4.1 Usage Requirements

IDDescriptionCommentsPriorityDEV-1.1Engineering part registration (developer specificSee “Software Engineering BOM Creation”1requirements).for additional information concerning partregistration.DEV-1.1.1The set of LangRegions supported by the module1must be specified.DEV-1.1.2The part can be associated with a planning partSee BOM-1.3.5.1and/or target series. Neither is required (thoughwarning should be issued if neither is selected).DEV-1.2Check-in software release (non-image).1DEV-1.2.1Developer must identify LangRegions supported by1the software release to be checked-in.DEV-1.2.2Developer must indicate installation method and1unattended installation command. Alternateinstallation commands may also be entered withcomments.DEV-1.2.3Developer must indicate any special requirements ofThese releases will be given special attention1the software release (incompatibilities, specialduring “Series Software BOM” creation.instructions). System will flag release as havingCan include a flag on release calledspecial requirements where appropriate.“Special” or “Warning.” These releaseswould be called out on part templates andsnapshots and comment would be displayed.DEV-1.2.4Developer must enter release notes. A release noteSee attributes in section 10.4 for more1is text entered into ePic. User can append an entrydetails.to the release note.DEV-1.2.4.1Users can download all release note entries in a1single text file via the UI.DEV-1.2.5Software item check-in should allow files to be1checked-in to local mirror and uploaded to main storeasynchronously.DEV-1.2.6If the item to be checked in is not an image, it will1automatically be replicated to other file stores. If theitem is an image, replication will not occurautomatically. Users can request to the system thatan image be downloaded to their regional file store.via ePic UI.DEV-1.2.7The following statuses can be specified for a release:Satisfies VBD QA WG requirement 1d.1“ES/Test”, “FF”, “Pilot”, “CF”, “RC”, andSatisfies VBD Factory Install WG“GM.”requirement 2a.DEV-1.2.8User can optionally request that the system send the1release email.DEV-1.2.8.1Release email address list is a configurable systemThis list could also be auto-generated based1item.on roles.DEV-1.2.9User can set a release “inactive.” Inactive releases1cannot be set as “default” and vice versa.DEV-1.3Create/Edit Vendor1DEV-1.3.1User can store information about a software vendor1(Name, Address, Contact, Sony Contact).DEV-1.3.2Vendor can be optionally associated with anIt is appropriate to include vendor name in1engineering part.part name and also have a vendorassociation.DEV-1.4User can initiate download of any release via ePic1UI.


5.4.2 User Interface Requirements

IDDescriptionCommentsPriorityDEV-2.1Extracting engineering part, release, BOM data, andPer 2005-6-30 BRD feedback from VBD.1planning part associations from the database must beefficient for the developer.DEV-2.2Users should be able to easily initiate download of1any release via ePic UI.


5.4.3 Business Rules

IDDescriptionCommentsPriorityDEV-3.1Business rules specified as part ofrequirement BOM-3.1 apply todevelopers, as well.


5.4.4 Interface Requirements


None


5.5 Software Integration


ePic requirements to support integrators who use the system are listed here. ePic will provide a single interface to build tools. Each regional group is expected to modify their build tools to work with the new interface.


Functionality specified here is to be used by integrators as part of image creation and Series Software BOM creation. Functionality to manage DB Hero SKU's and associated BOMs and create dummy SKUs and BOMs is also included here.


5.5.1 Usage Requirements

IDDescriptionCommentsPriorityDropped. File store related requirementswill be captures in section 9.10.INT-1.2Check-in software release (image).1INT-1.2.1Software item check-in should allow files to be1checked-in to local mirror and uploaded to main storeasynchronously.INT-1.3Schedule software integration activities.Future Requirement. Not in scope.NTHINT-1.4Track software integration activities.Future Requirement. Not in scope.NTHINT-1.5Event triggered notification concerning softwareFuture Requirement. Not in scope.NTHintegration activities.INT-1.6System should not have any functional dependenciesBuild systems will be loosely coupled with1on any external build systems.ePic.INT-1.7Monolithic Images will be created by selecting aUser must select which series SW BOM5SKU that has been loaded from DB Hero orsnapshot to use for this function.manually created in the system (see INT-1.12). Thesystem will automatically create the Image BOMusing the series software BOM.INT-1.7.1Monolithic image BOMs are not editable by users.User must edit the appropriate Series5Software BOM to change monolithic BOMs.INT-1.8ePic will support creation and deployment of MLHDMLHD configurations are like SKUs that5configurations.include software for more than oneLangRegion.custom characterINT-1.8.1MLHD BOM Template will be automaticallycustom character5generated based on user selected SKU BOM(s)loaded from DB Hero or manually created in ePic(see INT-1.12).INT-1.8.2MLHD BOM is not manually editable.User should edit SKU BOM and associated5Series Software BOM to change MLHDBOM contents.INT-1.8.3MLHD BOM will be exposed to build system justAn attribute will allow VOE build system to5like any other image BOM.distinguish MLHD BOMs from otherimages.INT-1.9Component selector. Allow user to create DB HeroUser can use this function to specify a2Component lists by selecting DB Hero specs andconfiguration or just a set of components.classes.This function is used to specify component-to-release mappings during series SW BOMCreation (BOM-1.6) and dummy SKU BOMCreation (INT-1.12.2). It is intended tomake it easier for users to select componentsby allowing them to select the same items acustomer would in a sales system.custom characterINT-1.9.2If user is creating a configuration, DB HeroThis is necessary to create valid2constraints are checked by the system once allconfigurations.selections have been made.INT-1.9.3DB Hero spec-to-component relations are used toThomas will not implement constraints2convert user selected specs/classes to a list ofenforcement which is required for ePic.components.Dropped. VOA must adapt DB Hero2deliverables to existing systems and Thomaswill not have all required functionality.INT-1.10Specify Component-to-Release Mappings. One orThese mappings will be included in the1more DB Hero Components is mapped to one or“installation data file,” and factory tools willmore Releases on a Series SW BOM template.use these mappings to select the correctreleases to install on a configuration basedon the list of DB Hero components that makeup that configuration (this is a SKU BOM).INT-1.10.1If no mappings exist, the system will auto-generatecustom character1mappings by using planning part associations toresolve which components will be selected.INT-1.10.2User can use component selector to select additionalcustom character1components to be used in a component/releasemapping or select components directly.INT-1.10.3System will perform sanity checks upon submissioncustom character1of mappings:Ensure all SW items on the Series SW BOMhave mappings with DB Hero components.INT-1.11Integrators can request images from non-local fileImages are not synced to other file stores by1stores be copies to the local store.default.INT-1.12Manage SKU's. A SKU represents an individualSKU BOMs are used by the system to auto-2configuration.create monolithic image BOMs (INT-1.7)and MLHD BOMs (INT-1.8).A SKU (stock keeping unit) is a DB Heropart representing a configuration. The partnumber of such an item is also called SKUor F-number. A SKU BOM is a SKU partwith a list of DB Hero component partsrepresenting one configuration as children.Some configurations (for retail products) areofficially defined in DB Hero. These productconfigurations are referred to as FixedSKUs.INT-1.12.1SKU BOMs are loaded from DB Hero as part of DB2Hero interface functionality. SKU BOMs contain aSKU item as parent and components as children.INT-1.12.2User can also manually create SKU's. User can use2the component selector (INT-1.9) to create a SKUBOM. For manually created SKU BOMs, usershould specify the SKU Description.INT-1.12.3User cannot edit SKU BOMs originating from DB2Hero.


5.5.2 User Interface Requirements

IDDescriptionCommentsPriorityMoved to section 9.4.2, requirement BOM-2.1.


5.5.3 Business Rules

IDDescriptionCommentsPriorityINT-3.1Both regional and global of foundationimages will be supported by ePic. Whenreqional images are used, foundationimages will be designed and built locallyin each engineering division using ePicand local build tools.


5.5.4 Interface Requirements

IDDescriptionCommentsPriorityINT-4.1Provide image BOM data and software items for1VOA's build environment.Dropped.INT-4.3Provide image BOM data and software items for1SDNA's build environment.INT-4.4Data and functionality will be exposed to build toolsDB Connection will be used by SDNA.1via interface DLL.VOA and VOE will use web services.INT-4.5Build data will be exported via system interface.Build data is a snapshot of a BOM template1for an engineering part. The interfaceshould expose other data so that the remoteuser can select snapshots.INT-4.5.1Data to be exported:custom character1Active Series MasterLangRegion MasterImage/module BOM SnapshotsAll entity attributesBinary data (in file store)INT-4.5.2Functions to be provided:Multiple calls required to get BOM.1AuthenticateFiltering of data should be done client side.Get Active SeriesGet LangRegion MasterGet Composite Parts for SeriesGet Snapshot List for PartGet Snapshot BOMGet Binary Data for SW Release ID (fromfile store)INT-4.6Check-in functionality will be provided via systemcustom character1interface.INT-4.6.1Data to be imported:Part registration is needed since some parts1Release attributes(like “clean” or “base+” OS images) will beBinary data (to file store)auto-created from build tools.Part RegistrationINT-4.6.2Functions to be provided:Register part functionality must be available1Authenticateremotely, for example, so that a PIDVD partCheck-in (to ePic)(factory media) can be created by build toolsUpload files (to local file store)automatically for each monolithic imageRegister Part (to facilitate auto-creation ofcreated.related parts)Set default releaseINT-4.7Config Range must be retrieved from DB Hero.For INT-1.9. Interface specified in “DB2Hero Common Interface ProtocolSpecification 2005-07-07”, page 12 and 27.INT-4.8Constraints must be retrieved from DB Hero.For INT-1.9. Interface specified in “DB5Hero Common Interface ProtocolSpecification 2005-07-07”, page 14 and 30.INT-4.9Spec-to-Component relations must be retrieved fromFor INT-1.9. Interface specified in “DB2DB Hero.Hero Common Interface ProtocolSpecification 2005-07-07”, page 17 and 35.INT-4.10All SKU BOMs must be retrieved from DB Hero andFor INT-1.7 SKUs are identified by F-2stored in ePic.number. Interface specified in “DB HeroCommon Interface Protocol Specification2005-07-07”, page 10 and 24.


5.6 Factory Deployment


This section captures ePic requirements specific to factory deployment. Some of these requirements extend previously specified functionality. The requirements and data format for the installation data file is captured in section 9.8.


5.6.1 Usage Requirements

IDDescriptionCommentsPriorityMFG-1.1Snapshot Series Software BOM. This functionalitySnapshots are used for several operations:1should be available from the series software BOMInstallation Data File creation, Test Strategymanagement screens.management.MFG-1.1.1A snapshot can be flagged as a Release CandidateThe latest RC snapshot is used for generating2(RC).Test Strategies. This function would be usedfor the “BOM Freeze” milestone in VOA.MFG-1.1.2User must enter a text version string (or snapshotFor example, “1.0”, “1.1.1-rc”, or “Build1name) for each series software BOM snapshot. This1”. Business units will decide conventionsversion string should be unique forthis field.Series/LangRegion combination.This is in addition to system generated ID.It is used throughout the system and externaltools as the name of the snapshot.MFG.1.2Issue RTM or Test RTM. RTM's and Test RTM'sTest RTM's will be used as a mechanism for4will be issues by Series/LangRegion.pre-releasing BOMs for PVT events.MFG-1.2.1Only one snapshot for a given Series/LangRegionThis implies that different snapshots could be4combination can be flagged as RTM or Test RTM.used for different LangRegion combinations.MFG-1.2.2System must send when an RTM has been issued in5the system. Email must include the followinginformation:Installation data file name with hyperlink to ePicpage from which it can be downloaded.Name and email of user who issued the RTM.Engineering organization of the user.MFG-1.3Running change management.4MFG-1.3.1If a user issues an RTM against a Series/LangRegion4combination for which a RTM snapshot alreadyexists the system should warn the user that a previoussnapshot was RTM'ed and this is a running change.MFG-1.3.2When system sends release mail to users, the mailFor example:5should indicate that the change is a running change toChanges since initial RTM:RTM'ed software. In addition to items described in<part name> <detailed ver.> (<rel.MFG-1.2.2 the following items should be included inid>) [ADDED]the mail:<part name> <detailed ver.> (<rel.List of releases added/deleted/changed sinceid>) [DELETED]initial RTM. Items which are patches (EPCs)<part name> <detailed ver.> (<rel.should be tagged as such.id>) [CHANGED]List of releases added/deleted/changed since the<part name> <detailed ver.> (<rel.last running change release. Items which areid>) [ADDED] [PATCH]patches (EPCs) should be tagged as such.Changes since last RTM:<part name> <detailed ver.> (<rel.id>)) [ADDED]MFG-1.4Manage partitioning information. System willThis data will be included in the installation5provide functionality for specifying partition sizes fordata file.all partitions to be used on production systems.Special partitions “recovery” and “system” (or Cdrive) can be defined. “System partition mustalways be specified.MFG-1.4.1Partitions sizes can be defined for each5Series/LangRegion combination.MFG-1.4.2Partition sizes should be specified in MB5(megabytes).MFG-1.4.3For the recovery partition, user can select “dynamic”If a partition size is dynamic, installation5instead of specifying a size. For system partition usertools will decide whai the size will be.can specify “single partition” instead of specifying aIf partition size is “single partition”, then allsize.available space remaining on the disk wouldbe allocated for the partition.MFG-1.4.4For the “system” partition, user must specify aThis is used in the factory so that a5minimum size. This is always required.diagnostic partition can be created. Forsingle partition models the partition size willbe extended to the final size at the end of thefactory process.MFG-1.4.5If user selects “dynamic” for recovery partition size,5user must also specify “recovery partition installedsize.” This is the size in MB of all data included inthe recovery image. It is needed to calculate adynamic partition size.MFG-1.4.5For each partition specified, user must specify a diskFor example, “Disk 1, Partition 2,5number, partition number, and label name.SYSTEM.”MFG-1.4.6For each partition specified, user must specify a fileStandard partition types and numbers should5system type. This type will be stored as abe used.hexadecimal number, but system should prompt userswith partition type name.MFG-1.5Factory Media Management. System should provide4some addition functionality to facilitate mediadelivery to factories when defining factory mediaengineering parts.MFG-1.5.1System should provide function for auto-creating4media BOM based on a series SW BOM snapshot.User can select the snapshot (by RTM, Test RTM,Latest, or version field) and system will prepare aBOM which includes the appropriate installation datafile.MFG-1.5.2System should provide function for auto-creating a4media set containing only files which have changedfrom another media set. User should select twoseries software BOM snapshots. Default is initialRTM'ed snapshot and latest RTM'ed snapshot.Appropriate installation data file will be included onthe BOM.MFG-1.5.3User can manually add/remove releases from the4Factory Media BOM.MFG-1.6Miscellaneous IDF data maintenance. Functions for4managing data in the IDF not covered elsewhere inthis document must be provided.


5.6.2 User Interface Requirements

IDDescriptionCommentsPriorityMFG-2.1RTM/Running Change Wizard.5MFG-2.2Download Installation Data file.3


5.6.3 Business Rules

IDDescriptionCommentsPriorityMFG-3.1. . .


5.6.4 Interface Requirements

IDDescriptionCommentsPriorityMFG-4.1


5.7 Installation and Recovery (ePic)


These requirements describe ePic functionality required to support software installation and recovery.


5.7.1 Usage Requirements

IDDescriptionCommentsPriorityINST-1.1“Installation Data File” (IDF) Management.1INST-1.1.1Installation Data File (IDF) must include theSatisfies VBD Factory Install WG1following elements for each Series/LangRegion:requirements 1a-f.Minimum tools version number -Factory Install WG 1c and 1f-1 are satisfiedchecked by tools to ensure the correctsince P1 images, patches, and runningversion is being used (configurable value).changes are treated like any other module.Version number of the installation datasnapshot.The contents of Snyinst.oem. Installationorder for the modules.Mapping of DB Hero components to ePicSW releases.Data required for the installation tools toconfirm successful installation of eachrelease.CRC data for each binary file.Total size of each release binary data(used for dynamic partition sizecalculation).Path information required to locate binaryfiles in the file store and download them(via SMB share).Partition size information for recovery andsystem partitions. All partitioninformation defined in the system shouldbe included and a field listing total numberof partitions defined should be calculatedand included in the file.BIOS time zone offset from GMT by theseries/LangRegion (e.g., GMT +8, GMT−7).For each release included in the file,engineering organization for the developerwho checked-in the release.Recovery type (HDD Recovery or mediaonly).MLHD specific information, if applicable.Relevant MCode specification(s).List of all software releases and attributesof all software releases on the Series SWBOM (BLID will be included as anattribute of FI releases).INST-1.1.3An installation data file can be automaticallyIntended to satisfy Factory Install WG3downloaded to a factory file store, it can be retrievedrequirement 3a.manually via ePic UI, or it can be retrieved via DLLinterface.INST-1.1.4Installation data files are generated for each SeriesThere will be many IDF's. To make2Software BOM Snapshot.management easier special requirements havebeen specified for online (STOR-1.10 andSTOR-1.14) and offline (MFG-1.5) factorydeployment methods.INST-1.1.5All users can retrieve the “Test RTM” or “RTM”Satisfies Factory Install WQ requirement 1f-2.4version of the installation data file for a given series.Sony users can additionally retrieve the “latest”snapshot of an installation data file.INST-1.1.6Each installation data file must have a unique name1with the unique identifier included in the name.INST-1.2“RTM”, “Test RTM”, and “latest” snapshots of4installation data can be generated and stored in thesystem.INST-1.3Installation data will be “cycle-less.” Installation2data will support all cycles for a given series.INST-1.4All users must have a system account to access these2services.INST-1.5Third party users should have access only to data5relevant to them. Data will be restricted by series(see ADM-1.3).INST-1.6MCode management.4INST-1.6.2A MCode specification (bit mapping to softwareThis means that MCodes can be duplicated4releases) is defined for each Recovery Media Set.with each instance having different meanings.INST-1.6.3The system will generate a MCode specification once4the Recovery Media Set BOM and Series SW BOMfor the associated series' are complete. This functioncan be re-run if the BOM changes and existingMCode Mappings will not be affected.INST-1.6.4The system can calculate a MCode given a list of SWSatisfies VBD Factory Install WG5releases or a list of DB Hero componentsrequirement 2c.representing a single configuration.INST-1.6.5The system can calculate the list of software based5on a given MCode.INST-1.6.5.1User can produce a list of software from an5encrypted MCode or unencrypted MCode. If theMCode is encrypted, user must also enter a UUID(text string) to facilitate decryption.INST-1.6.6The system can calculate a MCode based on a SKUSystem must first convert list of DB Hero4BOM (user defined or from DB Hero) defined in thecomponents to a list of software releases tosystem.accomplish this.A SKU BOM must be used, becausecalculating a valid MCode requires that DBHero constraints have been enforced for theconfiguration (see Component Selector, INT-1.9).INST-1.6.6.1User can optionally generate an encrypted MCode by5entering a UUID in the system.INST-1.6.7The MCode specification will be included in the4installation data file.INST-1.7Recovery Media Planner. Users can define a BOM4template for a Recovery Media Engineering Partusing a wizard or form.INST-1.7.1User selects the Series and LangRegion for which the1recovery media will be created. Usermust select an OS, as well.INST-1.7.2System will auto create a Recovery Media BOM4template. This function is identical to SeriesSoftware BOM auto-generation except that it is alsoconstrained by OS selection.INST-1.7.2.1User can manually add/remove engineering1parts/release/groups to the BOM template.INST-1.7.2.2User can create snapshots of the Recovery Media1BOM template. Requirements are the same as forSeries Software BOM.INST-1.7.2.3A function for comparing Recovery media BOMRecovery Media BOM's and Series SW5snapshots to series SW BOM snapshots should beBOM's (their lifecycles are different) are notavailable. Differences should be shown to the user.directly related. This function is necessary sothat users can reconcile differences.INST-1.8The ePic component selector function must provide aThis is just a button or hyperlink.4function for issuing an HTTP GET or POST to theThis function cannot yet be merged into ePicOASIS system in the VOA (This system generatesbecause it is heavily tied to VSMS and legacyMCode writing floppy disks for Sony personnelsupport will be required for a while. This canaround the world). The HTTP request will includeeventually be convened to a standalone toolan unencrypted MCode and any other data necessarywhich runs alongside ePic once the VSMSto produce a MCode floppy in OASIS.dependencies can be lifted.


5.7.2 User Interface Requirements

IDDescriptionCommentsPriorityINST-2.1Recovery media planner (wizard).1INST-2.1.1Select Series, LangRegion, and OS. One or more of1any of these items may be selected. Set mediaspecific attributes.INST-2.1.2System auto-generates media BOM. Show softwareSeries SW BOM is required for auto-4releases and media layout. Allow user to add itemsgeneration. If it is unavailable, user mayto BOM. Items generated from Series SW BOMcreate BOM from scratch.cannot be edited.INST-2.1.3Generate MCode bit mappings. System stores bit4mappings. Existing bit mappings are frozen if anySeries/LangRegion assigned to media set it RTM'ed.Additional mappings may be created post-RTM.


5.7.3 Business Rules

IDDescriptionCommentsPriorityINST-3.1MCode format will be changed:Current MCode space occupied byPCODE will be replaced with aMCode Spec identifier. Allremaining bits will be usedfor algorithmic mapping bits tosoftware items. There will nolonger be HW/SW MCode -only SW MCode.INST-3.2HDD recovery and recovery fromcustomer created recovery mediawill not be dependent on MCode.MCode is required only for recoveryusing Sony supplied recovery media(as defined in ePic).


5.7.4 Interface Requirements

IDDescriptionCommentsPriorityINST-4.1. . .


5.7.5 MCode Specification Changes


5.7.5.1 Current MCode Implementation
embedded image

5.7.5.2 New MCode Implementation
embedded image


Installation Data File Mockup

<?xml version=“1.0” encoding=“UTF-8”?><InstallationDataFile>  // Versioning information and other top level data  <Header>    <Series name=“”/>    <LangRegion name=“”/>    <BomSnapshot id=“” versionString=“”/>    <MinimumToolVersion version=“” />  </Header>  // List of DB Hero component ID to SW release mappings  // (created as part of Series Software BOM management)  <ComponentReleaseMap>    <Mapping>        <ComponentIDList/>        <ReleaseIDList/>    </Mapping>    ...  </ComponentReleaseMap>  // List of MCode bit mappings  // MCode spec by recovery media set or Series/LangRegion/OS  <MCodeSpec>    <OperatingSystem id=””>      <Mapping>          <MCode bitmask=“” value=“”/>          <ReleaseIDList/>      </Mapping>      ...    </OperatingSystem>    ...  </MCodeSpec>  // Partition Data  <ParitionInfo/>  // List of all releases and their attributes for the Series/LangRegion  // (includes BIOS/Firmware releases)  <SeriesSoftwareBom>    <Release id=“” blid=“” ...>        <SetupCommand/>        <Dependencies/>    </Release>    ...  </SeriesSoftwareBom></InstallationDataFile>


5.8 Installation and Recovery (Tools)


As part of the requirements process global modular and recovery specifications will be defined. These requirements describe changes that must be made to US installation and recovery tools in order to work with ePic. These tools will become the global Installation and Recovery Toolset.


5.8.1 Usage Requirements

IDDescriptionCommentsPriorityTOOL-1.1Image and Module part types can be downloaded andRequirements TEST-1.1 to TEST-1.4 satisfy2installed automatically using the same tools to beQA WG requirements for networkused in the factory.installation item 2.Patches and running changes are “Modules”and are thus included.TOOL-1.2Installation without a Series SW BOM must beThis functionality should be provided on a2supported.boot CD.Software list building/storing functionalrequirements added to ePic per 2005-9-15VBD review.TOOL-1.3Installation of a clean OS should be possible.VBD QA WG Requirement.2This is for early SW development (ofdrivers, for example). ePic will allow suchimages to be checked in and users can useQA installation tools to image units.TOOL-1.4BIOS/Firmware and tools (e.g., to burn BIOS, write3firmware or write DMI) part types should bedownloaded automatically.TOOL-1.5BIOS/Firmware parts should be automatically3installable.TOOL-1.6Release Notes and Bug Lists for all parts can be2automatically downloaded.TOOL-1.7Paper manual contents can be automatically2downloaded.TOOL-1.8QA download and installation services and tools mustSatisfies QA WG requirements for network2be available worldwide to VAIO engineering groups,installation item 3 and 5c.outsourced QA groups, and ODMs.Detailed list of users is included in theoriginal document.TOOL-1.9Tools should check the minimum required version in2the installation data file and should return an error ifthey are a lower version.TOOL-1.10Tools will determine install order based on data from2ePic.TOOL-1.11Tools must operate in WinXP and WinPE.Satisfies QA WG requirements for network2installation item 5e and 2i.TOOL-1.12Tools must implement function to convert an MCodeThis enables the distribution of MCodes to2to a list of software releases (using the installationfactory for Fixed SKU production, and itdata file) and vice versa.enables calculation of MCodes on the fly byinstallation tools during the modularinstallation process.TOOL-1.13Unique ID of each software release must be verifiedSatisfies VBD QA WG requirement 3a.3after installation.TOOL-1.14Installation tools must be able to detect whether aSatisfies VBD QA WG requirement 3b.3module successfully installed.TOOL-1.15Installation tools should support automatic creation ofSatisfies QA WG requirements for network3a target environment on a machine.installation item 5a.TOOL-1.15.1Target environment includes an HDD image.Assumption is that this is a foundation3image.TOOL-1.15.2Target environment includes firmware and BIOS3updates.TOOL-1.15.3Target environment includes updating of DMI data.3TOOL-1.16Installation tools must have locking mechanism soSatisfies QA WG requirements for network3that they only work on Sony PCs.installation item 5b.TOOL-1.17QA installation can be initiated using a WinPE bootSatisfies QA WG requirements for network2CD.installation item 5d.TOOL-1.18Installation tools must work in Windows.2TOOL-1.19Installation tools must support preparing recoverySatisfies QA WG requirements for network3partition only without performing full install.installation.TOOL-1.20An automated system should exist that can scanThis would help facilitate Test System data3hardware data for test systems and load it into ePicentry.through a network connection.WMI based configuration checkingimplementation could be used to satisfy thisrequirement.TOOL-1.21A DLL should be provided that utilizes MCode1encoding/decoding and MCodedecryption/encryption.TOOL-1.22Three use cases for installation tools will becustom charactersupported:1.Installation using a list of DB Herocomponent part numbers.a.Convert list of component partnumbers to list of softwarereleases.b.Generate MCode using list ofsoftware releases (optional -could be done offline).c.Install software.2.Installation using a MCode.a.Generate list of softwarereleases using MCode.b.Install software.3.Installation using a list of releases.a.Generate MCode (optional -could be done offline).b.Install software.


5.8.2 User Interface Requirements

IDDescriptionCommentsPriorityTOOL-2.1


5.8.3 Business Rules

IDDescriptionCommentsPriorityTOOL-3.1For the use cases defined inTOOL-1.22:Factory Installation will usemethod #1 only.For retail models the DB Herocomponent part number listcan be prepared offline anddistributed at RTM time.Recovery Media Sets(RDVDs or FulfillmentMedia) will use method #2.HDD Recovery and recoveryusing customer created mediawill use method #3.Test system preparation will useall three methods.


5.8.4 Interface Requirements

IDDescriptionCommentsPriorityTOOL-4.1


5.9 File Store/Mini-ePic


5.9.1 Usage Requirements

IDDescriptionCommentsPriorityMoved to Business Rules section.Moved to Business Rules section.STOR-1.3New module and application releases will1automatically be synced with other engineering filestores. Images will not.STOR-1.4Sony user can request that images from another1engineering file store be transferred to their local filestore via ePic UI.STOR-1.5Factory engineers can automatically sync their localFile store solution would thus require a3file store by providing installation data file tofunction for parsing the installation data file.synchronization tool.STOR-1.5.1All binary data required will be automatically3downloaded to factory file store according toinstallation data file.STOR-1.5.2Obsolete releases will be automatically deleted fromThe “delete obsolete files” function is3factory file store according to installation data file.intended for factory use. Factories willThis function can be optionally disabled.usually only require latest RTM'ed releases.Obsolete releases would be any releases thatwere removed/replaced in the installationdata file. Such a function ensures thatfactories will never need to allocate morestorage than is absolutely necessary to thefile store.STOR-1.5.3Factory engineers can only download “RTM” or3“Test RTM” releases as indicated in the installationdata file the receive.STOR-1.6For each release, one or more files and directories1can be checked into file store.STOR-1.6.1During release check-in, upload process should be aUser should not have to zip up files or FTP1fully automated and atomic operation.them anywhere.STOR-1.7During a download operation, the total size of the3files to be downloaded can be reported to the userbefore the download starts.STOR-1.8Users must be able to load binary data into the fileSome factories will receive images and3store from media.modules on DVD (factory media set).STOR-1.9User must be able to operate the file store without aPerhaps factory file store can work with just1database connection to ePic.installation data file. Engineering stores mayuse database connection to acknowledgecheck-in(s) and perform other advancedfunctions.STOR-1.10File store will provide a function for downloadingThis function is for factories.3latest installation data file for a Series/LangRegion.The Series/LangRegion list for this function shouldbe kept in a configuration file and downloads shouldbe manually triggered.STOR-1.10.1User should be able to view/download the list of3changes (the same as in requirement MFG-1.3.2)when the file store download is triggered.STOR-1.11The file store solution should be deliverable as anPackage is sent with user manual and1easily installable package with a simple configurationrequired configuration parameters.file.STOR-1.12The file store solution should be deployable to a wideFile store users will have more flexibility in1range of system architectures.hardware selection or they can leverageexisting infrastructure.STOR-1.13File and directory management.11STOR-1.13.2Files should be stored in a flat file structure withIt is acceptable to have a few directories on1each file uniquely named.the file store, as long as it is human.navigable.Files could be named as the release ID withtype prefix.STOR-1.14A factory file store can be synchronized based on theIntended to satisfy Factory Install WG3installation data file.requirement 3b and 3d.STOR-1.15Files and directories (binary data) in the file storeSatisfies Factory Install WG requirement 3c.1should be uniquely named.


5.9.2 User Interface Requirements

IDDescriptionCommentsPrioritySTOR-2.1Solution should beOperations can be1command- line based.scripted. No graphicalSome functions may beUI required.implemented in a daemon.


5.9.3 Business Rules

IDDescriptionCommentsPrioritySTOR-3.1Any business unit requiring a file store will beStorage requirements will vary for eachresponsible for purchasing and maintaininginstallation.hardware.STOR-3.2Any non-GM software must be available for aSatisfies QA WG requirements for networkspecified period of time (e.g. 100 days) after the GMinstallation item 4.version has been released.STOR-3.3Golden Master (GM) SW releases must be availableSatisfies QA WG requirements for networkfor an indefinite period of time.installation item 4.If indefinite period is impossible one of thefollowing:By the end of OS support period.By the end of product support period.By the end of key parts availability for HW services.


5.9.4 Interface Requirements

IDDescriptionCommentsPrioritySTOR-4.1File store must communicate1with other file stores.STOR-4.2Files stores must authenticate1before connecting to another filestore or ePic for any reason.


5.10 Test Management and Defect Tracking


The following key concepts are central to ePic Test Management and Defect Tracking functionality:

    • Test Case: Unit test case associated with a single hardware or software item.
    • Test Case Strategy: A collection of test cases for a series or engineering part/major version. Partially auto-generated based on the releases on a series software BOM. The test case strategy changes over time as items on the series software BOM change.
    • Defect: A flaw of a software or hardware item. Defects can be linked to test cases or standalone.
    • Test System: A PC used for testing. ePic will track the configurations of test systems.


9.11.1 Usage Requirements

IDDescriptionCommentsPriorityTEST-1.1Three primary system roles are used for the3Test/Defect components of ePic: “Project Test3Lead,” “Test Lead,” and “Tester.”TEST-1.1.1Only “Project Test Leads” and “Test Leads” can3create/edit Test Cases and create/edit TestStrategies.TEST-1.1.2Testers can update the results of a Test Case or3create/edit defects. Testers can edit Test Casedefinitions if they have been added to the owner listfor the Test Case by a Test Lead or Project TestLead.TEST-1.1.3Developers and Integrators can update status and“Fix-verified” resolution is used to confirm3resolution of defects, but cannot set resolution ofregression tests were successful.defects to “Fix-verified.”TEST-1.1.4Any user with an assigned role in the system canAuthenticated users without roles are given3enter a defect in open status.read-only access to all parts of the system.TEST-1.2Defect management.3TEST-1.2.1Defects can be associated with one or moreThus for hardware defects, DB Hero part3engineering part/major versions, releases, series,numbers are used, and for software defectsor hardware parts. Defects cannot be associated(including BIOS and firmware) ePic partwith software planning parts from DB Hero.numbers are used.TEST-1.2.2If a user chooses to associate a defect with a series,3the user should then have the option of selectingreleases from the series software BOM (ifavailable).TEST-1.2.3Before entering a defect, the user should be able toSearch functions should be accessible from3search existing defects to ensure that duplicates orthe create defect view.similar defects do not already exist.TEST-1.2.4Defects can be associated with one or more Testcustom character3Systems.TEST-1.2.4Defects must be associated with Test Cases if theycustom character3are discovered as part of testing (see requirementsTEST-2.1.4). Defects can also manually beassociated with a test case.TEST-1.2.5Any changes made to an existing defect should becustom character3captured in a history log. The user, date/time, andattributes changed should be captured. Changes tovalues for status and resolution of defect should betracked in the history log. For other attributesvalues do not need to be tracked.TEST-1.2.6Users checking-in new part releases are required toThis will be required for ALL users who3update the status and resolution of any open defectscheck in releases regardless of whether theirlinked against that part/major version.organization uses the Test Mgmt/DefectTracking functions of ePic. This is criticalfor correctly assessing the quality level inany release on the series SW BOM, as willas auto-generating the regression portion of aTest Strategy.TEST-1.2.6.1System will display a table of open defects andIt is preferred that notes entry be a separate3allow user to enter status, resolution, and notes forscreen invoked by a link to facilitate a moreeach defect.compact UI.TEST-1.2.6.2If user sets defect resolution to “Will Not Fix” or3“Deferred” a note is required.TEST-1.3Foundation Image (FI) Defect Propagation Tool.This is a special purpose function required4because each FI is defined as separateengineering part in ePic, but defects found inthe FI will often apply to many FIs (forexample, defects cause by build tools). It isintended to be used by integrators/imagebuilders as opposed to QA personnel.TEST-1.3.1System displays all open defects against foundation4images and a table of all active foundation imageengineering parts and releases.TEST-1.3.2Attributes displayed for foundation images facilitate4dimensional analysis to identify other FIs affectedby a defect. User can sort table by column or filtertable by column values.TEST-1.3.3User can select one defect and one or morecustom character4releases in the FI table and assign the defect to allselected FIs.TEST-1.4Create/edit test system. User can define test5systems (PCs used for testing software andhardware) in ePic.TEST-1.4.1Each BOM should include a list of basic categoriesSuch categories are maintained in DB Hero5to help user create test BOM: CPU, HDD, ODD,as an attribute of parts calledMotherboard, LCD, etc. Parts for specific“Classification.” This attribute should becategories are not required to be entered; theseused for this function.categories are used only as filters for the hardwareparts list.TEST-1.4.2The user can create a BOM for the hardware (DB5Hero HW parts) and Firmware (ePic eng. parts) ina test system. User can browse parts by series ordescription.TEST-1.4.3The user should be able to define addition parts onSometimes users must substitute parts that5a test system BOM template that are not includedare not on the DB Hero BOM in the testin DB Hero part lists. User defined parts will onlysystem. User defined HW parts would usebe available for test system management. Userthe same attributes as DB Hero HW parts.defined parts will use the same categories asThis function will also be used for specialnormal DB Hero parts.items which must appear on the RTM report,like firmware versions.TEST-1.4.4User can use parts from more than one series on aAppropriate parts may not be available so5test system BOM.user should be able to use any part in testsystems.TEST-1.4.5When a defect is related to a test system, the test5system BOM template and other data isautomatically snapshotted. The snapshot must berelated to the defect.TEST-1.4.6DMI settings for each test system must be stored inThis data is included on RTM report. This4ePic. The user can enter the values for a set ofdata is output from the SXSYSINF toolkeys. The keys required are “Manufacturer,”maintained by System Engineering. Keys“Model Name,” “BIOS Lock ID,” “MCode (Un-must be kept in sync with the development ofencrypted),” “MCode Tool Version (CDS Modelsthis tool.Only),” “BIOS Information,” “UniversalInformation.” Keys should be configurable (noadmin screen necessary).TEST-1.4.7User can associate a test BOM or SKU BOM with4a test system. This BOM will be used to image thesystem.TEST-1.5Test Case Management.3TEST-1.5.1Test Cases can be associated with a series or3engineering part/major version combo. Anassociation is not required.TEST-1.5.1.1A Test Case result (Pass/Fail/Impeded/Not Tested)3can be stored for each combination of series andpart release. Results are not stored unless the testcase is added to a test strategy (default is “NotTested”). A text note and timestamp must bestored for each result entered in the system. Usershould be able to retrieve the Test Case resulthistory for a test case for a given Test Strategy orRelease.TEST-1.5.1.2Test cases have the following categories:3Basic, Ad-hoc, Use Case, Compatibility. FIV,Benchmarks, MDA, Screen Shot Capture,Accessory, Business Unit, and Other. Somecategories have special requirements. Seedescription of categories in section 9.11.5.1.TEST-1.5.1.2.1Benchmark and MDA Tests results include admincustom character3defined category/key sets. Category, Key, and theValue stored are all text fields. Categories shouldhave names and long descriptions.TEST-1.5.1.2.2Only users with admin privileges can define keyThese keys change regularly but3names to be used for Benchmark and MDA testing.infrequently. An admin screen (not configfile) is required for this function.TEST-1.5.1.2.3Screen Shot Capture tests can have an image fileThis is a special test case used for the RTM3(.JPG, .PNG, or .BMP) attached to it.report.TEST-1.5.1.2.4Compatibility Tests can have a list of required3parts attached to them. This is a text field filledout manually.TEST-1.5.1.3For all test cases “Level” can be set. Levels canThis attribute is used in Test Strategy3be 1, 2, 3, or “Sampling/Sanity Check” (seegeneration functions (see below).section 10.4.8, TST-13).TEST-1.5.1.4Test Case data for a single test case can bePer VOE review, 2005-11-10.3exported to an Excel spreadsheet.TEST-1.6Users can define named Test Case Groups.Functionality is similar but not identical to3groups used in software BOM creation.TEST-1.6.1Test Case Groups can be public or private. Private3groups are visible only to the user that created thegroup.TEST-1.6.2Test Case Groups can be assigned to the same3entities as Test Cases. Such assignments are usedas defaults when a user creates a new test within agroup.TEST-1.7Test Strategy Management.3TEST-1.7.1Each series defined in the system will have a test3strategy associated with it by default. A series teststrategy is a list of test cases and/or defectregressions to be executed against the latest seriessoftware BOM snapshot for that series.TEST-1.7.2User can create and ad-hoc named test strategy to3facilitate pre-integration testing. This test strategycan be associated with exactly one engineeringpart/major version.TEST-1.7.3Test cases and defect regressions can belong to3more than one test strategy. Test case can beadded to a strategy only once (no duplicatesallowed).TEST-1.7.4Test strategy auto-update and editing: TestOnly project test leads can perform these4strategies are partially auto-updated when a Projectactivities.Test Lead accesses the test strategy for a givenSeries/LangRegion combination.TEST-1.7.4.1For series test strategies, if a new series software4BOM snapshot has been changed or if the status ofthe snapshot has been changed to ReleaseCandidate (RC), the system will auto-update thetest strategy for any releases or that have changedsince the last time the test strategy was generated.Release for composite parts will be recursivelyprocessed (system will examine the BOMs for eachcomposite part, including FIs).TEST-1.7.4.2For ad-hoc test strategies the system will examine4the associated engineering part. Composite partswill be recursively processed.TEST-1.7.4.3Auto-update of test strategies is performed only for4the selected LangRegion.TEST-1.7.4.41st build (release) test strategy auto-update:4Triggered for the first release checked-in for thefirst major version of an engineering part.TEST-1.7.4.4.1Level 1 and 2 test cases associated with the4series/part and Level 1 and 2 test cases with noassociations are added to the test strategy.TEST-1.7.4.4.2User can manually add level 3 test cases and test4case groups. User can remove any auto-added testcases.TEST-1.7.4.5Minor revision test strategy auto-update: Triggered4for any new releases/defaults which are not thefirst release. Test cases are updated as follows:TEST-1.7.4.5.1Defect regressions are added to the test strategy:4Defects with resolution “Fixed” which areassociated with the current engineering part/majorversion or any of its releases are added to the teststrategy as “defect regressions.” There are no testcases associated with defect regressions (thoughthere may be test cases associated with the defectitself, they are not used here).TEST-1.7.4.5.2System adds test cases for any open defects againstIf defects matching the criteria do not have4the current engineering part/major version withassociated test cases then they are ignored byPriority of “Must Fix” or “Should fix.” Test casesthe system.for open defects with Priority equal to “None” andSeverity equal to “1” are also added to the teststrategy.TEST-1.7.4.6Major Revision test strategy auto-update: Triggered4for the first release checked in against a majorversion that is not the first major version.TEST-1.7.4.6.1Defect regressions are added to the test strategy:4Defects with resolution “Fixed” which areassociated with the previous engineering part/majorversion or any of its releases are added to the teststrategy as “defect regressions.” There are no testcases associated with defect regressions (thoughthere may be test cases associated with the defectitself, they are not used here).TEST-1.7.4.6.2System adds test cases for any open defects againstIf defects matching the criteria do not have4the previous engineering part/major version withassociated test cases then they are ignored byPriority of “Must Fix” or “Should fix.” Test casesthe system.for open defects with Priority equal to “None” andSeverity equal to “1” are also added to the teststrategy.TEST-1.7.4.7Final build test strategy auto-update: Triggered4whenever the latest series software BOM snapshothas been flagged as a Release Candidate (does notapply to ad-hoc test strategies).TEST-1.7.4.7.1System adds Compatibility, FIV, and Screen ShotIf a new snapshot has been generated and4Capture Test Cases to the test strategy.then flagged as an RC before the teststrategy has been auto-updated, the systemshould also run the appropriate auto-updatetasks.TEST-1.7.4.8User can re-initiate test strategy auto-update4manually at any time.TEST-1.7.4.9When an auto-update executes, system shouldFor example, using color coding.4display changes (test case adds, deletes, and statuschanges) to the user visually.TEST-1.7.5User can select a part on the test strategy and view3all open defects.TEST-1.7.5.1User can add test cases associated with open3defects to the test strategy.TEST-1.7.5.2User can add the defect as a defect regression3(implies changing status to “closed” and resolutionto “fixed”).TEST-1.7.6User can add/delete any test case or test group3from a test strategy (even if the test case was addedas part of an auto-update action).TEST-1.7.6.1If a level 1 or regression test case is deleted, aOnly one warning should be displayed for3warning/confirmation dialog is displayed to themultiple selections.user.TEST-1.7.6.2A note indicating that level 1 or regression test3cases were deleted from a test strategy, and whodeleted it when, should be added to the history log.TEST-1.7.7System should invalidate (set to “pending”) any testThis will only be done for Series Test4case result for parts if a new release for a part onStrategies, not Ad-Hoc ones.which they depend (based on dependencies definedin ePic) has been checked in. The invalidated testcases should be indicated (highlighted) for the useron screen. Results of the previous test case resultshould be retained by the system for reference.TEST-1.7.8Leads can assign Test Cases on a Test Strategy to3individual testers.TEST-1.7.9User can attach one or more test BOMs createdA test BOM can be extracted from the4using the function described in section 9.4.1,system via interface and used by installationrequirement BOM-1.9.tools to prepare a test system.TEST-1.7.10User can attach one or more SKUs to the testThe BOM associated with the SKU can be5strategy which have been created using the functionextracted from the system via interface anddescribed in section 9.6.1, requirement INT-1.12.used by installation tools to prepare a testsystem.TEST-1.7.11When a tester accesses a test strategy, the system3will display test cases/defect regressions assignedto that user, and any test cases/defect regressionsnot assigned to any user. Tester can update theresult of each test case and the status/resolution oreach defect displayed.TEST-1.7.12Test must select the Test System used before any5test results can be changed.TEST-1.7.13System must provide a view of a test strategies bySee RPT-21.4active series which displays the percentage of testcases completed.TEST-1.8System must provide function to escalate defect toThis requires an interface to the VELSUN5VELSUN (global sustaining system).system maintained by SDNA.TEST-1.9System must provide function to push defect toThis requires an interface to the VALSUN5VALSUN (software defect system used bysystem maintained by SDNA.SDNA/VBD).TEST-1.10Reports currently provided by VSMS for CISC4must be available in ePic.TEST-1.11All notes/text area fields should provide advanced5editing functionality.TEST-1.11.1Spell checker functionality should be available.5TEST-1.11.2Formatting functionality as follows:5BulletsNumbered listsColor textFont selectionTEST-1.11.3Formatting applied in edit screens should be5maintained for reports.TEST-1.12Benchmark/MDA Field editor. User can define3delete keys used for Benchmark/MDA test casecategories. Only users with admin privileges canuse this function.


9.11.2 User Interface Requirements

IDDescriptionCommentsPriorityTEST-2.1User interfaces for viewing test cases/strategies3should provide efficient means for updating data.TEST-2.1.1List of test cases and defect regressions should be3displayed in upper right panel. Test cases can bemarked as pass/fail and defect resolution can bechanged in this panel without opening otherwindows, only scrolling and clicking.TEST-2.1.2Facilitating for updating multiple test cases should beFor example, check boxes for selecting test3provided.cases and action buttons that apply attributechanges to all select test cases.TEST-2.1.3Details of each selected test case should be displayed3in lower right panel.TEST-2. 1.4Test cases marked as “failed” should trigger a3prompt for entering a defect. Defects created in thismanner will be automatically linked to theappropriate test case.TEST-2.2Defects can be entered directly from the main3menu/navigation panel or can be entered when a testcase has been marked as failed. If a defect is enteredin connection with a test case the defect.TEST-2.3Installation tools and recovery images can beSame as requirement DEV-2.2 since these1downloaded from ePic manually by UI.items will be defined as engineering parts inePic.


9.11.3 Business Rules

IDDescriptionCommentsPriorityTEST-3.1


9.11.4 Interface Requirements

IDDescriptionCommentsPriorityTEST-4.1VELSUN Interface. Used to escalate defects toSatisfies US sustaining requirements.5global sustaining group.TEST-4.2VALSUN Interface. Used to push defects into5software development defect database used inVBD/SDNATEST-4.4Tools interface. Tools will provide functions forAssumption is that testers will perform all4selecting test BOMs and SKU BOMs to be providedtest case/defect updating and test BOMto installation tools.preparation via ePic UI.TEST-4.4.1Data to be exported:These requirements can be merged with4Active Series Masterbuild tool requirements since the same toolsLangRegion Masterplatform will be used to interface to ePic.Test BOMsSKU BOMsAll DB Hero Data for Component SelectorTEST-4.4.2Functions to be provided:Some functions defined in requirements INT-4Authenticate.4.5 and INT-4.6 will be used and areGet Active Series.duplicated here.Get open defects for engineering part (usedTest BOMs contain software release ID'sduring release check-in).and thus don't require an installation dataUpdate defect status and resolution (used duringfile. SKU BOMs are DB Hero componentrelease check-in).lists and will require an Installation DataGet Test Strategy for series/part.File.Get Test BOMs for test strategy.Get SKU BOMs for test strategy.Get Installation Data File for series.Get Binary Data for SW Release ID (from filestore).Functions to allow the component selectorfunction to be used remotely with tools to createand save SKU BOMs.


9.11.5 Definitions


9.11.5.1 Test Case Types

NameDescriptionBasicAd-hocUse CaseDescribes a regular user scenario.CompatibilityList of steps to test compatibility with externaldevices (e.g., printer or camera).FIV (Final ImageValidation)BenchmarksPerformance parameters captured as key/valuepairs.MDA (MicrosoftPerformance parameters dictated by MicrosoftDevelopmentcaptured as key/value pairs.Agreement)Screen Shot CaptureSpecial test case consisting of just an image, whichis included on the RTM report.Business UnitAccessoryOther


9.11.6 Screen Shot Mock-ups



FIGS. 12-17 show various non-limiting screen shots for defect submission, defect update, test case submit form, defect view, test results, and test case update, respectively.


Reporting and Notification


9.12.1 General Requirements

IDDescriptionCommentsPriorityRPTREQ-1System must provide a custom reporting engine3which will allow custom SQL to be stored and run.RPTREQ-2Reports can be viewed on screen or downloaded inXML is not required for software integration3the following file formats:and factory deployment reports, because theAdobe Acrobat (PDF)installation data file contains all requiredMicrosoft Excelinformation in a single XML file.Comma Separated Values (CSV)MS Word format is required for the RTMXML (Test/Defect Reports only except forreport. If Word format files cannot beRTM)generated then a format that can be importedMicrosoft Word (RTM Report Only)into MS word is acceptable as a substitute.RPTREQ-3Some complex reports are configurable by the user.Details are specified in report descriptions.3Which data sets to be included and criteria for thereport data can be specified before the report isgenerated.


9.12.2 Reports


The following predefined reports must be provided by ePic. Samples can be found in the appendix (chapter 13.3).

IDReport NameDescriptionCommentsPriorityRPT-1Series ReportReport of all relevant information for a given Series2(SW BOM and Metadata).RPT-2Series BOMReport of all relevant SW BOM information for a2Reportgiven Series.RPT-3Series MetadataReport of all relevant metadata for a given Series.2ReportID was skipped (it is retained to avoid confusion).RPT-5BOM ReportReport of all relevant information for a given Part,Has Optional Data Choices:2Group or Release which has a BOM.parts, dependencies, parents,children, releases.RPT-6Module ReleaseReport of all relevant information for a givenHas Optional Data Choices:2ReportModule Release including BOM and Metadata.parts, dependencies, parents,children, releases.RPT-7Group ReportReport of all Parts and Releases in a given group.Has Optional Data Choices:2parts, dependencies, parents,children, releases.RPT-8Image BOMReport of all Parts and Releases in a given ImageHas Optional Data Choices:2ReportBOM.parts, dependencies, parents,children, releases.RPT-9BOM FreezeReport of all relevant information for a given SeriesPrevious report is an optional2ReportBOM - which includes a report of new items,drop down menu of ALLupdated items, missing items, removed items (fromavailable Series BOM Snapshotprevious report).revisions (this means you couldcompare two different Series).The user would be required toselect a BOM Snapshot to do thereport for and then a BOMSnapshot to compare it to. If nocomparison BOM Snapshot isprovided it simply creates thereport.RPT-10Media SetReport of all Components, Parts and Releases usedFactory Media Report would2Reportin a given factory or recovery media set.include Metadata for Factory.RPT-11Part ReportReport of all relevant information for a given Part.Has Optional Data Choices: part2releases, dependencies, parents,children.RPT-12Part ReleaseList of all Releases by major part with basic attributeHas Optional Data Choices:2Reportinformation.dependencies, parents, children.RPT-13Part ReleaseReport of all relevant information for a given PartHas Optional Data Choices:2Version ReportRelease Version.dependencies, parents, children.RPT-14RTM ReportThis is a multi-part report containing test systemTest/Defect report.3information, detailed SW BOM information, defects,test cases/results, and other items.User must select a Series/LangRegion and one ormore OSs from the report. User must also selectwhich sub-reports to include. The system will thenextract all required information from the relevant teststrategy and BOMs and format it.The report must be output in MS Word (orcompatible format) since it must be edited furtherafter being generated from ePic.See sample in appendix (13.3.14) for more details.RPT-15Test Status forThis Report should list ‘Unresolved Defects’ andTest/Defect report.2Series‘Test Cases’ that needs to be executed for aparticular Series.User can specify where test cases, defects or bothare to be included in the report.Unresolved Defects: Defects with ‘Defect Status’equal to Open and ‘Defect Resolution’ not equal to‘Fixed’, ‘Deferred’, ‘Will not Fix’, ‘Duplicate.’Defect Attributes to include in the report: Defect ID,Part, Summary, Severity, Exposure, DefectResolution (sorted by Priority).Test Cases that need to be executed: List of testcases with ‘Test Results’ equal to ‘Not Tested’ or‘Impeded.’RPT-16Test Status forSame as above for all active series. Sorted by Series.Test/Defect report.2all ActiveSeriesRPT-17Defect reportDisplays all available attributes for a defect. UserTest/Defect report.2for Individualcan optionally request that defect history be includedDefectin the report.RPT-18Defects byThis is a configurable report for Defect analysis. ItTest/Defect report.3user, team,is intended to be a way to export defect data forseries, cycle,analysis into external tools or for importing to otheretc.systems.Filtering fields for Defect: Defect ID, Defect Status,Defect Resolution, Responsible persons, Priority,Severity, Exposure, Champion, Defect Submitter,Submit Date, Close Date, Frequency, Assigned to,Microsoft Defect ID, Beta ID, Sustaining Status,Sustaining Priority, Days Open (less than or equal togiven number), Series, Part.custom characterSystem will include all available defect attributes inone table/data structure.RPT-19Test CaseThis report is similar to RTP-18 except it is for testTest/Defect report.2Reportcases.Filtering fields for Test Case: Test Case ID, TestCase Type, Test Results, Part, Series, Test Area,Status, Level, Submitter, Last Updated, ExcludedSeries, Submit Date, Linked Defects (to a particulartest case).System will include all available test case attributesin one table/data structure.RPT-20Test StrategyListing of test cases on a test strategy. User canTest/Defect report. PQD would2Reportoptionally request a view.like this report to functionsimilarly to the view onhttp://platform.itd.sel.sony.com/(click on “test cases” on menu).RPT-21Test StrategyA view of a test strategies by active series which2Status Reportdisplays the percentage of test cases completed.RPT-22End-of-cycleThis report contains summary information on various3Defect Reportdefects for one or more series and/or time periods.It is to be used as a post-cycle analysis tool.User can select one or more Series/LangRegions.User can also select one or more cycles or dateranges (for product cycle, initial product cycleattribute of the series would be used). User can alsoselect which sub-reports to include.Data is exportable as PDF or excel files (it is okay ifmore than one excel file is generated).The sub-reports are as follows:Defect PriorityDefect SeverityDefect ExposureDefect Resolution by Application ChampionDefect Resolution by Module (recursive for FIBOM)Top Ten Deferred/Will Not Fix Defects.RPT-23Build CountTable of Series, OS, FI build count, and RecoveryTest/Defect report. Used for2media build count.end-of-cycle accounting.User must select cycle, date range, or all activeseries.RPT-24FI Test CaseTest Case results for a cycle or date range by FITest/Defect report.2Reportrelease.RPT-25Module TestTest Case results for a cycle by Series SW BOMTest/Defect report.2Case Reportsnapshot (test strategy).


9.12.3 Notification


9.12.3.1 General Requirements

IDDescriptionCommentsPriorityNOTE-1Email notifications will not be tied to roles, but4functions for adding sets of email addresses to anotification list by system role or group should beavailable. Any email address can be added to anotification list (not just system users).NOTE-2When a new user is assigned a role in ePic system4should present a list of events to the administrator forwhich notification is available. User will be added tothe list for any events selected.NOTE-3All notification lists can be edited manually in the4system.


9.12.3.2 Events


The following events will trigger email notification to users. On screen notifications are indicated elsewhere in this document.

IDDescriptionReferenceCommentEVENT-1Email notification is issued when a release check-in isDEV-1.2.8completed (files have been uploaded to file store).EVENT-1.1Email notification lists should be stored for eachThis requirement will satisfy theEngineering Part Type (editable via admin screen).need to monitor image builds(Pilot, RC, GM events).EVENT-2RTM email notification requirements. RTM emailsMFG-1.2.2,should be sent when “Test RTMs,” “RTMs,” andMFG-1.3.2“running change RTMs” are issued in the system.EVENT-2.1Email lists should be maintained by series.EVENT-2.2Emails should clearly indicate which event for whichthe email is being sent.EVENT-2.3Each email notification should contain a uniqueidentifier in the subject line and body of the messagethat can be used to refer to the message. RTM emailnotifications should be logged in a history log that canbe viewed via ePic UI.EVENT-2.4Email content should also be attached as a PDFdocument to the email message (to be used as officialdocumentation).EVENT-3Series SW BOM snapshot created. Changes since theNotification of changes to thelast snapshot (per MFG-1.3.2) should be included inSeries SW BOM (module/imagethe notification.insertions).EVENT-3.1Email lists are maintained by Series.EVENT-4Series Software BOM snapshot flagged as releaseThis is a “BOM Freeze”.candidate.EVENT-4.1Email lists are maintained by Series.EVENT-5Defect submission or defect status/resolution change.Defect monitoring is performed by engineering part.Users can also choose to receive all.EVENT-5.1Application champion and any users on the owner listIf a user wants to monitor afor the affected engineering part should bespecific part they must be addedautomatically added to the notification list. Anyto the owner list.owners of a test case associated with the part must alsobe notified.EVENT-5.2Users can also subscribe to receive defects events bySeries and/or LangRegion.EVENT-6New series loaded in ePic from DB Hero.


9.13 Administration


9.13.1 Usage Requirements

IDDescriptionCommentsPriorityADM-1.1Add/edit user.1ADM-1.1.1User is required to be associated with an engineering1organization.ADM-1.1.2User can be assigned one or more roles.1ADM-1.1.3Users email address must be stored by system.1ADM-1.2Add/edit engineering organization.custom character1ADM-1.2.1Engineering organizations can be Sony or 3rd party.custom character1ADM-1.3Manage 3rd party data access.custom character3ADM-1.3.1One or more series can be assigned to a 3rd partycustom character3organization. The 3rd party organization users willonly be able to see/download data concerning theseries' which have been assigned to them.ADM-1.4Add/edit LangRegion's.custom character1ADM-1.4.1User can add/remove LangRegions to/from the1master.ADM-1.4.2DB Hero SPECS are mapped to correspondingThis requirement can be dropped if1LangRegions defined in the system.LangRegion relationship to DB Hero SPECSand COMPONENTS can be identifiedprogrammatically.ADM-1.5System will provide functionality to make batchThis is an admin function only. Users must2changes to attributes entities. User can search forchange items one by one.entities, select groups of items to change, and changeone or more attributes for all items in the group.ADM-1.6System should provide a function for defining teamsSome test/defect functions call for2of users.assignment to a team.The group management functionalityimplemented in ePic prototypes may satisfythis requirement.ADM-1.7Admin functions for defining values for Test Area2(10.4.9, TST-006) and Status (10.4.9, TST-013)should be available.


9.13.2 User Interface Requirements

IDDescriptionCommentsPriorityADM-2.1


9.13.3 Business Rules

IDDescriptionCommentsPriorityADM-3.1


9.13.4 Interface Requirements

IDDescriptionCommentsPriorityADM-4.1


9.14 ePic Interface Library


This section describes requirements for the ePic database interface library API for Build Tools and Test System Preparation Tools. Some interface requirements and tools requirements in other sections of this document are satisfied in whole or in part by this API.


VOA tools covered are Magellan and Modular Image Network Download System (MINDS).


All VOA build tools use ePic data, but most of the tools use flat files created by Magellan, as the source of data. Build tools also check in software releases and images and thus need to be able to write data to the ePic database and upload files to the file store.


VOA test system preparation is performed using MINDS tools. These tools are provided on a WinPE CD. This toolset will be made available to ePic users.


SDNA will use VOA provided build tools.


9.14.1 ePic Database Interface Requirements


The ePic database interface should provide the following functions. When a “Recordset” is specified as return value, all applicable attributes for the entity should be included in the Recordset.

IDFunctionParametersReturn valueCommentsUsed ByPriorityDLL-1AuthenticateUserUserIDAuthenticate user. TheMagellan,2PasswordSecurityTokensecurity token shouldMINDSAction (optional)be passed on to allother functions. Allother functions can thencheck for a valid securitytoken before getting data.DLL-2GetImageBOMDataSecurityTokenRecordsetThis function shouldMagellan1BOM Snapshot IDreturn all items on theisBasePlus (optional)specified Image BOMisOPK (optional)that meet the criteriaisRecoverable (optional)set by the optionalarguments. If anoptional argument isnot passed to thefunction, that criteriashould be ignoredDLL-3GetModulesEPCsSecurityTokenRecordsetThis function shouldMagellan1Series IDreturn all modules andLangRegionEPCs for the specifiedisPermanent (optional)Series/LangRegion. IfPermanent argument isTrue, return allpermanent items. If it isFalse, return alltemporary items. If it isnot specified return allitems.DLL-4GetSeriesSecurityTokenRecordsetThis function shouldMagellan,1return all active series.MINDSDLL-5GetLangRegionsSecurityTokenRecordsetThis function shouldMagellan,1return all availableMINDSLangRegion values.DLL-6GetBOMListSecurityTokenRecordsetThis function shouldMagellan,1Series IDreturn a list of availableMINDSLangRegionImage BOMisImageBOM (optional)Snapshots/Module BOMisModuleBOM (optional)Snapshots/All BOMSnapshots (depending onoptional arguments) forgivenSeries/LangRegion.DLL-7GetBOMSecurityTokenRecordsetThis function shouldMagellan,1BOM Snapshot IDreturn the BOM contentsMINDS(parts release list) forselected BOM SnapshotID.DLL-8UploadFilesSecurityTokenBooleanThis function shouldMagellan,1Part Release IDupload Part Release filesMINDSFiles to be uploaded.to the ePic file store.One function callshould upload all therequired files. We donot want to call thisfunction for each file.This function must becalled after CheckInPartRelease. It may becalled minutes or hoursafterCheckInPartReleaseformodules (becausemodules require releaseID to be embedded in themodule).DLL-9CheckInPartReleaseSecurityTokenPart Release IDThis function should addMagellan1All Part Release data fora new Part Release to thethis Part Type.ePic database.DLL-10UpdatePartReleaseSecurityTokenBooleanThis function shouldMagellan1Part Release ID.update Part ReleaseAll other Part Releaserecord. This function isdata for this Part Type.required as some partreleases may be createdusing ePic and thenupdated from MagellanDLL-11GetSeriesForPartSecurityTokenRecordsetThis function shouldMagellan2Part IDreturn a list of Series thathave this Part on theirBOM Templates.DLL-12AddPartReleaseToSeriesSecurityTokenBooleanThis function shouldMagellan2Part Release IDassign the specified PartSeries IDsRelease to one or moreSeries.DLL-13GetDefectsForPartSecurityTokenRecordsetThis function shouldMagellan2Part IDreturn a list of defectsStatus (optional)that are currentlyassigned to this Part.Optionally result set canbe filtered by defectstatus.DLL-14UpdateDefectsSecurityTokenThis function shouldMagellan2Part Release IDupdate the defect statusDefect IDsof specified defects. ThisNew Defect Statusesallows the user toNew Defect Resolutionsspecify what defects haveNew Defect Notesbeen fixed in this ReleaseDLL-15GetReleaseEmailContentsSecurityTokenTextGet the email text. ThisMagellan2Part Release IDis used to display theemail notification to theuser before it is actuallysent out.Emails sent fromMagellan will provideinformation on PACFiles, FI image, AppInfoand DataFile contents.DLL-16SendMailSecurityTokenBooleanSend email notification.Magellan2Part Release IDThe contents of the emailCCTextwill be generatedautomatically like partreleases checked in fromePic. Emails sent fromMagellan will have adifferent target recipientlist. User should be ableto add additionalrecipients.DLL-17LaunchComponentSelectorSecurityTokenString/RecordsetLaunch ComponentMINDS2Series IDSelector to allow user toLangRegion is FreeStyle.select a configuration,check for validity andreturns valid selection ofparts.This is used to create aSKU BOM in freestylemodeDLL-18GetSKUBOMSnapshotSecurityTokenRecordsetThis function shouldMINDS2ListSeries IDreturn a list of availableLangRegionSKU BOM snapshots forgiven Series/LangRegionDLL-19GetSKUBOMSecurityTokenRecordsetThis function shouldMINDS2BOM Snapshot IDreturn the SKU BOMcontents (parts list). Itshould also return theinstallation data file(either as XML orlocation from where itcan be obtained).DLL-20AddLogSecurityTokenBOOLThis function adds aMINDS2MACAddressrecord to the log.IPAddressSessionIDUserAction PartReleaseNameReleaseIDSizeStartTimestampEndTimestampTimeModeDLL-21GetLogSecurityTokenRecordsetThis function should getMINDS2LogID (optional)the specified log record.DLL-22GetSystemTimeSecurityTokenStringGet time on DB server;MINDS2value used in AddLog.(This can beimplemented withinAddLog in which casethis function is notrequired).DLL-23IsHDDProjectSecurityTokenBOOLCheck if Series usesMINDS2SeriesHDD recoveryLangRegion


9.14.2 Technical Requirements
    • Database access for use in MINDS must be able to run in the stripped down version of Windows, Windows Preinstall Environment. (This generally means the code must be written in C++. It's possible to write the programs in Java, Python, Perl, etc., but this would need to be tested and set up within WinPE.)
    • The Database Interface Layer should support applications running in different environments and developed using different programming languages, as shown in the Appendix 1.3.1.
    • All functions in the ePic Database Library should implement stateless security. For example, The Authenticate function should return a SecurityToken object that is then passed to other functions. These functions then check if the security token is valid before interacting with the database. Any other security mechanism can also be used.


      9.14.3 Architecture


      9.14.3.1 VOA Tools



FIG. 18 shows the non-limiting architecture of VOA Tools.


9.14.4 Usage Scenarios


9.14.4.1 MINDS Usage Scenarios


9.14.4.1.1 Download Image to Test System from MINDS CD.



FIG. 18A logic can be used by testers and by integrators.


9.14.4.1.2 Upload Foundation Image.



FIG. 19 refers, which has been described above and which can be used by integrators.


9.15 Sustaining


This section describes requirements for ePic from the Global Sustaining Group. These requirements will extend existing functionality.


9.15.1 Usage Requirements

IDDescriptionCommentsPrioritySUS-1.1Sustaining modules will be managed in ePic.5SUS-1.1.1A new part type “Sustaining Module” must be5added to ePic.SUS-1.1.2Addition sustaining specific attributes must be5supported.SUS-1.1.2.1Sustaining ID (or SP-ID), separate from normalcustom character5Part/Release ID must be maintained by ePic andreturned when applicable by check-in functions.(ePic will manage this sequence.)SUS-1.1.3Sustaining module release notifications will be sent5to a different email notification list than for othermodules.SUS-1.1.4Sustaining modules must have a unique identifierThis is similar functionality as other ePic5embedded in them to support post-installationmodules.verification by “VAIO Update” software.SUS-1.2Sustaining users should be able to retrieve software5BOM information from ePic UI.SUS-1.3Support groups require a network installationTest System Preparation CD can be used for5system.this purpose.SUS-1.4Maintenance Desk requires Recovery Media5(RDVD's/Fulfillment Media).SUS-1.5Module Specification should be unified withThis is so developers only need to create on5Sustaining Patch specification.format.SUS-1.6Software BOM views in ePic should also displaycustom character5any applicable sustaining patches.SUS-1.7Search function should allow entry of a modelcustom character5name.SUS-1.8Search functions should allow Series/LangRegionscustom character5to which a particular sustaining patch has beenapplied to be to be found by Sustaining Part ID(SP-ID).SUS-1.9User can use Part Name/Major Version as a search5key to find Series/LangRegion or list of sustainingpatches.SUS-1.10Legacy data must be maintained in ePic for a timecustom character5period suitable to sustaining.


9.15.2 User Interface Requirements

IDDescriptionCommentsPrioritySUS-2.1


9.15.3 Business Rules

IDDescriptionCommentsPrioritySUS-3.1


9.15.4 Interface Requirements

IDDescriptionCommentsPrioritySUS-4.1


10 Data Model


10.1 Concepts



FIG. 20 shows the overall, non-limiting system architecture for Sony PC production. The figure gives an overview for an ePic related systems diagram.


10.2 Data Structure


Moving to FIG. 21, the data structure and flow chart of ePic are shown.


10.3 Database Entities



FIG. 22 illustrates a non-limiting ePic database entities diagram.


10.4 Attributes


10.4.1 Series

AttributeRe-Mod-BasicExt.IDNameDescriptionCommentsIntended UsageExamplesquiredifiableSearchSearchSER-SeriesAuto-generated system001IDidentifier.SER-SeriesIRX or ATX number.IRX-3150,YNYY002NameATX-2230SER-CodeTextual code name forDiablo EPDYNYY003Namethe series.SER-MarketingThere will be manyMay be mapped to aSelection criteria inVGN-S270,YYYY004Name(region to region, cycleseries SW BOM andsystem screensVGN- S27,to cycle). Forone or morereporting.VGN-S270A,Example: PCV-RS500LangRegions.VGC-RB30,Functionality dependsVGC-RB30Con DB Hero handlingof Marketing Modelname.SER-OnOne date for eachMaintainedReporting.NYNY005SalesLangRegion.independently in ePic.DateMay be useful forsatisfying sustainingrequirements.SER-OffOne date for eachMaintainedReporting.NYNY006SalesLangRegion.independently in ePic.DateMay be useful forsatisfying sustainingrequirements.SER-EndYes/No. Defaults to no.MaintainedReporting.NYNY007ofindependently in ePic.LifeMay be useful forsatisfying sustainingrequirements.SER-StatusPlanning, active, archive,MaintainedReporting.YYYY008obsolete, sustaining.independently in ePic.(req)(req)SER-CommentsLong description of aMaintainedReporting.NYNY009series.independently in ePic.SER-CreatedSeries should not be010Bycreated manually -only imported from DBHero. DB Hero“created by” is notnecessary here.SER-Created011DateSER-ActiveYes/NoMaintainedControl display andYYYY012independently in ePic.default series lists.SER-PlanningList of planning cyclesReporting.2005 Q3,YYYY013Cycle/applicable for this series.2005 Q4,Season2006 Q1SER-ChangeHistory, systemMaintained014Loggenerated/maintainedindependently in ePic.SER-ProductionList of production sitesMaintainedMay be used forNFCH,NYNY015Sitefor this series.independently in ePic.RTM and test-RTMUCCH,release status byDPCH,production site toIT-M,facilitate file storeSNTfunctionality andreporting.SER-LangRegionsList of LangRegions toMaintainedUsed to filter the listen_US,NYYY016Supportedbe supported by thisindependently in ePic.of LangRegions onen_UK,engineering part.screens and forjp_JP,reporting.etc.


10.4.2 Components

IntendedBasicIDAttribute NameDescriptionCommentsUsageExamplesRequiredModifiableSearchExt. SearchCOM-001Component IDYYCOM-002Component NameYYCOM-003ActiveYes/NoYYComponents areYYunique per series sothis is really a seriesattribute.COM-005TypeNYComponents areNYsystem generated inDB Hero. There isno comments field.COM-007Child PartsListNYCOM-008List of SpecsSpec-to-ComponentNYrelationship may beneeded for ePicfunctionality.


10.4.3 Planning (DB Hero) Parts

IDAttribute NameDescriptionCommentsIntended UsageExamplesRequiredModifiableBasic SearchExt. SearchPP-001Part NameYYPP-002Part IDDB Hero PartYYNumber (notvendor part number).PP-003ActiveYes/NoYY(req)PP-004SW/HWFlagYYPP-005Major VersionAssumption isYYthat it will beseparated fromdescription inDR Hero froSW items.PP-006VendorYY


10.4.4 Engineering Parts

IDAttribute NameDescriptionCommentsIntended UsageExamplesRequiredModifiableBasic SearchExt. SearchEP-001Part NameThis is only application name with no versionCan be added to a group.Adobe Premiere,YYYYinformation.Sonic Stage Studio,Radeon 7500 DriverEP-002Parent Planning PartRelationUsed to facilitateIndex to DB HeroNYYYSeries SW BOM creation.EP-003ActiveYes/NoUsed to controlflag (0 or 1)YYYYdisplay of parts to(req)(req)users. Only activeparts should beshown in mostscreens. Inactivepart releases can bearchived from file store.EP-004Major VersionMajor version numberNew majorCan be added to a1.1, 2.4, 6.0, 7.0,YYYY(For Example: 1.1, 1.2,versions aregroup.4.2.00.06070(Not1.3).created whenfor LA)specificationschange —notwhen defectsare fixed orminor changesare made.EP-005Part TypeImage, OS Setup,See below.Lookup ListYNYYInstallable Application,including: Image,Internal Tools,OS Setup,BIOS/Firmware, MediaInstallableSet, OtherApplication,Internal Tools,BIOS/Firmware,Media Set, OtherEP-006Part Sub TypeImage (Foundation, P1,See below.Lookup ListYNYYMonolithic Image)/including: ImageInstallable Application(Foundation, P1,(Application, Driver,Monolithic Image)/Online Documents, OSInstallableAdd-on, Module)/ApplicationMedia Set (Recovery,(Application,Factory)Driver, OnlineDocuments, OSAdd-on, Module)/Media Set(Recovery, Factory)EP-007DependencyTextual description of aInformation for builders.Text field: IE canNYNYAppenddependency that is notonly be installed onenforced by the system.Tuesday.EP-008DependencyList of parts with “Don'tUsed toRelation to anotherNYNYcare,” “Need,” orvalidate/completeengineering part“Exclude” specified forrelease lists forindex.each part. System cantesters and duringenforce/interpret theseBOM creation.dependencies.EP-009Install OrderList of parts with “Don'tUsed by installationRelation to anotherNYNYcare,” “Before,” ortools to controlengineering part“After” specified fororder of releaseindex.each part.install.EP-010Customer LabelUsed in SingleDisplayed toAdobe PremiereY (forYNYApplication Recovery.customer duringStandard forrecoverableText for eachapplicationWindows XPapplicationsLangRegion.recovery.English, nVidiaonly)Graphics Driver,DVGate 2.0EP-011Customer DescMarketing Desc/HoverDisplayed toInstant VideoY (forYNYtext used in Singlecustomer duringEverywhere: SignrecoverableApplication Recovery.applicationup for IP VideoapplicationsText for eachrecovery.Conferencing.only)LangRegion.EP-012BLIDUsed for FoundationAssignedUsed duringUCV156PEUMY (for FIYYNImage sub type only.manuallyinstallation ofonly)BLID = BIOS Lock ID.currently.releases. Stored inUniquelyDMI.identifiesfoundationimage in VOA.One FI canhave multipleBLIDs inVBD/VOE.EP-013Is DefaultYes/no (default for eachActualCreating Snapshotsflag (0 or 1)YYNYPart Name, Majorimplementationof BOM TemplatesVersion, Release,per the data(Groups).LangRegionmodel providedcombination). Defaultsby Neusoft.to false.EP-014ChampionPerson responsible forRelation to a userNYNYtesting info. One orindex.more persons can belisted.EP-015OwnerContactRelation to a userYYNYPersons/Developer.indexOne or more personscan be listed.EP-016Localized ByEng. Organization whichFor informationtext field: VOE,NYNYlocalized the part.only. Not used bySDNA, VOA,Manually maintained.system.STC, VBDEP-017Target SeriesList that describes BOMIRX-3440, IRX-NYNYtemplate(this part needs3760, ATX-7100to go on these series).Specified by developers,integrators. Used togenerate series s/w bom.EP-018Series DependencyText description forFor informationText descriptionNYNYinformation, if any.only. May be usedfor information, ifby builders/testers.any.EP-019SupportedList of LangRegions toUnsupportedRelatuion toNYNYLangRegionsbe supported by thisLangRegionsLanguage Regionpart.should not beindexes: ENU-US,shown to users inENU-UK, SPA-otherLA, etc.screens/functions.EP-020Localized VariationYes/No —enablesUI control.flag (0 or 1)NYYYfunctionality for definingPlanned LocalizedVariations.EP-021Planned LocalizedA named group ofAlternate way toLook up table toNYNYVariationLangRegions. Theselect multipleLangRegionGroupsname of variation isLangRegions formanually specified andscreen functions.can be anything. ForReleases areexample: “EN-NTSC” ->associate withen_US, en_UK;LangRegions and“EN-PAL”->en_DEnot PlannedRelease Variations.EP-022Change LogHistory, systemAll changesHistory, systemgenerated/maintained.should begenerated/maintained.logged withwho and when.EP-023OSXPP, XPH, MCE,XPP, XPH, MCE,YYNYWinPE, etc. Only usedWinPE, etc. Onlywhen Part Type isused when PartImage.Type is Image.EP-024EPC/Module/X-For Module sub-typesUsed in VSMSUsed by buildersLook up table:Y (forYNYModuleonly. Select one of(VOA) toand installationEPC/Module/X-modulesthese (mutuallydescribe atools.Module.only)exclusive). EPC = EngineeringModule. MayProcesschange pendingChange.installationtool/recoveryspecificationdefinition.EP-025Is TemporarySpecifies the part mustInverse ofUsed by installationflag (0 or 1)NYNYbe deleted fromVOA “Istools.recovery partition afterPermanent”installation in theattribute.factory. Defaults tofalse.EP-026SpecificationFreezeOne date for eachFor informationDate field perNYNYSchedPlanned Localizedonly. In the future,LangRegionGroupVariation.will be used tospecified above.trigger emailnotifications.EP-027GUIFreezeSchedOne date for eachFor informationDate field perNYNYPlanned Localizedonly. In the future,LangRegionGroupVariation.will be used tospecified above.trigger emailnotifications.EP-028FeatureFreezeSchedOne date for eachFor informationDate field perNYNYPlanned Localizedonly. In the future,LangRegionGroupVariation.will be used tospecified above.trigger emailnotifications.EP-029RCRelaseScheduleOne date for eachFor informationDate field perNYNYPlanned Localizedonly. In the future,LangRegionGroupVariation.will be used tospecified above.trigger emailnotifications.EP-030GMReleaseSchedOne date for eachFor informationDate field perNYNYPlanned Localizedonly. In the future,LangRegionGroupVariation.will be used tospecified above.trigger emailnotifications.EP-031GMReleaseActualOne date for eachFor informationDate field perNYNYPlanned Localizedonly. In the future,LangRegionGroupVariation.will be used tospecified above.trigger emailnotifications.EP-032Default InstallerINF, EXE/BATCH,Install Property:lookup table: INF,N (for majorYNYType (select fromFILE COPYDefined inEXE/BATCH,version)list).MajorVersionFILE COPYas defaults,carried over toRelease, can bemodified atcheck-in.EP-033Default Setup FilePath to setup file relativeInstall Property:Used by build tools\setup.exe orN (forYNYto top level folder ofDefined into find setup\DVGATE\config\setup.majorrelease. Text Field.MajorVersionexecutable.exeversion)as defaults,carried over toRelease, can bemodified atcheck-in.EP-034Default CommandArguments to be passedInstall Property:Used by build tools/quiet/passiveN (for majorYNYLine Argumentsto “Setup File”. TextDefined inwhen running setup/norestart -sversion)Field.MajorVersionexecutable.as defaults,carried over toRelease, can bemodified atcheck-in.EP-035Default OPKYes/No: Set for eachInstall Property:Used by buildflag (0 or 1)Y (for majorYNYEngineeringDefined intools.version)OrganizationMajor Versionas defaults,carried over toRelease, can bemodified atcheck-in.EP-036Default Base PlusYes/No: Set for eachInstall Property:Used by buildflag (0 or 1)Y (for majorYNYEngineeringDefined intools.version)OrganizationMajorVersionas defaults,carried over toRelease, can bemodified atcheck-in.EP-037Default RecoverableYes/No: Set for eachInstall Property:Used by tools.flag (0 or 1)Y (for majorYNYEngineeringDefined inversion)OrganizationMajorVersionas defaults,carried over toRelease, can bemodified atcheck-in.EP-038Default InteractiveYes/No: user interactionInstall Property:Used by buildflag (0 or 1)Y (for majorYNYrequired?Defined intools.version)MajorVersionas defaults,carried over toRelease, can bemodified atcheck-in.EP-039VendorVendor of the software.This is simplyRelation to VendorYNYYan additionalIndexattribute. Itshould not beconcatenatedwith partname. Thereshould be aseparate tablewith basicVendorinformation.Vendor namemay also beincluded in partname if itmakes sense.


10.4.4.1 Engineering Part Types

TypeSub-TypeDescriptionSpecial RequirementsImageImage file(s)FoundationP1WinPE image used for HDD Recovery Partition.Monolithic ImageOS SetupOPK unattend setting, i386 folder.May include some OPKspecific attributes.Installable ApplicationInstalled on customer partition.ApplicationApplication as delivered from vendor. May berepackaged.DriverOnline DocumentsPDF Files and other documents installed on systems.OS Add-onQFE's, PatchesModulePackaged application: non-interactive installation,Can be X-module, module,secured, ready for factory delivery. Usually includes anor EPC.application and some internal tools.Internal ToolsTools, DLL layer, P1 tools/files.BIOS/FirmwareFirmware updates not recoverable by customer.Media SetRecoveryCustomer recovery media.FactoryMedia set for factory deployment.OtherCatch all for other types of files. Can be anything, ForExample “manual settings requests.”
    • Part types will have different system workflows.
    • Some types or sub-types may require additional attributes to be captured in the system.
    • Functionality for sub-types within a part type is mostly the same.


      10.4.4.2 LangRegion Table


The following table lists the LangRegions to be used initially.

LanguageLangRegionDescriptionenen_USEnglish for USA.en_GBEnglish for UK and other EU.en_intEnglish for Asia Pacific.dede_DEGerman for Germany, Austria, Switzerland.frfr_FRFrench for France, Belgium, Switzerland.fr_CAFrench for Canada.jaja_JPJapanese for Japan.koko_KRKorean for Korea.eses_ESSpanish for Spain.es_latSpanish for Latin America.itit_ITItalian for Italy, Switzerland.nlnl_NLDutch for the Netherlands, Belgium.zhcns_CNSimplified Chinese for China.zhcnt_TWTraditional Chinese for Taiwan.ptpt_PTPortuguese for Portugal.elel_GRGreek for Greece.ruru_RURussian for Russia.


REFERENCES

Language code (ISO-639)


http://ftp.ics.uci.edu/pub/ietf/http/related/iso639.txt


Region code (ISO-3166)


http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html


10.4.5 Software Releases


For the attributes listed as “required” in search columns, only one of the required fields must be specified by the user.


Some attributes are duplicated between Engineering Part and Release: The attributes set for engineering part should be used as defaults when creating a new release. User can override values set for engineering part at the release level. This function is intended to reduce repetitive data entry due release check-in.

IDAttribute NameDescriptionCommentsIntended UsageExamplesRequiredModifiableBasic SearchExt. SearchREL-001Release IDInteger identifier (possiblySITID(VOA)/ESP #YNYYwith part type prefix).(VOE)/Software ID(auto)(req)(req)System generated.(ITC)REL-002Detailed VersionFull release versionCan include the Major4.0.4.00.25691YYYYidentifier. Text field.Version value. This is the(req)(req)same as BOM VAIO's“Developer SoftwareRelease Version” ForExample: Major Version = 1.4,Detailed Version = 1.4.2or 1.4.02.06070.REL-003Release NameConcatenation of “PartFor Example: Sonic StageReporting.Generated: AdobeYNYYName” + “Detailed1.4.02.06070Premiere Standard(auto)(req)(req)Version.” Not user4.0.4.00.25691editable.REL-004TargetList of LangRegions to beRelation.Relation to one orNYNYLangRegionssupported by this release.more LangRegions.(req)(en_US, en_GB, en_int, de_DE,fr_FR, fr_CA,, ja_JP, ko_KR,es_ES, es_lat, it_IT,nl_NL, cns_CN, cnt_TW, pt_PT,el_GR, ru_RU)REL-005Release NotesA log of notes. EachUser can add a note to aFor InformationYYNNnotes can belong to one ofrelease. User specifiesOnly. Reporting.the categories listedcategory of the note atbelow.data entry time andcategories can be used tofilter display.REL-006StatusES/Test, FF,FF (Feature Freeze)/CFSanity checksLookup table:YYYYPilot, CF, RC, GM(Code Freeze) = WHQLduring BOMES/Test, FF,(req)(req)candidate.snapshotting.Pilot, CF, RC, GM.Reporting.REL-007Submitted ByUser who checked-in theReleased By (VOE),Relation to userYNYYrelease.Contact to Developerindex.(req)(req)(ITC)REL-008Next ReleaseText field which specifiesFor Information4.0.4.00.25693A toNYNNnext expected releaseOnly. Reporting.be released in lateversion and date.August 2007.REL-009Virus CheckDropdownFor InformationTBDNYNYOnly. Reporting.(req)REL-010WHQL statusNo submission/underSanity checksLookup table: noNYNYsubmission/passed/notduring BOMsubmission/under(req)applicable.snapshotting.submission/passed/Reporting.not applicable.REL-011PlmStatusDropdownNYNY(req)REL-012Is DefaultYes/NoSnapshotting offlag (0 or 1)NYNYReleaseBOMs.(req)REL-013Is Latest ReleaseYes/NoSnapshotting offlag (0 or 1)NYNYBOMs.(req)REL-014Version PathRegistry or file pathMay be changed as part ofUsed by currentHKEY_LOCAL_MACHINE\YYNN(text).a project globalization ofVOA installationSOFTWARE\installation tools.tools to verifyMicrosoft\Updates\installation of aWindowsmodule.XP\SP3\KB901214\Description\REL-015Version IDVersion of file or reg keyMay be changed as part ofUsed by currentSecurity Update forYYNNvalue(text).a project globalization ofVOA installationWindows XPinstallation tools.tools to verify(KB901214)installation of amodule.REL-016Version checkText field. DescribesFor Information[How to identifyNYNNbeforerequired installer versionOnly. Reporting.this version]installation.for the given release.Before InstallationCheck Version.txtin installerREL-017Version checkText field. DescribesFor Information[How to identifyNYNNafter installation.another method toOnly. Reporting.this version]Aftervalidation installation.InstallationCheck: Version.txtunder C:\ProgramFiles\Sony\SonicStageMasteringStudioincluding2.0.00.18220REL-018Change LogSystem generated history:System generatedwho changed releasehistory: whowhen.changed releasewhen.REL-019Installed FolderText field describing pathSome build tools\\us-sd-itd-san-YNNNPathto installed files.may use this1\swlibrary\isvrelease\field.0518002.SNC\REL-021Installer TypeINF, EXE/BATCH, FILEInstall Property: Definedlookup table: INF,YNYY(select from list)COPYin MajorVersion asEXE/BATCH,(req)(req)defaults, carried over toFILE COPYRelease, can be modifiedat check-in.REL-022Setup FilePath to setup file relativeInstall Property: DefinedUsed by buildSetup.exeYYNNto top level folder ofin MajorVersion astools to find setup(ifrelease. Text Field.defaults, carried over toexecutable.filesRelease, can be modifiednotat check-in.uploaded)REL-023Command LineArguments to be passed toInstall Property: DefinedUsed by build/quiet/passiveNYNNArguments“Setup File”. Text Field.in MajorVersion astools when/norestart -sdefaults, carried over torunning setupRelease, can be modifiedexecutable.at check-in.REL-024OPKYes/No: Set for eachInstall Property: DefinedUsed by buildflag (0 or 1)NYNYEngineering Organizationin MajorVersion astools.(req)defaults, carried over toRelease, can be modifiedat check-in.REL-025Base PlusYes/No: Set for eachInstall Property: DefinedUsed by buildflag (0 or 1)NYNYEngineering Organization.in MajorVersion astools.(req)defaults, carried over toRelease, can be modifiedat check-in.REL-026RecoverableYes/No: Set for eachInstall Property: DefinedUsed by tools.flag (0 or 1)NYYYEngineering Organization.in MajorVersion as(req)(req)defaults, carried over toRelease, can be modifiedat check-in.REL-027InteractiveYes/No: user interactionInstall Property: DefinedUsed by buildflag (0 or 1)NYNYrequired?in MajorVersion astools.(req)defaults, carried over toRelease, can be modifiedat check-in.REL-028RepackagedYes/No: Means releaseInstall PropertyFor Informationflag (0 or 1)NYNYhas been modified fromOnly. Reporting.(req)ISV original release.REL-029Snapshot IDIdentifier of the BOMRelation.For InformationRelation toNNNNsnapshot which was usedOnly. Reporting.Snapshot Indexfor this release(componsite parts only).Dropped. System will useNYNYactive/inactive status(req)instead.


10.4.5.1 Release Notice Categories

CategoryDescriptionBy ChampionBy BuilderOther NotesDescriptionTechnical DescriptionNew FeaturesNotificationE.g. “Same as 2005.2Q”Installation StepsStep by step description of a manual install.Uninstall StepsStep by step description of a manualuninstall process.C26


10.4.6 Groups

AttributeIntendedRe-Mod-BasicExt.IDNameDescriptionCommentsUsageExamplesquiredifiableSearchSearchGRP-001Group NameWindows XP HEYYYOS PartsGRP-002Group IDIndex IDGenerated IndexYNYGRP-003CommentsText field: ThisYYYgroup is for all(keywordWindows XP HEsearch)images builtbetween 2002 and2006.GRP-004Parts ListGroup MembersCan be group, part name,Relation to a listNYY (req)major version, release.of indexes.GRP-005ActiveYes/Noflag (0 or 1)YYY (req)Dropped. TooComplicated.Dropped. TooComplicated.Dropped. TooComplicated.GRP-009TargetOne or more engThis will be part of aLookup Table(s)NYYEngineeringorg, all eng org.“Define Target Criteria”Organizationfunction used throughoutthe system.GRP-010Target SeriesList of one or moreIRX-3370,NYYseries for which thisATX-7100group can only beused.GRP-011Target OSSelect a single OSThis will be part of aFor filtering,Lookup TableNYYor “All”. Default to“Define Target Criteria”reporting.all.function used throughoutPossiblythe system.used forsanity checks.GRP-012TargetOne or moreUsed toLookup TableNYYLangRegionsLangRegions.select thecorrect releasefor BOMsnapshots.GRP-013UsageIntended usage forFor filteringText field:NYYthe group.andThis grouporganizingis for allgroups.WindowsXP HEimages builtbetween 2002and 2006,but only onTuesdays.


10.4.7 Snapshots (BOMS)

AttributeRe-Mod-BasicExt.IDNameDescriptionCommentsIntended UsageExamplesquiredifiableSearchSearchSNP-001BOM IDIndex field auto-Index field auto-YNNYgenerated.generated.SNP-002DescriptionName & Revision(Series/FI/RDVD/Horizon 3-HEYYNY(IE: Horizon 3-HEMonolithic/Module/Build01Build01)Factory Media)SNP-003Time andAuto-GeneratedAuto-Generated:DateAug. 21, 2006StampPSTSNP-004ParentID of Series, Image,RelationRelation to IndexYNYYPart IDmodule, etc.of Parent part orGroup.SNP-005Child PartAll part releases onRelationRelation to a lisstYNY (returnYRelease Idsthe BOM.of Releaselist ofIndexes.snapswithmathcingchild)SNP-006CTO TypeRequired/Optional/HWRelationLookup TableYYNYDependentRequired/Optional/HW Dependent


10.4.8 Defect Attributes

Re-Modi-BasicExt.IDAttribute NameDescriptionCommentsIntended UsageExamplesquiredfiableSearchSearchDEF-001Defect IDAuto generatedYNYYsequence.DEF-002Defect StatusOpen/ClosedDefects can only beYYYYclosed if “DefectResolution is Fix-verified,Will Not Fix, Deferred,Duplicate, orWithdrawn.”DEF-004Defect ResolutionFixed, Fix-verified,Dropdown. Should be aYYYYWill Not Fix,configurable item.Deferred,Duplicate,Withdrawn.DEF-005ResponsibleCan be one orNYYYpersons.more users or ateam.DEF-006PriorityMust Fix, ShouldDropdown.NYYYFix, Optional Fix,NoneDEF-007Summary (DefectText field.YYYYTitle)DEF-008DescriptionText area.YYYYDEF-009FrequencyOnce, Always,Dropdown.NYNYSometimesDEF-010Frequency StatisticsX out of YThis can be entered ifFor use inNYNN“Frequency” isstatistical“Sometimes.” User cananalysis.enter multiple “X of Y”sets for each defect.DEF-011NotesText areaNYNYDEF-012Related Test CasesAssociation withThis cannot be a requiredNYNYone or more testattribute because defectscases.can be logged withoutassociated test cases.DEF-013Steps to reproduce.Can be copiedText area.YYNYfrom related testcases (attributeTST-010) andedited.DEF-014Expected ResultsCan be copiedText area.YYNYfrom related testcases (attributeTST-011) andedited.DEF-015WorkaroundText area.NYNYDEF-016SeverityValues:Dropdown. Should be aNYYY0-Noneconfigurable item - admin1screen not required.23DEF-017ExposureValues:Dropdown. Should be aNYYY1-LI (Legalconfigurable item -Implications)admin screen not2-HVCGrequired.(High VolumeCallGenerator)3-LNFU(Likely toNotice withFrequent Use)4-LIDB(Likely toIgnoreDefectiveBehavior)5-VUS (VeryUnlikely willSee)DEF-018Assigned to (parts)List of one or moreYYYYengineeringpart/majorversions, releases,HW parts, or userdefined partsassociated with thedefect. Should beauto-populated ifsubmitting from afailed test case.DEF-019Defect SubmitterYNNYDEF-020Submit DateYNNYDEF-021Close DateNYNYDEF-022AttachmentsNYNNDEF-023Sustaining statusNYNYDEF-024Sustaining PriorityNYNYDEF-025Microsoft Defect IDNYNYDEF-026Beta IDNYNYDEF-027LangRegionOne or moreYYYYLangRegion's towhich the defectapplies. User canalso select All“LangRegions.”DEF-028Target SeriesThe series forYYNYwhich the defectwas firstdiscovered.DEF-029Applicable SeriesList of all otherThis could be a systemNYNYseries for which amaintainable attributedefect wasbased on part information.discovered.


10.4.9 Test Case/Strategy Attributes

IntendedRe-BasicExt.IDAttribute NameDescriptionCommentsUsageExamplesquiredModifiableSearchSearchTST-001Test Case IDAuto-generatedYNYYsequence.TST-002Test CaseBasic, Ad-hoc, UseDrop-down.YNYYType/CategoryCase, Compatibility,For Benchmarks andFIV, Benchmarks,MDA categories: key,MDA, Screen Shotvalue, and expectedCapture, Business Unit,value can be entered.Accessory, and Other.For Screen ShotCapture category a.jpg or .bmp imagefile can be attached.TST-003Test ResultsPass/Fail/NotDefaults to “NotYYYYTested/Impeded storedTested.”by series, releasecombo.TST-004Part/Major VersionOne or more part/majorNYNYversions to which thetest case is constrained.TST-005SeriesOne or more series toNYNYwhich the Test Case isconstrained.TST-006Test AreaAudio, Video, StillDropdown. ShouldYYNYPicture, Productivity,be a configurable itemEtc.via admin screen.TST-007PurposeText area.YYNYTST-008RequirementsText area.NYNNTST-009Initial ConditionsText field/Dropdown.NYNNTST-010StepsText area.YYNNTST-011Expected ResultsText area.YYNNTST-012NotesText area.NYNYTST-013StatusActive, Obsolete, Etc.Dropdown. Should beYYYYa configurable itemvia admin screen.TST-014Level1 - Always Run,DropdownYYYY2 - Sometimes Run,3 - RandomSampling/Sanity CheckTST-015Time to ExecuteUser estimate of timeYYNYrequired to complete thetest. Integer (inminutes).TST-016SubmitterAuto - user who createsYNNYtest case.TST-017Related LinksOne or more hyperlinks.NYNNCan be a text field butsystem should interpretvalues as hyperlinks.TST-018Last UpdatedAutoYYNYTST-019Excluded SeriesOne or more seriesNYNYwhich are excluded fromthis test case.TST-020Submit DateDate user created testYNNYcase.


11 Production Rollout Plan


11.4 Deployment Locations


Now referencing FIG. 23, a non-limiting production rollout plan is shown.


As a global system, More than six places are involved in ePic network:

    • Tokyo
    • Vagana
    • Shanghai
    • Czech
    • Brussels
    • San Diego
    • Other three factories in China


Engineers and factories are in these places:

    • Engineer: San Diego, Brussels, Shanghai, Tokyo
    • Factory: San Diego, Czech, Nagano, Other three factories in China


Network Deployment Diagram

11.5 Phased Rollout


EPic will be rolled out in two phases.


11.5.1 Phase I Release


Phase 1 Requirements will include the following ePic functionality:

    • Parts Registration
    • Image and Module BOM Creation
    • Build System Interface
    • Series Software BOM Creation
    • DB Hero Interface
    • File Store


This release includes full support for image and module building and series software BOM creation. This is essentially the ePic “kernel.”


11.5.2 Phase 2 Release


Phase 2 Requirements will include the following ePic functionality:

    • Test Management
    • Defect Tracking
    • Release to Manufacturing
    • Installation and Recovery Tool Support
    • VALSUN Interface
    • Mini-ePic


This release adds factory deployment, quality assurance, and customer recovery functionality to the ePic system.


11.5.3 Sony Software Development Activities


VOA tools will be adapted to become the global recovery and installation tools. The release date for these new tools will be timed to coincide with the phase 2 release.


Build system modifications must be completed by VOA, VOE, and SDNA in order to build images and modules with ePic.


Plans for implementing and testing changes to build systems must be made with the following milestones in mind:

    • All required ePic system functionality will be implemented in the phase 1 release.
    • A warranty period will be in effect for a TBD period from date of the phase 2 release. After this, changes will be more costly.


      12 Changes to Legacy Systems


      12.1 Summary


      12.1.1 VBD


Current Tools and Systems

    • BOM VAIO—SDNA build system.
    • VELSUN/VALSUN—Defect tracking systems.


Changes to Tools & Systems

    • BOM VAIO will be replaced with VOA's ABU/Magellan.
    • VELSUN/VALSUN—transfer of defects from ePic to VELSUN/VALSUN must be established.


      12.1.2 VOE


Current Tools and Systems

    • EIS—VOE Project and Software Management System.
    • Tracker—Image Building and Tracking System.


Changes to Tools & Systems

    • ePic will not support VOE build system since images will no longer be developed at VOE.


      12.1.3 VOA
    • SW Plan—excel file defining the software BOM.
    • VSMS—the “VAIO Software Management System.”
    • ABU/Magellan—automated image building tools.
    • Oasis—MCode tool used to support testing.
    • MINDS—automated installation system used by testers.
    • Pacific—tools used to install software in the factory.
    • Recovery Tools—use a localized version of the SDNA GREEN engine.


Changes to Tools & Systems

    • The SW Plan excel file will no longer be used. The data contained therein will be maintained in DB Hero.
    • VSMS, Oasis, and MINDS will be replaced with ePic.
    • ABU/Magellan will be made to interface with the ePic.
    • VOA installation and recovery tools will be modified to become the global toolset.
    • OASIS must be modified to create a floppy based on a single direct HTTP request.


      12.2 Build System Changes


Three regional build tool implementations must be modified to work with ePic. Objects created by each regional build system may change to comply with the global modular and recovery specifications, which are to be defined as part of this project.


This section lists current build system artifacts from each region's build system and mappings to ePic fields. The ePic fields listed below are detailed in Section 10.4 of this document. Note that in some cases the format and meaning of the attribute may have changed from the current state. For example, Software Release ID (formerly ESP #, SITID, etc.) will now be an integer with a prefix denoting part type (this will necessitate changes to all three build systems).


Architectural note:






    • Build process should not be interrupted by WAN outages.

    • Caching build data can shield you from WAN outage:
      • Option 1: Build tools interface directly with ePic; caching mechanism can be built into build tools.
      • Option 2: Existing SW system (EIS, BOM VAIO, VSMS) can be used to cache ePic data (possibly lessening impact to build tools).


        [VOA has chosen to build a caching mechanism into its build system.]


        12.2.1 VOA-E Build Tools


        12.2.1.1 Build Tools Overview





Build Tools create the following objects:

    • Foundation Image
    • Base Plus Image
    • Monolithic Image
    • P1 Recovery Image
    • Module, X-Module, EPC
    • Factory Deployment Media (RDVD, PIDVD, BDVD)
    • PAC Files
    • P1 Recovery Image
    • PE Module
    • Data file


Database information required includes: Project Info, BOM Info, Component Info (location on server etc).


Files required by Build tools include: OS files, Component Installers (drivers, apps) Output files created by Magellan for use by Automated Build Utility (ABU), Chrysalis recovery tools and others are discussed in the next sections.


12.2.1.2 Files Required by Automated Build Utility (ABU) to Create Foundation and Base-Plus Images.


Script.INI: Contains all items on Image BOM with BasePlus set to FALSE.


BScript.INI: Contains all items on Image BOM with BasePlus set to TRUE and IntegrationMethod is not OPK.


OPKScript.INI: Contains all items on Image BOM with BasePlus set to TRUE and IntegrationMethod is OPK.

VSMS Fields used toCorresponding ePic fieldscreate above 3 files.(refer ePic-Attribs_20050808.xls).Project name: used for querying andEP-001to create folder on network to storethese files.Build name: used for querying and toREL-003create folder on network tostore these files.BasePlus: check OPK integrationREL-025method only for Base Plus.IntegrationMethod: used by tools &EP-005, EP-006, REL-021check for OPK items.Silent: Don't use IntegrationMethodEP-038, REL-027if not Silent.BiosLockNo: uniquely identifiesEP-012image.ReleaseNameREL-003SitidREL-001NetPathREL-020 or Mini ePic partSwitchesREL-023InstallInstructionsREL-Installation stepsBuildInfoREL-By BuilderVersionPathREL-014VersionIDREL-015


12.2.1.3 Files Required to Automate Module Creation.


MScript.INI: Contains all items on Module BOM.


VSMS Fields used: Same as above.


12.2.1.4 Files Required by Chrysalis Recovery Tools.


SonyPac.cmd


Is a batch file that creates the structure of one or more PAC files by copying the software releases (that make up the PAC file) from the network to a folder on the local machine. Each folder corresponds to a PAC file. The builder then runs the Pack tool to create a PAC file from the contents of each folder. It is required to create more than one PAC file as one PAC file may not fit on one disc. It contains all items on Image BOM with IsSingleApplicationRecovery is TRUE.

VSMS Fields used:Corresponding ePic fields.ProjectName: used for querying, notEP-001contained in the file.Build: used for querying, not containedREL-003in the file.SITID: to create folder on local machine.REL-001IsSingleApplicationRecovery: used forREL-026querying, not contained in the file.SITInstallProgram: Location on file server.REL-020/Mini ePicPac_File: this value is set in VSMS prior toObsolete in ePic. Move thecreating this file by calculating (accordingPac file assignmentto size) which PAC file this softwarefunctionality to Magellangoes on.(dynamically assign insteadof storing in database).


Appinfo.ini: Contains all applications and drivers that go on the Foundation Image and are available for recovery through Chrysalis (Single Application Recovery).

CorrespondingVSMS Fields used:ePic fields.Project name: used to create folder on network to storeEP-001these files.Build name: used to create folder on network to storeREL-003these files.ARCDFolder: used to distinguish Drivers fromEP-005, 006Applications.ARCDTitle: used as display title for Applications.EP-010IntegrationMethod: should be OPK-Driver for drivers.EP-006Used for querying.ReleaseName: used as display title for Drivers.REL-003ARCDSpec: text description (hover text).EP-011SITInstallProgram: installer file.REL-020, 022/Mini ePicSITID: used for unpacking.REL-001IsSingleApplicationRecovery: determine if compressed.REL-026Pac_File: used to determine correct PAC file.Obsolete;generated byexternal tooldynamically.InstallOrder: used to install in a given sequence.EP-009Prompts:


12.2.1.5 Files Required for BDVD


AllModules.TXT: Contains all modules and EPCs on a base unit.

VSMS Fields used:Corresponding ePic fields.ProjectName: used for querying,EP-001not contained in the file.ReleaseNameREL-003InstallerREL-020, 21, 22


12.2.1.6 Files Required for Media Creation


perm modules.cmd: Contains all permanent modules and EPCs for base unit (IsPermanent is TRUE).


temp modules.cmd: Contains all temporary modules and EPCs for base unit (IsPermanent is FALSE).

VSMS Fields used:Corresponding ePic fields.ProjectName: used for querying,EP-001not contained in the file.isPermanentEP-025(reverse logic)ReleaseNameREL-003InstallerREL-020, 21, 22SitidREL-001


12.2.1.7 Files Required by MINDS/Pacific


MINDS.CSV

VSMS Fields used:Corresponding ePic fields.PcodeSeries attributes TBDBLIDEP-012PhaseREL-003SetupREL-022VersionIDREL-015SwmcodeTBDVersionREL-002SITIDREL-001Release NameREL-003BaseUnitSeries attributes TBDTypeEP-005, 006


12.2.1.8 Files Required by Japan


BaseUnitInfo.INI: Contains all base units for a project.

VSMS Fields used:Corresponding ePic fields.BaseUnitSeries attributes TBDBaseUnitIDSalesTypeModelNo_JPOSProduct McodeC-Partition SizeP1 Partition Size


12.2.1.9 Other Functionality


Build tools also check in software releases and images and thus need to be able to have a method of writing release data to the database.


13 Appendix


13.4 Terminology

BusinessrelatedCTOGeneralConfigure To OrderProduce (configure) a product after taking theorder.BTOGeneralBuild To OrderRetail sales,GeneralSelling product through normal shop channel.Direct sales, Online salesGeneralSelling product through internet (Web).B2BGeneralBusiness To BusinessSelling product to corporate customer directlyfrom Sony.B2CGeneralBusiness To ConsumerSMBGeneralSmall BusinessSmall company like 50 employees.EnterpriseGeneralEnterpriseBig company.SOHOGeneralSmall Office HomeVery small company like 0 to 3 employees.OfficeUse home as office.Product DesignactivityBOMGeneralBill Of MaterialList of parts (materials) to produce a product.SW BOMGeneralSoftware Bill OfMaterialESEngineering SampleFFFeature FreezePilot BuildPilot BuildTest BuildRCGeneralRelease CandidateGMGeneralGolden MasterFinal and approved master software file.RTMRelease toManufacturingDVTSonyDesign Validation THardware prototype for design validation.PVTSonyProduction Validation THardware prototype for productionvalidation, almost final product.MPMass ProductionReal product production, not sample, notprototype.Ex factoryFirst shipping out of the mass productionproduct.SKUGeneralStock Keeping UnitBuildCombine many software pieces to makesingle big image file to be copied onto HardDisk Drive of target PC.Image build, build imageCombine many software pieces to makesingle big image file to be copied onto HardDisk Drive of target PC.IntegrationCombine many software pieces to makesingle big image file to be copied onto HardDisk Drive of target PC.Software IntegrationCombine many software pieces to makesingle big image file to be copied onto HardDisk Drive of target PC.PreinstallInstall application onto a product so thatcustomer doesn't have to install the softwarehimself.RecoveryMicrosoftWhen a customer wants to go back to factorystate, “Recovery” to be done.Hard Disk RecoveryMicrosoftExternal Recovery MediaMicrosoftRecovery CD, Recovery DVDMicrosoftBIOS Lock ID, BLIDSonyM-CodeSonyBIOSPCDMIPCRegistryMicrosoftOPKMicrosoftOEM Pre-installation KitOOBEMicrosoftOut Of Box ExperienceWindows Setup screens at very first power-on.Serial numberGeneralService TagPCOSRITCOS Recovery or SystemRecover the image file.RecoveryAPRITCApplication RecoveryRecover (install) application(s).SAR (ITE)ITESmart ApplicationSame meaning as “APR” in SDNA.RecoveryVSRUITCVAIO System RecoveryUtility name. Recover the image file, usingUtilityGreen Engine.VARUITCVAIO ApplicationUtility nameRecovery UtilityWiseGeneralwww.wise.comSoftware name to make a package.Install ShieldGeneralwww.installshield.comSoftware name to make an installer.F.I.VOAFoundation ImageMINDSVOAModule Installation . . .VSMSVOAVAIO Software Management SystemABUVOAAutomatic Build UtilityEISITEEngineering InformationSystemTrackerITEBomVAIOITCBugVAIOITCValsanITCIRT serverITCLibrarianVOAImage planning.Build ArchitectITEImage planning.BuilderITCImage planning.PMProject ManagerMulti Language SKUITEDB HeroterminologySeriesVBDA product platform. For example,“Horizon.”ClassVBDA concept representing a set of customerchoices. For example “Hard Drive” (choicesmight be “100 GB”, “200 GB”, or “250 GB”).SpecVBDRepresents a single customer choice.Config RangeVBDThe set of classes that constitute the full(global) range of customer choices for agiven series. Can be used by a sales systemto provide CTO offerings to customers.ComponentVBDPhantom BOM item. Derived from Configrange during DB Hero block definitionprocess.Component StructureVBDList of components for a given structure withparts as children. This is considered the“manufacturing BOM.”FactoryterminologyPCNProduction ChangeChange form used to disclose any non-BOMNoticerelated changes to the factory.ECNEngineering ChangeChange form used to disclose BOM changesNoticeto the factory.EPCVOE/VOAEngineering ProcessRunning change to software. Consists ofChangechange notification and a correspondingsoftware module.Factory ProcessGeneric term used to refer to all activitiesperformed in the factory in order to produceunits.ERPEnterprise resourceGeneric term for inventory, planning, andplannerorder management systems used in support ofmanufacturing or order fulfillment. Oracle,SAP, JD Edwards, etc.Configuration BOMVOAThe bill of materials for a specific PCconfiguration.Platform BOMVOAA bill of materials which encapsulates CTOcustomer choices (like the DB Hero Configrange).Phantom BOMVOAA bill of materials representing themanufacturing BOM for a series (like DBHero component structure). Phantom BOMitems can be included as customer choices onthe platform BOM.SMAPSimple ManufacturingUnit testing framework used to drive theAdvanced Processautomated factory process in Sony VAIOfactories. Imaging in the factory occurs as aSMAP process step.Sony Terminology:DepartmentnameVBD or ITCVAIO Business DivisionTokyo GroupFormerlycalled ITC.VOA or ITDVAIO of AmericaAmerica Group, SanFormerlyDiegocalled ITD orITA.VOE or ITEVAIO of EuropeEurope Group,FormerlyBrusselscalled ITE.STCSony Shanghai Tec CenterSNTSony Nagano Factory200 km from TokyoIT-MSony San DiegoManufacturing divisionSVLTaiwan Exteranl LaboODMChina ManufacturingSony Digital NetworkSDNAApplications Inc.,Tokyo GroupFormerly apart of ITC.OthersSENSony Enterprise NetworkSony Corporate Network (intranet).Firewalled.


13.5 Current Process Flows


13.5.1 VOA & IT-M


13.5.1.1 Planning


Below is sequence of how VOA SW planning occurs currently:

    • Explore new ISV business opportunities [VOA-Product Planning & VOA-PM] [Ongoing, but not necessary need to be tracked in DB].
    • Create 1st draft of SW Planning Strategy in ppt by VOA-E PM (N-17).
      • SW Strategy consists of:
        • No platform or project information yet.
        • 80% of Sony software titles leveraged from previous cycle (including utilities & Sony software, but no drivers).
        • Sony Utilities are not updated at this point (No visibility until engineering meeting).
        • Some Sony Software is updated at this point (Info is through grapevine, and not firm until engineering meeting).
        • SW Planning strategy or planning BOMs do not reflect drivers.
        • 20% of ISV software (mostly leverage from previous cycle).
        • Any ISV addition here are 75% firm.
      • Software is also added or remove from SW CTO configuration strategies chart.
        • Grouping of multiple modules to define an offering strategy starts here. Also defines offering rules.
      • Project code names at this point only, no detailed base units names or configuration on PPT.
    • Review 1st draft of SW Planning Strategy in ppt with VOA-PP & ITPD (N-16).
      • Gather questions & consensus prior to Engineering meeting.
        • Make necessary SW plan or offering strategy adjustment up to engineering meeting.
      • Usually not much change here, mostly just to keep ITPD in sync with upcoming strategy.
      • 95% of ISV software are fixed.
    • Present 2nd draft of SW Planning Strategy in ppt @ Engineering meeting in Japan (N-15).
      • 2rd draft includes & updates from PP & ITPD meeting from above.
      • Below is what occurs during engineering meeting:
        • Gather updates & add new Sony Utilities (Utilities strategy are fixed & owned by ITC per platform).
        • Gather updates & add new Sony Software (Sony SW strategies are mostly fixed and owned by ITC per platform. Occassionally, each region are given a choice on certain software pending lead time or if conflicts with local ISV SW strategy.
        • Versions of the above are gathered and updated to SW Strategy ppt (Build revisions are not reflected in SW Strategies or SW planning BOM since they are fixed during integration stage, only reflected in VSMS).
        • ISV Software are presented to ITC (purely to inform them of local strategies).
    • Create 3rd draft of SW Planning Strategy (still in ppt format) (N-14).
      • 3rd draft of the ppt includes updates from engineering meeting.
        • Platform is reflected only if certain software are assigned to specific SKUs.
      • Review 3rd draft with ITPD and VOA-PP to share information from engineering meeting.
    • Review with internal groups (SIT & PQD) by N-13.
      • SW Planning strategy ppt should be fixed.
      • SIT starts to prepare BOM layout in VSMS with SKU & HW config charts.
    • From N-13 to RTM.
      • VOA-PM turns the ppt into SW Planning BOM (in xls format) & adds platform & base units.
        • SW Plan reflects how SW are associated in VSMS to each base units.
        • Either as modules or in foundation image.
        • If in modules, it also reflects if it should be Require “R”, Default “D”, or Optional “O” per base unit.
        • Changes throughout the cycle occurs first in xls & announced to SIT & PQD (VOA-PP & ITPD as well) every Thursday.
        • SW Plan is also used during BOM Freeze (Milestone) to verify that modules assigned in VSMS are all accounted for in both plan & BOM (per base units with each particular projects's BOM Freeze).
        • SW Plan will also be used by ITM royalty reporting group after project RTMs.
        • SW Plan is not used by marketing spec sheet generation, instead a VSMS base unit BOM is used (base unit BOM includes every software, including drivers).
    • Future objectives
      • Elimination of SW planning BOM.
        • Go straight from Strategy ppt to VSMS.
        • Updates should occur in VSMS and populated to projects.
      • Royalty information be assigned according to base units/platform or SW module (Not necessary at planning stage, but need it by RTM).


        13.5.1.2 Software Integration



FIG. 23A shows a non-limiting software integration process:


13.5.1.3 Factory Deployment Process


In reference to FIG. 24, the process flow captures a process for deploying CTO software in the factory.


Many of the activities depicted in FIG. 24 are manual, with some small helper applications in use to speed up the work. Some of these activities are executed in parallel with the software integration process.


13.5.2 VOE


13.5.2.1 Software Integration






    • Engineers enter ESP numbers from software plan into EIS via UI.

    • EIS provides a build script via UI.

    • Builder supplies script to build system.

    • Build system builds item.

    • Tracker provides BIOS lock number, image number, and other data to build system.


      13.5.3 VBD


      13.5.3.1 Software Integration (SDNA)

    • BOM VAIO is standalone database system.

    • Build tools retrieve build data via database link to BOM VAIO.


      13.6 Sample Reports


      13.6.1 RPT-1: Series Report


      13.6.2 RPT-2: Series BOM Report


      13.6.3 RPT-3: Series Metadata Report


      13.6.4 RPT-4





None. Number skipped.


13.6.5 RPT-5: BOM Report


13.6.6 RPT-6: Module Release Report

MOD-Premiere Pro Build07BOM Info:Software TitleIndex IDVersionDefect OwnerRecoverableAdobe, Multimedia,0411303.ADB1.0.00.0404220Smith 1NoPremiere Delete DVDBurnAdobe, Multimedia,0419801.ADB1.5.0.0Smith 2YesPremiere ProSony ITC, Multimedia,0504604.SNC5.0.01.14040Smith 2YesVAIO Edit ComponentsAdobe, Marketing Material,0407101.ADB1.1.00.0403110Smith 1YesPremiere Pro SerNum andReadmeSony ITD, Build Image Tool,0504903.SND5.0.1Smith 3NoMCODE ReaderSony ITD, Tools, MN.DLL0306502.SND1.2.1Smith 3No



embedded image
embedded image


Series BOM Associations

RegisteredSeries NameStatusByRegistry DateHogwarts4-MCShippingSmith 42005/02/20Hogwarts4_Chrysalis3_TestIn progressSmith 52005/06/07Horizon2-HEShippingSmith 42005/02/20Horizon2-MCShippingSmith 52005/04/19Horizon2-PRShippingSmith 42005/02/20Horizon3_GD-HEShippingSmith 52005/06/09Horizon3_GD-MCShippingSmith 52005/06/09Horizon3_GD-PRShippingSmith 52005/06/09Jennys_module_test_projectIn progressSmith 42005/02/20LeonS2-HEShippingSmith 42005/02/20LeonS2-PRShippingSmith 42005/02/20LeonS2_Multi-recovery_testShippingSmith 52005/02/24LeonV-HEShippingSmith 52005/06/29LeonV-PRShippingSmith 52005/06/29Messenger-HEIn progressSmith 52005/10/14Messenger-PRIn progressSmith 52005/10/14Sherry_WWAN-PRIn progressSmith 42005/10/05Spirit2-HEShippingSmith 42005/02/20Spirit2-PRShippingSmith 42005/02/20Spirit3-HEShippingSmith 52005/06/15Spirit3-PRShippingSmith 52005/06/15


Attachments


13.6.7 RPT-7: Group Report


13.6.8 RPT-8: Image BOM Report


13.6.9 RPT-9: BOM Freeze Report


FI-Inazma-PR (Build03) Image BOM Report

VCC DescriptionsVendorComponentRelease NameHover TextAdobeProductivityAdobe Reader<ENG> Document viewer: View, navigate, and print PDFand E-Book format documents. </ENG><FRA> Visionneuse de document: La vue, dirigent, etimpriment des documents de format de PDF et E-Book </FRA> <ESN> Espectador del documento: La vision,navega, e imprime documentos del formato del PDF y del E-Book. </ESN>AlpsDriver-MouseTouchpadTouchpad DriverGoogleCommunicationGoogle Toolbar<ENG> Maximizes your web searchingexperience. </ENG> <FRA> Facilite vos recherches surinternet. </FRA> <ESN> Maximiza su tela que buscaexperiencia. </ESN>IntelDriver-SystemIntelIntel 915GM/PM/GMS 910GML Alviso Driver915GM_PM_GMS_910GMLAlvisoMacromediaMultimediaFlash Player<ENG> Play back videos and audio generated inFlash. </ENG> <FRA> Lecture de videos et de fichiers audiocrees avec Flash </FRA> <ESN> Juegue los videos traseros,audio generado en flash. </ESN>Sony ITCSystem ToolBattery Check Utility<ENG> Manage your notebook powersettings. </ENG> <FRA> Gerez les parametresd'alimentation de votre ordinateurportable. </FRA> <ESN> Maneje sus ajustes de energia delcuaderno. </ESN>Sony ITCShared LibraryImageStation Library<ENG> A program utility facilitating ImageStationaccess. </ENG> <FRA> Un utilitaire facilitant l'acces aImageStation. </FRA> <ESN> Una utilidad del programaque facilita el acceso de ImageStation. </ESN>Sony ITCSystem ToolMemory Stick Pro Formatter<ENG> A program utility for formatting a MemoryStick. </ENG> <FRA> Un utilitaire permettant de formaterun Memory Stick. </FRA> <ESN> Una utilidad delprograma para ajustar a formato un Memory Stick. </ESN>Sony ITCMultimediaOpenMG Setup<ENG> A program utility required byOpenMG. </ENG> <FRA> Un utilitaire indispensable aOpenMG. </FRA> <ESN> Una utilidad del programarequerida por OpenMG. </ESN>Sony ITCSystem ToolSetting Utility Series<ENG> A program for customizing your utility seriessettings. </ENG> <FRA> Un programme pour personnaliserles parametres de vos utlitaires. </FRA> <ESN> Unprograma para modificar sus ajustes para uso general de laserie para requisitos particulares. </ESN>Sony ITCShared LibrarySony Shared Library<ENG> A program utility required for Sonyapplications. </ENG> <FRA> Un utilitaire pour lesapplications Sony. </FRA> <ESN> Una utilidad delprograma para los usos de Sony. </ESN>Sony ITCShared LibrarySony Video Shared Library<ENG> A program utility required for video editingapplications. </ENG> <FRA> Un utilitaire indispensablepour les applications d'edition video. </FRA> <ESN> Unautilidad del programa requerida para el video que corrigeusos. </ESN>Sony ITCShared LibrarySonyUtils<ENG> A program utility required for VAIO


FI-Inazma-PR (Build03) Image BOM Report

VCC DescriptionsVendorComponentRelease NameHover Textapplications. </ENG> <FRA> Un utilitaire indispensablepour les applications VAIO. </FRA> <ESN> Una utilidad delprograma requerida para los usos de VAIO. </ESN>Sony ITCMultimediaVAIO Entertainment<ENG> A utility program that installs the VAIOPlatformEntertainment Platform. </ENG> <FRA> Un utilitairepermettant d'installer la Plateforme VAIOEntertainment. </FRA> <ESN> Un programa utilitario queinstala la VAIO Entertainment Platform. </ESN>Sony ITCSystem ToolVAIO Event Service<ENG> A program utility to control specific applications inyour VAIO computer. </ENG> <FRA> Un utilitaire pourcontroler les applications specifiques de votre ordinateur deVAIO. </FRA> <ESN> Usos especificos de un tocontrolpara uso general del programa en su computadora deVAIO. </ESN>Sony ITCSystem ToolVAIO Power Management<ENG> Manage your notebook powersettings. </ENG> <FRA> Gerez les parametresd'alimentation de votre ordinateurportable. </FRA> <ESN> Maneje sus ajustes de energia delcuaderno. </ESN>Sony ITCSystem ToolVAIO Update<ENG> Get notifications of the latest driver and news relatedto your VAIO computer. </ENG> <FRA> Recevez lesnotifications vous informant des pilotes les plus recents ainsique les dernieres nouvelles concernant votre ordinateur deVAIO. </FRA> <ESN> Consiga las notificaciones delconductor y de las noticias mas ultimos relacionados con sucomputadora de VAIO. </ESN>Sony ITDDocumentationLatest Information<ENG> Latest Information. </ENG> <FRA> La Plusdefunte Information </FRA> <ESN> La Informacion Masultima </ESN>Sony ITDDocumentationRecovery Guide<ENG> VAIO Recovery Guide. </ENG> <FRA> GuideDe Reinstallation </FRA> <ESN> Guia De laRecuperacion </ESN>Sony ITDToolsVAIO Drivers<ENG> VAIO Drivers installs the VAIO drivers to theiroriginal shipping condition. </ENG> <FRA> VAIO Driversinstalle les conducteurs de VAIO sur leur condition d'expeditionoriginale. </FRA> <ESN> VAIO Drivers instala losconductores de VAIO a su condicion de enviooriginal. </ESN>Sony ITDDocumentationVAIO User Manual<ENG> VAIO User Guide is a program that opens usermanuals on your VAIO computer. </ENG> <FRA> VAIOManuel D'Utilisateur </FRA> <ESN> Guia de Usuario deVAIO </ESN>SunWindowsJava 2 Runtime Environment<ENG> Installs the Sun MicroSystems Java 2 RuntimeMicrosystemsEnvironment. </ENG> <FRA> Installe l'environnementd'execution de Java 2 de Sun MicroSystems. </FRA><ESN> Instala el ambiente del tiempo de pasada de Java 2 delos Sun MicroSystems. </ESN>VeritasProductivityPxEngine<ENG> PxEngine is a shared dynamic link library for opticaldevice burning. </ENG> <FRA> PxEngine est unebibliotheque de lien dynamique partagee pour la brulure decircuit optique. </FRA> <ESN>PxEngine es una bibliotecade acoplamiento dinamica compartida para quemarse deldispositivo optico. </ESN>















FI-Inazma-PR (Build03) BOM Details





















Re-



Com-





cov-


Vendor
ponent
Release Name
Champion
SITID
Version
IRT ID
ery










Reference














Sony ITC
Reference
Boot Option Setting
Smith 7
0429908.snc
041017
SP-008333-01
False




Request


Sony ITC
Reference
HQ Filter setting
Smith 6
0504901.SNC
1.5.02180
SP-009406-00
False




request


Spirit 2


Sony ITC
Reference
Power Options Setting
Smith 6
0517803.SNC
050627
SP-010128-00
False




Requests


Sony ITC
Reference
Volume Control
Smith 6
0503821.SNC
050201
SP-009178-00
False




Settings


Sony ITD
Reference
FI Spec
Smith 8
0509604.SND
3.0.4

False


Sony ITD
Reference
HW Build Document
Smith 9
0521508.SND
Inazma-PR

False







Build v1.5


Sony ITD
Reference
SCR Specification
Smith 10
0507409.SND
1.1.00.0503150

False




Document


English







Operating


System














Microsoft
Windows
CDCR patch for
Smith 5
0320501.mst
1.0.0.0

False




Media Player


Microsoft
Windows
KB307154
Smith 5
0428804.MST
English
SP-008374-00
False




LowBatteryAlarm




QFE


Microsoft
Windows
KB835221 HD Audio
Smith 5
0503804.MST
1.0-200408180
SP-008559-00
False




QFE


English


Microsoft
Windows
KB870669 Critical
Smith 5
0420516.mst
multilingual

False




Desktop Update for




MDAC


Microsoft
Windows
KB873333 Security
Smith 5
0504104.mst
English 1.0-
SP-009238-00
False




Update MS05-012


200502090


Microsoft
Windows
KB873339-Security
Smith 5
0515914.MST
English 1.0-
SP-009052-00
False




Update MS04-043


200412150


Microsoft
Windows
KB883939-
Smith 5
0517207.MST
English 1.0-
SP-010023.00
False




Cumulative Security


200506200




Update for IE


Microsoft
Windows
KB884018-Add and
Smith 5
0422501.MST
English

False




Remove programs




copy error


Microsoft
Windows
KB884575
Smith 5
0428801.MST
English
SP-008390.00
False




BatteryPowerDrain




QFE


Microsoft
Windows
KB885250 Security
Smith 5
0504101.MST
English 1.0-
SP-009229-00
False




Update MS05-011


200502090


Microsoft
Windows
KB885835 Security
Smith 5
0503813.MST
KB885835

False




Update MS04-044


English


Microsoft
Windows
KB885836 Security
Smith 5
0503807.mst
KB8885836
SP-009043-00
False




Update MS04-041


English


Microsoft
Windows
KB886185 Security
Smith 5
0503801.MST
KB886185
SP-009089-00
False




Update


English


Microsoft
Windows
KB886612 Memory
Smith 5
0427201.mst
english

False




Stick Icon Fix


Microsoft
Windows
KB886903 Security
Smith 5
0513204.mst
KB886903

False




Update MS05-004


Generic


Microsoft
Windows
KB887472 Security
Smith 5
0504516.mst
English 1.0-
SP-009312-00
False




Update MS05-009


200502090


Microsoft
Windows
KB887742
Smith 5
0503810.MST
KB887742

False




WLanBlueScreenQFE


English


Microsoft
Windows
KB888113 Security
Smith 5
0504507.mst
English 1.0-
SP-009318-00
False




Update MS05-015


200502090


Microsoft
Windows
KB888239 MP10_MS
Smith 5
0434401.MST
English

False




OOBE splash screen


KB888239




fix


Microsoft
Windows
KB888302 Security
Smith 5
0504510.MST
English 1.0-
SP-009330-00
False




Update MS05-007


200502090


Microsoft
Windows
KB890046-Security
Smith 5
0517201.MST
English 1.0-
SP-010076-00
False




Update MS05-032


200506200


Microsoft
Windows
KB890859-Security
Smith 5
0515908.MST
English 1.0-
SP-009693-00
False




Update MS05.018


200506030


Microsoft
Windows
KB891781 Security
Smith 5
0504504.MST
English 1.0-
SP-009288-00
False




Update MS05-013


200502090


Microsoft
Windows
KB893056 Hibernate
Smith 5
0507506.mst
English

False




Button Turn Off fix


KB893056


Microsoft
Windows
KB893066-Security
Smith 5
0517301.MST
English 2.0-
SP-009713-01
False




Update MS05-019


200506200


Microsoft
Windows
KB893086-Security
Smith 5
0515901.MST
KB893086
SP-009684-00
False




Update MS05-016


English 1.0-







200506030


Microsoft
Windows
KB893803-Windows
Smith 5
0515904.MST
3.1-
SP-009766-00
False




Installer 3.1


KB893803-







1.0-200506060


Microsoft
Windows
KB894391-SVC Host
Smith 5
0515905.MST
English 1.0-
SP-009724-00
False




error fix


200505190


Microsoft
Windows
KB896358-Security
Smith 5
0517304.MST
English 1.0-
SP-010013-00
False




Update-MS05-026


200506200


Microsoft
Windows
KB896422-Security
Smith 5
0517204.MST
English 1.0-
SP-010055.00
False




Update-MS05-027


200506200


Microsoft
Windows
KB896428-Security
Smith 5
0522305.MST
English 1.0-
SP.010081-00
False




Update MS05-033


200506200.


Microsoft
Windows
KB901214-Security
Smith 5
0521301.mst
English OEM

False




Update MS05-036


distribution


Microsoft
Windows
KB903235-Security
Smith 5
0521304.mst
English OEM

False




Update MS05-037


Distribution


Microsoft
Windows
Media Player 10
Smith 10
0429401.MST
English OPK

False


Microsoft
Windows
Windows.NET
Smith 5
0513101.mst
SPI

False




Framework Service


KB867460




Pack


Microsoft
Windows
Windows Media
Smith 5
0516001.MST
ver.X10-86962
SP-009834-00
False




Connection


Microsoft
Windows
Windows XP OPK
Smith 10
0132507.mst
GM

False




MUI


Microsoft
Windows
Windows XP
Smith 10
0421902.mst
English SP2

False




Professional Edition


Gold


Microsoft
Windows
Windows.NET
Smith 10
0314926.mst
Framework

False







1.1 OPK







Support


Sony ITC
Windows
SLP Files
Smith 10
0516012.SNC
1.1.1.0-

False







200506040


Sun
Windows
Java 2 Runtime
Smith 10
0515401.sun
1.5.0.03

True


Micro-

Environment


systems







Driver














Alps
Driver-Mouse
Pointing Driver
Smith 6
0519301.ALP
050629
SP-010147-00
False




Registry Patch


Alps
Driver-Mouse
Touchpad
Smith 6
0421501.alp
5.3.511.2c
SP-001993-36
True







WHQL


Connexant
Driver-Modem
Smart MC3Z
Smith 6
0518101.CXT
7.28.00.50-
SP-008161-08
False







050628logo


Intel
Driver-
Ethernet driver
Smith 6
0430001.itl
8.0.13.0
SP-002515-11
False



Network



WHQL


Intel
Driver-Display
Intel 915G graphics
Smith 6
0518801.itl
6.14.10.4333h
SP-007709-14
False







WHQL


Intel
Driver-System
Intel
Smith 6
0520902.itl
6.1.0.1008
SP-008174-00
True




915GM_PM_GMS_910GML


WHQL




Alviso


Intel
Driver-Display
Intel Graphics Driver
Smith 6
0515102.itl
v01
SP-009674.00
False




Registry Patch


Intel
Driver-
Intel Pro
Smith 6
0516401.ITL
9.0.2.25a-logo
SP-007020-07
False



Wireless
2915ABG_2200BG



LAN


RealTek
Driver-Sound
Audio Driver
Smith 6
0519601.RTK
5.10.0.5129-
SP-008252-28
False







050715_WHQL


Sony
Driver-Modem
VDC EGPRS Modem
Smith 11
0506001.ser
3.0.0.1510
SP-009393-00
False


Ericsson

Driver


WHQL


Sony ITC
Driver-System
Notebook Control
Smith 12
0429202.SNC
6.0.1.08290-
SP-004458-00
False







020604







WHQL


Sony ITC
Driver-System
SonyPi
Smith 12
0418902.SNC
7.0.3.820
SP-004457-00
False







WHQL


Sony ITC
Driver-Mouse
USB Mouse
Smith 6
0508001.SNC
1.56-whql
SP-002012-05
False







(resubmitted)


Sony ITC
Driver-Imaging
VAIO USB Camera
Smith 6
0306208.snc
1.2.00.01172
SP-004578-01
False







WHQL


Sony ITC
Driver-Hard
VGP-MCA10 registry
Smith 6
0428705.snc
1.0.0.10130
SP-007787-02
False



Disk
patch


Texas
Driver-Hard
Memory Stick Driver
Smith 6
0520601.tex
2.0.0.5_Logo
SP-009671-04
False


Instru-
Disk


ments


Texas
Driver-Hard
Memory Stick driver
Smith 6
0517802.tex
1.0.0.0-
SP-010131-00
False


Instru-
Disk
Registry patch


20050610


ments


Toshiba
Driver-System
Bluetooth driver
Smith 13
0519901.TOB
3.03.13SO-
SP-009675-03
False







04_RC3.20050708


Toshiba
Driver-System
Bluetooth Registry
Smith 13
0517801.TOB
1.0.0.0
SP-010130-00
False




Patch







Utility














Sony ITC
System Tool
AV Mode Button
Smith 6
0519303.SNC
1.0.00.06291
SP-010142-00
False




Utility


Sony ITC
System Tool
Battery Check Utility
Smith 12
0506701.SNC
1.0.02.01240
SP-007112-03
True


Sony ITC
System Tool
Memory Stick Pro
Smith 12
0503605.snc
2.4.0.13260.0502040
SP-005054-04
True




Formatter


Sony ITC
System Tool
OCA Marker
Smith 6
0404201.snc
1.03.1.0401130

False


Sony ITC
System Tool
SetReso
Smith 12
0429607.snc
2.3.1.2702
SP-002911-18
False


Sony ITC
System Tool
Setting Utility Series
Smith 12
0516014.SNC
1.2.00.05270
SP-008403-11
True


Sony ITC
System Tool
VAIO Central
Smith 14
0516704.SNC
1.1.02.061005

False


Sony ITC
System Tool
VAIO Event Service
Smith 12
0516805.SNC
2.2.00.06130
SP-008245-21
True


Sony ITC
System Tool
VAIO Power
Smith 12
0521405.SNC
1.7.00.08011
SP-008404-19
True




Management


Sony ITC
System Tool
VAIO Update
Smith 11
0516103.SNC
2.1.02.01250

True







(Not for LA)


Sony ITD
System Tool
Sony Digital Signature
Smith 15
0121802.snd
1.0

False


Sony ITD
System Tool
VAIO Support Central
Smith 14
0519320.SND
1.0.0.63005

False







Library














Sony ITC
Shared Library
ImageStation Library
Smith 16
0318106.snc
3.0.01.05290
SP-005050-01
True


Sony ITC
Shared Library
Sony MP4 Shared
Smith 17
0503512.snc
1.1.00.12200
SP-009172-00
False




Library


Sony ITC
Shared Library
Sony Shared Library
Smith 18
0503811.snc
2.10.00.01250
SP-005988-01
True







XP


Sony ITC
Shared Library
Sony Video Shared
Smith 17
0503505.snc
2.0.01.12200
SP-009171-00
True




Library


Sony ITC
Shared Library
SonyUtils
Smith 12
0515908.snc
6.2.00.17310
SP-008151-18
True







Application-


AudioVideo














Macro-
Multimedia
Flash Player
Smith 19
0420101.MAC
7.0.19.0

True


media


Sony ITC
Multimedia
OpenMG Setup
Smith 17
0516005.snc
4.2.00.06070
SP-009199-02
True







(Not for LA)


Sony ITC
Multimedia
Sonic Stage Mastering
Smith 17
0430713.snc
1.4.00.10260_Aroma-
SP-007851-03
False




Studio Audio Filter


IRX3190




Presets


Sony ITC
Multimedia
VAIO Entertainment
Smith 17
0517204.snc
1.2.11.06150
SP-009842-01
True




Platform







Application-


Productivity














Adobe
Productivity
Adobe Reader
Smith 1
0504801.ADB
7.0.0.0-

True







English







Updated


Adobe
Productivity
Adobe Reader Patch
Smith 1
0515201.adb
7.0.1

False


Veritas
Productivity
PxEngine
Smith 20
0518101.VER
2.4.35.500a
SP-007059-10
True







Application-


Communications














Google
Commu-
Google Toolbar
Smith 1
0503801.goo
2.0.114.10_US

True



nication







Applications-


Marketing














Sony ITC
Marketing
Memory Stick Icon
Smith 12
0209504.snc
1.2.0.0-
SP-002377-02
False



Material



20010912


Sony ITC
Marketing
VAIO LiteFlow
Smith 18
0515905.snc
1.0.01.05100
SP-008504-01
False



Material
Wallpaper


Sony ITC
Marketing
VAIO Long Battery
Smith 18
0516607.SNC
1.0.00.05200
SP-009801-00
False



Material
Life Wallpaper


(RC)


Sony ITC
Marketing
VAIO Original Screen
Smith 18
0516001.snc
1.1.01.06070
SP-008470-05
False



Material
Saver


Sony ITC
Marketing
VAIO Scene
Smith 18
0503503.snc
1.0.01.12280_Scene_SD_Wide
SP-008486-01
False



Material
Screensaver


Sony ITD
Marketing
Bookmarks-IE
Smith 1
0503801.SND
1.0.00.0502070

False



Material



(US)


Sony ITD
Marketing
Image Station Photo
Smith 5
0508804.snd
1.0.0.0503280

False



Material
Printing RegKeys


Sony ITD
Marketing
VAIO Registration
Smith 15
0519419.SND
Fall05-14.0.2

False



Material







Documentation














Sony ITD
Documentation
Latest Information
Smith 21
0522304.SND
Fall05 English
n/a
True







V2


Sony ITD
Documentation
Recovery Guide
Smith 21
0520301.SND
Fall05 English
n/a
True


Sony ITD
Documentation
VAIO User Manual
Smith 21
0520701.SND
1.00.16EN07251
SP-010132.02
True







(IRX-3250







ENU)







SIT Build


Tools














Sony ITD
Tools
E-Flyer pop up utility
Smith 4
0507506.SND
1.2.1901.20464

False


Sony ITD
Tools
HDD Kick Tool
Smith 3
0520614.SND
3.1.5.0

False


Sony ITD
Tools
VAIO Drivers
Smith 10
0521610.SND
G336B02

True









Items Associated to Series:

TypeRelease NameIndexMODULEMOD-Click_To_DVD(0518903.snd)MODULEMOD-DVGate_Plus(0516403.snd)MODULEMOD-IceMaker(0519313.snd)MODULEMOD-Image_Converter(0517211.snd)MODULEMOD-Moodlogic(0516810.snd)MODULEMOD-MS_Works_Bundle(0506705.snd)MODULEMOD-NIS_2005_Trial(0521324.snd)MODULEMOD-Office_2003_Basic(0505102.snd)MODULEMOD-Office_2003_Professional(0520615.snd)MODULEMOD-Office_2003_Small_Business(0520613.snd)MODULEMOD-Office_2003_Small_Business_Trial(0519613.snd)MODULEMOD-Office_2003_Student_Teacher_Trial(0519616.snd)MODULEMOD-PhotoShop_Album_Starter_Edition(0517909.snd)MODULEMOD-Photoshop_Elements(0505510.snd)MODULEMOD-Premiere_Pro(0503904.snd)MODULEMOD-Premiere_Standard(0520304.snd)MODULEMOD-Quicken_New_User_Edition(0504901.snd)MODULEMOD-Roxio_DigitalMedia_SE(0518107.snd)MODULEMOD-S_S_M_S(0518801.snd)MODULEMOD-Spy_Subtract(0517402.snd)MODULEMOD-Toshiba_Bluetooth(0518111.snd)MODULEMOD-VAIO_Media(0519301.snd)MODULEMOD-VAIO_Survey_Standalone(0518615.snd)MODULEMOD-WinDVD(0518607.snd)MODULEMOD-Wireless_Help_Utility(0504904.snd)MODULEMOD-Wireless_Switch_Setting_Utility(0518108.snd)MODULEXMOD-AOL_Software(0519417.snd)MODULEXMOD-SonicStage(0517302.snd)Recovery ImageP1 Recovery Image(0520914.snd)


Changes from Previous:

Missing From Module Build 7VendorRelease NameDefect OwnerIndexVersion















New Components to Premiere Pro Module Build 7





















Vendor
Release
Defect Owner
Index
Version
IRT ID
Recovery



Name






















New Releases to Premiere Pro Module Build 7




















Vendor
Release Name
Index
New Version
Old SITID
Old Version






















Removed from Premiere Pro Module Build 7











Vendor
Release Name
Defect Owner
Index
Version





Sony
Driver Settings
Smith 6
0503807.SNC
050131 NB


ITC
Request Page









13.6.10 RPT-10: Media Set Report

TypeRelease NameIndexMODULEMOD-Click_To_DVD(0518903.snd)MODULEMOD-DVGate_Plus(0516403.snd)MODULEMOD-IceMaker(0519313.snd)MODULEMOD-Image_Converter(0517211.snd)MODULEMOD-Moodlogic(0516810.snd)MODULEMOD-MS_Works_Bundle(0506705.snd)MODULEMOD-NIS_2005_Trial(0521324.snd)MODULEMOD-Office_2003_Small_Business_Trial(0519613.snd)MODULEMOD-Office_2003_Student_Teacher_Trial(0519616.snd)MODULEMOD-PhotoShop_Album_Starter_Edition(0517909.snd)MODULEMOD-Photoshop_Elements(0505510.snd)MODULEMOD-Premiere_Pro(0503904.snd)MODULEMOD-Premiere_Standard(0520304.snd)MODULEMOD-Quicken_New_User_Edition(0504901.snd)MODULEMOD-Roxio_DigitalMedia_SE(0518107.snd)MODULEMOD-S_S_M_S(0518801.snd)MODULEMOD-Spy_Subtract(0517402.snd)MODULEMOD-Toshiba_Bluetooth(0518111.snd)MODULEMOD-VAIO_Media(0519301.snd)MODULEMOD-VAIO_Survey_Standalone(0518615.snd)MODULEMOD-WinDVD(0518607.snd)MODULEMOD-Wireless_Help_Utility(0504904.snd)MODULEMOD-Wireless_Switch_Setting_Utility(0518108.snd)MODULEXMOD-AOL_Software(0519417.snd)MODULEXMOD-SonicStage(0517302.snd)RecoveryP1 Recovery Image(0520914.snd)ImageData Filebitindex.ini(0519625.snd)Data FileLeonV-HE Data File(0521334.snd)Data Filemodule.iniR (0520102.snd)EPCEPC_A-0198-LeonV_Latest_Information(0521323.snd)EPCEPC_A-0199-Security_Updates_MS05-036_037(0521602.snd)EPCEPC_A-0202-Security_Updates_MS05-038_039(0523011.snd)FoundationFI-LeonV-HE(0520208.snd)ImagePAC FileFI-LeonV-HE PAC File(0520209.snd)


13.6.11 RPT-11: Part Report

Attribute NameDescriptionPart NameAdobe Premiere ProParent Planning PartAdobe Premiere ProActiveYesMajor Version7Part TypeInstallable ApplicationPart Sub TypeApplicationDependency AppendNoneDependencyNeed: VAIO Edit Components 5.0Install OrderAfter: VAIO Edit Components 5.0Customer LabelAdobe Premiere ProCustomer DescENU-US: Adobe's semi professionalvideo editing application.BLIDN/AisDefaultYesChampionSmith 1OwnerSmith 1Localised ByVOATarget SeriesHogwarts4-MCHorizon2-HEHorizon2-MCHorizon2-PRHorizon3_GD-HEHorizon3_GD-MCHorizon3_GD-PRLeonS2-HELeonS2-PRLeonV-HELeonV-PRMessenger-HEMessenger-PRSherry_WWAN-PRSpirit2-HESpirit2-PRSpirit3-HESpirit3-PRSeries DependencyN/ASupported LangRegionsENU-USChange LogisTemporaryNoDefault Installer Type (selectEXEfrom list)Default Setup FilePremiere.EXEDefault Command Line-s -nArgumentsDefault OPKNoDefault Base PlusNoDefault RecoverableyesDefault InteractiveNoVendorAdobe


13.6.12 RPT-12: Part Release Report

Attribute NameDescriptionRelease ID120123Detailed Version7.5.0.0Release NameAdobe Premiere 7.0Target LangRegionsen_USRelease Notes***Install Instructions***[WeberN - 7/16/04 12:10:00 PM]Run Setup.exe***Uninstall Instructions***[WeberN - 7/16/04 12:10:00 PM]Uninstall via Add/Remove Programs***Release Notes***[WeberN - Jul. 16, 2004 12:10:00 PM]Adobe Premiere Pro 7.5, OEM 282StatusGMSubmitted BySmith 22Next ReleasenoneVirus Checkdropdown: statuses TBDWHQL statusnot applicablePlmStatusdropdown: statuses TBDIs Default ReleaseyesIs Latest ReleaseyesVersion PathC:\PROGRAM FILES\ADOBE\PREMIERE PRO 7.5\ADOBEPREMIERE PRO.EXEVersion ID7.5.0.000.1010Version check beforePremiere.EXE version 7.5installationChange LogNo recordInstalled Folder PathC:\PROGRAM FILES\ADOBE\PREMIERE PRO 7.5\Installer PlaceTBDInstaller Type (select fromEXElist)Setup FilePremiere.EXECommand Line-s -nArgumentsOPKnoBase PlusnoRecoverableyesInteractivenoRepackagedyesSnapshot IDn/a


13.6.13 RPT-13: Part Release Version Report


13.6.14 RPT-14: RTM Report
    • 1. User picks one Series/LangRegion.
    • 2. User picks one or more OSs.
    • 3. User selects which sub-reports to include.
    • 4. System presents format that can be loaded into MS Word for further editing.


      13.6.15 RPT-15: Test Status for Series


      13.6.16 RPT-16: Test Status for All Active Series


      13.6.17 RPT-17: Defect Report for Individual Defect
    • Now referencing FIG. 25, the screen shot of a “Defect View” is shown, which includes the defect report.


      13.6.18 RPT-18: Defects By User, Team, Series, Cycle, Etc.


      13.6.19 RPT-19: Test Case Report
    • Now referencing FIG. 26, the screen shot of “Test Results: Update from test strategy” is shown.


      13.6.20 RPT-20: Test Strategy Report
    • With reference to FIG. 27, the report currently being implemented is shown. This report must be adapted to the Epic Data Model.


      13.6.21 RPT-20: Test Strategy Status Report


      13.6.22 RPT-22: End-of-cycle Defect Report
    • 1. User picks one or more Series/LangRegion combinations.
    • 2. User picks one or more cycles or date ranges.
    • 3. User selects which sub-reports to include.
    • 4. System loads each report into separate worksheet (preferred) or separate excel document.


Defect Priority

Fall 05Sum 05PriorityPriority 05882Priority 121399Priority 2263139Priority 3193102Priority 4224Priority N/A146114Total895540


Defect Severity

Fall 05Sum 05Severity02022119212023571763203127N/A12395895540


Defect Exposure

Fall 05Sum 05ExposureLI2517HVCG16076LNFU348194LIDB15496VUS10159Blank10798895540


Defect Resolution by Application Champion

Fall 05ChampionFixedDef/WNFOtherTotalSmith 233036Smith 24121518Smith 180123Smith 251124Smith 262141843Smith 272412642Smith 28911222Smith 29141217Smith 21811423Smith 30117725Smith 311691944Smith 32321924Smith 3321710Smith 51921334Smith 19202123Smith 203238Smith 34682034Smith 355038Smith 121141327Smith 144181436Smith 10493258139Smith 362125Smith 3422338103Smith 3727111753Smith 944917Smith 1313203568Smith 15935448















Summer 05













Champion
Fixed
Def/WNF
Other
Total

















jones1
0
2
2
4



jones2
1
0
0
1



jones3
6
6
16
28



jones4
15
3
8
26



jones5
7
6
4
17



jones
14
3
11
28



jones
8
10
45
63



Jone
0
5
3
8



jones
13
1
3
17



jonesa
1
6
0
7



jones
1
5
5
11



jones
8
2
1
11



Smith 19
1
0
1
2



jones
4
1
1
6



jones
13
3
17
33



jones
26
7
16
49



jones
9
2
2
13



jones
0
2
1
3



jones
71
10
25
106



jones
3
3
6
10



Winter
4
5
2
11



jones
1
40
22
63



jones
7
7
6
20










Defect Resolution by Module (First level applications on FI BOM should be included)

All resolutions-Fall 2005-Top TenApplicationSev 0Sev 1Sev 2Sev 3N/ATotalP = 0P = 1P = 2P = 3P = 4P = N/ATotalHDD Kick Tool02934121489034211821489NB Hardware0182621056014191031056OtherVAIO02729442026300442RegistrationVAIO Support8011182391206180339CentralDesktop0161022301151020230Hardware OtherSony Changer36147030371460030S/WFinger Print PS02195127001591227IE Remote011860250111220025ControlExtensionKansas051010025250000025Emerald/KansasSmartWi126782412940824ConnectionUtility















All resolutions-Summer 2005-Top Ten




















Application
Sev 0
Sev 1
Sev 2
Sev 3
N/A
Total
P = 0
P = 1
P = 2
P = 3
P = 4
P = N/A
Total























HDD Kick Tool
0
46
45
14
6
111
23
32
39
9
0
8
111


VAIO Control
0
2
18
13
10
43
1
7
11
11
1
12
43


Central


VAIO Central
12
0
9
5
6
32
24
0
0
1
0
7
32


Beta


Connection
1
0
2
21
4
28
0
0
12
9
1
6
28


Manager


SmartWi
0
0
1
16
9
26
0
1
3
12
0
10
26


Connection


Utility


Emerald Beta
1
7
5
3
3
19
14
0
0
2
0
3
19


VAIO
0
0
5
5
4
14
0
1
1
8
0
4
14


Registration


Intel Graphics
0
2
3
3
5
13
0
2
4
2
0
5
13


Windows Media
0
2
4
2
3
11
0
2
2
4
0
3
11


Center


AOL
0
5
1
1
2
9
0
3
2
2
0
2
9









Top Ten Deferred/Will Not Fix Defects

Top Ten Deferred/Will Not Fix Fall 2005ApplicationSev 0Sev 1Sev 2Sev 3N/ATotalVAIO Registration00427031HDD Kick Tool01109020VAIO Support Central00513018Windows MCE0048012Notebook Hardware Other0182011Sony Changer S/W014409Fingerprint Protection Suite003306Intel 915G Graphics004206MOD-Wireless Connection001506UtilityLibertas 802.11bg Wireless010405















Top Ten Deferred/Will Not Fix Summer 2005













Application
Sev 0
Sev 1
Sev 2
Sev 3
N/A
Total
















Connection Manager
0
0
2
18
0
20


SmartWi Connection Utility
0
0
0
15
0
15


HDD Kick Tool
0
3
6
1
0
10


Emerald Beta
1
0
1
2
2
6


VAIO Registration
0
0
2
4
0
6


Intel Graphics
0
0
2
3
0
5


VAIO Control Center
0
0
2
3
0
5


Windows MCE
0
0
3
2
0
5


AOL
0
2
1
1
0
4


VAIO Central Beta
1
0
2
0
0
3









13.6.23 RPT-23: Build Count

FIRecoveryProjectOSBuildsMedia BuildsHorizon2MCE41Horizon2HE22Mare4/Viento4HE44Spirit2HE33Spirit2PR33JediH2HE23LeonS2HE22LeonS2PR22Horizon2LA22HEVientoLA22HEHorizon2PR22Spirit2LA42HESpirit2LA42PRLeonS2LA22HELeonS2LA23PRSpirit2FC22HEAroma3HE45Aroma3PR35Aroma3LA22PRHogwarts4MCE44Hogwarts4LA21HE


While the particular SYSTEM AND METHOD FOR SOFTWARE INTEGRATION AND FACTORY DEPLOYMENT is herein shown and described in detail, it is to be understood that the subject matter which is encompassed by the present invention is limited only by the claims.

Claims
  • 1. A method for managing computer production in an enterprise, comprising: receiving a block of software offerings, each block being associated with at least one product series; receiving a product series component structure defining parts for a respective product series; adding parts required for a product series to the block associated with the series, parts being assigned to each software class and related software specification pair in a block based on the part or parts required for the pair to thereby define a design structure; and establishing a software bill of materials (BOM) based on the design structure using at least one of: a template and/or a snapshot.
  • 2. The method of claim 1, further comprising: defining software offerings, a software offering including at least one software class and at least one associated software specification; associating at least one software offering with at least one product series in a plurality of series to establish a configuration, configurations cumulatively defining a configuration range that contains product offerings of the enterprise for all regions in which the enterprise does business; and grouping classes into blocks, a block being associated with at least one product series.
  • 3. The method of claim 2, comprising defining which classes are dependent on each other.
  • 4. The method of claim 3, comprising defining which blocks are base blocks.
  • 5. The method of claim 1, comprising associating defects with related classes.
  • 6. The method of claim 5, comprising associating corrective actions with respective defects.
  • 7. The method of claim 6, comprising associating a respective installation file with each software offering, each installation file including a data file format version number, a version number of an installation data snapshot, an installation order for modules, data required for confirming successful installation, cyclic redundancy check (CRC) data for each binary file, path information for locating files in a file store, partition size information for recovery and customer partitions.
  • 8. The method of claim 7, wherein installation and recovery tools use a list of software releases directly instead of microcode, which is used only for customer recovery, with microcode bit mappings being constrained to respective recovery media sets.
  • 9. A software management database on a computer readable medium, the database containing: data structures supporting computer software provisioning for a range of CTO/BTO variations, language variations, region variations, and operating system variations.
  • 10. The database of claim 9, comprising: bill of materials (BOM) entities, each BOM entity containing information related to parent BOMs and child BOMs, if any, each BOM entity also including at least one engineering part ID, at least one software release ID, at least one major version ID, at least one group ID, at least one component ID, at least one planning parts ID, and at least one software series ID; and at least one plan parts entity including launch dates for software base releases, import dates for software bases indicating when the bases were imported into computers, identifications for software bases.
  • 11. The database of claim 10, comprising at least one components entity including launch dates for software base releases, import dates for software bases, identifications for software bases.
  • 12. The database of claim 11, comprising at least one software release entity containing a base ID, a name, a file path, a launch date.
  • 13. The database of claim 12, comprising at least one software release status entity including data representing status and name of a software release.
  • 14. The database of claim 13, comprising at least one group entity containing data representing a name and launch of a type.
  • 15. The database of claim 14, comprising at least one series entity containing a software series ID, base ID, name, an indication of being active, a launch date, an import date.
  • 16. The database of claim 15, comprising at least one engineering parts entity containing an engineering part. ID, a base ID, a type ID, a name, a launch date, and indication of dependent parts.
  • 17. The database of claim 16, comprising at least one engineering parts major revision entity containing information related to default use.
  • 18. The database of claim 17, comprising at least one engineering part software release entity containing information on a related engineering part entity, a related engineering parts major revision entity, a related language code entity.
  • 19. The database of claim 18, comprising at least one language entity containing information related to a language name and a language code.
  • 20. A computer-implemented system for creating bills of materials (BOMs), comprising logic executable by a computer and stored on a computer readable medium, the logic: facilitating creation of BOMs using templates and/or snapshots.
  • 21. The system of claim 20, wherein BOMs are automatically generated based on part attributes and groups of parts, major versions, and releases.
  • 22. The system of claim 20, wherein the logic automatically checks BOMs to reduce errors.
  • 23. A computer system executing logic stored on a computer readable medium, the computer system: entering, into a first database, first software data, the first software data including operating systems and configure to order/build to order (CTO/BTO) options; transferring at least some of the first software data in the first database to a comprehensive global database; and automatically adding to a bill of materials (BOM) through the comprehensive global database second software data, the second software data including one or more of operating system updates, device drivers, utilities.
  • 24. The system of claim 23, wherein software along with metadata that describes the software is checked into the comprehensive global database by users.
  • 25. The system of claim 24, wherein the BOM for a specific series/language/region is frozen/locked and the process to create factory deliverables including software image, software modules, and data) is then begun.
  • 26. The system of claim 25, wherein factory deliverables derived from the comprehensive global database are tested and validated to meet quality standards, the factory deliverables, and metadata that describes them, then being delivered to a factory to be used in mass production.
  • 27. The system of claim 26, wherein the comprehensive global database supports software variations in CTO/BTO, language, region, and OS, the comprehensive global database facilitating the creation of CTO systems, based on individual customer orders, in a mass production process with every piece of software preinstalled and ready to use.
  • 28. The system of claim 28, wherein the comprehensive global database facilitates automatically mapping hardware components to software releases.
  • 29. The system of claim 28, wherein the comprehensive global database facilitates specifying language and geographic region for each software release at the time of software check-in, with a correct release being assigned to each BOM automatically.
  • 30. The system of claim 29, wherein the comprehensive global database facilitates creation of BOMs using templates and snapshots for efficiency, the BOMs being automatically generated based on part attributes, groups of parts, major versions, and releases.
  • 31. The system of claim 29, wherein the comprehensive global database facilitates automatic checking of BOMs to reduce errors.
  • 32. The system of claim 29, wherein the comprehensive global database facilitates use of a list of software releases directly instead of microcode, with microcode bit mappings being constrained to each recovery media set that is defined.
RELATED APPLICATION

This application claims priority from U.S. provisional application 60/722,130, filed Sep. 29, 2005, incorporated herein by reference.

Provisional Applications (1)
Number Date Country
60722130 Sep 2005 US