20220105 13540900 1.0 FALSE JoinFeatures iCare_ALL_CompositeLocator_9 C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\iCare_ALL_CompositeLocator_SummarizeAttributes_ID C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join "Join one to one" # # # # "USER_PATIENT_ID USER_PATIENT_ID" # # # FeatureClassToFeatureClass C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb Shot1Joined # "USER_PATIENT_ID "PATIENT_ID" true true false 8 Long 0 0,First,#,\\gisfile\GISstaff\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join,USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,\\gisfile\GISstaff\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join,USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join,USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,\\gisfile\GISstaff\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join,USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,\\gisfile\GISstaff\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join,USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,\\gisfile\GISstaff\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join,USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,\\gisfile\GISstaff\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Shot1Join,USER_PROVIDER_COVID_PIN,0,10485758" # FeatureClassToFeatureClass Shot1Joined_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_and_2 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,Shot1Joined_Layer,Shot1Joined.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,Shot1Joined_Layer,Shot1Joined.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,Shot1Joined_Layer,Shot1Joined.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot1Joined.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot1Joined.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot1Joined.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot1Joined.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,Shot1Joined_Layer,Shot2Joined.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,Shot1Joined_Layer,Shot2Joined.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot2Joined.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot2Joined.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot2Joined.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,Shot1Joined_Layer,Shot2Joined.USER_PROVIDER_COVID_PIN,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_and_2_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_2_and_3 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,SHOT_Join_1_and_2.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_and_2_Layer1,Shot3Joined.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_and_2_Layer1,Shot3Joined.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,Shot3Joined.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,Shot3Joined.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,Shot3Joined.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_and_2_Layer1,Shot3Joined.USER_PROVIDER_COVID_PIN3,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_2_and_3_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_2_3_and_4 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,SHOT_Join_1_2_and_3.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_and_3_Layer,Shot4Joined.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_and_3_Layer,Shot4Joined.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,Shot4Joined.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,Shot4Joined.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,Shot4Joined.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_and_3_Layer,Shot4Joined.USER_PROVIDER_COVID_PIN4,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_2_3_and_4_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_thru_5 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,SHOT_Join_1_2_3_and_4.USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,Shot5Joined.USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,Shot5Joined.USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,Shot5Joined.USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,Shot5Joined.USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,Shot5Joined.USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_2_3_and_4_Layer,Shot5Joined.USER_PROVIDER_COVID_PIN5,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_thru_5_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_thru_6 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,SHOT_Join_1_thru_5.USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_5_Layer,Shot4Joined.USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_5_Layer,Shot4Joined.USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,Shot4Joined.USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,Shot4Joined.USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,Shot4Joined.USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_5_Layer,Shot4Joined.USER_PROVIDER_COVID_PIN6,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_thru_6_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_thru_7 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,SHOT_Join_1_thru_6.USER_PROVIDER_COVID_PIN6,0,10485758;USER_SHOT_DATE7 "7th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_6_Layer,Shot7Joined.USER_SHOT_DATE7,-1,-1;USER_SHOT_DOSE7 "7th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_6_Layer,Shot7Joined.USER_SHOT_DOSE7,-1,-1;USER_SHOT_VACCINE7 "7th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,Shot7Joined.USER_SHOT_VACCINE7,0,10485758;USER_SHOT_LOT_NUMBER7 "7th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,Shot7Joined.USER_SHOT_LOT_NUMBER7,0,10485758;USER_COVID_COMPLETE7 "7th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,Shot7Joined.USER_COVID_COMPLETE7,0,10485758;USER_PROVIDER_COVID_PIN7 "7th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_6_Layer,Shot7Joined.USER_PROVIDER_COVID_PIN7,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_thru_7_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_thru_8 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PROVIDER_COVID_PIN6,0,10485758;USER_SHOT_DATE7 "7th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DATE7,-1,-1;USER_SHOT_DOSE7 "7th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_DOSE7,-1,-1;USER_SHOT_VACCINE7 "7th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_VACCINE7,0,10485758;USER_SHOT_LOT_NUMBER7 "7th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_SHOT_LOT_NUMBER7,0,10485758;USER_COVID_COMPLETE7 "7th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_COVID_COMPLETE7,0,10485758;USER_PROVIDER_COVID_PIN7 "7th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,SHOT_Join_1_thru_7.USER_PROVIDER_COVID_PIN7,0,10485758;USER_SHOT_DATE8 "8th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_7_Layer,Shot8Joined.USER_SHOT_DATE8,-1,-1;USER_SHOT_DOSE8 "8th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_7_Layer,Shot8Joined.USER_SHOT_DOSE8,-1,-1;USER_SHOT_VACCINE8 "8th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,Shot8Joined.USER_SHOT_VACCINE8,0,10485758;USER_SHOT_LOT_NUMBER8 "8th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,Shot8Joined.USER_SHOT_LOT_NUMBER8,0,10485758;USER_COVID_COMPLETE8 "8th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,Shot8Joined.USER_COVID_COMPLETE8,0,10485758;USER_PROVIDER_COVID_PIN8 "8th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_7_Layer,Shot8Joined.USER_PROVIDER_COVID_PIN8,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_thru_8_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_thru_9 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PATIENT_ID,-1,-1;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN6,0,10485758;USER_SHOT_DATE7 "7th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE7,-1,-1;USER_SHOT_DOSE7 "7th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE7,-1,-1;USER_SHOT_VACCINE7 "7th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE7,0,10485758;USER_SHOT_LOT_NUMBER7 "7th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER7,0,10485758;USER_COVID_COMPLETE7 "7th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE7,0,10485758;USER_PROVIDER_COVID_PIN7 "7th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN7,0,10485758;USER_SHOT_DATE8 "8th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DATE8,-1,-1;USER_SHOT_DOSE8 "8th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_DOSE8,-1,-1;USER_SHOT_VACCINE8 "8th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_VACCINE8,0,10485758;USER_SHOT_LOT_NUMBER8 "8th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_SHOT_LOT_NUMBER8,0,10485758;USER_COVID_COMPLETE8 "8th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_COVID_COMPLETE8,0,10485758;USER_PROVIDER_COVID_PIN8 "8th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,SHOT_Join_1_thru_8.USER_PROVIDER_COVID_PIN8,0,10485758;USER_SHOT_DATE9 "9th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_8_Layer,Shot9Joined.USER_SHOT_DATE9,-1,-1;USER_SHOT_DOSE9 "9th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_8_Layer,Shot9Joined.USER_SHOT_DOSE9,-1,-1;USER_SHOT_VACCINE9 "9th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,Shot9Joined.USER_SHOT_VACCINE9,0,10485758;USER_SHOT_LOT_NUMBER9 "9th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,Shot9Joined.USER_SHOT_LOT_NUMBER9,0,10485758;USER_COVID_COMPLETE9 "9th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,Shot9Joined.USER_COVID_COMPLETE9,0,10485758;USER_PROVIDER_COVID_PIN9 "9th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_8_Layer,Shot9Joined.USER_PROVIDER_COVID_PIN9,0,10485758" # FeatureClassToFeatureClass SHOT_Join_1_thru_9_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb SHOT_Join_1_thru_10 # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PATIENT_ID,-1,-1;COVID_VACCINATION_STATUS "Vaccination Status" true true false 40 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.COVID_VACCINATION_STATUS,0,40;TEAM "Team" true true false 100 Text 0 0,First,#;IC_ADDITIONAL_SHOT_RECEIVED "IC Shot Received" true true false 5 Text 0 0,First,#;COVID_BOOSTED "Received A Booster" true true false 40 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.COVID_BOOSTED,0,40;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE "Eligible Additional Shot On After Date" true true false 40 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Additional Date" true true false 40 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.COVID_VALID_ADDITIONAL_SHOT_DATE,-1,-1;IC_ADDITIONAL_SHOT_ON_AFTER_DATE "Immunocompromised Valid Shot On or After Date" true true false 255 Date 0 0,First,#;LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE "Likely Immunocompromised Actual Eligible Shot Date" true true false 255 Date 0 0,First,#;BOOSTER_VALID_SHOT_ON_AFTER_DATE "Eligible Booster Shot On After Date" true true false 40 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.BOOSTER_VALID_SHOT_ON_AFTER_DATE,-1,-1;BOOSTER_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Booster Date" true true false 40 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.BOOSTER_VALID_ADDITIONAL_SHOT_DATE,-1,-1;USER_SHOT_DOSE "1st_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN6,0,10485758;USER_SHOT_DATE7 "7th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE7,-1,-1;USER_SHOT_DOSE7 "7th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE7,-1,-1;USER_SHOT_VACCINE7 "7th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE7,0,10485758;USER_SHOT_LOT_NUMBER7 "7th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER7,0,10485758;USER_COVID_COMPLETE7 "7th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE7,0,10485758;USER_PROVIDER_COVID_PIN7 "7th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN7,0,10485758;USER_SHOT_DATE8 "8th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE8,-1,-1;USER_SHOT_DOSE8 "8th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE8,-1,-1;USER_SHOT_VACCINE8 "8th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE8,0,10485758;USER_SHOT_LOT_NUMBER8 "8th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER8,0,10485758;USER_COVID_COMPLETE8 "8th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE8,0,10485758;USER_PROVIDER_COVID_PIN8 "8th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN8,0,10485758;USER_SHOT_DATE9 "9th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DATE9,-1,-1;USER_SHOT_DOSE9 "9th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_DOSE9,-1,-1;USER_SHOT_VACCINE9 "9th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_VACCINE9,0,10485758;USER_SHOT_LOT_NUMBER9 "9th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_SHOT_LOT_NUMBER9,0,10485758;USER_COVID_COMPLETE9 "9th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_COVID_COMPLETE9,0,10485758;USER_PROVIDER_COVID_PIN9 "9th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,SHOT_Join_1_thru_9.USER_PROVIDER_COVID_PIN9,0,10485758;USER_SHOT_DATE10 "10th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.USER_SHOT_DATE10,-1,-1;USER_SHOT_DOSE10 "10th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.USER_SHOT_DOSE10,-1,-1;USER_SHOT_VACCINE10 "10th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.USER_SHOT_VACCINE10,0,10485758;USER_SHOT_LOT_NUMBER10 "10th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.USER_SHOT_LOT_NUMBER10,0,10485758;USER_COVID_COMPLETE10 "10th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.USER_COVID_COMPLETE10,0,10485758;USER_PROVIDER_COVID_PIN10 "10th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_9_Layer,Shot10Joined.USER_PROVIDER_COVID_PIN10,0,10485758" # CalculateField C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\SHOT_Join_1_thru_10 COVID_VACCINATION_STATUS "First Dose Recieved" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE3! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE3! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer1 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer2 COVID_VACCINATION_STATUS "Complete (Single Dose)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer2 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 2, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer2 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE3! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer3 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE3! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes3" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes4" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes5" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes6" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes7" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes8" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes9" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 IC_ADDITIONAL_SHOT_RECEIVED "Yes10" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer4 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE3! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes3" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes4" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes5" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes6" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes7" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes8" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes9" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 BOOSTER_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer5 COVID_BOOSTED "Yes10" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE3! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 17, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer6 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE3! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 24, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VACCINATION_STATUS "Complete (Two Dose Series)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 COVID_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 IC_ADDITIONAL_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 28, 'days') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.COVID_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer7 TEAM !USER_SHOT_VACCINE2! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer8 COVID_VACCINATION_STATUS "Complete (Single Dose)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer8 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.USER_SHOT_DATE2, 2, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer8 TEAM !USER_SHOT_VACCINE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE4! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 IC_ADDITIONAL_SHOT_RECEIVED "Yes4" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE5! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 IC_ADDITIONAL_SHOT_RECEIVED "Yes5" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE6! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 IC_ADDITIONAL_SHOT_RECEIVED "Yes6" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE7! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 IC_ADDITIONAL_SHOT_RECEIVED "Yes7" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE8! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 IC_ADDITIONAL_SHOT_RECEIVED "Yes8" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE9! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 IC_ADDITIONAL_SHOT_RECEIVED "Yes9" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE !USER_SHOT_DATE10! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 IC_ADDITIONAL_SHOT_RECEIVED "Yes10" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SHOT_Join_1_thru_10_Layer9 BOOSTER_VALID_SHOT_ON_AFTER_DATE DateAdd($feature.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE, 6, 'months') Arcade # Text NO_ENFORCE_DOMAINS FeatureClassToFeatureClass SHOT_Join_1_thru_10_Layer C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb C19_Vacc_by_PID # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_ID,-1,-1;COVID_VACCINATION_STATUS "Vaccination Status" true true false 40 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.COVID_VACCINATION_STATUS,0,40;TEAM "Team" true true false 100 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.TEAM,0,100;IC_ADDITIONAL_SHOT_RECEIVED "IC Shot Received" true true false 5 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.IC_ADDITIONAL_SHOT_RECEIVED,0,5;COVID_BOOSTED "Received A Booster" true true false 40 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.COVID_BOOSTED,0,40;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE "Eligible Additional Shot On After Date" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Additional Date" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.COVID_VALID_ADDITIONAL_SHOT_DATE,-1,-1;IC_ADDITIONAL_SHOT_ON_AFTER_DATE "Immunocompromised Valid Shot On or After Date" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.IC_ADDITIONAL_SHOT_ON_AFTER_DATE,-1,-1;LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE "Likely Immunocompromised Actual Eligible Shot Date" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE,-1,-1;BOOSTER_VALID_SHOT_ON_AFTER_DATE "Eligible Booster Shot On After Date" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.BOOSTER_VALID_SHOT_ON_AFTER_DATE,-1,-1;BOOSTER_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Booster Date" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.BOOSTER_VALID_ADDITIONAL_SHOT_DATE,-1,-1;USER_SHOT_DOSE "1st_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN6,0,10485758;USER_SHOT_DATE7 "7th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE7,-1,-1;USER_SHOT_DOSE7 "7th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE7,-1,-1;USER_SHOT_VACCINE7 "7th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE7,0,10485758;USER_SHOT_LOT_NUMBER7 "7th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER7,0,10485758;USER_COVID_COMPLETE7 "7th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE7,0,10485758;USER_PROVIDER_COVID_PIN7 "7th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN7,0,10485758;USER_SHOT_DATE8 "8th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE8,-1,-1;USER_SHOT_DOSE8 "8th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE8,-1,-1;USER_SHOT_VACCINE8 "8th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE8,0,10485758;USER_SHOT_LOT_NUMBER8 "8th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER8,0,10485758;USER_COVID_COMPLETE8 "8th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE8,0,10485758;USER_PROVIDER_COVID_PIN8 "8th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN8,0,10485758;USER_SHOT_DATE9 "9th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE9,-1,-1;USER_SHOT_DOSE9 "9th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE9,-1,-1;USER_SHOT_VACCINE9 "9th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE9,0,10485758;USER_SHOT_LOT_NUMBER9 "9th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER9,0,10485758;USER_COVID_COMPLETE9 "9th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE9,0,10485758;USER_PROVIDER_COVID_PIN9 "9th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN9,0,10485758;USER_SHOT_DATE10 "10th_SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE10,-1,-1;USER_SHOT_DOSE10 "10th_SHOT_DOSE" true true false 4 Long 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE10,-1,-1;USER_SHOT_VACCINE10 "10th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE10,0,10485758;USER_SHOT_LOT_NUMBER10 "10th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER10,0,10485758;USER_COVID_COMPLETE10 "10th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE10,0,10485758;USER_PROVIDER_COVID_PIN10 "10th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN10,0,10485758;USER_PATIENT_NAME_LAST "PATIENT_NAME_LAST" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_NAME_LAST,0,255;USER_PATIENT_NAME_FIRST "PATIENT_NAME_FIRST" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_NAME_FIRST,0,255;USER_PATIENT_ID_1 "PATIENT_ID" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_ID_1,-1,-1;USER_PATIENT_BIRTH_DATE "PATIENT_BIRTH_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_BIRTH_DATE,-1,-1;USER_PATIENT_AGE_YEARS "PATIENT_AGE_YEARS" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_AGE_YEARS,-1,-1;USER_PATIENT_ADDRESS_1 "PATIENT_ADDRESS_1" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_ADDRESS_1,0,255;USER_PATIENT_ADDRESS_2 "PATIENT_ADDRESS_2" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_ADDRESS_2,0,255;USER_PATIENT_CITY "PATIENT_CITY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_CITY,0,255;USER_PATIENT_STATE "PATIENT_STATE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_STATE,0,255;USER_PATIENT_ZIP "PATIENT_ZIP" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_ZIP,-1,-1;USER_PATIENT_COUNTY "PATIENT_COUNTY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_COUNTY,0,255;USER_PATIENT_GENDER "PATIENT_GENDER" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_GENDER,0,255;USER_PATIENT_RACE "PATIENT_RACE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_RACE,0,255;USER_PATIENT_ETHNICITY "PATIENT_ETHNICITY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PATIENT_ETHNICITY,0,255;USER_SHOT_DATE_1 "SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DATE_1,-1,-1;USER_SHOT_DOSE_1 "SHOT_DOSE" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_DOSE_1,-1,-1;USER_SHOT_VACCINE_1 "SHOT_VACCINE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_VACCINE_1,0,255;USER_SHOT_LOT_NUMBER_1 "SHOT_LOT_NUMBER" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_SHOT_LOT_NUMBER_1,0,255;USER_COVID_COMPLETE_1 "COVID_COMPLETE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_COVID_COMPLETE_1,0,255;USER_PROVIDER_COVID_PIN_1 "PROVIDER_COVID_PIN" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_COVID_PIN_1,0,255;USER_PROVIDER_SITE "PROVIDER_SITE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_SITE,0,255;USER_PROVIDER_CITY "PROVIDER_CITY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_CITY,0,255;USER_PROVIDER_STATE "PROVIDER_STATE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,SHOT_Join_1_thru_10.USER_PROVIDER_STATE,0,255;USER_PATIENT_NAME_LAST "PATIENT_NAME_LAST" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_NAME_LAST,0,255;USER_PATIENT_NAME_FIRST "PATIENT_NAME_FIRST" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_NAME_FIRST,0,255;USER_PATIENT_ID "PATIENT_ID" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_ID,-1,-1;USER_PATIENT_BIRTH_DATE "PATIENT_BIRTH_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_BIRTH_DATE,-1,-1;USER_PATIENT_AGE_YEARS "PATIENT_AGE_YEARS" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_AGE_YEARS,-1,-1;USER_PATIENT_ADDRESS_1 "PATIENT_ADDRESS_1" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_ADDRESS_1,0,255;USER_PATIENT_ADDRESS_2 "PATIENT_ADDRESS_2" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_ADDRESS_2,0,255;USER_PATIENT_CITY "PATIENT_CITY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_CITY,0,255;USER_PATIENT_STATE "PATIENT_STATE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_STATE,0,255;USER_PATIENT_ZIP "PATIENT_ZIP" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_ZIP,-1,-1;USER_PATIENT_COUNTY "PATIENT_COUNTY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_COUNTY,0,255;USER_PATIENT_GENDER "PATIENT_GENDER" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_GENDER,0,255;USER_PATIENT_RACE "PATIENT_RACE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_RACE,0,255;USER_PATIENT_ETHNICITY "PATIENT_ETHNICITY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PATIENT_ETHNICITY,0,255;USER_SHOT_DATE "SHOT_DATE" true true false 8 Date 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_SHOT_DATE,-1,-1;USER_SHOT_DOSE "SHOT_DOSE" true true false 8 Double 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_SHOT_VACCINE,0,255;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_SHOT_LOT_NUMBER,0,255;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_COVID_COMPLETE,0,255;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PROVIDER_COVID_PIN,0,255;USER_PROVIDER_SITE "PROVIDER_SITE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PROVIDER_SITE,0,255;USER_PROVIDER_CITY "PROVIDER_CITY" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PROVIDER_CITY,0,255;USER_PROVIDER_STATE "PROVIDER_STATE" true true false 255 Text 0 0,First,#,SHOT_Join_1_thru_10_Layer,iCare_ALL_CompositeLocator.USER_PROVIDER_STATE,0,255" # SpatialJoin C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID \\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID_SpatialJoin_StatsPrep "Join one to one" KEEP_ALL "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_ID,-1,-1;COVID_VACCINATION_STATUS "Vaccination Status" true true false 40 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,COVID_VACCINATION_STATUS,0,40;TEAM "Team" true true false 100 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,TEAM,0,100;IC_ADDITIONAL_SHOT_RECEIVED "IC Shot Received" true true false 5 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,IC_ADDITIONAL_SHOT_RECEIVED,0,5;COVID_BOOSTED "Received A Booster" true true false 40 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,COVID_BOOSTED,0,40;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE "Eligible Additional Shot On After Date" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Additional Date" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,COVID_VALID_ADDITIONAL_SHOT_DATE,-1,-1;IC_ADDITIONAL_SHOT_ON_AFTER_DATE "Immunocompromised Valid Shot On or After Date" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,IC_ADDITIONAL_SHOT_ON_AFTER_DATE,-1,-1;LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE "Likely Immunocompromised Actual Eligible Shot Date" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE,-1,-1;BOOSTER_VALID_SHOT_ON_AFTER_DATE "Eligible Booster Shot On After Date" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,BOOSTER_VALID_SHOT_ON_AFTER_DATE,-1,-1;BOOSTER_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Booster Date" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,BOOSTER_VALID_ADDITIONAL_SHOT_DATE,-1,-1;USER_SHOT_DOSE "1st_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN6,0,10485758;USER_SHOT_DATE7 "7th_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE7,-1,-1;USER_SHOT_DOSE7 "7th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE7,-1,-1;USER_SHOT_VACCINE7 "7th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE7,0,10485758;USER_SHOT_LOT_NUMBER7 "7th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER7,0,10485758;USER_COVID_COMPLETE7 "7th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE7,0,10485758;USER_PROVIDER_COVID_PIN7 "7th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN7,0,10485758;USER_SHOT_DATE8 "8th_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE8,-1,-1;USER_SHOT_DOSE8 "8th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE8,-1,-1;USER_SHOT_VACCINE8 "8th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE8,0,10485758;USER_SHOT_LOT_NUMBER8 "8th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER8,0,10485758;USER_COVID_COMPLETE8 "8th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE8,0,10485758;USER_PROVIDER_COVID_PIN8 "8th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN8,0,10485758;USER_SHOT_DATE9 "9th_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE9,-1,-1;USER_SHOT_DOSE9 "9th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE9,-1,-1;USER_SHOT_VACCINE9 "9th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE9,0,10485758;USER_SHOT_LOT_NUMBER9 "9th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER9,0,10485758;USER_COVID_COMPLETE9 "9th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE9,0,10485758;USER_PROVIDER_COVID_PIN9 "9th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN9,0,10485758;USER_SHOT_DATE10 "10th_SHOT_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DATE10,-1,-1;USER_SHOT_DOSE10 "10th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_DOSE10,-1,-1;USER_SHOT_VACCINE10 "10th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_VACCINE10,0,10485758;USER_SHOT_LOT_NUMBER10 "10th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_SHOT_LOT_NUMBER10,0,10485758;USER_COVID_COMPLETE10 "10th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_COVID_COMPLETE10,0,10485758;USER_PROVIDER_COVID_PIN10 "10th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_COVID_PIN10,0,10485758;USER_PATIENT_NAME_LAST "PATIENT_NAME_LAST" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_NAME_LAST,0,255;USER_PATIENT_NAME_FIRST "PATIENT_NAME_FIRST" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_NAME_FIRST,0,255;USER_PATIENT_ID_1 "PATIENT_ID" true true false 8 Double 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_ID_1,-1,-1;USER_PATIENT_BIRTH_DATE "PATIENT_BIRTH_DATE" true true false 8 Date 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_BIRTH_DATE,-1,-1;USER_PATIENT_AGE_YEARS "PATIENT_AGE_YEARS" true true false 8 Double 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_AGE_YEARS,-1,-1;USER_PATIENT_ADDRESS_1 "PATIENT_ADDRESS_1" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_ADDRESS_1,0,255;USER_PATIENT_ADDRESS_2 "PATIENT_ADDRESS_2" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_ADDRESS_2,0,255;USER_PATIENT_CITY "PATIENT_CITY" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_CITY,0,255;USER_PATIENT_STATE "PATIENT_STATE" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_STATE,0,255;USER_PATIENT_ZIP "PATIENT_ZIP" true true false 8 Double 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_ZIP,-1,-1;USER_PATIENT_COUNTY "PATIENT_COUNTY" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_COUNTY,0,255;USER_PATIENT_GENDER "PATIENT_GENDER" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_GENDER,0,255;USER_PATIENT_RACE "PATIENT_RACE" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_RACE,0,255;USER_PATIENT_ETHNICITY "PATIENT_ETHNICITY" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PATIENT_ETHNICITY,0,255;USER_PROVIDER_SITE "PROVIDER_SITE" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_SITE,0,255;USER_PROVIDER_CITY "PROVIDER_CITY" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_CITY,0,255;USER_PROVIDER_STATE "PROVIDER_STATE" true true false 255 Text 0 0,First,#,C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\C19_NewDashboard.gdb\C19_Vacc_by_PID,USER_PROVIDER_STATE,0,255;All_PercentVaccinated_FirstDose "All_PercentVaccinated_FirstDose" true true false 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,All_PercentVaccinated_FirstDose,-1,-1;All_JoinCount "All Total First Dose" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,All_JoinCount,-1,-1;TOTPOP_CY "2020 Total Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,TOTPOP_CY,-1,-1;Asian_PercentVaccinated_FirstDose "Asian Percent Vaccinated First Dose" true true false 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Asian_PercentVaccinated_FirstDose,-1,-1;Asian_JoinCount "Asian Total First Dose" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Asian_JoinCount,-1,-1;ASIAN_CY "2020 Asian Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,ASIAN_CY,-1,-1;Black_PercentVaccinated_FirstDose "Black_PercentVaccinated_FirstDose" true true false 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Black_PercentVaccinated_FirstDose,-1,-1;Black_JoinCount "Black Total First Dose" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Black_JoinCount,-1,-1;BLACK_CY "2020 Black/African American Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,BLACK_CY,-1,-1;Hispanic_PercentVaccinated_FirstDose "Hispanic Percent Vaccinated First Dose" true true false 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Hispanic_PercentVaccinated_FirstDose,-1,-1;Hispanic_JoinCount "Hispanic Total First Dose" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Hispanic_JoinCount,-1,-1;HISPPOP_CY "2020 Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPPOP_CY,-1,-1;White_PercentVaccinated_FirstDose "White Percent Vaccinated First Dose" true true false 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,White_PercentVaccinated_FirstDose,-1,-1;White_JoinCount "White Total First Dose" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,White_JoinCount,-1,-1;WHITE_CY "2020 White Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,WHITE_CY,-1,-1;FID_L2Block_Group "FID_L2Block_Group" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,FID_L2Block_Group,-1,-1;ID "ID" true true false 12 Text 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,ID,0,12;NAME "NAME" true true false 13 Text 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NAME,0,13;STATE_NAME "STATE_NAME" true true false 20 Text 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,STATE_NAME,0,20;ST_ABBREV "ST_ABBREV" true true false 2 Text 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,ST_ABBREV,0,2;HHPOP_CY "2020 Household Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HHPOP_CY,-1,-1;FAMPOP_CY "2020 Family Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,FAMPOP_CY,-1,-1;GQPOP_CY "2020 Group Quarters Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,GQPOP_CY,-1,-1;POPDENS_CY "2020 Population Density (Pop per Square Mile) (Esri)" true true false 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,POPDENS_CY,-1,-1;TOTHH_CY "2020 Total Households (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,TOTHH_CY,-1,-1;AMERIND_CY "2020 American Indian/Alaska Native Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,AMERIND_CY,-1,-1;PACIFIC_CY "2020 Pacific Islander Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,PACIFIC_CY,-1,-1;OTHRACE_CY "2020 Other Race Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,OTHRACE_CY,-1,-1;RACE2UP_CY "2020 Population of Two or More Races (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,RACE2UP_CY,-1,-1;HISPWHT_CY "2020 Hispanic White Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPWHT_CY,-1,-1;HISPBLK_CY "2020 Hispanic Black/African American Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPBLK_CY,-1,-1;HISPAI_CY "2020 Hispanic American Indian/Alaska Native Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPAI_CY,-1,-1;HISPASN_CY "2020 Hispanic Asian Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPASN_CY,-1,-1;HISPPI_CY "2020 Hispanic Pacific Islander Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPPI_CY,-1,-1;HISPOTH_CY "2020 Hispanic Other Race Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPOTH_CY,-1,-1;HISPMLT_CY "2020 Hispanic Population of Two or More Races (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,HISPMLT_CY,-1,-1;NONHISP_CY "2020 Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NONHISP_CY,-1,-1;NHSPWHT_CY "2020 White Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NHSPWHT_CY,-1,-1;NHSPBLK_CY "2020 Black/African American Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NHSPBLK_CY,-1,-1;NHSPAI_CY "2020 American Indian/Alaska Native Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NHSPAI_CY,-1,-1;NHSPASN_CY "2020 Asian Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NHSPASN_CY,-1,-1;NHSPPI_CY "2020 Pacific Islander Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NHSPPI_CY,-1,-1;NHSPOTH_CY "2020 Other Race Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NHSPOTH_CY,-1,-1;NHSPMLT_CY "2020 Multiple Races Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,NHSPMLT_CY,-1,-1;MINORITYCY "2020 Minority Population (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,MINORITYCY,-1,-1;DIVINDX_CY "2020 Diversity Index (Esri)" true true false 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,DIVINDX_CY,-1,-1;RACEBASECY "2020 Population by Race Base (Esri)" true true false 4 Long 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,RACEBASECY,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,\\gisfile\GISstaff\Projects\Covid19\MasterFiles\BlkGrpMapping.gdb\Blckgrp2020_PopbyRace,Shape_Area,-1,-1" "Completely within" # # FeatureClassToFeatureClass C19_Vacc_by_PID_SpatialJoin_StatsPrep "C:\Users\rcolwell\Documents\ArcGIS\Projects\C19_NewDashboard\gisadmin_to_gissql01 (1).sde\gisedit.DBO.Covid19" C19_Vacc_by_PID_SpatialJoin_StatsPrep # "USER_PATIENT_ID "PATIENT_ID" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_ID,-1,-1;COVID_VACCINATION_STATUS "Vaccination Status" true true false 40 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,COVID_VACCINATION_STATUS,0,40;TEAM "Team" true true false 100 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,TEAM,0,100;IC_ADDITIONAL_SHOT_RECEIVED "IC Shot Received" true true false 5 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,IC_ADDITIONAL_SHOT_RECEIVED,0,5;COVID_BOOSTED "Received A Booster" true true false 40 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,COVID_BOOSTED,0,40;USER_SHOT_DATE "1st_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE "Eligible Additional Shot On After Date" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,COVID_VALID_ADDITIONAL_SHOT_ON_AFTER_DATE,-1,-1;COVID_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Additional Date" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,COVID_VALID_ADDITIONAL_SHOT_DATE,-1,-1;IC_ADDITIONAL_SHOT_ON_AFTER_DATE "Immunocompromised Valid Shot On or After Date" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,IC_ADDITIONAL_SHOT_ON_AFTER_DATE,-1,-1;LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE "Likely Immunocompromised Actual Eligible Shot Date" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,LIKELY_IC_VALID_ADDITIONAL_SHOT_DATE,-1,-1;BOOSTER_VALID_SHOT_ON_AFTER_DATE "Eligible Booster Shot On After Date" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,BOOSTER_VALID_SHOT_ON_AFTER_DATE,-1,-1;BOOSTER_VALID_ADDITIONAL_SHOT_DATE "Actual Eligible Booster Date" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,BOOSTER_VALID_ADDITIONAL_SHOT_DATE,-1,-1;USER_SHOT_DOSE "1st_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE,-1,-1;USER_SHOT_VACCINE "SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE,0,10485758;USER_SHOT_LOT_NUMBER "SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER,0,10485758;USER_COVID_COMPLETE "COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE,0,10485758;USER_PROVIDER_COVID_PIN "PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN,0,10485758;USER_SHOT_DATE2 "2nd_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE2,-1,-1;USER_SHOT_DOSE2 "2nd_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE2,-1,-1;USER_SHOT_VACCINE2 "2nd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE2,0,10485758;USER_SHOT_LOT_NUMBER2 "2nd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER2,0,10485758;USER_COVID_COMPLETE2 "2nd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE2,0,10485758;USER_PROVIDER_COVID_PIN2 "2nd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN2,0,10485758;USER_SHOT_DATE3 "3rd_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE3,-1,-1;USER_SHOT_DOSE3 "3rd_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE3,-1,-1;USER_SHOT_VACCINE3 "3rd_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE3,0,10485758;USER_SHOT_LOT_NUMBER3 "3rd_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER3,0,10485758;USER_COVID_COMPLETE3 "3rd_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE3,0,10485758;USER_PROVIDER_COVID_PIN3 "3rd_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN3,0,10485758;USER_SHOT_DATE4 "4th_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE4,-1,-1;USER_SHOT_DOSE4 "4th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE4,-1,-1;USER_SHOT_VACCINE4 "4th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE4,0,10485758;USER_SHOT_LOT_NUMBER4 "4th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER4,0,10485758;USER_COVID_COMPLETE4 "4th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE4,0,10485758;USER_PROVIDER_COVID_PIN4 "4th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN4,0,10485758;USER_SHOT_DATE5 "5th_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE5,-1,-1;USER_SHOT_DOSE5 "5th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE5,-1,-1;USER_SHOT_VACCINE5 "5th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE5,0,10485758;USER_SHOT_LOT_NUMBER5 "5th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER5,0,10485758;USER_COVID_COMPLETE5 "5th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE5,0,10485758;USER_PROVIDER_COVID_PIN5 "5th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN5,0,10485758;USER_SHOT_DATE6 "6th_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE6,-1,-1;USER_SHOT_DOSE6 "6th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE6,-1,-1;USER_SHOT_VACCINE6 "6th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE6,0,10485758;USER_SHOT_LOT_NUMBER6 "6th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER6,0,10485758;USER_COVID_COMPLETE6 "6th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE6,0,10485758;USER_PROVIDER_COVID_PIN6 "6th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN6,0,10485758;USER_SHOT_DATE7 "7th_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE7,-1,-1;USER_SHOT_DOSE7 "7th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE7,-1,-1;USER_SHOT_VACCINE7 "7th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE7,0,10485758;USER_SHOT_LOT_NUMBER7 "7th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER7,0,10485758;USER_COVID_COMPLETE7 "7th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE7,0,10485758;USER_PROVIDER_COVID_PIN7 "7th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN7,0,10485758;USER_SHOT_DATE8 "8th_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE8,-1,-1;USER_SHOT_DOSE8 "8th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE8,-1,-1;USER_SHOT_VACCINE8 "8th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE8,0,10485758;USER_SHOT_LOT_NUMBER8 "8th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER8,0,10485758;USER_COVID_COMPLETE8 "8th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE8,0,10485758;USER_PROVIDER_COVID_PIN8 "8th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN8,0,10485758;USER_SHOT_DATE9 "9th_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE9,-1,-1;USER_SHOT_DOSE9 "9th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE9,-1,-1;USER_SHOT_VACCINE9 "9th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE9,0,10485758;USER_SHOT_LOT_NUMBER9 "9th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER9,0,10485758;USER_COVID_COMPLETE9 "9th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE9,0,10485758;USER_PROVIDER_COVID_PIN9 "9th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN9,0,10485758;USER_SHOT_DATE10 "10th_SHOT_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DATE10,-1,-1;USER_SHOT_DOSE10 "10th_SHOT_DOSE" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_DOSE10,-1,-1;USER_SHOT_VACCINE10 "10th_SHOT_VACCINE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_VACCINE10,0,10485758;USER_SHOT_LOT_NUMBER10 "10th_SHOT_LOT_NUMBER" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_SHOT_LOT_NUMBER10,0,10485758;USER_COVID_COMPLETE10 "10th_COVID_COMPLETE" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_COVID_COMPLETE10,0,10485758;USER_PROVIDER_COVID_PIN10 "10th_PROVIDER_COVID_PIN" true true false 10485758 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_COVID_PIN10,0,10485758;USER_PATIENT_NAME_LAST "PATIENT_NAME_LAST" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_NAME_LAST,0,255;USER_PATIENT_NAME_FIRST "PATIENT_NAME_FIRST" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_NAME_FIRST,0,255;USER_PATIENT_ID_1 "PATIENT_ID" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_ID_1,-1,-1;USER_PATIENT_BIRTH_DATE "PATIENT_BIRTH_DATE" true true false 8 Date 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_BIRTH_DATE,-1,-1;USER_PATIENT_AGE_YEARS "PATIENT_AGE_YEARS" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_AGE_YEARS,-1,-1;USER_PATIENT_ADDRESS_1 "PATIENT_ADDRESS_1" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_ADDRESS_1,0,255;USER_PATIENT_ADDRESS_2 "PATIENT_ADDRESS_2" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_ADDRESS_2,0,255;USER_PATIENT_CITY "PATIENT_CITY" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_CITY,0,255;USER_PATIENT_STATE "PATIENT_STATE" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_STATE,0,255;USER_PATIENT_ZIP "PATIENT_ZIP" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_ZIP,-1,-1;USER_PATIENT_COUNTY "PATIENT_COUNTY" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_COUNTY,0,255;USER_PATIENT_GENDER "PATIENT_GENDER" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_GENDER,0,255;USER_PATIENT_RACE "PATIENT_RACE" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_RACE,0,255;USER_PATIENT_ETHNICITY "PATIENT_ETHNICITY" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PATIENT_ETHNICITY,0,255;USER_PROVIDER_SITE "PROVIDER_SITE" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_SITE,0,255;USER_PROVIDER_CITY "PROVIDER_CITY" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_CITY,0,255;USER_PROVIDER_STATE "PROVIDER_STATE" true true false 255 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,USER_PROVIDER_STATE,0,255;All_PercentVaccinated_FirstDose "All_PercentVaccinated_FirstDose" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,All_PercentVaccinated_FirstDose,-1,-1;All_JoinCount "All Total First Dose" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,All_JoinCount,-1,-1;TOTPOP_CY "2020 Total Population (Esri)" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,TOTPOP_CY,-1,-1;Asian_PercentVaccinated_FirstDose "Asian Percent Vaccinated First Dose" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,Asian_PercentVaccinated_FirstDose,-1,-1;Asian_JoinCount "Asian Total First Dose" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,Asian_JoinCount,-1,-1;ASIAN_CY "2020 Asian Population (Esri)" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,ASIAN_CY,-1,-1;Black_PercentVaccinated_FirstDose "Black_PercentVaccinated_FirstDose" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,Black_PercentVaccinated_FirstDose,-1,-1;Black_JoinCount "Black Total First Dose" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,Black_JoinCount,-1,-1;BLACK_CY "2020 Black/African American Population (Esri)" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,BLACK_CY,-1,-1;Hispanic_PercentVaccinated_FirstDose "Hispanic Percent Vaccinated First Dose" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,Hispanic_PercentVaccinated_FirstDose,-1,-1;Hispanic_JoinCount "Hispanic Total First Dose" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,Hispanic_JoinCount,-1,-1;HISPPOP_CY "2020 Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,HISPPOP_CY,-1,-1;White_PercentVaccinated_FirstDose "White Percent Vaccinated First Dose" true true false 8 Double 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,White_PercentVaccinated_FirstDose,-1,-1;White_JoinCount "White Total First Dose" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,White_JoinCount,-1,-1;WHITE_CY "2020 White Population (Esri)" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,WHITE_CY,-1,-1;FID_L2Block_Group "FID_L2Block_Group" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,FID_L2Block_Group,-1,-1;ID "ID" true true false 12 Text 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,ID,0,12;NONHISP_CY "2020 Non-Hispanic Population (Esri)" true true false 4 Long 0 0,First,#,C19_Vacc_by_PID_SpatialJoin_StatsPrep,NONHISP_CY,-1,-1" # gisedit.DBO.C19_Vacc_by_PID_SpatialJoin_StatsPrep 002 Server=gissql01; Service=sde:sqlserver:gissql01; Database=gisedit; User=gisadmin; Version=dbo.DEFAULT ArcSDE Connection Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) WGS_1984_Web_Mercator_Auxiliary_Sphere <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> 20220107 09374000 20220107 09374000 Microsoft Windows 10 Version 10.0 (Build 19043) ; Esri ArcGIS 12.9.0.32739 C19_Vacc_by_PID_SpatialJoin_StatsPrep C19 Icare Vaccination Will County An index of vaccine recipients in Will County with everyone's vacc history assigned to their unique ID. Enterprise Geodatabase Feature Class dataset EPSG 6.18.3(9.3.1.2) 0 Simple FALSE 0 TRUE FALSE gisedit.DBO.C19_Vacc_by_PID_SpatialJoin_StatsPrep Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. USER_PATIENT_ID PATIENT_ID Integer 4 10 0 COVID_VACCINATION_STATUS Vaccination Status String 40 0 0 TEAM Team String 100 0 0 IC_ADDITIONAL_SHOT_RECEIVED IC Shot Received String 5 0 0 COVID_BOOSTED Received A Booster String 40 0 0 COVID_VALID_ADDITIONAL_SHOT_ON_ Eligible Additional Shot On After Date Date 8 0 0 COVID_VALID_ADDITIONAL_SHOT_DAT Actual Eligible Additional Date Date 8 0 0 IC_ADDITIONAL_SHOT_ON_AFTER_DAT Immunocompromised Valid Shot On or After Date Date 8 0 0 LIKELY_IC_VALID_ADDITIONAL_SHOT Likely Immunocompromised Actual Eligible Shot Date Date 8 0 0 BOOSTER_VALID_SHOT_ON_AFTER_DAT Eligible Booster Shot On After Date Date 8 0 0 BOOSTER_VALID_ADDITIONAL_SHOT_D Actual Eligible Booster Date Date 8 0 0 USER_SHOT_DATE 1st_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE 1st_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE2 2nd_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE2 2nd_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE2 2nd_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER2 2nd_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE2 2nd_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN2 2nd_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE3 3rd_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE3 3rd_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE3 3rd_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER3 3rd_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE3 3rd_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN3 3rd_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE4 4th_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE4 4th_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE4 4th_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER4 4th_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE4 4th_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN4 4th_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE5 5th_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE5 5th_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE5 5th_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER5 5th_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE5 5th_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN5 5th_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE6 6th_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE6 6th_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE6 6th_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER6 6th_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE6 6th_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN6 6th_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE7 7th_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE7 7th_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE7 7th_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER7 7th_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE7 7th_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN7 7th_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE8 8th_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE8 8th_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE8 8th_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER8 8th_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE8 8th_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN8 8th_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE9 9th_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE9 9th_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE9 9th_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER9 9th_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE9 9th_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN9 9th_PROVIDER_COVID_PIN String 1073741822 0 0 USER_SHOT_DATE10 10th_SHOT_DATE Date 8 0 0 USER_SHOT_DOSE10 10th_SHOT_DOSE Integer 4 10 0 USER_SHOT_VACCINE10 10th_SHOT_VACCINE String 1073741822 0 0 USER_SHOT_LOT_NUMBER10 10th_SHOT_LOT_NUMBER String 1073741822 0 0 USER_COVID_COMPLETE10 10th_COVID_COMPLETE String 1073741822 0 0 USER_PROVIDER_COVID_PIN10 10th_PROVIDER_COVID_PIN String 1073741822 0 0 USER_PATIENT_NAME_LAST PATIENT_NAME_LAST String 255 0 0 USER_PATIENT_NAME_FIRST PATIENT_NAME_FIRST String 255 0 0 USER_PATIENT_ID_1 PATIENT_ID Double 8 38 8 USER_PATIENT_BIRTH_DATE PATIENT_BIRTH_DATE Date 8 0 0 USER_PATIENT_AGE_YEARS PATIENT_AGE_YEARS Double 8 38 8 USER_PATIENT_ADDRESS_1 PATIENT_ADDRESS_1 String 255 0 0 USER_PATIENT_ADDRESS_2 PATIENT_ADDRESS_2 String 255 0 0 USER_PATIENT_CITY PATIENT_CITY String 255 0 0 USER_PATIENT_STATE PATIENT_STATE String 255 0 0 USER_PATIENT_ZIP PATIENT_ZIP Double 8 38 8 USER_PATIENT_COUNTY PATIENT_COUNTY String 255 0 0 USER_PATIENT_GENDER PATIENT_GENDER String 255 0 0 USER_PATIENT_RACE PATIENT_RACE String 255 0 0 USER_PATIENT_ETHNICITY PATIENT_ETHNICITY String 255 0 0 USER_PROVIDER_SITE PROVIDER_SITE String 255 0 0 USER_PROVIDER_CITY PROVIDER_CITY String 255 0 0 USER_PROVIDER_STATE PROVIDER_STATE String 255 0 0 All_PercentVaccinated_FirstDose All_PercentVaccinated_FirstDose Double 8 38 8 All_JoinCount All Total First Dose Integer 4 10 0 Asian_PercentVaccinated_FirstDo Asian Percent Vaccinated First Dose Double 8 38 8 TOTPOP_CY 2020 Total Population (Esri) Integer 4 10 0 Asian_JoinCount Asian Total First Dose Integer 4 10 0 Black_PercentVaccinated_FirstDo Black_PercentVaccinated_FirstDose Double 8 38 8 ASIAN_CY 2020 Asian Population (Esri) Integer 4 10 0 Black_JoinCount Black Total First Dose Integer 4 10 0 Hispanic_PercentVaccinated_Firs Hispanic Percent Vaccinated First Dose Double 8 38 8 BLACK_CY 2020 Black/African American Population (Esri) Integer 4 10 0 Hispanic_JoinCount Hispanic Total First Dose Integer 4 10 0 White_PercentVaccinated_FirstDo White Percent Vaccinated First Dose Double 8 38 8 HISPPOP_CY 2020 Hispanic Population (Esri) Integer 4 10 0 White_JoinCount White Total First Dose Integer 4 10 0 WHITE_CY 2020 White Population (Esri) Integer 4 10 0 FID_L2Block_Group FID_L2Block_Group Integer 4 10 0 ID ID String 12 0 0 NONHISP_CY 2020 Non-Hispanic Population (Esri) Integer 4 10 0 20220107 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2ylxS 7qOtADTxRXO+LJpIobQI0qgyNuEbEE4Ht1rlJ7zdC37y7JxwWEnH4mvMxWZxw9X2Tg36HXRwjqw5 +ZI9NoHWvO9v+0//AH2ansokWG9kFnHN5ahvnPTg5x1z0rz/APWOi1pB/eu9jSrl86UeZtHoFNLI D8zKD7muOWzXz7gNplpMFVSqkgjp2yO+Kwb6MNPKRa26RuqOvl4AVSAeBiqpcQQqSaUO3Vdbf5mM MO5O1z0tp4VODKg+rCojfWi/euoB9ZBXH2Ph+GVbgTtskSXb+627fuqe496r3VzLaudOURrHAERm CYLLxySehPpUR4ijUnyU4Xel9enfYHh10Z2/9o2I/wCXyD/v4KX+07Ef8vcP/fYrlzcxrZAK0Bj+ 0B2kMo5Bk3HA69+9ajX1mqbzdQbfXeK5KvE9SHw0L6vr/wAD8BKh5mhJrGnR4D3sK59WqEeINKIy L2Nhn+EE/wAhXD6vqz3dxJIi7Y1UpGCMn1Jx2zx9MVhzX83ltCn7tCTxj5sV3wzbESpc7ppfM66G AVWahfVnsFtdwXsXn20okjJIDD1FTVzfgU7vDaAA5Erj9a6kKqcnlvTsK92lPngp91c4K1P2dSUO za+4YqM3PQep6U75E7Fj78CgsWOSc0hGaszEZ2fGTwOg9KbSkU1iF69fQUAL2zTQS/C9O5pQhc5f p6VJ0oAaFxQ1OprdaAHIwA2sMr/KmspU4NJUg+dNv8Q6e4oAjooooAKKKKACiiigAoopcDucUAKP ut9KbThgZGeo60bf9pfzoAbSgkUY5waQ8UAFL0pdtLQBzfizAgsmJx++IyfTaf8ACuUmmjkgkVMy Agg7en511ni9Va2slYAjzycH/cauYnH+jSgf3D/Kvjc8cVjY97L82e5l6bw7+Z0a6FpygfuXP+9M 5/majh0uzW+uIxDhfLQ4DHvu9/atQHKgjpisy5CDVmaWDzY/JQEgElfmfsOtfJUa1afMnN7d/NeZ ySfcr3NjFFNcNDHCqokeFZNwySR69KXTLO1lluDJaW7AhCh8hVBXHGBzjpRZWFrcqyur7GiUsqyM oJy2cgEZ/GpktRBfTQwzGCHyoyect1YYBbOBgV2VK1oTpc75klrb07NshLW5m6jdPZXtzbQuIYGK ttiGGJIUcY6DgfnWTLcMlwN6YeTLeZM5JOPzrpRHZeZqEBmjVXRQWZ8noeSScms3+zJLmWVbe8gk eBFdSgzuJ3cHnjpXRRqU0rSWlldu66Kz08973OqjVhGOuj+8x5LiTymlDR8MVyqegz1P+eai+0bG mdJlByOCQcjA54HXiuiXw2biLeLwbXyeI/X8axdfR9MufKSdXLbWZSnUdv5V2UMRh6kvZxtfrp0u vI2jN1ZqMXq9v6uVdwWNishBEoOAuew6+tQ3gR1LyklugGduCRzximf2jKElLjMkntgAYGDj8Kpy SPK5d2LMepNdbqcjvbX/AIbyTO/D4CpUd27L/h9j0/wFIv8AwjjCMEfv3Bz16DvXS1ynw/J/sGUd hcN/IV1RYDqa+twrvQg/JfkfN4yPLiKi83+YtHSm5Y9BgepoC9ycn3rc5hpcscJ+ZpyoF56n1NKV U9QKTYvuPoaAHUU3aR0c/jR8/qPyoAdSEcUmWHVc/Q0hb/ZP5UAFAODkU3eo6kD68U7qKAHt8y7+ M5w1Mp8fO5P7w4+tNIxQAlFFFABRRRQAdaVuv4Uq9foDTaACiilGBknoASaAFY8gegoxVJr7EpAV SM9c1eHSgAooooA5/wAW/wDHlZ/9fX/tN65aUZhcf7Jrq/Ff/IPt/wDr4H/oLVyzjKMPUV8XxDpj IvyX5s93LNaDXn+iOjtrC0NtEwi+8gPLH0+tZWrxW9tcSRJa7mlt8IVONrAnn9RW1p8gl022cdDE v4cVka9hdQtyT1ib9CP8a+Zw9WosRJNt79X0OalCM5KLI9Es7eS4uA8KNhE6j61tjTrJfu2duPpE v+FZOgsDe3ABBzGvT6n/ABrfrLGVaqq/E9l18iq8UqjscrqsKRa6rRxRBY4432FeDgtjp7j9K0tI uXub+6aRI1IijACDA6v/AI1T1kY1gn1t0/Rn/wAaq2mpLYTzOFDGSMBGJwuQT+fUV3OM69HkWr5V +hr7KLoqXX/gs3pbmLTZ28zKwzZdcf3+6ge/X865rUBHqmr/AGmWIqEiVVQnOeW5NLNfpI5mnuN7 ep6D6DtVG7vFSJp4JOSoUfIcHnsenetcNhpxd0nzNWvr/W3X56G1CiqbUm9exQ1hNt9nGAUGKoU5 3aRizsWY9yabXfskj6ehTdOmos9H+H4J0a45wPPP8hXWcDoMVyXw850i7X/ptx+Qrra+0wX+7w9E fB5gv9rqerFyaUdKbRXScY+ikB4paACikNNxigB9ITikyfWl6jmgBvWk2L6Y+lLRQA3DDo351KXD /fwrevY0yjHFAClGXqPxpKFZ4/uE4/u04lWTevHZgeMUANoo3Jj7w/Om71/vCgCRep+hptIsg3YG TkHtQuSMlcUALTgBjnkEYNV7sOsW9XIx2FSCRcD5x+dAFJ7YRXSggiMnhjzV8zRqcF1B9M0q7ZUK khhVCa2ZJCI4tynke1AjRpD0paKBmF4oUnSkbssyk/qP61xkEEDQqWijLdyVGTXa+KI92jNnBXzU yD3+auQ+zw/88k/KvkeIJ8teKu1dL82e1lsb036/5Gtod0sUjWjEBG+aPnoe4/r+dXrhYJdWthIs br5EpwwBGd0eP5mub8iL/nkn/fNVYYoybX92vMJzx/u184qEJzdVSadn+T13NauFbldO1/8AgHar JZQDKPbxg8cEClbULJfvXduPrIP8a5GRreHHmGJM9N2Bmq11NAyqqyR7SM5Hc5H+NZ0suVWSvza9 SJ4ZQWskb9zNpd5rKvJfQtGIR8qSAhiGPBx9elVtYu7Vr6ExupVYiAVHHWsdbpYrlD5jllT5ZIuD /nk1JJrX2m7Q3M4wiMBkAEcr6fSvQWCcWmk2ku/5aE06co1FZ3I7+5WW2khjSQlhgHYcZ7dqqXip FpqpFJMyBhjcmB/Kr8t/ZumPtAGCCCBzWZdy2xtjFC5fBUqSMHvnt9Pzrow/KoqPK1Z3/rQ9CMan tV1V1+ZQRWkcIilmPQCrI028P/LA/mP8adpa7tRi9sn9DXSVlXrqm0orc9OtiKkJuKZP4R1FdFtr mG6hlLu4cbMHjH1roG8VWxYkWlz+S/41xdxexWc7eZuJYDAUc96W3v8A7WGMMLYU4O4gV3wzfGU6 aUIx5Ulv/wAOeJVwUKsnVnfV/L8jrpfF1uigiyuOoHJUdTj1pp8VHnFg3tmUD+lctL9okTaIUHzA 8v6EH0pv2mf7Os3lRBSob/WHv/wGq/tnHSiuXlvfy+XX1MfqOHT1v/XyOl/4TB84/s7nfs/1/fGf 7tN/4TKZgdtlAhUkHdcE8/8AfNc1GJpWcr5WBIG4YkfdHtSL5irM5SIkOe3fireb4p6cyvp2JWCo 72Z6LpGoHUtPS5ZFUsWBCnI4JFXjzWJ4X40VVOMiRwcDA+8a2a+poTc6UZPqkeRUjyzaXcfjjFMp cmkrUgKctNpw6UALSY4xS0hINADafGRkqejDFMooACCpwRgiiniRgMcH6jNKyhsMuAD1HpQAxOH3 dsHPtSnpSE9h0/nTeQMAjH0oAU8jB5FN8qLvGn/fIpQecEYNLQBF5RWZHgCrz8w9af5r/wDPF/wx T1+8PrQepoAdRRRQBk+JRnRJfZ0P/jwrj67HxF/yA5yTgAqf/HhXFGeLIAkTcxwBuFfIcRwlKvCy 6fqe1lklGnK76imaJTgyID05aq2lg6hqUNrE6r5cTFmIz3FdAdTsdE0xAZknl5+WIgliTk/hzXFW jLcam810A3mFmJkGRk8968fDRcoT91pa2e99HrbQ6oSlXjKWyX53R6RZ2tvbQjyApz1k6lvqayPE TIk1uWIGUcfyqlp2rQWD7VlRrc/ejQ52+4A/lVjWtRs5JrcpOjYVs459K4KWGqwxKk02nf8AI5Ix cKqu/mY6zJALYzOEzDj5vX5axL9omvnaEgoecjpnvWhqga8MItkeUjJIRCfSs97G8jxvtJ1z0zGR n9K9mjFr3rO7T0+bPbwyoq0pVEvu8vMr0VOLK6PS3k/75pHtLmMZeCQD1xT5Wep9Zov7S+8taMM3 +fRDW+xCqWPQDNYOj7luZCI2YheQMDHPvUl19vuHkZGZI87Qm7B+mKwqUHUqK7srfqeXiJp1pWf9 WQt7bXF9c7o4tuEHDMPerWl20lr5scu3Jw3Bz6/4VHp8V3bvIJhvYqp5fOOtWw0v2l/3a52L/F7n 2orN2lTja1l19PMwVWXKoN3V+3r5E0r+XGzAZI7VEYGNksGRkKqn0IGKS4abyHzGnT+//wDWqTM/ 9yMf8DP+Fc0VKEU1bfuum35ktptp9iss3kTSqWgQls4z7CliEk3n4aPHmg5wfRTUoS4DuwMXzHOM E0xVuEuGUPF+8y5+Q8YAHrXRzxd7WvZfhbyMrNb7XOz8LFv7KcNjImbp+B/rW3WF4SDnTJw7KWFw wyowPur7mt3vX3eDd8NT9F+R89X/AIsvVhRS9qSukyCjJoooAXJpKB70vFACUoFGDSjnigBoGakU goyD0zn3phOBgfnT4f8AWigCOiilxxmgBpAPWkDYyGPQ06igBFZSw57+lOJySfWhRkkex/lUYcgA FWzjnigCaiikyKAM3xDj+wrotgAAE5/3hXDLNbMwVJIiT2DCu7135tDvMEZ8snmvP7ppY0R2aMhX HGCP15/lXy+f01OrTXVp/wBbHr5bJxhJlrauc7Rn1xUcnEsP+8f5Gq5fzk/fSDGc7UQn9cU13UtE BPMQG/ucjg+1fPxw8k9fPo+x6TqqwfPHOiDYhGRvznI5PP5Gpo3ZpVaVduRhCOh/w+lQSbC8JV5D ubBYoTnjPp7ClaaV2SKUHYxOWUHLfhjj8K3lTc0tOmu9+t/+G/IzUlFm5o//ACE1/wCubfzFW/EG BFbN6SEf+On/AArJ0a7jTVIhI5VCrKrvxk8cc96u61f29wI4IixdJmDfKcZAIPP1rzJ0JxxEdNLP 9Tmm+bEXXkQR6ffyorJYzlWGVOAMj8TTLi1ubRkFzbvFvzt3EHOPoa3bTxVp8VlaxMJy/lhQAnUg c96yNf1NdSlDwrIkaR7RvGDknnv6Yr6XGZdgKNFuE7y6K672FRxWJnNKUdPQwbqcQu8jK3lSEJuX qQM5/Wi22XKtIsczqGO3MmMcD35qLULW5urgLCg8qIBQMgDP+cUlvFqVoBCgh+bLfMc+lcKt7Ncs knbv/XQ73CHLd3vf5f1cvQgRXL5TywUHVs55NTD/AI+W/wBwfzNUQl80580W7SbPlznAGee1WoEe Oba7A4jAGB05rmrQSTk5Ju3qTB68ttLktx/x7yf7pqQdKa6742XOMjFMCz4+/H/3yf8AGuRWcbXN ndO41nkado0eNcAHDKST+opyxyecJHkDYUgALjrj39qYyyCaEuyn5iOFx2PvVitJy5UlG2q7fLtc mKu3c6bwmT9hvPa5OP8AvhK3a57wof3F6uf+WwOP+AD/AAroa/Qcvd8JT/wr8j5rE/xp+rHDpSGl XpSHrXYYCUUUUAFKB3pKVaADqcCl6/Koz9O9SRxcFm4GKaXAGIxj3PU0AJsC/fbB9BzT4zErg7my D3FQ0UASeS3YqR65o8s4xlf++hUYooAeIj3ZR+NHl/7a/nSLQBzQA9Ymzngj2IpPJf2/OkPSmUAP plPpuTQBn60M6Je+0LH9K4KaZGRcbiQ6n7p9RXoGrqToeoADJNtJj/vk1xHWvl+ImoypSa7/AKHr 5Wm1Nen6leWdWTYoJLAjJU4H6VCjbSNxZiJOW2EZGKuSSLEm5ycZA4BP8qryXCybY0MiksAT5bDH 4kV8/Ru42jF27/0j0p6O7ev9eZWknRYUzI8YWdiXCdBlvUe9OEyGW3kFxNKpYgZT/ZPooqee0SWG O3SJipcYSMcn8qikiWzlto/JnVlbIV0OcFWHf/PFdMJU5p2T+128+ttDKXu2Teun6eY2S4SCQecG EW5iCUPOcnFOaWJmCmGQxKA/K9Sc9c1FOEuWQyxSkCRu2OAD/hTVg1G33tdRzBnjDRncvQH61oqU Wk27P1t13/O5Lmhs4mc2sSQyBUkyyggZzyMc+mamknaK2mkMEixFhjcw46D19RVefbEu+ZXaPcpw 2CcEHHHTFUprzzbaOBT8qknG0D+X1rd0+aCaSaXr69yqMXOai7/h6di6dWtmJb7NJknn5sULrEKN lLY59S3NZ9nbzNcI6BRt+cMx4GD3q5IllJGJ2Yk7h5uwAYPPT2qZ4amrx/z+XU3U6akla/3d/QtW t+95eDZGqlYz1bryParu2fzd+I/u4xk1StLdYdSWWJNsMkHy+vUda1K87EyjBxUFpb/PzGkpNtbX /Qi/f/8ATP8AWmB5zO0eY+FDZwe5Pv7VMzqgyzAD3qsJWa7JjjY5Tq3y9/zrKmnJN8q2FKya1JGj mYqTJGNpyPkPpj196dsnP/LVR9E/+vTX89QZC8YC8lccY+tIEmeNX80o55IwCB7U9bJtq3p/wA0v s/6+ZZ0+/vrGW4jguAAxVjmMHPFWF1vVnaRft7LtIAIiTPQHutZB/dXbqZpMFFJwm4nk+g4pPPCG ZYzJuYjBZT6e4r0o4rGKPLTm7WVrLTp5HI6NBu8o63f6msusaszyKdTmwpGP3cY7ey1wGv8Aj/xV p2tXFqmpERxn5f3a8jH0rqorpEMzN5pUYO4rnjHtWVqNjo15qEk2oWztLtAGQRxXThsdiYVJe2ba svv0/wAzahSwykrwT30OVPxH8Vkk/wBrSD6Kv+FRH4geKySf7buRn0x/hWxPo+kmd/ItAI+MBs56 Vh3vh66utUWLTrM+Wyj5hwoPfJr04Y5TduZrS+v/AA56kaGF5VKVKKT7pHuHw31C61jwZBeX1000 5lkVnk6nB9q64bU6fMfU9K4X4XW93YeGpdOvIlR4JiQQ2dwbmu4r2aMlOmpJ3uj43FpRrzUdrv8A MepJ3k9dpqGpU6n6GmbRWhzjaKKKACiiigBR1pcihaCOaAF6ikwKTBFLx60ALRRRQBW1EFtLuwOp hcD/AL5NeeC4RQBh2OBnahOPyr0i4z9ml243bDjPTpXmlvIi28YVJMbR/Ca+a4iinGm2r7/oerlb s5fIZdXCmAYSXh0PKEdGFRhnIEm2ZiZA2AvBGeD+VT3DmWEqschOQfu+hBpbYyGOCAo6yMVjyRwC SBmvBg1Gkklrfv0svwPQn8TbeljV0bmQ3bW87KMrGQvHoT/T86XVrSe/uIbu1jZ9h8uSM4DLjJzy fet+GJYIUiQYVBgVzc8sw1eaP7RKkX2lQyo20YO3PI5715lCr7Ss5w0suuum3/B9Tg5pzm5rfcz5 bZrBo59St51tvNbdhh3DYxg1U1S8TUpYhpb3OI4yH8xz04xjn610muaOt1YpAlxMC8yjMkrOB+BN VLXwgbNmdb7cSm3Hlf8A167qWOocqqzlaWtlrb9e5rSnT+Op8S27dP8AgnM3ao1quZHz8pO4NgD8 SaysKGPOfQ1vRabd3GXvontLKFcyuY9pYDpgHqayoIEnvljBYRs5xnrjtXtQxEEnHm/rtt/Wh24e Ds2tbejWvz3K4dtu0dM9M8Zp8YkZ1jQkFmGAD1OeP51sRaRalDvlcMGIPI9afHp9tFcRNFMS2fVT jj6VE8bT5nydL9/6saKUfZtS1fyt/mR2Vpcw3imZmG5Tghs88Vp+VKz4aXMeP4eDmo5Im8+HM8h5 I/h9PpTntmbGJ5MdwT1/LFeXUq87jKUlt2b6v5ku7bdv06IjhMCTSNu+fO1dxJJA+vXmkYvJLFOA yKdoHzdQT3xT5hJGqDeuwtg/u84GDVBjHHOd7SiEMuCQQnvgVtSpqo3NO+nm9NvL9TGcnH3bGk7r K5iBGFILHP6VI0sa/ekQfVhWe01lJJGIChckgALwc9aswvEiInlMHCjI8s1zToWitH6WNlNp6iKV mvHMcjDEa8joeTTVhJu5isvzbQCSMnv+VPwZbskeZEQg9OeT9aka2iMe07gAPvBiD+JFU6ig7Xtd JdH2+8lRcvvIvLiAAa45VduFx09MUR6Q2pSySLbuwjVRjeAe9LbR3EzslrH56RBfup1znvnHaug0 EOGuiUIGVXPB5Gcjior1p0ISktX/AJtdNDCpWUFeDszCfQxaW7ySae2xeWZmUn+dV0jWJyEjmi3P 8qpgDp6Zx2NdVrV3CLWaybeZZYjgKOmeM5/Cualt8GM7pmAPIDc9KWGxM6kL1Xa9++2lt2FKc6ic mjqvB27ybzdvzvX7+M9PaukJOa5rwcNsV7w4+dfvnJ6V0pPNffZf/usPQ8XE/wAaXqPiPz49j/Km k0sefMH0P8qZXYYBRRRQAUUUUAKKcOlMpw6UAKelNwadRQAUUUUAIyh0KnoRivNbU5tIT6ov8q9L rzWAYt4wOgUCvmeJV+7pvzZ62VfFIkoU4ntz6Tx/+hiiobn/AFB/3l/mK+UpK80vM9eqrwkvI7aq CR6beXrSoI5LiMglhnt0Poa5tokfO8Fweu4k5/OtDSLeSW8WWNtkcPDEfxZH3f5H8q5Fh404ylGb 29P1e55s8M6cXKTNjUOI4D6Tx/qwH9ag1nWYdItt74eZvuR55Pv9KTxBM9voss8YBeJ43APTh1P9 K86vL2e/uWnuZC8jfkB6CtMHhFWpqc9k3p9xtgME8TNt/Cty5qev32qr5czKkPXy4xgH6+tZR7fW lpCMivcpKMGlHRH0qw9OnScKa0JoLl4XU4VwpztYZHTH9auDWZF5EEQPqBWbg+1Hzeo/KtZqM5Xk 0/vOf6rTa+B3/rzNi21OS5u4lkRQoJPyAk9DWp54/wCecv8A3zXP6VxqEWff+VdHIdsbHOMAnNcG KjBTikun6s460OSbS0IWleSVI1Dx5BJJUVDe2zS24WSdipdRgKB1YD096Irdkuop5JXeR1IIJGBx nip7sZtyASCWUZH+8KE1TqwULfd5+epzauLk73/4BUj0aGKRZFmmDKcg5H+FWArQXIZ3llVlxkqD g59hUghYdZ5T9cf4Uvk/9NZP++qmVdy0nK/y/wCAU4tu/X1IT+/uhhpY8J6Yzz7ipTbBgQ0spB4I LdaRU2XK4ZjlD9457ipicDpkkgAepPAFROo04qAKKs3It6ZZvc3Mm2WSOEACTYxG7rgfzrUFoy3Z hgu7mCNY1O1WD9z/AHw36VYsLQWdosfVz8zn1bvTh/yEW/64j+ZrzJ4mUpSSeiXr89fwPIqyU5uR h38drbamRdR3l2WhUgrLgjlv9pRUYm0k9dOvl+sv+ElT63/yEk/64j+ZqhXZGo3CLd9l1a/J2Oyh h1OmndnS+GWt2N79mikiTch2yHJ6H3Nb4HNc54T+9e/VP610tfoeVu+Dp+h42Jjy1ZRHJ/EfQGo+ KkPyxZ/vHFRV3mAUUUUAGM0pGBSr0pGHegBMU4dKbmlB5oAdTKfTdtAEgjYjOMD3NLs/2l/Omkkn JOaaTQA/Z/tr+deYiRhkCFzgnnI9frXpWDXmc0Qjuwed3nuGJYn+9xXz/EEU6UL93+Xqellram7f 1qP81/8Ani/5j/Gqt1dFraVUjYkKSSCDjHPNWT+9mKH7iAE+59P8+tR3YL280ScKIzuI+nAr5ehy KpHmj2fU9ed3F2ZUbW4iCFikB9eK2IfGNjbxLFFZTBF6fMK4yitJ4ajNcso/i/8AM9SeW0amsm/6 +R1Gq+LItQ0ye1FpIhkAAYuDjkGuW59B+dB6Utb0qdOjT5YR0u+/l5mmHwkKEnGm2lp+vkJ83tR8 3tS0VfP2SOn2fdsT5vUflRz6/pS0Ue0fl9yD2UfP73/mWdOBN/EAxByeQPauhaFnUq0zkEYIwP8A Cuf0441CH/e/pXTVx4qpJOLX5I8vFwXtX/myD7O3ykzyEr0PH+FK0BbG6Vzg5HT/AAqaiuX2s/6s c3JEi8k/89pPzH+FHk/9NZP++qlope0kPlRj6sXtjEYpZATkE7j7Vm/a7nIP2ibIIIIc8GtfW1Bt Y2xyHx+hrCr0qU26cXf+rs78HSpTg+aKevbyRb/tXUf+ghef9/2/xpP7T1Ddu+33e7GM+e2cfnVW iqOr6pQ/kX3Ine9u5W3SXdw7AYy0rE4/Om/arj/n4m/7+H/GoqKfM+41hqK2gvuRraNd3f2t0F5c qrJkhJ2XJBGOh963DNcMMNeXbD0Ny5/rXO6N/wAf5/3D/MV0FYYnFV4OKjNpW7vuzx8Rh6SrS91f cuyGNNMJ1U3Vzt2k489/Ue9SCSU9Lm4/7/v/AI0xo0fG5FbHTIqOFVWWZVAABHA+grL63XlG6qSu l3ff1MPY00/hWvkZ+r3l3DMiR3lyqsnI85uefrWX9svO93P+Ejf41rarZTXLxyRKG2jBGeayLi3l tWVZUwWGRyDXo0MVWlBKM7v11O3D0sLypTir69DE8Q6xqtu8At9Qu0BByFlb/GtLSJ9XOixXlxf3 TeYSuGmbJGeOK0tLubeFpPP7gYyua1f7QsWTaZE2/wB0rW9TMK9OKpqLfd6mVaNJuygrJ9t/wMa3 jv7hN8bSsAcE7+n61s5X90JFcgf6x3UgHjvn3ptveW3nukBBGF2qox69B+FWWaWT5RGUU9WJGR9A K46+LrOVpaL1tuv6+fc5pRjLpt5eZXjNmZJGY24Gdqj5cYHesO5YfapdjfLvOMHjFdSqKihVAAHQ CuXvRi+n/wB81nRxEpOVm+nU7MDRj7S0ktn09D2+kaloPSv0A+LGg815xfcXEqkfL9ofL/3fmOK9 GHWvO70O15dxhRtMrjcT/tHtXg5//Bg+0v0Z6OW/HJeRn3GoR2jyjG6Ut930GBVY6vH5LxiFyWBy xbqTVTUbY2tycklHyVJOc1Ur55QppJpX211PqqGEp1IKTeoUUUVR6a0Eb7po59qD0NLVp2iZuN5v 0X6iZwcEijI9aWkPJxTXLLp/X3CfPFb/ANfeLRRRWZqTWkiw3cUjnCq3Jram1S1MeEnYEkchTkDP PaueP9aWlKnCXLKXQ462GVWb1todRGgljDpcSsrcg5H+FKUMckeJHbLYO5vY1zcV1PENkcrKvoDS te3JKkzvweOaj6vLmtzaenkcLwc91bfv5nVUVywvbkHPnyf99Upvro/8t3/Ouf6p/eNfqdXy+/8A 4Br6z/x4j/fFYFPluJpVCySuwz0JqPH1/OuyFNQppNnThoTp80Wl9/l6C0UmB7/nRgVVo9/w/wCC dN59l9//AABaKTaPSjaPQU7Q7v7v+CF6nZff/wAA0dG/4/8A/gB/pXQVzmkbVvweB8proTJGOrr+ dcOLjeS5e36s8nEN+1lzf1ohSwUZJA+tQ5Q3SlCpJU5I/CqepXiQPCyiOQ85Dc+lR2V611dYjhiQ qp6d+lOnhpKHP5P9TnlzNXtoa9Ur3T0vJFd2YBVIAHc1YxcesX5GjFx/fiH/AAE/41jTcqcuaMkm Dd+jOYmtZrVgsybSRxyD/Ko60tZEomi3sh+U4wpHf61mfN6j8q9Rv2lptrX1PUwk5eyWjf3f5mto Z/fzD1UfzrbrA0Mn7Y4J/gP8xW5JLHCm6Rwq+pNcGMg/apLXQ4asr1JPzH1y19n7fPz/ABmtS41p FDLApY9Ax4FYrMWYsxySck1phoSpXcup04WjJy5mrL7j3WmGWLODImfTcKQxl1/eNx3C8ClWKID5 UX8q/RD4MUMp+6Qfoa4G7GL+6H/TZ/5muzuv3c8bxkBzwfQ1w17dx/2lfhzsaOViwPbmvB4ig5YW Nl9pfkz0crdqr9P8jD1e63zeQnIUYY++Qf6frWXT5ZDNM8jDBdicelMrwfhioLZH2mFoqnC/V6sK vXekXtjaQ3VxEEhnx5Z3g5yM9Ac9KTSdNfV9Rjs432FwSX252gCui8dboDptmDmOOE4PqRgf0ruo 4VPDTrzW2xyYjGyWMp4am99/z/zOPPQ0tB6GrWm2Eup38NpD96Q4J7KO5rkhCU7Rju2d1SpGnecn ZJFUnAJoHSvQf+FfWPe8uT68L/hTx4B04dbm5P4j/CvS/sjEcttPvPI/t7C819fu/wCD6HndFejj wFpY6zXJ/wCBD/CnDwJpI6vcn/gY/wAKP7GxHdfj/kD4gwvaX3L/ADPNT0/Glr0weBtGGMrO31k/ wrmPFmm6XpMkFtZRsJ2G9y0hbC9AP5/lU1ssqUaTnOS09S8PnNKvXVOnF3fp/mczj60bR7/nS0V5 3tJ9z1/ZQ3sFFFFQWIe31paQ9B9aWrfwozj8b+QUUUVBoFFFFFgui7pQVr9QwBBU8EV0AijHSNB/ wEVz2lMq36FmAGDyT7V0BuIR1mjH/AhXNiVU5klfb9WeNinH2zf9bDtif3V/KnYA7VF9qt/+e8X/ AH2Kb9ttf+fmH/v4K5vZVX9lnPzwXUnoqv8AbrQf8vMX/fYoN/aD/l4j/wC+qPYVf5X9w+ePczdc /wBbD/un+lZNaOsXEMzxGORXwDnBrNyP8ivSp0pqnHRnp4SpBU7NotadcLazNKwzhWGPU5qKeeS4 lMkjZJ/Sofz4OelLn6/lW9WD5rpa/wDBFQjTUnOTV9PyFopM/X8qM+x/KsuSXY6/aQ7nuCjaoXJw BipU6UUV90fmZXuNqTRyOPkPymvKfFH/ACMt8QBgyZH5CiivMzd2w6fn/me3kKvimvJ/mjI59qOf aiivmObyPseTzZ3fw9jHk3spj+bcqh8dscjP5Vt6/wCHYtd8gtMYWiyNwXOQaKK+uwtOM8LGMldN HweNqzp42c4OzTZjj4ewY51CTPtGP8a2ND8M2miSSSxu8srjaHcD5R6CiitKeFo03eEUmY1cbiKq 5ak20bdFFFdByhRRRQAyWVIIXlkYLGilmY9gOSa8c1O8bUdTuLts5lckDPQdh+WKKK8XOakoxhFP e59Hw9ShOc5SV2rfjf8AyKm0e/50Y+v50UV8/wC0n3PqfZQ/lQYH+TRgUUUe0n3D2UOyJbVFe7hV lBBdQQfrXSCxtR/y7x/980UVzYqrNKNm+v6Hl4uMVW0XRfmx32O2H/LCP/vkUv2W3H/LGP8A75FF FcXtZ/zM5+Vdg+zwD/ljH/3yKUQRDpEn/fIoope0n3Ycq7GfrKItmm1VH7wdB7GsPFFFejQk3TWp 6OBiuR+v6IKKKK0O4KKKKAE/ipaKKqXQiG79QoooqSwooooA/9k=