Snippets of REDCap operations in a paediatric cancer registry

1Scope

UCI-Ped-Reg is a hospital-based paediatric cancer registry built on REDCap at the Uganda Cancer Institute. ICCC-3 coding is implemented with REDCap's native branching logic and @CALCTEXT calculated fields only.

This page reproduces, verbatim, the field labels, choices and expressions that assign the ICCC-3 extended classification and subgroup for Group X. In this group the result depends on two entered values: the ICD-O-3.2 morphology and the topography. The expressions run in your browser. Nothing you select is stored or transmitted.

Sections 5 and 6 show two further calculated fields from the same dictionary: age at the first UCI visit, and the location and level of the referring facility. Their values are shown for one illustrative entry each.

2Data entry

Complete the four fields in order. Each field is displayed only when its branching logic is satisfied, as on the registry form. The suggested entries reproduce a yolk sac tumour of the testis.

Field 1 of 4

dx_cancer · yes/no

Suggested entry: Yes

Displayed on every record (no branching logic).

Field 2 of 4

topo_code · dropdown · ICD-O-3.2 topography

Suggested entry: Testis, NOS (C62.9). The registry form lists 327 sites; eight are offered here.

Not displayed.

Field 3 of 4

diag_main · radio · ICCC-3 main group

Suggested entry: X

Not displayed.

Field 4 of 4

x_morph · dropdown · ICD-O-3.2 morphology

Suggested entry: 9071 - Yolk sac tumor. The stored value is the morphology code itself. The registry form lists 157 Group X morphologies; five are offered here.

Not displayed.

3Calculated values

Complete fields 1 to 4 to see the values REDCap calculates.

Variable	Stored value	Origin

How `x_extended` is derived

The expression is a chain of if() conditions on x_morph and topo_code, read in order. The first condition that holds returns its label; the conditions before it do not hold.

Show the complete x_extended expression

How `x_subgroup` is derived

x_subgroup reads x_extended: its first two characters (left([x_extended],2)) select the subgroup.

Show the complete x_subgroup expression

4Effect of topography

Select a morphology in field 4 to compare sites.

The same morphology, , evaluated at each site offered in field 2. The highlighted row is the site currently selected.

Site	`x_extended`	`x_subgroup`

5Age at the first UCI visit

Age is not entered. Three calculated fields derive it from the date of birth on the Demographics instrument and the date of the first visit to UCI on the Referral characteristics instrument. age_days counts the days between the two dates; age_months and age_year divide that count by one twelfth of the Julian year (30.4375 days) and by the Julian year (365.25 days) and round down, so both express completed months and years.

Variable	Value	Source or expression
date_birth	14-03-2019	Entered (Demographics)
visit_date	02-06-2025	Entered (Referral characteristics): first visit to UCI
age_days	2272	`datediff([date_birth], [visit_date], "d", "dmy", true)`
age_months	74	`rounddown([age_days]/30.4375, 0)`
age_year	6	`rounddown([age_days]/365.25, 0)`

Dates are illustrative and do not belong to a registered patient. Because age is anchored to the first UCI visit, it does not increase with time; it changes only if either date is corrected.

6Location and level of the referring facility

When a child is referred from a facility in Uganda, the abstractor selects it from ref_facility, a list of 3,346 facilities. The stored value is the facility's position in that list. Two calculated fields read that number:

facility_location returns one of 146 locations (136 districts and 10 cities). The expression is a binary search: 538 nested comparisons of the form [ref_facility]< n, of which any one facility passes through at most 10.
facility_level returns one of 6 levels of care from contiguous ranges of positions.

Variable	Value	Origin
ref_facility	3001	Entered: Gulu Regional Referral Hospital
facility_location	Gulu City	Calculated by `@CALCTEXT` from `ref_facility`
facility_level	RRH	Calculated by `@CALCTEXT` from `ref_facility`

How `facility_location` is derived for value 3001

The first condition returns a blank location when no facility is selected. Each comparison after it splits the remaining range of positions in two: a satisfied comparison takes the first branch, an unsatisfied one the second. For this facility, 9 comparisons reach the result.

Not satisfied[ref_facility] = ''
Not satisfied[ref_facility]< 1984
Not satisfied[ref_facility]< 2901
Satisfied[ref_facility]< 3041
Not satisfied[ref_facility]< 2979
Satisfied[ref_facility]< 3006
Not satisfied[ref_facility]< 2988
Not satisfied[ref_facility]< 3001
Satisfied[ref_facility]< 3003
Satisfied[ref_facility]< 3002
Returns'Gulu City'

Show the complete facility_location expression

if([ref_facility] = '', '',
if([ref_facility]< 1984,if([ref_facility]< 561,if([ref_facility]< 394,if([ref_facility]< 179,if([ref_facility]< 89,if([ref_facility]< 27,if([ref_facility]< 17,if([ref_facility]< 11,if([ref_facility]< 2,'Amuru District','Gulu City'),if([ref_facility]< 13,'Gulu District','Kitgum District')),if([ref_facility]< 19,if([ref_facility]< 18,'Lamwo District','Nwoya District'),if([ref_facility]< 25,'Pader District','Bushenyi District'))),if([ref_facility]< 70,if([ref_facility]< 51,if([ref_facility]< 47,'Ibanda District','Kazo District'),if([ref_facility]< 58,'Kiruhura District','Mbarara City')),if([ref_facility]< 84,if([ref_facility]< 74,'Mbarara District','Ntungamo District'),if([ref_facility]< 86,'Rwampara District','Sheema District')))),if([ref_facility]< 156,if([ref_facility]< 100,if([ref_facility]< 92,if([ref_facility]< 90,'Kapchorwa District','Manafwa District'),if([ref_facility]< 96,'Mbale City','Namisindwa District')),if([ref_facility]< 104,if([ref_facility]< 103,'Busia District','Butaleja District'),if([ref_facility]< 105,'Pallisa District','Tororo District'))),if([ref_facility]< 165,if([ref_facility]< 162,if([ref_facility]< 159,'Hoima City','Kagadi District'),if([ref_facility]< 164,'Kakumiro District','Kibaale District')),if([ref_facility]< 171,if([ref_facility]< 166,'Kikuube District','Kiryandongo District'),if([ref_facility]< 172,'Masindi District',if([ref_facility]< 177,'Bugiri District','Bugweri District')))))),if([ref_facility]< 253,if([ref_facility]< 234,if([ref_facility]< 215,if([ref_facility]< 203,if([ref_facility]< 188,'Iganga District','Jinja City'),if([ref_facility]< 205,'Jinja District','Mayuge District')),if([ref_facility]< 231,if([ref_facility]< 216,'Namayingo District','Kampala District'),if([ref_facility]< 233,'Amudat District','Moroto District'))),if([ref_facility]< 241,if([ref_facility]< 239,if([ref_facility]< 237,'Kabale District','Kisoro District'),if([ref_facility]< 240,'Rukiga District','Rukungiri District')),if([ref_facility]< 244,if([ref_facility]< 243,'Apac District','Dokolo District'),if([ref_facility]< 250,'Kole District',if([ref_facility]< 252,'Kwania District','Lira City'))))),if([ref_facility]< 332,if([ref_facility]< 297,if([ref_facility]< 257,if([ref_facility]< 254,'Lira District','Buikwe District'),if([ref_facility]< 296,'Kayunga District','Kiboga District')),if([ref_facility]< 299,if([ref_facility]< 298,'Luwero District','Mubende District'),if([ref_facility]< 331,'Mukono District','Gomba District'))),if([ref_facility]< 356,if([ref_facility]< 335,if([ref_facility]< 334,'Kalangala District','Kalungu District'),if([ref_facility]< 345,'Kyotera District','Lyantonde District')),if([ref_facility]< 376,if([ref_facility]< 374,'Masaka City','Masaka District'),if([ref_facility]< 384,'Sembabule District',if([ref_facility]< 393,'Wakiso District','Amuria District'))))))),if([ref_facility]< 469,if([ref_facility]< 433,if([ref_facility]< 413,if([ref_facility]< 399,if([ref_facility]< 396,if([ref_facility]< 395,'Kaberamaido District','Katakwi District'),if([ref_facility]< 398,'Soroti City','Bunyangabu District')),if([ref_facility]< 404,if([ref_facility]< 403,'Kyenjojo District','Adjumani District'),if([ref_facility]< 407,'Arua City','Koboko District'))),if([ref_facility]< 425,if([ref_facility]< 418,if([ref_facility]< 417,'Moyo District','Obongi District'),if([ref_facility]< 422,'Yumbe District','Zombo District')),if([ref_facility]< 427,if([ref_facility]< 426,'Agago District','Amuru District'),if([ref_facility]< 430,'Gulu City','Kitgum District')))),if([ref_facility]< 450,if([ref_facility]< 439,if([ref_facility]< 435,if([ref_facility]< 434,'Nwoya District','Buhweju District'),if([ref_facility]< 438,'Bushenyi District','Ibanda District')),if([ref_facility]< 447,if([ref_facility]< 440,'Kiruhura District','Mbarara City'),if([ref_facility]< 448,'Mitooma District','Ntungamo District'))),if([ref_facility]< 458,if([ref_facility]< 452,if([ref_facility]< 451,'Sheema District','Bududa District'),if([ref_facility]< 453,'Kapchorwa District','Mbale City')),if([ref_facility]< 462,if([ref_facility]< 460,'Busia District','Butaleja District'),if([ref_facility]< 463,'Butebo District',if([ref_facility]< 464,'Pallisa District','Tororo District')))))),if([ref_facility]< 528,if([ref_facility]< 479,if([ref_facility]< 474,if([ref_facility]< 472,if([ref_facility]< 470,'Buliisa District','Hoima City'),if([ref_facility]< 473,'Kagadi District','Kakumiro District')),if([ref_facility]< 477,if([ref_facility]< 476,'Kiryandongo District','Masindi District'),if([ref_facility]< 478,'Bugiri District','Iganga District'))),if([ref_facility]< 488,if([ref_facility]< 485,if([ref_facility]< 482,'Jinja City','Jinja District'),if([ref_facility]< 487,'Kamuli District','Mayuge District')),if([ref_facility]< 525,if([ref_facility]< 489,'Namutumba District','Kampala District'),if([ref_facility]< 526,'Abim District',if([ref_facility]< 527,'Amudat District','Kaabong District'))))),if([ref_facility]< 540,if([ref_facility]< 534,if([ref_facility]< 530,if([ref_facility]< 529,'Kotido District','Napak District'),if([ref_facility]< 532,'Kabale District','Kanungu District')),if([ref_facility]< 537,if([ref_facility]< 536,'Kisoro District','Rubanda District'),if([ref_facility]< 539,'Rukungiri District','Amolatar District'))),if([ref_facility]< 550,if([ref_facility]< 544,if([ref_facility]< 542,'Apac District','Lira City'),if([ref_facility]< 545,'Oyam District','Buikwe District')),if([ref_facility]< 554,if([ref_facility]< 551,'Kiboga District','Luwero District'),if([ref_facility]< 555,'Mityana District',if([ref_facility]< 557,'Mubende District','Mukono District')))))))),if([ref_facility]< 1033,if([ref_facility]< 625,if([ref_facility]< 591,if([ref_facility]< 573,if([ref_facility]< 566,if([ref_facility]< 564,if([ref_facility]< 563,'Nakaseke District','Nakasongola District'),if([ref_facility]< 565,'Butambala District','Kalungu District')),if([ref_facility]< 569,if([ref_facility]< 568,'Kyotera District','Lyantonde District'),if([ref_facility]< 570,'Masaka City','Mpigi District'))),if([ref_facility]< 587,if([ref_facility]< 575,if([ref_facility]< 574,'Rakai District','Sembabule District'),if([ref_facility]< 586,'Wakiso District','Amuria District')),if([ref_facility]< 589,if([ref_facility]< 588,'Bukedea District','Kaberamaido District'),if([ref_facility]< 590,'Kalaki District','Katakwi District')))),if([ref_facility]< 612,if([ref_facility]< 598,if([ref_facility]< 595,if([ref_facility]< 594,'Kumi District','Ngora District'),if([ref_facility]< 597,'Soroti City','Bundibugyo District')),if([ref_facility]< 604,if([ref_facility]< 603,'Fort Portal City','Kabarole District'),if([ref_facility]< 605,'Kamwenge District','Kasese District'))),if([ref_facility]< 619,if([ref_facility]< 614,if([ref_facility]< 613,'Kyegegwa District','Kyenjojo District'),if([ref_facility]< 615,'Adjumani District','Arua City')),if([ref_facility]< 621,if([ref_facility]< 620,'Arua District','Koboko District'),if([ref_facility]< 622,'Maracha District',if([ref_facility]< 623,'Moyo District','Nebbi District')))))),if([ref_facility]< 818,if([ref_facility]< 688,if([ref_facility]< 650,if([ref_facility]< 627,if([ref_facility]< 626,'Terego District','Zombo District'),if([ref_facility]< 641,'Agago District','Amuru District')),if([ref_facility]< 667,if([ref_facility]< 661,'Gulu City','Gulu District'),if([ref_facility]< 677,'Kitgum District','Lamwo District'))),if([ref_facility]< 735,if([ref_facility]< 711,if([ref_facility]< 697,'Nwoya District','Omoro District'),if([ref_facility]< 725,'Pader District','Buhweju District')),if([ref_facility]< 763,if([ref_facility]< 750,'Bushenyi District','Ibanda District'),if([ref_facility]< 792,'Isingiro District',if([ref_facility]< 803,'Kazo District','Kiruhura District'))))),if([ref_facility]< 918,if([ref_facility]< 872,if([ref_facility]< 832,if([ref_facility]< 826,'Mbarara City','Mbarara District'),if([ref_facility]< 844,'Mitooma District','Ntungamo District')),if([ref_facility]< 889,if([ref_facility]< 884,'Rubirizi District','Rwampara District'),if([ref_facility]< 907,'Sheema District','Bududa District'))),if([ref_facility]< 966,if([ref_facility]< 946,if([ref_facility]< 927,'Bukwo District','Bulambuli District'),if([ref_facility]< 956,'Kapchorwa District','Kween District')),if([ref_facility]< 983,if([ref_facility]< 971,'Manafwa District','Mbale City'),if([ref_facility]< 1001,'Mbale District',if([ref_facility]< 1011,'Namisindwa District','Sironko District'))))))),if([ref_facility]< 1500,if([ref_facility]< 1285,if([ref_facility]< 1150,if([ref_facility]< 1081,if([ref_facility]< 1064,if([ref_facility]< 1049,'Budaka District','Busia District'),if([ref_facility]< 1075,'Butaleja District','Butebo District')),if([ref_facility]< 1115,if([ref_facility]< 1095,'Kibuku District','Pallisa District'),if([ref_facility]< 1142,'Tororo District','Buliisa District'))),if([ref_facility]< 1211,if([ref_facility]< 1165,if([ref_facility]< 1157,'Hoima City','Hoima District'),if([ref_facility]< 1182,'Kagadi District','Kakumiro District')),if([ref_facility]< 1248,if([ref_facility]< 1226,'Kibaale District','Kikuube District'),if([ref_facility]< 1256,'Kiryandongo District',if([ref_facility]< 1274,'Masindi District','Bugiri District'))))),if([ref_facility]< 1390,if([ref_facility]< 1330,if([ref_facility]< 1299,if([ref_facility]< 1292,'Bugweri District','Buyende District'),if([ref_facility]< 1310,'Iganga District','Jinja City')),if([ref_facility]< 1354,if([ref_facility]< 1339,'Jinja District','Kaliro District'),if([ref_facility]< 1377,'Kamuli District','Luuka District'))),if([ref_facility]< 1470,if([ref_facility]< 1417,if([ref_facility]< 1406,'Mayuge District','Namayingo District'),if([ref_facility]< 1426,'Namutumba District','Kampala District')),if([ref_facility]< 1478,if([ref_facility]< 1474,'Abim District','Amudat District'),if([ref_facility]< 1486,'Kaabong District',if([ref_facility]< 1490,'Karenga District','Kotido District')))))),if([ref_facility]< 1704,if([ref_facility]< 1588,if([ref_facility]< 1522,if([ref_facility]< 1511,if([ref_facility]< 1509,'Moroto District','Nabilatuk District'),if([ref_facility]< 1515,'Nakapiripirit District','Napak District')),if([ref_facility]< 1556,if([ref_facility]< 1537,'Kabale District','Kanungu District'),if([ref_facility]< 1578,'Kisoro District','Rubanda District'))),if([ref_facility]< 1639,if([ref_facility]< 1618,if([ref_facility]< 1595,'Rukiga District','Rukungiri District'),if([ref_facility]< 1628,'Alebtong District','Amolatar District')),if([ref_facility]< 1658,if([ref_facility]< 1647,'Apac District','Dokolo District'),if([ref_facility]< 1671,'Kole District',if([ref_facility]< 1681,'Kwania District','Lira City'))))),if([ref_facility]< 1811,if([ref_facility]< 1761,if([ref_facility]< 1721,if([ref_facility]< 1710,'Lira District','Otuke District'),if([ref_facility]< 1741,'Oyam District','Buikwe District')),if([ref_facility]< 1783,if([ref_facility]< 1769,'Buvuma District','Kassanda District'),if([ref_facility]< 1798,'Kayunga District','Kiboga District'))),if([ref_facility]< 1909,if([ref_facility]< 1854,if([ref_facility]< 1825,'Kyankwanzi District','Luwero District'),if([ref_facility]< 1888,'Mityana District','Mubende District')),if([ref_facility]< 1952,if([ref_facility]< 1940,'Mukono District','Nakaseke District'),if([ref_facility]< 1963,'Nakasongola District',if([ref_facility]< 1976,'Bukomansimbi District','Butambala District'))))))))),if([ref_facility]< 2901,if([ref_facility]< 2747,if([ref_facility]< 2539,if([ref_facility]< 2299,if([ref_facility]< 2072,if([ref_facility]< 2033,if([ref_facility]< 2002,if([ref_facility]< 1995,'Gomba District','Kalangala District'),if([ref_facility]< 2014,'Kalungu District','Kyotera District')),if([ref_facility]< 2053,if([ref_facility]< 2045,'Lwengo District','Lyantonde District'),if([ref_facility]< 2066,'Masaka City','Masaka District'))),if([ref_facility]< 2258,if([ref_facility]< 2120,if([ref_facility]< 2108,'Mpigi District','Rakai District'),if([ref_facility]< 2130,'Sembabule District','Wakiso District')),if([ref_facility]< 2284,if([ref_facility]< 2272,'Amuria District','Bukedea District'),if([ref_facility]< 2294,'Kaberamaido District','Kalaki District')))),if([ref_facility]< 2379,if([ref_facility]< 2331,if([ref_facility]< 2317,if([ref_facility]< 2305,'Kapelebyong District','Katakwi District'),if([ref_facility]< 2324,'Kumi District','Ngora District')),if([ref_facility]< 2358,if([ref_facility]< 2344,'Serere District','Soroti City'),if([ref_facility]< 2363,'Soroti District','Bundibugyo District'))),if([ref_facility]< 2437,if([ref_facility]< 2404,if([ref_facility]< 2395,'Bunyangabu District','Fort Portal City'),if([ref_facility]< 2422,'Kabarole District','Kamwenge District')),if([ref_facility]< 2499,if([ref_facility]< 2492,'Kasese District','Kitagwenda District'),if([ref_facility]< 2509,'Kyegegwa District',if([ref_facility]< 2533,'Kyenjojo District','Ntoroko District')))))),if([ref_facility]< 2715,if([ref_facility]< 2644,if([ref_facility]< 2593,if([ref_facility]< 2571,if([ref_facility]< 2557,'Adjumani District','Arua City'),if([ref_facility]< 2577,'Arua District','Koboko District')),if([ref_facility]< 2619,if([ref_facility]< 2603,'Madi-Okollo District','Maracha District'),if([ref_facility]< 2632,'Moyo District','Nebbi District'))),if([ref_facility]< 2700,if([ref_facility]< 2657,if([ref_facility]< 2650,'Obongi District','Pakwach District'),if([ref_facility]< 2671,'Terego District','Yumbe District')),if([ref_facility]< 2712,if([ref_facility]< 2711,'Zombo District','Agago District'),if([ref_facility]< 2713,'Amuru District',if([ref_facility]< 2714,'Gulu District','Kitgum District'))))),if([ref_facility]< 2731,if([ref_facility]< 2722,if([ref_facility]< 2719,if([ref_facility]< 2718,'Lamwo District','Omoro District'),if([ref_facility]< 2721,'Pader District','Buhweju District')),if([ref_facility]< 2726,if([ref_facility]< 2724,'Bushenyi District','Ibanda District'),if([ref_facility]< 2730,'Isingiro District','Kazo District'))),if([ref_facility]< 2736,if([ref_facility]< 2734,if([ref_facility]< 2732,'Kiruhura District','Mbarara City'),if([ref_facility]< 2735,'Mbarara District','Mitooma District')),if([ref_facility]< 2742,if([ref_facility]< 2741,'Ntungamo District','Rubirizi District'),if([ref_facility]< 2744,'Rwampara District',if([ref_facility]< 2746,'Sheema District','Bududa District'))))))),if([ref_facility]< 2809,if([ref_facility]< 2775,if([ref_facility]< 2760,if([ref_facility]< 2753,if([ref_facility]< 2751,if([ref_facility]< 2750,'Bukwo District','Bulambuli District'),if([ref_facility]< 2752,'Kapchorwa District','Kween District')),if([ref_facility]< 2758,if([ref_facility]< 2755,'Manafwa District','Mbale City'),if([ref_facility]< 2759,'Mbale District','Namisindwa District'))),if([ref_facility]< 2766,if([ref_facility]< 2763,if([ref_facility]< 2762,'Sironko District','Budaka District'),if([ref_facility]< 2764,'Busia District','Butaleja District')),if([ref_facility]< 2768,if([ref_facility]< 2767,'Butebo District','Kibuku District'),if([ref_facility]< 2771,'Tororo District',if([ref_facility]< 2773,'Buliisa District','Hoima City'))))),if([ref_facility]< 2790,if([ref_facility]< 2781,if([ref_facility]< 2777,if([ref_facility]< 2776,'Hoima District','Kagadi District'),if([ref_facility]< 2780,'Kakumiro District','Kibaale District')),if([ref_facility]< 2784,if([ref_facility]< 2783,'Kikuube District','Kiryandongo District'),if([ref_facility]< 2789,'Masindi District','Bugiri District'))),if([ref_facility]< 2798,if([ref_facility]< 2793,if([ref_facility]< 2791,'Bugweri District','Buyende District'),if([ref_facility]< 2794,'Iganga District','Jinja City')),if([ref_facility]< 2802,if([ref_facility]< 2800,'Jinja District','Kaliro District'),if([ref_facility]< 2805,'Kamuli District',if([ref_facility]< 2806,'Luuka District','Mayuge District')))))),if([ref_facility]< 2858,if([ref_facility]< 2833,if([ref_facility]< 2828,if([ref_facility]< 2811,if([ref_facility]< 2810,'Namayingo District','Namutumba District'),if([ref_facility]< 2827,'Kampala District','Amudat District')),if([ref_facility]< 2830,if([ref_facility]< 2829,'Karenga District','Nabilatuk District'),if([ref_facility]< 2832,'Nakapiripirit District','Napak District'))),if([ref_facility]< 2845,if([ref_facility]< 2841,if([ref_facility]< 2837,'Kabale District','Kanungu District'),if([ref_facility]< 2844,'Kisoro District','Rubanda District')),if([ref_facility]< 2854,if([ref_facility]< 2848,'Rukiga District','Rukungiri District'),if([ref_facility]< 2856,'Alebtong District',if([ref_facility]< 2857,'Amolatar District','Apac District'))))),if([ref_facility]< 2868,if([ref_facility]< 2862,if([ref_facility]< 2860,if([ref_facility]< 2859,'Dokolo District','Kole District'),if([ref_facility]< 2861,'Kwania District','Lira City')),if([ref_facility]< 2865,if([ref_facility]< 2864,'Lira District','Otuke District'),if([ref_facility]< 2866,'Oyam District','Buikwe District'))),if([ref_facility]< 2876,if([ref_facility]< 2873,if([ref_facility]< 2869,'Buvuma District','Kassanda District'),if([ref_facility]< 2875,'Kayunga District','Kiboga District')),if([ref_facility]< 2886,if([ref_facility]< 2877,'Kyankwanzi District','Luwero District'),if([ref_facility]< 2890,'Mityana District',if([ref_facility]< 2898,'Mukono District','Nakaseke District')))))))),if([ref_facility]< 3041,if([ref_facility]< 2979,if([ref_facility]< 2946,if([ref_facility]< 2917,if([ref_facility]< 2908,if([ref_facility]< 2905,if([ref_facility]< 2904,'Nakasongola District','Bukomansimbi District'),if([ref_facility]< 2906,'Gomba District','Kalangala District')),if([ref_facility]< 2912,if([ref_facility]< 2910,'Kalungu District','Kyotera District'),if([ref_facility]< 2915,'Lwengo District','Masaka City'))),if([ref_facility]< 2941,if([ref_facility]< 2921,if([ref_facility]< 2919,'Masaka District','Mpigi District'),if([ref_facility]< 2923,'Sembabule District','Wakiso District')),if([ref_facility]< 2944,if([ref_facility]< 2942,'Amuria District','Bukedea District'),if([ref_facility]< 2945,'Kalaki District','Kapelebyong District')))),if([ref_facility]< 2960,if([ref_facility]< 2954,if([ref_facility]< 2951,if([ref_facility]< 2948,'Katakwi District','Kumi District'),if([ref_facility]< 2952,'Ngora District','Serere District')),if([ref_facility]< 2956,if([ref_facility]< 2955,'Soroti City','Soroti District'),if([ref_facility]< 2959,'Bundibugyo District','Bunyangabu District'))),if([ref_facility]< 2970,if([ref_facility]< 2963,if([ref_facility]< 2962,'Fort Portal City','Kabarole District'),if([ref_facility]< 2966,'Kamwenge District','Kasese District')),if([ref_facility]< 2973,if([ref_facility]< 2971,'Kitagwenda District','Kyegegwa District'),if([ref_facility]< 2976,'Kyenjojo District',if([ref_facility]< 2978,'Ntoroko District','Adjumani District')))))),if([ref_facility]< 3006,if([ref_facility]< 2988,if([ref_facility]< 2984,if([ref_facility]< 2982,if([ref_facility]< 2981,'Arua City','Arua District'),if([ref_facility]< 2983,'Madi-Okollo District','Maracha District')),if([ref_facility]< 2986,if([ref_facility]< 2985,'Moyo District','Nebbi District'),if([ref_facility]< 2987,'Obongi District','Pakwach District'))),if([ref_facility]< 3001,if([ref_facility]< 2992,if([ref_facility]< 2989,'Terego District','Yumbe District'),if([ref_facility]< 2993,'Zombo District','Kampala District')),if([ref_facility]< 3003,if([ref_facility]< 3002,'Gulu City','Mbarara City'),if([ref_facility]< 3004,'Mbale City',if([ref_facility]< 3005,'Hoima City','Jinja City'))))),if([ref_facility]< 3014,if([ref_facility]< 3010,if([ref_facility]< 3008,if([ref_facility]< 3007,'Moroto District','Kabale District'),if([ref_facility]< 3009,'Lira City','Kayunga District')),if([ref_facility]< 3012,if([ref_facility]< 3011,'Mubende District','Masaka City'),if([ref_facility]< 3013,'Wakiso District','Soroti City'))),if([ref_facility]< 3022,if([ref_facility]< 3016,if([ref_facility]< 3015,'Fort Portal City','Arua City'),if([ref_facility]< 3017,'Yumbe District','Gulu City')),if([ref_facility]< 3026,if([ref_facility]< 3025,'Kitgum District','Lamwo District'),if([ref_facility]< 3039,'Omoro District',if([ref_facility]< 3040,'Pader District','Bushenyi District'))))))),if([ref_facility]< 3173,if([ref_facility]< 3108,if([ref_facility]< 3058,if([ref_facility]< 3052,if([ref_facility]< 3048,if([ref_facility]< 3047,'Ibanda District','Isingiro District'),if([ref_facility]< 3051,'Kazo District','Kiruhura District')),if([ref_facility]< 3056,if([ref_facility]< 3055,'Mbarara City','Mbarara District'),if([ref_facility]< 3057,'Sheema District','Mbale City'))),if([ref_facility]< 3073,if([ref_facility]< 3066,if([ref_facility]< 3059,'Budaka District','Butaleja District'),if([ref_facility]< 3072,'Kagadi District','Kakumiro District')),if([ref_facility]< 3084,if([ref_facility]< 3082,'Kiryandongo District','Bugweri District'),if([ref_facility]< 3094,'Jinja City',if([ref_facility]< 3095,'Jinja District','Kampala District'))))),if([ref_facility]< 3145,if([ref_facility]< 3118,if([ref_facility]< 3110,if([ref_facility]< 3109,'Kisoro District','Apac District'),if([ref_facility]< 3114,'Kole District','Kwania District')),if([ref_facility]< 3124,if([ref_facility]< 3119,'Oyam District','Buikwe District'),if([ref_facility]< 3133,'Kayunga District','Mukono District'))),if([ref_facility]< 3158,if([ref_facility]< 3148,if([ref_facility]< 3147,'Kyotera District','Lyantonde District'),if([ref_facility]< 3149,'Masaka City','Sembabule District')),if([ref_facility]< 3167,if([ref_facility]< 3165,'Wakiso District','Bunyangabu District'),if([ref_facility]< 3170,'Kamwenge District',if([ref_facility]< 3172,'Kyenjojo District','Adjumani District')))))),if([ref_facility]< 3225,if([ref_facility]< 3213,if([ref_facility]< 3197,if([ref_facility]< 3193,if([ref_facility]< 3192,'Arua City','Pakwach District'),if([ref_facility]< 3195,'Yumbe District','Zombo District')),if([ref_facility]< 3202,if([ref_facility]< 3198,'Iganga District','Kampala District'),if([ref_facility]< 3203,'Apac District','Wakiso District'))),if([ref_facility]< 3217,if([ref_facility]< 3215,if([ref_facility]< 3214,'Arua City','Mitooma District'),if([ref_facility]< 3216,'Budaka District','Kibuku District')),if([ref_facility]< 3220,if([ref_facility]< 3219,'Pallisa District','Hoima District'),if([ref_facility]< 3221,'Kagadi District',if([ref_facility]< 3222,'Masindi District','Kaliro District'))))),if([ref_facility]< 3250,if([ref_facility]< 3243,if([ref_facility]< 3237,if([ref_facility]< 3226,'Namayingo District','Kampala District'),if([ref_facility]< 3239,'Lira City','Mityana District')),if([ref_facility]< 3246,if([ref_facility]< 3245,'Mubende District','Kalungu District'),if([ref_facility]< 3248,'Lwengo District','Mpigi District'))),if([ref_facility]< 3333,if([ref_facility]< 3329,if([ref_facility]< 3328,'Wakiso District','Serere District'),if([ref_facility]< 3330,'Kabarole District','Kasese District')),if([ref_facility]< 3344,if([ref_facility]< 3334,'Kiboga District','Wakiso District'),if([ref_facility]< 3345,'Kasese District',if([ref_facility]< 3346,'Kampala District','Wakiso District'))))))))))
)

How `facility_level` is derived for value 3001

Not satisfied5 preceding range conditions
Satisfied[ref_facility]>=3001 and [ref_facility]<=3016
Returns'RRH'

Show the complete facility_level expression

if([ref_facility]>=1 and [ref_facility]<=424,'Clinic',
if([ref_facility]>=425 and [ref_facility]<=626,'General Hospital',
if([ref_facility]>=627 and [ref_facility]<=2710,'HC III',
if([ref_facility]>=2711 and [ref_facility]<=2992,'HC IV',
if([ref_facility]>=2993 and [ref_facility]<=3000,'NRH',
if([ref_facility]>=3001 and [ref_facility]<=3016,'RRH',
if([ref_facility]>=3017 and [ref_facility]<=3196,'Clinic',
if([ref_facility]>=3197 and [ref_facility]<=3213,'General Hospital',
if([ref_facility]>=3214 and [ref_facility]<=3332,'HC III',
if([ref_facility]>=3333 and [ref_facility]<=3344,'HC IV', if([ref_facility]>=3345 and [ref_facility]<=3346,'General Hospital', '' )))))))))))

Both expressions depend on each facility keeping its position in the list. Section 7 explains why positions are never changed.

7Positional choice lists

In REDCap a dropdown stores the code to the left of the comma, not the label. In ICCC-3 Groups III, IV, VII and VIII of this registry, that code is a sequence number, and a calculated field converts it to the ICD-O-3.2 code. Three of the 26 choices of iv_morph (Group IV):

Stored value	Label shown to the abstractor	`iv_code` returns

if([iv_morph]='','',
 if([iv_morph]>=1 and [iv_morph]<=2, 9490,
 if([iv_morph]=3, 9500,
 if([iv_morph]>=4 and [iv_morph]<=6, 8680,
 if([iv_morph]=7, 8681,
 …

If a new choice were inserted at position 3 and the list renumbered, every record holding the stored value 3 would display the new choice, and iv_code would return its code. No record would have been edited. In a REDCap project in development status, such a change takes effect immediately and without a warning. The registry therefore applies three rules to positional lists:

New choices are appended after the last existing code.
Existing codes are never deleted, reordered or renumbered.
A superseded choice keeps its code; its label is prefixed [RETIRED] and the choice is hidden from new entry with the @HIDECHOICE action tag.

8Method

Labels, choices and expressions were exported from the UCI-Ped-Reg REDCap data dictionary on 1 October 2026 through the REDCap API (metadata only; no records). The Group X expression x_extended is shown in its corrected form of 13 October 2026, in which the site conditions and the Xa5 morphology list follow the ICCC-3 (2017) definitions. The page evaluates them with a parser that follows REDCap's comparison rules: equality is numeric when both operands are numbers and textual otherwise, and an ordering comparison with a blank operand is false.

1Scope

2Data entry

3Calculated values

How x_extended is derived

How x_subgroup is derived

4Effect of topography

5Age at the first UCI visit

6Location and level of the referring facility

How facility_location is derived for value 3001

How facility_level is derived for value 3001

7Positional choice lists

8Method

How `x_extended` is derived

How `x_subgroup` is derived

How `facility_location` is derived for value 3001

How `facility_level` is derived for value 3001