Versions Compared

Key

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

View contains aggregate declarations by area, msp, division and doctor per day 

ParametersDescriptionAggregate logic
datecalculation date

all calendar dates

area_idarea, where legal_entity is located in which the declaration was made
msp_idlegal_entity in which the declaration was made
division_iddivision in which the declaration was made
doctor_iddoctor which signed declaration
declaration_totalcount all declarations on current date
declarations_createdcount active declarations per day
declarations_closedcount closed declarations per day

View contains aggregate doctors by area, msp and division per day.

ParametersDescriptionAggregate logic
datecalculation date

all calendar dates

area_idarea, where legal_entity is located in which the declaration was made
msp_idlegal_entity in which the declaration was made
division_iddivision in which the declaration was made
doctors_totalcount all doctors on current date
doctors_createdcount all declarations per day

View contains aggregate devisions by area and msp per day.

ParametersDescriptionAggregate logic
datecalculation date

all calendar dates

area_idarea, where legal_entity is located in which the declaration was made
msp_createdlegal_entity in which the declaration was made
doctors_createdcount all doctors on current date