Can I use PER_PEOPLE_F_PK for my internal unique identifier
I currently use PERSON_NUMBER as the unique Id for my internal applications. I have a separate business process for re-hires where I change the PERSON_NUMBER after it's been passed from Oracle to my internal applications. This change causes considerable rework.
Do others have experience using PER_PEOPLE_F_PK or PERSON_ID as a unique id for internal applications? Is this more reliable and unchanging? Are there negative impacts to using PERSON_ID that should be considered?
Tagged:
0