Hovedflow

Mapping	Beskrivelse	Loadtype
SOURCE_DSAHIST_DUBU2_Benefit_Plan_Line_Items	Delsnitfladen SOURCE_DUBU2_Benefit_Plan_Line_Items indlæses til destinationstabellen DSAHIST_DUBU2_Benefit_Plan_Line_Items. Værdierne overføres direkte. Kildesystemet indlæser data som full extraction.	Full Load

Primær kilde og destination

Kildelag	Primær kilde tabel	FilterExpression på primær kildetabel	Destinationslag	Primær destinations tabel
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items		DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items

Forretningsregler

Kildelag	Kildetabel	Kolonne	Forretningsregel	Destinationslag	Destinationstabel	Kolonne
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Created	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Created
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	CAC_recalc_date	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	CAC_recalc_date
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Last_Upd_by_ID	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Last_Upd_by_ID
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Reason_alternative	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Reason_alternative
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Total_before_reimbursement_all_sibling	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Total_before_reimbursement_all_sibling
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Created_by_ID	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Created_by_ID
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Single_additional_cost_all_siblings_Total	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Single_additional_cost_all_siblings_Total
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Reimbursement_municipality	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Reimbursement_municipality
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	All_sibling_Additional_cost_Total	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	All_sibling_Additional_cost_Total
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Total_all_sibling	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Total_all_sibling
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Last_Upd	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Last_Upd
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Alternative	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Alternative
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Row_ID	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Row_ID
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Benefit_plan_ID	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Benefit_plan_ID
SOURCE	dbo.SOURCE_DUBU2_Benefit_Plan_Line_Items	Reimbursement_state	Værdien overføres direkte	DSAHIST	dbo.DSAHIST_DUBU2_Benefit_Plan_Line_Items	Reimbursement_state