a_sbs_interview_flat_view

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 63227 | Published / External
Created: 2020-11-17 | Last Modified: 2022-08-09

Parent: American Samoa Shore-based Creel Survey
Data Set (DS) | ID: 5614

ID: 63227
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	a_sbs_interview_flat_view
Short Name
* Status	Completed
Creation Date
Revision Date
• Publication Date
* » Abstract
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)
DOI Registration Authority
DOI Issue Date

Keywords

Theme Keywords

Thesaurus	Keyword

Temporal Keywords

Thesaurus	Keyword

* Spatial Keywords

Thesaurus	Keyword

Stratum Keywords

Thesaurus	Keyword

Instrument Keywords

Thesaurus	Keyword

Platform Keywords

Thesaurus	Keyword

Physical Location

• » Organization
• » City
• » State/Province
• Country
• » Location Description

Entity Information

Entity Type	Data View
Active Version?	Y
Alias
Schema Name	amsam_dmwr_wh
» Description
Change Summary

Data Attributes

Attribute Summary

Score	Req'd?	PKey?	» Name	Data Storage Type	Description
100	No	No	INTERVIEW_PK	varchar	Primary key, a unique identifier for each record in this table. Value is YYYYMMDDNNNN where NNNN is a sequential number assigned to interviews as they are created, starting with 0001 each year. Associates the detailed records in AIFyyCAT.DBF with their header record in AIFyyINT.DBF. The value is a unique integer assigned to interviews in increasing numeric order as they are created.
100	No	No	ROUTE_FK	int	Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
100	No	No	SAMPLE_DATE	date	Date of the survey.
100	No	No	INTERVIEW_TIME	datetime	Date and time the interview started.
100	No	No	TYPE_OF_DAY	varchar	Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.
100	No	No	GRAMS_F	char	Indicates whether the weight of the fish caught is in grams or pounds. If true (T), the value in the ACT_WT field (in A_SBS_CAT or AIFyyCAT.DBF) was recorded in grams and then converted to pounds before being entered in the EST_WHOLE_LBS field or CALC_LBS field. If false (F), the value is in pounds and is copied directly into the EST_WHOLE_LBS or the CALC_LBS field.
100	No	No	NON_SCHED_F	char	If true, the interview was non-scheduled (opportunistic), i.e., not held during the scheduled ranges of times and date for the route.
100	No	No	INTERVIEWER1_FK	int	Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
100	No	No	INTERVIEWER2_FK	int	Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
100	No	No	INTERVIEWER3_FK	int	Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
100	No	No	HOURS_FISHED	decimal	Number of hours spent fishing before the interview was started.
100	No	No	AREA_FK	int	Area code. Detailed information can be found in A_AREA and A_AREA.DBF.
100	No	No	HOME_F	char	Indicates whether the area in A_AREA or VILLAGE is the fisher’s home village. If true, the area or village is the fisher’s home.
100	No	No	METHOD_FK	int	Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.
100	No	No	NUM_GEAR	int	Number of gears used.
100	No	No	NUM_PEOPLE	int	Number of people in the group being interviewed whether they are fishing or not.
100	No	No	NUM_CHILD_M	int	Number of male children younger than 14 years old present in the group being interviewed whether they are fishing or not.
100	No	No	NUM_CHILD_F	int	Number of female children younger than 14 years old present in the group being interviewed whether they are fishing or not.
100	No	No	NUM_ADULT_F	int	Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not.
100	No	No	NUM_ADULT_M	int	Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not.
100	No	No	TOT_EST_WHOLE_LBS	decimal	Calculated, estimated total pounds for the trip; the sum of EST_WHOLE_LBS in A_SBS_CAT for the trip.
100	No	No	PORCENT_SOLD	int	Percentage of the interview catch sold commercially.
100	No	No	COMPLETED_INT_F	char	If true, all fish the fisher caught were weighed, measured, and included in the interview. If false, only some of the fish that the fisher caught were weighted, measured, and included in the interview. Incomplete interviews are not used in the shore-based creel survey expansion but can be used for size-frequency calculations and determining a/b factors for use in length-to-weight conversion.
100	No	No	START_TIME	datetime	Date and time or time the fishing activity started.
100	No	No	STOP_TIME	datetime	time when fishing stopped.
100	No	No	INT_REMARKS	varchar	Remarks.
100	No	No	INT_CREATE_TIME	datetime	date of interview record created
100	No	No	INT_MODIFY_TIME	datetime	When this record was last modified.
100	No	No	INT_LOAD_TABLE	varchar	Foxpro files where this record was loaded from.
100	No	No	INT_LOAD_DATETIME	datetime	Date when data was loaded
100	No	No	INT_LOAD_USER	varchar	User who loaded the a_sbs_int data table from Focpro data
100	No	No	CATCH_PK	int	Primary key value found in the a_sbs_cat data table
100	No	No	INTERVIEW_FK	varchar	Unique identifier for A_SBS_CAT. The value is YYYYMMDDNNN where NNN is a number that groups detailed records to associate them with the header record in A_SBS_INT. A unique identifier for each record in AIFyyINT.DBF .
100	No	No	SPECIES_FK	int	species code , detailed information can be found in A_SPECIES.
100	No	No	DISPOSITION_FK	int	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.
100	No	No	LEN_CM	decimal	Length in centimeters of a single fish if measured.
100	No	No	ACT_WT	decimal	Actual measured weight.
100	No	No	NUM_PIECES	int	Number of pieces of fish caught.
100	No	No	EST_WHOLE_LBS_TYPE	varchar	Describes how EST_WHOLE_LBS_TYPE or CALC_LBS was calculated. Values can be W, L, I, or S. W = Calculated from the ACT_WT field. L = Calculated from the LEN_CM field. If no weight data is available, but the fish length has been measured, the weight is calculated using a length-weight regression factor. I = If there is no weight or length data in this record, the whole weight is obtained by multiplying NUM_PIECES by the average of EST_WHOLE_LBS for this species with weight data in this interview. S = If there is no length or weight data for this species in any records in this interview, EST_WHOLE_LBS is obtained by multiplying NUM_PIECES by the average pounds for the species in the species table (A_SPECIES). This rarely happens.
100	No	No	EST_WHOLE_LBS	decimal	Whole weight of fish measured in pounds for an interview. If ACT_WT value is in grams, it is converted to pounds by multiplying the ACT_WT value by 2.203. If the ACT_WT value is in pounds it is copied from the ACT_WT field. For other conditions, see EST_WHOLE_LBS_TYPE for how this field is calculated.
100	No	No	CAT_REMARKS	varchar	Remarks.
100	No	No	CAT_CREATE_TIME	datetime	When catch data record was created.
100	No	No	CAT_MODIFY_TIME	datetime	When this record was last modified.
100	No	No	CAT_LOAD_TABLE	varchar	Foxpro files where this record was loaded from.
100	No	No	CAT_LOAD_DATETIME	datetime	When the a_sbs_catch data table was loaded ito MySQL.
100	No	No	CAT_LOAD_USER	varchar	User who loaded the a_sbs_catch data table from Focpro data.
100	No	No	FISHING_METHOD	varchar	gear used code. See description in A_METHOD table
100	No	No	FISHING_AREA	varchar	area fished code. See description in the A_AREA table
100	No	No	ROUTE_NAME	varchar	The name of the route.
100	No	No	SCIENTIFIC_NAME	varchar	Scientific name of the species (Genus name + Species name).
100	No	No	COMMON_NAME	varchar	Common English name for the species.
100	No	No	LOCAL_NAME	varchar	Local name of the species.
100	No	No	DISPOSITION	varchar	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.

Attribute Details

Attribute Name	INTERVIEW_PK
Seq. Order	1
Data Storage Type	varchar
Max Length	12
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Primary key, a unique identifier for each record in this table. Value is YYYYMMDDNNNN where NNNN is a sequential number assigned to interviews as they are created, starting with 0001 each year. Associates the detailed records in AIFyyCAT.DBF with their header record in AIFyyINT.DBF. The value is a unique integer assigned to interviews in increasing numeric order as they are created.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	ROUTE_FK
Seq. Order	2
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SAMPLE_DATE
Seq. Order	3
Data Storage Type	date
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date of the survey.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INTERVIEW_TIME
Seq. Order	4
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date and time the interview started.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_OF_DAY
Seq. Order	5
Data Storage Type	varchar
Max Length	2
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	GRAMS_F
Seq. Order	6
Data Storage Type	char
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Indicates whether the weight of the fish caught is in grams or pounds. If true (T), the value in the ACT_WT field (in A_SBS_CAT or AIFyyCAT.DBF) was recorded in grams and then converted to pounds before being entered in the EST_WHOLE_LBS field or CALC_LBS field. If false (F), the value is in pounds and is copied directly into the EST_WHOLE_LBS or the CALC_LBS field.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NON_SCHED_F
Seq. Order	7
Data Storage Type	char
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	If true, the interview was non-scheduled (opportunistic), i.e., not held during the scheduled ranges of times and date for the route.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INTERVIEWER1_FK
Seq. Order	8
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INTERVIEWER2_FK
Seq. Order	9
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INTERVIEWER3_FK
Seq. Order	10
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HOURS_FISHED
Seq. Order	11
Data Storage Type	decimal
Max Length
Min Length
Required	No
Primary Key	No
Precision	7
Scale	2
Status	Active
Description	Number of hours spent fishing before the interview was started.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	AREA_FK
Seq. Order	12
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Area code. Detailed information can be found in A_AREA and A_AREA.DBF.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HOME_F
Seq. Order	13
Data Storage Type	char
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Indicates whether the area in A_AREA or VILLAGE is the fisher’s home village. If true, the area or village is the fisher’s home.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	METHOD_FK
Seq. Order	14
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUM_GEAR
Seq. Order	15
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Number of gears used.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUM_PEOPLE
Seq. Order	16
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Number of people in the group being interviewed whether they are fishing or not.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUM_CHILD_M
Seq. Order	17
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Number of male children younger than 14 years old present in the group being interviewed whether they are fishing or not.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUM_CHILD_F
Seq. Order	18
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Number of female children younger than 14 years old present in the group being interviewed whether they are fishing or not.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUM_ADULT_F
Seq. Order	19
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUM_ADULT_M
Seq. Order	20
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TOT_EST_WHOLE_LBS
Seq. Order	21
Data Storage Type	decimal
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	3
Status	Active
Description	Calculated, estimated total pounds for the trip; the sum of EST_WHOLE_LBS in A_SBS_CAT for the trip.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	PORCENT_SOLD
Seq. Order	22
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Percentage of the interview catch sold commercially.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	COMPLETED_INT_F
Seq. Order	23
Data Storage Type	char
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	If true, all fish the fisher caught were weighed, measured, and included in the interview. If false, only some of the fish that the fisher caught were weighted, measured, and included in the interview. Incomplete interviews are not used in the shore-based creel survey expansion but can be used for size-frequency calculations and determining a/b factors for use in length-to-weight conversion.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	START_TIME
Seq. Order	24
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date and time or time the fishing activity started.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	STOP_TIME
Seq. Order	25
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	time when fishing stopped.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INT_REMARKS
Seq. Order	26
Data Storage Type	varchar
Max Length	256
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Remarks.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INT_CREATE_TIME
Seq. Order	27
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	date of interview record created
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INT_MODIFY_TIME
Seq. Order	28
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	When this record was last modified.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INT_LOAD_TABLE
Seq. Order	29
Data Storage Type	varchar
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Foxpro files where this record was loaded from.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INT_LOAD_DATETIME
Seq. Order	30
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date when data was loaded
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INT_LOAD_USER
Seq. Order	31
Data Storage Type	varchar
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	User who loaded the a_sbs_int data table from Focpro data
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CATCH_PK
Seq. Order	32
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Primary key value found in the a_sbs_cat data table
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INTERVIEW_FK
Seq. Order	33
Data Storage Type	varchar
Max Length	12
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Unique identifier for A_SBS_CAT. The value is YYYYMMDDNNN where NNN is a number that groups detailed records to associate them with the header record in A_SBS_INT. A unique identifier for each record in AIFyyINT.DBF .
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SPECIES_FK
Seq. Order	34
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	species code , detailed information can be found in A_SPECIES.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DISPOSITION_FK
Seq. Order	35
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LEN_CM
Seq. Order	36
Data Storage Type	decimal
Max Length
Min Length
Required	No
Primary Key	No
Precision	8
Scale	2
Status	Active
Description	Length in centimeters of a single fish if measured.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	ACT_WT
Seq. Order	37
Data Storage Type	decimal
Max Length
Min Length
Required	No
Primary Key	No
Precision	8
Scale	3
Status	Active
Description	Actual measured weight.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUM_PIECES
Seq. Order	38
Data Storage Type	int
Max Length
Min Length
Required	No
Primary Key	No
Precision	10
Scale	0
Status	Active
Description	Number of pieces of fish caught.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	EST_WHOLE_LBS_TYPE
Seq. Order	39
Data Storage Type	varchar
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Describes how EST_WHOLE_LBS_TYPE or CALC_LBS was calculated. Values can be W, L, I, or S. W = Calculated from the ACT_WT field. L = Calculated from the LEN_CM field. If no weight data is available, but the fish length has been measured, the weight is calculated using a length-weight regression factor. I = If there is no weight or length data in this record, the whole weight is obtained by multiplying NUM_PIECES by the average of EST_WHOLE_LBS for this species with weight data in this interview. S = If there is no length or weight data for this species in any records in this interview, EST_WHOLE_LBS is obtained by multiplying NUM_PIECES by the average pounds for the species in the species table (A_SPECIES). This rarely happens.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	EST_WHOLE_LBS
Seq. Order	40
Data Storage Type	decimal
Max Length
Min Length
Required	No
Primary Key	No
Precision	8
Scale	3
Status	Active
Description	Whole weight of fish measured in pounds for an interview. If ACT_WT value is in grams, it is converted to pounds by multiplying the ACT_WT value by 2.203. If the ACT_WT value is in pounds it is copied from the ACT_WT field. For other conditions, see EST_WHOLE_LBS_TYPE for how this field is calculated.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CAT_REMARKS
Seq. Order	41
Data Storage Type	varchar
Max Length	256
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Remarks.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CAT_CREATE_TIME
Seq. Order	42
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	When catch data record was created.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CAT_MODIFY_TIME
Seq. Order	43
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	When this record was last modified.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CAT_LOAD_TABLE
Seq. Order	44
Data Storage Type	varchar
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Foxpro files where this record was loaded from.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CAT_LOAD_DATETIME
Seq. Order	45
Data Storage Type	datetime
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	When the a_sbs_catch data table was loaded ito MySQL.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CAT_LOAD_USER
Seq. Order	46
Data Storage Type	varchar
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	User who loaded the a_sbs_catch data table from Focpro data.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	FISHING_METHOD
Seq. Order	47
Data Storage Type	varchar
Max Length	45
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	gear used code. See description in A_METHOD table
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	FISHING_AREA
Seq. Order	48
Data Storage Type	varchar
Max Length	255
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	area fished code. See description in the A_AREA table
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	ROUTE_NAME
Seq. Order	49
Data Storage Type	varchar
Max Length	30
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The name of the route.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SCIENTIFIC_NAME
Seq. Order	50
Data Storage Type	varchar
Max Length	73
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Scientific name of the species (Genus name + Species name).
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	COMMON_NAME
Seq. Order	51
Data Storage Type	varchar
Max Length	46
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Common English name for the species.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LOCAL_NAME
Seq. Order	52
Data Storage Type	varchar
Max Length	46
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Local name of the species.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DISPOSITION
Seq. Order	53
Data Storage Type	varchar
Max Length	30
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class
* Security Classification System
Security Handling Description
• Data Access Policy
» Data Access Procedure
• » Data Access Constraints
• Data Use Constraints
Metadata Access Constraints
Metadata Use Constraints

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue

Issue Date
Author
Issue

Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score	Type	Title

Related Items

Item Type	Relationship Type	Title

Catalog Details

Catalog Item ID	63227
Metadata Record Created By	Brent M Miyamoto
Metadata Record Created	2020-11-17 23:42+0000
Metadata Record Last Modified By	SysAdmin InPortAdmin
» Metadata Record Last Modified	2022-08-09 17:11+0000
Metadata Record Published	2021-01-21
Owner Org	PIFSC
Metadata Publication Status	Published Externally
Do Not Publish?	N
Metadata Workflow State	Published / External
Metadata Last Review Date	2021-01-21
Metadata Review Frequency	1 Year
Metadata Next Review Date	2022-01-21

Tags