Thank you Robert. This is very helpful and you were so prompt in replying.
Regards
Janet
From: Robert Lacina [
mailto:anz.heug@list.heug.org]Sent: Wednesday, 9 July 2014 11:04 AM
To:
anz.heug@list.heug.orgSubject: [anz.heug] - RE: Creating a pseudonymous identity using information from Campus Solutions
Hi Janet – You could create a new “name type” (e.g. PSN=Pseudonym) and a new name usage order that returns the pseudonym if it exists, otherwise PRI or PRF, depending on how you set up the name usage table.
We did a similar thing where we created a new “Degree” name type (DEG), primarily for use for students from countries where their family/given name order is reversed, so that the name printed on their graduation parchment is correct.
Example “name usage” table setup: This can then be used to return a “Degree” name if it exists, otherwise it uses the “Primary” name.
[cid:
image001.png@01CF9B66.BEB7F4D0]
Example SQL:
SELECT A.EMPLID,
A.FIRST_NAME,
A.LAST_NAME,
A.NAME,
B.NAME_USAGE,
B.NAME_TYPE,
B.NAME_USAGE_ORDER
FROM PS_NAMES A,
PS_NAME_ORDER_TBL B
WHERE A.EFFDT = (SELECT MAX(A2.EFFDT)
FROM PS_NAMES A2
WHERE A2.EMPLID = A.EMPLID
AND A2.NAME_TYPE = A.NAME_TYPE
AND A2.EFFDT <= SYSDATE)
AND A.EFF_STATUS = 'A'
AND A.EMPLID = ‘123456789’
AND B.NAME_TYPE = A.NAME_TYPE
AND B.NAME_USAGE = 'NAME USG 4'
AND B.NAME_USAGE_ORDER = (SELECT MIN(D.NAME_USAGE_ORDER)
FROM PS_NAMES C,
PS_NAME_ORDER_TBL D
WHERE D.NAME_USAGE = B.NAME_USAGE
AND C.NAME_TYPE = D.NAME_TYPE
AND C.EMPLID = A.EMPLID
AND C.EFFDT = A.EFFDT);
Rob.
Robert Lacina
University of South Australia
Information Strategy and Technology Services
Student Information Systems
Phone: (08) 8302 5251 (external), 25251 (internal)
CRICOS Provider Number: 00121B
From: Janet A. Baker [
mailto:anz.heug@list.heug.org]Sent: Tuesday, 8 July 2014 2:15 PM
To: '
anz.heug@list.heug.org'
Subject: [anz.heug] - Creating a pseudonymous identity using information from Campus Solutions
Hi
Perhaps some of you can help us in how we might address the issue of a student requesting to use a pseudonym (as allowed under the Australian Privacy Principles) in a Learning Management System discussion forum that is deriving a first name and last name identification from Campus Solutions for students who are happy for their details to be displayed. We are searching for a solution that would allow us to continue to allow first and last name to be displayed for those who are agreable while allowing those who request it to use a pseudonym to do so.
Any ideas would be appreciated.
Janet Baker
Senior Policy Advisor
Open Universities Australia
Tel: +61 3 8628 2511
Fax: +61 3 8628 2900
www.open.edu.auhttp://www.open.edu.au-----End Original Message-----
-----End Original Message-----
For two decades, Open Universities Australia has broken down traditional barriers to tertiary learning. With an aim of making education easier to access, we’ve built a reputation as pioneers and leaders in online education. With our success has come an opportunity to expand, and from 2014, through Open Universities Australia, Open Training Institute, Open2Study and e3Learning, we will offer the broadest set of post-secondary education and training programs in Australia.
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