Draft_Nigeria_EIR_DecisionLogic_V4.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Nigeria EIR Decision Logic Workbook - Cleaned Review Copy
2
3	Source workbook	Draft_Nigeria_EIR-DecisionLogic_V4.xlsx
4	Source SHA-256	1a61632da7479031910913e487fb2f0a51056c32ab7026971fda450a843bc9b7
5	Cleaned workbook	Draft_Nigeria_EIR-DecisionLogic_V4_cleaned_for_review.xlsx
6	Scope	COVER regenerated from actual sheet contents. Source tabs are preserved; generated normalized tabs support Codex extraction and human review.
7
8	Workbook Summary
9	Included source sheets	16
10	Excluded source sheets	1
11	Normalized rule rows	143
12	Normalized schedule rows	39
13	Rules with inherited references	117
14	Rules with unresolved references	0
15	Rules requiring review	117
16
17
18	include_status	sheet_name	canonical_decision_id	source_decision_id	trigger	business_rule	rule_rows	schedule_rows_on_sheet	reference_status	review_status	review_notes

19	included	BCG	IMMZ.DT.01.BCG	IMMZ.DT.01.BCG	IMMZ.D2 Determine Required Vaccinations if any	If child or person has not been vaccinated, give BCG vaccine as soon as possible after birth	16	1	inherited, row	needs_review
20	included	BCG	IMMZ.DT.CONTRA.BCG_contraindications	IMMZ.D5.DT.BCG contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	5	1	inherited, row	needs_review
21	included	Covid 19	IMMZ.DT.10.Covid19	IMMZ.DT.10.Covid19	IMMZ.D10 Determine Required Vaccinations if any	If the child or Client has not been given Covid vaccination	7	0	inherited, row	needs_review
22	included	DPT-Hep B-Hib	IMMZ.DT.06.DPT-Hep_B-Hib	IMMZ.DT.06.DPT-Hep B-Hib	IMMZ.D6 Determine Required Vaccinations if any	If child or person has not been given DPT-Hep B-Hib, start scheme	5	6	inherited	needs_review
23	included	DPT-Hep B-Hib	IMMZ.DT.Hepatitis_B.Birth_dose	IMMZ.D2.DT.Hepatitis B.Birth dose	IMMZ.D2 Determine required vaccination(s) if any	Determine if the client is due for a hepatitis B vaccination according to the national immunization schedule	2	6	inherited, row	needs_review
24	included	HPV	IMMZ.DT.08.HPV	IMMZ.DT.08.HPV	IMMZ.D8 Determine Required Vaccinations if any	If child or person has not been vaccinated, give HPV vaccine according to the defined schedule	3	4	inherited	needs_review
25	included	HPV	IMMZ.DT.CONTRA.HPV_contraindications	IMMZ.D5.DT.HPV contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	2	4	row	ready_for_review
26	included	Malaria	IMMZ.DT.CONTRA.Malaria_contraindications	IMMZ.D5.DT.Malaria contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	1	5	row	ready_for_review
27	included	Malaria	IMMZ.DT.Malaria	IMMZ.D2.DT.Malaria	IMMZ.D2 Determine required vaccination(s) if any	Determine if the client is due for a malaria vaccination according to the national immunization schedule	8	5	inherited	needs_review
28	included	Measles	IMMZ.DT.04.Measles-Rubella	IMMZ.DT.04.Measles-Rubella	IMMZ.D4 Determine Required Vaccinations if any	If the child or Client has not been given Measles-Rubella vaccination	6	2	inherited, row	needs_review
29	included	Measles	IMMZ.DT.CONTRA.Measles_contraindications	IMMZ.D5.DT.Measles contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	6	2	inherited, row	needs_review
30	included	Meningococcal	IMMZ.DT.CONTRA.Meningococcal_contraindications	IMMZ.D5.DT.Meningococcal contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	1	2	row	ready_for_review
31	included	Meningococcal	IMMZ.DT.Meningococcal.MenA_conjugate_vaccine_1_dose	IMMZ.D2.DT.Meningococcal.MenA conjugate vaccine 1 dose	IMMZ.D2 Determine required vaccination(s) if any	Determine if the client is due for a meningococcal vaccination according to the national immunization schedule	2	2	inherited, row	needs_review
32	included	Pneumococcal	IMMZ.DT.CONTRA.Pneumococcal_contraindications	IMMZ.D5.DT.Pneumococcal contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	4	6	inherited, row	needs_review
33	included	Pneumococcal	IMMZ.DT.Pneumococcal.3_doses	IMMZ.D2.DT.Pneumococcal.3 doses	IMMZ.D2 Determine required vaccination(s) if any	Determine if the client is due for a pneumococcal vaccination according to the national immunization schedule	19	6	inherited	needs_review
34	included	Polio	IMMZ.DT.02.Polio	IMMZ.DT.02.Polio	IMMZ.D2 Determine Required Vaccinations if any	If child or person has not been vaccinated, give Polio vaccine	16	5	inherited, row	needs_review
35	included	Rotavirus	IMMZ.DT.07.Rotavirus	IMMZ.DT.07.Rotavirus	IMMZ.D7 Determine Required Vaccinations if any	If child or person has not been vaccinated, give Rotavirus vaccine according to the defined schedule	11	3	inherited, row	needs_review
36	included	Rotavirus	IMMZ.DT.CONTRA.Rotavirus_contraindications	IMMZ.D5.DT.Rotavirus contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	10	3	inherited, row	needs_review
37	included	Td for pregnant women	IMMZ.DT.CONTRA.DTP_contraindications	IMMZ.D5.DT.DTP contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	2	0	row	ready_for_review
38	included	Td for pregnant women	IMMZ.DT.DTP.Pregnancy	IMMZ.D2.DT.DTP.Pregnancy	IMMZ.D2 Determine required vaccination(s) if any	Determine if the client is due for tetanus-diptheria vaccination according to the national immunization schedule	5	0	inherited, row	needs_review
39	included	Vitamin A	IMMZ.DT.09.Vitamin_A	IMMZ.DT.09.Vitamin A	Determine Required Vaccinations if any	If child or person has not been vaccinated, give Vitamin A according to the defined schedule	2	3	inherited	needs_review
40	included	Yellow Fever	IMMZ.DT.03.Yellow_Fever	IMMZ.DT.03.Yellow Fever	IMMZ.D3 Determine Required Vaccinations if any	If child or person has not been vaccinated, give Yellow Fever vaccine between age 9-12 months	3	2	inherited	needs_review
41	included	Yellow Fever	IMMZ.DT.CONTRA.Yellow_fever_contraindications	IMMZ.D5.DT.Yellow fever contraindications	IMMZ.D5 Determine vaccine(s) to be administered based on contraindications	Check for contraindications before administering the vaccine(s) due	7	2	inherited	needs_review
42	excluded	FP.LO.004-3. PregTestNegative				excluded_non_immunization_family_planning_logic	0	0		needs_review
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100