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

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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.
CREATED_BY_USER_ID
VARCHAR2
A control field listing the user_id of the record creator.
CREATED_DATE
DATE
A control field listing the system time when the record was created.
MODIFIED_BY_USER_ID
VARCHAR2
A control field listing the user_id of the person modifying the record.
MODIFIED_DATE
DATE
A control field listing the system time when the record was last modfied.
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).
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).
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.
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).
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).
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.
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.
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.

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: CONTROL_PARAMETERS
Short Name: CONTROL_PARAMETERS
Status: Completed
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.

Notes:

Loaded by batch 1643, 10-10-2007 10:43

Entity Information

Entity Type: Data Table
Active Version?: Yes
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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
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
CREATED_BY_USER_ID VARCHAR2 A control field listing the user_id of the record creator.
100
CREATED_DATE DATE A control field listing the system time when the record was created.
100
MODIFIED_BY_USER_ID VARCHAR2 A control field listing the user_id of the person modifying the record.
100
MODIFIED_DATE DATE A control field listing the system time when the record was last modfied.
100
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
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
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
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
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
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
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
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

CURRENT_PROCESSING_YEAR

CC ID: 15371
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
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

CREATED_BY_USER_ID

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

A control field listing the user_id of the record creator.

General Data Type: VARCHAR2

CREATED_DATE

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

A control field listing the system time when the record was created.

General Data Type: DATE

MODIFIED_BY_USER_ID

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

A control field listing the user_id of the person modifying the record.

General Data Type: VARCHAR2

MODIFIED_DATE

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

A control field listing the system time when the record was last modfied.

General Data Type: DATE

SMALLEST_FUEL_WARNING_PERCENT

CC ID: 15366
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

LARGEST_FUEL_WARNING_PERCENT

CC ID: 15365
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

OVERHEAD_COEFF_PERCENT

CC ID: 15364
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

SMALLEST_INSUR_WARNING_PERCENT

CC ID: 15363
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

LARGEST_INSUR_WARNING_PERCENT

CC ID: 15362
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

SMALLEST_NONSHRMP_WARN_PERCENT

CC ID: 15361
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

SMALLEST_TOT_EXP_WARN_PERCENT

CC ID: 15360
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

LARGEST_TOT_EXP_WARN_PERCENT

CC ID: 15359
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

Catalog Details

Catalog Item ID: 5287
GUID: gov.noaa.nmfs.inport: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 Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07