Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > Terracing at Pierce Marsh in Galveston Bay 2001... >

samples_column_descriptions.csv

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:54679  |  Updated: August 9, 2022  |  Published / External 
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