Staging table: Staging table is an physical table like state record. It has suffix with "_stg". It is used for doing manuplations.

Staging tables are the interface tables to thirdpary or different modules.
Data will be inserted in those tables and then we need to have some process to validate those data and if validated sucessfully we insert that data into PeopleSoft tables.
For e.g.
In Inventory, we can have 3rd party to pack and ship the material.
So 3rd party will provide the shipping information which will be published and staged in staging tables.
Then that data will be validated and correct data will be inserted in PeopleSoft Inventory table.

Cheers
Nitin

Hi Nitin,
how to insert staging table data to job record using AE and CI.
Can u provide me any code.

Thanks in advance.

In its simplest form, "staging" involves putting something in a specific location to be accessed at a later time. All like items will be staged in the same location. For databases, the most common staging location would be a database table. Maybe an example can help illustrate why we would use staging.

Let's assume we are working on a website to obtain orders from our customers. Our customer shops for items on our website and then places their order. At the end of the order, we confirm their credit charges and then display webpage indicating the successful status of their order. The next thing that normally happens is that we email the customer a copy of their order. But waiting for an email server can cause an unacceptable delay in displaying the order confirmation. So we stage the email confirmation in the table. Instead of actually sending an email to the user during their order process, all we do is INSERT one row containing the order_id into the email staging table. If we have many simultaneous users, the email staging table can contain many rows, one for each order. Every five minutes, a scheduled job looks in the staging table to see if it needs to send out order confirmation emails. If the table contains data, it formulates the email and sends it out. The job then removes the entry from the staging table.

With the staging table, we do not need to perform the action right now. We will get to the action later. So the table contains entries for that action.

Courtesy: Internet

Thanks gaurav nanda. Thanks was helpful information.

i need peoplecode i have a normal table and stagging table and check box on a page vn i click the check box the data should come from normal table to stagging table i need how to write the peoplecode and event is Copmonent Record Filed Event (FIeld Edit , Field Change)
Plz help me frenz

I am having a weird problem. I have one query which provides me some records from my database . I use Oracle Sql developer or Toad as database tool, the problem is with the results. When I run the same query directly from different machine then it displays complete results, therefore I can say that query has no problem. But when I run the same query with SQL Developer then it does not provide me any result, and shows one empty row. Please help me I am running on Oracle 10g.

this is a view select * from okc_k_headers_all_v

Appreciate gaurav's explanation, Thanks a lot for Posting .

Gaurav's reply was very helpful.

Gaurav Nanda's explaination is good

Gaurav, I am new in this field and I am sure even layman can understand what is staging by reading through your example. Thank you very much :-)