Difference between revisions of "BrinfoCCYYMMDD.xls"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(Created page with "== Overview == The Branch Info spreadsheet defines the open and closed hours for Branches during the week. This information is used to determine Teller Hours in the [[Transa...")
 
>Jeremyb
Line 32: Line 32:
  
 
'''XLS_EXT_FTE'''
 
'''XLS_EXT_FTE'''
     The extended full time employees
+
     The number of extended full time employees
 
      
 
      
 
'''XLS_COMMENTS'''
 
'''XLS_COMMENTS'''
 
     Comments about the row
 
     Comments about the row

Revision as of 21:35, 31 August 2012

Overview

The Branch Info spreadsheet defines the open and closed hours for Branches during the week.

This information is used to determine Teller Hours in the Transaction Analysis application.

Columns

XLS_BRANCH

   The Branch number

XLS_DAY

   The day of the week: Monday, Tuesday...Sunday

XLS_ENTRY_DAY

   The order of the days

XLS_OPEN

   The time the Credit Union opens in 24 hour format

XLS_CLOSE

   The time the Credit Union closes in 24 hour format

XLS_FTE

   The number of full time employees

XLS_EXT_OPEN

   The extended open time in 24 hour format

XLS_EXT_CLOSE

   The extended close time in 24 hour format

XLS_EXT_FTE

   The number of extended full time employees
   

XLS_COMMENTS

   Comments about the row