Home » Applications » Oracle Fusion Apps & E-Business Suite » Social Insurance Number (GOSI Number) in which table
Social Insurance Number (GOSI Number) in which table [message #415506] Tue, 28 July 2009 02:10 Go to next message
adelshehri
Messages: 12
Registered: July 2009
Junior Member
Hello,

In the HRMS assignment details we add the social insurance for all employees as (GOSI Number)..

but I couldn't know the table which contains that column,,

I try to do examin --> Field name .. but it is not a column name !!

GOSI = General Organization of Social Insurance.

Please check the below Screenshot ...
/forum/fa/6613/0/


Can any one help
.
  • Attachment: gosi.JPG
    (Size: 48.34KB, Downloaded 2996 times)
Re: Social Insurance Number (GOSI Number) in which table [message #415543 is a reply to message #415506] Tue, 28 July 2009 03:50 Go to previous messageGo to next message
SanthoshKumar_s
Messages: 28
Registered: March 2005
Location: Hyderabad
Junior Member

Im not sure about this.
But u can give a try.

per_all_people_f.national_identifier
Re: Social Insurance Number (GOSI Number) in which table [message #415581 is a reply to message #415543] Tue, 28 July 2009 05:21 Go to previous messageGo to next message
adelshehri
Messages: 12
Registered: July 2009
Junior Member
Hi,

Thank you, but national_identifier is the column of the National ID number ...

Regards
Re: Social Insurance Number (GOSI Number) in which table [message #415590 is a reply to message #415581] Tue, 28 July 2009 05:40 Go to previous messageGo to next message
SanthoshKumar_s
Messages: 28
Registered: March 2005
Location: Hyderabad
Junior Member

I hope GOSI Number is the National Identifier for the Gulf region.
Re: Social Insurance Number (GOSI Number) in which table [message #415599 is a reply to message #415590] Tue, 28 July 2009 05:57 Go to previous messageGo to next message
adelshehri
Messages: 12
Registered: July 2009
Junior Member
Hi,

No it is not the National ID, It is for Social Insurance (This is an organization cutiing 9% of the employee salary monthly to return it to him after he completes his service "40 Years" service or 60 Years Age)


Regards
Re: Social Insurance Number (GOSI Number) in which table [message #415600 is a reply to message #415599] Tue, 28 July 2009 06:01 Go to previous messageGo to next message
SanthoshKumar_s
Messages: 28
Registered: March 2005
Location: Hyderabad
Junior Member

Ok. Thanks for sharing the info.
Re: Social Insurance Number (GOSI Number) in which table [message #415651 is a reply to message #415506] Tue, 28 July 2009 09:29 Go to previous messageGo to next message
Alien
Messages: 292
Registered: June 1999
Senior Member
It is set on the assignment, right?
Did you check hr_soft_coding_keyflex? (Join on soft_coding_keyflex_id).
Re: Social Insurance Number (GOSI Number) in which table [message #415755 is a reply to message #415651] Wed, 29 July 2009 02:46 Go to previous message
adelshehri
Messages: 12
Registered: July 2009
Junior Member
Thanks Alot ,...

Yes I found it in hr_soft_coding_keyflex Smile

Regards
Previous Topic: Sample Code For Check Funds
Next Topic: BP080 for contracts
Goto Forum:
  


Current Time: Mon Nov 04 12:51:48 CST 2024