c_sbs_exp_vfp
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 63464
| Published / External
Created: 2021-01-21
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 5629
ID: 63464
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | c_sbs_exp_vfp |
---|---|
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 Table |
---|---|
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 | Yes | Yes | EXP_PK | varchar | Primary key created for each expansion record. |
100 | No | No | EXP_KEY2 | varchar | Primary key created to link the records found in the c_sbs_spc_r records. NOTE:Each EXP_KEY2 value records contain two Exp_PK records; thus, becareful when you link data from c_sbs_spc_r into the c_sbs_exp_r table, you will get two EXP records per each SPC record. |
100 | No | No | YEAR | int | Year of the survey date |
100 | No | No | TYPE_OF_DAY | varchar | Type of day on which the interview was conducted (1 = weekday, 2 = weekend/holiday). |
100 | No | No | AM_PM | varchar | Day (D) or night (N) expanded data stratum. |
100 | No | No | METHOD_FK | int | Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF. |
100 | No | No | SHIFT | int | shift of the stratum |
100 | No | No | SUB_SHIFT | int | No used |
100 | No | No | POOL_FLAG | varchar | CPUE calculated with pooled data, if flagged |
100 | No | No | NUM_PAR | int | The number of participation log entries for the current stratum |
100 | No | No | NUM_RUNS | int | Number of participation runs |
100 | No | No | NUM_INTERVIEW | int | Total interview, including pooled interviews. |
100 | No | No | NUM_INTERVIEW_NOPOOL | int | Total interview, without pooled interviews. |
100 | No | No | NUM_CALENDAR_DAYS | int | Number of days that expansion was done |
100 | No | No | SUM_GEAR_PAR | int | The total number of gears recorded during participation runs for the current stratum. |
100 | No | No | SUM_GEAR2_PAR | int | The total number of gears recorded during participation runs for the current stratum squared. |
100 | No | No | SUM_FISHER_PAR | int | The total number of fishers recorded during participation runs for the current stratum. |
100 | No | No | SUM_TOT_KGS | decimal | Total species weight per this stratum |
100 | No | No | SUM_TOT_KGS2 | decimal | Total species weight per this stratum squared |
100 | No | No | SUM_GEAR_HOUR | decimal | The number of gear hours represented by interviews collected for the current stratum. |
100 | No | No | SUM_GEAR_HOUR2 | decimal | The number of gear hours represented by interviews collected for the current stratum squared. |
100 | No | No | SUM_KG_GEAR_HOUR | decimal | The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum. |
100 | No | No | SUM_HOUR_INT | decimal | The number of fishing hours represented by interviews collected for the current stratum. |
100 | No | No | SUM_GEAR_INT | decimal | The total number of gears represented by interviews collected for the current stratum |
100 | No | No | SUM_FISHER_INT | int | The number of fishers represented by interviews collected for the current stratum |
100 | No | No | SUM_FISHER_HOUR_INT | decimal | The number of fisher-hours represented by interviews collected for the current stratum. |
100 | No | No | CPUE_GEAR_HOUR | decimal | CPUE (catch per gear-hours) |
100 | No | No | AVG_GEAR_PAR | decimal | Average number of gears |
100 | No | No | AVG_FISHER_PAR | decimal | Average number of fishers |
100 | No | No | EXP_HOUR | int | Expanded hours |
100 | No | No | EXP_GEAR_HOUR | decimal | Expanded Gear_Hour per stratum = AV_GR * EX_HR. |
100 | No | No | EXP_FISHER_HOUR | decimal | expanded fisher hours |
100 | No | No | EXP_TOT_KGS | decimal | Expanded kgs of the expansion stratum |
100 | No | No | VAR_EXP_TOT_KGS | decimal | Varian of expanded fish weight |
100 | No | No | VAR_AVG_GEAR | decimal | Varian of average gears |
100 | No | No | VAR_GEAR_HOUR | decimal | Varian of gear-hours CPUE |
100 | No | No | VAR_CPUE_GEAR_HOUR | decimal | Varian of gear-hours CPUE |
100 | Yes | No | STD_GEAR_HOUR | decimal | Standard deviation of gear-hours |
100 | No | No | STD_CPUE_GEAR_HOUR | decimal | Standard deviation of gear-hours CPUE |
100 | No | No | STD_EXP_TOT_KGS | decimal | Standard deviation of expanded weight |
100 | No | No | P2 | decimal | P2 adjustment percent |
100 | No | No | LOAD_TABLE | varchar | Name of the FoxPro table that was loaded into MySQL. |
100 | No | No | LOAD_DATETIME | datetime | The date and time the data was loaded in to the table |
100 | No | No | LOAD_USER | varchar | User who loaded the data to the MySQL table. |
Attribute Details
Attribute Name | EXP_PK |
---|---|
Seq. Order | 1 |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Primary key created for each expansion 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 | EXP_KEY2 |
---|---|
Seq. Order | 2 |
Data Storage Type | varchar |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary key created to link the records found in the c_sbs_spc_r records. NOTE:Each EXP_KEY2 value records contain two Exp_PK records; thus, becareful when you link data from c_sbs_spc_r into the c_sbs_exp_r table, you will get two EXP records per each SPC 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 | YEAR |
---|---|
Seq. Order | 3 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Year of the survey 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 | TYPE_OF_DAY |
---|---|
Seq. Order | 4 |
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 (1 = weekday, 2 = 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 | AM_PM |
---|---|
Seq. Order | 5 |
Data Storage Type | varchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Day (D) or night (N) expanded data stratum. |
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 | 6 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SHIFT |
---|---|
Seq. Order | 7 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
shift of the stratum |
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 | SUB_SHIFT |
---|---|
Seq. Order | 8 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
No 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 | POOL_FLAG |
---|---|
Seq. Order | 9 |
Data Storage Type | varchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
CPUE calculated with pooled data, if flagged |
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_PAR |
---|---|
Seq. Order | 10 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The number of participation log entries for the current stratum |
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_RUNS |
---|---|
Seq. Order | 11 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Number of participation runs |
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_INTERVIEW |
---|---|
Seq. Order | 12 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Total interview, including pooled interviews. |
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_INTERVIEW_NOPOOL |
---|---|
Seq. Order | 13 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Total interview, without pooled interviews. |
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_CALENDAR_DAYS |
---|---|
Seq. Order | 14 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Number of days that expansion was done |
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 | SUM_GEAR_PAR |
---|---|
Seq. Order | 15 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The total number of gears recorded during participation runs for the current stratum. |
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 | SUM_GEAR2_PAR |
---|---|
Seq. Order | 16 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The total number of gears recorded during participation runs for the current stratum squared. |
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 | SUM_FISHER_PAR |
---|---|
Seq. Order | 17 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The total number of fishers recorded during participation runs for the current stratum. |
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 | SUM_TOT_KGS |
---|---|
Seq. Order | 18 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 4 |
Status | Active |
Description |
Total species weight per this stratum |
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 | SUM_TOT_KGS2 |
---|---|
Seq. Order | 19 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | 4 |
Status | Active |
Description |
Total species weight per this stratum squared |
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 | SUM_GEAR_HOUR |
---|---|
Seq. Order | 20 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 5 |
Status | Active |
Description |
The number of gear hours represented by interviews collected for the current stratum. |
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 | SUM_GEAR_HOUR2 |
---|---|
Seq. Order | 21 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 14 |
Scale | 5 |
Status | Active |
Description |
The number of gear hours represented by interviews collected for the current stratum squared. |
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 | SUM_KG_GEAR_HOUR |
---|---|
Seq. Order | 22 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 14 |
Scale | 5 |
Status | Active |
Description |
The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum. |
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 | SUM_HOUR_INT |
---|---|
Seq. Order | 23 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 1 |
Status | Active |
Description |
The number of fishing hours represented by interviews collected for the current stratum. |
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 | SUM_GEAR_INT |
---|---|
Seq. Order | 24 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 1 |
Status | Active |
Description |
The total number of gears represented by interviews collected for the current stratum |
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 | SUM_FISHER_INT |
---|---|
Seq. Order | 25 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The number of fishers represented by interviews collected for the current stratum |
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 | SUM_FISHER_HOUR_INT |
---|---|
Seq. Order | 26 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 2 |
Status | Active |
Description |
The number of fisher-hours represented by interviews collected for the current stratum. |
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 | CPUE_GEAR_HOUR |
---|---|
Seq. Order | 27 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 4 |
Status | Active |
Description |
CPUE (catch per gear-hours) |
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 | AVG_GEAR_PAR |
---|---|
Seq. Order | 28 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 4 |
Status | Active |
Description |
Average number of gears |
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 | AVG_FISHER_PAR |
---|---|
Seq. Order | 29 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 4 |
Status | Active |
Description |
Average number of fishers |
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 | EXP_HOUR |
---|---|
Seq. Order | 30 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Expanded hours |
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 | EXP_GEAR_HOUR |
---|---|
Seq. Order | 31 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 2 |
Status | Active |
Description |
Expanded Gear_Hour per stratum = AV_GR * EX_HR. |
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 | EXP_FISHER_HOUR |
---|---|
Seq. Order | 32 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 2 |
Status | Active |
Description |
expanded fisher hours |
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 | EXP_TOT_KGS |
---|---|
Seq. Order | 33 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | 2 |
Status | Active |
Description |
Expanded kgs of the expansion stratum |
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 | VAR_EXP_TOT_KGS |
---|---|
Seq. Order | 34 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 14 |
Scale | 4 |
Status | Active |
Description |
Varian of expanded 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 | VAR_AVG_GEAR |
---|---|
Seq. Order | 35 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | 4 |
Status | Active |
Description |
Varian of average gears |
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 | VAR_GEAR_HOUR |
---|---|
Seq. Order | 36 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | 4 |
Status | Active |
Description |
Varian of gear-hours CPUE |
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 | VAR_CPUE_GEAR_HOUR |
---|---|
Seq. Order | 37 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 15 |
Scale | 4 |
Status | Active |
Description |
Varian of gear-hours CPUE |
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 | STD_GEAR_HOUR |
---|---|
Seq. Order | 38 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 6 |
Scale | 1 |
Status | Active |
Description |
Standard deviation of gear-hours |
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 | STD_CPUE_GEAR_HOUR |
---|---|
Seq. Order | 39 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 1 |
Status | Active |
Description |
Standard deviation of gear-hours CPUE |
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 | STD_EXP_TOT_KGS |
---|---|
Seq. Order | 40 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 1 |
Status | Active |
Description |
Standard deviation of expanded 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 | P2 |
---|---|
Seq. Order | 41 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 4 |
Status | Active |
Description |
P2 adjustment percent |
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 | LOAD_TABLE |
---|---|
Seq. Order | 42 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the FoxPro table that was loaded 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 | LOAD_DATETIME |
---|---|
Seq. Order | 43 |
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 |
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 | LOAD_USER |
---|---|
Seq. Order | 44 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User who loaded the data to the MySQL table. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » 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 | 63464 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2021-01-21 00:49+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 |
---|