3/29/12

BENEFIT_NBR, BENEFIT_RCD_NBR and EMPL_RCD field relationships

What is the difference between BENEFIT_NBR and BENEFIT_RCD_NBR fields?
I had this question for so long and below is what I found.

BENEFIT_NBR:
BENEFIT_NBR field is particular to Base Benefits Enrollment. From my analysis, I found that this field is no longer used by PeopleSoft and Oracle would also confirm that. So, BENEFIT_NBR being a numeric field should always contain the value of 0.

BENEFIT_RCD_NBR:
This field is used in capturing benefits data for multiple jobs. BENEFIT_RCD_NBR field is used in employment and would contain similar values to Employee Record Number (EMPL_RCD).


1 comment:

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month