The Candidate mobile number disappeared from ADR2 table

[former_member813945]

Hi,

I have an observation that, when candidate gets registered in the system with all the basic details like First name, last name, Email ID and Mobile number. The details get stored in respective tables. The mobile number of the candidate gets stored in ADR2 table. In ADR2 table requires ADRCOMM number which we get from BUT000. Till the candidate was not hired the ADRCOMM Number was there in BUT000 table but as soon as the hiring has been done for that candidate the ADRCOMM number got vanished from BUT000.

Kindly let me know that after hiring is that mobile number getting stored in any other table? Or what is the reason for mobile number to get disappeared?

Regards,

Sarika Mansukh

[JoshGn_zzz]

I am over a decade late. But I came across this question, when i was searching for solution, where BUT000-ADDRCOMM was empty, when BUPA_CENTRAL_GET_DETAIL was trying to retrieve the email ID of a candidate in E-Recruitment system, which led to some issues in our process.

In my case, BUT000-ADDRCOMM got filled when in t-code BP, Tab 'Address', 'Address Independent Communication' section was filled with email-id. 

[former_member731263]

Thank you very much but I wish we could have a table having all the data together not having a separate BUTOO, ADR2 etc. It is a process to match all the tables to give you results

[NicoleGeischnek]

Hi Sarika,

Employees usually don't have a possibility to maintain there telephone numbers in E-Recruiting. This is done in the ESS services as E-Recruiting doesn't have an automated transfer to HR.

Regards,

Nicole

[former_member813945]

Hi Nicole,

Thanks for your response. In E-recruitment the candidate gets register in the system then gives the confirmation and then go to My profile and fills mobile number becoz we have made customization on my profile page that the mobile number is the mandatory field. However, i want to display that mobile number in one of my applicant details report.

Therefore, I have given logic to fetch mobile number from ADR2 table. But ADR2 table needs ADDRCOMM number which we get from BUT000 table. For registered candidates the ADDRCOMM numbers get created in BUT000 but as soon as hiring done that number gets diapered from the table.

Can you pls let me know that after hiring the mobile number gets stored in other table?

Or

What is the reason to ADDRCOMM number to get disappeared from BUT000 table.

Regards,

Sarika Mansukh