Metadata Rubric

100%

6 / 6

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_SCANNED_HEADERS

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5411 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Pre-validation table that holds header data

Description

Pre-validation table that holds header data

Entity Type
Data Table

Data Attribute / Type	Description
ID_NUMBER VARCHAR2	Sequential Number Assigned By Vendor Software During Data Entry
TIF_NUMBER VARCHAR2	This contains the scanned images provided by the vendor. It currently does not have a place in our master tables
SCHEDULE VARCHAR2	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.
NE_PNUMBER VARCHAR2	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.
SE_PNUMBER VARCHAR2	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.
BEGIN_DATE VARCHAR2	This is the date that the reporting period begins. This date is often the first or the 16th of each month.
END_DATE VARCHAR2	This is the date that the reporting period ends. This date is often the 15th or the last day of each month.
COUNTY_NAME VARCHAR2	County Name
DEALER_PHONE VARCHAR2	Phone Number Of Dealer
STATE_ABBREVIATION VARCHAR2	State Abbreviation
NMFS_STATE_CODE VARCHAR2	NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.
NMFS_COUNTY_CODE VARCHAR2	NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.
FORM_ID VARCHAR2	Logbook form version date is shown in this column
PURCHASE_FISH VARCHAR2	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.
FISH_IMPORTED VARCHAR2	This is a yes/no field. If the dealer did not import any fish during the 2 week period, the no is checked.
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 iss
WEIGH_OUT VARCHAR2	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.
OP_NAME VARCHAR2	Vendor SUpplied Column
OP_VALUE VARCHAR2	Vendor Supplied Column
OP_DATE VARCHAR2	Vendor Supplied Column
SOURCE_FILE VARCHAR2	Name Of source file loaded that populates this table
RECEIVED_DATE VARCHAR2	Date Logbook form was recieved
POSTMARK_DATE VARCHAR2	Date Logbook form was post marked

Data Attribute / Type

Description

ID_NUMBER
VARCHAR2

Sequential Number Assigned By Vendor Software During Data Entry

TIF_NUMBER
VARCHAR2

This contains the scanned images provided by the vendor. It currently does not have a place in our master tables

SCHEDULE
VARCHAR2

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.

NE_PNUMBER
VARCHAR2

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.

SE_PNUMBER
VARCHAR2

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.

BEGIN_DATE
VARCHAR2

This is the date that the reporting period begins. This date is often the first or the 16th of each month.

END_DATE
VARCHAR2

This is the date that the reporting period ends. This date is often the 15th or the last day of each month.

COUNTY_NAME
VARCHAR2

County Name

DEALER_PHONE
VARCHAR2

Phone Number Of Dealer

STATE_ABBREVIATION
VARCHAR2

State Abbreviation

NMFS_STATE_CODE
VARCHAR2

NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.

NMFS_COUNTY_CODE
VARCHAR2

NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.

FORM_ID
VARCHAR2

Logbook form version date is shown in this column

PURCHASE_FISH
VARCHAR2

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.

FISH_IMPORTED
VARCHAR2

This is a yes/no field. If the dealer did not import any fish during the 2 week period, the no is checked.

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 iss

WEIGH_OUT
VARCHAR2

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.

OP_NAME
VARCHAR2

Vendor SUpplied Column

OP_VALUE
VARCHAR2

Vendor Supplied Column

OP_DATE
VARCHAR2

Vendor Supplied Column

SOURCE_FILE
VARCHAR2

Name Of source file loaded that populates this table

RECEIVED_DATE
VARCHAR2

Date Logbook form was recieved

POSTMARK_DATE
VARCHAR2

Date Logbook form was post marked

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: PDC_INT_SCANNED_HEADERS
Short Name:	PDC_INT_SCANNED_HEADERS
Status:	Completed
Abstract:	Pre-validation table that holds header data
Notes:	Loaded by batch 1703, 10-15-2007 10:13

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	FLS
Description:	Pre-validation table that holds header data

Attribute Summary

	Name	Type	Description
100	ID_NUMBER	VARCHAR2	Sequential Number Assigned By Vendor Software During Data Entry
100	TIF_NUMBER	VARCHAR2	This contains the scanned images provided by the vendor. It currently does not have a place in our master tables
100	SCHEDULE	VARCHAR2	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.
100	NE_PNUMBER	VARCHAR2	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.
100	SE_PNUMBER	VARCHAR2	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.
100	BEGIN_DATE	VARCHAR2	This is the date that the reporting period begins. This date is often the first or the 16th of each month.
100	END_DATE	VARCHAR2	This is the date that the reporting period ends. This date is often the 15th or the last day of each month.
100	COUNTY_NAME	VARCHAR2	County Name
100	DEALER_PHONE	VARCHAR2	Phone Number Of Dealer
100	STATE_ABBREVIATION	VARCHAR2	State Abbreviation
100	NMFS_STATE_CODE	VARCHAR2	NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.
100	NMFS_COUNTY_CODE	VARCHAR2	NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.
100	FORM_ID	VARCHAR2	Logbook form version date is shown in this column
100	PURCHASE_FISH	VARCHAR2	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.
100	FISH_IMPORTED	VARCHAR2	This is a yes/no field. If the dealer did not import any fish during the 2 week period, the no is checked.
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 iss
100	WEIGH_OUT	VARCHAR2	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.
100	OP_NAME	VARCHAR2	Vendor SUpplied Column
100	OP_VALUE	VARCHAR2	Vendor Supplied Column
100	OP_DATE	VARCHAR2	Vendor Supplied Column
100	SOURCE_FILE	VARCHAR2	Name Of source file loaded that populates this table
100	RECEIVED_DATE	VARCHAR2	Date Logbook form was recieved
100	POSTMARK_DATE	VARCHAR2	Date Logbook form was post marked

Name

Type

Description

100

ID_NUMBER

VARCHAR2

Sequential Number Assigned By Vendor Software During Data Entry

100

TIF_NUMBER

VARCHAR2

This contains the scanned images provided by the vendor. It currently does not have a place in our master tables

100

SCHEDULE

VARCHAR2

100

NE_PNUMBER

VARCHAR2

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.

100

SE_PNUMBER

VARCHAR2

100

BEGIN_DATE

VARCHAR2

This is the date that the reporting period begins. This date is often the first or the 16th of each month.

100

END_DATE

VARCHAR2

This is the date that the reporting period ends. This date is often the 15th or the last day of each month.

100

COUNTY_NAME

VARCHAR2

County Name

100

DEALER_PHONE

VARCHAR2

Phone Number Of Dealer

100

STATE_ABBREVIATION

VARCHAR2

State Abbreviation

100

NMFS_STATE_CODE

VARCHAR2

NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.

100

NMFS_COUNTY_CODE

VARCHAR2

NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.

100

FORM_ID

VARCHAR2

Logbook form version date is shown in this column

100

PURCHASE_FISH

VARCHAR2

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.

100

FISH_IMPORTED

VARCHAR2

This is a yes/no field. If the dealer did not import any fish during the 2 week period, the no is checked.

100

BATCH_NUMBER

VARCHAR2

100

WEIGH_OUT

VARCHAR2

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.

100

OP_NAME

VARCHAR2

Vendor SUpplied Column

100

OP_VALUE

VARCHAR2

Vendor Supplied Column

100

OP_DATE

VARCHAR2

Vendor Supplied Column

100

SOURCE_FILE

VARCHAR2

Name Of source file loaded that populates this table

100

RECEIVED_DATE

VARCHAR2

Date Logbook form was recieved

100

POSTMARK_DATE

VARCHAR2

Date Logbook form was post marked

Attribute Details

ID_NUMBER

CC ID: 16913

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential Number Assigned By Vendor Software During Data Entry
General Data Type:	VARCHAR2

TIF_NUMBER

CC ID: 16912

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	This contains the scanned images provided by the vendor. It currently does not have a place in our master tables
General Data Type:	VARCHAR2

SCHEDULE

CC ID: 16911

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

NE_PNUMBER

CC ID: 16910

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

SE_PNUMBER

CC ID: 16909

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

BEGIN_DATE

CC ID: 16908

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	This is the date that the reporting period begins. This date is often the first or the 16th of each month.
General Data Type:	VARCHAR2

END_DATE

CC ID: 16907

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	This is the date that the reporting period ends. This date is often the 15th or the last day of each month.
General Data Type:	VARCHAR2

COUNTY_NAME

CC ID: 16906

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	County Name
General Data Type:	VARCHAR2

DEALER_PHONE

CC ID: 16905

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Phone Number Of Dealer
General Data Type:	VARCHAR2

STATE_ABBREVIATION

CC ID: 16904

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	State Abbreviation
General Data Type:	VARCHAR2

NMFS_STATE_CODE

CC ID: 16903

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.
General Data Type:	VARCHAR2

NMFS_COUNTY_CODE

CC ID: 16902

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry.
General Data Type:	VARCHAR2

FORM_ID

CC ID: 16901

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Logbook form version date is shown in this column
General Data Type:	VARCHAR2

PURCHASE_FISH

CC ID: 16900

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

FISH_IMPORTED

CC ID: 16899

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	This is a yes/no field. If the dealer did not import any fish during the 2 week period, the no is checked.
General Data Type:	VARCHAR2

BATCH_NUMBER

CC ID: 16898

Seq. Order:	16
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 iss
General Data Type:	VARCHAR2

WEIGH_OUT

CC ID: 16897

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

OP_NAME

CC ID: 16896

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Vendor SUpplied Column
General Data Type:	VARCHAR2

OP_VALUE

CC ID: 16895

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Vendor Supplied Column
General Data Type:	VARCHAR2

OP_DATE

CC ID: 16894

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Vendor Supplied Column
General Data Type:	VARCHAR2

SOURCE_FILE

CC ID: 16893

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Name Of source file loaded that populates this table
General Data Type:	VARCHAR2

RECEIVED_DATE

CC ID: 16892

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Date Logbook form was recieved
General Data Type:	VARCHAR2

POSTMARK_DATE

CC ID: 16891

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Date Logbook form was post marked
General Data Type:	VARCHAR2

Catalog Item ID:	5411
GUID:	gov.noaa.nmfs.inport:5411
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

Table: PDC_INT_SCANNED_HEADERS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ID_NUMBER

TIF_NUMBER

SCHEDULE

NE_PNUMBER

SE_PNUMBER

BEGIN_DATE

END_DATE

COUNTY_NAME

DEALER_PHONE

STATE_ABBREVIATION

NMFS_STATE_CODE

NMFS_COUNTY_CODE

FORM_ID

PURCHASE_FISH

FISH_IMPORTED

BATCH_NUMBER

WEIGH_OUT

OP_NAME

OP_VALUE

OP_DATE

SOURCE_FILE

RECEIVED_DATE

POSTMARK_DATE

Catalog Details