Third-Party Data Importation into Interface Tables

To import third-party data into PeopleSoft Project Costing interface tables:

1. Map fields from the third-party application to fields in the appropriate PeopleSoft Project Costing interface table based on this list:

   Interface	Table Name
   Projects	Projects Interface staging table (INTFC_PROJ_GEN)
   Activities	Activities Interface staging table (INTFC_ACT_GEN)
   Resources	Project and Activity Team Interface staging table (INTFC_TEAM_GEN)
   Transactions	Project Transaction Interface staging table (INTFC_PROJ_RES)

2. Review and edit data by using the appropriate interface page based on this list:

   Data to Review and Edit	Page
   Project and project tree information	Review Project Details page
   Activity information	Review Activity Details page
   Resource information	Review Resource Details page
   Transaction information	Review Transaction Details page

   See Reviewing and Modifying Interface Table Data and Pages Used to Review and Modify Interface Table Data.

3. Run processes to load data from the interface tables into PeopleSoft Project Costing tables.

   Use process options to create, update, or append a project tree.

   If you set up the appropriate exchange rates, the system converts transaction amounts that differ from the business unit currency during the transaction loading process.