Task&Document Workflow Builder Database details
Task&Document workflow was placed in project wise and each project has following collections to store the form related documents.
The project wise means, each project has its database and each database has its set of default collections which contains following task&document related collections.
queue
queuestates
queuestatesaction
queuescenarios
queuescenariostatemapping
queuemessagecatalogue
QDMATPtransactionlog
Taskviewer_config
Task&Document Workflow Sender and Consumer Details
The source or UI of Task&Document was client projects ie) ipmo, survillance, clmm etc.
The Task&Document Workflow consumes Arango Adapter API, Arango Adapter was a java spring boot application which consists set of APIs.
Using Arango Adapter API, we can perform CRUD operation in Arango sDB server.
Collections with details
| Collection Name | Usage |
| queue | This collection used to store the queue details |
| queuestates | This collection used to store the queuestaes details mapping with queue details |
| queuestatesaction | This collection used to stores the action details mapping with queue and state details. |
| queuescenarios | This collection used to stores the scenario details mapping with queue details |
| queuescenariostatemapping | This collection used to stores the scenario details mapping with queue,state and Rules details |
| queuemessagecatalogue | This collection used to stores the message configuration details |
| QDMATPtransactionlog | This collection used to stores the queue log |
| Taskviewer_config | This collection used to store viewer configuration details. |
Collection attributes with details
Collection Name: queue
| Attributes | Usage |
| queueid | This attribute used to store the queueid. |
| queuename | This attributes holds the queuename |
| msgqueuegroup | This attribute stores the message queue group name |
| queuedescription | This attribute stores the queue description |
| kafkatopicname | This attribute stores the create an nifi kafkatopic |
| entrycriteria | This attribute store the rules (_id in rules collection) |
| inputschema | This attribute store the input name and schema details. |
| queuestatus | This attribute stores the value(true/false) queue is active or not |
| active | This attribute store the value(true/false) active or not |
| projectid | This attribute stores the projectid |
| clientid | This attribute stores the clientid |
| metedataid | This attribute stores the metadataid |
| idmid | This attribute stores the metadataid of IDM |
| groupdetails | This attribute stores the value of message group details |
| activestatus | This attribute stores the value(true/false) active or not |
Collection Name: queuestates
| Attributes | Usage |
| queueid | This attribute used to store the queue collection _id |
| statesid | This attributes holds the state collection _id |
| states | This attribute stores the states name |
| active | This attribute stores the value(true/false) active or not |
| bgcolor | This attribute stores the queuestate background color |
| textcolor | This attribute stores the queuestate text color |
| icon | This attribute stores the queuestate text color |
| activestatus | This attribute stores the value(true/false) active or not |
Collection Name: queuestatesaction
| Attributes | Usage |
| queueid | This attribute used to store the queue collection _id |
| statesid | This attributes holds the state collection _id |
| actionid | This attribute stores the actionid |
| action | This attribute stores the actionname |
| choosetype | This attribute stores the servicetype(api,nifi,servicecall) |
| chooseform | This attribute stores the iform id or form name |
| apiendpoint | This attribute stores the apiendpoint url |
| active | This attribute stores the value(true/false) active or not |
| bgcolor | This attribute stores the queuestateaction background color |
| icon | This attribute stores the queuestateaction icon |
| textcolor | This attribute stores the queuestateaction text color |
| activestatus | This attribute stores the value(true/false) active or not |
Collection Name: queuescenarios
| Attributes | Usage |
| queueid | This attribute used to store the queue collection _id |
| scenarioid | This attributes holds the scenarioid |
| scenarioname | This attribute stores the scenario name |
| scenariodescription | This attribute stores the scenatiodescription |
| bgcolor | This attribute stores the queuescenarios background color |
| textcolor | This attribute stores the queuescenarios text color |
| icon | This attribute stores the queuescenarios icon |
| scenariocriteria | This attribute stores the rules in Rules collection(_id) |
| status | This attribute stores the value(true/false) active or not |
| active | This attribute stores the value(true/false) active or not |
| activestatus | This attribute stores the value(true/false) active or not |
Collection Name: queuescenariostatemapping
| Attributes | Usage |
| queueid | This attribute used to store the queue collection _id |
| scenarioid | This attribute used to store the queuescenarios collection _id |
| workflow | This attribute stores the Rule collection _id |
| active | This attribute stores the value(true/false) active or not |
| states | This attribute stores the elements of queuestate details. |
| workflowdiagram | This attribute stores the workflow diagram properties. |
| activestatus | This attribute stores the value(true/false) active or not |
Collection Name: queuemessagecatalogue
| Attributes | Usage |
| messageid | This attribute used to store the messageid for messageconfiguartion |
| title | This attributes stores the title of queuemessage |
| status | This attribute stores the statue value of queuemessage |
| remarks | This attribute stores the remarks for message configuration |
| active | This attribute stores the value(true/false) active or not |
| activestatus | This attribute stores the value(true/false) active or not |
Collection Name: QDMATPtransactionlog
| Attributes | Usage |
| messageId | This attribute used to store the error through the messageid |
| ticketId | This attributes holds the transactionid |
| payload | This attribute stores the input payload |
| queueId | This attribute stores the queue collection in _id |
| id | This attribute stores the QDMATPtransactionlog collection in _id |
| statesEnd | This attribute stores end of the transaction states id |
| favourite | This attribute stores the boolean value (true/false) |
| activestatus | This attribute stores the value(true/false) active or not |
Collection Name: Taskviewer_config
| Attributes | Usage |
| queueid | This attribute used to store the queue collection in _id. |
| field1 | This attributes holds the patient first name |
| field2 | This attribute stores the orderdate |
| field3 | This attribute stores the patientMRN number |
| field4 | This attribute stores the orderotherdetails |
| field5 | This attribute stores the mealdisplay name |
| field6 | This attribute stores the Addon |
| field7 | This attribute stores the mealdescription |
| field8 | This attribute stores the bednumber |
| field9 | This attribute stores the ordertimecode |
| field10 | This attribute stores the allergies |
| field11 | This attribute stores the foodpreferences |
| field12 | This attribute stores the patientcategory |
| field13 | This attribute stores the patientcategorysubtype |
| activestatus | This attribute stores the value(true/false) active or not |
Production Collection
queue
queuestates
queuestatesaction
queuescenarios
queuescenariostatemapping
queuemessagecatalogue
QDMATPtransactionlog
Taskviewer_config