Information Technology Reference
In-Depth Information
Table 1. Competencies at the network partners level: I Life cycle
Partner
CO
P1
P2
P3
P4
P5
P6
P7
P8
P9
INPRO
No. person
12
9
19
15
12
14
7
6
1
5
100
I. Life cycle
399 569 811 491 614 639 443 312
45
112
4435
Design
269
385
569
233
393
362
247
146
14
65
2683
>Conceptual design
96
113
141
67
134
114
101
49
5
17
837
>Detail design
143
216
353
106
221
181
77
33
9
39
1378
>Support
30
56
75
60
38
67
69
64
0
9
468
Manufacturing
86
155
189
229
185
240
182
133
30
43
1472
>Manufacturing systems
9
11
8
4
18
27
5
6
1
8
97
>Manufacturing pro-
cesses
38
55
79
165
84
105
111
48
15
13
713
>Quality control
5
17
49
34
12
9
44
30
10
210
>Operation management
5
25
19
19
36
44
12
24
4
14
202
>Manufacturing support
13
32
7
5
27
28
8
12
4
136
>Management support
16
15
27
2
8
27
2
13
4
114
Utilization / Service
27
24
32
17
28
24
10
16
4
182
>Monitoring
5
3
4
4
7
2
4
2
31
>Diagnosis
3
5
1
4
2
2
17
>e-service
1
4
2
3
2
12
Maintenance
2
4
6
8
4
4
2
30
>Support
16
12
24
4
6
16
10
4
92
End of life cycle
17
5
21
12
8
13
4
17
1
98
>Disassembly
2
1
2
1
2
1
9
>Testing
1
1
>Recycling
2
3
1
1
1
1
9
>Refurbishing
1
2
1
1
1
6
>Disposal
1
1
2
>Support
16
1
18
7
6
11
12
71
network must work to gain competencies through
the training procedures of human resources.
data into three tables was necessary, because of
the great number of fields (255+255+253). The
three tables were linked by relations using key
fields. In order to find the person with certain
competencies, a usual Access query is launched
(Figure 9) or using SQL.
An Internet based interrogation is in train to
be finished, using MySQL. This creates the pos-
sibility to query the (sole) competencies database
by each partner, from his office or from anywhere
an Internet link exists.
creating the database
with the network's human
resources competencies
The data from the forms were extracted in a neu-
tral format (CSV), and then used to create a usual
database (by importing data from CSV text files).
For the Microsoft Access application, splitting the
Search WWH ::
Custom Search