Integration with Mpowered's systems requires a mininum set of fields are available in the source system. The tables below define the fields involved in integration.
For more information on how integration works, see 'Getting Started'.
Minimum data requirements
Field |
Data Type |
Accepted Values |
Notes |
Training program name |
Text |
Any free text, eg: |
|
Category |
Text |
Must be exactly: ‘A’, ‘B’, ‘C’, ‘D’, ‘E’, ‘F’ or ‘G’ |
As defined in the B-BBEE codes Skills Development matrix. Will require a custom field in the source system. |
Learner name |
Text |
Any free text, eg: |
|
Gender |
Text |
Must be exactly: ‘Male’ ‘Female’ |
|
Race |
Text |
Must be exactly: ‘Coloured’ ‘White’ |
|
Start date |
|
A valid date formatted as ‘dd/mm/yyyy’ |
|
End date |
|
A valid date formatted as ‘dd/mm/yyyy’ |
|
Course cost |
Decimal number |
Eg: 5200.0 |
|
ID number |
Text |
Any free text |
The learner’s RSA ID number or passport number. |
Foreign |
Text |
Must be exactly: |
As defined in the B-BBEE codes. May require a custom field in the source system. |
Disabled |
Text |
Must be exactly: |
|
Age |
Integer |
|
|
Recommended data requirements
Field |
Data Type |
Accepted Values |
Notes |
Mandatory training |
Text |
Must be exactly: |
As defined in the B-BBEE codes. May require a custom field in the source system. |
Bursary - Higher Education |
Text |
Must be exactly: |
|
Employment status at the start of the training program |
Text |
Must be exactly: |
|
Y.E.S employee |
Text |
Must be exactly: |
|
Completed |
Text |
Must be exactly: |
For Category ‘B’, ‘C’, ‘D’ only. |
Absorbed |
Text |
Must be exactly: |
For Category ‘B’, ‘C’, ‘D’ only. |
Business unit |
Text |
Any free text |
|
Employee code |
Text |
Any free text |
|
Travel cost |
Decimal number |
Eg: 5200.0 |
Attributable to the learner for this training intervention. |
Accommodation cost |
Decimal number |
Eg: 5200.0 |
Attributable to the learner for this training intervention. |
Catering cost |
Decimal number |
Eg: 5200.0 |
Attributable to the learner for this training intervention. |
Stationery cost |
Decimal number |
Eg: 5200.0 |
Attributable to the learner for this training intervention. |
Training facility cost |
Decimal number |
Eg: 5200.0 |
Attributable to the learner for this training intervention. |
Salary cost |
Decimal number |
Eg: 5200.0 |
For Category ‘B’, ‘C’, ‘D’ only |
Other costs |
Decimal number |
Eg: 5200.0 |
Attributable to the learner for this training intervention. |
Comments
0 comments
Please sign in to leave a comment.