Limit Sets Business Rules

               

Input

Business Rule

Add Scheduled Limit Set

 

     Limit Set Designator is unique within the Permitted Feature and NPDES ID.

     If Default Months Limit Set Applies is not entered, system will set the Default Months Limit Set Applies to all months; the screen will default to show all months selected (i.e., checked) for the Limit Set.

Non-Editable Data Elements:

     The user has not entered any of the following data elements:

-   Report Units (always display only)

-   Limit Set Status End Date (always display only).

Default Statistical Base Codes

     A single Statistical Base Code may only be entered once for Quantity Limit Values (i.e., Limit Value Type = Quantity 1 or Quantity 2).

     A single Statistical Base Code may only be entered once for Concentration Limit Values (i.e., Limit Value Type = Concentration 1, Concentration 2, or Concentration 3).

     Only one Statistical Base Code with Statistical Base Code Type = A (i.e., monthly average) can be entered for Quantity Limit Values.

     Only one Statistical Base Code with Statistical Base Code Type = A (i.e., monthly average) can be entered for Concentration Limit Values.

Schedule Data

Initial Monitoring Date

     Initial Monitoring Date must be entered.

     The Initial Monitoring Date must be less than or equal to the Permit Expiration Date (if Expiration Date has been entered).

     If IMD is less than the Permit Effective Date, Initial Monitoring Period End Date (IMPED) must be greater than the Permit Effective Date.  IMPED is calculated using the following formula: IMPED = IMD + (Number of Report Units x Calendar Month) - 1 Day.

Initial DMR Due Date

     The Initial DMR Due Date must be entered.

     The Initial DMR Due Date must be greater than the Initial Monitoring Period End Date (Initial Monitoring Period End Date = Initial Monitoring Date + (Number of Report Units x Calendar Month) - 1day)).

     The Initial DMR Due Date must be greater than or equal to the earliest possible submission due date (Initial DMR Due Date must be >= Initial Monitoring Date + (Number of Submission Units x Calendar Month) - 1 day)).

Modification Data Element Rules

     If Modification Effective Date is entered, it must be greater than or equal to Permit Issue Date and less than or equal to Permit Expiration Date.

     If Modification Type is entered, Modification Effective Date must be entered and vice versa.

Number of Report/Submission Units

     Number of Report Units must be entered.

     Number of Submission Units must be entered.

     The Number of Submission Units must be greater than or equal to the Number of Report Units.

     The Number of Submission Units must be evenly divisible by the Number of Report Units.

Add Scheduled Limit Set

 

Limit Set Status Rules – General:

     There must be at least one Limit Set Status and Status Start Date.

     If Status is entered, Status Start Date must be entered and vice versa.

     If Status and Status Start Date are blank, Change Reason must be blank.

     Limit Set Status defaults to Active if not entered

     Limit Set Status Start Date defaults to Initial Monitoring Date if not entered

     Earliest Limit Set Status Start Date must equal earliest Initial Monitoring Date.

Add Unscheduled Limit Set

     Limit Set Designator is unique within the Permitted Feature and NPDES ID.

     If Default Months Limit Set Applies is not entered, system will set the Default Months Limit Set Applies to all months; the screen will default to show all months selected (i.e., checked) for the Limit Set.

Non-Editable Data Elements:

     The user has not entered any of the following data elements:

-   Report Units (always display only)

-   Limit Set Status End Date (always display only).

Default Statistical Base Codes

     A single Statistical Base Code may only be entered once for Quantity Limit Values (i.e., Limit Value Type = Quantity 1 or Quantity 2).

     A single Statistical Base Code may only be entered once for Concentration Limit Values (i.e., Limit Value Type = Concentration 1, Concentration 2, or Concentration 3).

     Only one Statistical Base Code with Statistical Base Code Type = A (i.e., monthly average) can be entered for Quantity Limit Values.

     Only one Statistical Base Code with Statistical Base Code Type = A (i.e., monthly average) can be entered for Concentration Limit Values.

Schedule Data

     Number of Report Units must be entered.

     Number of Submission Units must be blank.

     Initial Monitoring Date must be blank.

     Initial DMR Due Date must be blank.

     If Modification Effective Date is entered, it must be greater than or equal to Permit Issue Date and less than or equal to Permit Expiration Date.

     If Modification Type is entered, Modification Effective Date must be entered and vice versa.

Limit Set Status Rules – General:

     There must be at least one Limit Set Status and Status Start Date.

     If Status is entered, Status Start Date must be entered and vice versa.

     If Status and Status Start Date are blank, Change Reason must be blank.

     Limit Set Status defaults to Active if not entered

     Limit Set Status Start Date defaults to Permit Effective Date if not entered

     Earliest Limit Set Status Start Date must be >= Permit Effective Date and <= Permit Expiration Date.

Edit Limit Set

     System validates that the user may edit the Limit Set by validating that none of the DMRs for the Limit Set are Unsubmitted.

Edit Scheduled Limit Set

 

System validates the Limit Set data based on the edit checks in the Data Mapping and the following business rules:

     At least one month must be entered for Default Months Limit Set Applies: 

-   If user blanks out all Months, system generates an error message.

Schedule Data

For each row of Limit Set Schedule data, the following rules apply.  Note:  if any of the Limit Set Schedule data rows are from a Permit Modification (i.e., Modification Effective Date is not blank), the word Modification should be assumed to precede each data element.

Initial Monitoring Date

     Initial Monitoring Date must be entered.

     The  earliest Initial Monitoring Date (IMD)/Modification Initial Monitoring Date (MIMD) must be less than or equal to the Permit Expiration Date (if Permit Expiration Date has been entered).

     The Initial Monitoring Date/Modification Initial Monitoring Date must be less than or equal to the Permit Expiration Date (if Permit Expiration Date has been entered).

     If IMD/MIMD is less than the Permit Effective Date, Initial Monitoring Period End Date (IMPED) must be greater than the Permit Effective Date.  IMPED is calculated using the following formula: IMPED = IMD/MIMD + (Number of Report Units x Calendar Month) - 1 Day.

Initial DMR Due Date

     Initial DMR Due Date must be entered.

     The Initial DMR Due Date must be greater than the Initial Monitoring Period End Date (Initial Monitoring Period End Date = Initial Monitoring Date + (Number of Report Units x Calendar Month) - 1day).

     The Initial DMR Due Date must be greater than or equal to the earliest possible submission due date (Initial DMR Due Date is greater than or equal to Initial Monitoring Date + (Number of Submission Units x Calendar Month) - 1 day).

Number of Report/Submission Units

     Number of Report Units must be entered.

     Number of Submission Units must be entered.

     The Number of Submission Units must be greater than or equal to the Number of Report Units.

     The Number of Submission Units must be evenly divisible by the Number of Report Units.

Modification Data Element Rules

     When adding a row of Schedule Data, if at least one row of Schedule Data already exists then Modification Effective Date and Modification Type are required.

     If Modification Effective Date is entered for a row of schedule data, it must be greater than or equal to Permit Issue Date and less than or equal to Permit Expiration Date.

     If Modification Type is entered for a row of schedule data, Modification Effective Date must be entered for that row and visa versa.

Limit Set Status Rules – General:

     There must be at least one Status and Status Start Date.

     If Status is entered, Status Start Date must be entered and vice versa.

     If Status and Status Start Date are blank, Change Reason must be blank.

     The earliest Limit Set Status Start Date must equal the earliest Initial Monitoring/Modification Initial Monitoring Date.

     If a Status is deleted the previous status row end date will be recalculated (blanked out or set to the date before the next status).

Limit Set Status Rules – Web:

If any Status Start Date has been changed or added:

     If multiple Statuses and Status Start Dates are entered:

-   System generates Status End Date to be one day prior to next Status Start Date (except the latest Status Start Date which has a blank Status End Date)

-   No duplicate Status Start Dates.

     If a Status is deleted the previous status row end date will be recalculated (blanked out or set to the date before the next status).

System validates that none of the following business rules have been violated:

Default Months Limit Set Applies

If the Default Months Limit Set Applies has been changed, the system applies Default Months Limit Set edits to the Months Limit Applies for each Limit:

     If a Month has been deselected (i.e., unchecked) in the Limit Set, the system:

-   Validates that no DMR Forms with Monitoring Period End Date for any removed month exist for the Limit Set

-   If none exist, removes that month from any Limit which has that month selected.

     If a Month has been selected in the Limit Set, the system adds that month to any Limit which does not already have that month selected.

     The system will generate a warning message if seasonal Limit records have duplicate months (i.e., they share the following key data elements with different Limit Season IDs, and the same month(s):

-   NPDES ID

-   Permitted Feature Identifier

-   Limit Set Designator

-   Parameter Code

-   Monitoring Location Code

-   Limit Start Date

-   Limit End Date

-   Matching Change of Limit Status:

v Both blank OR

v Both Permit Modification AND same Modification Effective Date OR

v Both Enforcement Action AND same Final Order ID.)

Orphaning Validation

     If the Permit for the Limit Set is an Individual or GPCF, the system performs the following validation:

-   If the Limit Set has at least one DMR Value with a DMR Value Received Date entered, and any of the following data have been changed, the system runs Expected DMR Schedule Processing to validate that no Received DMR Values will be orphaned as a result of the Limit Set edit:

v Number of Report Units

v Number of Submission Units

v Initial Monitoring Date

v Initial DMR Due Date

v Default Months Limit Set Applies.

Edit Unscheduled Limit Set

     At least one month must be entered for Default Months Limit Set Applies: 

-   If user blanks out all Months, system generates an error message.

     Only one Statistical Base Code with Statistical Base Code Type = A (i.e., monthly average) can be entered for Quantity Limit Values.

     Only one Statistical Base Code with Statistical Base Code Type = A (i.e., monthly average) can be entered for Concentration Limit Values.

Schedule Data:

For each set of Limit Set Schedule data, the following rules apply.  Note:  if any of the Limit Set Schedule data are from a Permit Modification, the word Modification should be assumed to precede each data element.

Edit Unscheduled Limit Set

 

     Number of Report Units must be entered.

     The Initial Monitoring Date must be blank.

     The Number of Submission Units must be blank.

     The Initial DMR Due Date must be blank.

Modification Data Element Rules

     When adding a row of Schedule Data, if at least one row of Schedule Data already exists then Modification Effective Date and Modification Type are required.

     If Modification Effective Date is entered for a row of schedule data, it must be greater than or equal to Permit Issue Date and less than or equal to Permit Expiration Date.

     If Modification Type is entered for a row of schedule data, Modification Effective Date must be entered for that row, and vice versa.

Limit Set Status Rules – General:

     There must be at least one Status and Status Start Date.

     If Status is entered, Status Start Date must be entered and vice versa.

     If Status and Status Start Date are blank, Change Reason must be blank.

     The earliest Limit Set Status Start Date must be greater than or equal to the Permit Effective Date and less than or equal to the Permit Expiration Date.

     If a Status is deleted the previous status row end date will be recalculated (blanked out or set to the date before the next status).

Limit Set Status Rules – Web:

If any Status Start Date has been changed or added:

     If multiple Statuses and Status Start Dates are entered:

-   System generates Status End Date to be one day prior to next Status Start Date (except the latest Status Start Date which has a blank Status End Date)

     No duplicate Status Start Dates.

     If a Status is deleted the previous status row end date will be recalculated (blanked out or set to the date before the next status)

System validates that none of the following business rules have been violated:

Default Months Limit Set Applies

If the Default Months Limit Set Applies has been changed, the system applies Default Months Limit Set edits to the Months Limit Applies for each Limit:

     If a Month has been deselected (i.e., unchecked) in the Limit Set, the system:

-   Validates that no DMR Forms with Monitoring Period End Date for any removed month exist for the Limit Set

-   If none exist, removes that month from any Limit which has that month selected.

     If a Month has been selected in the Limit Set, the system adds that month to any Limit which does not already have that month selected.

     The system will generate a warning message if seasonal Limit records have duplicate months (i.e., they share the following key data elements with different Limit Season IDs, and the same month(s):

-   NPDES ID

-   Permitted Feature Identifier

-   Limit Set Designator

-   Parameter Code

-   Monitoring Location Code

-   Limit Start Date

-   Limit End Date

-   Matching Change of Limit Status:

v Both blank OR

v Both Permit Modification AND same Modification Effective Date OR

v Both Enforcement Action AND same Final Order ID.)

Copy Limit Set

     The Source NPDES ID exists in the system

     The Source NPDES ID has a current version that has at least one Limit Set

     If the Target Permit is a GPCF, the Source Permit screen will default to the NPDES   ID of the Master General Permit associated with the GPCF.

Limit Set Dates

     Limit Start Date defaults to target Permit Effective Date; if target Permit Effective Date is blank, Limit Start Date defaults to blank.

     Limit End Date defaults to target Permit Expiration Date; if target Permit Expiration Date is blank, Limit End Date defaults to blank.

     Limit Start and End Date must be entered.

Target Permitted Feature

     Target Permitted Feature must be entered

     Defaults to blank

     May be pre-populated based on the source Permitted Feature ID by selecting the Pre-populate button

Target Limit Set Designator

     Target Limit Set Designator must be entered.

     Defaults to blank

     May be pre-populated based on the source Limit Set Designator by selecting the Pre-populate button

Number of Report Units

     Number of Report Units must be entered.

     Defaults to source Number of Report Units

     If multiple Limit Set Schedule rows exist for the source Limit Set, the Number of Report Units from the row with the latest Modification Effective Date will be used.  If multiple rows with the same Modification Effective Date exist, the row with the latest sequence ID will be used.

Number of Submission Units

     Required for Scheduled Limit Sets; not enterable for Unscheduled Limit Sets

     Defaults to source Number of Submission Units

     If multiple Limit Set Schedule rows exist for the source Limit Set, the Number of Submission Units from the row with the latest Modification Effective Date will be used.  If multiple rows with the same Modification Effective Date exist, the row with the latest sequence ID will be used.

Initial Monitoring Date

     Required for Scheduled Limit Sets; not enterable for Unscheduled Limit Sets

     Defaults to blank

     May be pre-populated by entering a date in the Pre-populate Initial Monitoring Date field and selecting the Pre-populate button.

Initial DMR Due Date

     Required for Scheduled Limit Sets; not enterable for Unscheduled Limit Sets

     Defaults to blank.

     May be pre-populated by entering a date in the Pre-populate Initial DMR Due Date field and selecting the Pre-populate button.

When a Limit Set is being copied the system validates the following general business rules:

     At least one Limit Set has its select checkbox set to checked.

     Limit Start and End Date are entered.

     Limit End Date is greater than or equal to Limit Start Date.

For each selected Limit Set, the system validates that all required fields have entries  and the following business rules:

Target Permitted Feature ID and Limit Set Designator

     Combination of Target Permitted Feature ID and Target Limit Set Designator must be unique for the current version of the target permit.

     Permitted Feature ID must be at least three and a maximum of 4 alphanumeric characters.

     Limit Set Designator must be at least one and a maximum of 2 alphanumeric characters.

Number of Report Units/Number of Submission Units

     Scheduled Limit Sets

-   Number  of Reports and Number of Submission Units must be entered.

-   Number of Submission Units must be greater than or equal to the Number of Report Units.

-   Number of Submission Units must be evenly divisible by the Number of Report Units.

     Unscheduled Limit Sets

-   Number of Reports Units must be entered.

-   Number of Submission Units must be blank.

Initial Monitoring Date (Scheduled Limit Sets only)

     The Initial Monitoring Date (IMD) must be less than or equal to the target Permit Expiration Date.

     If IMD is less than the target Permit Effective Date, Initial Monitoring Period End Date (IMPED) must be greater than the source Permit Effective Date.  IMPED is calculated using the following formula: IMPED = IMD + (Number of Report Units x Calendar Month) - 1 Day.

Initial DMR Due Date (Scheduled Limit Sets only)

     The Initial DMR Due Date (IDDD) must be greater than the Initial Monitoring Period End Date (Initial Monitoring Period End Date = Initial Monitoring Date + (Number of Report Units x Calendar Month) - 1day)).

     The IDDD must be greater than or equal to the earliest possible submission due date (Initial DMR Due Date must be >= Initial Monitoring Date + (Number of Submission Units x Calendar Month) - 1 day)).

Copy Limits

     For each parameter on the source Limit Set, the system identifies the Base limit or Permit Modification Limit (PML) segment in effect as of the current date (note, if an Enforcement Action limit segment is in effect, that segment will be ignored and the next segment in the hierarchy will be selected).  All limits will be created on the target permit as base limits, regardless of whether they were Base or PML Limits on the source permit.

-   A parameter is defined by NPDES ID, Permitted Feature ID, Limit Set Designator, Parameter Code, Monitoring Location Code, Limit Season ID.

-   The in effect limit meets the following criteria for a source Permit that is Effective (i.e., source Expiration Date is greater than or equal to Current Date):

v Limit Start Date is less than or equal to the current date.

v Limit End Date is greater than or equal to the current date.

v PML with the latest Modification Effective Date; if no PMLs, use the Base Limit.

-   The in effect limit meets the following criteria for a source Permit that is Expired/Admin Continued (i.e., source Expiration Date is less than Current Date):

v Limit Start Date is less than or equal to the current date.

v Limit End Date is equal to the Source Expiration Date.

v PML with the latest Modification Effective Date; if no PMLs, use the Base Limit.

Note:  Some source parameters will not have any segments in effect as of the current date and thus will not be copied forward.

Delete Limit Set

System validates that the Limit Set does not contain any Enforcement Action Limits (i.e., none of the Limits has a Change of Limit Status = Enforcement).