Table: CONTROL_PARAMETERS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5287 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionA 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |