MSO to Parent System Integration Mapping file formats
MSO to parent system mapping file formats.
Contracting Provider to Staff and Program
|
Column |
Description |
Comments |
|---|---|---|
|
1 |
1 |
Required field. Must be '1'. |
|
2 |
Provider ID |
Required field. Must be valid myAvatar provider ID. |
|
3 |
PM Staff ID |
Required field. Must be valid myAvatar staff ID. |
|
4 |
PM Program Code |
Required field. Must be valid myAvatar program code (Program Maintenance form) |
Contracting Provider Program to Staff and Program
|
Column |
Description |
Comments |
|---|---|---|
|
1 |
2 |
Required field. Must be '2'. |
|
2 |
Provider ID |
Required field. Must be valid myAvatar provider ID. |
|
3 |
Contracting Provider Program |
Enter a valid 'PGMuniqueid' for the provider (defined in the 'SYSTEM.provider_program_data' SQL table). |
|
4 |
PM Staff ID |
Required field. Must be valid myAvatar staff ID. |
|
5 |
PM Program Code |
Required field. Must be valid myAvatar program code (Program Maintenance form) |
Contracting Provider / Performing Provider to Staff and Program
|
Column |
Description |
Comments |
|---|---|---|
|
1 |
3 |
Required field. Must be '3'. |
|
2 |
Provider ID |
Required field. Must be valid myAvatar provider ID. |
|
3 |
Performing Provider |
Enter a valid 'PPI_uniqueid' for the provider (defined in the 'SYSTEM.provider_performing_data' SQL table). |
|
4 |
PM Staff ID |
Required field. Must be valid myAvatar staff ID. |
|
5 |
PM Program Code |
Required field. Must be valid myAvatar program code (Program Maintenance form) |
Contracting Provider / Performing Provider / Provider Program to Staff and Program
|
Column |
Description |
Comments |
|---|---|---|
|
1 |
4 |
Required field. Must be '4'. |
|
2 |
Provider ID |
Required field. Must be valid myAvatar provider ID. |
|
3 |
Performing Provider |
Enter a valid 'PPI_uniqueid' for the provider (defined in the 'SYSTEM.provider_performing_data' SQL table). |
|
4 |
Contracting Provider Program |
Enter a valid 'PGMuniqueid' for the provider (defined in the 'SYSTEM.provider_program_data' SQL table). |
|
5 |
PM Staff ID |
Required field. Must be valid myAvatar staff ID. |
|
6 |
PM Program Code |
Required field. Must be valid myAvatar program code (Program Maintenance form) |
Contracting Provider and CPT Code to Program
|
Column |
Description |
Comments |
|---|---|---|
|
1 |
5 |
Required field. Must be '5'. |
|
2 |
Provider ID |
Required field. Must be valid myAvatar provider ID. |
|
3 |
CPT Code |
Required field. Must be valid myAvatar CPT code. |
|
4 |
PM Program Code |
Required field. Must be valid myAvatar program code (Program Maintenance form) |
CPT Code to Service Code
|
Column |
Description |
Comments |
|---|---|---|
|
1 |
6 |
Required field. Must be '6'. |
|
2 |
CPT Code |
Required field. Must be valid myAvatar CPT code. |
|
3 |
PM Service Code |
Required field. Must be valid myAvatar service code (Service Codes form) |
Revenue Code to Service Code
|
Column |
Description |
Comments |
|---|---|---|
|
1 |
7 |
Required field. Must be '7'. |
|
2 |
Revenue Code |
Required field. Must be valid myAvatar revenue code. |
|
3 |
PM Service Code |
Required field. Must be valid myAvatar service code (Service Codes form) |