5408
Table: PDC_INT_ACCESS_VESSELS
PDC_INT_ACCESS_VESSELS
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
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
gov.noaa.nmfs.inport:5408
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