a_cl_flat_view
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 63476
| Published / External
Created: 2021-01-21
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 5615
ID: 63476
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | a_cl_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 | INVOICE_PK | int | Unique invoice number. Primary key, a unique identifier—the invoice number—for each record in a_ccl_head table. |
100 | No | No | INVOICE_DATE | date | Date invoice was completed by buyer. |
100 | No | No | FISHER_FK | int | Code for the fisher who caught the fish reported on the invoice. Detailed information can be found in A_FISHER or A_FISHER.DBF. |
100 | No | No | ISLAND_FK | varchar | Code for the island where the fish was caught if locally caught, this value can be “Tutuila” (TTL), 'Ofu,' “Olosega,” “Tau” or blank for non-locally caught fish. |
100 | No | No | RESALE_F | char | If true, this sale is a resale (not a locally caught fish purchased directly from fishers). |
100 | No | No | IMPORTED_F | char | Indicates whether this fish is imported. If true, the fish is imported. |
100 | No | No | CANNERY_F | char | Indicates whether this fish was purchased from the cannery or not. If true, it is a non-local fish purchased from the cannery. |
100 | No | No | IMPORT_FROM | int | If the fish was imported, the area code where it came from. Detailed information can be found in A_AREA or A_AREA.DBF. |
100 | No | No | VESSEL_FK | int | Code number of the vessel used to catch the fish reported on invoice. Detailed information can be found in A_VESSEL_HISTORY or A_MASTVSSL.DBF. |
100 | No | No | AREA_FK | int | Code number of the area where fish reported on the invoice were caught. If fish are purchased or imported and the METHOD is 18, then this code refers to where the fish was purchased or imported from. Detailed information can be found in A_AREA or A_AREA.DBF. |
100 | No | No | BUYER_FK | int | Code number of the buyer who bought the fish reported on the invoice. This field duplicates the BUYER field in A_CCL_BOOK or ACLBOOK.DBF. Detailed information can be found in A_BUYER or A_BUYER.DBF. |
100 | No | No | METHOD_FK | int | Code number of the method used to catch the fish reported on this invoice. A value of 18 denotes that the fish were purchased or imported from another area indicated in the AREA_FK or AREA_FISH field. Detailed information can be found in A_METHOD or A_METHOD.DBF. |
100 | No | No | TOTAL_VALUE | decimal | Total price paid by the buyer for all fish reported on invoice. This is the sum of the SOLD_REVENUE fields in A_CCL_DETAIL. |
100 | No | No | TOTAL_POUNDS | decimal | Total weight of all fish purchased by buyer and reported on the invoice. This is the sum of the SOLD_LBS field in the A_CCL_DETAIL. |
100 | No | No | BOOK_FK | int | Invoice book number. Detailed information can be found in A_CCL_BOOK or in ACLBOOK.DBF. |
100 | No | No | HEAD_REMARKS | varchar | Header comment field. |
100 | No | No | HEAD_CREATE_TIME | datetime | Date and time the header record was created. |
100 | No | No | HEAD_MODIFY_TIME | datetime | Date and time the header record was last modified. |
100 | No | No | HEAD_LOAD_TABLE | varchar | Name of the header FoxPro table that was loaded into MySQL. |
100 | No | No | HEAD_DATETIME | datetime | Date and time header record migrated from FoxPro to MySQL. |
100 | No | No | HEAD_LOAD_USER | varchar | User who loaded record into the header MySQL table. |
100 | No | No | DETAIL_PK | int | System-generated artificial primary key for detail table. |
100 | No | No | INVOICE_FK | int | Same as INVOICE_PK column. Used to link detail to header table. |
100 | No | No | SPECIES_FK | int | Code for the species recorded on the invoice. Detailed information can be found in A_SPECIES or A_SPEC.DBF. |
100 | No | No | PRICE_PER_LB | decimal | Price per pound paid by the buyer for a species, calculated as (SOLD_REVENUE/SOLD_LBS). |
100 | No | No | SOLD_LBS | decimal | Total weight of this species reported on this invoice. |
100 | No | No | SOLD_REVENUE | decimal | Total price paid by the buyer for a species. |
100 | No | No | NUM_PIECES | int | Total count of a particular species purchased. A value of 0 indicates an unknown number for this species. |
100 | No | No | DETAIL_REMARKS | varchar | Detail comment field. |
100 | No | No | DETAIL_CREATE_TIME | datetime | Date and time the detail record was created. |
100 | No | No | DETAIL_MODIFY_TIME | datetime | Date and time the detail record was last modified. |
100 | No | No | DETAIL_LOAD_TABLE | varchar | Name of the detail FoxPro table that was loaded into MySQL. |
100 | No | No | DETAIL_DATETIME | datetime | Date and time detail record migrated from FoxPro to MySQL. |
100 | No | No | DETAIL_LOAD_USER | varchar | User who loaded record into the detail MySQL table. |
100 | No | No | FISHING_METHOD | varchar | Name of fishing method linked to METHOD_FK. |
100 | No | No | FISHING_AREA | varchar | Name of fishing area linked to AREA_FK. |
100 | No | No | VESSEL_REGIST_NO | varchar | Vessel registration number linked to VESSEL_FK. |
100 | No | No | BUYER_NAME | varchar | Name of buyer linked to BUYER_FK. |
100 | No | No | ISLAND_NAME | varchar | Name of island linked to ISLAND_FK. |
100 | No | No | FISHER_NAME | varchar | Name of fisher linked to FISHER_FK. |
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 | INVOICE_PK |
---|---|
Seq. Order | 1 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Unique invoice number. Primary key, a unique identifier—the invoice number—for each record in a_ccl_head 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 | INVOICE_DATE |
---|---|
Seq. Order | 2 |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date invoice was completed by buyer. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISHER_FK |
---|---|
Seq. Order | 3 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Code for the fisher who caught the fish reported on the invoice. Detailed information can be found in A_FISHER or A_FISHER.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 | ISLAND_FK |
---|---|
Seq. Order | 4 |
Data Storage Type | varchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the island where the fish was caught if locally caught, this value can be “Tutuila” (TTL), 'Ofu,' “Olosega,” “Tau” or blank for non-locally caught fish. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RESALE_F |
---|---|
Seq. Order | 5 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If true, this sale is a resale (not a locally caught fish purchased directly from 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 | IMPORTED_F |
---|---|
Seq. Order | 6 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether this fish is imported. If true, the fish is imported. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CANNERY_F |
---|---|
Seq. Order | 7 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether this fish was purchased from the cannery or not. If true, it is a non-local fish purchased from the cannery. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | IMPORT_FROM |
---|---|
Seq. Order | 8 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
If the fish was imported, the area code where it came from. Detailed information can be found in A_AREA or A_AREA.DBF. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_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 number of the vessel used to catch the fish reported on invoice. 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 | AREA_FK |
---|---|
Seq. Order | 10 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Code number of the area where fish reported on the invoice were caught. If fish are purchased or imported and the METHOD is 18, then this code refers to where the fish was purchased or imported from. Detailed information can be found in A_AREA or A_AREA.DBF. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BUYER_FK |
---|---|
Seq. Order | 11 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Code number of the buyer who bought the fish reported on the invoice. This field duplicates the BUYER field in A_CCL_BOOK or ACLBOOK.DBF. Detailed information can be found in A_BUYER or A_BUYER.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 | 12 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Code number of the method used to catch the fish reported on this invoice. A value of 18 denotes that the fish were purchased or imported from another area indicated in the AREA_FK or AREA_FISH field. Detailed information can be found in A_METHOD or A_METHOD.DBF. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_VALUE |
---|---|
Seq. Order | 13 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 16 |
Scale | 2 |
Status | Active |
Description |
Total price paid by the buyer for all fish reported on invoice. This is the sum of the SOLD_REVENUE fields in A_CCL_DETAIL. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_POUNDS |
---|---|
Seq. Order | 14 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 16 |
Scale | 2 |
Status | Active |
Description |
Total weight of all fish purchased by buyer and reported on the invoice. This is the sum of the SOLD_LBS field in the A_CCL_DETAIL. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BOOK_FK |
---|---|
Seq. Order | 15 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Invoice book number. Detailed information can be found in A_CCL_BOOK or in ACLBOOK.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 | HEAD_REMARKS |
---|---|
Seq. Order | 16 |
Data Storage Type | varchar |
Max Length | 256 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Header 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 | HEAD_CREATE_TIME |
---|---|
Seq. Order | 17 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the header 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 | HEAD_MODIFY_TIME |
---|---|
Seq. Order | 18 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the header 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 | HEAD_LOAD_TABLE |
---|---|
Seq. Order | 19 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the header 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 | HEAD_DATETIME |
---|---|
Seq. Order | 20 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time header record migrated from FoxPro to 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 | HEAD_LOAD_USER |
---|---|
Seq. Order | 21 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User who loaded record into the header 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 | DETAIL_PK |
---|---|
Seq. Order | 22 |
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 for detail 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 | INVOICE_FK |
---|---|
Seq. Order | 23 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Same as INVOICE_PK column. Used to link detail to header 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 | SPECIES_FK |
---|---|
Seq. Order | 24 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Code for the species recorded on the invoice. Detailed information can be found in A_SPECIES or A_SPEC.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 | PRICE_PER_LB |
---|---|
Seq. Order | 25 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 2 |
Status | Active |
Description |
Price per pound paid by the buyer for a species, calculated as (SOLD_REVENUE/SOLD_LBS). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SOLD_LBS |
---|---|
Seq. Order | 26 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 2 |
Status | Active |
Description |
Total weight of this species reported on this invoice. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SOLD_REVENUE |
---|---|
Seq. Order | 27 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 2 |
Status | Active |
Description |
Total price paid by the buyer for 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 | NUM_PIECES |
---|---|
Seq. Order | 28 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Total count of a particular species purchased. A value of 0 indicates an unknown number for 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 | DETAIL_REMARKS |
---|---|
Seq. Order | 29 |
Data Storage Type | varchar |
Max Length | 256 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Detail 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 | DETAIL_CREATE_TIME |
---|---|
Seq. Order | 30 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the detail 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 | DETAIL_MODIFY_TIME |
---|---|
Seq. Order | 31 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time the detail 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 | DETAIL_LOAD_TABLE |
---|---|
Seq. Order | 32 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the detail 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 | DETAIL_DATETIME |
---|---|
Seq. Order | 33 |
Data Storage Type | datetime |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time detail record migrated from FoxPro to 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 | DETAIL_LOAD_USER |
---|---|
Seq. Order | 34 |
Data Storage Type | varchar |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User who loaded record into the detail 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 | FISHING_METHOD |
---|---|
Seq. Order | 35 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of fishing method linked to METHOD_FK. |
General Data Type | |
Unit of 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 | 36 |
Data Storage Type | varchar |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of fishing area linked to AREA_FK. |
General Data Type | |
Unit of 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 | 37 |
Data Storage Type | varchar |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vessel registration number linked to VESSEL_FK. |
General Data Type | |
Unit of 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_NAME |
---|---|
Seq. Order | 38 |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of buyer linked to BUYER_FK. |
General Data Type | |
Unit of 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 | 39 |
Data Storage Type | varchar |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of island linked to ISLAND_FK. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISHER_NAME |
---|---|
Seq. Order | 40 |
Data Storage Type | varchar |
Max Length | 33 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of fisher linked to FISHER_FK. |
General Data Type | |
Unit of 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 | 41 |
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 | 42 |
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 | 43 |
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 | |
---|---|
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 | 63476 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2021-01-21 01:28+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 |
---|