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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Entity Type
Data View

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

Data Attribute / Type

Description

CCL_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.

INVOICE_DATE
date

Invoice date.

BUYER_FK
int

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

FISHER_FK
int

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

INCOMPLETE_F
char

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

ISLAND
int

Code for the island where the fisher is based.

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.

CCL_DT_PK
int

System-generated artificial primary key for detail table.

CCL_HD_FK
varchar

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

SPECIES_FK
int

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

Name of the user who created the detail record.

DETAIL_MODIFY_TIME
datetime

Date and time the detail record was last modified.

DETAIL_MODIFY_USER
varchar

Name of the user who last modified the detail record.

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.

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.

No Child Items for this record.

No contact information is available for this record.

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

Title:	c_cl_flat_view
Status:	Completed

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

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CCL_HD_PK

INVOICE

INVOICE_DATE

BUYER_FK

FISHER_FK

RESALE_F

REMARK1

REMARK2

REMARK3

TOT_LBS

TOT_SOLD_REVENUE

INCOMPLETE_F

ISLAND

HEAD_CREATE_TIME

HEAD_CREATE_USER

HEAD_MODIFY_TIME

HEAD_MODIFY_USER

HEAD_LOAD_TABLE

HEAD_DATETIME

HEAD_LOAD_USER

CCL_DT_PK

CCL_HD_FK

SPECIES_FK

NUM_SOLD

LBS_SOLD

PRICE_PER_LB

SOLD_REVENUE

DETAIL_CREATE_TIME

DETAIL_CREATE_USER

DETAIL_MODIFY_TIME

DETAIL_MODIFY_USER

DETAIL_LOAD_TABLE

DETAIL_DATETIME

DETAIL_LOAD_USER

BUYER_NAME

FISHER_NAME

SCIENTIFIC_NAME

COMMON_NAME

LOCAL_NAME

Catalog Details