Contracte HR — termene și suspendări — Pro
Contracte cu termene apropiate, începuturi viitoare și suspendări; date, motive și jurnal REGES la cerere.
Contracte validate și neradiate care merită consultate: suspendate ASTĂZI, durată care se încheie în următoarele 90 zile, început viitor sau încetare viitoare înregistrată. Fiecare contract apare o singură dată, cu toate motivele aplicabile, persoană, funcție, formație, loc de muncă, angajator și date distincte. Starea vine din funcția Nexus datată, nu din anul de inactivitate al persoanei. Contractele viitoare rămân vizibile chiar dacă nu sunt încă în funcția stării curente. Sub-butoane: suspendările valide/neanulate în vigoare și jurnalul REGES din ultimele 90 zile. Jurnalul arată separat evenimente istorice/anulate și erori înregistrate la acel moment. Nu declară automat o eroare veche drept problemă nerezolvată, nu calculează expirarea perioadei de probă și nu certifică respectarea legislației. Orizontul este explicit: azi → ziua 90, nu filtrul istoric Ultimele 90 zile. Este un ecran read-only, nu notificare garantată în fundal. Nu sunt citite CNP, conturi, adrese sau explicații medicale. Pro, live, maximum 5.000 rânduri per listă, capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/activare-avertizari-privind-contractele-de-munca/5211 ; https://www.docs.nexuserp.ro/articol/operatiuni-ulterioare-inregistrarii-contractelor-de-munca/5207 .
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Contracte care necesită atenție
- Details: Suspendările în vigoare
- Details: Jurnalul recent al contractului
- Sub-button: Suspendări în vigoare
- Sub-button: Jurnal REGES — ultimele 90 zile
Sources are mapped locally and verified before applying.
Custom queriesPRO3 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 CONCAT(c.pct_lcr,':',c.id) AS row_id,c.pct_lcr AS contract_pl,c.id AS contract_id,
c.nume_pers AS persoana,c.nr_doc AS contract,c.nume_functia AS functia,c.den_form AS formatia,c.den_locm AS loc_munca,c.nume_angajator AS angajator,
CAST(GETDATE() AS date) AS verificat_la,DATEADD(day,90,CAST(GETDATE() AS date)) AS orizont_pana,
CASE WHEN s.stare='ContractStareActiv' THEN N'Activ' WHEN s.stare='ContractStareSuspendare' THEN N'Suspendat'
WHEN c.d_inceput>CAST(GETDATE() AS date) AND c.d_inceput<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Început viitor' ELSE N'Vezi datele contractului' END AS stare,
c.d_inceput AS inceput_contract,s.d_sfarsit AS sfarsit_contract,c.d_incetare AS incetare_inregistrata,
CASE WHEN s.stare IN ('ContractStareActiv','ContractStareSuspendare') AND s.d_sfarsit>=CAST(GETDATE() AS date) AND s.d_sfarsit<DATEADD(day,91,CAST(GETDATE() AS date)) THEN DATEDIFF(day,CAST(GETDATE() AS date),s.d_sfarsit) ELSE NULL END AS zile_pana_la_sfarsit,
CONCAT(CASE WHEN s.stare IN ('ContractStareActiv','ContractStareSuspendare') AND s.d_sfarsit>=CAST(GETDATE() AS date) AND s.d_sfarsit<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Termen în următoarele 90 zile. ' ELSE N'' END,
CASE WHEN s.stare='ContractStareSuspendare' THEN N'Suspendat la data verificării. ' ELSE N'' END,
CASE WHEN c.d_inceput>CAST(GETDATE() AS date) AND c.d_inceput<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Început viitor. ' ELSE N'' END,
CASE WHEN c.d_incetare>=CAST(GETDATE() AS date) AND c.d_incetare<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Încetare viitoare înregistrată.' ELSE N'' END) AS motive
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 (s.stare IN ('ContractStareActiv','ContractStareSuspendare') AND s.d_sfarsit>=CAST(GETDATE() AS date) AND s.d_sfarsit<DATEADD(day,91,CAST(GETDATE() AS date)) OR s.stare='ContractStareSuspendare' OR c.d_inceput>CAST(GETDATE() AS date) AND c.d_inceput<DATEADD(day,91,CAST(GETDATE() AS date)) OR c.d_incetare>=CAST(GETDATE() AS date) AND c.d_incetare<DATEADD(day,91,CAST(GETDATE() AS date)))static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(s.pct_lcr,':',s.id) AS row_id, CONCAT(s.pl_cm,':',s.id_cm) AS contract_key,CONCAT(RTRIM(s.seria_doc),' ',s.numar_doc,RTRIM(s.suf_nr_doc)) AS document, s.data_doc,s.data_ini,s.data_fin,s.data_inc FROM dbo.Sal_REGES_Centralizare_Suspendari_view s WHERE s.pl_cm=:contract_pl AND s.id_cm=:contract_id AND s.valid=1 AND s.anulat=0 AND s.data_ini<=CAST(GETDATE() AS date) AND (s.data_fin IS NULL OR s.data_fin>=CAST(GETDATE() AS date)) AND (s.data_inc IS NULL OR s.data_inc>CAST(GETDATE() AS date))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONVERT(varchar(30),j.id) AS row_id, CONCAT(j.pl_cm,':',j.id_cm) 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 eroare FROM dbo.Sal_REGES_Jurnal_browse_view j WHERE j.pl_cm=:contract_pl AND j.id_cm=:contract_id AND j.data_cons>=DATEADD(day,-89,CAST(GETDATE() AS date)) AND j.data_cons<DATEADD(day,1,CAST(GETDATE() AS date))
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "4A12292C-A2DA-5361-B805-BFCC47A938BA",
"kind": "sqlServer",
"requiredObjects": [
"dbo.Sal_CM_view",
"dbo.sal_stare_contracte",
"dbo.Sal_REGES_Centralizare_Suspendari_view",
"dbo.Sal_REGES_Jurnal_browse_view"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "95F1F5AA-4EFF-5C01-AB12-A8B889062C62",
"key": "persoana",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "748844DC-26C3-569A-89E2-7A5D2E090E88",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"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": "persoana",
"label": "Persoană",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "persoana",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "contract",
"label": "Contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "contract",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "functia",
"label": "Funcție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "functia",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "formatia",
"label": "Formație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "formatia",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "loc_munca",
"label": "Loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "loc_munca",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "angajator",
"label": "Angajator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "angajator",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "verificat_la",
"label": "Stare verificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "verificat_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "orizont_pana",
"label": "Termene urmărite până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "orizont_pana",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "stare",
"label": "Stare la verificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "inceput_contract",
"label": "Început contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "inceput_contract",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sfarsit_contract",
"label": "Sfârșit durată contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sfarsit_contract",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "incetare_inregistrata",
"label": "Încetare înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "incetare_inregistrata",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_pana_la_sfarsit",
"label": "Zile până la sfârșitul duratei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_pana_la_sfarsit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "motive",
"label": "Ce merită verificat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "motive",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Contracte care necesită atenție",
"primaryKey": "row_id",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"persoana",
"contract",
"functia",
"formatia",
"loc_munca",
"angajator",
"verificat_la",
"orizont_pana",
"stare",
"inceput_contract",
"sfarsit_contract",
"incetare_inregistrata",
"zile_pana_la_sfarsit",
"motive"
],
"sourceID": "4A12292C-A2DA-5361-B805-BFCC47A938BA",
"sqlQuery": "SELECT CONCAT(c.pct_lcr,':',c.id) AS row_id,c.pct_lcr AS contract_pl,c.id AS contract_id,\n c.nume_pers AS persoana,c.nr_doc AS contract,c.nume_functia AS functia,c.den_form AS formatia,c.den_locm AS loc_munca,c.nume_angajator AS angajator,\n CAST(GETDATE() AS date) AS verificat_la,DATEADD(day,90,CAST(GETDATE() AS date)) AS orizont_pana,\n CASE WHEN s.stare='ContractStareActiv' THEN N'Activ' WHEN s.stare='ContractStareSuspendare' THEN N'Suspendat'\n WHEN c.d_inceput>CAST(GETDATE() AS date) AND c.d_inceput<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Început viitor' ELSE N'Vezi datele contractului' END AS stare,\n c.d_inceput AS inceput_contract,s.d_sfarsit AS sfarsit_contract,c.d_incetare AS incetare_inregistrata,\n CASE WHEN s.stare IN ('ContractStareActiv','ContractStareSuspendare') AND s.d_sfarsit>=CAST(GETDATE() AS date) AND s.d_sfarsit<DATEADD(day,91,CAST(GETDATE() AS date)) THEN DATEDIFF(day,CAST(GETDATE() AS date),s.d_sfarsit) ELSE NULL END AS zile_pana_la_sfarsit,\n CONCAT(CASE WHEN s.stare IN ('ContractStareActiv','ContractStareSuspendare') AND s.d_sfarsit>=CAST(GETDATE() AS date) AND s.d_sfarsit<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Termen în următoarele 90 zile. ' ELSE N'' END,\n CASE WHEN s.stare='ContractStareSuspendare' THEN N'Suspendat la data verificării. ' ELSE N'' END,\n CASE WHEN c.d_inceput>CAST(GETDATE() AS date) AND c.d_inceput<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Început viitor. ' ELSE N'' END,\n CASE WHEN c.d_incetare>=CAST(GETDATE() AS date) AND c.d_incetare<DATEADD(day,91,CAST(GETDATE() AS date)) THEN N'Încetare viitoare înregistrată.' ELSE N'' END) AS motive\nFROM 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\nWHERE c.valid=1 AND c.radiat=0 AND (s.stare IN ('ContractStareActiv','ContractStareSuspendare') AND s.d_sfarsit>=CAST(GETDATE() AS date) AND s.d_sfarsit<DATEADD(day,91,CAST(GETDATE() AS date)) OR s.stare='ContractStareSuspendare' OR c.d_inceput>CAST(GETDATE() AS date) AND c.d_inceput<DATEADD(day,91,CAST(GETDATE() AS date)) OR c.d_incetare>=CAST(GETDATE() AS date) AND c.d_incetare<DATEADD(day,91,CAST(GETDATE() AS date)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "1E34AA80-9C07-5943-9B9D-C82CD29F7614",
"key": "document",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "A836C9A5-D9F2-5FA6-942B-EC8F1C747223",
"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": "document",
"label": "Document suspendare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_doc",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_ini",
"label": "Început suspendare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_ini",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_fin",
"label": "Sfârșit prevăzut",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_fin",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_inc",
"label": "Încetare suspendare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_inc",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Suspendări în vigoare",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_pl",
"id": "8F4AC01D-0F23-5130-8CF8-D4B0FCA93465",
"name": "contract_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_id",
"id": "11F78B3D-85DA-5A70-BF68-232307E39A15",
"name": "contract_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"document",
"data_doc",
"data_ini",
"data_fin",
"data_inc"
],
"sourceID": "4A12292C-A2DA-5361-B805-BFCC47A938BA",
"sqlQuery": "SELECT CONCAT(s.pct_lcr,':',s.id) AS row_id,\n CONCAT(s.pl_cm,':',s.id_cm) AS contract_key,CONCAT(RTRIM(s.seria_doc),' ',s.numar_doc,RTRIM(s.suf_nr_doc)) AS document,\n s.data_doc,s.data_ini,s.data_fin,s.data_inc\nFROM dbo.Sal_REGES_Centralizare_Suspendari_view s\nWHERE s.pl_cm=:contract_pl AND s.id_cm=:contract_id AND s.valid=1 AND s.anulat=0\n AND s.data_ini<=CAST(GETDATE() AS date) AND (s.data_fin IS NULL OR s.data_fin>=CAST(GETDATE() AS date))\n AND (s.data_inc IS NULL OR s.data_inc>CAST(GETDATE() AS date))",
"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": "29CB29F7-FC78-5F33-ABE9-4CEA2122C02F",
"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 înregistrată",
"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": false
},
{
"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": "eroare",
"label": "Eroare la eveniment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "eroare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Jurnal REGES — ultimele 90 zile",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_pl",
"id": "8F4AC01D-0F23-5130-8CF8-D4B0FCA93465",
"name": "contract_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "contract_id",
"id": "11F78B3D-85DA-5A70-BF68-232307E39A15",
"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",
"eroare"
],
"sourceID": "4A12292C-A2DA-5361-B805-BFCC47A938BA",
"sqlQuery": "SELECT CONVERT(varchar(30),j.id) AS row_id,\n CONCAT(j.pl_cm,':',j.id_cm) 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 eroare\nFROM dbo.Sal_REGES_Jurnal_browse_view j WHERE j.pl_cm=:contract_pl AND j.id_cm=:contract_id\n AND j.data_cons>=DATEADD(day,-89,CAST(GETDATE() AS date)) AND j.data_cons<DATEADD(day,1,CAST(GETDATE() AS date))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "690057F7-1161-589D-BBC6-21E79FD150CF",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "57F099E4-D042-577F-9752-794F7E92AEBD",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A836C9A5-D9F2-5FA6-942B-EC8F1C747223",
"title": "Suspendările în vigoare",
"urlKey": ""
},
{
"id": "E8785D05-CD88-5138-9F84-E14A22388FCB",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "BB0F21D6-1B6D-5C6F-BECA-D73DDB4821CA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "29CB29F7-FC78-5F33-ABE9-4CEA2122C02F",
"title": "Jurnalul recent al contractului",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "functia",
"label": "Funcție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "formatia",
"label": "Formație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "verificat_la",
"label": "Stare verificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare",
"label": "Stare la verificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sfarsit_contract",
"label": "Sfârșit durată contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_pana_la_sfarsit",
"label": "Zile până la sfârșitul duratei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "748844DC-26C3-569A-89E2-7A5D2E090E88",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "contract",
"label": "Contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "functia",
"label": "Funcție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "formatia",
"label": "Formație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "loc_munca",
"label": "Loc de muncă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "angajator",
"label": "Angajator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "verificat_la",
"label": "Stare verificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "orizont_pana",
"label": "Termene urmărite până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare",
"label": "Stare la verificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "inceput_contract",
"label": "Început contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sfarsit_contract",
"label": "Sfârșit durată contract",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "incetare_inregistrata",
"label": "Încetare înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_pana_la_sfarsit",
"label": "Zile până la sfârșitul duratei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FF0A06DC-1157-5FC4-8330-26990DE1D074",
"openFilters": [
{
"id": "CA32DB31-D937-5B10-8AE9-0FF599368EC4",
"includeAllOption": true,
"key": "formatia",
"title": "Formație",
"type": "text"
},
{
"id": "7D2B8A05-C802-5F69-8F6B-FDD3986AC63A",
"includeAllOption": true,
"key": "stare",
"title": "Stare",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "95F1F5AA-4EFF-5C01-AB12-A8B889062C62",
"key": "persoana",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "motive",
"systemImage": "person.2",
"title": "Contracte care necesită atenție",
"titleKey": "persoana"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_ini",
"label": "Început suspendare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_fin",
"label": "Sfârșit prevăzut",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A836C9A5-D9F2-5FA6-942B-EC8F1C747223",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_ini",
"label": "Început suspendare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_fin",
"label": "Sfârșit prevăzut",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_inc",
"label": "Încetare suspendare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "753464CF-6E80-5A03-B997-E94B3A12174A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "1E34AA80-9C07-5943-9B9D-C82CD29F7614",
"key": "document",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "doc.text",
"title": "Suspendări în vigoare",
"titleKey": "document"
},
{
"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 înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "29CB29F7-FC78-5F33-ABE9-4CEA2122C02F",
"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 înregistrată",
"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": "eroare",
"label": "Eroare la eveniment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FDB18404-1D78-5A61-B841-21A471F9E9DD",
"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 REGES — ultimele 90 zile",
"titleKey": "den_modif"
}
],
"relations": [
{
"childDatasetID": "A836C9A5-D9F2-5FA6-942B-EC8F1C747223",
"childKey": "contract_key",
"id": "57F099E4-D042-577F-9752-794F7E92AEBD",
"name": "Suspendările în vigoare",
"parentDatasetID": "748844DC-26C3-569A-89E2-7A5D2E090E88",
"parentKey": "row_id"
},
{
"childDatasetID": "29CB29F7-FC78-5F33-ABE9-4CEA2122C02F",
"childKey": "contract_key",
"id": "BB0F21D6-1B6D-5C6F-BECA-D73DDB4821CA",
"name": "Jurnalul recent al contractului",
"parentDatasetID": "748844DC-26C3-569A-89E2-7A5D2E090E88",
"parentKey": "row_id"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T10:23:52Z",
"description": "Contracte validate și neradiate care merită consultate: suspendate ASTĂZI, durată care se încheie în următoarele 90 zile, început viitor sau încetare viitoare înregistrată. Fiecare contract apare o singură dată, cu toate motivele aplicabile, persoană, funcție, formație, loc de muncă, angajator și date distincte. Starea vine din funcția Nexus datată, nu din anul de inactivitate al persoanei. Contractele viitoare rămân vizibile chiar dacă nu sunt încă în funcția stării curente. Sub-butoane: suspendările valide/neanulate în vigoare și jurnalul REGES din ultimele 90 zile. Jurnalul arată separat evenimente istorice/anulate și erori înregistrate la acel moment. Nu declară automat o eroare veche drept problemă nerezolvată, nu calculează expirarea perioadei de probă și nu certifică respectarea legislației. Orizontul este explicit: azi → ziua 90, nu filtrul istoric Ultimele 90 zile. Este un ecran read-only, nu notificare garantată în fundal. Nu sunt citite CNP, conturi, adrese sau explicații medicale. Pro, live, maximum 5.000 rânduri per listă, capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/activare-avertizari-privind-contractele-de-munca/5211 ; https://www.docs.nexuserp.ro/articol/operatiuni-ulterioare-inregistrarii-contractelor-de-munca/5207 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "98D3660F-5827-534B-8475-4072D67F7818",
"rootButtonCount": 1,
"summary": "Contracte cu termene apropiate, începuturi viitoare și suspendări; date, motive și jurnal REGES la cerere.",
"tags": [
"NexusERP",
"Pro"
],
"title": "Contracte HR — termene și suspendări — Pro"
}
}