Index
Purpose
This tool extracts data from the Microsiga Protheus® ERP and builds the entire relational structure to create managerial information.
To offer managerial views related to the Legal Management (SIGAJURI) module on the TOTVS Analytics platform (GoodData).
Information regarding legal requests, contingencies and accredited offices is available.
For data analysis, the location and classification of legal matters were also added to the information.
Outflows
Related Dimensions
HYH – Judicial District (Function BIXComarca)
Displays the information by circuit court.
Phase |
Fields |
Target Attribute (Stage) |
Source |
09 |
Business Key |
HYH_COMARC |
NQ6_FILIAL+NQ6_COD |
Code |
HYH_CODIGO |
NQ6_COD |
|
Judicial District |
HYH_DESC | NQ6_DESC |
|
State |
HYH_UF |
NQ6_UF |
HYI – Prognostic (Function BIXPrognostico)
Displays the information by prognostic (probable future development or result of a lawsuit).
Phase |
Fields |
Target Attribute (Stage) |
Source |
09 |
Business Key |
HYI_PROGNO |
NQ7_FILIAL+NQ7_COD |
Code |
HYI_CODIGO |
NQ7_COD |
|
Prognostic |
HYI_DESC |
NQ7_DESC |
|
Percentage |
HYI_PORCEN |
NQ7_PORCEN |
|
Type |
HYI_TIPO |
NQ7_TIPO |
HYJ – Legal Area (Function BIXAreasJuridico)
Displays the information by legal area
Phase |
Fields |
Target Attribute (Stage) |
Source |
09 |
Business Key |
HYJ_AREAJU |
NRB_FILIAL+NRB_COD |
Code |
HYJ_CODIGO |
NRB_COD |
|
Description |
HYJ_DESC |
NRB_DESC |
HYK – Reason for Closing (Function BIXMotivEncerramento)
Displays the information by reasons for closing
Phase |
Fields |
Target Attribute (Stage) |
Source |
09 |
Business Key |
HYK_MOTIVO |
NQI_FILIAL+NQI_COD |
Code |
HYK_CODIGO |
NQI_COD |
|
Reason |
HYK_DESC |
NQI_DESC |
HYL – Legal Request (Function BIXPedidosJuridico)
Displays the information by request.
Phase |
Fields |
Target Attribute (Stage) |
Source |
09 |
Business Key |
HYL_PEDJUR |
NSP_FILIAL+NSP_COD |
Code |
HYL_CODIGO |
NSP_COD |
|
Order |
HYL_DESC | NSP_DESC |
|
Type |
HYL_TIPO |
NSP_TIPO |
HYO – Legal Matter (Function BIXAssuntoJuridico)
Displays the information by legal matter type
Phase |
Fields |
Target Attribute (Stage) |
Source |
09 |
Business Key |
HYO_ASSUNT |
NYB_FILIAL+NYB_COD |
Code |
HYO_CODIGO |
NYB_COD |
|
Legal Matter |
HYO_DESC |
NYB_DESC |
Business Rule
HYP - Lawsuits in Progress
Fact related to legal matter, quantity of lawsuits in progress.
Description |
Physical Table |
Phase |
Company |
HJ4 |
1 |
Establishment |
HKK |
1 |
Business Unit |
HJ1 |
1 |
Legal Matter |
HYO |
9 |
Legal Area |
HYJ |
9 |
Judicial District |
HYH |
9 |
Supplier (Accredited) |
HKJ |
1 |
| Indicators: Lawsuits in Progress | ||
Main Flow of Source: Legal Matters Register |
||
Dimensions Lookup |
Source |
Phase |
Company – (HYP_EMPRES) |
FWGrpCompany() +FWCompany() |
9 |
Establishment – (HYP_ESTABL) |
FWFilial() |
9 |
Legal Matter – (HYP_ASSUNT) |
NYB_COD |
9 |
Legal Area – (HYP_AREAJU) |
NRB_COD |
9 |
Judicial District – (HYP_COMARC) |
NQ6_COD |
9 |
Accredited - (HYP_CREDEN) |
A2_COD+A2_LOJA, for records in which field A2_MJURIDI = '1' |
9 |
Indicators |
Source |
Phase |
Extraction Date – (HYP_DTEXTR) |
Extraction date |
9 |
Quantity of Lawsuits – (HYP_QTDPRO) |
Quantity of lawsuits in progress |
9 |
HYQ - Lawsuits Open and Closed
Fact related to legal matter, quantity of processes open and closed in current month.
Description |
Physical Table |
Phase |
Company |
HJ4 |
1 |
Establishment |
HKK |
1 |
Business Unit |
HJ1 |
1 |
Legal Matter |
HYO |
9 |
Legal Area |
HYJ |
9 |
Judicial District |
HYH |
9 |
Supplier (Accredited) |
HKJ |
1 |
| Client | HJ7 | 1 |
| Reason for Closing | HYK | 9 |
Indicators: Lawsuits Open and Closed |
||
Main Flow of Source: Legal Matters Register |
||
Dimensions Lookup |
Source |
Phase |
Company – (HYQ_EMPRES) |
FWGrpCompany() +FWCompany() |
9 |
Establishment – (HYQ_ESTABL) |
FWFilial() |
9 |
Legal Matter – (HYQ_ASSUNT) |
NYB_COD |
9 |
Legal Area – (HYQ_AREAJU) |
NRB_COD |
9 |
Judicial District - (HYQ_COMARC) |
NQ6_COD |
9 |
Accredited - (HYQ_CREDEN) |
A2_COD+A2_LOJA, for records in which field A2_MJURIDI = '1' |
9 |
| Client - (HYQ_CLIENT) | A1_COD+A1_LOJA | 9 |
| Reason for Closing - (HYQ_MOTIVO) | NQI_COD | 9 |
Indicators |
Source |
Phase |
Extraction Date – (HYQ_DTEXTR) |
Date of extraction |
9 |
Quantity Open – (HYQ_QTDABE) |
Quantity of lawsuits pending |
9 |
Quantity Closed – (HYQ_QTDENC) |
Quantity of lawsuits closed |
9 |
HYR - Legal Economic Benefit
Fact related to legal matter, provision value, final value of case and value involved of legal matters of lawsuits closed in current month.
Description |
Physical Table |
Phase |
Company |
HJ4 |
1 |
Establishment |
HKK |
1 |
Business Unit |
HJ1 |
1 |
Legal Matter |
HYO |
9 |
Judicial District |
HYH |
9 |
Supplier (Accredited) |
HKJ |
1 |
| Currency | HJ6 | 1 |
Indicators: Legal Economic Benefit |
||
Main Flow of Source: Legal Matters Register |
||
Dimensions Lookup |
Source |
Phase |
Company – (HYR_EMPRES) |
FWGrpCompany() +FWCompany() |
9 |
Establishment – (HYR_ESTABL) |
FWFilial() |
9 |
Legal Matter – (HYR_ASSUNT) |
NYB_COD |
9 |
Judicial District - (HYR_COMARC) |
NQ6_COD |
9 |
Accredited - (HYR_CREDEN) |
A2_COD+A2_LOJA, for records in which field A2_MJURIDI = '1' |
9 |
| Currency - (HYR_MOEDA) | Attributed through function BIXPdrMoeda([MoedaOrigem]), considering Wizard parameter. | 9 |
Indicators |
Source |
Phase |
Extraction Date – (HYR_DTEXTR) |
Date of extraction |
9 |
| Currency – (HYR_MOEDA) | Currency of legal matter values | 9 |
Provision Value – (HYR_VLPROV) |
Value of provision |
9 |
Final value of case – (HYR_VLFINC) |
Final value of case |
9 |
| Value involved – (HYR_VLENVO) | Value involved | 9 |
HYS - Lawsuits x Requests Analysis
Fact related to legal matter, quantity of lawsuits pending in current month grouped by requests.
Description |
Physical Table |
Phase |
Company |
HJ4 |
1 |
Establishment |
HKK |
1 |
Business Unit |
UJ1 |
1 |
Legal Matter |
HYO |
9 |
Judicial District |
HYH |
9 |
Supplier (Accredited) |
HKJ |
1 |
Legal Area |
HYJ |
9 |
| Legal Request | HYL | 9 |
Indicators: Lawsuit x Requests Analysis |
||
Main Flow of Source: Legal Matters Register |
||
Dimensions Lookup |
Source |
Phase |
Company – (HYS_EMPRES) |
FWGrpCompany() +FWCompany() |
9 |
Establishment – (HYS_ESTABL) |
FWFilial() |
9 |
Legal Matter – (HYS_ASSUNT) |
NYB_COD |
9 |
Judicial District - (HYS_COMARC) |
NQ6_COD |
9 |
Accredited - (HYS_CREDEN) |
A2_COD+A2_LOJA, para registros onde o campo A2_MJURIDI = '1' |
9 |
Legal Area – (HYS_AREAJU) |
NRB_COD |
9 |
| Legal Requests - (HYS_PEDJUR) | NSP_COD | 9 |
Indicators |
Source |
Phase |
Extraction Date – (HYS_DTEXTR) |
Date of extraction |
9 |
Quantity of Lawsuits x Requests – (HYS_QTDPPE) |
Quantity of lawsuits grouped by request |
9 |
HYT - Consolidated Provision
Fact related to legal matter, provision value of legal matters pending in current month.
Description |
Physical Table |
Phase |
Company |
HJ4 |
1 |
Establishment |
HKK |
1 |
Business Unit |
HJ1 |
1 |
Legal Matter |
HYO |
9 |
Judicial District |
HYH |
9 |
Supplier (Accredited) |
HKJ |
1 |
Prognostic |
HYI |
9 |
| Currency | HJ6 | 1 |
Indicators: Consolidated Provision |
||
Main Flow of Source: Legal Matters Register |
||
Dimension Lookup |
Source |
Phase |
Company – (HYT_EMPRES) |
FWGrpCompany() +FWCompany() |
9 |
Establishment – (HYT_ESTABL) |
FWFilial() |
9 |
Legal Matter – (HYT_ASSUNT) |
NYB_COD |
9 |
Judicial District – (HYT_COMARC) |
NQ6_COD |
9 |
Accredited - (HYT_CREDEN) |
A2_COD+A2_LOJA, for records in which field A2_MJURIDI = '1' |
9 |
Prognostic – (HYT_PROGNO) |
NQ7_COD |
9 |
| Currency - (HYT_MOEDA) | Attributed through function BIXPdrMoeda([MoedaOrigem]), considering Wizard parameter. | 9 |
Indicators |
Source |
Phase |
Extraction Date – (HYS_DTEXTR) |
Date of extraction |
9 |
Provision Value – (HYT_VLPROV) |
Value of consolidated provision |
9 |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas