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.
DATE_LANDED
VARCHAR2
Date Landed
VESSEL_NAME
VARCHAR2
Vessel name
VESSEL_ID
VARCHAR2
Vessel Identification Number
PORT_LANDED
VARCHAR2
Port Landed
STATE_LANDED
VARCHAR2
State Landed
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 some come logbooks in the older format are returned
OP_NAME
VARCHAR2
A Vendor Supplied field
OP_VALUE
VARCHAR2
A Vendor Supplied field
OP_DATE
VARCHAR2
A Vendor Supplied field

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_VESSELS
Short Name: PDC_INT_ACCESS_VESSELS
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
DATE_LANDED VARCHAR2 Date Landed
100
VESSEL_NAME VARCHAR2 Vessel name
100
VESSEL_ID VARCHAR2 Vessel Identification Number
100
PORT_LANDED VARCHAR2 Port Landed
100
STATE_LANDED VARCHAR2 State Landed
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 some come logbooks in the older format are returned
100
OP_NAME VARCHAR2 A Vendor Supplied field
100
OP_VALUE VARCHAR2 A Vendor Supplied field
100
OP_DATE VARCHAR2 A Vendor Supplied field

Attribute Details

ID_NO

CC ID: 16873
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: 16872
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: 16871
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
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

DATE_LANDED

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

Date Landed

General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 16869
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Vessel name

General Data Type: VARCHAR2

VESSEL_ID

CC ID: 16868
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Vessel Identification Number

General Data Type: VARCHAR2

PORT_LANDED

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

Port Landed

General Data Type: VARCHAR2

STATE_LANDED

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

State Landed

General Data Type: VARCHAR2

BATCH_NUMBER

CC ID: 16865
Seq. Order: 9
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 some come logbooks in the older format are returned

General Data Type: VARCHAR2

OP_NAME

CC ID: 16864
Seq. Order: 10
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: 16863
Seq. Order: 11
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: 16862
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A Vendor Supplied field

General Data Type: VARCHAR2

Catalog Details

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