beCPG administration console
The beCPG administration console is available through the menu « beCPG » on the upper headband:
This console provides access to system characteristics and system folders.
System characteristics
Characteristics
Lists of value
Product hierarchy (family, subfamily)
Project lists
Quality lists
Security lists
Characteristics
The following lists of characteristics are available in the administration:
- Ingredients
- Allergens
- Claims
- Cost
- Nutrients
- Organoleptic characteristics
- Physico-chemical characteristics
- Storage conditions
- Precautions for use
- Geographical origins
- Organic origins
- Trademarks
- Subsidiaries
- Target markets
- Taxes
- Customs codes
- Certifications
- Plants
- Process steps
- Resource parameters
- Notifications
- Labeling templates
- Mentions
- Publication channels
Creation {#adminCreation}
For example, the addition of an allergen will enable users to declare this allergen in a product's allergen list. The same applies to all other characteristics.
Deletion
To delete a value, you must select “yes” in the "deleted” column. This value will no longer be selected in the drop-down list for the field concerned. However, it will still appear on entities using this value. This feature avoids constraint errors linked to the permanent deletion of a value.
Propagate
The "Propagate" function allows you to automatically add one or more characteristics (physicochemical, claims or nutrients) present in a raw material to all cases of use of the latter whatever it may be: semi-finished, finished product or a generic raw material.
This makes it possible to add a characteristic formulated or not exceptionally to a formula if it is present in one of the raw materials which compose it.
The models allow lists to be filled in advance based on “standard” and systematic characteristics. Propagation allows you to handle the exception.
Ex: development of a prototype rich in calcium
Characteristic configuration
The characteristics concerned are as follows:
- nutrients
- claims
physicochemicals
Administration
Click “Add” or “Modify” the characteristic(s)
- Click “Propagate”
- Complete and save the characteristic
Product Reference
- Add the desired characteristic(s) to the raw material(s) concerned.
- Complete the values
- Formulate the use cases.
Ingredient characteristics
beCPG offers a non-exhaustive list of ingredients for the food and cosmetics sectors, which you can customize by adding your own ingredients, either by import or manually. The “Name” corresponds to the appellation used in the search to associate the ingredient with its category, while the “Legal name” designates the name appearing on the label. This distinction allows you to add further details to the name, making it easier for users to enter ingredients within entities. *example: Soy lecithin (E322 - emulsifier).
This list also includes several other parameters:
- Plural legal name: Name displayed on the label if the ingredient is present more than once. example: Flavor > Flavors.
- No. E: Regulatory code (example: E322).
- CAS: Number assigned to a chemical substance by the U.S. Chemical Abstracts Service (CAS).
- EINECS: EC number identifying a chemical substance listed in the European Inventory of Existing Chemical Substances (EINECS).
- EC No: EC nomenclature, numerical classification of enzymes according to the chemical reaction they catalyze.
- FDA Cat: FDA code for US regulations.
- FEMA No.: Unique identification number for flavorings, assigned by the Flavorings and Extracts Manufacturers Association.
- No. FL: Code related to aromas and flavors.
- Parent entity :For compound ingredients (e.g. custard cream), it is possible to copy the ingredients of a raw material.
- Linked search:: Used to link ingredients so that they appear together in searches.
- Regulatory code: Used for specific interfaces (example: Interface with Decernis.).
- Regulatory category: Associates a type with the ingredient, for additives (e.g. antioxidant) or groupings (e.g. spices).
- Compliance comment: Information on ingredient compliance.
- Evaporation rate: Amount of water present in the ingredient.
- Allergens: Binds an allergen directly to the ingredient. If this ingredient is added to an entity, the allergen is automatically added in voluntary presence.
- Rate of allergens provided %: Quantity of allergens present in the ingredient, to be indicated in the form: CODE_ALLERGEN1|qté1, CODE_ALLERGEN2|qté2, or simply qté (indicating the same quantity for all allergens). example: If the ingredient contains 80% F1 allergen and 77.9% FX1 allergen, it should be formatted as follows: F1|80, FX1|77.9.
- Type of activity: Selects the geographical origin expected in this ingredient. If required, this field can be displayed in the product's ingredient list to help users complete this field.
- SVHC: Indication of hazardous substances (example: endocrine disruptor).
- SVHC type: Type of substance of very high concern.
For cosmetic and fragrance applications, the following toxicological data:
- POD systemic (mg/kg/d)
- Dermal absorption (%)
- MoS/MoE
- Max skin irritation rinse-off (%)
- Max skin irritation leave-on (%)
- Max sensitization (%)
- Max ocular irritation (%)
- Max phototoxic (%)
- Toxicologic data
Allergen characteristics
A list of allergens pre-established with GS1 and INCO already exists in the system by default.
Create an allergen If you need to add new allergens, click on "Add". A form appears, allowing you to enter :
The name of the allergen to be selected
The legal name of the allergen (this is the name that will appear in brackets on the label)
Type: major or minor
Major allergens must be declared on the ingredient list. Minor allergens have two functions:
- To manage child allergens of major allergens e.g. hazelnut is a nut allergen for children. Hazelnut will be recognized as an allergen and the name will be declared.
To manage allergens that are not required to be declared ex: rice
Allergens subset {#characteristics-allergensSubset}
These are minor allergens on which translations are stored so that they can be recognized in beCPG as allergens. ex : Allergen "nuts" has minor allergens "almonds", "hazelnuts", "walnuts" etc. If child allergens are present, here is the labeling :almonds, ... If child allergens are not present, here is the labeling : ...,almonds (nuts),...
- Regulatory threshold (%)
Some of allergens are considered present only above a certain quantity. This is the case for sulfite in European regulations.
- May Contain threshold (%)
In order to carry out analyses on the presence or absence of adventitious contamination of an allergen in your product according to VITAL®, it is also possible to define a threshold for which the allergen is not considered to be present as adventitious contamination.
- Report languages Language for which the allergen is considered. e.g.: In Japan, tomatoes are a major allergen.
Note: the allergen must be indicated as major; it will be considered minor for languages not indicated.
Characteristics Claims
Create a claim
- Click on add item
- Complete your claim: Code, Name, legal wording, description, languages, formula...
- Save
Modify an existing claim
- Select the claim to be modified
To modify an existing claim, select the claim you wish to modify from the list or use the filter search (enter the keyword in the first field then click on filter. To cancel the filter, click on delete).
- Click on the pencil icon at the end of the line.
- Modify your claim
- Save
Notifications
Notifications can be sent to users by e-mail on a scheduled frequency for special events (document updates, FP, RM or SFP updates...)
You can add a notification in the “Notifications” section of the “Characteristics:
Notifications:
- Groups/persons to notify.
- Changes Types:
- X days before date: MIN to (Now-X)
- X days after date: (Now+X) to MAX
- From X days: (Now-X) to Now
- In less than X days: Now to (Now+X)
- X days to date: date field equals to (NOW+X).
ex : Today's date = 1/1/2023 & X = 10 d & Date = bcpg:certifcatDate X days before date: All certificates prior to 12/21/2022. X days after the date: All certificates after 1/10/2023. Since X days: Date between 12/21/2022 and 1/1/2023. In less than X days: Date between 1/1/2023 and 1/10/2023. X days to date: Certificate to this date 1/10/2023.
- Related date field: For example, cm:modified for any modification in a document.
- Script : By adding a script, it is possible to make modifications or perform calculations on the entities found by the search.
</br>
e.g.: archive products that have passed their sell-by date.
Filters
- Of Type: Entity type, like Raw Material, Finished Product,...
- Folder: allow you to look to apply your notification only in a certain folder or site.
- Only changed version: choose if it's only notification about minor or major modifications.
- Advanced filter : you can add an advanced filter, in JSON format. For example, if you want to be notified for semiFinished product that have a certain plant, you should use:
{
"query": "@cm\\:name:\"Fiche*\"",
"entityFilter": {
"entityType": "bcpg:semiFinishedProduct",
"criteria": {
"assoc_bcpg_plants_added": "nodeRef"
}
}
}
or
{
"query": "@cm\\:name:\"Fiche*\"",
"entityFilter": {
"entityType": "bcpg:semiFinishedProduct",
"criteria": {
"assoc_bcpg_plants_added": "nodeRef"
}
},
"nodeFilter": {
"criteria": {
"assoc_bcpg_clients_added": "nodeRef"
}
}
}
or
{ "query":
"+@{http://www.bcpg.fr/model/becpg/1.0}productState:\"Valid\" OR
+@{http://www.bcpg.fr/model/becpg/1.0}productState:\"Simulation\" OR
+@{http://www.bcpg.fr/model/becpg/1.0}productState:\"ToValidate\""
}
E-mail:
- Subject: object of the notification e-mail
- E-mail template: you can choose any built templates.
Recurring:
- Repetition and type. Choose how often you want to send the notification in days/weeks/months/years.
- Repeat in: choose to repeat a certain day (only useful for a week type notification)
- Start date: choose when the notification rules will be active.
Surveys
Since the 3.2.3 version, it's possible to set up surveys and use them in project wizards (for example for the supplier portal referencing project).
To configure surveys, go to the administration characteristics, and choose the Survey questions list:
Here, you can find several fields to complete:
- Label: name of the question / answer
- Parent: used to link answers to questions. A label without any children will be considered as a message the system needs to display.
- Next question: name of the question to open based on the answer
Response type: there a 4 types of answers:
- By default (empty) : single choice checkbox. To use for next question usage.
- List : single choice list.
- multiChoiceList : mulitple choices lists.
- checkboxes : multiple choices checkbox.
Comment type : use to add or not a comment to the question. There are 4 comment types:
- none : no comment
- text : add a free text comment field. To use for short comment.
- textarea : add a free text area comment field.to use for long comment.
- file
Comment label: gives a title to the comment section.
- Score: gives a score to questions.
- Mandatory: to use if you want a question to be mandatory or not. A mandatory question should be completed to validate the survey.
- Visible : display by default the question, without any dependencies with next question field. To use for first questions to display or questions that should always be displayed.
Surveys should be added in the concerned entity, and should be added in the entity template to be added by default in all entities using a template:
Depending on this configuration, we can have the following display:
Answers are sorted in the survey list of the entity under referencing.
Products hierarchy
The product hierarchy is configured per type of product :
Add a family : In order to add a family to raw materials, it’s necessary to fill the « Hierarchy of raw materials » list.
Value : grocery
Add a subfamily : In order to add a subfamily to raw materials, it’s necessary to fill the « Hierarchy of raw materials » list.
Value : pasta, rice, semolina Parent : grocery This allows to link the family to the sub family.
Projects list
In the projects lists, there are :
- The steps’ legends (which associate colours to steps) ;
- Projects hierarchy (projects’ families and subfamilies) ;
- Requests status ;
- Requests origins (ex : the service which made the request) ;
- Sponsors (persons or sponsor service of the project) ;
- Evaluation criteria (criteria to evaluate the project, for example, market or feasibility).
List of value
Packaging material
This list is initialized with CITEO values when the system is created:
- Steel
- Aluminum
- Paper-cardboard other than bricks
- Bricks
- Glass
- Plastic - Bottle and vial in clear PET
- Plastic - Bottle and vial in coloured PET, in PE or PP
- Plastic - Rigid packaging in PE, PP or PET
- Plastic - Flexible PE packaging
- Plastic - PS rigid packaging
- Plastic - Complex packaging or other resins excluding PVC
- Plastic - Packaging containing PVC
- Other materials - Unprocessed materials from renewable resources and sustainably managed with recycling channel or organic recovery in development (wood, cork).
- Other materials - Without recycling channel and energy recoverable (textile, other materials...)
- Other materials - Without recycling channel and non recoverable (stoneware, porce-lain, ceramics)
If the list has not been initialized, you can ask beCPG to import the file "07 - pmLists.csv".
This list can be customized. Please note: added values will not be recognized by the CITEO report.
Ingredient Type
This list is initialized with the additive types defined by regulations (European, American, etc.). It can be customized to create other grouping categories (e.g. flavorings, vegetables, mushrooms), in a similar way to other lists. The “Value” corresponds to the name used in the search to associate the type to the ingredient, while the “Legal name” designates the name displayed on the label.
In the label, the ingredient type is used to group ingredients according to their regulatory classifications. example: antioxidant: E300; emulsifier: E472, E322.
Other options are also available in this list:
- Plural legal name: Name displayed on the label if the grouping contains several values.
- Threshold (%): Allows you to group ingredients related to this category if their proportion is below a certain threshold. example: Group spices only if their quantity is less than 2%.
- Do not declare: If this box is checked, the category and associated ingredients are not declared. example: Do not declare the “anti-caking agent” category.
- Place at the end: If this box is checked, the category and associated ingredients are placed at the end of the list. example: The “casings” category is systematically placed at the end.
Entity templates
Folders
Entities’ templates are configured per entity type (product, client, supplier) in which there are subfolders, for example : images, documents etc. When the model is parameterized, once a user will create a product, the system will initialize the entity’s folder according to the folder model by creating the subfolders.
Data lists
Entity templates allows you to define the characteristics managed on each product (ie : costs, allergens, nutrition facts). Each time you create a new product, it inherits characteristics defined on template.
- From beCPG admin console, open "Entity templates".
- Open folder "Templates of product"
- Open "Finished Product" data lists
- For each data list, add characteristics you want to manage on every
product
> Costs, select costs previously created (Cost raw material,
Cost packaging, Cost production)
> Nutrients, select nutrients previously created (Energy, Fat,
Sugar, ...)
> * etc...
- Do the same with other templates : semi-finished, raw material, ...
- Now, when you create a new product, it inherits characteristics defined on template.
Note:
The new allergen will be added to new products, but won’t be added to already existing products as long as they are no formulated or as long as the administrator doesn’t click on the « Synchronize the entities » action.
Creation of a new template for raw material (if it is really necessary)
Repository> System> Entity templates> Product templates
- Make a copy of a raw material template,
- Change the name of the copy (for example : "Fresh fruit Raw Material"),
- Click on the "Fresh fruit Raw Material" template,
- Change the informations in the lists (physico-chemical ...)
Now you have 2 different templates for raw material. When you will create a raw material, you will have to chose the right template.
Add a list to an entity
Other lists can be added to entity templates. To manage additional information:
On the model: Add a list
- Select the list. You can rename it if required.
The following lists are available:
Life Cycle Assessment (LCA) - Process List - Materials - Claims - Microbiology - Resource Parameters - Control Parameters - Fish Information - Packaging - Alcohol Beverage - Stocks - Hazards - Price - Selling Price - Product - Time Spent - Custom View - Budget - Expense - Sample - Evaluation - Invoicing - Request List - Publication Channels - Certification - Contacts - Composition - Variant Characteristic
Creation of a generic raw material
Purpose
You create and use a generic RM because you want to manage independently several "identical" RM which have slight differences (suppliers, origins ...)
You will have te create an entity template call "generic raw material". It will have a composition's list so it will be possible to add in the composition list the "identical RM" The generic raw material will bring together the informations.
For example, you have 3 tomatoes with 3 different suppliers and with different quantities of minerals. You will create one unique RM which will synthesize all the informations.
How to create a specific entity's template : "generic RM"
Repository> System> Entity templates> Product templates
- Make a copy of a raw material template,
- Change the name of the copy to : « Generic Raw Material »,
- Click on the Generic Raw Material template,
- Add a new list and choose « Composition »,
- Name this new list "Composition" for example,
- Save.
How to use this entity template :
- Go back to your original folder,
- Create a raw material,
- Name your raw material,
- Choose the template : Generic Raw Material,
- Save.
Now, it is possible to add in the composition list of your raw materials, the similar RM. Formulate,
The various fields : nutrients, allergens ... will be completed automatically using the information you added in the "similar" raw materials. The calculation are the same as for the semi-finished products and the finished products.
Formulation
If BeCPG is not linked to your ERP: It is possible to formulate your recipes with the raw material contained in the generic raw material. You just need to create a different ERP code. For example : ERP code of your generic RM + ERP code of your supplier. It will be easy to tell them apart.
If BeCPG is linked to your ERP : It won't be possible because your ERP won't tell the RM apart. Only the ERP code of the generic RM will be recognized by your ERP.
Microbiological criteria Folder
The microbiological criteria can be in the administration to avoid unintentional modifications by users. A folder is available in the administration: beCPG menu > Administration > Microbiological criteria > System folders: Microbiological criteria
Click here for more information on microbiological criteria.
Reports models
Entity reports (example : product technical sheet)
There exists two types of reports for the product sheet:
- System report (always generated by the system, automatically) ;
- User report (chosen by the user when he edits the product). This type of report is an upon request report.
Product reports are defined in Repository> System> Reports> Product reports.
The addition of a new report is made like that :
Add a folder ;
Add the file .rptdesign and then edit its metadata :
The name of the report ;
- The product type (raw material, finished product etc.) to define the product type on which the report can be applied ;
- Tick « System model » to indicate if the report is automatically generated for this type of product. In the case in which the report isn’t a system report, the user must select it when he edits the product ;
- Tick « Default model » to indicate that the report is the default report for the product, which means that it will be display per default when the user opens the « Reports » list. It’s not possible to have more than one default report for a type of product. Reports which are not default reports are classified in the product « Documents » folder when the report is generated.
- Report extension
To create or modify a BIRT report, please refer to « Product report model modification ».
When a product is created or edited, the system generates a report which is associated to the product.
Extraction reports from a research
These reports are defined in the folder Repository> System> Reports> Export search.
They are BIRT or EXCEL reports which export a research result. They are also used for the projects follow up.
To add a new report :
Add a folder ;
In this later, add :
The BIRT or EXCEL report, filled with its name and its metadata. The name will be displayed on the results page of a research ;
- The file extension must be « xls » for an EXCEL report and « rptdesign » for a BIRT report ;
- Define its permissions on the report folder. People must have the « Reading » permission to be able to see the report in the result of a query.
Solely for the BIRT reports : Definition of the data to be exported to feed the report, which name is ExportSearchQuery.xml. This file defines the attributes of a product which must be exported during the report execution : > product properties (state, name etc.); > product’s links (supplier, clients, etc...); > * product’s characteristics (costs, nutrients, allergens, etc...).
To create or modify a BIRT report, please refer to « Modification of a product report model ».
EXCEL reports are easy to create. In EXCEL, in the first tab, define the principal type to extract as follow :
TYPE bcpg:finishedProduct
COLUMNS cm:name bcpg:code bcpg:erpCode bcpg:productHierarchy1 bcpg:productHierarchy2
# Nom Code Code ERP Famille Sous famille
On the following tabs, extract the principal type data lists. Example for the composition :
TYPE bcpg:compoList
COLUMNS bcpg:erpCode bcpg:compoListProduct bcpg:compoListProduct_bcpg:erpCode bcpg:compoListProduct_bcpg:productHierarchy1
# Produit Composant Composant – Code ERP Composant – Famille
Columns and types attributes are internal names given to fields.