Who's Online
1 registered (CT), 7 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Concurrent Request - running slow
by CT
Today at 11:16 AM
Element to recover value in balance on leaving
by jkavia
Today at 11:04 AM
P11d's
by jkavia
Today at 10:49 AM
Assignment EIT not displaying in Self Service
by CT
Today at 06:45 AM
Vehicle Mileage Setup
by Chris Abraham
Yesterday at 12:24 PM
In which table is external learning data stored
by DMC
Yesterday at 08:45 AM
Oracle Payroll and Cash Management
by Gus
20/05/12 11:27 AM
Pension Auto Enrolment
by CT
18/05/12 09:46 AM
11.5.10 "Extended Support" extended til..... when?
by Vigneswar Battu
17/05/12 10:59 AM
Hacking element definitions
by CT
15/05/12 08:42 AM
Top Posters (30 Days)
CT 38
delboy 36
Vigneswar Battu 15
pat.woodall 9
bcooper 4
Gus 4
DMC 3
Mani 3
7Giri 3
Ryan 3
(Views)Popular Topics
Family Pack K issues thread 20153
CREATE_GRADE api returns:PLS-00306: wrong number o 15194
Still trying to locate... 13844
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11889
Viewing Output of another user 10307
HR_PF.K RUP4 10271
Review of my Release 12 laptop 9733
Enhanced Retro & Release 12 9397
Adding a taskflow button to a form 9129
Family Pack K 7906
Topic Options
Rate This Topic
#3773 - 08/12/08 03:33 PM Table name for Assignment Statutory Info
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 356
Loc: UK
Does anyone know the underlying table for the Statutory Info on Assignment screen?

Top
#3775 - 08/12/08 04:16 PM Re: Table name for Assignment Statutory Info [Re: SBi]
PeterP Offline
hacker
*****

Registered: 08/03/07
Posts: 94
Loc: Manchester, UK
It's in the assignments table -- PER_ALL_ASSIGNMENTS_F.

Top
#3776 - 08/12/08 04:16 PM Re: Table name for Assignment Statutory Info [Re: SBi]
kp_rapolu Offline
claiming squatters rights

Registered: 15/11/07
Posts: 213
Loc: U.K
Statutory Info on Assignment screen is nothing but a Soft Coded Keyflex rey.....

check the table HR_SOFT_CODING_KEYFLEX

At present for UK Legislation it is enabled at Payroll Screen Level.

_________________________
Krishna Prasad Rapolu
Oracle HRMS Consultant

Top
#3777 - 08/12/08 04:20 PM Re: Table name for Assignment Statutory Info [Re: kp_rapolu]
kp_rapolu Offline
claiming squatters rights

Registered: 15/11/07
Posts: 213
Loc: U.K
Which is specific to Legislations to capture the Statutory deatils

Ex:- PAYE tax reference for UK Legislation maintained at Payroll screen Level

Check the legislation rules

select * from pay_legislation_rules
where legislation_code ='GB'
and rule_type in ('SDL', 'S')

SDL - Means at What level you want to enable the Soft Coded keyflex
P -for Payroll , A- for Assignment These are only two levels seeded

S - tells you what is the ID_FLEX_NUM(GB_STATUTORY_INFO. Structure Id) from the Soft Coded KeyFlexfield.



Edited by kp_rapolu (08/12/08 04:23 PM)
_________________________
Krishna Prasad Rapolu
Oracle HRMS Consultant

Top
#3778 - 08/12/08 04:25 PM Re: Table name for Assignment Statutory Info [Re: kp_rapolu]
kp_rapolu Offline
claiming squatters rights

Registered: 15/11/07
Posts: 213
Loc: U.K
This is generally not to be changed, any changes to this lead to a spport issue.


Edited by kp_rapolu (08/12/08 04:25 PM)
_________________________
Krishna Prasad Rapolu
Oracle HRMS Consultant

Top
#3780 - 09/12/08 09:21 AM Re: Table name for Assignment Statutory Info [Re: kp_rapolu]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 356
Loc: UK
Thanks a lot KP

Top



Moderator:  bcooper, CT 
Forum Stats
791 Members
48 Forums
1582 Topics
7651 Posts

Max Online: 67 @ 14/04/12 05:38 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
CT 1185
bcooper 1112
delboy 594
Geoff Dixon 369
SBi 356
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 163
Gus 146
May
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31