5405
Table: PDC_HEADERS
PDC_HEADERS
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
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
gov.noaa.nmfs.inport:5405
Lee Weinberger
2007-10-15T10:13:54
SysAdmin InPortAdmin
2022-08-09T17:11:00
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
2021-05-06
1 Year
2022-05-06