BrinfoCCYYMMDD.xls
Revision as of 23:38, 1 December 2015 by >Johno
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. |
- Use extended hours when the main lobby is closed, but the branch is open for drive-through business.
