{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Setup - START HERE","Acknowledgement","Records For Testing","SCRIPTS-MAIN","C2G3Worksheet","POSWorksheet","AutoPayWorksheet","Detailed Steps","Addendums","DropdownResources"],"not_rendered":{"charts":0,"images":53,"macros":1,"external_links":0,"defined_names":72,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Setup - START HERE","index":0,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,1],[15,0,15,1],[17,0,17,1],[43,0,43,1],[67,0,67,1],[59,0,59,1],[60,0,60,1],[2,0,2,1],[12,0,12,1]]}
["Setup - START HERE"]
[null,null,null,null,"DO NOT MODIFY THIS COLUMN!!",null,"Last Saved Date:"]
["General Information:",null,null,null,null,null,{"$f":"LastSaveDate()","v":"2017-09-16T19:38:52"}]
["Client Name:"]
["Client ID:"]
["Person Completing Form:"]
["Time Frame of Testing (Test Window or At Go-Live)?","CLICK TO SELECT"]
["Date Testing Started:"]
["Date Testing Completed:"]
["CUSTOMER COMPLETION ACKNOWLEDGEMENT (IMPORTANT): \nPlease read the acknowledgement at the following link, and then enter  your initials on the right to confirm testing completion"]
["Additional Notes:"]
[]
["IMPORTANT: Please see section \"How to Complete this form\" for more info"]
[]
[]
["Apps / Components to be Installed / Tested:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Link / Control Cells"]
["Component","Details / Notes"]
[null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,true]
[null,null,null,null,false]
[]
["Proceed to Test Records Sheet"]
["Proceed to MAIN SCRIPTS Sheet"]

{"sheet":"Acknowledgement","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,13]]}
["Completion Acknowledgement"]
["I confirm that (client name) has, in working with Superion resources, tested all required payment functionality utilizing the Paymentus User Acceptance Testing (UAT) system and I approve that we are ready to deploy the system in production. I also confirm that the payment transactions are posting correctly to my Superion systems, and I accept the reporting batch/bank cut-off time agreed upon (typically 12:00 AM EST) that is included in the SunGard sign-off checklist."]
[]
["Return to Setup Page and enter initials to acknowledge"]

{"sheet":"Records For Testing","index":2,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[20,0,20,1],[21,0,21,1],[22,0,22,1],[0,0,0,13],[3,0,3,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[16,0,16,1]]}
["Records for Testing"]
["Back to Setup Sheet"]
[]
["Card and Checking Account Info for Pre-Go-Live Testing Window (Pointing to TEST Paymentus Environment)"]
["Payment Method ","Account Information "]
["MasterCard (Credit/Debit) ","Account number:  5454 5454 5454 5454 "]
["  ","Expiration month:  any future month date "]
["  ","Expiration year:  any future year "]
["  ","CVV2:  111 "]
["Visa (Credit) ","Account number:  4444 4444 4444 4448 "]
["  ","Expiration month:  any future month date "]
["  ","Expiration year:  any future year "]
["  ","CVV2:  111 "]
["E-check ","Routing Number:  122000247 "]
[]
["ADDITIONAL NOTES:"]
["Can also use a valid card for testing - will not process actual hold on funds if processing against TEST Paymentus environment"]
["POS Keyed transactions can use above values or a valid card number"]
["POS Swiped Transactions will require valid card (see note above will not process actual hold on funds"]
[]
["Notes on Card and Checking Account Info for Go-LiveTesting Window (Pointing to PROD Paymentus Environment)"]
["Must use valid card and checking account info for all testing"]
["Will be able to void approved transactions, although must process at least one transaction through to posting (will be able to credit that back to card)"]
[]
["Record Type","Record Value(s) in TEST environment","Record Value(s) in PROD Environment","C2G3 URL (if applicable)","How to Obtain Value / Details"]
["C2G3 NaviLine:"]
["Single Sign On (SSO) Profile(s) - Multiple C2G app records could be associated with this email address",null,null,null,"How to Obtain Test Data"]
["C2G3 Utilities ONLY - Auto Pay - Record that is NOT Initially signed up for recurring card payments (Prior to Paymentus Migration)",null,null,null,"AutoPay ONLY - How to Obtain Test Data"]
["C2G3 Utilities (One-time) Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Building Permits Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Occupational Licenses Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Parking Tickets Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Code Enforcement Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Tax Billing Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Courts Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Accts Recv. And Loans Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 ONESolution ONLY:"]
["C2G3 Accts Recv. And Loans Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Building Permits Online Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Business Account Management Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Planning, Engineering, and Zoning Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["C2G3 Code Compliance Card and/or eCheck Payments",null,null,null,"How to Obtain Test Data"]
["Point of Sale Records (See Notes on How to Fill out Below section)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proceed to MAIN SCRIPTS Sheet"]

{"sheet":"SCRIPTS-MAIN","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["TEST SCRIPTS - Prior to Payment and Wrap-up"]
[]
["Testing Step:","Link to Details of Step:","Pass / Fail (Indicate Reason / Case in Add. Notes)","Date Testing Started","Date Test Completed","Additional Notes:"]
["iSeries Setup Completed"]
["Has Web Enablement (WB)  Been installed successfully (on both TEST and PROD iSeries if applicable)?  Use link on right to test","Additional Testing Steps","CLICK TO SELECT"]
["CR Cash Receipts Setup Completed?  NOTE: Most setup is outside scope of this doc - see link on right for setup table and IMPORTANT NOTE.","Use Setup table to track","CLICK TO SELECT"]
["Communication Testing - from iSeries and C2G3 Server"]
["RT Notification - from C2G3 Server (Proxy) to Web Enablement (WB) module on iSeries - test from C2G3 Server:\nhttp://[iSeriesURL]:81/htepgm/crwebpymtc\nNOTE: Please indicate URL used in Additional Notes","Example URL and Typical Output","CLICK TO SELECT"]
["VOID communication - from iSeries to C2G3 Proxy (OR directly to Paymentus URL) - test from iSeries\nNOTE: Please indicate URL used in Additional Notes","Example URL and Typical Output","CLICK TO SELECT"]
["VOID Communication 2 - from C2G3 Proxy to Paymentus for Voids and Auto Pay processing - test from C2G3 server:\nhttps://secure1.paymentus.com/xotp/xxxx  (TEST Paymentus Env.)\nhttps://ipn.paymentus.com/xotp/xxxx (PROD Paymentus ONLY)\n(XXXX = Client Code)\nNOTE: Please indicate URL used in Additional Notes","Example URL and Typical Output","CLICK TO SELECT"]
["AutoPay URL - internal test to ensure ePortalLocalService app is running - Test from C2G3 Server:\nhttp://127.0.0.1:7101/ePortalLocalService/","Example URL and Typical Output","CLICK TO SELECT"]
["Communication Testing - from Outside (Paymentus)"]
["RT Notification - Outside (Paymentus) to iSeries via C2G3 Proxy - for notification of approved payments - test from outside Internet:\nhttps://[clientexternalURL]/htepgm/crwebpymtc","Example URL and Typical Output","CLICK TO SELECT"]
["RT Notification - Auto Pay URL to iSerires (via C2G3 Proxy) - for notification of Auto Pay sign up - Test from outside Internet:\nhttps://[clientexternalURL]/ePortalLocalService","Example URL and Typical Output","CLICK TO SELECT"]
["Test SSL Certificate by going to https://www.ssllabs.com/ssltest/analyze.html","Example URL and Typical Output","CLICK TO SELECT"]
["Prep Steps (as needed)"]
["Confirm Clean Shutdown Performed (if at go-live)?","Clean Shutdown Notes","CLICK TO SELECT"]
["TM Interface Value in Cash Receipts Toggled to Yes (immediately prior to void testing if no test iSeries environment)?","see IMPORTANT NOTE","CLICK TO SELECT"]
[]
["C2G3 Payment Testing","Go to Worksheet","CLICK TO SELECT"]
[]
["POS Payment Testing","Go to Worksheet","CLICK TO SELECT"]
[]
["AutoPay Testing","Go to Worksheet","CLICK TO SELECT"]
[]
["Testing Wrap-Up Tasks"]
["If NOT going live and testing against PROD iSeries environment, turn TM Interface setting back to 'N' and notify customer","N/A (see notes on test item)","CLICK TO SELECT"]
["Specify any outstanding issues in Addendums section (case numbers as appropriate etc)","N/A (see notes on test item)","CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]

{"sheet":"C2G3Worksheet","index":4,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["C2G3 App Payment Testing Steps"]
["Back to Main Scripts"]
["Use this link or links to the right for testing details",null,"TESTING DETAILS"]
["C2G3 Module / Payment Type","Date / Time Started","Pre-Approval Screens as Expected (see link above)?","Payment Approved? (specify Conf #)","Write to CR Batch? (Provide Batch Name & Tender Code)","Edit Report - Conf # Matches?","Void Successful?","Batch Post? (Optional)","Credit / CR Reversal? (Optional)","Date / Time Completed","NOTES"]
["Click2Gov Utilities - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Utilities - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Building Permits - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Building Permits - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Business Licenses - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Business Licenses - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Parking Tickets - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Parking Ticekts - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov  Code Enforcement - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov  Code Enforcement - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Tax Billing - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Tax Billing - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Courts - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Courts - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Accts. Receivables & Loans - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov Accts. Receivables & Loans - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Accts. Receivables & Loans - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Accts. Receivables & Loans - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Building Permits Online - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Building Permits Online - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Business Acct. Management - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Business Acct. Management - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Planning, Engineering & Zoning - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Planning, Engineering & Zoning - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Code Compliance - Test CARD Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
["Click2Gov ONES Code Compliance - Test ECHECK Payment",null,"CLICK TO SELECT",null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT"]
[]
["Back to Main Scripts"]

{"sheet":"POSWorksheet","index":5,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["POS Payment Testing Steps"]
["Back to Main Scripts"]
["Use this link or links to the right for testing details - some testing not required on all Workstations",null,null,"See page 10 doc in this link","TESTING DETAILS","TESTING DETAILS","TESTING DETAILS","TESTING DETAILS","TESTING DETAILS","TESTING DETAILS"]
["Workstation Name / Description","Local IP","Date / Time Started","Installed APL on Workstation w\\ no errors?","APL Service URL successful? ","Telnet from iSeries to APL ","Timeout and Closing behaviors","Tender Code(s) Used","Swipe Payment Tested ","Keyed Payment Tested (at least one)","Payment Approved? (specify Conf #)","Date / Time Completed","NOTES"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[null,null,null,"CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT","CLICK TO SELECT",null,"CLICK TO SELECT","CLICK TO SELECT"]
[]
[]
[]
["Back to Main Scripts"]

{"sheet":"AutoPayWorksheet","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["AutoPay Testing Steps"]
["Back to Main Scripts"]
["Testing Step:","Link to Details of Step:","Pass / Fail (Indicate Reason / Case in Add. Notes)","Date Testing Started","Date Test Completed","Additional Notes:"]
["Auto Pay Testing (C2G3 Utilities Only)"]
["Pre-Confirmation Screens - no issues (card option only, no \"draft date on 10th of the month\" etc)","Testing Details","CLICK TO SELECT"]
["Auto Pay Confirmation Successful?  (specify confirmation # in notes)","Testing Details","CLICK TO SELECT"]
["Process a recurring card Auto Pay payment in NaviLine / Select Utilities (specify confirmation # in notes) and void","Testing Details","CLICK TO SELECT"]
["Remove the card added earlier from Auto Pay","Testing Details","CLICK TO SELECT"]
["Test Setting up record for Recurring ACH and remove","Testing Details","CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[null,null,"CLICK TO SELECT"]
[]
["Back to Main Scripts"]

{"sheet":"Detailed Steps","index":7,"n_rows":296,"n_cols":3,"rows_kept":296,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Detailed Steps"]
[]
["How to Complete This Form","Back to Start Sheet"]
["NOTES:",null,"Macro Warning (Choose Enable Macros)"]
["Make sure you have the checklist SunGardPaymentusChecklist.doc handy for the customer in question - much of the initial info needed can be found there.  "]
["Also, when saving the document, append the file name to represent the client code.  Recommend the format [CLIENT-CODE]-Paymentus-TESTINGSCRIPTS-[TESTINGorGo-Live].xlsm"]
["You may get an \"Excel security Notice\" prompt when opening this file.  You should ALWAYS choose \"Enable Macros\" on this notice.  See also some other prompts that may come up after pulling up the document (and the appropriate response)"]
["Be aware that this Checklist is Proprietary and should not be shared with persons other than valid customer, SunGard, and Paymentus personnel."]
["Finally, be aware that you will want to complete at least two copies of this checklist (one for the testing / pre-go-live window, and a second for the go-live time frame). The "]
["STEPS:"]
["1. Fill out the info in the Setup - START HERE Sheet under the General Information heading.  Note whether this version of the test script is for the Testing (Pre-go-live) window, or during Go-Live."]
["2. In the \"Apps / Components to be Installed / Tested\" heading, check the boxes for the modules and featured being tested - this will modify the hidden and available values not only on the setup sheet, but also on the test records and other sheets."]
["3. Proceed to the Records for Testing Sheet.  Based on the selections in Step 2, the sheet should only present rows for the valid items that need to be tested.  NOTE: It will not show items for Fusion at this time."]
["4. Fill in the appropriate value in the \"Record Value in TEST Environment\" or \"…in PROD Environment\" columns as appropriate.  Note that the \"How to Obtain Value / Details\" column may provide a link back to an area of this page - with more info on finding records."]
["5. Proceed to the MAIN SCRIPTS Sheet.  Based on the selections in Step 2, the sheet should only present rows for the valid items that need to be tested. "]
["6. Complete all the test script items listed.  Each will have a link to detailed steps (off this page).  Pass/fail dropdown should be completed for each"]
[]
[]
["OBTAINING DATA"]
[]
["How to Obtain Data for Testing (Normal Payment Testing - NOT Auto Pay)","Back to Records for Testing Sheet"]
["1. A background in working with the NaviLine / Select modules on the iSeries is always helpful.  You may need to work with the customer on obtaining account records to use for testing based on the below recommendations."]
["2. If the customer has a TEST iSeries environment and it is currently being used (prior to go-live ONLY), there is typically no harm in using any record desired.  While you do NOT typically have to clear the use of the record with the customer,  it may still help to work wiht the customer in obtaining records.  "]
["3. If pointing to the PRODUCTION iSeries environment, it is ALWAYS advisable to confirm with the customer the records that will be used (in advance).  This is true even during the testing window (when pointing to the Paymentus TEST environment).   "]
["4. Most Click2Gov apps require records to have an amount due to be able to be paid online.  The exceptions (you can pay even without a balance due) are Click2Gov Utilities and possibly Click2Gov Tax Billing (latter is based on property settings)."]
["Please See Addendums section for more info on app-specific navigations for pulling up records with a balance."]
[]
[]
["How to Obtain Data for Testing Auto Pay feature"]
["NOTE: Paymentus will run a migration and provide lists of migrated records, as well as a list of records that were NOT migrated due to expired card number, etc.","Back to Records for Testing Sheet"]
["Finding Auto Pay Records via UT288AP"]
["NOTE: The following query can be run in SQL (STRSQL) to find records that meet the criteria of a Specific Auto Pay status (see below for value for X)"]
["Find records NOT already setup for Auto Pay:\nSELECT * FROM htedta/ut288ap WHERE UTABDF = 'N'"]
["NOTE: HTEDTA may not be the library name if a test library (HTEDTAT) or different naming convention (more plausible with a Cloud customer) "]
["To find a record that IS already signed up for recurring credit card (Auto Pay) - Can change the 'N' to an 'R' to the aforementioned query"]
["To find accounts signed up for Recurring ACH, query on 'C' or 'S'"]
["To check the Current Auto Pay Status of a Record and Change History"]
["(from NaviLine / Select Utilities Main Menu) --> Customer Inquiry Menu --> Customer Services --> (Search for customer ID and choose Select option) --> (Hit enter until \"Display Customer Services\" window apppears) --> F22 - Auto Pay option --> take a \"Display (5) option on CORRECT Location ID"]
["Can also choose F9 - Change History option to see changes"]
["OTHER Requirements for Utility Accounts for Auto Pay Testing"]
["1. One of the records should NOT already be associated with recurring card or ACH - see above for steps to query UT288AP for records meeting these criteria"]
["2. If Auto Pay was being used Prior to Paymentus Migration - Will also need a record that WAS ALREADY signed up for Auto Pay credit card prior to the Paymentus Migration - can use the same UT288 Query as indicated above"]
["a. IMPORTANT - record already defined for auto-pay should NOT have a pending transaction.  To check this, See step 5 in the \"How to Associate Utility Account with SSO Profile below.  You will see a Pending Transactions screen which will reflect a pending transaction if there is one."]
["3. For Recurring ACH - can also run query on UT288AP where UTABDF = 'C' or 'S'"]
[]
[]
["TEST SCRIPT DETAILS"]
[]
["Testing Details - Cash Receipts Setup in iSeries","Back to Test Item"]
[]
[]
[]
["See section below for recommended steps of Clean Shutdown"]
[]
[]
["Communication Testing Details - Auth Notification - C2G3 Proxy to iSeries  - Confirm Web Enablement is Listening and Accessible","Back to Test Item"]
["Perform this test from C2G3 Server - value should match in httpd.conf file"]
["Example URL: http://iaovdo.aspgov.com:81/htepgm/crwebpymtc"]
["Output of page"]
[]
[]
[]
[]
[]
["Communicattion Testing Details - Void / Cancel Request -  iSeries to C2G3 or Paymentus for iSeries-based Voids and Auto Pay Processing","Back to Test Item"]
["Perform this test form the ISERIES ITSELF (steps below):"]
["1. Obtain the URL by navigating in CR File Maintenance to: TM interface defaults --> F11 - Web Services --> 2 next to Paymentus Void Request --> (enter to second screen)"]
["2. Note Web Service URI Server address value (after portion after https://) and back out to command line "]
["3. TELNET RMTSYS('<<URI-VALUE>>') PORT(443)"]
["Output of page"]
["Will present wording at bottom:"]
["Connecting to remote host 172.30.12.54 using port 443."]
["SUCCESSFUL RESPONSE:"]
["TELNET session ended.  Connection closed."]
[]
[]
["Communication Testing Details - Void / Cancel Request -  C2G3 to Paymentus for iSeries-based Voids and Auto Pay Processing","Back to Test Item"]
["Perform this test form the C2G3 server - value should match in httpd.conf file"]
["Example URL (IN TEST): https://secure1.paymentus.com/xotp/ovdo "]
["Example URL (IN PROD): https://ipn.paymentus.com/xotp/ovdo "]
["Output of page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IMPORTANT: If the above instead shows an error of \"IP NOT ALLOWED\" - this suggests the filter rule is not in Paymentus rule set"]
[]
[]
[]
[]
["Communication Testing Details - Ensure ePortalLocalService App is running internally (for Auto Pay)","Back to Test Item"]
["Perform this test form the C2G3 server - value should match in httpd.conf file"]
["Example URL (TEST or PROD): http://127.0.0.1:7101/ePortalLocalService/"]
["Output of page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Communication Testing Details - Outside (Paymentus) to iSeries via Proxy for RT Notification on One-time payment Authorizations","Back to Test Item"]
["Perform this test form the OUTSIDE Internet.  NOTE: Cloud customers do not resolve from inside SPS network (no issues from any other outside machine).  Use customer's fully qualified external URL (in place of xxxx-egov.aspgov.com in the below example)"]
["Example URL (TEST or PROD): https://xxxx-egov.aspgov.com/htepgm/crwebpymtc"]
["Output of page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Communication Testing Details - Outside (Paymentus) to iSeries via Proxy for AutoPay Status Update","Back to Test Item"]
["Perform this test form the OUTSIDE Internet.  NOTE: Cloud customers do not resolve from inside SPS network (no issues from any other outside machine).  Use customer's fully qualified external URL (in place of xxxx-egov.aspgov.com in the below example)"]
["Example URL (TEST or PROD): https://xxxx-egov.aspgov.com/ePortalLocalService"]
["Output of page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Communication Testing Details - Test SSL Certificate via www.ssllabs.com","Back to Test Item"]
["Go to URL: https://www.ssllabs.com/ssltest/analyze.html"]
["(Should confirm there are no issues with the certificate chain or other errors)"]
[]
[]
["Testing Details - Creating an SSO (Single Sign On) Profile","Back to MAIN SCRIPTS Sheet"]
["1. Create a Temporary Email Account.  Recommend using a site  www.mailinator.com.  Also recommend using the format XXXXTEST@mailinator.com (XXXX = Client code EX: SPS1TEST@mailinator.com","Back to Records for Testing Sheet"]
["1. From any C2G3 landing page, choose \"New User\" at top-right"]
["2. Complete All required fields and hit Create New User button to submit"]
["3. Check your temporary email address at mailinator site"]
["4. Click the link in the email to enable account"]
[]
[]
["Testing Details - How to Associate Utility Account with SSO Profile","Back to MAIN SCRIPTS Sheet"]
["NOTE: This must be done for Auto Pay testing.  If the One Time Payment feature is turned off, it will also need to be done for other payment testing in Utilities (otherwise, that can be used instead for normal payment testing).  "]
["1. Sign into Click2Gov CX with your SSO Profile."]
["2. Choose \"Select Account\" from the left-hand menu."]
["3. Choose \"Manage Accounts\" from the left-hand menu."]
["4. Click the \"Add Account link."]
["5. In addition to the Account ID (Customer - Location ID values), you will likely need to validate other fields from a utility bill.  To look up these values, use the following navigation in NaviLine / Select:\nCustomer Inquiry Menu --> Combined History --> (search on last name or other means to find hte customer value) --> (make sure the status is \"A\" and select the customer record) --> (hit enter until \"Account History - Combined Inquiry) screen appears --> (view the most recent \"bill\" record to see relevant fields"]
[]
[]
["Click2Gov Payment Testing Tips"]
["Pre-Approval Screens as Expected?","Back to C2G3 Testing Sheet"]
["1. Each App should present the correct card types and payment options (card, debit and/or eCheck based on checklist responses)"]
["2. Back / and cancel buttons behave as expected"]
["3. Customer branding and notes appear correctly"]
["4. If customer chooses to allow billfold option, this options should appear (on \"confirm payment screen\") and be presented as option on follow-up payment"]
["5. Service fees presented on \"confirm payment\" screen (if specified on checklist)"]
["C2G3 CX: "]
["Can use One-Time payment for non Auto Pay testing (if the menu option is turned on).  Otherwise, will have to associate Utility Account with SSO profile (see below)"]
["C2G3 BP: "]
["1. Select Permit"]
["2. Search for Application Number (of BP app with fees due)"]
["3. \"Application Fees\" (left-hand menu option)"]
["4. Check the box in the Pay column and hit the Pay Now button"]
["C2G3 OL: "]
["1. \"Renew License\" menu option"]
["2. specify license number and PIN.  NOTE: See Addendum for how to find pin"]
["3. Choose Renew Option (NOTE: If it does not appear license might not meet requirements for renewal)."]
["4. Go through the remaining screens until you get to a screen presenting a calculated cost for the renewal"]
["C2G3 PT: "]
["<WILL COMPLETE LATER>"]
["C2G3 CE: "]
["<WILL COMPLETE LATER>"]
["C2G3 TX: "]
["<WILL COMPLETE LATER>"]
["C2G3 CS: "]
["<WILL COMPLETE LATER>"]
["C2G3 ARL: "]
["<WILL COMPLETE LATER>"]
[]
[]
["Point of Sale TestingTips"]
["Agnostic Payment Listener (APL) Service URL Coming up Successfully?","Back to POS Testing Sheet"]
["Test this on ALL Workstations"]
["1. Test from each workstation after APL installed"]
["http://localhost:<port#>/PaymentEngineService"]
["NOTE: May not need port # specified if using port 80"]
["2. Screen should appear similar to this:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Telnet from iSeries to Workstation running APL","Back to POS Testing Sheet"]
["Test this on ALL Workstations"]
["1. Need local IP of each workstation in the below test (run from iSeries)"]
["TELNET RMTSYS('<<local-Workstation-IP>>') PORT(<<port#>>)"]
["Will present wording at bottom:"]
["Connecting to remote host 172.30.12.54 using port 80."]
["SUCCESSFUL RESPONSE:"]
["TELNET session ended.  Connection closed."]
[]
["Timeout and closing behaviors as expected?","Back to POS Testing Sheet"]
["Only need to test on one of the workstations"]
["<<WILL ADD MORE NOTES / SCREENS LATER>>"]
["1. Close action on APL screens should update NaviLine / Select CR screen to reflect cancelled attempt "]
["2. APL window will automatically close based on value defined in CR settings (NOTE: Future enhancement as of 7/6/17)"]
["3. After approval on APL side - screen will close after X seconds (value defined in CR settings) and approval response will display in NaviLine / Select CR"]
[]
["POS Tender Codes Used?","Back to POS Testing Sheet"]
["1. Goal is to make sure all POS tender codes are tested"]
["2. Doesn't matter which are tested on which workstation, as long as collectively all are tested (just list which were tested on each WS for documentation purposes)"]
[]
["Swipe Testing Tips","Back to POS Testing Sheet"]
["Test this on ALL Workstations to ensure physical swipe devices work"]
["1. Screens may vary if not Paymentus - their screen will default to allowing swipe once presented.  May still need to key in CVV code from card"]
["2. Swipe action will output to screen.  User will need to hit submit button to proceed to \"Confirm Payment\" screen"]
["3. Should get approval after submitting, followed by window close and update to CR (see timeout behaviors section)"]
[]
["Keyed Testing Tips","Back to POS Testing Sheet"]
["Only needs to be tested on one of the workstations"]
["1. Screens may vary if not Paymentus - initail screen will include toggle button to change to manually-keyed mode"]
["2. User will need to hit submit button to proceed to \"Confirm Payment\" screen"]
["3. Should get approval after submitting, followed by window close and update to CR (see timeout behaviors section)"]
[]
[]
["Auto Pay Testing Details"]
["Adding a Recurring Card in C2G3 CX","Back to Auto Pay Testing Sheet"]
["1. After signing into C2G3 CX --> Select Account --> Select the Utility Account that is NOT already setup for Auto Pay."]
["2. Click \"Auto Pay\" Menu option (left-hand menu)"]
["3. Click \"Enroll in Auto Pay\" link in the content area of the page"]
["4. Will launch a Paymentus entry screen - fill in the card info and continue, and then hit \"Confirm Schedule\" on the final page.  NOTE: IF in Test Paymentus interface, may see an erroneous message about \"draft date on the 10th of the month\".  "]
["5.  User will be redirected back to Click2Gov screen - can hit \"Refresh Auto Pay Status\" link to confirm status changes to \"Enrolled in Auto Pay\" (with \"View / Modify\" link and \"Disable\" link appearing)"]
["6. Click \"View / Modify Enrollment Details\" link - make sure it reflects last four digits of card that was setup for Auto Pay."]
[]
["Processing an Auto Pay Payment in NaviLine / Select Utilities","Back to Auto Pay Testing Sheet"]
["IMPORTANT: These steps should be followed EXACTLY as stated (in Select interface), as failure to do so could cause a large volume of live card payments to be processed erroneously."]
["NOTE: In the below steps: XX = Current Year || YY = Previous Year"]
["1. Run a SQL Query (STRSQL):\nSELECT * FROM HTEDTA/UT431AP WHERE UTPDYY < XX"]
["a. This will confirm there's no card records scheduled for the previous year - should reflect a blank response if this is the case."]
["2. Create a Recurring Payment with the following steps:"]
["a. Utilities Main Menu --> Adjustments Menu --> Work with Auto Pay Payment --> (search for the account that was just added to Auto Pay in C2G3) --> (Hit Enter until \"Work with Auto Pay\" screen appears) --> F6 - Add --> (use the below values)"]
["i. Auto Pay Date 12/31/YY (year PRIOR to current year)"]
["ii. Auto Pay amount of $1.00 should be fine"]
["3. Run a Credit Card Auto Pay process against the payment you created."]
["a. Utilities Main Menu --> Update Processing Menu --> Credit Card Auto Pay"]
["b. \"Through Payment Date\": Use 12/31/YY (year PRIOR to current year) and hit enter"]
["4. F14 (Shift + F2) to look at job UT_CR_CRD"]
["a. Keep using F5 to refresh until job goes from status \"Active\" to \"OUTQ\""]
["b. Work with spooled files on the job (option 8)"]
["c. Display (5) option next to User Data UT431CCU"]
["d. Make sure the error count (page down) is 0 and the transaction does not reflect an error."]
["5. Make sure it created a batch in Cash Receipts.  Will typically have a different name than one-time payment batch, such as C2G_CXRECP (the User ID value defined in Web Service Interface)"]
[]
["Removing the Auto Pay Card Setup in C2G3 CX","Back to Auto Pay Testing Sheet"]
["1. After signing into C2G3 CX --> Select Account --> Select the Utility Account that you setup for Auto Pay in the earlier section"]
["2. Click \"Auto Pay\" Menu option (left-hand menu)"]
["3. Click \"Disable Auto Pay Enrollment\" link in the content area of the page"]
["4. Will launch a Paymentus entry screen - hit \"Confirm\" butto non the screen and then \"Close\" button"]
["5.  Back on Click2Gov Screen - \"Refresh Auto Pay Enrollment Status\" link - should now show \"This account is not enrolled in Auto Pay…\""]
[]
["Recurring ACH Testing","Back to Auto Pay Testing Sheet"]
["1. After signing into C2G3 CX --> Select Account --> Select the Utility Account that WAS already setup for Recurring ACH Auto Pay "]
["2. Click \"Auto Pay\" Menu option (left-hand menu)"]
["3. Should see \"Your account is enrolled in Auto Pay…\" wording, along with links to \"View ACH Enrollment Details\" and \"Disable ACH Auto Pay Enrollment\""]
["4. Click the \"View ACH Enrollment Details\" option"]
["5. Should reflect some sort of checking account info"]
["6. Click the \"Disable ACH Enrollment Details\" Option"]
["7. If the page comes up cleanly, click the \"Cancel\" button on the Paymentus screen.  Do NOT actually proceed to disable Recurring ACH."]

{"sheet":"Addendums","index":8,"n_rows":139,"n_cols":6,"rows_kept":139,"cut":false,"hidden":false,"merged":[[5,0,5,2],[115,0,115,2],[128,0,128,2],[0,0,0,14],[111,0,111,2],[112,0,112,2],[83,0,83,2],[92,0,92,5],[94,0,94,5],[60,0,60,4],[61,0,61,4],[62,0,62,4],[59,0,59,4],[3,0,3,4],[31,0,31,2],[49,0,49,2]]}
["Addendums / Screenshots "]
[]
[]
["Cash Receipts / iSeries Troubleshooting Tips"]
[]
["Set Logging Level to debug"]
["Type the below from the iSeries to pull up the logs:"]
["WRKLNK OBJ('/sungardps/cr/htedta/debug/')"]
["NOTE: Will use htedtat if test environment"]
[]
["Will be presented with the logs below - take a 5=Display option to choose the right one"]
["Directory  . . . . :   /sungardps/cr/htedta/debug                                                                                           "]
[" Type options, press Enter.                                                 "]
["   2=Edit   3=Copy   4=Remove   5=Display   7=Rename   8=Display attributes"]
["   11=Change current directory ...                                                                                                             "]
[" Opt   Object link            Type     Attribute    Text                    "]
["       CRAUTHRQST_debug.t >   STMF           - This is for POS auth requests                             "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["       CRRECURQST_debug.t >   STMF           - recurring (Auto Pay) card processes                                 "]
["Core Logging steps"]
["Type the below from the iSeries to pull up the logs:"]
["WRKLNK OBJ('/sungardps/cr/htedta/debug/')"]
["NOTE: Will use htedtat if test environment"]
[]
["Will be presented with the logs below - take a 5=Display option to choose the right one"]
["Directory  . . . . :   /sungardps/cr/htedta/debug                                                                                           "]
[" Type options, press Enter.                                                 "]
["   2=Edit   3=Copy   4=Remove   5=Display   7=Rename   8=Display attributes"]
["   11=Change current directory ...                                                                                                             "]
[" Opt   Object link            Type     Attribute    Text                    "]
["       CRAUTHRQST_debug.t >   STMF           - This is for POS auth requests                             "]
["       CRRECURQST_debug.t >   STMF           - recurring (Auto Pay) card processes                                 "]
["       CRVOIDRQST_debug.t >   STMF           - Void requests                                          "]
["       CRWEBPYMT_debug.tx >   STMF           - ??                                         "]
[]
["Will document specific errors at a later time (as of 12/2016)"]
[]
["Key iSeries tables and usage"]
[]
["CRWEBXAP - will present confirmation number if RT notification was successful"]
[]
[]
[]
[]
[]
[]
[]
["Cash Receipts Setup Values and Notes"]
["Exact Setup Steps are documented outside this file."]
["IMPORTANT NOTE: TM interface value should NOT be set to Y (Yes) in the PROD environment UNTIL go-live (or limited testing windows below).  This could cause significant issues with payments \"lost\" and other significant downtime."]
["Some customers do not have a TEST environment.  In those cases, most testing should be coordinated in specific downtime windows prior to go-live, immediately preceded by a clean shutdown of C2G and posting of existing batches."]
["Back to MAIN SCRIPTS Sheet"]
["*CR Default N/A for POS Transactions"]
["Payment Type Description","Tender Code","Merchant Code (if applicable)","Assoc. CR Batch Default *","Tested Successfully"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Other Cash Receipts Setup Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Point of Sale Workstation Testing (WorkSheet)"]
["Back to POS Testing Main"]
["*Columns marked with an asterisk (*) are NOT applicable to Premise Customers (ONLY to Cloud customers)"]
["Description","Local IP","External IP*","Added to VPN*","Tested Successfully?","Other Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["C2G3 OL - Finding Pin for Renewal Testing:"]
["(From Business License Main Menu) --> License Processing Menu --> Work with Business / License --> (if wanting to view by license, use F8 to change view) -->  (5 - Display option next to the license you are reviewing) --> (may have to hit enter to get to \"License Master Inquiry\" screen --> (value should be near top left)"]
[]
[]
["Issues Resolved:"]
["ISSUE:"]
["Description of issue (and or Case #)"]
["RESEARCH:"]
["Description of steps taken to troubleshoot"]
["RESOLUTION:"]
["description of steps taken to resolve"]
[]
[]
[]
[]
[]
[]
["OUTSTANDING ISSUES"]
[]
["CASE # (if Applicable):"]
["ISSUE / CASE SYNOPSIS:"]
["Description of issue "]
["Case Description (if applicable):"]
["see above"]
["RESEARCH / Other case Notes:"]
["Description of steps taken to troubleshoot"]
["RESOLUTION:"]
["description of steps taken to resolve"]

{"sheet":"DropdownResources","index":9,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["Dropdowns and other Resources"]
[]
[]
["Boolean Values",null,"Test Pass / Fail"]
[true,null,"CLICK TO SELECT"]
[false,null,"IN PROCESS"]
["N/A",null,"PASS"]
[null,null,"FAIL"]
["Testing Time-Frame",null,"N/A"]
["CLICK TO SELECT"]
["Testing Window"]
["At Go-Live"]