5411
Table: PDC_INT_SCANNED_HEADERS
PDC_INT_SCANNED_HEADERS
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
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
gov.noaa.nmfs.inport:5411
Lee Weinberger
2007-10-15T10:13:55
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