Exibir origem

Table Maintenance

Linha Microsiga Protheus - Inglês > Table Maintenance - Brazil-gpea320_manutencao_de_tabelas_bra.htm > bra.jpg

This register is used to perform table maintenance according to the structure registered in Table Definition.

Data storage has the following fields as search keys: Branch, Reference Month/Year and Sequence. These fields are mandatory in any table and there is no need to define them in the structure, as they are created automatically by the system.

The tables can be differentiated between branches, if necessary; otherwise the Branch field must be left blank so that the table is common for all branches. Besides, they can be registered monthly or even have a table for unregistered months, as long as the Month/Year field is left blank.

The sequence is filled out automatically for each existing search key and, as it is registered, it is classified according to the caption.

Example:

Using the title table, the table filled with the classification of the titles and their respective percentages is displayed as follows:

Branch	Month/Year	Sequence	Code	Description	Percentage
		001	01	GRADUATION	1%
		002	02	SPECIALIZATION	2%
		003	03	MASTER'S DEGREE	3%
		004	04	DOCTOR'S DEGREE	4%

The columns Code, Description and Percentage were defined by the Table Definition routine.

Linha Microsiga Protheus - Inglês > Table Maintenance - Brazil-gpea320_manutencao_de_tabelas_bra.htm > help_button.zoom40.gif Important:

•	Table deletion is subject to its use in calculations, i.e., if in use, it cannot be deleted.

•	In order to fill out the table and use the defined structure in calculations, you must define a calculation formula anticipating their types and percentages. Otherwise, the simple act of creating a table and filling it out does not have any consequence in calculation results.

Some of the tables used:

Dental Care
S013	Dental Care by Salary Range
S014	Dental Care by Age Group
S017	Dental Care by Provider

Health Care
S008	Health Care by Salary Range
S009	Health Care by Age Group
S016	Health Care by Provider

Contract History - Abroad
S021	Health Care by Salary Range
S022	Health Care by Age Group
S023	Dental Care by Provider

Procedures

Maintaining tables:

1.	In Tables, select Add.

The fields to be filled out are displayed on screen according to the structure registered in the Table Definition.

2.	Fill out data according to field help instructions.

3.	After entering the fields, check and confirm them.