Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Data Table to describe sampling location and methodology

Notes:

Loaded by batch 2004, 12-03-2007 09:39

Entity Information

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

Data Table to describe sampling location and methodology

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Unique id for the sample record
100
INTERVIEW_ID NUMBER Unique key for the interview record
100
IS_RANDOM NUMBER Was the sampling done on a random basis
100
IS_FULL_CATCH NUMBER Were all of the catch for that species included in 1 or more samples or subsamples
100
CREATED_BY_USER_ID VARCHAR2 Control field identifying record creator
100
CREATED_DATE DATE Date/Time stamp of record creation
100
SPECIES_CODE VARCHAR2 The species identified by the sampler. It may or may not match landing species
100
TOTAL_WEIGHT NUMBER Total weight of the animals in that sample
100
SAMPLE_COUNT NUMBER The number of individuals in the sample
100
SAMPLE_FORM VARCHAR2 HISTORICAL DATA FROM TIP31
100
SAMPLE_METHOD_TYPE_ID NUMBER Key to SAMPLE_METHOD_TYPE (LANDED SORTED, LANDED UNSORTED, etc)
100
WEIGHT_UNIT_ID NUMBER Key to weight unit (KILOGRAM, POUNDS, etc) for the total weight
100
SAMPLE_COMMENT VARCHAR2 Comment for this sample record.
100
SPECIES_SIZE_ID NUMBER Size group for the sampled individuals (MIXED/UNSIZED, JUMBO, etc)
100
CONDITION_TYPE_ID NUMBER Key to Condition_Type (ROUND(WHOLE), HEADS_OFF, etc)
100
GRADE_ID NUMBER Key to grade (NO_GRADE, #1 IF TUNA, etc)
100
SUB_SAMPLE_COUNT NUMBER Number of individuals in the subsample
100
SUB_SAMPLE_WEIGHT_UNIT_ID NUMBER key to weight_unit (KILOGRAMS, POUNDS, etc) for the subsample_total_weight
100
SUB_SAMPLE_TOTAL_WEIGHT NUMBER Weight of subsample
100
SUB_SAMPLE_COND_TYPE_ID NUMBER Key to condition of the subsample (ROUND(WHOE), HEAD OFF,etc)
100
SUB_SAMPLE_IS_RANDOM NUMBER Was the subsample randomly selected
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
MARKET_SPECIES_ID VARCHAR2 Key to agency specific species code
100
SPECIES_QUANTITY NUMBER not used
100
LANDING_ID NUMBER Key to the related landing record
100
REPLICATE NUMBER Key to the landing record in the historical data
100
SAMPLE_NUMBER NUMBER Key to sample in the historical data
100
STANDARD_SPECIES_ID VARCHAR2 Species code converted to the standard species code

Attribute Details

ID

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

Unique id for the sample record

General Data Type: NUMBER

INTERVIEW_ID

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

Unique key for the interview record

General Data Type: NUMBER

IS_RANDOM

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

Was the sampling done on a random basis

General Data Type: NUMBER

IS_FULL_CATCH

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

Were all of the catch for that species included in 1 or more samples or subsamples

General Data Type: NUMBER

CREATED_BY_USER_ID

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

Control field identifying record creator

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 22283
Seq. Order: 6
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_CODE

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

The species identified by the sampler. It may or may not match landing species

General Data Type: VARCHAR2

TOTAL_WEIGHT

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

Total weight of the animals in that sample

General Data Type: NUMBER

SAMPLE_COUNT

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

The number of individuals in the sample

General Data Type: NUMBER

SAMPLE_FORM

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

HISTORICAL DATA FROM TIP31

General Data Type: VARCHAR2

SAMPLE_METHOD_TYPE_ID

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

Key to SAMPLE_METHOD_TYPE (LANDED SORTED, LANDED UNSORTED, etc)

General Data Type: NUMBER

WEIGHT_UNIT_ID

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

Key to weight unit (KILOGRAM, POUNDS, etc) for the total weight

General Data Type: NUMBER

SAMPLE_COMMENT

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

Comment for this sample record.

General Data Type: VARCHAR2

SPECIES_SIZE_ID

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

Size group for the sampled individuals (MIXED/UNSIZED, JUMBO, etc)

General Data Type: NUMBER

CONDITION_TYPE_ID

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

Key to Condition_Type (ROUND(WHOLE), HEADS_OFF, etc)

General Data Type: NUMBER

GRADE_ID

CC ID: 22293
Seq. Order: 16
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

SUB_SAMPLE_COUNT

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

Number of individuals in the subsample

General Data Type: NUMBER

SUB_SAMPLE_WEIGHT_UNIT_ID

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

key to weight_unit (KILOGRAMS, POUNDS, etc) for the subsample_total_weight

General Data Type: NUMBER

SUB_SAMPLE_TOTAL_WEIGHT

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

Weight of subsample

General Data Type: NUMBER

SUB_SAMPLE_COND_TYPE_ID

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

Key to condition of the subsample (ROUND(WHOE), HEAD OFF,etc)

General Data Type: NUMBER

SUB_SAMPLE_IS_RANDOM

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

Was the subsample randomly selected

General Data Type: NUMBER

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 22300
Seq. Order: 23
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

MARKET_SPECIES_ID

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

Key to agency specific species code

General Data Type: VARCHAR2

SPECIES_QUANTITY

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

not used

General Data Type: NUMBER

LANDING_ID

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

Key to the related landing record

General Data Type: NUMBER

REPLICATE

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

Key to the landing record in the historical data

General Data Type: NUMBER

SAMPLE_NUMBER

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

Key to sample in the historical data

General Data Type: NUMBER

STANDARD_SPECIES_ID

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

Species code converted to the standard species code

General Data Type: VARCHAR2

Related Items

Item Type Relationship Type Title
Entity (ENT) Cross Reference Table: CONDITION_TYPE
Entity (ENT) Cross Reference Table: SPECIES_SIZE
Entity (ENT) Cross Reference Table: WEIGHT_UNIT

Catalog Details

Catalog Item ID: 6570
GUID: gov.noaa.nmfs.inport:6570
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 09:39+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