310 likes | 497 Views
Kuali Days VII. Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System. Welcome. John Harner, Director Travel Management at Indiana University Anne Bartlett, Lead Developer Travel@IU Marilyn Kisters, Subject Matter Expert - Workflow. Overview. History of travel systems at IU
E N D
Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System
Welcome • John Harner, Director Travel Management at Indiana University • Anne Bartlett, Lead Developer Travel@IU • Marilyn Kisters, Subject Matter Expert - Workflow
Overview • History of travel systems at IU • Travel@IU Abstract • Workflow Design
TAPS (Before) • DOS based programming language • Difficult to push out to end users • Document initiation & approval continued to be paper • Limited developer pool • Reporting depended on the application developers
TAPS (Before) • Limited interface with Financial System • Database management was involved, continuous, and labor-intensive (done by Travel)
Travel Today • J2EE Web Application/Oracle Database • Foundation for 2009 Deployment • Document initiation & approval continues to be paper • Because it is developed in a widely used language developer pool has fewer limitations.
Travel@IU - Today • Data has been dimensionally modeled and is no longer dependent on J2EE developers. • Data input/output is easily configured (csv, xml) • Transferring data to Financial System is much easier because of the database. • Database management is being done by qualified DBAs
Travel@IU - 2009 • The document initiation will occur at the traveler/arranger level • Workflow controls routing • Receipts will be scanned and associated with the reimbursements • Traveler/arrangers can track reimbursements
Travel@IU - 2009 • Reporting • Details of expenses are maintained, i.e., airfare, taxi, hotel, per diem, etc. • Foreign vs. Domestic vs. In-State categories • By Individual • By Account • By Organization • By Campus
Travel@IU Trip Prepayment Before Trip Authorization -Encumber Funds -Payments Additional Payments? Out-of-State? Yes Yes No Supplement After Trip Reimbursement -Disencumber Funds -Expenses Additional Expenses? Yes
Travel@IU Trip Prepayment Before Trip Authorization -Encumber Funds -Payments Additional Payments? Out-of-State? Yes Yes No Supplement After Trip Reimbursement -Disencumber Funds -Expenses Additional Expenses? Yes
Account Information 1181.67 1.67
Reconciled Expenses • Air • Lodging • Rental Car • Fuel • Limo
Expense Reconciliation Process • Expenses • Air • Lodging • Rental Car • Fuel • Limo Batch Process Vendor Invoice Data Reconciliation - Invoice/Itinerary Number - Trip Id - Account Number Credit Card Transactional Data
Travel@IU Trip Prepayment Before Trip Authorization -Encumber Funds -Payments Additional Payments? Out-of-State? Yes Yes No Supplement After Trip Reimbursement -Disencumber Funds -Expenses Additional Expenses? Yes
Travel@IU - Future • Non-Employee Travel (Reimbursements) • Group Travel • Single-sign on to Agency Vendors • Route Documents to Tax • Route Documents to Export Controls Office