Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: TblCrewSec1Sub6
Short Name: TblCrewSec1Sub6
Status: Completed
Abstract:

Table holding the information from the Crew Survey Section 1 (Household and Communities) Question 6 - List of all persons who live in household

Entity Information

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

Table holding the information from the Crew Survey Section 1 (Household and Communities) Question 6 - List of all persons who live in household

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
cSec16ID Number Autonumber key
100
CrewID Number Crew Identifier
100
LastName Text Crew Last Name
100
FirstName Text Crew First Name
100
Vessel1Permit# Text Vessels Multispecies Groundfish Permit Number
100
CSec16Relation1 Text 6. Person 1 Relation to crew member
100
CSec16Gender1 Text 6. Person 1 Gender
100
CSec16Age1 Text 6. Person 1 Age
100
CSec16FishingWork1 Number 6. Person 1 Involved in fishing work
100
CSec16FishingWorkType1 Text 6. Person 1 Type of fishing-related work
100
CSec16Occupation1 Text 6. Person 1 Other Occupation (or retiree, student, unemployed, etc.)
100
CSec16Relation2 Text 6. Person 2 Relation to crew member
100
CSec16Gender2 Text 6. Person 2 Gender
100
CSec16Age2 Text 6. Person 2 Age
100
CSec16FishingWork2 Number 6. Person 2 Involved in fishing work
100
CSec16FishingWorkType2 Text 6. Person 2 Type of fishing-related work
100
CSec16Occupation2 Text 6. Person 2 Other Occupation (or retiree, student, unemployed, etc.)
100
CSec16Relation3 Text 6. Person 3 Relation to crew member
100
CSec16Gender3 Text 6. Person 3 Gender
100
CSec16Age3 Text 6. Person 3 Age
100
CSec16FishingWork3 Text 6. Person 3 Involved in fishing work
100
CSec16FishingWorkType3 Text 6. Person 3 Type of fishing-related work
100
CSec16Occupation3 Text 6. Person 3 Other Occupation (or retiree, student, unemployed, etc.)
100
CSec16Relation4 Text 6. Person 4 Relation to crew member
100
CSec16Gender4 Text 6. Person 4 Gender
100
CSec16Age4 Text 6. Person 4 Age
100
CSec16FishingWork4 Number 6. Person 4 Involved in fishing work
100
CSec16FishingWorkType4 Text 6. Person 4 Type of fishing-related work
100
CSec16Occupation4 Text 6. Person 4 Other Occupation (or retiree, student, unemployed, etc.)
100
CSec16Relation5 Text 6. Person 5 Relation to crew member
100
CSec16Gender5 Text 6. Person 5 Gender
100
CSec16Age5 Text 6. Person 5 Age
100
CSec16FishingWork5 Number 6. Person 5 Involved in fishing work
100
CSec16FishingWorkType5 Text 6. Person 5 Type of fishing-related work
100
CSec16Occupation5 Text 6. Person 5 Other Occupation (or retiree, student, unemployed, etc.)
100
CSec16Relation6 Text 6. Person 6 Relation to crew member
100
CSec16Gender6 Text 6. Person 6 Gender
100
CSec16Age6 Text 6. Person 6 Age
100
CSec16FishingWork6 Number 6. Person 6 Involved in fishing work
100
CSec16FishingWorkType6 Text 6. Person 6 Type of fishing-related work
100
CSec16Occupation6 Text 6. Person 6 Other Occupation (or retiree, student, unemployed, etc.)

Attribute Details

cSec16ID

CC ID: 363610
Seq. Order: 1
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Autonumber key

General Data Type: Number

CrewID

CC ID: 363611
Seq. Order: 2
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Crew Identifier

General Data Type: Number

LastName

CC ID: 363612
Seq. Order: 3
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Crew Last Name

General Data Type: Text

FirstName

CC ID: 363613
Seq. Order: 4
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Crew First Name

General Data Type: Text

Vessel1Permit#

CC ID: 363614
Seq. Order: 5
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Vessels Multispecies Groundfish Permit Number

General Data Type: Text

CSec16Relation1

CC ID: 363615
Seq. Order: 6
Data Storage Type: Text
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

6. Person 1 Relation to crew member

General Data Type: Text

CSec16Gender1

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

6. Person 1 Gender

General Data Type: Text

CSec16Age1

CC ID: 363617
Seq. Order: 8
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

6. Person 1 Age

General Data Type: Text

CSec16FishingWork1

CC ID: 363618
Seq. Order: 9
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

6. Person 1 Involved in fishing work

General Data Type: Number

CSec16FishingWorkType1

CC ID: 363619
Seq. Order: 10
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 1 Type of fishing-related work

General Data Type: Text

CSec16Occupation1

CC ID: 363620
Seq. Order: 11
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 1 Other Occupation (or retiree, student, unemployed, etc.)

General Data Type: Text

CSec16Relation2

CC ID: 363621
Seq. Order: 12
Data Storage Type: Text
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

6. Person 2 Relation to crew member

General Data Type: Text

CSec16Gender2

CC ID: 363622
Seq. Order: 13
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

6. Person 2 Gender

General Data Type: Text

CSec16Age2

CC ID: 363623
Seq. Order: 14
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

6. Person 2 Age

General Data Type: Text

CSec16FishingWork2

CC ID: 363624
Seq. Order: 15
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

6. Person 2 Involved in fishing work

General Data Type: Number

CSec16FishingWorkType2

CC ID: 363625
Seq. Order: 16
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 2 Type of fishing-related work

General Data Type: Text

CSec16Occupation2

CC ID: 363626
Seq. Order: 17
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 2 Other Occupation (or retiree, student, unemployed, etc.)

General Data Type: Text

CSec16Relation3

CC ID: 363627
Seq. Order: 18
Data Storage Type: Text
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

6. Person 3 Relation to crew member

General Data Type: Text

CSec16Gender3

CC ID: 363628
Seq. Order: 19
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

6. Person 3 Gender

General Data Type: Text

CSec16Age3

CC ID: 363629
Seq. Order: 20
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

6. Person 3 Age

General Data Type: Text

CSec16FishingWork3

CC ID: 363630
Seq. Order: 21
Data Storage Type: Text
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

6. Person 3 Involved in fishing work

General Data Type: Text

CSec16FishingWorkType3

CC ID: 363631
Seq. Order: 22
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 3 Type of fishing-related work

General Data Type: Text

CSec16Occupation3

CC ID: 363632
Seq. Order: 23
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 3 Other Occupation (or retiree, student, unemployed, etc.)

General Data Type: Text

CSec16Relation4

CC ID: 363633
Seq. Order: 24
Data Storage Type: Text
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

6. Person 4 Relation to crew member

General Data Type: Text

CSec16Gender4

CC ID: 363634
Seq. Order: 25
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

6. Person 4 Gender

General Data Type: Text

CSec16Age4

CC ID: 363635
Seq. Order: 26
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

6. Person 4 Age

General Data Type: Text

CSec16FishingWork4

CC ID: 363636
Seq. Order: 27
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

6. Person 4 Involved in fishing work

General Data Type: Number

CSec16FishingWorkType4

CC ID: 363637
Seq. Order: 28
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 4 Type of fishing-related work

General Data Type: Text

CSec16Occupation4

CC ID: 363638
Seq. Order: 29
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 4 Other Occupation (or retiree, student, unemployed, etc.)

General Data Type: Text

CSec16Relation5

CC ID: 363639
Seq. Order: 30
Data Storage Type: Text
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

6. Person 5 Relation to crew member

General Data Type: Text

CSec16Gender5

CC ID: 363640
Seq. Order: 31
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

6. Person 5 Gender

General Data Type: Text

CSec16Age5

CC ID: 363641
Seq. Order: 32
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

6. Person 5 Age

General Data Type: Text

CSec16FishingWork5

CC ID: 363642
Seq. Order: 33
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

6. Person 5 Involved in fishing work

General Data Type: Number

CSec16FishingWorkType5

CC ID: 363643
Seq. Order: 34
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 5 Type of fishing-related work

General Data Type: Text

CSec16Occupation5

CC ID: 363644
Seq. Order: 35
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 5 Other Occupation (or retiree, student, unemployed, etc.)

General Data Type: Text

CSec16Relation6

CC ID: 363645
Seq. Order: 36
Data Storage Type: Text
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

6. Person 6 Relation to crew member

General Data Type: Text

CSec16Gender6

CC ID: 363646
Seq. Order: 37
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

6. Person 6 Gender

General Data Type: Text

CSec16Age6

CC ID: 363647
Seq. Order: 38
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

6. Person 6 Age

General Data Type: Text

CSec16FishingWork6

CC ID: 363648
Seq. Order: 39
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

6. Person 6 Involved in fishing work

General Data Type: Number

CSec16FishingWorkType6

CC ID: 363649
Seq. Order: 40
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 6 Type of fishing-related work

General Data Type: Text

CSec16Occupation6

CC ID: 363650
Seq. Order: 41
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

6. Person 6 Other Occupation (or retiree, student, unemployed, etc.)

General Data Type: Text

Catalog Details

Catalog Item ID: 35963
GUID: gov.noaa.nmfs.inport:35963
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-14 12:34+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-14
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-14