Personal și dosar HR — Pro
Dosar HR: contract activ astăzi, salariu în Detalii, decizii, pontaj, jurnal REGES și concediu anual.
Dosar HR: persoană → contracte → istoric salarial, pontaj, jurnal REGES și concediu de odihnă. La deschidere alegi perioada desfășurătoarelor, formația și dacă persoana are contract activ ASTĂZI. Starea este citită din funcția datată Nexus, cu contractele nevalidate/radiate excluse; nu se deduce din regsal sau anul de inactivitate. Contractele arată angajator, funcție, ocupație COR, formație, loc de muncă, tip și durată, datele de început/sfârșit, program, probă și preaviz. În Detalii se văd salariul negociat și norma la data curentă; istoricul salarial arată deciziile validate/neanulate și tariful orar. Dintr-o decizie poți deschide sporurile, cu procentul și suma fixă separate, fără a le aduna sau a pretinde că reprezintă sume lunare plătite. Nu sunt salarii nete plătite și nu este un stat de plată. Istoricul deciziilor este complet pentru contract, independent de perioada pontajului. Pontajul și jurnalul sunt citite numai pentru contractul și intervalul selectat; zilele lipsă nu înseamnă absență. Jurnalul păstrează distinct evenimentele anulate/istorice, fără a le prezenta ca stare curentă. Concediul de odihnă arată valorile calculate de Nexus pentru fiecare AN CALENDARISTIC atins de perioada aleasă, nu doar pentru zilele filtrului. Salariile apar în Detalii, nu pe cardul public de personal. Cheile relațiilor sunt ascunse; nu se citesc CNP, IBAN, acte de identitate, adrese sau explicații medicale. Necesită autorizare HR pe propria sursă. Galeria folosește exclusiv persoane și sume DEMO. Citire live la cerere, fără actualizare globală automată; maximum 5.000 de rânduri pe listă, 10.000 la pontaj. Pro; iOS 1.1.0(336)/Android 1.1.0(284) sau mai nou. Nu scrie în ERP, nu înlocuiește salarizarea sau obligațiile REGES. Manuale: https://www.docs.nexuserp.ro/articol/contracte-de-munca/2770 ; https://www.docs.nexuserp.ro/manual-curs/nexus-salarii-online/3 ; https://www.docs.nexuserp.ro/articol/configurare-aplicatie-pontaje-online/5291 .
Screenshots
What this package creates
1 Home6 Details7 lists1 sources to map
- Home: Personal — dosar HR
- Details: Contracte și dosar
- Details: Istoric salarial
- Details: Sporuri din decizie
- Details: Pontaj în perioada aleasă
- Details: Jurnalul contractului
- Details: Concediu de odihnă — anual
- Sub-button: Contracte de muncă
- Sub-button: Istoric salarial — decizii
- Sub-button: Sporuri din decizia salarială
- Sub-button: Pontaj înregistrat
- Sub-button: Jurnal contract — REGES
- Sub-button: Concediu de odihnă — situație anuală
Sources are mapped locally and verified before applying.
Custom queriesPRO7 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT p.id_intern,p.nume,p.nume_form,p.den_functie_int,
CASE WHEN COALESCE(a.nr_active,0)>0 THEN N'Da' ELSE N'Nu' END AS cm_activ,
COALESCE(a.nr_active,0) AS contracte_active,COALESCE(a.nr_suspendate,0) AS contracte_suspendate,
COALESCE(a.nr_contracte,0) AS contracte_inregistrate,
CAST(GETDATE() AS date) AS stare_la_data,
CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,
CAST(:period_from AS date) AS data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM dbo.accesex_personal_view p
LEFT JOIN (
SELECT CONCAT(CONVERT(varchar(30),c.id_pers),'(',CONVERT(varchar(10),c.pl_pers),')') AS person_key,COUNT_BIG(*) AS nr_contracte,
SUM(CASE WHEN s.stare='ContractStareActiv' AND s.d_inceput<=CAST(GETDATE() AS date) THEN 1 ELSE 0 END) AS nr_active,
SUM(CASE WHEN s.stare='ContractStareSuspendare' THEN 1 ELSE 0 END) AS nr_suspendate
FROM dbo.Sal_CM_view c
LEFT JOIN dbo.sal_stare_contracte(CAST(GETDATE() AS date)) s ON s.pct_lcr=c.pct_lcr AND s.id=c.id
WHERE c.valid=1 AND c.radiat=0
GROUP BY c.pl_pers,c.id_pers
) a ON a.person_key=p.id_internstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(c.pct_lcr,':',c.id) AS row_id,CONCAT(CONVERT(varchar(30),c.id_pers),'(',CONVERT(varchar(10),c.pl_pers),')') AS person_key,
c.pct_lcr AS contract_pl,c.id AS contract_id,c.nume_pers,c.nr_doc,c.nume_angajator,
CASE WHEN c.d_inceput>CAST(GETDATE() AS date) THEN N'Începe în viitor'
WHEN s.stare='ContractStareActiv' THEN N'Activ'
WHEN s.stare='ContractStareSuspendare' THEN N'Suspendat'
WHEN s.stare='ContractStareIncetare' THEN N'Încetat' ELSE N'Stare Nexus de verificat' END AS stare_contract,
CAST(GETDATE() AS date) AS stare_la_data,c.nume_tip_cm,c.den_tip_contr,
COALESCE(s.nume_cor,c.nume_cor) AS nume_cor,COALESCE(s.nume_functia,c.nume_functia) AS nume_functia,
COALESCE(s.den_form,c.den_form) AS den_form,c.den_locm,c.d_inceput,c.d_sfarsit,c.d_incetare,
s.sal_neg AS salariu_negociat,s.data_decizie AS data_decizie_salariala,
s.ore_norm,s.ore_locm,c.h_start,c.h_stop,c.zile_preav,c.zile_proba,
CASE WHEN c.calc_tic=1 THEN N'Da' ELSE N'Nu' END AS calc_tichete,
CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,
CAST(:period_from AS date) AS data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM dbo.Sal_CM_view c
LEFT JOIN dbo.sal_stare_contracte(CAST(GETDATE() AS date)) s ON s.pct_lcr=c.pct_lcr AND s.id=c.id
WHERE c.valid=1 AND c.radiat=0 AND CONCAT(CONVERT(varchar(30),c.id_pers),'(',CONVERT(varchar(10),c.pl_pers),')')=:person_keystatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(s.pct_lcr,':',s.id) AS row_id,CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key, s.pct_lcr AS decision_pl,s.id AS decision_id, s.data_doc,s.data_actad,s.seria_doc,s.numar_doc,s.sal_neg,s.sal_ora,s.ore_norm,s.ore_locm,s.perioada_salarii, CASE WHEN s.data_doc>CAST(GETDATE() AS date) THEN N'Document datat în viitor' ELSE N'Document înregistrat' END AS stare_decizie FROM dbo.sal_salariu_view s WHERE s.pl_cm=:contract_pl AND s.id_cm=:contract_id AND s.valid=1 AND s.anulat=0
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT CONCAT(s.pct_lcr,':',s.id) AS row_id, CONCAT(s.pl_salsalariu,':',s.id_salsalariu) AS decision_key,s.spor,s.procent,s.integral,s.ordine FROM dbo.Sal_Salariu_Sporuri_view s WHERE s.pl_salsalariu=:decision_pl AND s.id_salsalariu=:decision_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT CONCAT(p.pct_lcr,':',p.id,':',p.pl_cm,':',p.id_cm,':',CONVERT(varchar(10),p.data,23),':',p.tip) AS row_id,
CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key,p.data,p.tip_pontaj,p.simbol,p.ore,p.h_start,p.h_stop,p.formatie,p.den_locm,
CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,
CAST(:period_from AS date) AS data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM dbo.Sal_Pontaj_view p
WHERE p.pl_cm=:contract_pl AND p.id_cm=:contract_id AND p.data>=:period_from AND p.data<:period_untilstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.5.sqlQuerySELECT CONVERT(varchar(30),j.id) AS row_id,CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key,j.data_cons,j.den_modif,j.den_operatie,j.status,
CASE WHEN j.anulat=1 THEN N'Anulat' WHEN j.valid=1 THEN N'Validat' ELSE N'Nevalidat' END AS validare,
CASE WHEN j.istoric=1 THEN N'Da' ELSE N'Nu' END AS in_istoric,
CASE WHEN j.transmis_reges=1 THEN N'Da' ELSE N'Nu' END AS transmis,
CASE WHEN j.eroare=1 THEN N'Da' ELSE N'Nu' END AS are_eroare,
CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,
CAST(:period_from AS date) AS data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM dbo.Sal_REGES_Jurnal_browse_view j
WHERE j.pl_cm=:contract_pl AND j.id_cm=:contract_id AND j.data_cons>=:period_from AND j.data_cons<:period_untilstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.6.sqlQuerySELECT CONCAT(:contract_pl,':',:contract_id,':',a.an) AS row_id,CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key, a.an,a.inceput,a.sfarsit,a.zile_contract,a.zile_anterioare,a.zile_suplimentare,a.zile_cuvenite,a.zile_efectuate,a.zile_de_efectuat, N'An calendaristic complet, valori calculate de Nexus' AS explicatie FROM (SELECT YEAR(CAST(:period_from AS date)) AS an UNION SELECT YEAR(DATEADD(day,-1,CAST(:period_until AS date)))) y CROSS APPLY dbo.sal_cm_calc_co_an(y.an,:contract_pl,:contract_id) a
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_personal_view",
"dbo.Sal_CM_view",
"dbo.sal_stare_contracte",
"dbo.sal_salariu_view",
"dbo.Sal_Salariu_Sporuri_view",
"dbo.Sal_Pontaj_view",
"dbo.Sal_REGES_Jurnal_browse_view",
"dbo.sal_cm_calc_co_an"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "806AEF75-B86B-5174-87AF-695322D9D502",
"key": "nume",
"type": "text"
},
{
"direction": "ascending",
"id": "A9A3CD3C-1CC1-553F-9D89-BC863F719F40",
"key": "id_intern",
"type": "text"
}
],
"id": "E59B31F5-91E5-5AAB-B015-CD3B8DFD5ECC",
"mappings": [
{
"commonFieldKey": "",
"key": "id_intern",
"label": "id_intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_intern",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume",
"label": "Persoană",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_functie_int",
"label": "Funcție internă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_functie_int",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_form",
"label": "Formație / echipă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_form",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cm_activ",
"label": "Contract activ astăzi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cm_activ",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "contracte_active",
"label": "Contracte active",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contracte_active",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "contracte_suspendate",
"label": "Contracte suspendate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contracte_suspendate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "contracte_inregistrate",
"label": "Contracte validate, neradiate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contracte_inregistrate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "stare_la_data",
"label": "Starea contractelor la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_la_data",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "period_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "period_from",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "period_until",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Personal — dosar HR",
"primaryKey": "id_intern",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "AE6606C4-32DA-579A-90E8-658823D39847",
"name": "period_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "76FF1087-A195-558C-BFCC-5692AF7EB184",
"name": "period_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"nume",
"den_functie_int",
"nume_form",
"cm_activ",
"contracte_active",
"contracte_suspendate",
"contracte_inregistrate",
"stare_la_data",
"data_de_la",
"data_pana_la"
],
"sourceID": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"sqlQuery": "SELECT p.id_intern,p.nume,p.nume_form,p.den_functie_int,\n CASE WHEN COALESCE(a.nr_active,0)>0 THEN N'Da' ELSE N'Nu' END AS cm_activ,\n COALESCE(a.nr_active,0) AS contracte_active,COALESCE(a.nr_suspendate,0) AS contracte_suspendate,\n COALESCE(a.nr_contracte,0) AS contracte_inregistrate,\n CAST(GETDATE() AS date) AS stare_la_data,\n CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM dbo.accesex_personal_view p\nLEFT JOIN (\n SELECT CONCAT(CONVERT(varchar(30),c.id_pers),'(',CONVERT(varchar(10),c.pl_pers),')') AS person_key,COUNT_BIG(*) AS nr_contracte,\n SUM(CASE WHEN s.stare='ContractStareActiv' AND s.d_inceput<=CAST(GETDATE() AS date) THEN 1 ELSE 0 END) AS nr_active,\n SUM(CASE WHEN s.stare='ContractStareSuspendare' THEN 1 ELSE 0 END) AS nr_suspendate\n FROM dbo.Sal_CM_view c\n LEFT JOIN dbo.sal_stare_contracte(CAST(GETDATE() AS date)) s ON s.pct_lcr=c.pct_lcr AND s.id=c.id\n WHERE c.valid=1 AND c.radiat=0\n GROUP BY c.pl_pers,c.id_pers\n) a ON a.person_key=p.id_intern",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "D7D07942-C4F9-5201-9410-8A2E47C5F16A",
"key": "d_inceput",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "person_key",
"label": "person_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "person_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "contract_pl",
"label": "contract_pl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contract_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "contract_id",
"label": "contract_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contract_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_pers",
"label": "Persoană",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_pers",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_doc",
"label": "Contract nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_doc",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_angajator",
"label": "Angajator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_angajator",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stare_contract",
"label": "Stare la data curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_contract",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stare_la_data",
"label": "Verificat la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_la_data",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_tip_cm",
"label": "Tip contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_tip_cm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_tip_contr",
"label": "Durata contractului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_tip_contr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_cor",
"label": "Ocupație COR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_cor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_functia",
"label": "Funcție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_functia",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_form",
"label": "Formație / echipă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_form",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_locm",
"label": "Loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_locm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "d_inceput",
"label": "Început activitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "d_inceput",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "d_sfarsit",
"label": "Sfârșit perioadă determinată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "d_sfarsit",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "d_incetare",
"label": "Data încetării înregistrate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "d_incetare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "salariu_negociat",
"label": "Salariu negociat la data curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "salariu_negociat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_decizie_salariala",
"label": "Decizie salarială la data curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_decizie_salariala",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ore_norm",
"label": "Ore normă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ore_norm",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ore_locm",
"label": "Ore loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ore_locm",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "h_start",
"label": "Program — început",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "h_start",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "h_stop",
"label": "Program — sfârșit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "h_stop",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_preav",
"label": "Zile preaviz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_preav",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_proba",
"label": "Zile perioadă de probă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_proba",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "calc_tichete",
"label": "Calcul tichete",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "calc_tichete",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "period_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "period_from",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "period_until",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Contracte de muncă",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "6FC96841-A52F-5DA7-A871-FBD75BA5B90C",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "03AA68AA-9CB5-5426-8AA3-F9D994A8A83F",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_intern",
"id": "636244E2-3C77-5588-8D56-03C70F087EDE",
"name": "person_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"nume_pers",
"nr_doc",
"nume_angajator",
"stare_contract",
"stare_la_data",
"nume_tip_cm",
"den_tip_contr",
"nume_cor",
"nume_functia",
"den_form",
"den_locm",
"d_inceput",
"d_sfarsit",
"d_incetare",
"salariu_negociat",
"data_decizie_salariala",
"ore_norm",
"ore_locm",
"h_start",
"h_stop",
"zile_preav",
"zile_proba",
"calc_tichete",
"data_de_la",
"data_pana_la"
],
"sourceID": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"sqlQuery": "SELECT CONCAT(c.pct_lcr,':',c.id) AS row_id,CONCAT(CONVERT(varchar(30),c.id_pers),'(',CONVERT(varchar(10),c.pl_pers),')') AS person_key,\n c.pct_lcr AS contract_pl,c.id AS contract_id,c.nume_pers,c.nr_doc,c.nume_angajator,\n CASE WHEN c.d_inceput>CAST(GETDATE() AS date) THEN N'Începe în viitor'\n WHEN s.stare='ContractStareActiv' THEN N'Activ'\n WHEN s.stare='ContractStareSuspendare' THEN N'Suspendat'\n WHEN s.stare='ContractStareIncetare' THEN N'Încetat' ELSE N'Stare Nexus de verificat' END AS stare_contract,\n CAST(GETDATE() AS date) AS stare_la_data,c.nume_tip_cm,c.den_tip_contr,\n COALESCE(s.nume_cor,c.nume_cor) AS nume_cor,COALESCE(s.nume_functia,c.nume_functia) AS nume_functia,\n COALESCE(s.den_form,c.den_form) AS den_form,c.den_locm,c.d_inceput,c.d_sfarsit,c.d_incetare,\n s.sal_neg AS salariu_negociat,s.data_decizie AS data_decizie_salariala,\n s.ore_norm,s.ore_locm,c.h_start,c.h_stop,c.zile_preav,c.zile_proba,\n CASE WHEN c.calc_tic=1 THEN N'Da' ELSE N'Nu' END AS calc_tichete,\n CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM dbo.Sal_CM_view c\nLEFT JOIN dbo.sal_stare_contracte(CAST(GETDATE() AS date)) s ON s.pct_lcr=c.pct_lcr AND s.id=c.id\nWHERE c.valid=1 AND c.radiat=0 AND CONCAT(CONVERT(varchar(30),c.id_pers),'(',CONVERT(varchar(10),c.pl_pers),')')=:person_key",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "C956662F-F1E4-588E-8A1E-3BA1555F879A",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "contract_key",
"label": "contract_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contract_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "decision_pl",
"label": "decision_pl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "decision_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "decision_id",
"label": "decision_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "decision_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_doc",
"label": "Decizie nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_doc",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "seria_doc",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "seria_doc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_doc",
"label": "Data deciziei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_doc",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_actad",
"label": "Data actului adițional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_actad",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sal_neg",
"label": "Salariu negociat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sal_neg",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sal_ora",
"label": "Tarif orar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sal_ora",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ore_norm",
"label": "Ore normă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ore_norm",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ore_locm",
"label": "Ore loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ore_locm",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "perioada_salarii",
"label": "Perioadă salarii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "perioada_salarii",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stare_decizie",
"label": "Stare document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_decizie",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Istoric salarial — decizii",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_pl",
"id": "685CD6BB-9721-5CA8-A6C1-869046B2B74B",
"name": "contract_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_id",
"id": "E5CAD75A-74ED-5991-944B-F05D13D2CBD8",
"name": "contract_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"numar_doc",
"seria_doc",
"data_doc",
"data_actad",
"sal_neg",
"sal_ora",
"ore_norm",
"ore_locm",
"perioada_salarii",
"stare_decizie"
],
"sourceID": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"sqlQuery": "SELECT CONCAT(s.pct_lcr,':',s.id) AS row_id,CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key,\n s.pct_lcr AS decision_pl,s.id AS decision_id,\n s.data_doc,s.data_actad,s.seria_doc,s.numar_doc,s.sal_neg,s.sal_ora,s.ore_norm,s.ore_locm,s.perioada_salarii,\n CASE WHEN s.data_doc>CAST(GETDATE() AS date) THEN N'Document datat în viitor' ELSE N'Document înregistrat' END AS stare_decizie\nFROM dbo.sal_salariu_view s\nWHERE s.pl_cm=:contract_pl AND s.id_cm=:contract_id AND s.valid=1 AND s.anulat=0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "34CCDB38-B49F-5F62-86B1-01C2629F710C",
"key": "ordine",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "D6AEDA64-C85C-5C01-AE3E-58B4785C3BB8",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "decision_key",
"label": "decision_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "decision_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "spor",
"label": "Spor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "spor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "procent",
"label": "Procent din decizie (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "procent",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "integral",
"label": "Sumă fixă din decizie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "integral",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ordine",
"label": "ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ordine",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Sporuri din decizia salarială",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "decision_pl",
"id": "6628001E-42F7-54B8-A0AF-F56318826D6B",
"name": "decision_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "decision_id",
"id": "7F5BC2F7-4B59-514D-A4B1-48D64E25FDDE",
"name": "decision_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"spor",
"procent",
"integral"
],
"sourceID": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"sqlQuery": "SELECT CONCAT(s.pct_lcr,':',s.id) AS row_id,\n CONCAT(s.pl_salsalariu,':',s.id_salsalariu) AS decision_key,s.spor,s.procent,s.integral,s.ordine\nFROM dbo.Sal_Salariu_Sporuri_view s\nWHERE s.pl_salsalariu=:decision_pl AND s.id_salsalariu=:decision_id",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "18BDBE81-C082-54F7-8966-141F1F0EA2F8",
"key": "data",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "F04016F7-42E1-59B2-8B92-729AE50347F1",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "contract_key",
"label": "contract_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contract_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data",
"label": "Ziua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tip_pontaj",
"label": "Tip pontaj",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_pontaj",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "simbol",
"label": "Simbol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "simbol",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ore",
"label": "Ore înregistrate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ore",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "h_start",
"label": "De la ora",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "h_start",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "h_stop",
"label": "Până la ora",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "h_stop",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "formatie",
"label": "Formație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "formatie",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_locm",
"label": "Loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_locm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "period_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "period_from",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "period_until",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Pontaj înregistrat",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "999B5D09-4430-5A55-88D8-43CB0D91E8AF",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "04F6A883-6346-5313-BD97-270141C3A1ED",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_pl",
"id": "685CD6BB-9721-5CA8-A6C1-869046B2B74B",
"name": "contract_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_id",
"id": "E5CAD75A-74ED-5991-944B-F05D13D2CBD8",
"name": "contract_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"data",
"tip_pontaj",
"simbol",
"ore",
"h_start",
"h_stop",
"formatie",
"den_locm",
"data_de_la",
"data_pana_la"
],
"sourceID": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"sqlQuery": "SELECT CONCAT(p.pct_lcr,':',p.id,':',p.pl_cm,':',p.id_cm,':',CONVERT(varchar(10),p.data,23),':',p.tip) AS row_id,\n CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key,p.data,p.tip_pontaj,p.simbol,p.ore,p.h_start,p.h_stop,p.formatie,p.den_locm,\n CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM dbo.Sal_Pontaj_view p\nWHERE p.pl_cm=:contract_pl AND p.id_cm=:contract_id AND p.data>=:period_from AND p.data<:period_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "A60E1A57-7B96-561B-9FC5-51F7D26B30D7",
"key": "data_cons",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "ACA08C04-43E2-5EE7-BE06-FCE418C4FAE5",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "contract_key",
"label": "contract_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contract_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_cons",
"label": "Data evenimentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_cons",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_modif",
"label": "Modificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_modif",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_operatie",
"label": "Operațiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_operatie",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "status",
"label": "Stare REGES",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "validare",
"label": "Validare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validare",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "in_istoric",
"label": "În istoric",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "in_istoric",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "transmis",
"label": "Transmis REGES",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "transmis",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "are_eroare",
"label": "Eroare raportată de Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "are_eroare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "period_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "period_from",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "period_until",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Jurnal contract — REGES",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "999B5D09-4430-5A55-88D8-43CB0D91E8AF",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "04F6A883-6346-5313-BD97-270141C3A1ED",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_pl",
"id": "685CD6BB-9721-5CA8-A6C1-869046B2B74B",
"name": "contract_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_id",
"id": "E5CAD75A-74ED-5991-944B-F05D13D2CBD8",
"name": "contract_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"data_cons",
"den_modif",
"den_operatie",
"status",
"validare",
"in_istoric",
"transmis",
"are_eroare",
"data_de_la",
"data_pana_la"
],
"sourceID": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"sqlQuery": "SELECT CONVERT(varchar(30),j.id) AS row_id,CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key,j.data_cons,j.den_modif,j.den_operatie,j.status,\n CASE WHEN j.anulat=1 THEN N'Anulat' WHEN j.valid=1 THEN N'Validat' ELSE N'Nevalidat' END AS validare,\n CASE WHEN j.istoric=1 THEN N'Da' ELSE N'Nu' END AS in_istoric,\n CASE WHEN j.transmis_reges=1 THEN N'Da' ELSE N'Nu' END AS transmis,\n CASE WHEN j.eroare=1 THEN N'Da' ELSE N'Nu' END AS are_eroare,\n CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM dbo.Sal_REGES_Jurnal_browse_view j\nWHERE j.pl_cm=:contract_pl AND j.id_cm=:contract_id AND j.data_cons>=:period_from AND j.data_cons<:period_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "6E551EE2-851D-5DCA-BA57-09B8331D54C0",
"key": "an",
"type": "text"
}
],
"id": "F1AEB060-1FF2-503F-8A04-BB200D00B25E",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "contract_key",
"label": "contract_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contract_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an",
"label": "An calendaristic",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "inceput",
"label": "Început calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "inceput",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sfarsit",
"label": "Sfârșit calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sfarsit",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_contract",
"label": "Zile prevăzute în contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_contract",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_anterioare",
"label": "Zile din anii anteriori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_anterioare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_suplimentare",
"label": "Zile suplimentare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_suplimentare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_cuvenite",
"label": "Zile cuvenite",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_cuvenite",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "zile_efectuate",
"label": "Zile efectuate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_efectuate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "zile_de_efectuat",
"label": "Zile de efectuat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_de_efectuat",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "explicatie",
"label": "Acoperirea situației",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatie",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Concediu de odihnă — situație anuală",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "999B5D09-4430-5A55-88D8-43CB0D91E8AF",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "04F6A883-6346-5313-BD97-270141C3A1ED",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_pl",
"id": "685CD6BB-9721-5CA8-A6C1-869046B2B74B",
"name": "contract_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_id",
"id": "E5CAD75A-74ED-5991-944B-F05D13D2CBD8",
"name": "contract_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"an",
"inceput",
"sfarsit",
"zile_contract",
"zile_anterioare",
"zile_suplimentare",
"zile_cuvenite",
"zile_efectuate",
"zile_de_efectuat",
"explicatie"
],
"sourceID": "E06ACB64-9FA1-556C-AB35-E58CB8EB68B4",
"sqlQuery": "SELECT CONCAT(:contract_pl,':',:contract_id,':',a.an) AS row_id,CONCAT(CAST(:contract_pl AS int),':',CAST(:contract_id AS decimal(18,0))) AS contract_key,\n a.an,a.inceput,a.sfarsit,a.zile_contract,a.zile_anterioare,a.zile_suplimentare,a.zile_cuvenite,a.zile_efectuate,a.zile_de_efectuat,\n N'An calendaristic complet, valori calculate de Nexus' AS explicatie\nFROM (SELECT YEAR(CAST(:period_from AS date)) AS an\n UNION SELECT YEAR(DATEADD(day,-1,CAST(:period_until AS date)))) y\nCROSS APPLY dbo.sal_cm_calc_co_an(y.an,:contract_pl,:contract_id) a",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "2C12CF7C-9088-5261-94B1-C88223B2313E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "1A273E64-82A8-540C-8106-589741D304C1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"title": "Contracte și dosar",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_form",
"label": "Formație / echipă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cm_activ",
"label": "Contract activ astăzi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "contracte_active",
"label": "Contracte active",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "contracte_suspendate",
"label": "Contracte suspendate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E59B31F5-91E5-5AAB-B015-CD3B8DFD5ECC",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_form",
"label": "Formație / echipă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cm_activ",
"label": "Contract activ astăzi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "contracte_active",
"label": "Contracte active",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "contracte_suspendate",
"label": "Contracte suspendate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "contracte_inregistrate",
"label": "Contracte validate, neradiate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare_la_data",
"label": "Starea contractelor la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A1420D52-F907-5A92-A5F7-8B73C6477025",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "6042A454-1AA0-5606-A923-A50FB89BAF05",
"includeAllOption": false,
"key": "period_date",
"title": "Perioada pontajului și a jurnalului",
"type": "date"
},
{
"id": "DE94D0D6-74F9-5DE6-AC30-D5C6C14DFA11",
"includeAllOption": true,
"key": "cm_activ",
"title": "Are contract activ astăzi?",
"type": "text"
},
{
"id": "79CF3142-9D0E-5ABF-996A-AD9CB1D371BD",
"includeAllOption": true,
"key": "nume_form",
"title": "Formație / echipă",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "806AEF75-B86B-5174-87AF-695322D9D502",
"key": "nume",
"type": "text"
},
{
"direction": "ascending",
"id": "A9A3CD3C-1CC1-553F-9D89-BC863F719F40",
"key": "id_intern",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "den_functie_int",
"systemImage": "person.2",
"title": "Personal — dosar HR",
"titleKey": "nume"
},
{
"actions": [
{
"id": "3BBE9F68-7DB7-594E-AF75-AB5A93A033D3",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "6FBE9FCA-563E-5ACC-8793-02FB7632DD8C",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C956662F-F1E4-588E-8A1E-3BA1555F879A",
"title": "Istoric salarial",
"urlKey": ""
},
{
"id": "56EFF0F8-5177-5B6A-A2E0-0442DA46B0AE",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "4A356786-F478-54EF-B43F-FEAC97173E40",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "F04016F7-42E1-59B2-8B92-729AE50347F1",
"title": "Pontaj în perioada aleasă",
"urlKey": ""
},
{
"id": "8290206F-8974-5C07-A170-F2B4AC4E6607",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A9C058C4-5E9F-5BCA-9498-F3A41225DC48",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "ACA08C04-43E2-5EE7-BE06-FCE418C4FAE5",
"title": "Jurnalul contractului",
"urlKey": ""
},
{
"id": "52FE71A8-E96A-5E2D-AA39-96E9CD1E5C6E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "31064B81-45C6-5A3E-AB0B-B7AD3AB7B775",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "F1AEB060-1FF2-503F-8A04-BB200D00B25E",
"title": "Concediu de odihnă — anual",
"urlKey": ""
}
],
"badgeKey": "stare_contract",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_angajator",
"label": "Angajator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_functia",
"label": "Funcție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_form",
"label": "Formație / echipă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "d_inceput",
"label": "Început activitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "nume_angajator",
"label": "Angajator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "stare_la_data",
"label": "Verificat la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "nume_tip_cm",
"label": "Tip contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "den_tip_contr",
"label": "Durata contractului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "nume_cor",
"label": "Ocupație COR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "nume_functia",
"label": "Funcție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "den_form",
"label": "Formație / echipă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "den_locm",
"label": "Loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "d_inceput",
"label": "Început activitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "d_sfarsit",
"label": "Sfârșit perioadă determinată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "d_incetare",
"label": "Data încetării înregistrate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Condiții salariale și program",
"detailRole": "information",
"isVisible": true,
"key": "salariu_negociat",
"label": "Salariu negociat la data curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Condiții salariale și program",
"detailRole": "information",
"isVisible": true,
"key": "data_decizie_salariala",
"label": "Decizie salarială la data curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Condiții salariale și program",
"detailRole": "information",
"isVisible": true,
"key": "ore_norm",
"label": "Ore normă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Condiții salariale și program",
"detailRole": "information",
"isVisible": true,
"key": "ore_locm",
"label": "Ore loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Condiții salariale și program",
"detailRole": "information",
"isVisible": true,
"key": "h_start",
"label": "Program — început",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Condiții salariale și program",
"detailRole": "information",
"isVisible": true,
"key": "h_stop",
"label": "Program — sfârșit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "zile_preav",
"label": "Zile preaviz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "zile_proba",
"label": "Zile perioadă de probă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Condiții salariale și program",
"detailRole": "information",
"isVisible": true,
"key": "calc_tichete",
"label": "Calcul tichete",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract și încadrare",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0777DB8E-B92F-53C6-A99F-40A5C2DC51B9",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "D7D07942-C4F9-5201-9410-8A2E47C5F16A",
"key": "d_inceput",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "nume_pers",
"systemImage": "doc.text",
"title": "Contracte de muncă",
"titleKey": "nr_doc"
},
{
"actions": [
{
"id": "11D594A2-91C5-5955-895B-BD6DAF18BE3C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "E2664CC4-12E4-5410-BF83-C0F2F5DD161D",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "D6AEDA64-C85C-5C01-AE3E-58B4785C3BB8",
"title": "Sporuri din decizie",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data deciziei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ore_norm",
"label": "Ore normă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare_decizie",
"label": "Stare document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "C956662F-F1E4-588E-8A1E-3BA1555F879A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "seria_doc",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data deciziei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_actad",
"label": "Data actului adițional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sal_neg",
"label": "Salariu negociat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sal_ora",
"label": "Tarif orar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ore_norm",
"label": "Ore normă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ore_locm",
"label": "Ore loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare_decizie",
"label": "Stare document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "44D76367-8691-554F-A85C-B38EC4AACCB7",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "perioada_salarii",
"systemImage": "doc.text",
"title": "Istoric salarial — decizii",
"titleKey": "numar_doc"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent",
"label": "Procent din decizie (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "D6AEDA64-C85C-5C01-AE3E-58B4785C3BB8",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent",
"label": "Procent din decizie (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "integral",
"label": "Sumă fixă din decizie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "5361C944-215C-5E5C-B60E-DDA8D7F079B8",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "34CCDB38-B49F-5F62-86B1-01C2629F710C",
"key": "ordine",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "doc.text",
"title": "Sporuri din decizia salarială",
"titleKey": "spor"
},
{
"actions": [],
"badgeKey": "ore",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "formatie",
"label": "Formație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "F04016F7-42E1-59B2-8B92-729AE50347F1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "simbol",
"label": "Simbol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "h_start",
"label": "De la ora",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "h_stop",
"label": "Până la ora",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "formatie",
"label": "Formație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_locm",
"label": "Loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "457798F7-7283-5D3C-99DE-C838812E6911",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "18BDBE81-C082-54F7-8966-141F1F0EA2F8",
"key": "data",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "data",
"systemImage": "doc.text",
"title": "Pontaj înregistrat",
"titleKey": "tip_pontaj"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_cons",
"label": "Data evenimentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status",
"label": "Stare REGES",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "ACA08C04-43E2-5EE7-BE06-FCE418C4FAE5",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_cons",
"label": "Data evenimentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status",
"label": "Stare REGES",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "in_istoric",
"label": "În istoric",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "transmis",
"label": "Transmis REGES",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "are_eroare",
"label": "Eroare raportată de Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "Perioada desfășurătoarelor — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E4008E2A-DB18-5CCF-BC9B-3FF62142600A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "A60E1A57-7B96-561B-9FC5-51F7D26B30D7",
"key": "data_cons",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "den_operatie",
"systemImage": "doc.text",
"title": "Jurnal contract — REGES",
"titleKey": "den_modif"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_cuvenite",
"label": "Zile cuvenite",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_efectuate",
"label": "Zile efectuate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_de_efectuat",
"label": "Zile de efectuat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatie",
"label": "Acoperirea situației",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "F1AEB060-1FF2-503F-8A04-BB200D00B25E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "inceput",
"label": "Început calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sfarsit",
"label": "Sfârșit calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_contract",
"label": "Zile prevăzute în contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_anterioare",
"label": "Zile din anii anteriori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_suplimentare",
"label": "Zile suplimentare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_cuvenite",
"label": "Zile cuvenite",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_efectuate",
"label": "Zile efectuate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_de_efectuat",
"label": "Zile de efectuat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatie",
"label": "Acoperirea situației",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BEABFAED-D01C-5130-A10C-584F11201AA8",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "6E551EE2-851D-5DCA-BA57-09B8331D54C0",
"key": "an",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "doc.text",
"title": "Concediu de odihnă — situație anuală",
"titleKey": "an"
}
],
"relations": [
{
"childDatasetID": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"childKey": "person_key",
"id": "1A273E64-82A8-540C-8106-589741D304C1",
"name": "Contracte și dosar",
"parentDatasetID": "E59B31F5-91E5-5AAB-B015-CD3B8DFD5ECC",
"parentKey": "id_intern"
},
{
"childDatasetID": "C956662F-F1E4-588E-8A1E-3BA1555F879A",
"childKey": "contract_key",
"id": "6FBE9FCA-563E-5ACC-8793-02FB7632DD8C",
"name": "Istoric salarial",
"parentDatasetID": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"parentKey": "row_id"
},
{
"childDatasetID": "D6AEDA64-C85C-5C01-AE3E-58B4785C3BB8",
"childKey": "decision_key",
"id": "E2664CC4-12E4-5410-BF83-C0F2F5DD161D",
"name": "Sporuri din decizie",
"parentDatasetID": "C956662F-F1E4-588E-8A1E-3BA1555F879A",
"parentKey": "row_id"
},
{
"childDatasetID": "F04016F7-42E1-59B2-8B92-729AE50347F1",
"childKey": "contract_key",
"id": "4A356786-F478-54EF-B43F-FEAC97173E40",
"name": "Pontaj în perioada aleasă",
"parentDatasetID": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"parentKey": "row_id"
},
{
"childDatasetID": "ACA08C04-43E2-5EE7-BE06-FCE418C4FAE5",
"childKey": "contract_key",
"id": "A9C058C4-5E9F-5BCA-9498-F3A41225DC48",
"name": "Jurnalul contractului",
"parentDatasetID": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"parentKey": "row_id"
},
{
"childDatasetID": "F1AEB060-1FF2-503F-8A04-BB200D00B25E",
"childKey": "contract_key",
"id": "31064B81-45C6-5A3E-AB0B-B7AD3AB7B775",
"name": "Concediu de odihnă — anual",
"parentDatasetID": "BF239E51-8664-5D1B-A17E-4D49AA502630",
"parentKey": "row_id"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T08:07:41Z",
"description": "Dosar HR: persoană → contracte → istoric salarial, pontaj, jurnal REGES și concediu de odihnă. La deschidere alegi perioada desfășurătoarelor, formația și dacă persoana are contract activ ASTĂZI. Starea este citită din funcția datată Nexus, cu contractele nevalidate/radiate excluse; nu se deduce din regsal sau anul de inactivitate. Contractele arată angajator, funcție, ocupație COR, formație, loc de muncă, tip și durată, datele de început/sfârșit, program, probă și preaviz. În Detalii se văd salariul negociat și norma la data curentă; istoricul salarial arată deciziile validate/neanulate și tariful orar. Dintr-o decizie poți deschide sporurile, cu procentul și suma fixă separate, fără a le aduna sau a pretinde că reprezintă sume lunare plătite. Nu sunt salarii nete plătite și nu este un stat de plată. Istoricul deciziilor este complet pentru contract, independent de perioada pontajului. Pontajul și jurnalul sunt citite numai pentru contractul și intervalul selectat; zilele lipsă nu înseamnă absență. Jurnalul păstrează distinct evenimentele anulate/istorice, fără a le prezenta ca stare curentă. Concediul de odihnă arată valorile calculate de Nexus pentru fiecare AN CALENDARISTIC atins de perioada aleasă, nu doar pentru zilele filtrului. Salariile apar în Detalii, nu pe cardul public de personal. Cheile relațiilor sunt ascunse; nu se citesc CNP, IBAN, acte de identitate, adrese sau explicații medicale. Necesită autorizare HR pe propria sursă. Galeria folosește exclusiv persoane și sume DEMO. Citire live la cerere, fără actualizare globală automată; maximum 5.000 de rânduri pe listă, 10.000 la pontaj. Pro; iOS 1.1.0(336)/Android 1.1.0(284) sau mai nou. Nu scrie în ERP, nu înlocuiește salarizarea sau obligațiile REGES. Manuale: https://www.docs.nexuserp.ro/articol/contracte-de-munca/2770 ; https://www.docs.nexuserp.ro/manual-curs/nexus-salarii-online/3 ; https://www.docs.nexuserp.ro/articol/configurare-aplicatie-pontaje-online/5291 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "00064FF6-8E6F-5372-9375-7A88C0326C30",
"rootButtonCount": 1,
"summary": "Dosar HR: contract activ astăzi, salariu în Detalii, decizii, pontaj, jurnal REGES și concediu anual.",
"tags": [
"NexusERP",
"HR",
"pro"
],
"title": "Personal și dosar HR — Pro"
}
}