The D2 and the Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre use Oracle FastFormula to define formulas that control some of the data that is retrieved. If the supplied formulas do not meet the requirements of you enterprise you must create new formulas in the Formula window.
See: Oracle FastFormula User's Guide
The TEMPLATE_MMO_REASON formula is used by the Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre to retrieve the START_REASON and END_REASON. This formula assumes that when a person is hired or terminated the start and end reasons will be entered in the PERIOD_OF_SERVICE table, whilst changes in establishment due to transfers, or suspended assignments becoming active will have start and end reasons entered in the ASSIGNMENT table. If your enterprise records starting and leaving reasons differently then you must copy and amend the formula. The new formula must be given the name USER_MMO_REASON.
The TEMPLATE_CONTRACT_PRORATED formula is used to calculate the various headcounts required by the D2 report. For each given block (the link between assignment and contract) the formula determines what fraction of a one year full-time employment it represents.
The formula will return different values depending on the inputs. For example, if CONTRACT_TYPE is apprenticeship, the value returned will be 0. If EMPLOYMENT_CATEGORY is full-time and CONTRACT_CATEGORY is permanent, the value returned will be 1. All other cases require a more complicated calculation which is performed by the formula, prorating part-time assignments etc.
The result is then added to RUNNING_TOTAL and returned as NEW_TOTAL. The inputs and database items used by this formula are detailed in the formula itself. If your enterprise requires the headcount to be calculated in a different way, you must copy and amend the formula. The new formula must be given the name USER_CONTRACT_PRORATED.