============
Implementare
============

**1.** Se sterge tabela *PARAMETRI*.

**2.** Se incarca tabela *PARAMETRI* (:download:`Parametri 2024 <_downloads_xls/Parametri_2024.xlsx>`, :download:`Parametri 2001-2023 <_downloads_xls/Parametri 2001 - 2023.xlsx>`).
								
**3.** Se exporta listele rezervate - tipurile de lista: 

	"ABL", "ACT", "ASO", "ATS", "BNC", "C00", "C01", "C02", "C03", "C04", "CAL", "CET", "CGA", "CLA", "CLF", "CML", "COR", "CRD", "CRT", "CTG", "D00", "DGS", "DIS", "DOM", "DST", "EVN", "F00", "FDS", "FJF", "FNV", "FOF", "FPC", "FPG", "FPR", "FPT", "GML", "ICS", "IND", "LMB", "M05", "M06", "M07", "MDA", "MMD", "MTP", "NAT", "NMT", "NVA", "NVC", "NVL", "P00", "PNT", "RCM", "REL", "S00", "SMJ", "SML", "SPC", "STU", "TCT", "TNL", "TNP", "TPS", "TPV", "TSO", "TTS", "VNV", "DCL", "SCT", "DEC", "SAN", "MOT", "CAE". 

Exemple de lista necesare pentru functionarea modulului HR sunt:

- ACT ACTIVITATI - :download:`Activitati <_downloads_xls/Activitati.xlsx>`,

- ABL CODURI PENTRU ABILITATI - :download:`Abilitati <_downloads_xls/Abilitati.xlsx>`,

- ASO CASE DE ASIGURARI SOCIALE	- :download:`Case de Asigurari Sociale <_downloads_xls/Case de Asigurari Sociale.xlsx>`,

- ATS ACTE STUDIU - :download:`Acte Studiu <_downloads_xls/Acte Studiu.xlsx>`,

- BNC BANCI CARD - :download:`Banci pentru Viramente Carduri <_downloads_xls/Banci pentru Viramente Carduri.xlsx>`,

- C00 CODURI INCETARE CONTRACT - :download:`Incetare Contract <_downloads_xls/Incetare Contract.xlsx>`,

- C01 MOTIVE SCHIMBARE CONTRACT	- :download:`Motive Schimbare Contract <_downloads_xls/Motive Schimbare Contract.xlsx>`,

- C02 MOTIVE REACTIVARE CONTRACT - :download:`Motive Reactivare Contract <_downloads_xls/Motive Reactivare Contract.xlsx>`,

- C03 MOTIVE NR/DATA CONTRACT - :download:`Motive NrData Contract <_downloads_xls/Motive NrData Contract.xlsx>`,

- C04 CATEGORIE DE PERSONAL	- :download:`Motive Categorie Personal <_downloads_xls/Motive Categorie Personal.xlsx>`,

- CAL CALIFICATIVE STUDII - :download:`Calificative Studii <_downloads_xls/Calificative Studii.xlsx>`,

- CET CODURI PENTRU CETATENI - :download:`Cetatenii <_downloads_xls/Cetatenii.xlsx>`,

- CGA CODURI PENTRU CATEGORIILE AUTO - :download:`Categorii Auto <_downloads_xls/Categorii Auto.xlsx>`,

- CLA CALIFICATIVE ABILITATI - :download:`Calificative Abilitati <_downloads_xls/Calificative Abilitati.xlsx>`,

- CLF CODURI NIVEL CUNOASTERE LIMBI STRAINE - :download:`Calificative Limbi Straine <_downloads_xls/Calificative Limbi Straine.xlsx>`,

- CML CORP MILITAR - :download:`Corpuri Militare <_downloads_xls/Corpuri Militare.xlsx>`,

- COR CODURI COR - :download:`COR <_downloads_xls/COR.xlsx>`,

- CRD CODURI PENTRU TIPURI DE CARDURI - :download:`Tipuri De Carduri <_downloads_xls/Tipuri De Carduri.xlsx>`,

- CRT CARACTERISTICI - :download:`Caracteristici <_downloads_xls/Caracteristici.xlsx>`,

- CTG CODURI PENTRU CATEGORII DE PERSONAL - :download:`Categorii De Personal <_downloads_xls/Categorii De Personal.xlsx>`,

- D00 MOTIVE SCHIMBARE DOMICILIU - :download:`Motive Schimbare Domiciliu <_downloads_xls/Motive Schimbare Domiciliu.xlsx>`,

- DGS DIAGNOSTIC MEDICAL - :download:`Diagnostic Medical <_downloads_xls/Diagnostic Medical.xlsx>`,

- DOM DOMENII SPECIALIZARI - :download:`Specializare <_downloads_xls/Specializare.xlsx>`,

- DMO DIMENSIUNI ORGANIGRAMA - :download:`Dimensiuni Organigrama <_downloads_xls/Dimensiuni Organigrama.xlsx>`,

- DST CODURI PENTRU DOMENII STUDII - :download:`Domenii Studii <_downloads_xls/Domenii Studii.xlsx>`,

- EVN EVENIMENTE - :download:`Evenimente <_downloads_xls/Evenimente.xlsx>`,

- F00 MOTIVE FUNCTII OCUPATII - :download:`Motive Functii Ocupatii <_downloads_xls/Motive Functii Ocupatii.xlsx>`,

- FDS CASE DE ASIGURARI DE SANATATE - :download:`Case De Sanatate <_downloads_xls/Case De Sanatate.xlsx>`,

- FJF FORMA JURIDICA FIRMA - :download:`Forma Juridica Firma <_downloads_xls/Forma Juridica Firma.xlsx>`,

- FOF FORMA DE ORGANIZARE FIRMA - :download:`Forma De Organizare Firma <_downloads_xls/Forma De Organizare Firma.xlsx>`,

- FPC CLASE FUNCTII - :download:`Clase Salarii <_downloads_xls/Clase Salarii.xlsx>`,

- FPG GRADE FUNCTII - :download:`Grade Profesionale <_downloads_xls/Grade Profesionale.xlsx>`,

- FPR GRADATII FUNCTII - :download:`Gradatii Functii <_downloads_xls/Gradatii Functii.xlsx>`,

- FPT TREPTE FUNCTII - :download:`Treapta De Salarizare <_downloads_xls/Treapta De Salarizare.xlsx>`,

- GML GRADE MILITARE - :download:`Grade Militare <_downloads_xls/Grade Militare.xlsx>`,

- GRM GRUPE DE MUNCA - :download:`Grupe De Munca <_downloads_xls/Grupe De Munca.xlsx>`,

- HDM TIPURI DE DOCUMENTE SCANATE - :download:`Documente Dosar Digital <_downloads_xls/Documente Dosar Digital.xlsx>`,

- ICS INDICATOR COND SPECIALE DE MUNCA - :download:`Indicativ Cond Spec <_downloads_xls/Indicativ Cond Spec.xlsx>`,

- IND CODURI PENTRU INDICI DE LISTARE - :download:`Indici De Listare <_downloads_xls/Indici De Listare.xlsx>`,

- LMB CODURI PENTRU LIMBI STRAINE - :download:`Limbi Straine <_downloads_xls/Limbi Straine.xlsx>`,

- M05 CODURI BOLI INFECTO-CONTAGIOASE GRUPA A - :download:`Boli Infecto-Contagioase Grupa A <_downloads_xls/Boli Infecto-Contagioase Grupa A.xlsx>`,

- M06 CODURI URGENTE MEDICO CHIRURGICALE - :download:`Urgente Medico-chirurgicale <_downloads_xls/Urgente Medico-chirurgicale.xlsx>`,

- M07 LOC PRESCRIERE CERTIFICAT MEDICAL - :download:`Loc De Prescrire Certificat Medical <_downloads_xls/Loc De Prescrire Certificat Medical.xlsx>`,

- MDA CODURI PENTRU MODURILE DE ANGAJARE - :download:`Moduri De Angajare <_downloads_xls/Moduri De Angajare.xlsx>`,

- MMD MOTIVE MODIFICARE - :download:`Lista Pentru Motive Modificare <_downloads_xls/Lista Pentru Motive Modificare.xlsx>`,

- MTP CODURI PENTRU MOTIVE DE PLECARE DIN UNITATE - :download:`Motive de Plecare din Unitate <_downloads_xls/Motive de Plecare din Unitate.xlsx>`,

- NAT CODURI PENTRU NATIONALITATI - :download:`Nationalitati <_downloads_xls/Nationalitati.xlsx>`,

- NMT CODURI PENTRU NORME DE TIMP - :download:`Norme De Timp <_downloads_xls/Norme De Timp.xlsx>`,

- NVA NIVEL CUNOASTERE ABILITATI - :download:`Nivel Cunostinte Abilitati <_downloads_xls/Nivel Cunostinte Abilitati.xlsx>`,
 
- NVC NIVELURI CUNOSTINTE CALCULATOR - :download:`Nivel Cunostinte Calculatoare <_downloads_xls/Nivel Cunostinte Calculatoare.xlsx>`,

- NVL NIVELURI CUNOSTINTE LIMBI STRAINE - :download:`Nivel Cunostinte Limbi Straine <_downloads_xls/Nivel Cunostinte Limbi Straine.xlsx>`,

- P00 MOTIVE SCHIMBARE SPORURI - :download:`Motive Schimbare Sporuri <_downloads_xls/Motive Schimbare Sporuri.xlsx>`,

- PNT CODURI DE PONTAJ - :download:`Coduri De Pontaj <_downloads_xls/Coduri De Pontaj.xlsx>`,

- RCM MOTIV RECTIFICARE - :download:`Motive Rectificare <_downloads_xls/Motive Rectificare.xlsx>`,

- REL CODURI PENTRU RELIGII - :download:`Religii <_downloads_xls/Religii.xlsx>`,

- RGL REGIMURI DE LUCRU - :download:`Regimuri De Lucru <_downloads_xls/Regimuri De Lucru.xlsx>`,

- S00 MOTIVE SCHIMBARE SALARII - :download:`Motive Schimbare Salarii <_downloads_xls/Motive Schimbare Salarii.xlsx>`,

- SMJ CASE DE ASIGURARI DE SOMAJ - :download:`Case De Somaj <_downloads_xls/Case De Somaj.xlsx>`,

- SML CODURI PENTRU SPECIALITATI MILITARE - :download:`Specialitati Militare <_downloads_xls/Specialitati Militare.xlsx>`,

- SPC SPECIALIZARI - :download:`Specializari <_downloads_xls/Specializari.xlsx>`,

- STU NIVELURI DE STUDII - :download:`Studii <_downloads_xls/Studii.xlsx>`,

- TCT TIPURI CONTRACTE DE MUNCA - :download:`Tipuri Contracte De Munca <_downloads_xls/Tipuri Contracte De Munca.xlsx>`,

- TNL CODURI PENTRU TIPURI DE TIMP NELUCRAT - :download:`Tipuri de Timp Nelucrat <_downloads_xls/Tipuri de Timp Nelucrat.xlsx>`,

- TNP TIMP NELUCRAT - :download:`Timp Nelucrat <_downloads_xls/Timp Nelucrat.xlsx>`,

- TPS TIP STUDII  - :download:`Tip Studii <_downloads_xls/Tip Studii.xlsx>`,

- TPV TIPURI DE VENIT - :download:`Tipuri De Venit <_downloads_xls/Tipuri De Venit.xlsx>`,

- TTS TITLURI STIINTIFICE - :download:`Titlu Stiintific <_downloads_xls/Titlu Stiintific.xlsx>`,

- SCT TIP SCUTIRE - :download:`Scutiri Impozite <_downloads_xls/Scutiri Impozite.xlsx>`.

**4.** Daca lipsesc, de exemplu de pe baza listele rezervate: "CAL", "CML", "COR", "DIS", "DST", "EVN", "FNV", "M07", "SPC", "TPS", "TSO", "TTS", "VNV", "DCL", "DEC", "SAN", "MOT"; se face insert in baza - :download:`Insert TIPINTERN <_downloads_xls/Insert_TIPINTERN.sql>`        

**5.** Incarcare liste rezervate - :download:`Liste rezervate <_downloads_xls/Liste rezervate.xlsx>`.

**6.** Se importa VGFIRMA - :download:`Vgfirma <_downloads_xls/Vgfirma.xlsx>`.

**7.** Se importa VGFILIALE - :download:`Vgfiliale <_downloads_xls/Vgfiliale.xlsx>`.

**8.** Se sterge bazaimp, apoi se importa - :download:`Bazaimp <_downloads_xls/Bazaimp.xlsx>`.

**9.** Dictionar formule - :download:`Dictionar formule <_downloads_xls/Dictionar formule.xlsx>`.

**10.** Configurare pontaje - :download:`Configurare pontaje <_downloads_xls/Configpont.xlsx>`.  

**11.** Norme timp - :download:`Norme de timp <_downloads_xls/Norme de timp.xlsx>`.     

**12.** Pontaje implicite - :download:`Pontaje implicite <_downloads_xls/Pontimpl.xlsx>`. 

**13.** Setari salarii - :download:`Setari salarii <_downloads_xls/Setsalarii.xlsx>`.                

**14.** Tabela concedii medicale - :download:`Tabela concedii medicale <_downloads_xls/Tabela Concedii Medicale.xlsx>`.

**15.** Casieri - :download:`Casieri <_downloads_xls/Casieri.xlsx>`.   

**16.** Dictionar documente - :download:`Documente <_downloads_xls/Documente.xlsx>`.   

**17.** Insert in baza in tabela *COR_LEGE* - :download:`COR_LEGE <_downloads_xls/_cor_lege.sql>`.          

**18.** Dicmes - :download:`Dictionar functii <_downloads_xls/Dicmes.xlsx>`.

**19.** Defcor - :download:`Defcor <_downloads_xls/Defcor.xlsx>`.

**20.** Fp_dicmes.

**21.** Coefmes - :download:`Coefmes <_downloads_xls/Coefmes.xlsx>`.

**22.** Indici.
								
**23.** Configspor.																															  
            
**24.** Beneficiar - :download:`Beneficiar <_downloads_xls/Beneficiar.xlsx>`.

**25.** Dicdat - :download:`Dictionar de datorii <_downloads_xls/Dicplata.xlsx>`.        

**26.** Taxecomis - :download:`Taxe si comisioane <_downloads_xls/Taxecomis.xlsx>`.

**27.** Dicspor - :download:`Dictionar de sporuri <_downloads_xls/Dicspor.xlsx>`.               

**28.** Dicplata - :download:`Dictionar de plati <_downloads_xls/Dicplata.xlsx>`.