Search This Blog

Loading...

Thursday, July 16, 2015

Time and Labor Tables


TL_EMPL_DATA
Contains high level data of an employee like Workgroup, Taskgroup, Time Reporter Status.

TL_RPTD_TIME
Extracts employee time reported data.
Both the elapsed and punch type data is stored in this table.
TL_QUANTITY is field which stores the reported hours data.
DUR field contains Date value.

Thursday, July 9, 2015

File Layout: Previewing Input Data

Some useful information related to previewing data in File Layouts.

1. Preview file data is available only for FIXED and CSV file layouts.
2. With an XML file, you cannot preview the data

The preview data appears only if you selected an import file, if the file format matches the format specified for the file layout definition, and if it contains a file record ID that matches the file record ID of the selected segment.

Source referred from PeopleTools 8.52

Tuesday, May 19, 2015

BI Publisher: Please close MS Word and try again

When you get below error while installing BI Publisher Desktop version make sure that all MS office related items like Outlook,MS Word etc are closed.
Then try installing again.
This would mostly resolve the issue.

Error: Please close MS Word and try again

Friday, May 8, 2015

Override Search Record

Why do you override a search record? What are the scenarios you come across to implement this option?

Ususally, component search records will do. They help us in getting the required data onto the search page.
Below are few such cases, where you would be using 'Override Search Record' option.

1. May be you come across a scenario where when you access component should have one
    search  record and when you access component through Component Interface another
    search record.

2. Also another case is, if you want to register the same component  to be available at two
    different places in PIA.
 

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.