You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!