The update_concept_totalnum message is used to populate the patient's total count information (totalnum) in the metadata table. This service is used to synchronize the TOTALNUM value in the metadata table, if there is updates to just the datamart tables. Syncing the TOTALNUM column helps in the query performance and also it is displayed in the Ontology's navigation view.

Update the TOTALNUM in the Metadata Table

To update the patient total count, the sequence of events is as follows:

  1. The client specifies a request to start the update patient count process.
  2. The ontology server returns the status of the patient count process



update_concept_totalnum Request Message

This message accepts the operation type parameter.
Example:
<update_concept_totalnum operation_type = "restart_only | synchronize_all">
</update_concept_totalnum>

operation_type

Description

synchronize_all

This option is used to refresh the concepts TOTAL_NUM information. This will clear the TOTAL_NUM column of the metadata table by setting NULL value before updating it.

Restart_only

This option will update the concepts TOTAL_NUM information, whose TOTAL_NUM value is NULL.



update_concept_totalnum Response Message

A status type of DONE or ERROR is specified in the response header. The <message_body> provides the information about the state of the process.
Example:
<message_body>
<ontology_process_status>
<process_id>1</process_id>
<process_type_cd>ONT_PATIENT_COUNT_UPDATE</process_type_cd>
<process_step_cd>PROCESSED 10/95900</process_step_cd>
<process_status_cd>PROCESSING</process_status_cd>
<start_date>2010-04-05T00:00:00.000-04:00</start_date>
<end_date>2010-04-05T00:00:00.000-04:00</end_date>
</ontology_process_status>
</message_body>

The process_status_cd provides information about the status of the step identified at the process_step_cd.

process_status_cd

Description

ERROR

Indicates that an error occurred

PROCESSING

Indicates that the process is in progress

COMPLETED

Indicates that the process has competed

ABORT

Indicates that the process should set itself to KILLED status because the user started another instance of this process.

KILLED

Indicates that the process was killed because the user started another instance of this process.