CREATE TABLE xxx.xxx (
	ID bigint NOT NULL IDENTITY(1,1),
	chart_id nvarchar(255) NOT NULL,
	request_id nvarchar(255) NULL,
	parentid nvarchar(255) NULL,
	parentid2 nvarchar(255) NULL,
	barcode nvarchar(255) NULL,
	pafm_uid nvarchar(255) NULL,
	chart_dup_id int NULL,
	project_id nvarchar(255) NULL,
	project_year int NOT NULL,
	projectid_type nvarchar(255) NULL,
	engagementchannel nvarchar(255) NULL,
	distributionchannel nvarchar(255) NULL,
	distribution_method nvarchar(255) NULL,
	form_type nvarchar(255) NULL,
	projecttype nvarchar(255) NULL,
	reimbursement_type nvarchar(255) NULL,
	[source] nvarchar(255) NULL,
	review_type nvarchar(255) NULL,
	tfname nvarchar(255) NULL,
	completeness nvarchar(255) NULL,
	run_date datetime NULL,
	datepscdeployed datetime NULL,
	deploydate datetime NULL,
	actualdeployed int NULL,
	netdeployed int NULL,
	deriveddeployed int NULL,
	chart_status nvarchar(255) NULL,
	overall_status nvarchar(255) NULL,
	opaf_suppressed int NULL,
	paf_suppress_reason nvarchar(255) NULL,
	retrieval_date datetime NULL,
	retrieval_date_clean datetime NULL,
	returned int NULL,
	returnednetcna int NULL,
	retrievedby nvarchar(255) NULL,
	prep_date datetime NULL,
	cnaon datetime NULL,
	cnareason nvarchar(255) NULL,
	cnareasondesc nvarchar(255) NULL,
	released_for_coding_date datetime NULL,
	pended_date datetime NULL,
	prep_reject_date datetime NULL,
	coding_reject_date datetime NULL,
	reject_code nvarchar(255) NULL,
	rejectreason nvarchar(255) NULL,
	rejreasonnote nvarchar(255) NULL,
	screeningrejecton datetime NULL,
	screeningrejectcode nvarchar(255) NULL,
	screeningrejectreason nvarchar(255) NULL,
	screenrejreasonnote nvarchar(255) NULL,
	singlerejectdate datetime NULL,
	singlerejectreason nvarchar(255) NULL,
	coding_date datetime NULL,
	codingvendor nvarchar(255) NULL,
	codinglocation nvarchar(255) NULL,
	codoverreadon datetime NULL,
	raorlocation nvarchar(255) NULL,
	extract_date datetime NULL,
	screeningstate nvarchar(255) NULL,
	screeningdate datetime NULL,
	coded_for_risk int NULL,
	coded_for_quality int NULL,
	daysout int NULL,
	hic_num nvarchar(255) NULL,
	mem_id nvarchar(255) NULL,
	mbrlastname nvarchar(255) NULL,
	mbrfirstname nvarchar(255) NULL,
	dob datetime NULL,
	mbridkey nvarchar(255) NULL,
	mbr_glb_id nvarchar(255) NULL,
	levelcode nvarchar(255) NULL,
	carepriority int NULL,
	mbr_card_id nvarchar(255) NULL,
	mbr_gdr_cd nvarchar(255) NULL,
	mbr_addr1 nvarchar(255) NULL,
	mbr_addr2 nvarchar(255) NULL,
	mbr_city nvarchar(255) NULL,
	mbr_state nvarchar(255) NULL,
	mbr_zip nvarchar(255) NULL,
	mbr_phone nvarchar(255) NULL,
	mbr_email nvarchar(255) NULL,
	mbr_cont_enrl nvarchar(255) NULL,
	prov_id nvarchar(255) NULL,
	prov_fname nvarchar(255) NULL,
	prov_lname nvarchar(255) NULL,
	provname nvarchar(255) NULL,
	provideraddress1 nvarchar(255) NULL,
	provideraddress2 nvarchar(255) NULL,
	providercity nvarchar(255) NULL,
	providerstate nvarchar(255) NULL,
	providerzip nvarchar(255) NULL,
	prov_group_id nvarchar(255) NULL,
	prov_group_type nvarchar(255) NULL,
	prov_group_name nvarchar(255) NULL,
	group_name_current nvarchar(255) NULL,
	cs_group_id nvarchar(255) NULL,
	insite_group_id nvarchar(255) NULL,
	insite_group_name nvarchar(255) NULL,
	tin nvarchar(255) NULL,
	site_id int NULL,
	market_outreach_rep nvarchar(255) NULL,
	hca nvarchar(255) NULL,
	director nvarchar(255) NULL,
	optumregion nvarchar(255) NULL,
	contracted_payment nvarchar(255) NULL,
	timelypmt nvarchar(255) NULL,
	latepmt nvarchar(255) NULL,
	cgappmt nvarchar(255) NULL,
	completenesspmt nvarchar(255) NULL,
	pmtsource nvarchar(255) NULL,
	gapgrpexcl nvarchar(255) NULL,
	hcfa_contract_number nvarchar(255) NULL,
	pbp nvarchar(255) NULL,
	pbp_state nvarchar(255) NULL,
	client nvarchar(255) NULL,
	client1 nvarchar(255) NULL,
	subclient nvarchar(255) NULL,
	lob2 nvarchar(255) NULL,
	clientregion nvarchar(255) NULL,
	clientstate nvarchar(255) NULL,
	businessunit nvarchar(255) NULL,
	lob nvarchar(255) NULL,
	health_plan nvarchar(255) NULL,
	clientid nvarchar(255) NULL,
	hpid nvarchar(255) NULL,
	maxdos datetime NULL,
	encounter_type nvarchar(255) NULL,
	cnt_telehealth bigint NULL,
	cnt_encounters bigint NULL,
	[2018include] nvarchar(255) NULL,
	[2018parentid] nvarchar(255) NULL,
	[2018deduped] nvarchar(255) NULL,
	userdefinedcategory1 nvarchar(255) NULL,
	userdefinedcategory2 nvarchar(255) NULL,
	userdefineddate1 datetime NULL,
	userdefineddate2 datetime NULL,
	userdefinednumber1 nvarchar(255) NULL,
	userdefinednumber2 nvarchar(255) NULL,
	refresh_date datetime NULL,
	wk_nbr int NULL,
	run_yr int NULL,
	IsSecondarySubmissionEligible nvarchar(255) NULL,
	IsGAThresholdMet nvarchar(255) NULL,
	IsDVThresholdMet nvarchar(255) NULL,
	IsCGapCriteriaMet nvarchar(255) NULL,
	ModifiedDate datetime NULL,
	SecondarySubmissionUpdateFlag nvarchar(50) NULL,
	UpdatedDate datetime NOT NULL,
	CreatedDate datetime NOT NULL,
	PAFCreatedDate datetime NOT NULL,
	PAFUpdatedDate datetime NOT NULL,
	RecordChangeType nvarchar(20) NULL,
	EligibleProgramType nvarchar(50) NULL,
	CPG nvarchar(2) NULL,
	CONSTRAINT PK_Member_Assessment PRIMARY KEY (chart_id,project_year)
);