affiliates_yyyy

Title:	affiliates_yyyy
Short Name:	affiliates_yyyy
Status:	Completed
Abstract:	These data are assembled for analysis required by the Regulatory Flexibility Act. Fishing vessels (permits) are linked together, an industry determination is made, and firms are classified as small or large based on SBA guidelines. Per SBA guidelines, we use revenue data in a single year to make the industry determination. Per SBA guidelines, we use 3 year trailing average to make the small determination.

Entity Type:	Data File
Active Version?:	Yes
Description:	These data are assembled for analysis required by the Regulatory Flexibility Act. Fishing vessels (permits) are linked together, an industry determination is made, and firms are classified as small or large based on SBA guidelines. Per SBA guidelines, we use revenue data in a single year to make the industry determination. Per SBA guidelines, we use 3 year trailing average to make the small determination.

	Name	Type	Description
N/A	affiliate_id	NUMBER	Affiliate_id is "constant" for all permits which have identical person_id's associated with it
N/A	year	NUMBER	Year
N/A	count_permits	NUMBER	count_permits contains the number of permits owned by an Affiliate_id. It is constant across Affiliate_id and Year groupings.
N/A	entity_type_yyyy	CHARACTER	FINFISH, SHELLFISH, FORHIRE, or NO_REV based on highest revenues in year YYYY. Entity_type is NO_REV if the entity had zero fishing revenues in year YYYY. An affiliate_id may be classifed as NO_REV if it had revenues in earlier years. Entity_type_YYYY takes on the same value for each distinct affiliate_id in all years.
N/A	small_business	NUMBER	Small Business is based on the SBA guidelines, entity_type, and affiliate_total. An entity that is classified as NO_REV is classified as small.
N/A	permit	NUMBER	Permit
N/A	affiliate_total	NUMBER	total revenues for a AFFILIATE_ID in a year
N/A	affiliate_shellfish	NUMBER	shellfish revenues for a AFFILIATE_ID in a year
N/A	affiliate_finfish	NUMBER	finfish revenues for a AFFILIATE_ID in a year
N/A	affiliate_forhire	NUMBER	for-hire revenues for a AFFILIATE_ID in a year
N/A	value_permit	NUMBER	value_permit are the analogous values for a PERMIT in a year
N/A	value_permit_finfish	NUMBER	value_permit_finfish are the analogous values for a PERMIT in a year
N/A	value_permit_shellfish	NUMBER	value_permit_shellfish are the analogous values for a PERMIT in a year
N/A	value_permit_forhire	NUMBER	value_permit_forhire are the analogous values for a PERMIT in a year
N/A	value000	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value001	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value003	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value006	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value011	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value012	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value013	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value018	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value019	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value023	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value024	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value026	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value027	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value031	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value032	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value033	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value045	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value051	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value052	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value057	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value063	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value067	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value068	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value076	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value077	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value081	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value082	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value087	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value090	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value093	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value096	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value098	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value099	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value104	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value105	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value106	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value107	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value112	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value114	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value115	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value116	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value120	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value121	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value122	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value123	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value124	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value125	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value127	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value130	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value132	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value133	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value134	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value141	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value142	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value144	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value145	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value146	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value147	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value150	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value152	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value153	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value154	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value155	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value158	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value159	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value165	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value167	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value168	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value171	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value173	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value181	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value188	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value189	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value194	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value196	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value197	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value206	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value210	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value212	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value213	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value214	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value215	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value221	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value234	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value235	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value237	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value240	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value242	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value249	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value250	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value258	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value267	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value268	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value269	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value271	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value272	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value285	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value286	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value311	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value326	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value327	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value329	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value330	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value331	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value332	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value333	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value335	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value336	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value340	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value341	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value342	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value343	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value344	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value345	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value346	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value347	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value348	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value350	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value351	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value352	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value353	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value355	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value356	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value357	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value358	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value359	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value360	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value362	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value363	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value364	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value365	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value366	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value367	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value368	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value369	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value370	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value371	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value372	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value373	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value374	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value375	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value376	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value381	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value384	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value385	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value386	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value406	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value415	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value418	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value423	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value429	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value430	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value431	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value432	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value435	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value438	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value443	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value444	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value445	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value446	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value447	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value451	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value456	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value459	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value464	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value466	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value467	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value468	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value469	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value470	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value471	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value472	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value476	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value478	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value479	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value481	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value482	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value485	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value487	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value488	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value489	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value491	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value492	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value493	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value494	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value495	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value498	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value499	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value503	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value506	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value507	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value508	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value509	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value512	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value513	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value517	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value526	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value662	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value700	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value701	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value708	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value710	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value711	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value712	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value713	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value715	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value724	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value727	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value728	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value730	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value731	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value733	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value735	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value736	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value737	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value738	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value743	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value748	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value754	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value760	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value763	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value769	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value775	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value776	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value777	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value778	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value779	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value780	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value781	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value786	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value789	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value795	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value798	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value799	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value800	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value801	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value802	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value803	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value804	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value806	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value815	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value823	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value832	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value833	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	value899	NUMBER	value associated with species indicated by last 3 digits of attribute name
N/A	person_id1	NUMBER	id of vessel ownership
N/A	person_id2	NUMBER	id of vessel ownership
N/A	person_id3	NUMBER	id of vessel ownership
N/A	person_id4	NUMBER	id of vessel ownership
N/A	person_id5	NUMBER	id of vessel ownership
N/A	person_id6	NUMBER	id of vessel ownership
N/A	person_id7	NUMBER	id of vessel ownership
N/A	person_id8	NUMBER	id of vessel ownership
N/A	person_id9	NUMBER	id of vessel ownership
N/A	person_id10	NUMBER	id of vessel ownership
N/A	person_id11	NUMBER	id of vessel ownership
N/A	person_id12	NUMBER	id of vessel ownership
N/A	person_id13	NUMBER	id of vessel ownership
N/A	person_id14	NUMBER	id of vessel ownership
N/A	person_id15	NUMBER	id of vessel ownership
N/A	person_id16	NUMBER	id of vessel ownership
N/A	person_id17	NUMBER	id of vessel ownership
N/A	person_id18	NUMBER	id of vessel ownership
N/A	person_id19	NUMBER	id of vessel ownership
N/A	person_id20	NUMBER	id of vessel ownership
N/A	person_id21	NUMBER	id of vessel ownership
N/A	person_id22	NUMBER	id of vessel ownership
N/A	person_id23	NUMBER	id of vessel ownership
N/A	person_id24	NUMBER	id of vessel ownership
N/A	person_id25	NUMBER	id of vessel ownership
N/A	BLU_1	NUMBER	NEFSC fishery permit species_category-type
N/A	BLU_2	NUMBER	NEFSC fishery permit species_category-type
N/A	BSB_1	NUMBER	NEFSC fishery permit species_category-type
N/A	BSB_2	NUMBER	NEFSC fishery permit species_category-type
N/A	DOG_1	NUMBER	NEFSC fishery permit species_category-type
N/A	FLS_1	NUMBER	NEFSC fishery permit species_category-type
N/A	FLS_2	NUMBER	NEFSC fishery permit species_category-type
N/A	HMS_1	NUMBER	NEFSC fishery permit species_category-type
N/A	HRG_A	NUMBER	NEFSC fishery permit species_category-type
N/A	HRG_B	NUMBER	NEFSC fishery permit species_category-type
N/A	HRG_C	NUMBER	NEFSC fishery permit species_category-type
N/A	HRG_D	NUMBER	NEFSC fishery permit species_category-type
N/A	HRG_E	NUMBER	NEFSC fishery permit species_category-type
N/A	LGC_A	NUMBER	NEFSC fishery permit species_category-type
N/A	LGC_B	NUMBER	NEFSC fishery permit species_category-type
N/A	LGC_C	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_1	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_2	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_A1	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_A2	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_A3	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_A4	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_A5	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_A5W	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_A6	NUMBER	NEFSC fishery permit species_category-type
N/A	LO_AOC	NUMBER	NEFSC fishery permit species_category-type
N/A	MNK_A	NUMBER	NEFSC fishery permit species_category-type
N/A	MNK_B	NUMBER	NEFSC fishery permit species_category-type
N/A	MNK_C	NUMBER	NEFSC fishery permit species_category-type
N/A	MNK_D	NUMBER	NEFSC fishery permit species_category-type
N/A	MNK_E	NUMBER	NEFSC fishery permit species_category-type
N/A	MNK_F	NUMBER	NEFSC fishery permit species_category-type
N/A	MNK_H	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_A	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_C	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_D	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_E	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_F	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_HA	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_HB	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_I	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_J	NUMBER	NEFSC fishery permit species_category-type
N/A	MUL_K	NUMBER	NEFSC fishery permit species_category-type
N/A	NFO_1	NUMBER	NEFSC fishery permit species_category-type
N/A	OQ_6	NUMBER	NEFSC fishery permit species_category-type
N/A	OQ_7	NUMBER	NEFSC fishery permit species_category-type
N/A	RCB_A	NUMBER	NEFSC fishery permit species_category-type
N/A	RCB_B	NUMBER	NEFSC fishery permit species_category-type
N/A	RCB_C	NUMBER	NEFSC fishery permit species_category-type
N/A	SCP_1	NUMBER	NEFSC fishery permit species_category-type
N/A	SCP_2	NUMBER	NEFSC fishery permit species_category-type
N/A	SC_2	NUMBER	NEFSC fishery permit species_category-type
N/A	SC_3	NUMBER	NEFSC fishery permit species_category-type
N/A	SC_5	NUMBER	NEFSC fishery permit species_category-type
N/A	SC_6	NUMBER	NEFSC fishery permit species_category-type
N/A	SC_7	NUMBER	NEFSC fishery permit species_category-type
N/A	SF_1	NUMBER	NEFSC fishery permit species_category-type
N/A	SKT_1	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_1	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_2	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_3	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_4	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_5	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_T1	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_T2	NUMBER	NEFSC fishery permit species_category-type
N/A	SMB_T3	NUMBER	NEFSC fishery permit species_category-type
N/A	TLF_1	NUMBER	NEFSC fishery permit species_category-type
N/A	TLF_2	NUMBER	NEFSC fishery permit species_category-type
N/A	__000000	NUMBER	unused variable
N/A	check	NUMBER	unused variable

Name

Type

Description

N/A

affiliate_id

NUMBER

Affiliate_id is "constant" for all permits which have identical person_id's associated with it

N/A

year

NUMBER

Year

N/A

count_permits

NUMBER

count_permits contains the number of permits owned by an Affiliate_id. It is constant across Affiliate_id and Year groupings.

N/A

entity_type_yyyy

CHARACTER

FINFISH, SHELLFISH, FORHIRE, or NO_REV based on highest revenues in year YYYY. Entity_type is NO_REV if the entity had zero fishing revenues in year YYYY. An affiliate_id may be classifed as NO_REV if it had revenues in earlier years. Entity_type_YYYY takes on the same value for each distinct affiliate_id in all years.

N/A

small_business

NUMBER

Small Business is based on the SBA guidelines, entity_type, and affiliate_total. An entity that is classified as NO_REV is classified as small.

N/A

permit

NUMBER

Permit

N/A

affiliate_total

NUMBER

total revenues for a AFFILIATE_ID in a year

N/A

affiliate_shellfish

NUMBER

shellfish revenues for a AFFILIATE_ID in a year

N/A

affiliate_finfish

NUMBER

finfish revenues for a AFFILIATE_ID in a year

N/A

affiliate_forhire

NUMBER

for-hire revenues for a AFFILIATE_ID in a year

N/A

value_permit

NUMBER

value_permit are the analogous values for a PERMIT in a year

N/A

value_permit_finfish

NUMBER

value_permit_finfish are the analogous values for a PERMIT in a year

N/A

value_permit_shellfish

NUMBER

value_permit_shellfish are the analogous values for a PERMIT in a year

N/A

value_permit_forhire

NUMBER

value_permit_forhire are the analogous values for a PERMIT in a year

N/A

value000

NUMBER