g_cl_flat_view
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:63470 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | g_cl_flat_view |
---|---|
Status: | Completed |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | guam_dawr_wh |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
GCL_HD_PK | varchar | Primary key for header table created by concatenating invoice year and invoice number. | |
100
|
INVOICE | int | Invoice number that uniquely identifies and invoice. | |
100
|
INCOMPLETE_F | char | If true, this invoice is not complete. | |
100
|
INVOICE_DATE | date | Invoice date. | |
100
|
BUYER_FK | int | Code of the fish buyer. Detailed information can be found in G_GCL_BUYER or G_BUYER.DBF. | |
100
|
FISHER_FK | int | Code of the fisher. Detailed information can be found in G_GCL_FISHER or G_FISHER.DBF. | |
100
|
HOURS_FISHED | decimal | Number of hours fished. | |
100
|
NUM_FISHER | int | Number of fishermen fishing. | |
100
|
AREA1_FK | int | General location code of fish caught (applies to whole invoice). Detailed information can be found in G_GCL_AREA or G_AREA.DBF. | |
100
|
AREA2_FK | int | General location code # 2. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. | |
100
|
AREA3_FK | int | General location code # 3. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. | |
100
|
AREA4_FK | int | General location code # 4. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. | |
100
|
AREA5_FK | int | General location code # 5. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. | |
100
|
RESALE_F | char | If true (T), indicates this is a resale invoice. | |
100
|
REMARK1 | varchar | Comment field. | |
100
|
REMARK2 | varchar | Comment field. | |
100
|
REMARK3 | varchar | Comment field. | |
100
|
TOT_LBS | decimal | Total weight of all species on invoice. | |
100
|
TOT_SOLD_REVENUE | decimal | Total pirce paid for all species on invoice. | |
100
|
HEAD_CREATE_TIME | datetime | Date and time the header record was created. | |
100
|
HEAD_CREATE_USER | varchar | Name of the user who created the header record. | |
100
|
HEAD_MODIFY_TIME | datetime | Date and time the header record was last modified. | |
100
|
HEAD_MODIFY_USER | varchar | Name of the user who last modified the header record. | |
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
|
GCL_DT_PK | int | System-generated artificial primary key for detail table. | |
100
|
GCL_HD_FK | varchar | Same as GCL_HD_PK column. Used to link detail to header table. | |
100
|
SPECIES_FK | int | Numeric code for the species. Detailed information can be found in G_GCL_SPECIES or G_SPEC.DBF. | |
100
|
METHOD_FK | int | Numeric code for the fishing method. Detailed information can be found in G_GCL_METHOD or G_METHOD.DBF. | |
100
|
NUM_SOLD | decimal | Number of pieces of a species sold. | |
100
|
LBS_SOLD | decimal | Number of pounds of a species sold. | |
100
|
PRICE_PER_LB | decimal | Price per pound of a species. | |
100
|
SOLD_REVENUE | decimal | Total price paid by the buyer for a species. | |
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
|
BUYER_NAME | varchar | Name of buyer linked to BUYER_FK. | |
100
|
FISHER_NAME | varchar | Name of fisher linked to FISHER_FK. | |
100
|
METHOD_NAME | varchar | Name of fishing method linked to METHOD_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
GCL_HD_PK
Seq. Order: | 1 |
---|---|
Data Storage Type: | varchar |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary key for header table created by concatenating invoice year and invoice number. |
INVOICE
Seq. Order: | 2 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Invoice number that uniquely identifies and invoice. |
INCOMPLETE_F
Seq. Order: | 3 |
---|---|
Data Storage Type: | char |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If true, this invoice is not complete. |
INVOICE_DATE
Seq. Order: | 4 |
---|---|
Data Storage Type: | date |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Invoice date. |
BUYER_FK
Seq. Order: | 5 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code of the fish buyer. Detailed information can be found in G_GCL_BUYER or G_BUYER.DBF. |
FISHER_FK
Seq. Order: | 6 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code of the fisher. Detailed information can be found in G_GCL_FISHER or G_FISHER.DBF. |
HOURS_FISHED
Seq. Order: | 7 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 7 |
Scale: | 2 |
Status: | Active |
Description: |
Number of hours fished. |
NUM_FISHER
Seq. Order: | 8 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Number of fishermen fishing. |
AREA1_FK
Seq. Order: | 9 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
General location code of fish caught (applies to whole invoice). Detailed information can be found in G_GCL_AREA or G_AREA.DBF. |
AREA2_FK
Seq. Order: | 10 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
General location code # 2. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. |
AREA3_FK
Seq. Order: | 11 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
General location code # 3. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. |
AREA4_FK
Seq. Order: | 12 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
General location code # 4. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. |
AREA5_FK
Seq. Order: | 13 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
General location code # 5. Detailed information can be found in G_GCL_AREA or G_AREA.DBF. |
RESALE_F
Seq. Order: | 14 |
---|---|
Data Storage Type: | char |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If true (T), indicates this is a resale invoice. |
REMARK1
Seq. Order: | 15 |
---|---|
Data Storage Type: | varchar |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comment field. |
REMARK2
Seq. Order: | 16 |
---|---|
Data Storage Type: | varchar |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comment field. |
REMARK3
Seq. Order: | 17 |
---|---|
Data Storage Type: | varchar |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comment field. |
TOT_LBS
Seq. Order: | 18 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 12 |
Scale: | 2 |
Status: | Active |
Description: |
Total weight of all species on invoice. |
TOT_SOLD_REVENUE
Seq. Order: | 19 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 12 |
Scale: | 2 |
Status: | Active |
Description: |
Total pirce paid for all species on invoice. |
HEAD_CREATE_TIME
Seq. Order: | 20 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time the header record was created. |
HEAD_CREATE_USER
Seq. Order: | 21 |
---|---|
Data Storage Type: | varchar |
Max Length: | 35 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the user who created the header record. |
HEAD_MODIFY_TIME
Seq. Order: | 22 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time the header record was last modified. |
HEAD_MODIFY_USER
Seq. Order: | 23 |
---|---|
Data Storage Type: | varchar |
Max Length: | 35 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the user who last modified the header record. |
HEAD_LOAD_TABLE
Seq. Order: | 24 |
---|---|
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: | 25 |
---|---|
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: | 26 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User who loaded record into the header MySQL table. |
GCL_DT_PK
Seq. Order: | 27 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
System-generated artificial primary key for detail table. |
GCL_HD_FK
Seq. Order: | 28 |
---|---|
Data Storage Type: | varchar |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Same as GCL_HD_PK column. Used to link detail to header table. |
SPECIES_FK
Seq. Order: | 29 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Numeric code for the species. Detailed information can be found in G_GCL_SPECIES or G_SPEC.DBF. |
METHOD_FK
Seq. Order: | 30 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Numeric code for the fishing method. Detailed information can be found in G_GCL_METHOD or G_METHOD.DBF. |
NUM_SOLD
Seq. Order: | 31 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Number of pieces of a species sold. |
LBS_SOLD
Seq. Order: | 32 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 2 |
Status: | Active |
Description: |
Number of pounds of a species sold. |
PRICE_PER_LB
Seq. Order: | 33 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Price per pound of a species. |
SOLD_REVENUE
Seq. Order: | 34 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Total price paid by the buyer for a species. |
DETAIL_CREATE_TIME
Seq. Order: | 35 |
---|---|
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: | 36 |
---|---|
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: | 37 |
---|---|
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: | 38 |
---|---|
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: | 39 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User who loaded record into the detail MySQL table. |
BUYER_NAME
Seq. Order: | 40 |
---|---|
Data Storage Type: | varchar |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of buyer linked to BUYER_FK. |
FISHER_NAME
Seq. Order: | 41 |
---|---|
Data Storage Type: | varchar |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of fisher linked to FISHER_FK. |
METHOD_NAME
Seq. Order: | 42 |
---|---|
Data Storage Type: | varchar |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of fishing method linked to METHOD_FK. |
SCIENTIFIC_NAME
Seq. Order: | 43 |
---|---|
Data Storage Type: | varchar |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name of the species (Genus name + Species name). |
COMMON_NAME
Seq. Order: | 44 |
---|---|
Data Storage Type: | varchar |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common English name for the species. |
LOCAL_NAME
Seq. Order: | 45 |
---|---|
Data Storage Type: | varchar |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local name of the species. |
Catalog Details
Catalog Item ID: | 63470 |
---|---|
GUID: | gov.noaa.nmfs.inport:63470 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-01-21 01:08+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 |