The Wastewater Information System Tool (TWIST)
Contents
1. cccceesseeeeeees 18 Figure 17 First Steps for Enforcing User Level Privileges ccccccsssseeceeeseeeeeeeeeeeeseeeeesaeeseeeeseaaseeeeeneas 19 Figure 18 Selecting Users to Include in the Security File ccccccccseeeeeeceeeeeeeeeeeeeeeeeeaseeeeeeeeeseessaeeaeees 20 Figure 19 Providing User Group PermMiSSIONs cccccccsseeeceeeceeeeeeeeecaaeeceeeeeeaeeeeeseeaeeeeesseeeeeesaeeseseeeeaas 20 Figure 20 Dialog Box for Adding USESS ccccccccsseseeeeeceeeeeceeeeaaeeeeeeeseeeeeeeeseaseeeeesseaseeeessaeeeeeessesageeenensas 21 Figure 21 Assigning User Group Privileges ccccccccccssseeeeeceeeeeeecceeseeceeeceaaseceessuaaseeesseaeeeeesseasseeeeeeaas 22 FIGURE 225 TWIST Database MaD nerca St Sic chea etic ease case clea ace ene esac een 28 Tables Table 1 Corresponding Form and Table Names in the TWIST Database cccccccccccescsseeeeeeeeeseeeeees 18 Table 2 List of Data Elements if TWIST erste ctossvt newcsdtartsiciicettstieanincet a a e ata aa eai 23 This text has not been reviewed for technical accuracy or adherence to EPA policy Do not quote or cite Mention of trade names products or services does not convey official EPA approval endorsement or recommendation Microsoft product screen shot s reprinted with permission from Microsoft Corporation For more information about TWIST contact Rod Frederick 202 566 1197 or Robert Goo 202 566 1201 at EPA or Sab2. United States Environmental Protection Agency The Wastewater Information System Tool User Guide Contents Bi PEATE GUUS TO Iasi cs cect fend terete E O E IAE E a 1 TWIST Database System Requirement cccccccseecccceeeccseeseeeeeeeeeeaeeeseeceeeeeeeseeeseeeeeeessaeaaeeeeeeeessaaeags 1 PNIS TUSSE GUJE ununa i neh aha eu led ha Gledenel cecal etek aes 1 il GETING Stared 25 isete scorers evieeinde i Aree televise ra 2 Downloading the TWIST Database circ n ceiecsetescccncceacsets ce desakelbese scadesceteieadentesdiagetededeesttielemianedegahielent 2 WO FsFe1 gla 1 10211 211 6 9 Reema eee eee re eee ee er ee ee ee eee ee eee 2 User OCI Aisi cast tesctaie the tier ot hac taal e the iet hein clases hata a aie the Lek ee 3 Iil Data MamaGeme it a a a EEO 4 NOW DAR ENUY rae a E a Ea a 6 Reviewing Dala sircriiopraci erido stiai ea aaa p Eara aapa a aA paa Ea a A R aara 14 Wie e re 1d q 6 Daleer O E tee nee eres 15 Generating Data REDOrts cccccceccceccceecceeseseeccceeeeeeaeeseeeeeeesseeeueeeeeeeeessseasaseeeeeeesssaaaaeeeeeesseaeaaaeeeeeeees 16 IV Database DOS I Gin aen a e a a 17 Adding New Data Fields or Modifying Fields ccccccsssseccccceeeceeccsesececeeeeeeeeeeseeeuseesesageeeessaaageeesess 17 EMOrcinG WSerLCVel PMIVIICGCS xesitsecds vacasaudiacanad chetaslac E a R 19 V Eist of Data Elements m TWIS Trise aiana aea aeaaaee a Aaaa aaa Geta 22 Figures Figure T Database Log SClCCM tsiais sina
3. Security Wizard E Mow you can assign users ko groups in your workgroup information File Do you want to choose which groups a user belongs to or choose which users belong to a group f Select a user and assign the user to groups Select a group and assign users to the group Group or User name usert hl S8 New Data Users M lg Read Only Users Help Cancel lt Back Wesck gt Finish Figure 21 Assigning user group privileges In the next window click Finish For more details search the Microsoft Access Helpdesk for About user level security V List of Data Elements in TWIST TWIST is designed as an easy to use tool for entering storing and reporting data on onsite cluster system site locations permits services and other information The following table lists the data elements in TWIST Users can select the data fields they wish to fill in it is not necessary to fill in all the blanks For example counties in the eastern U S will not likely list the range and section location information since those terms are mostly used out West Drop down boxes with checkoff selections are used where small arrows appear to the right of the data field title Text entries should be typed in where the data field box does not show a drop down arrow Local users should coordinate and agree on which data fields will be used and how terms are defined locally before using TWIST Users can adap
4. OperatingPermitType_ID Figure 2 OperatingPermitType_Name ViolationTypes TWIST Database Map PK Milan 10 i ViolationType_Name Pome PK FK4 I5 Permit ID FK6 17 Property_ID FK5 PermiteeName_ID States PermitViolation SystemPermitNumber FK3 16 PermitType_ID PK State ID PK I3 PermitViolation_ID Datelssued State Name i2 Permit_ID a i Se Ge IsBuildingPermitFeePaid ermitViolationNumber lsOtherFeePaid InvestigatorName IsVariancelssued Addresses l1 Investigator _I D TypeOfVariance ActionTaken IsOperatingPermitNeeded AptOrSuite A F OperatorName_ID Street SVOMpPllaNncesOnnirme 14 Operator_ID City isFineAssessed FK2 OpertingPermitType_ID FK1 State FineAmount OperatingPermitNumber 12 ZipCode IsFinePaid OperatingPermitExpiry OperatingPermitFee a l1 IsOperatingPermitFeePaid FK1 InspectionFrequencyType_ID InspectionFrequency PumpoutFrequencyType_ID aa PumpoutFrequency Facilities IsEffluentSampled WaterSupplySources PKI Facility ID EffluentSamplingFrequencyType_ID PK 11 WaterSupplySource_ID IsaWSampled FK3 18 TreatmentSystem_ID GWSamplingFrequencyType_ID WaterSupplySource_Desc FK1 l2 Faciltiy Address_ID lsMaintenanceContractNeeded FK2 Facility_Type_ID 12 MaintenanceContractld Other Facility Type 13 MaintenanceContractor_Name_ID Facility_Area Facility 13 Number_of_Bathrooms acility Types 14 Number_of Bedrooms PK I1 FacilityType_ID I
5. The Wastewater Information System Tool TWIST Main Form Current User System User Agency Division Division 1 Local Office Name OFFice 1 Enter New Complaint Enter New Service Information Update Existing Data Lookup Existing Data Generate Report Logout Form Wier Figure 3 TWIST Main Form This form is the starting point for all data management activities lil Data Management After successfully logging into the system the user can begin to enter or view data From the TWIST Main Form Figure 3 the user can enter new data update existing data view existing data and view a sample report Instructions for these activities are provided later in this section It is important to note here that various data categories are linked together and in some cases dependent upon other categories That is some data cannot be entered until other prerequisite data are entered first Several of these connections are illustrated in Figure 4 For illustrative purposes only Figure 4 divides data into three categories Tier 1 Tier 2 and Tier 3 Nearly all data in TWIST is dependent upon the data entered in General Site Information represented by a clear box in Figure 4 and labeled TIER 1 Until data are entered in the General Site Information data form data regarding permits site details and the wastewater treatment TWIST User Guide October 2005 system represented by the TIER 2 Permit Information Site Eval
6. x File Edit Insert Records Window Help Type a question for help X The Wastewater Information System Tool TWIST Edit or Lookup Existing Data Current User System User Agency Division Division 1 Local Office Name OFFice 1 Service Report Information Complaint Information Return To Main Form Logout Form Wiem Figure 13 Edit or Lookup Existing Data window This is accessible via the TWIST Main Form and allows the user to access and review information that has already been entered Clicking on the Site Related Information button allows the user to view previously entered data in the General Site Information Permit Information Site Evaluation Information Treatment System Information and Facility Information forms Important Note While the Service Reports form can be located in this manner Whe a eink by navigating through the Treatment System Information form Existing Data mode users cannot modify it can also be accessed directly by clicking on the Service existing data or create new records Report Information button in Figure 13 Finally Complaint form can be reviewed by clicking on the Complaint Information button in Figure 13 Updating Data To modify previously entered data first click on the Update Existing Data button on the TWIST Main Form Figure 3 This will generate a form similar in appearance to form in Figure 13 15 TWIST User Guide October 2005 Clicking on the Site Related Inf
7. 1 General Site Information form is completed Step 3 Site Evaluation Information Another TIER 2 data element Site Evaluation is also tied to the General Site Information form Hence the user can enter Site Evaluation information only after the General Site Information 1s entered To get to the Site Evaluation form Figure 8 click on the Site Evaluation button located on the right side of the General Site Information form After entering and saving data the user can return to the General Site Information form by clicking the Return to Site Info button Alternatively the user can return to the TWIST Main Form Figure 3 by clicking the Return to Main Form button TWIST User Guide October 2005 Microsoft Access SiteEvaluationinfo Ale Edt whew Inget Format Herod Ink Window Help a ee hA Rod ALI UTA be bx cot oo amp M5 Sans Serit 3 Biu a l A F a The Wastewater Information System Tool TWIST Site Evaluation Information wle Descnplion ouil Analysis enn Soil Analpsiz Type Dale of Evalualon o MMDD YYY l Evalualur Hame Evaluator ID O Soil Analytic Result Did Site Pass Evaluation Depth of Pit for Pit Dore Hole ita O Neco Rata itor Porca Teni Soum SSE M Infiltration Area Landscape Information 1s Soil Compacted Return to Main Form eds bal ba i Depth To Seaconal Ground Water Landscape Position Ej Perched Ground Water Slope Angle Hor to Ver Depth
8. Downing Street Zip Code ine Cily London Return fn lookup Form Phone 999 999 9999 State A EL Zip Code E eee sjack email com Phone _ 399 999 9999 Email __sjackigfiernail com Registration Lives o y ssj Edits will only be saved by clicking the Save button Figure 9 Treatment System Information form This TIER 2 data cannot be entered until the TIER 1 General Site Information form is completed The Treatment System Information form has two TIER 3 data elements associate with it Service Report and Facility Important Note Information see Figure 4 If accessing the Service Report form via the TWIST Main Form the user must manually select the appropriate treatment system control ID from the The Service Report form Figure 10 can be accessed from the pull down menu see Figure 10 If Service Report Treatment System Information form by clicking the Service accessing the Service Report from via Reports button In addition the Service Report form can be the Treatment System Information reached from the TWIST Main Form Figure 3 by clicking form the treatment system control ID i i ically the Enter New Service Information button is selected automatically After entering data in this form the user can return to the Treatment System Information form by clicking the Treatment System button on the right side of the screen Alternatively the user can return to the TWIST Main Form by clicking the
9. Return to Main Form button 11 TWIST User Guide October 2005 E State Wastewater Information System Enumerator Stabe WISE Service Reports Ale Edit insert Records wanda Help The Wastewater Information System Tool TWIST Service Reports Trealment Syslem Site Address Selact Treatment 0 g Glee Syttem Control 1D General Intormabon Inspection Info Components Info Repair Info Service Information Demice Date Name List Derice Provider Name Aparrtment of Suite Treatment Sustem Sheet Return to Main Form Cily State Zip Code Fhone Number Email Registration License ou Ty he tiite will only he saved hy clicking the Save houttan Figure 10 Service Report form A TIER 3 data element this form is connected to the TIER 2 Treatment System Information form and is also accessible from the TWIST Main Form Facility Information The Facility Information form Figure 11 describes the structure served by the treatment system This form can be accessed from the Treatment System Information form by clicking the Facility Served button After entering data in this form the user can return to the Treatment System Information form by clicking the Return to Treatment System button on the right side of the screen Alternatively the user can return to the TWIST Main Form Figure 3 by clicking the Return to Main Form button 12 TWIST User Guide October 2005 E Microsoft Access TWIST Facility Serv
10. User Guide October 2005 F State Wastewater Information System Enumerator State WISE State WISE Site Information a a __ ol a a Type a question For help he Wastewater Information System Tool TWIST General Site Information Permit Into Site Evaluation Hreatment System Figure 5 General site Information form showing the Ownership set of data fields With few exceptions data must be entered into this TIER 1 form before data can be entered into other forms TWIST User Guide October 2005 FQ State Wastewater Information System Enumerator State WISE State WISE Site Information e File Edit Insert Records Window Help Type a question For help The Wastewater Information System Tool TWIST General Site Information Ownership Property Information eee Property Details County Place Type Township Place Name Range Zoning Classification Section In Overlay Zone Pernt Info Site Evaluation Plat Overlay Zone Designation 1 Treatment System Lot Number Overlay Zone Designation 2 Return to Main Form Tax Number Property Control ID Parcel Or Lot Size Geographic Coordinates ACMA l Latitude Oo Longitude oO w j v Edits will only be saved by clicking the Save button County where the property is located Figure 6 General Site Information form showing the Property Information set of data fields Step 2 Permit Information As a TIER 2 data element Pe
11. _ _ _ _ Addresses Personnels Personnels serviceReports serviceReport SsiteEvaluation nfo siteEvaluationinfo Sitelnfo Properties TreatmentSystem TreatmentSystem 18 TWIST User Guide October 2005 Enforcing User Level Privileges It may be necessary to specify the individuals who can access the database from a shared network Instructions for doing this are provided in this section To do this click on Tools Security User Level Security Wizard as shown in Figure 17 Microsoft Access File Edit View Insert Tools Window Help Dee Bias Spelling Re a 23 fee TWIST Database Analyze b lationships Open Design Database Utilities Objects Set Database Password _ Tables Startup workgroup Administrator H Queries Macro User and Group Permissions Customize User and Group Accounts Options User Level Security Wizard 2 kE Fages Encode Decode Database Macros ee Modules Groups E Permitviolation Favorites Personnels ServiceRepoarts FrmLbLogin MainForm Permit Figure 17 First step for enforcing user level privileges In the window that opens check Create a new workgroup information file and click Next Provide the file name optional name and company name in the following dialog box Make sure that I want to create a shortcut to open my security enhanced database is selected and click Next In the next dialog box
12. a user name and password must be entered First time users must register before being allowed to log on TWIST User Guide October 2005 User Registration To create a new user register a new account click the Register button on the database Login screen Enter all the information on the user registration screen Figure 2 and click the Register button If the registration was successful the user will be re directed back to the database Login screen Figure 1 State Wastewater Information System Enumerator State WISE Personnels ol x File Edit Insert Records Window Help Type a question For help amp The Wastewater Information System Tool TWIST User Registration First Time Registration Hame Agency Division Local Office Name User Name Password Yenty Password Cancel Register Form view Figure 2 User Registration screen First time users must complete the fields on this screen before being permitted to log in to the database User Login To log in to the database returning users and first time users who have registered can enter their user name and password while on the database Login screen Figure 1 Click the Login button to complete the log in process The TWIST Main Form Figure 3 will then appear TWIST User Guide October 2005 State Wastewater Information System Enumerator State WISE MainForm Form _ o File Edit Insert Records Window Help Type a question for help x
13. sactmodcehasinancsdandscdsadtewdcy S A E E IEA 2 Figure 2 Wiser AeGiStration SClCOM sisaan ae aa aaa aa r aA N 3 FOUE TWIS Talis O N aian a N EAE AT detec 4 Figure 4 Relationships Between Various Data Elements in the TWIST Database cceeeeeeeeeeetteee 5 Figure 5 General Site Information Form Showing the Ownership Set of Data Fields ccecceeeseeees 7 Figure 6 General Site Information Form Showing the Property Information Set of Data Fields 8 Foure 7 PCLMIEINTORMATION FOM yss a aa 9 Figure 8 Site Evaluation Information Form cccccccsseeceecsceseeceececeseeeeesscseeeeessosseeeeecesseeeesscaseseeeseses 10 Figure 9 Treatment System Information FOr cccccccsssseeeecceeseceecceeseeceeecseeeceesseaaeeeesesaseeeesssaseeeseesaas 11 Figure TO SERVICE REDON FON cuiner a i a a a a e a eE E 12 FIGUre T11 Facility Iniormalion FORM sisone E a A Ea EEEE Da 13 Figure 2 Compan FOr oeae a E a A a O a 14 Figure 13 Edit or Lookup Existing Data Window cccccccseeeeeceeeeeecaeeeeesaeseeeeeaueeesaeeeessaeeeeneaseeesseneeeeas 15 Figure 14 Generate Reports WINdOwW cccccccccssssseecceeeeeeaeeeeeeeeeeeseeeesseeeeeeeesaeeaseeeeeeeeseaseeeeeseseeseaaaaeess 16 Figure 15 TWIST Database Window Showing the Database s List Of FOrMS cccseeeeeeeeeeeeeeeeeeeaees 17 Figure 16 Dialog Box for Adding or Modifying a Data Field in the TWIST Database
14. select the objects tables queries etc to which security options will be applied and click Next Select the groups of users to include in the security file Figure 18 and click Next 19 TWIST User Guide October 2005 Security Wizard These optional security group accounts each define specific permissions For the users You Will assign to the group Click a group to see a list of the group s permissions what groups da you want to include in your workgroup information File Backup Operators Group name Read Only Users Full bata Users bas Group ID BIBIDMSONy4z5WbNKYG Full Permissions Mews Data Users Group permissions Project Designers This group can read all data but can t alter Acc LL eee data or the design of any database objects Update Data Users Each group is uniquely identified by an encoded value generated From the combination of its name and its Group ID which is a unique alphanumeric string 4 20 characters long Help Cancel lt Back Meck gt Finish Figure 18 Selecting users to include in the security file In the next dialog Figure 19 provide permissions to the user groups and click Next Security Wizard All users belong to khe Users group in all workgroup information Files By default the wizard assigns na permissions bo the Users group buk you may wank to assign limited permissions to this group Don t assign Full permissions to the Users group because this will remove al
15. 5 Number_of Employees 16 Number_of_Guests Persons PermitTypes FacilityType_Name E Use PK I2_ Persons 1D PK 11 PermitType Id IsCommercial SeasonPeriod _ Has_In_Sink_Grinders Persons Name PermitType_Name Has_Hot_Tubs FK1 11 Address_ID I7 Number_of_Hot_Tubs 13 PhoneNum Capacity_of_Hot_Tubs Email Has_Water_Softener Li Numb Additional Special_ Fixtures PSR RATS FrequencyTypes Year_Structure_Built PK PeriodType ID Is_Rental_Property Last_Property_ Transfer PeriodType_Desc FK4 I9 Water_Supply_System_ID Other_Water_Supply_System PlaceTypes PlaceType ID PlaceType_Desc Complaint TreatmentSystem PK I1 Complaint_ID PK I8 TreatmentSystem_ID SiteEvaluation nfo Control_ID FK5 I7 Property_ID FK1 14 TreatmentSystem_Address_ID 11 Controlld PK l4_ SiteEvaluation_ID FK2 12 Complaint_Type_ID 14 NumberOfStructures Properties Complaint_desc Datelnstalled FK1 I3 Property_ID FK3 I2 Installer_ID PK I1 Property ID ControLID InstallerRegNumber DateOfE valuation Homeowner ID FK1 12 Property_Owner_ID EvaluatorName SystemManager_ID 14 System_Owner_ID Evaluator_ID DesignFlow County DidSitePassEvaluation ComplaintTypes WasteStrength Township AreaSystemDes NonConventionalWastes Range SoilAnalysisType_ID PK I1 ComplaintType_ ID Tank1 Size Section OtherSoilAnalysisType Tank1 MaterialType ID Plat SoilDrainageClass_ID ComplaintType_Desc Tank2Size T LotNumber DepthofPit Tank2MaterialType_ID TaxNumber PercolationRate SepticTank1 Size Parc
16. To Bedrock Cutam Diam Needed If Other Specify Curtain Dram Installation Available Draintield Area Dranheld Area Heplaced Replaned Ara gt j Fidits will only he saved hy clicking the Save hutton Figure 8 Site Evaluation Information form This TIER 2 data cannot be entered until the TIER 1 General Site Information form is completed Step 4 Treatment System Information The third TIER 2 data element shown in Figure 4 Treatment System Information is also tied to the General Site Information form The Treatment System Information form Figure 9 is accessed by clicking the Treatment System button on the General Site Information form 10 TWIST User Guide October 2005 E State Wastewater Information System Enumerator Stabe WISE TreatmentSystem Form Hle Edit insert Records windia Help The Wastewater Information System Tool TWIST Treatment System Information Goneral Info Tank Info Treatment ElecLlricalfMerhanical Fealures Infiltration Setback System Delails SysLem Manager Control Id o Hame ist C Number ot Structures Name Clack weh Date Installed MM DD i Apartment or Suite 201 Installer Details Sheer 1 oening rert Name ist 7 Service Reports N Jock Welsh City London mah Facility Served Apartment or Suite 201 State Massachusetts i 1 Downing Street Return to Site Info Street 1
17. ankRepairNeeded Pune DistributionSystemTypes PK I1 SoilAnalysisType_ID IsInfiltFieldRRNeeded 13 NumberOfPumps AIAG ae IsPumpsRRNeeded HasTimers p PK I1 DistributionSystemType_ID SoilAnalysisType_Name CompSystemP eet __ DistrioutionsystemType_Dese IsCompSystemRRNeeded HasSiphon DistributionSystemType_Desc ComplianceRequiredDate HasAlarms ComplianceAchievedDate AlarmType MaterialTypes l2 NumberOfTanksPumped HasModelOrRemoteSensor PKI PK I1 MaterialType_ID Se ee HasGWWellWithin200Ft 13 SeptageDestination_ID IsWelllnUse MaterialType_Desc ManifestControl DepthOfWell I6 SystemRapairControl_ID DistanceToWaterbody PostTankTreatmentTypes TypeOfRepair Waterbody N YeNeITe PK I1 PostTankTreatmentType_ ID ull eat DistanceToPropertyLine Sere ae DistanceToStructures PostTankTreatmentType_Desc 28
18. be saved In a shared database file make sure that the file is NOT read only oo o i ata simultaneously but only one To verify this go to the correct file directory and right person at a time can make database click on the newly copied file name Click on design changes to the database See Properties If the Read Only box at the bottom of the the Database Design section of this dialog is checked un check the box and click OK User Guide for more information To open the database go to the correct file directory and double click the file name If a Security Warning dialog box opens with Do you want to open this file or cancel the operation click Open The database Login screen will appear Figure 1 E State Wastewater Information System Enumerator StateWISE TWIST Login Sigg File Edit Insert Records Window Help Adobe PDF Type a question for help amp X The Wastewater Information System Tool TWIST Uraft Beta best version of July UUE USEPA s Microsoft Access based Data Management Tool developed to manage the onsite and clustered wastewater treatment systems This tool weas deweloped for US CPA by Tetras Tech as a serwice to state and local agencies invebred with managing decentralized wastewater treatment systems Mo updates are planned Users may adapt or amend this tool without restriction Figure 1 Database Login screen To enter information into the database or to view stored data
19. d or Gravel Mound Type Contained in Tank Structure Textile Compartment Peat Modules Other Media Specify Recirculation Y N Sequencing Batch Reactor Soil Infiltration System Infiltration Area __s sq ft Depth of Infiltration System _ inches Distribution System Type Perforated Pipe amp Aggregate Leaching Chambers Gravelless Pipe Pipe amp Plastic Other Drain Modules Pressure Drip Tubing Seepage Pit Spray Field Evaporation Field Trenches Other Specify of Trenches Lines Total Length of Trench Lines _ft Observation Wells in Trenches Y N Surface Discharging System Y N Receiving Water Name NPDES Permit Flow Gravity Flow Pumped Distribution Service Information Service Date DD MM YYYY Service Control or ID Service Provider Name Apt Suite PO Box Street City State Zip Code Phone Email Registration License 26 TWIST User Guide October 2005 Septic Tank 2 Size _ Gallons Type of Material Concrete Plastic Fiberglass Metal Manufacturer Compartments 1 or 2 Septic Tank 3 Size___ Gal Type or Material Concrete Plastic Fiberglass Metal Manufacturer Compartments 1 or 2 Tank Risers Above Final Grade Y N Effluent Filter s on Tanks Y N Electrical Mechanical Features Pumps Y N of Pumps Timers Y N Float Switches Y N Siphon Y N Alarms Y N Alarm Type Modem or Remote Sensor Y N Infiltration System Setbacks Groundwater Well Within 200 ft Y N Distance to Well_ ft We
20. ed t joj x File Edit Wew Insert Format Records Took Window Helo Type a question for help Gl Tean Bi UES BE MS Sans Serif The Wastewater Information System Tool TWIST Facility Information Facility Address Apartment or Suite Strect City Facility Delails Facility Type Haz Hot Tubs Other Facility Type Humber of Hot Tubs Capacity of Hot Tubs Ea DoOoOooooo Number of Bathrooms ae Has Water Softener OoOo i oOo Fauilily Aea Humber of Bedrooms Additional Special Fixtures Humber ul Nerupants F mplnpers Year Structure Built Number of Guests ls Rental Property Last Property Transfer Seasonal Use Only xl 7 a ET l Water Supply Source El Return to Treatment System cormorant J Other Water Supply Source Has In Sink Grinders Return to Main Form 4j v gt Edits will only be saved by clicking the Save button Aparbment or suite number Figure 11 Facility Information form A TIER 3 data element this is connected to the TIER 2 Treatment System Information form Step 5 Complaint Optional Completed as Needed As mentioned previously in this document and illustrated in Figure 4 the data for the Complaint TIER 3 element can be entered even if the user does not enter related TIER 2 Treatment System Information This goes against the general rule that TIER 2 data is required before TIER 3 data can be entered This exception is in t
21. elOrLotSize IsSoilCompacted SepticTank1MaterialType_ID FK2 FK3 Place_Type_ID DepthToSeasonalGW ServiceReport SepticTank1 Manufacturer Place_Name IsPerchedGW SepticTank2Size ZoningClass DepthToBedrock PK I5 Servicelnfo_ID SepticTank2MaterialType ID IsOverlayZone IsCurtainDrainNeeded SepticTank2Manufacturer OverlayZoneDesignation1 CurtainDrainInstallation FK3 I7 Treatment_System_ID SepticTank3Size OverlayZoneDesignation2 AvailableDrainfieldArea ServiceDate FK2 SepticTank3MaterialType_ID I3 PropertyControl_ID IsDrainfieldAreaReplaced 14 ServiceControl_ID SepticTank3Manufacturer Latitude ReplacedArea FK2 ServiceProvider_ID SepticTank1 Compartments Longitude LS_Type Pre CoverConsInsp SepticTank2Compartments LS_Top_Of_Slope Regularlnsp SepticTank3Compartments LS_U_Slope_Shoulder ComplaintDate IsTankRisersAboveFinalGrade LS_M_Slope l1 ComplaintControlld IsEffluentFiltersOnTanks z gt LS_L Slope FK1 NatureOfComplaint_ID FK4 I6 PostTankTreatmentType_ID SoilDrainageClassTypes LS _Toe_Slope ComplaintReferredTo HasRecirculation SoilDrainageClassType_ID LS_ Floodplain IsSystemInCompliance SoillnfiltrationArea LS_Slope_Angle gt Be SoillnfiltrationDepth SoilDrainageClassType_Desc anksinspecte FK1 19 DistributionSystemType_ID InfiltrationAreas 15 NumOfTreches IsFloatSwitchInsp LengthOfTrenches AreAlarmsinsp IsObservationWellsInTrenches IsinstPanellnsp ReceivingWaterName 5 ArePumpsinsp NPDESPermitNumber SoilAnalysisTypes OtherCompInps FlowType i IsT
22. er Facility Type Specify __ _ 24 Local State NPDES Operating Permit Date of Permit Expiration Permit Fee Amount Fee Paid Y N Operating Permit Conditions Inspections Monthly Quarterly Annually Every Years Pumpout Every _ s Years Effluent Sampling Y N Monthly Quarterly Annually Groundwater Sampling Y N Monthly Quarterly Annually Facility Information Facility Square Footage __ sqft Bathrooms Sleeping Rooms Employees Customers Guests Seasonal Use Y N Months in Use MM MM Special Fixtures In Sink Grinder s Hot Tub s Drained to Treatment System of Hot Tubs Hot Tub s Capacity _ Gallons Total Water Softener Other Specify Approximate Year Structure s Built YYYY Rental Property Y N Last Property Transfer MM YYYY Water Supply Source Public Water Line Well Private Public Cistern Lake Spring Other Specify Untreated Treated Site Evaluation Information Treatment System Site Description Control or ID Date of Site Evaluation DD MM YYYY Evaluator Name Evaluator ID Site Passed Evaluation Y N Area System Density s Acre Type of Soil Analysis Backhoe Pit Auger Holes Depth of Pit Bore Hole _ ft Percolation Test __ Min Inch Other Specify Landscape Position Infiltration Area Level Slightly Rolling Top of Slope Upper Slope Shoulder Middle of Slope Lower Slope Toe of Slope Floodplain Slope Angle Horiz to Ver Installation Info
23. he database because in many cases public complaints about wastewater treatment systems must be recorded before specific information about the problem treatment system is known This allows for electronic reporting even in cases where a treatment system is not entered into the database Thus for information collection purposes the Complaint data element is not fully dependent upon the treatment system information The Complaint form Figure 12 1s reached via the TWIST Main Form Figure 3 by clicking on the Enter New Complaint button 13 TWIST User Guide October 2005 State Wastewater Information System Enumerator StateWISE TWIST Complaint i ble Edr Insert Records Wine Help adabe POF The Wastewater Information System Tool TWIST Complaint Treatment System Location palmenl w Sule General Information Complaint Control ID Complaint Type Complaint Description TEdits will only be saved by clicking the Save button Figure 12 Complaint form This form is loosely connected to the Treatment System Information form but is not fully dependent on Treatment System Information data Reviewing Data To review previously entered data first click on the Lookup Existing Data button on the TWIST Main Form Figure 3 This will generate a form Figure 13 similar in appearance to the Main Form 14 TWIST User Guide October 2005 my State Wastewater Information System Enumerator State WISE Lookup Data oO
24. l security Would wou like bo grant the Users group some permissions i Yes I would like to grant some permissions to the Users group C No the Users group should not hawe any permissions Database Tables Queries Forms Reports Macros al Open Fun E Read Data E Open Exclusive E Update Gate E Modify Design E Insert Data E Administer E belete Data Figure 19 Providing user group permissions 20 TWIST User Guide October 2005 Create users in the next dialog Figure 20 Type in the User Name and Password then click on the Add This User to the List button When finished adding users click Next Security Wizard B Mow vou can add users to your workgroup information file and assign each user a password and unique Personal ID PID To edit a password or PID click a name in the box on the left what users do you want in your workgroup information File F Add Mew Leer User name HAA Sabu paul useri Password ae PID Th wATMrBstAjlpZqzF dd This User bo khe List Delete User Fron the List Each user is uniguely identified by an encoded value generated From the user name and PIC The PID is a unique alphanumeric string 4 20 characters long Help Cancel lt Back MHexk gt Finish Figure 20 Dialog box for adding users Assign user group privileges to newly created users or assign users to different groups Figure 21 Click Next 21 TWIST User Guide October 2005
25. ll in Use Y N Depth of Well _ft Distance to Stream Lake Wetland ft Stream Lake Wetland Name Distance to Property Line s _ft Distance to Structures s _ _ft Tank Pumpout of Tanks Pumped Gallons Pumped Septage Destination Septage Destination ID Control Manifest Control System Repair Control or ID Type of Repair Tank Repair Replacement Pumps Switches Infiltration System Rehabilitate Infiltration System Replace Infiltration System Other Specify Complaint Inspection Pre Coverup Construction Inspection Regular Scheduled Inspection Complaint Investigation Complaint Received Date Complaint Control ID Nature of Complaint Sewage Surfacing Discharge to Water Body Odors No Installation Permit Installation Sediment Runoff Complaint Referred To Specify Components Inspected Tank s 1 2 3 Infiltration Area s 1 2 3 Float Switches Alarms Instrument Panel Pumps Other Components Specify Address Control or ID Number Complaint Type Complaint Description 2 TWIST User Guide October 2005 System In Compliance Y N Repair Needed Y N Tank Repair Replacement Needed Infiltrat Field Repair Replacement Needed Pumps Control Repair Replace Needed Media Filter Repair Replacement Needed Complete System Replacement Needed Compliance Required By DD MM YYYY Compliance Achieved On DD MM YYY System to be Replaced Y N New Permit TWIST User Guide October 2005 OperatingPermitTypes PK I1
26. ober 2005 IV Database Design The regular menus and toolbars are disabled when the user opens the database To be able to modify the database design or functionalities press and hold the Shift key while opening the database The database is in an editable mode when the screen shown in Figure 15 appears E Microsoft Access Me x E File Edit View Insert Tools Window Help Type a question for help OBA RIERYV 42 BlY F l Dolm lsa ofF fe TWIST Database Access 2000 file format Objects _ Tables Queries ShowReports SiteEvaluationInfo Addresses a SiteInfo Complaint TreatmentSystem EditData Reports 2 Pages 2 Macros Facilities FrmLatlong Frmbogin MainForrmi amp Modules Groups Permit Permitviolation Favorites Personnels Cul i i i i i i i il i i ServiceReports Figure 15 TWIST database window showing the database s list of forms Adding New Data Fields or Modifying Fields With the database in the editable mode and the screen in Figure 15 is showing select Tables in the Objects list Right click the table to be modified and then click on Design View This will open the desired table in design view To add a new field move below the last existing field type the field name in the Field Name column and select the field data type under the Data Type column Figure 16 The user can optionally insert information about the newly added field under the Descrip
27. ormation button allows the user to locate and modify previously entered data in the General Site Information Permit Information Site Evaluation Information Treatment System Information and Facility Information forms Accessibility to different forms is the same as mentioned in the section New Data Entry found previously in this User Guide Unlike the Lookup Existing Data mode new records can be added to TWIST database while in Update Existing Data mode Generating Data Reports The TWIST Main Form contains a Generate Report button Clicking this button takes the user to the window shown in Figure 14 From this window the user can produce various data summaries By clicking the Site Report button the user can view tables containing all the data entered in the General Site Information form Site Report is the only active button in the Generate Report window The user would need to activate the other reports by modifying the database FD State Wastewater Information System Enumerator StateWISE Generate Report i Ale Edt Insert Reronds Windia Help adabe POF The Wastewater Information System Tool TWIST Generate Reports Current User Ron Agency Division Coastal Carolina Local Ottice Name Chanticleers Site Report Reluonn Ty Main Furmi Figure 14 Generate Reports window This is the starting point for creating reports The TWIST user would need to modify the database to generate other reports 16 TWIST User Guide Oct
28. refore some of the functionalities may not work on earlier versions The operating systems should be Windows NT or higher TWIST User Guide This document is provided as guidance for TWIST database The User Guide is divided into two major sections for two slightly different audiences The first section Data Management instructs the TWIST user on entering searching and modifying data This section is written for beginners who don t need to be very familiar with Microsoft Access The second major section Database Design is written for users who might want to modify the TWIST database create new forms or otherwise make changes to accommodate specific user needs This section Important Note would be most applicable to the intermediate or advanced Microsoft Access user Questions about the TWIST database or User Manual should ae i i be directed to Rod Frederick The User Guide is not intended to offer instructions on using 202 5661 197 S Microsoft Access For such guidance the user should refer to 202 566 1201 at EPA the Helpdesk available in the software TWIST User Guide October 2005 ll Getting Started Downloading the TWIST Database Important Note The database is available on CD and the Internet at If making the database accessible to www epa gov and may be copied onto a local or shared many users at the same time the folder as C Twist for example After copying the database must
29. rmation Control or ID of Structures Served _ Date Installed DD MM YYYY Installer Name Apt Suite PO Box Street City State Zip Code Phone Installer Registration License Certification System Manager If Not Homeowner Homeowner Other Manager Name of Manager Apt Suite PO Box Street City State Zip Code Phone Wastewater Information Design Flow __ Gallons Per Day Waste Strength Moderate e g Residential High e g Some Kitchen Service Very High e g Restaurant Non Conventional Wastes Specify 25 TWIST User Guide October 2005 Soil Analysis Results Soil Drainage Class Excessively Drained Somewhat Excessively Drained Well Drained Moderately Well Drained Somewhat Poorly Drained Poorly Drained Very Poorly Drained Soil Compacted Y N Depth to Seasonal GW inches Perched GW Table Y N Depth to Bedrock __ inches Curtain Drain Needed Y N Curtain Drain Installation NESW side Available Drainfield Area__ sqft Drainfield Replacement Area Y N Replace Area__ sqft Tanks Grease Trap Tank 1 Size __ Gallons Type of Material Concrete Plastic Fiberglass Metal Grease Trap Tank 2 Size __ Gallons Type of Material Concrete Plastic Fiberglass Metal Septic Tank 1 Size ____ Gallons Type or Material Concrete Plastic Fiberglass Metal Manufacturer Compartments 1 or 2 Service Reports Post Tank Treatment Soil Infiltration Only Aerobic Treatment Unit Wetland Lagoon Media Filter San
30. rmit Information 1s linked to the General Site Information form Figures 5 6 Therefore the user can enter Permit Information only after the General Site Information data 1s entered Clicking on the Permit Info button located on the right side of the General Site Information form takes the user to the Permit Information form Figure 7 After entering and saving data the user can return to the General Site Information form by clicking the Back to Site button Alternatively the user can return to the TWIST Main Form by clicking the Return to Main Form button TWIST User Guide October 2005 a Microsoft Access Permit File Edt Yew Insert Format Records Tools Window Help MIiIHRIEGRT s BBlI SAA Bvigml gt el GS a 1 8 E Soh Ae ol oe The Wastewater Information System Tool TWIST Permit Information Permit Details Permitee Operating Permit Maintenance Permit Violations General Information _ r Special Permit Conditions System Permit Humber Yariance lssued Permit Type Type Of Yariance Permit lesuance Date Other Conditions MH DDSTYTYT Permit Fee Operating Permit Needed Back to Site Maintenance Contractor Needed __ Return to Main Form Permit Fee Pami Building Permit Fee Paid Other Fee Paid oj Edits will only be saved by clicking the Save button System permit number Figure 7 Permit Information form This TIER 2 data cannot be entered until the TIER
31. t Size In City Village Town Limits Y N City Village Town Name If Applicable Zoning Classification Overlay Zone Y N Overlay Zone Designation 1 Overlay Zone Designation 2 Property Control ID Lat Long GPS Coordinates Maintenance Contract Needed Y N Control or ID Name of Maintenance Contractor Apt Suite PO Box Street City State Zip Code Phone Email Permit Violations Date of Violation DD MM YYYY Permit Violation Violation Investigator Name Violation Investigator ID Type of Violation Sewage Surfacing Discharge to Surf Water Receiving Water Name Installed W O Permit Operating W O Permit Action Taken Specify Compliance Date DD MM YYYY Compliance Confirmed Y N Fine Assessed Y N Fine Amount Fine Paid Y N TWIST User Guide October 2005 Operating Permit Needed Y N Operator Name Type of Operating Permit Facility Served ID Number Apt Suite PO Box Street City State Zip Code Phone Email Facility Address If Different Apt Suite Street City State Zip Code Type of Facility Single Family Residence Bedrooms Baths Square Footage Multi Family Residential of Dwelling Units Multiple Single Family Homes Homes Served Commercial Public Facility Office Building Retail Store Restaurant Service Station Park Campground Youth Other Camp RV Park Camp Resort Church Airport Bar Tavern Hotel Motel Laundry Theater Industrial Sanitary Only Oth
32. t TWIST in any manner they choose such as adding or deleting data fields changing the appearance of the pages etc TWIST is a free use tool developed by US EPA and Tetra Tech as a service to state local and tribal agencies and other users from the public and private sectors 22 Data category Data elements in TWIST Main Form Agency Name Front Page Agency Division Local Office Name Person Entering Data Username Password General Site Property Owner Information Name Apt Suite PO Box Street City State Zip Code Phone Email System Owner If Different Name Apt Suite PO Box Street City State Zip Code Phone Email Permit Permit Type Information New System Installation Replacement System System Repair Holding Tank Only Other System Permit Number Permit Issued To Name ID Number Apt Suite PO Box Street City State Zip Code Phone Email Permit Details Date of Permit Issuance DD MM YYYY Permit Fee Permit Fee Paid Y N Building Permit Fee Paid Y N Other Fee Paid Y N Special Permit Conditions Variance Issued Y N Type of Variance Issued Specify Other Conditions Specify 23 TWIST User Guide October 2005 Action Taken Date DD MM YYYY Enter New Site amp Permit Info Enter New Complaint Enter New Service Info Update Existing Data Lookup Existing Data Generate Report Report Type Property Information County Township Range Section Plat Lot Tax Number Parcel Lo
33. tion column 17 TWIST User Guide October 2005 Microsoft Access Complaint Table D 2 Ioj x c Eie Edit wiew Insert Tools Window Help Type a question for help f X a h a pv A B 9 I7 e gt aG Field Mame r E Complaint ID AutoNumber F Control Ib Text Complaint control ID TreatmentSystem Address 1 Number Address ID For the treatment system Complaint Type ID Number Type oF complaint Complaint desc Text Detailed description of complaint o gt TF NewFieldname Text r Text Field Properties General Lookup Field Size Format Input Mask Caption Default Value Validation Rule Validation Text Lookup Wizard The data type determines the kind of values thak users can store in the Field Press Required Mo Fi For help on data types Allow Zera Length Yes Indexed Mo Unicode Compression Yes IME Mode No Control IME Sentence Mode None Smart Tags Design view Fe Switch panes Fl Help Figure 16 Dialog box for adding or modifying a data field in TWIST database After modifying the data field in the table add a control e g text box or combo box in the corresponding form While most forms in TWIST database have the same corresponding table name there are some exceptions Table shows the names of tables and the names of their corresponding forms Table 1 Corresponding form and table names in TWIST database Form Name Ci TatbleName _
34. u Paul or Barry Tonning at Tetra Tech 703 385 6000 TWIST User Guide October 2005 I Introduction The TWIST database was created for local county and state health departments or other agencies that need an adaptable tool for tracking and managing onsite and clustered wastewater treatment systems TWIST is designed to track information related to the facility served permits site evaluations system types services provided and complaints see Section V on page 22 for a complete list of data elements It can also provide guidance to private vendors who might be developing databases with similar purposes TWIST is a template which can be modified to meet specific Important Note needs TWIST is not a secure database Users concerned about security should TWIST is a Microsoft Access based data develop secure protocols for using management tool Because TWIST has a narrowly TWIST defined purpose it does not include the whole set of functions that can be achieved by similar Microsoft Access databases TWIST Database System Requirements TWIST is a customized Microsoft Access based database and therefore has similar hardware and software requirements as Microsoft Access TWIST can be operated on IBM compatible personal computers PCs with a RAM of 128 MB or greater The operating system should be Microsoft Windows 2000 with Service Pack 3 SP3 Windows XP or later The system is developed in Microsoft Access 2003 the
35. uation Information and Treatment System Information boxes in Figure 4 respectively cannot be entered Likewise TIER 3 data can be entered only after the requisite TIER 2 data are entered In Figure 4 the TIER 3 Complaints box is connected to the TIER 2 Treatment System Information box by a broken arrow This shows that the Complaints form is connected to Treatment System Information but unlike the other data Complaints data can be entered without corresponding Treatment System Information being entered This exception to the general rule is explained later in this section TIER 2 Permit Information Figure 7 TIER 1 TIER 2 General Site Information Site Evaluation Information Figures 5 6 Figure 8 TIER 2 TIER 3 Treatment System Information Facility Information Figure 9 Figure 11 TIER 3 TIER 3 Service Report Complaints Figure 10 Figure 12 Figure 4 Relationships between various data elements in the TWIST database TIER 3 data can be entered only after TIER 2 data which can be entered only after TIER 1 data An exception to this rule is the TIER 3 Complaints data which can be entered without the TIER 2 Treatment System Information data Boxes in this illustration also refer to figures in the User Guide showing screen shots of the various data elements TWIST User Guide October 2005 New Data Entry The bottom of each data entry form shows the following set of buttons Important Note New or edited data
36. will only be saved by clicking on the save button before moving to another record or data entry form The function performed by these buttons from left to right are navigate to the previous record navigate to the next record save current record and add a new record respectively The following sections explain how to enter first time data into the TWIST database The steps are intended as key examples illustrating the data relationships shown in Figure 4 and do not cover every data form In addition other than Step 1 the order of many steps can be arbitrary Step 1 General Site Information As illustrated in Figure 4 most data cannot be entered into the database until TIER 1 data is entered To begin entering new data click the Enter New Site and Permit Information button on the TWIST Main Form Figure 3 This will take the user to the General Site Information form Figure 5 l Important Note The General Site Information form contains two sets of data fields Ownership Figure 5 and Property Many data forms contain a field Information Figure 6 Toggle between the data field sets ee oe 7 by clicking on the tabs near the top of the general site n be completed even if the actual site information form After entering the applicable data click address does not have an apartment the save button Ey or suite number In such cases the user should enter some place holder such as the number 0 TWIST
Download Pdf Manuals
Related Search