Queries

Modul 11: System Queries

iSIKHNAS allows users in the field to query information from system. It is possible to query system-based static data such as message formats and codes as well as submitted data such as case reports and farmer herd lists, for example.

Message formats

It is easy to forget the exact format of a message if you haven't used it frequently. Users should just send the start code of the message to iSIKHNAS and the system will send a return SMS with the correct message format. Here is an example

U

The system replies

U [sign,sign...] [species] [number of animals] {location} {differential diagnosis,differential diagnosis...}

This will help you to send an accurate message to the system using the correct format, such as

U MC,DM SP 5 COC,SAL

The reply for this message:

Terima kasih. [ID kasus 2352] Anda telah melaporkan 5 kasus mencret, demam pada sapi di DKI Jakarta, Jakarta Selatan, ... 
Ddx: koksidiosis, Salmonellosis

Location queries

Using the start code CKL with a freetext entry (of three or more letters) users can query the code for a location they know the name of. Here is an example;

CKL BOGOR

The system replies

Bogor: 3201; Bogor: 33100520; Bogor: 32122801; Bogor: 91051409; Kota Bogor: 3271; Kota Bogor Timur: 327102; Kota Bogor Selatan: 327101; Kota Bogor Utara: 327103; Kota Bogor Tengah: 327104; Kota Bogor Barat: 327105; Kampung Bogor: 17080608; Babakan Bogor: 17080507; Bogo: 35181407; Bogo: 35221...

This reply shows that there are many locations with the name "Bogor". Remember: Village level location codes are eight digits long. The first 2 represent the province, the following 2 the kabupaten, then 2 for kecematan, and the final 2 for village. Most staff will come to learn their relevant province, district and kecematan codes quickly so it will become a quick and easy process. 3201 is the district Bogor in Jawa Barat, 3270 is district Kota Bogor in Jawa Barat ...

• CKL: Cari Kode lokasi : Query Location codes using freetext
• DKL: Daftar Kode lokasi : Desa code report using kabupaten codes

Kode-kode sistem : System Code Queries

• KODE: Code list query
• CKL: Cari Kode Lokasi : Location code query using freetext
• CKO: Cari Kode Obat : Drug code query using freetext
• CKT: Cari Kode Tanda : Signs code query using freetext
• CKP: Cari Kode Penyakit : Disease code query using freetext
• CKJS: Cari Kode Jenis Specimen : Search a specimen type code using freetext
• CKI: Cari Kode Infrastruktura : Search an infrastructure code in a location
• DKB: Daftar Kode Bangsa : List a breed type within a species

Pertanyaan laporan lapangan : Field report queries

• LAPD: Laporan Desa : Village Case List query
• LAPK: Laporan Kasus : Case Report query

Laporan Kegiatan khusus : Special purpose queries

• LAPSK: Query movements to and from a location

There will probably be more queries of this type developed in the future.

ID Hewan dan produksi : Animal ID and Breeding queries

• DHP: Owner herd list
• IH: Individual animal report

Pertanyaan freetext : Freetext query

• Q: Freetext question or feedback

Training materials

• Manual for System Queries