Internal Data Mapping - Several Sources Target Table

In the case of the Excursions data mapping, we have to map data from several distinct tables into the same target table: Standard Excursions, Bookable Excursions go into the same Excursions Definition target table, Wait List Excursions and Pre-Paid Excursions go into the same Excursions target table. To have an application inserting new records when the source table changes, you add a Group Element in to the source section mapping, you assign the source base on the source and target table relation, you must be extremely cautious when assigning the group since there is not any pattern in the application that helps you to detect any wrong group assignation. This table shows you all the pre-defined groups that exist in the application and their related value that is inserted in the Groups column.

Table 15-1 Excursions Data Mapping

Group	DefaultValue	Group	Default Value
ADDRESS_GUEST	D	TRAVEL_AGENT	T
ADDRESS_GUEST_PREVUSA	Z	TRAVEL_DOC_PASSPORT	P
ADDRESS_GUEST_POSTUSA	Y	TRAVEL_DOC_ALIEN_RESIDENT_ID	V
ADDRESS_GROUPS	G	TRAVEL_DOC_VISAS	V
ADDRESS_BILLING	B	Other Groups	R
EMERGENCY_CONTACT	E	AMENITY_DEF SPECIAL_RQST_DEF	S

Excursion Groups

Table 15-2 Excursion Groups

Excursions Groups	DefaultValue	Group	Default Value
EXCUR_WAIT_LIST	WL	PAX_TO_AIR1	AA
EXCUR_STND	STD	PAX_TO_AIR3	AA
EXCUR_PRE_PAID	PP	PAX_FROM_AIR5	AA
EXCUR_BOK	BOK	PAX_FROM_AIR7	AA
		PAX_FROM_AIR9
		PAX_TO_AIR
		PAX_TO_AIR2
		PAX_TO_AIR4
		PAX_FROM_AIR6
		PAX_FROM_AIR8