Important:

Important:

For a better view of the formula is suggested that the completion of field Description:

Operator

Description

DIAS_HAB_PROG

Working days of a payroll items date range that is in use;

DIAS_HABILES

Working days of a determined date range;

DIVIDE

Division math operation;

LABEL

It is used for the creation of a label;

EXPONENT

It elevates the creation of a determined number.

FILTRO_ACUM

Accrual Filter;

FILTRO_MOVLI

Period Transaction Filter;

GET_MONEDA

Searches the currency convector factor;

GRABA

Saves inf. in the Tables. SRA,SRK,RG4,RCP,RG1,SRD e SRF;

HASTA_IGUAL

Performs the comparison until the field value is = à;

HASTA_MAYOR

Performs the comparison until the field value is = a;

HASTA_MAYORIGUAL

Performs the comparison until the field value is >= a 2aE;

HASTA_MENOR

Performs the comparison until the field value is < a;

HASTA_MENORIGUAL

Performs the comparison until the field value is >= a 2aE;

HORAS_HABILES

Working hours of a determined date range;

IE_TOTAL_CON

Totalizes the Payroll Item Value of the employees that is calculated based on the indicated criterion;

IE_TOTAL_EMP

Totalizes the Employee Number that is in accordance with the indicated Criterion;

IMPORTE_EMPRESA

It sums in values the accrual table payroll items;

IMPORTE_TOTAL

It sums the values the accrual table payroll items;

LEE_DEP

Returns the dependants records;

LEE_TRAY

Returns the work history Records in a date range;

MONTH

Returns a determined date month;

MUEVE

Attributes a values for a determined variable;

MULTIPLICA

Multiplication math operation;

PAGA_DIA_DER

Returns the number of payable entitled days;

PRIMER_REG_DEP

Reads the first record of dependants;

PRIMER_REG_TRAY

Reads the first record of work history;

REDONDEA

Rounds up the decimal houses;

RESIDUE

Residue of a division operation;

RESTA

Subtraction math operation;

SALTA

Places the cursor of the calculation script proc, to the sequence;

SI_DIFERENTE

Checks whether two values are different;

SI_IGUAL

Compares two values;

SI_MAYOR

Compares whether the first value content is greater than s;

SI_MENOR

Compares whether the first value content is smaller than s;

SIG_DEP

Advances until the dependant next record;

SIG_TRAY

Advances until the work history next record;

STRTOVAL

Converts a string in value;

SUMA

Addition math operation;

SUMA_DIAS

Sums the incidence days of the same payroll item to the Records;

SUMA_IMPHIS

Sums the values of the calculated payroll items in the indicated process;

SUMA_IMPORTES

Sums all values of the calculated payroll item;

SUMA_MOVLI

Sums of the generated Payroll Items in the month transactions;

SUMA_UNIDADES

Sums all units of the calculated payroll item;

SUMA_UNIHIS

Sums the units of the calculated payroll items in the indicated process;

TIPO_DIA

Returns the type of date entered - S-Worked, C-Clear;

TRACE_OFF

Disable the debug process in the formulas;

TRACE_ON

Activates the debug process in the formulas;

TRUNCATE

Truncates the indicated value;

ULTIMO_REG_DEP

Reads the last record of dependants;

ULTIMO_REG_TRAY

Reads the last record of work history;

UNIDADES_EMPRESA

It sums in units the accrual table payroll items;

UNIDADES_TOTAL

It sums the units the accrual table payroll items;

VALTOSTR

Converts the value in string.

F, N

SUM

N

F, N

Operator SUM has to ways to operate. Sum of numbers and dates. For the second case, the days can be summed up to a date, resulting a date.

F, N

RESTA

F, N

N

Operator SUBTRACTION manipulates the decrease of numbers and dates. For the second case, the dates subtraction is in the number of days between the two dates.

N

MULTIPLICA

N

N

Operator MULTIPLY can only be used with numbers.

N

DIVIDE

N

N

Operator DIVISION can only be used with numbers. If there is a division with 0, in the calculation log, there will be a mistake.

{decimals}

TRUNCATE

N

N

Operator TRUNCATE has to ways to operate. If the decimals are not placed in the OPERAND1, the decimals truncate. If the decimals are placed in the OPERAND1, the number of decimals indicated are truncated.

Example:

N

RESIDUE

N

N

Operator RESIDUE performs the full division and reports the residue of this division.

Example:

Normal Division: 5/2 = 2.5        Full Division: 5/2 = 2 RESIDUE 1.

{decimals}

ROUNDING

N

N

Operator ROUNDING, when the decimals are not placed, it rounds two decimals up, according to the currency procedure (to hundredth, 1 and 2 decrease to 0; 3 and 4 increase to 5; 6 and 7 decrease to 5; 8 and 9 increase to 0). If the decimals are placed in OPERAND1, it arithmetically rounds up (if it is smaller than 5, it decreases; if it is higher than 5, it increases).

Example:

N

EXPONENT

N

N

Operator EXPONENT elevates the number to the indicated power .

LABEL

LABEL

This operator only indicates the row in which the brand or label used by the operators is SI_MAYOR, SI_MENOR, SI_DIFERENTE, SI_IGUAL e SALTA.

N, F, C, L

SI_IGUAL

N, F, C, L

LABEL

N, F

SI_MAYOR

N, F

LABEL

N, F

SI_MENOR

N, F

LABEL

N, F, C, L

SI_DIFERENTE

N, F, C, L

LABEL

These four operators are used to compare two values. If the result is positive, so it skips to the formula row in which the label indicated in the Result is. It can skip above or below.

Generally, when conditionals (IF or SI for Excel, for example), the following actions are placed after the condition. In GPE MODELO II, place the actions, in positive case and the the condition. Below the condition, the contrary actions.

For example: If the employee has the seniority date, take this information into account in order to determine the seniority. Otherwise, check whether there is a readmission date and take this date to determine the seniority; otherwise, take the hiring date.

SALTA

Label

This operator is an unconditional skip. That is, it automatically pass to the formula row in which the label indicated in Results is.

For instance, if the increase type is equal to 1 and the daily salary is smaller than the minimum and different than zero, the minimum salary must be moved for daily salary. If the type of raise is equal to 2, so the daily salary must be multiplied by the general %.

C

STRTOVAL

N

N

Converts the data indicated in the operand 1 character type in numeric. Character type data, or string, can be a file type mnemonic, reserved or a constant. To identify the decimals, use dot (12.5). If there is comma character (,), as decimal separator, this is not considered.  In operand 2, the number of decimals to return is indicated. If n number is indicated in this field, a full number is returned.

N

VALTOSTR

N

C

Converts data indicated in operand 1 numeric type (file type, reserved or constant) in a character or string. The dot is used (.) as a separator in the decimals. In operand 2, the size of the character that is returned must be indicated, considering the decimal dot in a characters account.  For example: 12.45 is size 5. If it is not indicated, or the indicated size is smaller, the exact value converted in string is returned. If the sizer is bigger, it is filled out by using zeros on the left.

F

GET_MONEDA

Número Moneda

N

It returns the rate value corresponding to determined date and requested currency. In the Financials, the currencies are identified with numbers that are defined to each customer. For example: 1 for local currency, 2 for dollars.

Example 1: If March 1st, 2012 has parity of 39.12, Pesos from Dominican Republic x Dollars, and this currency 3. And the employee salary is 1000 USD. To obtain salary in Pesos.

Example 2:

If a bonus of 500 USD is granted to the employee, calculated with end date of the Period, you get the bonus in Pesos.

YEAR

F

N

Returns a determined date year:

MONTH

F

N

Returns a determined date month:

DIA

F

N

Returns a determined date day:

DIA_SEMANA

F

N

Returns the week day a determined date considering 1=Sunday and 7=Saturday

MUEVE

N, F, C, L

N, F, C, L

Operator MUEVE allocates the content of the data in mnemonic where the result is found.

CONVIERTE_FECHA

Date {YYYYMMDD}

F

It is used to arrange dates. For example, to obtain birth date, take the mnemonic year of the start date of the period and the month and day of the hiring date. To obtain the date in format yyyymmdd, multiply year by 10000 + month * 100 + day. To apply the CONVIERTE_FECHA, there will be a date type mnemonic that can be kept, compared, summed or subtracted as date.

Example: Pay 12 days of vacation premium for all the employees, if birth date is between start and end date of the period. If Period is 01/01/2009 to 01/15/2009 and the hiring date is 01/05/2004

Start day

SUMA_DIAS

End day

N

There are three ways to capture the incidences: Incidences per Employee, Incidences per Payroll Item and Extra Time. This last way, generally, occupies the extra time, that is the reason of its denomination, and it enables capturing the incidences day by day, considering a record per week.

Data are captured from day 1 to 7, that corresponds to the week days, day 1 is the first day of the week for the company. Irrespective of the capture per each day in the time field, the total captured is accrued in the 7 days.

With this operator, the incidences of each day or a range of days are read. It is occupied not to perform the calculation of each day, repeating the same seven times. Therefore, a cycle together with the operator SI_MENOR can be used.

For example: Determine the double or triple extra times that can be integrated, saved or exempt, considering until 3 hours x integrated days and until 3 days per week. Until 9 double and the remained ones tripled. Exemption of 50% until 5 SMG per week, the remaining ones saved. For this, each week is captured in one incidence record per day.

<Value to Filter>

<BLANK>

FILTRO_MOVLI

<Field SRV>

<budget list>

<BLANK>

Operator FILTRO_MOVLI aims at performing a pre filter by using, as reference, the payroll items catalog fields. It will work together with the operator SUMA_MOVLI, where the table Payroll Transactions (SRC) is filter per payroll items (RC_PD).

Use of operator FILTRO_MOVLI with SUMA_MOVLI only works if there are payroll values previously calculated in the Payroll Transactions (SRC). Several FILTRO_MOVLI can be added and they will connect to an AND.

If the SUMA_MOVLI does not have data in the first or second expression, it means filter indicated in FILTRO_MOVLI must be considered.

Example 01: only with a filter in FILTRO_MOVLI

Example 02: only with a filter in SUMA_MOVLI

Example 03: only with a filter in SUMA_MOVLI and taking value “1” or “S” as standard

Example 04: only a filter in FILTRO_MOVLI and searching several values

Example 05: search different values of the same field.

Content

SUMA_MOVLI

SRV Mnemonic or

BASE_PENSIÓN or

Payroll Items List

N

Allows, via formula, the calculation (addition/subtraction) of budget values already calculated on Monthly Movements (SRC), according to the list of budgets selected. It also allows the calculation for beneficiaries according to definition of the BASE_PENSION operator.

By default, values (RC_VALOR) will be obtained from the entered budget list; however, if you need to obtain the total of H=Hours or D=Days, you must indicate the reserved mnemonic TP_SUMA_MOVLI.

The position for the table of beneficiaries must be carried out with operator SUMA_MOVLI and reserved Mnemonic BASE_PENSION, identified in the second expression of formula used.

It is also possible to use the SUMA_MOVLI operator with a Mnemonic that identifies an incidence field from table SRV, for instance, RV_PENSAO. Therefore, all payroll items with the value of this field equal to Yes, to affect:

Another possibility is to directly use values in the formula's expression. They must be registered payment codes in table SRV, in the Code field (RV_COD).

Example:

Sums the payroll items values calculated to this moment, according to the selected payroll items list. Follows the payroll item type, that is, if it is Collections or Collection Base, it will be summed up; if it is Deduction or Deduction Base, it will be subtracted.

Example 1: Mnemonic CONISR is associated to the table SRV=Payroll Items and the field RV_IR=ISR

“2”        SUMA_MOVLI        CONISR        NAUX_01

Example 2: Mnemonic CONSDO is associated to the table SRV=Payroll Items and the field RV_INCORP

In case you want to obtain the incorporated days to the salary, to determine the days to be paid.

ie_total_con

<criterion>

N

IE_TOTAL_EMP

<criterion>

N

These operators are used together with an alphanumeric table called Criterion, that has a key and a description. A criterion is attributed to each employee.

IE_TOTAL_CON retrieves the sum of values of the month that is processed (RCH_MES, RCH_ANO), the payroll item that is calculated and all employees that follow the indicated <criterion> .

IE_TOTAL_EMP retrieves the Total of Employees that, in the month that is processed (RCH_MES, RCH_ANO), had value in the payroll item that is calculated, and meet the indicated <criterion> .

Example: Sum the monthly state basis of the month, of all employees with criterion 004. From this base, 8 minimum salaries are subtracted, considering factor 30.5. From this result, divide between the original basis to obtain a factor. The State Tax is obtained by summing up the month state tax base of the employee and by multiplying by the factor (State Tax Calculation Script of Querétar, Mexico).

BUSCA_ANO_EMPRES

YEAR

The accrual history in Model 2 has start and end year, that is the reason why you must indicate the accrual year searched, when the operators IMPORTE_EMPRESA and UNIDADES_EMPRESA are occupied.

If it is indicated with operator BUSCA_ANO_EMPRES, both start and end year must be attributed to this operator. If this operator is not occupied, the current year accrual will return, both start and end year.

If the years are different, when an accrual starts in a different month than January, you must indicate it in the reserved mnemonic ANO_INI_ACU and ANO_FIM_ACU.

BUSCA_PROCESO

Process

When the SUMA_UNIDADES or SUMA_IMPORTES are used as standard, it is searched in the process the employee is allocated. If the extraction of other processes accrual is required, with BUSCA_PROCESO, the process accrual employee and indicated payroll item are loaded, as the scope of this operator is for the formula that is being evaluated. The process is a character field.

C

<VACIO>

FILTRO_ACUM

<campo SRV>

<lista conceptos>

<VACIO>

Operator FILTRO_ACUM aims at performing a pre-filter of Accruals (RG7), using as parameter the payroll item field (RG7_PD), and will send this filter to the next operator of Accruals.

An important thing is that the operators: SUMA_UNIDADES, SUMA_IMPORTES, UNIDADESA_EMPRESA, IMPORTE_EMPRESA, UNIDADES_TOTAL, IMPORTE_TOTAL can work without the need to use the payroll filter.

In Payroll Items Catalog per Process (SRM) must be associated to payroll item (RM_VERBA) with a formula (RM_CODFOR); however, if the operator FILTRO_ACUM is used, the payroll item (RM_VERBA) is not taken into account, as the operator FILTRO_ACUM, performs the pre filter of the payroll items indicated in itself.

If the condition of the filter used in FILTRO_ACUM does not exist, the operator return is Zero (0).

If you need to clean the content of FILTRO_ACUM, use 1st and 2nd expression of the formula without data (empty).

The FILTRO_ACUM can be used several times in a formula, and each one is added to the previous one, giving it AND treatment (as long as a filter without the 1st and 2nd expression is not added, as it cleans all filters). In each new formula, the FILTRO_ACUM is clean.

<tipo>

BUSCA_SUCURSAL

Sucursales

When you use UNIDADES_EMPRESA or IMPORTE_EMPRESA as standard, the accrual of the branch in which the employee is allocated is read. If the extraction of other branches accrual is required, with BUSCA_SUCUSAL, the accrual of the branches and the payroll item indicted are loaded. The scope of this operator is for ALL the formulas of the payroll items per process from the formula it occupies, as it is recommendable to add in the first defined formula. To indicate the branches, capture them separately using comma (,) and this branch must be in the sigamat.

Leave this first expression blank to clear the branches filter.

Considering the following configuration of Company Management and the employee belonging to branch=D MG 01.

Example 1: Formula to get companyD accruals:

Example 2: Formula to get company D and M accruals.

Example 3: Formula to get the accruals of the company D and Business Unit MG:

Start month

SUMA_IMPORTES

month end

N

Start month

SUMA_UNIDADES

month end

N

These two operators (SUMA_UNIDADES and SUMA_IMPORTES) read the accruals of the employee from the start month until the end month of the process in the employee master or the one indicated in BUSCA_PROCESO. The months are character type size 2. To indicate the start and end year, you must allocate it in mnemonics ANO_INI_ACU and ANO_FIN_ACU or, if the year is the same for both, operator BUSCA_ANO_EMPRES can be occupied.

Start month

UNIDADES_EMPRESA

Month end

N

Start month

IMPORTE_EMPRESA

Month end

N

These two operators (UNIDADES_EMPRESA and IMPORTES_EMPRESA) read the accruals of the employee from start to end month of all processes belonging to the company in which the process that is being run is allocated. The months are character type size 2. To indicated the start and end year, you must allocate it in the mnemonics ANO_INI_ACU and ANO_FIN_ACU or, if the year is the same for both, operator BUSCA_ANO_EMPRES can be occupied.

This operator considers whether the customer is occupying the Company Management. From version 11, branch field (FILIAL) is divided in 3 parts: Company, Business Unit and Branch. The customer can occupy these three fields, two of just one field. A possible definition is that the Company is one Company and the business unit and branches are logical divisions. Other definition is that the Company is occupied as Company Group and the Business Units as the companies and branches, a logical division. Finally, the branches can be occupied as companies.

Start month

UNIDADES_TOTAL

Month end

N

Start month

IMPORTE_TOTAL

Month end

N

These two operators (UNIDADES_EMPRESA and IMPORTES_EMPRESA) read the accruals of the employee from start to end month of all processes belonging to the company in which the process that is being run is allocated. The months are character type size 2. To indicate start and end date, you must allocate them in the mnemonics ANO_INI_ACU e ANO_FIN_ACU.

Example: a customer has three processes: 01 Employ, 02 Unionized and 03 Fees. Processes 01 and 02 belong to branches 01, 02; 03 to branch 04. In some cases, when moved from the personnel to payroll, the payroll items of the payroll that have not been performed in their corresponding processes are paid or discounted. Therefore, in the annual statement of revenue and salaries, the accruals of the four branches must be consider for all employees. The formula the accruals of the recordable payroll items read can be as follows:

Initial Period

SUMA_IMPHIS

Final Period

N

Initial Period

SUMA_UNIHIS

Final Period

N

These two operators (SUMA_IMPHIS and SUMA_UNIHIS) read the transaction history that are between the periods - initial and final- indicated to this employee and payroll item of a determined type of payroll (or calculation script).

Obtaining the monthly average commission, only regarding the paid commissions in the payroll. You must sum the N previous periods values, indicated in Periods.  It implies the reading of previous year Periods and current year Periods to which is indicated in the Period and the Period and initial payment to the added are paid as advance payment.

SEARCH

TABLA_XXXX

This operator searches the numeric table indicated in the operand 2. OBSERVATION: it is not placed in any record. Operand 2 must be comprised by the word TABLA_ plus the type (U if is user, S, if it is System) and the 4-digit table key.

ELEMENTO_01 to ELEMENTO_99

HASTA_IGUAL

N, C, F

ELEMENTO_01 to ELEMENTO_99

HASTA_MAYOR

N

ELEMENTO_01 to ELEMENTO_99

HASTA_MENOR

N

ELEMENTO_01 to ELEMENTO_99

HASTA_MAYORIGUAL

N

ELEMENTO_01 to ELEMENTO_99

HASTA_MENORIGUAL

N

Searches the table (previously called with operator SEARCH) until the indicated element in operand 1 is equal to, greater than, equal to or greater then, smaller than, equal to or smaller than the mnemonic indicated in operand 1. If it is not found, the record returns with zeros. If it is not found, it returns the record with zeros. To use the operators HASTA_MENOR and HASTA_MENORIGUAL the table must be captured in a descending manner. That is, higher values come in the first records and lower in the last.

the records must be captured in order, as, in the alphanumeric tables, different types of tables can be defined with different data types and sizes, you cannot organize an index.

For example: Get the tax according to article 113 of LISR.

SAVE

table

During payroll calculation, this operator purpose is to save the values in the following tables In order to perform it, process the payroll item, check whether it is correct and then, process the payroll again with option Save enabled. Only new values before the operand Save must be moved to the mnemonic associated to the corresponding field tables.

Tables that are edited and added during calculation are:

Start Date

LEE_TRAY

End date

{transaction type}

In the 4.1 version of the calculation, the functionality that enables you to read the work history transactions has been implemented.

For example: The transactions from March, 15th to April 30th of an employee that has the following transactions are read:

For the first transaction, 10 days are returned in the DIAS_TRAY_SIG that refers to the days from March, 15th (start date of the desired range) until March, 24th (the previous day to the following transaction).

For the second transaction, 7 days are returned in the DIAS_TRAY_SIG that refers to the days from March, 15th until March, 31st (the previous day to the following transaction).

For the third transaction, 30 days are returned in the DIAS_TRAY_SIG that refers to the days from April, 1st until March, 31st (end date of the desired range).

SIG_TRAY

{GEN_MOV}

With this operator, the following record from the ones selected by the operator LEE_TRAY is read.

PRIMER_REG_TRAY

With this operator, the first record of work history loads the memory in the selected range.

ULTIMO_REG_TRAY

With this operator, the last record of work history loads the memory in the selected range.

Example: In a company, the negotiation of the following collective agreement generally delays (over a month). As, during this negotiation period, position changes have been performed, and the employee master has the current and previous salary, the retroactive payment must be performed after the reading of the work history records.

It is necessary to perform the retroactive raise from January 1st, 2003 to August 15th, 2003, keeping the corresponding salaries to each position separately.

LEE_DEP

{Type Dep}

With this operator, the records of the employee dependents of the indicated type are brought, from a transaction before the start date to the end date indicated.

For example: The transactions from March, 15th to April 30th of an employee that has the following transactions are read:

For the first transaction, 10 days are returned in the DIAS_TRAY_SIG that refers to the days from March, 15th (start date of the desired range) until March, 24th (the previous day to the following transaction).

For the second transaction, 7 days are returned in the DIAS_TRAY_SIG that refers to the days from March, 15th until March, 31st (the previous day to the following transaction).

For the third transaction, 30 days are returned in the DIAS_TRAY_SIG that refers to the days from April, 1st until March, 31st (end date of the desired range).

SIG_DEP

With this operator, the following record from the ones selected by the operator LEE_DEP is to be read.

PRIMER_REG_DEP

With this operator, the first record of dependants loads the memory in the selected range.

ULTIMO_REG_DEP

With this operator, the first record of dependants loads the memory in the selected range.

Example: It is needed to determine whether there is a dependant that is spouse (C) to grant the correspondent IST credit.