Hi Guys ...
ada yang ada pengalaman bikin struktur data untuk organisasi?
harapannya ada semacam history dari organisasi, misalnya strukturnya gini :
BOD
- SALES
-- SALES #1
-- SALES #2
- ADMIN
-- GA
-- FINANCE
-- ACCOUNTING
-- SOFTWARE
- BUSINESS
-- RESEARCH
--- MESIN #1
--- MESIN #2
--- MESIN #3
-- DEVELOPMENT
--- SOFTWARE #1
--- SOFTWARE #2
Terus misalnya per tanggal 1 November 2005 berganti :
BOD
- SALES
-- SALES #1
-- SALES #2
- ADMIN
-- GA
-- FINANCE
-- ACCOUNTING
-- SOFTWARE
BUSINESS
- RESEARCH
-- MESIN #1
-- MESIN #2
-- MESIN #3
- DEVELOPMENT
-- SOFTWARE #1
-- SOFTWARE #2
Terus misalnya lagi per tanggal 1 Maret 2006 berganti menjadi :
BOD
SALES
- SALES #1
- SALES #2
ADMIN
- GA
- FINANCE
- ACCOUNTING
BUSINESS
- RESEARCH
-- MESIN #1
-- MESIN #2
-- MESIN #3
- DEVELOPMENT
-- SOFTWARE #1
-- SOFTWARE #2
-- ADMIN
Nah ... saya bikin strukturnya ada dalam 2 table :
table organization :
organization_code organization_name ..... ( plus banyak field lainnya )
============================================================
BOD Board of Director
SLS Department Sales
SL1 Unit Sales 1
SL2 Unit Sales 2
ADM Admin Department
GA Unit General Affair Unit
FIN Unit Finance Unit
ACC Unit Accounting
ASW Unit Admin Software
BSN Department Bussiness
RSC Unit Research
MS1 Unit Mesin 1
MS2 Unit Mesin 2
MS3 Unit Mesin 3
DEV Unit Development
SW1 Unit Software 1
SW2 Unit Software 2
table organizationhistory :
organization_code organization_id app_date exp_date parent_organization_id
============================================================================
BOD 1 NULL NULL 0
SLS 2 NULL 20060301 1
SL1 3 NULL 20060301 2
SL2 4 NULL 20060301 2
ADM 5 NULL 20060301 1
GA 6 NULL 20060301 5
FIN 7 NULL 20060301 5
ACC 8 NULL 20060301 5
ASW 9 NULL 20060301 5
BSN 10 NULL 20051101 1
RSC 11 NULL 20051101 10
MS1 12 NULL 20051101 11
MS2 13 NULL 20051101 11
MS3 14 NULL 20051101 11
DEV 15 NULL 20051101 10
SW1 16 NULL 20051101 15
SW2 17 NULL 20051101 15
BSN 18 20051101 NULL 0
RSC 19 20051101 NULL 18
MS1 20 20051101 NULL 19
MS2 21 20051101 NULL 19
MS3 22 20051101 NULL 19
DEV 23 20051101 NULL 18
SW1 24 20051101 NULL 23
SW2 25 20051101 NULL 23
SLS 26 NULL 20060301 0
SL1 27 NULL 20060301 26
SL2 28 NULL 20060301 26
ADM 29 NULL 20060301 0
GA 30 NULL 20060301 29
FIN 31 NULL 20060301 29
ACC 32 NULL 20060301 29
ASW 33 NULL 20060301 23
Struktur ini bisa menjadi solusi untuk konsep history kalau ada perubahan
struktur organisasi. Tapi cukup sulit untuk membuat report summarynya.
Ada yang mempunyai pengalaman untuk kasus seperti ini?
Thanks.
esr
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
