Search Help Show/Hide Menu
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
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.

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_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 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 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.

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 Details

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