a_cl_flat_view
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:63476 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | a_cl_flat_view |
---|---|
Status: | Completed |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | amsam_dmwr_wh |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
INVOICE_PK | int | Unique invoice number. Primary key, a unique identifier—the invoice number—for each record in a_ccl_head table. | |
100
|
INVOICE_DATE | date | Date invoice was completed by buyer. | |
100
|
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
|
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
|
RESALE_F | char | If true, this sale is a resale (not a locally caught fish purchased directly from fishers). | |
100
|
IMPORTED_F | char | Indicates whether this fish is imported. If true, the fish is imported. | |
100
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
BOOK_FK | int | Invoice book number. Detailed information can be found in A_CCL_BOOK or in ACLBOOK.DBF. | |
100
|
HEAD_REMARKS | varchar | Header comment field. | |
100
|
HEAD_CREATE_TIME | datetime | Date and time the header record was created. | |
100
|
HEAD_MODIFY_TIME | datetime | Date and time the header record was last modified. | |
100
|
HEAD_LOAD_TABLE | varchar | Name of the header FoxPro table that was loaded into MySQL. | |
100
|
HEAD_DATETIME | datetime | Date and time header record migrated from FoxPro to MySQL. | |
100
|
HEAD_LOAD_USER | varchar | User who loaded record into the header MySQL table. | |
100
|
DETAIL_PK | int | System-generated artificial primary key for detail table. | |
100
|
INVOICE_FK | int | Same as INVOICE_PK column. Used to link detail to header table. | |
100
|
SPECIES_FK | int | Code for the species recorded on the invoice. Detailed information can be found in A_SPECIES or A_SPEC.DBF. | |
100
|
PRICE_PER_LB | decimal | Price per pound paid by the buyer for a species, calculated as (SOLD_REVENUE/SOLD_LBS). | |
100
|
SOLD_LBS | decimal | Total weight of this species reported on this invoice. | |
100
|
SOLD_REVENUE | decimal | Total price paid by the buyer for a species. | |
100
|
NUM_PIECES | int | Total count of a particular species purchased. A value of 0 indicates an unknown number for this species. | |
100
|
DETAIL_REMARKS | varchar | Detail comment field. | |
100
|
DETAIL_CREATE_TIME | datetime | Date and time the detail record was created. | |
100
|
DETAIL_MODIFY_TIME | datetime | Date and time the detail record was last modified. | |
100
|
DETAIL_LOAD_TABLE | varchar | Name of the detail FoxPro table that was loaded into MySQL. | |
100
|
DETAIL_DATETIME | datetime | Date and time detail record migrated from FoxPro to MySQL. | |
100
|
DETAIL_LOAD_USER | varchar | User who loaded record into the detail MySQL table. | |
100
|
FISHING_METHOD | varchar | Name of fishing method linked to METHOD_FK. | |
100
|
FISHING_AREA | varchar | Name of fishing area linked to AREA_FK. | |
100
|
VESSEL_REGIST_NO | varchar | Vessel registration number linked to VESSEL_FK. | |
100
|
BUYER_NAME | varchar | Name of buyer linked to BUYER_FK. | |
100
|
ISLAND_NAME | varchar | Name of island linked to ISLAND_FK. | |
100
|
FISHER_NAME | varchar | Name of fisher linked to FISHER_FK. | |
100
|
SCIENTIFIC_NAME | varchar | Scientific name of the species (Genus name + Species name). | |
100
|
COMMON_NAME | varchar | Common English name for the species. | |
100
|
LOCAL_NAME | varchar | Local name of the species. |
Attribute Details
INVOICE_PK
Seq. Order: | 1 |
---|---|
Data Storage Type: | int |
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. |
INVOICE_DATE
Seq. Order: | 2 |
---|---|
Data Storage Type: | date |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date invoice was completed by buyer. |
FISHER_FK
Seq. Order: | 3 |
---|---|
Data Storage Type: | int |
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. |
ISLAND_FK
Seq. Order: | 4 |
---|---|
Data Storage Type: | varchar |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
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. |
RESALE_F
Seq. Order: | 5 |
---|---|
Data Storage Type: | char |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If true, this sale is a resale (not a locally caught fish purchased directly from fishers). |
IMPORTED_F
Seq. Order: | 6 |
---|---|
Data Storage Type: | char |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates whether this fish is imported. If true, the fish is imported. |
CANNERY_F
Seq. Order: | 7 |
---|---|
Data Storage Type: | char |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
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. |
IMPORT_FROM
Seq. Order: | 8 |
---|---|
Data Storage Type: | int |
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. |
VESSEL_FK
Seq. Order: | 9 |
---|---|
Data Storage Type: | int |
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. |
AREA_FK
Seq. Order: | 10 |
---|---|
Data Storage Type: | int |
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. |
BUYER_FK
Seq. Order: | 11 |
---|---|
Data Storage Type: | int |
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. |
METHOD_FK
Seq. Order: | 12 |
---|---|
Data Storage Type: | int |
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. |
TOTAL_VALUE
Seq. Order: | 13 |
---|---|
Data Storage Type: | decimal |
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. |
TOTAL_POUNDS
Seq. Order: | 14 |
---|---|
Data Storage Type: | decimal |
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. |
BOOK_FK
Seq. Order: | 15 |
---|---|
Data Storage Type: | int |
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. |
HEAD_REMARKS
Seq. Order: | 16 |
---|---|
Data Storage Type: | varchar |
Max Length: | 256 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Header comment field. |
HEAD_CREATE_TIME
Seq. Order: | 17 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time the header record was created. |
HEAD_MODIFY_TIME
Seq. Order: | 18 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time the header record was last modified. |
HEAD_LOAD_TABLE
Seq. Order: | 19 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the header FoxPro table that was loaded into MySQL. |
HEAD_DATETIME
Seq. Order: | 20 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time header record migrated from FoxPro to MySQL. |
HEAD_LOAD_USER
Seq. Order: | 21 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User who loaded record into the header MySQL table. |
DETAIL_PK
Seq. Order: | 22 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
System-generated artificial primary key for detail table. |
INVOICE_FK
Seq. Order: | 23 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Same as INVOICE_PK column. Used to link detail to header table. |
SPECIES_FK
Seq. Order: | 24 |
---|---|
Data Storage Type: | int |
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. |
PRICE_PER_LB
Seq. Order: | 25 |
---|---|
Data Storage Type: | decimal |
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). |
SOLD_LBS
Seq. Order: | 26 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 2 |
Status: | Active |
Description: |
Total weight of this species reported on this invoice. |
SOLD_REVENUE
Seq. Order: | 27 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 2 |
Status: | Active |
Description: |
Total price paid by the buyer for a species. |
NUM_PIECES
Seq. Order: | 28 |
---|---|
Data Storage Type: | int |
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. |
DETAIL_REMARKS
Seq. Order: | 29 |
---|---|
Data Storage Type: | varchar |
Max Length: | 256 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Detail comment field. |
DETAIL_CREATE_TIME
Seq. Order: | 30 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time the detail record was created. |
DETAIL_MODIFY_TIME
Seq. Order: | 31 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time the detail record was last modified. |
DETAIL_LOAD_TABLE
Seq. Order: | 32 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the detail FoxPro table that was loaded into MySQL. |
DETAIL_DATETIME
Seq. Order: | 33 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time detail record migrated from FoxPro to MySQL. |
DETAIL_LOAD_USER
Seq. Order: | 34 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User who loaded record into the detail MySQL table. |
FISHING_METHOD
Seq. Order: | 35 |
---|---|
Data Storage Type: | varchar |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of fishing method linked to METHOD_FK. |
FISHING_AREA
Seq. Order: | 36 |
---|---|
Data Storage Type: | varchar |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of fishing area linked to AREA_FK. |
VESSEL_REGIST_NO
Seq. Order: | 37 |
---|---|
Data Storage Type: | varchar |
Max Length: | 11 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Vessel registration number linked to VESSEL_FK. |
BUYER_NAME
Seq. Order: | 38 |
---|---|
Data Storage Type: | varchar |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of buyer linked to BUYER_FK. |
ISLAND_NAME
Seq. Order: | 39 |
---|---|
Data Storage Type: | varchar |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of island linked to ISLAND_FK. |
FISHER_NAME
Seq. Order: | 40 |
---|---|
Data Storage Type: | varchar |
Max Length: | 33 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of fisher linked to FISHER_FK. |
SCIENTIFIC_NAME
Seq. Order: | 41 |
---|---|
Data Storage Type: | varchar |
Max Length: | 73 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name of the species (Genus name + Species name). |
COMMON_NAME
Seq. Order: | 42 |
---|---|
Data Storage Type: | varchar |
Max Length: | 46 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common English name for the species. |
LOCAL_NAME
Seq. Order: | 43 |
---|---|
Data Storage Type: | varchar |
Max Length: | 46 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local name of the species. |
Catalog Details
Catalog Item ID: | 63476 |
---|---|
GUID: | gov.noaa.nmfs.inport: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 Last Review Date: | 2021-01-21 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-01-21 |