5407
Table: PDC_INT_ACCESS_PURCHASES
PDC_INT_ACCESS_PURCHASES
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
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
gov.noaa.nmfs.inport:5407
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