5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Oracle Tables For PDC/HMS Reporting
Data Set
Published / External
2004
Pelagic Dealer Compliance
Project
In Work
This data set contains summarized pounds of select pelagic fish species bought by selected federally permitted seafood dealers in the SE Region of the US mainland. Data was collected 2 times each month and used for quota monitoring.
Commercial in-season quota monitoring
Trip landing reports submitted by HMS dealers
Theme
dealers
Theme
highly migratory species
Theme
sharks
Theme
swordfish
Theme
tuna
Theme
vessels
Spatial
East Coast Of United States
Spatial
Puerto Rico
Spatial
Virgin Islands
Southeast Fisheries Science Center
Miami
FL
USA
Location Of The Main Office Of The South East Fisheries Science Center
Data Set
Table (digital)
N/A
N/A
N/A
5403
Table: DPS_DEALER_PERMIT
DPS_DEALER_PERMIT
Published / External
Completed
Dealer Permit Table .
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Dealer Permit Table .
1
LU
VARCHAR2
1
No
No
Active
- Retrofitted
VARCHAR2
2
IDNUM
VARCHAR2
15
No
No
Active
- Retrofitted
VARCHAR2
3
TOP
VARCHAR2
40
No
No
Active
Type Of Permit
VARCHAR2
4
PNUMBER
VARCHAR2
4
No
No
Active
Permit Number
VARCHAR2
5
EDOP
DATE
7
No
No
Active
Effective Date Of Permit
DATE
6
RDEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
7
RSEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
8
SGEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
9
SHEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
10
SDEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
11
EXPDATE
DATE
7
No
No
Active
Expiration Date Of Permit
DATE
12
DOE
DATE
7
No
No
Active
- Retrofitted
DATE
13
STATUS
VARCHAR2
1
No
No
Active
- Retrofitted
VARCHAR2
14
DOS
DATE
7
No
No
Active
- Retrofitted
DATE
15
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
16
BSTRT
VARCHAR2
30
No
No
Active
Business Stret Address
VARCHAR2
17
BPHONE
VARCHAR2
12
No
No
Active
Bisiness Phine Number
VARCHAR2
18
BCITY
VARCHAR2
30
No
No
Active
City In Business Address
VARCHAR2
19
BSTATE
VARCHAR2
2
No
No
Active
State Of Business Address
VARCHAR2
20
BZIPCODE
VARCHAR2
10
No
No
Active
Zip Code Of Business Address
VARCHAR2
21
BDOB
DATE
7
No
No
Active
Business Date Of Incorporation or date of business start or application for permit
DATE
22
FNAME1
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
23
FPHONE1
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
24
FSTRT1
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
25
FCITY1
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
26
FSTATE1
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
27
FZIPCOD1
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
28
FNAME2
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
29
FPHONE2
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
30
FSTRT2
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
31
FCITY2
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
32
FSTATE2
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
33
FZIPCOD2
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
34
FNAME3
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
35
FPHONE3
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
36
FSTRT3
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
37
FCITY3
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
38
FSTATE3
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
39
FZIPCOD3
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
40
FNAME4
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
41
FPHONE4
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
42
FSTRT4
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
43
FCITY4
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
44
FSTATE4
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
45
FZIPCOD4
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
46
FNAME5
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
47
FPHONE5
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
48
FSTRT5
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
49
FCITY5
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
50
FSTATE5
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
51
FZIPCOD5
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
52
FNAME6
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
53
FPHONE6
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
54
FSTRT6
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
55
FCITY6
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
56
FSTATE6
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
57
FZIPCOD6
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
58
APPNAME
VARCHAR2
35
No
No
Active
- Retrofitted
VARCHAR2
59
APPPOS
VARCHAR2
25
No
No
Active
- Retrofitted
VARCHAR2
60
APPPHONE
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
61
APPSSN
VARCHAR2
11
No
No
Active
- Retrofitted
VARCHAR2
62
APPDOB
DATE
7
No
No
Active
- Retrofitted
DATE
63
APPSTRT
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
64
APPCITY
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
65
APPSTATE
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
66
APPZIP
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
67
REMARKS
VARCHAR2
250
No
No
Active
- Retrofitted
VARCHAR2
68
INITS
VARCHAR2
8
No
No
Active
- Retrofitted
VARCHAR2
69
NE_PNUMBER
VARCHAR2
4
No
No
Active
Permit Number Assigned By NE Regional Office for Permits that they are responsible for.
VARCHAR2
70
NMFS_STATE
VARCHAR2
2
No
No
Active
NMFS State Of Dealer Location
VARCHAR2
71
NMFS_CTY
VARCHAR2
2
No
No
Active
NMFS County
VARCHAR2
72
FL_STATE
VARCHAR2
2
No
No
Active
Florida State
VARCHAR2
5404
Table: FLS_INT_VALIDATION_ERRORS
FLS_INT_VALIDATION_ERRORS
Published / External
Completed
Hold Validation Errors from the processing of a scanned batchof logbook data. All columns may not be used in this table depeneding upon whether the validation run is for a dealer logbook, or from whatever fishers logbook that was scanned
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Hold Validation Errors from the processing of a scanned batchof logbook data. All columns may not be used in this table depeneding upon whether the validation run is for a dealer logbook, or from whatever fishers logbook that was scanned
1
ERROR_NUMBER
VARCHAR2
10
No
No
Active
Error Number
VARCHAR2
2
BATCH_NUMBER
VARCHAR2
10
No
No
Active
Batch Number
VARCHAR2
3
SCHEDULE_NUMBER
VARCHAR2
10
No
No
Active
Schedule Number
VARCHAR2
4
LOGBOOK_KEY
NUMBER
22
No
No
10
0
Active
Logbook Key -- Links to FLS_LOGBOOKS Received
NUMBER
5
FISHING_ACTIVITY_KEY
NUMBER
22
No
No
10
0
Active
Fishing Activity Key
NUMBER
6
GEAR_FISHED_KEY
NUMBER
22
No
No
10
0
Active
Gear Fished Key Of Record With Errors
NUMBER
7
CATCH_KEY
NUMBER
22
No
No
10
0
Active
Catch Key Of Record With Errors
NUMBER
8
CHILD_NAME_KEY
VARCHAR2
30
No
No
Active
In caes of fisher logbooks, the name of the child table that is generating the error
VARCHAR2
9
CHILD_VALUE_KEY
NUMBER
22
No
No
10
0
Active
In caes of fisher logbooks, the valuef the child table column that is generating the error
NUMBER
10
TABLE_NAME
VARCHAR2
50
No
No
Active
Oracle Table that contains validation Error
VARCHAR2
11
COLUMN_NAME
VARCHAR2
50
No
No
Active
Oracle Column of Record containg validation error
VARCHAR2
12
VALUE
VARCHAR2
50
No
No
Active
Data Value in error
VARCHAR2
13
ERROR_MESSAGE
VARCHAR2
200
No
No
Active
Validation Error Message
VARCHAR2
14
DATA_TYPE
VARCHAR2
10
No
No
Active
Data Type Of Column That is in err
VARCHAR2
15
TABLE_TYPE
VARCHAR2
10
No
No
Active
Type Of table that has validation error
VARCHAR2
16
ERROR_TYPE
VARCHAR2
10
Yes
No
Active
Type Of validation error
VARCHAR2
17
DATE_ENTERED
DATE
7
No
No
Active
Date Time stamp of when record was added to this table
DATE
18
SOURCE_FILE
VARCHAR2
30
No
No
Active
Name Of File Loaded That caused validation error
VARCHAR2
19
USERID
VARCHAR2
20
No
No
Active
Oracle Id of one who ran validation program
VARCHAR2
20
ERROR_TYPE_CHANGED
VARCHAR2
1
No
No
Active
Has Type Of Error changed. Valid values or Y or N.
VARCHAR2
21
BATCH_SEQUENCE_NUMBER
VARCHAR2
10
No
No
Active
Batch sequence Number of record that erred
VARCHAR2
22
VESSEL_ID_NUMBER
VARCHAR2
10
No
No
Active
Vessel Identification Number Of Record that erred
VARCHAR2
5405
Table: PDC_HEADERS
PDC_HEADERS
Published / External
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
5406
Table: PDC_INT_ACCESS_HEADERS
PDC_INT_ACCESS_HEADERS
Published / External
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
5407
Table: PDC_INT_ACCESS_PURCHASES
PDC_INT_ACCESS_PURCHASES
Published / External
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
5408
Table: PDC_INT_ACCESS_VESSELS
PDC_INT_ACCESS_VESSELS
Published / External
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
5409
Table: PDC_INT_MOST_ACTIVE_DLRS
PDC_INT_MOST_ACTIVE_DLRS
Published / External
Completed
Table Listing Dealers With Highest Recorded Purchases
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table Listing Dealers With Highest Recorded Purchases
1
DEALER_NAME
VARCHAR2
45
No
No
Active
Dealer Name
VARCHAR2
2
SE_PNUMBER
VARCHAR2
4
No
No
Active
South East Permit Number
VARCHAR2
3
NE_PNUMBER
VARCHAR2
4
No
No
Active
North East Permit Number
VARCHAR2
4
EXPIRATION_DATE
DATE
7
No
No
Active
That is the date in which the permit expires
DATE
5
TOTAL_POUNDS
NUMBER
22
No
No
10
0
Active
Total Pounds Reported
NUMBER
6
RANK
NUMBER
22
No
No
5
0
Active
The rank according to the total pounds, being 1 the dealer with more total pounds
NUMBER
7
PERCENT
NUMBER
22
No
No
6
2
Active
This dealer total pounds / ALL dealer total pounds * 100
NUMBER
8
USERID
VARCHAR2
30
No
No
Active
Who is calling the report.
VARCHAR2
5410
Table: PDC_INT_REPORTING_LABELS
PDC_INT_REPORTING_LABELS
Published / External
Completed
Each record is a dealer soon to be mailed
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Each record is a dealer soon to be mailed
1
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
2
BPHONE
VARCHAR2
12
No
No
Active
Business Phone Of Permit Holder
VARCHAR2
3
SE_PNUMBER
VARCHAR2
4
No
No
Active
South East Permit Number
VARCHAR2
4
NE_PNUMBER
VARCHAR2
4
No
No
Active
North East Permit Number
VARCHAR2
5
BEGIN_DATE
DATE
7
No
No
Active
Start Date
DATE
6
END_DATE
DATE
7
No
No
Active
End Date
DATE
7
USERID
VARCHAR2
30
No
No
Active
Oracle ID of the creator of this record
VARCHAR2
8
VOID
VARCHAR2
1
No
No
Active
Trick field. It will be TRUE if the record is not to be printed
VARCHAR2
9
TYPE_TOP
VARCHAR2
2
No
No
Active
Type Of Permit
VARCHAR2
5411
Table: PDC_INT_SCANNED_HEADERS
PDC_INT_SCANNED_HEADERS
Published / External
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
5412
Table: PDC_INT_SCANNED_PURCHASES
PDC_INT_SCANNED_PURCHASES
Published / External
Completed
Pre-validation table that holds purchase data
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Pre-validation table that holds purchase data
1
ID_NUMBER
VARCHAR2
10
No
No
Active
Sequential Number Assigned By Vendor Software During Data Entry
VARCHAR2
2
TIF_NO
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
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 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
SE_PERMIT_NUMBER
VARCHAR2
4
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
5
NE_PERMIT_NUMBER
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
6
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
7
NMFS_SPECIES
VARCHAR2
4
No
No
Active
4 digit NMFS Species Code
VARCHAR2
8
SIZE_CODE
VARCHAR2
2
No
No
Active
A code to indicate the size/market category of the fish sold.Sizecodes have not been used previous to 2001. Changes to the sizecode table need to be made.
VARCHAR2
9
DRESSED_WEIGHT
NUMBER
22
No
No
10
2
Active
The total pounds that were purchased during the reporting period in dressed weight.
NUMBER
10
PRICE_PER_POUND
NUMBER
22
No
No
10
3
Active
This is the average price that the dealer paid for the respective species during the reporting period.
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 every year to each permit holder, we may get information written on logbooks printed as early as 1992.When this batch of records are sent to the contractor that enters them, since there records are entered using an electronic scanner, the logbooks must be culled by year so that the scanner can correctly interpret the image it is reading. Hence, for each year, we have a separate file.All of the files that form part of a batch are loaded together so that the schedule numbers can be checked. If any are missing or out of bounds, an error is reported during validation. Validation:None.
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
15
SOURCE_FILE
VARCHAR2
50
No
No
Active
A Vendor Supplied field
VARCHAR2
5413
Table: PDC_INT_SCANNED_VESSELS
PDC_INT_SCANNED_VESSELS
Published / External
Completed
pre-validation table for the vessel data in PDC System. This table is loaded with data from PDC_INT_ACCESS_VESSELS and data from this table goes into the table PDS_VESSELS
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
pre-validation table for the vessel data in PDC System. This table is loaded with data from PDC_INT_ACCESS_VESSELS and data from this table goes into the table PDS_VESSELS
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
The scan images provided by the vendor
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 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
DATE_LANDED
VARCHAR2
10
No
No
Active
Dta vessel landed
VARCHAR2
5
VESSEL_NAME
VARCHAR2
30
No
No
Active
Vessel Name
VARCHAR2
6
VESSELID
VARCHAR2
10
No
No
Active
The corrected vessl information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
VARCHAR2
7
PORT_LANDED
VARCHAR2
30
No
No
Active
Port Landed
VARCHAR2
8
STATE_LANDED
VARCHAR2
10
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 every year to each permit holder, we may get information written on logbooks printed as early as 1992.When this batch of records are sent to the contractor that enters them, since there records are entered using an electronic scanner, the logbooks must be culled by year so that the scanner can correctly interpret the image it is reading. Hence, for each year, we have a separate file.All of the files that form part of a batch are loaded together so that the schedule numbers can be checked. If any are missing or out of bounds, an error is reported during validation. Validation:None.
VARCHAR2
10
OP_NAME
VARCHAR2
50
No
No
Active
A Vendor Supplied field
VARCHAR2
11
OP_DATE
VARCHAR2
8
No
No
Active
A Vendor Supplied field
VARCHAR2
12
OP_VALUE
VARCHAR2
50
No
No
Active
A Vendor Supplied field
VARCHAR2
13
SOURCE_FILE
VARCHAR2
50
No
No
Active
Source file used to load this data
VARCHAR2
14
REP_VESSELID
VARCHAR2
10
No
No
Active
The vessel information reported on the form
VARCHAR2
5414
Table: PDC_INT_SCHEDULES
PDC_INT_SCHEDULES
Published / External
Completed
Table listing all schedules entered
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table listing all schedules entered
1
USERID
VARCHAR2
30
No
No
Active
Oracle ID
VARCHAR2
2
SCHEDULE
NUMBER
22
No
No
12
0
Active
Schedule Number
NUMBER
5415
Table: PDC_INT_SCHED_GAPS
PDC_INT_SCHED_GAPS
Published / External
Completed
Table listing schedules that are not in the system where corresponding schedule numbers below and above the schedule number are in the system
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table listing schedules that are not in the system where corresponding schedule numbers below and above the schedule number are in the system
1
USERID
VARCHAR2
30
No
No
Active
Userid of person running program to populate table.
VARCHAR2
2
SCHEDULE_FROM
NUMBER
22
No
No
12
0
Active
Lower Schedule Number
NUMBER
3
SCHEDULE_TO
NUMBER
22
No
No
12
0
Active
Higher SChedule Number
NUMBER
4
SCHEDULE_COUNT
NUMBER
22
No
No
8
0
Active
Number of schedules in range
NUMBER
5416
Table: PDC_INT_SHARK_LANDINGS
PDC_INT_SHARK_LANDINGS
Published / External
Completed
Table Reporting Sharks Landings For HMS Reports
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table Reporting Sharks Landings For HMS Reports
1
LINE
NUMBER
22
No
No
3
0
Active
Line Number On Report
NUMBER
2
DESCRIPTION
VARCHAR2
35
No
No
Active
Descrpition to be displayed On The Report
VARCHAR2
3
GM_LBS_DRESSED
NUMBER
22
No
No
10
0
Active
Gulf Of Mexico Pounds Dressed Weight
NUMBER
4
GM_MT_DRESSED
NUMBER
22
No
No
11
2
Active
Dressed Weight From Gulf Of mexico used in HMS Report
NUMBER
5
SA_LBS_DRESSED
NUMBER
22
No
No
10
0
Active
South Atlantic Weight in Dressed Pounds
NUMBER
6
SA_MT_DRESSED
NUMBER
22
No
No
11
2
Active
Dressed Weight From South Atlantic used in HMS Report
NUMBER
7
NE_LBS_DRESSED
NUMBER
22
No
No
10
0
Active
NE Weight in Dressed Pounds
NUMBER
8
NE_MT_DRESSED
NUMBER
22
No
No
11
2
Active
Dressed Weight From North Easten Areas used in HMS Report
NUMBER
9
TOTAL_MT_DRESSED
NUMBER
22
No
No
11
2
Active
Total Dressed Weight used in HMS Report
NUMBER
10
USERID
VARCHAR2
30
No
No
Active
Oracle ID of peroson who populated this table
VARCHAR2
5417
Table: PDC_LOGBOOKS_MAILING_CONTROLS
PDC_LOGBOOKS_MAILING_CONTROLS
Published / External
Completed
Table to track mailing of logbook forms
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table to track mailing of logbook forms
1
MAILING_PREPARATION_DATE
DATE
7
Yes
Yes
Active
Date when the NOAA employee is preparing the mailing lote
DATE
2
STARTING_PERMIT_EFFECTIVE_DATE
DATE
7
No
No
Active
Date after which the new dealers will be included in the mailing list.
DATE
3
LABEL_COUNT
NUMBER
22
No
No
6
0
Active
How many labels were printed in this mailing batch
NUMBER
4
USER_ID
VARCHAR2
20
Yes
Yes
Active
The NOAA employee who created the mailing batch
VARCHAR2
5
COVER_LETTER_MAILING_DATE
DATE
7
No
No
Active
Which mailing date will appear in the cover letter
DATE
5418
Table: PDC_NEW_PERMITS
PDC_NEW_PERMITS
Published / External
Completed
Each record is a dealer soon to be mailed
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Each record is a dealer soon to be mailed
1
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
2
SE_PNUMBER
VARCHAR2
4
Yes
No
Active
South East Permit Number
VARCHAR2
3
NE_PNUMBER
VARCHAR2
4
No
No
Active
North East Permit Number
VARCHAR2
4
STATUS
VARCHAR2
1
No
No
Active
Status. 'A' stands for Active
VARCHAR2
5
TOP
VARCHAR2
40
Yes
No
Active
Type Of Permit
VARCHAR2
6
EDOP
DATE
7
No
No
Active
Effective Date Of Permit or when the Permit is Effective
DATE
7
EXPDATE
DATE
7
No
No
Active
When the Permit is not effective anymore
DATE
8
BSTR
VARCHAR2
30
No
No
Active
Business Street Address Of Permit Holder
VARCHAR2
9
APPSTRT
VARCHAR2
30
No
No
Active
Applicants Street Address
VARCHAR2
10
TYPE_TOP
VARCHAR2
2
No
No
Active
Type Of Permit
VARCHAR2
11
NUM_REPORTING_PERIODS
NUMBER
22
No
No
3
0
Active
Number Of Reporting Periods IN the time period the permit is effective
NUMBER
12
BCITY
VARCHAR2
30
No
No
Active
Business CIty Of Permit Holder
VARCHAR2
13
BSTATE
VARCHAR2
2
No
No
Active
Business State Of Permit Holder
VARCHAR2
14
BZIPCODE
VARCHAR2
10
No
No
Active
Business Zip Code Of Permit Holder
VARCHAR2
15
BPHONE
VARCHAR2
12
No
No
Active
Business Phone Of Permit Holder
VARCHAR2
5419
Table: PDC_NEW_PERMITS_HISTORY
PDC_NEW_PERMITS_HISTORY
Published / External
Completed
Each record is a dealer soon to be mailed
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Each record is a dealer soon to be mailed
1
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
2
SE_PNUMBER
VARCHAR2
4
Yes
No
Active
South East Permit Number
VARCHAR2
3
NE_PNUMBER
VARCHAR2
4
No
No
Active
North East Permit Number
VARCHAR2
4
STATUS
VARCHAR2
1
No
No
Active
Status. 'A' stands for Active
VARCHAR2
5
TOP
VARCHAR2
40
Yes
No
Active
Type Of Permit
VARCHAR2
6
EDOP
DATE
7
No
No
Active
Effective Date Of Permit or when the Permit is Effective
DATE
7
EXPDATE
DATE
7
No
No
Active
When the Permit is not effective anymore
DATE
8
BSTR
VARCHAR2
30
No
No
Active
Business Street Address Of Permit Holder
VARCHAR2
9
APPSTRT
VARCHAR2
30
No
No
Active
Applicants Street Address
VARCHAR2
10
TYPE_TOP
VARCHAR2
3
No
No
Active
Made 3 05/18/2004 By Lee WeinbergerSo load of historical data goes
VARCHAR2
11
NUM_REPORTING_PERIODS
NUMBER
22
No
No
3
0
Active
Number Of Reporting Periods IN the time period the permit is effective
NUMBER
12
BCITY
VARCHAR2
30
No
No
Active
Business CIty Of Permit Holder
VARCHAR2
13
BSTATE
VARCHAR2
2
No
No
Active
Business State Of Permit Holder
VARCHAR2
14
BZIPCODE
VARCHAR2
10
No
No
Active
Business Zip Code Of Permit Holder
VARCHAR2
15
BPHONE
VARCHAR2
12
No
No
Active
Business Phone Of Permit Holder
VARCHAR2
16
MAILING_PREPARATION_DATE
DATE
7
Yes
No
Active
Date Mailing was prepared for the Dealer
DATE
5420
Table: PDC_NEW_PERMITS_SUBSET
PDC_NEW_PERMITS_SUBSET
Published / External
Completed
Each record is a dealer soon to be mailed
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Each record is a dealer soon to be mailed
1
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
2
SE_PNUMBER
VARCHAR2
4
Yes
No
Active
South East Permit Number
VARCHAR2
3
NE_PNUMBER
VARCHAR2
4
No
No
Active
North East Permit Number
VARCHAR2
4
STATUS
VARCHAR2
1
No
No
Active
Status. 'A' stands for Active
VARCHAR2
5
TOP
VARCHAR2
40
Yes
No
Active
Type Of Permit
VARCHAR2
6
EDOP
DATE
7
No
No
Active
Effective Date Of Permit or when the Permit is Effective
DATE
7
EXPDATE
DATE
7
No
No
Active
When the Permit is not effective anymore
DATE
8
BSTR
VARCHAR2
30
No
No
Active
Business Street Address Of Permit Holder
VARCHAR2
9
APPSTRT
VARCHAR2
30
No
No
Active
Street Address Of Applicant
VARCHAR2
10
TYPE_TOP
VARCHAR2
2
No
No
Active
Type Of Permit
VARCHAR2
11
NUM_REPORTING_PERIODS
NUMBER
22
No
No
3
0
Active
Number Of Reporting Periods IN the time period the permit is effective
NUMBER
12
BCITY
VARCHAR2
30
No
No
Active
Business CIty Of Permit Holder
VARCHAR2
13
BSTATE
VARCHAR2
2
No
No
Active
Business State Of Permit Holder
VARCHAR2
14
BZIPCODE
VARCHAR2
10
No
No
Active
Business Zip Code Of Permit Holder
VARCHAR2
15
BPHONE
VARCHAR2
12
No
No
Active
Business Phone Of Permit Holder
VARCHAR2
5421
View: PDC_NE_PNBR_SINGLE_V
PDC_NE_PNBR_SINGLE_V
Published / External
Completed
View Of those who hold Permits from NE Region
Loaded by batch 1703, 10-15-2007 10:13
Data View
Yes
FLS
View Of those who hold Permits from NE Region
1
NE_PNUMBER
VARCHAR2
4
No
No
Active
Permit Number From North East Regional Office
VARCHAR2
2
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
3
BPHONE
VARCHAR2
12
No
No
Active
Bisiness Phine Number
VARCHAR2
4
BSTRT
VARCHAR2
30
No
No
Active
Business Stret Address
VARCHAR2
5
BCITY
VARCHAR2
30
No
No
Active
City In Business Address
VARCHAR2
6
BSTATE
VARCHAR2
2
No
No
Active
State Of Business Address
VARCHAR2
7
BZIPCODE
VARCHAR2
10
No
No
Active
Zip Code Of Business Address
VARCHAR2
5422
Table: PDC_PNUMBER_XREF
PDC_PNUMBER_XREF
Published / External
Completed
Provides a cross reference between NE and SE Permits
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Provides a cross reference between NE and SE Permits
1
SE_PNUMBER
VARCHAR2
4
No
No
Active
Permit Number from SE
VARCHAR2
2
NE_PNUMBER
VARCHAR2
4
No
No
Active
Permt Number from NE
VARCHAR2
3
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
5423
Table: PDC_PURCHASES
PDC_PURCHASES
Published / External
Completed
Table recording purchases by dealers
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table recording purchases by dealers
1
PDC_HEADER_KEY
NUMBER
22
Yes
No
10
0
Active
To Link with PDC_HEADER table. The column here is programatically filled.
NUMBER
2
PDC_PURCHASE_KEY
NUMBER
22
Yes
Yes
10
0
Active
Sequence Generated key of this table
NUMBER
3
PC_ARTIFICIAL_KEY
NUMBER
22
No
No
10
0
Active
The old PC Key carried from the SDC System on the PC. It was loaded with the historical data, so that the new keys could be assigned. This column is not populated for new data.
NUMBER
4
SPECIES_CODE_NMFS
VARCHAR2
4
Yes
No
Active
Four digit NMFS code that identifies each species.
VARCHAR2
5
PRICE_PER_POUND
NUMBER
22
No
No
8
2
Active
This is the average price that the dealer paid for the respective species during the reporting period.
NUMBER
6
VALUE
NUMBER
22
No
No
9
2
Active
Value. Is calculated aS PRICE_PER_POUNDS * TOTAL_POUNDS
NUMBER
7
SIZE_CODE
VARCHAR2
2
No
No
Active
A code to indicate the size/market category of the fish sold.
VARCHAR2
8
TOTAL_POUNDS
NUMBER
22
No
No
8
0
Active
The total pounds that were purchased during the reporting period in dressed weight.
NUMBER
5424
View: PDC_SCANNED_VESSELS_ERRORS_V
PDC_SCANNED_VESSELS_ERRORS_V
Published / External
Completed
View Of Errors Detected While validating pelagic dealer Vessel data
Loaded by batch 1703, 10-15-2007 10:13
Data View
Yes
FLS
View Of Errors Detected While validating pelagic dealer Vessel data
1
BATCH_NUMBER
VARCHAR2
20
No
No
Active
Vendor assigned number for all records processed during a data scan
VARCHAR2
2
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 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
3
VESSELID
VARCHAR2
10
No
No
Active
The corrected vessel information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
VARCHAR2
4
VESSEL_NAME
VARCHAR2
30
No
No
Active
Reported Vessel Name On The Form
VARCHAR2
5
DATE_LANDED
VARCHAR2
10
No
No
Active
Dta vessel landed
VARCHAR2
6
STATE_LANDED
VARCHAR2
10
No
No
Active
State Landed
VARCHAR2
7
PORT_LANDED
VARCHAR2
30
No
No
Active
Port Landed On Data Entry Form
VARCHAR2
8
VESSEL_ID_VALUE
VARCHAR2
50
No
No
Active
Suggested Vessel Id Value
VARCHAR2
9
VESSEL_NAME_VALUE
VARCHAR2
50
No
No
Active
Suggested New Vessel Name Value
VARCHAR2
10
PORT_LANDED_VALUE
VARCHAR2
50
No
No
Active
Suggested New Port Landed Value
VARCHAR2
11
COLUMN_NAME
VARCHAR2
50
No
No
Active
Column That has the validation error. (Usually this will be a port name that there is no assigned port/county code or a case where a vessel name is supplied with no vessel id.
VARCHAR2
12
USERID
VARCHAR2
20
No
No
Active
Oracle ID of the runner of the validation program
VARCHAR2
5425
View: PDC_SE_PNBR_SINGLE_V
PDC_SE_PNBR_SINGLE_V
Published / External
Completed
View Of those who hold Permits from SE Region
Loaded by batch 1703, 10-15-2007 10:13
Data View
Yes
FLS
View Of those who hold Permits from SE Region
1
PNUMBER
VARCHAR2
4
No
No
Active
Permit Number
VARCHAR2
2
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
3
BPHONE
VARCHAR2
12
No
No
Active
Bisiness Phine Number
VARCHAR2
4
BSTRT
VARCHAR2
30
No
No
Active
Business Stret Address
VARCHAR2
5
BCITY
VARCHAR2
30
No
No
Active
City In Business Address
VARCHAR2
6
BSTATE
VARCHAR2
2
No
No
Active
State Of Business Address
VARCHAR2
7
BZIPCODE
VARCHAR2
10
No
No
Active
Zip Code Of Business Address
VARCHAR2
5426
Table: PDC_SIZE_CODES
PDC_SIZE_CODES
Published / External
Completed
List OF Valid Size Codes From PDC System. In some cases the size code refers to a specific species code and the isize of that species that was brought to market
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
List OF Valid Size Codes From PDC System. In some cases the size code refers to a specific species code and the isize of that species that was brought to market
1
SIZE_CODE
VARCHAR2
2
Yes
Yes
Active
Size Code For PDC System
VARCHAR2
2
NMFS_CODE
VARCHAR2
4
No
No
Active
4 digit NMFS SPecies Code corresponding to the species associated with the size code.
VARCHAR2
3
DESCRIPTION
VARCHAR2
40
No
No
Active
The description of the meaning of the size code
VARCHAR2
5427
Table: PDC_SPC_CATEGORIES
PDC_SPC_CATEGORIES
Published / External
Completed
For HMS Reporting -- This table lists the valid Categories and their descriptions and the group and sub group associated with them
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
For HMS Reporting -- This table lists the valid Categories and their descriptions and the group and sub group associated with them
1
GROUP_NAME
VARCHAR2
5
Yes
Yes
Active
Group Name
VARCHAR2
2
SUB_GROUP
VARCHAR2
3
Yes
Yes
Active
Sub Group Name
VARCHAR2
3
CATEGORY
VARCHAR2
5
Yes
Yes
Active
Category Name
VARCHAR2
4
CATEGORY_DESCR
VARCHAR2
30
Yes
No
Active
Category Descriptions
VARCHAR2
5428
Table: PDC_SPECIES_NMFS_TOP
PDC_SPECIES_NMFS_TOP
Published / External
Completed
Table listing Species Summarized On The Top half of the report to HMS and the permit associated wih them
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table listing Species Summarized On The Top half of the report to HMS and the permit associated wih them
1
SPECIES_CODE_NMFS
VARCHAR2
4
Yes
Yes
Active
NMFS Species Code
VARCHAR2
2
PERMIT_CODE
VARCHAR2
2
Yes
Yes
Active
Permit required to sell the species in question
VARCHAR2
5429
Table: PDC_SPECIES_RANGES
PDC_SPECIES_RANGES
Published / External
Completed
Table used for range checking of reported landings of species. The Group_name , sub_group, and category columns are also used for allow flexible summary and grouping for reports to Headquaters (HMS) on quota monitoring.
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table used for range checking of reported landings of species. The Group_name , sub_group, and category columns are also used for allow flexible summary and grouping for reports to Headquaters (HMS) on quota monitoring.
1
SPECIES_CODE_NMFS
VARCHAR2
4
Yes
Yes
Active
NMFS 4 digit species code
VARCHAR2
2
COMMON_NAME
VARCHAR2
30
No
No
Active
Common Name Associated With The Species Code
VARCHAR2
3
MAXIMUM_TOTAL_WHOLE_WEIGHT
NUMBER
22
No
No
5
0
Active
Maximum Whole Weight Reported To Trigger an error.inquiry
NUMBER
4
GROUP_NAME
VARCHAR2
5
No
No
Active
Which Group To Be Used in Reporting Data to HMS for quota monitoring
VARCHAR2
5
SUB_GROUP
VARCHAR2
3
No
No
Active
Which Sub-Group To Be Used in Reporting Data to HMS for quota monitoring
VARCHAR2
6
CATEGORY
VARCHAR2
5
No
No
Active
Which Category To Be Used in Reporting Data to HMS for quota monitoring
VARCHAR2
5430
Table: PDC_SUB_GROUPS
PDC_SUB_GROUPS
Published / External
Completed
Table Of Valid Sub Groups. This table allows flexibility on delaing with the changing requiemnets of reporting to HMS in headquarters.
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Table Of Valid Sub Groups. This table allows flexibility on delaing with the changing requiemnets of reporting to HMS in headquarters.
1
GROUP_NAME
VARCHAR2
5
Yes
Yes
Active
Group Code
VARCHAR2
2
SUB_GROUP
VARCHAR2
3
Yes
Yes
Active
Sub Group Code
VARCHAR2
3
SUB_GROUP_DESCR
VARCHAR2
30
Yes
No
Active
Sub Group Description
VARCHAR2
5431
Table: PDC_VESSELS
PDC_VESSELS
Published / External
Completed
This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER.
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER.
1
PDC_HEADER_KEY
NUMBER
22
Yes
No
10
0
Active
Key to Header Table
NUMBER
2
PDC_VESSEL_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary key of the table..
NUMBER
3
PC_ARTIFICIAL_KEY
NUMBER
22
No
No
10
0
Active
historical key use when this was a PC based system
NUMBER
4
VESSELID
VARCHAR2
10
No
No
Active
The corrected vessl information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
VARCHAR2
5
VESSELNAME
VARCHAR2
30
No
No
Active
The vessel name
VARCHAR2
6
DATE_LANDED
DATE
7
No
No
Active
Dta vessel landed
DATE
7
LANDING_PORT
VARCHAR2
30
No
No
Active
Landing port of the vessel
VARCHAR2
8
ALPHA_STATE_LANDED
VARCHAR2
2
No
No
Active
2 character alphabetic code of state landed.
VARCHAR2
9
REP_VESSELID
VARCHAR2
10
No
No
Active
The vessel information reported on the form
VARCHAR2
10
TIF_NUMBER
VARCHAR2
12
No
No
Active
The scan images provided by the vendor
VARCHAR2
Data Steward
1992
2016
Person
Baertlein, Heather
heather.baertlein@noaa.gov
(608) 713-1793
Distributor
1992
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Metadata Contact
1992
2016
Person
Baertlein, Heather
heather.baertlein@noaa.gov
(608) 713-1793
Point of Contact
1992
Person
Judge, Michael
Michael.Judge@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4235
305-361-4562
Contact by email preferred.
Ground Condition
-100
-40
30
0
Gulf Of Mexico And South Atlantic Ocean
Range
1992
2012
Sensitive
Read and sign for NOAA Administrative Order 216 100 Read and sign System Access Application (see URLs) Contact DBA Daniel Leon at daniel.leon noaa.gov for userid password.
Waiver needed
Range checks and validation against historical distributions.
Yes
70
Yes
Yes
No
60
Confidentiality. This data is currently wavered under the current NOAA guidelines for relational databases.
To Be Determined
0
The data resides on a secure database server only accessible through the NMFS network requiring separate multi-factor authentication for both network and database access.
1
Forms submitted by seafood dealers to SEFSC staff through paper logbooks. Data entry is done by an offsite contractor. SEFSC staff Q/C data into database housed in Miami.
5403
Entity
Table: DPS_DEALER_PERMIT
5404
Entity
Table: FLS_INT_VALIDATION_ERRORS
5405
Entity
Table: PDC_HEADERS
5406
Entity
Table: PDC_INT_ACCESS_HEADERS
5407
Entity
Table: PDC_INT_ACCESS_PURCHASES
5408
Entity
Table: PDC_INT_ACCESS_VESSELS
5409
Entity
Table: PDC_INT_MOST_ACTIVE_DLRS
5410
Entity
Table: PDC_INT_REPORTING_LABELS
5411
Entity
Table: PDC_INT_SCANNED_HEADERS
5412
Entity
Table: PDC_INT_SCANNED_PURCHASES
5413
Entity
Table: PDC_INT_SCANNED_VESSELS
5414
Entity
Table: PDC_INT_SCHEDULES
5415
Entity
Table: PDC_INT_SCHED_GAPS
5416
Entity
Table: PDC_INT_SHARK_LANDINGS
5417
Entity
Table: PDC_LOGBOOKS_MAILING_CONTROLS
5418
Entity
Table: PDC_NEW_PERMITS
5419
Entity
Table: PDC_NEW_PERMITS_HISTORY
5420
Entity
Table: PDC_NEW_PERMITS_SUBSET
5422
Entity
Table: PDC_PNUMBER_XREF
5423
Entity
Table: PDC_PURCHASES
5426
Entity
Table: PDC_SIZE_CODES
5427
Entity
Table: PDC_SPC_CATEGORIES
5428
Entity
Table: PDC_SPECIES_NMFS_TOP
5429
Entity
Table: PDC_SPECIES_RANGES
5430
Entity
Table: PDC_SUB_GROUPS
5431
Entity
Table: PDC_VESSELS
5421
Entity
View: PDC_NE_PNBR_SINGLE_V
5424
Entity
View: PDC_SCANNED_VESSELS_ERRORS_V
5425
Entity
View: PDC_SE_PNBR_SINGLE_V
gov.noaa.nmfs.inport:5402
Lee Weinberger
2007-10-15T10:05:37
SysAdmin InPortAdmin
2022-08-09T17:11:01
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