BrinfoCCYYMMDD.xls

From Vital Soft Wiki
Revision as of 21:35, 31 August 2012 by >Jeremyb
Jump to: navigation, search

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