c_bbs_interview_flat_view
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 63461
| Published / External
Created: 2021-01-21
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 5628
ID: 63461
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | c_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 | cnmi_dfw_wh |
» Description | |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | INTERVIEW_PK | varchar | UID, Primary key . |
100 | No | No | SAMPLE_DATE | date | Date of the survey. |
100 | No | No | TYPE_OF_DAY | varchar | Type of day on which the interview was conducted (WD= weekday, WE = weekend/holiday). |
100 | No | No | INTERVIEW_TIME | int | Time the interview was conducted. |
100 | No | No | INTERVIEWER1_FK | int | Interviewer1 code. |
100 | No | No | INTERVIEWER2_FK | int | Interviewer2 code. |
100 | No | No | INTERVIEW_ORDER | int | Order of the survey was taken. |
100 | No | No | BOATLOG_DT_FK | int | Filler, not in used. |
100 | No | No | AREA_FK | int | Code for the area fished. Detailed information can be found in C_BBS_AREA or C_AREA.DBF. |
100 | No | No | METHOD_FK | int | Fishing method code. |
100 | No | No | DEPTH | varchar | Bottomfishing set depth (D = deep, S = shallow, M = mixed). |
100 | No | No | WEATHER_FK | int | Code for weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF. |
100 | No | No | CLOUD_FK | int | Cloud condition code. |
100 | No | No | WIND_DIRECTION | varchar | Place holder, not used. |
100 | No | No | WIND_SPEED | int | Place holder, not used. |
100 | No | No | HOURS_FISHED | decimal | Number of hours fished. |
100 | No | No | NUM_FISHER | int | Number of fishermen fishing. |
100 | No | No | NUM_GUEST | int | Number of guests onboard during trip. |
100 | No | No | NUM_GEAR | int | Number of gears used. |
100 | No | No | VESSEL_NAME | varchar | Name of the fishing vessel. |
100 | No | No | PORT_FK | int | Port code. |
100 | No | No | CAR_LICENSE | varchar | Vehicle/trailer license number. |
100 | No | No | TOT_NUM_KEPT_TYPE | int | How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated). |
100 | No | No | TOT_NUM_KEPT | int | Total pieces of fish caught. |
100 | No | No | TOT_EST_KGS_TYPE | int | How TOT_EST_KGS was collected (1 = actual, 2 = calculated, 3 = estimated). |
100 | No | No | TOT_EST_KGS | decimal | Total fish caught in kgs for this trip. |
100 | No | No | TOT_SPECIES_TYPE | int | How TOT_SPECIES was collected (1 = actual, 2 = calculated, 3 = estimated). |
100 | No | No | TOT_SPECIES | int | Number of species caught on this trip. |
100 | No | No | PERCENT_SOLD_DOCK | decimal | Percent of catch sold at dock (to the hundredths). |
100 | No | No | PERCENT_SOLD | decimal | Percent of catch sold (to the hundredths). |
100 | No | No | PERCENT_UNSOLD | decimal | Percent of unsold catch. |
100 | No | No | BUYER_FK | int | Filler, not in used. |
100 | No | No | BYCATCH_F | varchar | If true, this was a bycatch. |
100 | No | No | CHARTER_F | char | If true (T), indicates chartered trip. |
100 | No | No | BERTHED_F | char | If true (T), the boat was berthed. |
100 | No | No | SMALLCRAFT_F | char | If true (T), small craft advisory was in effect. |
100 | No | No | HIGHSURF_F | char | If true, high surf warning was in effect. |
100 | No | No | NON_SCHED_F | char | If true (T), the interview was non-scheduled (opportunistic). |
100 | No | No | LUNAR_DAY | int | Lunar day. Data obtained from C_LUNAR.DBF (foxpro table), based on the value of the survey date (15 = full moon, 1 or 29/30 = new moon). |
100 | No | No | INCOMPLETE_F | char | This interview is not complete (all catch from this trip was not captured on this interview). |
100 | No | No | INT_REMARKS | varchar | Comment field. |
100 | No | No | INT_CREATE_TIME | datetime | Date and time that the record was created or date the record was created. |
100 | No | No | INT_MODIFY_TIME | datetime | When was the last date this record was editted |
100 | No | No | INT_CREATE_USER | int | Name of the user who created the record. |
100 | No | No | INT_MODIFY_USER | int | Name of the user who last modified the record. |
100 | No | No | INT_LOAD_TABLE | varchar | Which VFP table where this data was loaded from |
100 | No | No | INT_LOAD_DATETIME | datetime | When this record was loade into MySQL VFP |
100 | No | No | INT_LOAD_USER | varchar | User load the data into MySQL |
100 | No | No | CATCH_PK | varchar | Primary key (MySQL only) which is a unique identifier for each record in this table. Specify value. |
100 | No | No | INTERVIEW_FK | varchar | Key that link this record back to its related record found in the c_bbs_int. |
100 | No | No | SPECIES_FK | int | Species code. |
100 | No | No | NUM_KEPT | int | Pieces of fish caught. |
100 | No | No | NUM_KEPT_TYPE | int | How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated). |
100 | No | No | EST_KGS | decimal | Total catch of this species. |
100 | No | No | EST_KGS_TYPE | int | How weight was collected (1 = actual, 2 = calculated, 3 = estimated). |
100 | No | No | PRICE_LB | decimal | Place holder, not used. |
100 | No | No | PRICE_LB_TYPE_FK | int | Place holder, not used. |
100 | No | No | SIZE_GROUP | int | fish size goup. |
100 | No | No | BYCATCH_TYPE | varchar | Condition of bycatch if caught (1 = live, 2 = damaged/injured, 3 = other). |
100 | No | No | CAT_REMARKS | varchar | Comment field. |
100 | No | No | CAT_CREATE_TIME | datetime | When this record was created |
100 | No | No | CAT_MODIFY_TIME | datetime | When was the last date this record was editted |
100 | No | No | CAT_LOAD_TABLE | varchar | Which VFP table where this data was loaded from |
100 | No | No | CAT_LOAD_DATETIME | datetime | When this record was loade into MySQL VFP |
100 | No | No | CAT_LOAD_USER | varchar | User load the data into MySQL |
100 | No | No | SIZE_PK | int | System-generated artificial primary key. |
100 | No | No | CATCH_FK | varchar | Key link this record to its related record in C_BBS_CATCH. |
100 | No | No | LEN_MM | int | Fork length of fish in mm. |
100 | No | No | LEN_MM_TYPE | int | How len was collected (1 = actual, 2 = calculated, 3 = estimated). |
100 | No | No | KGS | decimal | Fish weight in kilograms. |
100 | No | No | KGS_TYPE | int | How weight was collected (1 = actual, 2 = calculated, 3 = estimated). |
100 | No | No | SEX | varchar | Place holder, not in used. |
100 | No | No | SIZ_CREATE_TIME | datetime | Date the record was created |
100 | No | No | SIZ_MODIFY_TIME | datetime | Date the record was last modified |
100 | No | No | SIZ_LOAD_TABLE | varchar | varchar(32) |
100 | No | No | SIZ_LOAD_DATETIME | datetime | datetime |
100 | No | No | SIZ_LOAD_USER | varchar | varchar(32) |
100 | No | No | FISHING_METHOD | varchar | Fishing method. |
100 | No | No | FISHING_AREA | varchar | Fishing area code. |
100 | No | No | PORT_NAME | varchar | Port name. |
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. |
Attribute Details
Attribute Name | INTERVIEW_PK |
---|---|
Seq. Order | 1 |
Data Storage Type | varchar |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
UID, Primary key . |
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 on which the interview was conducted (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 | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Time the interview was conducted. |
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 |
Interviewer1 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 |
Interviewer2 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 |
Order of the survey was taken. |
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 | BOATLOG_DT_FK |
---|---|
Seq. Order | 8 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Filler, not in 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 | 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 |
Code for the area fished. Detailed information can be found in C_BBS_AREA or C_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 | 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 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 | DEPTH |
---|---|
Seq. Order | 11 |
Data Storage Type | varchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bottomfishing set depth (D = deep, S = shallow, M = mixed). |
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 | WEATHER_FK |
---|---|
Seq. Order | 12 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Code for weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.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 | CLOUD_FK |
---|---|
Seq. Order | 13 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Cloud condition 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 | WIND_DIRECTION |
---|---|
Seq. Order | 14 |
Data Storage Type | varchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder, not 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 | WIND_SPEED |
---|---|
Seq. Order | 15 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Place holder, not 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 | HOURS_FISHED |
---|---|
Seq. Order | 16 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | 2 |
Status | Active |
Description |
Number of hours 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_FISHER |
---|---|
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 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 | 18 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Number of guests onboard during 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 | NUM_GEAR |
---|---|
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 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_NAME |
---|---|
Seq. Order | 20 |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the fishing vessel. |
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 | 21 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Port 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 | CAR_LICENSE |
---|---|
Seq. Order | 22 |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vehicle/trailer license 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 | TOT_NUM_KEPT_TYPE |
---|---|
Seq. Order | 23 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated). |
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_NUM_KEPT |
---|---|
Seq. Order | 24 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Total 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 | TOT_EST_KGS_TYPE |
---|---|
Seq. Order | 25 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
How TOT_EST_KGS was collected (1 = actual, 2 = calculated, 3 = estimated). |
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_KGS |
---|---|
Seq. Order | 26 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | 3 |
Status | Active |
Description |
Total fish caught in kgs for 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 | TOT_SPECIES_TYPE |
---|---|
Seq. Order | 27 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
How TOT_SPECIES was collected (1 = actual, 2 = calculated, 3 = estimated). |
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_SPECIES |
---|---|
Seq. Order | 28 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Number of species caught 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 | PERCENT_SOLD_DOCK |
---|---|
Seq. Order | 29 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 1 |
Status | Active |
Description |
Percent of catch sold at dock (to the hundredths). |
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 | PERCENT_SOLD |
---|---|
Seq. Order | 30 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 1 |
Status | Active |
Description |
Percent of catch sold (to the hundredths). |
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 | PERCENT_UNSOLD |
---|---|
Seq. Order | 31 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 1 |
Status | Active |
Description |
Percent of unsold catch. |
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 | BUYER_FK |
---|---|
Seq. Order | 32 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Filler, not in 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 | BYCATCH_F |
---|---|
Seq. Order | 33 |
Data Storage Type | varchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, this was a bycatch. |
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 | 34 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true (T), indicates chartered 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 | 35 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true (T), the boat was berthed. |
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 | SMALLCRAFT_F |
---|---|
Seq. Order | 36 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true (T), small craft advisory was in effect. |
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 | HIGHSURF_F |
---|---|
Seq. Order | 37 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, high surf warning was in effect. |
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 | 38 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true (T), the interview was non-scheduled (opportunistic). |
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 | 39 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Lunar day. Data obtained from C_LUNAR.DBF (foxpro table), based on the value of the survey date (15 = full moon, 1 or 29/30 = new moon). |
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 | 40 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
This interview is not complete (all catch from this trip was not captured on 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 | 41 |
Data Storage Type | varchar |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comment 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 | INT_CREATE_TIME |
---|---|
Seq. Order | 42 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time that the record was created or date the 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 | INT_MODIFY_TIME |
---|---|
Seq. Order | 43 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
When was the last date this record was editted |
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_USER |
---|---|
Seq. Order | 44 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Name of the user who created the 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_MODIFY_USER |
---|---|
Seq. Order | 45 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Name of the user who last modified the 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 | 46 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Which VFP table where this data 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 | 47 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
When this record was loade into MySQL VFP |
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 | 48 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User load the data into 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 | CATCH_PK |
---|---|
Seq. Order | 49 |
Data Storage Type | varchar |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary key (MySQL only) which is a unique identifier for each record in this table. Specify 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 | INTERVIEW_FK |
---|---|
Seq. Order | 50 |
Data Storage Type | varchar |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Key that link this record back to its related record found in the c_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 | 51 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Species 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 | NUM_KEPT |
---|---|
Seq. Order | 52 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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 | NUM_KEPT_TYPE |
---|---|
Seq. Order | 53 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated). |
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_KGS |
---|---|
Seq. Order | 54 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 3 |
Status | Active |
Description |
Total catch of this 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_KGS_TYPE |
---|---|
Seq. Order | 55 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
How weight was collected (1 = actual, 2 = calculated, 3 = estimated). |
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 | 56 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 2 |
Status | Active |
Description |
Place holder, not 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 | PRICE_LB_TYPE_FK |
---|---|
Seq. Order | 57 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Place holder, not 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 | SIZE_GROUP |
---|---|
Seq. Order | 58 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
fish size goup. |
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 | 59 |
Data Storage Type | varchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Condition of bycatch if caught (1 = live, 2 = damaged/injured, 3 = other). |
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 | 60 |
Data Storage Type | varchar |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comment 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 | CAT_CREATE_TIME |
---|---|
Seq. Order | 61 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
When this 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 | 62 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
When was the last date this record was editted |
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 | 63 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Which VFP table where this data 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 | 64 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
When this record was loade into MySQL VFP |
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 | 65 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User load the data into 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 | SIZE_PK |
---|---|
Seq. Order | 66 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
System-generated artificial primary key. |
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 | 67 |
Data Storage Type | varchar |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Key link this record to its related record in C_BBS_CATCH. |
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 | 68 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Fork length of fish in mm. |
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 | 69 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
How len was collected (1 = actual, 2 = calculated, 3 = estimated). |
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 | KGS |
---|---|
Seq. Order | 70 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | 3 |
Status | Active |
Description |
Fish weight in kilograms. |
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 | KGS_TYPE |
---|---|
Seq. Order | 71 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
How weight was collected (1 = actual, 2 = calculated, 3 = estimated). |
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 | SEX |
---|---|
Seq. Order | 72 |
Data Storage Type | varchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Place holder, not in 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 | SIZ_CREATE_TIME |
---|---|
Seq. Order | 73 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the 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 | SIZ_MODIFY_TIME |
---|---|
Seq. Order | 74 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the 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 | SIZ_LOAD_TABLE |
---|---|
Seq. Order | 75 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
varchar(32) |
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 | 76 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
datetime |
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 | 77 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
varchar(32) |
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 | 78 |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fishing method. |
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 | 79 |
Data Storage Type | varchar |
Max Length | 27 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 | PORT_NAME |
---|---|
Seq. Order | 80 |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Port 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 | SCIENTIFIC_NAME |
---|---|
Seq. Order | 81 |
Data Storage Type | varchar |
Max Length | 40 |
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 | 82 |
Data Storage Type | varchar |
Max Length | 25 |
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 | 83 |
Data Storage Type | varchar |
Max Length | 25 |
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 | |
---|---|
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 | 63461 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2021-01-21 00:29+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 |
---|