Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Pre-validation table that holds purchase 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 purchase 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_NO VARCHAR2 This contains the scanned images provided by the vendor. It currently does not have a place in our master tables
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 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
SE_PERMIT_NUMBER 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
NE_PERMIT_NUMBER 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
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
NMFS_SPECIES VARCHAR2 4 digit NMFS Species Code
100
SIZE_CODE VARCHAR2 A code to indicate the size/market category of the fish sold.Sizecodes have not been used previous to 2001. Changes to the sizecode table need to be made.
100
DRESSED_WEIGHT NUMBER The total pounds that were purchased during the reporting period in dressed weight.
100
PRICE_PER_POUND NUMBER This is the average price that the dealer paid for the respective species during the reporting period.
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 every year to each permit holder, we may get information written on logbooks printed as early as 1992.When this batch of records are sent to the contractor that enters them, since there records are entered using an electronic scanner, the logbooks must be culled by year so that the scanner can correctly interpret the image it is reading. Hence, for each year, we have a separate file.All of the files that form part of a batch are loaded together so that the schedule numbers can be checked. If any are missing or out of bounds, an error is reported during validation. Validation:None.
100
OP_NAME VARCHAR2 A Vendor Supplied field
100
OP_VALUE VARCHAR2 A Vendor Supplied field
100
OP_DATE DATE A Vendor Supplied field
100
SOURCE_FILE VARCHAR2 A Vendor Supplied field

Attribute Details

ID_NUMBER

CC ID: 16928
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_NO

CC ID: 16927
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: 16926
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 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

SE_PERMIT_NUMBER

CC ID: 16925
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 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

NE_PERMIT_NUMBER

CC ID: 16924
Seq. Order: 5
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

END_DATE

CC ID: 16923
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 ends. This date is often the 15th or the last day of each month.

General Data Type: VARCHAR2

NMFS_SPECIES

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

4 digit NMFS Species Code

General Data Type: VARCHAR2

SIZE_CODE

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

A code to indicate the size/market category of the fish sold.Sizecodes have not been used previous to 2001. Changes to the sizecode table need to be made.

General Data Type: VARCHAR2

DRESSED_WEIGHT

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

The total pounds that were purchased during the reporting period in dressed weight.

General Data Type: NUMBER

PRICE_PER_POUND

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

This is the average price that the dealer paid for the respective species during the reporting period.

General Data Type: NUMBER

BATCH_NUMBER

CC ID: 16918
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 every year to each permit holder, we may get information written on logbooks printed as early as 1992.When this batch of records are sent to the contractor that enters them, since there records are entered using an electronic scanner, the logbooks must be culled by year so that the scanner can correctly interpret the image it is reading. Hence, for each year, we have a separate file.All of the files that form part of a batch are loaded together so that the schedule numbers can be checked. If any are missing or out of bounds, an error is reported during validation. Validation:None.

General Data Type: VARCHAR2

OP_NAME

CC ID: 16917
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: 16916
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: 16915
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

SOURCE_FILE

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

A Vendor Supplied field

General Data Type: VARCHAR2

Catalog Details

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