Data Management (Naming Convention) Poll

Hey Folks,

Looking to develop a new program. Need some insight from the group at
large. I know this will hit a few nerves. If you have a spare moment
would love to get the groups input. Yes and no answers will suffice,
however long-winded, detailed info is entirely welcome.

Thanks in advance!

Such as:

File Naming
1. Is the file name the part number?
2. Is the part number in custom property if the file name is generic or
text based.
3. Do you use intelligent part numbers or not.
4. Do you use commodity codes to define the part type.
5. What other taxonomy do you use if any?
6. What "quirks" do you have in numbering, i.e. are parts numbered
differently than drawings for the delineated part. Are assemblies named
differently?

Custom Properties
6. Are custom properties entered manually each time a part is made?
7. Do you use template (seed) items with properties predefined in them?
8. Do you store rev (model or drawing) in custom properties?
9. Do you store model revs and drawing revs or do they track together?
10. Do you have a standard list of custom properties? What are they?
11. Do you use configuration specific custom properties.

Costing Information
12. Does your company have an MRP system to track project costs.
13. Do you carry costing data in Solidworks parts in any way?
14. Do buy/procure at the piece part level or sub-assembly level or
both?
15. Is real-time costed BOM's an issue your company struggles with?
16. Do pass data from your MRP to SW or vice-versa?
17. Do you use Excel to look at coating data?
18. Do the purchasing folks look at drawings to order product? If so
how do the do that, i.e. SW Viewer, PDF, etc.

 

Have to head out to meeting.
Answers are a little rushed - sorry.

File Naming
1. Is the file name the part number?
Yes if only one configuration
No if multiple configuration (Use a PDM value called ID to identifiy
each configuration (part)).


2. Is the part number in custom property if the file name is generic or

text based
Use configuration property ID to identify the part


..
3. Do you use intelligent part numbers or not.
Non-inteligent - pulls the next available number from ERP system

4. Do you use commodity codes to define the part type.
Yes

5. What other taxonomy do you use if any?
Maintenance Authority to determine who has rights to edit document.

6. What "quirks" do you have in numbering, i.e. are parts numbered
differently than drawings for the delineated part. Are assemblies named

differently

Parts, Assemblies, Generic Documents (Word, Excel, etc...) get the next
non-intelligent number.




Custom Properties
6. Are custom properties entered manually each time a part is made
PDM system generates the configuration properties on the fly.

7. Do you use template (seed) items with properties predefined in them?

Nope - See #6

8. Do you store rev (model or drawing) in custom properties?
Stored in Configuration properties

9. Do you store model revs and drawing revs or do they track together

Use configuration revsions to track individual part revisions - model
values propagate to drawings. Don't try to match file revisions -
especially with configurations.

?

10. Do you have a standard list of custom properties? What are they
PDM system generates them on the fly. Hint: use the same ones as ERP
system the
meta data will be sent to.


11. Do you use configuration specific custom properties.
100%

Costing Information
12. Does your company have an MRP system to track project costs
Clients do - yes.


..
13. Do you carry costing data in Solidworks parts in any way?
No - wrong way to do it - PDM generates excel sheet that is linked to
ERP cost values.
SW model generates geometry and quantities - ERP values populate Excel
BOM

14. Do buy/procure at the piece part level or sub-assembly level or
both
Both - changes depending on prototype or production


?
15. Is real-time costed BOM's an issue your company struggles with?
No - PDM pulls info from ERP.
16. Do pass data from your MRP to SW or vice-versa?

PDM reads ERP data and flags standard items . PDM passes item master
and BOMs to ERP.

17. Do you use Excel to look at coating data?
Excel - costing data? yes

18. Do the purchasing folks look at drawings to order product? If so
how do the do that, i.e. SW Viewer, PDF, etc
PDM system generates PDF or e-drawings on the fly. Purchasing can use
either (engineering). Manufacturing purchaser only sees released PDF's

Len