Hi all,
The country codes delivered with PeopleSoft products use the ISO3166 international standard, however updates to these records are only provided with 'major releases' and depricated country codes (i.e. those no longer used within the ISO3166 standards) are not removed from the Country table.
This means that we have a growing list of country codes in our system that are no longer valid, yet can be readily selected for fields such as birth country, address country etc.
In Australia, this impacts our government reporting, as we now report live and direct from Campus Solutions. Country fields that invalid can be mapped to generic values but correcting or ensuring more accurate data entry is impossible when students and staff can select country values that should no longer exist.
I have logged this issue with Oracle requesting an ability to inactivate countries so that they can no longer be selected as a value in the Country field. I was asked to add this as an idea in the ideas lab, which I have now done:
https://community.oracle.com/mosc/discussion/4516885/Please vote on this idea if you agree that this change is of value.
regards
Jason
------------------------------
Jason McIntyre
Team Leader, Student Information Systems
University of The Sunshine Coast
+61 7 5456 3432
------------------------------