FILER_LINKS_CD

Links filers to each other.

Fields

Information about the 10 fields and the definitions of any abbreviated values.

FILER_ID_A Integer · Unique

Unique identification number for the first filer in the relationship

FILER_ID_B Integer · Unique

Unique identification number for the second filer in the relationship

ACTIVE_FLG String (up to 1) · Unique

Indicates if the link is active

SESSION_ID Integer · Unique

Legislative session identification number

LINK_TYPE Integer · Unique

Denotes the type of the link

Code	Definition
`-12019`	CANDIDATE CONTROLLED CAUCUS COMMITTEE
`-12018`	PROPONENT
`-12016`	TREASURER/RESPONSIBLE OFFICER FOR
`-12015`	ASSOCIATED
`-12014`	SUPPORT
`-12013`	OPPOSE
`-12011`	CONTROLLING CANDIDATE
`-12008`	FIRM OF A LOBBYIST
`-12005`	FIRM OF A CLIENT (WHO IS ALSO A FIRM)
`-12004`	FIRM OF A CLIENT (WHO IS AN EMPLOYER)
`-12002`	EMPLOYER OF AN IN-HOUSE LOBBYIST
`-12001`	CLIENT OF A FIRM
`0`	N/A
`12001`	FIRM OF A CLIENT
`12002`	IN-HOUSE LOBBYIST OF AN EMPLOYER
`12004`	CLIENT (WHO IS AN EMPLOYER) OF A FIRM
`12005`	CLIENT (WHO IS ALSO A FIRM) OF ANOTHER FIRM
`12008`	LOBBYIST OF A FIRM
`12011`	CANDIDATE CONTROLS THIS COMMITTEE
`12013`	OPPOSE
`12014`	SUPPORT
`12015`	ASSOCIATED
`12016`	TREASURER/RESPONSIBLE OFFICER
`12018`	PROPONENT
`12019`	CANDIDATE CONTROLLED CAUCUS COMMITTEE
Sources: Lookup-Codes-Cd (6-7)

LINK_DESC String (up to 255)

Unused

EFFECT_DT Date (without time)

Date the link became active

DOMINATE_FILER String (up to 1)

Unused

TERMINATION_DT Date (without time)

Termination effective date

The documents that provided the information on this page.