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

Summary

Abstract

Table to track mailing of logbook forms

Description

Table to track mailing of logbook forms

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
MAILING_PREPARATION_DATE
DATE
Date when the NOAA employee is preparing the mailing lote
STARTING_PERMIT_EFFECTIVE_DATE
DATE
Date after which the new dealers will be included in the mailing list.
LABEL_COUNT
NUMBER
How many labels were printed in this mailing batch
USER_ID
VARCHAR2
The NOAA employee who created the mailing batch
COVER_LETTER_MAILING_DATE
DATE
Which mailing date will appear in the cover letter

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: PDC_LOGBOOKS_MAILING_CONTROLS
Short Name: PDC_LOGBOOKS_MAILING_CONTROLS
Status: Completed
Abstract:

Table to track mailing of logbook forms

Notes:

Loaded by batch 1703, 10-15-2007 10:13

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Table to track mailing of logbook forms

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key MAILING_PREPARATION_DATE DATE Date when the NOAA employee is preparing the mailing lote
100
STARTING_PERMIT_EFFECTIVE_DATE DATE Date after which the new dealers will be included in the mailing list.
100
LABEL_COUNT NUMBER How many labels were printed in this mailing batch
100
Primary Key USER_ID VARCHAR2 The NOAA employee who created the mailing batch
100
COVER_LETTER_MAILING_DATE DATE Which mailing date will appear in the cover letter

Attribute Details

MAILING_PREPARATION_DATE

CC ID: 16963
Seq. Order: 1
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

Date when the NOAA employee is preparing the mailing lote

General Data Type: DATE

STARTING_PERMIT_EFFECTIVE_DATE

CC ID: 16962
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date after which the new dealers will be included in the mailing list.

General Data Type: DATE

LABEL_COUNT

CC ID: 16961
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

How many labels were printed in this mailing batch

General Data Type: NUMBER

USER_ID

CC ID: 16960
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: Yes
Status: Active
Description:

The NOAA employee who created the mailing batch

General Data Type: VARCHAR2

COVER_LETTER_MAILING_DATE

CC ID: 16959
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Which mailing date will appear in the cover letter

General Data Type: DATE

Catalog Details

Catalog Item ID: 5417
GUID: gov.noaa.nmfs.inport:5417
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-15 10:13+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06