View source for Tc tellers.xls

== 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 ==

{| class="wikitable"
| '''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.  
|}