Skip to contents

The crosswalk maps each title to one role, but some titles mean different things in different organizations:

  • A PRESIDENT is the paid chief executive in one organization and a volunteer board chair in the next.
  • A VICE PRESIDENT may sit on the board or on staff.
  • A DIRECTOR may be a board member or a department head.

conditional_logic() (a wrapper for resolve_roles()) settles these with what the filer reported about each person: the Part VII checkboxes (trustee, officer, key employee, highly compensated), pay and hours. It also names the chief executive when no title does, and decides that a filing has none when the board runs the organization.

Before and after

Four example filings, built by hand. “Before” is the title-only answer from steps 07-08. “After” is step 09’s answer for each person.

Boxes: T trustee, O officer, K key employee, H highly compensated.

A large organization (990). org.leadership: designated; org.type: NA (none)
title pay hours boxes before: title only after: step 09 method
President & CEO 410,000 55 O CEO CEO (designated) rules
Chair of the Board 0 5 TO BOARD CHAIR BOARD CHAIR rules
Treasurer 0 3 TO BOARD TREASURER BOARD TREASURER rules
Director 0 2 T BOARD MEMBER BOARD MEMBER rules
Chief Financial Officer 260,000 50 O OFFICER OFFICER rules
VP of Development 190,000 45 K OFFICER OFFICER rules
Director of Nursing 175,000 40 H MANAGER MANAGER rules
Staff Physician 320,000 40 H PROFESSIONAL PROFESSIONAL rules

The checkboxes settle most of filing A. The CEO is designated by a CEO-level title in an officer position. The board titles with the trustee box are board seats. The paid staff keep the level their title implies.

B paid president, no CEO title (990). org.leadership: imputed; org.type: NA (none)
title pay hours boxes before: title only after: step 09 method
President 85,000 40 TO BOARD CHAIR CEO (imputed) rules
Vice President 0 2 T BOARD VICE CHAIR BOARD VICE CHAIR rules
Secretary 0 2 TO BOARD SECRETARY BOARD SECRETARY rules
Program Director 42,000 40 MANAGER MANAGER rules

No title in filing B names a CEO, but the president is paid $85,000 for 40 hours a week and ticks the officer box: the president is the imputed CEO. The unpaid vice president is a board seat (VICE CHAIR), not a staff officer.

C run by its board (990). org.leadership: board_governed; org.type: NA (none)
title pay hours boxes before: title only after: step 09 method
President 6,000 5 TO BOARD CHAIR BOARD CHAIR rules
Secretary 0 2 TO BOARD SECRETARY BOARD SECRETARY rules
Treasurer 0 2 TO BOARD TREASURER BOARD TREASURER rules
Bookkeeper 18,000 10 STAFF STAFF rules

Filing C pays its president a $6,000 stipend for 5 hours a week. A board title held under 10 hours a week for under $25,000 is a board seat, even with the officer box. No paid person qualifies as a leader (the bookkeeper is staff), so the filing is board_governed: no CEO is named.

D small organization (990-EZ). org.leadership: model; org.type: NA (none)
title pay hours boxes before: title only after: step 09 method
President 38,000 40 none on a 990-EZ BOARD CHAIR CEO (model) model (rules alone: CEO)
Administrator 30,000 40 none on a 990-EZ MANAGER OFFICER model (rules alone: MANAGER)
Director of Operations 0 10 none on a 990-EZ MANAGER BOARD MEMBER model (rules alone: MANAGER)
Secretary 0 2 none on a 990-EZ BOARD SECRETARY BOARD SECRETARY model (rules alone: BOARD)
Treasurer 0 2 none on a 990-EZ BOARD TREASURER BOARD TREASURER model (rules alone: BOARD)

A 990-EZ has no checkboxes. When the xgboost package is installed, roles on a 990-EZ come from the no-checkbox model, and role.method says model. Without xgboost, or with resolve_roles(use_model = FALSE), the rules decide. Here they disagree on two people: - Director of Operations. The rules read the title as a department head (MANAGER). The model reads an unpaid person working 10 hours a week in a small filing as a volunteer board member. - Administrator. The model makes the second paid full-timer an officer rather than a manager.

Rules and models explains the difference.

Some kinds of organization name their chief executive with a title of their own. The CEO thesaurus covers them (see below).

E country club (990). org.leadership: thesaurus; org.type: club (inferred)
title pay hours boxes before: title only after: step 09 method
Golf Course Superintendent 142,000 50 H MANAGER MANAGER rules
General Manager 128,000 55 O MANAGER CEO (thesaurus) rules
Executive Chef 96,000 50 H STAFF STAFF rules
President 0 4 TO BOARD CHAIR BOARD CHAIR rules
Treasurer 0 2 TO BOARD TREASURER BOARD TREASURER rules

In a country club the general manager runs the club, even when the golf course superintendent is paid more. The taxonomy files GENERAL MANAGER as a manager, not a CEO-level title. The name marks filing E as a club, so the thesaurus makes the general manager the thesaurus CEO.

F lodge (990). org.leadership: board_governed; org.type: fraternal (inferred)
title pay hours boxes before: title only after: step 09 method
Secretary 21,000 20 O BOARD SECRETARY OFFICER rules
Exalted Ruler 0 10 TO BOARD CHAIR BOARD CHAIR rules
Treasurer 3,000 5 TO BOARD TREASURER BOARD TREASURER rules
Trustee 0 2 T BOARD MEMBER BOARD MEMBER rules
Bookkeeper 12,000 12 STAFF STAFF rules

A lodge’s secretary is often paid a stipend for keeping the books. Pay alone would make the secretary of filing F the CEO. The thesaurus marks a fraternal secretary paid under $40,000 for under 35 hours a week as never the CEO. The secretary stays an officer and the lodge is board_governed: no one runs it as a paid executive. The bookkeeper is part-time staff.

What it does

conditional_logic()  ->  resolve_roles()
|
+- 1. position, per row       trustee box = board; officer box = officer; both = board_officer;
|                             key-employee or high-comp box = staff; a paid CEO- or
|                             officer-level title counts as an officer without the box
+- 2. one role per person     a person with split titles (PRESIDENT & TREASURER) gets
|                             the most senior position; role.primary marks one row
+- 3. leadership, per filing  a CEO-level title in an officer position = designated CEO;
|                             else the highest-paid plausible leader = imputed CEO;
|                             else one unpaid full-time leader with the officer box = imputed CEO;
|                             else board_governed (paid people, no leader) or no_paid
+- 4. CEO thesaurus           for the organization's type, a title that runs it = thesaurus CEO
+- 5. final role              CEO, OFFICER, MANAGER, PROFESSIONAL, STAFF or BOARD,
|                             and for BOARD the board role
+- 6. 990-EZ                  the no-checkbox model replaces the rules' answer
                              (the thesaurus still applies after it)

These thresholds keep token pay from making a leader:

  • Imputed CEO. A leader with no CEO title must have the officer box or a leadership title. They must also work at least 15 hours a week or earn at least $25,000. When hours are reported, they must be at least 5 a week, unless the person is a president: pay for a seat held an hour a week is a stipend, or pay from a related organization.
  • Board chair pattern. A paid board chair with the trustee box who works under 25 hours a week is not imputed as CEO.
  • Stipend rule. A board title held under 10 hours a week for under $25,000 is a board seat, with or without the officer box. On a 990-EZ the same holds for a board title paid a small fee. When the 990-EZ model names a CEO with no CEO-level title who works under 20 hours for under $50,000, the rules’ answer stands.
  • Unpaid full-time leader. When no one else is the CEO, an unpaid president, chair or leader with the officer box who works 35+ hours a week runs the organization. If several people tie for the most hours, no one is named.

Board roles have rules of their own:

  • Past and elect. A past president or president-elect holds a seat (MEMBER), not the office. The flags come from step 06’s FORMER and FUTURE statuses. A dated change is the exception: CHAIR THRU 6/20 held the office for part of the year.
  • Secretary-treasurer. The combined office is kept whole, as SECRETARY TREASURER.

The CEO thesaurus

A post adjutant, a club’s general manager, a union local’s business manager and a senior pastor each run their organization, but their titles are not CEO-level titles in the taxonomy. ceo.thesaurus lists such titles by organization type, as regular expressions on the cleaned title. Each entry has an effect:

  • ceo: the holder runs the organization when paid at least min_pay and working at least min_hours. They are named when the filing has no CEO, when its CEO was only imputed from pay, or when its CEO’s title matches outranks: a university president over a chancellor, a union’s business manager over a paid president.
  • not_ceo: a holder paid under min_pay and working under min_hours is never imputed as CEO. Examples are a lodge secretary or a post treasurer on a stipend.
th <- get_ceo_thesaurus()
knitr::kable(th[, c("org_type", "title_pattern", "effect", "min_hours", "min_pay", "outranks")])
org_type title_pattern effect min_hours min_pay outranks
veterans ceo 20 25000
veterans TREASURER|FINANCE OFFICER|QUARTERMASTER|TRUSTEE|SECRETARY|ADJUTANT)not_ceo 35 30000
fraternal SECRETARY|RECORDER|TREASURER)not_ceo 35 40000
club GENERAL MANAGER|CLUB MANAGER|GM)ceo 20 25000 SUPERINTENDENT|GOLF|PROFESSIONAL|\b|CHEF|CONTROLLER|DIRECTOR OF
club POOL|SNACK|CANTEEN|BAR|GROUNDS) MANAGERnot_ceo NA 25000
coop GENERAL MANAGER|GM)ceo 20 25000
trust ^(FUND |PLAN |TRUST |BENEFITS? )?A?D?MINISTRATORceo 20 25000
union BUSINESS MANAGER|BUS MGR)ceo 20 25000 PRESIDENT
university ^PRESIDENTceo 20 50000 CHANCELLOR|PROVOST|VICE PRESIDENT|
ministry ^(SENIOR |LEAD |GENERAL |HEAD )?PASTOR\b|\b|\b|RABBI\b|RECTORceo 20 0
fire ^(FIRE )?CHIEF$|^FIRE CHIEFceo 20 25000
fire SECRETARY|TREASURER)not_ceo 35 40000
cemetery not_ceo NA 1

The organization type, org.type, comes from the first of these that the input has (org.type.source records which):

  1. supplied: an org.type column, one of org_type_levels();
  2. codes: the IRS Business Master File’s NTEE code and 501(c) subsection, in columns ntee_code_clean and subsection_code (or ntee and subsection), mapped by org_type_from_codes(). For example, 501(c)(19) is veterans, 501(c)(8) fraternal and NTEE M24 fire;
  3. inferred: the organization’s name and titles, read by org_type_from_name(): AMERICAN LEGION, LODGE, COUNTRY CLUB, LOCAL 123, or an ADJUTANT or EXALTED RULER among the titles.
org_type_from_codes(ntee = c("J40", NA, "M24", "X21"), subsection = c(5, 19, 3, 3))
#> [1] "union"    "veterans" "fire"     "ministry"
org_type_from_name(c("AMERICAN LEGION POST 12", "OAK HILL COUNTRY CLUB", "SMITH COLLEGE"))
#> [1] "veterans"   "club"       "university"

Codes are more reliable than names. To use them, join the NCCS unified BMF (panel990::bmf_retrieve()) to the Part VII rows by EIN before step 01:

bmf <- panel990::bmf_retrieve()   # EIN2, ntee_code_clean, subsection_code, ...
d <- merge(partvii, bmf[, c("EIN2", "ntee_code_clean", "subsection_code")], by = "EIN2", all.x = TRUE)
d |>
  standardize_df() |> remove_dates() |> standardize_conj() |> split_titles() |>
  standardize_spelling() |> gen_status_codes() |> standardize_titles() |>
  categorize_titles() |> conditional_logic()

In checks against hand labels, the thesaurus raised the share of filings with the right chief executive from 85.1% to 87.6% on the 750 filings it was written from. On 126 filings from organizations it had not seen, the share rose from 79.4% to 81.7%. The gains were largest for lodges, clubs and ministries. A later fix, letting a better-paid university president outrank a paid chancellor, raised the 750-filing share to 88.1% (Performance).

Columns added

Column Values
role.final CEO, OFFICER, MANAGER, PROFESSIONAL, STAFF, BOARD
role.board for BOARD: CHAIR, VICE CHAIR, SECRETARY TREASURER, SECRETARY, TREASURER, MEMBER
role.ceo for CEO: designated, co-ceo, interim, imputed, thesaurus, model
role.position board, officer, board_officer, staff, unknown
role.source what settled the position: checkbox, title+pay, title
role.method rules, or model (990-EZ with xgboost installed)
role.primary TRUE on one row per person (count people with it)
org.leadership per filing: designated, thesaurus, imputed, model, board_governed, no_paid
org.type per filing: veterans, fraternal, union, club, coop, trust, cemetery, university, ministry, fire, orchestra, or NA
org.type.source supplied, codes, inferred, or none

The crosswalk’s own emp.level and board.role are kept: role.final is the resolved answer, the crosswalk columns the title-only default. Taxonomy defines each value.

Assets

Asset Type Used for Load it with
emp.level, board.role columns of title.taxonomy (from step 08) the title-only role each rule starts from get_title_taxonomy()
the role model xgboost model file, inst/extdata/role-model/ roles on 990-EZ filings predict_roles(); features from role_model_features()
ceo.thesaurus crosswalk (package data, data-raw/crosswalks/ceo-thesaurus.csv) chief-executive and stipend titles by organization type get_ceo_thesaurus()
organization types functions the type each filing is matched on org_types(), org_type_from_codes(), org_type_from_name()
system.file("extdata", "role-model", package = "titleclassifier") |> list.files()
#> [1] "feature-names.txt" "role-model.ubj"
# the model's input: one row per person-title, no checkboxes
X <- role_model_features(ex[ex$object.id == "D small organization (990-EZ)", ])
dim(X)
#> [1]   5 100
head(colnames(X), 12)
#>  [1] "comp"     "hours"    "paid"     "former"   "interim"  "co"      
#>  [7] "founder"  "exoff"    "n_titles" "n_people" "n_paid"   "pay_rank"
predict_roles(ex[ex$object.id == "D small organization (990-EZ)", ])
#> [1] "CEO"     "OFFICER" "BOARD"   "BOARD"   "BOARD"

Try it on the demo data

data(tinypartvii)
set.seed(8)
d <- dplyr::sample_n(tinypartvii, 1500)
df <- d |>
  standardize_df() |> remove_dates() |> standardize_conj() |>
  split_titles() |> standardize_spelling() |> gen_status_codes() |>
  standardize_titles() |> categorize_titles() |> conditional_logic()
#> [OK] standardize df step complete
#> [OK] remove dates step complete
#> [OK] standardize conjunctions step complete
#> [OK] split titles step complete
#> [OK] standardize spelling step complete
#> [OK] generate status codes step complete
#> [OK] standardize titles step complete
#> [OK] categorize titles step complete
#> 
#> [OK] conditional logic step complete

people <- dplyr::filter(df, role.primary)
table(people$role.final)
#> 
#>        BOARD          CEO      MANAGER      OFFICER PROFESSIONAL        STAFF 
#>         1335          115            2           27            1           20
table(people$formtype, people$role.method)
#>        
#>         model rules
#>   990       0  1082
#>   990EZ   418     0

Titles the crosswalk files as board seats but that resolve otherwise, here a paid board president who runs the organization:

people |>
  dplyr::filter(title.standard == "BOARD PRESIDENT", role.final != "BOARD") |>
  dplyr::select(org.name, title.raw, tot.comp, tot.hours, role.final, role.ceo) |>
  head(8)
#>                                                              org.name
#> 1                                  MOUNTAINEER UNITED SOCCER CLUB INC
#> 2                                 Noah Webster Educational Foundation
#> 3                            LABORERS' INTERNATIONAL UNION LOCAL 1092
#> 4 LOCAL NO 1 ELEVATOR CONSTRUCTORS UNIONOF NEW YORK CITY AND VICINITY
#> 5                              JUNIOR ACHIEVEMENT OF THE OCOEE REGION
#> 6                            AMERICAN FEDERATION OF LABOROHIO AFL-CIO
#> 7                                            THE KEYSTONE PROJECT INC
#> 8                                   NATIONAL GREYHOUND FOUNDATION INC
#>                title.raw tot.comp tot.hours role.final role.ceo
#> 1              President        0        40        CEO  imputed
#> 2              President    55015        30        CEO  imputed
#> 3              PRESIDENT   255118        40        CEO  imputed
#> 4 PRESIDENT/BUSINESS MGR   423136        55        CEO  imputed
#> 5              PRESIDENT    62704        40        CEO  imputed
#> 6              PRESIDENT   302557        40        CEO  imputed
#> 7              PRESIDENT   106291        40        CEO  imputed
#> 8              PRESIDENT        0        40        CEO  imputed

How each filing is led:

df |>
  dplyr::distinct(object.id, formtype, org.leadership) |>
  dplyr::count(formtype, org.leadership)
#>   formtype org.leadership   n
#> 1      990 board_governed  61
#> 2      990     designated  32
#> 3      990        imputed  63
#> 4      990        no_paid 770
#> 5    990EZ board_governed  21
#> 6    990EZ     designated  12
#> 7    990EZ          model   8
#> 8    990EZ        no_paid 353

Input: the output of categorize_titles(). Output: the same rows with the role columns added. See Performance for how often the roles agree with hand labels.