Australia - New Zealand (ANZ)

Hi All,

UNSW is currently investigating the implementation of address validation.

Has anyone implemented address validation with Campus Solution 9?

If so, what suppliers are recommended?

What are the lessons learned from implementing address validation?

Any impacts on system performance associated with implementing address validation?

Any information/advice would be appreciated.

 

Thanks

Nader Jarufe

NextGen SAAS Program | The University of NSW

P +61 2 9385 7892 | E n.jarufe@unsw.edu.au | W www.unsw.edu.au

CRICOS Provider Code 000098G

HI Nader,
We have it turned on at ANU - to the City/Suburb and Postcode level.
We obtained the list from the Australia Post website.

This seems to be the best compromise on validation vs maintenance.
Implementing down to the street level requires constant updates to the validation tables.

We have also created an ASCII character set validation that we run over the input fields that are exposed to the users.
Thus we can check and restrict white space characters and the likes, from users using Cut/Copy and Paste from websites, etc.

Cheers,

Paul Yeoh
ES, ITS
Building 3K
The Australian National University
ACT 0200

+61 2 6125 9537

From: Nader Jarufe [mailto:n.jarufe@unsw.edu.au]
Sent: Wednesday, 29 January 2014 14:17
To: anz.heug@list.heug.org
Subject: [anz.heug] - Address Validation


Hi All,

UNSW is currently investigating the implementation of address validation.

Has anyone implemented address validation with Campus Solution 9?

If so, what suppliers are recommended?

What are the lessons learned from implementing address validation?

Any impacts on system performance associated with implementing address validation?

Any information/advice would be appreciated.



Thanks

Nader Jarufe

NextGen SAAS Program | The University of NSW

P +61 2 9385 7892 | E n.jarufe@unsw.edu.au<mailto:n.jarufe@unsw.edu.au> | W www.unsw.edu.auhttp://www.unsw.edu.au

CRICOS Provider Code 000098G

-----End Original Message-----

Hi Nader,

The University of Newcastle have implemented the Experian QAS solution for student HOME and MAIL address validation (Australian addresses only).

We validate the full address through an overnight batch process, with some addresses marked for manual confirmation.

We haven't yet implemented the real-time point-of-entry address validation solution that QAS has, this would be ideal though.

I'm happy to have a chat with you about our experiences and I can put you in touch with our Account Manager if you'd like further info from the vendor.

Kind regards,
Richard.

RICHARD OLDE
Manager, Student Systems and Projects
Student and Academic Services
Academic Division

T: +61 2 4921 8787
M: +61 (0)407 788 174
F: +61 2 4921 6937
E: Richard.Olde@newcastle.edu.au<mailto:Richard.Olde@newcastle.edu.au>

The University of Newcastle (UoN)
University Drive
Callaghan NSW 2308
Australia

CRICOS Provider 00109J
[http://s.uon.nu/i/1.gif]http://www.newcastle.edu.au

[http://s.uon.nu/i/2.gif]

[Web]<http://s.uon.nu/l/1>

[Blog]<http://s.uon.nu/l/2>

[Facebook]<http://s.uon.nu/l/3>

[Twitter]<http://s.uon.nu/l/4>

[YouTube]<http://s.uon.nu/l/5>

[http://s.uon.nu/i/0.gif?2]



From: Paul Yeoh [mailto:paul.yeoh@anu.edu.au]
Sent: Wednesday, 29 January 2014 2:25 PM
To: anz.heug@list.heug.org
Subject: [anz.heug] - RE: Address Validation

HI Nader,
We have it turned on at ANU - to the City/Suburb and Postcode level.
We obtained the list from the Australia Post website.

This seems to be the best compromise on validation vs maintenance.
Implementing down to the street level requires constant updates to the validation tables.

We have also created an ASCII character set validation that we run over the input fields that are exposed to the users.
Thus we can check and restrict white space characters and the likes, from users using Cut/Copy and Paste from websites, etc.

Cheers,

Paul Yeoh
ES, ITS
Building 3K
The Australian National University
ACT 0200

+61 2 6125 9537

From: Nader Jarufe [mailto:n.jarufe@unsw.edu.au]
Sent: Wednesday, 29 January 2014 14:17
To: anz.heug@list.heug.org<mailto:anz.heug@list.heug.org>
Subject: [anz.heug] - Address Validation


Hi All,

UNSW is currently investigating the implementation of address validation.

Has anyone implemented address validation with Campus Solution 9?

If so, what suppliers are recommended?

What are the lessons learned from implementing address validation?

Any impacts on system performance associated with implementing address validation?

Any information/advice would be appreciated.



Thanks

Nader Jarufe

NextGen SAAS Program | The University of NSW

P +61 2 9385 7892 | E n.jarufe@unsw.edu.au<mailto:n.jarufe@unsw.edu.au> | W www.unsw.edu.auhttp://www.unsw.edu.au

CRICOS Provider Code 000098G

-----End Original Message-----

-----End Original Message-----

Hi Nader,

RMIT is using QAS as well. We have implemented a plug-in in PeopleSoft that
does the validation at point-of-entry. We receive an updated address file
from them every 3 months which we load into our system.

I can't remember exactly but they also have webservices for real-time
validation.

Best Regards
Nishit Kotecha

Sr PeopleSoft Developer
Student Solutions Centre
RMIT





On 29 January 2014 14:30, Richard Olde <Richard.Olde@newcastle.edu.au>wrote:

> Hi Nader,
>
>
>
> The University of Newcastle have implemented the Experian QAS solution for
> student HOME and MAIL address validation (Australian addresses only).
>
>
>
> We validate the full address through an overnight batch process, with some
> addresses marked for manual confirmation.
>
>
>
> We haven't yet implemented the real-time point-of-entry address validation
> solution that QAS has, this would be ideal though.
>
>
>
> I'm happy to have a chat with you about our experiences and I can put you
> in touch with our Account Manager if you'd like further info from the
> vendor.
>
>
>
> Kind regards,
> Richard.
>
>
>
> *RICHARD OLDE*
> *Manager, Student Systems and Projects*
> Student and Academic Services
> Academic Division
>
> T: +61 2 4921 8787
> M: +61 (0)407 788 174
> F: +61 2 4921 6937
> E: Richard.Olde@newcastle.edu.au
>
> *The University of Newcastle (UoN)*
> University Drive
> Callaghan NSW 2308
> Australia
>
> CRICOS Provider 00109J
>
> [image: http://s.uon.nu/i/1.gif] http://www.newcastle.edu.au
>
> [image: http://s.uon.nu/i/2.gif]
>
> [image: Web] <http://s.uon.nu/l/1>
>
> [image: Blog] <http://s.uon.nu/l/2>
>
> [image: Facebook] <http://s.uon.nu/l/3>
>
> [image: Twitter] <http://s.uon.nu/l/4>
>
> [image: YouTube] <http://s.uon.nu/l/5>
>
> [image: http://s.uon.nu/i/0.gif?2]
>
>
>
>
>
> *From:* Paul Yeoh [mailto:paul.yeoh@anu.edu.au]
> *Sent:* Wednesday, 29 January 2014 2:25 PM
> *To:* anz.heug@list.heug.org
> *Subject:* [anz.heug] - RE: Address Validation
>
>
>
> HI Nader,
>
> We have it turned on at ANU - to the City/Suburb and Postcode level.
>
> We obtained the list from the Australia Post website.
>
>
>
> This seems to be the best compromise on validation vs maintenance.
>
> Implementing down to the street level requires constant updates to the
> validation tables.
>
>
>
> We have also created an ASCII character set validation that we run over
> the input fields that are exposed to the users.
>
> Thus we can check and restrict white space characters and the likes, from
> users using Cut/Copy and Paste from websites, etc.
>
>
>
> Cheers,
>
>
>
> Paul Yeoh
>
> ES, ITS
>
> Building 3K
>
> The Australian National University
>
> ACT 0200
>
>
>
> +61 2 6125 9537
>
>
>
> *From:* Nader Jarufe [mailto:n.jarufe@unsw.edu.au <n.jarufe@unsw.edu.au>]
> *Sent:* Wednesday, 29 January 2014 14:17
> *To:* anz.heug@list.heug.org
> *Subject:* [anz.heug] - Address Validation
>
>
>
> Hi All,
>
> UNSW is currently investigating the implementation of address validation.
>
> Has anyone implemented address validation with Campus Solution 9?
>
> If so, what suppliers are recommended?
>
> What are the lessons learned from implementing address validation?
>
> Any impacts on system performance associated with implementing address
> validation?
>
> Any information/advice would be appreciated.
>
>
>
> Thanks
>
> *Nader Jarufe*
>
> NextGen SAAS Program | The University of NSW
>
> *P* +61 2 9385 7892 | *E* n.jarufe@unsw.edu.au | *W *www.unsw.edu.au
>
> CRICOS Provider Code 000098G
>
>
>
> -----End Original Message-----
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>

Hi,

We currently run Campus 8.9 on an Oracle 10g database. I am looking at options around upgrading to Campus 9 and I am wondering if any Universities are running Campus on a non oracle database. Such as MS SQL Server.

If so

- How do you find performance

- How many students (EFTSL) does your university have

- Any tips or pointers?


regards,

David Lawrence
Director, Business Systems Operation
Information & Technology

[cid:8EF9CA22-4D09-4C41-9774-09139F9A35F2]

Open Universities Australia
Level 1, 473 Bourke Street, Melbourne VIC 3000
GPO Box 5387, Melbourne VIC 3001
T + 61(3) 8628 2541 F +61(3) 8628 2900
Leading online learning: open.edu.au





Leading online learning. Open Universities Australia is the national leader in providing open and flexible access to quality tertiary education, enrolling more than 250,000 students since 1993. We provide access to over 1700 units and 180 qualifications taught by more than 20 of Australia's leading universities and higher education providers.

DISCLAIMER

This e-mail message is intended only for the use of the recipient. Any use of this information by any other person is unauthorised. If you receive this e-mail in error, please immediately advise the sender by return e-mail and delete the message from your system. Any views expressed in this e-mail are those of the individual sender only, unless expressly stated to be those of Open Universities Australia. Open Universities Australia Pty Ltd : ACN 053 431 888

Hi Nader,

We are using the Experian QAS - inline point of entry address validation on our web-site. We were using the multiline QAS validation validation in Peoplesoft CRM.

We never implemented it in Campus as our address entry / update is either via the web-site or the CRM.


regards,

David Lawrence
Director, Business Systems Operation
Information & Technology

[cid:8EF9CA22-4D09-4C41-9774-09139F9A35F2]

Open Universities Australia
Level 1, 473 Bourke Street, Melbourne VIC 3000
GPO Box 5387, Melbourne VIC 3001
T + 61(3) 8628 2541 F +61(3) 8628 2900
Leading online learning: open.edu.au





From: Richard Olde [mailto:Richard.Olde@newcastle.edu.au]
Sent: Wednesday, 29 January 2014 2:30 PM
To: anz.heug@list.heug.org
Subject: [anz.heug] - RE: Address Validation

Hi Nader,

The University of Newcastle have implemented the Experian QAS solution for student HOME and MAIL address validation (Australian addresses only).

We validate the full address through an overnight batch process, with some addresses marked for manual confirmation.

We haven't yet implemented the real-time point-of-entry address validation solution that QAS has, this would be ideal though.

I'm happy to have a chat with you about our experiences and I can put you in touch with our Account Manager if you'd like further info from the vendor.

Kind regards,
Richard.

RICHARD OLDE
Manager, Student Systems and Projects
Student and Academic Services
Academic Division

T: +61 2 4921 8787
M: +61 (0)407 788 174
F: +61 2 4921 6937
E: Richard.Olde@newcastle.edu.au<mailto:Richard.Olde@newcastle.edu.au>

The University of Newcastle (UoN)
University Drive
Callaghan NSW 2308
Australia

CRICOS Provider 00109J
[http://s.uon.nu/i/1.gif]http://www.newcastle.edu.au

[http://s.uon.nu/i/2.gif]

[Web]<http://s.uon.nu/l/1>

[Blog]<http://s.uon.nu/l/2>

[Facebook]<http://s.uon.nu/l/3>

[Twitter]<http://s.uon.nu/l/4>

[YouTube]<http://s.uon.nu/l/5>

[http://s.uon.nu/i/0.gif?2]



From: Paul Yeoh [mailto:paul.yeoh@anu.edu.au]
Sent: Wednesday, 29 January 2014 2:25 PM
To: anz.heug@list.heug.org<mailto:anz.heug@list.heug.org>
Subject: [anz.heug] - RE: Address Validation

HI Nader,
We have it turned on at ANU - to the City/Suburb and Postcode level.
We obtained the list from the Australia Post website.

This seems to be the best compromise on validation vs maintenance.
Implementing down to the street level requires constant updates to the validation tables.

We have also created an ASCII character set validation that we run over the input fields that are exposed to the users.
Thus we can check and restrict white space characters and the likes, from users using Cut/Copy and Paste from websites, etc.

Cheers,

Paul Yeoh
ES, ITS
Building 3K
The Australian National University
ACT 0200

+61 2 6125 9537

From: Nader Jarufe [mailto:n.jarufe@unsw.edu.au]
Sent: Wednesday, 29 January 2014 14:17
To: anz.heug@list.heug.org<mailto:anz.heug@list.heug.org>
Subject: [anz.heug] - Address Validation


Hi All,

UNSW is currently investigating the implementation of address validation.

Has anyone implemented address validation with Campus Solution 9?

If so, what suppliers are recommended?

What are the lessons learned from implementing address validation?

Any impacts on system performance associated with implementing address validation?

Any information/advice would be appreciated.



Thanks

Nader Jarufe

NextGen SAAS Program | The University of NSW

P +61 2 9385 7892 | E n.jarufe@unsw.edu.au<mailto:n.jarufe@unsw.edu.au> | W www.unsw.edu.auhttp://www.unsw.edu.au

CRICOS Provider Code 000098G

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

Leading online learning. Open Universities Australia is the national leader in providing open and flexible access to quality tertiary education, enrolling more than 250,000 students since 1993. We provide access to over 1700 units and 180 qualifications taught by more than 20 of Australia's leading universities and higher education providers.

DISCLAIMER

This e-mail message is intended only for the use of the recipient. Any use of this information by any other person is unauthorised. If you receive this e-mail in error, please immediately advise the sender by return e-mail and delete the message from your system. Any views expressed in this e-mail are those of the individual sender only, unless expressly stated to be those of Open Universities Australia. Open Universities Australia Pty Ltd : ACN 053 431 888

QAS has a product for PeopleSoft.

Griffith licensed the batch application not the on-line product.


There are some issues to note with the batch solution

QAS Batch API solution automatically cleans contact data records. It takes
the records that you wish to clean, passes them through the search engine
one at a time and when an acceptable match is found, the database is
updated.

During a typical batch run, a copy of the existing data is made, the
address checking process verifies each record in the address database
against the latest Australia Post Postal Address File (PAF), updates are
made to the copy of data based on match code and when the changed are
accepted the data is then committed back to the original database.

Due to the way QAS batch updates the data (committing back to the
database, only updating the existing line with no effective dating logic)
there will be no audit record.

When a student updates their data through the student centre it will save
a new effective dated row in the PS_ADDRESSES table and also update the
PS_PERSONAL_DATA table through People Code to show the max effective dated
row for home address and mailing address.


If the PS_ADDRESSES table is updated directly by QAS Batch then the
PS_PERSONAL_DATA table will be out of sync.


We built triggers to overcome this.




On Wed, Jan 29, 2014 at 1:17 PM, Nader Jarufe <n.jarufe@unsw.edu.au> wrote:

> Hi All,
>
> UNSW is currently investigating the implementation of address validation.
>
> Has anyone implemented address validation with Campus Solution 9?
>
> If so, what suppliers are recommended?
>
> What are the lessons learned from implementing address validation?
>
> Any impacts on system performance associated with implementing address
> validation?
>
> Any information/advice would be appreciated.
>
>
>
> Thanks
>
> *Nader Jarufe*
>
> NextGen SAAS Program | The University of NSW
>
> *P* +61 2 9385 7892 | *E* n.jarufe@unsw.edu.au | *W *www.unsw.edu.au
>
> CRICOS Provider Code 000098G
>
> -----End Original Message-----
>



--

*Neal Andrews*
Manager, Application Infrastructure Services
Enterprise Information Systems
Information & Communication Technology Services
Nathan Campus, Brisbane QLD

* email:* n.andrews@griffith.edu.au

*tel: **+61 (0) 7 3735 3826*

*Griffith University* http://www.griffith.edu.au

PRIVILEGED, PRIVATE AND CONFIDENTIAL
This email and any files transmitted with it are intended solely for the
use of the addressee(s) and may contain information which is confidential
or privileged. If you receive this email and you are not the addressee(s)
[or responsible for delivery of the email to the addressee(s)], please
disregard the contents of the email, delete the email and notify the author
immediately.

"If the PS_ADDRESSES table is updated directly by QAS Batch then the PS_PERSONAL_DATA table will be out of sync.
We built triggers to overcome this."
Any reason you couldn't use the delivered process AppEngine.PERS_REFRESH? Usually run every night.
Set Up HRMS > System Administration > Database Processes > Refresh Personal Data


From: Neal Andrews [mailto:N.Andrews@griffith.edu.au]
Sent: Wednesday, 29 January 2014 3:05 PM
To: anz.heug@list.heug.org
Subject: [anz.heug] - RE: Address Validation

QAS has a product for PeopleSoft.

Griffith licensed the batch application not the on-line product.


There are some issues to note with the batch solution

QAS Batch API solution automatically cleans contact data records. It takes the records that you wish to clean, passes them through the search engine one at a time and when an acceptable match is found, the database is updated.

During a typical batch run, a copy of the existing data is made, the address checking process verifies each record in the address database against the latest Australia Post Postal Address File (PAF), updates are made to the copy of data based on match code and when the changed are accepted the data is then committed back to the original database.

Due to the way QAS batch updates the data (committing back to the database, only updating the existing line with no effective dating logic) there will be no audit record.

When a student updates their data through the student centre it will save a new effective dated row in the PS_ADDRESSES table and also update the PS_PERSONAL_DATA table through People Code to show the max effective dated row for home address and mailing address.

If the PS_ADDRESSES table is updated directly by QAS Batch then the PS_PERSONAL_DATA table will be out of sync.

We built triggers to overcome this.


On Wed, Jan 29, 2014 at 1:17 PM, Nader Jarufe <n.jarufe@unsw.edu.au<mailto:n.jarufe@unsw.edu.au>> wrote:

Hi All,

UNSW is currently investigating the implementation of address validation.

Has anyone implemented address validation with Campus Solution 9?

If so, what suppliers are recommended?

What are the lessons learned from implementing address validation?

Any impacts on system performance associated with implementing address validation?

Any information/advice would be appreciated.



Thanks

Nader Jarufe

NextGen SAAS Program | The University of NSW

P +61 2 9385 7892<tel:%2B61%202%209385%207892> | E n.jarufe@unsw.edu.au<mailto:n.jarufe@unsw.edu.au> | W www.unsw.edu.auhttp://www.unsw.edu.au

CRICOS Provider Code 000098G

-----End Original Message-----

Hi Nader,

At the University of Adelaide we have been using QAS to clean and geocode student address data so that it can be used indicate students' socio-economic areas of origin. This information in turn is used to predict funding based on these placements. Our particular implementation was based on the process developed by the University of Newcastle.

The validation itself is an offline batch process. For the purpose above we're only interested in the PERM address type, which we export from PeopleSoft and run through QAS in batch mode. We then re-upload the cleaned and geocoded data back into PeopleSoft. QAS is able to determine student addresses about 95-98% of the time, the remainder requiring manual intervention.

This process, being off-line has no impact on system performance. However a much nicer solution would have been to implement validation at the point of data entry, but this was out of scope of this particular project.

Hope this helps in some way :)

Regards,

--
Daniel Moore
Team Leader System Operations
Student Administrative Services
The University of Adelaide, AUSTRALIA 5005
Ph : +61 8 8313 36361
e-mail: daniel.moore@adelaide.edu.au<mailto:daniel.moore@adelaide.edu.au>

-----------------------------------------------------------
This email message is intended only for the addressee(s)
and contains information which may be confidential and/or
copyright. If you are not the intended recipient please
do not read, save, forward, disclose, or copy the contents
of this email. If this email has been sent to you in error,
please notify the sender by reply email and delete this
email and any copies or links to this email completely and
immediately from your system. No representation is made
that this email is free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.

From: Nader Jarufe [mailto:n.jarufe@unsw.edu.au]
Sent: Wednesday, 29 January 2014 1:47 PM
To: anz.heug@list.heug.org
Subject: [anz.heug] - Address Validation


Hi All,

UNSW is currently investigating the implementation of address validation.

Has anyone implemented address validation with Campus Solution 9?

If so, what suppliers are recommended?

What are the lessons learned from implementing address validation?

Any impacts on system performance associated with implementing address validation?

Any information/advice would be appreciated.



Thanks

Nader Jarufe

NextGen SAAS Program | The University of NSW

P +61 2 9385 7892 | E n.jarufe@unsw.edu.au<mailto:n.jarufe@unsw.edu.au> | W www.unsw.edu.auhttp://www.unsw.edu.au

CRICOS Provider Code 000098G

-----End Original Message-----

Nader,

RMIT does use real time validation software using the QAS software mentioned in a previous post. We only validate Australian addresses, but it is down to street level. We have not experienced problems with performance although did have some issues (I can get more technical details if you are interested) around installing the software in a multi-tier highly available system (multiple app and web servers behind load balancer). We load an update of the data quarterly.

Our largest issue is around what to do with addresses that don't quite match the database of addresses. We have opted to allow students to override the validation in a situation where they don't believe the validated address is correct. Overall the software has improved data integrity, however this ability to override does sometimes leave us with data that still needs cleansing. We do employ some batch checks to clean up remaining data. We opted for the override option to avoid calls into the service desk when the validation did not match.

We are currently looking at geo-coding software for QAS as well.

Happy to speaks to you more about our setup if you are interested.

Regards,
Michael



> On 30 Jan 2014, at 10:14 am, Daniel Moore <daniel.moore@adelaide.edu.au> wrote:
>
> Hi Nader,
>
> At the University of Adelaide we have been using QAS to clean and geocode student address data so that it can be used indicate students’ socio-economic areas of origin. This information in turn is used to predict funding based on these placements. Our particular implementation was based on the process developed by the University of Newcastle.
>
> The validation itself is an offline batch process. For the purpose above we’re only interested in the PERM address type, which we export from PeopleSoft and run through QAS in batch mode. We then re-upload the cleaned and geocoded data back into PeopleSoft. QAS is able to determine student addresses about 95-98% of the time, the remainder requiring manual intervention.
>
> This process, being off-line has no impact on system performance. However a much nicer solution would have been to implement validation at the point of data entry, but this was out of scope of this particular project.
>
> Hope this helps in some way J
>
> Regards,
>
> --
> Daniel Moore
> Team Leader System Operations
> Student Administrative Services
> The University of Adelaide, AUSTRALIA 5005
> Ph : +61 8 8313 36361
> e-mail: daniel.moore@adelaide.edu.au
>
> -----------------------------------------------------------
> This email message is intended only for the addressee(s)
> and contains information which may be confidential and/or
> copyright. If you are not the intended recipient please
> do not read, save, forward, disclose, or copy the contents
> of this email. If this email has been sent to you in error,
> please notify the sender by reply email and delete this
> email and any copies or links to this email completely and
> immediately from your system. No representation is made
> that this email is free of viruses. Virus scanning is
> recommended and is the responsibility of the recipient.
>
> From: Nader Jarufe [mailto:n.jarufe@unsw.edu.au]
> Sent: Wednesday, 29 January 2014 1:47 PM
> To: anz.heug@list.heug.org
> Subject: [anz.heug] - Address Validation
>
> Hi All,
>
> UNSW is currently investigating the implementation of address validation.
>
> Has anyone implemented address validation with Campus Solution 9?
>
> If so, what suppliers are recommended?
>
> What are the lessons learned from implementing address validation?
>
> Any impacts on system performance associated with implementing address validation?
>
> Any information/advice would be appreciated.
>
>
>
> Thanks
>
> Nader Jarufe
>
> NextGen SAAS Program | The University of NSW
>
> P +61 2 9385 7892 | E n.jarufe@unsw.edu.au | W www.unsw.edu.au
>
> CRICOS Provider Code 000098G
>
>
> -----End Original Message-----
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> HEUG.Online supported in part by:
> GreyHeller Makes PeopleSoft Mobile & Secure
>
> Use of this email content is governed by the terms of service at:
> http://www.heug.org/p/cm/ld/fid=403
>

Hi Nader,

Daniel’s post below reminded me about the geocoding…

We use QAS to add SA1 codes, CCD codes, DPID, and Barcodes to student addresses, which our Planning, Quality and Reporting unit uses for reasons outlined by Daniel.

We added the SA1 codes around October/November last year and are looking to retire CCD codes in April/May this year.

Thanks
Richard.


RICHARD OLDE
Manager, Student Systems and Projects
Student and Academic Services
Academic Division

T: +61 2 4921 8787
M: +61 (0)407 788 174
F: +61 2 4921 6937
E: Richard.Olde@newcastle.edu.au<mailto:Richard.Olde@newcastle.edu.au>

The University of Newcastle (UoN)
University Drive
Callaghan NSW 2308
Australia

CRICOS Provider 00109J
[http://s.uon.nu/i/1.gif]http://www.newcastle.edu.au

[http://s.uon.nu/i/2.gif]

[Web]<http://s.uon.nu/l/1>

[Blog]<http://s.uon.nu/l/2>

[Facebook]<http://s.uon.nu/l/3>

[Twitter]<http://s.uon.nu/l/4>

[YouTube]<http://s.uon.nu/l/5>

[http://s.uon.nu/i/0.gif?2]



From: Michael Bobele [mailto:michael.bobele@rmit.edu.au]
Sent: Thursday, 30 January 2014 10:39 AM
To: anz.heug@list.heug.org
Subject: [anz.heug] - RE: Address Validation

Nader,

RMIT does use real time validation software using the QAS software mentioned in a previous post. We only validate Australian addresses, but it is down to street level. We have not experienced problems with performance although did have some issues (I can get more technical details if you are interested) around installing the software in a multi-tier highly available system (multiple app and web servers behind load balancer). We load an update of the data quarterly.

Our largest issue is around what to do with addresses that don't quite match the database of addresses. We have opted to allow students to override the validation in a situation where they don't believe the validated address is correct. Overall the software has improved data integrity, however this ability to override does sometimes leave us with data that still needs cleansing. We do employ some batch checks to clean up remaining data. We opted for the override option to avoid calls into the service desk when the validation did not match.

We are currently looking at geo-coding software for QAS as well.

Happy to speaks to you more about our setup if you are interested.

Regards,
Michael


On 30 Jan 2014, at 10:14 am, Daniel Moore <daniel.moore@adelaide.edu.au<mailto:daniel.moore@adelaide.edu.au>> wrote:
Hi Nader,

At the University of Adelaide we have been using QAS to clean and geocode student address data so that it can be used indicate students’ socio-economic areas of origin. This information in turn is used to predict funding based on these placements. Our particular implementation was based on the process developed by the University of Newcastle.

The validation itself is an offline batch process. For the purpose above we’re only interested in the PERM address type, which we export from PeopleSoft and run through QAS in batch mode. We then re-upload the cleaned and geocoded data back into PeopleSoft. QAS is able to determine student addresses about 95-98% of the time, the remainder requiring manual intervention.

This process, being off-line has no impact on system performance. However a much nicer solution would have been to implement validation at the point of data entry, but this was out of scope of this particular project.

Hope this helps in some way ☺

Regards,

--
Daniel Moore
Team Leader System Operations
Student Administrative Services
The University of Adelaide, AUSTRALIA 5005
Ph : +61 8 8313 36361
e-mail: daniel.moore@adelaide.edu.au<mailto:daniel.moore@adelaide.edu.au>

-----------------------------------------------------------
This email message is intended only for the addressee(s)
and contains information which may be confidential and/or
copyright. If you are not the intended recipient please
do not read, save, forward, disclose, or copy the contents
of this email. If this email has been sent to you in error,
please notify the sender by reply email and delete this
email and any copies or links to this email completely and
immediately from your system. No representation is made
that this email is free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.

From: Nader Jarufe [mailto:n.jarufe@unsw.edu.au]
Sent: Wednesday, 29 January 2014 1:47 PM
To: anz.heug@list.heug.org<mailto:anz.heug@list.heug.org>
Subject: [anz.heug] - Address Validation


Hi All,

UNSW is currently investigating the implementation of address validation.

Has anyone implemented address validation with Campus Solution 9?

If so, what suppliers are recommended?

What are the lessons learned from implementing address validation?

Any impacts on system performance associated with implementing address validation?

Any information/advice would be appreciated.



Thanks

Nader Jarufe

NextGen SAAS Program | The University of NSW

P +61 2 9385 7892 | E n.jarufe@unsw.edu.au<mailto:n.jarufe@unsw.edu.au> | W www.unsw.edu.auhttp://www.unsw.edu.au

CRICOS Provider Code 000098G

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

USC is using QAS Experian – QAS Batch.  We have built a custom page within PeopleSoft Campus Solutions version 9 to export students MAIL and/or PERM address types (Australian only) for cleansing and to import the cleansed addresses.

Our Admissions and Enrolments staff in Student Administration use QAS Experion to undertake address cleansing as follows:

• Addresses of all new students loaded into the system are cleansed after each QTAC offer round;
• Students active in programs are cleansed fortnightly;
• Deferred and Completed students are cleansed monthly;
• Students with other program statuses are cleansed ad hoc.

 Approximately 10% of addresses in TAC loads require cleansing.