This file contains one record for each candidate to committee linakge registered with the Federal Election Commission.
The end-of-line (EOL) marker is line feed '\n' (LF, 0x0A, 10 in decimal). The Candidate to Committee Linkage file contains the following information:
| Column Name | Field Name | Position | Null? | Data Type | Description |
| CAND_ID |
Candidate Identification |
1 | N | VARCHAR2 (9 Byte) |
A 9-character alpha-numeric code assigned to a candidate by the Federal Election Commission. The candidate ID for a specific candidate remains the same across election cycles as long as the candidate is running for the same office. |
| CAND_ELECTION_YR |
Candidate Election Year |
2 | N | NUMBER (4) |
Candidate's election year |
| FEC_ELECTION_YR |
FEC Election Year |
3 | N | NUMBER (4) |
Active 2-year period |
| CMTE_ID |
Committee Identification |
4 | Y | VARCHAR2 (9 Byte) |
A 9-character alpha-numeric code assigned to a committee by the Federal Election Commission. The committee ID for a specific committee always remains the same. |
| CMTE_TP |
Committee Type |
5 | Y | VARCHAR2 (1 Byte) |
List of committee type codes |
| CMTE_DSGN |
Committee Designation |
6 | Y | VARCHAR2 (1 Byte) |
A = Authorized by a candidate B = Lobbyist/Registrant PAC D = Leadership PAC J = Joint fundraiser P = Principal campaign committee of a candidate U = Unauthorized |
| LINKAGE_ID |
Linkage ID |
7 | N | NUMBER (12) |
Unique link ID |
