Tc tellers.xls

From Vital Soft Wiki
Jump to: navigation, search

Overview

Define the teller initials to be included in the Transaction Analysis document and optionally assign each a teller code for quick selection.

Note: The Transaction Analysis document adds new tellers that are found in history to a chart on the Maintenance Tab of the document. It is faster/easier to export that chart when modifying the list of tellers.

   TC_COMMENT  TC_INITIALS TC_NAME       TC_TELLER_CODE  TC_START_DATE   TC_END_DATE TC_TEL_COMMENTS TC_LOAD_COMMENTS                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
               AAC         Arthur Crane  TLR             20120601        0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       


Sheet1 Worksheet

Excel Column Meaning
TC_COMMENT If this column is NOT empty, the entire row is considered a comment.
TC_INITIALS The teller initials as stored in Spectrum.
TC_NAME Initially the teller name as stored in Spectrum, but can be modified.
TC_TELLER_CODE A valid teller code to be associated with the teller. Codes are defined in the TC_CODES.xls file.
TC_START_DATE The day the code definition for this teller takes effect. 0 means all loaded dates.
TC_END_DATE The day the code definition for this teller ends. 0 means all loaded dates.
TC_TEL_COMMENTS Any comment to be associated with the teller.
TC_LOAD_COMMENTS Comments generated by the refresh of the document (such as a new teller that was added) are placed here.