Search This Blog

Loading...

Monday, April 20, 2015

SQL to find the Navigation for a given Record Name

SELECT  A.PORTAL_URI_SEG2,
RTRIM(E.PORTAL_LABEL)
|| ' >> ' || RTRIM(D.PORTAL_LABEL)
|| ' >> ' || RTRIM(C.PORTAL_LABEL)
|| ' >> ' || RTRIM(B.PORTAL_LABEL)
|| ' >> ' || RTRIM(A.PORTAL_LABEL)
FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME
AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C
ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D
ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E
ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE
A.PORTAL_URI_SEG2 IN (select PNLGRPNAME from PSPNLGROUP WHERE PNLNAME IN (select distinct pnlname from pspnlfield where recname = < RECORD_NAME > ));

Friday, April 17, 2015

What is a fringe benefit?

Fringe Benefit:
Fringe is nothing but an extra/ an edge over something etc.
These are usually paid by employers to the employee to retain the talent pool. Fringe Benefits is a supplemental to employee's salary. Like an Employer can offer Employer Paid Life Insurance to an employee.

Most of the cases , fringe benefits are non-taxable unless until they represent a fair market value.
So these benefits doesn't fall under Employee taxable income. That's the reason the premium deducted in the Pay comes under Pre-Tax.

However, this depends on the  rules set by the IRS (Internal Revenue Service) in US.

Suppose if a coverage limit is set for Life Insurance and if an employers offers more coverage than the coverage limit set by the IRS then the extra perk becomes taxable.

Other examples of Fringe Benefits is like using company provided car, getting stocks etc.

Saturday, April 4, 2015

When to go for Partial Position Management.



Good example when to go for Partial Position Mgmnt. Source: Peoplebooks
“If you use PeopleSoft Pension Administration, you track your pension payees—retirees, beneficiaries, and QDRO (qualified domestic relations order) alternate payees—using the same tables that you use to track your workers. You want to drive your retiree organization by person (or in this case, by payee), rather than by position, so that you don't have to establish a different position for each payee in the system. To drive your worker organization by position and your payee organization by person, use the partial position management option.”

By Default, in the installations page, it is set to partial.

What is Person Mgmnt?  We go with this option, if our business has requirement of creating more jobs more often.
What is Position Mgmnt? We go with this option, if our business already defined positions (usually static, say healthcare etc.)and want people filling these positions.

Wednesday, March 25, 2015

HR: Tax Location Code Error while hiring an Employee.

This error might confuse us because there are two location fields on the Job Data page.
One is one the Work Location Page and other one is on the Payroll tab.

Location on Work Location page does not determine the employee’s primary work state. It is determined by the Tax location entered in the Payroll tab.

Once we provide data in this field, we should be able to save the Job data for New Hire.

Tuesday, March 24, 2015

Benefits Terms

OASDI -- Old Age, Survivor and Disability Insurance
FICA  -- Federal Insurance Contributions Act
FMLA  -- Family and Medical Leave Act
COBRA -- The Consolidated Omnibus Budget Reconciliation Act
FLSA  -- Fair Labor Standards Act
FEGLI -- Federal Employee Group Life Insurance
ABBR -- Annual Benefits Base Rate
EIC     -- Earned Income Credit. Represented as $E

Monday, February 9, 2015

%FilePath_Absolute and %Filepath_Relative


These are the meta variables used generally with File Classes.
Both of the help us in defining the path of the file. One of them is Absolute and other one is Relative.

I will not go much details about the syntax of the functions which use these variables.

I believe most of you might have put this question to your self when encounterd with below variables like what is Absolute path and Relative path.

 %FilePath_Absolute: We define the actual path on the server.
                                    We can place file on any folder path in the server.

Ex:- PS_HOME/user/filename.txt

%Filepath_Relative: This uses the system defined path.
                                  Files can be placed in the sub-folders beneath this path.
                                  System Defined paths are like PS_FILEDIR/PS_SERVDIR etc.

Ex:- PS_FILEDIR/filename.txt

SQL to find Navigation for a Given Process.

-- SQL to find Navigation for a Given Process.

The below SQL lists all the Navigations where the process is attached.

SELECT  A.PORTAL_URI_SEG2,
RTRIM(E.PORTAL_LABEL)
|| ' >> ' || RTRIM(D.PORTAL_LABEL)
|| ' >> ' || RTRIM(C.PORTAL_LABEL)
|| ' >> ' || RTRIM(B.PORTAL_LABEL)
|| ' >> ' || RTRIM(A.PORTAL_LABEL)
FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME
AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C
ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D
ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E
ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE
A.PORTAL_URI_SEG2 IN (SELECT PNLGRPNAME from PS_PRCSDEFNPNL P WHERE P.PRCSNAME = < PROCESS_NAME >);

Note: Substitue Process Name in the < PROCESS_NAME >.