Difference between revisions of "BrinfoCCYYMMDD.xls"
>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...") |
>Kevint |
||
| (2 intermediate revisions by 2 users not shown) | |||
| 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. | ||
| − | == | + | {| 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 | ||
| + | | 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. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 21:40, 7 January 2016
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.
