Transaction Exception Trends
Contents
1. Authorizations Employee System MyForms Logout Open ecuri Solutions Tickler Authorization Information x Transaction Exception Trends Search Criteria Search Criteria By Institution By Branch C By Employee By Overriding Employee djay saysoney 8910 95 Employee JOE BANKER Start Date 02 03 2013 gt Bal ThruDate oe 02 2013 FE Search Result Total Number of Exceptions New Balance is less than Minimum Allowed Allow Account Status Change Allow Critical Account Status Change Insufficient Funds Checking Assess Regulation DD Service Charge Payment against Delinquent Loan Waive Check Issue Service Charge Loan is Non Performing Error Correct a Transat ction f n ininin BS Uncollected Funds Variables Calculation Type A calculation type under the calculation category TRXP is required to associate the variables to the application This calculation type is set at the system institution level only with no product or account level functionality Calculation Type Description how used MjMiYN Transaction Exception TEXC This Calculation Type will be used for associating the N Trends calculation variable Number of Back Date Query Days TEQD Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 10 of 22 Open solutions There s P2. Open Solutions Transaction Exception Trends Transaction Exception Trends Application 1d7953a3 ad88 4fb7 b6e0 e93ec0e425ad Overview The Transaction Exception Trends application is an online application with a single new screen that allows the User to obtain an online snapshot of historical exception tracking with several filtering options including by Financial Institution Branch Employee and Overriding Employee over a period of time designated by the User Key Benefits Current standard reporting for exception tracking EM _SUPR is done via an application that typically is run at the end of day and has a single day s reporting data available the next business day This application helps the User go beyond daily report review to explore trends that help point to both audit alerts and daily processing changes required The application helps the User by e Presenting a historical look at the exceptions that occur over a period of time For example an employee may only process a certain exception once or twice a day but over a month or longer period if this same exception is occurring this may point to a need to review that exception and why is occurring so much for that employee or their role e Breaking down the exceptions processed by a branch employee or overriding employee for instant review of a branch or employee s exception trends e Providing real time data and analysis of exception trends e Listing the except
3. 06033 4335 860 652 3155 860 652 3156 fax www opensolutions com 3 Open solutions ihere s Power in Community lf a user selects Search Criteria By Employee the application will count the transaction exceptions occurring between the dates specified in the Start Date through Thru Date criteria options for a selected employee An additional field Employee with a dropdown list of the Financial Institution employees will become available on the screen and the User will select from this list to choose the employee they wish to query on Upon selecting the Query button the resulting results grid will display grouping by transaction exception number provide a summary in the top row and then list the exceptions by highest to lowest frequency in the subsequent rows along with the percentage of the total exception count per exception Authorizations Employee System MyForms Logout See Authorization Information Transaction Exception Trends Search Criteria C By Institution By Branch By Employee C By Overriding Employee djay saysoney S22 mS Employee gt Start Date AMY PAIGE MAGDITCH Page 6 of 22 Security Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax x Open olutions There s Power in Community An Employee is selected System MyForms Logout Security Tickler Authorization Information Transaction Exception Trends Sea
4. ThruDate fos 02 2013 gt FR Search Result Total Number of Exceptions New Balance is less than Minimum Allowed Payment against Delinquent Loan Al Allow Account Status Change Allow Critical Account Status Change Insufficient Funds Checking Assess Regulation DD Service Charge Waive Check Issue Service Charge Loan is Non Performing Error Correct a Transa ction Uncollected Funds Field Listing Description By Institution Option to allow the User to select all Exceptions for the Financial radio button Institution between the dates specified in the Start and Thru Date fields By Branch Option to allow the User to select all Exceptions for a selected Branch radio button between the dates specified in the Start and Thru Date fields This option will bring up an additional Location field where the User can select the Branch from a drop down list By Employee Option to allow the User to select all Exceptions for the Financial radio button Institution for a selected Employee between the dates specified in the Start and Thru Date fields This option will bring up an additional Employee field where the User can select the Employee from a drop down list By Overriding Option to allow the User to select all Exceptions for the Financial Employee Institution for a selected Overriding Employee between the dates radio button specified in the Start and Thru Date fields This option
5. to address the first exception message and if a valid value is entered to satisfy that exception upon selecting the Query button again the second exception message may be raised Selection of the Clear button after clicking OK on any exception message will always set the default values back as stated above and ensure there are no secondary exception messages e lf the User clears either the Start or Thru Date values or both and attempts to run a query with either or both of these parameters with no value the application will display system error messages advising the User to provide a valid value An example is shown below for a missing Start Date value Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 16 of 22 Open solutions There s Power in Community Authorizations Employee System MyForms Logout i Open Security Solutions Authorization Information Transaction Exception Trends Search Criteria Search Criteria By Institution C By Branch C By Employee C By Overriding Employee Start Date SE thrubate 08 02 2013 FR djay saysoney S299 MS Exceptions X Please provide a valid Start Date And another example where both the Start and Thru Date values have been removed Institution Business Tables System Tables GL Printing Operations Product and Pricing Manage MyForms System Logout GY See Tickler Authorization Information Trans
6. 1 of 22 Open solutions There s Power in Community Institution Business Tables System Tables GL Printing Operations Product and Pricing Manage MyForms System Logout 9 Open System Solutions Table Maintenance Variables Selection Criteria Calculation Type ransaction Exception Trends I Show History djay sayioney SINS System Variables Transaction Exception Tre Number of Back Date Quer 180 Iv Auto Hide System Variable Maintenance Type Description Variable Description Value Close Clear O Review Process Screens Navigation Security Module gt System gt Transaction Exception Trends Screen Appearance Authorizations Employee System MyForms Logout or Authorization Information Transaction Exception Trends Search Criteria Search Criteria By Institution By Branch By Employee By Overriding Employee djap saysoney S991095 Start Date 02 03 2013 F Thru Date o0s 02 2013 FRY Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax www opensolutions com Page 12 of 22 Open Solutions There s Power in Community Authorizations Employee System MyForms Logout Open ecuri 5 Solutions x B Transaction Exception Trends eo Search Criteria Search Criteria By Institution C By Branch C By Employee By Overriding Employee Start Date 02 03 2013 SRE
7. a pop up exception message The Start Date must be equal or greater than MM DD YYYY where MM DD YYYY is the Post Date value minus the value of the Number of Back Query Days TEQD variable Example System Post Date is 02 27 2013 Thru Date is 02 27 2013 and the Number of Back Query Days TEQD is Null or 0 making the minimum Start Date value 02 27 2013 If the User selects a date less than 02 27 2013 for the Start Date such as 02 25 2013 the following message is raised Institution Business Tables System Tables GL Printing Operations Product and Pricing Manage Open Solutions A The Start Date must be equal or greater than 02 27 2013 lf the User attempts to select a Start Date value of a date greater than the Thru Date and the Thru Date is equal to the Post Date the system will display a pop up exception message The Start Date must be equal or less than MM DD YYYY where MM DD YYYY is the Post Date Example System Post Date is 08 02 2013 Thru Date is 08 02 2013 and the User selects a date of 08 15 2013 for the Start Date The following message is raised Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 20 of 22 O Open Solutions iere s Power in Community Ano iz ations E Moye Syste m My F re Lou 9 Open Solutions Tickk Authoriz Transaction Exception Trends e Ifthe User attempts to select a Start Date value of a date grea
8. action Exception Trends Search Criteria Search Criteria By Institution By Branch By Employee By Overriding Employee Start Date gt lt iL x Thru Date gt i x djay sayoney S991035 Exceptions XJ Please provide a valid Start Date B Please provide a valid Thru Date X Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax www opensolutions com Page 17 of 22 Open solutions There s Power in Community lf the User attempts to enter an incorrect date format the system will display a pop up exception message The current date is not in the correct format MM DD YYYY or is an impossible date The previous valid date will be restored Please enter a new valid date CORE Prometheus DNA Creator System TEST SYSTEM Institution Business Tables System Tables GL Printing Operations Product and Pricing Manage MyForms System Logout O pen stem S Solutions e djay sapone S99MS By Institution By Branch By Employee By Overriding Employee Start Date 13 01 2013 R ThruDate 08 29 2013 Fy The current date is notin the correct format MM DD YYYY or is an impossible date The previous valid date will be restored Please enter a new valid date lf the User attempts to select a Thru Date value of a date greater than the current Post Date the system will display a pop up exception message The Thru Date must be equal
9. dation feedback 08 2013 1 0 2 0 Updated code and User Manual based on validation feedback 08 2013 1 0 3 0 Updated code and User Manual based on validation feedback Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 22 of 22
10. e Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 15 of 22 Open Solutions of Total of total Exceptions displayed in descending order from highest per Exception Number to lowest of Exception Number Note The per Exception Number will round to the nearest hundredth So it is possible the total of all the individual rows may be slightly less or more than the summary of 100 00 An example would be if there was a total of 3 Exceptions 1 for each of 3 Exception Numbers each would have a of 33 33 with rounding so the sum of all three would be 99 99 while the summary row would display 100 00 Application Messages The system will display the following exception messages when application exceptions occur Note when the OK button on an exception message is clicked the cursor will return to the date field that caused the exception At this point the date can be corrected or the Clear button may be selected When clicked the Clear button will change the Start and Thru Dates back to the default values from the calculated Start and Thru Dates as calculated by the current post date and the TEQD calculation variable value and return the default selection to the By Institution radio button lf there are two exceptions possible i e both the Start and Thru Date values are valid dates but outside the allowed calculated reporting period only one exception message will be displayed at a time The User will need
11. esult in longer query result times When processed the query will then return information in a four column grid The first row of this grid will act as a Summary row and will list the total number of exceptions selected using the query based on the criteria selected The second and subsequent rows will list a count of each exception number in descending order of most frequent to least frequent Accompanying the count is a field for percentage to show the User what percentage of the total was for that particular exception For example if the Institution choice was selected for the previous three months and there were 300 exceptions raised during that time for the Financial Institution with the 300 among three exceptions 210 for Insufficient Funds Exception 3 60 for Uncollected Funds Exception 4 and 30 for Management Hold Exception 87 there would be four rows returned in the results grid The top summary row would show a count of 300 and a percentage of 100 00 The second row would show the exception number 3 a count of 210 and a percentage of 70 00 The third row would show the exception number 4 a count of 60 and a percentage of 20 00 The fourth row would show the exception number 87 a count of 30 and a percentage of 10 00 The rows can be sorted in reverse order by clicking on the column headings Note that if this is done the summary row and the detail rows will also be sorted Open Solutions Inc 455 Winding Br
12. ions per filter by most frequent to less frequent so the most prevalent exceptions are shown at the top of the query return grid e Showing the User both a count and percentage view of the frequency of exceptions per each of the filters e Offering the internal audit team an on demand method to review what is happening across the Financial Institution without having to request special report runs to be generated Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 1 of 22 Open Solutions Processing The Transaction Exception Trends screen can be accessed from the Security module within DNA The application has four query choices by Institution by Branch by Employee and by Overriding Employee These four choices allow the User to look for overall Exceptions exceptions that are raised across the Financial Institution or to filter and drill down at the Branch Employee or Overriding Employee level to obtain exceptions data at more granular levels Once one of these four choices is selected the User will then select a date range using the Start Date and Thru Date selections to establish a query range The Thru Date will default to the current Post Date and the Start Date will default to the value of the current Post Date minus the value of the Number of Back Date Query Days TEQD calculation variable Note when setting dates for the query longer date ranges will r
13. lues and return the default selection to the By Institution radio button When clicked after the Query button has been selected and data has been returned will clear the results grid and return the Start and Thru Dates to the default values and return the default selection to the By Institution radio button When clicked will close the screen after all query activities are performed This button is not available when the screen is first opened until after the initial query is run Query Results Top Row which is a summary row Exception Number Will be NULL Description Exceptions query data range of Total of total Exceptions by the criteria selected and in the query data range this will always be 100 00 Query Results Subsequent Rows Exception Number DNA System Exception Number Exception Description Number of Exceptions Description of the DNA System Exception Number taken from the Description for each Exception Number in the Exception system table Count for each Exception Number displayed in descending order from highest count per Exception Number to lowest count of Exception Number Where the count of the individual Exception Number is the same i e 3 Exception Numbers each have a count of 10 so they have equal counts and percentages they will be displayed in Exception Number order high to low Exception Number 10 would be ahead of Exception Number 3 Open Solutions Inc 455 Winding Brook Driv
14. mployee performed the override on An additional field Employee with a dropdown list of the Financial Institution s employees will become available on the screen and the User will select from this list to choose the overriding employee they wish to query on Upon selecting the Query button the resulting results grid will display grouping by transaction exception number provide a Summary in the top row and then list the exceptions by highest to lowest frequency in the subsequent rows along with the percentage of the total exception count per exception Authorizations Employee System MyForms Logout Open Solutions Transaction Exception Trends Search Criteria C By Institution By Branch By Employee djay sayioney SIMS Employee gt lt All hs Start Date 02 03 2013 E ThruDate fos 02 2013 F CORE Prometheus DNA Creator System TEST SYSTEM BF 18 x Authorizations Employee System MyForms Logout Open Security Solutions Authorization Information x 1 Transaction Exception Trends By Overriding Employee AMY CASELLA Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 8 of 22 Open solutions There s Power in Community The No Overriding Employee is selected This option allows the User to select exceptions where there was not an Overriding Employee Authorizations Employee System MyForms Logout A Solutions oriza
15. ook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 2 of 22 Open Solutions There s Power in Community The multiple processing options are shown below The User first accesses the new screen by logging in to DNA selecting the Security module and then selecting System from the toolbar and the new Transaction Exception Trends menu item The User will then use one of the four radio button selections and the Start Date and Thru Date search criteria options The default search criterion is by By Institution with a Start Date value of the current Post Date minus the value of the Number of Back Date Query Days TEQD calculation variable in MM DD YYYY format and a Thru Date value of the current Post Date in MM DD YYYY format Authorizations Employee System MyForms Logout SEn Authorization Information Transaction Exception Trends Seach COiteia By hst ution C By Branch C By Employee C By Overriding Employee diay samOney 89919 StatDate f2032013 SE TruDate f0e 022013 E oey Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 3 of 22 Open solutions There s Power in Community 1 If the User selects Search Criteria By Institution the application will count the transaction exceptions occurring between the dates specified in the Start Date through Thru Date criteria options Upon selecting the Query bu
16. or less than MM DD YYYY where MM DD YYYY is the current Post Date Example System Post Date is 02 27 2013 If the User selects a Thru Date of greater than 02 27 2013 the following message is raised Institution Business Tables System Tables GL Printing Operations Product and Pricing Manage MyForms System Logout Open System Solutions Transaction Exception Trends Search Criteria By Institution By Employee C By Overriding Employee diay saysoney saainsas Start Date 08 31 2012 FR ThruDete 03 27 2013 FB A The Thru Date must be equal or less than 02 27 2013 Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 18 of 22 Open solutions There s Power in Community lf the User attempts to select a Start Date that is equal to or greater than the Calculated Start Date and also selects a Thru Date value that is less than the Calculated Start Date the system will display a pop up exception message The Start Date must be equal or less than MM DD YYYY where MM DD YYYY is the Thru Date value entered Note although the Thru Date value is outside the allowable limit established by the Calculation Variable value the application will always check the logic on the Start Date value first to determine if there is an exception Example System Post Date is 08 02 2013 the TEQD variable has a value of 180 and a Start Date of 06 19 2013 is en
17. ower in Community The following Calculation Variable stores the number of days and is used to set a limit on how far back a query may go from the current Post Date Description how used Data Type Default Number of TEQD Maximum number of days allowed for historical NUM 180 Back Date search criteria backdated from the current Post Date Query Days This is a system institution level variable that sets a historical date limit on how long the search period can be for a query This is so a User does not inadvertently select a long reporting period such as several years that will result in a long query run time possible timeout The Variable Number of Back Date Query Days TEQD is associated at the system institution level with Calculation Type TEXC Transaction Exception Trends Navigation for inquiry and maintenance of this variable s value is shown below Services gt System gt Institution gt Variables gt Transaction Exception Trends Institution Business Tables System Tables GL Printing Operations Product and Pricing Manage MyForms System Logout Open System Solutions Table Maintenance x Variables Selection Criteria Calculation Type None gt nsaction Exce Tra djay sayoney saaisas System Variables Txn Signature Pad Config uni4270 System Variable Maintenance Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 1
18. ptions for a selected branch An additional field Location with a dropdown list of the Financial Institution branches will become available on the screen and the User will select from this list to choose the branch they wish to query on Upon selecting the Query button the resulting results grid will display grouping by transaction exception number provide a summary in the top row and then list the exceptions by highest to lowest frequency in the subsequent rows along with the percentage of the total exception count per exception Authorizations Employee System MyForms Logout Open Solutions 8 Transaction Exception Trends C By Institution O By Branch By Employee By Overriding Employee Start Date 07 29 2013 R ThruDate f08 02 2013 A Authorizations Employee System MyForms Logout S Open Solutions i Transaction Exception Trends PA Search Criteria Search Criteria C By Institution By Branch C By Employee C By Overriding Employee Search Result New Balance is less than Minimum Allowe Payment against Delinquent Loan Allow Account Status Change Allow Critical Account Status Change Insufficient Funds Checking Assess Regulation DD Service Charge Waive Check Issue Service Charge Loan is Non Performing Error Correct a Transa ction Uncollected Funds Page 5 of 22 Security x Open Solutions Inc 455 Winding Brook Drive Glastonbury CT
19. rch Criteria Search Criteria By Institution C By Branch By Employee C By Overriding Employee NKER Employee JOE BA Start Date f02 03 2013 FR ThruDate 08 02 2013 FR Results for that employee are then displayed Authorizations Employee System MyForms Logout Open Solutions Authorization Information Security Transaction Exception Trends Search Criteria Search Criteria C By Institution By Branch By Employee By Overriding Employee Employee fu0e BANKER 7 Start Date f02 03 2013 F ThruDate 08 02 2013 EA djay saysoney sacinsas Search Result Total Number of Exceptions New Balance is less than Minimum Allowed Payment against Delinquent Loan Allow Account Status Change Allow Critical Account Status Change Insufficient Funds Checking Assess Regulation DD Service Charge Waive Check Issue Service Charge Loan is Non Performing Error Correct a Transaction 2 2 s 42 ninininin B Uncollected Funds Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax www opensolutions com Page 7 of 22 Open solutions There s Power in Community 4 If a user selects Search Criteria By Overriding Employee the application will count the transaction exceptions occurring between the dates specified in the Start Date through Thru Date criteria options that a selected e
20. ter than the Thru Date and the Thru Date is less than the Post Date but both Date values are within the allowed Calculated Date timeframe the system will display a pop up exception message The Start Date must be equal or less than MM DD YYYY where MM DD YYYY is the Thru Date Example System Post Date is 08 02 2013 the TEQD variable days are set at 180 and the User selects a Start Date of 05 23 2013 and a Thru Date of 03 05 2013 The following message is raised Solutions Tiokler ithorieation information Transaction Exception Trends a n ora Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax www opensolutions com Page 21 of 22 Open Solutions Additional Requirements Open Solutions DNA 3 3 or higher The Transaction Exception Trends screen is assigned to the SECM Security Module Auth Item for security authorization Users of this application will require access to this Auth Item within their user profile Configuration Checklist ltem Test Production Environment Environment User Access ensure Users have the Auth Item SECM Security Module in their DNA Authorization Profile with the appropriate auth permissions generally View Set value of the Number of Back Query Days TEQD calculation variable Revisions App Version 07 2013 1 0 0 0 Application Created 07 2013 1 0 1 0 Updated code and User Manual based on vali
21. tered If the User selects a Thru Date of 01 02 2012 the following message is raised Author Q Open Solutions information ransaction Exception Trends tf N If the User then adjusts the Start Date value to be 01 02 2012 per the exception message if Query is then selected the following exception message will be raised Authorizations Employee System My Forms ogol Qo Tickler Auti horization Information lt Transaction Exception Trends 2 Search Criteria A The Start Date must be equal or greater than 02 03 2013 Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 19 of 22 Open Solutions n j TF i ies d f f l f i oil i i giir wes UWI i VUNNU This is due to the logic being set to check the Start Date value first as the application is designed to guide the User back toward using a valid Start Date However if the User changes the value of the Start Date to 02 02 2013 per this second exception message they will receive the first exception message again as the Thru Date value is still at 01 02 2012 and the validation is looking for the Start Date to always be equal to or less than the Thru Date lf the User attempts to select a Start Date value that will set a date range that is outside the range of the value of the calculation variable Number of Back Query Days TEQD the system will display
22. tion Transaction Exception Trends Search Criteria i C By Instiution C By Branch C By Enplyee By Overiding Employes Employee VOE BANKER Oe ON moas EET e djap saone 53910195 Total Number of Excep ons 525 New Balance is less then Mninum Alowed 95 Allow Account Staus Change 4 Allow Criical Account Status Change 3 Insufficient Funds Checking 1074 Assess Reguiation DD Service Cherce 186 Payment against Delinquent Loan 148 Werve Check Issue Service Charge 117 Loan is Non Performing 58 Error Correct a Transaction 4 Uncofected Funds This returns all exceptions where the exception was raised but did not require a password to override the User was able to simply click through to process and complete their activity When an employee is selected zr r Authorization Information Transaction Exception Trends Search Criteria Search Criteria By Institution By Branch C By Employee By Overriding Employee djay sayuoney SaaS Employee Melsteeanltaas Start Date 02 03 2013 FR Thru Date f08 02 2013 Py Security x Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 9 of 22 Open solutions There s Power in Community The query will return all the exceptions that employee provided an override for both their own and for others
23. tton the resulting results grid will display grouping by transaction exception number provide a summary in the top row and then list the exceptions by highest to lowest frequency in the subsequent rows along with the percentage of the total exception count per exception Transaction Exception Trends Search Criteria Search Criteria By Institution By Branch By Employee 0 By Overriding Employee StartDete 21020 2013 SF trudate spona BR Authorizations Employee System MyForms Logout Open ecuri 6 Solutions Bi Transaction Exception Trends A Search Criteria Search Criteria By Institution By Branch By Employee By Overriding Employee Start Date 02 03 2013 Fy ThruDate 08 02 2013 FE Search Result Total Number of Exceptions New Balance is less than Minimum Allowed Payment against Delinquent Loan Allows Account Status Change Allow Critical Account Status Change Insufficient Funds Checking ssess Regulation DD Service Charge aive Check Issue Service Charge Uncollected Funds Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 4 of 22 2 Open solutions There s Power in Community lf the User selects Search Criteria By Branch the application will count the transaction exceptions occurring between the dates specified in the Start Date through Thru Date criteria o
24. will bring up an additional Employee field where the User can select the Overriding Employee from a drop down list Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 13 of 22 Open Solutions Start Date A date field that allows the User to enter the Query period beginning date entered in the format MM DD YYYY or by using the provided calendar icon to the right of the field and selecting the desired date from this calendar The Start Date will default to the current system Post Date minus the value of the Number of Back Date Query Days TEQD calculation variable The Start Date has a restriction in that the value cannot be less than the current Post Date minus the value of the Number of Back Date Query Days TEQD variable Even if a User selects a Thru Date that is less than the current Post Date the restriction in the Start Date will not change it will not move back to accommodate the earlier date request Thru Date A date field that allows the User to enter the Query period ending date entered in the format MM DD YYYY or be using the provided calendar icon to the right of the field and selecting the desired date from this calendar The Thru Date will default to the current system Post Date Location When the Branch radio button is selected this field will become available and the Financial Institution s branches will be available for selection in the dropdo
25. wn menu The branches will be listed in name order with lt All gt as the starting option in the selection Employee When the Employee radio button is selected this field will become available and the Financial Institution s employees will be available for selection in the dropdown menu The employees will be listed by First Name Last Name with lt All gt as the starting option in the selection Employee When the Overriding Employee radio button is selected this field will become available and the Financial Institution s employees will be available for selection in the dropdown menu The employees will be listed by First Name Last Name with lt All gt as the starting option in the selection There is an additional selection value immediately below the lt All gt starting option lt No Overriding Employee gt This value will isolate Exceptions that were raised but only required the User to click through without requiring them to type in their password Query button Will start the DNA database query run process based on the selection criteria entered from the preceding selection criteria and return the output in the query results data grid Open Solutions Inc 455 Winding Brook Drive Glastonbury CT 06033 4335 860 652 3155 860 652 3156 fax Page 14 of 22 Open Solutions Clear button Close button When clicked prior to the Query button being selected will reset the Start and Thru Dates to the default va
Download Pdf Manuals
Related Search