Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dealer Reporting > Pelagic Dealer Compliance > Pelagic Dealer Commercial Landings Monitoring (... >

Table: PDC_INT_ACCESS_PURCHASES

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5407  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Processing Table to take the scanned data received from the vendor into oracle via access macro

Description

Processing Table to take the scanned data received from the vendor into oracle via access macro

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID_NO
VARCHAR2 		ID NUmber On The form
TIF_NO
VARCHAR2 		TIF Number
SCHEDULE
VARCHAR2 		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.
SE_DEALER
VARCHAR2 		Permit Number Assigned to Dealer by the SOuth East Regional Office
NE_DEALER
VARCHAR2 		Permit Number Assigned By North East Regional Office
END_DATE
VARCHAR2 		Ending Date of The Time/Reporting Period In question
NMF_SPECIES
VARCHAR2 		NMFS Species Code
SIZE_CODE
VARCHAR2 		Size Code
DRESSED_WEIGHT
NUMBER 		Dressed Weight
PRICE_PER_POUND
NUMBER 		Price Per Pound
BATCH_NUMBER
VARCHAR2 		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
OP_NAME
VARCHAR2 		A Vendor Supplied field
OP_VALUE
VARCHAR2 		A Vendor Supplied field
OP_DATE
DATE 		A Vendor Supplied field

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: Table: PDC_INT_ACCESS_PURCHASES
Short Name: PDC_INT_ACCESS_PURCHASES
Status: Completed
Abstract:

Processing Table to take the scanned data received from the vendor into oracle via access macro
Notes:

Loaded by batch 1703, 10-15-2007 10:13

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Processing Table to take the scanned data received from the vendor into oracle via access macro

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID_NO VARCHAR2 ID NUmber On The form
100
 TIF_NO VARCHAR2 TIF Number
100
 SCHEDULE VARCHAR2 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.
100
 SE_DEALER VARCHAR2 Permit Number Assigned to Dealer by the SOuth East Regional Office
100
 NE_DEALER VARCHAR2 Permit Number Assigned By North East Regional Office
100
 END_DATE VARCHAR2 Ending Date of The Time/Reporting Period In question
100
 NMF_SPECIES VARCHAR2 NMFS Species Code
100
 SIZE_CODE VARCHAR2 Size Code
100
 DRESSED_WEIGHT NUMBER Dressed Weight
100
 PRICE_PER_POUND NUMBER Price Per Pound
100
 BATCH_NUMBER VARCHAR2 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
100
 OP_NAME VARCHAR2 A Vendor Supplied field
100
 OP_VALUE VARCHAR2 A Vendor Supplied field
100
 OP_DATE DATE A Vendor Supplied field

Attribute Details

ID_NO

CC ID: 16861
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: Yes
Status: Active
Description:

ID NUmber On The form
General Data Type: VARCHAR2

TIF_NO

CC ID: 16860
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

TIF Number
General Data Type: VARCHAR2

SCHEDULE

CC ID: 16859
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

SE_DEALER

CC ID: 16858
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Permit Number Assigned to Dealer by the SOuth East Regional Office
General Data Type: VARCHAR2

NE_DEALER

CC ID: 16857
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Permit Number Assigned By North East Regional Office
General Data Type: VARCHAR2

END_DATE

CC ID: 16856
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Ending Date of The Time/Reporting Period In question
General Data Type: VARCHAR2

NMF_SPECIES

CC ID: 16855
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

NMFS Species Code
General Data Type: VARCHAR2

SIZE_CODE

CC ID: 16854
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Size Code
General Data Type: VARCHAR2

DRESSED_WEIGHT

CC ID: 16853
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Dressed Weight
General Data Type: NUMBER

PRICE_PER_POUND

CC ID: 16852
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Price Per Pound
General Data Type: NUMBER

BATCH_NUMBER

CC ID: 16851
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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
General Data Type: VARCHAR2

OP_NAME

CC ID: 16850
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

A Vendor Supplied field
General Data Type: VARCHAR2

OP_VALUE

CC ID: 16849
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

A Vendor Supplied field
General Data Type: VARCHAR2

OP_DATE

CC ID: 16848
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

A Vendor Supplied field
General Data Type: DATE

Catalog Details

Catalog Item ID: 5407
GUID: gov.noaa.nmfs.inport:5407
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-15 10:13+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06