TANOD KONTRACOVID (TKC) TRAINING

Outline of Presentation
I. History of TKC
II. Data Components of TKC
a. CDRS (RTPCR)
b. Linelist (Antigen)
III. TKC Account Features for ESU and Sentinel Sites
IV. Steps on how to use the system
a. Creation / Registration of Account
- Certificate of Training
- Non-Disclosure Agreement (NDCA)
V. TKC Features
a. Case Management
b. eCIF
c. Data Management (Linelist)
d. Uploading of Linelist
- Notification, Error Handling, Duplicates, Updating
e. Extraction of Linelist
History of TKC
 How did Kira KontraCOVID and TanodCOVID evolve as “TanodKontraCOVID or TKC?”

Kira KontraCOVID TanodCOVID

✔ March: First prototype and proposal submission ✔ March: Derivative of Project eBayanihan, pivoted for COVID-19
✔ Development is closely guided by DOH KMITS and HPCS ✔ Component in the FASSSTER Platform to address need for
✔ April: Signed MOA and press release of launch by DOH, included symptoms tracking from citizens; supported by DOST-PCHRD
Phase I and II development for LGU portal ✔ April-May: Launched and supported by IATF resolution #36 and
#38; JMC 2020-01; official SMS channel for citizen reporting in IATF
✔ Supported by development sector and tech community
Unified COVID Architecture
✔ June: Introduced to the IATF-ICT COVID-19 architecture

TanodKontraCOVID or TKC

In June 2020, the IATF-ICT sTWG conducted pilot implementation activities of the COVID-19 applications for donation which led to the deduplication
and merging of the two platforms into one “TKC”. Kira (chatbot) + Tanod (sms) + Kontracovid (data management portal)

- Public reference of this merging was published in the DOST-PCHRD annual report 2020
- Other names such as Kira, KontraCOVID, TanodCOVID, Kira-Tanod KontraCOVID all refer to the TKC system
- The official system url is kontracovid.ph it can also be accessed in tkc.doh.gov.ph, email via kira@doh.gov.ph
 Inclusive and accessible touchpoints Access to lab results and smooth
through self-reporting technologies integration to existing internal processes

Self-Reporting ESU + DRU + Labs

SMS WEB ACCESS LAB UPLOAD ENCODE

CHAT
RESULTS LINELIST CIF

Verify and update

information

Case monitoring ️️✔️Access Lab Results when there’s a new lab

️️✔️Online: Report via DOH messenger,
result in your LGU
viber, or kontracovid.ph
Contact tracing
️️✔️Upload Linelist send SMS for health checks to
suspect/probable cases
️️✔️Offline or no load? REG J.P.
Report via SMS Rizal St.
️️✔️Encode CIF listen to your citizens, ensure
Makati
Globe users: 2158 5779 quality service
City, 4
Non-Globe: 225 655 779
Data Components of TKC
• CDRS is used for the
reporting of RTPCR
Results. CDRS
Linelist
• It is used by the
laboratories.
TANOD
KONTA
COVID
• Antigen Reporting is via (TKC)
Google Sheet.
Antige
• It is used by the PESUs, n
MESUs, hospitals, and
laboratories. Linelist
CDRS Linelist Uploading to
TKC
• CDRS will still be used for the reporting of RTPCR Results.
• Updates on the regarding the uploading process to TKC is to be announced by
the developer.
TKC Account Features for
ESU and Sentinel Sites
 Sentinel Sites/Hospitals

● Given a unique TKC Sentinel Account with the following features only:
○ Upload Linelist
○ Manual Encoding
○ Updating/Viewing access to TKC
○ Only cases encoded and uploaded by the sentinel sites will appear in their
case management.
○ Submit nothing to report.
● Once linelist is uploaded, TKC will automatically notify* and disseminate it to your
respective Region/Province/City/Barangay
 Epidemiology and Surveillance Unit

● Given a TKC account with the following features only:

○ Upload Linelist
○ Manual Encoding
○ Updating/Viewing access to TKC
● Receive notification when any sentinel site uploads cases that are within their
jurisdiction
● Ensure that case details of the uploaded cases by sentinel sites are complete; ESUs
shall update details as needed.
Steps on How to Use the
System
Creation of Account
Demo Site

Kindly visit:
bit.ly/TKCTest
Create your account!
How to register?
Register and attach
Certificate of Training and
NDCA

tkc.doh.gov.ph/auth/register
or
kontracovid.ph
Website
How to register?
Confirm your email and wait
for account activation

After email confirmation,

account managers will review
your submitted files and
activate your account within 24
hrs
TKC Test Account Credentials

Kindly visit:
bit.ly/TKCAccounts
TKC Features
Case Management
Features
Case Management

Add filter Notification (bell icon)

Linelist action:
● Upload Linelist
● Export Linelist
● Nothing to report
● View Linelist
Progress

View case/update case

Different ‘search by’ Download case as CIF file

options
Create eCIF

Duplicate checker
Create eCIF (Encode)
 Create eCIF Module

2 ● You can create e-CIF record that

follows the minimum data fields
for COVID-19 systems
according to DOH Department
Memorandum No. 2020-0436

● TKC eCIF is using the CIF v9

View/Update Case

View/Update eCIF
● An editable eCIF window will
appear and display Case Details of
the patient.

Download CIF PDF

● To download patient eCIF record as
a CIF PDF.
 Notification of Location Changes
RESUs will receive a notification when another RESUs assign a case/record to them.
Duplicate Checker (show possible duplicates)
● Name + Bday + Sex
○ First Name + Last Name + Middle
name (if available) + Birth date +
Sex
● Name + Bday + Mobile#
○ First Name + Last Name + Middle
name (if available) + Birth date +
Mobile number
● Mobile number only
○ Mobile Number

● Trigrams: FN, LN, MN

○ First Name + Last Name + Middle
name (if available) + Suffix (if
available) (using trigram matching
with 0.3 threshold)
● Duplicate Error!
○ An error will be displayed if we
encode existing case.
Data Management
(Linelist)
Templates and Fields

Access at: bit.ly/TKCTemplateVersion3

(File → Download → Excel)
Templates and Fields
 Templates and Fields

The template is divided into six groups:

Outcome and
Signs and Exposure
Registration Health Status
Symptoms History
Details

Lab Result Vaccination

Details* Information*
 Templates and Fields

Summary
- Headers and column names should not be changed
- Values for most fields should follow defined values only (e.g. true/false fields,
nationality)
- Location fields should be in PSG codes
- Lab results and Vaccine columns can contain multiple values. If multiple, all related
columns with values should have double colon separator (regardless if value is
available or not)
Steps in Uploading
the TKC Linelist
 Uploading the TKC Linelist: Steps

1. Log-in to TKC and go to “Case Management”

2. Click “Linelist Actions” and “Upload Linelist”
 Uploading the TKC Linelist: Steps

3. Add a unique name for the linelist

for the shortcode and name fields

Suggested format:
[Hospital]_linelist_YYYYMMDD

4. Click “Browse” and choose CSV

file

5. Confirm two checkboxes:

- Uploaded reports are verified
- Create TKC records
 Uploading the TKC Linelist: Steps

6. Check linelist upload progress through:

- Bell icon (upper right) or
- Linelist Actions → View Linelist Progress

7. Click the uploaded linelist to check if successful;

three possible results:
- “Linelist - Import Successful”
- “Linelist - Imported, with skipped rows”
- “Linelist - Import Duplicates”
 Uploading the TKC Linelist: Steps

8. To view TKC records

(if “Linelist - Import Successful”):
- Click linelist name; or
- Search linelist name in “Short
Code”
 Uploading the TKC Linelist: Steps

8. To view TKC records

(if “Linelist - Import Successful”):
- Click linelist name; or
- Search linelist name in “Short
Code”
Uploading the TKC Linelist:
Notification when Sentinel
Site Upload.
 Notification when Sentinel Sites upload Linelist

- RESU will be notified when a sentinel site uploaded a linelist.

Uploading the TKC Linelist:
Error Handling
 Uploading the TKC Linelist: Error Handling

1 To view errors:
1. Click Linelist Actions → View Linelist Progress
2. Find uploaded linelist name and click X icon to check errors
3. Check row number and column header name

3
 Uploading the TKC Linelist: Error Handling (Common Errors)

1. Error: Null/Empty
Cause: Required field but no value was added
Resolution: Check row number and column then input required value
 Uploading the TKC Linelist: Error Handling (Common Errors)

2. Error: Invalid Date Provided / “values must be valid dates”

Cause: Date format is not a date or not in MM/DD/YYYY format
Resolution: Check row number and column then check date format
 Uploading the TKC Linelist: Error Handling (Common Errors)

3. Error: (column name) is invalid / Invalid Multiple (column name)

Cause: Input is not part of accepted values
Resolution: Check row number and column then check value if in accepted
values
 Uploading the TKC Linelist: Error Handling (Common Errors)

4. Error: The selected current address (column name) psgc is invalid

Cause: PSGC does not follow TKC PSGC format or input is not valid
Resolution: Check row number and column then update to TKC PSGC
format or check if PSGC value is valid
 Uploading the TKC Linelist: Error Handling (Common Errors)

5. Error: (column name) doesn’t match count of (column name).

See (column name)
Cause: For lab result and vaccine columns, if result / vaccine is more than one,
related columns should have double colon separator “::”
Resolution: Check row number and column then check values if all related
columns have the double colon separator “::”
Uploading the TKC Linelist:
Duplicates
 Uploading the TKC Linelist: Duplicate Handling

Three possible actions for duplicates:

1. Import: Use import if new case is different and not a duplicate (two rows - old and new)
2. Update: Use update if the newly uploaded case will be used instead of old (one row - new)
3. Ignore: Use ignore if the newly uploaded case will not be used (one row - old)
TKC Linelist
Extraction
 TKC Linelist Extraction

1. In “Case Management”, click “Linelist Actions” then “Export

Linelist”
2. We can also filter the case management before exporting, to extract
specific case.
3. Enter a name for the linelist and always select “CSV” as file format.
4. Click “Proceed Exporting” and wait for the download to finish.
Batch Updating via
Linelist Upload
 Batch Updating via Linelist Upload
Steps:
1. Export cases need’s to batch update
2. Update the exported linelist Important!
3. Upload the updated linelist back to TKC For batch updating of cases using
4. Wait for the upload to finish import linelist, it is important not to
5. Click the notification bell icon and open the linelist to show change the TKC_ID. Changing
successfully updated cases. TKC_ID will overwrite an existing
case with the same TKC_ID.
Sample linelist: bit.ly/TKCTemplateVersion3
 TKC Reporting: 2 ways to create records
1. Using ‘create eCIF’ 2. Using linelist upload
- One record - CSV Bulk upload
(bit.ly/TKCTemplateVersion3)
 TKC Reporting: 2 ways to create records

1. Using ‘create eCIF’ 2. Using linelist upload

- Use of PSG codes
Spreadsheet Tips:
● Excel
● Google sheet
 Spreadsheet Tips: Dropdown Values

To create cells with dropdown values in Excel:

- Highlight Cells
- Data → Data Validation
- Select List
- Input values
 Spreadsheet Tips: Dropdown Values

To create cells with dropdown values in Google Sheet:

- Highlight Cells
- Data → Data Validation
- Select List of Items
- Input values
 Spreadsheet Tips: Formatting

To force text format in Google Sheet:

- Highlight Cells
- Format → Number → Plain Text
 Spreadsheet Tips: Formatting

To force text format in Excel:

- Highlight Cells
- Home → Number → Text
Thank you!
ACTIVITY (Linelist
Upload)
 Activity (Linelist Upload)
Two case 1 asymptomatic & 1 symptomatic.

Symptomatic Asymptomatic
● Personal details (Name, address, birthday, gender, nationality, ● Personal details (Name, address, birthday, gender, nationality,
cellphone & telephone number, email address) (users define) cellphone & telephone number, email address) (users define)
● Signs and Symptoms (users define) ● Exposure History (Health care worker)
● Exposure History (Health care worker) ● Lab results
● Lab results ○ First Test
○ First Test ■ Cartridge
■ Antigen ■ Positive
■ Positive ■ Date collected, received and released. Lab name
■ KIT Brand (FUJIFILM COVID-19 Ag Test or choose and specimen ID (users define)
your own) ○ Second Test
■ Reason for test (GIDA,suspect,travel requirement) ■ RTPCR
■ Date collected, received and released. Lab name ■ Positive
and specimen ID (users define) ■ Date collected, received and released. Lab name
○ Second Test and specimen ID (users define)
■ RTPCR ● Outcome and Health Status
■ Negative ○ Admitted (Hospital)
■ Date collected, received and released. Lab name ○ Quarantine Status (users define)
and specimen ID (users define) ○ Date admitted & discharged (users define)
● Outcome and Health Status ○ Health Status (users define)
○ Admitted (Hospital) ○ Sentinel Site (users define)
○ Quarantine Status (users define) ○ Case Assessment (users define)
○ Date admitted & discharged (users define) ○ Outcome (users define)
○ Health Status (users define) ● Vaccination
○ Sentinel Site (users define) ○ First and second dose vaccinated (users define)
○ Case Assessment (users define)
○ Outcome (users define)
● Vaccination
○ First and second dose vaccinated (users define)