PeopleSoft HCM 9.2 - New Features

Improved User Interfacce
MSS Improvements

Manager Dashboard
Talen Summary

Analytics/Pivot Grids

Global Search  - Data and Trasnaction Navigation
Improved Overall Performance

Smart HR Template
HR Notifications
Peoplesoft Update Manager (PUM)
Peronalizing Toolbars

Fluid Mobile Interface

PeopleSoft General Ledger (GL)

PeopleSoft General Ledger

For your PeopleSoft, QA Automation Testing and Big Data training and job needs, Please contact eastbaytrng@gmail.com or (925) 322 3131

PeopleSoft GL is core of PeopleSoft Financial Management System. It is integrated with other modules such as Purchasing, Expenses, Payroll, AM, AR, AP, Billing, Inventory, Cost Management, EPM, Treasury, HRMS, ELM and PC.

Below diagram illustrates the GL flow of the implementation. This is not only applicable for GL, even other modules AP, PO, AR (even any ERP modules) follow the same flow.

Implementation planning - Includes how to structure the Business Unit, Tables and other business rules.

Tables Setup – Setting up Business Unit, Installation Options,  User Preferences,  Account Types,  Details Calendars, Defining Chart fields,  Creating Trees,  Journal Processing setup such as Ledger Templates, Ledger Group, Accounting Periods maintenance,  Defining Journal Entry templates,  Journal Source setup,  Define ChartField Combination edits

Transaction Processing – Entering data to GL using the Tables setup done in above step.  Includes Entering Journals, Journal Edit Process, Posting Journals, Copy Journals, Unposting Journals,  Importaing Spreadsheet Journals, InterUnit and IntraUnit Accounting.

Reporting – Performing Year-End Close. Reporting results using PS/nVision which includes creating simple Matrix Layout, Report Request and creating an Income Statement and Document Sequencing

GL Process Flow

Below diagram shows the GL Process flow from feeder systems to summary ledger. 

Feeder systems  - Feeder systems can be non-PeopleSoft or other PeopleSoft modules such as Payables, Receivables, or even PeopleSoft HRMS. For example, PeopleSoft HRMS- Payroll  sends the Payroll summary information to account the payroll expenses in GL module after the Payroll process completion during each pay period. Jounral Generator is PeopleSoft process to integrate other PeopleSoft modules transactions.

GL Menu navigation shows the most of the Setup Tables used in the left side.  Right side shows the functions under the GL.

 
What is LEDGER?

Ledger represents a set of books for each business unit or entity. The source for LEDGER is journal entries.

Ledger Table can represent multiple ledgers such as ACTUALS, BUDGET, FORECAST, ENCUMBRANCE, STATistical or any other type of data.

What is Control Table vs. Transaction Table?

Control Tables store the information related to Accounting Structure and processing rules when a transaction is recorded.

Examples of Control tables are: Accounts, Departments, Trees, Calendars

Generally control tables are keyed by SETID and Effective-dated.

Transaction Tables are keyed by BUSINESS_UNIT  which stores business activity such as Journals, Vouchers,  Balances and Invoices.

Sample Transaction tables in GL are,

• o   JRNL_HEADER -  Journal Header Table
• o   JRNL_LN  - Journal Line Table
• o   LEDGER – Ledger Table

Control tables relatively static, but transaction tables are updated frequently.

JRNL_HEADER

Journal Header Data - Header Record for Journal.

Important Fields include the following:

JOURNAL_ID, JOURNAL_DATE, JRNL_HDR_STATUS,BUDGET_HDR_STATUS, DESCR254

JRNL_LN  Journal Line Data - Line Record for Journal.

Important fields include the following: Journal

ID, Journal Line #, Department ID and Account (and Other Chartfields), Budget Line

Status, Distribution Amounts, Budget Dates, Close Flag

LEDGER Ledger Data - Summary of Balances by Chartfields by Fiscal Year, Accounting Period

Navigation: 

Creating a Journal Entry - Revenue

Navigation: General Ledger > Journals > Journal Entry > Create/Update Journal Entries

Deleting a Journal Entry

Navigation: General Ledger > Journals > Journal Entry > Create/Update Journal Entries

Journal Entries in General Ledger can only be deleted if they have not been posted. 

For your PeopleSoft, QA Automation Testing and Big Data training and job needs, Please contact eastbaytrng@gmail.com or (925) 322 3131

PeopleSoft HCM 9.2 Features

• PeopleSoft Search – To find information faster using internal Search Engine

• Pivot Grids – To deploy the dynamic reporting and analytics capabilities

• Embedded Help - Detailed, embedded help now appears to users when they select the information icon available on group boxes, grids, or scrolls on a page

• New PeopleSoft Online Help Solution - Starting with 9.2, PeopleSoft delivers new help solution interface that looks and functions much like a website.

• PeopleSoft Continuous Delivery Model - PeopleSoft plans to accomplish by delivering new features and capabilities within each calendar year between major releases

• PeopleSoft Update Manager - PeopleSoft Update Manager provides the tools a customer needs to reduce time, effort, and the cost of PeopleSoft application maintenance

• iPad Certification -The iPad makes PeopleSoft dashboards even more effective at providing important information at a-glance.

• PeopleSoft Interaction Hub - The PeopleSoft Applications Portal has just been re-branded as the PeopleSoft Interaction Hub

• PeopleSoft Talent Management 9.2 to HCM 9.1 Integrations - PeopleSoft Talent Management 9.2 to PeopleSoft HCM 9.1 Integrations provide PeopleSoft HCM 9.1 customers the ability to leverage the newest Talent Management 9.2 applications without requiring a full upgrade to PeopleSoft HCM 9.2

• PeopleSoft Fluid User Interface (delivered in PeopleSoft HCM 9.2 Update Image 9) - The PeopleSoft Fluid User Interface is a significant enhancement to the PeopleSoft’s “classic” user interface. Fluid pages are designed to be used on mobile devices, and they offer a familiar and intuitive mobile-friendly interface. The pages can also be used on laptops and desktops if you so choose.

• Employee Photo (delivered in PeopleSoft HCM 9.2 Update Image 9) - The PeopleSoft application now gives you control on whether you want to display a photo of the employee on application pages throughout the HCM system. The Installation Table has the option to choose.

HCM 9.2 Navigation

Data Navigation
Add a Person Workforce Administration > Personal Information > Add a Person
Add employment instance Workforce Administration > Job Information > Add Employment Instance
Bio/Demo Data Workforce Administration > Personal Information > Biograpical > Modify a Person
Business Unit Setup Set Up HCM > Foundation Tables > Organization > Business Unit
Citizenship Data Workforce Administration > Personal Information > Citizenship > Identification Data
Combination code Table Set Up HCM > Common Definitions > Chartfield Configurations > Chartfield Transaction Table
Company Table Set Up HCM > Foundation Tables > Organization > Company
Department Code Table Set Up HCM > Foundation Tables > Organization > Departments
Disability Workforce Administration > Personal Information > Disability > Disabilities
E-Profile for personal information Workforce Administration > Self Service Transactions > Workflow Inquiry
Education Workforce Development > Profile Management > Profiles > Person Profiles
Emergency Contact Workforce Administration > Personal Information > Personal Relationships > Emergency Contact
Employee checklist Workforce Administration > Personal Information > Organizational Relationships > Person Assignment Checklist
Establishment ID Setup Tables Set Up HCM > Foundation Tables > Organization > Establishment
Ethnic Group Workforce Administration > Personal Information > Modify a Person (Regional Tab)
General Comments Workforce Administration > Personal Information > Biographical > General Comments
Identification Data Workforce Administration > Personal Information > Citizenship > Identification Data
Job Code Table Set Up HCM > Foundation Tables > Job Attributes > Job Code Table
Job Data Workforce Administration > Job Information > Job Data
Job Opening (Add) Recruiting > Create Job Opening
Job Opening (Update) Recruiting > Browse Job Openings
Leave Accruals Benefits > Enroll in Benefits > Manage Leave Accruals > Review Accrual Balances
Leave Plans Benefits > Enroll in Benefits > Leave Plans
Location Table Set Up HCM > Foundation Tables > Organization > Location
Maintain Flags Benefits > Maintain Primary Jobs > Maintain Flags
Manage Hires (Hire Applicant) Workforce Administration > Personal Information > Manage Hires
Modify a Person (Personal Info) Workforce Administration > Personal Information > Modify a Person
Pay Group Table Set Up HCM > Product Related > Payroll for North America > Payroll Processing Controls > Pay Group Table
Payroll Data Payroll for North America > Employee Pay Data USA > Update Payroll Options
Positions Organizational Development > Position Management
Query Manager Reporting Tools >Query > Query Manager
Recruting Table Update Set Up HCM > Product Related > Recruiting > Statuses and Reasons
Retirement Plan Benefits > Enroll in Benefits > Retirement Plan
Tenure Info Workforce Development > Faculty Events > Calculate Tenure > Create Tenure Data

PeopleSoft Implementations and Upgrades

PeopleSoft Implementations and Upgrades:

·         Our Company Reliance Transition Systems (RTSYS) offers implementation services specifically designed for PeopleSoft applications - HCM and FSCM. We can upgrade your system to the PeopleSoft version 9.2 to increase productivity.

·         Remote PeopleSoft Administration using 12+ Years experienced PS DBAs.

·         Offshore/Onsite Services to design and develop & provide customized solution.

·         Consulting Services for the Complex PeopleSoft Business process, Security, Workflow, Interfaces and performance tuning.

Staffing Services - Match the job requirements against consultants & provide experienced matching consultants for the projects.

We work in PeopleSoft since Version 7.5 and can provide exemplary services based on our past experiences.

We also provide Big Data & Hadoop Training and QA Java Selenium Automation Training through experienced consultants @ lowest cost possible.

Feel free to contact hr@rtsysinc.com or (925) 322 3131 for further questions.

PeopleSoft Security & Navigation Path

PeopleSoft Security:

5 core tables in the Security:

PSOPRDEFN - Stores user information

PSROLEUSER -  Stores user roles

PSROLECLASS — Permission Lists in roles

PSAUTHITEM — Menu items granted security by permission lists

PSAUTHBUSCOMP — Access to Component Interfaces

Master definition tables:

PSROLEDEFN — Role header table

PSCLASSDEFN — Permission List header table

User profiles define individual PeopleSoft users.Roles are intermediate objects that link user profiles to permission lists.Permission lists are groups of authorizations that you assign to roles.

PeopleSoft User security is organized as below.

User profiles (PSOPRDEFN) ->  Roles (PSROLEUSER) ->  Permission lists (PSROLECLASS).

Security Hierarchy:

One user can have multiple roles; one role can have multiple Permission lists. 

Objects Hierarchy:

Pages are attached to Components; Compoents are attached to Menu and Menus are assigned to Permission Lists. 

Tips:

1) How to reset the password from the back-end database - SQL:

update psoprdefn set OPERPSWD = '', acctlock = 0  WHERE oprid = '' ;

I store my ecnrypted password from another environment where my ID is working such as "DygLnRmZYrP43R6Dr02N", so my SQL will be,

update psoprdefn set OPERPSWD = 'DygLnRmZYrP43R6Dr02N', acctlock = 0  WHERE oprid = 'GGTESTID' ;

2) Password reset can be done via Data Mover Script:

update PSOPRDEFN
set OPERPSWD = 'new_password', ENCRYPTED = 0
where OPRID = '';

encrypt_password YOUR_USER_OPRID;

Advantage with Data Mover script is that you can use the readable password instead of encrypted in SQL above.

Find the page navigation:

If you know the Page or Component name but want to find the navigation path to access via PIA, use the following, 

Main Menu > Enterprise Components > Find Object Navigation.

Main Menu > Enterprise Components > Find Object Navigation.

Also, we can use the below query for the same.

SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH 
(REVERSE(PORTAL_LABEL),' >- '),' >- ')) "NAVIGATION" 
FROM PSPRSMDEFN P 
WHERE PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT' 
START WITH PORTAL_URI_SEG2 = 'Component Name' 
CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME 
AND PORTAL_NAME = PRIOR PORTAL_NAME 
AND PORTAL_REFTYPE = 'F' 

PeopleSoft Chrome and Firefox Extension

Thought this is useful for the PS community. Below link has extension for Chrome and Firefox browsers.

http://melban.me/extensions/peoplesoft-chrome-helper-extension/

I liked the field display information, which gives record and field-name directly from the page itself instead of going through application designer, which may be useful to developers and BA.

No more control + J, Control+Shit+J keys needed – page and others information can be found using the quick links as well.

Process Monitor has some quick links. Instead of navigating through the details- we can directly view the message logs & auto-refresh time can be configured.

Currently it supports all the tools version except 8.53 yet - I guess as of 12/12/2014.

XML FIle output from PeopleCode

Below is sample PeopleCode to export a Record View – PS_BCP1 to a xml file. Highlighted is the Target XML file name and Source table name.

Local XmlDoc &inXMLDoc;

Local XmlNode &rootNode, &childNode1, &childNode2, &textNode2;

Local string &xmlStr;

Local File &xmlFile;

Local number &i;

&xmlFile = GetFile("c:\temp\export_sample1.xml", "W", %FilePath_Absolute);

&inXMLDoc = CreateXmlDoc("");

&rootNode = &inXMLDoc.CreateDocumentElement("root");

Local Record &rec = CreateRecord(Record.BCP1);

Local SQL &sql = CreateSQL("SELECT * FROM PS_BCP1");

While &sql.Fetch(&rec)

   &childNode1 = &rootNode.AddElement(Lower(&rec.Name));

   For &i = 1 To &rec.FieldCount

      &childNode2 = &childNode1.AddElement(Lower(&rec.GetField(&i).Name));

      &textNode2 = &childNode2.AddText(&rec.GetField(&i).Value);

   End-For;

End-While;

&xmlStr = &inXMLDoc.GenFormattedXmlString();

&xmlFile.WriteLine(&xmlStr);

&xmlFile.Close();

PeopleSoft 9.1 has eMail approval feature - HCM

Announcing PeopleSoft HTML Email Approvals for HCM

https://blogs.oracle.com/peoplesoft/entry/announcing_peoplesoft_html_email_approvals

 This is good feature to Approve/Deny requests by Managers via eMail itself instead of PIA. Per Oracle delivered template, they have the below delivered options for email approvals.

·         Job Opening

·         Job Offer

·         Absence Request

·         Extended Absence Request

·         Promote Employee

·         Transfer Employee

·         Reporting Change

·         Performance Document

Spartan Programming

What is Spartan Programming?
Spartan programming seeks to reduce code complexity through  minimum coding practices.

Instead of these 4 lines of code,

import GREETERS:MyClass;
Local GREETERS:MyClass &greeter = create GREETERS:MyClass();
Local string &message = &greeter.GreetMe();
MessageBox(0, "", 0, 0, &message)

we could rewrite in two lines as below:

import GREETERS:MyClass;
MessageBox(0, "", 0, 0, (create GREETERS:MyClass()).sayHello());

It may be difficult to read this 2nd method but less codes to maintain..

Application Class

Steps to create application Class:
1. Create an application package.
2. Create an application class.
3. Code your class.
4. Test your code.

Using Application designer we can do step-1 and Step-2 above.

Step-3 might look something like this:

class MyClass
   method GreetMe() Returns string;
end-class;

method GreetMe
    Return "Hello " | %OperatorId;
end-method;

Step-4 Test the code:

import GREETERS:MyClass;
Local GREETERS:MyClass &greeter = create GREETERS:MyClass();
Local string &message = &greeter.GreetMe();
MessageBox(0, "", 0, 0, &message);


The first line of this listing imports the MyClass application class into the current PeopleCode module in a manner similar
to a PeopleCode Declare directive.
The second line creates a new instance of the MyClass class using the create keyword.

Inappropriate use of application Class:
1) Avoid using Runtime Context-Sensitive Variables such as %Component, %Portal, %Request, %Page, %Response.

2) Avoid Event-Based PeopleCode such as SavePostChange for Application Classes.

Mouse Over Popup - PeopleSoft 9.1

Mouse Over popup is new feature in PeopleSoft 9.1

Below example shows what is mouse over popup. It quickly shows additional employee or applicant information by pausing on a person's name or ID that has a dotted line under it, as shown in this example.

Now, let us see how to implement this technically. PeopleSoft application delivers these mouse over IDs:
APPLICNT_INFO_1
APPLICNT_INFO_2

EMPLOYEE_INFO_1

EMPLOYEE_INFO_2

EMPLOYEE_INFO_3

Field-Level

Navigation ->

Set Up HRMS, Common Definitions, Mouse Over Popup, MouseOver Field Definition, MouseOver Field Definition 

Component Level:

Set Up HRMS, Common Definitions, Mouse Over Popup, MouseOver Component Setup, MouseOver Component Setup

Note:  PeopleSoft delivers 31 fields in HCM 9.1 with this feature. Adding any other fields would be considered a customization and will require peoplecode modifications to the Application Package/Class - HR_MO_COMMON: SET_UP_COMMON, that is used to retrieve the data associated with any new fields.

Tools 8.52 - PS Admin tool to manage WEB server

Tools 8.52 introduces new options in the psadmin menu to administer the PIA web server. 

New psadmin options are listed below.

 1) Application Server 

 2) Process Scheduler

 3) Search Server

 4) Web (PIA) Server 

 5) Switch Config Home

 6) Replicate Config Home

 q) Quit

Command to execute (1-6, q): 4

Option 4 above has WEB server administration. Using this we can create domain same as Application server and Process scheduler servers.

Accounts Payable - Overview

PeopleSoft AP Integration with Other systems/modules:

PeopleSoft Payables Business Process

Voucher Entry & Approval
Voucher Build
Voucher Edit
Matching Process
Voucher Posting
Pay Cycle
Drafts
Payment Posting
Withholding
Archiving

PeopleSoft Payables tracks the stages using statuses of a voucher:

 - Entry status 

 - Match status

 - Approval status -- A voucher has to be reviewed for approval, or unless it is pre-approved. You can post a voucher even though it has not been approved for payment, if your business unit definitions enable you to.

 - Budget status

 - Post status -- The system creates balanced accounting entries to record your liability and sets the post status to posted.  To change the numbers on a posted voucher, you must first unpost the voucher to create reversing entries.  

 - Payment status -- The payment status is unselected, selected for payment, or paid.

 - Payment post status

Voucher Build
Voucher Build is a batch program that builds voucher record sets from limited information entered online or retrieved from other procurement processes.

Voucher Edit

Voucher Edit is an Application Engine program that loads new voucher data from the Voucher Build temporary processing tables and/or any recycled vouchers from the online tables to the Voucher Edit work tables and performs the following:

-- Performs field-level, relational, and balancing edits for the voucher header, voucher line.
-- Calculates net payment dues dates, discount due dates, and discount amounts according to the payment terms.

Matching Process

Matching is a flexible process that compares vouchers with purchase orders and receiving documents to ensure that you  pay for what you ordered and received. 

To run matching, you must have PeopleSoft Payables and PeopleSoft Purchasing installed on the same database. The system automatically does matching based on document characteristics.

Voucher Posting Process

Creates expense accrual accounting entries in accounts payable.  This process creates balanced voucher accounting lines entries on the voucher accounting line table.  The source for the voucher accounting entries are the expense distribution on the voucher (DR).  The  liability offset (CR) account value is populated from the default setup on the accounting entry template.  

Payment Posting Process

Creates voucher payments accounting entries in accounts payable.  This process creates balances payment accounting line entries on the voucher accounting line table.  The payment posting process used the voucher posting process and the accounting entry template as the source for the cash (CR) side of the accounting entry.  The offset (DR) side of the payment accounting entry is created by reversing the liability offset from the voucher accounting line entry.  

Journal Generator

This is the process that creates General Ledger journal entries from PS subsystems (modules).  For Accounts Payable, the journal generator selects rows from the voucher accounting line table that meet the defined selection criteria.  These rows are summarized and the data is sent to the general ledger in the form of a general ledger journal.  

AP Reports
Some major reports in PS payables :

Match Exception Report
    --Lists the match exceptions with voucher data, purchase order data, receiver data, and match error information.

AP/GL Open liability Report
--Compares the AP Open Liability balance to the GL Open Liability balance Detail AP/GL Open Liability Account Reconciliation Report
--Shows all accounting activity for accounts payable transactions for each voucher. Use the detail report to validate the AP Open Liability balance to the General Ledger

Aged Vendor Liability
--Lists all vouchers that have not been paid by the As of Date. You can run the report in either summary or detail format for specific vendors


Vendor Aging Report
--Lists all vouchers that have not been paid at the date you specify Vendor Witholding Balances Control Report
--Lists withholding activity for internal audits. We recommend that you run the report on a regular basis to check the withholding summaries

Outstanding Balance by Vendor
--Lists the gross amount of all the outstanding vouchers for the specified vendor

Deferred Processing

What is Deferred processing?
Deferred processing is used speed up the data-entry process.  This means that the system does not validate the data for each field as you  Tab through a page.  You can enter in all the data for your page without unnecessary trips to the  server for data validation. Entered data is validated when:

• You navigate to another page in the component 
• Click the Save button 
• Click the Refresh button (access key: Alt+0) 

If there are any errors in your data, you are notified at this time.

Point to consider -> FieldEdit event will not fire until we press the SAVE button if the deferred processing is ON.


You can select Deferred mode at the following levels:

• Page control 
• Grid
• Page (include subpage and secondary page) 
• Component levels

Next, how to setup this property in Application designer?  To set Deferred mode at the page level:

1. Open the page properties in PeopleSoft Application Designer.

2. On the Use tab, select Allow Deferred Processing

Similarly, we can do for other objects in their properties. For example, below property shows how to do deferred processing for Component-level.

File DELETE in SQR

Using the CALL SYSTEM, any OS commands can be executed from SQRs. 

CALL SYSTEM Using $del_file #del_status Wait 

if edit(#del_status,’9′) = ‘0′
show ‘intfiles.txt was deleted sucessfully’
end-if

$del_file – Specifies the operating system command to execute. The command can be a quoted string, string variable, or column.

#del_status – Represents the status of execution of OS Command. This is always going to be Numeric variable
UNIX/Linux: Zero (0) indicates success. Any other value is the system error code.
PC/ Microsoft Windows: A value less than 32 indicates an error.

Wait – This flag is used to enable to do multitask processing.
(Microsoft Windows only): WAIT specifies that SQR suspend its execution until the CALL SYSTEM command has finished processing. NOWAIT specifies that SQR start the CALL SYSTEM command but continue its own processing while that command is in progress.

For Microsoft Windows, the default is NOWAIT. On UNIX\Linux operating systems the behavior is always WAIT.

** Please note delete command needs to be built dynamically in $del_file above based on your process scheduler OS environment.

Deleting file from PeopleCode

Solution 1) Using Java class:
/* Deleting previously created csv file */
&MAIL_FILES1 = "\\test-server\test-folder\test_File_To_Delete.CSV";

&javaFile = CreateJavaObject("java.io.File", &MAIL_FILES1);

If &javaFile.exists() Then
   rem &Filename.open();
   &javaFile.delete();
End-If;

Solution 2) 

&tmpfile1 = GetFile(“c:\temp\filetoDelete.txt”, “W”, “A”, %FilePath_Absolute);
&tmpfile1.Delete();

Thanks Srivani for the solution-1.

PeopleSoft HCM/Payroll - Core Tables list

Human Resources Information/ Personal Data:

PERSONAL_DATA

PERS_DATA_EFFDT

PERS_NID

Employment Data:

EMPLOYMENT- - general employment data, such as various service dates, etc.

DEPT_TBL --This is one of foundation tables in HR.    

JOBCODE_TBL --This is also a foundation table. 

JOB-- Job Table (main HR, Payroll record) -Contains job records along with other

data.    

Benefits Data:

BEN_PROG_PARTIC – Stores the Benefit Program to which the employee is assigned.

LEAVE_PLAN – Stores enrollment in leave plans.

HEALTH_BENEFIT – Stores enrollment in health insurance plans

SAVINGS_PLAN --  Stores enrollment in TDA, ORP and Deferred Compensation

LIFE_ADD_BEN --  Stores enrollment in life insurance plans.

RTRMNT_PLAN – Stores TRS enrollment.

DISABILITY_BEN – Stores enrollment in disability plans.

Tax Data:

FED_TAX_DATA – Contains federal tax data, including nonresident alien data

STATE_TAX_DATA – State Tax Data

Payroll Data:

Payroll processing check data (records used by the payroll process to store check history)

PAY_CALENDAR

PAY_CHECK                                  

PAY_LINE                                                                                       

PAY_EARNINGS                                    

PAY_OTH_EARNS                                 

PAY_DEDUCTION                                

PAY_TAX

Payroll funding distribution data (records that tie funding to payroll actual):

PAY_ERN_DIST

PAY_DED_DIST

PAY_TAX_DIST

                                              

Other employee level payroll data:

GENL_DEDUCTION

GENL_DED_CD

ADDL_PAY_EFFDT

ADDL_PAY_DATA

ADDL_PAY_ERNCD

DIRECT_DEPOSIT

DIR_DEP_DISTRIB

PS_EMPLOYEE - Used for Reporting which contains almost all employee level data. Refreshed periodically.

PeopleSoft - Phases, Input and Output, Approvers

Table below shows the stakeholders of each phase and input/output.

Task/Phase	Contributors	Approver	Input	Output
Fit/Gap	Business Analyst, Functional Analyst, PM	Business Process Owner	User Requirement	List of RICE Objects
Functional Design	BPO, Functional Analyst, Solution Architect	Business Process Owner	List of RICE objects,  Business Rules,	Functional Unit Test plan, Functional Design Document
Technical Design	Development Team	Project Manager	Functional Design document	Technical Design Document, Unit Test plan, Deployment Plan
Development	Development Team	Technical Architect, Tech Lead & PM	Technical Design Doc.	Source Code for RICE
Testing	Development Team and Testers, Users	PM, Tech Lead,  Test Manager	RICE Objects	Test Result
Implementation	Environment Team (DBA, Admin),  Sponsors, DEV team, Functional Team	Business Owners, PM,  Release Manager	UAT Approved RICE Objects, Deployment Plan	RICE objects in Production

PeopleCode Event Sequence

'