This table contains sample header data for all port samples except those from the current year
| name | value |
|---|---|
| name | [dbo].[MASTER_SAMPLES] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 46,249 |
| Size of data | 5,888 kb |
| Size of indexes | 32 kb |
| Maximum size of a single row | 371 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| sample_no | varchar | 9 | 9 | no | yes | no | formay yyyynnnnnn where yyyy=year and nnnnnn = a unique number for the year | |||
| cal_port | varchar | 15 | 15 | no | no | actual port where fish were landed | ||||
| sample_date | datetime | 23 | 8 | no | no | |||||
| gear | varchar | 5 | 5 | yes | no | actual fishing gear used | ||||
| mark_cat | int | 10 | 4 | yes | no | market category - a sort group not a species code | ||||
| boat_no | int | 10 | 4 | yes | no | |||||
| total_wgt | numeric | 7 | 5 | yes | no | weight in pounds of the strata that the sample was taken from | ||||
| pink_ticket | varchar | 7 | 7 | yes | no | landing receipt number | ||||
| dressed | varchar | 1 | 1 | yes | no | were the fish landed dressed, typically only used for sablefish | ||||
| live_fish | varchar | 1 | 1 | yes | no | were the fish landed live - Y or N | ||||
| otoliths | varchar | 1 | 1 | yes | no | were otoliths collected, often not recorded | ||||
| comments | varchar | 250 | 250 | yes | no | |||||
| size | varchar | 3 | 3 | yes | no | if sorted based on size, refer to size_codes table for descriptions, typically only for sablefish | ||||
| sampler | varchar | 15 | 15 | yes | no | port samplers last name | ||||
| port_complex | varchar | 3 | 3 | yes | no | assigned port complex based on port of landing | ||||
| check_me | varchar | 1 | 1 | yes | no | used by port samplers if sample is unusual, see comments column for details | ||||
| last_date | datetime | 23 | 8 | yes | no | automatically inserted by a trigger if table is updated | ||||
| gear_grp | varchar | 3 | 3 | yes | no | assigned gear group based on actual gear used | ||||
| pink_ticket2 | varchar | 7 | 7 | yes | no | if landing made on more than one receipt this column is used | ||||
| pink_ticket3 | varchar | 7 | 7 | yes | no | if landing made on more than 2 receipts this column is used | ||||
| observed_trip | char | 1 | 1 | yes | no | was an observer onboard the vessel Y or N, sometimes hard to determine | ||||
| efp_trip | char | 1 | 1 | yes | no | was this trip done under an Experimental Fishing Permit Y or N, may not be reliable | ||||
| ifq_trip | char | 1 | 1 | yes | no | was this trip made under an Individual Fish Quota Y or N, may not be reliable | ||||
| old_sample_no | varchar | 11 | 11 | yes | no | sample number used under previous version of CALCOM |
| name | object type | level |
|---|