Requirements in Temp Profile.

1.When a user first signs-in and submits his details the data goes into in_profile table and the status will be pending.

2.Once the PowerUser goes through it, he can approve it and put it in Active state or decline(sentBack) it .

3.An Active profile if modified goes into Modified State and a new record is created into the in_tempprofile table but the in_profile table is not updated.

4.A profile which is in modified state if modified again ,then we have to check if this record already exists in the in_tempprofile table if exists update in_tempprofile ,if does not exist then a record is added.