80 likes | 178 Views
New Cancer Waiting Times Information Day. IT Update. IT for New Cancer Waiting Times. Data in Information out Looking to the future. Data In. Submit the monthly file using SWIFT DVL Validation 3 types of errors File Field Rules. Outcome of File Submission. Successful run
E N D
New Cancer Waiting Times Information Day IT Update
IT for New Cancer Waiting Times • Data in • Information out • Looking to the future
Data In • Submit the monthly file using SWIFT DVL • Validation • 3 types of errors • File • Field • Rules
Outcome of File Submission • Successful run • Message sent to email account • Failed run • Messages via email • Resubmission
Information Out • Secondary validation – looking for duplicates • Extract into Excel • Use a filter within BO directly on data • Report Production
Report Production • Monthly reports • Produced using SPSS/Excel • Distributed via email • Move to using Business Objects • In test at present • Parallel running
Looking to the Future • Upgrading the validation tools • Making SWIFT DVL more flexible • Improving the error messages
Looking to the Future - 2 • Providing access directly to your own data via BusinessObjects • Running standard reports • Ad hoc queries • Publications produced using Business Objects