SampleDataForCommunity.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	test_case_id	layer	data_source_id	data_source	market_id	market_name	sub_market_id	sub_market_name	check_name	failure_reason	failed_record.1	failed_record.2	data_refreshed_date
2	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	{patient_sk	5388068139LAADGIC	2024-12-01
3	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	tokenized_patient_id	null	2024-12-01
4	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	product_sk	00032122401LAADGIC	2024-12-01
5	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	abbvie_product_id	PRD00032122401	2024-12-01
6	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	physician_sk	6794064LAADGIC	2024-12-01
7	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	abbvie_customer_id	204834	2024-12-01
8	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	plan_sk	0000030564LAADGIC	2024-12-01
9	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	abbvie_plan_id	2071841814	2024-12-01
10	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	pharmacy_id	null	2024-12-01
11	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_product_strength	24000-76000-120000 UNIT	2024-12-01
12	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mdm_npi_number	1427018530	2024-12-01
13	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mdm_abbvie_best_specialty_code	IM	2024-12-01
14	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_patient_hipaa_birth_year	1958	2024-12-01
15	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_patient_gender	FEMALE	2024-12-01
16	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_patient_ethnicity	NULL	2024-12-01
17	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	abbvie_plan_channel	Medicare	2024-12-01
18	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	claim_id	23118517394622770002	2024-12-01
19	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_indication	PANCREAS REMOVAL	2024-12-01
20	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	initial_claim_id	null	2024-12-01
21	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_sequence_number	1	2024-12-01
22	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_secondary_plan_id	null	2024-12-01
23	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	pharmacy_distribution_desc	R	2024-12-01
24	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_pharmacy_distribution	RETAIL	2024-12-01
25	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_enhanced_plan	null	2024-12-01
26	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_fill_type	0	2024-12-01
27	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_fill_type	00	2024-12-01
28	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	primary_claim_status_code	PD	2024-12-01
29	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	secondary_claim_status_code	null	2024-12-01
30	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_claim_status_code	FILLED	2024-12-01
31	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_initial_final_flag	S	2024-12-01
32	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_final_claim	N	2024-12-01
33	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_final_claim	DIRECT_FEED	2024-12-01
34	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_new_to_brand_yn	N	2024-12-01
35	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	new_to_product_flag	0	2024-12-01
36	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	new_to_product_flag_flex	null	2024-12-01
37	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_of_business	CN	2024-12-01
38	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_product_name	null	2024-12-01
39	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_sob	CONTINUING	2024-12-01
40	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_sob_flex	null	2024-12-01
41	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	lot	null	2024-12-01
42	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_product_name_flex	CREON 24	2024-12-01
43	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	lot_flex	null	2024-12-01
44	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	rx_origin_code	null	2024-12-01
45	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	daw_code	0	2024-12-01
46	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	daw_desc	null	2024-12-01
47	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	primary_reject_code	null	2024-12-01
48	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	secondary_reject_code	null	2024-12-01
49	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	coupon_flag	null	2024-12-01
50	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_coupon_flag	null	2024-12-01
51	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	single_payer_flag	Y	2024-12-01
52	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_single_payer_flag	null	2024-12-01
53	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	primary_reject_type_desc	null	2024-12-01
54	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	secondary_reject_type_desc	null	2024-12-01
55	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	primary_reject_group_desc	null	2024-12-01
56	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	secondary_reject_group_desc	null	2024-12-01
57	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	product_qty_dispensed	90.00	2024-12-01
58	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	product_days_supply	30.00	2024-12-01
59	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	days_supply_group	null	2024-12-01
60	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	fill_date	2016-05-16T00	2024-12-01
61	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	primary_patient_pay	null	2024-12-01
62	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	primary_plan_pay	null	2024-12-01
63	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	secondary_plan_pay	null	2024-12-01
64	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	secondary_patient_pay	null	2024-12-01
65	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	mastered_patient_pay	3.60	2024-12-01
66	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	primary_patient_copay	3.60	2024-12-01
67	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	secondary_patient_copay	null	2024-12-01
68	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_primary_encrypted_group_id	null	2024-12-01
69	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_secondary_encrypted_group_id	null	2024-12-01
70	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_usual_customary_charge	null	2024-12-01
71	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_copay_30_days	null	2024-12-01
72	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_rx_origin_code	null	2024-12-01
73	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_diagnosis_code	null	2024-12-01
74	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_days_till_next_fill	null	2024-12-01
75	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_concomitant_flag	null	2024-12-01
76	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_encrypted_rx_number	null	2024-12-01
77	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	source_incnt_srvcs_fee_paid_amt	null	2024-12-01
78	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	refills_authorized	2	2024-12-01
79	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	eligibility_lf	1	2024-12-01
80	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	eligibility_lb	0	2024-12-01
81	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	free_good_flag	0	2024-12-01
82	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	regimen	null	2024-12-01
83	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	reversal_lag	null	2024-12-01
84	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	deletion_flag	0	2024-12-01
85	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	market_non_market_flag	null	2024-12-01
86	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_1	nbrx_exclude_flag	2024-12-01
87	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_value_1	N	2024-12-01
88	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_2	null	2024-12-01
89	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_value_2	null	2024-12-01
90	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_3	null	2024-12-01
91	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_value_3	null	2024-12-01
92	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_4	null	2024-12-01
93	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_value_4	null	2024-12-01
94	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_5	null	2024-12-01
95	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_value_5	null	2024-12-01
96	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_6	null	2024-12-01
97	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_value_6	null	2024-12-01
98	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_7	null	2024-12-01
99	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_value_7	null	2024-12-01
100	TC_00528	FFP Layer	180647	LAAD	663702	GIC	588996	iqvia_laad_pert	Null_check	Null values detected in columns: initial_claim_id: 10219128 nulls	custom_field_name_8	null	2024-12-01