BrinfoCCYYMMDD.xls
Revision as of 21:35, 31 August 2012 by >Jeremyb
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.
Columns
XLS_BRANCH
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