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_ACCESS_HEADERS

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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 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	SE Permit Number
NE_DEALER VARCHAR2	NE Dealer Code
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
STATE VARCHAR2	State Name
FISH_PURCHASE VARCHAR2	Were fish purchases
FISH_IMPORTED VARCHAR2	Indicates whether or not the data reported included imports in addition to domestic purchases.
DEALER_PHONE VARCHAR2	Phone nUmber of Dealer
FORM_ID VARCHAR2	Which Version Of The Form was scanned
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	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.
OP_NAME VARCHAR2	A Vendor Supplied field
OP_VALUE VARCHAR2	A Vendor Supplied field
OP_DATE VARCHAR2	A Vendor Supplied field
RECEIVED_DATE VARCHAR2	Date Logbook Form was received.
POSTMARK_DATE VARCHAR2	Date in which envelope containing the logbook form was post marked.

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

SE Permit Number

NE_DEALER
VARCHAR2

NE Dealer Code

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

STATE
VARCHAR2

State Name

FISH_PURCHASE
VARCHAR2

Were fish purchases

FISH_IMPORTED
VARCHAR2

Indicates whether or not the data reported included imports in addition to domestic purchases.

DEALER_PHONE
VARCHAR2

Phone nUmber of Dealer

FORM_ID
VARCHAR2

Which Version Of The Form was scanned

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

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.

OP_NAME
VARCHAR2

A Vendor Supplied field

OP_VALUE
VARCHAR2

A Vendor Supplied field

OP_DATE
VARCHAR2

A Vendor Supplied field

RECEIVED_DATE
VARCHAR2

Date Logbook Form was received.

POSTMARK_DATE
VARCHAR2

Date in which envelope containing the 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_ACCESS_HEADERS
Short Name:	PDC_INT_ACCESS_HEADERS
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 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

Attribute Summary

	Name	Type	Description
100	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	SE Permit Number
100	NE_DEALER	VARCHAR2	NE Dealer Code
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	STATE	VARCHAR2	State Name
100	FISH_PURCHASE	VARCHAR2	Were fish purchases
100	FISH_IMPORTED	VARCHAR2	Indicates whether or not the data reported included imports in addition to domestic purchases.
100	DEALER_PHONE	VARCHAR2	Phone nUmber of Dealer
100	FORM_ID	VARCHAR2	Which Version Of The Form was scanned
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	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.
100	OP_NAME	VARCHAR2	A Vendor Supplied field
100	OP_VALUE	VARCHAR2	A Vendor Supplied field
100	OP_DATE	VARCHAR2	A Vendor Supplied field
100	RECEIVED_DATE	VARCHAR2	Date Logbook Form was received.
100	POSTMARK_DATE	VARCHAR2	Date in which envelope containing the logbook form was post marked.

Name

Type

Description

100

ID_NO

VARCHAR2

ID NUmber On The form

100

TIF_NO

VARCHAR2

TIF Number

100

SCHEDULE

VARCHAR2

100

SE_DEALER

VARCHAR2

SE Permit Number

100

NE_DEALER

VARCHAR2

NE Dealer Code

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

STATE

VARCHAR2

State Name

100

FISH_PURCHASE

VARCHAR2

Were fish purchases

100

FISH_IMPORTED

VARCHAR2

Indicates whether or not the data reported included imports in addition to domestic purchases.

100

DEALER_PHONE

VARCHAR2

Phone nUmber of Dealer

100

FORM_ID

VARCHAR2

Which Version Of The Form was scanned

100

BATCH_NUMBER

VARCHAR2

100

WEIGH_OUT

VARCHAR2

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.

100

OP_NAME

VARCHAR2

A Vendor Supplied field

100

OP_VALUE

VARCHAR2

A Vendor Supplied field

100

OP_DATE

VARCHAR2

A Vendor Supplied field

100

RECEIVED_DATE

VARCHAR2

Date Logbook Form was received.

100

POSTMARK_DATE

VARCHAR2

Date in which envelope containing the logbook form was post marked.

Attribute Details

ID_NO

CC ID: 16847

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: 16846

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	TIF Number
General Data Type:	VARCHAR2

SCHEDULE

CC ID: 16845

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	Yes
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: 16844

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	SE Permit Number
General Data Type:	VARCHAR2

NE_DEALER

CC ID: 16843

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NE Dealer Code
General Data Type:	VARCHAR2

BEGIN_DATE

CC ID: 16842

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: 16841

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: 16840

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

STATE

CC ID: 16839

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

FISH_PURCHASE

CC ID: 16838

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were fish purchases
General Data Type:	VARCHAR2

FISH_IMPORTED

CC ID: 16837

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether or not the data reported included imports in addition to domestic purchases.
General Data Type:	VARCHAR2

DEALER_PHONE

CC ID: 16836

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Phone nUmber of Dealer
General Data Type:	VARCHAR2

FORM_ID

CC ID: 16835

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Which Version Of The Form was scanned
General Data Type:	VARCHAR2

BATCH_NUMBER

CC ID: 16834

Seq. Order:	14
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: 16833

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

OP_NAME

CC ID: 16832

Seq. Order:	16
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: 16831

Seq. Order:	17
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: 16830

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	A Vendor Supplied field
General Data Type:	VARCHAR2

RECEIVED_DATE

CC ID: 16829

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Date Logbook Form was received.
General Data Type:	VARCHAR2

POSTMARK_DATE

CC ID: 16828

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Date in which envelope containing the logbook form was post marked.
General Data Type:	VARCHAR2

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ID_NO

TIF_NO

SCHEDULE

SE_DEALER

NE_DEALER

BEGIN_DATE

END_DATE

COUNTY_NAME

STATE

FISH_PURCHASE

FISH_IMPORTED

DEALER_PHONE

FORM_ID

BATCH_NUMBER

WEIGH_OUT

OP_NAME

OP_VALUE

OP_DATE

RECEIVED_DATE

POSTMARK_DATE

Catalog Details