5402 Oracle Tables For PDC/HMS Reporting Data Set Published / External 2004 Pelagic Dealer Compliance Project In Work This data set contains summarized pounds of select pelagic fish species bought by selected federally permitted seafood dealers in the SE Region of the US mainland. Data was collected 2 times each month and used for quota monitoring. Commercial in-season quota monitoring Trip landing reports submitted by HMS dealers Theme dealers Theme highly migratory species Theme sharks Theme swordfish Theme tuna Theme vessels Spatial East Coast Of United States Spatial Puerto Rico Spatial Virgin Islands Southeast Fisheries Science Center Miami FL USA Location Of The Main Office Of The South East Fisheries Science Center Data Set Table (digital) N/A N/A N/A 5403 DPS_DEALER_PERMIT Published / External Completed Dealer Permit Table . Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Dealer Permit Table . 1 LU VARCHAR2 1 No No Active - Retrofitted VARCHAR2 2 IDNUM VARCHAR2 15 No No Active - Retrofitted VARCHAR2 3 TOP VARCHAR2 40 No No Active Type Of Permit VARCHAR2 4 PNUMBER VARCHAR2 4 No No Active Permit Number VARCHAR2 5 EDOP DATE 7 No No Active Effective Date Of Permit DATE 6 RDEDOP DATE 7 No No Active - Retrofitted DATE 7 RSEDOP DATE 7 No No Active - Retrofitted DATE 8 SGEDOP DATE 7 No No Active - Retrofitted DATE 9 SHEDOP DATE 7 No No Active - Retrofitted DATE 10 SDEDOP DATE 7 No No Active - Retrofitted DATE 11 EXPDATE DATE 7 No No Active Expiration Date Of Permit DATE 12 DOE DATE 7 No No Active - Retrofitted DATE 13 STATUS VARCHAR2 1 No No Active - Retrofitted VARCHAR2 14 DOS DATE 7 No No Active - Retrofitted DATE 15 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 16 BSTRT VARCHAR2 30 No No Active Business Stret Address VARCHAR2 17 BPHONE VARCHAR2 12 No No Active Bisiness Phine Number VARCHAR2 18 BCITY VARCHAR2 30 No No Active City In Business Address VARCHAR2 19 BSTATE VARCHAR2 2 No No Active State Of Business Address VARCHAR2 20 BZIPCODE VARCHAR2 10 No No Active Zip Code Of Business Address VARCHAR2 21 BDOB DATE 7 No No Active Business Date Of Incorporation or date of business start or application for permit DATE 22 FNAME1 VARCHAR2 45 No No Active - Retrofitted VARCHAR2 23 FPHONE1 VARCHAR2 12 No No Active - Retrofitted VARCHAR2 24 FSTRT1 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 25 FCITY1 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 26 FSTATE1 VARCHAR2 2 No No Active - Retrofitted VARCHAR2 27 FZIPCOD1 VARCHAR2 10 No No Active - Retrofitted VARCHAR2 28 FNAME2 VARCHAR2 45 No No Active - Retrofitted VARCHAR2 29 FPHONE2 VARCHAR2 12 No No Active - Retrofitted VARCHAR2 30 FSTRT2 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 31 FCITY2 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 32 FSTATE2 VARCHAR2 2 No No Active - Retrofitted VARCHAR2 33 FZIPCOD2 VARCHAR2 10 No No Active - Retrofitted VARCHAR2 34 FNAME3 VARCHAR2 45 No No Active - Retrofitted VARCHAR2 35 FPHONE3 VARCHAR2 12 No No Active - Retrofitted VARCHAR2 36 FSTRT3 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 37 FCITY3 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 38 FSTATE3 VARCHAR2 2 No No Active - Retrofitted VARCHAR2 39 FZIPCOD3 VARCHAR2 10 No No Active - Retrofitted VARCHAR2 40 FNAME4 VARCHAR2 45 No No Active - Retrofitted VARCHAR2 41 FPHONE4 VARCHAR2 12 No No Active - Retrofitted VARCHAR2 42 FSTRT4 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 43 FCITY4 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 44 FSTATE4 VARCHAR2 2 No No Active - Retrofitted VARCHAR2 45 FZIPCOD4 VARCHAR2 10 No No Active - Retrofitted VARCHAR2 46 FNAME5 VARCHAR2 45 No No Active - Retrofitted VARCHAR2 47 FPHONE5 VARCHAR2 12 No No Active - Retrofitted VARCHAR2 48 FSTRT5 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 49 FCITY5 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 50 FSTATE5 VARCHAR2 2 No No Active - Retrofitted VARCHAR2 51 FZIPCOD5 VARCHAR2 10 No No Active - Retrofitted VARCHAR2 52 FNAME6 VARCHAR2 45 No No Active - Retrofitted VARCHAR2 53 FPHONE6 VARCHAR2 12 No No Active - Retrofitted VARCHAR2 54 FSTRT6 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 55 FCITY6 VARCHAR2 30 No No Active - Retrofitted VARCHAR2 56 FSTATE6 VARCHAR2 2 No No Active - Retrofitted VARCHAR2 57 FZIPCOD6 VARCHAR2 10 No No Active - Retrofitted VARCHAR2 58 APPNAME VARCHAR2 35 No No Active - Retrofitted VARCHAR2 59 APPPOS VARCHAR2 25 No No Active - Retrofitted VARCHAR2 60 APPPHONE VARCHAR2 12 No No Active - Retrofitted VARCHAR2 61 APPSSN VARCHAR2 11 No No Active - Retrofitted VARCHAR2 62 APPDOB DATE 7 No No Active - Retrofitted DATE 63 APPSTRT VARCHAR2 30 No No Active - Retrofitted VARCHAR2 64 APPCITY VARCHAR2 30 No No Active - Retrofitted VARCHAR2 65 APPSTATE VARCHAR2 2 No No Active - Retrofitted VARCHAR2 66 APPZIP VARCHAR2 10 No No Active - Retrofitted VARCHAR2 67 REMARKS VARCHAR2 250 No No Active - Retrofitted VARCHAR2 68 INITS VARCHAR2 8 No No Active - Retrofitted VARCHAR2 69 NE_PNUMBER VARCHAR2 4 No No Active Permit Number Assigned By NE Regional Office for Permits that they are responsible for. VARCHAR2 70 NMFS_STATE VARCHAR2 2 No No Active NMFS State Of Dealer Location VARCHAR2 71 NMFS_CTY VARCHAR2 2 No No Active NMFS County VARCHAR2 72 FL_STATE VARCHAR2 2 No No Active Florida State VARCHAR2 5404 FLS_INT_VALIDATION_ERRORS Published / External Completed Hold Validation Errors from the processing of a scanned batchof logbook data. All columns may not be used in this table depeneding upon whether the validation run is for a dealer logbook, or from whatever fishers logbook that was scanned Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Hold Validation Errors from the processing of a scanned batchof logbook data. All columns may not be used in this table depeneding upon whether the validation run is for a dealer logbook, or from whatever fishers logbook that was scanned 1 ERROR_NUMBER VARCHAR2 10 No No Active Error Number VARCHAR2 2 BATCH_NUMBER VARCHAR2 10 No No Active Batch Number VARCHAR2 3 SCHEDULE_NUMBER VARCHAR2 10 No No Active Schedule Number VARCHAR2 4 LOGBOOK_KEY NUMBER 22 No No 10 0 Active Logbook Key -- Links to FLS_LOGBOOKS Received NUMBER 5 FISHING_ACTIVITY_KEY NUMBER 22 No No 10 0 Active Fishing Activity Key NUMBER 6 GEAR_FISHED_KEY NUMBER 22 No No 10 0 Active Gear Fished Key Of Record With Errors NUMBER 7 CATCH_KEY NUMBER 22 No No 10 0 Active Catch Key Of Record With Errors NUMBER 8 CHILD_NAME_KEY VARCHAR2 30 No No Active In caes of fisher logbooks, the name of the child table that is generating the error VARCHAR2 9 CHILD_VALUE_KEY NUMBER 22 No No 10 0 Active In caes of fisher logbooks, the valuef the child table column that is generating the error NUMBER 10 TABLE_NAME VARCHAR2 50 No No Active Oracle Table that contains validation Error VARCHAR2 11 COLUMN_NAME VARCHAR2 50 No No Active Oracle Column of Record containg validation error VARCHAR2 12 VALUE VARCHAR2 50 No No Active Data Value in error VARCHAR2 13 ERROR_MESSAGE VARCHAR2 200 No No Active Validation Error Message VARCHAR2 14 DATA_TYPE VARCHAR2 10 No No Active Data Type Of Column That is in err VARCHAR2 15 TABLE_TYPE VARCHAR2 10 No No Active Type Of table that has validation error VARCHAR2 16 ERROR_TYPE VARCHAR2 10 Yes No Active Type Of validation error VARCHAR2 17 DATE_ENTERED DATE 7 No No Active Date Time stamp of when record was added to this table DATE 18 SOURCE_FILE VARCHAR2 30 No No Active Name Of File Loaded That caused validation error VARCHAR2 19 USERID VARCHAR2 20 No No Active Oracle Id of one who ran validation program VARCHAR2 20 ERROR_TYPE_CHANGED VARCHAR2 1 No No Active Has Type Of Error changed. Valid values or Y or N. VARCHAR2 21 BATCH_SEQUENCE_NUMBER VARCHAR2 10 No No Active Batch sequence Number of record that erred VARCHAR2 22 VESSEL_ID_NUMBER VARCHAR2 10 No No Active Vessel Identification Number Of Record that erred VARCHAR2 5405 PDC_HEADERS Published / External Completed The Header Information from the Pelagic Dealer LOgbook forms. Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS The Header Information from the Pelagic Dealer LOgbook forms. 1 PDC_HEADER_KEY NUMBER 22 Yes Yes 10 0 Active Primary Key of This Table NUMBER 2 PC_ARTIFICIAL_KEY NUMBER 22 No No 10 0 Active This is the artificial key to link the Header , vessel and purchase tables on the old PC SDC system. This column was generated as records were added. NUMBER 3 BATCH_YEAR VARCHAR2 4 Yes No Active Year Of The schedule.This column is derived from the 4 digit year of the BEGIN_DATE.This column is necesssary because there were some years in which the Schedule NUmbers were recycled for the year before, so to get a unique key it was necessary to use Year and Schedule. VARCHAR2 4 SCHEDULE VARCHAR2 12 Yes No Active This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemThe actual unique key is SCHEDULE + BATCH_YEAR. VARCHAR2 5 SE_PERMIT_NUMBER VARCHAR2 5 No No Active This is the permit number issued by the Southeast Regional Office for Swordfish and Shark dealers. It is comprised of 4 letters, up to 4 numbers, followed by 2 digits for the year, e.g., DLR-LA-1234-01. Only the center numbers of the permit (e.g., 1234) are entered in the permit files provided by the SE office, as well as into the Swordfish Compliance Program. Updated dealer permit numbers are downloaded and saved in n:\sdc\dbf\dlr_new.dbf.If a Swordfish or Shark dealer (indicated by a SE permit number) also has a Tuna dealer permit (indicated by a NE permit number), it would be helpful if the NE number was automatically entered with the SE permit number. These dealers with both NE and SE issued permits are currently linked in the above mentioned file, dlr_new.dbf. VARCHAR2 6 NE_PERMIT_NUMBER VARCHAR2 5 No No Active This is the permit number issued by the Northeast Regional Office for Tuna dealers. It was once a 5 digit number, zero filled. Now it ranges from 3-4 digits, and not zero filled. VARCHAR2 7 NMFS_STATE_CODE VARCHAR2 2 No No Active NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry. VARCHAR2 8 NMFS_COUNTY_CODE VARCHAR2 3 No No Active NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry. VARCHAR2 9 ALPHA_STATE_CODE VARCHAR2 2 No No Active Two letter state abbreviation corresponing to the Dealerlocation.Thiscolumn is filled in on data entry. VARCHAR2 10 BEGIN_DATE DATE 7 Yes No Active This is the date that the reporting period begins. This date is often the first or the 16th of each month. DATE 11 END_DATE DATE 7 Yes No Active This is the date that the reporting period ends. This date is often the 15th or the last day of each month. DATE 12 FACILITY_LOCATION VARCHAR2 20 No No Active The port of landing of the vessel VARCHAR2 13 PHONE_NUMBER VARCHAR2 20 No No Active This is the number that a person at the dealer facility can be reached in case of questions. This field may be blank. This field is entered in by the vendor, but is not being entered by SEFSC staff. VARCHAR2 14 SCAN_ID VARCHAR2 20 No No Active Date entered by vendor VARCHAR2 15 BATCH_NUMBER VARCHAR2 20 No No Active When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are iss VARCHAR2 16 PURCHASE_FISH VARCHAR2 1 No No Active This is a yes/no field. If the dealer did not purchase any highly migratory species during the 2 week period, the 'no' is checked. VARCHAR2 17 FISH_IMPORTED VARCHAR2 1 No No Active Indicates whether or not the data reported included imports in addition to domestic purchases. VARCHAR2 18 VESSEL_DATA VARCHAR2 1 No No Active A vestigal column from old PC System which indicated whether or not there was vessel data on the logbook form. VARCHAR2 19 EDIT_DATA VARCHAR2 1 No No Active A vestigal column from old PC System which indicated whether or not data had to be corrected due to judgment of data manager. VARCHAR2 20 WEIGH_OUT VARCHAR2 1 No No Active his indicates whether or not tally sheets (weigh out data) were provided with the HMS form. This aids in locating weigh out sheets upon request. VARCHAR2 21 TIF_NUMBER VARCHAR2 12 No No Active The scan images provided by the vendor VARCHAR2 22 ID_NUMBER VARCHAR2 10 No No Active Assigned By Vendor Software During Data Entry VARCHAR2 23 RECEIVED_DATE DATE 7 No No Active Date Logbook Form was received. DATE 24 POSTMARK_DATE DATE 7 No No Active Date in which envelope containing the logbook form was post marked. DATE 5406 PDC_INT_ACCESS_HEADERS Published / External Completed Processing Table to take the scanned data received from the vendor into oracle via access macro Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Processing Table to take the scanned data received from the vendor into oracle via access macro 1 ID_NO VARCHAR2 10 Yes Yes Active ID NUmber On The form VARCHAR2 2 TIF_NO VARCHAR2 12 No No Active TIF Number VARCHAR2 3 SCHEDULE VARCHAR2 12 Yes No Active This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemThe actual unique key is SCHEDULE + BATCH_YEAR. VARCHAR2 4 SE_DEALER VARCHAR2 4 No No Active SE Permit Number VARCHAR2 5 NE_DEALER VARCHAR2 4 No No Active NE Dealer Code VARCHAR2 6 BEGIN_DATE VARCHAR2 10 No No Active This is the date that the reporting period begins. This date is often the first or the 16th of each month. VARCHAR2 7 END_DATE VARCHAR2 10 No No Active This is the date that the reporting period ends. This date is often the 15th or the last day of each month. VARCHAR2 8 COUNTY_NAME VARCHAR2 20 No No Active County Name VARCHAR2 9 STATE VARCHAR2 2 No No Active State Name VARCHAR2 10 FISH_PURCHASE VARCHAR2 1 No No Active Were fish purchases VARCHAR2 11 FISH_IMPORTED VARCHAR2 1 No No Active Indicates whether or not the data reported included imports in addition to domestic purchases. VARCHAR2 12 DEALER_PHONE VARCHAR2 20 No No Active Phone nUmber of Dealer VARCHAR2 13 FORM_ID VARCHAR2 20 No No Active Which Version Of The Form was scanned VARCHAR2 14 BATCH_NUMBER VARCHAR2 20 No No Active When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are iss VARCHAR2 15 WEIGH_OUT VARCHAR2 1 No No Active his indicates whether or not tally sheets (weigh out data) were provided with the HMS form. This aids in locating weigh out sheets upon request. VARCHAR2 16 OP_NAME VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 17 OP_VALUE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 18 OP_DATE VARCHAR2 8 No No Active A Vendor Supplied field VARCHAR2 19 RECEIVED_DATE VARCHAR2 10 No No Active Date Logbook Form was received. VARCHAR2 20 POSTMARK_DATE VARCHAR2 10 No No Active Date in which envelope containing the logbook form was post marked. VARCHAR2 5407 PDC_INT_ACCESS_PURCHASES Published / External Completed Processing Table to take the scanned data received from the vendor into oracle via access macro Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Processing Table to take the scanned data received from the vendor into oracle via access macro 1 ID_NO VARCHAR2 10 Yes Yes Active ID NUmber On The form VARCHAR2 2 TIF_NO VARCHAR2 50 No No Active TIF Number VARCHAR2 3 SCHEDULE VARCHAR2 12 No No Active This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemThe actual unique key is SCHEDULE + BATCH_YEAR. VARCHAR2 4 SE_DEALER VARCHAR2 4 No No Active Permit Number Assigned to Dealer by the SOuth East Regional Office VARCHAR2 5 NE_DEALER VARCHAR2 4 No No Active Permit Number Assigned By North East Regional Office VARCHAR2 6 END_DATE VARCHAR2 10 No No Active Ending Date of The Time/Reporting Period In question VARCHAR2 7 NMF_SPECIES VARCHAR2 4 No No Active NMFS Species Code VARCHAR2 8 SIZE_CODE VARCHAR2 2 No No Active Size Code VARCHAR2 9 DRESSED_WEIGHT NUMBER 22 No No 10 0 Active Dressed Weight NUMBER 10 PRICE_PER_POUND NUMBER 22 No No 10 2 Active Price Per Pound NUMBER 11 BATCH_NUMBER VARCHAR2 20 No No Active When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are issued some come logbooks in the older format are returned VARCHAR2 12 OP_NAME VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 13 OP_VALUE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 14 OP_DATE DATE 7 No No Active A Vendor Supplied field DATE 5408 PDC_INT_ACCESS_VESSELS Published / External Completed Processing Table to take the scanned data received from the vendor into oracle via access macro Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Processing Table to take the scanned data received from the vendor into oracle via access macro 1 ID_NO VARCHAR2 10 Yes Yes Active ID Number On The form VARCHAR2 2 TIF_NO VARCHAR2 12 No No Active TIF Number VARCHAR2 3 SCHEDULE VARCHAR2 12 No No Active This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemThe actual unique key is SCHEDULE + BATCH_YEAR. VARCHAR2 4 DATE_LANDED VARCHAR2 10 No No Active Date Landed VARCHAR2 5 VESSEL_NAME VARCHAR2 30 No No Active Vessel name VARCHAR2 6 VESSEL_ID VARCHAR2 10 No No Active Vessel Identification Number VARCHAR2 7 PORT_LANDED VARCHAR2 30 No No Active Port Landed VARCHAR2 8 STATE_LANDED VARCHAR2 2 No No Active State Landed VARCHAR2 9 BATCH_NUMBER VARCHAR2 20 No No Active When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are issued some come logbooks in the older format are returned VARCHAR2 10 OP_NAME VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 11 OP_VALUE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 12 OP_DATE VARCHAR2 8 No No Active A Vendor Supplied field VARCHAR2 5409 PDC_INT_MOST_ACTIVE_DLRS Published / External Completed Table Listing Dealers With Highest Recorded Purchases Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table Listing Dealers With Highest Recorded Purchases 1 DEALER_NAME VARCHAR2 45 No No Active Dealer Name VARCHAR2 2 SE_PNUMBER VARCHAR2 4 No No Active South East Permit Number VARCHAR2 3 NE_PNUMBER VARCHAR2 4 No No Active North East Permit Number VARCHAR2 4 EXPIRATION_DATE DATE 7 No No Active That is the date in which the permit expires DATE 5 TOTAL_POUNDS NUMBER 22 No No 10 0 Active Total Pounds Reported NUMBER 6 RANK NUMBER 22 No No 5 0 Active The rank according to the total pounds, being 1 the dealer with more total pounds NUMBER 7 PERCENT NUMBER 22 No No 6 2 Active This dealer total pounds / ALL dealer total pounds * 100 NUMBER 8 USERID VARCHAR2 30 No No Active Who is calling the report. VARCHAR2 5410 PDC_INT_REPORTING_LABELS Published / External Completed Each record is a dealer soon to be mailed Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Each record is a dealer soon to be mailed 1 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 2 BPHONE VARCHAR2 12 No No Active Business Phone Of Permit Holder VARCHAR2 3 SE_PNUMBER VARCHAR2 4 No No Active South East Permit Number VARCHAR2 4 NE_PNUMBER VARCHAR2 4 No No Active North East Permit Number VARCHAR2 5 BEGIN_DATE DATE 7 No No Active Start Date DATE 6 END_DATE DATE 7 No No Active End Date DATE 7 USERID VARCHAR2 30 No No Active Oracle ID of the creator of this record VARCHAR2 8 VOID VARCHAR2 1 No No Active Trick field. It will be TRUE if the record is not to be printed VARCHAR2 9 TYPE_TOP VARCHAR2 2 No No Active Type Of Permit VARCHAR2 5411 PDC_INT_SCANNED_HEADERS Published / External Completed Pre-validation table that holds header data Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Pre-validation table that holds header data 1 ID_NUMBER VARCHAR2 10 No No Active Sequential Number Assigned By Vendor Software During Data Entry VARCHAR2 2 TIF_NUMBER VARCHAR2 12 No No Active This contains the scanned images provided by the vendor. It currently does not have a place in our master tables VARCHAR2 3 SCHEDULE VARCHAR2 12 Yes Yes Active his is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique. VARCHAR2 4 NE_PNUMBER VARCHAR2 4 No No Active This is the permit number issued by the Northeast Regional Office for Tuna dealers. It was once a 5 digit number, zero filled. Now it ranges from 3-4 digits, and not zero filled. VARCHAR2 5 SE_PNUMBER VARCHAR2 5 No No Active This is the permit number issued by the Southeast Regional Office for Swordfish and Shark dealers. It is comprised of 4 letters, up to 4 numbers, followed by 2 digits for the year, e.g., DLR-LA-1234-01. Only the center numbers of the permit (e.g., 1234) are entered in the permit files provided by the SE office, as well as into the Swordfish Compliance Program. Updated dealer permit numbers are downloaded and saved in n:\sdc\dbf\dlr_new.dbf.If a Swordfish or Shark dealer (indicated by a SE permit number) also has a Tuna dealer permit (indicated by a NE permit number), it would be helpful if the NE number was automatically entered with the SE permit number. These dealers with both NE and SE issued permits are currently linked in the above mentioned file, dlr_new.dbf. VARCHAR2 6 BEGIN_DATE VARCHAR2 10 No No Active This is the date that the reporting period begins. This date is often the first or the 16th of each month. VARCHAR2 7 END_DATE VARCHAR2 10 No No Active This is the date that the reporting period ends. This date is often the 15th or the last day of each month. VARCHAR2 8 COUNTY_NAME VARCHAR2 20 No No Active County Name VARCHAR2 9 DEALER_PHONE VARCHAR2 20 No No Active Phone Number Of Dealer VARCHAR2 10 STATE_ABBREVIATION VARCHAR2 2 No No Active State Abbreviation VARCHAR2 11 NMFS_STATE_CODE VARCHAR2 2 No No Active NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry. VARCHAR2 12 NMFS_COUNTY_CODE VARCHAR2 3 No No Active NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry. VARCHAR2 13 FORM_ID VARCHAR2 20 No No Active Logbook form version date is shown in this column VARCHAR2 14 PURCHASE_FISH VARCHAR2 1 No No Active This is a yes/no field. If the dealer did not purchase any highly migratory species during the 2 week period, the no is checked. VARCHAR2 15 FISH_IMPORTED VARCHAR2 1 No No Active This is a yes/no field. If the dealer did not import any fish during the 2 week period, the no is checked. VARCHAR2 16 BATCH_NUMBER VARCHAR2 20 No No Active When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are iss VARCHAR2 17 WEIGH_OUT VARCHAR2 1 No No Active This is a yes/no field. If the weigh out was not submitted by the dealer during the 2 week period, the no is checked. VARCHAR2 18 OP_NAME VARCHAR2 50 No No Active Vendor SUpplied Column VARCHAR2 19 OP_VALUE VARCHAR2 50 No No Active Vendor Supplied Column VARCHAR2 20 OP_DATE VARCHAR2 10 No No Active Vendor Supplied Column VARCHAR2 21 SOURCE_FILE VARCHAR2 50 No No Active Name Of source file loaded that populates this table VARCHAR2 22 RECEIVED_DATE VARCHAR2 10 No No Active Date Logbook form was recieved VARCHAR2 23 POSTMARK_DATE VARCHAR2 10 No No Active Date Logbook form was post marked VARCHAR2 5412 PDC_INT_SCANNED_PURCHASES Published / External Completed Pre-validation table that holds purchase data Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Pre-validation table that holds purchase data 1 ID_NUMBER VARCHAR2 10 No No Active Sequential Number Assigned By Vendor Software During Data Entry VARCHAR2 2 TIF_NO VARCHAR2 12 No No Active This contains the scanned images provided by the vendor. It currently does not have a place in our master tables VARCHAR2 3 SCHEDULE VARCHAR2 12 Yes No Active This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique. VARCHAR2 4 SE_PERMIT_NUMBER VARCHAR2 4 No No Active This is the permit number issued by the Southeast Regional Office for Swordfish and Shark dealers. It is comprised of 4 letters, up to 4 numbers, followed by 2 digits for the year, e.g., DLR-LA-1234-01. Only the center numbers of the permit (e.g., 1234) are entered in the permit files provided by the SE office, as well as into the Swordfish Compliance Program. Updated dealer permit numbers are downloaded and saved in n:\sdc\dbf\dlr_new.dbf.If a Swordfish or Shark dealer (indicated by a SE permit number) also has a Tuna dealer permit (indicated by a NE permit number), it would be helpful if the NE number was automatically entered with the SE permit number. These dealers with both NE and SE issued permits are currently linked in the above mentioned file, dlr_new.dbf. VARCHAR2 5 NE_PERMIT_NUMBER VARCHAR2 4 No No Active This is the permit number issued by the Northeast Regional Office for Tuna dealers. It was once a 5 digit number, zero filled. Now it ranges from 3-4 digits, and not zero filled. VARCHAR2 6 END_DATE VARCHAR2 10 No No Active This is the date that the reporting period ends. This date is often the 15th or the last day of each month. VARCHAR2 7 NMFS_SPECIES VARCHAR2 4 No No Active 4 digit NMFS Species Code VARCHAR2 8 SIZE_CODE VARCHAR2 2 No No Active A code to indicate the size/market category of the fish sold.Sizecodes have not been used previous to 2001. Changes to the sizecode table need to be made. VARCHAR2 9 DRESSED_WEIGHT NUMBER 22 No No 10 2 Active The total pounds that were purchased during the reporting period in dressed weight. NUMBER 10 PRICE_PER_POUND NUMBER 22 No No 10 3 Active This is the average price that the dealer paid for the respective species during the reporting period. NUMBER 11 BATCH_NUMBER VARCHAR2 20 No No Active When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are issued every year to each permit holder, we may get information written on logbooks printed as early as 1992.When this batch of records are sent to the contractor that enters them, since there records are entered using an electronic scanner, the logbooks must be culled by year so that the scanner can correctly interpret the image it is reading. Hence, for each year, we have a separate file.All of the files that form part of a batch are loaded together so that the schedule numbers can be checked. If any are missing or out of bounds, an error is reported during validation. Validation:None. VARCHAR2 12 OP_NAME VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 13 OP_VALUE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 14 OP_DATE DATE 7 No No Active A Vendor Supplied field DATE 15 SOURCE_FILE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 5413 PDC_INT_SCANNED_VESSELS Published / External Completed pre-validation table for the vessel data in PDC System. This table is loaded with data from PDC_INT_ACCESS_VESSELS and data from this table goes into the table PDS_VESSELS Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS pre-validation table for the vessel data in PDC System. This table is loaded with data from PDC_INT_ACCESS_VESSELS and data from this table goes into the table PDS_VESSELS 1 ID_NUMBER VARCHAR2 10 No No Active Sequential Number Assigned By Vendor Software During Data Entry VARCHAR2 2 TIF_NUMBER VARCHAR2 12 No No Active The scan images provided by the vendor VARCHAR2 3 SCHEDULE VARCHAR2 12 Yes No Active This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique. VARCHAR2 4 DATE_LANDED VARCHAR2 10 No No Active Dta vessel landed VARCHAR2 5 VESSEL_NAME VARCHAR2 30 No No Active Vessel Name VARCHAR2 6 VESSELID VARCHAR2 10 No No Active The corrected vessl information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error. VARCHAR2 7 PORT_LANDED VARCHAR2 30 No No Active Port Landed VARCHAR2 8 STATE_LANDED VARCHAR2 10 No No Active State Landed VARCHAR2 9 BATCH_NUMBER VARCHAR2 20 No No Active When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are issued every year to each permit holder, we may get information written on logbooks printed as early as 1992.When this batch of records are sent to the contractor that enters them, since there records are entered using an electronic scanner, the logbooks must be culled by year so that the scanner can correctly interpret the image it is reading. Hence, for each year, we have a separate file.All of the files that form part of a batch are loaded together so that the schedule numbers can be checked. If any are missing or out of bounds, an error is reported during validation. Validation:None. VARCHAR2 10 OP_NAME VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 11 OP_DATE VARCHAR2 8 No No Active A Vendor Supplied field VARCHAR2 12 OP_VALUE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 13 SOURCE_FILE VARCHAR2 50 No No Active Source file used to load this data VARCHAR2 14 REP_VESSELID VARCHAR2 10 No No Active The vessel information reported on the form VARCHAR2 5414 PDC_INT_SCHEDULES Published / External Completed Table listing all schedules entered Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table listing all schedules entered 1 USERID VARCHAR2 30 No No Active Oracle ID VARCHAR2 2 SCHEDULE NUMBER 22 No No 12 0 Active Schedule Number NUMBER 5415 PDC_INT_SCHED_GAPS Published / External Completed Table listing schedules that are not in the system where corresponding schedule numbers below and above the schedule number are in the system Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table listing schedules that are not in the system where corresponding schedule numbers below and above the schedule number are in the system 1 USERID VARCHAR2 30 No No Active Userid of person running program to populate table. VARCHAR2 2 SCHEDULE_FROM NUMBER 22 No No 12 0 Active Lower Schedule Number NUMBER 3 SCHEDULE_TO NUMBER 22 No No 12 0 Active Higher SChedule Number NUMBER 4 SCHEDULE_COUNT NUMBER 22 No No 8 0 Active Number of schedules in range NUMBER 5416 PDC_INT_SHARK_LANDINGS Published / External Completed Table Reporting Sharks Landings For HMS Reports Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table Reporting Sharks Landings For HMS Reports 1 LINE NUMBER 22 No No 3 0 Active Line Number On Report NUMBER 2 DESCRIPTION VARCHAR2 35 No No Active Descrpition to be displayed On The Report VARCHAR2 3 GM_LBS_DRESSED NUMBER 22 No No 10 0 Active Gulf Of Mexico Pounds Dressed Weight NUMBER 4 GM_MT_DRESSED NUMBER 22 No No 11 2 Active Dressed Weight From Gulf Of mexico used in HMS Report NUMBER 5 SA_LBS_DRESSED NUMBER 22 No No 10 0 Active South Atlantic Weight in Dressed Pounds NUMBER 6 SA_MT_DRESSED NUMBER 22 No No 11 2 Active Dressed Weight From South Atlantic used in HMS Report NUMBER 7 NE_LBS_DRESSED NUMBER 22 No No 10 0 Active NE Weight in Dressed Pounds NUMBER 8 NE_MT_DRESSED NUMBER 22 No No 11 2 Active Dressed Weight From North Easten Areas used in HMS Report NUMBER 9 TOTAL_MT_DRESSED NUMBER 22 No No 11 2 Active Total Dressed Weight used in HMS Report NUMBER 10 USERID VARCHAR2 30 No No Active Oracle ID of peroson who populated this table VARCHAR2 5417 PDC_LOGBOOKS_MAILING_CONTROLS Published / External Completed Table to track mailing of logbook forms Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table to track mailing of logbook forms 1 MAILING_PREPARATION_DATE DATE 7 Yes Yes Active Date when the NOAA employee is preparing the mailing lote DATE 2 STARTING_PERMIT_EFFECTIVE_DATE DATE 7 No No Active Date after which the new dealers will be included in the mailing list. DATE 3 LABEL_COUNT NUMBER 22 No No 6 0 Active How many labels were printed in this mailing batch NUMBER 4 USER_ID VARCHAR2 20 Yes Yes Active The NOAA employee who created the mailing batch VARCHAR2 5 COVER_LETTER_MAILING_DATE DATE 7 No No Active Which mailing date will appear in the cover letter DATE 5418 PDC_NEW_PERMITS Published / External Completed Each record is a dealer soon to be mailed Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Each record is a dealer soon to be mailed 1 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 2 SE_PNUMBER VARCHAR2 4 Yes No Active South East Permit Number VARCHAR2 3 NE_PNUMBER VARCHAR2 4 No No Active North East Permit Number VARCHAR2 4 STATUS VARCHAR2 1 No No Active Status. 'A' stands for Active VARCHAR2 5 TOP VARCHAR2 40 Yes No Active Type Of Permit VARCHAR2 6 EDOP DATE 7 No No Active Effective Date Of Permit or when the Permit is Effective DATE 7 EXPDATE DATE 7 No No Active When the Permit is not effective anymore DATE 8 BSTR VARCHAR2 30 No No Active Business Street Address Of Permit Holder VARCHAR2 9 APPSTRT VARCHAR2 30 No No Active Applicants Street Address VARCHAR2 10 TYPE_TOP VARCHAR2 2 No No Active Type Of Permit VARCHAR2 11 NUM_REPORTING_PERIODS NUMBER 22 No No 3 0 Active Number Of Reporting Periods IN the time period the permit is effective NUMBER 12 BCITY VARCHAR2 30 No No Active Business CIty Of Permit Holder VARCHAR2 13 BSTATE VARCHAR2 2 No No Active Business State Of Permit Holder VARCHAR2 14 BZIPCODE VARCHAR2 10 No No Active Business Zip Code Of Permit Holder VARCHAR2 15 BPHONE VARCHAR2 12 No No Active Business Phone Of Permit Holder VARCHAR2 5419 PDC_NEW_PERMITS_HISTORY Published / External Completed Each record is a dealer soon to be mailed Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Each record is a dealer soon to be mailed 1 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 2 SE_PNUMBER VARCHAR2 4 Yes No Active South East Permit Number VARCHAR2 3 NE_PNUMBER VARCHAR2 4 No No Active North East Permit Number VARCHAR2 4 STATUS VARCHAR2 1 No No Active Status. 'A' stands for Active VARCHAR2 5 TOP VARCHAR2 40 Yes No Active Type Of Permit VARCHAR2 6 EDOP DATE 7 No No Active Effective Date Of Permit or when the Permit is Effective DATE 7 EXPDATE DATE 7 No No Active When the Permit is not effective anymore DATE 8 BSTR VARCHAR2 30 No No Active Business Street Address Of Permit Holder VARCHAR2 9 APPSTRT VARCHAR2 30 No No Active Applicants Street Address VARCHAR2 10 TYPE_TOP VARCHAR2 3 No No Active Made 3 05/18/2004 By Lee WeinbergerSo load of historical data goes VARCHAR2 11 NUM_REPORTING_PERIODS NUMBER 22 No No 3 0 Active Number Of Reporting Periods IN the time period the permit is effective NUMBER 12 BCITY VARCHAR2 30 No No Active Business CIty Of Permit Holder VARCHAR2 13 BSTATE VARCHAR2 2 No No Active Business State Of Permit Holder VARCHAR2 14 BZIPCODE VARCHAR2 10 No No Active Business Zip Code Of Permit Holder VARCHAR2 15 BPHONE VARCHAR2 12 No No Active Business Phone Of Permit Holder VARCHAR2 16 MAILING_PREPARATION_DATE DATE 7 Yes No Active Date Mailing was prepared for the Dealer DATE 5420 PDC_NEW_PERMITS_SUBSET Published / External Completed Each record is a dealer soon to be mailed Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Each record is a dealer soon to be mailed 1 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 2 SE_PNUMBER VARCHAR2 4 Yes No Active South East Permit Number VARCHAR2 3 NE_PNUMBER VARCHAR2 4 No No Active North East Permit Number VARCHAR2 4 STATUS VARCHAR2 1 No No Active Status. 'A' stands for Active VARCHAR2 5 TOP VARCHAR2 40 Yes No Active Type Of Permit VARCHAR2 6 EDOP DATE 7 No No Active Effective Date Of Permit or when the Permit is Effective DATE 7 EXPDATE DATE 7 No No Active When the Permit is not effective anymore DATE 8 BSTR VARCHAR2 30 No No Active Business Street Address Of Permit Holder VARCHAR2 9 APPSTRT VARCHAR2 30 No No Active Street Address Of Applicant VARCHAR2 10 TYPE_TOP VARCHAR2 2 No No Active Type Of Permit VARCHAR2 11 NUM_REPORTING_PERIODS NUMBER 22 No No 3 0 Active Number Of Reporting Periods IN the time period the permit is effective NUMBER 12 BCITY VARCHAR2 30 No No Active Business CIty Of Permit Holder VARCHAR2 13 BSTATE VARCHAR2 2 No No Active Business State Of Permit Holder VARCHAR2 14 BZIPCODE VARCHAR2 10 No No Active Business Zip Code Of Permit Holder VARCHAR2 15 BPHONE VARCHAR2 12 No No Active Business Phone Of Permit Holder VARCHAR2 5421 PDC_NE_PNBR_SINGLE_V Published / External Completed View Of those who hold Permits from NE Region Loaded by batch 1703, 10-15-2007 10:13 Data View Yes FLS View Of those who hold Permits from NE Region 1 NE_PNUMBER VARCHAR2 4 No No Active Permit Number From North East Regional Office VARCHAR2 2 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 3 BPHONE VARCHAR2 12 No No Active Bisiness Phine Number VARCHAR2 4 BSTRT VARCHAR2 30 No No Active Business Stret Address VARCHAR2 5 BCITY VARCHAR2 30 No No Active City In Business Address VARCHAR2 6 BSTATE VARCHAR2 2 No No Active State Of Business Address VARCHAR2 7 BZIPCODE VARCHAR2 10 No No Active Zip Code Of Business Address VARCHAR2 5422 PDC_PNUMBER_XREF Published / External Completed Provides a cross reference between NE and SE Permits Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Provides a cross reference between NE and SE Permits 1 SE_PNUMBER VARCHAR2 4 No No Active Permit Number from SE VARCHAR2 2 NE_PNUMBER VARCHAR2 4 No No Active Permt Number from NE VARCHAR2 3 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 5423 PDC_PURCHASES Published / External Completed Table recording purchases by dealers Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table recording purchases by dealers 1 PDC_HEADER_KEY NUMBER 22 Yes No 10 0 Active To Link with PDC_HEADER table. The column here is programatically filled. NUMBER 2 PDC_PURCHASE_KEY NUMBER 22 Yes Yes 10 0 Active Sequence Generated key of this table NUMBER 3 PC_ARTIFICIAL_KEY NUMBER 22 No No 10 0 Active The old PC Key carried from the SDC System on the PC. It was loaded with the historical data, so that the new keys could be assigned. This column is not populated for new data. NUMBER 4 SPECIES_CODE_NMFS VARCHAR2 4 Yes No Active Four digit NMFS code that identifies each species. VARCHAR2 5 PRICE_PER_POUND NUMBER 22 No No 8 2 Active This is the average price that the dealer paid for the respective species during the reporting period. NUMBER 6 VALUE NUMBER 22 No No 9 2 Active Value. Is calculated aS PRICE_PER_POUNDS * TOTAL_POUNDS NUMBER 7 SIZE_CODE VARCHAR2 2 No No Active A code to indicate the size/market category of the fish sold. VARCHAR2 8 TOTAL_POUNDS NUMBER 22 No No 8 0 Active The total pounds that were purchased during the reporting period in dressed weight. NUMBER 5424 PDC_SCANNED_VESSELS_ERRORS_V Published / External Completed View Of Errors Detected While validating pelagic dealer Vessel data Loaded by batch 1703, 10-15-2007 10:13 Data View Yes FLS View Of Errors Detected While validating pelagic dealer Vessel data 1 BATCH_NUMBER VARCHAR2 20 No No Active Vendor assigned number for all records processed during a data scan VARCHAR2 2 SCHEDULE VARCHAR2 12 Yes No Active This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique. VARCHAR2 3 VESSELID VARCHAR2 10 No No Active The corrected vessel information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error. VARCHAR2 4 VESSEL_NAME VARCHAR2 30 No No Active Reported Vessel Name On The Form VARCHAR2 5 DATE_LANDED VARCHAR2 10 No No Active Dta vessel landed VARCHAR2 6 STATE_LANDED VARCHAR2 10 No No Active State Landed VARCHAR2 7 PORT_LANDED VARCHAR2 30 No No Active Port Landed On Data Entry Form VARCHAR2 8 VESSEL_ID_VALUE VARCHAR2 50 No No Active Suggested Vessel Id Value VARCHAR2 9 VESSEL_NAME_VALUE VARCHAR2 50 No No Active Suggested New Vessel Name Value VARCHAR2 10 PORT_LANDED_VALUE VARCHAR2 50 No No Active Suggested New Port Landed Value VARCHAR2 11 COLUMN_NAME VARCHAR2 50 No No Active Column That has the validation error. (Usually this will be a port name that there is no assigned port/county code or a case where a vessel name is supplied with no vessel id. VARCHAR2 12 USERID VARCHAR2 20 No No Active Oracle ID of the runner of the validation program VARCHAR2 5425 PDC_SE_PNBR_SINGLE_V Published / External Completed View Of those who hold Permits from SE Region Loaded by batch 1703, 10-15-2007 10:13 Data View Yes FLS View Of those who hold Permits from SE Region 1 PNUMBER VARCHAR2 4 No No Active Permit Number VARCHAR2 2 BNAME VARCHAR2 45 No No Active Business Name VARCHAR2 3 BPHONE VARCHAR2 12 No No Active Bisiness Phine Number VARCHAR2 4 BSTRT VARCHAR2 30 No No Active Business Stret Address VARCHAR2 5 BCITY VARCHAR2 30 No No Active City In Business Address VARCHAR2 6 BSTATE VARCHAR2 2 No No Active State Of Business Address VARCHAR2 7 BZIPCODE VARCHAR2 10 No No Active Zip Code Of Business Address VARCHAR2 5426 PDC_SIZE_CODES Published / External Completed List OF Valid Size Codes From PDC System. In some cases the size code refers to a specific species code and the isize of that species that was brought to market Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS List OF Valid Size Codes From PDC System. In some cases the size code refers to a specific species code and the isize of that species that was brought to market 1 SIZE_CODE VARCHAR2 2 Yes Yes Active Size Code For PDC System VARCHAR2 2 NMFS_CODE VARCHAR2 4 No No Active 4 digit NMFS SPecies Code corresponding to the species associated with the size code. VARCHAR2 3 DESCRIPTION VARCHAR2 40 No No Active The description of the meaning of the size code VARCHAR2 5427 PDC_SPC_CATEGORIES Published / External Completed For HMS Reporting -- This table lists the valid Categories and their descriptions and the group and sub group associated with them Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS For HMS Reporting -- This table lists the valid Categories and their descriptions and the group and sub group associated with them 1 GROUP_NAME VARCHAR2 5 Yes Yes Active Group Name VARCHAR2 2 SUB_GROUP VARCHAR2 3 Yes Yes Active Sub Group Name VARCHAR2 3 CATEGORY VARCHAR2 5 Yes Yes Active Category Name VARCHAR2 4 CATEGORY_DESCR VARCHAR2 30 Yes No Active Category Descriptions VARCHAR2 5428 PDC_SPECIES_NMFS_TOP Published / External Completed Table listing Species Summarized On The Top half of the report to HMS and the permit associated wih them Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table listing Species Summarized On The Top half of the report to HMS and the permit associated wih them 1 SPECIES_CODE_NMFS VARCHAR2 4 Yes Yes Active NMFS Species Code VARCHAR2 2 PERMIT_CODE VARCHAR2 2 Yes Yes Active Permit required to sell the species in question VARCHAR2 5429 PDC_SPECIES_RANGES Published / External Completed Table used for range checking of reported landings of species. The Group_name , sub_group, and category columns are also used for allow flexible summary and grouping for reports to Headquaters (HMS) on quota monitoring. Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table used for range checking of reported landings of species. The Group_name , sub_group, and category columns are also used for allow flexible summary and grouping for reports to Headquaters (HMS) on quota monitoring. 1 SPECIES_CODE_NMFS VARCHAR2 4 Yes Yes Active NMFS 4 digit species code VARCHAR2 2 COMMON_NAME VARCHAR2 30 No No Active Common Name Associated With The Species Code VARCHAR2 3 MAXIMUM_TOTAL_WHOLE_WEIGHT NUMBER 22 No No 5 0 Active Maximum Whole Weight Reported To Trigger an error.inquiry NUMBER 4 GROUP_NAME VARCHAR2 5 No No Active Which Group To Be Used in Reporting Data to HMS for quota monitoring VARCHAR2 5 SUB_GROUP VARCHAR2 3 No No Active Which Sub-Group To Be Used in Reporting Data to HMS for quota monitoring VARCHAR2 6 CATEGORY VARCHAR2 5 No No Active Which Category To Be Used in Reporting Data to HMS for quota monitoring VARCHAR2 5430 PDC_SUB_GROUPS Published / External Completed Table Of Valid Sub Groups. This table allows flexibility on delaing with the changing requiemnets of reporting to HMS in headquarters. Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table Of Valid Sub Groups. This table allows flexibility on delaing with the changing requiemnets of reporting to HMS in headquarters. 1 GROUP_NAME VARCHAR2 5 Yes Yes Active Group Code VARCHAR2 2 SUB_GROUP VARCHAR2 3 Yes Yes Active Sub Group Code VARCHAR2 3 SUB_GROUP_DESCR VARCHAR2 30 Yes No Active Sub Group Description VARCHAR2 5431 PDC_VESSELS Published / External Completed This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER. Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER. 1 PDC_HEADER_KEY NUMBER 22 Yes No 10 0 Active Key to Header Table NUMBER 2 PDC_VESSEL_KEY NUMBER 22 Yes Yes 10 0 Active Primary key of the table.. NUMBER 3 PC_ARTIFICIAL_KEY NUMBER 22 No No 10 0 Active historical key use when this was a PC based system NUMBER 4 VESSELID VARCHAR2 10 No No Active The corrected vessl information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error. VARCHAR2 5 VESSELNAME VARCHAR2 30 No No Active The vessel name VARCHAR2 6 DATE_LANDED DATE 7 No No Active Dta vessel landed DATE 7 LANDING_PORT VARCHAR2 30 No No Active Landing port of the vessel VARCHAR2 8 ALPHA_STATE_LANDED VARCHAR2 2 No No Active 2 character alphabetic code of state landed. VARCHAR2 9 REP_VESSELID VARCHAR2 10 No No Active The vessel information reported on the form VARCHAR2 10 TIF_NUMBER VARCHAR2 12 No No Active The scan images provided by the vendor VARCHAR2 Data Steward 1992 2016 Person Baertlein, Heather heather.baertlein@noaa.gov (608) 713-1793 Distributor 1992 Organization Southeast Fisheries Science Center SEFSC https://ror.org/0396y0w87 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center About SEFSC Online Resource 8:00 a.m. - 4:30 p.m. EST Metadata Contact 1992 2016 Person Baertlein, Heather heather.baertlein@noaa.gov (608) 713-1793 Point of Contact 1992 Person Judge, Michael Michael.Judge@noaa.gov 75 Virginia Beach Drive Miami FL 33149 305-361-4235 305-361-4562 Contact by email preferred. Ground Condition -100 -40 30 0 Gulf Of Mexico And South Atlantic Ocean Range 1992 2012 Sensitive Read and sign for NOAA Administrative Order 216 100 Read and sign System Access Application (see URLs) Contact DBA Daniel Leon at daniel.leon noaa.gov for userid password. Waiver needed Range checks and validation against historical distributions. Yes 70 Yes Yes No 60 Confidentiality. This data is currently wavered under the current NOAA guidelines for relational databases. To Be Determined 0 The data resides on a secure database server only accessible through the NMFS network requiring separate multi-factor authentication for both network and database access. 1 Forms submitted by seafood dealers to SEFSC staff through paper logbooks. Data entry is done by an offsite contractor. SEFSC staff Q/C data into database housed in Miami. 5403 Entity 5404 Entity 5405 Entity 5406 Entity 5407 Entity 5408 Entity 5409 Entity 5410 Entity 5411 Entity 5412 Entity 5413 Entity 5414 Entity 5415 Entity 5416 Entity 5417 Entity 5418 Entity 5419 Entity 5420 Entity 5422 Entity 5423 Entity 5426 Entity 5427 Entity 5428 Entity 5429 Entity 5430 Entity 5431 Entity 5421 Entity 5424 Entity 5425 Entity gov.noaa.nmfs.inport:5402 Lee Weinberger 2007-10-15T10:05:37 SysAdmin InPortAdmin 2026-03-04T19:17:18 2021-05-06 Southeast Fisheries Science Center SEFSC 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 www.sefsc.noaa.gov 8:00 a.m. - 4:30 p.m. EST 1001 Public No No 2021-05-06 1 Year 2022-05-06