Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

  1. EMPLOYEE_TYPE vs EDUCATION_DEGREE 
  2. EMPLOYEE_TYPE vs QUALIFICATION_TYPE 
  3. EMPLOYEE_TYPE vs SPECIALITY_TYPE 
  4. EMPLOYEE_TYPE vs SPECIALITY_LEVEL 
  5. EMPLOYEE_TYPE = OWNER vs POSITION

EMPLOYEE_TYPE vs POSITION

(Рекомендований мапінг. Валідація типу співробітника і посади не здійснюється)

"ADMIN": "P5", "P6", "P14", "P18", "P19",
"ASSISTANT": "P17", "P169", "P170", "P171", "P173", "P174", "P175", "P176", "P177", "P178", "P179", "P180", "P181", "P182", "P183", "P184", "P185", "P186", "P187", "P188", "P189", "P190", "P191", "P192", "P193", "P194", "P195", "P196", "P197", "P198", "P199", "P200", "P201", "P202", "P203", "P204", "P205", "P206", "P207", "P208", "P209", "P210", "P211", "P212", "P213", "P214", "P215", "P216", "P250", "P251", "P252", "P253", "P256" ,
"DOCTOR": "P7", "P8", "P9", "P10", "P11",
"HR":"P14",
"OWNER", ""PHARMACY_OWNER": "P1", "P2", "P3", "P4", Following validations should exist and be configurable:

  1. EMPLOYEE_TYPE vs EDUCATION_DEGREE 

  2. EMPLOYEE_TYPE vs QUALIFICATION_TYPE 

  3. EMPLOYEE_TYPE vs SPECIALITY_TYPE 

  4. EMPLOYEE_TYPE vs SPECIALITY_LEVEL 

  5. EMPLOYEE_TYPE = OWNER vs POSITION


EMPLOYEE_TYPE vs POSITION

"ADMIN": "P5", "P6", "P14", "P18", "P19",

"ASSISTANT": "P17", “P66“, "P169", "P170", "P171", "P173", "P174", "P175", "P176", "P177", "P178", "P179", "P180", "P181", "P182", "P183", "P184", "P185", "P186", "P187", "P188", "P189", "P190", "P191", "P192", "P193", "P194", "P195", "P196", "P197", "P198", "P199", "P200", "P201", "P202", "P203", "P204", "P205", "P206", "P207", "P208", "P209", "P210", "P211", "P212", "P213", "P214", "P215", "P216", "P250", "P251", "P252", "P253", "P256" ,

"DOCTOR": "P7", "P8", "P9", "P10", "P11",

"HR": "P14",

"OWNER", ""PHARMACY_OWNER": "P1", "P2", "P3", "P4", "P5", "P6", "P18", "P19", "P22", "P23", "P24", "P25", "P26", "P32", "P229", "P230", "P231", "P232", "P233", "P234", "P235", "P236", "P237", "P238", "P239", “P240“, "P247", "P249", "P257",

"PHARMACIST": "P16", "P19", "P20", "P21", "P217", "P218", "P219", "P220", "P221", "P222", "P223", “P259”, “P260”, “P261”, “P262”, “P263”, “P264”, “P265”

"PHARMACY_OWNER":,

"RECEPTIONIST": "P15",

"SPECIALIST": "P5", "P6", "P18P8", "P19P9", "P22P10", "P23P11", "P24P12", "P25P13", "P26P33", "P32P34", "P229P35", "P230P36", "P231P37", "P232P38", "P233P39", "P234P40", "P235P41", "P236P42", "P249P43", "P257P44",
"PHARMACISTP45": , "P16P46", "P20P47", "P21P48", "P217P49", "P218P50", "P219P51", "P220P52", "P221P53", "P222P54", "P223P55",
"PHARMACY_OWNERP56":,
"RECEPTIONISTP57": , "P15P58",
"SPECIALISTP59": , "P5P60", "P6P61", "P8P62", "P9P63", "P10P64", "P11P65", "P12P66", "P13P67", "P33P68", "P34P69", "P35P70", "P36P71", "P37P72", "P38P73", "P39P74", "P40P75", "P41P76", "P42P77", "P43P78", "P44P79", "P45P80", "P46P81", "P47P82", "P48P83", "P49P84", "P50P85", "P51P86", "P52P87", "P53P88", "P54P89", "P55P90", "P56P91", "P57P92", "P58P93", "P59P94", "P60P95", "P61P96", "P62P97", "P63P98", "P64P99", "P65P100", "P66P101", "P67P102", "P68P103", "P69P104", "P70P105", "P71P106", "P72P107", "P73P108", "P74P109", "P75P110", "P76P111", "P77P112", "P78P113", "P79P114", "P80P115", "P81P116", "P82P117", "P83P118", "P84P119", "P85P120", "P86P121", "P87P122", "P88P123", "P89P124", "P90P125", "P91P126", "P92P127", "P93P128", "P94P129", "P95P130", "P96P131", "P97P132", "P98P133", "P99P134", "P100P135", "P101P136", "P102P137", "P103P138", "P104P139", "P105P140", "P106P141", "P107P142", "P108P143", "P109P144", "P110P145", "P111P146", "P112P147", "P113P148", "P114P149", "P115P150", "P116P151", "P117P152", "P118P153", "P119P154", "P120P155", "P121P156", "P122P157", "P123P158", "P124P159", "P125P160", "P126P161", "P127P162", "P128P163", "P129P164", "P130P165", "P131P166", "P132P167", "P133P228", "P134P248", "P135P245", P246, "P136P258", "P137P266", "P138P267", "P139P268", "P140P269", "P141P270",

"P142NHS ADMIN","P143NHS ADMIN MONITORING","P144NHS ADMIN PROGRAM MEDICATION","P145NHS ADMIN REIMBURSEMENT","P146NHS ADMIN SIGNER","P147NHS ADMIN VERIFIER","P148NHS FORBIDDEN ADMIN","P149NHS LE TERMINATOR","P150NHS LE VERIFIER","P151NHS REVIEWER", : "P152P27", "P153P28", "P154P29", "P155P30", "P156P31", "P157P237", "P158P238", "P159P239",

"P160", "P161MED_ADMIN": лікарські посади "P5", "P162P6", "P163P7", "P164P8", "P165P9", "P166P10", "P167P11", "P228P12", "P248P13", "P245P33", "P258P34"
, "NHS ADMINP35", "NHS ADMIN MONITORINGP36", "NHS ADMIN PROGRAM MEDICATIONP37", "NHS ADMIN REIMBURSEMENTP38", "NHS ADMIN SIGNERP39", "NHS ADMIN VERIFIERP40", "NHS FORBIDDEN ADMINP41", "NHS LE TERMINATORP42", "NHS LE VERIFIERP43", "NHS REVIEWERP44": , "P27P45", "P28P46", "P29P47", "P30P48", "P31P49", "P237P50", "P238P51", "P239P52"
, "MED_ADMIN": лікарські посади "P5P53", "P54", "P6P55", "P8P56", "P9P57", "P10P58", "P11P59", "P12P60", "P13P61", "P33P62", "P34P63", "P35P64", "P36P65", "P37P66", "P38P67", "P39P68", "P40P69", "P41P70", "P42P71", "P43P72", "P44P73", "P45P74", "P46P75", "P47P76", "P48P77", "P49P78", "P50P79", "P51P80", "P52P81", "P53P82", "P54P83", "P55P84", "P56P85", "P57P86", "P58P87", "P59P88", "P60P89", "P61P90", "P62P91", "P63P92", "P64P93", "P65P94", "P66P95", "P67P96", "P68P97", "P69P98", "P70P99", "P71P100", "P72P101", "P73P102", "P74P103", "P75P104", "P76P105", "P77P106", "P78P107", "P79P108", "P80P109", "P81P110", "P82P111", "P83P112", "P84P113", "P85P114", "P86P115", "P87P116", "P88P117", "P89P118", "P90P119", "P91P120", "P92P121", "P93P122", "P94P123", "P95P124", "P96P125", "P97P126", "P98P127", "P99P128", "P100P129", "P101P130", "P102P131", "P103P132", "P104P133", "P105P134", "P106P135", "P107P136", "P108P137", "P109P138", "P110P139", "P111P140", "P112P141", "P113P142", "P114P143", "P115P144", "P116P145", "P117P146", "P118P147", "P119P148", "P120P149", "P121P150", "P122P151", "P123P152", "P124P153", "P125P154", "P126P155", "P127P156", "P128P157", "P129P158", "P130P159", "P131P160", "P132P161", "P133P162", "P134P163", "P135P164", "P136P165", "P137P166", "P138P167", "P139P228", "P140P248", "P141P245", "P142P258", "P143P266", "P144P267", "P145P268", "P146P269", "P147", "P148P270" + керівні медичні посади "P1", "P149P2", "P150P3", "P151P4", "P152P5", "P153P6", "P154P23", "P155P24", "P156P25", "P157P26", "P158P32", "P159P229", "P160P230", "P161P231", "P162P249", "P163", "P164", "P165", "P166", "P167", "P228", "P248", "P245", "P258" + керівні медивні посади "P1", "P2", "P3", "P4", "P5", "P6", "P23", "P24", "P25", "P26", "P32", "P229", "P230", "P231", "P249", "P257"

EMPLOYEE_TYPE vs SPECIALITY_TYPE

"DOCTOR": "FAMILY_DOCTOR", "PEDIATRICIAN", "THERAPIST"

"SPECIALIST": "PHYSICAL_THERAPEUTICS", "ERGOTHERAPEUTICS", "IMMUNOLOGY", "INFECTIOUS_DISEASES", "CARDIOLOGY", "CLINICAL_BIOCHEMISTRY", "CLINICAL_IMMUNOLOGY", "CLINICAL_DIAGNOSTIC", "COMBUSTIOLOGY", "COMMUNAL_HYGIENE", "LABORATORY_IMMUNOLOGY", "LABORATORY_RESEARCH_OF_ENVIRONMENTAL_FACTORS", "LABORATORY_RESEARCH_OF_ENVIRONMENT_PHYSICAL_FACTORS", "LABORATORY_RESEARCH_OF_ENVIRONMENT_CHEMICAL_FACTORS", "PHYSICAL_THERAPY", "PHYSICAL_THERAPY_AND_SPORTS_MEDICINE", "EMERGENCY_MEDICINE", "MEDICAL_PSYCHOLOGY", "MICROBIOLOGY", "NARCOLOGY", "TRADITIONAL_ALTERNATIVE_MEDICINE", "NEUROLOGY", "NEUROSURGERY", "NEONATOLOGY", "NEPHROLOGY", "GYNECOLOGIC_ONCOLOGY", "ONCOLOGY", "ONCOTOLARYNGOLOGY", "SURGICAL_ONCOLOGY", "PUBLIC_HEALTH_ORGANIZATION", "ORTHODONTOLOGY", "ORTHOPEDIC_DENTISTRY", "ORTHOPAEDICS", "OTORHINOLARYNGOLOGY", "OPHTHALMOLOGY", "PARASITOLOGY", "PATHOLOGIC_ANATOMY", "PEDIATRICIAN", "ADOLESCENT_MEDICINE", "PROCTOLOGY", "RADIATION_THERAPY", "OCCUPATIONAL_PATHOLOGY", "PSYCHIATRY", "PSYCHOTHERAPY", "PSYCHOPHYSIOLOGY", "PULMONOLOGY", "RADIATION_HYGIENE", "RADIOLOGY", "RADIOLOGIC_DIAGNOSIS", "RHEUMATOLOGY", "X_RAY_RADIOLOGY", "REFLEXOLOGY", "SANOLOGY", "SEXOPATHOLOGY", "SPORTS_MEDICINE", "STOMATOLOGY", "VASCULAR_SURGERY", "FORENSIC_MEDICINE", "FORENSIC_MEDICAL_HISTOLOGY", "FORENSIC_MEDICAL_EXAMINATION", "FORENSIC_IMMUNOLOGY", "FORENSIC_CRIMINOLOGY", "FORENSIC_MEDICAL_TOXICOLOGY", "FORENSIC_CYTOLOGY", "FORENSIC_PSYCHIATRIC_EXAMINATION", "AUDIOLOGY", "THERAPEUTIC_DENTISTRY", "THERAPIST", "TOXICOLOGY", "THORACIC_SURGERY", "TRANSPLANTOLOGY", "TRANSFUSIOLOGY", "ULTRASONIC_DIAGNOSIS", "UROLOGY", "PHYSIOTHERAPY", "PHYSICAL_MEDICINE_AND_REHABILITATION", "PHTHISIOLOGY", "FUNCTIONAL_DIAGNOSTICS", "SURGICAL_DENTISTRY", "GENERAL_SURGERY", "CARDIOVASCULAR_SURGERY", "AEROSPACE_MEDICINE", "OBSTETRICS_AND_GYNECOLOGY", "ALLERGOLOGY", "ANAESTHETICS", "BACTERIOLOGY", "VIROLOGY", "GASTROENTEROLOGY", "GENERAL_HEMATOLOGY", "LABORATORY_GENETICS", "MEDICAL_GENETICS", "GERIATRICS", "PEDIATRIC_HYGIENE", "OCCUPATIONAL_MEDICINE", "FOOD_HYGIENE", "DISINFECTION_", "DERMATO-VENEREOLOGY", "PEDIATRIC_ALLERGY", "PEDIATRIC_ANAESTHETICS", "PEDIATRIC_GASTROENTEROLOGY", "PEDIATRIC_HEMATOLOGY", "PEDIATRIC_GYNECOLOGY", "PEDIATRIC_DERMATO-VENEREOLOGY", "PEDIATRIC_ENDOCRINOLOGY", "PEDIATRIC_IMMUNOLOGY", "PEDIATRIC_CARDIOLOGY", "PEDIATRIC_NEUROLOGY", "PEDIATRIC_NEPHROLOGY", "PEDIATRIC_ONCOLOGY", "PEDIATRIC_ORTHOPAEDICS", "PEDIATRIC_OTOLARYNGOLOGY", "PEDIATRIC_OPHTHALMOLOGY", "PEDIATRIC_PATHOLOGY", "PEDIATRIC_PSYCHIATRY", "PEDIATRIC_PULMONOLOGY", "PEDIATRIC_STOMATOLOGY", "PEDIATRIC_UROLOGY", "PEDIATRIC_PHTHISIOLOGY", "PEDIATRIC_SURGERY", "PEDIATRIC_INFECTIOUS_DISEASE", "DIETETICS", "ENDOCRINOLOGY", "ENDOSCOPY", "EPIDEMIOLOGY", "COMMON_HYGIENE"

"ASSISTANT": "ORTHOPEDIC_DENTISTRY", "X_RAY_RADIOLOGY", "SANOLOGY", "STOMATOLOGY", "GENERAL_MEDICINE", "MEDICAL_CASE_EMERGENCY_MEDICINE", "PUBLIC_HEALTH_AND_PREVENTIVE_MEDICINE", "CLINICAL_LABORATORY", "HYGIENE_LABORATORY", "PATHOLOGY_LABORATORY", "OBSTETRICS", "NURSING", "OPERATING_NURSING", "MEDICAL_STATISTICS", "PHYSICAL_THERAPEUTICS", "ERGOTHERAPEUTICS"

"PHARMASIST": "PHARMACEUTICS_ORGANIZATION", "PROVISOR", "ANALYTICAL_AND_CONTROL_PHARMACY", "CLINICAL_PROVISOR", "PHARMACIST"

EMPLOYEE_TYPE vs EDUCATION_DEGREE 

"DOCTORP257"

”MED_COORDINATOR”: "P280"

“LABORANT“: “P17”, “P170”, “P173”, “P241”, “P242”, “P243”, “P244”, “P251”, “P256”, “P271”, “P272”, “P273”, “P274”, “P276”, “P277”, “P278”, “P279”

EMPLOYEE_TYPE vs SPECIALITY_TYPE

"DOCTOR": "FAMILY_DOCTOR", "PEDIATRICIAN", "THERAPIST"

"SPECIALIST", ”MED_COORDINATOR” : "PHYSICAL_THERAPEUTICS", "ERGOTHERAPEUTICS", "IMMUNOLOGY", "INFECTIOUS_DISEASES", "CARDIOLOGY", "CLINICAL_BIOCHEMISTRY", "CLINICAL_IMMUNOLOGY", "CLINICAL_DIAGNOSTIC", "COMBUSTIOLOGY", "COMMUNAL_HYGIENE", "LABORATORY_IMMUNOLOGY", "LABORATORY_RESEARCH_OF_ENVIRONMENTAL_FACTORS", "LABORATORY_RESEARCH_OF_ENVIRONMENT_PHYSICAL_FACTORS", "LABORATORY_RESEARCH_OF_ENVIRONMENT_CHEMICAL_FACTORS", "PHYSICAL_THERAPY", "PHYSICAL_THERAPY_AND_SPORTS_MEDICINE", "EMERGENCY_MEDICINE", "MEDICAL_PSYCHOLOGY", "MICROBIOLOGY", "NARCOLOGY", "TRADITIONAL_ALTERNATIVE_MEDICINE", "NEUROLOGY", "NEUROSURGERY", "NEONATOLOGY", "NEPHROLOGY", "GYNECOLOGIC_ONCOLOGY", "ONCOLOGY", "ONCOTOLARYNGOLOGY", "SURGICAL_ONCOLOGY", "PUBLIC_HEALTH_ORGANIZATION", "ORTHODONTOLOGY", "ORTHOPEDIC_DENTISTRY", "ORTHOPAEDICS", "OTORHINOLARYNGOLOGY", "OPHTHALMOLOGY", "PARASITOLOGY", "PATHOLOGIC_ANATOMY", "PEDIATRICIAN", "ADOLESCENT_MEDICINE", "PROCTOLOGY", "RADIATION_THERAPY", "OCCUPATIONAL_PATHOLOGY", "PSYCHIATRY", "PSYCHOTHERAPY", "PSYCHOPHYSIOLOGY", "PULMONOLOGY", "RADIATION_HYGIENE", "RADIOLOGY", "RADIOLOGIC_DIAGNOSIS", "RHEUMATOLOGY", "X_RAY_RADIOLOGY", "REFLEXOLOGY", "SANOLOGY", "SEXOPATHOLOGY", "SPORTS_MEDICINE", "STOMATOLOGY", "VASCULAR_SURGERY", "FORENSIC_MEDICINE", "FORENSIC_MEDICAL_HISTOLOGY", "FORENSIC_MEDICAL_EXAMINATION", "FORENSIC_IMMUNOLOGY", "FORENSIC_CRIMINOLOGY", "FORENSIC_MEDICAL_TOXICOLOGY", "FORENSIC_CYTOLOGY", "FORENSIC_PSYCHIATRIC_EXAMINATION", "AUDIOLOGY", "THERAPEUTIC_DENTISTRY", "THERAPIST", "TOXICOLOGY", "THORACIC_SURGERY", "TRANSPLANTOLOGY", "TRANSFUSIOLOGY", "ULTRASONIC_DIAGNOSIS", "UROLOGY", "PHYSIOTHERAPY", "PHYSICAL_MEDICINE_AND_REHABILITATION", "PHTHISIOLOGY", "FUNCTIONAL_DIAGNOSTICS", "SURGICAL_DENTISTRY", "GENERAL_SURGERY", "CARDIOVASCULAR_SURGERY", "AEROSPACE_MEDICINE", "OBSTETRICS_AND_GYNECOLOGY", "ALLERGOLOGY", "ANAESTHETICS", "BACTERIOLOGY", "VIROLOGY", "GASTROENTEROLOGY", "GENERAL_HEMATOLOGY", "LABORATORY_GENETICS", "MEDICAL_GENETICS", "GERIATRICS", "PEDIATRIC_HYGIENE", "OCCUPATIONAL_MEDICINE", "FOOD_HYGIENE", "DISINFECTION_", "DERMATO-VENEREOLOGY", "PEDIATRIC_ALLERGY", "PEDIATRIC_ANAESTHETICS", "PEDIATRIC_GASTROENTEROLOGY", "PEDIATRIC_HEMATOLOGY", "PEDIATRIC_GYNECOLOGY", "PEDIATRIC_DERMATO-VENEREOLOGY", "PEDIATRIC_ENDOCRINOLOGY", "PEDIATRIC_IMMUNOLOGY", "PEDIATRIC_CARDIOLOGY", "PEDIATRIC_NEUROLOGY", "PEDIATRIC_NEPHROLOGY", "PEDIATRIC_ONCOLOGY", "PEDIATRIC_ORTHOPAEDICS", "PEDIATRIC_OTOLARYNGOLOGY", "PEDIATRIC_OPHTHALMOLOGY", "PEDIATRIC_PATHOLOGY", "PEDIATRIC_PSYCHIATRY", "PEDIATRIC_PULMONOLOGY", "PEDIATRIC_STOMATOLOGY", "PEDIATRIC_UROLOGY", "PEDIATRIC_PHTHISIOLOGY", "PEDIATRIC_SURGERY", "PEDIATRIC_INFECTIOUS_DISEASE", "DIETETICS", "ENDOCRINOLOGY", "ENDOSCOPY", "EPIDEMIOLOGY", "COMMON_HYGIENE", "PEDIATRIC_HEMATOLOGY_AND_ONCOLOGY", "INVASIVE_ELECTROPHYSIOLOGY", "INTERVENTIONAL_CARDIOLOGY", "PEDIATRIC_NEUROLOGICAL_SURGERY", "PERIODONTOLOGY", "PLASTIC_SURGERY", "ORAL_AND_MAXILLOFACIAL_SURGERY", “CHILD_CARDIOLOGY“, “PEDIATRIC_RHEUMATOLOGY“, “SURGICAL_DERMATOLOGY”

"ASSISTANT": "ORTHOPEDIC_DENTISTRY", "X_RAY_RADIOLOGY", "SANOLOGY", "STOMATOLOGY", "GENERAL_MEDICINE", "MEDICAL_CASE_EMERGENCY_MEDICINE", "PUBLIC_HEALTH_AND_PREVENTIVE_MEDICINE", "CLINICAL_LABORATORY", "HYGIENE_LABORATORY", "PATHOLOGY_LABORATORY", "OBSTETRICS", "NURSING", "OPERATING_NURSING", "MEDICAL_STATISTICS", "PHYSICAL_THERAPEUTICS", "ERGOTHERAPEUTICS"

"PHARMASIST": "PHARMACEUTICS_ORGANIZATION", "PROVISOR", "ANALYTICAL_AND_CONTROL_PHARMACY", "CLINICAL_PROVISOR", "PHARMACIST"

“LABORANT“: “VIROLOGY”, “MICROBIOLOGY”, “LABORATORY_GENETICS”, “LABORATORY_IMMUNOLOGY”, “CLINICAL_DIAGNOSTIC”, “PARASITOLOGY”, “BACTERIOLOGY”, “CLINICAL_BIOCHEMISTRY”, “CLINICAL_LABORATORY”, “HYGIENE_LABORATORY”, “PATHOLOGY_LABORATORY”, “GENERAL_MEDICINE”, “PUBLIC_HEALTH_AND_PREVENTIVE_MEDICINE”

EMPLOYEE_TYPE vs EDUCATION_DEGREE 

"DOCTOR": "EXPERT", "MASTER", "BACHELOR", "JUNIOR_EXPERT"

"SPECIALIST":"EXPERT", "MASTER", "BACHELOR", "JUNIOR_EXPERT"

"SPECIALISTASSISTANT":  "EXPERT", "MASTER", "BACHELOR", "JUNIOR_EXPERT"

"ASSISTANTPHARMASIST":  "EXPERT", "MASTER", "BACHELOR", "JUNIOR_EXPERT""PHARMASIST": 

”MED_COORDINATOR”: "EXPERT", "MASTER", "BACHELOR", "JUNIOR_EXPERT"

“LABORANT“: ”MASTER”, “EXPERT”, “BACHELOR”, “JUNIOR_EXPERT”

EMPLOYEE_TYPE vs QUALIFICATION_TYPE 

"DOCTOR": "CLINICAL_RESIDENCY", "INTERNSHIP", "REATTESTATION", "SPECIALIZATION", "STAZHUVANNYA", "POSTGRADUATE", "TOPIC_IMPROVEMENT" 

"SPECIALIST": "CLINICAL_RESIDENCY", "INTERNSHIP", "REATTESTATION", "SPECIALIZATION", "STAZHUVANNYA", "POSTGRADUATE", "TOPIC_IMPROVEMENT" 

"ASSISTANT":    "CLINICAL_RESIDENCY", "INTERNSHIP", "REATTESTATION", "SPECIALIZATION", "STAZHUVANNYA", "POSTGRADUATE", "TOPIC_IMPROVEMENT" 

"PHARMASIST": "REATTESTATION", "SPECIALIZATION", "STAZHUVANNYA", "POSTGRADUATE"REATTESTATION", "SPECIALIZATION", "STAZHUVANNYA", "POSTGRADUATE"

”MED_COORDINATOR”: "INFORMATION_COURSES", "STAZHUVANNYA"

“LABORANT“: ”REATTESTATION”, “SPECIALIZATION”, “CLINICAL_RESIDENCY”, “INTERNSHIP”, “STAZHUVANNYA”, “POSTGRADUATE”, “TOPIC_IMPROVEMENT”

EMPLOYEE_TYPE vs SPECIALITYvs SPECIALITY_LEVEL 

"DOCTOR": "BASIC", "SECOND", "FIRST", "HIGHEST", "NOT_APPLICABLE"

"SPECIALIST": SECOND", "FIRST", "HIGHEST", "NOT_APPLICABLE"

"ASSISTANT":  SECOND", "FIRST", "HIGHEST", "NOT_APPLICABLE"

"PHARMASIST": SECOND", "FIRST", "HIGHEST", "NOT_APPLICABLE"“FIRST“, “SECOND“, “HIGHEST“, “BASIC“, “NOT_APPLICABLE“

"SPECIALIST": “FIRST“, “SECOND“, “HIGHEST“, “BASIC“, “NOT_APPLICABLE“

"ASSISTANT":  “FIRST“, “SECOND“, “HIGHEST“, “BASIC“, “NOT_APPLICABLE“

"PHARMASIST": “FIRST“, “SECOND“, “HIGHEST“, “NOT_APPLICABLE“

"MED_COORDINATOR": “FIRST”, "SECOND”, “HIGHEST”, “NOT_APPLICABLE"

“LABORANT”: “FIRST”, “SECOND”, “SPECIALIST”, “HIGHEST”, “NOT_APPLICABLE”,

ARCHIVED DRAFTS (NOT SUPPORTED!!!):

View file
nameDovidnyk_Posad (1).xlsx

...

View file
nameDovidnyk_Med_Specialities (1).xlsx

...

View file
nameMapping_for_Small_Dictionaries.xlsx

...