DTTS Query and Ad Hoc

DTTS Demo Screens

This module gives you the power of a very detailed Subscriber Inquiry tool, as well as sophisticated Adhoc Query capability. Just logon and begin to explore the intimate details of your circulation file.

 

DTTS LOGON

dtts logon

Back to DTTS

 

MAIN MENUINQUIRY.  The DTTS Main Menu Screen displays your options clearly and succinctly.

main menu

Back to DTTS

 

INQUIRY BROWSE SCREEN - A DTTS Inquiry immediately presents you with a browse screen with many   search options. For example, you can immediately locate a record if you have the subscriber’s full account number.


INQUIRY SEARCH Account Number

inquiry browse screen

Back to DTTS


INQUIRY SEARCH Last Name - Or you can search by using a portion of the subscriber’s Last Name.

inquiry search

Back to DTTS

 

INQUIRY SEARCH Multi - Or you can query by multiple criteria. In this example Last Name and State fields.

inquiry search

Back to DTTS


INQUIRY SEARCH Multiple - Fine tune your search criteria with any combination of fields!

inquiry search

Back to DTTS

 

 

INQUIRY DETAIL SCREEN - Inquiry “detail” screen displays all of the subscriber information you will need to fully handle any Customer Service situation. Note the address information, Status and ITG (issues to go) information immediately at the top. Order information is at the bottom half of the screen.

inquiry search

Back to DTTS


INQUIRY AUDIT BUTTON - DTTS provides audit tracking of any action against the file.

inquiry

Back to DTTS

 

INQUIRY AUDIT DETAIL – Audit trail information available with a ‘click’.

inquiry

Back to DTTS

 

INQUIRY NOTES - Need to notate something important about this customer? This is easily accomplished by clicking on the ‘Add Notes’ button.

inquiry

Back to DTTS

 

INQUIRY NOTES Indicator - Quill and Folio ‘icon’ indicates notes field now contains information.

inquiry

Back to DTTS

 

MAIN MENUAD HOC  Let’s go back to the Main Menu screen now and select Ad Hoc Query.

main menu ad hoc

Back to DTTS


DTTS Ad Hoc - AdHoc Query is an extremely powerful tool used to gather statistical information, select records with specific criteria such as ‘geographic data’ (i.e. by State or Zip code) or ‘demographic data’ (i.e. by business title or function) for immediate output to an Excel file and much more. Select fields for ‘criteria’ and/or ‘output’ from all the available tables.

dtts ad hoc

Back to DTTS

 

 

AD HOC Criteria - Drag and drop fields like Masterfile-Last_Name and ServiceOrder-amount into the Criteria section.

ad hoc criteria

Back to DTTS

 

 

AD HOC Selection - Double-click on fields like LAST_NAME, STREET and CITY to use for building an output report.
Then click on ‘Execute Now’ button. Your results will display in ‘output’ window below.

Back to DTTS

 

 

AD HOC Output - Hit the ‘Next’ button to select output ‘options’ (such as Excel format output and Save Query for future use).

Back to DTTS