5406
Table: PDC_INT_ACCESS_HEADERS
PDC_INT_ACCESS_HEADERS
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
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
gov.noaa.nmfs.inport:5406
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