Results 1 to 2 of 2

Thread: State and temp Records in PeopleSoft

  1. #1
    Administrator
    Join Date
    May 2006
    Answers
    331

    State and temp Records in PeopleSoft

    1. State record at any point of time has only single line information, as it's driven by the Process Instance. While temp table can have multiple rows.

    2. State record had only single instance, while the temp table can have maximum of 99 instances.

    3. State record is used for restart logic.

    4. State record can be used for dynamically calling AE section, by adding AE_SECTION, AE_APPLID as fields. Temp table can not be used.

    The Temp table data is available only for the duration of run. Hence when the program is aborted the data stored in Temp table is lost and you can not restart the program from that particular point. Hence the statement I used is correct that State record can only be used for re-start logic.

    If you create a sql table as State Record - data will be stored in the database. If at any point of time, App Engine programs stops, you can continue from that point on provided Restart is enabled. This is called the restart logic. With restart enabled, you don't have to run app. engine program all over again. For this to be true, state record cannot be a derived record. It has to be a sql table.

    Temp. table is primarily used for set processing. If there are several users running the program at the same time, copies of tables are created in order to process in parallel. Temp. Table lives only until the program runs and is dissolved immediately after.

    Adapted Notes from Answers by peoplesoftfirendly, Vaibhav.

    Source: http://www.geekinterview.com/question_details/1704

    Note: This notes is user contributed. There is no guarantee that answers will be accurate. Please use it at your own risk.

    Last edited by admin; 05-21-2006 at 10:51 AM.

  2. #2
    Junior Member
    Join Date
    Feb 2007
    Answers
    1

    Re: State and temp Records in PeopleSoft

    hi ....
    Can any one post interview questions for peoplesoft HRMS?
    Thank you


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact