Search This Blog


Friday, February 12, 2016

Benefits Tables

Benefit Tables:

PS_DEPENDENT_VW -- Contains information related to Dependent Beneficiaries.
PS_BAS_ACTIVITY    -- Lists all events triggered for an Employee.

Thursday, January 7, 2016

Application Engine: Dynamic Message Catalog

Usually , we use Message Catalog to display Warning/Error Messages. Sometimes, due to requirements we are tend to show dynamic messages.

For example, if an Employee applies for a leave, we can show a soft message saying ' Leave approval request sent to Ram,K' assuming 'Ram,K' is the supervisor of the Employee. For other Employee, it could be different supervisor name.

To make use of dynamic message, we use %bind variables in the Message Catalog.

Now in our current post, we will see how to invoke Dynamic messages from with in Application Engine program.

We may come across a requirement, where we need SQL trace only on certain important SQLs.
In general, we set the SQL trace setting in AE process definition which generates trace for all SQLs.

To cater the requirement, we can make use of dynamic messages.
 %bind from Message Catalog is replaced with the data from Parameters section.

Below is the snapshot.

From AE , the Message Catalog uses the Parameters

Message Catalog Entry:

 So the End message could look something like " A total of 1200 rows were inserted from PS_JOB into table PS_REC1_STG

Tuesday, August 25, 2015

Time And Labor: Some useful Info -- Part 1

Time And Labor:
As the name itself suggests, it captures the time consumed for each of the efforts. Based on hourly rate, the employee is paid through payroll.

There are two types of noting time in PS.
1. Punch time -- Captures Time IN and Time OUT. say Lunch 12:30 pm to 1:30 pm
2. Elapse time -- Captures time in periods. say 8 hours etc.

Base Benefits: Some Useful Info -- Part 1

Where do we set Age limit for Dependents in Benefits Module?

Let's consider a scenario where an Employee enrolls dependents into a plan ,say Health Care Plan.
And as per the insurance plan, only dependents upto 25 years are covered.

Setup HRMS --> Product Related --> Base Benefits --> Rates and Rules --> Dependent Rules Table.

Where do we setup to exclude disabled from Age limit for Dependents in Benefits Module?
Setup HRMS --> Product Related --> Base Benefits --> Rates and Rules --> Dependent Rules Table.

Saturday, August 8, 2015

Core HR : Some useful info -- Part 1

Action Stat Table:
 We have come across tables such as ACTION_TBL (Action Setup Table) and ACTN_REASON_TBL (Action/Action Reason Combinations). There is one another table, ACTION_STAT_TBL where we can see the list of all possible Action that can be applied on a Job row.

Though it contains both the delivered/custom actions, we can distinguish them using the value stored in the SYSTEM_DATA_FLG.
Application Version: 9.1

Payroll Status field on Job Data:
As we know the importance of the payroll status filed, which is used by Payroll. The field behind the scenes used is JOB.EMPL_STATUS !!

Some known values for EMPL_STATUS
A - Active
L - Leave
P - Leave with Pay
S - Suspended
R - Retired
T - Terminated

Next question is what is the field used for HR Status? .....
It's nothing but HR_STATUS !!

Thursday, July 16, 2015

Time and Labor Tables

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

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