How to identify DATE TRACKED tables??? - HRMS Aces - The Oracle HRMS Community

You are not logged in. [Log In] HRMS Aces - The Online HRMS Community » Forums » Oracle HR » Miscellaneous » How to identify DATE TRACKED tables???

1 registered (CT), 8 Guests and 4 Spiders online.

Key: Admin, Global Mod, Mod

Recent Posts

Concurrent Request - running slow
by CT
Today at 11:16 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

GB EOY reports
by Vigneswar Battu
09/05/12 02:07 PM

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

#3341 - 16/07/08 07:43 AM How to identify DATE TRACKED tables???
gagsway1 hanger-on Registered: 25/06/07 Posts: 65	Dear all, could you please apprise of how to identify Date Tracked tables on Oracle HRMS/Payroll ?? Eagerly awaiting your response. Cheers!! god bless GS
Top

#3342 - 16/07/08 08:33 AM Re: How to identify DATE TRACKED tables??? [Re: gagsway1]
CT Guru Registered: 11/03/05 Posts: 1185 Loc: Bath	Tables end in "_F" and have a primary key comprising <internal id>, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE _________________________ L&K CT Remember: A dog is for life, not just for Christmas... unless you're in Korea
Top

View All Topics

Hop to:

Moderator: Administrator, Geoff Dixon

Forum Stats

791 Members
48 Forums
1582 Topics
7650 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