Portfolio
TACCentre NotifyXpress Scheduler
Siemens Soarian Financials Data Extract to TACCentre NotifyXpress
Project: Provide automated call system with an upload file to allow for the automation of daily appointment reminder calls.
- Project Highlights:
- Created an interface to pick up the data extract file
and move it to an upload directory for use by the NotifyXpress
System. A PERL script was created to take the comma delimited file,
analyze coded values and transform into usable data so that the
appointment system could speak the department location, directions,
and allocate call back numbers. The script also included logic to
assess HIPPA compliance related to patient care to determine how
call logic would be handled. A second PERL script was also created
to route a copy of the output file to appointment support staff
and send email notification after the file transfer process.
- FTP Connections, Flat File transfer, PERL Script.
- Created a SQL query that was called to run as a data
extract against the Soarian Finanical database by the
Financial Job Scheduler to produced a comma delimited
data extract file containing appointment related data.
- ODBC Connections, SQL Query, Job Scheduler, .BAT File
- Created an interface to pick up the data extract file
and move it to an upload directory for use by the NotifyXpress
System. A PERL script was created to take the comma delimited file,
analyze coded values and transform into usable data so that the
appointment system could speak the department location, directions,
and allocate call back numbers. The script also included logic to
assess HIPPA compliance related to patient care to determine how
call logic would be handled. A second PERL script was also created
to route a copy of the output file to appointment support staff
and send email notification after the file transfer process.