Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

View: EDC_ANNUAL_COSTS_VW

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6848  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Contains identify information about annual cost records

Description

Contains identify information about annual cost records

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ANNUAL_COSTS_ID
NUMBER 		Primary Key
YEAR
NUMBER 		Year
VESSEL_NAME
VARCHAR2 		Vessel Name
VESSEL_ID
VARCHAR2 		Vessel Identifier (either state vessel number or Federal vessel)
SIGNING_PERSON_NAME
VARCHAR2 		Person who signed Economic Survey Form
DATA_ENTRY_DATE
DATE 		Date Data Was Entered
IS_DELETED_FLAG
NUMBER 		Has Record Been Excluded From Use
OWNER_NAME
VARCHAR2 		Owner Of The Vessel
FORM_TYPE_CD
VARCHAR2 		Inducates What Survey form was completed

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: View: EDC_ANNUAL_COSTS_VW
Short Name: EDC_ANNUAL_COSTS_VW
Status: Completed
Abstract:

Contains identify information about annual cost records
Notes:

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

Entity Information

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

Contains identify information about annual cost records

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ANNUAL_COSTS_ID NUMBER Primary Key
100
 YEAR NUMBER Year
100
 VESSEL_NAME VARCHAR2 Vessel Name
100
 VESSEL_ID VARCHAR2 Vessel Identifier (either state vessel number or Federal vessel)
100
 SIGNING_PERSON_NAME VARCHAR2 Person who signed Economic Survey Form
100
 DATA_ENTRY_DATE DATE Date Data Was Entered
100
 IS_DELETED_FLAG NUMBER Has Record Been Excluded From Use
100
 OWNER_NAME VARCHAR2 Owner Of The Vessel
100
 FORM_TYPE_CD VARCHAR2 Inducates What Survey form was completed

Attribute Details

ANNUAL_COSTS_ID

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

Primary Key
General Data Type: NUMBER

YEAR

CC ID: 24446
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Year
General Data Type: NUMBER

VESSEL_NAME

CC ID: 24448
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Vessel Name
General Data Type: VARCHAR2

VESSEL_ID

CC ID: 24444
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Vessel Identifier (either state vessel number or Federal vessel)
General Data Type: VARCHAR2

SIGNING_PERSON_NAME

CC ID: 24447
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Person who signed Economic Survey Form
General Data Type: VARCHAR2

DATA_ENTRY_DATE

CC ID: 24451
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Data Was Entered
General Data Type: DATE

IS_DELETED_FLAG

CC ID: 24443
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Has Record Been Excluded From Use
General Data Type: NUMBER

OWNER_NAME

CC ID: 24445
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Owner Of The Vessel
General Data Type: VARCHAR2

FORM_TYPE_CD

CC ID: 24450
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Inducates What Survey form was completed
General Data Type: VARCHAR2

Catalog Details

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