Tag Archives: P6

The integration of TimeControl timesheets to Primavera is highly configurable

When you are looking to integrate TimeControl with Primavera you have many possible options to employ to make sure you get the actuals you need into however you’ve configured Primavera.  TimeControl has had a link with Primavera since 1997 and we are very familiar with both the technical architecture and functional specifications of the system.  All versions of TimeControl: TimeControl, TimeControl Industrial and TimeControl Online include Primavera bi-directional integration.  Here are some ways the integration can be configured.

Integration with either Primavera EPPM or Primavera Pro P6

First of all TimeControl includes the ability to integrate with either Primavera’s EPPM centralized system or Primavera Professional.  Linking with EPPM is usually done using Primavera’s Web Services but can alternately be done directly with the database.  Linking with Primavera Pro on a desktop or using a network file share for the data is done directly between the TimeControl and Primavera databases.  This is set up in the Link Definition area of TimeControl.

Moving data into TimeControl

Once you’ve defined the link to your Primavera, data can be updated from selected Primavera projects into TimeControl either on demand or on a scheduled basis.  You can even configure TimeControl to automatically update the TimeControl Project Table with new projects in Primavera which you flag there to be ready to be transferred to TimeControl.  You have a number of options on updating the TimeControl project and charge code list with information from Primavera.  This includes deciding whether or not to bring in the milestones, whether to bring in Activity Steps, whether to bring in tasks even if they haven’t had a change and whether to bring in tasks which are already closed.  You can also decide if only the Primavera Primary Resource can update the ETC and TimeControl will respect that choice in the timesheet.  You can decide whether to bring in Resource definitions, Role Definitions or both and even decide if you want to work in TimeControl at a more summarized level of the project than is in Primavera.

Moving data back to Primavera

Once data has gone through the Matrix Approval Process in TimeControl, it can be used to update the Primavera project.  There are a lot of options here.

Link Configuration

First, decide if you want to send back the ETC as hours remaining, days remaining or percent complete.  Then tell TimeControl if you’d like to send back actuals in days or hours and how many hours make up a day.  Then decide if you’d like to group all the timesheet hours into one entry per timesheet period (handy for super long multi-decade projects) or on the date you did the work (much more common).  If TimeControl can’t find an assignment for the work it is trying to update, decide if TimeControl should create an assignment with a budget of zero or create the assignment budget equal to whatever the timesheet data is.

Resource Assignment Options

TimeControl can determine what resource an employee should be counted as either in the employee definition or from each timesheet line.  We call that line-item-resources.  Not everyone configures TimeControl this way but this allows an employee to log their time as one type of resource for part of the day and as other types of resource for other parts of the day.  So if you’re being an engineer in the morning and a project manager in the afternoon, TimeControl can update Primavera’s assignments and costs properly.

Rate Options

TimeControl allows an unlimited number of rates per employee and even multiple timesheet lines on one timesheet with different rates for each.  For each possible rate code, there are multiple possible rate values.  So, for example, an employees “Standard” rate code might have one value for actual salary, another for billing, another for average project value and so on.  You can decide in this link definition, which of the Rate Values to transfer to Primavera if you elect to transfer costs.  For more information on Rates, we recommend looking at the White Paper: Creating your Rate Structure in TimeControl on the TimeControl.com website.

Material Transfer Rate Option

If you are using TimeControl Industrial, you may be collecting more than timesheet hours and timesheet costs.  If you are collecting material consumption, equipment usage or even production accomplished in TimeControl Industrial’s material entry module, then the same concept of rates and costs exist there.  This means you might have an internal cost of purchase for materials along with a billing cost and a project committed price which are all distinct.  The Materials Transfer Rate Option lets you decide which rate value to use when calculating the cost as it is transferred to Primvera.

PMV Transfer Options

TimeControl’s Project Manager Validation functionality lets the project manager execute a line-by-line approval once the overall timesheet is approved.  This allows a project manager to hold back on transferring some data to Primavera due to project updating reasons even though it might be just fine on the timesheet for the individual.  The PMV Transfer Options allows you to define whether all data is being pushed back to Primavera or only that data which the project manager has approved in the PMV screen.

Data Options

Finally, the data options has numerous options on what to send back to Primavera and how including.

    • Transfer Resource Actual Hours
    • Transfer Resource Actual Cost
    • Transfer Expenses. This refers to the expenses associated to each TimeControl timesheet.
    • Transfer Resource ETC. This will transfer the assignment estimate to complete based on the definitions above.
    • Transfer Resource Complete Indicator. This is the complete checkbox on the timesheet.  When selected, TimeControl will mark the task as complete in Primavera with no remaining duration.
    • Transfer Line Notes to P6. This transfers the notes from the TimeControl timesheet line item to notes in the Primavera activity.
    • Transfer Activity ETC. This is the Activity Estimate to Complete that is on the Activity tab of the timesheet not the assignment estimate to complete.
    • Transfer Activity Complete Indicator. This is the estimate to complete for the overall activity, not each assignment.  This can be updated within the Project Manager Validation Screen when doing line item approvals.
    • Transfer Project Steps. These are activity steps that can be updated in the timesheet.  Updates to this may have been restricted to the (Primavera Primary Resource if you selected that option above).
    • Transfer to Financial Periods. You can elect to move data into Primavera’s Financial Periods rather than to the task summary. There are implications to this which you’ll see discussed in the TimeControl Reference Guide.
    • Transfer Materials. This moves the TimeControl Industrial Materials usage and costs.
    • Transfer Expected Finish Date. This can be updated on the timesheet if you make the field visible.

Whew!  It’s a lot right?  If you’re using Primavera and are feeling a bit overwhelmed, don’t worry.  The important thing is that these options are all designed to allow you to adapt TimeControl’s integration to whatever elements of Primavera you are using however you have configured Primavera.  When creating your link between TimeControl and Primavera, the TimeControl technical staff are always ready to help you figure out how to configure the system to suit you best and, once it’s configured most organizations don’t have to touch the link definition again.

For more information on the Link between TimeControl and Primavera, go to the TimeControl/Primavera solutions portal at: TimeControl.com/use-cases/linking-with-primavera-p6.

Read the new White Paper on Integrating TimeControl and Primavera

Oracle_GoldPartner_300x80Oracle-Primavera EPPM administrators know that a Primavera timesheet for task updates is already included when you purchase the EPPM Team Member license. But there are many business scenarios where using a third party timesheet will maximize your Primavera effectiveness.

TimeControl is a multi-function timesheet that is already integrated to both Oracle-Primavera EPPM and Primavera Pro.  It was created to bring timesheet functionality even further.

Imagine one or more of these scenarios:

You need a timesheet but you are using Primavera Pro on the desktop, not EPPM on the server or in the cloud

TimeControl already includes complete integration with both Primavera EPPM and Primavera Pro on the desktop. You can support as many desktop users as you wish and even have a mix of EPPM projects and remotely managed projects on Primavera Professional integrated at the same time.

Your rates are different per client or per project or per task

TimeControl has extensive rate management functionality allowing an individual to have an unlimited number of rate codes. An employee can have different rates for different projects, different rates for different roles on the same project or different rates for different tasks all on the same timesheet. Not only that, but for each of those rate codes you can maintain multiple values so tracking the internal cost, billing value and average project cost can be done all at the same time.

You use Roles rather than individuals in Primavera for Resource Scheduling

TimeControl supports the notion of work at the role level, the generic resource level and the individual.

You are working at a different level than the project tasks

TimeControl allows you to summarize Primavera activities into higher level TimeControl Charge Codes or to summarize TimeControl Charge Codes to Primavera activities. This lets the timesheet function at a different level than the project schedule.

Same timesheet for Primavera and Payroll and HR and Billing and R&D Tax Credits…

This is TimeControl’s key design feature. It is an auditable timesheet that is designed to be multi-purpose.  TimeControl fulfills multiple timesheet requirements from the same timesheet at the same time.  It’s perfect for Finance, HR, Payroll, Billing, and governance as well as integrated with Primavera.

You need to enter timesheets for a whole crew at a time not just individuals

Need to enter a high volume of timesheet data for field personnel who don’t even have access to a computer? TimeControl Industrial is our field data collection version which allows you to enter Crew Timesheets, Material consumption, Equipment usage and even production accomplished and integrate that information with Primavera.

TimeControl 6 / Primavera 6 Solution Portal

We have just published a new White Paper in our free TimeControl / Primavera Resource Portal where you’ll also find webcasts, factsheets, white papers, slide presentations and other information. You will see how integrating TimeControl and Oracle-Primavera allows a single timesheet to be used for multiple purposes.  You can read the new White Paper at: Integrating TimeControl and Primavera. or, go to the Portal at: Primavera.TimeControl.com.

The TimeControl / Primavera Alliance continues as Oracle names HMS a Gold Partner for the 21st year of their partnership!

Our technical alliance relationship with Primavera started back in 1997 when TimeControl 3 was about to enter the market.  HMS and Primavera had known each other well since the mid 1980s but as competitors selling project management software.  Now we had an opportunity to collaborate together as partners instead of adversaries and the president’s of HMS and Primavera struck the deal in a short phone call.

We’ve never looked back.

TimeControl 3 was released that year with a bi-directional integration with Primavera P3 and HMS has maintained the integration with Primavera since that time.

In 2008 Oracle would purchase Primavera but for HMS that only served to draw the two firms closer.  HMS already had a partnership with Oracle to enable integration of TimeControl with Oracle Financials and to support the Oracle database.

Now Oracle and HMS have extended their relationship and the relationship has never been stronger.  There are so many technical facets to the two firms working together that we’ve had to create a portal to keep track of them all.  The TimeControl integration now works in two ways, direct from database-to-datebase or through the Oracle-Primavera Web Services link.  The link works with multiple versions of Primavera including Primavera Professional and Primavera EPPM.

There are more Oracle products of course.  TimeControl has been configured to work with many different Oracle tools including Oracle EBS, PeopleSoft, JD Edwards and, MySQL.

Some of the many TimeControl’s value-added benefits when linking with Oracle-Primavera include:

  • Support for Multiple rates per employee
  • Automated business rule validations
  • Automated workflow
  • Auditable timesheet records suitable for Finance, HR, Invoicing or Payroll
  • Missing timesheet notification
  • Simultaneous support for multiple versions of Primavera
  • The free TimeControl Mobile App for smartphones and tablets supporting both iOS and Android
  • matrix timesheet approvals with HMS’s unique Matrix Approval Process for Labor Actuals™
  • With TimeControl Industrial, the Crew Timesheet and Materials and Equipment field data collection

HMS is proud of our long standing relationship with Oracle and particularly with the Oracle-Primavera teams.  We look forward to a productive year working together as a Gold Partner.

For more information about TimeControl and how it links to Oracle technologies, visit the TimeControl Oracle Solution Portal at: http://www.timecontrol.com/use-cases/oracle-portalor contact HMS at info@hms.ca.