
Design Table for WBS

Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.
Level 1 Project, Level 2 Area, Level 3 Subarea, and Level 4 Subtistem in each box Level are asociated documents by disciplines.
Now I Link Each level to documents 1 to Many Level 1 to Documents, Level 2 to Documents etc.
I don't sure if is the best options I trie too related Level 1, to Level 2 to Level 3 and Level 4 but these option is complicated.
Some Alternative help
I send image example
-
Rafael Sanchis said:
Horas Ganadas Real are the Earned value it reflects the amount of hours that has actually been accomplished to data date.I read this as Horas Ganadas Real should be a formula field that sums up the Horas Consumidas for each documentos/disciplinas/ or actividades. Currently you are using the same horas humbre to figure out Plan and Real Horas Ganadas. To me, hitos only make sense at the planning level. Once you need actual horas then you have to track horas spent in another field (or table).
Take a look at the attached DB. I've made a few modifications:
1) at the Documentos Hito tab
2) FechaCorte table
-
Now that I've had a chance to play around more, I've modified:
Avances
Disciplinas
Documentos
FechaCorte
Take a look to see what you can do when you have a horasconsumidas table tracking horas. You can see the charts change in Tablero Avances when you add horas in Documentos.
FechaCorte, I've changed into a dashboard. I've added the ability to see horas consumidas real by Hito selected.