Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Audit Table For Landings Data Table

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

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

Audit Table For Landings Data Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER Unique ID
100
INTERVIEW_ID NUMBER Unique key
100
SPECIES_SIZE_ID NUMBER Key to size (MIXED/UNSIZED, JUMBO, etc)
100
MARKET_SPECIES_ID VARCHAR2 Key to an agency specific species table
100
SPECIES_QTY NUMBER How many fish of that species were reported
100
GEAR_CODE VARCHAR2 Key to agency specific gear table
100
REGION_ID NUMBER Key to region (GULF, ATLANTIC, etc)
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
SPECIES_CONDITION_ID NUMBER Key to CONDITION_TYPE (ROUND(whole), HEADS ON, etc)
100
ISRIPE NUMBER not used
100
ISBYCATCH NUMBER HISTORICAL DATA
100
GRADE_ID NUMBER Key to Grade (NO GRADE, #1 IF TUNA, etc)
100
MARKET_COUNT_MIN NUMBER Minimun number of individuals per unit for this category
100
MARKET_COUNT_MAX NUMBER Maximun number of individuals per unit for this category
100
TOTAL_VOLUME NUMBER Not used
100
TOTAL_WEIGHT NUMBER Total weight of the catch for that species
100
WEIGHT_UNIT_ID NUMBER Key to Weight_Unit (KILLOGRAMS, POUNDS, etc)
100
VOLUME_UNIT_ID NUMBER Not used
100
ISAGGREGATED NUMBER Not used
100
LANDING_COMMENT VARCHAR2 Comment on this landing record
100
PRICE NUMBER HISTORICAL DATA
100
VALUE NUMBER HISTORICAL DATA
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
AREA_ID NUMBER Key to agency specific area table telling the primary area where fishing occurred
100
REPLICATE NUMBER Part of key to relate the data back to the historical data.
100
STANDARD_GEAR_ID VARCHAR2 The standardized gear for this catch
100
STANDARD_SPECIES_ID VARCHAR2 Key to standard_species
100
STANDARD_AREA_ID NUMBER Key to standard area
100
CHANGE_DATE DATE Date Record Was Changed

Attribute Details

ID

CC ID: 22427
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique ID

General Data Type: NUMBER

INTERVIEW_ID

CC ID: 22428
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique key

General Data Type: NUMBER

SPECIES_SIZE_ID

CC ID: 22429
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Key to size (MIXED/UNSIZED, JUMBO, etc)

General Data Type: NUMBER

MARKET_SPECIES_ID

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

Key to an agency specific species table

General Data Type: VARCHAR2

SPECIES_QTY

CC ID: 22431
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

How many fish of that species were reported

General Data Type: NUMBER

GEAR_CODE

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

Key to agency specific gear table

General Data Type: VARCHAR2

REGION_ID

CC ID: 22433
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to region (GULF, ATLANTIC, etc)

General Data Type: NUMBER

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 22435
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date/Time stamp of record creation

General Data Type: DATE

SPECIES_CONDITION_ID

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

Key to CONDITION_TYPE (ROUND(whole), HEADS ON, etc)

General Data Type: NUMBER

ISRIPE

CC ID: 22437
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

not used

General Data Type: NUMBER

ISBYCATCH

CC ID: 22438
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

HISTORICAL DATA

General Data Type: NUMBER

GRADE_ID

CC ID: 22439
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Grade (NO GRADE, #1 IF TUNA, etc)

General Data Type: NUMBER

MARKET_COUNT_MIN

CC ID: 22440
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Minimun number of individuals per unit for this category

General Data Type: NUMBER

MARKET_COUNT_MAX

CC ID: 22441
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Maximun number of individuals per unit for this category

General Data Type: NUMBER

TOTAL_VOLUME

CC ID: 22442
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Not used

General Data Type: NUMBER

TOTAL_WEIGHT

CC ID: 22443
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total weight of the catch for that species

General Data Type: NUMBER

WEIGHT_UNIT_ID

CC ID: 22444
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Weight_Unit (KILLOGRAMS, POUNDS, etc)

General Data Type: NUMBER

VOLUME_UNIT_ID

CC ID: 22445
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Not used

General Data Type: NUMBER

ISAGGREGATED

CC ID: 22446
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Not used

General Data Type: NUMBER

LANDING_COMMENT

CC ID: 22447
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment on this landing record

General Data Type: VARCHAR2

PRICE

CC ID: 22448
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

HISTORICAL DATA

General Data Type: NUMBER

VALUE

CC ID: 22449
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

HISTORICAL DATA

General Data Type: NUMBER

MODIFIED_DATE

CC ID: 22450
Seq. Order: 24
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date/Time stamp of when record was modifed

General Data Type: DATE

MODIFIED_BY_USER_ID

CC ID: 22451
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

User modifying record

General Data Type: VARCHAR2

AREA_ID

CC ID: 22452
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to agency specific area table telling the primary area where fishing occurred

General Data Type: NUMBER

REPLICATE

CC ID: 22453
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Part of key to relate the data back to the historical data.

General Data Type: NUMBER

STANDARD_GEAR_ID

CC ID: 22454
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

The standardized gear for this catch

General Data Type: VARCHAR2

STANDARD_SPECIES_ID

CC ID: 22455
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Key to standard_species

General Data Type: VARCHAR2

STANDARD_AREA_ID

CC ID: 22456
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to standard area

General Data Type: NUMBER

CHANGE_DATE

CC ID: 22457
Seq. Order: 31
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Record Was Changed

General Data Type: DATE

Catalog Details

Catalog Item ID: 6578
GUID: gov.noaa.nmfs.inport:6578
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:12+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05