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

Summary

Abstract

A list of form templates wich have a corresponding user interface for data entry. Supports having different information collected BY Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.

Description

A list of form templates wich have a corresponding user interface for data entry. Supports having different information collected BY Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FORM_TEMPLATE_CD
VARCHAR2
Primary key for this table.
FORM_TEMPLATE_NM
VARCHAR2
Field to store the name of the Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.
LU_DT
DATE
Last update date.
LU_USER_ID
NUMBER
Last update user.
IS_ENABLED
NUMBER
Is the value enabled?
FORM_TEMPLATE_DESC
VARCHAR2
Description of a Region.
SUBREGION_CD
VARCHAR2
FK to Subregion List

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: FORM_TEMPLATE_LIST
Short Name: FORM_TEMPLATE_LIST
Status: Completed
Abstract:

A list of form templates wich have a corresponding user interface for data entry. Supports having different information collected BY Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.

Notes:

Loaded by batch 7533, 11-05-2015 16:10

Entity Information

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

A list of form templates wich have a corresponding user interface for data entry. Supports having different information collected BY Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FORM_TEMPLATE_CD VARCHAR2 Primary key for this table.
100
FORM_TEMPLATE_NM VARCHAR2 Field to store the name of the Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.
100
LU_DT DATE Last update date.
100
LU_USER_ID NUMBER Last update user.
100
IS_ENABLED NUMBER Is the value enabled?
100
FORM_TEMPLATE_DESC VARCHAR2 Description of a Region.
100
SUBREGION_CD VARCHAR2 FK to Subregion List

Attribute Details

FORM_TEMPLATE_CD

CC ID: 246978
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key for this table.

General Data Type: VARCHAR2

FORM_TEMPLATE_NM

CC ID: 246979
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
Description:

Field to store the name of the Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.

General Data Type: VARCHAR2

LU_DT

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

Last update date.

General Data Type: DATE

LU_USER_ID

CC ID: 246981
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Last update user.

General Data Type: NUMBER

IS_ENABLED

CC ID: 246982
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Is the value enabled?

General Data Type: NUMBER

FORM_TEMPLATE_DESC

CC ID: 246983
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 256
Required: No
Primary Key: No
Status: Active
Description:

Description of a Region.

General Data Type: VARCHAR2

SUBREGION_CD

CC ID: 246977
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

FK to Subregion List

General Data Type: VARCHAR2
Foreign Key Relations:

CCL.SUBREGION_LIST

Catalog Details

Catalog Item ID: 28545
GUID: gov.noaa.nmfs.inport:28545
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-11-05 16:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+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