5631 Data Set Published / External 5608 Western Pacific Fisheries Information Network (WPacFIN) Project In Work The Commonwealth of Northern Mariana Islands (CNMI), Division of Fish and Wildlife (DFW) collects 'Trip Ticket' or purchase invoice data from vendors that buy fish directly from the fishermen. This system is similar to other trip ticket invoice systems, except that compliance is voluntary and invoices are only provided to dealers, hotel, stores, fish mobiles etc. on the island of Saipan. Participation has deteriorated in recent years as the economy has suffered and businesses have failed and struggled to stay in existence. DFW has always run the system and have efforts underway to improve compliance and actually make such commercial vendor reporting mandatory through local legislation, although this has been tried in the past and failed. Data are collected by vendors and may include a fisherman's identity and include number of pieces, weight, and price for some individual species and some species groups. Data exist back to about 1983 and are continuing, although the relative coverage of the fisheries has varied over the time series. These data are considered highly confidential. Monitoring Theme DFW Theme FMB Theme FRMD Theme IFMP Theme PIFSC Theme WPacFIN Theme sales Theme trip ticket Spatial CNMI Spatial Northern Mariana Islands Pacific Islands Fisheries Science Center Honolulu HI USA 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Data Set Database Quarterly Table (digital) N/A N/A Trip Ticket 63463 Published / External Completed Data View Yes cnmi_dfw_wh 1 CCL_HD_PK varchar 18 No No Active Primary key for header table created by concatenating invoice year and invoice number. 2 INVOICE int No No 10 0 Active Invoice number that uniquely identifies and invoice. 3 INVOICE_DATE date No No Active Invoice date. 4 BUYER_FK int No No 10 0 Active Code for the fish buyer. Detailed information can be found in C_CCL_BUYER or C_BUYER.DBF. 5 FISHER_FK int No No 10 0 Active Code for the fisher. Detailed information can be found in C_CCL_FISHER or C_FISHER.DBF. 6 RESALE_F char 1 No No Active If true (T), indicates this is a resale invoice. 7 REMARK1 varchar 25 No No Active Comment field. 8 REMARK2 varchar 25 No No Active Comment field. 9 REMARK3 varchar 25 No No Active Comment field. 10 TOT_LBS decimal No No 12 2 Active Total weight of all species on invoice. 11 TOT_SOLD_REVENUE decimal No No 12 2 Active Total pirce paid for all species on invoice. 12 INCOMPLETE_F char 1 No No Active If true (T), indicates the invoice is not complete. 13 ISLAND int No No 10 0 Active Code for the island where the fisher is based. 14 HEAD_CREATE_TIME datetime No No Active Date and time the header record was created. 15 HEAD_CREATE_USER varchar 35 No No Active Name of the user who created the header record. 16 HEAD_MODIFY_TIME datetime No No Active Date and time the header record was last modified. 17 HEAD_MODIFY_USER varchar 35 No No Active Name of the user who last modified the header record. 18 HEAD_LOAD_TABLE varchar 32 No No Active Name of the header FoxPro table that was loaded into MySQL. 19 HEAD_DATETIME datetime No No Active Date and time header record migrated from FoxPro to MySQL. 20 HEAD_LOAD_USER varchar 32 No No Active User who loaded record into the header MySQL table. 21 CCL_DT_PK int No No 10 0 Active System-generated artificial primary key for detail table. 22 CCL_HD_FK varchar 18 No No Active Same as CCL_HD_PK column. Used to link detail to header table. 23 SPECIES_FK int No No 10 0 Active Code for the species. Detailed information can be found in C_CCL_SPECIES or C_SPEC.DBF. 24 NUM_SOLD decimal No No 8 2 Active Number of pieces of a species sold. 25 LBS_SOLD decimal No No 9 2 Active Number of pounds of a species sold. 26 PRICE_PER_LB decimal No No 6 2 Active Price per pound of a species. 27 SOLD_REVENUE decimal No No 8 2 Active Total price paid by the buyer for a species. 28 DETAIL_CREATE_TIME datetime No No Active Date and time the detail record was created. 29 DETAIL_CREATE_USER varchar 35 No No Active Name of the user who created the detail record. 30 DETAIL_MODIFY_TIME datetime No No Active Date and time the detail record was last modified. 31 DETAIL_MODIFY_USER varchar 35 No No Active Name of the user who last modified the detail record. 32 DETAIL_LOAD_TABLE varchar 32 No No Active Name of the detail FoxPro table that was loaded into MySQL. 33 DETAIL_DATETIME datetime No No Active Date and time detail record migrated from FoxPro to MySQL. 34 DETAIL_LOAD_USER varchar 32 No No Active User who loaded record into the detail MySQL table. 35 BUYER_NAME varchar 20 No No Active Name of buyer linked to BUYER_FK. 36 FISHER_NAME varchar 35 No No Active Name of fisher linked to FISHER_FK. 37 SCIENTIFIC_NAME varchar 50 No No Active Scientific name of the species (Genus name + Species name). 38 COMMON_NAME varchar 25 No No Active Common English name for the species. 39 LOCAL_NAME varchar 25 No No Active Local name of the species. Data Steward 2025-11-11 Person Suter, Jenny M jenny.suter@noaa.gov 1845 Wasp Blvd Honolulu HI 96818 USA Data Steward 2021-07 Person Gough, Bradley M bradley.gough@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA Contact via email Data Steward 2011-11-01 2020-12 Person Quach, Michael M michael.quach@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5695 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Contact via email Distributor 1980 Organization Western Pacific Fishery Information Network WPacFIN NMFS/PIFSC/FRMD/IFMP, 1845 Wasp Blvd., Building 176 Honolulu HI 96818 (808) 725-5660 8:00am-4:30pm (HST) 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Metadata Contact 2021-07 Person Gough, Bradley M bradley.gough@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA Contact via email Metadata Contact 2015-11-01 2020-02 Person Dukes, Stefanie NS stefanie.dukes@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5615 (808)725-5475 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Contact via email Point of Contact 2025-11-11 Person Gough, Bradley M bradley.gough@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA Point of Contact 2021-12 Person Suter, Jenny M jenny.suter@noaa.gov 1845 Wasp Blvd Honolulu HI 96818 USA Contact via email Point of Contact 2019-04-01 2021-04 Person Lumsden, Beth beth.lumsden@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5330 Contact via email Point of Contact 2011-11-01 2018 Person Lowe, Kimberly kimberly.lowe@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5660 9:00 a.m. - 5:30 p.m. HST M-F 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Contact via email 140 150 25 10 CNMI & Guam EEZ Continuing 1983 Sensitive Data belong to the Commonwealth of the Northern Mariana Islands (CNMI), Division of Fish and Wildlife (DFW). Data sharing is by cooperative WPacFIN agreement. Other access can only be granted by DFW. Requires signing a PIFSC non-disclosure statement for fisheries confidential data and approval from the data owner. QC review prior to data entry, some automated QC during data entry, and further QC after data entry. Yes Unknown Yes Yes No 1 Year To Be Determined Unknown PIFSC ITS performs scheduled back-ups. Data are submitted to and entered by the Division of Fish and Wildlife (DFW), Commonwealth of the Northern Mariana Islands (CNMI). 63463 Entity gov.noaa.nmfs.inport:5631 Christopher Tokita 2007-10-18T16:06:33 Matthew Long 2025-11-11T22:37:35 2019-07-22 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No No 2019-07-22 1 Year 2020-07-22