CalculationofScheduleDate

PM Scheduling and Completion

Minor Business Rule

Object Name: N1300090

Parent DLL: CMFG

Location: Client/Server

Language: NER

Functional Description

Purpose

This function will be used to calculate the number of days for the next scheduled Preventive Maintenance.

Setup Notes and Prerequisites

Special Logic

Technical Specification

If Service Days not equal to blank add the number of days to DateScheduledTickler.

If Frequency Indicator is equal to 1 add one month to DateScheduledTickler and return value through DatePlannedToStart.

If Frequency Indicator is equal to 2 add one month to DateScheduledTickler and then use the last_day function to calculate the last day of the month and
return value through DatePlannedToStart.

If Frequency Indicator is equal to 3 add three months to DateScheduledTickler and return value through DatePlannedToStart.

If Frequency Indicator is equal to 4 add twelve months to DateScheduledTickler and return value through DatePlannedToStart.

Data Structure

D1300090 - PM Scheduling & Completion

Parameter Name Data Item Data Type Req/Opt I/O/Both

cFrequencyIndicator FRIN char NONE NONE

When used in conjunction with Schedule Date, this field indicates the frequency at which the system schedules maintenance. When
maintenance is completed, the system automatically schedules the next maintenance according to the value that you enter in this field. Valid values
are: blank No frequency indicator 1 Same date each month 2 Last date each month 3 Same date each quarter 4 Same
date each year 5 Same day each week 6 Semi-annually (same date at six month intervals)

jdDateScheduledTickler TDT JDEDATE NONE NONE

The date that you want to receive a reminder message about an asset.

jdDatePlannedToStart PNST JDEDATE NONE NONE

The date when the item or line of work is to start.

jdCompletedDate CPLD JDEDATE NONE NONE

This is the actual date that the maintenance was completed.

mnServiceDays SRVD MATH_NUMERIC NONE NONE

The number of days to elapse before you schedule maintenance.

jdLastCompletedDate LCPD JDEDATE NONE NONE

Date of last maintenance.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cFrequencyIndicator	FRIN	char	NONE	NONE
When used in conjunction with Schedule Date, this field indicates the frequency at which the system schedules maintenance. When maintenance is completed, the system automatically schedules the next maintenance according to the value that you enter in this field. Valid values are: blank No frequency indicator 1 Same date each month 2 Last date each month 3 Same date each quarter 4 Same date each year 5 Same day each week 6 Semi-annually (same date at six month intervals)
jdDateScheduledTickler	TDT	JDEDATE	NONE	NONE
The date that you want to receive a reminder message about an asset.
jdDatePlannedToStart	PNST	JDEDATE	NONE	NONE
The date when the item or line of work is to start.
jdCompletedDate	CPLD	JDEDATE	NONE	NONE
This is the actual date that the maintenance was completed.
mnServiceDays	SRVD	MATH_NUMERIC	NONE	NONE
The number of days to elapse before you schedule maintenance.
jdLastCompletedDate	LCPD	JDEDATE	NONE	NONE
Date of last maintenance.