(@P0 int,@P1 int,@P2 decimal(38,0),@P3 varchar(8000),@P4 varchar(8000),@P5 varchar(8000),@P6 datetime2(7),@P7 datetime2(7),@P8 varchar(8000),@P9 varchar(8000),@P10 varchar(8000),@P11 varchar(8000),@P12 varchar(8000),@P13 varchar(8000),@P14 varchar(8000),@P15 varchar(8000),@P16 varchar(8000),@P17 varchar(8000),@P18 varchar(8000),@P19 varchar(8000),@P20 int,@P21 varchar(8000),@P22 varchar(8000),@P23 datetime2(7),@P24 varchar(8000),@P25 int,@P26 varchar(8000),@P27 varchar(8000),@P28 int,@P29 int,@P30 int,@P31 int,@P32 int,@P33 int,@P34 int,@P35 int,@P36 int,@P37 int,@P38 int,@P39 varchar(8000),@P40 varchar(8000),@P41 int,@P42 varchar(8000),@P43 int,@P44 varchar(8000),@P45 int,@P46 varchar(8000),@P47 varchar(8000),@P48 varchar(8000),@P49 varchar(8000),@P50 varchar(8000),@P51 varchar(8000),@P52 varchar(8000),@P53 varchar(8000),@P54 varchar(8000),@P55 varchar(8000),@P56 int,@P57 varchar(8000),@P58 varchar(8000),@P59 varchar(8000),@P60 varchar(8000),@P61 varchar(8000),@P62 varchar(8000),@P63 varchar(8000),@P64 varchar(8000),@P65 varchar(8000),@P66 varchar(8000),@P67 varchar(8000),@P68 varchar(8000),@P69 float,@P70 float,@P71 varchar(8000),@P72 varchar(8000),@P73 varchar(8000),@P74 varchar(8000),@P75 varchar(8000),@P76 varchar(8000),@P77 float,@P78 float,@P79 date,@P80 varchar(8000),@P81 varchar(8000),@P82 int,@P83 int,@P84 varchar(8000),@P85 varchar(8000),@P86 varchar(8000),@P87 varchar(8000),@P88 varchar(8000),@P89 varchar(8000),@P90 varchar(8000),@P91 varchar(8000),@P92 varchar(8000),@P93 varchar(8000),@P94 varchar(8000),@P95 varchar(8000),@P96 varchar(8000),@P97 varchar(8000),@P98 int,@P99 int,@P100 varchar(8000),@P101 varchar(8000),@P102 varchar(8000),@P103 varchar(8000),@P104 varchar(8000),@P105 date,@P106 date,@P107 float,@P108 float,@P109 float,@P110 datetime2(7),@P111 bit,@P112 float,@P113 varchar(8000),@P114 varchar(8000),@P115 varchar(8000),@P116 float,@P117 int,@P118 int,@P119 int,@P120 varchar(8000),@P121 datetime2(7))INSERT INTO [DWH].[Person_Dim] ([Person_Key],[Person_Identity],[Banner_PIDM],[R_Number],[Person_Ref],[Person_ID],[Created],[Updated],[Student_type],[Full_Name],[Preferred_Name],[First_Name],[Middle_Name],[Last_Name],[Suffix],[Alias],[Email_Address],[Phone_Daytime],[Phone_Mobile],[Phone_Evening],[Gender_Key],[Gender_Description],[Gender_Detail],[Birth_Date],[Race],[RaceEthnicity_Key],[RaceEthnicity_Description],[IPEDS_Classification],[Hispanic_Ind],[Am_Indian_or_Alaska_Native_Ind],[Asian_Ind],[Black_or_African_American_Ind],[Pacific_Islands_American_Ind],[White_Ind],[Non_Resident_Alien_Ind],[Two_Or_More_Races_Ind],[Unknown_Race_Ethnicity_Ind],[Minority_Ind],[Citizenship_Key],[Citizenship],[Citizenship_Description],[US_Citizenship_Ind],[Citizenship_Primary],[Citizenship_Secondary_Key],[Citizenship_Secondary],[Dual_Citizen_Ind],[Permanent_Address_Street_Line1],[Permanent_Address_Street_Line2],[Permanent_Address_Street_Line3],[Permanent_Address_City],[Permanent_Address_State_Province],[Permanent_Address_Postal_Code],[Permanent_Address_County],[Permanent_Address_Country],[Permanent_Address_Geomarket],[Permanent_Address_Continent],[Resident_Address_Location_Key],[Resident_Address_Street_Line1],[Resident_Address_Street_Line2],[Resident_Address_Street_Line3],[Resident_Address_City],[Resident_Address_State_Province],[Resident_Address_Postal_Code],[Resident_Address_County],[Resident_Address_Country],[Resident_Address_Geomarket],[Resident_Address_Continent],[Person_Status],[Affinity_Assessment],[Affinity_Score],[Affinity_Average],[RNL_Applicant_Score],[RNL_Applicant_Score_At_Read],[Personicx_Code],[Personicx_Life_Stage_Group],[Personicx_Cluster],[Personicx_Life_Stage_Group_Description],[Average_Household_Income],[Miles_From_Rollins],[First_Contact_Date],[First_Contact_Summary],[First_Contact_Category],[Permanent_Address_Location_Key],[Active_Address_Location_Key],[Active_Address_Street_Line1],[Active_Address_Street_Line2],[Active_Address_Street_Line3],[Active_Address_City],[Active_Address_County],[Active_Address_State_Province],[Active_Address_Postal_Code],[Active_Address_US_5_Digit_Zip_Code],[Active_Address_US_4_Digit_Zip_Code],[Active_Address_Country],[Active_Address_Geomarket],[Active_Address_Continent],[Active_Address_ISO_2_Digit_Country_Code],[Active_Address_ISO_3_Digit_Country_Code],[Florida_Ind_By_Perm_Address],[Florida_Ind_By_High_School],[Sub_Region_High_School],[Geo_Region_High_School],[High_School_Type],[High_School_Code],[High_School_Institution],[High_School_From],[High_School_To],[High_School_GPA],[High_School_GPA_Recalculated],[High_School_GPA_Scale],[High_School_Degree_Conferred],[High_School_Confirmed],[High_School_GPA_Converted],[High_School_City],[High_School_Region],[High_School_Country],[High_School_Hours],[High_School_Class_Rank_Numeric],[High_School_Class_Size],[International_Ind],[College_Source_Key],[ETL_Timestamp]) VALUES (@P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19,@P20,@P21,@P22,@P23,@P24,@P25,@P26,@P27,@P28,@P29,@P30,@P31,@P32,@P33,@P34,@P35,@P36,@P37,@P38,@P39,@P40,@P41,@P42,@P43,@P44,@P45,@P46,@P47,@P48,@P49,@P50,@P51,@P52,@P53,@P54,@P55,@P56,@P57,@P58,@P59,@P60,@P61,@P62,@P63,@P64,@P65,@P66,@P67,@P68,@P69,@P70,@P71,@P72,@P73,@P74,@P75,@P76,@P77,@P78,@P79,@P80,@P81,@P82,@P83,@P84,@P85,@P86,@P87,@P88,@P89,@P90,@P91,@P92,@P93,@P94,@P95,@P96,@P97,@P98,@P99,@P100,@P101,@P102,@P103,@P104,@P105,@P106,@P107,@P108,@P109,@P110,@P111,@P112,@P113,@P114,@P115,@P116,@P117,@P118,@P119,@P120,@P121)