Versions Compared

Key

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

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",

...

"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":

...

"P1",

...

"P2",

...

"P3",

...

"P4",

...

"P5",

...

"P6",

...

"P18",

...

"P19",

...

"P22",

...

"P23",

...

"P24",

...

"P25",

...

"P26",

...

"P32",

...

"P229",

...

"P230",

...

"P231",

...

"P232",

...

"P233",

...

"P234",

...

"P235",

...

"P236",

...

"P249",

...

"P257",

"PHARMACIST":

...

"P16",

...

"P20",

...

"P21",

...

"P217",

...

"P218",

...

"P219",

...

"P220",

...

"P221",

...

"P222",

...

"P223",

"PHARMACY_OWNER":,

"RECEPTIONIST":

...

"P15",

"SPECIALIST":

...

"P5",

...

"P6",

...

"P8",

...

"P9",

...

"P10",

...

"P11",

...

"P12",

...

"P13",

...

"P33",

...

"P34",

...

"P35",

...

"P36",

...

"P37",

...

"P38",

...

"P39",

...

"P40",

...

"P41",

...

"P42",

...

"P43",

...

"P44",

...

"P45",

...

"P46",

...

"P47",

...

"P48",

...

"P49",

...

"P50",

...

"P51",

...

"P52",

...

"P53",

...

"P54",

...

"P55",

...

"P56",

...

"P57",

...

"P58",

...

"P59",

...

"P60",

...

"P61",

...

"P62",

...

"P63",

...

"P64",

...

"P65",

...

"P66",

...

"P67",

...

"P68",

...

"P69",

...

"P70",

...

"P71",

...

"P72",

...

"P73",

...

"P74",

...

"P75",

...

"P76",

...

"P77",

...

"P78",

...

"P79",

...

"P80",

...

"P81",

...

"P82",

...

"P83",

...

"P84",

...

"P85",

...

"P86",

...

"P87",

...

"P88",

...

"P89",

...

"P90",

...

"P91",

...

"P92",

...

"P93",

...

"P94",

...

"P95",

...

"P96",

...

"P97",

...

"P98",

...

"P99",

...

"P100",

...

"P101",

...

"P102",

...

"P103",

...

"P104",

...

"P105",

...

"P106",

...

"P107",

...

"P108",

...

"P109",

...

"P110",

...

"P111",

...

"P112",

...

"P113",

...

"P114",

...

"P115",

...

"P116",

...

"P117",

...

"P118",

...

"P119",

...

"P120",

...

"P121",

...

"P122",

...

"P123",

...

"P124",

...

"P125",

...

"P126",

...

"P127",

...

"P128",

...

"P129",

...

"P130",

...

"P131",

...

"P132",

...

"P133",

...

"P134",

...

"P135",

...

"P136",

...

"P137",

...

"P138",

...

"P139",

...

"P140",

...

"P141",

...

"P142",

...

"P143",

...

"P144",

...

"P145",

...

"P146",

...

"P147",

...

"P148",

...

"P149",

...

"P150",

...

"P151",

...

"P152",

...

"P153",

...

"P154",

...

"P155",

...

"P156",

...

"P157",

...

"P158",

...

"P159",

...

"P160",

...

"P161",

...

"P162",

...

"P163",

...

"P164",

...

"P165",

...

"P166",

...

"P167",

...

"P228",

...

"P248",

...

"P258"

"NHS

...

ADMIN","NHS

...

ADMIN

...

MONITORING","NHS

...

ADMIN

...

PROGRAM

...

MEDICATION","NHS

...

ADMIN

...

REIMBURSEMENT","NHS

...

ADMIN

...

SIGNER","NHS

...

ADMIN

...

VERIFIER","NHS

...

FORBIDDEN

...

ADMIN","NHS

...

LE

...

TERMINATOR","NHS

...

LE

...

VERIFIER","NHS

...

REVIEWER":

...

"P27",

...

"P28",

...

"P29",

...

"P30",

...

"P31",

...

"P237",

...

"P238",

...

"P239"


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 

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

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

"ASSISTANT":  "EXPERT", "MASTER", "BACHELOR", "JUNIOR_EXPERT"

"PHARMASIST": "EXPERT", "MASTER", "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"


EMPLOYEE_TYPE vs 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"




ARCHIVED DRAFTS (NOT SUPPORTED!!!):


View file
nameDovidnyk_Posad (1).xlsx
height250
View file
nameDovidnyk_Med_Specialities (1).xlsx
height250
View file
nameMapping_for_Small_Dictionaries.xlsx
height250

...