Slide Menu
Search Help Show/Hide Menu

Item Identification

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 Information

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

Pre-validation table that holds header data

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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
Primary Key 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

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 Details

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07