Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table That records distribution of various economic costs

Notes:

Loaded by batch 2043, 12-20-2007 08:10

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

Table That records distribution of various economic costs

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key CLUSTER_ID NUMBER Foreign key to EDC_CLUSTER
100
Primary Key DISTRIBUTION_NUMBER NUMBER Sequential Key
100
FLOOR_COST NUMBER Lowest COst For element
100
CEILING_COST NUMBER Highest Cost for element
100
PERCENTAGE NUMBER percentage of records with value for element
100
REC_COUNT NUMBER Number of records with values for element

Attribute Details

CLUSTER_ID

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

Foreign key to EDC_CLUSTER

General Data Type: NUMBER

DISTRIBUTION_NUMBER

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

Sequential Key

General Data Type: NUMBER

FLOOR_COST

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

Lowest COst For element

General Data Type: NUMBER

CEILING_COST

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

Highest Cost for element

General Data Type: NUMBER

PERCENTAGE

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

percentage of records with value for element

General Data Type: NUMBER

REC_COUNT

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

Number of records with values for element

General Data Type: NUMBER

Catalog Details

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