Australia - New Zealand (ANZ)

  • 1.  Country Code management

    Posted 04-05-2022 09:55 PM
    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
    ------------------------------
    Attend a Regional Conference Near You!


  • 2.  RE: Country Code management

    Posted 04-05-2022 10:34 PM

    Thanks Justin

     

    So the former country codes remain for students to pick even though no longer used?  Assume the Taiwan title will still be fine?

     

    Tony

     




    Attend a Regional Conference Near You!