Home » Applications » Oracle Fusion Apps & E-Business Suite » why _f in HR table? (HR)
why _f in HR table? [message #344568] Sat, 30 August 2008 10:57 Go to next message
smithapadmini
Messages: 1
Registered: August 2008
Junior Member
Why there is a _f in hr tables like per_all_people_f?

Report message to a moderator

Re: why _f in HR table? [message #344631 is a reply to message #344568] Sun, 31 August 2008 03:38 Go to previous message
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
Senior Member
The "_F" suffix indicates that the table is date-tracked. Date-tracking is used when you need information of historical and future values of some piece of data. Since PER_ALL_PEOPLE_F is date-tracked you will for instance be able to see whether someone has changed their name, citizenship, employment or some other thing.

--
Aleksander

Report message to a moderator

Previous Topic: Superseded Items in Oracle Inventory
Next Topic: Foreign Currency Transaction
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 10:40:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.