Docstoc

Optical Fiber Solutions

Document Sample
Optical Fiber Solutions Powered By Docstoc
					Family Type: Misc. Parts                Field Type               Req.    Multi ?   Source
Family Name                             string                                     PLM
Family Overview (incl: Value Prop.)     text                                       PLM
Merchandise Class                       string                                     SAP
Description (incl: features/benefits)   string                                     App. Eng
Family Coding Scheme                    url                                        PLM
Family Coding Image                     Associated Coding Image                    PLM
Family Specifications                   url                                        PLM
Family Photos                           Associated Photo            x              PLM
Family Illustrations                    Associated illustrations    x              PLM
Applications Information                Associated pdf              x              App. Eng
Engineering Rules & Guidelines          Associated pdf              x              PLM
Installation Instructions               Associated pdf              x              PLM
Warranty Info                           link to page asset                         PLM
Return Policy                           link to page asset                         PLM
UL Certification                        string                     Y/N             PLM
SA Certification                        string                     Y/N             PLM
Other Certifications                    Certification Image         x              PLM
Family Fact Sheet                       Associated pdf              x              App. Eng
Family White Papers                     Associated pdf              x              App. Eng
footnote                                text                                       App. Eng


Associated products
Parent G2
Parent G3
Parent A2                                                                Application Sub-Level
A-Z Index                                                                For Product A-Z index
             Notes   No Page Display




ion Sub-Level
duct A-Z index
       Child Type: Misc. Parts               Field Type        Req.   Multi ?    Source    Notes   No Page Display
Full Product Name                     string                                    App. Eng
Product ERP Short Description         string                                    SAP                       x
Product Code                          string                                    SAP
Product Comcode                       integer                                   SAP
Product List Price                    numeric                                   SAP
Stock/Non-Stock Product Status        string                                    SAP
Product DA Status                     string                                    SAP
Product DA Replacement / Substitute   string                                    SAP
Product Ship Interval                 integer                                   SAP
Product Weight                        float                                     SAP                       x
Product Denomination                  integer                                   SAP                       x
Product Package Quantity              integer                                   SAP
Product Photo(s)                      associated photo                   x      PLM
Product Illustrations                 associated illustrations           x      PLM
A-Z Index                             string                                    PLM                       x

Product Group (G3 is the parent)                                                PLM                       x
             Child Type: Adapters             Field Type         Req.   Multi ?
Full Product Name                     string
Product ERP Short Description         string
Product Code                          string
Product Comcode                       integer
Product List Price                    float
Stock/Non-Stock Product Status        string
Product DA Status                     string
Product DA Replacement / Substitute   string
Product Ship Interval                 integer
Product Weight                        float
Product Denomination                  integer
Product Package Quantity              integer
Product Description                   text
Product Photo(s)                      associated photo                     x
Product Illustrations                 associated illustrations             x
Connector Type                        string
Number of Colnnections                string
A-Z Index                             string

Product Family
          Notes      Source     No Page Display
                    App. Eng.
                    SAP                x
                    SAP
                    SAP
                    SAP
                    SAP
                    SAP
                    SAP
                    SAP
                    SAP                x
                    SAP                x
                    SAP
                    PLM
                    PLM
                    PLM
LC, SC, ST          PLM
simplex or duplex   PLM
                    PLM                x

                                       x
                 Child Type: Kits             Field Type         Req.   Multi ?
Full Product Name                     string
Product ERP Short Description         string
Product Code                          string
Product Comcode                       integer
Product List Price                    float
Stock/Non-Stock Product Status        string
Product DA Status                     string
Product DA Replacement / Substitute   string
Product Ship Interval                 integer
Product Weight                        float
Product Denomination                  integer
Product Package Quantity              integer
Product Description                   text
Product Photo(s)                      associated photo                     x
Product Illustrations                 associated illustrations             x
Kit Type                              string
A-Z Index                             string

Other Children                                                             x
Product Family (parent)
           Notes            Source No Page Display
                           App. Eng.
                           SAP            x
                           SAP
                           SAP
                           SAP
                           SAP
                           SAP
                           SAP
                           SAP
                           SAP            x
                           SAP            x
                           SAP
                           PLM
                           PLM
                           PLM
Jumper, Attenuator, etc.   PLM
                           PLM            x
              Child Type: Connectors          Field Type          Req.   Multi ?
Full Product Name                      string
Product ERP Short Description          string
Product Code                           string
Product Comcode                        integer
Product List Price                     float
Stock/Non-Stock Product Status         string
Product DA Status                      string
Product DA Replacement / Substitute    string
Product Ship Interval                  integer
Product Weight                         float
Product Denomination                   integer
Product Package Quantity               integer
Product Description                    text
Product Photo(s)                       associated photo                     x
Product Illustrations                  associated illustrations             x
Connector Type                         string
Fiber Type                             string
Cordage Acceptance size                float                                x
Ferrule Type                           string
Tip Geometry                           string
A-Z Index                              string

Product Family (parent)
           Notes               Source    No Page Display
                             App. Eng.
                             SAP                x
                             SAP
                             SAP
                             SAP
                             SAP
                             SAP
                             SAP
                             SAP
                             SAP                x
                             SAP                x
                             SAP
                             PLM
                             PLM
                             PLM
e.g: LC, ST, SC              PLM
e.g.L SM, MM                 PLM
1.6, 3.0, 0.9 mm             PLM
(alumina or zirconia)        PLM
(e.g.: angled or polished?   PLM
                             PLM                x
 Child Type: Passive Optical Components         Field Type         Req.   Multi ?
Full Product Name                         string
Product ERP Short Description             string
Product Code                              string
Product Comcode                           integer
Product List Price                        float
Stock/Non-Stock Product Status            string
Product DA Status                         string
Product DA Replacement / Substitute       string
Product Ship Interval                     integer
Product Weight                            float
Product Denomination                      integer
Product Package Quantity                  integer
Product Description                       text
Product Photo(s)                          associated photo                   x
Product Illustrations                     associated illustrations           x
Number of Output Signals (# splits)       integer
Split Ratio                               string                             x
A-Z Index                                 string

Product Family (parent)
Notes     Source    No Page Display
        App. Eng.
        SAP                x
        SAP
        SAP
        SAP
        SAP
        SAP
        SAP
        SAP
        SAP                x
        SAP                x
        SAP
        PLM
        PLM
        PLM
        PLM
        PLM
        PLM                x
Notes




(balanced, 30/35/35 etc.)
               Child Type: Closures            Field Type        Req.   Multi ?
Full Product Name                     string
Product ERP Short Description         string
Product Code                          string
Product Comcode                       integer
Product List Price                    float
Stock/Non-Stock Product Status        string
Product DA Status                     string
Product DA Replacement / Substitute   string
Product Ship Interval                 integer
Product Weight                        float
Product Denomination                  integer
Product Package Quantity              integer
Product Description                   text
Product Photo(s)                      associated photo                     x
Product Illustrations                 associated illustrations
Maximum Number of Cables              numeric
Minimum Cable Outside Diameter        float
Maximum Cable Outside Diameter        float
Splice Type                           string
Splice Capacity                       numeric
Connector Capacity                    numeric
Design Geometry                       string
Usage Category                        string                               x
A-Z Index                             string

Product Family (parent)
             Notes                 Source No Page Display
                                  App. Eng.
                                  SAP            x
                                  SAP
                                  SAP
                                  SAP
                                  SAP
                                  SAP
                                  SAP
                                  SAP
                                  SAP            x
                                  SAP            x
                                  SAP
                                  PLM
                                  PLM
                                  PLM
                                  PLM
                                  PLM
                                  PLM
e.g: mass or single               PLM
                                  PLM
                                  PLM
in-line or butt                   PLM
eg: Aerial, Buried, Underground   PLM
                                  PLM            x
   Child Type: Fiber Distribution & Shelves              Field Type        Req. Multi ?
Full Product Name                                 string
Product ERP Short Description                     string
Product Code                                      string
Product Comcode                                   integer
Product List Price                                float
Stock/Non-Stock Product Status                    string
Product DA Status                                 string
Product DA Replacement / Substitute               string
Product Ship Interval                             integer
Product Weight                                    float
Product Denomination                              integer
Product Package Quantity                          integer
Product Description                               text
Product Photo(s)                                  associated photo                x
Product Illustrations                             associated illustrations        x
Shelf height                                      float
Shelf width                                       float
Shelf Depth                                       float
OSP cable capacity                                integer
Fiber capacity                                    integer
Termination Access Type                           string
Shelf type                                        string
ISE Connector (inside end)                        string
OSE Connector (outside end)                       string
design type (e.bg: adapters, ubo, front access)   string
fiber type                                        string
cable type                                        string
number of fibers                                  integer
stub length                                       float
A-Z Index                                         string

Product Family (parent)
                Notes                        Source No Page Display
                                            App. Eng.
                                            SAP            x
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP            x
                                            SAP            x
                                            SAP
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
e.g.: front, rear                           PLM
e.g.: termination, splicing, combo, storage PLM
for pre-terminated shelves only             PLM
for pre-terminated shelves only             PLM
for pre-terminated shelves only             PLM
for pre-terminated shelves only             PLM
for pre-terminated shelves only             PLM
for pre-terminated shelves only             PLM
                                            PLM
                                            PLM            x
   Child Type: Fiber Distribution & Shelves          Field Type        Req. Multi ?
Full Product Name                             string
Product ERP Short Description                 string
Product Code                                  string
Product Comcode                               integer
Product List Price                            float
Stock/Non-Stock Product Status                string
Product DA Status                             string
Product DA Replacement / Substitute           string
Product Ship Interval                         integer
Product Weight                                float
Product Denomination                          integer
Product Package Quantity                      integer
Product Description                           text
Product Photo(s)                              associated photo                x
Product Illustrations                         associated illustrations        x
Shelf height                                  float
Shelf width                                   float
Shelf Depth                                   float
OSP cable capacity                            integer
Fiber capacity                                integer
Termination Access Type                       string
Shelf type                                    string
A-Z Index                                     string

Product Family (parent)
                Notes                        Source No Page Display
                                            App. Eng.
                                            SAP            x
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP
                                            SAP            x
                                            SAP            x
                                            SAP
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
                                            PLM
e.g.: front, rear                           PLM
e.g.: termination, splicing, combo, storage PLM
                                            PLM            x
         Child Type: Attenuators               Field Type          Req.   Multi ?
Full Product Name                       string
Product ERP Short Description           string
Product Code                            string
Product Comcode                         integer
Product List Price                      float
Stock/Non-Stock Product Status          string
Product DA Status                       string
Product DA Replacement / Substitute     string
Product Ship Interval                   integer
Product Weight                          float
Product Denomination                    integer
Product Package Quantity                integer
Product Description                     text
Product Photo(s)                        associated photo                     x
Product Illustrations                   associated illustrations             x
type connection                         string
attenuation level 1 (nominal loss db)   float
attenuation level 2                     float
tolerance                               float
label color                             string
A-Z Index                               string

Product Family (parent)
Notes    Source No Page Display
        App. Eng.
        SAP            x
        SAP
        SAP
        SAP
        SAP
        SAP
        SAP
        SAP
        SAP            x
        SAP            x
        SAP
        PLM
        PLM
        PLM
        PLM                       e.g. sm-sm, mm-mm
        PLM
        PLM
        PLM
        PLM
        PLM            x

        PLM
e.g. sm-sm, mm-mm
        Child Type: Premises Cable           Field Type          Req.   Multi ?
Full Product Name                     string
Product ERP Short Description         string
Product Code                          string
Product Comcode                       integer
Product List Price                    float
Stock/Non-Stock Product Status        string
Product DA Status                     string
Product DA Replacement / Substitute   string
Product Ship Interval                 integer
Product Weight                        float
Product Denomination                  integer
Product Package Quantity              integer
Product Description                   text
Product Photo(s)                      associated photo                     x
Product Illustrations                 associated illustrations
Number of fibers                      numeric
Fiber Type                            string
Cable Rating                          string                               x
Core Design                           string
Sheath Design                         string
Cable Colors                          string
Diameter (inside diameter)            float
Diameter (outside diameter)           float
A-Z Index                             string

Product Family (parent)
             Notes                   Source    No Page Display
                                   App. Eng.
                                   SAP                x
                                   SAP
                                   SAP
                                   SAP
                                   SAP
                                   SAP
                                   SAP
                                   SAP
                                   SAP                x
                                   SAP                x
                                   SAP
                                   PLM
                                   PLM
                                   PLM
                                   PLM
eg: single-mode, multimode, etc)   PLM
e.g: plenum, riser, accuribbon     PLM
                                   PLM
                                   PLM
                                   PLM
                                   PLM
                                   PLM
                                   PLM                x
Required Content for Phase 1


  Child Type: Jumpers & Pre-term Cables          Field Type          Req.   Multi ?                   Notes                     Source    No Page Display
Full Product Name                         string                                                                              App. Eng.
Product ERP Short Description             string                                                                              SAP                x
Product Code                              string                                                                              SAP
Product Comcode                           integer                                                                             SAP
Product List Price                        float                                                                               SAP
Stock/Non-Stock Product Status            string                                                                              SAP
Product DA Status                         string                                                                              SAP
Product DA Replacement / Substitute       string                                                                              SAP
Product Ship Interval                     integer                                                                             SAP
Product Weight                            float                                                                               SAP                x
Product Denomination                      integer                                                                             SAP                x
Product Package Quantity                  integer                                                                             SAP
Product Description                       text                                                                                PLM
Product Photo(s)                          associated photo                     x                                              PLM
Product Illustrations                     associated illustrations             x                                              PLM
Length (ft)                               float                                                                               PLM
Length (meters)                           float                                       algorithm to compute easier to admin.   PLM
Cordage e/w Comcode                       integer                                     specify cordage for custom lengths      PLM
Number of fibers                          numeric                                                                             PLM
End 1 Connector / ISE Connector           string                                      Connector type for Inside end 1         PLM
End 2 Connector / OSE Connector           string                                      Connector type for Inside end 2         PLM
Cordage/Cable Type                        string                                      1.6mm minicord, 3.0mm, etc.             PLM
Cordage/Cable Color(s)                    string                                                                              PLM
Fiber Type                                string                                      eg: single-mode, multimode, etc.        PLM
Cable Rating                              string                               x      eg: plenum, riser, accuribbon           PLM
Diameter (inside diameter)                float                                                                               PLM
Diameter (outside diameter)               float                                                                               PLM                x
A-Z Index                                 string                                                                              PLM

Product Family (parent)




                                                                                                                                                         26
                                                                                                                                        9/3/2011 @ 5:05 PM
                                                                                                                  bb790070-dd0d-46d5-8ba9-5310230508dc.xls
L.L.Kee                                                      Lucent Technologies Proprietary                                            jumper&preconn cbl.
PF Table - Column Asset

List of Attributes (columns) to render in a product family child table
   (This table will consist of a record for each child type. Allow a maximum of 7 columns/attributes per table)


 Child Asset Type          Adapters            Jumpers                Closures           Attenuators
Column 1             Product Code         Product Code          Product Code         Product Code
Column 2             Comcode              Comcode               Comcode              Comcode
Column 3             Full Name            Full Name             Full Name            Full Name
Column 4
Column 5
Column 6                                  Length                Splice Capacity      Attenuation Level
Column 7             Price                Price                 Price                Price
tributes per table)


                Premises Cable   Fiber Distribution   PON Components     Connectors          Kits
              Product Code       Product Code         Product Code   Product Code     Product Code
              Comcode            Comcode              Comcode        Comcode          Comcode
              Full Name          Full Name            Full Name      Full Name        Full Name
              # Fibers


              Price              Price                Price           Price           Price
     Misc. Parts
Product Code
Comcode
Full Name



Price
Illustration Asset      Type   Note
Alt                            text that will be stated when mouse is o
Image caption
Standard image
Standard Image Height
Standard Image Width
will be stated when mouse is over the image
Image Asset                                    data type   Multi valued?
Alt                                            string
Image caption                                  string
Thumbnail                                      gif/jpg
Standard image                                 gif/jpg
Standard Image Height                          float
Standard Image Width                           float
Image Map for either Standard or Large Image   text
Large Image                                    gif/jpg
Note
text that will be stated when mouse is over the image
G3 Group Asset           type   Note

Title
Description
Pointer to Image Asset
Pointer to G2
Pointer to A2
Pointer to Alpha Index
Pointer to Aliases
G2 Group Asset           data type Multi-Valued?   Notes

Title                    string
Description              text
Pointer to Image Asset   ptr       x
Pointer to G1
Pointer to Aliases       ptr       x
Pointer to Alpha Index
G1 Group Asset                   data type   Multi-Valued? Notes

Title                            string
Description                      text
Pointer to Image/Graphic Asset   ptr         x
Alias Asset

Alpha Index
Alias Name    jumper                         interconnect cable
                                             patchcord


              LGX                            ODF, FDF, Optical Distribution Frame
                                             Fiber Distribution Frame, LCIE, LCIT,
                                             Optical Cross Connect, optical patch panel,
                                             patch panel


              adapter                        coupling,
                                             sleeve
                                             alignment sleeve


              connector                      plug


              cordage                        cable


              adhesive                       epoxy, glue


              OCEF                           vault splice box


              Kevlar®                         aramid yard, strength members
              (trademark of E. I. duPont de Nemours)


              simplex                        single-fiber

              duplex                         dual-fiber


              coupler                        splitter, WDM, DWDM, wavelength multiplexer
th multiplexer
A2 Application Asset

Title
Description
Pointer to Image Asset
Pointer to A1
Pointer to Alpha Index
Pointer to Aliases
A1 Application Asset

Title
Description
Pointer to Image Asset
Alpha Pointer
Lookup Table for all Asset Names vs display name
Attribute Look-Up Asset
 Name to render for attribute name

Attribute Name                                     EN        ES
comcode                                            COMCODE
title
Search Results List Definition


This spreadsheet defines the attributes that will be presented for each type of asset when it appears as an item in a search resu
Search results list pages will have two sections to them. The first section is a list of any products returned by the search.
The second section is a list of all other asset types returned by the search. If either section is empty, it will not appear
on the page at all.

All Product Types    comments
Title
Description
Product Code
Product Comcode
DA Status *
Package quantity
Product Denomination
Replacement Product *



Notes
DA Status will only be shown if product is discontinued.
For DA'd products, the product code and comcode for the replacement product(s) will be displayed as a hypertext link to the pro
detail page for the replacement product.

For white papers, product brochures and other content that is in PDF file format, the search results list should indicate to the
user that the item is a PDF file and provide a link to download Adobe Acrobat.



                     comments
Asset Type = White Papers
Date
Title
Author
Abstract Description
PDF file size

                     Brochures
Asset Type = Productcomments and Data Sheets
Date
Title
Abstract Description
PDF file size
Document Number

                      comments
Asset Type = Installation Instructions
Title
Abstract Description
PDF file size
comcode number
Document Number

                    comments
Asset Type = Engineering Rules and Guidelines
Date
Title
Abstract Description
PDF file size
Document Number

                     Webserver
Asset Type = Link to comments page
Title
Abstract
File Type            only if file is not an html file.
File Size            only if file is not an html file.

                       comments
Asset Type = Press Release/Article
Date
Title of Press Release
Abstract Description
where published        if value is present in field
 t appears as an item in a search results list.
oducts returned by the search.
n is empty, it will not appear




isplayed as a hypertext link to the product.


h results list should indicate to the
 Asset Type = Event                   Multi-Valued? Format     Display on Detail Page?
Date                                                date      yes
Name of Event                                       string    yes
Location                                            string    yes
OFS Booth Number                            Y       string    yes
Overview Description (Abstract)                     text      yes
Pointer to Event Website                            pointer   yes
Pointer to speakers/presentations            y      pointer   yes
expiration date                                     date
pointer to graphic                                  pointer   yes

Asset Type = Event Presentation
Speaker                                    y       string     yes
Presentation/Paper Title                           string     yes
Pointer to Paper PDF                               pointer
Pointer to Presentation (.pps file)                pointer
PDF file size                                                 yes
PPS file size                                                 yes
                                    Note




Not sure whether the pps file type will be too large for internet downloads
 Asset Type = Press Release/Article   Multi-Valued? Format    Display on Detail Page
Date                                                date     yes
Title of Press Release                              string   yes
Abstract Description                                text
press release or article                            text     yes
Keywords                                            text
expiration date                                     date
where published                                     text     yes
type                                                text
                       Note



(html)

date article is moved from current list to archive

value must be press release or article
Asset Type = Link to Webserver page   Multi-Valued? Format                     Note
Title                                               string this will be the text that is hyperlinked
Abstract                                            text
URL                                                 URL
Rendering template
Keywords                                              string
File Type                                             text
File Size                                             numeric
Asset Type = PDF           Multi-Valued?     Format
Date                                       date
Title                                      string
Author                           y         string
Abstract Description                       text
Pointer to PDF file                        pointer
PDF file size                              int
Document Number                            string
Comcode Number                             integer
Pointer to group asset           y         pointer
pointer to product asset         y         pointer
keywords
file type                                  text
                                              Note



for white papers only


Applies to brochures and installation manuals
Applies to Installation Instructions Only
used to render index pages for brochures, installation manuals, etc.
used to render index pages for brochures, installation manuals, etc.

value will be brochure, datasheet, installation instructions, white paper or engineering rules
Sales Rep Asset   multi-valued? show on detail page notes

Name                           y
Phone Number                   y
address
email                          y
fax number                     y
Territory/Category x           y
Client/Customer(s) x
Description

				
DOCUMENT INFO