Table: CTS_SAMPLES
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7080 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Data Table describing sampling done
DescriptionData Table describing sampling done
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SAMPLE_ID
NUMBER |
Code for agency collecting the sample data. |
SAMPLE_TYPE
VARCHAR2 |
Code to indicate type of sample done |
AMOUNT_SAMPLED
NUMBER |
Measurement of the quantity of what was sampled. |
SAMPLE_UNITS
VARCHAR2 |
Units Of Sampling Meausrements |
SAMPLE_DESCRIPTION
VARCHAR2 |
Description Of Sampling Methodology |
EDITCYC
NUMBER |
A control field, (0) indicates an add, (1) indicates an update. Once update, records are stored with a value of 0 in this field. |
EDITDAT
DATE |
The date the record was initially entered, or last updated, whichever is later. |
DELEDAT
DATE |
A control field used to delete existing records from this table. No records are stored with a value in this 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: CTS_SAMPLES |
---|---|
Short Name: | CTS_SAMPLES |
Status: | Completed |
Abstract: |
Data Table describing sampling done |
Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CTSPAT |
Description: |
Data Table describing sampling done |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
SAMPLE_ID | NUMBER | Code for agency collecting the sample data. |
100
|
![]() |
SAMPLE_TYPE | VARCHAR2 | Code to indicate type of sample done |
100
|
AMOUNT_SAMPLED | NUMBER | Measurement of the quantity of what was sampled. | |
100
|
SAMPLE_UNITS | VARCHAR2 | Units Of Sampling Meausrements | |
100
|
SAMPLE_DESCRIPTION | VARCHAR2 | Description Of Sampling Methodology | |
100
|
EDITCYC | NUMBER | A control field, (0) indicates an add, (1) indicates an update. Once update, records are stored with a value of 0 in this field. | |
100
|
EDITDAT | DATE | The date the record was initially entered, or last updated, whichever is later. | |
100
|
DELEDAT | DATE | A control field used to delete existing records from this table. No records are stored with a value in this field. |
Attribute Details
SAMPLE_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Code for agency collecting the sample data. |
General Data Type: | NUMBER |
SAMPLE_TYPE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Code to indicate type of sample done |
General Data Type: | VARCHAR2 |
AMOUNT_SAMPLED
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Measurement of the quantity of what was sampled. |
General Data Type: | NUMBER |
SAMPLE_UNITS
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units Of Sampling Meausrements |
General Data Type: | VARCHAR2 |
SAMPLE_DESCRIPTION
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description Of Sampling Methodology |
General Data Type: | VARCHAR2 |
EDITCYC
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
A control field, (0) indicates an add, (1) indicates an update. Once update, records are stored with a value of 0 in this field. |
General Data Type: | NUMBER |
EDITDAT
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the record was initially entered, or last updated, whichever is later. |
General Data Type: | DATE |
DELEDAT
Seq. Order: | 8 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A control field used to delete existing records from this table. No records are stored with a value in this field. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 7080 |
---|---|
GUID: | gov.noaa.nmfs.inport:7080 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2008-02-22 12:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-05 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-05 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-05 |