Table: PDC_INT_ACCESS_VESSELS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5408 | Updated: August 9, 2022 | Published / External
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
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
|
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
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
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
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
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
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
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
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
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
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
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
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
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 |