Difference between revisions of "BrinfoCCYYMMDD.xls"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Johno
Line 5: Line 5:
 
This information is used to determine Teller Hours in the [[Transaction Analysis]] application.
 
This information is used to determine Teller Hours in the [[Transaction Analysis]] application.
  
== Columns ==
+
{| class="wikitable"
 +
| '''Excel Column'''
 +
| '''Meaning'''
 +
|-
 +
| XLS_BRANCH
 +
| The branch number.
 +
|-
 +
| XLS_DAY
 +
| The day name: Monday, Tuesday, ...
 +
|-
 +
| XLS_ENTRY_DAY
 +
| Numeric value for day of week:  Monday=0.
 +
|-
 +
| XLS_OPEN
 +
| The branch open time (24 hour format).
 +
|-
 +
| XLS_CLOSE
 +
| The branch close time (24 hour format).
 +
|-
 +
| XLS_FTE
 +
| The typical number of full time employees scheduled at this branch.
 +
|-
 +
|-
 +
| XLS_EXT_OPEN (1)
 +
| The branch extended open time (24 hour format).
 +
|-
 +
| XLS_EXT_CLOSE
 +
| The branch extended close time (24 hour format).
 +
|-
 +
| XLS_EXT_FTE
 +
| The typical number of full time employees scheduled during extended hours at this branch.
 +
|-
 +
| XLS_COMMENTS
 +
| Any comments, not loaded in any documents.
 +
|}
  
'''XLS_BRANCH'''
+
# Use extended hours when the main lobby is closed, but the branch is open for drive-through business.
    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
 

Revision as of 23:38, 1 December 2015

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.

Excel Column Meaning
XLS_BRANCH The branch number.
XLS_DAY The day name: Monday, Tuesday, ...
XLS_ENTRY_DAY Numeric value for day of week: Monday=0.
XLS_OPEN The branch open time (24 hour format).
XLS_CLOSE The branch close time (24 hour format).
XLS_FTE The typical number of full time employees scheduled at this branch.
XLS_EXT_OPEN (1) The branch extended open time (24 hour format).
XLS_EXT_CLOSE The branch extended close time (24 hour format).
XLS_EXT_FTE The typical number of full time employees scheduled during extended hours at this branch.
XLS_COMMENTS Any comments, not loaded in any documents.
  1. Use extended hours when the main lobby is closed, but the branch is open for drive-through business.