Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > American Samoa Commercial Purchases >

a_cl_flat_view

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63476  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
INVOICE_PK
int 		Unique invoice number. Primary key, a unique identifier—the invoice number—for each record in a_ccl_head table.
INVOICE_DATE
date 		Date invoice was completed by buyer.
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.
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.
RESALE_F
char 		If true, this sale is a resale (not a locally caught fish purchased directly from fishers).
IMPORTED_F
char 		Indicates whether this fish is imported. If true, the fish is imported.
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.
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.
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.
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.
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.
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.
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.
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.
BOOK_FK
int 		Invoice book number. Detailed information can be found in A_CCL_BOOK or in ACLBOOK.DBF.
HEAD_REMARKS
varchar 		Header comment field.
HEAD_CREATE_TIME
datetime 		Date and time the header record was created.
HEAD_MODIFY_TIME
datetime 		Date and time the header record was last modified.
HEAD_LOAD_TABLE
varchar 		Name of the header FoxPro table that was loaded into MySQL.
HEAD_DATETIME
datetime 		Date and time header record migrated from FoxPro to MySQL.
HEAD_LOAD_USER
varchar 		User who loaded record into the header MySQL table.
DETAIL_PK
int 		System-generated artificial primary key for detail table.
INVOICE_FK
int 		Same as INVOICE_PK column. Used to link detail to header table.
SPECIES_FK
int 		Code for the species recorded on the invoice. Detailed information can be found in A_SPECIES or A_SPEC.DBF.
PRICE_PER_LB
decimal 		Price per pound paid by the buyer for a species, calculated as (SOLD_REVENUE/SOLD_LBS).
SOLD_LBS
decimal 		Total weight of this species reported on this invoice.
SOLD_REVENUE
decimal 		Total price paid by the buyer for a species.
NUM_PIECES
int 		Total count of a particular species purchased. A value of 0 indicates an unknown number for this species.
DETAIL_REMARKS
varchar 		Detail comment field.
DETAIL_CREATE_TIME
datetime 		Date and time the detail record was created.
DETAIL_MODIFY_TIME
datetime 		Date and time the detail record was last modified.
DETAIL_LOAD_TABLE
varchar 		Name of the detail FoxPro table that was loaded into MySQL.
DETAIL_DATETIME
datetime 		Date and time detail record migrated from FoxPro to MySQL.
DETAIL_LOAD_USER
varchar 		User who loaded record into the detail MySQL table.
FISHING_METHOD
varchar 		Name of fishing method linked to METHOD_FK.
FISHING_AREA
varchar 		Name of fishing area linked to AREA_FK.
VESSEL_REGIST_NO
varchar 		Vessel registration number linked to VESSEL_FK.
BUYER_NAME
varchar 		Name of buyer linked to BUYER_FK.
ISLAND_NAME
varchar 		Name of island linked to ISLAND_FK.
FISHER_NAME
varchar 		Name of fisher linked to FISHER_FK.
SCIENTIFIC_NAME
varchar 		Scientific name of the species (Genus name + Species name).
COMMON_NAME
varchar 		Common English name for the species.
LOCAL_NAME
varchar 		Local name of the species.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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

CC ID: 1008444
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

CC ID: 1008445
Seq. Order: 2
Data Storage Type: date
Required: No
Primary Key: No
Status: Active
Description:

Date invoice was completed by buyer.

FISHER_FK

CC ID: 1008446
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

CC ID: 1008447
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

CC ID: 1008448
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

CC ID: 1008449
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

CC ID: 1008450
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

CC ID: 1008451
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

CC ID: 1008452
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

CC ID: 1008453
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

CC ID: 1008454
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

CC ID: 1008455
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

CC ID: 1008456
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

CC ID: 1008457
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

CC ID: 1008458
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

CC ID: 1008459
Seq. Order: 16
Data Storage Type: varchar
Max Length: 256
Required: No
Primary Key: No
Status: Active
Description:

Header comment field.

HEAD_CREATE_TIME

CC ID: 1008460
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

CC ID: 1008461
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

CC ID: 1008462
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

CC ID: 1008463
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

CC ID: 1008464
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

CC ID: 1008465
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

CC ID: 1008466
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

CC ID: 1008467
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

CC ID: 1008468
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

CC ID: 1008469
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

CC ID: 1008470
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

CC ID: 1008471
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

CC ID: 1008472
Seq. Order: 29
Data Storage Type: varchar
Max Length: 256
Required: No
Primary Key: No
Status: Active
Description:

Detail comment field.

DETAIL_CREATE_TIME

CC ID: 1008473
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

CC ID: 1008474
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

CC ID: 1008475
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

CC ID: 1008476
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

CC ID: 1008477
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

CC ID: 1008478
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

CC ID: 1008479
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

CC ID: 1008480
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

CC ID: 1008481
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

CC ID: 1008482
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

CC ID: 1008483
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

CC ID: 1008484
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

CC ID: 1008485
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

CC ID: 1008486
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