BrinfoCCYYMMDD.xls
Revision as of 21:40, 7 January 2016 by >Kevint
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 | Obsolete. Use a value of 0 for all rows. |
| XLS_EXT_OPEN (1) | The branch extended open time (24 hour format). |
| XLS_EXT_CLOSE (1) | The branch extended close time (24 hour format). |
| XLS_EXT_FTE | Obsolete. Use a value of 0 for all rows. |
| 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.
