The INFLOR Analytics module is a Data Warehouse specific to the INFLOR FOREST solution. It contains tables Facts and Dimensions to provide INFLOR customers a consistent basis for building reports and dashboards through self-service BI tools such as Microsoft Power BI, Tableau, Qlik Sense, QuickSight, Domo,...
The INFLOR solution Data Warehouse consists of tables of the type FACT and DIMENSION.
Back to topics
Tables of the FACT type are the main tables in a Data Warehouse model. A FACT table represents factual data from a business process, for example, monthly cost of operations by region.
A FACT table has quantitative characteristic, and can have one or more columns classified as measures.
Measures are the values to be analyzed by sums, averages, counting, etc.
The fact table is found in the center of schemas of the star type or the snowflake type, surrounded by dimension tables.
INFLOR Analytics uses the star model in its data warehouse.
See more on https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Back to topics
In a data warehouse, dimensions is a set of supplemental tables for a fact table.
Unlike fact tables, dimension tables contain descriptive attributes (or fields) that are usually text fields (or discrete numbers that behave like text). These attributes are designed to serve two critical purposes: query restriction and/or filtering, and query result set labeling.
Dimension table rows are uniquely identified by a single key field.
INFLOR has standardized the key attribute names of dimension tables. They have the name of the table ending with "_id". For example: The dimension table dim_material has the key attribute dim_material_id. And it is through this attribute that the relationship between the fact table and the dimension table dim_material should be made.
The fact tables contain attributes that are business measures and attributes that are the key fields of dimension tables.
See more on https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Back to topics
The INFLOR Forest solution has several processes besides INFLOR Analytics. Among them we can highlight:
Back to topics
¶ Processes and their facts
¶ Land Contract Management
¶ Bioasset and exhaustion
Back to topics
Back to topics
¶ Facts and their attributes
List of all facts of the INFLOR Analytics modules, sorted alphabetically, and their respective attributes:
¶ FACT_CONSOLIDATED_STAND
Stands consolidated (CON_USO_SOLO)
| Attribute |
Description |
Type |
Classification |
| dim_consolidated_id |
Automatic Code of Forest Register Consolidation |
int(19) |
Dimension |
| dim_locality_id |
Automatic Code of the Area Measurement Unit |
int(19) |
Dimension |
| automatic_stand_code |
Stand ID in the forest register consolidation |
int(19) |
Degenerate Dimension |
| region_id |
Property Code |
int(19) |
Degenerate Dimension |
| region_description |
Property description |
text(64) |
Degenerate Dimension |
| project_id |
Tract ID |
text(16) |
Degenerate Dimension |
| project_name |
Tract Name |
text(64) |
Degenerate Dimension |
| stand_code |
Stand key |
text(24) |
Degenerate Dimension |
| cycle |
Planting cycle number. |
int(2) |
Degenerate Dimension |
| Rotation |
Planting rotation number. |
int(2) |
Degenerate Dimension |
| planting_date |
Planting date |
int(19) |
Degenerate Dimension |
| land_use_characteristic_identification |
Land Use Feature ID |
int(19) |
Degenerate Dimension |
| land_use_characteristic_description |
Description of land use feature |
text(64) |
Degenerate Dimension |
| land_use_characteristic_group_identification |
Land Use Feature group ID |
int(19) |
Degenerate Dimension |
| land_use_characteristic_group_description |
Land use feature group description |
text(64) |
Degenerate Dimension |
| watershed_description |
Watersheed Description |
text(64) |
Degenerate Dimension |
| soil_type_description |
Soil Type Description |
text(264) |
Degenerate Dimension |
| spacing_description |
Description of spacing |
text(64) |
Degenerate Dimension |
| genus_description |
Description of the genus |
text(64) |
Degenerate Dimension |
| specie_description |
Description of the species. |
text(128) |
Degenerate Dimension |
| genetic_material_description |
Description of genetic material |
text(128) |
Degenerate Dimension |
| seedling_generation_description |
Description of the propagation system. |
text(64) |
Degenerate Dimension |
| planting_establishment_system_description |
Regime description |
text(64) |
Degenerate Dimension |
| slope_description |
Description of the slope. |
text(64) |
Degenerate Dimension |
| ownership_type_description |
Property Type Description |
text(64) |
Degenerate Dimension |
| site_class_description |
Description of site class |
text(64) |
Degenerate Dimension |
| transport_distance |
Distance to nearest consumption center |
numeric(9,2) |
Degenerate Dimension |
| stand_area |
Stand area |
numeric(9,2) |
Measure |
| register_type |
Record type. A=Current, P=Projected. |
text(1) |
Degenerate Dimension |
| register_date |
Registration date |
int(19) |
Degenerate Dimension |
| register_status |
Register status. A=Active, H=Historical, E=Loading error |
text(1) |
Degenerate Dimension |
| investment_project_description |
Investment project description |
text(64) |
Degenerate Dimension |
| investiment_project_task_description |
Tract ID |
text(25) |
Degenerate Dimension |
| farm_name |
Farm Name |
text(128) |
Degenerate Dimension |
| land_use_transition_description |
Description of the land use transition. |
text(64) |
Degenerate Dimension |
| legal_person_name |
Stand responsible company |
text(200) |
Degenerate Dimension |
| typology_description |
Description of the typology. |
text(250) |
Degenerate Dimension |
| biome_description |
Biome Description |
text(50) |
Degenerate Dimension |
| extra_text_01 |
Extra Description 01. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_02 |
Extra Description 02. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_03 |
Extra Description 03. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_04 |
Extra Description 04. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_05 |
Extra Description 05. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_06 |
Extra Description 06. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_07 |
Extra Description 07. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_08 |
Extra Description 08. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_09 |
Extra Description 09. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_10 |
Extra Description 10. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_11 |
Extra Description 11. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_12 |
Extra Description 12. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_13 |
Extra Description 13. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_14 |
Extra Description 14. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_15 |
Extra Description 15. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_number_01 |
Extra number 01. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_02 |
Extra number 02. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_03 |
Extra number 03. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_04 |
Extra number 04. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_05 |
Extra number 05. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_06 |
Extra number 06. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_07 |
Extra number 07. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_08 |
Extra number 08. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_09 |
Extra number 09. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_10 |
Extra number 10. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_11 |
Extra number 11. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_12 |
Extra number 12. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_13 |
Extra number 13. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_14 |
Extra number 14. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_15 |
Extra number 15. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_date_01 |
Extra Date 01. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_02 |
Extra Date 02. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_03 |
Extra Date 03. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_04 |
Extra Date 04. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_05 |
Extra Date 05. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_06 |
Extra Date 06. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_07 |
Extra Date 07. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_08 |
Extra Date 08. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_09 |
Extra Date 09. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_10 |
Extra Date 10. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_11 |
Extra Date 11. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_12 |
Extra Date 12. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_13 |
Extra Date 13. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_14 |
Extra Date 14. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_15 |
Extra Date 15. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| stand_observation |
Note |
text(250) |
Degenerate Dimension |
| plan_description |
Description of the operation plan. |
text(64) |
Degenerate Dimension |
| employee_name |
Username |
text(96) |
Degenerate Dimension |
| macro_region_description |
Fund description |
text(96) |
Degenerate Dimension |
| stand_group_identification |
Compartment Code |
text(16) |
Degenerate Dimension |
| stand_group_description |
Compartment description |
text(64) |
Degenerate Dimension |
| measure_unit_description |
Description of the area measure unit |
text(64) |
Degenerate Dimension |
| planting_year |
Planting Year |
int(4) |
Degenerate Dimension |
| planting_month |
Month of planting |
int(2) |
Degenerate Dimension |
Back to topics
¶ FACT_STAND
Forest Register (Stands) (CFG_USO_SOLO)
| Attribute |
Description |
Type |
Classification |
| stand_automatic_code |
Automatic Code of Stands Register |
text(24) |
Degenerate Dimension |
| stand_full_key |
Complete code for the stand. Property_Code+-+Tract_Code+-+Stand_ID+-+Cycle+-+Rotation+-+Operational_Plan_Code |
text(50) |
Degenerate Dimension |
| dim_macro_region_id |
Fund ID |
int(19) |
Dimension |
| dim_region_id |
Property ID |
int(19) |
Dimension |
| dim_project_id |
Tract ID |
int(19) |
Dimension |
| dim_stand_block_id |
Compartment ID |
int(19) |
Dimension |
| stand_code |
Stand key |
text(24) |
Degenerate Dimension |
| cycle |
Cycle Number. |
int(2) |
Degenerate Dimension |
| Rotation |
Rotation Number |
int(2) |
Degenerate Dimension |
| planting_date |
Planting date |
int(19) |
Degenerate Dimension |
| transport_distance |
Distance to nearest consumption center |
numeric(9,2) |
Degenerate Dimension |
| stand_area |
Stand area |
numeric(9,2) |
Measure |
| register_status |
Register status. A=Active, H=Historical, E=Loading error |
text(1) |
Degenerate Dimension |
| register_type |
Record type. A=Current, P=Projected. |
text(1) |
Degenerate Dimension |
| register_date |
Registration date |
datetime |
Degenerate Dimension |
| dim_land_use_characteristic_id |
Automatic Code Land Use Classification |
int(19) |
Dimension |
| dim_watershed_id |
Automatic Code Forest Type |
int(19) |
Dimension |
| dim_soil_type_id |
Automatic Code of Soil Type |
int(19) |
Dimension |
| dim_spacing_id |
Automatic Code of Spacing |
int(19) |
Dimension |
| dim_seedling_generation_id |
Automatic Code of Propagation System |
int(19) |
Dimension |
| dim_genetic_material_id |
Automatic Code of Genetic Material |
int(19) |
Dimension |
| dim_specie_id |
Automatic Code of Species |
int(19) |
Dimension |
| dim_work_scheme_id |
Automatic Code of Work Scheme (Silviculture) |
int(19) |
Dimension |
| dim_planting_establishment_system_id |
Automatic Code of Regime |
int(19) |
Dimension |
| dim_slope_id |
Automatic Code of Slope |
int(19) |
Dimension |
| dim_ownership_type_id |
Automatic Code of Property Type |
int(19) |
Dimension |
| dim_site_class_id |
Automatic code of the investment project |
int(19) |
Dimension |
| dim_biome_id |
Automatic Code of Biome |
int(19) |
Dimension |
| dim_typology_id |
Automatic Code of Typology |
int(19) |
Dimension |
| dim_plan_id |
Automatic Code of Operation Plan |
int(19) |
Dimension |
| dim_investment_project_id |
Automatic code of the investment project |
text(20) |
Dimension |
| dim_investiment_project_task_id |
Automatic code of the investment project task |
int(19) |
Dimension |
| dim_farm_id |
Automatic Code of Farm |
int(19) |
Dimension |
| dim_person_company_id |
Automatic code of the responsible for the cost of the stand |
int(19) |
Dimension |
| dim_land_use_transition_id |
Automatic Code of Land Use Transition |
int(19) |
Dimension |
| dim_user_id |
Code of the user responsible to create the record |
int(19) |
Dimension |
| dim_measure_unit_id |
Automatic Code Location |
int(19) |
Dimension |
| dim_locality_id |
Automatic Code of the Area Measurement Unit |
int(19) |
Dimension |
| stand_observation |
Note |
text(256) |
Degenerate Dimension |
| extra_text_01 |
Extra Description 01. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_02 |
Extra Description 02. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_03 |
Extra Description 03. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_04 |
Extra Description 04. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_05 |
Extra Description 05. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_06 |
Extra Description 06. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_07 |
Extra Description 07. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_08 |
Extra Description 08. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_09 |
Extra Description 09. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_10 |
Extra Description 10. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_11 |
Extra Description 11. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_12 |
Extra Description 12. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_13 |
Extra Description 13. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_14 |
Extra Description 14. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_text_15 |
Extra Description 15. Consult the support team for this attribute. |
text(256) |
Degenerate Dimension |
| extra_number_01 |
Extra number 01. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_02 |
Extra number 02. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_03 |
Extra number 03. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_04 |
Extra number 04. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_05 |
Extra number 05. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_06 |
Extra number 06. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_07 |
Extra number 07. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_08 |
Extra number 08. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_09 |
Extra number 09. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_10 |
Extra number 10. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_11 |
Extra number 11. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_12 |
Extra number 12. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_13 |
Extra number 13. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_14 |
Extra number 14. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_number_15 |
Extra number 15. Consult the support team for this attribute. |
numeric(18,4) |
Degenerate Dimension |
| extra_date_01 |
Extra Date 01. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_02 |
Extra Date 02. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_03 |
Extra Date 03. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_04 |
Extra Date 04. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_05 |
Extra Date 05. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_06 |
Extra Date 06. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_07 |
Extra Date 07. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_08 |
Extra Date 08. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_09 |
Extra Date 09. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_10 |
Extra Date 10. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_11 |
Extra Date 11. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_12 |
Extra Date 12. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_13 |
Extra Date 13. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_14 |
Extra Date 14. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| extra_date_15 |
Extra Date 15. Consult the support team for this attribute. |
int(19) |
Degenerate Dimension |
| latitude_centroid |
Polygon centroid latitude value. |
numeric(11,8) |
Degenerate Dimension |
| longitude_centroid |
Polygon centroid longitude value. |
numeric(11,8) |
Degenerate Dimension |
Back to topics
¶ FACT_STAND_TIMBER_CERTIFICATION
Stands x Certificates (CFG_CARACTERISTICA_MADEIRA_USO)
| Attribute |
Description |
Type |
Classification |
| dim_timber_certification_id |
Automatic Code of Certificate |
int(19) |
Dimension |
| dim_stand_id |
Stand ID |
int(19) |
Dimension |
| stand_area |
Stand area |
numeric(9,2) |
Measure |
Back to topics
¶ FACT_STAND_WOOD_CHARACTERISTIC
Stands x Wood Characteristics (CFG_CARACTERISTICA_MADEIRA_USO)
| Attribute |
Description |
Type |
Classification |
| dim_wood_characteristic_id |
Automatic Code of the Wood Characteristics |
int(19) |
Dimension |
| dim_stand_id |
Stand ID |
int(19) |
Dimension |
| stand_area |
Stand area |
numeric(9,2) |
Measure |
| characteristic_value |
Characteristic Value |
numeric(18,2) |
Measure |
| class_description |
Description of wood feature |
text(64) |
Degenerate Dimension |
| class_abbreviation |
Wood feature short description |
text(16) |
Degenerate Dimension |
| indeterminate_flag |
Undetermined class mark |
text(1) |
Degenerate Dimension |
| desired_flag |
Desired class Flag |
text(1) |
Degenerate Dimension |
| initial_class_value |
Class start value |
numeric(10,2) |
Degenerate Dimension |
| final_class_value |
Final class value |
numeric(10,2) |
Degenerate Dimension |
Back to topics
Follow-ups - Complete query (CTL_BOLETIM_SILVICULTURA)
| Attribute |
Description |
Type |
Classification |
| FOLLOWUP_DESCRIPTION |
Follow-up code (mannual) |
text(32) |
Degenerate Dimension |
| FOLLOWUP_ID |
Automatic Code of Follow-up |
int(10) |
Degenerate Dimension |
| DIM_OPERATION_DATE_ID |
Opertation date |
int(10) |
Dimension |
| DIM_PAYMENT_PROCESS_ID |
Automatic Code of Payment Process |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Automatic Code of supplier |
int(10) |
Dimension |
| DIM_CONTRACT_ID |
Automatic Code of Contract |
int(10) |
Dimension |
| DIM_PROCESS_ID |
Automatic Code of Process |
int(10) |
Dimension |
| FOLLOWUP_STATUS |
Follow-up Status. I=Inserted; A=Approved; R=Not approved; E=In Analysis; C=Canceled |
text(1) |
Degenerate Dimension |
| CALCULATION_PAYMENT_TYPE |
Type of calculation. O=Pay for the Operation; R=Pay for resources (equipment + worker) |
text(1) |
Degenerate Dimension |
| FOLLOWUP_COSTS |
Follow-up cost |
numeric(18,5) |
Measure |
| DIM_REGION_ID |
Property ID |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Automatic code of the investment project |
int(10) |
Dimension |
| STAND_CODE |
Stand key |
text(24) |
Degenerate Dimension |
| DIM_STAND_ID |
Stand ID |
int(10) |
Dimension |
| DIM_GENETIC_MATERIAL_ID |
Automatic Code of Genetic Material |
int(10) |
Dimension |
| DIM_SPECIE_ID |
Automatic Code of Species |
int(10) |
Dimension |
| OPERATION_PRODUCTION |
Worked Quantity |
float |
Measure |
| PERCENTAGE_DONE |
Operation completion percentage |
numeric(5,2) |
Measure |
| DIM_FOLLOWUP_DATE_ID |
Record date |
int(10) |
Dimension |
| DIM_OPERATION_ID |
Automatic Code of Operation |
int(10) |
Dimension |
| DIM_REPORTER_USER_ID |
User who performed the registration. |
int(10) |
Dimension |
| DIM_EMPLOYEE_ID |
Automatic Code of Employee in Chage |
int(10) |
Dimension |
| DIM_WORK_ORDER_ID |
Automatic Code of Service Order |
int(10) |
Dimension |
| DIM_MEASURE_UNIT_ID |
Automatic Code of Operation Measurement Unit |
int(10) |
Dimension |
| UNITARY_OPERATION_PRICE |
Operation unit cost |
float |
Measure |
| OPERATION_COSTS |
Operaction Cost |
float |
Measure |
| DIM_PRODUCTIVITY_CLASS_ID |
Automatic Code of Productivity Scale of Operation |
int(10) |
Dimension |
| QUANTITY_LEVEL2 |
Number of assessments performed level 2 |
float |
Degenerate Dimension |
| NOTE_LEVEL2 |
Average level 2 ratings grade |
float |
Degenerate Dimension |
| DIM_UNIT_ID |
Automatic Code of Business Unit |
int(10) |
Dimension |
| DIM_EQUIPMENT_ID |
Automatic Code of Equipment Used |
int(10) |
Dimension |
| DIM_POSITION_ID |
Automatic Code of Used Position |
int(10) |
Dimension |
| DIM_MATERIAL_ID |
Automatic Code of Material Used |
int(10) |
Dimension |
| QUANTITY_RESOURCE |
Resource Quantity |
float |
Measure |
| MEASURE_UNID_ABBREVIATION |
Abbreviation of Resource Production Measurement Unit |
text(32) |
Degenerate Dimension |
| FLAG_DESCARD |
Material Disposal Flag |
float |
Degenerate Dimension |
| ESTIMATED_PRODUCTIVITY |
Expected resource yield |
numeric(18,5) |
Measure |
| REAL_PRODUCTIVITY |
Actual resource yield |
numeric(18,5) |
Measure |
| DIM_WORKTIME_CLASSIFICATION_ID |
Automatic Code of Hour Type |
int(10) |
Dimension |
| FLAG_PAID_HOUR |
Flag for paying the hour type (0= No; 1= Yes) |
text(2) |
Degenerate Dimension |
| START_HOUR_METER |
Initial hour meter |
error |
Degenerate Dimension |
| FINISH_HOUR_METER |
Final hour meter |
error |
Degenerate Dimension |
| TOTAL_HOUR_METER |
Total hour meter |
error |
Measure |
| START_HOUR |
Start Time |
datetime |
SCD - Overwrite |
| FINISH_HOUR |
End Time |
datetime |
SCD - Overwrite |
| TOTAL_HOUR |
Total Hours |
error |
Measure |
| UNITARY_PRICE |
Resource unit cost |
float |
Measure |
| TOTAL_COSTS |
Resource cost |
float |
Measure |
| RESOURCE_PRODUCTIVITY_CLASS_DESCRIPTION |
Description of resource yield scale |
text(64) |
Degenerate Dimension |
| DIM_INVESTMENT_PROJECT_ID |
Automatic code of the investment project task |
int(10) |
Dimension |
| DIM_INVESTMENT_PROJECT_TASK_ID |
Automatic code of the investment project task |
int(10) |
Dimension |
| DIM_LOCALITY_ID |
Automatic Code of County |
int(10) |
Dimension |
| FLAG_PAY_RESOURCE |
Flag for paying the resource (0 = No; 1 = Yes) |
float |
Degenerate Dimension |
| DIM_MANAGEMENT_UNIT_ID |
Automatic Code of Management Unit |
int(10) |
Dimension |
| FLAG_INCIDENT |
Occurrence Flag (0 = No; 1 = Yes) |
float |
Degenerate Dimension |
| FLAG_PAY_OPERATION |
Flag for paying the Follow-up (0 = No; 1 = Yes) |
float |
Degenerate Dimension |
| FLAG_WRITE_OFF_MATERIAL |
Material consumption flag (0 = No; 1 = Yes) |
float |
Degenerate Dimension |
| FLAG_REEXECUTE_OPERATION |
Flag for re-execute the operation (0 = No; 1 = Yes) |
float |
Degenerate Dimension |
| DIM_PRESCRIPTION_PHASE_ID |
Automatic Code of Prescription Phase |
int(10) |
Dimension |
| DIM_APPROVER_USER_ID |
User responsible for approval |
int(10) |
Dimension |
| COST_TYPE |
Follow-up costing type. M=Maintenance; I=Investment |
text(1) |
Degenerate Dimension |
| COST_OBJECT_DESCRIPTION |
Costs Collector |
text(4000) |
Degenerate Dimension |
| OBSERVATION_DESCRIPTION |
Follow-up comments |
text(2000) |
Degenerate Dimension |
| FLAG_CLOSED_STAND |
Field closing mark (completion of operation) |
float |
Degenerate Dimension |
| DIM_WORK_SHIFT_ID |
Work shift |
int(10) |
Dimension |
| FACT_FOLLOWUPS_ERP_STATUS_INT |
ERP integration status |
text(1) |
Degenerate Dimension |
| DIM_CURRENCY_TYPE_ID |
Document currency. |
int(10) |
Dimension |
| APPROVAL_DATE |
Approval date |
date |
Degenerate Dimension |
Back to topics
Non-scheduled operation follow-up (eventual work order) (CTL_BOLETIM_SILVICULTURA)
| Attribute |
Description |
Type |
Classification |
| TYPE_INFORMATION |
Enumerated. Type of information. R = Accomplished, P = Planned, O = Budgeted. |
text(1) |
Degenerate Dimension |
| FOLLOWUP_ID |
Follow-up code |
int(10) |
Degenerate Dimension |
| DIM_STAND_ID |
Stand ID |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Tract ID |
int(10) |
Dimension |
| DIM_REGION_ID |
Property ID |
int(10) |
Dimension |
| DIM_LOCALITY_ID |
Automatic Code of Location |
int(10) |
Dimension |
| DIM_OPERATION_ID |
Automatic Code of Operation |
int(10) |
Dimension |
| DIM_ACTIVITY_ID |
Automatic Code of Activity |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Automatic Code of Supplier |
int(10) |
Dimension |
| DIM_DATE_ID |
Date of operation |
int(10) |
Dimension |
| DIM_ACCRUAL_BASIS_CALENDAR_ID |
Automatic Code of Accrual Calendar |
int(10) |
Dimension |
| OPERATION_PRODUCTION |
Operation performed quantity |
float |
Measure |
| OPERATION_EQUIPMENT_COST |
Total equipment costs |
float |
Measure |
| OPERATION_MATERIAL_COST |
Total material cost |
float |
Measure |
| OPERATION_LABOR_COST |
Total worker cost |
float |
Measure |
| OPERATION_COST |
Operation Cost, when paid per operation and not per resources |
float |
Measure |
| DIM_PROCESS_ID |
Process Code |
int(10) |
Dimension |
| DIM_PLAN_ID |
Operational or Budgetary Plan Code |
int(10) |
Dimension |
| DIM_WORK_ORDER_ID |
Automatic Code of Service Order |
int(10) |
Dimension |
| DIM_MANAGEMENT_UNIT_ID |
Automatic Code of Management Unit |
int(10) |
Dimension |
| STATUS |
Enumerated. Status of Follow-up approval. I = Undefined, A = Approved, R = Reproved, E = In Analysis, C = Canceled. |
text(2) |
Degenerate Dimension |
| DIM_UNIT_ID |
Automatic Code of Business Unit |
int(10) |
Dimension |
| FLAG_CLOSED_STAND |
Flag Field closed (operation completed) |
float |
Degenerate Dimension |
| DIM_PRESCRIPTION_PHASE_ID |
Automatic Code of Prescription Phase |
int(10) |
Dimension |
| UNITARY_OPERATION_PRICE |
Transaction unit value |
float |
Measure |
| APPROVAL_DATE |
Approval date |
date |
Degenerate Dimension |
Back to topics
Payment processes (CTL_PROCESSO_PAGAMENTO)
| Attribute |
Description |
Type |
Classification |
| dim_unit_id |
Automatic Code of Unit |
int(19) |
Dimension |
| dim_process_id |
Automatic Code of Process |
int(19) |
Dimension |
| payment_process_code |
Automatic Code of Payment Process |
int(19) |
Degenerate Dimension |
| dim_management_unit_id |
Automatic Code of Management Unit |
int(19) |
Dimension |
| payment_process_description |
Payment Process Description |
text(32) |
Degenerate Dimension |
| dim_start_date_id |
Payment process - start date |
int(19) |
Dimension |
| dim_finish_date_id |
Payment process - end date |
int(19) |
Dimension |
| dim_calculate_date_id |
Payment process calculation date |
int(19) |
Dimension |
| dim_supplier_id |
Automatic Code of Supplier |
int(19) |
Dimension |
| dim_contract_id |
Automatic Code of Contract |
int(19) |
Dimension |
| payment_process_status |
Payment process status. It can be: P - Paid; I-Inserted; A-Approved; C-Calculated; E-Sent to ERP |
text(1) |
Degenerate Dimension |
| payment_value |
Calculated payment amount |
numeric(18,6) |
Measure |
| deduction_value |
Calculated Deduction Amount |
numeric(18,6) |
Measure |
| payment_calculation_delay |
Interval of days between the last calculation date and the final payment process date. |
int(5) |
Measure |
Back to topics
Details of the payment process (CTL_ITEM_PROCESSO_PAGAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_UNIT_ID |
Automatic Code of Unit |
int(10) |
Dimension |
| DIM_PROCESS_ID |
Automatic Code of Process |
int(10) |
Dimension |
| PAYMENT_PROCESS_CODE |
Payment Process Code |
int(10) |
Degenerate Dimension |
| DIM_MANAGEMENT_UNIT_ID |
Automatic Code of Management Unit |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Automatic Code of Supplier |
int(10) |
Dimension |
| DIM_CONTRACT_ID |
Automatic Code of Contract |
int(10) |
Dimension |
| PAYMENT_PROCESS_ITEM_CODE |
Automatic Code of Payment Process Item |
int(10) |
Degenerate Dimension |
| PAYMENT_RETENTION_FLAG |
Payment hold flag |
error |
Degenerate Dimension |
| PAYMENT_PREVIOUS_RETENTION_FLAG |
Previous payment hold flag |
error |
Degenerate Dimension |
| DIM_OPERATION_DATE |
Operation Date |
int(10) |
Dimension |
| DIM_OPERATION_ID |
Automatic Code of Operation |
int(10) |
Dimension |
| DIM_MEASURE_UNIT_ID |
Automatic Code of Measurement Unint, Dividend of Productivity Template |
int(10) |
Dimension |
| DIM_PRODUCTIVITY_CLASS_ID |
Automatic Code of Productivity Scale |
int(10) |
Dimension |
| PAYMENT_PROCESS_ITEM_TYPE |
Enumerated. Indicates how the payment is calculated. O = Operation and R = Resources (equipment / worker) |
text(1) |
Degenerate Dimension |
| DIM_INVESTMENT_PROJECT_ID |
Automatic code of the investment project |
int(10) |
Dimension |
| DIM_INVESTMENT_PROJECT_TASK_ID |
Automatic code of the investment project task |
int(10) |
Dimension |
| DIM_ACCOUNT_ID |
Automatic Code of Bookkeeping Account |
int(10) |
Dimension |
| DIM_WORK_ORDER_ID |
Automatic Code of Service Order |
int(10) |
Dimension |
| FOLLOWUP_TYPE |
Enumerated. Indicates the type of operation Follow-up. A=Harvest Adjustment, B=Harvest, C=Delivery Note, D=Demands, F=Environmental Monitoring, G=Trigger Activity, I=Inventory, M=Post-Planting Measurement, P=Wood Yard, S=Silviculture, T=Transport, V=Nursery, X=Eventual Services |
text(2) |
Degenerate Dimension |
| FOLLOWUP_NUMBER |
Follow-up code |
text(32) |
Degenerate Dimension |
| PAY_FLAG |
Flag that identifies whether the Follow-up should be considered for payment. 0 = No and 1 = yes. |
error |
Degenerate Dimension |
| QUANTITY_WORKED |
Worked Quantity |
error |
Measure |
| UNITARY_OPERATION_PRICE |
Transaction unit value |
float |
Measure |
| OPERATION_COSTS |
Cost of operation. It depends on the payment type attribute |
float |
Measure |
| DEDUCTION_AMOUNT |
Deduction Amount |
float |
Measure |
| OPERATION_COSTS_AFTER_DEDUCTION |
Cost value after deduction |
float |
Measure |
| DISTRIBUTION_PERCENTAGE |
Apportionment Percentage |
float |
Measure |
| DIM_COST_OBJECT_ID |
Automatic Code of Cost Center |
int(10) |
Dimension |
| DISTRIBUTED_QUANTITY_WORKED |
Worked quantity prorated by cost center. |
float |
Measure |
| DISTRIBUTED_OPERATION_COSTS |
Cost Value Prorated by Cost Center |
float |
Measure |
| DISTRIBUTED_DEDUCTION_AMOUNT |
Deduction amount prorated by cost center |
float |
Measure |
| DISTRIBUTED_OPERATION_COSTS_AFTER_DEDUCTION |
Cost value after prorated deduction |
float |
Measure |
| DIM_CURRENCY_TYPE_ID |
Document currency. |
int(10) |
Dimension |
| DIM_REGION_ID |
Property ID |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Automatic code of the investment project |
int(10) |
Dimension |
| DIM_STAND_ID |
Stand ID |
int(10) |
Dimension |
Back to topics
Resources - Equipment (PLA_EQUIPAMENTO_PROGRAMADO)
| Attribute |
Description |
Type |
Classification |
| information_type |
Enumerated. Indicates the type of information. B = Budgeted, P = Planned, R = Accomplished. |
text(1) |
Degenerate Dimension |
| dim_unit_id |
Automatic Code of Unit |
int(19) |
Dimension |
| dim_process_id |
Automatic Code of Process |
int(19) |
Dimension |
| dim_plan_id |
Automatic Code of Operational or Budgetary Plan |
int(19) |
Dimension |
| dim_activity_id |
Automatic Code of Activity |
int(19) |
Dimension |
| dim_operation_id |
Automatic Code of Operation |
int(19) |
Dimension |
| dim_measure_unit_id |
Automatic Code of Measurement Unint, Dividend of Productivity Template |
int(19) |
Dimension |
| programed_operation_code |
Automatic Code of Scheduled Operation |
int(19) |
Degenerate Dimension |
| dim_prescription_id |
Automatic Code of Prescription |
int(19) |
Dimension |
| dim_stand_id |
Stand ID |
int(19) |
Dimension |
| productivity_value |
Yield value |
numeric(18,3) |
Degenerate Dimension |
| dim_equipment_model_id |
Automatic Code of Equipment Family |
int(19) |
Dimension |
| total_hours |
Number of hours. When performed hours it can be hours or hour meter |
numeric(18,6) |
Measure |
| total_cost |
Total equipment costs. Only downtime type N = Normal Work |
numeric(18,6) |
Measure |
| dim_work_order_id |
Automatic Code of Service Order |
int(19) |
Dimension |
| dim_date_id |
Initial expected date |
int(19) |
Dimension |
| dim_accrual_basis_calendar_id |
Automatic Code of Accrual Calendar |
int(19) |
Dimension |
| dim_team_id |
Automatic Code of Team |
int(19) |
Dimension |
Back to topics
Resources - Labor (PLA_MAO_OBRA_PROGRAMADA)
| Attribute |
Description |
Type |
Classification |
| information_type |
Enumerated. Indicates the type of information. B = Budgeted, P = Planned, R = Accomplished. |
text(1) |
Degenerate Dimension |
| dim_unit_id |
Automatic Code of Unit |
int(19) |
Dimension |
| dim_process_id |
Automatic Code of Process |
int(19) |
Dimension |
| dim_plan_id |
Automatic Code of Operational or Budgetary Plan |
int(19) |
Dimension |
| dim_activity_id |
Automatic Code of Activity |
int(19) |
Dimension |
| dim_operation_id |
Automatic Code of Operation |
int(19) |
Dimension |
| dim_measure_unit_id |
Automatic Code of Measurement Unint, Dividend of Productivity Template |
int(19) |
Dimension |
| programed_operation_code |
Automatic Code of Scheduled Operation |
int(19) |
Degenerate Dimension |
| dim_prescription_id |
Automatic Code of Prescription |
int(19) |
Dimension |
| dim_stand_id |
Stand ID |
int(19) |
Dimension |
| productivity_value |
Yield value |
numeric(18,3) |
Degenerate Dimension |
| dim_position_id |
Automatic Code of Position |
int(19) |
Dimension |
| total_labor |
Quantity of worker |
numeric(18,6) |
Measure |
| total_cost |
Total worker cost |
numeric(18,6) |
Measure |
| dim_work_order_id |
Automatic Code of Service Order |
int(19) |
Dimension |
| dim_date_id |
Expected or rescheduled or completed date |
int(19) |
Dimension |
| dim_accrual_basis_calendar_id |
Automatic Code of Accrual Calendar |
int(19) |
Dimension |
| dim_team_id |
Automatic Code of Team |
int(19) |
Dimension |
Back to topics
Resources - Chemical (PLA_MATERIAL_PROGRAMADO)
| Attribute |
Description |
Type |
Classification |
| information_type |
Enumerated. Indicates the type of information. B = Budgeted, P = Planned, R = Accomplished. |
text(1) |
Degenerate Dimension |
| dim_unit_id |
Automatic Code of Unit |
int(19) |
Dimension |
| dim_process_id |
Automatic Code of Process |
int(19) |
Dimension |
| dim_plan_id |
Automatic Code of Operational or Budgetary Plan |
int(19) |
Dimension |
| dim_activity_id |
Automatic Code of Activity |
int(19) |
Dimension |
| dim_operation_id |
Automatic Code of Operation |
int(19) |
Dimension |
| dim_measure_unit_id |
Automatic Code of Measurement Unint, Dividend of Productivity Template |
int(19) |
Dimension |
| programed_operation_code |
Automatic Code of Scheduled Operation |
int(19) |
Degenerate Dimension |
| dim_prescription_id |
Automatic Code of Prescription |
int(19) |
Dimension |
| dim_stand_id |
Stand ID |
int(19) |
Dimension |
| productivity_value |
Yield value |
numeric(18,3) |
Degenerate Dimension |
| dim_material_id |
Automatic Code of Material |
int(19) |
Dimension |
| total_material |
Material Quantity |
numeric(18,6) |
Measure |
| total_cost |
Total material cost |
numeric(18,6) |
Measure |
| dim_work_order_id |
Automatic Code of Service Order |
int(19) |
Dimension |
| dim_date_id |
Expected or rescheduled or completed date |
int(19) |
Dimension |
| dim_accrual_basis_calendar_id |
Automatic Code of Accrual Calendar |
int(19) |
Dimension |
| dim_team_id |
Automatic Code of Team |
int(19) |
Dimension |
Back to topics
Follow-ups - Planting Summary (VW_PLA_RESUMO_PLANTIO)
| Attribute |
Description |
Type |
Classification |
| followup_id |
Automatic Code of Follow-up |
int(12) |
Degenerate Dimension |
| followup_status |
Follow-up Status. I=Inserted; A=Approved; R=Not approved; E=In Analysis; C=Canceled |
text(1) |
Degenerate Dimension |
| dim_stand_id |
Stand |
int(19) |
Dimension |
| dim_region_id |
Property ID |
int(19) |
Dimension |
| dim_project_id |
Tract |
int(19) |
Dimension |
| stand_code |
Stand key |
text(24) |
Degenerate Dimension |
| activity_type |
Activity Type P=Planting; R=Replanting |
text(1) |
Degenerate Dimension |
| dim_operation_id |
Automatic Code of Operation |
int(19) |
Dimension |
| dim_date_id |
Operation Date |
int(19) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(19) |
Dimension |
| dim_spacing_id |
Space |
int(19) |
Dimension |
| dim_material_id |
Material used |
int(19) |
Dimension |
| amount_material |
Quantity of material used |
numeric(18,5) |
Measure |
| amount_material_descarded |
Quantity of seedlings discarded |
numeric(18,5) |
Measure |
| dim_motive_id |
reason for disposal |
int(19) |
Dimension |
| stand_area |
Stand area |
numeric(18,2) |
Measure |
| planting_area |
Operated Area |
numeric(18,2) |
Measure |
| dim_unit_id |
Automatic Code of Business Unit |
int(19) |
Dimension |
Back to topics
Scheduled operations (PLA_OPERACAO_PROGRAMADA)
| Attribute |
Description |
Type |
Classification |
| INFORMATION_TYPE |
Enumerated. Indicates the type of information. B = Budgeted, P = Planned, R = Accomplished. |
text(1) |
Degenerate Dimension |
| PROGRAMED_OPERATION_CODE |
Automatic Code of Scheduled Operation |
int(10) |
Degenerate Dimension |
| DIM_UNIT_ID |
Automatic Code of Business Unit |
int(10) |
Dimension |
| DIM_OPERATION_ID |
Automatic Code of Operation |
int(10) |
Dimension |
| DIM_ACTIVITY_ID |
Automatic Code of Activity |
int(10) |
Dimension |
| DIM_PROCESS_ID |
Process Code |
int(10) |
Dimension |
| DIM_PLAN_ID |
Operational or Budgetary Plan Code |
int(10) |
Dimension |
| DIM_PRESCRIPTION_ID |
Automatic Code of Prescription |
int(10) |
Dimension |
| DIM_STAND_ID |
Stand ID |
int(10) |
Dimension |
| DIM_MANAGEMENT_UNIT_ID |
Automatic Code of Management Unit |
int(10) |
Dimension |
| DIM_DATE_ID |
Best expected date |
int(10) |
Dimension |
| DIM_ACCRUAL_BASIS_CALENDAR_ID |
Automatic Code of Accrual Calendar |
int(10) |
Dimension |
| OPERATION_PRODUCTION |
Operation Quantity |
float |
Measure |
| OPERATION_EQUIPMENT_COST |
Total equipment costs |
float |
Measure |
| OPERATION_MATERIAL_COST |
Total material cost |
float |
Measure |
| OPERATION_LABOR_COST |
Total worker cost |
float |
Measure |
| OPERATION_COST |
Operation Cost, when paid per operation and not per resources |
float |
Measure |
| ROAD_ID |
Planned Road |
int(10) |
Degenerate Dimension |
| ROAD_LENGTH_SCHEDULED |
Planned Length of Road |
numeric(18,4) |
Degenerate Dimension |
| UNITARY_OPERATION_PRICE |
Transaction unit value |
float |
Measure |
| PERCENTAGE_DONE |
Operation completion percentage |
float |
Measure |
| FLAG_CLOSED_STAND |
Flag Field closed (operation completed) |
float |
Degenerate Dimension |
| DIM_PRESCRIPTION_PHASE_ID |
Automatic Code of Prescription Phase |
int(10) |
Dimension |
| DIM_WORK_ORDER_ID |
Automatic Code of Service Order |
int(10) |
Dimension |
| DIM_PRODUCTIVITY_CLASS_ID |
Productivity scale |
int(10) |
Dimension |
Back to topics
Operational efficiency of the equipments (daily) (CTL_BOLETIM_COLHEITA)
| Attribute |
Description |
Type |
Classification |
| dim_macro_region_id |
Fund (when applicable) |
numeric(8,0) |
Dimension |
| dim_region_id |
Property |
numeric(8,0) |
Dimension |
| dim_project_id |
Tract |
numeric(8,0) |
Dimension |
| dim_stand_block_id |
Compartment (when applicable) |
numeric(8,0) |
Dimension |
| dim_stand_id |
Stand |
numeric(8,0) |
Dimension |
| dim_management_unit_id |
Management Unit |
numeric(8,0) |
Dimension |
| dim_operation_group_id |
Operation Group |
numeric(8,0) |
Dimension |
| dim_activity_id |
Activity |
numeric(8,0) |
Dimension |
| dim_operation_id |
Operation |
numeric(8,0) |
Dimension |
| dim_productivity_class_id |
Productivity scale |
numeric(8,0) |
Dimension |
| dim_supplier_id |
Supplier |
numeric(8,0) |
Dimension |
| dim_work_team_id |
Operation team |
numeric(8,0) |
Dimension |
| dim_equipment_class_id |
Equipment Class |
numeric(8,0) |
Dimension |
| dim_equipment_model_id |
Equipment Family |
numeric(8,0) |
Dimension |
| dim_equipment_id |
Equipment |
numeric(8,0) |
Dimension |
| dim_operation_date_id |
Operation Date |
numeric(8,0) |
Dimension |
| mechanical_availability_goal |
Mechanical availability goal (per equipment) |
numeric(10,2) |
Measure |
| operational_efficiency_goal |
Operational efficiency goal (per operation front) |
numeric(10,2) |
Measure |
| volume_per_tree |
Volume per tree (calculated as volume / number of trees) |
numeric(5,2) |
Measure |
| volume_per_tree_or_trip |
Volume per tree per trip (calculated as volume / number of trees / trips) |
numeric(5,2) |
Measure |
| volume_per_operated_hour |
Volume per hour (calculated as volume / operation duration) |
numeric(8,2) |
Measure |
| number_of_trees |
Number of Trees |
numeric(10,2) |
Measure |
| extraction_average_distance |
Average Forwarding Distance (calculated as Average Forwarding Distance - Weighted / Number of Trees / Trips) |
numeric(10,2) |
Measure |
| extraction_weighted_average_distance |
Average forwarding distance - weighted by number of trees / trips |
numeric(18,2) |
Measure |
| number_of_trees_or_trips |
Number of Trees / Trips |
numeric(10,2) |
Measure |
| volume |
Operated volume (with adjustments) |
numeric(18,2) |
Measure |
| operated_time |
Operated duration |
numeric(10,2) |
Measure |
| maintenance_downtime |
Maintenance downtime |
numeric(10,2) |
Measure |
| operational_downtime |
Operational downtime |
numeric(10,2) |
Measure |
| total_downtime |
Total Downtime Duration |
numeric(10,2) |
Measure |
| total_time |
Total duration |
numeric(10,2) |
Measure |
| operational_efficiency_index |
Operational efficiency indicator (calculated as Hours Operated / (Hours Operated + Operating Downtime)) |
numeric(5,2) |
Measure |
| mechanical_availability_index |
Mechanical Availability Indicator (calculated as (Hours Operated + Operating Downtime) / Total Duration) |
numeric(5,2) |
Measure |
| utilization_tax_index |
Utilization rate indicator (calculated as Hours Operated / Total Duration) |
numeric(5,2) |
Measure |
Back to topics
Harvesting follow-ups (CTL_BOLETIM_COLHEITA)
| Attribute |
Description |
Type |
Classification |
| DIM_MACRO_REGION_ID |
Fund (when applicable) |
int(10) |
Dimension |
| DIM_REGION_ID |
Property |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Tract |
int(10) |
Dimension |
| DIM_STAND_BLOCK_ID |
Compartment (when applicable) |
int(10) |
Dimension |
| DIM_STAND_ID |
Stand |
int(10) |
Dimension |
| DIM_MANAGEMENT_UNIT_ID |
Management Unit |
int(10) |
Dimension |
| DIM_PLAN_ID |
Plan |
int(10) |
Dimension |
| DIM_SLOPE_ID |
Slope |
int(10) |
Dimension |
| DIM_PLANTING_ESTABLISHMENT_SYSTEM_ID |
Automatic Code of Regime |
int(10) |
Dimension |
| DISTANCE |
Transport distance |
float |
Measure |
| STAND_AGE_ON_HARVEST |
Age at Cut |
float |
Measure |
| DENSITY |
Density Value |
float |
Measure |
| DIM_TIMBER_DENSITY_CLASS_ID |
Density Class |
int(10) |
Dimension |
| DIM_WORK_SCHEME_ID |
Harvest Work Scheme |
int(10) |
Dimension |
| DIM_PLANNED_PRODUCT_ID |
Scheduled Product |
int(10) |
Dimension |
| DIM_REPORTED_PRODUCT_TYPE_ID |
Reported Product Type |
int(10) |
Dimension |
| DIM_REPORTED_PRODUCT_ID |
Reported Product |
int(10) |
Dimension |
| DIM_REPORTED_OPERATION_GROUP_ID |
Appointed Operation group |
int(10) |
Dimension |
| DIM_ACTIVITY_ID |
Reported Activity |
int(10) |
Dimension |
| DIM_OPERATION_ID |
Reported Operation |
int(10) |
Dimension |
| DIM_OPERATION_FINISH_DATE_ID |
OTC Date |
int(10) |
Dimension |
| DIM_PRODUCTIVITY_CLASS_ID |
Productivity scale |
int(10) |
Dimension |
| BASE_MACHINE_DOWNTIME_INDICATOR |
Base machine downtime? |
text(1) |
Degenerate Dimension |
| DIM_BASE_MACHINE_WORKTIME_TYPE_ID |
Downtime type in the operation report |
int(10) |
Dimension |
| DIM_BASE_MACHINE_WORKTIME_CLASS_ID |
Downtime Class in the Follow-up |
int(10) |
Dimension |
| DIM_BASE_MACHINE_WORKTIME_CLASSIFICATION_ID |
Reporting downtime |
int(10) |
Dimension |
| HEAD_DOWNTIME_INDICATOR |
Equipment head downtime? |
text(1) |
Degenerate Dimension |
| DIM_HEAD_WORKTIME_TYPE_ID |
Equipment head downtime type |
int(10) |
Dimension |
| DIM_HEAD_WORKTIME_CLASS_ID |
Downtime Class of Equipment Head |
int(10) |
Dimension |
| DIM_HEAD_WORKTIME_CLASSIFICATION_ID |
Equipment head downtime |
int(10) |
Dimension |
| DIM_WORK_ORDER_ID |
Service Order |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Supplier |
int(10) |
Dimension |
| DIM_WORK_TEAM_ID |
Operation team |
int(10) |
Dimension |
| DIM_WORK_SHIFT_ID |
Shift |
int(10) |
Dimension |
| DIM_OPERATOR_EMPLOYEE_ID |
Operator Employee |
int(10) |
Dimension |
| DIM_TYPIST_EMPLOYEE_ID |
Typing employee |
int(10) |
Dimension |
| DIM_BASE_MACHINE_EQUIPMENT_CLASS_ID |
Base Machine Equipment Class |
int(10) |
Dimension |
| DIM_BASE_MACHINE_EQUIPMENT_MODEL_ID |
Base machine equipment family |
int(10) |
Dimension |
| DIM_BASE_MACHINE_EQUIPMENT_ID |
Equipment base machine |
int(10) |
Dimension |
| DIM_HEAD_EQUIPMENT_CLASS_ID |
Head Equipment Class |
int(10) |
Dimension |
| DIM_HEAD_EQUIPMENT_MODEL_ID |
Headstock family |
int(10) |
Dimension |
| DIM_HEAD_EQUIPMENT_ID |
Equipment head |
int(10) |
Dimension |
| INITIAL_HOURMETER |
Initial hour meter |
float |
Measure |
| FINAL_HOURMETER |
Final hour meter |
float |
Measure |
| INITIAL_ODOMETER |
Initial odometer |
float |
Measure |
| FINAL_ODOMETER |
Final odometer |
float |
Measure |
| REPORT_DURATION |
Duration of entry note |
float |
Measure |
| DIM_OPERATION_DATE_ID |
Operation Date |
int(10) |
Dimension |
| DIM_INITIAL_DATE_ID |
Start date |
int(10) |
Dimension |
| INITIAL_HOUR |
Start Time |
int(10) |
Measure |
| INITIAL_MINUTE |
Start minute |
int(10) |
Measure |
| DIM_FINAL_DATE_ID |
End date |
int(10) |
Dimension |
| FINAL_HOUR |
End Time |
int(10) |
Measure |
| FINAL_MINUTE |
End minute |
int(10) |
Measure |
| REPORTED_VOLUME |
Reporeted Volume |
float |
Measure |
| WRITE_OFF_VOLUME |
Other Movements Volume |
float |
Measure |
| NUMBER_OF_TREES_OR_TRIPS |
Number of Trees / Trips |
float |
Measure |
| VOLUME_PER_TREE_OR_TRIP |
Volume per tree per trip |
float |
Measure |
| COST |
Real cost |
float |
Measure |
| DIM_PREVIOUS_OPERATION_ID |
Previous Operation |
int(10) |
Dimension |
| DIM_PREVIOUS_SUPPLIER_ID |
Previous Supplier |
int(10) |
Dimension |
| DIM_PREVIOUS_PRODUCT_ID |
Previous Product |
int(10) |
Dimension |
| REPORT_STATUS |
Follow-up Status <I-Entered, P-Processed, C-Payment Calculated, G-Payment Confirmed> |
text(1) |
Degenerate Dimension |
| DIM_CURRENCY_TYPE_ID |
Document currency. |
int(10) |
Dimension |
Back to topics
Harvest follow-ups, transport (from field) follow-ups and adjustments (CTL_BOLETIM_COLHEITA)
| Attribute |
Description |
Type |
Classification |
| DIM_MACRO_REGION_ID |
Fund (when applicable) |
int(10) |
Dimension |
| DIM_REGION_ID |
Property |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Tract |
int(10) |
Dimension |
| DIM_STAND_BLOCK_ID |
Compartment (when applicable) |
int(10) |
Dimension |
| DIM_STAND_ID |
Stand |
int(10) |
Dimension |
| DIM_MANAGEMENT_UNIT_ID |
Management Unit |
int(10) |
Dimension |
| DIM_PLAN_ID |
Plan |
int(10) |
Dimension |
| DIM_SLOPE_ID |
Slope |
int(10) |
Dimension |
| DIM_PLANTING_ESTABLISHMENT_SYSTEM_ID |
Automatic Code of Regime |
int(10) |
Dimension |
| DIM_CONSOLIDATED_FOLLOW_UP_ORIGIN_ID |
Follow-up Type |
int(10) |
Dimension |
| DISTANCE |
Transport distance |
float |
Measure |
| STAND_AGE_ON_HARVEST |
Age at Cut |
float |
Measure |
| DENSITY |
Density Value |
float |
Measure |
| DIM_TIMBER_DENSITY_CLASS_ID |
Density Class |
int(10) |
Dimension |
| DIM_WORK_SCHEME_ID |
Harvest Work Scheme |
int(10) |
Dimension |
| DIM_PLANNED_PRODUCT_ID |
Scheduled Product |
int(10) |
Dimension |
| DIM_REPORTED_PRODUCT_TYPE_ID |
Reported Product Type |
int(10) |
Dimension |
| DIM_REPORTED_PRODUCT_ID |
Reported Product |
int(10) |
Dimension |
| DIM_REPORTED_OPERATION_GROUP_ID |
Appointed Operation group |
int(10) |
Dimension |
| DIM_ADJUSTER_OPERATION_GROUP_ID |
Adjusting Operation Group |
int(10) |
Dimension |
| DIM_ACTIVITY_ID |
Reported Activity |
int(10) |
Dimension |
| DIM_OPERATION_ID |
Reported Operation |
int(10) |
Dimension |
| DIM_OPERATION_FINISH_DATE_ID |
OTC Date |
int(10) |
Dimension |
| DIM_PRODUCTIVITY_CLASS_ID |
Productivity scale |
int(10) |
Dimension |
| BASE_MACHINE_DOWNTIME_INDICATOR |
Base machine downtime? |
text(1) |
Degenerate Dimension |
| DIM_BASE_MACHINE_WORKTIME_TYPE_ID |
Downtime type in the operation report |
int(10) |
Dimension |
| DIM_BASE_MACHINE_WORKTIME_CLASS_ID |
Downtime Class in the Follow-up |
int(10) |
Dimension |
| DIM_BASE_MACHINE_WORKTIME_CLASSIFICATION_ID |
Reporting downtime |
int(10) |
Dimension |
| HEAD_DOWNTIME_INDICATOR |
Equipment head downtime? |
text(1) |
Degenerate Dimension |
| DIM_HEAD_WORKTIME_TYPE_ID |
Equipment head downtime type |
int(10) |
Dimension |
| DIM_HEAD_WORKTIME_CLASS_ID |
Downtime Class of Equipment Head |
int(10) |
Dimension |
| DIM_HEAD_WORKTIME_CLASSIFICATION_ID |
Equipment head downtime |
int(10) |
Dimension |
| DIM_WORK_ORDER_ID |
Service Order |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Supplier |
int(10) |
Dimension |
| DIM_WORK_TEAM_ID |
Operation team |
int(10) |
Dimension |
| DIM_WORK_SHIFT_ID |
Shift |
int(10) |
Dimension |
| DIM_OPERATOR_EMPLOYEE_ID |
Operator Employee |
int(10) |
Dimension |
| DIM_TYPIST_EMPLOYEE_ID |
Typing employee |
int(10) |
Dimension |
| DIM_BASE_MACHINE_EQUIPMENT_CLASS_ID |
Base Machine Equipment Class |
int(10) |
Dimension |
| DIM_BASE_MACHINE_EQUIPMENT_MODEL_ID |
Base machine equipment family |
int(10) |
Dimension |
| DIM_BASE_MACHINE_EQUIPMENT_ID |
Equipment base machine |
int(10) |
Dimension |
| DIM_HEAD_EQUIPMENT_CLASS_ID |
Head Equipment Class |
int(10) |
Dimension |
| DIM_HEAD_EQUIPMENT_MODEL_ID |
Headstock family |
int(10) |
Dimension |
| DIM_HEAD_EQUIPMENT_ID |
Equipment head |
int(10) |
Dimension |
| INITIAL_HOURMETER |
Initial hour meter |
float |
Measure |
| FINAL_HOURMETER |
Final hour meter |
float |
Measure |
| INITIAL_ODOMETER |
Initial odometer |
float |
Measure |
| FINAL_ODOMETER |
Final odometer |
float |
Measure |
| REPORT_DURATION |
Duration of entry note |
float |
Measure |
| DIM_OPERATION_DATE_ID |
Operation Date |
int(10) |
Dimension |
| DIM_INITIAL_DATE_ID |
Start date |
int(10) |
Dimension |
| INITIAL_HOUR |
Start Time |
int(10) |
Measure |
| INITIAL_MINUTE |
Start minute |
int(10) |
Measure |
| DIM_FINAL_DATE_ID |
End date |
int(10) |
Dimension |
| FINAL_HOUR |
End Time |
int(10) |
Measure |
| FINAL_MINUTE |
End minute |
int(10) |
Measure |
| REPORTED_VOLUME |
Reporeted Volume |
float |
Measure |
| ADJUSTED_VOLUME |
Adjusted Volume |
float |
Measure |
| EFICIENCY_VOLUME |
Efficiency Volume |
float |
Measure |
| EFECTIVE_ADJUSTED_VOLUME |
Effective adjusted volume (difference between adjusted and reported) |
float |
Measure |
| WRITE_OFF_VOLUME |
Other Movements Volume |
float |
Measure |
| NUMBER_OF_TREES_OR_TRIPS |
Number of Trees / Trips |
float |
Measure |
| VOLUME_PER_TREE_OR_TRIP |
Volume per tree per trip |
float |
Measure |
| COST |
Real cost |
float |
Measure |
| DIM_PREVIOUS_OPERATION_ID |
Previous Operation |
int(10) |
Dimension |
| DIM_PREVIOUS_SUPPLIER_ID |
Previous Supplier |
int(10) |
Dimension |
| DIM_PREVIOUS_PRODUCT_ID |
Previous Product |
int(10) |
Dimension |
| REPORT_STATUS |
Follow-up Status <I-Entered, P-Processed, C-Payment Calculated, G-Payment Confirmed> |
text(1) |
Degenerate Dimension |
| ADJUSTED_PERIOD_VOLUME |
Adjusted period volume |
float |
Measure |
| DIM_CURRENCY_TYPE_ID |
Document currency. |
int(10) |
Dimension |
Back to topics
Harvesting sequence (PLA_COLHEITA_PROGRAMADA)
| Attribute |
Description |
Type |
Classification |
| dim_macro_region_id |
Fund (when applicable) |
numeric(8,0) |
Dimension |
| dim_region_id |
Property |
numeric(8,0) |
Dimension |
| dim_project_id |
Tract |
numeric(8,0) |
Dimension |
| dim_stand_block_id |
Compartment (when applicable) |
numeric(8,0) |
Dimension |
| dim_stand_id |
Stand |
numeric(8,0) |
Dimension |
| dim_genus_id |
Genre |
numeric(8,0) |
Dimension |
| dim_specie_id |
Species |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Genetic material |
numeric(8,0) |
Dimension |
| dim_management_unit_id |
Management Unit |
numeric(8,0) |
Dimension |
| dim_plan_id |
Plan |
numeric(8,0) |
Dimension |
| plan_type |
Plan Type <P-Operational, R-Budget> |
text(1) |
Degenerate Dimension |
| dim_slope_id |
Slope |
numeric(8,0) |
Dimension |
| dim_work_scheme_id |
Harvest Work Scheme |
numeric(8,0) |
Dimension |
| dim_product_id |
Main Product |
numeric(8,0) |
Dimension |
| dim_future_planting_stablishment_system_id |
Future Regime |
numeric(8,0) |
Dimension |
| stand_area |
Stand area |
numeric(7,2) |
Measure |
| dim_harvest_reference_date_id |
Harvest - reference date |
numeric(8,0) |
Dimension |
| planned_percentage |
Scheduled Percentage |
numeric(7,2) |
Measure |
| stand_age_on_harvest |
Cut Age |
numeric(7,2) |
Measure |
| density |
Density |
numeric(7,2) |
Measure |
| extrative |
Extractive |
numeric(7,2) |
Measure |
| distance |
Distance |
numeric(10,2) |
Measure |
| has_fsc_indicator |
FSC? |
text(64) |
Degenerate Dimension |
| has_cerflor_indicator |
CERFLOR? |
text(64) |
Degenerate Dimension |
| work_scheme_product_volume |
Volume per work scheme and harvest product |
numeric(10,2) |
Measure |
| stand_inventory_volume |
Stand - Inventory volume |
numeric(10,2) |
Measure |
| unitary_tree_volume |
Unit Volume |
numeric(10,3) |
Measure |
| tree_per_area |
Hectore Tree |
numeric(10,3) |
Measure |
| stand_productivity |
Forest productivity (m3 / ha) |
numeric(10,3) |
Measure |
| cut_start_indicator |
Started cutting? |
numeric(1,0) |
Degenerate Dimension |
| dim_cut_start_date_id |
Harvest - Start date |
numeric(8,0) |
Dimension |
| cutting_volume |
Harvested Volume |
numeric(18,2) |
Measure |
| cutting_write_off |
Other movements at the harvest at the base date |
numeric(18,2) |
Measure |
| cutting_stock |
Current cutting timber stock |
numeric(18,2) |
Measure |
| cut_finish_indicator |
End of Cut? |
numeric(1,0) |
Degenerate Dimension |
| dim_cut_finish_date_id |
Harvest - End date |
numeric(8,0) |
Dimension |
| days_in_cutting |
Cutting days |
numeric(22,0) |
Measure |
| extraction_start_indicator |
Forward started? |
numeric(1,0) |
Degenerate Dimension |
| dim_extraction_start_date_id |
Forward - Start date |
numeric(8,0) |
Dimension |
| extraction_volume |
Forwarded Volume |
numeric(18,2) |
Measure |
| extraction_write_off |
Other forwarding movements |
numeric(18,2) |
Measure |
| extraction_stock |
Current forward timber stock |
numeric(18,2) |
Measure |
| extraction_finish_indicator |
End of Forward? |
numeric(1,0) |
Degenerate Dimension |
| dim_extraction_finish_date_id |
Forward - End date |
numeric(8,0) |
Dimension |
| days_in_extraction |
Forwarding days |
numeric(22,0) |
Measure |
| transport_start_indicator |
Started transport? |
numeric(1,0) |
Degenerate Dimension |
| dim_transport_start_date_id |
Transport - Start date |
numeric(8,0) |
Dimension |
| transport_volume |
Transported Volume |
numeric(18,2) |
Measure |
| transport_finish_indicator |
End of Transport? |
numeric(1,0) |
Degenerate Dimension |
| dim_transport_finish_date_id |
Transport - End date |
numeric(8,0) |
Dimension |
| days_in_transport |
Transporting days |
numeric(22,0) |
Measure |
| days_after_cut |
Post Cutting Time |
numeric(22,0) |
Measure |
| harvest_status |
Harvest Status <R-Budget, P-Planned, C-Harvest started, CF-Harvest finished, B-Extraction started, T-Transport started, TF-Transport finished> |
text(2) |
Degenerate Dimension |
Back to topics
Scheduled operations of harvest (PLA_OPERACAO_PROGRAMADA)
| Attribute |
Description |
Type |
Classification |
| dim_macro_region_id |
Fund (when applicable) |
numeric(8,0) |
Dimension |
| dim_region_id |
Property |
numeric(8,0) |
Dimension |
| dim_project_id |
Tract |
numeric(8,0) |
Dimension |
| dim_stand_block_id |
Compartment (when applicable) |
numeric(8,0) |
Dimension |
| dim_stand_id |
Stand |
numeric(8,0) |
Dimension |
| dim_management_unit_id |
Management Unit |
numeric(8,0) |
Dimension |
| dim_plan_id |
Plan |
numeric(8,0) |
Dimension |
| dim_reference_date_id |
Reference date (performed, rescheduled or expected) |
numeric(8,0) |
Dimension |
| dim_operation_group_id |
Operation Group |
numeric(8,0) |
Dimension |
| dim_activity_id |
Activity |
numeric(8,0) |
Dimension |
| dim_operation_id |
Operation |
numeric(8,0) |
Dimension |
| dim_work_scheme_id |
Work Scheme |
numeric(8,0) |
Dimension |
| dim_supplier_id |
OS Supplier |
numeric(8,0) |
Dimension |
| dim_contract_id |
Contract (of Service Order) |
numeric(8,0) |
Dimension |
| dim_productivity_class_id |
Productivity scale |
numeric(8,0) |
Dimension |
| budget_produccion |
Budgeted production |
numeric(11,2) |
Measure |
| planned_produccion |
Scheduled Production |
numeric(11,2) |
Measure |
| real_produccion |
Executed production |
numeric(11,2) |
Measure |
| budget_hours |
Budgeted Hours |
numeric(11,2) |
Measure |
| planned_hours |
Scheduled Hours |
numeric(11,2) |
Measure |
| real_hours |
Hours performed |
numeric(11,2) |
Measure |
| budget_cost |
Bugetary cost |
numeric(11,2) |
Measure |
| planned_cost |
Scheduled cost |
numeric(11,2) |
Measure |
| real_cost |
Performed cost |
numeric(11,2) |
Measure |
Back to topics
Scheduled resources of harvest (PLA_OPERACAO_PROGRAMADA)
| Attribute |
Description |
Type |
Classification |
| dim_macro_region_id |
Fund (when applicable) |
numeric(8,0) |
Dimension |
| dim_region_id |
Property |
numeric(8,0) |
Dimension |
| dim_project_id |
Tract |
numeric(8,0) |
Dimension |
| dim_stand_block_id |
Compartment (when applicable) |
numeric(8,0) |
Dimension |
| dim_stand_id |
Stand |
numeric(8,0) |
Dimension |
| dim_management_unit_id |
Management Unit |
numeric(8,0) |
Dimension |
| dim_plan_id |
Plan |
numeric(8,0) |
Dimension |
| dim_reference_date_id |
Reference date (performed, rescheduled or expected) |
numeric(8,0) |
Dimension |
| dim_operation_group_id |
Operation Group |
numeric(8,0) |
Dimension |
| dim_activity_id |
Activity |
numeric(8,0) |
Dimension |
| dim_operation_id |
Operation |
numeric(8,0) |
Dimension |
| dim_work_scheme_id |
Work Scheme |
numeric(8,0) |
Dimension |
| resource_type |
Resource Type <E-Equipment, M-Material, S-Service, C-Position> |
text(1) |
Degenerate Dimension |
| dim_equipment_class_id |
Equipment Class |
numeric(8,0) |
Dimension |
| dim_equipment_model_id |
Equipment Family |
numeric(8,0) |
Dimension |
| dim_material_id |
Material |
numeric(8,0) |
Dimension |
| dim_service_id |
Service |
numeric(8,0) |
Dimension |
| dim_position_id |
Position |
numeric(8,0) |
Dimension |
| budget_amount |
Budgeted Resource Quantity |
numeric(11,2) |
Measure |
| planned_amount |
Scheduled Resource Quantity |
numeric(11,2) |
Measure |
| real_amount |
Actual Quantity of Resource |
numeric(11,2) |
Measure |
| budget_hours |
Budgeted Resource Hours |
numeric(11,2) |
Measure |
| planned_hours |
Resource Scheduled Hours |
numeric(11,2) |
Measure |
| real_hours |
Actual Resource Hours |
numeric(11,2) |
Measure |
| budget_cost |
Bugetary resource cost |
numeric(11,2) |
Measure |
| planned_cost |
Scheduled resource cost |
numeric(11,2) |
Measure |
| real_cost |
Real resource cost |
numeric(11,2) |
Measure |
Back to topics
¶ FACT_HARV_STOCK_BY_COLUMNS
Harvest stock per column (CTL_MOVIMENTACAO_ESTOQUE)
| Attribute |
Description |
Type |
Classification |
| dim_base_date_id |
Base Date |
numeric(8,0) |
Dimension |
| dim_macro_region_id |
Fund (when applicable) |
numeric(8,0) |
Dimension |
| dim_region_id |
Property |
numeric(8,0) |
Dimension |
| dim_project_id |
Tract |
numeric(8,0) |
Dimension |
| dim_stand_block_id |
Compartment (when applicable) |
numeric(8,0) |
Dimension |
| dim_stand_id |
Stand |
numeric(8,0) |
Dimension |
| stand_area |
Stand area |
numeric(7,2) |
Measure |
| dim_genus_id |
Genre |
numeric(8,0) |
Dimension |
| dim_specie_id |
Species |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Genetic material |
numeric(8,0) |
Dimension |
| dim_management_unit_id |
Management Unit |
numeric(8,0) |
Dimension |
| dim_product_type_id |
Product Type |
numeric(8,0) |
Dimension |
| dim_product_id |
Product |
numeric(8,0) |
Dimension |
| stand_age_on_harvest |
Cut Age |
numeric(7,2) |
Measure |
| density |
Density |
numeric(7,2) |
Measure |
| extrative |
Extractive |
numeric(7,2) |
Measure |
| distance |
Distance |
numeric(10,2) |
Measure |
| has_fsc_indicator |
FSC? |
text(64) |
Degenerate Dimension |
| has_cerflor_indicator |
CERFLOR? |
text(64) |
Degenerate Dimension |
| stand_inventory_volume |
Stand - Inventory volume |
numeric(10,2) |
Measure |
| cut_start_indicator |
Started cutting? |
numeric(1,0) |
Degenerate Dimension |
| dim_cut_start_date_id |
Harvest - Start date |
numeric(8,0) |
Dimension |
| cutting_volume_on_base_date |
Harvested volume at the base date |
numeric(18,2) |
Measure |
| cutting_volume_acumulated |
Accumulated Harvested Volume |
numeric(18,2) |
Measure |
| cutting_write_off_on_base_date |
Other movements at the harvest at the base date |
numeric(18,2) |
Measure |
| cutting_write_off_acumulated |
Other accumulated movements at the harvest |
numeric(18,2) |
Measure |
| cutting_stock |
Current cutting timber stock |
numeric(18,2) |
Measure |
| cut_finish_indicator |
End of Cut? |
numeric(1,0) |
Degenerate Dimension |
| dim_cut_finish_date_id |
Harvest - End date |
numeric(8,0) |
Dimension |
| days_in_cutting |
Cutting days |
numeric(22,0) |
Measure |
| extraction_start_indicator |
Forward started? |
numeric(1,0) |
Degenerate Dimension |
| dim_extraction_start_date_id |
Forward - Start date |
numeric(8,0) |
Dimension |
| extraction_volume_on_base_date |
Forwarded volume at the base date |
numeric(18,2) |
Measure |
| extraction_volume_acumulated |
Accumulated Forwarded Volume |
numeric(18,2) |
Measure |
| extraction_write_off_on_base_date |
Other movements at the forward at the base date |
numeric(18,2) |
Measure |
| extraction_write_off_acumulated |
Accumulated - Other forwarding movements |
numeric(18,2) |
Measure |
| extraction_stock |
Forwarded timber stock |
numeric(18,2) |
Measure |
| extraction_finish_indicator |
End of Forward? |
numeric(1,0) |
Degenerate Dimension |
| dim_extraction_finish_date_id |
Forward - End date |
numeric(8,0) |
Dimension |
| days_in_extraction |
Forwarding days |
numeric(22,0) |
Measure |
| transport_start_indicator |
Started transport? |
numeric(1,0) |
Degenerate Dimension |
| dim_transport_start_date_id |
Transport - Start date |
numeric(8,0) |
Dimension |
| transport_volume_on_base_date |
Transported volume at the base date |
numeric(18,2) |
Measure |
| transport_volume_acumulated |
Accumulated Transported Volume |
numeric(18,2) |
Measure |
| transport_finish_indicator |
End of Transport? |
numeric(1,0) |
Degenerate Dimension |
| dim_transport_finish_date_id |
Transport - End date |
numeric(8,0) |
Dimension |
| days_in_transport |
Transporting days |
numeric(22,0) |
Measure |
| days_after_cut |
Post Cutting Time |
numeric(22,0) |
Measure |
| dim_planting_stablishment_system_id |
Regime |
numeric(8,0) |
Dimension |
Back to topics
Harvest stock per lines (CTL_MOVIMENTACAO_ESTOQUE)
| Attribute |
Description |
Type |
Classification |
| dim_base_date_id |
Base Date |
numeric(8,0) |
Dimension |
| dim_macro_region_id |
Fund (when applicable) |
numeric(8,0) |
Dimension |
| dim_region_id |
Property |
numeric(8,0) |
Dimension |
| dim_project_id |
Tract |
numeric(8,0) |
Dimension |
| dim_stand_block_id |
Compartment (when applicable) |
numeric(8,0) |
Dimension |
| dim_stand_id |
Stand |
numeric(8,0) |
Dimension |
| stand_area |
Stand area |
numeric(7,2) |
Measure |
| dim_genus_id |
Genre |
numeric(8,0) |
Dimension |
| dim_specie_id |
Species |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Genetic material |
numeric(8,0) |
Dimension |
| dim_management_unit_id |
Management Unit |
numeric(8,0) |
Dimension |
| dim_operation_group_id |
Operation Group |
numeric(8,0) |
Dimension |
| dim_activity_id |
Activity |
numeric(8,0) |
Dimension |
| dim_operation_id |
Operation |
numeric(8,0) |
Dimension |
| dim_supplier_id |
Supplier |
numeric(8,0) |
Dimension |
| dim_field_pile_id |
Pile |
numeric(8,0) |
Dimension |
| dim_product_type_id |
Product Type |
numeric(8,0) |
Dimension |
| dim_product_id |
Product |
numeric(8,0) |
Dimension |
| stand_age_on_harvest |
Cut Age |
numeric(7,2) |
Measure |
| density |
Density |
numeric(7,2) |
Measure |
| extrative |
Extractive |
numeric(7,2) |
Measure |
| distance |
Distance |
numeric(10,2) |
Measure |
| has_fsc_indicator |
FSC? |
text(64) |
Degenerate Dimension |
| has_cerflor_indicator |
CERFLOR? |
text(64) |
Degenerate Dimension |
| stand_inventory_volume |
Stand - Inventory volume |
numeric(10,2) |
Measure |
| dim_operation_start_date_id |
Operation - Start date |
numeric(8,0) |
Dimension |
| operation_volume_on_base_date |
Volume at the base date |
numeric(18,2) |
Measure |
| operation_volume_acumulated |
Accumulated Volume |
numeric(18,2) |
Measure |
| operation_write_off_on_base_date |
Other movements - base date |
numeric(18,2) |
Measure |
| operation_write_off_acumulated |
Other accumulated movements |
numeric(18,2) |
Measure |
| operation_stock |
Stock at the base date |
numeric(18,2) |
Measure |
| operation_finish_indicator |
Operation has CTO? |
numeric(1,0) |
Degenerate Dimension |
| dim_operation_finish_date_id |
OTC Date |
numeric(8,0) |
Dimension |
| transport_finish_indicator |
Transportation own CTO? |
numeric(1,0) |
Degenerate Dimension |
| dim_transport_finish_date_id |
Transport - End date |
numeric(8,0) |
Dimension |
| days_after_cut |
Post Cutting Time |
numeric(22,0) |
Measure |
Back to topics
Average length of stay of trucks in the yard. (TRA_GUIA_CEM)
| Attribute |
Description |
Type |
Classification |
| dim_yard_id |
Woodyard |
numeric(8,0) |
Dimension |
| dim_date_id |
Base Date |
numeric(8,0) |
Dimension |
| dim_transportation_supplier_id |
Transport Operation Provider |
numeric(8,0) |
Dimension |
| dim_composition_type_id |
Set Type |
numeric(8,0) |
Dimension |
| dim_yard_destination_type_id |
Courtyard Destination Type (direct or indirect consumption) |
numeric(8,0) |
Dimension |
| dim_product_type_id |
Source Product Type |
numeric(8,0) |
Dimension |
| dim_product_id |
Origin Product |
numeric(8,0) |
Dimension |
| dim_destination_product_type_id |
Target Product Type |
numeric(8,0) |
Dimension |
| average_yard_time |
Average courtyard time in minutes |
numeric(22,0) |
Measure |
| average_yard_time_truck_quantity |
Number of Trucks |
numeric(22,0) |
Measure |
Back to topics
¶ FACT_STAND_TRANSPORTATION
Transport originated in the field. (TRA_GUIA_CEM)
| Attribute |
Description |
Type |
Classification |
| dim_date_id |
Transportation date |
numeric(8,0) |
Dimension |
| dim_region_id |
Property of the transported stand |
numeric(8,0) |
Dimension |
| dim_project_id |
Tract of the transported stand |
numeric(8,0) |
Dimension |
| dim_stand_id |
Transported stand |
numeric(8,0) |
Dimension |
| dim_ownership_type_id |
Property type of the transported stand |
numeric(8,0) |
Dimension |
| dim_specie_id |
Species of the transported stand |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Genetic material of the transported stand |
numeric(8,0) |
Dimension |
| dim_product_type_id |
Source Product Type |
numeric(8,0) |
Dimension |
| dim_product_id |
Origin Product |
numeric(8,0) |
Dimension |
| dim_origin_locality_id |
Municipality of Stand of origin |
numeric(8,0) |
Dimension |
| dim_transportation_supplier_id |
Transport Operation Provider |
numeric(8,0) |
Dimension |
| dim_composition_type_id |
Set type of transport equipment |
numeric(8,0) |
Dimension |
| dim_destination_yard_id |
Transport Destination Woodyard |
numeric(8,0) |
Dimension |
| dim_destination_locality |
Municipality of the destination courtyard |
numeric(8,0) |
Dimension |
| dim_yard_destination_type_id |
Courtyard Destination Type (direct or indirect consumption) |
numeric(8,0) |
Dimension |
| dim_destination_produtct_type_id |
Target Product Type |
numeric(8,0) |
Dimension |
| stand_transportation_fsc_indicator |
FSC certification indicator |
numeric(1,0) |
Degenerate Dimension |
| stand_transportation_fsc_cw_indicator |
FSC CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| stand_transportation_cerflor_indicator |
CERFLOR certification indicator |
numeric(1,0) |
Degenerate Dimension |
| stand_transportation_cerflor_cw_indicator |
CERFLOR CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| stand_transportation_average_distance |
Average transport distance |
numeric(18,2) |
Measure |
| stand_transportation_volume |
Total volume transported |
numeric(18,5) |
Measure |
| stand_transportation_net_weight |
Total net weight carried |
numeric(18,5) |
Measure |
| stand_transportation_density |
Weighted density by transported volume |
numeric(18,2) |
Measure |
| stand_transportation_age |
Age weighted by transported volume |
numeric(18,2) |
Measure |
| stand_transportation_tac |
Pos-cut time weighted by transported volume |
numeric(18,2) |
Measure |
| stand_transportation_precipitation |
Preciptation weighted by transported volume |
numeric(18,2) |
Measure |
Back to topics
Transportation (TRA_DETALHE_CEM)
| Attribute |
Description |
Type |
Classification |
| DIM_TRANSPORT_ID |
transport |
int(10) |
Dimension |
| TRANSPORT_SERIE |
Transport serie |
text(16) |
Degenerate Dimension |
| TRANSPORT_NUMBER |
Transport number |
error |
Degenerate Dimension |
| START_DATE |
Start date |
datetime |
SCD - Overwrite |
| ARRIVAL_DATE |
Arrival date |
datetime |
SCD - Overwrite |
| DIM_ORIGIN_LOCAL_TYPE_ID |
Origin local type |
int(10) |
Dimension |
| DIM_ORIGIN_YARD_ID |
Origin Yard |
int(10) |
Dimension |
| ORIGIN_BLOCK_NUMBER |
Origin block number |
text(64) |
Degenerate Dimension |
| ORIGIN_PILE_NUMBER |
Origin pile number |
text(16) |
Degenerate Dimension |
| DIM_ORIGIN_LOCALITY_ID |
Origin locality |
int(10) |
Dimension |
| DIM_STAND_ID |
Stand |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Project |
int(10) |
Dimension |
| DIM_REGION_ID |
Region |
int(10) |
Dimension |
| DIM_OWNERSHIP_TYPE_ID |
Ownership type |
int(10) |
Dimension |
| DIM_SPECIE_ID |
Specie |
int(10) |
Dimension |
| DIM_GENETIC_MATERIAL_ID |
Genetic material |
int(10) |
Dimension |
| FSC_INDICATOR |
FSC indicator |
error |
Degenerate Dimension |
| FSC_CW_INDICATOR |
FSC CW indicator |
error |
Degenerate Dimension |
| CERFLOR_INDICATOR |
CERFLOR Indicator |
error |
Degenerate Dimension |
| CERFOR_CW_INDICATOR |
CERFLOR CW indicator |
error |
Degenerate Dimension |
| DIM_DESTINATION_YARD_ID |
Destination yard |
int(10) |
Dimension |
| DIM_DESTINATION_LOCALITY_ID |
Destination municipality |
int(10) |
Dimension |
| DIM_ORIGIN_PRODUCT_TYPE_ID |
Origin Product type |
int(10) |
Dimension |
| DIM_ORIGIN_PRODUCT_ID |
Origin product |
int(10) |
Dimension |
| DIM_DEST_PRODUCT_TYPE_ID |
Destination Product Type |
int(10) |
Dimension |
| WEIGHT_VOLUME_RELATION |
Weight Volume Relation |
numeric(10,2) |
Measure |
| DISTANCE |
Distance |
error |
Measure |
| DIM_COMPOSITION_TYPE_ID |
Composition type |
int(10) |
Dimension |
| DIM_TRANSPORT_EQUIPMENT_ID |
Transport equipment |
int(10) |
Dimension |
| DIM_TRANSPORT_SUPPLIER_ID |
Transport supplier |
int(10) |
Dimension |
| DIM_TRANSPORT_CONTRACT_ID |
Transport contract |
int(10) |
Dimension |
| DIM_LOAD_EQUIPMENT_ID |
Load equipment |
int(10) |
Dimension |
| DIM_LOAD_SUPPLIER_ID |
Load supplier |
int(10) |
Dimension |
| DIM_LOAD_CONTRACT_ID |
Load contract |
int(10) |
Dimension |
| DIM_YARD_DESTINATION_TYPE_ID |
Yard destination type |
error |
Dimension |
| GROSS_WEIGHT |
Gross weight |
error |
Measure |
| TARE_WEIGHT |
Tare weight |
numeric(18,6) |
Measure |
| NET_WEIGHT |
Net weight |
error |
Measure |
| VOLUME |
Volume |
error |
Measure |
| CYCLE_TIME |
Cycle time |
error |
Measure |
| DENSITY |
Density |
error |
Measure |
| AGE |
Age |
error |
Measure |
| TIME_AFTER_CUTTING |
Time after cutting |
error |
Measure |
| PRECIPITATION |
Precipitation |
error |
Measure |
Back to topics
Transportation payments (CTL_ITEM_PROCESSO_PAGAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Operation Date |
error |
Dimension |
| DIM_ORIGIN_LOCAL_TYPE_ID |
Type of Origin Place |
int(10) |
Dimension |
| DIM_STAND_ID |
Stand |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Project |
int(10) |
Dimension |
| DIM_REGION_ID |
Region |
int(10) |
Dimension |
| DIM_OWNERSHIP_TYPE_ID |
Type of Land Use |
int(10) |
Dimension |
| DIM_SPECIE_ID |
Species |
int(10) |
Dimension |
| DIM_GENETIC_MATERIAL_ID |
Genetic material |
int(10) |
Dimension |
| DIM_ORIGIN_YARD_ID |
Origin Yard |
int(10) |
Dimension |
| ORIGIN_BLOCK_NUMBER |
Origin block number |
text(64) |
Measure |
| ORIGIN_PILE_NUMBER |
Origin pile number |
text(16) |
Measure |
| FSC_INDICATOR |
FSC indicator |
error |
Degenerate Dimension |
| FSC_CW_INDICATOR |
FSC CW indicator |
error |
Degenerate Dimension |
| CERFLOR_INDICATOR |
Indicator if the original field has CERFLOR |
error |
Degenerate Dimension |
| CERFOR_CW_INDICATOR |
Indicator if the original field has CERFLOR CW |
error |
Degenerate Dimension |
| DIM_OPERATION_ID |
Operation |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Supplier |
int(10) |
Dimension |
| DIM_CONTRACT_ID |
Contract |
int(10) |
Dimension |
| DIM_COMPOSITION_TYPE_ID |
Set Type |
int(10) |
Dimension |
| DIM_PRODUCT_TYPE_ID |
Property Type |
int(10) |
Dimension |
| DIM_PRODUCT_ID |
Product |
int(10) |
Dimension |
| DISTANCE |
Distance |
error |
Measure |
| VOLUME |
Volume |
error |
Measure |
| NET_WEIGHT |
Net weight |
error |
Measure |
| AMOUNT_PAID |
Amount paid |
error |
Measure |
Back to topics
Wood consumed in mincing lines. (TRA_GUIA_CEM / TRA_ITEM_BOLETIM_PATIO)
| Attribute |
Description |
Type |
Classification |
| dim_yard_id |
Chipper Woodyard |
numeric(8,0) |
Dimension |
| dim_date_id |
Consumption date |
numeric(8,0) |
Dimension |
| dim_specie_id |
Consumed species |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Genetic material consumed |
numeric(8,0) |
Dimension |
| dim_origin_product_type_id |
Consumed Source product type |
numeric(8,0) |
Dimension |
| dim_origin_product_id |
Consumed Origin Product |
numeric(8,0) |
Dimension |
| dim_destination_product_type_id |
Type of product consumed |
numeric(8,0) |
Dimension |
| dim_yard_destination_type_id |
Courtyard Destination Type (direct or indirect consumption) |
numeric(8,0) |
Dimension |
| dim_consumption_place_id |
Place of Consumption ID |
numeric(8,0) |
Dimension |
| yard_consumption_fsc_indicator |
FSC certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_consumption_fsc_cw_indicator |
FSC CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_consumption_cerflor_indicator |
CERFLOR certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_consumption_cerflor_cw_indicator |
CERFLOR CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_consumption_volume |
Consumed Volume |
numeric(18,5) |
Measure |
| yard_consumption_density |
Weighted density by consumed volume |
numeric(18,2) |
Measure |
| yard_consumption_age |
Age weighted by consumed volume |
numeric(18,2) |
Measure |
| yard_consumption_tac |
Pos-cut time weighted by consumed volume |
numeric(18,2) |
Measure |
| yard_consumption_precipitation |
Preciptation weighted by consumed volume |
numeric(18,2) |
Measure |
Back to topics
Downtime of discharge equipment in the woodyard. (TRA_ITEM_BOLETIM_PATIO)
| Attribute |
Description |
Type |
Classification |
| dim_yard_id |
Woodyard |
numeric(8,0) |
Dimension |
| dim_date_id |
Base Date |
numeric(8,0) |
Dimension |
| dim_equipment_id |
Unload equipment |
numeric(8,0) |
Dimension |
| dim_worktime_class_id |
Downtime Class |
numeric(8,0) |
Dimension |
| dim_worktime_type_id |
Downtime Type |
numeric(8,0) |
Dimension |
| dim_worktime_classification_id |
Downtime |
numeric(8,0) |
Dimension |
| downtime_value |
Total downtime (minutes) |
numeric(22,0) |
Measure |
Back to topics
Woodyard stock. (CFG_MOVIMENTACAO_ESTOQUE)
| Attribute |
Description |
Type |
Classification |
| dim_yard_id |
Woodyard |
numeric(8,0) |
Dimension |
| dim_date_id |
Base Date |
numeric(8,0) |
Dimension |
| dim_local_type_id |
Courtyard location type (intermediary, third party, etc.) |
numeric(8,0) |
Dimension |
| dim_product_type_id |
Stocked Product Type |
numeric(8,0) |
Dimension |
| dim_product_id |
Stocked Product |
numeric(8,0) |
Dimension |
| dim_specie_id |
Stocked species |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Stocked genetic material |
numeric(8,0) |
Dimension |
| external_yard_idicator |
External Woodyard? |
numeric(1,0) |
Degenerate Dimension |
| yard_stock_fsc_indicator |
FSC certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_stock_fsc_cw_indicator |
FSC CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_stock_cerflor_indicator |
CERFLOR certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_stock_cerflor_cw_indicator |
CERFLOR CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_stock_volume |
Stocked Volume |
numeric(18,5) |
Measure |
| yard_stock_density |
Density weighted by voume |
numeric(18,2) |
Measure |
| yard_stock_age |
Age weighted by voume |
numeric(18,2) |
Measure |
| yard_stock_tac |
Pos-cut time weighted by volume |
numeric(18,2) |
Measure |
| yard_stock_precipitation |
Preciptation weighted by volume |
numeric(18,2) |
Measure |
Back to topics
Stock removal in the woodyard. (TRA_ITEM_BOLETIM_PATIO)
| Attribute |
Description |
Type |
Classification |
| dim_yard_id |
Woodyard |
numeric(8,0) |
Dimension |
| dim_date_id |
Base Date |
numeric(8,0) |
Dimension |
| dim_stock_movimentation_id |
Inventory movement type |
numeric(8,0) |
Dimension |
| dim_product_type_id |
Withdrawn Product Type |
numeric(8,0) |
Dimension |
| dim_product_id |
Produto retirado |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Genetic material consumed |
numeric(8,0) |
Dimension |
| dim_specie_id |
Species |
numeric(8,0) |
Dimension |
| yard_stock_drop_volume |
Total volume withdrawn except consumption |
numeric(18,5) |
Measure |
Back to topics
Transportation originating in the yard (Factory, third parties, intermediaries, etc). (TRA_GUIA_CEM)
| Attribute |
Description |
Type |
Classification |
| dim_date_id |
Transportation date |
numeric(8,0) |
Dimension |
| dim_yard_id |
Transport Destination Woodyard |
numeric(8,0) |
Dimension |
| dim_specie_id |
Species of the woodyard pile, the origin of the transport |
numeric(8,0) |
Dimension |
| dim_genetic_material_id |
Genetic material from the cell of the transport origin yard |
numeric(8,0) |
Dimension |
| dim_product_type_id |
Transportation Home Yard Stack Product Type |
numeric(8,0) |
Dimension |
| dim_product_id |
Product of the woodyard pile, origin of the transportation |
numeric(8,0) |
Dimension |
| dim_origin_locality_id |
Municipality of the origin courtyard |
numeric(8,0) |
Dimension |
| dim_transportation_supplier_id |
Transport Operation Provider |
numeric(8,0) |
Dimension |
| dim_composition_type_id |
Set type of transport equipment |
numeric(8,0) |
Dimension |
| dim_destination_yard_id |
Transport Destination Woodyard |
numeric(8,0) |
Dimension |
| dim_destination_locality_id |
Municipality of the destination courtyard |
numeric(8,0) |
Dimension |
| dim_destination_product_type_id |
Target Product Type |
numeric(8,0) |
Dimension |
| dim_yard_destination_type_id |
Courtyard Destination Type (direct or indirect consumption) |
numeric(8,0) |
Dimension |
| yard_transportation_fsc_indicator |
FSC certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_transportation_fsc_cw_indicator |
FSC CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_transportation_cerflor_indicator |
CERFLOR certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_transportation_cerflor_cw_indicator |
CERFLOR CW certification indicator |
numeric(1,0) |
Degenerate Dimension |
| yard_transportation_average_distance |
Average transport distance |
numeric(18,2) |
Measure |
| yard_transportation_volume |
Total volume transported |
numeric(18,5) |
Measure |
| yard_transportation_net_weight |
Total net weight carried |
numeric(18,5) |
Measure |
| yard_transportation_density |
Weighted density by transported volume |
numeric(18,2) |
Measure |
| yard_transportation_age |
Age weighted by transported volume |
numeric(18,2) |
Measure |
| yard_transportation_tac |
Pos-cut time weighted by transported volume |
numeric(18,2) |
Measure |
| yard_transportation_precipitation |
Preciptation weighted by transported volume |
numeric(18,2) |
Measure |
Back to topics
Harvest inventory (SPP_MEDICOES_COLHEITA_PROG)
| Attribute |
Description |
Type |
Classification |
| dim_plan_id |
Harvest Plan |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_work_scheme_id |
Stand work scheme |
int(8) |
Dimension |
| dim_wood_product_id |
Harvest Product |
int(8) |
Dimension |
| dim_inventory_source_id |
Measurement Type |
int(8) |
Dimension |
| dim_inventory_type_id |
Measurement Objective |
int(8) |
Dimension |
| cd_medicao |
Measurement code |
int(22) |
|
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| dim_harvest_date_id (DIM_DATE) |
Harvest Date |
int(8) |
Dimension |
| age |
Stand age |
numeric(16,14) |
Measure |
| area |
Stand area |
numeric(16,14) |
Measure |
| volume |
Product Volume |
numeric(16,14) |
Measure |
| volume_unit |
Product Unit Volume |
numeric(16,14) |
Measure |
| ntree |
Number of Trees |
numeric(16,14) |
Measure |
| volume_col |
Harvest Scheduled Volume |
numeric(16,14) |
Measure |
Back to topics
Cubage field data (SPP_MEDICOES_SECCOES)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| tree |
Tree Number |
int(22) |
Degenerate Dimension |
| section |
Section Number |
int(22) |
Degenerate Dimension |
| age |
Stand age |
numeric(16,14) |
Measure |
| dbh |
DBH - Diameter at Breast Height |
numeric(16,14) |
Measure |
| ht |
Height |
numeric(16,14) |
Measure |
| Dia |
Section Diameter |
numeric(16,14) |
Measure |
| Hi |
Section Height |
numeric(16,14) |
Measure |
| Bark |
Section Bark Thickness |
numeric(16,14) |
Measure |
Back to topics
Inventory results by plot (SPP_RESULT_PARCELAS)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_inventory_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_inventory_scheduling_id |
Program |
int(8) |
Dimension |
| dim_inventory_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_inventory_prescription_id |
Prescription |
int(8) |
Dimension |
| dim_inventory_source_id |
Measurement Type |
int(8) |
Dimension |
| dim_inventory_stratum_id |
Strata |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_inventory_plot_id |
Plot |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| age |
Stand age |
numeric(16,14) |
Measure |
| area |
Stand area |
numeric(16,14) |
Measure |
| ntree |
Number of Trees |
numeric(16,14) |
Measure |
| dbh |
DBH - Diameter at Breast Height |
numeric(16,14) |
Measure |
| g |
Basal Area |
numeric(16,14) |
Measure |
| ht |
Height |
numeric(16,14) |
Measure |
| hdom |
Dominant Height |
numeric(16,14) |
Measure |
| volume_standard |
Volume per Ha |
numeric(16,14) |
Measure |
| ima_standard |
Annual Average Increment |
numeric(16,14) |
Measure |
| vol_unit_standard |
Unit Volume |
numeric(16,14) |
Measure |
| volume_total_standard |
Total Volume |
numeric(16,14) |
Measure |
Back to topics
Inventory Program (SPP_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
|
| dim_inventory_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_inventory_scheduling_id |
Program |
int(8) |
Dimension |
| dim_inventory_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_inventory_prescription_id |
Prescription |
int(8) |
Dimension |
| dim_inventory_source_id |
Measurement Type |
int(8) |
Dimension |
| dim_inventory_stratum_id |
Strata |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_expected_date_id (DIM_DATE) |
Expected date |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| n_parcelas_prev |
Planned plots |
int(22) |
Measure |
| n_parcelas_med |
Measured plots |
int(22) |
Measure |
Back to topics
¶ FACT_INV_STAND_LAST_RESULT
Last inventory result (SPP_RESULT_PLANTIOS)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_inventory_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_inventory_scheduling_id |
Program |
int(8) |
Dimension |
| dim_inventory_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_inventory_prescription_id |
Prescription |
int(8) |
Dimension |
| dim_inventory_source_id |
Measurement Type |
int(8) |
Dimension |
| dim_inventory_stratum_id |
Strata |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| n_parcelas |
Number of plots |
int(22) |
Measure |
| age |
Stand age |
numeric(16,14) |
Measure |
| area |
Stand area |
numeric(16,14) |
Measure |
| ntree |
Number of Trees |
numeric(16,14) |
Measure |
| dbh |
DBH - Diameter at Breast Height |
numeric(16,14) |
Measure |
| g |
Basal Area |
numeric(16,14) |
Measure |
| ht |
Height |
numeric(16,14) |
Measure |
| hdom |
Dominant Height |
numeric(16,14) |
Measure |
| volume_standard |
Volume per Ha |
numeric(16,14) |
Measure |
| ima_standard |
Annual Average Increment |
numeric(16,14) |
Measure |
| vol_unit_standard |
Unit Volume |
numeric(16,14) |
Measure |
| volume_total_standard |
Total Volume |
numeric(16,14) |
Measure |
Back to topics
¶ FACT_INV_STAND_RESULT
Inventory Results by Stand (SPP_RESULT_PLANTIOS)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_inventory_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_inventory_scheduling_id |
Program |
int(8) |
Dimension |
| dim_inventory_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_inventory_prescription_id |
Prescription |
int(8) |
Dimension |
| dim_inventory_source_id |
Measurement Type |
int(8) |
Dimension |
| dim_inventory_stratum_id |
Strata |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| n_parcelas |
Number of plots |
int(22) |
Measure |
| age |
Stand age |
numeric(16,14) |
Measure |
| area |
Stand area |
numeric(16,14) |
Measure |
| ntree |
Number of Trees |
numeric(16,14) |
Measure |
| dbh |
DBH - Diameter at Breast Height |
numeric(16,14) |
Measure |
| g |
Basal Area |
numeric(16,14) |
Measure |
| ht |
Height |
numeric(16,14) |
Measure |
| hdom |
Dominant Height |
numeric(16,14) |
Measure |
| volume_standard |
Volume per Ha |
numeric(16,14) |
Measure |
| ima_standard |
Annual Average Increment |
numeric(16,14) |
Measure |
| vol_unit_standard |
Unit Volume |
numeric(16,14) |
Measure |
| volume_total_standard |
Total Volume |
numeric(16,14) |
Measure |
Back to topics
¶ FACT_INV_STAND_RESULT_BY_PRODUCT
Results by Product (SPP_RESULT_PLANTIOS)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_inventory_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_inventory_scheduling_id |
Program |
int(8) |
Dimension |
| dim_inventory_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_inventory_prescription_id |
Prescription |
int(8) |
Dimension |
| dim_inventory_source_id |
Measurement Type |
int(8) |
Dimension |
| dim_inventory_stratum_id |
Strata |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_product_id |
Harvest Product |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| n_parcelas |
Number of plots |
int(22) |
Measure |
| age |
Stand age |
numeric(16,14) |
Measure |
| area |
Stand area |
numeric(16,14) |
Measure |
| ntree |
Number of Trees |
numeric(16,14) |
Measure |
| dbh |
DBH - Diameter at Breast Height |
numeric(16,14) |
Measure |
| g |
Basal Area |
numeric(16,14) |
Measure |
| ht |
Height |
numeric(16,14) |
Measure |
| hdom |
Dominant Height |
numeric(16,14) |
Measure |
| volume_product |
Volume per Ha |
numeric(16,14) |
Measure |
| ima_product |
Annual Average Increment |
numeric(16,14) |
Measure |
| vol_unit_product |
Unit Volume |
numeric(16,14) |
Measure |
| volume_total_product |
Total Volume |
numeric(16,14) |
Measure |
Back to topics
Farm (potential land) (TER_TERRA_POTENCIAL)
| Attribute |
Description |
Type |
Classification |
| dim_farm_id |
Automatic Code of Farm |
int(19) |
Dimension |
| dim_locality_id |
County code where the farm is located |
int(19) |
Dimension |
| dim_region_id |
Code of the property where the farm is located |
int(19) |
Dimension |
| dim_management_unit_id |
Management Unit Code, where the farm is located |
int(19) |
Dimension |
| dim_unit_id |
Internationalization unit |
int(19) |
Dimension |
| farm_total_area |
Farm Area |
numeric(28,8) |
Measure |
Back to topics
People associated with land documents (TER_PESSOA_ENVOLVIDA_TERRA_POT)
| Attribute |
Description |
Type |
Classification |
| dim_farm_id |
Farm Code |
int(19) |
Dimension |
| dim_person_company_id |
Code of person involved with the farm |
int(19) |
Dimension |
| dim_role_id |
Type of person involved with the farm |
int(19) |
Dimension |
Back to topics
¶ FACT_LAND_CONTRACT
Agreements (land) (TER_CONTRATO)
| Attribute |
Description |
Type |
Classification |
| dim_land_contract_id |
Automatic Code of Contract |
int(19) |
Dimension |
| dim_locality_id |
Municipality where the contract was signed |
int(19) |
Dimension |
| dim_region_id |
Property where the contract was concluded |
int(19) |
Dimension |
| dim_management_unit_id |
Management unit where the contract was signed |
int(19) |
Dimension |
| dim_unit_id |
Internationalization unit |
int(19) |
Dimension |
| dim_land_contract_type_id |
Type of contract |
int(19) |
Dimension |
| dim_currency_type_id |
Contract Currency Type |
int(19) |
Dimension |
| land_contract_total_area |
Contract Area |
numeric(28,8) |
Measure |
| land_contract_total_value |
Total contract value |
numeric(28,8) |
Measure |
Back to topics
¶ FACT_LAND_CONTRACT_FARM
Farms associated to the agreements (TER_PROPRIEDADE_CONTRATO)
| Attribute |
Description |
Type |
Classification |
| dim_farm_id |
Farm Code |
int(19) |
Dimension |
| dim_land_contract_id |
Contract Code |
int(19) |
Dimension |
Back to topics
¶ FACT_LAND_CONTRACT_LAND_DOCUMENTATION
Land documents associated with agreements (TER_ASSOC_PROPRIEDADE_DOCTERRA)
| Attribute |
Description |
Type |
Classification |
| dim_land_documentation_id |
Land Document Code |
int(19) |
Dimension |
| dim_land_contract_id |
Contract Code |
int(19) |
Dimension |
Back to topics
¶ FACT_LAND_CONTRACT_PAYMENT
Contract payments (TER_PAGAMENTO_CONTRATO)
| Attribute |
Description |
Type |
Classification |
| dim_land_contract_id |
Contract Code |
int(19) |
Dimension |
| dim_role_id |
Person responsible for payment of quota |
int(19) |
Dimension |
| dim_currency_type_id |
Quota Currency Type |
int(19) |
Dimension |
| dim_unit_id |
Internationalization unit |
int(19) |
Dimension |
| dim_date_expiration_id |
Quota due date |
int(19) |
Dimension |
| dim_date_conclusion_id |
Efective date of the quota payment |
int(19) |
Dimension |
| dim_date_measurement_id |
Measurement date to release the quota payment |
int(19) |
Dimension |
| land_contract_payment_parcel_value |
Quota Amount |
numeric(14,2) |
Degenerate Dimension |
| land_contract_payment_value_paid |
Amount paid from quota |
numeric(14,2) |
Degenerate Dimension |
| land_contract_payment_note |
Note (free text) |
text(64) |
Degenerate Dimension |
| land_contract_payment_parcel_number |
Quota Number |
numeric(14,0) |
Degenerate Dimension |
| land_contract_payment_parcel_type |
Quota Type |
text(64) |
Degenerate Dimension |
Back to topics
¶ FACT_LAND_DOCUMENTATION
Land documents (TER_DOCTERRA)
| Attribute |
Description |
Type |
Classification |
| dim_land_documentation_id |
Automatic Code of Land Document |
int(19) |
Dimension |
| dim_farm_id |
Farm Code, related to the Land Document |
int(19) |
Dimension |
| dim_locality_id |
County code where the land document is located |
int(19) |
Dimension |
| dim_region_id |
Code of the property where the land document is located |
int(19) |
Dimension |
| dim_management_unit_id |
Management Unit Code, where the land use document is located |
int(19) |
Dimension |
| dim_unit_id |
Internationalization unit |
int(19) |
Dimension |
| land_documentation_tittle_area |
The deeded area as in the land document |
numeric(28,8) |
Measure |
| land_documentation_legitimated_area |
The legitimated area as in the land document |
numeric(28,8) |
Measure |
| land_documentation_measured_area |
Measured area as in the land document |
numeric(28,8) |
Measure |
| land_documentation_gis_area |
The GIS area as in the land document |
numeric(28,8) |
Measure |
Back to topics
¶ FACT_LAND_DOCUMENTATION_CONDITIONS
Encumbrances associated with land documents (TER_SOBCONDICAO_DOCTERRA)
| Attribute |
Description |
Type |
Classification |
| dim_land_documentation_id |
Land Document Code |
int(19) |
Dimension |
| land_documentation_conditions_purpose |
Purpose of the lien |
text(32) |
Degenerate Dimension |
| land_documentation_conditions_type |
Lien Type |
text(32) |
Degenerate Dimension |
| land_documentation_conditions_nature |
Nature of the lien |
text(32) |
Degenerate Dimension |
| land_documentation_conditions_maturity_date |
Due date of the lien |
date |
Degenerate Dimension |
Back to topics
¶ FACT_LAND_DOCUMENTATION_LAND_USE
Land uses associated with land documents (VW_CUBO_USO_SOLO_DOCTERRA)
| Attribute |
Description |
Type |
Classification |
| dim_land_documentation_id |
Land Document Code |
int(19) |
Dimension |
| dim_stand_id |
Stand key |
int(19) |
Dimension |
| dim_project_id |
Tract Code |
int(19) |
Dimension |
| dim_region_id |
Property Code |
int(19) |
Dimension |
| dim_land_use_characteristic_id |
Land Use Classification Code |
int(19) |
Dimension |
| land_documentation_land_use_area |
Stand area defined by the land document |
numeric(18,8) |
Measure |
Back to topics
¶ FACT_LAND_DOCUMENTATION_PERSON
People associated with farms (TER_ASSOC_PESSOA_DOCTERRA)
| Attribute |
Description |
Type |
Classification |
| dim_land_documentation_id |
Land Document Code |
int(19) |
Dimension |
| dim_person_company_id |
Code of person involved with the land document |
int(19) |
Dimension |
| dim_role_id |
Type of person involved with the land document |
int(19) |
Dimension |
Back to topics
¶ FACT_LAND_DOCUMENTATION_REGISTRATION
Endorsements related to land documents (TER_AVERB_REGISTRO_DOCTERRA)
| Attribute |
Description |
Type |
Classification |
| dim_land_documentation_id |
Land Document Code |
int(19) |
Dimension |
| land_documentation_registration_type |
Endorsement Type |
text(32) |
Degenerate Dimension |
| land_documentation_registration_description |
Description of the endorsement |
text(32) |
Degenerate Dimension |
| land_documentation_registration_description_type |
Indicates whether this is a description or registration. |
text(32) |
Degenerate Dimension |
| land_documentation_registration_lr |
Indicates whether this is a legal reserve endorsement |
text(18) |
Degenerate Dimension |
| land_documentation_registration_area |
Indicates endorsed area |
numeric(28,8) |
Measure |
Back to topics
Licenses (TER_LICENCA_TERRA_POT)
| Attribute |
Description |
Type |
Classification |
| dim_license_id |
Automatic Code of License |
int(19) |
Dimension |
| dim_farm_id |
Farm to which the license is related |
int(19) |
Dimension |
| dim_date_protocol_id |
Environmental protocol license date |
int(19) |
Dimension |
| dim_date_pub_requirement_id |
Date of publication of the license application in a press vehicle |
int(19) |
Dimension |
| dim_date_pub_receiving_id |
Date of publication of license release in a press release |
int(19) |
Dimension |
| dim_date_inspection_id |
Date of the survey conducted by the environmental agency to release the license |
int(19) |
Dimension |
| dim_date_issue_id |
License issue date |
int(19) |
Dimension |
| dim_date_expiration_id |
License Expiration Date |
int(19) |
Dimension |
Back to topics
Roads (CFG_ESTRADA)
| Attribute |
Description |
Type |
Classification |
| dim_region_id |
ID of the property the road belongs to |
numeric(8,0) |
Dimension |
| dim_project_id |
ID of the tract the road belongs to |
numeric(8,0) |
Dimension |
| dim_land_use_characteristic_id |
Road feature ID |
numeric(8,0) |
Dimension |
| dim_locality_id |
Municipality of the road |
numeric(8,0) |
Dimension |
| road_stand |
Road grouped Stand code |
text(32) |
Degenerate Dimension |
| dim_date_construction_id |
Contruction date |
numeric(8,0) |
Dimension |
| dim_unit_id |
Internationalization unit |
numeric(8,0) |
Dimension |
| dim_road_id |
Road ID |
numeric(8,0) |
Dimension |
| road_length |
Length |
text(38) |
Measure |
Back to topics
Roads dimension (EST_DIMENSAO_ESTRADA)
| Attribute |
Description |
Type |
Classification |
| dim_road_id |
Road |
numeric(8,0) |
Dimension |
| dim_dimension_id |
Road size |
numeric(8,0) |
Dimension |
| dim_measure_unit_id |
Measurement Unit |
numeric(8,0) |
Dimension |
| dim_unit_id |
Internationalization unit |
numeric(8,0) |
Dimension |
| road_dimension_type |
Dimension Type |
text(128) |
Degenerate Dimension |
| road_dimension_value_type |
Dimension Value Type |
text(1) |
Degenerate Dimension |
| road_dimension_value |
Dimension Value |
numeric(18,6) |
Measure |
Back to topics
Weather station measurements (CLI_MEDICAO)
| Attribute |
Description |
Type |
Classification |
| dim_station_id |
Station where measurement was taken |
numeric(8,0) |
Dimension |
| dim_variables_id |
Measured variable |
numeric(8,0) |
Dimension |
| dim_measurement_unit_id |
Unit of measure in which the variable was measured |
numeric(8,0) |
Dimension |
| dim_date_measurement_id |
Measurement Date |
numeric(8,0) |
Dimension |
| measurement_value |
Measurement value |
numeric(28,0) |
Measure |
Back to topics
Activities price (VW_EXA_MOVIMENTO_CUSTO)
| Attribute |
Description |
Type |
Classification |
| dim_cost_group_id |
The cost group is the element that subdivides and classifies biological asset balances according to business rules determined by the customer. Depending on the needs of each customer, these groups are created for a specific purpose. |
int(19) |
Dimension |
| dim_account_id |
Automatic Code of Bookkeeping Account |
int(19) |
Dimension |
| dim_cost_object_id |
Automatic Code of Cost Center |
int(19) |
Dimension |
| dim_resource_group_id |
The resource group associates a company´s own resources with cost centers. This association is used in the pricing process to search for the values that will serve as the basis for the tariff calculation. |
int(19) |
Dimension |
| dim_supplier_id |
Own company |
int(19) |
Dimension |
| dim_year_month_id |
Year and Month of Data Entry (YYYY/MM Format) |
int(19) |
Dimension |
| percentage |
Percentage that Cost Object and G / L Account combination represents in total resource rate |
numeric(18,4) |
Measure |
| unit_price |
Segregated Rate by Cost Object and G/L Account |
numeric(22,0) |
Measure |
Back to topics
Asset cost (VW_EXA_MOVIMENTO_CUSTO)
| Attribute |
Description |
Type |
Classification |
| dim_posting_type_id |
Movement type made in the cost module. Sorts the movements according to the transaction that generated it. The list of available movement types may vary by customer and is found in the system under Asset / Configuration / Movement Types [9080]. |
int(19) |
Dimension |
| dim_stand_id |
Automatic Code of Stands Register |
int(19) |
Dimension |
| dim_region_id |
Property ID |
int(19) |
Dimension |
| dim_project_id |
Tract ID |
int(19) |
Dimension |
| dim_planting_establishment_system_id |
Automatic Code of Regime |
int(19) |
Dimension |
| dim_land_use_characteristic_id |
Automatic Code Land Use Classification |
int(19) |
Dimension |
| dim_cost_group_id |
The cost group is the element that subdivides and classifies biological asset balances according to business rules determined by the customer. Depending on the needs of each customer, these groups are created for a specific purpose. |
int(19) |
Dimension |
| dim_cost_type_id |
It is the element that represents the main subdivision of balances of biological assets. They can be used to subdivide, for example, deployment and training costs. |
int(19) |
Dimension |
| dim_cost_group_setup_id |
Provides some additional information for each cost group, such as the associated cost classification and the cost type (direct or indirect). |
int(19) |
Dimension |
| dim_currency_type_id |
Currency Type Used in Transaction |
int(19) |
Dimension |
| dim_supplier_id |
Cost movement own company |
int(19) |
Dimension |
| dim_year_month_id |
Year and Month of Data Entry (YYYY/MM Format) |
int(19) |
Dimension |
| dim_posting_date_id |
Costs movement date |
int(19) |
Dimension |
| cost_document |
Unique identification of cost movement |
numeric(22,0) |
Degenerate Dimension |
| doc_reference |
Document number that originates the cost movement. It could be, for example, the number of the silviculture Follow-up. |
numeric(22,0) |
Degenerate Dimension |
| closing_process |
Unique identifier of the closing process in which the cost movement is posted. |
numeric(22,0) |
Degenerate Dimension |
| posting_amount |
Cost Movement Value |
numeric(22,0) |
Measure |
Back to topics
Bioasset direct costs (EXA_BOLETIM_FECHAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_CLOSING_PROCESS_ID |
Closing process |
int(10) |
Dimension |
| DIM_CURRENCY_TYPE_ID |
Document currency. |
int(10) |
Dimension |
| DIM_ACCOUNT_ID |
INFLOR G / L account for posting. |
int(10) |
Dimension |
| DIM_MANAGEMENT_UNIT_ID |
Management unit. |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Company (own supplier) of the document. |
int(10) |
Dimension |
| DIM_OPERATION_DATE_ID |
Date of the operation in the source follow-up. |
datetime |
Dimension |
| DIM_OPERATION_ID |
Operation in the source follow-up. |
int(10) |
Dimension |
| DIM_MATERIAL_ID |
Material code on the input lines. |
int(10) |
Dimension |
| DIM_EQUIPMENT_ID |
Equipment code on equipment lines. |
int(10) |
Dimension |
| DIM_POSITION_ID |
Job code on labor lines. |
int(10) |
Dimension |
| DOC_REFERENCE |
Document number that originates the cost movement. It could be, for example, the number of the silviculture Follow-up. |
error |
Degenerate Dimension |
| DIM_STAND_ID |
Field registration code in the forest base. |
int(10) |
Dimension |
| DIM_CREATION_DATE_ID |
Creation date |
datetime |
Dimension |
| DIM_ACCRUAL_CALENDAR_DATE_ID |
Reference date for determining the month of accounting. |
datetime |
Dimension |
| DIM_MEASURE_UNIT_ID |
Unit of measure of the realized quantity. |
int(10) |
Dimension |
| DIM_POSTING_TYPE_ID |
Movement type made in the cost module. Sorts the movements according to the transaction that generated it. The list of available movement types may vary by customer and is found in the system under Asset / Configuration / Movement Types [9080]. |
error |
Dimension |
| DIRECT_ALOCATION |
Indicates whether the amount has been allocated as a direct cost. 1 - Yes; 0 - No |
error |
Degenerate Dimension |
| DIRECT_COST_DOCUMENT |
Registration line in Biological Assets. |
int(10) |
Degenerate Dimension |
| RELATED_DOCUMENT |
Origin follow-up number. |
error |
Degenerate Dimension |
| DOCUMENT_TYPE |
S - Silviculture; E-Event |
text(2) |
Degenerate Dimension |
| ITEM_TYPE |
Indicates whether the item refers to the cost of (O) operation / Service, (I) materials, (E) equipment or (M) labor |
text(1) |
Degenerate Dimension |
| PAYMENT_TYPE |
N - Normal; R - Retroactive |
text(1) |
Degenerate Dimension |
| PRODUCTION_AREA |
Operated area in hectares |
error |
Measure |
| QUANTITY |
Quantity of operation |
error |
Measure |
| AMOUNT |
Document costs |
error |
Measure |
Back to topics
Bioasset harvest follow up (EXA_APONTAMENTO_COLHEITA)
| Attribute |
Description |
Type |
Classification |
| DIM_STAND_ID |
Stand operated |
int(10) |
Dimension |
| DIM_OPERATION_DATE_ID |
Operation date in the source follow-up. |
datetime |
Dimension |
| DIM_PRODUCT_ID |
Harvested product. |
int(10) |
Dimension |
| DIM_PRODUCT_FINISH_DATE_ID |
Product CTO date |
datetime |
Dimension |
| DIM_STAND_FINISH_DATE_ID |
Stand CTO date |
datetime |
Dimension |
| DIM_CLOSING_PROCESS_ID |
Closing process |
int(10) |
Dimension |
| BIOASSET_HARVEST_FOLLOW_UP_NUMBER |
Control document in the Biological Asset module |
int(10) |
Degenerate Dimension |
| DOCUMENT_TYPE |
Type of source bulletin. BC = Harvest Follow-up, PC = Harvest production, I = Import |
text(5) |
Degenerate Dimension |
| PRODUCTION_VOLUME |
Pre-harvest volume |
error |
Measure |
| INVENTORY_VOLUME |
Pre-cut inventory volume |
error |
Measure |
| REPORTED_VOLUME |
Reported volume |
error |
Measure |
| AJUSTED_VOLUME |
Adjusted Volume |
error |
Measure |
Back to topics
Depletion (EXA_MOVIMENTO_BAIXA)
| Attribute |
Description |
Type |
Classification |
| dim_posting_type_id |
Movement type made in the cost module. Sorts the movements according to the transaction that generated it. The list of available movement types may vary by customer and is found in the system under Asset / Configuration / Movement Types [9080]. |
int(19) |
Dimension |
| dim_stand_id |
Automatic Code of Stands Register |
int(19) |
Dimension |
| dim_region_id |
Property ID |
int(19) |
Dimension |
| dim_project_id |
Tract ID |
int(19) |
Dimension |
| dim_planting_establishment_system_id |
Automatic Code of Regime |
int(19) |
Dimension |
| dim_land_use_characteristic_id |
Automatic Code Land Use Classification |
int(19) |
Dimension |
| dim_cost_group_id |
The cost group is the element that subdivides and classifies biological asset balances according to business rules determined by the customer. Depending on the needs of each customer, these groups are created for a specific purpose. |
int(19) |
Dimension |
| dim_cost_type_id |
It is the element that represents the main subdivision of balances of biological assets. They can be used to subdivide, for example, deployment and training costs. |
int(19) |
Dimension |
| dim_cost_group_setup_id |
Provides some additional information for each cost group, such as the associated cost classification and the cost type (direct or indirect). |
int(19) |
Dimension |
| dim_currency_type_id |
Currency Type Used in Transaction |
int(19) |
Dimension |
| dim_supplier_id |
Cost movement own company |
int(19) |
Dimension |
| dim_year_month_id |
Year and Month of Data Entry (YYYY/MM Format) |
int(19) |
Dimension |
| dim_posting_date_id |
Costs movement date |
int(19) |
Dimension |
| dim_product |
Product code informed in the harvest follow-up that generated the write-off / depletion |
int(19) |
Dimension |
| cost_document |
Unique identification of cost movement |
numeric(22,0) |
Degenerate Dimension |
| doc_reference |
Document number that originates the cost movement. It could be, for example, the number of the silviculture Follow-up. |
numeric(22,0) |
Degenerate Dimension |
| closing_process |
Unique identifier of the closing process in which the cost movement is posted. |
numeric(22,0) |
Degenerate Dimension |
| posting_amount |
Cost Movement Value |
numeric(22,0) |
Measure |
Back to topics
Harvest Volumes for depletion (EXA_EXAUSTAO_PRODUTO)
| Attribute |
Description |
Type |
Classification |
| DIM_STAND_ID |
Stand |
int(10) |
Dimension |
| DIM_REGION_ID |
Property |
int(10) |
Dimension |
| DIM_PROJECT_ID |
Tract |
int(10) |
Dimension |
| DIM_PLANTING_ESTABLISHMENT_SYSTEM_ID |
Automatic Code of Regime |
int(10) |
Dimension |
| DIM_LAND_USE_CHARACTERISTIC_ID |
Automatic Code Land Use Classification |
int(10) |
Dimension |
| DIM_SUPPLIER_ID |
Supplier |
int(10) |
Dimension |
| DIM_YEAR_MONTH_ID |
Year and Month (YYYYMM Format) |
int(10) |
Dimension |
| DIM_PRODUCT_ID |
Product |
int(10) |
Dimension |
| DIM_MOTIVE_ID |
Automatic Code of Motive |
int(10) |
Dimension |
| CREATION_TYPE |
Type of creation. Indicates if the exhaustion was provided by the harvest (C), if it was generated manually (M), if it was generated from pending exhaust (P) that cannot be processed automatically or if it was generated from import (I) |
text(2) |
Degenerate Dimension |
| HARVEST_DOCUMENT |
Harvest document |
int(10) |
Degenerate Dimension |
| HARVEST_VOLUME |
Harvest Volume |
error |
Measure |
Back to topics
User X Management Unit (CFG_ASSOC_USUARIO_UNID_GESTAO)
| Attribute |
Description |
Type |
Classification |
| dim_user_id |
Automatic Code of User |
int(19) |
Dimension |
| user_name |
Username |
text(64) |
Degenerate Dimension |
| user_login |
User Login |
text(64) |
Degenerate Dimension |
| user_email |
User Email |
text(64) |
Degenerate Dimension |
| user_language |
User Language |
text(10) |
Degenerate Dimension |
| flag_internal_user |
Internal employee Flag. 0 = No; 1 = Yes |
text(1) |
Degenerate Dimension |
| dim_supplier_id |
Automatic Code of Supplier |
int(19) |
Dimension |
| supplier_description |
Provider´s name |
text(200) |
Degenerate Dimension |
| dim_process_id |
Automatic Code of User |
int(19) |
Dimension |
| process_description |
Process description |
text(64) |
Degenerate Dimension |
| process_abbreviation |
Process short description |
text(16) |
Degenerate Dimension |
| flag_management_unit_control |
Flag indicating that the process has control by management unit. 0 = No; 1 = Yes |
text(1) |
Degenerate Dimension |
| dim_management_unit_id |
Automatic Code of Management Unit |
int(19) |
Dimension |
| management_unit_description |
Management Unit Description |
text(64) |
Degenerate Dimension |
| management_unit_abbreviation |
Management Unit short description |
text(16) |
Degenerate Dimension |
Back to topics
Quality data - Individual level (SPP_DADOS_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_quali_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_quali_scheduling_id |
Program |
int(8) |
Dimension |
| dim_quali_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_quali_plot_id |
Plot |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| individuo |
Individual Number |
int(22) |
Degenerate Dimension |
| variable_name |
Variable Name |
text(30) |
Degenerate Dimension |
| value_txt |
Text Value |
text(200) |
Degenerate Dimension |
| group_attribute |
Attibrutes Group |
text(200) |
Degenerate Dimension |
| score |
Score |
numeric(16,14) |
Measure |
| value |
Value |
numeric(16,14) |
Measure |
Back to topics
Quality data - Sample level (SPP_DADOS_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_quali_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_quali_scheduling_id |
Program |
int(8) |
Dimension |
| dim_quali_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_quali_plot_id |
Plot |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| variable_name |
Variable Name |
text(30) |
Degenerate Dimension |
| value_txt |
Text Value |
text(200) |
Degenerate Dimension |
| group_attribute |
Attibrutes Group |
text(200) |
Degenerate Dimension |
| score |
Score |
numeric(16,14) |
Measure |
| value |
Value |
numeric(16,14) |
Measure |
Back to topics
Quality model result (SPP_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_quali_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_quali_scheduling_id |
Program |
int(8) |
Dimension |
| dim_quali_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| result |
Result |
numeric(16,14) |
Measure |
| goal |
Goal |
numeric(16,14) |
Measure |
Back to topics
¶ FACT_QUALI_STAND_DETAIL
Quality data - stand level (SPP_DADOS_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| cd_medicao |
Measurement code |
int(22) |
Degenerate Dimension |
| dim_quali_plan_id |
Operational Plan |
int(8) |
Dimension |
| dim_quali_scheduling_id |
Program |
int(8) |
Dimension |
| dim_quali_type_id |
Measurement Objective |
int(8) |
Dimension |
| dim_region_id |
Property |
int(8) |
Dimension |
| dim_project_id |
Tract |
int(8) |
Dimension |
| dim_stand_id |
Stand |
int(8) |
Dimension |
| dim_specie_id |
Species |
int(8) |
Dimension |
| dim_genetic_material_id |
Genetic material |
int(8) |
Dimension |
| dim_spacing_id |
Space |
int(8) |
Dimension |
| dim_soil_type_id |
Soil Type |
int(8) |
Dimension |
| dim_supplier_id |
Supplier |
int(8) |
Dimension |
| dim_measurement_date_id (DIM_DATE) |
Measurement Date |
int(8) |
Dimension |
| dim_planting_date_id (DIM_DATE) |
Planting date |
int(8) |
Dimension |
| dim_compare_date_id (DIM_DATE) |
Date of comparison |
int(8) |
Dimension |
| variable_name |
Variable Name |
text(30) |
Degenerate Dimension |
| value_txt |
Text Value |
text(200) |
Degenerate Dimension |
| group_attribute |
Attibrutes Group |
text(200) |
Degenerate Dimension |
| score |
Score |
numeric(16,14) |
Measure |
| value |
Value |
numeric(16,14) |
Measure |
Back to topics
Back to topics
¶ Dimensions and their attributes
Closing process (EXA_FECHAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_CLOSING_PROCESS_ID |
Unique key of the dimension table (surrogate key) |
error |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Closing Process |
int(10) |
SCD - Business Key |
| CLOSING_PROCESS_STATUS |
Closing process status: C - Creation / Opening Balance; E - Calculated Depletion; I - BioAsset calculated; F - Finished |
text(1) |
|
| CLOSING_PROCESS_YEAR |
Fiscal year. |
error |
|
| CLOSING_PROCESS_MONTH |
Fiscal period |
error |
|
| CLOSING_PROCESS_ACTIVE |
Closing process situation: 1 - Active; 0 - Inactive |
text(1) |
|
| CLOSING_PROCESS_SUPPLIER |
Supplier code (own company) |
int(10) |
|
Back to topics
Ledger account (CFG_CONTA_CONTABIL)
| Attribute |
Description |
Type |
Classification |
| DIM_ACCOUNT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Bookkeeping Account |
int(10) |
SCD - Business Key |
| ACCOUNT_IDENTIFICATION |
Automatic Code of Bookkeeping Account |
text(32) |
SCD - Business Key |
| ACCOUNT_DESCRIPTION |
G / L Account Description |
text(64) |
|
| ACCOUNT_ABBREVIATION |
Account account shoft description |
text(16) |
|
| ACCOUNT_SUPPLIER |
Automatic Code of Supplier |
int(10) |
SCD - Business Key |
Back to topics
Competence calendar (CFG_CALENDARIO_COMPETENCIA)
| Attribute |
Description |
Type |
Classification |
| DIM_ACCRUAL_BASIS_CALENDAR_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Accrual Calendar |
int(10) |
SCD - Business Key |
| ACCRUAL_BASIS_CALENDAR_DESCRIPTION |
Description of the accrual calendar. |
text(64) |
|
| START_DATE |
Initial date of the accrual calendar |
datetime |
|
| FINISH_DATE |
End date of the accrual calendar |
datetime |
|
Back to topics
Activity (CFG_ATIVIDADE)
| Attribute |
Description |
Type |
Classification |
| DIM_ACTIVITY_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Activity |
int(10) |
SCD - Business Key |
| ACTIVITY_EXTERNAL_ID |
Activity External ID |
text(32) |
|
| ACTIVITY_DESCRIPTION |
Activity description |
text(64) |
|
| ACTIVITY_ABREVIATION |
Activity abreviation |
text(16) |
|
| GROUPER_ACTIVITY_DESCRIPTION |
Grouper Activity Description |
text(250) |
|
Back to topics
Operation groups (CFG_GRUPO_OPERACAO_MANEJO) (Copy of DIM_OPERATION_GROUP)
| Attribute |
Description |
Type |
Classification |
| DIM_OPERATION_GROUP_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Operation Group |
int(10) |
SCD - Business Key |
| OPERATION_GROUP_DESCRIPTION |
Description of operation group |
text(64) |
|
| OPERATION_GROUP_ABREVIATION |
Abbreviation of Operation Group |
text(16) |
|
| OPERATION_GROUP_SEQUENCE |
Operation group sequence |
error |
|
Back to topics
User (CFG_USUARIO) (Copy of DIM_USER)
| Attribute |
Description |
Type |
Classification |
| DIM_USER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of User |
int(10) |
SCD - Business Key |
| USER_NAME |
User Description |
text(64) |
|
| USER_LOGIN |
User Login |
text(64) |
|
| USER_EMAIL |
User Email |
text(64) |
|
| LOCK_FLAG |
Identification Flag that the user is locked in the system. (0 = Unlocked and 1 = Locked). |
error |
|
| EMPLOYEE_CODE |
Automatic Code of Employee |
int(10) |
|
| EMPLOYEE_REGISTER |
Employee Registration |
text(64) |
|
| EMPLOYEE_NAME |
Name of the employee. |
text(96) |
|
| ADMISSION_DATE |
Employee Admission Date |
error |
|
| POSITION_DESCRIPTION |
Description of the employee´s position |
text(128) |
|
| COMPANY_NAME |
Name of the company the user works for. |
text(200) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Equipment (CFG_EQUIPAMENTO) (Copy of DIM_EQUIPMENT)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment |
int(10) |
SCD - Business Key |
| EQUIPMENT_EXTERNAL_ID |
Equipment External ID |
text(32) |
|
| EQUIPMENT_SERIAL_NUMBER |
Equipment Serial Number |
text(64) |
|
| EQUIPMENT_DESCRIPTION |
Equipment description |
text(64) |
|
| EQUIPMENT_ABREVIATION |
Abbreviation of Equipment |
text(16) |
|
| EQUIPMENT_PURCHASE_DATE |
Equipment Purchase Date |
datetime |
|
| EQUIPMENT_OWNER_DESCRIPTION |
Description of equipment owner |
text(200) |
|
| EQUIPMENT_OWNER_ABREVIATION |
Abbreviation of the Supplier, Equipment Propietary |
text(16) |
|
| EQUIPMENT_MODEL_DESCRIPTION |
Description of the equipment model |
text(64) |
|
| EQUIPMENT_CLASS_DESCRIPTION |
Description of the equipment class |
text(64) |
|
Back to topics
Equipment classes (CFG_CLASSE_EQUIPAMENTO) (Copy of DIM_EQUIPMENT_CLASS)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment Class |
int(10) |
SCD - Business Key |
| EQUIPMENT_CLASS_DESCRIPTION |
Description of equipment class |
text(64) |
|
| EQUIPMENT_CLASS_ABREVIATION |
Abbreviation of Equipment Class |
text(16) |
|
Back to topics
Down time types (<enumerado>) (Copy of DIM_EQUIPMENT_MODEL)</enumerado>
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_MODEL_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment Family |
int(10) |
SCD - Business Key |
| EQUIPMENT_MODEL_DESCRIPTION |
Description of equipment family |
text(64) |
|
| EQUIPMENT_MODEL_ABREVIATION |
Abbreviation of Equipment Family |
text(16) |
|
| EQUIPMENT_CLASS_DESCRIPTION |
Description of the equipment class |
text(64) |
|
Back to topics
Down time classes (CFG_CLASSE_PARADA) (Copy of DIM_WORKTIME_CLASS)
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Downtime Class |
int(10) |
SCD - Business Key |
| WORKTIME_CLASS_DESCRIPTION |
Description of Stop class |
text(64) |
|
| WORKTIME_CLASS_ABREVIATION |
Abbreviation of Downtime Class |
text(16) |
|
Back to topics
Down time (CFG_PARADA) (Copy of DIM_WORKTIME_CLASSIFICATION)
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_CLASSIFICATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Downtime |
int(10) |
SCD - Business Key |
| WORKTIME_CLASSIFICATION_EXTERNAL_ID |
Downtime External Id |
text(32) |
|
| WORKTIME_CLASSIFICATION_DESCRIPTION |
Downtime Description |
text(64) |
|
| WORKTIME_CLASSIFICATION_ABREVIATION |
Abbreviation of Downtime |
text(16) |
|
Back to topics
Down time types (<enumerado>) (Copy of DIM_WORKTIME_TYPE)</enumerado>
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Downtime Type Id (Enumerated) |
text(32) |
SCD - Business Key |
| WORKTIME_TYPE_DESCRIPTION |
Downtime Type Description |
text(4000) |
|
Back to topics
Biome (CFG_BIOMA)
| Attribute |
Description |
Type |
Classification |
| DIM_BIOME_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Biome |
int(10) |
SCD - Business Key |
| BIOME_DESCRIPTION |
Biome Description |
text(50) |
|
| BIOME_ABBREVIATION |
Biome short description |
text(16) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Set type (CFG_TIPO_CONJUNTO)
| Attribute |
Description |
Type |
Classification |
| DIM_COMPOSITION_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Composition Type |
int(10) |
SCD - Business Key |
| COMPOSITION_TYPE_DESCRIPTION |
Set Type Description |
text(64) |
|
| COMPOSITION_TYPE_ABREVIATION |
Short description of set type |
text(64) |
|
Back to topics
Consolidation process (CON_CONSOLIDADO)
| Attribute |
Description |
Type |
Classification |
| DIM_CONSOLIDATED_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Consolidation |
int(10) |
SCD - Business Key |
| CONSOLIDATED_DATE |
Consolidation - reference date |
datetime |
|
| CONSOLIDATED_YEAR |
Consolidation Reference Month |
error |
|
| CONSOLIDATED_MONTH |
Consolidation Reference Year |
error |
|
| CONSOLIDATED_GENERATION_DATE |
Date of consolidation |
datetime |
|
Back to topics
Follow-ups report origin (TIP_APONTAMENTO_BOLETIM)
| Attribute |
Description |
Type |
Classification |
| DIM_CONSOLIDATED_FOLLOW_UP_ORIGIN_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Entry Follow-up Type |
text(2) |
SCD - Business Key |
| CONSOLIDATED_FOLLOW_UP_ORIGIN_DESCRIPTION |
Description |
text(128) |
|
Back to topics
Consumption place - chipping lines (CFG_LOCAL_CONSUMO)
| Attribute |
Description |
Type |
Classification |
| DIM_CONSUMPTION_PLACE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Consumption Center |
int(10) |
SCD - Business Key |
| CONSUMPTION_PLACE_DESCRIPTION |
Description of the place of consumption |
text(64) |
|
| CONSUMPTION_PLACE_ABREVIATION |
Comsumption local short description |
text(16) |
|
| YARD_DESCRIPTION |
Site Description |
text(128) |
|
Back to topics
Contract (CFG_CONTRATO)
| Attribute |
Description |
Type |
Classification |
| DIM_CONTRACT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Contract |
int(10) |
SCD - Business Key |
| CONTRACT_DESCRIPTION |
Contract Description |
text(64) |
|
| CONTRACT_ABREVIATION |
Abbreviation of Contract |
text(16) |
|
| CONTRACT_INITIAL_VALID_DATE |
Initial experiration date |
datetime |
|
| CONTRACT_END_VALID_DATE |
Expiration date |
datetime |
|
| CONTRACT_ERP_ID |
ERP Contract |
text(64) |
|
| CONTRACT_NUMBER |
Contract number |
text(45) |
|
Back to topics
Cost group (EXA_GRUPO_CR)
| Attribute |
Description |
Type |
Classification |
| DIM_COST_GROUP_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of the Costs Group |
int(10) |
SCD - Business Key |
| COST_GROUP_DESCRIPTION |
CR group name |
text(64) |
|
| COST_GROUP_TYPE |
Indicates whether the group is for (R) apportionment or for grouping of own operating (P) cost |
text(1) |
|
| COST_GROUP_ABBREVIATION |
CR Group Abbreviation |
text(32) |
|
| COST_TYPE |
Indicates whether the group is of direct (D) or indirect (I) cost |
text(1) |
|
Back to topics
Cost Group Configuration (EXA_CONFIG_GRUPO_CR)
| Attribute |
Description |
Type |
Classification |
| DIM_COST_GROUP_SETUP_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of the Configuration of Costs Group |
int(10) |
SCD - Business Key |
| COST_GROUP_SETUP_DESCRIPTION |
Description of cost classification |
text(64) |
|
| COST_OBJECT_GROUP_TYPE |
For expense groups, defines the macro classification of the group, which can be: T=Training, M=Maintenance, C=Charge (Goodwill, Historical Value, Acquisition Cost, etc.). For other cases N=Not Applicable |
text(1) |
|
| COST_TYPE |
Indicates whether the group is of (D) direct, (I) indirect, or (V) Nursery cost |
text(1) |
|
| CLASSIFICATION_TYPE |
For expense groups, defines the macro classification of the group, which can be: T=Training, M=Maintenance, C=Charge (Goodwill, Historical Value, Acquisition Cost, etc.). For other cases N=Not Applicable |
text(1) |
|
Back to topics
Cost object (CFG_CENTRO_CUSTO)
| Attribute |
Description |
Type |
Classification |
| DIM_COST_OBJECT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Cost Collector |
int(10) |
SCD - Business Key |
| COST_OBJECT_IDENTIFICATION |
Cost Object Identification |
text(32) |
SCD - Business Key |
| COST_OBJECT_DESCRIPTION |
Cost Collector Description |
text(64) |
|
| COST_OBJECT_ABBREVIATION |
Cost Collector short description |
text(32) |
|
| COST_OBJECT_SUPPLIER |
Automatic Code of Supplier |
int(10) |
SCD - Business Key |
| COST_OBJECT_TYPE |
Automatic Code of Cost Collector Type |
int(10) |
SCD - Business Key |
Back to topics
Cost classification (EXA_CLASSIFICACAO_CUSTO)
| Attribute |
Description |
Type |
Classification |
| DIM_COST_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of the Cost Collector Type |
int(10) |
SCD - Business Key |
| COST_TYPE_DESCRIPTION |
Description of cost classification |
text(64) |
|
Back to topics
Currency types (CFG_TIPO_MOEDA)
| Attribute |
Description |
Type |
Classification |
| DIM_CURRENCY_TYPE_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of Currency Type |
int(10) |
SCD - Business Key |
| CURRENCY_TYPE_DESCRIPTION |
Description of the currency type. |
text(128) |
|
| CURRENCY_TYPE_ABBREV |
Short description of the currency type. |
text(16) |
|
| CURRENCY_TYPE_SYMBOL |
Currency type symbol. |
text(32) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Location (CFG_LOCALIDADE) (Copy of DIM_LOCALITY)
| Attribute |
Description |
Type |
Classification |
| DIM_LOCALITY_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Location |
int(10) |
SCD - Business Key |
| LOCALITY_LEVEL1 |
Location Description Level 1 |
text(192) |
|
| LOCALITY_LEVEL2 |
Location Description Level 2 |
text(192) |
|
| LOCALITY_LEVEL3 |
Location Description Level 3 |
text(192) |
|
| LOCALITY_LEVEL4 |
Location Description Level 4 |
text(192) |
|
| LOCALITY_LEVEL5 |
Location Description Level 5 |
text(192) |
|
| LOCALITY_LEVEL6 |
Location Description Level 6 |
text(192) |
|
| LOCALITY_LEVEL7 |
Location Description Level 7 |
text(192) |
|
| OFFICIAL_CODE |
Location Code (Country) |
text(10) |
|
| LEVEL |
Location Type Code |
int(10) |
|
| AREA |
Location Area |
error |
|
Back to topics
Wood product types (CFG_TIPO_PRODUTO) (Copy of DIM_PRODUCT_TYPE)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product Type |
int(10) |
SCD - Business Key |
| PRODUCT_TYPE_DESCRIPTION |
Product Type Description |
text(64) |
|
| PRODUCT_TYPE_ABREVIATION |
Abbreviation of Product Type |
text(16) |
|
Back to topics
Transport woodyard (CFG_LOCAL) (Copy of DIM_YARD)
| Attribute |
Description |
Type |
Classification |
| DIM_YARD_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Location |
int(10) |
SCD - Business Key |
| YARD_DESCRIPTION |
Site Description |
text(128) |
|
| YARD_ABREVIATION |
Local short description |
text(24) |
|
| LOCAL_TYPE_DESCRIPTION |
Location Type |
text(64) |
|
| SUPPLIER_DESCRIPTION |
Supplier Description |
text(200) |
|
Back to topics
Road dimensions (CFG_DIMENSAO)
| Attribute |
Description |
Type |
Classification |
| DIM_DIMENSION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Road Dimension |
int(10) |
SCD - Business Key |
| DIMENSION_DESCRIPTION |
Dimension Description |
text(128) |
|
| DIMENSION_ABBREV |
Dimenson short description |
text(64) |
|
| DIMENSION_TYPE |
Dimension Type |
text(1) |
|
| DIMENSION_VALUE_TYPE |
Dimension Value |
text(1) |
|
Back to topics
Employee (CFG_FUNCIONARIO)
| Attribute |
Description |
Type |
Classification |
| DIM_EMPLOYEE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Employee |
int(10) |
SCD - Business Key |
| EMPLOYEE_REGISTRY |
Employee Registration |
text(64) |
|
| EMPLOYEE_NAME |
Employee Name |
text(96) |
|
Back to topics
Equipment (CFG_EQUIPAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment |
int(10) |
SCD - Business Key |
| EQUIPMENT_EXTERNAL_ID |
Equipment External ID |
text(32) |
|
| EQUIPMENT_SERIAL_NUMBER |
Equipment Serial Number |
text(64) |
|
| EQUIPMENT_DESCRIPTION |
Equipment description |
text(64) |
|
| EQUIPMENT_ABREVIATION |
Abbreviation of Equipment |
text(16) |
|
| EQUIPMENT_PURCHASE_DATE |
Equipment Purchase Date |
datetime |
|
| EQUIPMENT_OWNER_DESCRIPTION |
Description of equipment owner |
text(200) |
|
| EQUIPMENT_OWNER_ABREVIATION |
Abbreviation of the Supplier, Equipment Propietary |
text(16) |
|
| EQUIPMENT_MODEL_DESCRIPTION |
Description of the equipment model |
text(64) |
|
| EQUIPMENT_CLASS_DESCRIPTION |
Description of the equipment class |
text(64) |
|
Back to topics
Equipment classes (CFG_CLASSE_EQUIPAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment Class |
int(10) |
SCD - Business Key |
| EQUIPMENT_CLASS_DESCRIPTION |
Description of equipment class |
text(64) |
|
| EQUIPMENT_CLASS_ABREVIATION |
Abbreviation of Equipment Class |
text(16) |
|
Back to topics
Equipment family (CFG_FAMILIA_EQUIPAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_MODEL_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment Family |
int(10) |
SCD - Business Key |
| EQUIPMENT_MODEL_DESCRIPTION |
Description of equipment family |
text(64) |
|
| EQUIPMENT_MODEL_ABREVIATION |
Abbreviation of Equipment Family |
text(16) |
|
| EQUIPMENT_CLASS_DESCRIPTION |
Description of the equipment class |
text(64) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Farm (potential land) (TER_TERRA_POTENCIAL (FAZENDA))
| Attribute |
Description |
Type |
Classification |
| DIM_FARM_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Farm |
int(10) |
SCD - Business Key |
| FARM_PROPERTY_NAME |
Indicates the name of the farm |
text(128) |
|
| FARM_CAPTATION_PHASE |
Indicates which catchment stage the farm is in |
text(64) |
|
| FARM_CAPTATION_PHASE_STATUS |
For the farm capture stage, indicates the status |
text(64) |
|
| FARM_PROPERTY_STATUS |
Indicates the status of the property |
text(64) |
|
| FARM_PRIORITY |
Indicates the priority of the farm in the company´s land management. |
text(6) |
|
| FARM_PURPOSE |
Indicates the potential purpose of the farm |
text(13) |
|
| FARM_CONTACT_NAME |
Indicates the name of the person responsible for the farm |
text(128) |
|
| FARM_VILLAGE |
Indicates in which town the farm is located |
text(128) |
|
| FARM_WATERSHED |
Indicates the river basin where the farm is located |
text(64) |
|
| FARM_GEOREFERENCING_SITUATION |
Indicates the farm georeferencing status |
text(26) |
|
| FARM_INCRA_CODE |
Indicates the code with which the farm is registered with INCRA |
text(32) |
|
| FARM_ENTRANCE_COORDS |
Coordinates of the farm entrance |
text(256) |
|
| FARM_HEAD_COORDS |
Coordinates of the farm headquarters |
text(256) |
|
| FARM_VERTICES_COORDS |
Coordinates of property vertices |
text(256) |
|
| FARM_QTD_PROJECT |
Number of projects with intercession with the farm |
error |
|
| FARM_PROJECT_CODE |
Project code with larger area with intercession with the farm |
text(16) |
|
| FARM_PROJECT_NAME |
Project name with the largest area with intercession with the farm |
text(64) |
|
| FARM_PROJECT_AREA |
Project area with the largest area with intercession with the farm |
error |
|
| FARM_PROJECT_PROD_AREA |
Project productive area with the largest area with intercession with the farm |
error |
|
| FARM_PROJECT_NPROD_AREA |
Project non productive area with the largest area with intercession with the farm |
error |
|
Back to topics
Farm situation (TER_SITUACAO_PROPRIEDADE)
| Attribute |
Description |
Type |
Classification |
| DIM_FARM_SITUATION_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential code (automatic) of the situation of the property. |
int(10) |
SCD - Business Key |
| FARM_SITUATION_DESCRIPTION |
Description of the situation of the property |
text(64) |
|
| FARM_SITUATION_ABBREVIATION |
Short description of the property situation |
text(16) |
|
Back to topics
Field piles (CFG_PILHA)
| Attribute |
Description |
Type |
Classification |
| DIM_FIELD_PILE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Pile |
int(10) |
SCD - Business Key |
| FIELD_PILE_BLOCK |
Block |
text(64) |
|
| FIELD_PILE_NUMBER |
Pile |
text(16) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Regime (CFG_REGIME) (Copy of DIM_PLANTING_ESTABLISHMENT_SYSTEM)
| Attribute |
Description |
Type |
Classification |
| DIM_PLANTING_ESTABLISHMENT_SYSTEM_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Regime |
int(10) |
SCD - Business Key |
| PLANTING_STABLISHMENT_SYSTEM_DESCRIPTION |
Planting establishment system description |
text(64) |
|
| PLANTING_STABLISHMENT_SYSTEM_ABREVIATION |
Planting establishment system short description |
text(16) |
|
Back to topics
Genetic material (CFG_MATERIAL_GENETICO)
| Attribute |
Description |
Type |
Classification |
| DIM_GENETIC_MATERIAL_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Genetic Material |
int(10) |
SCD - Business Key |
| GENETIC_MATERIAL_DESCRIPTION |
Description of genetic material |
text(128) |
|
| GENETIC_MATERIAL_ABBREVIATION |
Genetic Material Short Description |
text(16) |
|
| WOOD_DENSITY |
Density Value |
error |
|
| PRODUCTIVITY |
Yield value |
error |
|
| SPECIFIC_WOOD_CONSUMPTION |
Specific consumption value M3 TSA |
numeric(3,2) |
|
| GRAVIMETRIC_PRODUCTIVITY |
Gravimetric yield value |
error |
|
| GENETIC_MATERIAL_TYPE |
Genetic Material Type (C=Clone, S=Seed) |
text(1) |
|
| AVAILABLE_FLAG |
Flag identifying that genetic material is available for use |
text(1) |
|
| SPECIE_DESCRIPTION |
Description of the species. |
text(128) |
|
| SPECIE_ABBREVIATION |
Specie short description |
text(16) |
|
| PURE_SPECIE_FLAG |
Identification Flag indicating that it is a pure species. |
text(1) |
|
| SPECIE_GROUP_DESCRIPTION |
Description of the species group. |
text(64) |
|
| SPECIE_GROUP_ABBREVIATION |
Species group short description |
text(16) |
|
| GENUS_DESCRIPTION |
Description of the genus |
text(64) |
|
| GENUS_ABBREVIATION |
Genre short description |
text(64) |
|
Back to topics
Genre (CFG_GENERO)
| Attribute |
Description |
Type |
Classification |
| DIM_GENUS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Genre |
int(10) |
SCD - Business Key |
| GENUS_DESCRIPTION |
Description of the genus |
text(64) |
|
| GENUS_ABREVIATION |
Abbreviation of Genre |
text(64) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Equipment (CFG_EQUIPAMENTO) (Copy of DIM_EQUIPMENT)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment |
int(10) |
SCD - Business Key |
| EQUIPMENT_EXTERNAL_ID |
Equipment External ID |
text(32) |
|
| EQUIPMENT_SERIAL_NUMBER |
Equipment Serial Number |
text(64) |
|
| EQUIPMENT_DESCRIPTION |
Equipment description |
text(64) |
|
| EQUIPMENT_ABREVIATION |
Abbreviation of Equipment |
text(16) |
|
| EQUIPMENT_PURCHASE_DATE |
Equipment Purchase Date |
datetime |
|
| EQUIPMENT_OWNER_DESCRIPTION |
Description of equipment owner |
text(200) |
|
| EQUIPMENT_OWNER_ABREVIATION |
Abbreviation of the Supplier, Equipment Propietary |
text(16) |
|
| EQUIPMENT_MODEL_DESCRIPTION |
Description of the equipment model |
text(64) |
|
| EQUIPMENT_CLASS_DESCRIPTION |
Description of the equipment class |
text(64) |
|
Back to topics
Equipment classes (CFG_CLASSE_EQUIPAMENTO) (Copy of DIM_EQUIPMENT_CLASS)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment Class |
int(10) |
SCD - Business Key |
| EQUIPMENT_CLASS_DESCRIPTION |
Description of equipment class |
text(64) |
|
| EQUIPMENT_CLASS_ABREVIATION |
Abbreviation of Equipment Class |
text(16) |
|
Back to topics
Equipment family (CFG_FAMILIA_EQUIPAMENTO) (Copy of DIM_EQUIPMENT_MODEL)
| Attribute |
Description |
Type |
Classification |
| DIM_EQUIPMENT_MODEL_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Equipment Family |
int(10) |
SCD - Business Key |
| EQUIPMENT_MODEL_DESCRIPTION |
Description of equipment family |
text(64) |
|
| EQUIPMENT_MODEL_ABREVIATION |
Abbreviation of Equipment Family |
text(16) |
|
| EQUIPMENT_CLASS_DESCRIPTION |
Description of the equipment class |
text(64) |
|
Back to topics
Down time classes (CFG_CLASSE_PARADA) (Copy of DIM_WORKTIME_CLASS)
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Downtime Class |
int(10) |
SCD - Business Key |
| WORKTIME_CLASS_DESCRIPTION |
Description of Stop class |
text(64) |
|
| WORKTIME_CLASS_ABREVIATION |
Abbreviation of Downtime Class |
text(16) |
|
Back to topics
Down time (CFG_PARADA) (Copy of DIM_WORKTIME_CLASSIFICATION)
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_CLASSIFICATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Downtime |
int(10) |
SCD - Business Key |
| WORKTIME_CLASSIFICATION_EXTERNAL_ID |
Downtime External Id |
text(32) |
|
| WORKTIME_CLASSIFICATION_DESCRIPTION |
Downtime Description |
text(64) |
|
| WORKTIME_CLASSIFICATION_ABREVIATION |
Abbreviation of Downtime |
text(16) |
|
Back to topics
Down time types (<enumerado>) (Copy of DIM_WORKTIME_TYPE)</enumerado>
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Downtime Type Id (Enumerated) |
text(32) |
SCD - Business Key |
| WORKTIME_TYPE_DESCRIPTION |
Downtime Type Description |
text(4000) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Measurement plan (SPP_PLANOS_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_PLAN_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Measurement Plan |
int(10) |
SCD - Business Key |
| PLAN_DESCRIPTION |
Plan Name |
text(16) |
|
| PLAN_YEAR |
Plan Year |
int(5) |
|
Back to topics
Inventory plot (SPP_PARCELAS)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_PLOT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Plot |
int(10) |
SCD - Business Key |
| PLOT_NRO |
Plot number |
text(15) |
|
| COORD_X |
Coordinate X |
numeric(24,7) |
|
| COORD_Y |
Coordinate Y |
numeric(24,7) |
|
Back to topics
Inventory prescription (SPP_PRESCRICOES)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_PRESCRIPTION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Prescription |
int(10) |
SCD - Business Key |
| PRESCRIPTION_DESCRIPTION |
Prescription Name |
text(64) |
|
Back to topics
Measurement Program (SPP_PROGRAMACAO_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_SCHEDULING_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Measurement Program |
int(10) |
SCD - Business Key |
| SCHEDULING_DESCRIPTION |
Schedule Name |
text(64) |
|
Back to topics
Measurement type (SPP_TIPOS_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_SOURCE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Measurement Type |
int(10) |
SCD - Business Key |
| SOURCE_NAME |
Inventory Type Name |
text(64) |
|
Back to topics
Strata (SPP_ESTRATOS)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_STRATUM_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Autmatic Code of Strata |
int(10) |
SCD - Business Key |
| STRATUM_NAME |
Stratum Name |
text(450) |
|
| STRATUM_QTY |
Number of Associated Subcompartments |
error |
|
| STRATUM_AREA |
Sum of associated subcompartment areas |
numeric(11,3) |
|
| STRATUM_FLAG_GIS |
S - Manually Generated Stratum, N - Automatically Generated |
text(1) |
|
Back to topics
Measurement object (SPP_OBJETIVOS_MEDICAO)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Measurement Objective |
int(10) |
SCD - Business Key |
| TYPE_NAME |
Measurement Objective Name |
text(50) |
|
| TYPE_DESCRIPTION |
Measurement Objective Description |
text(80) |
|
Back to topics
Inventory Work Order (PLA_ORDEM_SERVICO)
| Attribute |
Description |
Type |
Classification |
| DIM_INVENTORY_WORK_ORDER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Work Order |
int(10) |
SCD - Business Key |
| INVENTORY_WORK_ORDER_DESCRIPTION |
Work Order description |
text(64) |
|
Back to topics
Investment project (CFG_PROJETO_INVESTIMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_INVESTMENT_PROJECT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic code of the investment project |
text(20) |
SCD - Business Key |
| INVESTMENT_PROJECT_DESCRIPTION |
Investment project description |
text(64) |
|
| INVESTMENT_PROJECT_LONG_DESCRIPTION |
Extensive description of the investment project |
text(1000) |
|
Back to topics
Investment project task (CFG_TAREFA_PROJ_INV)
| Attribute |
Description |
Type |
Classification |
| DIM_INVESTMENT_PROJECT_TASK_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic code of the investment project task |
int(10) |
SCD - Business Key |
| INVESTMENT_PROJECT_TASK_CODE |
Investment project task code. |
text(20) |
|
| INVESTMENT_PROJECT_TASK_DESCRIPTION |
Investment project task description. |
text(25) |
|
| INVESTMENT_PROJECT_TASK_OBSERVATION |
Observation of the investment project task. |
text(300) |
|
| INVESTMENT_PROJECT_TASK_LONG_DESCRIPTION |
Long description of the investment project task. |
text(100) |
|
Back to topics
¶ DIM_LAND_CONTRACT
Contracts (land) (TER_CONTRATO)
| Attribute |
Description |
Type |
Classification |
| DIM_LAND_CONTRACT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Land Contract |
int(10) |
SCD - Business Key |
| LAND_CONTRACT_NUMBER |
Contract number |
text(15) |
|
| LAND_CONTRACT_ACTIVE |
Flag indicating whether the contract is active |
text(1) |
|
| LAND_CONTRACT_CONCLUSION |
Flag indicating if the contract has been terminated |
text(1) |
|
| LAND_CONTRACT_DEADLINE |
Contract term (in years) |
int(5) |
|
| LAND_CONTRACT_DATE |
Date the contract was signed |
datetime |
|
| LAND_CONTRACT_BEGIN_VALIDITY |
Contract validity start |
datetime |
|
| LAND_CONTRACT_FINE |
Penalty to be applied to contract payment quotas in case of delay |
numeric(5,2) |
|
| LAND_CONTRACT_PAYMENT_TIME_1 |
Frequency of payment of contract quotas |
text(13) |
|
| LAND_CONTRACT_PAYMENT_TIME_2 |
Type of payment of contract quotas (advance or overdue) |
text(10) |
|
| LAND_CONTRACT_ADJUSTMENT |
Type of adjustment applied to contract |
text(13) |
|
| LAND_CONTRACT_FIRST_PARCEL_DATE |
Payment date of contract quota |
datetime |
|
| LAND_CONTRACT_PARCEL_APPROVED |
Flag indicating if the contract is approved |
text(1) |
|
| LAND_CONTRACT_STATUS_CODE |
Contract status code |
text(128) |
|
| LAND_CONTRACT_PO_NUMBER |
Purchase Order Number |
text(15) |
|
| LAND_CONTRACT_IMMOBILIZED |
Asset code in the ERP system |
text(64) |
|
| LAND_CONTRACT_STATUS |
Contract status |
text(1) |
|
| LAND_CONTRACT_LEGALIZED_AREA |
Legalized area flag. 1=Yes, 0=No |
text(1) |
|
| LAND_CONTRACT_PROPERTY_CONSTRAINT |
Property restrictions flag |
text(1) |
|
| LAND_CONTRACT_PROMISE_DATE |
Contract promise date |
datetime |
|
| LAND_CONTRACT_END_DATE |
Contract termination date |
datetime |
|
| LAND_CONTRACT_VARIATION_PERCENTAGE |
Percentage limit of variation for contractual renegotiation |
numeric(5,2) |
|
| LAND_CONTRACT_COMMON_KIND |
Kind of nature or common |
text(8) |
|
| LAND_CONTRACT_COMMON_TYPE |
Common type |
text(1) |
|
| LAND_CONTRACT_RELEASED_AREA_TXT |
Descriptive text of the area released to the owner |
text(2000) |
|
| LAND_CONTRACT_INTEREST_PERCENTAGE |
Interest and arrears percentage |
numeric(5,2) |
|
| LAND_CONTRACT_PAYMENT_TERMS |
Payment condition description |
text(2000) |
|
| LAND_CONTRACT_ENDORSEMENT_DATE |
Endorsement date |
datetime |
|
| LAND_CONTRACT_ENDORSEMENT_NUMBER |
Endorsement number |
text(15) |
|
| LAND_CONTRACT_USEFULNESS_CODE |
Usefulness code |
int(10) |
|
| LAND_CONTRACT_LICENSING_DEADLINE |
Number of days to obtain licensing |
int(10) |
|
| LAND_CONTRACT_PROPERTY_RETURN |
Number of days to return the property |
int(10) |
|
| LAND_CONTRACT_CONTRACTUAL_CONDITION |
Contractual conditions description |
text(2000) |
|
| LAND_CONTRACT_DESCRIPTION_AUX |
Auxiliary description |
text(2000) |
|
| LAND_CONTRACT_NOTE |
Notes description |
text(2000) |
|
| LAND_CONTRACT_REGISTER_DATE |
Register date |
datetime |
|
| LAND_CONTRACT_STATE |
Record status. A = Active, H = History |
text(1) |
|
| LAND_CONTRACT_TAC_NUMBER |
Contractual amendment term number |
int(10) |
|
| LAND_CONTRACT_ENDORSED_FLAG |
Endorsed contract flag. 1=Yes, 0=No |
text(1) |
|
| LAND_CONTRACT_SUSPENDED_PAYMENT |
Suspended payments flag. 1=Yes, 0=No |
text(1) |
|
| LAND_CONTRACT_CONTRACT_AMENDMENT_DATE |
Contractual amendment date |
datetime |
|
| LAND_CONTRACT_PARCEL_UNIT_TYPE |
Parcel unit type |
text(1) |
|
| LAND_CONTRACT_OWNER_SIGNATURE |
Contract signed by the owner flag |
text(1) |
|
| LAND_CONTRACT_COMPANY_SIGNATURE |
Contract signed by the company flag |
text(1) |
|
| LAND_CONTRACT_VERIFY_DATE |
Verification date |
datetime |
|
| LAND_CONTRACT_VERIFY_FLAG |
Verification flag |
text(1) |
|
| LAND_CONTRACT_DESCRIPTION |
Contract Descrption |
text(250) |
|
Back to topics
¶ DIM_LAND_CONTRACT_TYPE
Type of contract (land) (TER_TIPO_CONTRATO)
| Attribute |
Description |
Type |
Classification |
| DIM_LAND_CONTRACT_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Contract Type |
int(10) |
SCD - Business Key |
| CONTRACT_TYPE_DESCRIPTION |
Description of the type of contract. |
text(30) |
|
Back to topics
¶ DIM_LAND_DOCUMENTATION
Land documents (TER_DOCTERRA)
| Attribute |
Description |
Type |
Classification |
| DIM_LAND_DOCUMENTATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Land Document |
int(10) |
SCD - Business Key |
| LAND_DOCUMENTATION_REFERENCE_CODE |
Land document reference code |
text(256) |
|
| LAND_DOCUMENTATION_NAME |
Land document Name |
text(256) |
|
| LAND_DOCUMENTATION_SITUATION |
Land document status |
text(128) |
|
| LAND_DOCUMENTATION_ASSET_NUMBER |
Land document Asset Number in ERP |
text(256) |
|
| LAND_DOCUMENTATION__ORIGIN |
Original Land Document Mark |
text(6) |
|
| LAND_DOCUMENTATION_ADDRESS |
Land document address |
text(256) |
|
| LAND_DOCUMENTATION_NIRF |
Land document Federal Revenue Registration Number |
text(96) |
|
| LAND_DOCUMENTATION_INCRA_CODE |
Code registered at Brazilian INCRA for land document |
text(96) |
|
| LAND_DOCUMENTATION_ADA_CODE |
Brazilian ADA code of the land document |
text(20) |
|
| LAND_DOCUMENTATION_REFERENCE |
Land document address reference |
text(256) |
|
| LAND_DOCUMENTATION_OWN_FLAG |
Indicates whether or not the land document is its own |
text(1) |
|
| LAND_DOCUMENTATION_COMDOMINIUM_FLAG |
Indicates if the land document belongs to a condominium |
text(1) |
|
| LAND_DOCUMENTATION_HAS_ENCUMBRANCE |
Indicates if the land document has lien |
text(1) |
|
| LAND_DOCUMENTATION_LEGAL_SITUATION |
Indicates whether the land document is legalized or not |
text(16) |
|
| LAND_DOCUMENTATION_AUTHORITY |
Indicates the titrator of the land document |
text(64) |
|
| LAND_DOCUMENTATION_ACQUISITION_MEANS |
Indicates the land document acquisition |
text(128) |
|
| LAND_DOCUMENTATION_REGISTER_NOTARY_OFFICE |
Indicates the registry office where the land documet registration was made |
text(512) |
|
| LAND_DOCUMENTATION_REGISTER_DOCUMENT |
Indicates the land document registration number |
text(96) |
|
| LAND_DOCUMENTATION_REGISTER_PAGES |
Indicates the land document log sheet |
text(256) |
|
| LAND_DOCUMENTATION_REGISTER_BOOK |
Indicates the land document registry book |
text(96) |
|
| LAND_DOCUMENTATION_REGISTER_DATE |
Indicates the lad document registeration date |
datetime |
|
| LAND_DOCUMENTATION_REGISTER_TYPE |
Indicates the land document register type |
text(17) |
|
| LAND_DOCUMENTATION_DOCUMENTAL_ANALYSIS |
Result of document analysis |
text(60) |
|
Back to topics
¶ DIM_LAND_USE_CHARACTERISTIC
Land use characteristic (CFG_CARACTERISTICA_USO_SOLO)
| Attribute |
Description |
Type |
Classification |
| DIM_LAND_USE_CHARACTERISTIC_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of the Land Use Characteristics |
int(10) |
SCD - Business Key |
| LAND_USE_CHARACTERISTIC_DESCRIPTION |
Description of land use feature |
text(64) |
|
| LAND_USE_CHARACTERISTIC_ABBREVIATION |
Land Use feature short description |
text(32) |
|
| LAND_USE_CHARACTERISTIC_IDENTIFICATION |
Land Use Feature ID |
error |
|
| LAND_USE_CHARACTERISTIC_TYPE |
Land use feature type. P-Plantable, N-Not Plantable, O-Other, S-Service |
text(1) |
|
| UTIL_AREA_FLAG |
Identification Flag indicating that the characteristic is from a useful area. |
text(1) |
|
| LAND_USE_CHARACTERISTIC_GROUP_DESCRIPTION |
Description of land use feature (parent) |
text(64) |
|
| LAND_USE_CHARACTERISTIC_GROUP_ABBREVIATION |
Land Use feature short description (father) |
text(32) |
|
| LAND_USE_CHARACTERISTIC_GROUP_IDENTIFICATION |
Land Use Feature ID (Parent) |
error |
|
| OFFICIAL_CODE_DISCRIMINATION |
Official government code for classification of the characteristic (Brazil ITR Code) |
int(10) |
|
Back to topics
¶ DIM_LAND_USE_TRANSITION
Land use transition (CFG_TRANSICAO_USO_SOLO)
| Attribute |
Description |
Type |
Classification |
| DIM_LAND_USE_TRANSITION_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code for the land use transition. |
int(10) |
SCD - Business Key |
| LAND_USE_TRANSITION_DESCRIPTION |
Description of the land use transition |
text(64) |
|
Back to topics
Licenses (TER_LICENCA_TERRA_POT)
| Attribute |
Description |
Type |
Classification |
| DIM_LICENSE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Land License |
int(10) |
SCD - Business Key |
| LICENSE_PROTOCOL |
License Request Protocol Number |
text(120) |
|
| LICENSE_NUMBER |
License Number |
text(120) |
|
| LICENSE_TYPE |
License Type |
text(64) |
|
| LICENSE_OBJECT |
License Object |
text(64) |
|
| LICENSE_ART |
TRN (Technical Responsibility Note) |
error |
|
| LICENSE_NOTE |
Note (free text) |
text(2000) |
|
| LICENSE_LICENSING_ORGAN |
Agency responsible for license review and release |
text(64) |
|
| LICENSE_LOCAL_PUBLISHING_REQUIREMENT |
Place of publication of license application |
text(64) |
|
| LICENSE_LOCAL_PUBLISHING_RECEIVING |
Place of publication of license receipt |
text(64) |
|
Back to topics
Location (CFG_LOCALIDADE)
| Attribute |
Description |
Type |
Classification |
| DIM_LOCALITY_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Location |
int(10) |
SCD - Business Key |
| LOCALITY_LEVEL1 |
Location Description Level 1 |
text(192) |
|
| LOCALITY_LEVEL2 |
Location Description Level 2 |
text(192) |
|
| LOCALITY_LEVEL3 |
Location Description Level 3 |
text(192) |
|
| LOCALITY_LEVEL4 |
Location Description Level 4 |
text(192) |
|
| LOCALITY_LEVEL5 |
Location Description Level 5 |
text(192) |
|
| LOCALITY_LEVEL6 |
Location Description Level 6 |
text(192) |
|
| LOCALITY_LEVEL7 |
Location Description Level 7 |
text(192) |
|
| OFFICIAL_CODE |
Location Code (Country) |
text(10) |
|
| LEVEL |
Location Type Code |
int(10) |
|
| AREA |
Location Area |
error |
|
Back to topics
Location type (CFG_TIPO_LOCAL)
| Attribute |
Description |
Type |
Classification |
| DIM_LOCAL_TYPE_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Location Type |
int(10) |
SCD - Business Key |
| LOCAL_TYPE_DESCRIPTION |
Location Type Description |
text(64) |
|
| LOCAL_TYPE_ABREVIATION |
Short description of location type |
text(16) |
|
Back to topics
Fund (CFG_MACRO_REGIAO)
| Attribute |
Description |
Type |
Classification |
| DIM_MACRO_REGION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Fund ID |
int(10) |
SCD - Business Key |
| MACRO_REGION_EXTERNAL_ID |
External ID of Fund |
error |
|
| MACRO_REGION_DESCRIPTION |
Fund description |
text(96) |
|
| MACRO_REGION_ABREVIATION |
Fund abreviation |
text(24) |
|
Back to topics
Manageable activity (TER_ATIVIDADE_GERENCIAVEL)
| Attribute |
Description |
Type |
Classification |
| DIM_MANAGEABLE_ACTIVITY_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the manageable activity. |
int(10) |
SCD - Business Key |
| MANAGEABLE_ACTIVITY_DESCRIPTION |
Description of the manageable activity |
text(64) |
|
| MANAGEABLE_ACTIVITY_ABBREVIATION |
Short description of the manageable activity |
text(16) |
|
| MANAGEABLE_ACTIVITY_GROUP_DESCRIPTION |
Group description of the manageable activity |
text(64) |
|
| MANAGEABLE_ACTIVITY_GROUP_ABBREVIATION |
Short group description of the manageable activity |
text(16) |
|
Back to topics
Management unit (CFG_UNIDADE_GESTAO)
| Attribute |
Description |
Type |
Classification |
| DIM_MANAGEMENT_UNIT_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Management Unit |
int(10) |
SCD - Business Key |
| MANAGEMENT_UNIT_DESCRIPTION |
Management Unit Description |
text(64) |
|
| MANAGEMENT_UNIT_ABBREVIATION |
Short description of the Management Unit |
text(16) |
|
Back to topics
Material (CFG_MATERIAL)
| Attribute |
Description |
Type |
Classification |
| DIM_MATERIAL_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Material |
int(10) |
SCD - Business Key |
| MATERIAL_EXTERNAL_ID |
Material External ID |
text(32) |
|
| MATERIAL_DESCRIPTION |
Material description |
text(384) |
|
| MATERIAL_ABREVIATION |
Abbreviation of Material |
text(16) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Measure unit (CFG_UNIDADE_MEDIDA)
| Attribute |
Description |
Type |
Classification |
| DIM_MEASURE_UNIT_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the unit of measurement. |
int(10) |
SCD - Business Key |
| MEASURE_UNIT_DESCRIPTION |
Description of the unit of measurement |
text(64) |
|
| MEASURE_UNIT_ABBREV |
Short description of the unit of measurement |
text(16) |
|
Back to topics
Moment type (CFG_TIPO_MOMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_MOMENT_TYPE_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the moment type. |
int(10) |
SCD - Business Key |
| MOMENT_TYPE_CODE |
Moment type ID |
text(8) |
|
| MOMENT_TYPE_DESCRIPTION |
Description of the moment type |
text(64) |
|
Back to topics
Reasons (CFG_ITEM_MOTIVO)
| Attribute |
Description |
Type |
Classification |
| DIM_MOTIVE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Reason |
int(10) |
SCD - Business Key |
| MOTIVE_DESCRIPTION |
Description of the purpose |
text(64) |
|
| MOTIVE_GROUP_DESCRIPTION |
Description of the purpose group |
text(64) |
|
Back to topics
Operations (CFG_OPERACAO)
| Attribute |
Description |
Type |
Classification |
| DIM_OPERATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Operation |
int(10) |
SCD - Business Key |
| OPERATION_EXTERNAL_ID |
Operation External ID |
text(10) |
|
| OPERATION_DESCRIPTION |
Description of the operation |
text(128) |
|
| OPERATION_ABREVIATION |
Abbreviation of Operation |
text(16) |
|
| GROUPER_OPERATION_DESCRIPTION |
Grouper Operation Description |
text(250) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Operation groups (CFG_GRUPO_OPERACAO_MANEJO)
| Attribute |
Description |
Type |
Classification |
| DIM_OPERATION_GROUP_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Operation Group |
int(10) |
SCD - Business Key |
| OPERATION_GROUP_DESCRIPTION |
Description of operation group |
text(64) |
|
| OPERATION_GROUP_ABREVIATION |
Abbreviation of Operation Group |
text(16) |
|
| OPERATION_GROUP_SEQUENCE |
Operation group sequence |
error |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Employee (CFG_FUNCIONARIO) (Copy of DIM_EMPLOYEE)
| Attribute |
Description |
Type |
Classification |
| DIM_EMPLOYEE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Employee |
int(10) |
SCD - Business Key |
| EMPLOYEE_REGISTRY |
Employee Registration |
text(64) |
|
| EMPLOYEE_NAME |
Employee Name |
text(96) |
|
Back to topics
Location (CFG_LOCALIDADE) (Copy of DIM_LOCALITY)
| Attribute |
Description |
Type |
Classification |
| DIM_LOCALITY_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Location |
int(10) |
SCD - Business Key |
| LOCALITY_LEVEL1 |
Location Description Level 1 |
text(192) |
|
| LOCALITY_LEVEL2 |
Location Description Level 2 |
text(192) |
|
| LOCALITY_LEVEL3 |
Location Description Level 3 |
text(192) |
|
| LOCALITY_LEVEL4 |
Location Description Level 4 |
text(192) |
|
| LOCALITY_LEVEL5 |
Location Description Level 5 |
text(192) |
|
| LOCALITY_LEVEL6 |
Location Description Level 6 |
text(192) |
|
| LOCALITY_LEVEL7 |
Location Description Level 7 |
text(192) |
|
| OFFICIAL_CODE |
Location Code (Country) |
text(10) |
|
| LEVEL |
Location Type Code |
int(10) |
|
| AREA |
Location Area |
error |
|
Back to topics
Wood products (CFG_PRODUTO) (Copy of DIM_PRODUCT)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product |
int(10) |
SCD - Business Key |
| PRODUCT_EXTERNAL_ID |
Product External ID |
text(32) |
|
| PRODUCT_DESCRIPTION |
Product description |
text(64) |
|
| PRODUCT_ABREVIATION |
Abbreviation of Product |
text(16) |
|
Back to topics
Wood product types (CFG_TIPO_PRODUTO) (Copy of DIM_PRODUCT_TYPE)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product Type |
int(10) |
SCD - Business Key |
| PRODUCT_TYPE_DESCRIPTION |
Product Type Description |
text(64) |
|
| PRODUCT_TYPE_ABREVIATION |
Abbreviation of Product Type |
text(16) |
|
Back to topics
Type of land use (type of property) (CFG_TIPO_USO_SOLO)
| Attribute |
Description |
Type |
Classification |
| DIM_OWNERSHIP_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Property Type |
int(10) |
SCD - Business Key |
| OWNERSHIP_TYPE_DESCRIPTION |
Property Type Description |
text(64) |
|
| OWNERSHIP_TYPE_ABBREVIATION |
Short description of the property type |
text(16) |
|
Back to topics
Payment process (CTL_PROCESSO_PAGAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_PAYMENT_PROCESS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Payment Process |
int(10) |
SCD - Business Key |
| PAYMENT_PROCESS_DESCRIPTION |
Payment Process Description |
text(32) |
|
| PAYMENT_PROCESS_STATUS |
Payment process status. It can be: P - Paid; I-Inserted; A-Approved; C-Calculated; E-Sent to ERP |
text(1) |
|
| DIM_START_DATE_ID |
Payment process - start date |
datetime |
|
| DIM_FINISH_DATE_ID |
Payment process - end date |
datetime |
|
| DIM_CALCULATE_DATE_ID |
Payment process calculation date |
datetime |
|
| PAYMENT_VALUE |
Calculated payment amount |
numeric(18,2) |
|
Back to topics
Individuals and companies (VW_TER_PESSOA)
| Attribute |
Description |
Type |
Classification |
| DIM_PERSON_COMPANY_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Person or Entity |
int(10) |
SCD - Business Key |
| PERSON_COMPANY_NAME |
Description of natural or legal person |
text(200) |
|
| PERSON_COMPANY_SHORT_NAME |
Company or Individual short description |
text(16) |
|
| PERSON_COMPANY_OFFICIAL_REGISTER |
Official document number of the natural or legal person |
text(40) |
|
| PERSON_COMPANY_TYPE |
Type of person. F=Natural and J=Legal |
text(1) |
|
| PERSON_COMPANY_CONTRACTOR_FLAG |
Flag indicating that the person is a service provider. |
text(1) |
|
| PERSON_COMPANY_ERP_CODE |
Person ERP Code |
text(64) |
|
Back to topics
Plan (PLA_PLANO_OPERACAO)
| Attribute |
Description |
Type |
Classification |
| DIM_PLAN_ID |
Plan Code |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Plan |
int(10) |
SCD - Business Key |
| PLAN_DESCRIPTION |
Plan Description |
text(64) |
|
| PLAN_ABBREV |
Plan short Description |
text(16) |
|
| PLAN_STATE_TYPE |
Plan Status. C=Creation, A=Alteration, E=Execution and I=Restricted |
text(1) |
|
| PLAN_TYPE |
Plan Type. R=Budget, P=Operational |
text(1) |
|
| PLAN_INITIAL_PERIOD |
Plan - start date |
datetime |
|
| PLAN_END_PERIOD |
Plan - end date |
datetime |
|
Back to topics
Wood products (CFG_PRODUTO) (Copy of DIM_PRODUCT)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product |
int(10) |
SCD - Business Key |
| PRODUCT_EXTERNAL_ID |
Product External ID |
text(32) |
|
| PRODUCT_DESCRIPTION |
Product description |
text(64) |
|
| PRODUCT_ABREVIATION |
Abbreviation of Product |
text(16) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Regime (CFG_REGIME)
| Attribute |
Description |
Type |
Classification |
| DIM_PLANTING_ESTABLISHMENT_SYSTEM_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Regime |
int(10) |
SCD - Business Key |
| PLANTING_STABLISHMENT_SYSTEM_DESCRIPTION |
Planting establishment system description |
text(64) |
|
| PLANTING_STABLISHMENT_SYSTEM_ABREVIATION |
Planting establishment system short description |
text(16) |
|
Back to topics
Position (CFG_CARGO)
| Attribute |
Description |
Type |
Classification |
| DIM_POSITION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Position |
int(10) |
SCD - Business Key |
| POSITION_DESCRIPTION |
Job description |
text(128) |
|
| POSITION_ABREVIATION |
Abbreviation of Position |
text(16) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Movements (EXA_TIPO_MOVIMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_POSTING_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Addition Movements: D=Direct Allocation, I=Indirect Allocation. A=Adjustment on the Reduction Movement: E=Depletion, P=Reduction caused by Wood Loss, R=Depletion due Reversion, B=Manual Reduction, M=Manual Depletion. Transfer Movements(Reduction/Addiction): T=Coppice Transfer, G=Change of GIS Area |
text(20) |
SCD - Business Key |
| POSTING_TYPE_DESCRIPTION |
Description of the movement type. |
text(64) |
|
| POSTING_TYPE_KEY |
It can be I=Input, O=Output or T=Transfer (Generates Input and Output) |
text(1) |
|
| POSTING_TYPE_IDENTIFICATION |
Movement Type |
text(20) |
|
| DEPLETION_POSTING_TYPE |
Only applicable to outgoing movements (TIP_SENTIDO = S). Indicates whether the movement generates depletion |
text(1) |
|
Back to topics
Prescription (CFG_PRESCRICAO)
| Attribute |
Description |
Type |
Classification |
| DIM_PRESCRIPTION_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the prescription. |
int(10) |
SCD - Business Key |
| PRESCRIPTION_TABLE |
Description of the prescription table. |
text(64) |
|
| PRESCRIPTION_WORK_SCHEME |
Management description. |
text(64) |
|
| PRESCRIPTION_REFERENCE_DAYS |
Number of reference days |
error |
|
| PRESCRIPTION_VALIDITY_DAYS |
Number of days of validity. |
error |
|
| PRESCRIPTION_REFERENCE_ACTIVITY |
Description of the referenced activity |
text(64) |
|
| PRESCRIPTION_INDICATED_ACTIVITY |
Description of the indicated activity |
text(64) |
|
| PRESCRIPTION_PHASE |
Description of the prescription phase |
text(64) |
|
| PRESCRIPTION_TYPE |
Prescription type. A = Automatic or M = Manual |
text(1) |
|
Back to topics
Prescription phase (CFG_FASE_PRESCRICAO)
| Attribute |
Description |
Type |
Classification |
| DIM_PRESCRIPTION_PHASE_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the prescription phase. |
int(10) |
SCD - Business Key |
| PRESCRIPTION_PHASE_DESCRIPTION |
Description of the prescription phase. |
text(64) |
|
| PRESCRIPTION_PHASE_ABBREV |
Short description of the prescription phase. |
text(16) |
|
Back to topics
Operations (CFG_OPERACAO) (Copy of DIM_OPERATION)
| Attribute |
Description |
Type |
Classification |
| DIM_OPERATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Operation |
int(10) |
SCD - Business Key |
| OPERATION_EXTERNAL_ID |
Operation External ID |
text(10) |
|
| OPERATION_DESCRIPTION |
Description of the operation |
text(128) |
|
| OPERATION_ABREVIATION |
Abbreviation of Operation |
text(16) |
|
Back to topics
Wood products (CFG_PRODUTO) (Copy of DIM_PRODUCT)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product |
int(10) |
SCD - Business Key |
| PRODUCT_EXTERNAL_ID |
Product External ID |
text(32) |
|
| PRODUCT_DESCRIPTION |
Product description |
text(64) |
|
| PRODUCT_ABREVIATION |
Abbreviation of Product |
text(16) |
|
Back to topics
Supplier (CFG_FORNECEDOR) (Copy of DIM_SUPPLIER)
| Attribute |
Description |
Type |
Classification |
| DIM_SUPPLIER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Supplier |
int(10) |
SCD - Business Key |
| SUPPLIER_DESCRIPTION |
Supplier Description |
text(200) |
|
| SUPPLIER_ABBREVIATION |
Supplier short description |
text(16) |
|
| OWN_COMPANY |
Indicates if the company is a service taker or own |
text(1) |
|
Back to topics
Process (CFG_PROCESSO)
| Attribute |
Description |
Type |
Classification |
| DIM_PROCESS_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the process. |
int(10) |
SCD - Business Key |
| PROCESS_DESCRIPTION |
Process description |
text(64) |
|
| PROCESS_ABBREV |
Short description of the process. |
text(16) |
|
| PROCESS_TYPE |
Type of process. A = Environmental Management, C = Harvest, D = Demands, E = Roads, G = Cadastral Activities, I = Inventory, M = Native Management, O = Events, P = Sawmill, R = Lands, S = Forestry, T = Transport, V = Nursery, X = SEGX Events |
text(1) |
|
Back to topics
Wood products (CFG_PRODUTO)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product |
int(10) |
SCD - Business Key |
| PRODUCT_EXTERNAL_ID |
Product External ID |
text(32) |
|
| PRODUCT_DESCRIPTION |
Product description |
text(64) |
|
| PRODUCT_ABREVIATION |
Abbreviation of Product |
text(16) |
|
Back to topics
Productivity rate (CFG_ESCALA_RENDIMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCTIVITY_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Productivity Scale |
int(10) |
SCD - Business Key |
| PRODUCTIVITY_CLASS_DESCRIPTION |
Description of yield scale |
text(64) |
|
| PRODUCTIVITY_CLASS_ABREVIATION |
Abbreviation of Productivity Scale |
text(16) |
|
Back to topics
Wood product types (CFG_TIPO_PRODUTO)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product Type |
int(10) |
SCD - Business Key |
| PRODUCT_TYPE_DESCRIPTION |
Product Type Description |
text(64) |
|
| PRODUCT_TYPE_ABREVIATION |
Abbreviation of Product Type |
text(16) |
|
Back to topics
Tract (CFG_PROJETO)
| Attribute |
Description |
Type |
Classification |
| DIM_PROJECT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Tract ID |
int(10) |
SCD - Business Key |
| PROJECT_NAME |
Tract description |
text(64) |
|
| PROJECT_ID |
Tract ID |
text(16) |
|
| PROJECT_AREA |
Tract Area |
numeric(8,2) |
|
| DIM_REGION_ID |
Property ID |
int(10) |
|
Back to topics
Prospection steps (TER_ETAPA_CAPTACAO)
| Attribute |
Description |
Type |
Classification |
| DIM_PROSPECTION_STEP_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the capture step. |
int(10) |
SCD - Business Key |
| PROSPECTION_STEP_DESCRIPTION |
Description of the capture stage. |
text(64) |
|
| PROSPECTION_STEP_ABBREVIATION |
Short description of the capture stage. |
text(16) |
|
Back to topics
Measurement plan (SPP_PLANOS_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| DIM_QUALI_PLAN_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Measurement Plan |
int(10) |
SCD - Business Key |
| PLAN_DESCRIPTION |
Plan Name |
text(16) |
|
| PLAN_YEAR |
Plan Year |
int(5) |
|
Back to topics
PLOTS (SPP_PARCELAS)
| Attribute |
Description |
Type |
Classification |
| DIM_QUALI_PLOT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Plot |
int(10) |
SCD - Business Key |
| PLOT_NRO |
Plot number |
text(15) |
|
| COORD_X |
Coordinate X |
numeric(24,7) |
|
| COORD_Y |
Coordinate Y |
numeric(24,7) |
|
Back to topics
Measurement Program (SPP_PROGRAMACAO_MEDICOES)
| Attribute |
Description |
Type |
Classification |
| DIM_QUALI_SCHEDULING_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Measurement Program |
int(10) |
SCD - Business Key |
| SCHEDULING_DESCRIPTION |
Schedule Name |
text(64) |
|
Back to topics
Measurement object (SPP_OBJETIVOS_MEDICAO)
| Attribute |
Description |
Type |
Classification |
| DIM_QUALI_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Measurement Objective |
int(10) |
SCD - Business Key |
| TYPE_NAME |
Measurement Objective Name |
text(50) |
|
| TYPE_DESCRIPTION |
Measurement Objective Description |
text(80) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Property (CFG_REGIAO)
| Attribute |
Description |
Type |
Classification |
| DIM_REGION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Property ID |
int(10) |
SCD - Business Key |
| REGION_DESCRIPTION |
Property description |
text(64) |
|
| REGION_ABBREVIATION |
Property abreviation |
text(16) |
|
| REGION_ID |
Property Code |
error |
|
| REGION_AREA |
Property Area |
numeric(8,2) |
|
Back to topics
Operation groups (CFG_GRUPO_OPERACAO_MANEJO) (Copy of DIM_OPERATION_GROUP)
| Attribute |
Description |
Type |
Classification |
| DIM_OPERATION_GROUP_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Operation Group |
int(10) |
SCD - Business Key |
| OPERATION_GROUP_DESCRIPTION |
Description of operation group |
text(64) |
|
| OPERATION_GROUP_ABREVIATION |
Abbreviation of Operation Group |
text(16) |
|
| OPERATION_GROUP_SEQUENCE |
Operation group sequence |
error |
|
Back to topics
Wood products (CFG_PRODUTO) (Copy of DIM_PRODUCT)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product |
int(10) |
SCD - Business Key |
| PRODUCT_EXTERNAL_ID |
Product External ID |
text(32) |
|
| PRODUCT_DESCRIPTION |
Product description |
text(64) |
|
| PRODUCT_ABREVIATION |
Abbreviation of Product |
text(16) |
|
Back to topics
Wood product types (CFG_TIPO_PRODUTO) (Copy of DIM_PRODUCT_TYPE)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product Type |
int(10) |
SCD - Business Key |
| PRODUCT_TYPE_DESCRIPTION |
Product Type Description |
text(64) |
|
| PRODUCT_TYPE_ABREVIATION |
Abbreviation of Product Type |
text(16) |
|
Back to topics
User (CFG_USUARIO) (Copy of DIM_USER)
| Attribute |
Description |
Type |
Classification |
| DIM_USER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of User |
int(10) |
SCD - Business Key |
| USER_NAME |
User Description |
text(64) |
|
| USER_LOGIN |
User Login |
text(64) |
|
| USER_EMAIL |
User Email |
text(64) |
|
| LOCK_FLAG |
Identification Flag that the user is locked in the system. (0 = Unlocked and 1 = Locked). |
error |
|
| EMPLOYEE_CODE |
Automatic Code of Employee |
int(10) |
|
| EMPLOYEE_REGISTER |
Employee Registration |
text(64) |
|
| EMPLOYEE_NAME |
Name of the employee. |
text(96) |
|
| ADMISSION_DATE |
Employee Admission Date |
error |
|
| POSITION_DESCRIPTION |
Description of the employee´s position |
text(128) |
|
| COMPANY_NAME |
Name of the company the user works for. |
text(200) |
|
Back to topics
Resource Group (EXA_GRUPO_RECURSO)
| Attribute |
Description |
Type |
Classification |
| DIM_RESOURCE_GROUP_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Resource Group |
int(10) |
SCD - Business Key |
| RESOURCE_GROUP_ABBREVIATION |
Resource Group Name |
text(64) |
|
| RESOURCE_GROUP_DESCRIPTION |
Free explanatory text |
text(300) |
|
| RESOURCE_GROUP_TYPE |
Indicates whether the grouping is from E-Equipment or C-Job Position (Labor) |
text(1) |
|
Back to topics
Roads (CFG_ESTRADA)
| Attribute |
Description |
Type |
Classification |
| DIM_ROAD_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Road |
int(10) |
SCD - Business Key |
| ROAD_CODE |
Road ID |
text(32) |
|
| ROAD_DESCRIPTION |
Road Description |
text(135) |
|
| ROAD_LENGTH |
Length value |
numeric(38,8) |
|
| ROAD_PROPERTY |
Road Owner Description |
text(64) |
|
| ROAD_TYPE |
Description of the road type |
text(64) |
|
| ROAD_PAVEMENT |
Description of pavement type |
text(64) |
|
| ROAD_CONDITION |
Description of the state of the road |
text(64) |
|
| ROAD_AVAILABILITY |
Description of road availability period |
text(64) |
|
| ROAD_SPEED_RANGE |
Speed Range Description |
text(64) |
|
| ROAD_TRACK_TYPE |
Track Type Description |
text(64) |
|
Back to topics
Type of person (TER_TIPO_PESSOA)
| Attribute |
Description |
Type |
Classification |
| DIM_ROLE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Person Type |
int(10) |
SCD - Business Key |
| ROLE_DESCRIPTION |
Description of the type of person. |
text(64) |
|
| ROLE_ABBREVIATION |
Short description of the type of person. |
text(32) |
|
Back to topics
Propagation system (CFG_SISTEMA_PROPAGACAO)
| Attribute |
Description |
Type |
Classification |
| DIM_SEEDLING_GENERATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Propagation System |
int(10) |
SCD - Business Key |
| SEEDLING_GENERATION_DESCRIPTION |
Description of the propagation system. |
text(64) |
|
| SEEDLING_GENERATION_ABBREVIATION |
Propagation system short description |
text(16) |
|
Back to topics
Operations (CFG_OPERACAO) (Copy of DIM_OPERATION)
| Attribute |
Description |
Type |
Classification |
| DIM_OPERATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Operation |
int(10) |
SCD - Business Key |
| OPERATION_EXTERNAL_ID |
Operation External ID |
text(10) |
|
| OPERATION_DESCRIPTION |
Description of the operation |
text(128) |
|
| OPERATION_ABREVIATION |
Abbreviation of Operation |
text(16) |
|
Back to topics
Class site (CFG_CLASSE_SITIO)
| Attribute |
Description |
Type |
Classification |
| DIM_SITE_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Syte Class |
int(10) |
SCD - Business Key |
| SITE_CLASS_DESCRIPTION |
Site class unit description |
text(64) |
|
| SITE_CLASS_ABBREVIATION |
Site Class short description |
text(16) |
|
| MIN_VALUE_SITE_CLASS |
Minimum value of site class. |
numeric(4,2) |
|
| MAX_VALUE_SITE_CLASS |
Maximum value of site class. |
numeric(4,2) |
|
Back to topics
Slope (CFG_DECLIVIDADE)
| Attribute |
Description |
Type |
Classification |
| DIM_SLOPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Slope |
int(10) |
SCD - Business Key |
| SLOPE_DESCRIPTION |
Description of the slope |
text(64) |
|
| SLOPE_ABBREVIATION |
Slope short description |
text(16) |
|
| START_VALUE |
Initial value of slope range |
numeric(5,2) |
|
| FINISH_VALUE |
Final value of slope range |
numeric(5,2) |
|
| UTIL_AREA_FLAG |
Identification Flag indicating that the characteristic is from a useful area. |
text(1) |
|
| HARVEST_OPERATION_TYPE |
Harvest Operation Type |
text(3) |
|
Back to topics
Soil type (CFG_TIP_SOLO)
| Attribute |
Description |
Type |
Classification |
| DIM_SOIL_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Soil Type |
int(10) |
SCD - Business Key |
| SOIL_TYPE_DESCRIPTION |
Description of soil type. |
text(256) |
|
| SOIL_TYPE_ABBREVIATION |
Short description of soil type. |
text(16) |
|
| UTIL_AREA_FLAG |
Identification Flag indicating that the characteristic is from a useful area. |
text(1) |
|
| SOIL_TYPE_GROUP_DESCRIPTION |
Description of the soil type group. |
text(64) |
|
| SOIL_TYPE_GROUP_ABBREVIATION |
Soil type Group short description |
text(16) |
|
Back to topics
Spacing (CFG_ESPACAMENTO)
| Attribute |
Description |
Type |
Classification |
| DIM_SPACING_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Spacing |
int(10) |
SCD - Business Key |
| SPACING_DESCRIPTION |
Description of line spacing x plant spacing |
text(64) |
|
| SPACING_ABBREVIATION |
Spacing short description |
text(16) |
|
| ROWS_DISTANCE |
Distance between planting lines |
error |
|
| TREE_DISTANCE |
Distance between plants |
error |
|
| TREE_PER_HECTARE |
Number of trees per hectare |
numeric(8,2) |
|
Back to topics
Species (CFG_ESPECIE)
| Attribute |
Description |
Type |
Classification |
| DIM_SPECIE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Species |
int(10) |
SCD - Business Key |
| SPECIE_DESCRIPTION |
Description of the species. |
text(128) |
|
| SPECIE_ABBREVIATION |
Specie short description |
text(16) |
|
| PURE_SPECIE_FLAG |
Identification Flag indicating that it is a pure species. |
text(1) |
|
| SPECIE_GROUP_DESCRIPTION |
Description of the species group. |
text(64) |
|
| SPECIE_GROUP_ABBREVIATION |
Species group short description |
text(16) |
|
| GENUS_DESCRIPTION |
Description of the genus |
text(64) |
|
| GENUS_ABBREVIATION |
Genre short description |
text(64) |
|
Back to topics
¶ DIM_STAND
Stand (CFG_USO_SOLO)
| Attribute |
Description |
Type |
Classification |
| DIM_STAND_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Forest Register (Stands) |
int(10) |
SCD - Business Key |
| STAND_FULL_KEY |
Complete code for the stand. Property_Code+-+Tract_Code+-+Stand_ID+-+Cycle+-+Rotation+-+Operational_Plan_Code |
text(446) |
|
| MACRO_REGION_CODE |
Macro Region Code |
int(10) |
|
| MACRO_REGION_DESCRIPTION |
Fund description |
text(96) |
|
| REGION_CODE |
Region Code |
int(10) |
|
| REGION_ID |
Property Code |
error |
|
| REGION_DESCRIPTION |
Property description |
text(64) |
|
| PROJECT_CODE |
Forest Project Code |
int(10) |
|
| PROJECT_ID |
Tract ID |
text(16) |
|
| PROJECT_NAME |
Tract Name |
text(128) |
|
| STAND_BLOCK_CODE |
Block Code |
int(10) |
|
| STAND_GROUP_IDENTIFICATION |
Compartment Code |
text(64) |
|
| STAND_GROUP_DESCRIPTION |
Compartment description |
text(64) |
|
| STAND_CODE |
Stand key |
text(24) |
|
| CYCLE |
Planting cycle number. |
int(5) |
|
| ROTATION |
Planting rotation number. |
int(5) |
|
| PLANTING_YEAR |
Planting Year |
error |
|
| PLANTING_MONTH |
Month of planting |
int(5) |
|
| PLANTING_DATE |
Planting date |
datetime |
|
| TRANSPORT_DISTANCE |
Distance to nearest consumption center |
float |
|
| STAND_AREA |
Stand area |
numeric(7,2) |
|
| REGISTER_STATUS |
Register status. A=Active, H=Historical, E=Loading error |
text(1) |
|
| REGISTER_TYPE |
Record type. A=Current, P=Projected. |
text(1) |
|
| REGISTER_DATE |
Registration date |
datetime |
|
| STAND_OBSERVATION |
Note |
text(375) |
|
| EXTRA_TEXT_01 |
Extra Description 01. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_02 |
Extra Description 02. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_03 |
Extra Description 03. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_04 |
Extra Description 04. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_05 |
Extra Description 05. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_06 |
Extra Description 06. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_07 |
Extra Description 07. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_08 |
Extra Description 08. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_09 |
Extra Description 09. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_10 |
Extra Description 10. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_11 |
Extra Description 11. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_12 |
Extra Description 12. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_13 |
Extra Description 13. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_14 |
Extra Description 14. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_TEXT_15 |
Extra Description 15. Consult the support team for this attribute. |
text(256) |
|
| EXTRA_NUMBER_01 |
Extra number 01. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_02 |
Extra number 02. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_03 |
Extra number 03. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_04 |
Extra number 04. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_05 |
Extra number 05. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_06 |
Extra number 06. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_07 |
Extra number 07. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_08 |
Extra number 08. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_09 |
Extra number 09. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_10 |
Extra number 10. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_11 |
Extra number 11. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_12 |
Extra number 12. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_13 |
Extra number 13. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_14 |
Extra number 14. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_NUMBER_15 |
Extra number 15. Consult the support team for this attribute. |
numeric(18,4) |
|
| EXTRA_DATE_01 |
Extra Date 01. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_02 |
Extra Date 02. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_03 |
Extra Date 03. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_04 |
Extra Date 04. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_05 |
Extra Date 05. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_06 |
Extra Date 06. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_07 |
Extra Date 07. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_08 |
Extra Date 08. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_09 |
Extra Date 09. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_10 |
Extra Date 10. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_11 |
Extra Date 11. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_12 |
Extra Date 12. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_13 |
Extra Date 13. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_14 |
Extra Date 14. Consult the support team for this attribute. |
datetime |
|
| EXTRA_DATE_15 |
Extra Date 15. Consult the support team for this attribute. |
datetime |
|
| LAND_USE_CHARACTERISTIC_GROUP_CODE |
Automatic Code of the Land Use Characteristics |
int(10) |
|
| LAND_USE_CHARACTERISTIC_GROUP_ID |
Land Use Feature group ID |
error |
|
| LAND_USE_CHARACTERISTIC_GROUP_DESCRIPTION |
Land use feature group description |
text(64) |
|
| LAND_USE_CHARACTERISTIC_CODE |
Automatic Code of the Land Use Characteristics |
int(10) |
|
| LAND_USE_CHARACTERISTIC_ID |
Land Use Feature ID |
error |
|
| LAND_USE_CHARACTERISTIC_DESCRIPTION |
Description of land use feature |
text(64) |
|
| WATERSHED_CODE |
Automatic Code of Foret Type |
int(10) |
|
| WATERSHED_DESCRIPTION |
Watersheed Description |
text(64) |
|
| SOIL_TYPE_CODE |
Automatic Code of Soil Type |
int(10) |
|
| SOIL_TYPE_DESCRIPTION |
Soil Type Description |
text(512) |
|
| SPACING_CODE |
Automatic Code of Spacing |
int(10) |
|
| SPACING_DESCRIPTION |
Description of spacing |
text(64) |
|
| SEEDLING_GENERATION_CODE |
Automatic Code of Propagation System |
int(10) |
|
| SEEDLING_GENERATION_DESCRIPTION |
Description of the propagation system. |
text(64) |
|
| GENETIC_MATERIAL_CODE |
Automatic Code of Genetic Material |
int(10) |
|
| GENETIC_MATERIAL_DESCRIPTION |
Description of genetic material |
text(128) |
|
| SPECIE_CODE |
Automatic Code of Species |
int(10) |
|
| SPECIE_DESCRIPTION |
Description of the species. |
text(128) |
|
| GENUS_CODE |
Automatic Code of Genre |
int(10) |
|
| GENUS_DESCRIPTION |
Description of the genus |
text(64) |
|
| PLANTING_STABLISHMENT_SYSTEM_CODE |
Automatic Code of Regime |
int(10) |
|
| PLANTING_STABLISHMENT_SYSTEM_DESCRIPTION |
Regime description |
text(64) |
|
| SLOPE_CODE |
Automatic Code of Slope |
int(10) |
|
| SLOPE_DESCRIPTION |
Description of the slope. |
text(64) |
|
| OWNERSHIP_TYPE_CODE |
Automatic Code of Property Type |
int(10) |
|
| OWNERSHIP_TYPE_DESCRIPTION |
Property Type Description |
text(64) |
|
| SITE_CLASS_CODE |
Automatic Code of Syte Class |
int(10) |
|
| SITE_CLASS_DESCRIPTION |
Description of site class |
text(64) |
|
| BIOME_CODE |
Automatic Code of Biome |
int(10) |
|
| BIOME_DESCRIPTION |
Biome Description |
text(50) |
|
| TYPOLOGY_CODE |
Automatic Code of Typology |
int(10) |
|
| TYPOLOGY_DESCRIPTION |
Description of the typology. |
text(250) |
|
| PLAN_CODE |
Automatic Code of Plan |
int(10) |
|
| PLAN_DESCRIPTION |
Plan Description |
text(64) |
|
| INVESTMENT_PROJECT_CODE |
Automatic code of the investment project |
text(20) |
|
| INVESTMENT_PROJECT_DESCRIPTION |
Investment project description |
text(64) |
|
| INVESTMENT_PROJECT_TASK_CODE |
Automatic code of the investment project task |
int(10) |
|
| INVESTMENT_PROJECT_TASK_DESCRIPTION |
Tract ID |
text(25) |
|
| FARM_PROPERTY_CODE |
Automatic Code of Farm |
int(10) |
|
| FARM_PROPERTY_NAME |
Farm Name |
text(128) |
|
| PERSON_COMPANY_CODE |
Automatic Code of Person or Entity |
int(10) |
|
| PERSON_COMPANY_NAME |
Stand responsible company |
text(200) |
|
| LAND_USE_TRANSITION_CODE |
Sequential (automatic) code for the land use transition. |
int(10) |
|
| LAND_USE_TRANSITION_DESCRIPTION |
Description of the land use transition. |
text(64) |
|
| PLANTING_LIBERATION_DATE |
Planting liberation date |
date |
|
| LATITUDE |
Polygon centroid latitude value. |
numeric(38,8) |
|
| LONGITUDE |
Polygon centroid longitude value. |
numeric(38,8) |
|
| SPECIE_ABBREVIATION |
Short description of the species. |
text(16) |
|
Back to topics
¶ DIM_STAND_BLOCK
Compartment (CFG_GLEBA)
| Attribute |
Description |
Type |
Classification |
| DIM_STAND_BLOCK_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Compartment ID |
int(10) |
SCD - Business Key |
| STAND_BLOCK_EXTERNAL_ID |
External ID of Compartment |
text(64) |
|
| STAND_BLOCK_DESCRIPTION |
Compartment description |
text(64) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Stations (CLI_ESTACAO)
| Attribute |
Description |
Type |
Classification |
| DIM_STATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Station |
int(10) |
SCD - Business Key |
| STATION_CODE |
Station Code |
text(32) |
|
| STATION_NAME |
Station Name |
text(32) |
|
| STATION_X_COORD |
Station latitude |
int(10) |
|
| STATION_Y_COORD |
Station Longitude |
int(10) |
|
| STATION_SPINDLE |
Timezone Station |
text(3) |
|
| STATION_ALTITUDE |
Station Altitude |
error |
|
| STATION_RESPONSIBLE |
User responsible for the station |
text(64) |
|
Back to topics
Type of stock movement (CFG_TIPO_MOVIMENTACAO_ESTOQUE)
| Attribute |
Description |
Type |
Classification |
| DIM_STOCK_MOVIMENTATION_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Movement Type |
int(10) |
SCD - Business Key |
| STOCK_MOVIMENTATION_TYPE_DESCRIPTION |
Description of stock movement type |
text(64) |
|
| STOCK_MOVIMENTATION_TYPE_ABREVIATION |
Short description of stock movement type |
text(16) |
|
Back to topics
Supplier (CFG_FORNECEDOR)
| Attribute |
Description |
Type |
Classification |
| DIM_SUPPLIER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Supplier |
int(10) |
SCD - Business Key |
| SUPPLIER_DESCRIPTION |
Supplier Description |
text(200) |
|
| SUPPLIER_ABBREVIATION |
Supplier short description |
text(16) |
|
| OWN_COMPANY |
Indicates if the company is a service taker or own |
text(1) |
|
Back to topics
Team (CFG_EQUIPE)
| Attribute |
Description |
Type |
Classification |
| DIM_TEAM_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential code (automatic) of the team. |
int(10) |
SCD - Business Key |
| TEAM_DESCRIPTION |
Description of the team. |
text(64) |
|
| TEAM_ABBREV |
Short description of the team. |
text(16) |
|
| TEAM_ID |
Team ID. |
text(20) |
|
Back to topics
Wood certificates (CFG_CARACTERISTICA_MADEIRA)
| Attribute |
Description |
Type |
Classification |
| DIM_TIMBER_CERTIFICATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of the Certificate Characteristic |
int(10) |
SCD - Business Key |
| CERTIFICATION_DESCRIPTION |
Description of the certificate number. |
text(128) |
|
| START_DATE |
Initial certificate expiration date. |
datetime |
|
| FINISH_DATE |
Certificate expiration date |
datetime |
|
| CERTIFICATION_TYPE |
Certificate Type M=Management; C=Chain of Custody |
text(1) |
|
| CERTIFICATION_GROUP_DESCRIPTION |
Description of wood feature |
text(96) |
|
| CERTIFICATION_GROUP_ABBREVIATION |
Wood feature short description |
text(24) |
|
Back to topics
Wood characteristics (CFG_CARACTERISTICA_MADEIRA)
| Attribute |
Description |
Type |
Classification |
Back to topics
Wood density class (CFG_CLASSE_MADEIRA)
| Attribute |
Description |
Type |
Classification |
| DIM_TIMBER_DENSITY_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of the Wood Density Class |
int(10) |
SCD - Business Key |
| TIMBER_DENSITY_CLASS_DESCRIPTION |
Description of wood density class |
text(64) |
|
| TIMBER_DENSITY_CLASS_ABREVIATION |
Abbreviation of Wood Density Class |
text(16) |
|
| TIMBER_DENSITY_CHARACTERISTIC_GOAL |
Density Characteristic Goal |
numeric(10,2) |
|
| TIMBER_DENSITY_CHARACTERISTIC_DESVIATION |
Density characteristic deviation value |
numeric(10,2) |
|
Back to topics
Supplier (CFG_FORNECEDOR) (Copy of DIM_SUPPLIER)
| Attribute |
Description |
Type |
Classification |
| DIM_SUPPLIER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Supplier |
int(10) |
SCD - Business Key |
| SUPPLIER_DESCRIPTION |
Supplier Description |
text(200) |
|
| SUPPLIER_ABBREVIATION |
Supplier short description |
text(16) |
|
| OWN_COMPANY |
Indicates if the company is a service taker or own |
text(1) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Calendar (Calendário) (Copy of DIM_DATE)
| Attribute |
Description |
Type |
Classification |
| DIM_DATE_ID |
Unique key of the dimension table. Date in year, month and day format (YYYYMMDD) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| DAY |
day |
int(10) |
|
| MONTH |
Month |
int(10) |
|
| YEAR |
Year |
int(10) |
|
| YEARMONTH |
Year and Month in YYYYMM format |
int(10) |
|
| WEEKDAY |
Week number |
int(10) |
|
| WEEK |
Week number |
int(10) |
|
| QUARTER |
Quarter number |
int(10) |
|
Back to topics
Employee (CFG_FUNCIONARIO) (Copy of DIM_EMPLOYEE)
| Attribute |
Description |
Type |
Classification |
| DIM_EMPLOYEE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Employee |
int(10) |
SCD - Business Key |
| EMPLOYEE_REGISTRY |
Employee Registration |
text(64) |
|
| EMPLOYEE_NAME |
Employee Name |
text(96) |
|
Back to topics
Typology (CFG_TIPOLOGIA)
| Attribute |
Description |
Type |
Classification |
| DIM_TYPOLOGY_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Typology |
int(10) |
SCD - Business Key |
| TYPOLOGY_DESCRIPTION |
Description of the typology. |
text(250) |
|
| TYPOLOGY_ABBREVIATION |
Typology short Description |
text(16) |
|
Back to topics
Unit (CFG_UNIDADE)
| Attribute |
Description |
Type |
Classification |
| DIM_UNIT_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Sequential (automatic) code of the unit. |
int(10) |
SCD - Business Key |
| UNIT_DESCRIPTION |
Unit description. |
text(64) |
|
| UNIT_ABBREV |
Short description of the unit. |
text(16) |
|
Back to topics
User (CFG_USUARIO)
| Attribute |
Description |
Type |
Classification |
| DIM_USER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of User |
int(10) |
SCD - Business Key |
| USER_NAME |
User Description |
text(64) |
|
| USER_LOGIN |
User Login |
text(64) |
|
| USER_EMAIL |
User Email |
text(64) |
|
| LOCK_FLAG |
Identification Flag that the user is locked in the system. (0 = Unlocked and 1 = Locked). |
error |
|
| EMPLOYEE_CODE |
Automatic Code of Employee |
int(10) |
|
| EMPLOYEE_REGISTER |
Employee Registration |
text(64) |
|
| EMPLOYEE_NAME |
Name of the employee. |
text(96) |
|
| ADMISSION_DATE |
Employee Admission Date |
error |
|
| POSITION_DESCRIPTION |
Description of the employee´s position |
text(128) |
|
| COMPANY_NAME |
Name of the company the user works for. |
text(200) |
|
Back to topics
Variables (CLI_PES_NOME_VARIAVEL)
| Attribute |
Description |
Type |
Classification |
| DIM_VARIABLES_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Variable |
int(10) |
SCD - Business Key |
| VARIABLES_NAME |
Variable Name |
text(64) |
|
| VARIABLES_TEXT |
Detailed text about the variable |
text(128) |
|
Back to topics
Hydrographic basin (CFG_BACIA_HIDROGRAFICA)
| Attribute |
Description |
Type |
Classification |
| DIM_WATERSHED_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Foret Type |
int(10) |
SCD - Business Key |
| WATERSHED_DESCRIPTION |
Watershed Description |
text(64) |
|
| WATERSHED_ABBREVIATION |
Watersheed short description |
text(16) |
|
| AREA |
Basin Area Value |
numeric(16,2) |
|
| LEVEL |
Level |
int(5) |
|
Back to topics
Wood characteristics (CFG_CARACTERISTICA_MADEIRA)
| Attribute |
Description |
Type |
Classification |
| DIM_WOOD_CHARACTERISTIC_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of the Wood Characteristics |
int(10) |
SCD - Business Key |
| WOOD_CHARACTERISTIC_DESCRIPTION |
Description of wood feature |
text(96) |
|
| WOOD_CHARACTERISTIC_ABREVIATION |
Short description of the characteristic of the wood. |
text(24) |
|
Back to topics
Wood products (CFG_PRODUTO) (Copy of DIM_PRODUCT)
| Attribute |
Description |
Type |
Classification |
| DIM_PRODUCT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Product |
int(10) |
SCD - Business Key |
| PRODUCT_EXTERNAL_ID |
Product External ID |
text(32) |
|
| PRODUCT_DESCRIPTION |
Product description |
text(64) |
|
| PRODUCT_ABREVIATION |
Abbreviation of Product |
text(16) |
|
Back to topics
Down time classes (CFG_CLASSE_PARADA)
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_CLASS_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Downtime Class |
int(10) |
SCD - Business Key |
| WORKTIME_CLASS_DESCRIPTION |
Description of Stop class |
text(64) |
|
| WORKTIME_CLASS_ABREVIATION |
Abbreviation of Downtime Class |
text(16) |
|
Back to topics
Down time (CFG_PARADA)
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_CLASSIFICATION_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Downtime |
int(10) |
SCD - Business Key |
| WORKTIME_CLASSIFICATION_EXTERNAL_ID |
Downtime External Id |
text(32) |
|
| WORKTIME_CLASSIFICATION_DESCRIPTION |
Downtime Description |
text(64) |
|
| WORKTIME_CLASSIFICATION_ABREVIATION |
Abbreviation of Downtime |
text(16) |
|
Back to topics
Down time types (<enumerado>)</enumerado>
| Attribute |
Description |
Type |
Classification |
| DIM_WORKTIME_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Downtime Type Id (Enumerated) |
text(32) |
SCD - Business Key |
| WORKTIME_TYPE_DESCRIPTION |
Downtime Type Description |
text(4000) |
|
Back to topics
Service Order (PLA_ORDEM_SERVICO)
| Attribute |
Description |
Type |
Classification |
| DIM_WORK_ORDER_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Service Order |
int(10) |
SCD - Business Key |
| WORK_ORDER_DESCRIPTION |
Service Order Description |
text(64) |
|
| WORK_ORDER_INITIAL_DATE |
Work order - start date |
datetime |
|
| WORK_ORDER_FINAL_DATE |
Work order - end date |
datetime |
|
| WORK_ORDER_STATUS |
Work order status (D-Draft, C-Changed, P-Waiting Approval at Operational Block Level, R-Waiting Approval at Site Level, A-Available to Receive Follow-ups, X-Closed) |
text(1) |
|
Back to topics
Management (CFG_MANEJO)
| Attribute |
Description |
Type |
Classification |
| DIM_WORK_SCHEME_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Work Scheme |
int(10) |
SCD - Business Key |
| WORK_SCHEME_DESCRIPTION |
Management Description |
text(64) |
|
| WORK_SCHEME_ABREVIATION |
Abbreviation of Work Scheme |
text(16) |
|
| WORK_SCHEME_STUMPAGE_SALES_INDICATOR |
Lump sum? |
error |
|
| WORK_SCHEME_THINNING_CUT_INDICATOR |
Thinning? |
error |
|
| WORK_SCHEME_THINNING_CUT_NUMBER |
Thinning Number |
error |
|
Back to topics
Shifts (CFG_TURNO)
| Attribute |
Description |
Type |
Classification |
| DIM_WORK_SHIFT_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Shift |
int(10) |
SCD - Business Key |
| WORK_SHIFT_DESCRIPTION |
Shift Description |
text(64) |
|
| WORK_SHIFT_ABREVIATION |
Abbreviation of Shift |
text(16) |
|
| WORK_SHIFT_INITIAL_HOUR |
Shift Start Time |
text(5) |
|
| WORK_SHIFT_FINAL_HOUR |
Shift End Time |
text(5) |
|
| WORK_SHIFT_DURATION |
Duration of shift |
error |
|
Back to topics
Operation team (PLA_FRENTE_OPERACAO)
| Attribute |
Description |
Type |
Classification |
| DIM_WORK_TEAM_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Work Team |
int(10) |
SCD - Business Key |
| WORK_TEAM_GROUPER |
Work Team Group |
text(60) |
|
| WORK_TEAM_DESCRIPTION |
Description of front of operation |
text(64) |
|
| WORK_TEAM_ABREVIATION |
Abbreviation of Work Team |
text(16) |
|
Back to topics
Transport woodyard (CFG_LOCAL)
| Attribute |
Description |
Type |
Classification |
| DIM_YARD_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Automatic Code of Location |
int(10) |
SCD - Business Key |
| YARD_DESCRIPTION |
Site Description |
text(128) |
|
| YARD_ABREVIATION |
Local short description |
text(24) |
|
| LOCAL_TYPE_DESCRIPTION |
Location Type |
text(64) |
|
| SUPPLIER_DESCRIPTION |
Supplier Description |
text(200) |
|
Back to topics
Woodyard destination type (<enumerado>)</enumerado>
| Attribute |
Description |
Type |
Classification |
| DIM_YARD_DESTINATION_TYPE_ID |
Dimension table unique key (surrogate key) |
int(10) |
Surrougate Key |
| DATA_SOURCE_KEY |
Delivery Type |
int(10) |
SCD - Business Key |
| YARD_DESTIONATION_TYPE_DESCRIPTION |
Delivery Type Description |
text(4000) |
|
Back to topics
Year_month (Calendário)
| Attribute |
Description |
Type |
Classification |
| DIM_YEAR_MONTH_ID |
Unique key of the dimension table (surrogate key) |
int(10) |
Surrougate Key |
| CALENDAR_DATE |
Date |
date |
|
| MONTH |
Month number (1..12) |
int(10) |
|
| YEAR |
Year number. |
int(10) |
|
| QUARTER |
Quarter number (1..4) |
int(10) |
|
Back to topics
Below are some suggestions of books and websites related to Data Warehouse, Power BI, DAX, ...
READING: Below are some books we recommend.
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (English), 30 jun 2013 by Ralph Kimball (Author), Margy Ross (Author)
The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel (English Edition) 2nd Edition by Marco Russo (Author), Alberto Ferrari (Author)
Mastering Power BI, 2nd Edition by Karine Lago (Author) and Laennder Alves (Author)
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query, 1st edition by Ken Puls and Miguel Escobar (Authors)
COURSE PROVIDERS
Portuguese - Brazil
- Aprenda Power BI - Leonardo Karpinski
- DATAB - Karine Lago e Laennder Alves
- Data Sciencie Academy
- Planilheiros - Ruy Lacerda e Fernando Garcia
ODL COURSES:
- Udemy
- Coursera
- EDX
INTERESTING LINKS:
- DAX Functions Guide
- DAX Guide
- DAX Formatter
- Microsoft Power BI Community
- Themes Gallery - Microsoft Power BI Community
INFOGRAPHICS:
Power BI – Overview Infographic
Power BI - End-to-End Features
Power BI - Visuals Reference
What are you trying to find in your data?
Financial Times Visual Vocabulary: Power BI Edition
Get to know our website and keep up with INFLOR news and solution.
Click here to access the INFLOR website.
Back to topics
