filer

affAbbr

Abbreviation of the affiliated union (e.g. "IUOE").

city

City of the filer's reported address.

detailId

OLMS internal detail identifier.

name

Filer's name (last, first).

srFilerId

OLMS surrogate filer ID. Primary key. The detail servlet is keyed by this.

srNum

The filer's "U-" file number (shown as "U-"+srNum on the report). One srNum can map to several srFilerIds.

state

State of the filer's reported address.

suffix

Name suffix, when present.

unionCity

City of that labor organization.

unionName

Name of the labor organization the filer reports against.

unionState

State of that labor organization.

18,159 rows

✎ View and edit SQL

Next page

CREATE TABLE "filer" (
   [srFilerId] INTEGER PRIMARY KEY,
   [srNum] INTEGER,
   [name] TEXT,
   [suffix] TEXT,
   [city] TEXT,
   [state] TEXT,
   [affAbbr] TEXT,
   [unionName] TEXT,
   [unionCity] TEXT,
   [unionState] TEXT,
   [detailId] INTEGER
);