Before connection string Step 1data source=10.10.2.182;initial catalog=Lexidatalive;User ID=GIS_mu33;Password=RifRal890#12@;
After Lexi connectionstring
GetAllSections
api.geesemed.com
{"data":[{"Section_uniq_id":"SEC00059","Expr1":"SEC00059","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Assessments","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00054","Expr1":"SEC00054","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"UDI","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00051","Expr1":"SEC00051","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Health Concerns","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00050","Expr1":"SEC00050","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Mental Status","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00049","Expr1":"SEC00049","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Goals","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00017","Expr1":"SEC00017","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Reason for Referral","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00015","Expr1":"SEC00015","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Encounter Diagnosis","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00014","Expr1":"SEC00014","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Care Plan","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00012","Expr1":"SEC00012","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Functional Status","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00009","Expr1":"SEC00009","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Immunization","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00008","Expr1":"SEC00008","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Results","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00007","Expr1":"SEC00007","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Vital Sign","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00006","Expr1":"SEC00006","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Procedures","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00005","Expr1":"SEC00005","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Problem List","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00004","Expr1":"SEC00004","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Social History","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00002","Expr1":"SEC00002","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Allergy","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00001","Expr1":"SEC00001","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Medication","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null}]}
section Not Null
api.geesemed.com
Prob in Generate CCD
Before connection string Step 1
data source=10.10.2.182;initial catalog=Lexidatalive;User ID=GIS_mu33;Password=RifRal890#12@;
After Lexi connectionstring
GetAllSections
api.geesemed.com
{"data":[{"Section_uniq_id":"SEC00059","Expr1":"SEC00059","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Assessments","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00054","Expr1":"SEC00054","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"UDI","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00051","Expr1":"SEC00051","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Health Concerns","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00050","Expr1":"SEC00050","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Mental Status","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00049","Expr1":"SEC00049","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Goals","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00017","Expr1":"SEC00017","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Reason for Referral","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00015","Expr1":"SEC00015","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Encounter Diagnosis","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00014","Expr1":"SEC00014","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Care Plan","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00012","Expr1":"SEC00012","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Functional Status","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00009","Expr1":"SEC00009","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Immunization","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00008","Expr1":"SEC00008","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Results","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00007","Expr1":"SEC00007","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Vital Sign","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00006","Expr1":"SEC00006","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Procedures","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00005","Expr1":"SEC00005","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Problem List","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00004","Expr1":"SEC00004","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Social History","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00002","Expr1":"SEC00002","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Allergy","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null},{"Section_uniq_id":"SEC00001","Expr1":"SEC00001","Pre_grp_Uniq_id":"CPG00016","SectionGrp_Masterkey":"CPG00016","Section_Name":"Medication","Pre_grp_title":"Clinical","ClientID":"14W","Active":true,"CPID":"14W1BX","DisplayID":null}]}
section Not Null
ClinicalList nt null
14W 1BX 15DIY Clinical 
Validate Generate CCD 1
api.geesemed.com
Validate Generate CCD before gen.ccd
Prob in Generate CCD