Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Audit Table for SAMPLE 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 SAMPLE Data table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
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
100
CHANGE_DATE DATE Date/Time stamp of when record was modifed

Attribute Details

ID

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

Unique id for the sample record

General Data Type: NUMBER

INTERVIEW_ID

CC ID: 22505
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: 22506
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: 22507
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: 22508
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: 22509
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: 22510
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: 22511
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: 22512
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: 22513
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: 22514
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: 22515
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: 22516
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: 22517
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: 22518
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: 22519
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: 22520
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: 22521
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: 22522
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: 22523
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: 22524
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: 22525
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: 22526
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: 22527
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: 22528
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: 22529
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: 22530
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: 22531
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: 22532
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

CHANGE_DATE

CC ID: 22533
Seq. Order: 30
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

Catalog Details

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