Metadata Rubric

83%

5 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > CNMI Commercial Purchases >

c_cl_flat_view

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63463 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	c_cl_flat_view
Status:	Completed

Entity Information

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

Data Attributes

Attribute Summary

	Name	Type	Description
100	CCL_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	INVOICE_DATE	date	Invoice date.
100	BUYER_FK	int	Code for the fish buyer. Detailed information can be found in C_CCL_BUYER or C_BUYER.DBF.
100	FISHER_FK	int	Code for the fisher. Detailed information can be found in C_CCL_FISHER or C_FISHER.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	INCOMPLETE_F	char	If true (T), indicates the invoice is not complete.
100	ISLAND	int	Code for the island where the fisher is based.
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	CCL_DT_PK	int	System-generated artificial primary key for detail table.
100	CCL_HD_FK	varchar	Same as CCL_HD_PK column. Used to link detail to header table.
100	SPECIES_FK	int	Code for the species. Detailed information can be found in C_CCL_SPECIES or C_SPEC.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_CREATE_USER	varchar	Name of the user who created the detail record.
100	DETAIL_MODIFY_TIME	datetime	Date and time the detail record was last modified.
100	DETAIL_MODIFY_USER	varchar	Name of the user who last modified the detail record.
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	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.

Name

Type

Description

100

CCL_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

INVOICE_DATE

date

Invoice date.

100

BUYER_FK

int

Code for the fish buyer. Detailed information can be found in C_CCL_BUYER or C_BUYER.DBF.

100

FISHER_FK

int

Code for the fisher. Detailed information can be found in C_CCL_FISHER or C_FISHER.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

INCOMPLETE_F

char

If true (T), indicates the invoice is not complete.

100

ISLAND

int

Code for the island where the fisher is based.

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

CCL_DT_PK

int

System-generated artificial primary key for detail table.

100

CCL_HD_FK

varchar

Same as CCL_HD_PK column. Used to link detail to header table.

100

SPECIES_FK

int

Code for the species. Detailed information can be found in C_CCL_SPECIES or C_SPEC.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_CREATE_USER

varchar

Name of the user who created the detail record.

100

DETAIL_MODIFY_TIME

datetime

Date and time the detail record was last modified.

100

DETAIL_MODIFY_USER

varchar

Name of the user who last modified the detail record.

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

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

CCL_HD_PK

CC ID: 1007820

Seq. Order:	1
Data Storage Type:	varchar
Max Length:	18
Required:	No
Primary Key:	No
Status:	Active
Description:	Primary key for header table created by concatenating invoice year and invoice number.

INVOICE

CC ID: 1007821

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.

INVOICE_DATE

CC ID: 1007822

Seq. Order:	3
Data Storage Type:	date
Required:	No
Primary Key:	No
Status:	Active
Description:	Invoice date.

BUYER_FK

CC ID: 1007823

Seq. Order:	4
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the fish buyer. Detailed information can be found in C_CCL_BUYER or C_BUYER.DBF.

FISHER_FK

CC ID: 1007824

Seq. Order:	5
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the fisher. Detailed information can be found in C_CCL_FISHER or C_FISHER.DBF.

RESALE_F

CC ID: 1007825

Seq. Order:	6
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: 1007826

Seq. Order:	7
Data Storage Type:	varchar
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment field.

REMARK2

CC ID: 1007827

Seq. Order:	8
Data Storage Type:	varchar
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment field.

REMARK3

CC ID: 1007828

Seq. Order:	9
Data Storage Type:	varchar
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment field.

TOT_LBS

CC ID: 1007829

Seq. Order:	10
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: 1007830

Seq. Order:	11
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	2
Status:	Active
Description:	Total pirce paid for all species on invoice.

INCOMPLETE_F

CC ID: 1007831

Seq. Order:	12
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	If true (T), indicates the invoice is not complete.

ISLAND

CC ID: 1007832

Seq. Order:	13
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the island where the fisher is based.

HEAD_CREATE_TIME

CC ID: 1007833

Seq. Order:	14
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: 1007834

Seq. Order:	15
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: 1007835

Seq. Order:	16
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: 1007836

Seq. Order:	17
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: 1007837

Seq. Order:	18
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: 1007838

Seq. Order:	19
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: 1007839

Seq. Order:	20
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	User who loaded record into the header MySQL table.

CCL_DT_PK

CC ID: 1007840

Seq. Order:	21
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	System-generated artificial primary key for detail table.

CCL_HD_FK

CC ID: 1007841

Seq. Order:	22
Data Storage Type:	varchar
Max Length:	18
Required:	No
Primary Key:	No
Status:	Active
Description:	Same as CCL_HD_PK column. Used to link detail to header table.

SPECIES_FK

CC ID: 1007842

Seq. Order:	23
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the species. Detailed information can be found in C_CCL_SPECIES or C_SPEC.DBF.

NUM_SOLD

CC ID: 1007843

Seq. Order:	24
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	2
Status:	Active
Description:	Number of pieces of a species sold.

LBS_SOLD

CC ID: 1007844

Seq. Order:	25
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: 1007845

Seq. Order:	26
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: 1007846

Seq. Order:	27
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: 1007847

Seq. Order:	28
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time the detail record was created.

DETAIL_CREATE_USER

CC ID: 1007848

Seq. Order:	29
Data Storage Type:	varchar
Max Length:	35
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the user who created the detail record.

DETAIL_MODIFY_TIME

CC ID: 1007849

Seq. Order:	30
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time the detail record was last modified.

DETAIL_MODIFY_USER

CC ID: 1007850

Seq. Order:	31
Data Storage Type:	varchar
Max Length:	35
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the user who last modified the detail record.

DETAIL_LOAD_TABLE

CC ID: 1007851

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: 1007852

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: 1007853

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.

BUYER_NAME

CC ID: 1007854

Seq. Order:	35
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: 1007855

Seq. Order:	36
Data Storage Type:	varchar
Max Length:	35
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of fisher linked to FISHER_FK.

SCIENTIFIC_NAME

CC ID: 1007856

Seq. Order:	37
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: 1007857

Seq. Order:	38
Data Storage Type:	varchar
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Common English name for the species.

LOCAL_NAME

CC ID: 1007858

Seq. Order:	39
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:	63463
GUID:	gov.noaa.nmfs.inport:63463
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2021-01-21 00:48+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