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

Patient Demographic Export Closed

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 Waiting Pending Active Hospitalized Discharged Hold	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

Patient Authorization Export Closed

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: Entire Period	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