Relational Data Files

AttributeList

File Name: AttributeList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/AttributeList.zip

This is a list of all amenity and short policy data. It is broken down by type. The possible types are PropertyAmenity, RoomAmenity and Policy. Policy is further broken down by Pet, CheckInOut, Payment and Other policies. Each Attribute is mapped to a property in the PropertyAttributeLink file.

Attribute Name Base Data Type (Length)
AttributeID int
LanguageCode nvarchar(5)
AttributeDesc nvarchar(255)
Type nvarchar(15)
SubType nvarchar(15)

AttributeList Multi-Language

File Name: AttributeList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/AttributeList_xx_XX.zip

This file holds all non-English language translations for the records located in the AttributeList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
AttributeID int
LanguageCode nvarchar(5)
AttributeDesc nvarchar(255)

PropertyAttributeLink

File Name: PropertyAttributeLink.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyAttributeLink.zip

This file links an attribute to an ESR property and also holds any additional information for that attribute that is property specific. For instance, the attribute NumberOfRooms will have a different value for each property. That value is held in the AppendTxt field of this file.

Attribute Name Base Data Type (Length)
EANHotelID int
AttributeID int
LanguageCode nvarchar(5)
AppendTxt nvarchar(800)

PropertyAttributeLink Multi-Language

File Name: PropertyAttributeLink_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyAttributeLink_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyAttributelink file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
AttributeID int
LanguageCode nvarchar(5)
AppendTxt nvarchar(800)