Table: CONTROL_PARAMETERS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5287 | Updated: August 9, 2022 | Published / External
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 |