This posting will be a discussion of a method used to help implement a new customer on an EGOV Travel system. At my agency, Excel spreadsheets are utilized to collect data that is used as the building block determining how information and tables will be setup in the EGOV Travel system. The information provided on these spreadsheets help ensure that good accurate data is used to build the new EGOV Travel database for the agency. The spreadsheets also serve as a tool to assist an agency with data cleanup.
In order to use the EGOV Travel software, new users go through a one-time self registration process the first time logging onto the EGOV Travel application. Self registration procedures are provided to the agency’s travelers before going live with the EGOV Travel application. When a new user self registers, a Tier II help desk will need to accept each new user into the EGOV Travel application. The process of accepting users into the EGOV Travel application requires the help desk personnel to have the capability to quickly determine the appropriate security group each new user will need added to, the appropriate routing each new user will need selected, etc. The help desk is able to facilitate this process with the information provided in the agency prepared spreadsheets.
Preparing the spreadsheets also gives the agency to be implemented on the EGOV Travel system an opportunity for data clean-up. The agency can take advantage of this opportunity to remove travelers from the prior travel system that is no longer with the agency or no longer travels, correct travelers office or division listing due to a transfer or promotion, close individual credit cards for individuals who no longer traveler or are no longer in need of a card, etc.
by Grant Brown
“The views expressed are those of the author and do not reflect any position of the Government or my agency.”