Difference between revisions of "Tc codes.xls"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
(Columns)
>Johno
(Overview)
 
Line 11: Line 11:
 
Use the exclude code to mark the tellers you want omitted from the final document
 
Use the exclude code to mark the tellers you want omitted from the final document
  
     TC_CODE TC_CODE_DESCRIPTION TC_GROUP TC_CODE_COMMENTS
+
     TC_CODE     TC_CODE_DESCRIPTION     TC_GROUP   TC_CODE_COMMENTS
     <X>         Exclude X Do not change -- used this for all atm machines, etc.
+
     <X>        Exclude                 X           Do not change -- used this for all atm machines, etc.
     <M>         <Missing> U Either a transaction or a teller record exist but teller not defined.
+
     <M>        <Missing>               U           Either a transaction or a teller record exist but teller not defined.
     <nowiki><U></nowiki>         <Undefined> U Teller has multiple or zero roles assigned for one or more days.
+
     <nowiki><U></nowiki>        <Undefined>             U           Teller has multiple or zero roles assigned for one or more days.
  
 
'''Example'''
 
'''Example'''
     TC_CODE TC_CODE_DESCRIPTION TC_GROUP TC_CODE_COMMENTS
+
     TC_CODE     TC_CODE_DESCRIPTION     TC_GROUP   TC_CODE_COMMENTS
     TLR         Teller         T handles bulk of trans
+
     TLR        Teller                   T           handles bulk of trans
     DTA         DTA             T phone teller
+
     DTA        DTA                     T           phone teller
     MSR         Service Rep O
+
     MSR        Service Rep             O
     MGR         Manager                 O
+
     MGR        Manager                 O
  
 
== Sheet1 Worksheet ==
 
== Sheet1 Worksheet ==

Latest revision as of 23:53, 1 December 2015

Overview

Define the codes used to classify teller roles Every code you define needs to belong to either the 'T' group or the 'O' group The T (teller) group should contain your main teller roles, whether for branches or call centers The O (other) group should contain employees who may process transactions, but it is not their primary duty

Note: that if you are usng FTE's, the FTE values are only plotted with the T group

The following codes are used by the Teller Activity document and should not be altered Use the exclude code to mark the tellers you want omitted from the final document

   TC_CODE     TC_CODE_DESCRIPTION     TC_GROUP    TC_CODE_COMMENTS
   <X>         Exclude                 X           Do not change -- used this for all atm machines, etc.
   <M>         <Missing>               U           Either a transaction or a teller record exist but teller not defined.
   <U>         <Undefined>             U           Teller has multiple or zero roles assigned for one or more days.

Example

   TC_CODE     TC_CODE_DESCRIPTION      TC_GROUP    TC_CODE_COMMENTS
   TLR         Teller                   T           handles bulk of trans
   DTA         DTA                      T           phone teller
   MSR         Service Rep              O		
   MGR         Manager                  O

Sheet1 Worksheet

Excel Column Meaning
TC_CODE The teller code.
TC_CODE_DESCRIPTION The description of the teller code.
TC_GROUP A unique group for the teller code.
TC_CODE_COMMENTS Any comment for the file. Comments are not loaded.