Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Meta Table which provides column level metadata on the samples table

Description

Meta Table which provides definitions for the columns in the samples data table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
Original Variable Name
Character
The original variable name for which the data is supplied. This is the column name in the original_data.csv file
Revised Variable Name
Character
This is the normalized corrected column for which the data is supplied. to the public.
Data Description
Character
The descriptor/Column definition of the corresponding column
Data Type
Character
Indicates the data type (generally character or numeric ) of the corresponding data column
Data Length
Numeric
The length of the corresponding field in question
Number of Decimal Places
Numeric
Indicates the number of data places (for a numeric column) of the corresponding column in question. This will be blank if the corresponding column in question
Required?
Character
Indicates If it is required that this column be populated in the corresponding data table

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: samples_column_descriptions.csv
Status: Completed
Abstract:

Meta Table which provides column level metadata on the samples table

Purpose:

To define the columns of the data table. Please use this information in conjunction with the descriptors provide for the columns as well as the abbreviations provided with the Galveston table

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Meta Table which provides definitions for the columns in the samples data table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Original Variable Name Character The original variable name for which the data is supplied. This is the column name in the original_data.csv file
100
Revised Variable Name Character This is the normalized corrected column for which the data is supplied. to the public.
100
Data Description Character The descriptor/Column definition of the corresponding column
100
Data Type Character Indicates the data type (generally character or numeric ) of the corresponding data column
100
Data Length Numeric The length of the corresponding field in question
100
Number of Decimal Places Numeric Indicates the number of data places (for a numeric column) of the corresponding column in question. This will be blank if the corresponding column in question
100
Required? Character Indicates If it is required that this column be populated in the corresponding data table

Attribute Details

Original Variable Name

CC ID: 796922
Seq. Order: 20
Data Storage Type: Character
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

The original variable name for which the data is supplied. This is the column name in the original_data.csv file

Revised Variable Name

CC ID: 796924
Seq. Order: 30
Data Storage Type: Character
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

This is the normalized corrected column for which the data is supplied. to the public.

Data Description

CC ID: 796918
Seq. Order: 40
Data Storage Type: Character
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

The descriptor/Column definition of the corresponding column

Data Type

CC ID: 796920
Seq. Order: 50
Data Storage Type: Character
Max Length: 12
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates the data type (generally character or numeric ) of the corresponding data column

Allowed Values: Character Number

Data Length

CC ID: 796919
Seq. Order: 60
Data Storage Type: Numeric
Max Length: 4
Required: Yes
Primary Key: No
Scale: 0
Status: Active
Description:

The length of the corresponding field in question

Number of Decimal Places

CC ID: 796921
Seq. Order: 70
Data Storage Type: Numeric
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Indicates the number of data places (for a numeric column) of the corresponding column in question. This will be blank if the corresponding column in question

Null Value Meaning:

I

Required?

CC ID: 796923
Seq. Order: 100
Data Storage Type: Character
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates If it is required that this column be populated in the corresponding data table

Allowed Values: Yes No

Catalog Details

Catalog Item ID: 54679
GUID: gov.noaa.nmfs.inport:54679
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-11-06 12:17+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-10-21
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-10-21
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-10-21