Table: CONTROL_PARAMETERS

Southeast Fisheries Science Center
Entity (ENT) | ID: 5287 | Published / External
Created: 2007-10-10   |   Last Modified: 2022-08-09

Parent: Economic Data Collection for Gulf of Mexico South Atlantic Shrimp Fisheries
Data Set (DS) | ID: 5282

ID: 5287
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: CONTROL_PARAMETERS
Short Name CONTROL_PARAMETERS
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

A control table that provides a set of application wide parameters, such as the year to process and additional parameters that determine whether values are flagged as warnings or errors.
* Purpose
Notes

Loaded by batch 1643, 10-10-2007 10:43
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name EC_SRV_GS
» Description

A control table that provides a set of application wide parameters, such as the year to process and additional parameters that determine whether values are flagged as warnings or errors.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 No No CURRENT_PROCESSING_YEAR NUMBER This sets the ACTIVE_YEAR of this survey, allowing all annual surveys to reside in the same Oracle table. It also controls the year displayed on data entry screens.
100 No No CREATED_BY_USER_ID VARCHAR2 A control field listing the user_id of the record creator.
100 No No CREATED_DATE DATE A control field listing the system time when the record was created.
100 No No MODIFIED_BY_USER_ID VARCHAR2 A control field listing the user_id of the person modifying the record.
100 No No MODIFIED_DATE DATE A control field listing the system time when the record was last modfied.
100 No No SMALLEST_FUEL_WARNING_PERCENT NUMBER The intial setting of 5 indicates that fuel_expenses will be accepted as valid when the fuel expense is within 95% and 105% of (average price per gallons * number of gallons purchased).
100 No No LARGEST_FUEL_WARNING_PERCENT NUMBER The intial setting of 20 indicates that fuel_expenses will be flagged as a probable error when the fuel_expense is less than 80% of (average price per gallons * number of gallons purchased) or the fuel_expense is more than 120% of (average price per gallons * number of gallons purchased).
100 No No OVERHEAD_COEFF_PERCENT NUMBER The intial setting of 2 indicates that overhead will be flagged as a probable error when: overhead is less than loan payments times average of market value of the vessel and purchase price of the vessel times the overhead_coefficient_percentage for vessels with hull insurance.
100 No No SMALLEST_INSUR_WARNING_PERCENT NUMBER 25 indicates that total amount vessel is insured for will be valid when the fuel expense is within 75% and 125% of vessel's average (market value, original purchase price).
100 No No LARGEST_INSUR_WARNING_PERCENT NUMBER The intial setting of 50 indicates that total amount vessel is insured for will be flagged as a probable error when it is less than 50% of vessel's average (market value, original purchase price) or greater than 150% of vessel's average (market value, original purchase price).
100 No No SMALLEST_NONSHRMP_WARN_PERCENT NUMBER The intial setting of 50 indicates that non-shrimp total gross revenue will be marked as questionable when it exceeds 50% of the total annual expenses.
100 No No SMALLEST_TOT_EXP_WARN_PERCENT NUMBER 0 indicates that any deviation in total annual expense from the sum of the above entries is flagged as a warning.
100 No No LARGEST_TOT_EXP_WARN_PERCENT NUMBER 2.5 indicates that a deviation in total annual expense from the sum of the above entries is flagged as an error.

Attribute Details

Attribute Name CURRENT_PROCESSING_YEAR
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 4
Scale 0
Status Active
Description

This sets the ACTIVE_YEAR of this survey, allowing all annual surveys to reside in the same Oracle table. It also controls the year displayed on data entry screens.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREATED_BY_USER_ID
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

A control field listing the user_id of the record creator.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREATED_DATE
Seq. Order 3
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

A control field listing the system time when the record was created.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name MODIFIED_BY_USER_ID
Seq. Order 4
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

A control field listing the user_id of the person modifying the record.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name MODIFIED_DATE
Seq. Order 5
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

A control field listing the system time when the record was last modfied.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SMALLEST_FUEL_WARNING_PERCENT
Seq. Order 6
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

The intial setting of 5 indicates that fuel_expenses will be accepted as valid when the fuel expense is within 95% and 105% of (average price per gallons * number of gallons purchased).
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LARGEST_FUEL_WARNING_PERCENT
Seq. Order 7
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

The intial setting of 20 indicates that fuel_expenses will be flagged as a probable error when the fuel_expense is less than 80% of (average price per gallons * number of gallons purchased) or the fuel_expense is more than 120% of (average price per gallons * number of gallons purchased).
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OVERHEAD_COEFF_PERCENT
Seq. Order 8
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

The intial setting of 2 indicates that overhead will be flagged as a probable error when: overhead is less than loan payments times average of market value of the vessel and purchase price of the vessel times the overhead_coefficient_percentage for vessels with hull insurance.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SMALLEST_INSUR_WARNING_PERCENT
Seq. Order 9
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

25 indicates that total amount vessel is insured for will be valid when the fuel expense is within 75% and 125% of vessel's average (market value, original purchase price).
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LARGEST_INSUR_WARNING_PERCENT
Seq. Order 10
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

The intial setting of 50 indicates that total amount vessel is insured for will be flagged as a probable error when it is less than 50% of vessel's average (market value, original purchase price) or greater than 150% of vessel's average (market value, original purchase price).
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SMALLEST_NONSHRMP_WARN_PERCENT
Seq. Order 11
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

The intial setting of 50 indicates that non-shrimp total gross revenue will be marked as questionable when it exceeds 50% of the total annual expenses.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SMALLEST_TOT_EXP_WARN_PERCENT
Seq. Order 12
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

0 indicates that any deviation in total annual expense from the sum of the above entries is flagged as a warning.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LARGEST_TOT_EXP_WARN_PERCENT
Seq. Order 13
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

2.5 indicates that a deviation in total annual expense from the sum of the above entries is flagged as an error.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 5287
Metadata Record Created By Lee M Weinberger
Metadata Record Created 2007-10-10 10:43+0000
Metadata Record Last Modified By SysAdmin InPortAdmin
» Metadata Record Last Modified 2022-08-09 17:11+0000
Metadata Record Published 2021-05-07
Owner Org SEFSC
Metadata Publication Status Published Externally
Do Not Publish? N
Metadata Workflow State Published / External
Metadata Last Review Date 2021-05-07
Metadata Review Frequency 1 Year
Metadata Next Review Date 2022-05-07
Tags