Data Dictionary Index
Daniel J. Hocking
2025-07-07
dictionary_index.Rmd
Index of Table and Column Definitions
TABLE_NAME | DESCRIPTION | |
---|---|---|
|
| |
1 | CAMS_ALL_PTNS_EM_TRIPS | All PTNS trips for EM assignment |
2 | CAMS_CFAGE2019AA | Biological sampling age data for 2019 linked to CAMS subtrips |
3 | CAMS_CFAGE2020AA | Biological sampling age data for 2020 linked to CAMS subtrips |
4 | CAMS_CFAGE2021AA | Biological sampling age data for 2021 linked to CAMS subtrips |
5 | CAMS_CFAGE2022AA | Biological sampling age data for 2022 linked to CAMS subtrips |
6 | CAMS_CFAGE_AA | Biological sampling age data for all years linked to CAMS subtrips |
7 | CAMS_CFDETS2019AA | Species-level landings formatted following the traditional AA structure |
8 | CAMS_CFDETS2020AA | Species-level landings formatted following the traditional AA structure |
9 | CAMS_CFDETS2021AA | Species-level landings formatted following the traditional AA structure |
10 | CAMS_CFDETS2022AA | Species-level landings formatted following the traditional AA structure |
11 | CAMS_CFDETS2023AA | Species-level landings formatted following the traditional AA structure |
12 | CAMS_CFDETS_AA | Species-level landings formatted following the traditional AA structure |
13 | CAMS_CFDETT2019AA | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure |
14 | CAMS_CFDETT2020AA | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure |
15 | CAMS_CFDETT2021AA | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure |
16 | CAMS_CFDETT2022AA | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure |
17 | CAMS_CFDETT2023AA | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure |
18 | CAMS_CFDETT_AA | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure |
19 | CAMS_CFLEN2019AA | Biological sampling length data for 2019 linked to CAMS subtrips |
20 | CAMS_CFLEN2020AA | Biological sampling length data for 2020 linked to CAMS subtrips |
21 | CAMS_CFLEN2021AA | Biological sampling length data for 2021 linked to CAMS subtrips |
22 | CAMS_CFLEN2022AA | Biological sampling length data for 2022 linked to CAMS subtrips |
23 | CAMS_CFLEN2023AA | Biological sampling length data for 2023 linked to CAMS subtrips |
24 | CAMS_CFLEN_AA | Biological sampling length data for all years linked to CAMS subtrips |
25 | CAMS_COMMENTS | Table of definitions for columns across all tables in CAMS |
Showing 1 to 25 of 84 entries
OBJECT_NAME | OBJECT_TYPE | COLUMN_NAME | DATA_TYPE | DATA_LENGTH | DATA_PRECISION | NULLABLE | CONSTRAINT_NAME | CONSTRAINT_TYPE | DESCRIPTION | |
---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
| |
1 | CAMS_CFLEN_AA | TABLE | MATCHED_AREAS | VARCHAR2 | 50 | Y | Biological sampling length data for all years linked to CAMS subtrips | |||
2 | CAMS_CFDETS_AA | TABLE | DEPTHCD | VARCHAR2 | 1 | Y | Species-level landings formatted following the traditional AA structure | |||
3 | CAMS_CFLEN_AA | TABLE | NEGEAR | VARCHAR2 | 3 | Y | Biological sampling length data for all years linked to CAMS subtrips | |||
4 | CAMS_CFAGE_AA | TABLE | CATDISP | VARCHAR2 | 1 | Y | Biological sampling age data for all years linked to CAMS subtrips | |||
5 | CAMS_CFDETS_AA | TABLE | NESPP3 | VARCHAR2 | 3 | Y | Species-level landings formatted following the traditional AA structure | |||
6 | CAMS_CFDETT_AA | TABLE | GEAR_IMP_METHOD | VARCHAR2 | 20 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | |||
7 | CAMS_CFDETT_AA | TABLE | DEALNUM | NUMBER | 22 | 6 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | ||
8 | CAMS_CFAGE_AA | TABLE | MATCHED_NEMAREAS | VARCHAR2 | 50 | Y | Biological sampling age data for all years linked to CAMS subtrips | |||
9 | CAMS_CFDETS_AA | TABLE | DOCN | VARCHAR2 | 15 | Y | Species-level landings formatted following the traditional AA structure | |||
10 | CAMS_CFDETT_AA | TABLE | VSERIAL | VARCHAR2 | 16 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | |||
11 | CAMS_CFAGE_AA | TABLE | AREA_SOURCES | VARCHAR2 | 30 | Y | Biological sampling age data for all years linked to CAMS subtrips | |||
12 | CAMS_CFDETT_AA | TABLE | AREA | VARCHAR2 | 3 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | |||
13 | CAMS_CFAGE_AA | TABLE | ITIS_TSN | VARCHAR2 | 11 | Y | Biological sampling age data for all years linked to CAMS subtrips | |||
14 | CAMS_CFDETT_AA | TABLE | STERN | VARCHAR2 | 1 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | |||
15 | CAMS_CFDETT_AA | TABLE | GEAR_SOURCE | VARCHAR2 | 12 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | |||
16 | CAMS_CFLEN_AA | TABLE | SAMPNO | VARCHAR2 | 10 | Y | Biological sampling length data for all years linked to CAMS subtrips | |||
17 | CAMS_CFDETT_AA | TABLE | MONTH | VARCHAR2 | 2 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | |||
18 | MATCH_CFLEN_DSM | TABLE | CFLEN_DSM_SCORE | NUMBER | 22 | Y | Table of CAMSID for all trips reported through CFLEN collected by the dock side monitoring (DSM) program and the associated matching information. | |||
19 | CAMS_CFLEN_AA | TABLE | NUMLEN | NUMBER | 22 | 3 | Y | Biological sampling length data for all years linked to CAMS subtrips | ||
20 | MATCH_AMS_VTR | TABLE | ACTIVITY_CODE | VARCHAR2 | 4000 | Y | Table of CAMSID for all trips reported through VTR and VMS (through AMS) systems and their associated matching information. | |||
21 | CAMS_CFDETT_AA | TABLE | COUNTY | VARCHAR2 | 2 | Y | Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure | |||
22 | CAMS_CFLEN_AA | TABLE | WGTSAMP | NUMBER | 22 | 5 | Y | Biological sampling length data for all years linked to CAMS subtrips | ||
23 | MATCH_CFLEN_DSM | TABLE | CFLEN_DSM_DOCN | VARCHAR2 | 4000 | Y | Table of CAMSID for all trips reported through CFLEN collected by the dock side monitoring (DSM) program and the associated matching information. | |||
24 | MATCH_SCAL_VMS | TABLE | SCALCAT_SENT | TIMESTAMP(6) | 11 | Y | ||||
25 | CAMS_CFAGE_AA | TABLE | QTR | VARCHAR2 | 1 | Y | Biological sampling age data for all years linked to CAMS subtrips |
Showing 1 to 25 of 1,478 entries
COLUMN_NAME | DESCRIPTION | TABLES | |
---|---|---|---|
|
|
| |
1 | ACCESSAREA | Scallop Access Area, only relevant for scallop trips | CAMS_AQUACULTURE_SUBTRIP; CAMS_DISCARD_NBR_NON_FMP; CAMS_LANDINGS; CAMS_OBDBS_ALL_YEARS; CAMS_OBS_CATCH; CAMS_SUBTRIP; CAMS_VTR_ORPHANS_SUBTRIP; CAMS_VTR_REC_SUBTRIP; CFG_NBR_FLEET; FOSS_NBR_ALL_SPECIES |
2 | ACCSP_CATEGORY_CODE | CFG_NEGEAR | |
3 | ACCSP_GEAR_CATEGORY | CAMS_GF_EM; CAMS_GF_EM_VTR_DISCARDS_SUBTRIP | |
4 | ACTIVITY_CODE | VMS declaration | CAMS_ALL_PTNS_EM_TRIPS; MATCH_AMS_VTR |
5 | ACTIVITY_CODE_1 | VMS declaration | CAMS_AQUACULTURE_SUBTRIP; CAMS_LANDINGS; CAMS_OBS_CATCH; CAMS_SUBTRIP; CAMS_VTR_ORPHANS_SUBTRIP; CAMS_VTR_REC_SUBTRIP |
6 | ACTIVITY_CODE_2 | VMS declaration, if more than one/trip | CAMS_AQUACULTURE_SUBTRIP; CAMS_LANDINGS; CAMS_SUBTRIP; CAMS_VTR_ORPHANS_SUBTRIP; CAMS_VTR_REC_SUBTRIP |
7 | AGE | The age of specimen in years. | CAMS_CFAGE_AA |
8 | AGESTRCT | The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. | CAMS_CFAGE_AA; CAMS_CFLEN_AA |
9 | ALEVEL | Legacy column not currently used in CAMS. See AREA_SOURCE and AREA_IMP_METHOD for area metadata. 1994-2019: The level at which the area was allocated to this unit of dealer landings. A = a Dealer trip matched a VTR trip; B = a Dealer trip matched a group of VTR trips stratified by permit, month, gear group, and species group; C = Dealer trip matched a group of VTR trips stratified by ton class, port group, gear group, species group, calendar quarter and year; D = Dealer trip matched a group of VTR trips stratified by port group; X = Dealer trip enter allocation but did not find a match; and NULL = Dealer trip did not enter allocation. | CAMS_CFAGE_AA; CAMS_CFDETS_AA; CAMS_CFDETT_AA; CAMS_CFLEN_AA |
10 | AMSVTRID | MATCH_AMS_VTR | |
11 | AMSVTR_ACTIVITY_CODE | CAMS_ALL_PTNS_EM_TRIPS | |
12 | AMSVTR_ORPHAN | MATCH_AMS_VTR | |
13 | AMSVTR_SCORE | MATCH_AMS_VTR | |
14 | AMSVTR_STITCH | MATCH_AMS_VTR | |
15 | AMSVTR_STITCHID | MATCH_AMS_VTR | |
16 | AMSVTR_STITCH_TYPE | MATCH_AMS_VTR | |
17 | AMSVTR_TRIPID | MATCH_AMS_VTR | |
18 | AMS_LAND | Date trip returned across VMS decmarc, taken from AMS | CAMS_ALL_PTNS_EM_TRIPS; MATCH_AMS_VTR |
19 | AMS_MULT_CHRG | MATCH_AMS_VTR; MATCH_TRIPID; MATCH_TRIPID_PZERO | |
20 | AMS_PROG | Fishery Program as taken from VMS declaration in AMS | MATCH_AMS_VTR; MATCH_TRIPID; MATCH_TRIPID_PZERO |
21 | AMS_SAIL | Date trip departed across VMS demarcation, taken from AMS | CAMS_ALL_PTNS_EM_TRIPS; MATCH_AMS_VTR |
22 | AMS_TRIP | MATCH_AMS_VTR | |
23 | AREA | The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. Unknown = '000'. For CAMS data, refer to AREA_SOURCE and AREA_IMP_METHOD for metadata about AREA. | CAMS_AQUACULTURE_SUBTRIP; CAMS_CFAGE_AA; CAMS_CFDETS_AA; CAMS_CFDETT_AA; CAMS_CFLEN_AA; CAMS_GF_EM_DELTA_VTR_DISCARD; CAMS_GF_EM_VTR_DISCARDS_AREA_ACCSPGEARCAT_TRIP; CAMS_GF_EM_VTR_DISCARDS_SUBTRIP; CAMS_LAND; CAMS_LANDINGS; CAMS_OBDBS_ALL_YEARS; CAMS_OBS_CATCH; CAMS_SUBTRIP; CAMS_VTR_ORPHANS; CAMS_VTR_ORPHANS_SUBTRIP; CAMS_VTR_REC; CAMS_VTR_REC_SUBTRIP; CFG_FED_AREA; CFG_NEMAREA; CFG_STATAREA_STOCK; CFG_STOCK_ASSESSMENT_AREAS |
24 | AREA_7130 | CFG_FED_AREA | |
25 | AREA_ADJ_PORT | CFG_PORT |
Showing 1 to 25 of 607 entries