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 (... > Guam Commercial Purchases >

g_cl_flat_view

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63470  |  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
GCL_HD_PK
varchar 		Primary key for header table created by concatenating invoice year and invoice number.
INVOICE
int 		Invoice number that uniquely identifies and invoice.
INCOMPLETE_F
char 		If true, this invoice is not complete.
INVOICE_DATE
date 		Invoice date.
BUYER_FK
int 		Code of the fish buyer. Detailed information can be found in G_GCL_BUYER or G_BUYER.DBF.
FISHER_FK
int 		Code of the fisher. Detailed information can be found in G_GCL_FISHER or G_FISHER.DBF.
HOURS_FISHED
decimal 		Number of hours fished.
NUM_FISHER
int 		Number of fishermen fishing.
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.
AREA2_FK
int 		General location code # 2. Detailed information can be found in G_GCL_AREA or G_AREA.DBF.
AREA3_FK
int 		General location code # 3. Detailed information can be found in G_GCL_AREA or G_AREA.DBF.
AREA4_FK
int 		General location code # 4. Detailed information can be found in G_GCL_AREA or G_AREA.DBF.
AREA5_FK
int 		General location code # 5. Detailed information can be found in G_GCL_AREA or G_AREA.DBF.
RESALE_F
char 		If true (T), indicates this is a resale invoice.
REMARK1
varchar 		Comment field.
REMARK2
varchar 		Comment field.
REMARK3
varchar 		Comment field.
TOT_LBS
decimal 		Total weight of all species on invoice.
TOT_SOLD_REVENUE
decimal 		Total pirce paid for all species on invoice.
HEAD_CREATE_TIME
datetime 		Date and time the header record was created.
HEAD_CREATE_USER
varchar 		Name of the user who created the header record.
HEAD_MODIFY_TIME
datetime 		Date and time the header record was last modified.
HEAD_MODIFY_USER
varchar 		Name of the user who last modified the header record.
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.
GCL_DT_PK
int 		System-generated artificial primary key for detail table.
GCL_HD_FK
varchar 		Same as GCL_HD_PK column. Used to link detail to header table.
SPECIES_FK
int 		Numeric code for the species. Detailed information can be found in G_GCL_SPECIES or G_SPEC.DBF.
METHOD_FK
int 		Numeric code for the fishing method. Detailed information can be found in G_GCL_METHOD or G_METHOD.DBF.
NUM_SOLD
decimal 		Number of pieces of a species sold.
LBS_SOLD
decimal 		Number of pounds of a species sold.
PRICE_PER_LB
decimal 		Price per pound of a species.
SOLD_REVENUE
decimal 		Total price paid by the buyer for a species.
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.
BUYER_NAME
varchar 		Name of buyer linked to BUYER_FK.
FISHER_NAME
varchar 		Name of fisher linked to FISHER_FK.
METHOD_NAME
varchar 		Name of fishing method linked to METHOD_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: g_cl_flat_view
Status: Completed

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: guam_dawr_wh

Data Attributes

Attribute Summary

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

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

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

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

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

Invoice date.

BUYER_FK

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

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

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

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

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

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

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

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

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

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

CC ID: 1008158
Seq. Order: 15
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Comment field.

REMARK2

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

Comment field.

REMARK3

CC ID: 1008160
Seq. Order: 17
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Comment field.

TOT_LBS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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