Viewing the Data in the PeopleSoft HCM Database
The EnterpriseOne data is automatically imported into the HCM database tables through subscription to the XML messages that are sent by the EnterpriseOne Integration Server.
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
Monitor Overview Page |
IB_MONITOR_OVRVIEW |
View high-level information sorted by service operation or queue. |
|
Asynchronous Details Page |
IB_MONITOR_DET |
View asynchronous service operation properties. |
|
GL Business Unit Page |
BUS_UNIT_TBL_GL |
View the identifier and description of business units imported into the GL Business Units table. |
|
GL Account Table Page |
GL_ACCOUNT |
View the identifier and description of accounts imported into the GL Account table. |
|
View Cost Centers Page |
HPYP_CC_TBL |
View cost centers imported into the Cost Center table. |
The GL Business Unit page only provides the IDs and descriptions of the GL business units imported into the GL business units table. To view additional information about the GL business units, such as the As of Date and Base Currency, you must create a query using Query Manager.
To create a query to view information from the GL business units table using Query Manager, you must:
Select
Select Create a New Query.
Search for the record BUS_UNIT_TBL_FS.
Click the Add Record link.
This takes you to the Query page.
On the Query page, click the Check All Fields button.
Click on the Records page and search for the record BUS_UNIT_TBL_GL.
Click the Join Record link.
Use the default join type, Join to filter and get additional fields (Standard Join).
Click on the A= BUS_UNIT_TBL_FS link.
Click the Add Criteria button.
Select the fields to include in the query.
Save the query.
Run the query.
The query returns a list of all GL business units.
The GL Accounts page only provides the IDs and descriptions of the GL accounts imported into the GL accounts table. To view additional information about the GL accounts, such as currency and account type, you must create a query using Query Manager.
To create a query to view information from the GL accounts table using Query Manager, you must:
Select
Select Create a New Query.
Search for the record GL_ACCOUNT_TBL.
Click the Add Record link.
This takes you to the Query page.
On the Query page, select the fields to include in the query.
Save the query.
Run the query.