Skip to Content
avatar image
Former Member

In a PCR record a date of an Action and flag 3 months later.

In a PCR how would I store the start date of a specific action type for an employee and then create a flag (wage type in Time) to pass to payroll 3 months later. The date will not be stored in Date Spec's

Eg. Date of action: September 15, 2016. I then need to create a flag as of December 15, 2016

Can any one suggest how I can do this process in the Time Evaluation Schema.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 01, 2016 at 04:39 PM

    Here is a suggestion:

    In a Time Evaluation pcr, query the Action that is valid "Today".

    - If the Action is "specific", then query the existence of Time Type XXXX "Yesterday"

    - If Time Type XXXX does not exist "Yesterday", create it with HRS=1 and ADDDBXXXX

    - If Time Type XXXX existed "Yesterday", add 1 to it (HRS+1) and ADD it to the DataBase

    - If the Action is not "specific", then query the existence of Time Type XXXX "Yesterday"

    - If Time Type XXXX does not exist "Yesterday", do nothing

    - If Time Type XXXX existed "Yesterday", add 1 to it (HRS+1) and ADD it to the DataBase

    Note that you'll also need a second pcr to check on the value of XXXX, so that when it is equal or greater than a 90 or 91 days (3 months), the value of XXXX is zeroed out and WT ZZZZ is created and transfered to table ZL.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 10:23 AM

    Based on the comment above. Use function ACTIO

    http://imgur.com/a/c8cRY

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Remy,

      You are correct on all points. I actually intended Z604 to cumulate in monthly balance (SALDO) and thus always available for query in daily processing.

      I have incorporated your corrections/suggestions in my reply to Margaret below.

      Cheers Stephen

  • avatar image
    Former Member
    Nov 02, 2016 at 05:37 PM

    Thank you both for your suggestions. The use of the counter per day will not work in this instance. I need to track "3 months" to the day. A 90 Day counter does not fulfill the requirement I need. Any further thoughts of how to record the "date" and compare it to 3 months later?

    I can store that date in Date Specs on the date of the action, but I have to use that date and compare the current date in the future and capture "3 months" later, not 90 days, to create a flag for payroll.

    Any further assistance is appreciated

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2016 at 01:05 PM

    Hello Stephen;

    Using a counter for 3 months does raise some issues, eg. What about if my date is the 31st. I have an issue with months that don't have 31 days? I will use your suggestion and see if I can work it out in additional logic.

    Thank you for your suggestions.

    Add comment
    10|10000 characters needed characters exceeded