BAB 6 KESIMPULAN DAN SARAN dan kemungkinan Bab ini berisi beberapakesimpulandari tugas akhir lebihlanjutyangdapatdilakukandari tugasakhir ini pengembangan
6.1 KesimPulan ini adalahsebagai Beberapakesimpulanyangdapatdiambildari rugasakhir berikut : penyakit tuberkulosisdi l. Dengan aplikasi ini, informasi tentang kondisi terbaruisetiapsaat Surabayaselalusiaptersediadan selaludalamkondisi web dapat memberikan 2. Visualisasipemetaandata statistik dengan basis denganlebih dinamis' informasiuntuk mengamatipenyebarantuberkulosis penyebarantuberkulosisdi 3. Hasil peramalandengan menggunakanModel sesuai dengan data Indonesia sebagai basis penghitunganternyata tidak disebabkanoleh pendentayang ada di surabaya. Ketidaksesuaiantersebut dengandi Surabaya persentasejumlah penderitatuberkulosis di Indonesia mungkin tojadi karena faktor faktor penentu 1.angjauh berbeda.Hal ini probabilitastransisiantarakeduanyaberbeda'
6.2 Saran dalamtugasakhirini adalatt yangbisadilakukan pengembangan Beberapa berikut: sebagai
n2
I
dapat Dikembangkansuatu ststem yang dapat dikustomisasisehinga - dinaskesehatan daerahlain. olehdinaskesehatan digunakan
danganbasis yang lebihtepat,yaitu peramalan merodeperamalan 2. penggunaan khtrsttsuntukkota Surabaya' penyakittuberkulosis modelpenvebaran
113
DAFTAR PUSTAKA
tll
Aronofr stanley, GeographicInformationsystems:A Management 1989' Ottawa:WDL Publications, Perspective,
Pedoman Nasional t21 Departemen Kesehatan Republik Indonesia, PenangguIangan Tuberlu Iosis- Cetakanke-6, JakartZ200|' Module3: Introductionto GISand t3l EDINA DigimapTrainingsessions, MapPingAPPlications. t4] Indonesia
dalam
Program
Penanggulangan Tuberlulosis'
Indonesia'pdf' who.inUgtb/Country-info/pdf http://www. M.R., t5l Joesoef,
'liiptoherijanto B'' Gunardi' P., Muhaimin,T', Soetrisna'
Analysisof Modelandcost Effectiveness A.S..Putrli. J., Epidemiological ia' TttbercuIosis T'reatment Programs in Indones An Applied Managerial t6] Saunter,Viciry l, DecisionSupportSystem: Wileyandsons,NewYork,1998' Approach,John
'*i
/ ,/ , ============================================================-_=** / ' T B DB r ' ' D a t a i : a s e n a l n e: */ 2 0 0 0 S e r v e r t S Q L i ' l i E r o s o f r ' + i ; i l i ' { S n a m e: */ 0 1/ 0 8 / 2 0 0 3 7 : 2 0 : 2 6 . . / +r : r e a i - e c ic n : =:=:=:====l'
! + -.------
I'IOIIITOR
cable
alter
,lrnn
r^onsfraint
FK-I{OI'i I T OR-KE C-I'ION-KE CAI"ATA
qo MObfITOR table alLer . - Jr ^ n r : c n s t r a i n t FK_}IO}II T OR-T HN_MO}I_TA}IUN J - u y
v v . . Y ! - e -
G3
table PENDERITA eiter irnn r:on.qf raint FK PEI'IDERIT PUSKESI'IASPUSKESMA oc tabie F:iI'IDERITA aiter FK-PEIII)ERIT-THI'I-PEI'IDE-TAHUI'I C:op const:aint a? table PENGGUNA alter .i.cn ccnst:r-aint FK PEIIGGUNALOGII'I GRUP
P-ilSFESi'ir'S a :t-.r table ir.,n ,-.,n.qiraint E-K PIJSI'3SI'IA t'lASUK DLI'I KECAMATA . r ! v t /
v v r . v L ! q :
table TAF.GET aiier ,1: op ci.ns t ! a I lt t FK-TA-FGET-PUS-TALGE-PIJSKESFIA .,JO
tal-!e T.IS.GET alter C: op cc.ns tr ai:r E FK-TARGET-THN-TARGE-TAIIUI'I
j :
= :
-.-l -!=j,r;i..:
J:op
,'-^: ^^t iie.:c1--l
1
s its i nCexe s f rcin = o n j e c t _ i c j ( ' I ' I O I I I T O R ') wh-ore ii name = 'KEC l'1Ol'IFK' anci in,lid > 0 an,i < 255) indid a:]d i'iC:'IITCR. i'JC-i'lOlI-FK irdex
a3 rf
=xisis
iseiecl 1 sysindexes frc:n = o b j e c t - i d ( ' I ' { O } ' I I T O R)' i+here id 'TliN MON Fti' = nane ani indid.'0 ani indirt < 2-55) an.i j -.,ie:< '.'rr;:J f f)F:. TfilI l.iol{ FK
/
from sysindexes = object_id('PENDERITA') where id name : 'PUSKESI'AS PENDERITA-FKI and ' ii'rdid > 0 and indid < 255) and index PENDERITA.PUSKESMAS-PENDERITA-FK
drop
.if
(seIecL I from sYsindexes = object-id('PENDERITA') id where name = 'THN-PENDERITA-FKI and indid > 0 and indid < 255) and THI-PENDERITA-FK PENDERITA. index
exisEs
circp
if
exists
drop
LL
(select 1 sYsindexes from = obiect- i d ( I P E N G G U N A I ) id where = TLOGIN F K ' nalne and > 0 indid and irldid < 255) and index PENGGUNA.LOGIN-FK
exists
drop
rf
(select 1 sYsindexes from = o b j e c t - i d ( ' P U S K E S M A S)' where id name = 'MASUK DLM FKI and indid > 0 and indid < 255) aud j-ndex PUSKESMAS.I'IASUK-DLI'1 FK
exists
drop
if
exists
if
- - - :
- !
gxfSLi
(select 1 sYsindexes from = object_id('TARGET') id where name = 'PUS-TARGET-FK' and indid > 0 and indid < 255) and index TARGET.PUS-TARGET-FK
(select 1 from sYsindexes = o b j e c t _ i d ( T T A R G E T)' id where na.ine = rTHN-TIIR.GET-FK' an,J indid > 0 and i-ndi-d ': 255) and inciex TFS.GET.TIiN-TARGET-FK
-
I
- ^ 1
^ - L
r.-)ETEL
frc'r
'';here i,l-:,j
L
r
s:,.sobjects
; ' - t = r . r l 1 j e ' : t - l r : l { r f - ; R I - l P )r i,,.'l::e = t U' )
':'ircc tabie
GRi;P
\ . v
j i
5 i
i--. ^-t :.rFirt.r-
-!^--: .-.Yr.i.5t t
f rc,m -,.jhere and -nn ,-r u|v'}/
p
fL ' J:hl v4-
1 r
sysobj ects i rJ = ob j ect_id t!'Pe = 'U')
( 'KECAi'1ATAN')
KF.CAi"iATAii r'.L
cLr ir
cvi':!:r
iSr:leiL f rnm
where i ah I e
ae l- q
ici = cbject_id rll! v
--
!..-^ LyPE
--l ott\)
;. r ! -,^.n ' / t ,
i q'.rqn)'ri
( ' l , I O I \ i I T O R) '
\ I
l4Oi.iI Tr.-)P.
qc i:
:t
er":isIS iseiect i f rorn 5 y-solrj ec t s where rd = ob j ect-id and lype = 'U') ,j:,-.c taL.Ie PnliDrF]i TA
-..,i^r-
1
,'-^l^-| f
( | F E I ' I I I E R I T A )T
rnn
crrcnh-i
e ) o v ^ ' ) v v v v
oe
|
<
!i'h-sre id = object t'y-Pe= 'U') and ri::op ia.b 1e PEi'jG/-;I-n'IA
id (r PEI'iGGU}'IA')
a'l; :f
er-isis
'- i- r n -nY
(seiect from w5ere and
!-rirl a
i sysobjects )' id = obj ecE id ( 'PUSKESI"IAS ' U ' ) t!'Pe =
PUSKiSI,!A-c
go ii
i
e'ri<:<
i
f rc'm s'ysobj ects wi-,Pr€ ij = ohlect-icl t YTe = 'tI' ) an.l rl . i rLn'n' , t ,
1 -: h l , r
i ' T A H l n ' I )'
TA.H[_il\j
q'.)
ir
nvi*i.r
iqcle,-l-
I
fron sysobjecEs ,...'i:.eie i.l = ,:b j ect_id and L - v p e= ' U ' ) :A
( 'TA-B,GET')
i
9o .,J
----=======================
-------
,/-'i aCie: - ='::-:--== i ,l .'1r.-r-rI ,3 .---t':t
1 ;i-,
==========*
l'rr:l.ir ==:==:====* i e
i-:--:l-l ?
/
*/
i -g.1;r_.11a1 (-ir_i i
il,')t
llLlil,
/
1rar.i,ar (100 ) l.ll,Tll...r.)lG.r.l] ( G F I T I )F l:eyc.t,.irsrr; i ni Fi'. GFrilF prinary
nlt i I ,
c^
= _ . _ , , ., *_/_ , ,/-
T,',1;l-e:
:.ia-:to
*/
i1.:CAl"lA1'Aii ===k
lrirlp
KEf-nL4ATnld
i
varcllal (-io) :'l 5:::ir r,-archar (100) i..nTnF3]icF-l.i pit KEC.aJ.lr^TFli p.riL".ary l:e)' :::.=traint
r i1 !--
:.i i-::iiT RTI r-qaaRii
iliLii
rrarr']rrr
I I U I I ,
inl-
at ^ - ! ) itt4t-
A-iii"i3i_IH
al^-! L LIlA
tr.-'t ttuflr r r ot n u l - I , -,,1
int :nt int ini int
r
/iflj
Iiot llulr' null, (NI_I'iC}.'[T)
L
1
n u l -I , nltl I, nuIf, nrll-f , nri11, n u l _1 , nul ],
/
:=a,r3
!F\i:iFlal
ra
I
not nul1, not nul l, nlll1, n,tt nul l , not nul I ' llot null, not nu]1, !1ot nul.l t Irot Ilu] I ' Ilot IluII, rrot nulf, not null, nu l l-,
int \-aF:Er:
nilii'ie r i c
'riii,F:
varchar (20) datet ime varchar (25)
FG
r:rrr'hat-{l}
numerlc (2 ) v a r c h a r ( 5 0) rlrf
I l . t , i L r , : . A : L l < A I
TIF,E
f 50i
^ ;
-
e
|
1
\
r^!^+.i-^
:l-:.t:tfl
F/-' f':"l,sT i irNLrl.if\D!r!z
rr1
rr-? r\??1,-T i!:LL:ini!l'j4
rl.
varchar (20 ) datet ime varchar (20) datet ime varchar (20) datetim.e
n^r ..r'rrnr rrt rf:n -) I UirL DL.I\
r_'!j-:i:\i:.lji'i
i
intr:
bi. r
-A-5.U
5.ir-A-:'f
ct
r,'::r'lrl'
r.iTF.IS l:.iFli
I
_\:,tj-nHt,t.Js
rr.rr'-lrrrf,)f))
I u!L'I1ltll1l!
r,'arcllar (2 0 ) ci^ Le tirp.e dateL irne
j. .Y,
11J gl-'115-':-IJ1.L j,.\irqKH
rr: rrh:
X
I kr:Hs
i :--il-i.il1t:u5.a
c-nsaraini
llurr,
nu11, nuIl, nul1, nu] 1, l)u1f, rlul l- , ltul l- , nul- -L, null, nul-l-, nu11, nuI l, (TiiN, NOREG)
r | ? O')
varchar (30) c!al,--tlme l Fi.. PEi;irEFiT.q pri marY' iiey I
= = = = = = = = = =/ *
/ - -=-=-== i t
*/
L:rde-v-: TiiN-PEliigF.lTA-'trK
============================* /
/ *:======
]N'JEY. THI'TFENDERITA F'K C)I] PENDER]TA (
CrEA:E T::I; 3a
,+ j n,jex :
pr_rSIiEliirv\li pENt)ERI TA FK
in,iex .l c.rLe :.:r'.i!r,-lLr::
j
-
Tai:ie:
. r-r:i to
t;hi
PEI.IGGT-j1'IA r' PEiii:Gltlil
/
==========*/
======:== i i.' -t ._'.-ia _.'r- i ) i-; '
:-
rr:i!'Cl,r:1 r'i-lal)
r:
\
*/
,'. - -- J
1-:' :
===========--=======
===========================================
,''
-
:rU-cii3-slii{-cFEI{I)ERITA t'K on PEI'II)ERITA (
' , ' . 1 i , _ . i r . _ r l i i i , !l
l - i ' : , t t r r - l ll , l'r,:'t nll 11, iiLlf f ,
nttIl, null-, nu1f, null, ( I t)r-lsER )
varchar (50 ) };.+.';1;SER varchar (20) iq.lpits varchar (15) ijTP varchar ( 100 ) *-5i;i,a;;i;.aji -PF:ptIVGGI-Ii'iA pr:ima::y key ,_-irn::i1,3 i n1)
/ + i:rdex:
LoGIIJ
FK =:======--::=======-=========*
t-------
/
/
iNCiCX LOGI^\ FK ON PENGGUNA (
CICATE ,i a
.:n
Talrl- e : L! F- g
!=
PLI-q^Y'ESi'1AS
r_ai_rl_e
gus\i-!!v\L:.J\i
( lrarr-lrrr
:i.L1.':-r_PLrs l; i:CtT
t?ll)
-j--i:1r
rrarnh:r{?O'l -r() rr: rrh: r / l
R-nilFE,alq
trrrah:r
J5;+.Ti F c-nsi:raint
iai I
/ 5l
primary P I . . PI_TSi:ESiiAS
I:ey
rrot nullt n u 1L , nul- l- , nuIf, nriI1, (l'TAl.{APtiS)
r-:1:r
n4ASIIi: f)U'l
r'rrriev:
ciea:e :; i.:A-!T
in.lex
FK
MASLTKDLf4 FK on PUSKESMAS (
t. =--==-==:==*
1 - =======
i * Tabie:
TAIiT-]}J
r)oL nul.l-,
::r-:,1
.t-nt
:t:l:,r:i;.q
]-nL
.-!.rir
flrra|
(lil
-tD
f l.r:f
f r 1I
t:,ll.iiE3.S 7 .:i.!i,FENl i.,ilil.:L.f,.H'i F: iilPi.l,-i.a,TT
f.ioai ('i ) nllmeri c nrline r I c nunerlc
=,-r--r,.'i1l-
, : , : , n s c r ; 1i n t
:
^,,11
null-, IIUAI,
nll 11, nlt I l, nlt11, n r 1 11 ,
I - t ] l l ' ] ,t ]r - f i c
-iK TAHt.lt'J f,rimary
key
(THt'l)
/
a
================================:----
:------
i
.u- Tabie:
----s
_
TA-I'IGET ==:=====:=*
- ==:--===
t'
l
!
*/ /
T,\CGET (
rlr-€ite table j-:rt T-ii (2 0 ) varchar ii.F;V.PLiS cirar { I ) i.iTICCRi flc.at TSEI11 I l - o aE ::F1..12 fLoat TSEI!3 fl':at TStrl.l-.: f l-oat TSEl.fTii\primary' 1:-'y TF.F:GET PF. c,:,nsi:raini:
t r r - , i -n U f l , l)ot nul-f ' noL nulf , llul-L, IluI I, null, nrlll, nul l, (THl'I, t'IAl'tAPIlS, KATEGORI)
I
i*
Tiil\ TARGIT FK
ladex-:
c:eate
in'-iex
THti Ti3.GtrT
=::===::::* Fli crlr TAiIGET
/
(
: :ii
CO
a l-ter tai-.1e l-fONITOR }.{Ol.li{ECAtIF.TAfcreign Fi:_}.{CtIITOF._KEC a.j ccn.s:raint (N i..Ct'tT) tiECAi.LqTAN ref_orences
}:ey (N-KCI4T)
C-r
i-lOiiITCii. iabie ai'Ler fK_I-iOi.IiTCR._THN l,lci'l TAHUi'I foreigu a,j,j c,il:sll'aj-rlrf TAJiUN (THll) re erences :a
-:.cF
1-?.te
IP..t
(THN)
key
trL5,:ljf-
ac.:i ccn.;i:raint re ferences
PUSI{ESI'IAforeign F?i_PEI.IDEP.IT_PUSKESI{AS (I{AI'IAPI15 ) PIiSi':ESI'1AS
}:ey (NAMAPUS )
.'t l
a', 1€-t i;ili e ii.iiirli: rrA .,:-i'-,,:::^:!--..1-:-r- I::.3''liiiriF-iT
THii i)i-liji-jl'ih''ii-ii'J frJrei'-fu
key
(THI'J)
references
TAliiill (THN)
a irer tal-rie PEI.IGGIJNA ar1,l consirai.nt F K P E N G ( j r - i t JLAC ) G I N G R U p f o r e i g n r e f e r e n c e s G R L T P( G R L r p ) (]c
(cRUp)
key
ai-ter tabLe PLTSKESMA-q aiii consr-raint i"F: PLTSKESI{A IIASUK DLI.{ KECA},IATAforeicrn
references KTcAl.{Ai*- fif*odl-
aiter table TARGET A.Id CCNSITAj.NI FK TAP.GETPIJS TARGE PLISKESMAforeign ref erences PLISKE-qI"!\-S(IIAI'IAPU-S )
alter tabl-e T.EF.GET a.Cd constraint EK T-IRGET THN TARGE TAHUN foreign references fafft-rN (THNI 9.
key
}:ev (N \"- KCMT)
Key (NAMAPUS)
(THN)
: lol
:
FE
I
tt
j
I
!
t
I
i! o I
t
z F-'l -t
iil '!
E-i \, /^, FI
p
dd
;ddi
!
AA l-{
E I
\l-
o
t
FA
lr
F
I I
rl.
frl
F
V)
FT () r-'1
&. l-t
I IIIi! E
E
I irlll
!
9
I I
T L:rnptnn 135 PROCRAM TB NASIONAL
Untuk Penderite Terdeftar Delem Tehun Ttiwulan dd................) (buhn
LAPORAN TRTWI.'LAI{ PEI\TEIIIUAI\I(ASUS BARU DAI\ KAMBUH Propinsi Kabupatca/Kota Nornor Kodc Kebqetct/Kota Jurnlah hskesmas peldcsaru DOTS
:
Jumlah suspekyang dipcnksa
BTA ncgatif dengan Ro.pcitif (3)
TB Peru BTA Positif Karnbuh (2)
KesusBaru (l)
L
P
T
P
L
L
P
TB Etstta Prru (4) T
L
Total (5)-
T
P
P
L
Totrl
Perincian Kclompok Umur (tahun) dari pcn&rita Banf BTA Pocitif Blok 2
0-14
L
P
ts -24 L
P
25-t4 P L
3 5- 4 P L
Jumlalr L P drn T padakolom I dari BLOK I hrnr samadcngan L. P dan JumlahpadeTOTAL dari BLOK 2.
45-54 L P
5 5. 6 5 P L
T
>65 L
?
L
P
Jumlah
Kolom(l): KasurBanrBTA (+)'pcndcria TB Prru dcngenBTA (+) ymg bclum mcndapat OAT atau sudahteupi kunng dari I bulen
Elok l: Scmuapendcda yang tcrdrftrr dalamtrirnrlan.
Kolom (2): PenderitadcnganTB PanrBTA pocitif yang alah dinptrkan Scrnbtrh(BTA ttclstif) taryi sckrang sakitlagi (BTA positi$
Blok 2: henyr dari pcnderitaBrru BTA Positif.
Kolom (3): BTA Ncg/Ro Positif
Tri*ulan: scsuaitahrm rnggaran-
Kolom (4): TB EkstraParu= PendcriteTB orgur lain diluar paru.
IUcngelahui :
YangMembuatLaporan:
i:'*,ffl - -drLut{
iFs "Eits -
c
E
863
!
8.
g
s6
o0
o
E e
5
E a,
E
E
oo
gtr
al
EO
z
Or
€/i
a 4
€
6
a
s
4)
EO
S<- l E
c
r
€ e
Hs.a Erct 6.= !L
\C' 6 €
iC6 - *
{
-{
=9
EZ E < 9F
qe
t{F
O. r.
=z
€ ]
q<
s
e:i
lta
i)
'=Elt gE{
E€E
!E;
q
€Fg E 5
al
";" o
t
:z \ D V 9L
o.o3
6:4 5 =98
c.' i-t
3*{ w
.c'EE €oGl
vzz
=
E
c a, oo c t,
oo c 3
! U
& F
=ar
:82
.E t=tr
ii=!9
AE E. E
= g -. tv.F! ! . E d
faoa
&E
E = e
z