Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

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.

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: c_cl_flat_view
Status: Completed

Entity Information

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

Data Attributes

Attribute Summary

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