a_bbs_interview_flat_view
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 60075
| Published / External
Created: 2020-06-18
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 5612
ID: 60075
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | a_bbs_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 or UID for each interview header data record. |
100 | No | No | SAMPLE_DATE | date | Date of the survey. |
100 | No | No | TYPE_OF_DAY | varchar | Type of day (WD – weekday, WE weekend/holiday). |
100 | No | No | INTERVIEW_TIME | datetime | Date and time of the Interview. |
100 | No | No | INTERVIEWER1_FK | int | Interviewer 1 code. |
100 | No | No | INTERVIEWER2_FK | int | Interviewer 2 code. |
100 | No | No | INTERVIEW_ORDER | int | Place holder for future usage. Current value is NULL. |
100 | No | No | BLDT_FK | int | Place holder for future usage. Current value is NULL. |
100 | No | No | AREA_FK | int | Fishing Area code |
100 | No | No | METHOD_FK | int | Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies. |
100 | No | No | DEPTH | varchar | The approximate depth range in fathoms of hook dropped. |
100 | No | No | TRIP_BEG_DATE | date | Fishing trip start date. |
100 | No | No | TRIP_BEG_TIME | int | Fishing trip start time. |
100 | No | No | HOURS_FISHED | decimal | Number of hours spent fishing. |
100 | No | No | NUM_FISHER | int | Number of fishermen fishing. |
100 | No | No | NUM_GUEST | int | Number of guests on trip that are not fishing. |
100 | No | No | NUM_SETS | int | For longline fishing method only. Number of sets covered by the interview. The value is usually 1, but it can be 2 or 3 for longline boats that set their gear two or three times during a trip. |
100 | No | No | HOURS_PER_SET | decimal | Longline: hours of line in water. Other method: hours of fishing time. |
100 | No | No | HOOKS_PER_SET | int | For longline method: Number of hooks per line. For others: number of gears used. |
100 | No | No | NUM_DAYS_FISHED | int | Number of days fished. |
100 | No | No | NUM_GEAR | int | For longline method: Number of hooks used. For others: number of gears used. |
100 | No | No | VESSEL_FK | int | Vessel code. |
100 | No | No | VESSEL_HISTORY_FK | int | Vessel’s history code (e.g. ownership, permit type or type of used). Detailed information can be found in A_VESSEL_HISTORY or A_MASTVSSL.DBF. |
100 | No | No | PORT_FK | int | Port code interview is conducted. Detailed information can be found in A_PORT or A_PORT.DBF |
100 | No | No | TOT_EST_LBS | decimal | Estimated total pounds of catch for the trip. |
100 | No | No | BYCATCH_F | char | If true, there was bycatch on this trip. |
100 | No | No | CHARTER_F | char | If true, it is a charter trip. |
100 | No | No | BERTHED_F | char | If true, the vessel is berthed at a specific designated place. |
100 | No | No | NON_SCHED_F | char | If true, this interview was from a nonscheduled survey day (opportunist interview). |
100 | No | No | LUNAR_DAY | int | Place holder for future usage to store the Lunar day of the month. Current value is NULL. |
100 | No | No | ISLAND_FK | varchar | Island where the interview was conducted. (TTL:Tutuila and MNA:Manu`a). |
100 | No | No | REFUSED_F | char | If true, the fisherman refused to be interviewed. |
100 | No | No | INCOMPLETE_F | char | If true, all catch from this trip were not fully captured in this interview. |
100 | No | No | INT_REMARKS | varchar | Comments related to the trip (interview header record). |
100 | No | No | INT_CREATE_TIME | datetime | Date and time the record was created (interview header records). |
100 | No | No | INT_MODIFY_TIME | datetime | Date and time the record was last modified (interview header record). |
100 | No | No | INT_LOAD_TABLE | varchar | Name of the FoxPro table (contain this data) that was loaded into MySQL (interview header record). |
100 | No | No | INT_LOAD_DATETIME | datetime | The date and time the data was loaded in to the table (interview header record). |
100 | No | No | INT_LOAD_USER | varchar | User who loaded the data to the MySQL table (interview header record). |
100 | No | No | CATCH_PK | varchar | Primary key, a unique identifier for each catch record. The value is the sample date, interview time, and fishing method (MMDDYYHHMMFF). |
100 | No | No | INTERVIEW_FK | varchar | Key (foreign) links the related of catch records (in A_BBS_CAT table) to its interview trip header data (table A_BBS_INT). |
100 | No | No | SPECIES_FK | int | Species code. Detailed information can be found in A_SPECIES. |
100 | No | No | FISH_CONDITION_FK | varchar | Fish condition code when interview took place. (i.e., whole, gilled-gutted, etc.) Code description is found in the A_FISH_CONDITION. |
100 | No | No | NUM_KEPT | int | Number of fish kept (pieces). |
100 | No | No | NUM_KEPT_TYPE | varchar | Place holder to store the source of PRICE_LB value. Currently NULL value. |
100 | No | No | CAT_LBS | decimal | Actual fish weight during sampling. When weight was not able to obtain during the interview, the value for this field is zero. |
100 | No | No | CAT_LBS_TYPE | varchar | Place holder to store the source of PRICE_LB value. Currently NULL value. |
100 | No | No | EST_LBS | decimal | Estimated fish weight calculated by one of the following cases. 1. It is CAT_LBS, if CAT_LBS >0; 2. Calculated whole fish weight (CAT_LBS and FISH_CONDITION_FK fields both have values); 3. Calculated from measured fish length (length-weight regression based estimation), when CAT_LBS =0 and LEN_MM=1; or 4. NUM_PIECES *AVG_WT when CAT_LBS =0 and NUM_PIECES = >1. AVG_WT is the average fish weight calculated from the measured fish; when there is no measured data (LEN_MM), default mean weight is used (a_species). |
100 | No | No | EST_LBS_TYPE | varchar | Place holder to store the source of PRICE_LB value. Currently NULL value. |
100 | No | No | DISPOSITION_FK | int | Fish disposition code. Detailed information can be found in A_DISPOSITION. |
100 | No | No | BYCATCH_TYPE | char | Type of bycatch (N-none, A-alive, U-unknown, I-injured or D-dead). |
100 | No | No | PRICE_LB | decimal | Estimated price per pound of fish will be selling, provided by fisher. |
100 | No | No | PRICE_LB_TYPE_FK | varchar | Place holder to store the source of PRICE_LB value. Currently NULL value. |
100 | No | No | CAT_REMARKS | varchar | Comment field (interview catch record). |
100 | No | No | CAT_CREATE_TIME | datetime | Date and time the record was created (interview catch record). |
100 | No | No | CAT_MODIFY_TIME | datetime | Date and time or date the record was last modified (interview catch record). |
100 | No | No | CAT_LOAD_TABLE | varchar | Name of the FoxPro table that was loaded into MySQL (interview catch record). |
100 | No | No | CAT_LOAD_DATETIME | datetime | The date and time the data was loaded into MySQL table (interview catch record). |
100 | No | No | CAT_LOAD_USER | varchar | User who loaded the data to the MySQL table (interview catch record). |
100 | No | No | SIZE_PK | int | Primary key, a unique identifier for each record of the interview’s size data. Value is auto-generated |
100 | No | No | CATCH_FK | varchar | Key (foreign) links the related size measurement records (in this table) to its catch record (A_BBS_CAT). |
100 | No | No | LEN_MM | decimal | Fork-length of fish in centimeters. Column name should be LEN_CM. |
100 | No | No | LEN_MM_TYPE | varchar | Place holder to store the source of PRICE_LB value. Currently NULL value. |
100 | No | No | SIZ_LBS | decimal | Calculated fish weight. |
100 | No | No | SIZ_LBS_TYPE | varchar | Place holder to store the source of PRICE_LB value. Currently NULL value. |
100 | No | No | SIZ_REMARKS | varchar | Comment field for collected individual fish (interview size record). |
100 | No | No | SIZ_CREATE_TIME | datetime | Date and time the record was created (interview size record). |
100 | No | No | SIZ_MODIFY_TIME | datetime | Date and time or date the record was last modified (interview size record). |
100 | No | No | SIZ_LOAD_TABLE | varchar | Name of the FoxPro table that was loaded into MySQL (interview size record). |
100 | No | No | SIZ_LOAD_DATETIME | datetime | The date and time the data was loaded in to the table (interview size record). |
100 | No | No | SIZ_LOAD_USER | varchar | User who loaded the data to the MySQL table (interview size record). |
100 | No | No | FISHING_METHOD | varchar | Fishing method code. |
100 | No | No | FISHING_AREA | varchar | Code of fishing area. |
100 | No | No | VESSEL_REGIST_NO | varchar | Vessel's registaton number.. |
100 | No | No | PORT_NAME | varchar | Description for PORT_FK code. |
100 | No | No | ISLAND_NAME | varchar | Description for ISLAND_FK code. |
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 | FISH_CONDITION | varchar | Description for FISH_CONDITION_FK code. |
100 | No | No | DISPOSITION | varchar | Description for DISPOSITION_FK code. |
100 | No | No | PRICE_LB_TYPE | varchar | Place holder to store the source of PRICE_LB value. Currently NULL value. |
Attribute Details
Attribute Name | INTERVIEW_PK |
---|---|
Seq. Order | 1 |
Data Storage Type | varchar |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary key or UID for each interview header data record. |
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 | 2 |
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 | TYPE_OF_DAY |
---|---|
Seq. Order | 3 |
Data Storage Type | varchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of day (WD – weekday, WE weekend/holiday). |
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 of the Interview. |
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 | 5 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Interviewer 1 code. |
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 | 6 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Interviewer 2 code. |
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_ORDER |
---|---|
Seq. Order | 7 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Place holder for future usage. Current value is NULL. |
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 | BLDT_FK |
---|---|
Seq. Order | 8 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Place holder for future usage. Current value is NULL. |
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 | 9 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Fishing Area code |
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 | 10 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies. |
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 | DEPTH |
---|---|
Seq. Order | 11 |
Data Storage Type | varchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The approximate depth range in fathoms of hook dropped. |
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 | TRIP_BEG_DATE |
---|---|
Seq. Order | 12 |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fishing trip start date. |
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 | TRIP_BEG_TIME |
---|---|
Seq. Order | 13 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Fishing trip start time. |
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 | 14 |
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. |
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_FISHER |
---|---|
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 fishermen fishing. |
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_GUEST |
---|---|
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 guests on trip that are not fishing. |
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_SETS |
---|---|
Seq. Order | 17 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
For longline fishing method only. Number of sets covered by the interview. The value is usually 1, but it can be 2 or 3 for longline boats that set their gear two or three times during a 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 | HOURS_PER_SET |
---|---|
Seq. Order | 18 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | 2 |
Status | Active |
Description |
Longline: hours of line in water. Other method: hours of fishing time. |
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 | HOOKS_PER_SET |
---|---|
Seq. Order | 19 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
For longline method: Number of hooks per line. For others: 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_DAYS_FISHED |
---|---|
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 days fished. |
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 | 21 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
For longline method: Number of hooks used. For others: 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 | VESSEL_FK |
---|---|
Seq. Order | 22 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Vessel code. |
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 | VESSEL_HISTORY_FK |
---|---|
Seq. Order | 23 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Vessel’s history code (e.g. ownership, permit type or type of used). Detailed information can be found in A_VESSEL_HISTORY or A_MASTVSSL.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 | PORT_FK |
---|---|
Seq. Order | 24 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Port code interview is conducted. Detailed information can be found in A_PORT or A_PORT.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 | TOT_EST_LBS |
---|---|
Seq. Order | 25 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 2 |
Status | Active |
Description |
Estimated total pounds of catch 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 | BYCATCH_F |
---|---|
Seq. Order | 26 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, there was bycatch on this 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 | CHARTER_F |
---|---|
Seq. Order | 27 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, it is a charter 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 | BERTHED_F |
---|---|
Seq. Order | 28 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, the vessel is berthed at a specific designated place. |
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 | 29 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, this interview was from a nonscheduled survey day (opportunist interview). |
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 | LUNAR_DAY |
---|---|
Seq. Order | 30 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Place holder for future usage to store the Lunar day of the month. Current value is NULL. |
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 | ISLAND_FK |
---|---|
Seq. Order | 31 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Island where the interview was conducted. (TTL:Tutuila and MNA:Manu`a). |
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 | REFUSED_F |
---|---|
Seq. Order | 32 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, the fisherman refused to be interviewed. |
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 | INCOMPLETE_F |
---|---|
Seq. Order | 33 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, all catch from this trip were not fully captured in this interview. |
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 | 34 |
Data Storage Type | varchar |
Max Length | 256 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments related to the trip (interview header record). |
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 | 35 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the record was created (interview header records). |
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 | 36 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the record was last modified (interview header record). |
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 | 37 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the FoxPro table (contain this data) that was loaded into MySQL (interview header record). |
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 | 38 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date and time the data was loaded in to the table (interview header record). |
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 | 39 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User who loaded the data to the MySQL table (interview header record). |
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 | 40 |
Data Storage Type | varchar |
Max Length | 24 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary key, a unique identifier for each catch record. The value is the sample date, interview time, and fishing method (MMDDYYHHMMFF). |
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 | 41 |
Data Storage Type | varchar |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Key (foreign) links the related of catch records (in A_BBS_CAT table) to its interview trip header data (table A_BBS_INT). |
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 | 42 |
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 | FISH_CONDITION_FK |
---|---|
Seq. Order | 43 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fish condition code when interview took place. (i.e., whole, gilled-gutted, etc.) Code description is found in the A_FISH_CONDITION. |
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_KEPT |
---|---|
Seq. Order | 44 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Number of fish kept (pieces). |
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_KEPT_TYPE |
---|---|
Seq. Order | 45 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder to store the source of PRICE_LB value. Currently NULL value. |
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_LBS |
---|---|
Seq. Order | 46 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | 3 |
Status | Active |
Description |
Actual fish weight during sampling. When weight was not able to obtain during the interview, the value for this field is zero. |
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_LBS_TYPE |
---|---|
Seq. Order | 47 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder to store the source of PRICE_LB value. Currently NULL value. |
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_LBS |
---|---|
Seq. Order | 48 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | 3 |
Status | Active |
Description |
Estimated fish weight calculated by one of the following cases. 1. It is CAT_LBS, if CAT_LBS >0; 2. Calculated whole fish weight (CAT_LBS and FISH_CONDITION_FK fields both have values); 3. Calculated from measured fish length (length-weight regression based estimation), when CAT_LBS =0 and LEN_MM=1; or 4. NUM_PIECES *AVG_WT when CAT_LBS =0 and NUM_PIECES = >1. AVG_WT is the average fish weight calculated from the measured fish; when there is no measured data (LEN_MM), default mean weight is used (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 | EST_LBS_TYPE |
---|---|
Seq. Order | 49 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder to store the source of PRICE_LB value. Currently NULL value. |
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 | 50 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Fish disposition code. Detailed information can be found in A_DISPOSITION. |
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 | BYCATCH_TYPE |
---|---|
Seq. Order | 51 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of bycatch (N-none, A-alive, U-unknown, I-injured or D-dead). |
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 | PRICE_LB |
---|---|
Seq. Order | 52 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 2 |
Status | Active |
Description |
Estimated price per pound of fish will be selling, provided by fisher. |
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 | PRICE_LB_TYPE_FK |
---|---|
Seq. Order | 53 |
Data Storage Type | varchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder to store the source of PRICE_LB value. Currently NULL value. |
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 | 54 |
Data Storage Type | varchar |
Max Length | 256 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comment field (interview catch record). |
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 | 55 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the record was created (interview catch record). |
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 | 56 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time or date the record was last modified (interview catch record). |
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 | 57 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the FoxPro table that was loaded into MySQL (interview catch record). |
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 | 58 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date and time the data was loaded into MySQL table (interview catch record). |
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 | 59 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User who loaded the data to the MySQL table (interview catch record). |
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 | SIZE_PK |
---|---|
Seq. Order | 60 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Primary key, a unique identifier for each record of the interview’s size data. Value is auto-generated |
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_FK |
---|---|
Seq. Order | 61 |
Data Storage Type | varchar |
Max Length | 24 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Key (foreign) links the related size measurement records (in this table) to its catch record (A_BBS_CAT). |
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_MM |
---|---|
Seq. Order | 62 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | 2 |
Status | Active |
Description |
Fork-length of fish in centimeters. Column name should be LEN_CM. |
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_MM_TYPE |
---|---|
Seq. Order | 63 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder to store the source of PRICE_LB value. Currently NULL value. |
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 | SIZ_LBS |
---|---|
Seq. Order | 64 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | 2 |
Status | Active |
Description |
Calculated fish 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 | SIZ_LBS_TYPE |
---|---|
Seq. Order | 65 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder to store the source of PRICE_LB value. Currently NULL value. |
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 | SIZ_REMARKS |
---|---|
Seq. Order | 66 |
Data Storage Type | varchar |
Max Length | 256 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comment field for collected individual fish (interview size record). |
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 | SIZ_CREATE_TIME |
---|---|
Seq. Order | 67 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the record was created (interview size record). |
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 | SIZ_MODIFY_TIME |
---|---|
Seq. Order | 68 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time or date the record was last modified (interview size record). |
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 | SIZ_LOAD_TABLE |
---|---|
Seq. Order | 69 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the FoxPro table that was loaded into MySQL (interview size record). |
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 | SIZ_LOAD_DATETIME |
---|---|
Seq. Order | 70 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date and time the data was loaded in to the table (interview size record). |
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 | SIZ_LOAD_USER |
---|---|
Seq. Order | 71 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User who loaded the data to the MySQL table (interview size record). |
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 | 72 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fishing method code. |
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 | 73 |
Data Storage Type | varchar |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code of fishing area. |
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 | VESSEL_REGIST_NO |
---|---|
Seq. Order | 74 |
Data Storage Type | varchar |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vessel's registaton number.. |
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 | PORT_NAME |
---|---|
Seq. Order | 75 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description for PORT_FK code. |
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 | ISLAND_NAME |
---|---|
Seq. Order | 76 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description for ISLAND_FK code. |
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 | 77 |
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 | 78 |
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 | 79 |
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 | FISH_CONDITION |
---|---|
Seq. Order | 80 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description for FISH_CONDITION_FK code. |
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 | 81 |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description for DISPOSITION_FK code. |
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 | PRICE_LB_TYPE |
---|---|
Seq. Order | 82 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder to store the source of PRICE_LB value. Currently NULL value. |
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
* » 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 | 60075 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2020-06-18 15:53+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 |
---|