File Format: Tab Delimited Text, no header or footer
File Access: Upload via Batch Desktop and FTP
File Naming Logic: ClientName_YYYYMMDD
Special Characters: Remove tabs from fields before file generation to avoid special characters breaking the file.
There are two versions of the File Specification:
- “Account” = MEDITECH Expanse Encounter Posting File
- “Guarantor” = MEDITECH Expanse Guarantor Posting File
Account
| Field # | Field Name | Default Value | Required? | Format | Max Length | Comment |
|---|---|---|---|---|---|---|
| 1 | Identifier Type | "Account" | Y | AN | 21 | |
| 2 | Identifier | Y | AN | 14 | Patient ID from payment form | |
| 3 | Facility | O | DICT VALUE | 10 | ||
| 4 | Bill Number | O | AN | 3 | ||
| 5 | Insurance | "SP" | O | AN | 12 | |
| 6 | Payment Code | "CREDIT" | O | SMONEY | 12 | Part 1: Default value equals "CREDIT". Part 2: Terminal Description overwrites if populated. If larger than 12 characters take left most characters |
| 7 | Payment Amount | O | AN | 9 | Payment Amount (Sub Amount) | |
| 8 | Payment Comment | O | AN | 45 | AdditionalInfo1 | |
| 9 | Adjustment Code | O | AN | 12 | ||
| 10 | Adjustment Amount | O | SMONEY | 9 | ||
| 11 | Adjustment Comment | O | AN | 25 | ||
| 12 | Additional Comment | O | AN | 25 | ||
| 13 | Name on Card | O | AN | 35 | CardHolder Name | |
| 14 | Credit Card Type | O | AN | 20 | Card Type (Visa, MC, DISC, AMEX) | |
| 15 | Credit Card Expiration Date | O | AN | 7 | ||
| 16 | Credit Card Authorization Number | O | AN | 20 | Authorization Number | |
| 17 | Service Date | O | DATE | 8 | Payment Transaction Date | |
| 18 | Txn Number | O | N | 5 | ||
| 19 | Space Filler | O | AN | 122 |
Guarantor
| Field # | Field Name | Default Value | Required? | Format | Max Length | Comment |
|---|---|---|---|---|---|---|
| 1 | Identifier Type | "Guarantor" | Y | AN | 21 | |
| 2 | Identifier | Y | AN | 14 | Guarantor ID from payment form | |
| 3 | Facility | O | DICT VALUE | 10 | ||
| 4 | Bill Number | O | AN | 3 | ||
| 5 | Insurance | "SP" | O | AN | 12 | |
| 6 | Payment Code | "CREDIT" | O | SMONEY | 12 | Part 1: Default value equals "CREDIT". Part 2: Terminal Description overwrites if populated. If larger than 12 characters take left most characters |
| 7 | Payment Amount | O | AN | 9 | Payment Amount (Sub Amount) | |
| 8 | Payment Comment | O | AN | 45 | AdditionalInfo1 | |
| 9 | Adjustment Code | O | AN | 12 | ||
| 10 | Adjustment Amount | O | SMONEY | 9 | ||
| 11 | Adjustment Comment | O | AN | 25 | ||
| 12 | Additional Comment | O | AN | 25 | ||
| 13 | Name on Card | O | AN | 35 | CardHolder Name | |
| 14 | Credit Card Type | O | AN | 20 | Card Type (Visa, MC, DISC, AMEX) | |
| 15 | Credit Card Expiration Date | O | AN | 7 | ||
| 16 | Credit Card Authorization Number | O | AN | 20 | Authorization Number | |
| 17 | Service Date | O | DATE | 8 | Payment Transaction Date | |
| 18 | Txn Number | O | N | 5 | ||
| 19 | Space Filler | O | AN | 122 |
