@extends('layouts.app') @push('styles') @endpush @section('content')
Reference page for M&E users: export documentation, data dictionary, and practical user guidance for routine reporting and data review.
Reception is the first point where clinic data becomes usable. The reception user checks whether the person already exists, registers new patients, records each visit, saves diagnosis and service data, and prepares appointment or follow-up lists for the next clinic action.
Use this flow as the normal working order when a patient arrives at the clinic.
Open Add New / Follow Up, use Next ID, complete registration fields, then save the registration and first visit.
Search by General ID or Fuchia ID, confirm the displayed patient details, then save the follow-up visit.
Open Diagnosis Data, search the patient, set visit date and next appointment, choose diagnosis/service data, then save.
Use Search to Update or Follow Up History, open the target row, adjust the values, and press Update.
Use Next Appointment List to find patients due on a selected date and review planned or unplanned visit status.
Use Export or QR Export only after checking patient identity, visit date, and required service fields.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| General ID / PID | Add New / Follow Up, Diagnosis Data, Follow Up History | Main patient ID used to search, register, save visits, and review history. |
| Fuchia ID | ID search and diagnosis sections | Alternative patient identifier. Useful when the General ID is not known. |
| Clinic Code | Add New / Follow Up | Clinic/site where the patient is registered or where the visit is recorded. |
| Peer Code | Add New / Follow Up | Peer or outreach code linked with the patient, when applicable. |
| Registration Date | Patient registration fields | Date the patient was first registered in reception data. |
| Visit Date | Add New / Follow Up, Diagnosis Data, Update | Date of the clinic contact. This is important for reports and follow-up history. |
| Current MD | Add New / Follow Up and Diagnosis Data | Current medical provider or MD initial connected with the visit. |
| Follow-up MD | Diagnosis Data and Update | Provider assigned for follow-up or next clinical action. |
| Main Risk / Sub Risk | Patient registration fields | Risk-category classification used for program reporting and data filtering. |
| Online Reach | Add New / Follow Up | Source/channel for online reach information, such as Prevent Yangon, SHE, Helping Hand, or other. |
| Next Appointment Date / Time | Diagnosis Data and Update | Planned return date and time. Use the days field when the system should calculate the appointment date. |
| Service Checkboxes | Diagnosis Data and Update | Service areas such as ART, PrEP, PMTCT, NCD, ANC, family planning, cervical cancer, feeding center, general, lab investigation, and related diagnosis fields. |
Dispensing connects the clinic visit to medicine use. The user searches the patient, records the medicine issued on the visit date, checks available stock, and maintains the medicine item list so consumption and stock reports stay reliable.
Use this working order when recording medicine for a clinic patient.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| General ID / Fuchia ID | Daily Consumption and To Edit | Patient identifier used to find the correct patient before saving or updating medicine consumption. |
| Nurse Name | Daily Consumption | Clinic staff name connected with the dispensing entry. |
| Visit Date | Daily Consumption | Date the patient received the medicine. This date drives consumption reporting. |
| Clinic Code | Daily Consumption | Clinic/site where the medicine was issued. |
| Medicine Name | Daily Consumption, Stock, Medical Item Add | Medicine item selected for issue, stock checking, or item-list maintenance. |
| Quantity | Daily Consumption and Stock update controls | Number of units issued or added. Quantity must be checked against available stock. |
| Stock | Stock and medicine selection area | Current remaining balance for the selected medicine item. |
| Expiry Date / Arrival Date | Stock add controls | Dates used when adding stock information for a medicine item. |
Lab documentation has two related entry points. Clinic Lab records the routine clinic test results for a patient visit. Office Lab records biochemistry and HIV confirmation testing, usually with clinic selection, specimen date, result entry, print, history, and export actions.
Use Clinic Lab when the clinic team records service-level laboratory results for a patient visit. Start with visit date and patient ID, confirm patient details, then enter the test result in the correct test tab.
Use Office Lab for office-based Biochemistry and HIV Confirmation records. It includes clinic target, specimen collected date, General/NAP-ID, Fuchia ID, patient profile fields, requested doctor, counsellor, print, history, and export.
The safest workflow is to identify the patient first, select the correct lab page, then enter only the test result for the selected test tab.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Visit Date | Clinic Lab | Date the clinic test is connected to the patient visit. |
| Specimen Collected Date | Office Lab | Date the office lab specimen was collected. Use this for office lab result tracking. |
| Patient ID / General ID / NAP-ID | Clinic Lab and Office Lab | Main identifier used to search the patient and connect results to the correct record. |
| Fuchia ID | Office Lab and print output | Secondary identifier used for patient matching and printed laboratory result forms. |
| Requested Doctor | Clinic Lab and Office Lab | Doctor or MD initial requesting the test. |
| Counsellor | Clinic Lab and Office Lab | Counsellor connected with the test workflow, when applicable. |
| Test Type | Test Records and Export | Selected lab category used to search, review, or export records. |
| Result Fields | Each test tab | Specific result values, such as HIV rapid test results, RPR result, urine findings, AFB result, or biochemistry numeric results. |
| Reference Value | Office Lab Biochemistry | Normal-range guide displayed beside biochemistry results. Review it before finalizing values. |
| Print Type | Clinic Lab print area | Chooses Clinic or Office print format before printing all available lab results. |
STI Entry records male and female STI visit data in one page. The user searches General ID and Visit Date, confirms the patient's sex and risk profile, completes the gender-specific symptom and examination sections, records diagnosis and treatment, then reviews history or exports male/female datasets.
Use the STI page as one connected workflow. The page changes visible sections based on the patient's recorded sex, and the save/update script sends the mapped male or female fields to the controller.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Clinic Code, General ID, Fuchia ID, Sex, Reg Year, Register Age, Current Age, Visit date | Patient identity and visit | Identifies the male STI record and links it to patient registration. Age and Fuchia ID are joined from patient configuration for export. Data format: General ID: number, length 10/11/12. Sex: Male/Female. Reg Year: YYYY. Age: number; month: 1-11. Visit date: DD-MM-YYYY in export. |
| First Visit, last_vis_within, about_clinic, Reason for Visit, Main Risk, Sub Risk | Visit history and source | Explains whether this is a first or follow-up STI contact, how the client reached the clinic, why the visit occurred, and which risk group applies. Data format: First Visit: 1=Yes, 2=No, 9=Missing. Last Visit: 1=Within 3 months, 2=>3 months ago, 9=Missing. About clinic: 1=From HE Team, 2=From Partner, 3=From Others, 4=Missing. Reason: 1=Symptomatic, 2=Screening/non-symptomatic, 3=Partner STI, 9=Missing. Risk: Code Book/list value. |
| urethral_disc, dysuria, genital_prut, genital_pain, genital_ulcer, pain, ulcer, prodromal_itch, vesicles, recurrent, last_episode, suspects_herpes, ing_lymph_node, unilateal, other_lymph_node, leg_ulcer, scrotal_swelling, td_ntd, gen_wart | Male symptoms | Patient-reported male symptoms and related duration/detail fields. These guide exam focus and presumptive diagnosis. Data format: Most symptom flags: 1=Yes, 2=No, 9=Missing. Duration/how-long fields: number of days or text. Pain: 1=Painful, 2=Painless, 9=Missing. Ulcer: 1=Single, 2=Multiple, 9=Missing. Unilateral/bilateral and tender/non-tender are selected coded values. |
| physical_exam, physical_exam_no_reason, urinated_wit_1h, discharge, discharge_milk, colour, erythema, blisters, gen_ulcer, esti_size, sing_multi, pain_full_less, herpes_suspect, inguinal_bubo, fluctant, tendr_ntender, oth_leg_inf, phy_genital_wart, crab_lice, scabies, gscrotal_swelling, estimated_siz, unilateal_bilateral, gtender_ntender, erythem, des_size, drawing_description | Male physical examination | Clinician-observed findings. These fields document objective signs and support diagnosis, treatment, and drawing-based lesion description. Data format: Exam done and findings: 1=Yes, 2=No, 9=Missing where coded. Colour: 1=Clear, 2=White, 3=Yellow, 4=Bloody, 5=Other, 9=Missing. Size/description/reason fields: free text or numeric size. Drawing description: free text. |
| tbl_treat_diagnosis_first_visit, epi_discharge, unprot_sex_new_part, genital_signs, previous_sti, previous_what, previous_when, prior_sti, prior_what, prior_when, prior_other_comment, presumptive_diag | Male diagnosis triggers and prior STI | Captures previous STI history and current diagnosis logic. New previous/prior fields are current app variables and are not fully represented in the old workbook. Data format: Trigger questions: 1=Yes, 2=No, 9=Missing. Previous/prior STI: Yes/No plus what/when text or date detail. Presumptive diagnosis: free text/list selected from diagnosis workflow. |
| pri_syphillis, sec_syphillis, chancroid, gen_herpes, gen_scabies, gud_other, Gonorhoea, non_gono_urethritis, non_gono_procti, trichomonas, genital_candidiosis, congenial_syphillis, latent_syphillis, molluscum_contag, bubos, othstd_genital_warts, ostd_other | Male STI diagnoses | Diagnosis checklist used to count STI syndromes and diagnosed conditions in exports and reports. Data format: Diagnosis flags: 1=Yes/selected, 2=No, 9=Missing where coded. Other diagnosis fields: free text when selected. |
| tre_azythro, acyclovir, clotrimazole, tre_podophyllin, tre_cefixim, tre_ciprofloxacin, tre_tinidazole, tre_fluconazole, tre_doxycycline, tre_ceftriaxone, tre_benz_pen, no_treat, al_Penicillin, al_sulfa, part_treat, condom_giv, counsel_disclosure, treatment_side_effect, tre_remarks, followup, clinician_name | Male treatment and counselling | Records medicines provided, contraindications/allergies, partner and condom counselling, side effects, remarks, follow-up plan, and clinician accountability. Data format: Treatment medicines and counselling fields: checkbox/service flags saved as 1 when selected, 0/2 when not selected depending on control, 9 where missing applies. Allergy/partner treatment/condom: Yes/No-style flags. Remarks/follow-up: text. Clinician: staff name/text. |
| demo_remarks, visit_type, visit_time, followup_visit, episode, other(please specify), beterial_vaginosis | Male legacy/export-only fields | Kept for backward compatibility with older STI male data. Review carefully before using for new reporting logic. Data format: Old data fields: mixed text or coded values. Some may be blank in the current UI. |
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Clinic Code, General ID, Fuchia ID, Sex, Reg Year, Register Age, Current Age, Visit date | Patient identity and visit | Identifies the female STI record and connects it to patient registration data used in export. Data format: General ID: number, length 10/11/12. Sex: Male/Female. Reg Year: YYYY. Age: number; month: 1-11. Visit date: DD-MM-YYYY in export. |
| first visit, last_vis_within, about_clinic, Reason for Visit, Main Risk, Sub Risk | Visit history and source | Describes the STI visit type, referral/source context, reason for visit, and risk classification. Data format: First Visit: 1=Yes, 2=No, 9=Missing. Last Visit: 1=Within 3 months, 2=>3 months ago, 9=Missing. About clinic: 1=From HE Team, 2=From Partner, 3=From Others, 4=Missing. Reason: 1=Symptomatic, 2=Screening/non-symptomatic, 3=Partner STI, 9=Missing. Risk: Code Book/list value. |
| abn_vaginal_disc, abn_vaginal_disc_long, linked_menstru, amount, colour, colour_oth, abn_veginal_odour, l_abn_pain, l_abon_pain_hl, fever, rec_terminate_preg, dyspareunia, oth_GI_sympt, dysuria, dysuria_hl | Female discharge and pain symptoms | Patient-reported vaginal discharge, lower abdominal pain, fever, dysuria, and related symptoms used for STI syndrome assessment. Data format: Most symptom flags: 1=Yes, 2=No, 9=Missing. Amount: 1=Abundant, 2/0=Normal where legacy data exists. Colour: 1=Clear, 2=White, 3=Yellow, 4=Bloody, 5=Other, 9=Missing. How-long fields: number of days/text. |
| gen_prutitus, gen_burn_pain, gen_ulcer, pain, ulcer, prodromal_itch, vesicles, recurrent, recurrent_last_episode, patient_suspects_herpes, inguinal_ln, unilateal_Bilateral, leg_ulcer_oth_inf, genital_warts | Female genital symptoms | Genital ulcer, itching, burning, herpes suspicion, lymph-node, and wart symptom set for female STI assessment. Data format: Yes/No/Missing coded fields. Pain: 1=Painful, 2=Painless, 9=Missing. Ulcer: 1=Single, 2=Multiple, 9=Missing. Laterality/tenderness: selected coded list values. Duration fields: number of days/text. |
| phy_exam_done, physical_exam_no_reason, washed_inside, vulvar_erythema, vulvar_odema, vaginal_discharge, vag_dis_amount, homogeneous, homogeneous_col, smell_without_KOH, vaginal_wall_injury, endocervical_mucopus, endocervical_colour, cerv_motion_tenderness, adnexal_tenderness, adnexal_enlargement, genital_blisters, genital_blisters_Location, gential_ulcer, gential_ulcerl, gent_ulcer_sm, gential_ulcer_pain, susp_herpes, inguinal_bubo, fluctuant, fluctuant_tender, oth_leg_infection, genital_wart, crab_lice, scablices, KOH_smell_test, pH_vagina, des_size, drawing_description | Female physical examination | Clinician-observed female exam findings, including updated endocervical and cervical motion tenderness variables from the current form. Data format: Exam/findings: Yes/No/Missing coded values where applicable. Colour/location/amount/tenderness: selected list values. pH: numeric/text. Location/size/drawing description: free text. |
| prev_STI, patient_genital_ulcer, patient_compl_low_abd, new_pat_past_3mont, part_compl_gential_sym, sworker, rg_score, risk, abn_yellow_disc, low_abd_pain, if_only_abnormal_abundant, unp_sex_new_clients, dysuria_risk_ass, partner_ulcer, high_rg_score, high_risk | Female risk assessment | Dynamic female risk-score section. The current JavaScript calculates risk values, so this group must be interpreted from the live form, not only the old Excel source. Data format: Risk questions: 1=Yes, 2=No, 9=Missing. Risk score: numeric. Risk/high_risk: Low Risk or High Risk. JS assigns points and calculates Low/High Risk from current answers. |
| pri_syphillis, Gonorhoea, congenial_syphillis, sec_syphillis, non_gono_urethritis, latent_syphillis, chancroid, non_gono_cervities, latent_syphillis_preg, gen_herpes, trichomonas, molluscum_contag, gen_scabies, genital_candidiosis, bubos, ostd_other, beterial_vaginosis, othstd_genital_warts, other_STD | Female STI diagnoses | Female diagnosis checklist used for STI condition reporting. Female export includes cervicitis, bacterial vaginosis, latent syphilis in pregnancy, and other female-specific diagnoses. Data format: Diagnosis flags: 1=Yes/selected, 2=No, 9=Missing where coded. Other diagnosis fields: free text when selected. |
| tre_azythro, acyclovir, tre_cefixim, tre_ciprofloxacin, tre_tinidazole, tre_fluconazole, tre_doxycycline, tre_ceftriaxone, tre_benz_pen, clotrimazole_vaginal_tab, clotrimazole, tre_podophyllin, no_treatment, al_Penicillin, al_sulfa, part_treat, condom_giv, counsel_disclosure, counsellor_sti_sign_symptom, counsel_vaginal, treatment_side_effect, tre_remarks, followup, clinician | Female treatment and counselling | Records medicines, allergies, partner treatment, condom provision, disclosure/sign-symptom/vaginal hygiene counselling, side effects, remarks, and follow-up plan. Data format: Treatment medicines and counselling fields: checkbox/service flags saved as 1 when selected, 0/2 when not selected depending on control, 9 where missing applies. Allergy/partner treatment/condom: Yes/No-style flags. Remarks/follow-up: text. Clinician: staff name/text. |
| visit_type, demo_remarks, episode, risk_cal_remark, pain_dur_sexual, gud_other, other_plz_specify, tre_Other | Female legacy/export-only fields | Kept for compatibility with old female STI data and older reporting outputs. Data format: Old data fields: mixed text or coded values. Some may be blank in the current UI. |
Cervical Cancer Screening records one connected visit workflow: patient search, reproductive readiness checks, HPV and breast screening, VIA screening and result confirmation, thermal ablation eligibility or treatment, referral, biopsy, gynaecologist management, and next appointment.
Use this order when completing the screening page. Conditional fields appear only when the related answer needs more detail.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Clinic Code, General ID, Fuchia ID, Main Risk, Sub Risk, Reg Year, Register Age, Current Age, Visit Date | Patient identity and visit | Identifies the patient, clinic, risk profile, age context, and exact screening visit used for export. Data format: Clinic/risk list values, General ID number, Fuchia ID text, year YYYY, age number, date DD-MM-YYYY. |
| HIV Status, Parity, UCG test date/result, HPV test, HPV not done reason, HPV test result | HIV, UCG, and HPV | Captures clinical readiness and HPV screening outcome before VIA/treatment decisions. Data format: HIV: Reactive, Non Reactive, Unknown, Inconclusive. UCG: Positive/Negative. HPV: Done/Not Done; result Negative, High risk type (16/18), Other genotype, Invalid. Dates DD-MM-YYYY. |
| Cancer History, Family's Cancer History, Breast examination, Breast abnormal Yes/No, Breast abnormal finding | Breast screening | Records personal/family cancer history and breast screening findings during the same visit. Data format: Yes/No, Done/Not Done, and free text abnormal findings when enabled. |
| VIA screening, VIA Done Date, VIA if done, follow-up year, Very ill, Pregnancy, Less than 12 weeks after delivery, genital infection, cervical surgery history, abnormal growth, bleed on touch, Others, Other specify | VIA screening and postponed reasons | Explains whether VIA was completed and why screening was postponed when it could not be done. Data format: VIA Done/Not Done. VIA history select list. Dates DD-MM-YYYY. Postponed reasons are checkbox flags, usually 1=selected and 0/blank=not selected. |
| SCJ, VIA test result, counselling/screening by, VIA(+) confirmation by, VIA confirmation result | Cervical map and VIA result | Documents visibility of SCJ, VIA result, confirmation, and responsible staff. Data format: SCJ: Was clearly seen or Not all seen. VIA results: Negative/Positive. Staff fields are free text. |
| Thermal Ablation, Thermal Ablation Date, Eligible, not-eligible reasons, treatment done at MAM, result, counselling by, performed by, done date, not-treatment reasons, postpone date | Thermal ablation | Tracks treatment need, eligibility, treatment completion, reason for no treatment, and provider accountability. Data format: Needed/Not needed, Yes/No, dates DD-MM-YYYY, checkbox reason flags, and free text result/staff/other reason fields. |
| Financial support, Refer to gynaecologist, Reason for referral, Other specify, Biopsy done/result, Gynaecologist management, Next appointment date, MD name, CSL name | Referral, biopsy, and follow-up | Records referral pathway, biopsy outcome, gynaecologist action, planned follow-up, and responsible clinical staff. Data format: Yes/No, selected referral/management list values, free text other/staff fields, and DD-MM-YYYY next appointment date. |
HBV Register records pregnant client HBV care from registration through risk assessment, HBV/HCV/HIV background, pregnancy history, laboratory investigation, treatment summary, delivery details, baby vaccination, and the baby's 9-month HBsAg result.
Use the HBV page as a longitudinal register. Search first, review existing records, then create or update the correct registration record.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| General ID, Date of Registration, Current Age(y), Current Age(m) | Patient identity and registration | Identifies the HBV register row and patient age context for program review and follow-up. Data format: General ID number; registration date DD-MM-YYYY; current age numeric years/months joined during M&E export. |
| Marital status, Partner HIV status, Partner HBV status, Partner HCV status | Patient demographics | Documents relationship and partner infection context for counselling, testing, and household follow-up. Data format: Marital status list; partner status values Positive, Negative, or Unknown. |
| PWID, If PWID Yes, If Ex OST, PWUD, FSW, Partners of 3-KAP, Blood transfusion, General population, Other | Hepatitis B risk assessment | Captures HBV exposure risks and priority-population context used for program monitoring. Data format: Yes/No select values, Active/Ex for PWID status, and free text for Other. |
| HBs Ag pos date, HCV Ab date/result, HIV test date/result | HBV, HCV, HIV background information | Records infection background and testing history at registration. Data format: Dates DD-MM-YYYY. HCV/HIV result values Positive, Negative, or Unknown. |
| Gravida, Parity, LMP, LMP Date, EDD, USG Scan, USG date, EDD by scan, children alive, children with HBsAg Pos, gestational age | Pregnancy and childbirth history | Defines pregnancy timing and child history needed for maternal HBV and baby follow-up planning. Data format: Numeric pregnancy/child counts, Known/Unknown and Yes/No select values, date fields DD-MM-YYYY, and text/numeric gestational age. |
| Baseline date, AST, Platelet, APRI, ALT, Creatinine, Cr CL, HBV VL, HBeAg, 3/6/9-month post-delivery ALT/Creatinine/Cr CL | Investigations and post-delivery monitoring | Supports treatment eligibility, safety monitoring, and post-delivery liver/renal follow-up. Data format: Laboratory numeric values with decimals where allowed, date DD-MM-YYYY, HBeAg Positive/Negative/Unknown, HBV VL exported as value x 10 exponent. |
| Eligible for treatment, planned date, no reason, regimen/dose, treatment start/stop date, complete treatment, incomplete reason | Treatment eligibility and summary | Documents treatment decision, treatment timeline, completion, and reason when treatment was not completed. Data format: Yes/No select values, dates DD-MM-YYYY, and free text regimen or reasons. |
| Delivery date/time, place of delivery, type of delivery, outcome of delivery baby | Child delivery information | Links maternal HBV care with delivery outcome and baby prevention follow-up. Data format: Date DD-MM-YYYY, time HH:MM, free text place, type NSVD/OVD/LSCS, outcome Alive/Dead. |
| HBIG, HBIG date/time, HBV active vaccination at birth/8 weeks/16 weeks/24 weeks, vaccination dates, baby HBsAg date/result | Baby vaccination and 9-month status | Tracks prevention-of-transmission services and confirms baby HBV status at 9 months after delivery. Data format: Yes/No select values, dates DD-MM-YYYY, time HH:MM, baby result Positive/Negative. |
Mental Health Program documentation covers the screening workflow, baseline register, follow-up form, follow-up history, and export. Users first search and confirm the patient, complete baseline assessment and substance-use screening, record intervention and outcomes, then use follow-up to monitor symptoms, adherence, treatment changes, referral, and next appointments.
Use Mental Health Program as three connected records. Mental Health Screening is entered from the Counsellor page; Mental Health Register and Follow-up are entered from the separate MentalHealth page.
This screening record is inside the Counsellor page under Mental Health, Drug Use, Chem Sex Screening. It is a separate dataset from Mental Health Register and Follow-up.
Register and Follow-up records are entered on the separate MentalHealth page. Create the baseline Register once, then add a Follow-up record for each later review. Review existing history before saving or updating either record.
The screening dictionary contains 48 variables and follows the current Mental Health export available from the Counsellor page.
| Field Group | HTML Label / Export Column | How Users Should Understand It |
|---|---|---|
| Patient and visit identity | Clinic Code, Visit Date, Pid, FuchiaID, Gender, registration and current age, Main Risk, Sub Risk, HIV status | Connects the screening encounter to the correct patient, date, demographic profile, HIV status, and risk classification. |
| Initial assessment | Referred by CF, Basic assessment, Basic MH assessment | Shows the referral pathway and whether initial community-facilitator and counsellor assessments were completed. |
| Mental health screening tools | Q1 to 4, Q5 to 7, GAD7, PASS, PHQ9, New/Follow up status, scores | Records screening completion and severity. Check that scores remain within the limits shown on the page. |
| Drug use and ASSIST | Drug use within six months, Name of Drug 1-5, ASSIST Score 1-5 | Documents recent substance use and substance-specific ASSIST scores for risk review and intervention planning. |
| Sexualized drug use and chemsex | Sexual activities under the drug effect, problematic chemsex assessment, A-E | Records sexualized drug use and indicators of problematic chemsex during the assessment period. |
| Brief intervention and completion | Brief intervention BI: Done, If not done BI, Remark | Shows whether BI was delivered, the reason when it was not delivered, and any supporting note. |
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Database, General ID, Fuchia ID, PrEP ID, Current Age, Sex, HIV status, Registration date, Risk factor, if PWID, OST | Register identity | Links the baseline register data to the correct patient and risk profile. Data format: Text/database, General ID number, age numeric, sex/risk/list values, date DD-MM-YYYY, PWID Active/Ex and OST Yes/No. |
| Q1-Q4, Q5-Q7, GAD7, PHQ9, PASS Score | Register screening scores | Baseline severity and screening status used to decide care plan and follow-up need. Data format: Selected screening summary and numeric scores. GAD7 0-21, PHQ9 0-27, PASS 0-93. |
| Psychosis, symptoms, duration, suicidal risk, drug use, sexualized drug use, injectable drug use, willingness to change, ASSIST Score, drug names and risks | Psychosis, suicidal risk, and drug screening | Documents clinical risk and substance-use context for counselling, BI, treatment, and referral. Data format: Yes/No/list values, duration/timeframe values, free text drug names, and ASSIST risk categories. |
| Brief Intervention, planned goal, Stage of BI, treatment at MAM, Fluoxetine, Risperidone, psychiatrist referral, diagnosis, outcomes, initials, next follow-up date | Register intervention and outcomes | Records baseline care actions, treatment plan, outcome status, provider accountability, and planned next review. Data format: Yes/No/NA, selected list values, checkbox flags, free text treatment/other fields, staff initials, date DD-MM-YYYY. |
| Visit Date, patient identity, improvement of symptoms, adherence problem, mental rescreening, GAD7, PHQ9, PASS, problematic sexualized drug use | Follow-up assessment | Measures change since baseline or last visit and identifies continuing support needs. Data format: Date DD-MM-YYYY, ID/age/risk values, Yes/No/list values, numeric scores. |
| ASSIST rescreening, drug names, scores, risks, BI changes, new drug use, suicidal risk between visits, MD consultation, pharmacological side effects, treatment changes | Follow-up ASSIST and treatment review | Tracks substance-use changes, safety risk, medication effects, and treatment adjustments during follow-up. Data format: Yes/No/list values, text drug names, numeric scores, risk categories, and treatment-change text. |
| Refer to psychiatrist, stopping drug, psychosocial intervention at MAM, depression, anxiety, psychosis, other symptoms, MD/CSL initials, next follow-up dates | Follow-up referral, diagnosis, and next dates | Closes the follow-up visit with referral, diagnosis/status, responsible staff, and next appointment planning. Data format: Selected referral values, Yes/No/list or checkbox flags, staff initials, and DD-MM-YYYY next dates. |
CMV Service records eye screening and treatment information for patients at risk of CMV retinitis. The user searches the patient, confirms identity and visit date, records ART/CD4 context, checks visual symptoms and acuity, documents right/left eye diagnosis, records treatment, and saves doctor, organization, follow-up date, and remarks.
Use the CMV page as a visit-based eye screening and treatment record. Always search first so previous CMV history can be reviewed before saving a new visit.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Database, Clinic Code, General ID, Fuchia ID, Sex, registration/current age, Visit Date, Patient Type | Patient identity and visit | Identifies the patient and the CMV visit being reviewed or exported. Data format: Database/clinic text, General ID number, Fuchia ID text, Male/Female, age numeric, date DD-MM-YYYY, Patient Type New/Old. |
| ART status, Current ART Regime, Art Start Date, Most Recent CD4, Recent CD4 Date | ART and immune status | Gives HIV treatment and immune-status context for CMV screening risk and clinical interpretation. Data format: ART status Yes/No, regimen 1st/2nd, CD4 numeric, dates DD-MM-YYYY. |
| Symptoms flashes/floater/scotoma/sudden vision loss, Vision acuity Right Eye, Vision acuity Left Eye | Symptoms and vision acuity | Documents visual complaint and acuity before diagnosis and treatment decisions. Data format: Symptoms Yes/No. Vision acuity values: No Eye, 6, CF, HM, LP, NLP; 6 and CF may include extra detail after a slash. |
| Right Eye Diagnosis, Type of Dx Right, Left Eye Diagnosis, Type of Dx Left | Eye findings and diagnosis | Records the right/left eye clinical finding and whether it is a new, follow-up, relapse, likely CMV, or unknown diagnosis. Data format: Diagnosis values: Active_CMV, Inactive_CMV, Extensive_CMV, RD, TB_G, CWS, NAD, Other. Dx type: New, FU, Relapse, Most likely CMV, UK. |
| Right eye treatment, Left eye treatment, Eye Doctor, Organization, Remark | Treatment and provider | Captures treatment plan, provider accountability, service organization, and notes for review. Data format: Treatment values: Injection only, Valgan only, Injection with valgan, Observation, No treatment. Doctor/organization/remark are free text. |
ANC Register records antenatal registration and follow-up care. The user searches by General ID, creates or updates the ANC register, records relevant maternal history, family and patient risk history, immunization, previous obstetrical history, investigation results, clean delivery kit/referral data, and follow-up visit findings.
Use the ANC page as one register episode with many follow-up visits. Register first, then add follow-up visits against that same ANC register record.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| General ID, Registered Date, patient name/age, Husband's Name, Age of Marriage, Height, G, P, Contact Number, Address, Last Menstrual Period, LMP, EDD, contraception history | Register identity and relevant history | Identifies the ANC episode and captures maternal background, obstetric status, pregnancy dating, and contact context. Data format: General ID number, age and clinical numeric values, date DD-MM-YYYY, LMP Known/Unknown, text for contact/address/history. |
| Family History Hypertension/Diabetes/Tuberculosis/Twins; Patient History Hypertension/Diabetes/Tuberculosis/Twins/Heart Disease/Allergy/Surgical Operation/Other Specify | Family and patient history | Marks family and personal risk factors that may change ANC monitoring, referral, or follow-up priority. Data format: Yes/No selections for risk conditions, plus free text for Other Specify. |
| 1st Dose, 2nd Dose, TA/Prem, Spont/Induced, 3rd stage complication, Condition of child, Remark | Immunization and previous obstetrical history | Tracks tetanus toxoid immunization and previous pregnancy/child outcomes. The export adds another 5 child-history columns for each extra child row. Data format: Dates for TT doses. Child-history fields are repeatable; condition values are Stillbirth, Alive, or End, with text fields for other details. |
| HIV, HBsAg, Anti-HCV, Syphilis RDT/RPR, Blood Group/Rh, Blood Sugar test dates and results | Investigation | Records laboratory and screening evidence used for antenatal care, risk review, and referral decisions. Data format: Dates DD-MM-YYYY. HIV/HBsAg/Anti-HCV results Positive, Negative, or Unknown/Unknow. Syphilis RDT Reactive/Non-reactive. Blood group/result fields are short clinical text. |
| Clean Delivery Kit Distribution, CDK Distributed Date, Refer, Date of referral, Referral place | Delivery and referral | Shows whether the mother received a clean delivery kit and whether referral was made, including when and where. Data format: Yes/No selections, dates DD-MM-YYYY, and referral place values TBA, RHC/UHC, or Hospital. |
| Visit Date, Weight, BP systolic/diastolic, Pr, Glu, Other, Gestational period, Fundal Height, Presentation, Engagement, FHS, Oedema, RPR recheck | Follow-up assessment | Documents routine ANC follow-up findings and clinical status for each visit. Data format: Date DD-MM-YYYY; numeric clinical values; urine Pr/Glu blank/0, 1+, 2+, 3+, or 4+; Oedema Yes/No; text for other findings. |
| Complaints, Treatment, USG result, Name of MD | Follow-up care | Records the care plan, ultrasound result, and responsible provider for continuity and review. Data format: Free text or short clinical note according to the field label. |
Feeding Center Register records nutrition admission, follow-up visits, and program outcomes. The user searches the patient, records Feeding Center ID and admission details, documents diagnosis, screening criteria, medical complications, nutrition measurements, transfer or discharge outcome, household context, and follow-up measurements.
Use the Feeding Center page as one admission episode with follow-up visits linked to the same admission date. A new register record also creates the first follow-up visit on admission date.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Database, Clinic Code, General ID, Sex, FC-Reg Age, FC-Reg Age(month), Feeding Center ID | Register identity | Identifies the admission record and links it to the patient, clinic, age, and Feeding Center episode. Data format: Database/clinic text, General ID number, sex value, calculated age values, and Feeding Center ID text. |
| Patient Type, Diagnosis, Enter from, Distance to clinic, Screening Criteria, Admission Type, Medical Complication, Date of admission | Admission profile | Describes why and how the patient entered the Feeding Center program and identifies admission risk context. Data format: Selected list values, multi-select complication text, and date DD-MM-YYYY. |
| FINAL MUAC, MUAC, Z-score, Weight, Clinical, Others | Admission nutrition status | Records baseline nutrition status at admission for monitoring and outcome comparison. Data format: Numeric nutrition values, MUAC color category, Z-score category, clinical selection, and free text note. |
| Date of transfer to ATFP, Date of Outcome, Outcome, Hospital Outcome, Length of Stay in Day care, Total Length of Stay | Outcome and discharge | Shows transfer/discharge timing, final program result, and duration of care. Data format: Dates DD-MM-YYYY, outcome selected lists, and numeric day counts. |
| MUAC1, Z_score1, Weight1, Clinical1, Others1, Parent's Status, Parent HIV status, Caretaker, Remark | Outcome nutrition and care context | Records nutrition status at outcome and household/caretaker context for care review. Data format: Numeric outcome measurements, selected list values, and free text notes. |
| Date of Admission, Visitdate, MUAC, Z_score, Weight, Height, Clinical, Other, Remark | Follow-up assessment | Tracks nutrition and clinical progress across Feeding Center follow-up visits. Data format: Date DD-MM-YYYY, numeric nutrition values, selected clinical status, and free text notes. |
NCD records non-communicable disease registration and follow-up care. The user searches by General ID or Fuchia ID, records baseline hypertension/diabetes screening, current medications, patient and family history, follow-up visits, BP/blood sugar/lab monitoring, medication changes, adherence, drug supply, appointments, and outcomes.
Use the NCD page as a long-term register with repeated follow-up visits. The Data tab helps users review clinical results, treatment history, and LTFU status before saving the next visit.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Database, Clinic code, General ID, Fuchia ID, Current Age, Sex, Reg Date, Township, State, Height, Weight, Reg_BMI | Register identity | Identifies the NCD register record and baseline patient context. Data format: Database/clinic text, ID values, age numeric, date DD-MM-YYYY, demographics, and numeric height/weight/BMI. |
| BP readings 1-3, BP read dates, Hypertension, Diabetes, diagnosis dates, staging, RBS tests, clinical symptoms, smoking status | Register diagnosis and screening | Classifies baseline hypertension/diabetes and related screening information at registration. Data format: BP numeric pairs, dates DD-MM-YYYY, diagnosis/status selected values, RBS numeric values, symptom text, and smoking status list. |
| Amlodipine, Enalapril, Atorvastatin, Hydrochlorothiazide, Aspirin, Metformin, Gliclazide, Other NCD medication, Current med1-6 | Register medications | Documents treatment already being used at NCD registration. Data format: Dose, frequency, duration, duration unit, selected medication values, and free text other-medication fields. |
| Diabetic foot, Hyperlipidemia, Gestational diabetes/HT, Neuropathy, CKD, CVD, Atrial fib, vision change, chronic lung disease, recurrent infection, family history, poor-compliance dates | Patient and family history | Captures risk history, comorbidities, family risk, and treatment-compliance warning dates. Data format: Yes/No, NA or clinical selected values, free text comment, and dates DD-MM-YYYY. |
| Visit Date, Register Date, NCD Diagnosis, Clinical History, Type_current_visit, late duration/unit, follow-up required duration/unit, next follow-up date, time | Follow-up visit planning | Shows the visit context, whether the patient came late, and when the next visit is planned. Data format: Dates DD-MM-YYYY, selected visit type, numeric duration, unit values, time text, and clinical history text. |
| BP MAM, BP state, FBS, 2HPP, RBS, HbA1C, ALT, urine ACR, glucose/protein/ketone, creatinine, CRCL, lipids, pulse, diabetic foot, diabetic neuropathy | Follow-up clinical and lab monitoring | Tracks disease control, complications, renal/lipid risk, and follow-up clinical status. Data format: Numeric clinical/lab values, unit fields, dates DD-MM-YYYY, and selected clinical status fields. |
| Lifestyle advice, medication changed, patient adherence, drug supply, follow-up medicine doses, hypoglycemia, other medication, outcome, transfer out, death date, cause of death, doctor initial | Follow-up medication, adherence, and outcome | Records treatment plan, adherence, medicine supply, outcome, transfer/death information, and accountable clinician. Data format: Selected values, medication dose/frequency/duration/unit fields, dates DD-MM-YYYY, and free text notes. |
PrEP documentation covers eligibility screening, facility intake, initiation or restart, and follow-up care. The user records client information, standalone PrEP age and risk values, sexual/drug-use risk classification, substantial HIV risk, eligibility, service offer/decline, facility laboratory checks, STI and HBV services, PrEP regimen, family planning, FSW type, follow-up testing, adherence, side effects, discontinuation, prescription, delivery, and outcome.
Use PrEP Screening first to decide substantial risk and eligibility, then use PrEP Facility to record initiation and follow-up. Age, Main Risk, and Sub Risk are recorded as PrEP program fields for this workflow and should not be interpreted as automatically drawn from patient configuration tables.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| General ID, Visit Date, PrEP ID, Tracker ID, Sex, Age, DOB, birth region/town, phone, facility, navigator, person completing form | Identity and demographics | Identifies the PrEP client and visit/screening context for the program record. Data format: ID/text values, dates DD-MM-YYYY, and standalone PrEP age fields recorded in the PrEP workflow. |
| Main Risk, Sub Risk, Consider Sex, Sex With, exchanged sex, injected drugs, key population flags, Final_class, Final_other | Standalone risk classification | Classifies PrEP risk and key population status without assuming these values come from pt_configs or patients. Data format: Standalone PrEP risk categories, selected answers, checkbox values, and free text other specify. |
| Condomless sex, sex partner HIV risk, STI history, PEP history, shared injection material, recent 72-hour exposure, symptoms, HIV test, confirmation, substantial risk, eligible, offered/accepted/declined, decline reasons, referrals | Screening risk, eligibility, and referrals | Documents substantial-risk criteria, HIV testing/eligibility decision, client decision, and referral pathway. Data format: Yes/No style selections, checkbox flags, test result lists, dates DD-MM-YYYY, and free text reasons. |
| Pregnancy, breastfeeding, HIV last test, creatinine, CrCL, HCV, urine, weight, HBsAg, HBV vaccination, STI screen/result/syndrome/treatment/lab investigation | Facility baseline lab and HBV/STI | Records clinical baseline checks and linked HBV/STI services before or during PrEP initiation. Data format: Dates DD-MM-YYYY, numeric lab/weight values, selected result/status values, and STI text/code values. |
| Prep Initial Type, Prep Start Date, Prep ARV Prescribed, Next Visit Date, Prep Re-Start Date, Start-stop eligible, Prep Taking Type, Family Planning, method flags, last family planning date | PrEP initiation, regimen, and family planning | Tracks PrEP start/restart, ARV regimen, next appointment, daily/start-stop use, and reproductive health support. Data format: Selected regimen/type values, checkbox flags, dates DD-MM-YYYY, and free text other values. |
| PrEP Active, Followup Month, HIV screen/confirmation, ART start, HBsAg, HCVAb, Urine RE, CrCL, STI/RDT/RPR, adherence, side effects, discontinuation, prescription, next date, outcome, delivery, interruption, condom usage | Follow-up testing, adherence, and outcome | Monitors PrEP continuation, safety, infection testing, risk reduction, adherence, supply, interruption, and final outcome. Data format: Dates DD-MM-YYYY, selected result/status values, numeric month/weight/interruption values, and free text notes. |
Prevention documentation covers confidential search, Logsheet data, CBS data, follow-up history, and export. Users identify the client through peer/clinic/year/serial information, record reach and risk status, service provision, commodities, HIV testing, mental health, OST/referral, drug-use and brief-intervention details, then export Logsheet or CBS data.
Use Confidential Facts first to find or confirm the client, then move into Log Sheet or CBS depending on source document and service modality.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Database, HE Code, Clinic Code, Register Year, Pid, Fuchia ID, PrEP Code, register/visit dates, age, sex | Record identity and demographics | Identifies the prevention activity, patient, peer/clinic context, and reporting period. Data format: ID/code values, dates DD-MM-YYYY, age numeric values, and sex value. |
| Initial Risk, Risk changed, Risk changed Date, Main Risk(Current), Sub Risk, Reach New_Old, Meeting Point, Reach_whom, Source_doc, Reached Township | Reach and risk | Shows who was reached, where, under which source document, and whether risk changed over time. Data format: Risk categories, Yes/No or New/Old status, date DD-MM-YYYY, and location/text values. |
| Service Provision1-3, HE_Section, Ns_distribute, Condom_m, Condom_f, Ns_return, CBS Service Provision | Service provision and commodities | Tracks services delivered and prevention commodities distributed or returned. Data format: Selected service values and numeric commodity counts. |
| HIV Status, Test_duration, HTS done, HIV results, date_confirm, Retesting, HIV_determine_result, HIV Sero-Status, Counselling_pretest, Counselling_posttest, Refer_to | HIV testing and CBS counselling | Documents HIV testing status, confirmation pathway, CBS counselling, and referral outcome. Data format: HIV status/result selected values, Yes/No counselling fields, referral text, and date DD-MM-YYYY. |
| Mental_Health, PHQ4_Q1_Q2, PHQ4_Q3_Q4, OST_Done, OST_Accept, Decline_Reason, OST_Initial_Date, OST_Eligible, Referral_Coupon, MMT Code | Mental health, OST, and referral | Records mental-health screening and OST/referral activity linked to prevention outreach. Data format: Selected screening/status values, referral/coupon text, and date DD-MM-YYYY. |
| Drug Use, Brief Intervention, problematic DU detail fields, Explain Harm Activity, Introduce Services, Discuss Reduce Risk, Explain OST Referral, BI_done, mtd_date | Drug use and brief intervention | Documents problematic drug-use risk details and brief-intervention components for follow-up and reporting. Data format: Checkbox/status values, Yes/No style flags, free text where applicable, and date DD-MM-YYYY. |
Pre TB Assessment records the first TB clinical assessment before confirmed TB registration. The page links a General ID to patient details, records symptoms and risk factors, captures X-ray and sputum/GeneXpert/Truenat/HIV diagnostics, then records diagnosis, treatment status, remark, and responsible MD.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| clinic, cid, TB-03, name, age, sex, typ_of_scr, mode_of_entry, dofscrrening, dofnv, phone | Record identity and visit | Identifies the patient, assessment visit, route into care, and whether the client already appears in TB-03. Data format: ID/text values, coded sex/type/mode values, and date values. |
| height, weight, bmi, main_presenting_complaint | Vitals and complaint | Documents clinical context for screening and nutrition or severity review. Data format: Numeric height/weight/BMI and free text complaint. |
| fever, cough, hemoptysis, weight_loss, loss_of_appetite, chest_pain, night_sweats, neck_glands, fatigue and duration fields | Symptoms | Shows which TB symptoms were present and how long they lasted. Data format: Yes/No coded values and symptom duration in days. |
| alcohol, smoking, malnutrition, PWID, PWUD, DM, dm_tx_status, hiv_status, hiv_tx, his_tb_self, his_tb_self_detail, his_tb_family | Risk factors | Captures clinical and exposure risks that influence assessment and follow-up priority. Data format: Coded current/ex/no/unknown, Yes/No/Unknown, treatment status, and free text detail. |
| chest_x-ray, chest_x-ray_date, chest_x-ray_fac, md_diagnosis, cad_score, radio_request, radiologist_result, sputum_afb, genexpert, truenat, hiv_det and result/date fields | Diagnostics | Tracks investigations requested, results received, and evidence for diagnosis. Data format: Yes/No flags, selected result codes, dates, numeric CAD score, specimen type, and comments. |
| antibiotics, antibiotic_date, drug, manage_oth, tb_diagnosis, treatment_status, treatment_status_other, xray_image_path, remark, md | Management and outcome | Records the final assessment decision, treatment or referral status, supporting notes, and accountability. Data format: Yes/No flags, dates, selected diagnosis/status values, file path, text notes, and staff name. |
Counsellor documentation covers four working parts. The counsellor starts from patient identification, records HIV testing service or counselling service data when needed, manages TB register records, records IPT, and exports or reviews data for follow-up.
The counselling page supports HTS data entry together with counselling data. The user can choose Counselling Only or HTS Entry and Counselling, then complete the HTS-related fields for the patient and visit.
Counselling data captures counselling-only visits, counselling connected to HTS, and tele-counselling records. It is the counsellor's main work record and should match the patient, counselling date, counsellor, risk context, and service outcome.
TB Register-03 records TB treatment registration and reporting data. It supports searching by General ID, Fuchia ID, or Township TB Register Number, then saving treatment details and follow-up information.
The TB-IPT page records IPT registration and outcomes. Users search the patient, confirm patient details, enter counsellor, registration/start/discontinuation dates, choose regimen, record outcome, and export IPT data.
Search General ID or Fuchia ID before creating or updating the IPT record.
Record IPT Register Date, IPT Start Date, and IPT Discontinuation Date where applicable.
Use the 6H or 3HP checkbox to mark the IPT regimen.
Choose Completed, Incomplete, or TB disease while on TPT.
Use History before editing an existing IPT record.
Use Export for IPT reporting after checking date and outcome fields.
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Clinic Code, Pid, FuchiaID, Gender, Register Year, Register Age, Current Age | Patient identity | Identifies the client and links HTS data to reception, lab, and counselling history. The Excel source defines General ID/Fuchia ID and registration/current age as shared EMR variables. Data format: General ID: number, length 10/11/12. Gender: Male/Female. Register Year: YYYY. Age: number; month: 1-11. |
| Counselling Date, Counselor, Pre, Post | Visit context | Date and staff responsible for the HTS counselling contact. Pre and Post show whether pre-test and post-test counselling were provided. Data format: Date: DD-MM-YYYY in export. Counselor: staff name/text. Pre/Post: Yes/No-style service flags. |
| Service Modality, Mode of Entry, New_Old, Test Location | Service classification | Classifies where and how the client entered HTS. Use these fields for service-delivery reporting and to separate new and returning HTS clients. Data format: Select/list values from the HTS form. New_Old supports New/Old and imported coded forms such as 1/N for new and 0/R for old. |
| Main Risk, Sub Risk | Risk classification | Client risk group. Use the Excel code-book categories, such as TB Patient, FSW, MSM, TGW, PWID, PWUD, partner groups, pregnant mother, exposed children, youth, and other low-risk categories. Data format: Coded/list value. Format reference: Code Book sheet for Main Risk and Sub Risk. |
| HIV Test Date, HIV Test Determine, HIV Test UNI, HIV Test STAT, HIV Final Result | HIV testing | Records the HIV testing algorithm and final interpretation. Use Final Result for reporting; the individual test columns explain the testing path. The Excel code book includes result values such as reactive/non-reactive/invalid and positive/negative/inconclusive/nil. Data format: Date: DD-MM-YYYY in export. Test results: Reactive, Non Reactive, Invalid. Final result: Positive, Negative, Inconclusive, Nil/blank when not done. |
| Syphillis Test Date, Syphillis RDT, Syphillis RPR, Syphillis VDRL, HepB/C Test Date, Hepatitis B, Hepatitis C, Request MD | Linked lab tests | Related STI/hepatitis results and requesting doctor, usually linked from lab data. These fields support complete HTS-linked screening review. Data format: Date: DD-MM-YYYY in export. Syphilis RDT: Reactive/Non Reactive. RPR/VDRL/Hepatitis: Positive/Negative-style result values. Request MD: staff name/text. |
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| General ID, Fuchia ID, TB Code / Township TB Reg Number, State/Region Name, Township Name, Facility Name, Reporting Period | TB identity | Identifies the TB register record and the reporting unit. TB Code is the township TB register number used for TB tracking. Data format: General ID: number, length 10/11/12. TB Code: text/number from township register. State/Township/Facility: text/list. Reporting Period: 1st, 2nd, 3rd, or 4th Qtr. |
| Treatment Registar Date, Nationality, Sex, Reg Year, Register Age, Current Age | Patient context | Demographic and time context for the TB record. Registration/current age should match the shared EMR interpretation from the Excel dictionary. Data format: Date: DD-MM-YYYY in export. Nationality: N/NN. Sex: Male/Female. Reg Year: YYYY. Age: number; month: 1-11. |
| Refered from, Type of Patient's, Type of Disease, Specify Site of EPTB, Transfer in, Treatment Regimens | Case classification | Defines TB case type, referral source, disease site, transfer-in status, and regimen. Complete EPTB site when the case is extra-pulmonary. Data format: Select/list values from TB03 form. Transfer in: Y/N. EPTB Site: text/list required when disease type is EPTB. |
| Treatment Start Date, Smoking Status, DM Status, HIV Status, CPT Start Date, ART Start Date | Clinical status | Clinical background and linked HIV/TB treatment dates. HIV Status should be interpreted with the Excel HIV status reference where coded values are used. Data format: Dates: DD-MM-YYYY in export. Smoking/DM/HIV: selected status values. HIV status reference: Unknown, Known Negative, Known Positive, ART where coded. |
| Microscope Result, X-Ray Result, Xpert Result, Culture Result | Baseline test results | Initial diagnostic result set. The Excel code book gives common result encodings, including reactive/non-reactive/invalid and positive/negative/inconclusive/nil. Data format: Result values from form/code book, commonly P/N or Positive/Negative, plus applicable blank/missing values. |
| 2nd month, 3rd month, 5th month, End of Tx, 1st line DST result | Follow-up test results | Monitoring tests across treatment. They support bacteriological follow-up and should be updated at the correct treatment month. Data format: Result values from form/code book, commonly P/N or Positive/Negative. Month fields should be filled only for the correct treatment follow-up point. |
| Treatment Outcome, Initial Regimen Started Date, Outcome Date, bacteriological/clinical, Consular Name, Remark | Treatment outcome | Final TB treatment status and interpretation basis. Outcome and outcome date should be completed when treatment status is known. Data format: Outcome and bacteriological/clinical: selected list values. Dates: DD-MM-YYYY in export. Counsellor: staff name/text. Remark: free text. |
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Clinic Code, General ID, Clinic Reg No. (ART No.), Register Age, Current Age, Sex | Patient identity | Identifies the patient for IPT reporting. Export uses the patient registration context for age, sex, and clinic registration number. Data format: General ID: number, length 10/11/12. Clinic/Fuchia ID: text. Age: number. Sex: Male/Female. |
| IPT Registration date, Really IPT Start date, IPT Discontinuation date | IPT timeline | Shows enrolment, real treatment start, and stop date. These dates are the core timeline for IPT completion or discontinuation review. Data format: Date fields, exported as DD-MM-YYYY. Discontinuation date may be blank when IPT is continuing or completed without stopping. |
| Outcome, Remarks, Counsellor, 6H, 3HP | Outcome and regimen | Outcome values include Completed, Incomplete, and TB disease while on TPT. The 6H/3HP fields identify the preventive treatment regimen used. Data format: Outcome select values: Completed, Incomplete, TB disease while on TPT. 6H/3HP: regimen flag/selection. Remark: free text. Counsellor: staff name/text. |
| Field | Where It Appears | How Users Should Understand It |
|---|---|---|
| Clinic Code, Pid, FuchiaID, PrEP_ID, Gender, Reg Year, Register Age, Current Age | Patient identity | Identifies the counselling client and links the record to reception demographics. The Excel dictionary is the reference for shared General ID/Fuchia ID and age definitions. Data format: General ID: number, length 10/11/12. Fuchia/PrEP ID: text. Gender: Male/Female. Reg Year: YYYY. Age: number; month: 1-11. |
| Main Risk, Sub Risk, Counselling Date, Counselor | Risk and visit | Defines client risk group, visit date, and responsible staff. Main Risk/Sub Risk should follow the Excel code book. Data format: Main/Sub Risk: Code Book reference. Date: DD-MM-YYYY in export. Counselor: staff name/text. |
| HTS done, Reason, Status, Pre, Post | HTS counselling status | Shows whether HTS was completed and whether pre/post counselling occurred. Reason and Status explain incomplete or special HTS situations. Data format: HTS done, Pre, Post: Yes/No-style service flags. Reason/Status: selected list or short explanatory text depending on the form choice. |
| PrEP, PrEP Status, C1, C2, C2_Done, C3, ADH, Stable | PrEP and routine counselling | Tracks PrEP-related counselling, standard counselling contacts, adherence work, and stable-client status. Data format: Service flags and status values from the form. C1/C2/C3/ADH/Stable are Yes/No-style flags; PrEP Status is a selected status/list value. |
| <15 Disclosure, <15 Disclosure Define, <5 ADH | Child/adolescent and disclosure | Records child/adolescent disclosure and adherence counselling. Definition text should explain the disclosure situation when selected. Data format: Disclosure/adherence: Yes/No-style flags. Define field: free text explanation. |
| OST, ART+TB, ART+TB Define, Only IPT, Only TB, Only TB_Define, ART+OST | TB, IPT, and HIV care support | Shows counselling support linked to OST/MMT, ART+TB, TB-only, IPT-only, and ART+OST services. Definition fields add needed clinical or service details. Data format: Service flags: Yes/No-style values. Define fields: free text. OST/MMT and ART/TB/IPT support values come from the counselling form selections. |
| NCD, ANC, PFA, PHQ9, PHQ9_Define, Other, EAC, FHT, C P case, PMTCT, Case_Presention | Other counselling services | Additional counselling services and presentations. Fill definition fields when the selected service requires explanation for review or export. Data format: Mostly Yes/No-style service flags. PHQ9_Define, Other, and Case Presentation: free text/detail fields. |
| PHQ4, GAD7, GAD7_Define, Brest Cancer, Hep C, D1, D2, D3, D4, CAGE | Additional screening flags | Screening flags recorded during counselling. Use the definition field to explain positive GAD7 screening or other flagged findings. Data format: Screening flags: Yes/No-style values. Definition field: free text. CAGE/D1-D4: screening item flags or coded answers from counselling form. |