During implementation, a number of user defined tables are set up that are used by particular reports. The following table lists the user defined tables and describes how they are used.
Note: For descriptions of user defined tables used by the Bilan Social Report process, see: User Defined Tables Used by the Bilan Social
| Field | Lookup | Description |
|---|---|---|
| EMP_CAT | FR_D2_CATEGORY | This is used to define the employment categories as full-time, part-time, or unknown, and is used in the D2 report. This table, column and values will be delivered as part of a post-install step. |
| FR_D2_RATES | VALUE | This is a legislative table defined for all FR business groups. It contains legally defined rates used in the D2 report. This table, column and values are delivered and may not be amended. |
| FR_ENDING_REASON | MMO_ENDING_CATEGORY | This is used to map the values in the FR_ENDING_REASON Lookup onto the codes required by the Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre. This table, column and values will be delivered as part of a post-install step. |
| FR_LEGISLATIVE_RATES | VALUE | This is a legislative table defined for all FR business groups. It contains legally defined rates used in the D2 report. This table, column and values are delivered and may not be amended. |
| FR_PCS_CODE | FR_D2_PARTICULAR | This is used to define the jobs that should be excluded when calculating the headcount for the D2 report. This table, column and values will be delivered as part of a post-install step. |
| FR_STARTING_REASON | MMO_STARTING_CATEGORY | This is used to map the values in the FR_STARTING_REASON Lookup onto the codes required by the Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre. This table, column and values will be delivered as part of a post-install step. |
| FR_USER_PERSON_TYPE | INCLUDE_DUE | This is used to determine which person types should be included in the headcount for the. Declaration Unique d'Embauche. The person types that should be included in the count must contain a Y in the INCLUDE_DUE column. This table and column will be delivered as part of a post-install step, however, the column values must be entered manually. |
| FR_USER_PERSON_TYPE | INCLUDE_D2 | This is used to determine which person types should be included in the D2 processing. The person types that should be included in the processing must contain a Y in the INCLUDE_D2 column. This table and column will be delivered as part of a post-install step, however, the column values must be entered manually. |
| FR_USER_PERSON_TYPE | INCLUDE_MMO_HEADCOUNT | This is used to determine which person types should be included in the headcount for the. Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre. The person types that should be included in the count must contain a Y in the INCLUDE_MMO_HEADCOUNT column. This table and column will be delivered as part of a post-install step, however, the column values must be entered manually. |
| FR_USER_PERSON_TYPE | INCLUDE_MMO_TEMPORARY | This is used to determine which person types should be included in the headcount of temporary employees for the. Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre. The person types that should be included in the count must contain a Y in the INCLUDE_MMO_TEMPORARY column. This table and column will be delivered as part of a post-install step, however, the column values must be entered manually. |
| NATIONALITY | DUE_NATIONALITY | This is used to map the values in the NATIONALITY Lookup onto the codes required by the Declaration Unique d'Embauche. All nationalities that are considered to be French by this report should have a value of FR. All nationalities that are considered to be from the European Union by this report should have a value of EU. All nationalities that do not have a value entered are considered to be from the Another Nationality by this report. This table and column will be delivered as part of a post-install step, however, the column values must be entered manually. |
| NATIONALITY | MMO_NATIONALITY | This is used to map the values in the NATIONALITY Lookup onto the codes required by the Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre. These are: All nationalities that are considered to be French by this report should have a value of FR. All nationalities that are considered to be from the European Union by this report should have a value of EU. All nationalities that do not have a value entered are considered to be from the Another Nationality by this report. This table and column will be delivered as part of a post-install step, however, the column values must be entered manually. |