calcom - [dbo].[CURRENT

Description

this table contaons sample header data for samples collected during the current year

column	datatype	length	bytes	nulls	PK	computed	comment
sample_no	varchar	9	9	no	yes	no
cal_port	varchar	15	15	no		no	a specific port code identifier, refer to PORT_CODES table
sample_date	datetime	23	8	no		no
gear	varchar	5	5	yes		no	A 3 character gear code for the specific gear type - refer to GEAR_CODES table
mark_cat	int	10	4	yes		no
boat_no	int	10	4	yes		no
total_wgt	numeric	7	5	yes		no	total weigh in pounds for this strata
pink_ticket	varchar	7	7	yes		no	landing rcpt number
dressed	varchar	1	1	yes		no	was this fish landed as dressed (typically used for sablefish only)
live_fish	varchar	1	1	yes		no	was this landing of Live fish (Y or N)
otoliths	varchar	1	1	yes		no	were otoliths collected - typically not used
comments	varchar	250	250	yes		no
size	varchar	3	3	yes		no	size sort group (if used by dealer)
sampler	varchar	15	15	yes		no
port_complex	varchar	3	3	yes		no
check_me	varchar	1	1	yes		no	flag used by port sampler to alert data manager of potential issue with sample
last_date	datetime	23	8	yes		no	last time sample was editted - used by data managers
gear_grp	varchar	3	3	yes		no	assigned gear group based on specific gear
pink_ticket2	varchar	7	7	yes		no	landing receipt number if a second receipt was prepared for the landing
pink_ticket3	varchar	7	7	yes		no	landing receipt number for third receipt if dealer prepared one
observed_trip	char	1	1	yes		no	was an oberserver on the vessel
efp_trip	char	1	1	yes		no	was the vessel operating under and Experimental Fishing Permit
ifq_trip	char	1	1	yes		no	was the vessel fishing under Individual Fishing Quota limits
old_sample_no	varchar	11	11	yes		no	for internal use only