Master Data Management Service (MDMS) & Configuration Updates
For MDMS-V2 changes, refer to the file below for MDMS schema and data that needs to be added for health - HCM-ADMIN-CONSOLE service:
1) Add below schemas:
1.1) Add HCM-ADMIN-CONSOLE.rolesForChecklist schema
{
"$schema": "http://json-schema.org/draft-07/schema#",
"title": "Generated schema for Root",
"type": "object",
"properties": {
"key": {
"type": "number"
},
"code": {
"type": "string"
}
},
"x-unique": [
"code"
],
"required": [
"key",
"code"
]
}
1.2) Add HCM-ADMIN-CONSOLE.ChecklistTemplates schema
{
"type": "object",
"title": "Generated schema for Root",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"campaignType",
"role",
"checklistType",
"data"
],
"x-unique": [
"campaignType",
"role",
"checklistType"
],
"properties": {
"data": {
"type": "array",
"items": {
"type": "object",
"required": [
"id",
"level",
"key",
"title",
"type",
"value",
"isRequired",
"options"
],
"properties": {
"id": {
"type": "string"
},
"key": {
"type": "number"
},
"type": {
"type": "object",
"required": [
"code"
],
"properties": {
"code": {
"type": "string"
}
}
},
"level": {
"type": "number"
},
"title": {
"type": "string"
},
"value": {},
"options": {
"type": "array",
"items": {
"type": "object",
"required": [
"id",
"key",
"parentQuestionId",
"label",
"optionDependency"
],
"properties": {
"id": {
"type": "string"
},
"key": {
"type": "number"
},
"label": {
"type": "string"
},
"comment": {
"type": "string"
},
"optionComment": {
"type": "boolean"
},
"optionDependency": {
"type": "boolean"
},
"parentQuestionId": {
"type": "string"
}
}
}
},
"parentId": {},
"isRequired": {
"type": "boolean"
}
}
}
},
"role": {
"type": "string"
},
"campaignType": {
"type": "string"
},
"checklistType": {
"type": "string"
}
}
}
1.3) Add of HCM-ADMIN-CONSOLE.microplanIntegration Schema
{
"id": "5dfabf03-941d-47a9-b05d-32b7fb199237",
"tenantId": "mz",
"code": "HCM-ADMIN-CONSOLE.microplanIntegration",
"description": "HCM-ADMIN-CONSOLE.microplanIntegration",
"definition": {
"type": "object",
"title": "HCM-ADMIN-CONSOLE.microplanIntegration",
"$schema": "http://json-schema.org/draft-07/schema#",
"isActive": true,
"required": [
"type",
"mappings"
],
"x-unique": [
"type"
],
"properties": {
"type": {
"type": "string"
},
"mappings": {
"type": "array",
"items": {
"type": "object",
"properties": {
"to": {
"type": "string"
},
"from": {
"type": "array",
"items": {
"type": "string"
}
},
"filter": {
"enum": [
"includes",
"equal"
],
"type": "string",
"default": "includes"
}
}
},
"minItems": 1
}
},
"auditDetails": {
"createdBy": null,
"createdTime": 1697098069220,
"lastModifiedBy": null,
"lastModifiedTime": 1697098069220
}
},
"isActive": true,
"auditDetails": {
"createdBy": null,
"lastModifiedBy": null,
"createdTime": 1732775436673,
"lastModifiedTime": 1732775436673
}
}
1.4) Update Schema of HCM-ADMIN-CONSOLE.appFieldTypes
{
"type": "object",
"title": "Generated schema for Root",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"type",
"code"
],
"x-unique": [
"code"
],
"properties": {
"code": {
"type": "string"
},
"type": {
"type": "array",
"items": {
"type": "string"
}
}
}
}
1.4) Update Schema of HCM-ADMIN-CONSOLE.HierarchySchema
{
"id": "ca0275c0-1c26-4403-b1c7-d7080accdf2b",
"tenantId": "mz",
"code": "HCM-ADMIN-CONSOLE.HierarchySchema",
"description": "hierarchy config for hcm admin console",
"definition": {
"type": "object",
"title": "Hierarchy Configuration Schema",
"$schema": "http://json-schema.org/draft-09/schema#",
"required": [
"hierarchy",
"type"
],
"x-unique": [
"type"
],
"properties": {
"type": {
"enum": [
"default",
"microplan",
"campaign",
"console",
"others"
],
"type": "string",
"description": "Specifies the type of hierarchy configuration."
},
"group": {
"type": "array",
"items": {
"type": "string"
},
"description": "An array of disease groups from the project type master."
},
"hierarchy": {
"type": "string",
"unique": true,
"pattern": "^[A-Za-z0-9]+$",
"description": "The type of hierarchy, must be a unique string."
},
"department": {
"type": "array",
"items": {
"type": "string"
},
"description": "An array of departments from the department master."
},
"lowestHierarchy": {
"type": "string",
"pattern": "^[A-Za-z0-9]+$",
"description": "The lowest administrative level in the hierarchy."
},
"highestHierarchy": {
"type": "string",
"pattern": "^[A-Za-z0-9]+$",
"description": "The highest administrative level in the hierarchy."
},
"splitBoundariesOn": {
"type": "string",
"pattern": "^[A-Za-z0-9]+$",
"description": "The level on which boundaries are split."
},
"consolidateUsersAt": {
"type": "string",
"pattern": "^[A-Za-z0-9]+$"
}
}
},
"isActive": true,
"auditDetails": {
"createdBy": "bfab6822-ec28-40f0-aef1-efd1cda8fcd5",
"lastModifiedBy": "bfab6822-ec28-40f0-aef1-efd1cda8fcd5",
"createdTime": 1733147673649,
"lastModifiedTime": 1733147673649
}
}
2) Add below data for the schemas:
2.1) Add data for HCM-PROJECT-TYPES.projectTypes data
{
"id": "dbd45c31-de9e-4e62-a9b6-abb818928fd1",
"code": "LLIN-mz",
"name": "mz project type configuration for LLIN Campaigns",
"group": "MALARIA",
"cycles": [
{
"id": 1,
"endDate": 1715279400000,
"startDate": 1714329000000,
"deliveries": [
{
"id": 1,
"doseCriteria": [
{
"condition": "CAMPAIGN_BEDNET_INDIVIDUAL_LABEL>=1andCAMPAIGN_BEDNET_HOUSEHOLD_LABEL<=5",
"ProductVariants": [
{
"name": "Bednet - Grade - 1",
"productVariantId": "PVAR-2024-11-18-000217",
"quantity": 1
}
]
}
],
"deliveryStrategy": "DIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
}
],
"mandatoryWaitSinceLastCycleInDays": null
}
],
"resources": [
{
"name": "Bednet - Grade - 1",
"productVariantId": "PVAR-2024-11-18-000217",
"isBaseUnitVariant": false
}
],
"dashboardUrls": {
"DISTRICT_SUPERVISOR": "/digit-ui/employee/dss/dashboard/district-health-dashboard",
"NATIONAL_SUPERVISOR": "/digit-ui/employee/dss/landing/national-health-dashboard",
"PROVINCIAL_SUPERVISOR": "/digit-ui/employee/dss/dashboard/provincial-health-dashboard"
},
"taskProcedure": [
"1 bednet is to be distributed per 2 household members.",
"If there are 4 household members, 2 bednets should be distributed.",
"If there are 5 household members, 3 bednets should be distributed."
],
"IsCycleDisable": true,
"attrAddDisable": true,
"beneficiaryType": "HOUSEHOLD",
"productCountHide": true,
"deliveryAddDisable": true,
"eligibilityCriteria": [
"All households are eligible.",
"Prison inmates are eligible."
]
}
```
{
"id": "ea1bb2e7-06d8-4fe4-ba1e-f4a6363a21be",
"code": "MR-DN",
"name": "Configuration for Multi Round Campaigns",
"group": "MALARIA",
"cycles": [
{
"id": 1,
"endDate": 1715279400000,
"startDate": 1714329000000,
"deliveries": [
{
"id": 1,
"doseCriteria": [
{
"condition": "3<=age<11",
"ProductVariants": [
{
"name": "SP 500mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000213"
},
{
"name": "AQ 150mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000215"
}
]
},
{
"condition": "12<=age<64",
"ProductVariants": [
{
"name": "SP 500mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000213"
},
{
"name": "AQ 150mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000215"
}
]
}
],
"deliveryStrategy": "DIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
},
{
"id": 2,
"doseCriteria": [
{
"condition": "3<=age<11",
"ProductVariants": [
{
"name": "SP 500mg",
"quantity": 1,
"productVariantId": "500 PVAR-2024-11-18-000213"
}
]
},
{
"condition": "12<=age<64",
"ProductVariants": [
{
"name": "SP 250mg",
"quantity": 1,
"productVariantId": "250 PVAR-2024-11-18-000214"
}
]
}
],
"deliveryStrategy": "INDIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
},
{
"id": 3,
"doseCriteria": [
{
"condition": "3<=age<11",
"ProductVariants": [
{
"name": "AQ 150mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000215"
}
]
},
{
"condition": "12<=age<64",
"ProductVariants": [
{
"name": "AQ 75mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000216"
}
]
}
],
"deliveryStrategy": "INDIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
}
],
"mandatoryWaitSinceLastCycleInDays": null
},
{
"id": 2,
"endDate": 1718908200000,
"startDate": 1716143400000,
"deliveries": [
{
"id": 1,
"doseCriteria": [
{
"condition": "3<=age<11",
"ProductVariants": [
{
"name": "SP 500mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000213"
},
{
"name": "AQ 150mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000215"
}
]
},
{
"condition": "12<=age<64",
"ProductVariants": [
{
"name": "SP 500mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000213"
},
{
"name": "AQ 150mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000215"
}
]
}
],
"deliveryStrategy": "DIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
},
{
"id": 2,
"doseCriteria": [
{
"condition": "3<=age<11",
"ProductVariants": [
{
"name": "SP 500mg",
"quantity": 1,
"productVariantId": "500 PVAR-2024-11-18-000213"
}
]
},
{
"condition": "12<=age<64",
"ProductVariants": [
{
"name": "SP 250mg",
"quantity": 1,
"productVariantId": "250 PVAR-2024-11-18-000214"
}
]
}
],
"deliveryStrategy": "INDIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
},
{
"id": 3,
"doseCriteria": [
{
"condition": "3<=age<11",
"ProductVariants": [
{
"name": "AQ 150mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000215"
}
]
},
{
"condition": "12<=age<64",
"ProductVariants": [
{
"name": "AQ 75mg",
"quantity": 1,
"productVariantId": "PVAR-2024-11-18-000216"
}
]
}
],
"deliveryStrategy": "INDIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
}
],
"mandatoryWaitSinceLastCycleInDays": "30"
}
],
"resources": [
{
"name": "SP 500mg",
"productVariantId": "PVAR-2024-11-18-000213",
"isBaseUnitVariant": false
},
{
"name": "SP 250mg",
"productVariantId": "PVAR-2024-11-18-000214",
"isBaseUnitVariant": true
},
{
"name": "AQ 250mg",
"productVariantId": "PVAR-2024-11-18-000215",
"isBaseUnitVariant": false
},
{
"name": "AQ 75mg",
"productVariantId": "PVAR-2024-11-18-000216",
"isBaseUnitVariant": true
}
],
"validMaxAge": 64,
"validMinAge": 3,
"dashboardUrls": {
"DISTRICT_SUPERVISOR": "/health-ui/employee/dss/dashboard/district-health-dashboard",
"NATIONAL_SUPERVISOR": "/health-ui/employee/dss/landing/national-health-dashboard",
"PROVINCIAL_SUPERVISOR": "/health-ui/employee/dss/dashboard/provincial-health-dashboard"
},
"taskProcedure": [
"1 bednet is to be distributed per 2 household members.",
"If there are 4 household members, 2 bednets should be distributed.",
"If there are 5 household members, 3 bednets should be distributed."
],
"beneficiaryType": "INDIVIDUAL",
"eligibilityCriteria": [
"All households having members under the age of 18 are eligible.",
"Prison inmates are eligible."
],
"observationStrategy": "DOT1"
}
{
"id": "192a20d1-0edd-4108-925a-f37bf544d6c4",
"code": "IRS-mz",
"name": "Project type configuration for IRS - Campaigns",
"group": "MALARIA",
"cycles": [
{
"id": 1,
"endDate": 1715279400000,
"startDate": 1714329000000,
"deliveries": [
{
"id": 1,
"doseCriteria": [
{
"condition": "TYPE_OF_STRUCTURE=CEMENT",
"ProductVariants": [
{
"name": "Sumishield - 1litre",
"productVariantId": "PVAR-2024-11-18-000207"
},
{
"name": "Fludora - 1litre",
"productVariantId": "PVAR-2024-11-18-000208"
},
{
"name": "Delt - 1litre",
"productVariantId": "PVAR-2024-11-18-000209"
},
{
"name": "Acetellic - 1litre",
"productVariantId": "PVAR-2024-11-18-000210"
},
{
"name": "DOT - 1litre",
"productVariantId": "PVAR-2024-11-18-000211"
},
{
"name": "Bendiocarb - 1litre",
"productVariantId": "PVAR-2024-11-18-000212"
}
]
}
],
"deliveryStrategy": "DIRECT",
"mandatoryWaitSinceLastDeliveryInDays": null
}
],
"mandatoryWaitSinceLastCycleInDays": null
}
],
"resources": [
{
"name": "Sumishield - 1litre",
"productVariantId": "PVAR-2024-11-18-000207",
"isBaseUnitVariant": true
},
{
"name": "Fludora - 1litre",
"productVariantId": "PVAR-2024-11-18-000208",
"isBaseUnitVariant": true
},
{
"name": "Delt - 1litre",
"productVariantId": "PVAR-2024-11-18-000209",
"isBaseUnitVariant": true
},
{
"name": "Acetellic - 1litre",
"productVariantId": "PVAR-2024-11-18-000210",
"isBaseUnitVariant": true
},
{
"name": "DOT - 1litre",
"productVariantId": "PVAR-2024-11-18-000211",
"isBaseUnitVariant": true
},
{
"name": "Bendiocarb - 1litre",
"productVariantId": "PVAR-2024-11-18-000212",
"isBaseUnitVariant": true
}
],
"dashboardUrls": {
"DISTRICT_SUPERVISOR": "/health-ui/employee/dss/dashboard/district-health-dashboard",
"NATIONAL_SUPERVISOR": "/health-ui/employee/dss/landing/national-health-dashboard",
"PROVINCIAL_SUPERVISOR": "/health-ui/employee/dss/dashboard/provincial-health-dashboard"
},
"taskProcedure": [
"1 DDT is to be distributed per house.",
"1 Malathion is to be distributed per house.",
"1 Pyrethroid is to be distributed per house."
],
"beneficiaryType": "HOUSEHOLD",
"eligibilityCriteria": [
"All households are eligible."
]
}
2.2) Add data for ACCESSCONTROL-ROLES.roles
{
"code": "BOUNDARY_MANAGER",
"name": "Boundary Manager",
"description": "Boundary Manager"
}
{
"code": "MICROPLAN_CAMPAIGN_INTEGRATOR",
"name": "Microplan Campaign integrator",
"description": "Microplan and Campaign integrated user"
}
2.3) Add data for HCM-ADMIN-CONSOLE.HierarchySchema
{
"type": "console",
"group": [
"MALARIA",
"PERFORMANCE",
"ADMINISTRATIVEPOST",
"DISTRICT"
],
"hierarchy": "MICROPLAN",
"department": [],
"lowestHierarchy": "VILLAGE",
"splitBoundariesOn": "DISTRICT",
"consolidateUsersAt": "LOCALITY"
}
{
"type": "microplan",
"group": [
"MALARIA"
],
"hierarchy": "MICROPLAN",
"department": [],
"lowestHierarchy": "VILLAGE",
"highestHierarchy": "COUNTRY",
"splitBoundariesOn": "DISTRICT"
},
{
"type": "others",
"hierarchy": "HIERARCHYTEST",
"lowestHierarchy": "ADMINISTRATIVEPOST",
"splitBoundariesOn": "DISTRICT"
},
{
"type": "default",
"group": [
"MALARIA"
],
"hierarchy": "TESTDEFHIER",
"department": [],
"lowestlevel": "ADMINISTRATIVEPOST",
"splitBasedOn": "DISTRICT",
"lowestHierarchy": "ADMINISTRATIVEPOST",
"splitBoundariesOn": "DISTRICT"
}
{
"type": "campaign",
"group": [
"MALARIA"
],
"hierarchy": "HierarchyTest02",
"department": [],
"lowestHierarchy": "ADMINISTRATIVEPOST",
"splitBoundariesOn": "DISTRICT"
}
2.4) Add data for HCM-ADMIN-CONSOLE.rolesForChecklist
{
"key": 1,
"code": "DISTRIBUTOR"
}
{
"key": 2,
"code": "WAREHOUSE_MANAGER"
}
{
"key": 3,
"code": "HEALTH_FACILITY_WORKER"
},
{
"key": 4,
"code": "DISTRICT_SUPERVISOR"
},
{
"key": 5,
"code": "NATIONAL_SUPERVISOR"
}
{
"key": 6,
"code": "PROVINCIAL_SUPERVISOR"
}
{
"key": 7,
"code": "TEAM_SUPERVISOR"
}
2.5) Add data for HCM-ADMIN-CONSOLE.ChecklistTemplates
{
"data": [
{
"id": "2d4a7b1e-1f2f-4a8a-9672-43396c6c9a1c",
"key": 1,
"type": {
"code": "SingleValueList"
},
"level": 1,
"title": "Is there a feedback system for health facilities to report any issues or requests related to bednet distribution?",
"value": null,
"options": [
{
"id": "0cff9846-03a2-4453-bf0e-200cdda5f390",
"key": 1,
"label": "Shortages",
"optionComment": true,
"optionDependency": false,
"parentQuestionId": "2d4a7b1e-1f2f-4a8a-9672-43396c6c9a1c"
},
{
"id": "2d4a7b1e-7c0d-48b1-9d53-8601c6264b90",
"key": 2,
"label": "Quality complaints",
"optionDependency": false,
"parentQuestionId": "2d4a7b1e-1f2f-4a8a-9672-43396c6c9a1c"
}
],
"isActive": true,
"parentId": null,
"isRequired": false
},
{
"id": "4add5323-fc98-4e71-a783-27dbb922c99f",
"key": 2,
"type": {
"code": "SingleValueList"
},
"level": 1,
"title": "What types of health facilities do you distribute to?",
"value": null,
"options": [
{
"id": "34eac43a-e0b5-428f-9d11-12fc5b10b1ac1",
"key": 1,
"label": "Hospitals",
"optionComment": false,
"optionDependency": false,
"parentQuestionId": "4add5323-fc98-4e71-a783-27dbb922c99f"
},
{
"id": "23ace43b-e0b5-428f-9d11-12fc5b10b1ac1",
"key": 2,
"label": "Clinics",
"optionComment": false,
"optionDependency": true,
"parentQuestionId": "4add5323-fc98-4e71-a783-27dbb922c99f"
},
{
"id": "32bbca43-db87-469b-8be4-22012cc22284",
"key": 3,
"label": "Community health centers",
"optionDependency": false,
"parentQuestionId": "4add5323-fc98-4e71-a783-27dbb922c99f"
}
],
"isActive": true,
"parentId": null,
"isRequired": false
},
{
"id": "23ca54be-038e-42df-a557-bb5fcd374dd5",
"key": 3,
"type": {
"code": "SingleValueList"
},
"level": 1,
"title": "What services or products do you distribute to health facilities?",
"value": null,
"options": [
{
"id": "ea32bc56-038e-42df-a557-bb5fcd374dd5",
"key": 1,
"label": "Medical equipment",
"optionComment": false,
"optionDependency": false,
"parentQuestionId": "23ca54be-038e-42df-a557-bb5fcd374dd5"
},
{
"id": "a34vc429-d13f-4340-ae5e-fe7f8aca4212",
"key": 2,
"label": "Pharmaceuticals",
"optionDependency": false,
"parentQuestionId": "23ca54be-038e-42df-a557-bb5fcd374dd5"
},
{
"id": "6c43b57c-d13f-4340-ae5e-fe7f8aca4212",
"key": 3,
"label": "Personal protective equipment (PPE)",
"optionDependency": false,
"parentQuestionId": "23ca54be-038e-42df-a557-bb5fcd374dd5"
}
],
"isActive": true,
"parentId": null,
"isRequired": false
},
{
"id": "c65ac34b-7cc0-4993-a8fe-37e854d2b189",
"key": 4,
"type": {
"code": "SingleValueList"
},
"level": 2,
"title": "Do you have enough products for distribution to health facilities?",
"value": null,
"options": [
{
"id": "cb45ca84-7cc0-4993-a8fe-37e854d2b189",
"key": 1,
"label": "Yes",
"optionDependency": false,
"parentQuestionId": "c65ac34b-7cc0-4993-a8fe-37e854d2b189"
},
{
"id": "a54c73cb-60da-4c51-8501-cf4a4f473a66",
"key": 2,
"label": "No",
"optionComment": true,
"optionDependency": false,
"parentQuestionId": "c65ac34b-7cc0-4993-a8fe-37e854d2b189"
}
],
"isActive": true,
"parentId": "23ace43b-e0b5-428f-9d11-12fc5b10b1ac1",
"isRequired": false
}
],
"role": "PROVINCIAL_SUPERVISOR",
"campaignType": "MR-DN",
"checklistType": "TEAM_FORMATION"
}
2.6) Add data for HCM-ADMIN-CONSOLE.appFieldTypes
{
"code": "SingleValueList",
"type": [
"checklist"
]
}
{
"code": "MultiValueList",
"type": [
"checklist"
]
}
2.7) Add data for HCM-ADMIN-CONSOLE.baseTimeOut
{
"baseTimeOut": 50,
"maxTime": 5000,
"timelineRefetch":3000
}
2.8) Add data for HCM-ADMIN-CONSOLE.HierarchySchema
{
"type": "microplan",
"group": [
"MALARIA"
],
"hierarchy": "MICROPLAN",
"department": [],
"lowestHierarchy": "VILLAGE",
"highestHierarchy": "COUNTRY",
"splitBoundariesOn": "DISTRICT"
}
{
"type": "console",
"group": [
"MALARIA",
"PERFORMANCE",
"ADMINISTRATIVEPOST",
"DISTRICT"
],
"hierarchy": "MICROPLAN",
"department": [],
"lowestHierarchy": "VILLAGE",
"splitBoundariesOn": "DISTRICT",
"consolidateUsersAt": "LOCALITY"
}
{
"type": "default",
"group": [
"MALARIA"
],
"hierarchy": "TESTDEFHIER",
"department": [],
"lowestlevel": "ADMINISTRATIVEPOST",
"splitBasedOn": "DISTRICT",
"lowestHierarchy": "ADMINISTRATIVEPOST",
"splitBoundariesOn": "DISTRICT"
}
{
"type": "campaign",
"group": [
"MALARIA"
],
"hierarchy": "HierarchyTest02",
"department": [],
"lowestHierarchy": "ADMINISTRATIVEPOST",
"splitBoundariesOn": "DISTRICT"
}
2.9) Add data for HCM-ADMIN-CONSOLE.microplanIntegration
{
"type": "Target-LLIN-mz",
"mappings": [
{
"to": "HCM_ADMIN_CONSOLE_TARGET",
"from": [
"CONFIRMED_HCM_ADMIN_CONSOLE_TARGET_POPULATION"
],
"filter": "equal"
}
]
}
{
"type": "Target-MR-DN",
"mappings": [
{
"to": "HCM_ADMIN_CONSOLE_TARGET_SMC_AGE_3_TO_11",
"from": [
"CONFIRMED_HCM_ADMIN_CONSOLE_TARGET_POPULATION_AGE_3TO11"
],
"filter": "equal"
},
{
"to": "HCM_ADMIN_CONSOLE_TARGET_SMC_AGE_12_TO_59",
"from": [
"CONFIRMED_HCM_ADMIN_CONSOLE_TARGET_POPULATION_AGE_12TO59"
],
"filter": "equal"
}
]
}
{
"type": "user",
"mappings": [
{
"to": "Supervisor",
"from": [
"PER_BOUNDARY_FOR_THE_CAMPAIGN",
"PER_BOUNDARY",
"TEAM",
"SUPERVISORS"
],
"filter": "includes"
},
{
"to": "Registrar",
"from": [
"PER_BOUNDARY_FOR_THE_CAMPAIGN",
"PER_BOUNDARY",
"TEAM",
"REGISTRATION"
],
"filter": "includes"
},
{
"to": "Distributor",
"from": [
"PER_BOUNDARY_FOR_THE_CAMPAIGN",
"PER_BOUNDARY",
"TEAM",
"DISTRIBUTION"
],
"filter": "includes"
}
]
}
2.10) Add data for HCM-ADMIN-CONSOLE.adminSchema
{
"title": "boundaryManagement",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"numberProperties": [
{
"name": "HCM_ADMIN_CONSOLE_LAT",
"type": "number",
"isRequired": true,
"description": "Latitude",
"orderNumber": 2
},
{
"name": "HCM_ADMIN_CONSOLE_LONG",
"type": "number",
"isRequired": true,
"description": "Longitude",
"orderNumber": 3
}
],
"stringProperties": [
{
"name": "HCM_ADMIN_CONSOLE_BOUNDARY_CODE",
"type": "string",
"isRequired": true,
"description": "Boundary Code",
"orderNumber": 1,
"freezeColumn": true
}
]
},
"campaignType": "all"
}
2.11) Update data for HCM-ADMIN-CONSOLE.HierarchySchema
{
"type": "console",
"group": [
"MALARIA"
],
"hierarchy": "ADMIN",
"department": [],
"lowestHierarchy": "Posto Administrativo",
"splitBoundariesOn": "Distrito"
}
2.12) Update data for HCM-ADMIN-CONSOLE.adminSchema
{
"title": "user",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"enumProperties": [
{
"enum": [
"Distributor",
"Health Facility Worker",
"Warehouse Manager",
"National Supervisor",
"Provincial Supervisor",
"District Supervisor",
"Field Supervisor",
"Registrar",
"Supervisor",
"Helpdesk User",
"Monitor Local",
"Logistical Officer"
],
"name": "HCM_ADMIN_CONSOLE_USER_ROLE",
"isRequired": true,
"description": "User Role",
"orderNumber": 3
},
{
"enum": [
"Temporary",
"Permanent"
],
"name": "HCM_ADMIN_CONSOLE_USER_EMPLOYMENT_TYPE",
"isRequired": true,
"description": "Employement Type",
"orderNumber": 4
},
{
"enum": [
"Active",
"Inactive"
],
"name": "HCM_ADMIN_CONSOLE_USER_USAGE",
"isRequired": true,
"description": "User Usage",
"orderNumber": 6
}
],
"numberProperties": [
{
"name": "HCM_ADMIN_CONSOLE_USER_PHONE_NUMBER",
"type": "number",
"maximum": 9999999999,
"minimum": 1000000000,
"isUnique": true,
"isRequired": true,
"description": "Phone Number",
"orderNumber": 2,
"errorMessage": "HCM_ADMIN_CONSOLE_USER_PHONE_NUMBER_ERROR"
}
],
"stringProperties": [
{
"name": "HCM_ADMIN_CONSOLE_USER_NAME",
"type": "string",
"maxLength": 128,
"minLength": 2,
"isRequired": true,
"description": "User Name",
"orderNumber": 1
},
{
"name": "HCM_ADMIN_CONSOLE_BOUNDARY_CODE_MANDATORY",
"type": "string",
"isRequired": true,
"description": "Boundary Code (Mandatory)",
"orderNumber": 5,
"errorMessage": "HCM_ADMIN_CONSOLE_BOUNDARY_CODE_MANDATORY_ERROR"
},
{
"name": "#status#",
"type": "string",
"isUpdate": true,
"hideColumn": true,
"description": "status",
"orderNumber": 7,
"freezeColumn": true
},
{
"name": "UserService Uuids",
"type": "string",
"isUpdate": true,
"hideColumn": true,
"description": "uuid",
"orderNumber": 9,
"freezeColumn": true
},
{
"name": "#errorDetails#",
"type": "string",
"isUpdate": true,
"hideColumn": true,
"description": "error details",
"orderNumber": 8,
"freezeColumn": true
},
{
"name": "UserName",
"type": "string",
"isUpdate": true,
"hideColumn": true,
"description": "user name",
"orderNumber": 10,
"freezeColumn": true
},
{
"name": "Password",
"type": "string",
"isUpdate": true,
"hideColumn": true,
"description": "password",
"orderNumber": 11,
"freezeColumn": true
},
{
"name": "HCM_ADMIN_CONSOLE_UPDATED_BOUNDARY_CODE",
"type": "string",
"isUpdate": true,
"description": "Updated Boundary Code",
"orderNumber": 12,
"errorMessage": "HCM_ADMIN_CONSOLE_UPDATED_BOUNDARY_CODE_ERROR"
}
]
},
"campaignType": "all"
},
{
"title": "user",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"enumProperties": [
{
"enum": [
"Registrar",
"Distributor",
"Supervisor",
"Helpdesk User",
"Monitor Local",
"Logistical Officer",
"Health Facility Worker",
"Warehouse Manager",
"National Supervisor",
"Provincial Supervisor",
"District Supervisor",
"Field Supervisor",
"Team Lead"
],
"name": "HCM_ADMIN_CONSOLE_USER_ROLE",
"isRequired": true,
"description": "User Role",
"orderNumber": 3
},
{
"enum": [
"Temporary",
"Permanent"
],
"name": "HCM_ADMIN_CONSOLE_USER_EMPLOYMENT_TYPE",
"isRequired": true,
"description": "Employement Type",
"orderNumber": 4
},
{
"enum": [
"Active",
"Inactive"
],
"name": "HCM_ADMIN_CONSOLE_USER_USAGE",
"isRequired": true,
"description": "User Usage",
"orderNumber": 6
}
],
"numberProperties": [
{
"name": "HCM_ADMIN_CONSOLE_USER_PHONE_NUMBER",
"type": "number",
"maximum": 9999999999,
"minimum": 1000000000,
"isUnique": true,
"isRequired": true,
"description": "Phone Number",
"orderNumber": 2,
"errorMessage": "HCM_ADMIN_CONSOLE_USER_PHONE_NUMBER_ERROR"
}
],
"stringProperties": [
{
"name": "HCM_ADMIN_CONSOLE_USER_NAME",
"type": "string",
"maxLength": 128,
"minLength": 2,
"isRequired": true,
"description": "User Name",
"orderNumber": 1
},
{
"name": "HCM_ADMIN_CONSOLE_BOUNDARY_CODE_MANDATORY",
"type": "string",
"description": "Boundary Code (Mandatory)",
"orderNumber": 5,
"errorMessage": "HCM_ADMIN_CONSOLE_BOUNDARY_CODE_MANDATORY_ERROR",
"freezeColumn": true
},
{
"name": "HCM_ADMIN_CONSOLE_UPDATED_BOUNDARY_CODE",
"type": "string",
"description": "Updated Boundary Code",
"orderNumber": 11,
"errorMessage": "HCM_ADMIN_CONSOLE_UPDATED_BOUNDARY_CODE_ERROR"
},
{
"name": "#status#",
"type": "string",
"description": "status",
"orderNumber": 7,
"freezeColumn": true
},
{
"name": "UserService Uuids",
"type": "string",
"description": "uuid",
"orderNumber": 8,
"freezeColumn": true
},
{
"name": "UserName",
"type": "string",
"description": "user name",
"orderNumber": 9,
"freezeColumn": true
},
{
"name": "Password",
"type": "string",
"description": "password",
"orderNumber": 10,
"freezeColumn": true
}
]
},
"campaignType": "allUpdated"
},
{
"title": "facility",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"enumProperties": [
{
"enum": [
"Warehouse",
"Health Facility",
"Storing Resource"
],
"name": "HCM_ADMIN_CONSOLE_FACILITY_TYPE",
"isRequired": true,
"description": "Facility type",
"orderNumber": 2
},
{
"enum": [
"Temporary",
"Permanent"
],
"name": "HCM_ADMIN_CONSOLE_FACILITY_STATUS",
"isRequired": true,
"description": "Facility status",
"orderNumber": 3
},
{
"enum": [
"Active",
"Inactive"
],
"name": "HCM_ADMIN_CONSOLE_FACILITY_USAGE",
"isRequired": true,
"description": "Facility usage",
"orderNumber": 6
}
],
"numberProperties": [
{
"name": "HCM_ADMIN_CONSOLE_FACILITY_CAPACITY",
"type": "number",
"maximum": 100000000,
"minimum": 1,
"isRequired": true,
"description": "Capacity",
"orderNumber": 4,
"errorMessage": "HCM_ADMIN_CONSOLE_FACILITY_CAPACITY_ERROR"
}
],
"stringProperties": [
{
"name": "HCM_ADMIN_CONSOLE_FACILITY_NAME",
"type": "string",
"isUnique": true,
"maxLength": 2000,
"minLength": 1,
"isRequired": true,
"description": "Facility Name",
"orderNumber": 1
},
{
"name": "HCM_ADMIN_CONSOLE_BOUNDARY_CODE_MANDATORY",
"type": "string",
"isRequired": false,
"description": "Boundary Code",
"orderNumber": 5,
"errorMessage": "HCM_ADMIN_CONSOLE_BOUNDARY_CODE_MANDATORY_ERROR",
"freezeColumn": true
},
{
"name": "HCM_ADMIN_CONSOLE_UPDATED_BOUNDARY_CODE",
"type": "string",
"isRequired": false,
"description": "Updated Boundary Code",
"orderNumber": 7,
"errorMessage": "HCM_ADMIN_CONSOLE_UPDATED_BOUNDARY_CODE_ERROR"
}
]
},
"campaignType": "allUpdated"
}
2.13) Update data for HCM.CHECKLIST_TYPES
{
"code": "IEC",
"name": "IEC",
"type": "ASSESSMENT"
}
{
"code": "HF_RF_DRUG_SE_CC",
"name": "HF_RF_DRUG_SE_CC",
"type": "ASSESSMENT"
},
{
"code": "HF_RF_DRUG_SE_PC",
"name": "HF_RF_DRUG_SE_PC",
"type": "ASSESSMENT"
},
{
"code": "HF_RF_FEVER",
"name": "HF_RF_FEVER",
"type": "ASSESSMENT"
},
{
"code": "HF_RF_SICK",
"name": "HF_RF_SICK",
"type": "ASSESSMENT"
}
{
"code": "TEAM_FORMATION",
"name": "TEAM_FORMATION",
"type": "DEFAULT"
}
{
"code": "TRAINING_SUPERVISION",
"name": "TRAINING_SUPERVISION",
"type": "DEFAULT"
}
{
"code": "WAREHOUSE",
"name": "WAREHOUSE",
"type": "DEFAULT"
}
3) action-test:
[
{
"id": 2046,
"name": "create data for Workbench.UISchema schema",
"url": "/mdms-v2/v2/_create/Workbench.UISchema",
"serviceCode": "mdms"
},
{
"id": 2047,
"name": "create data for HCM-PROJECT-TYPES.projectTypes schema",
"url": "/mdms-v2/v2/_create/HCM-PROJECT-TYPES.projectTypes",
"serviceCode": "mdms"
},
{
"id": 2048,
"name": "create data for HCM-PROJECT.projectConfiguration schema",
"url": "/mdms-v2/v2/_create/HCM-PROJECT.projectConfiguration",
"serviceCode": "mdms"
},
{
"id": 2049,
"name": "create data for HCM-FIELD-APP-CONFIG.appConfig schema",
"url": "/mdms-v2/v2/_create/HCM-FIELD-APP-CONFIG.appConfig",
"serviceCode": "mdms"
},
{
"id": 2050,
"name": "create data for HCM-ADDITIONAL-FIELD-SCHEMAS.additionalFieldSchemas schema",
"url": "/mdms-v2/v2/_create/HCM-ADDITIONAL-FIELD-SCHEMAS.additionalFieldSchemas",
"serviceCode": "mdms"
},
{
"id": 2051,
"name": "create data for HCM-ADMIN-CONSOLE.userSchema schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.userSchema",
"serviceCode": "mdms"
},
{
"id": 2052,
"name": "create data for HCM-ADMIN-CONSOLE.ReadMeConfig schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.ReadMeConfig",
"serviceCode": "mdms"
},
{
"id": 2053,
"name": "create data for HCM-ADMIN-CONSOLE.productType schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.productType",
"serviceCode": "mdms"
},
{
"id": 2054,
"name": "create data for HCM-ADMIN-CONSOLE.operatorConfig schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.operatorConfig",
"serviceCode": "mdms"
},
{
"id": 2055,
"name": "create data for HCM-ADMIN-CONSOLE.mailConfig schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.mailConfig",
"serviceCode": "mdms"
},
{
"id": 2056,
"name": "create data for HCM-ADMIN-CONSOLE.genderConfig schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.genderConfig",
"serviceCode": "mdms"
},
{
"id": 2057,
"name": "create data for HCM-ADMIN-CONSOLE.facilitySchema schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.facilitySchema",
"serviceCode": "mdms"
},
{
"id": 2058,
"name": "create data for HCM-ADMIN-CONSOLE.hierarchyConfig schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.hierarchyConfig",
"serviceCode": "mdms"
},
{
"id": 2059,
"name": "create data for HCM-ADMIN-CONSOLE.deliveryTypeConfig schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.deliveryTypeConfig",
"serviceCode": "mdms"
},
{
"id": 2060,
"name": "create data for HCM-ADMIN-CONSOLE.deliveryConfig schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.deliveryConfig",
"serviceCode": "mdms"
},
{
"id": 2061,
"name": "create data for HCM-ADMIN-CONSOLE.Boundary schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.Boundary",
"serviceCode": "mdms"
},
{
"id": 2062,
"name": "create data for Workbench.UISchema schema",
"url": "/mdms-v2/v2/_update/Workbench.UISchema",
"serviceCode": "mdms"
},
{
"id": 2063,
"name": "create data for HCM-PROJECT-TYPES.projectTypes schema",
"url": "/mdms-v2/v2/_update/HCM-PROJECT-TYPES.projectTypes",
"serviceCode": "mdms"
},
{
"id": 2064,
"name": "create data for HCM-PROJECT.projectConfiguration schema",
"url": "/mdms-v2/v2/_update/HCM-PROJECT.projectConfiguration",
"serviceCode": "mdms"
},
{
"id": 2065,
"name": "create data for HCM-FIELD-APP-CONFIG.appConfig schema",
"url": "/mdms-v2/v2/_update/HCM-FIELD-APP-CONFIG.appConfig",
"serviceCode": "mdms"
},
{
"id": 2066,
"name": "create data for HCM-ADDITIONAL-FIELD-SCHEMAS.additionalFieldSchemas schema",
"url": "/mdms-v2/v2/_update/HCM-ADDITIONAL-FIELD-SCHEMAS.additionalFieldSchemas",
"serviceCode": "mdms"
},
{
"id": 2067,
"name": "create data for HCM-ADMIN-CONSOLE.userSchema schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.userSchema",
"serviceCode": "mdms"
},
{
"id": 2068,
"name": "create data for HCM-ADMIN-CONSOLE.ReadMeConfig schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.ReadMeConfig",
"serviceCode": "mdms"
},
{
"id": 2069,
"name": "create data for HCM-ADMIN-CONSOLE.productType schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.productType",
"serviceCode": "mdms"
},
{
"id": 2070,
"name": "create data for HCM-ADMIN-CONSOLE.operatorConfig schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.operatorConfig",
"serviceCode": "mdms"
},
{
"id": 2071,
"name": "create data for HCM-ADMIN-CONSOLE.mailConfig schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.mailConfig",
"serviceCode": "mdms"
},
{
"id": 2072,
"name": "create data for HCM-ADMIN-CONSOLE.genderConfig schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.genderConfig",
"serviceCode": "mdms"
},
{
"id": 2073,
"name": "create data for HCM-ADMIN-CONSOLE.facilitySchema schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.facilitySchema",
"serviceCode": "mdms"
},
{
"id": 2074,
"name": "create data for HCM-ADMIN-CONSOLE.hierarchyConfig schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.hierarchyConfig",
"serviceCode": "mdms"
},
{
"id": 2075,
"name": "create data for HCM-ADMIN-CONSOLE.deliveryTypeConfig schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.deliveryTypeConfig",
"serviceCode": "mdms"
},
{
"id": 2076,
"name": "create data for HCM-ADMIN-CONSOLE.deliveryConfig schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.deliveryConfig",
"serviceCode": "mdms"
},
{
"id": 2077,
"name": "create data for HCM-ADMIN-CONSOLE.Boundary schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.Boundary",
"serviceCode": "mdms"
},
{
"id": 2078,
"name": "create data for ACCESSCONTROL-ROLES.roles schema",
"url": "/mdms-v2/v2/_create/ACCESSCONTROL-ROLES.roles",
"serviceCode": "mdms"
},
{
"id": 2079,
"name": "create data for ACCESSCONTROL-ROLES.roles schema",
"url": "/mdms-v2/v2/_update/ACCESSCONTROL-ROLES.roles",
"serviceCode": "mdms"
},
{
"id": 2080,
"name": "create data for HCM-ADMIN-CONSOLE.HierarchySchema schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.HierarchySchema",
"serviceCode": "mdms"
},
{
"id": 2081,
"name": "create data for HCM-ADMIN-CONSOLE.HierarchySchema schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.HierarchySchema",
"serviceCode": "mdms"
},
{
"id": 2082,
"name": "create data for HCM-ADMIN-CONSOLE.rolesForChecklist schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.rolesForChecklist",
"serviceCode": "mdms"
},
{
"id": 2083,
"name": "create data for HCM-ADMIN-CONSOLE.rolesForChecklist schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.rolesForChecklist",
"serviceCode": "mdms"
},
{
"id": 2084,
"name": "create data for HCM-ADMIN-CONSOLE.ChecklistTemplates schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.ChecklistTemplates",
"serviceCode": "mdms"
},
{
"id": 2085,
"name": "create data for HCM-ADMIN-CONSOLE.ChecklistTemplates schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.ChecklistTemplates",
"serviceCode": "mdms"
},
{
"id": 2086,
"name": "create data for HCM-ADMIN-CONSOLE.appFieldTypes schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.appFieldTypes",
"serviceCode": "mdms"
},
{
"id": 2087,
"name": "create data for HCM-ADMIN-CONSOLE.appFieldTypes schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.appFieldTypes",
"serviceCode": "mdms"
},
{
"id": 2088,
"name": "create data for HCM-ADMIN-CONSOLE.baseTimeOut schema",
"url": "/mdms-v2/v2/_create/HCM-ADMIN-CONSOLE.baseTimeOut",
"serviceCode": "mdms"
},
{
"id": 2089,
"name": "create data for HCM-ADMIN-CONSOLE.baseTimeOut schema",
"url": "/mdms-v2/v2/_update/HCM-ADMIN-CONSOLE.baseTimeOut",
"serviceCode": "mdms"
},
{
"id": 2090,
"name": "create data for Workbench.UISchema schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.Workbench.UISchema",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=Workbench&masterName=UISchema"
},
{
"id": 2091,
"name": "create data for HCM-PROJECT-TYPES.projectTypes schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-PROJECT-TYPES.projectTypes",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-PROJECT-TYPES&masterName=projectTypes"
},
{
"id": 2092,
"name": "create data for HCM-PROJECT.projectConfiguration schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-PROJECT.projectConfiguration",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-PROJECT&masterName=projectConfiguration"
},
{
"id": 2093,
"name": "create data for HCM-FIELD-APP-CONFIG.appConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-FIELD-APP-CONFIG.appConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-FIELD-APP-CONFIG&masterName=appConfig"
},
{
"id": 2094,
"name": "create data for HCM-ADDITIONAL-FIELD-SCHEMAS.additionalFieldSchemas schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADDITIONAL-FIELD-SCHEMAS.additionalFieldSchemas",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADDITIONAL-FIELD-SCHEMAS&masterName=additionalFieldSchemas"
},
{
"id": 2095,
"name": "create data for HCM-ADMIN-CONSOLE.userSchema schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.userSchema",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=userSchema"
},
{
"id": 2096,
"name": "create data for HCM-ADMIN-CONSOLE.ReadMeConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.ReadMeConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=ReadMeConfig"
},
{
"id": 2097,
"name": "create data for HCM-ADMIN-CONSOLE.productType schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.productType",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=productType"
},
{
"id": 2098,
"name": "create data for HCM-ADMIN-CONSOLE.operatorConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.operatorConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=operatorConfig"
},
{
"id": 2099,
"name": "create data for HCM-ADMIN-CONSOLE.mailConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.mailConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=mailConfig"
},
{
"id": 2100,
"name": "create data for HCM-ADMIN-CONSOLE.genderConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.genderConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=genderConfig"
},
{
"id": 2101,
"name": "create data for HCM-ADMIN-CONSOLE.facilitySchema schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.facilitySchema",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=facilitySchema"
},
{
"id": 2102,
"name": "create data for HCM-ADMIN-CONSOLE.hierarchyConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.hierarchyConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=hierarchyConfig"
},
{
"id": 2103,
"name": "create data for HCM-ADMIN-CONSOLE.deliveryTypeConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.deliveryTypeConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=deliveryTypeConfig"
},
{
"id": 2104,
"name": "create data for HCM-ADMIN-CONSOLE.deliveryConfig schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.deliveryConfig",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=deliveryConfig"
},
{
"id": 2105,
"name": "create data for HCM-ADMIN-CONSOLE.Boundary schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.Boundary",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=Boundary"
},
{
"id": 2106,
"name": "create data for ACCESSCONTROL-ROLES.roles schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.ACCESSCONTROL-ROLES.roles",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=ACCESSCONTROL-ROLES&masterName=roles"
},
{
"id": 2107,
"name": "create data for HCM-ADMIN-CONSOLE.HierarchySchema schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.HierarchySchema",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=HierarchySchema"
},
{
"id": 2108,
"name": "create data for HCM-ADMIN-CONSOLE.rolesForChecklist schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.rolesForChecklist",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=rolesForChecklist"
},
{
"id": 2109,
"name": "create data for HCM-ADMIN-CONSOLE.ChecklistTemplates schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.ChecklistTemplates",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=ChecklistTemplates"
},
{
"id": 2110,
"name": "create data for HCM-ADMIN-CONSOLE.appFieldTypes schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.appFieldTypes",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=appFieldTypes"
},
{
"id": 2111,
"name": "create data for HCM-ADMIN-CONSOLE.baseTimeOut schema",
"serviceCode": "mdms",
"url": "url",
"path": "MDMS.HCM-ADMIN-CONSOLE.baseTimeOut",
"enabled": true,
"leftIcon": "Article",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=HCM-ADMIN-CONSOLE&masterName=baseTimeOut"
},
{
"id": 2112,
"name": "fetch from microplan",
"url": "/project-factory/v1/project-type/fetch-from-microplan",
"displayName": "fetch from microplan",
"orderNumber": 0,
"enabled": false,
"serviceCode": "project-factory",
"code": "null",
"path": "/project-factory/v1/project-type/fetch-from-microplan"
}
]
}
]
4) roleactions:
[
{
"actionid": "2046",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2047",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2048",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2049",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2050",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2051",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2052",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2053",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2054",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2055",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2056",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2057",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2058",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2059",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2060",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2061",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2062",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2063",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2064",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2065",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2066",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2067",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2068",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2069",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2070",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2071",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2072",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2073",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2074",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2075",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2076",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2077",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2078",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2079",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2080",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2081",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2082",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2083",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2084",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2085",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2086",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2087",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2088",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2089",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2090",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2091",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2092",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2093",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2094",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2095",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2096",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2097",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2098",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2099",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2100",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2101",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2102",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2103",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2104",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2105",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2106",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2107",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2108",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2109",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2110",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2111",
"rolecode": "MDMS_ADMIN",
"tenantid": "mz",
"actioncode": ""
},
{
"actionid": "2112",
"rolecode": "MICROPLAN_CAMPAIGN_INTEGRATOR",
"tenantid": "mz",
"actioncode": ""
}
]
5) roles:
[
{
"code": "MICROPLAN_CAMPAIGN_INTEGRATOR",
"name": "Microplan Campaign integrator",
"description": "Microplan and Campaign integrated user"
},
{
"code": "BOUNDARY_MANAGER",
"name": "Boundary Manager",
"description": "Boundary Manager"
}
]
To enable the generation of unique identifiers via idGen service, the following data must be added to the MDMS under moduleName=common-masters
and masterName=IdFormat
.
MDMS Data for Usernames
The structure for generating sequence-based usernames is as follows:
{
"format": "USR-[SEQ_EG_USER_NAME]",
"idname": "username.name"
}
MDMS Data for Campaigns
The structure for generating sequence-based campaign IDs is as follows:
{
"format": "CMP-[cy:yyyy-MM-dd]-[SEQ_EG_CMP_ID]",
"idname": "campaign.number"
}
Ensure both configurations are added to MDMS before proceeding with ID generation.
Sequence Management in PostgreSQL
The IDGen service relies on PostgreSQL sequences to generate unique identifiers. If the sequences are not automatically created during ID generation, they must be manually created in the database.
Sequence for Usernames
To create a sequence for usernames, execute the following SQL script:
CREATE SEQUENCE IF NOT EXISTS public.seq_eg_user_name
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 9223372036854775807
CACHE 1;
Sequence for Campaigns
To create a sequence for campaign IDs, execute the following SQL script:
CREATE SEQUENCE IF NOT EXISTS public.seq_eg_cmp_id
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 9223372036854775807
CACHE 1;
API Postman Collection
Localisations:
Changes are being tracked in the Excel sheet:
Last updated