BrinfoCCYYMMDD.xls

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.

1. Use extended hours when the main lobby is closed, but the branch is open for drive-through business.