Pennsylvania Non-Homecare EDI Export Interface
HHAeXchange Flat File Data Exchange interfaces support the below-listed exports from HHAeXchange to the SFTP Outbox folder. All interfaces and applicable file formats are explained in the following tables.
-
NHC Patient Authorizations Export
-
NHC Patient Demographics Export
Creates a Patient Demographic Export file based on a flat file given in the following format.
Sample Template: Click Patient Demographic Export
Save the *.CSV file on your computer and Open the file using a text editor (such as Notepad) to preserve the formats for each field.
|
Field |
Description |
Data Type |
Max Length |
Cell |
|---|---|---|---|---|
|
Payer ID |
Unique ID of the Payer in HHAeXchange. |
Number |
10 |
A |
|
Agency Tax ID |
Tax ID of the Agency. |
Text |
20 |
B |
|
Patient ID |
Unique ID of the Patient in HHAeXchange. This field should be used as the key for all electronic data exchanges. |
Number |
10 |
C |
|
Admission ID |
Patient Admission ID |
Text |
20 |
D |
|
First Name |
First Name |
Text |
50 |
E |
|
Middle Name |
Middle Name |
Text |
50 |
F |
|
Last Name |
Last name |
Text |
50 |
G |
|
MR Number |
Always Blank. Reserved for future use. |
Text |
50 |
H |
|
Gender |
Possible Values (M/F) |
Text |
1 |
I |
|
DOB |
Format: YYYY-MM-DD |
Date |
10 |
J |
|
Priority Code |
Always Blank. Reserved for future use. |
Number |
1 |
K |
|
Medicaid Number |
Medicaid Number |
Text |
20 |
L |
|
Street 1 |
Address 1 |
Text |
500 |
M |
|
Street 2 |
Address 2 |
Text |
50 |
N |
|
City |
City |
Text |
50 |
O |
|
State |
State |
Text |
50 |
P |
|
Zip |
Zip |
Number |
5 |
Q |
|
Cross Street |
Always Blank. Reserved for future use. |
Text |
80 |
R |
|
Home Phone |
Format: XXX-XXX-XXXX |
Text |
12 |
S |
|
Phone 2 |
Format: XXX-XXX-XXXX |
Text |
12 |
T |
|
Phone 2 Description |
Phone 2 Description |
Text |
50 |
U |
|
Phone 3 |
Format: XXX-XXX-XXXX |
Text |
12 |
V |
|
Phone 3 Description |
Phone 3 Description |
Text |
50 |
W |
|
Emergency 1 Name |
Emergency 1 Name |
Text |
50 |
X |
|
Emergency 1 Address |
Emergency 1 Address |
Text |
50 |
Y |
|
Emergency 1 Relationship |
Emergency 1 Relationship |
Text |
50 |
Z |
|
Emergency 1 Phone 1 |
Always Blank. Reserved for future use. |
Text |
12 |
AA |
|
Emergency 1 Phone 2 |
Always Blank. Reserved for future use. |
Text |
12 |
AB |
|
Emergency 2 Name |
Always Blank. Reserved for future use. |
Text |
50 |
AC |
|
Emergency 2 Address |
Always Blank. Reserved for future use. |
Text |
50 |
AD |
|
Emergency 2 Relationship |
Always Blank. Reserved for future use. |
Text |
50 |
AE |
|
Emergency 2 Phone 1 |
Always Blank. Reserved for future use. |
Text |
12 |
AF |
|
Emergency 2 Phone 2 |
Always Blank. Reserved for future use. |
Text |
12 |
AG |
| Status |
Patient Status
|
Text | 50 | AH |
| Start of Care Date | Format: YYYY-MM-DD | Date | 10 | AI |
| Discharge Date | Format: YYYY-MM-DD | Date | 10 | AJ |
| Payer Coordinator | Always Blank. Reserved for future use. | Text | 100 | AK |
| Agency Coordinator | Always Blank. Reserved for future use. | Text | 100 | AL |
| Frequency | Always Blank. Reserved for future use. | Text | 50 | AM |
| Source of Admission | Always Blank. Reserved for future use. | Text | 50 | AN |
| Location | Always Blank. Reserved for future use. | Text | 100 | AO |
| Team | Always Blank. Reserved for future use. | Text | 100 | AP |
| Branch | Always Blank. Reserved for future use. | Text | 100 | AQ |
| Modified Date | Modified/Created time in UTC Format: YYYY-MM-DD HH:MM:SS.MSS |
Date/Time |
25 | AR |
| Is Deletion | Always N. Reserved for future use. | Text | 1 | AS |
| Alternate Patient ID | Alternate Patient ID | Text | 50 | AT |
| User Field 1 | Patient County | Text | 50 | AU |
| User Field 2 | Text | 500 | AV | |
| User Field 3 | Text | 500 | AW | |
| User Field 4 | Text | 500 | AX | |
| User Field 5 | Text | 500 | AY | |
| User Field 6 | Text | 500 | AZ | |
| User Field 7 | Text | 500 | BA |
Creates a Patient Authorization Export file based on a flat file given in the following format.
Sample Template: Click Patient Authorization Export
Save the *.CSV file on your computer and Open the file using a text editor (such as Notepad) to preserve the formats for each field.
|
Field |
Description |
Data Type |
Max Length |
Cell |
|---|---|---|---|---|
|
Payer ID |
Unique ID of the Payer in HHAeXchange. |
Number |
10 |
A |
|
Agency Tax ID |
Unique ID of the Payer in HHAeXchange. |
Text |
10 |
B |
|
Patient ID |
Internal Unique ID of the Patient in HHAeXchange. |
Number |
10 |
C |
|
Authorization ID |
Unique ID of the Patient in HHAeXchange. |
Number |
10 |
D |
|
Admission ID |
Patient Admission ID. |
Text |
20 |
E |
|
Service Category |
Service category such as Home Health or any other valid service category. |
Text |
50 |
F |
| Service Type | Text | 50 | G | |
|
Authorization Number |
Authorization Number |
Text |
50 |
H |
|
Billing Service Code |
Billing Service Code |
Text |
50 |
I |
|
From Date |
Format: YYYY-MM-DD |
Date |
10 |
J |
|
To Date |
Format: YYYY-MM-DD |
Date |
10 |
K |
| Authorization Type |
Possible Values:
|
Text | 50 | L |
|
Hours Per Auth Period |
Applicable if Authorization Type is Entire Period |
Number |
10 |
O |
| Invoice Limit | Decimal | 6 | P | |
|
Notes |
Notes |
Text |
500 |
Q |
|
Modified Date |
Modified/Created time in UTC Format: YYYY-MM-DD HH:MM:SS.MSS |
Date/Time |
25 |
R |
|
Is Deletion |
Possible Values: Y (Yes) or N (No) |
Text |
1 |
S |
|
User Field 1 |
Text |
500 | T | |
|
User Field 2 |
Text |
500 | U | |
|
User Field 3 |
Text |
500 | V | |
|
User Field 4 |
Text |
500 | W | |
|
User Field 5 |
Text |
500 | X | |
|
User Field 6 |
Text |
500 | Y | |
|
User Field 7 |
Text |
500 |
Z |