GitHub - Corrona-IT/CDM-SQL_Repository: To be used as a archival center for all CDM SQL Code, Views, Tables and Stored Procedures

Name		Name	Last commit message	Last commit date
Latest commit History 188 Commits
22Sep2023		22Sep2023
22Sep2023_Production		22Sep2023_Production
DEV_Reporting_April2024		DEV_Reporting_April2024
DEV_Reporting_Aug2024		DEV_Reporting_Aug2024
DEV_Reporting_Dec2023		DEV_Reporting_Dec2023
DEV_Reporting_Dec2024		DEV_Reporting_Dec2024
DEV_Reporting_Jan2024		DEV_Reporting_Jan2024
DEV_Reporting_Jan2025		DEV_Reporting_Jan2025
DEV_Reporting_July2024		DEV_Reporting_July2024
DEV_Reporting_Jun2024		DEV_Reporting_Jun2024
DEV_Reporting_Mar2024		DEV_Reporting_Mar2024
DEV_Reporting_May2024		DEV_Reporting_May2024
DEV_Reporting_Nov2023		DEV_Reporting_Nov2023
DEV_Reporting_Oct2024		DEV_Reporting_Oct2024
DEV_Reporting_October2023		DEV_Reporting_October2023
PROD_Reporting_April2024		PROD_Reporting_April2024
PROD_Reporting_Aug2024		PROD_Reporting_Aug2024
PROD_Reporting_Dec2023		PROD_Reporting_Dec2023
PROD_Reporting_Dec2024		PROD_Reporting_Dec2024
PROD_Reporting_Jan2024		PROD_Reporting_Jan2024
PROD_Reporting_Jan2025		PROD_Reporting_Jan2025
PROD_Reporting_July2024		PROD_Reporting_July2024
PROD_Reporting_Jun2024		PROD_Reporting_Jun2024
PROD_Reporting_Mar2024		PROD_Reporting_Mar2024
PROD_Reporting_May2024		PROD_Reporting_May2024
PROD_Reporting_Nov2023		PROD_Reporting_Nov2023
PROD_Reporting_Oct2023		PROD_Reporting_Oct2023
PROD_Reporting_Oct2024		PROD_Reporting_Oct2024
MULTI.t_SubjectIDChecks.Table.sql		MULTI.t_SubjectIDChecks.Table.sql
MULTI.t_op_RegistryCounts.Table.sql		MULTI.t_op_RegistryCounts.Table.sql
MULTI.t_op_SiteProfile.Table.sql		MULTI.t_op_SiteProfile.Table.sql
MULTI.t_op_SiteVisits.Table.sql		MULTI.t_op_SiteVisits.Table.sql
MULTI.usp_IDErrors.StoredProcedure.sql		MULTI.usp_IDErrors.StoredProcedure.sql
MULTI.usp_IDErrors_V2.StoredProcedure.sql		MULTI.usp_IDErrors_V2.StoredProcedure.sql
MULTI.usp_SubjectIDErrors_OLD_KEEP.StoredProcedure.sql		MULTI.usp_SubjectIDErrors_OLD_KEEP.StoredProcedure.sql
MULTI.usp_op_FullDataEntryLag.StoredProcedure.sql		MULTI.usp_op_FullDataEntryLag.StoredProcedure.sql
MULTI.usp_op_MULTIREG_VisitAccruals.StoredProcedure.sql		MULTI.usp_op_MULTIREG_VisitAccruals.StoredProcedure.sql
MULTI.usp_op_RegistryCounts.StoredProcedure.sql		MULTI.usp_op_RegistryCounts.StoredProcedure.sql
MULTI.usp_op_RegistryCountsScheduler.StoredProcedure.sql		MULTI.usp_op_RegistryCountsScheduler.StoredProcedure.sql
MULTI.usp_op_SiteProfile.StoredProcedure.sql		MULTI.usp_op_SiteProfile.StoredProcedure.sql
MULTI.usp_op_SiteProfile_Pre8Nov2021.StoredProcedure.sql		MULTI.usp_op_SiteProfile_Pre8Nov2021.StoredProcedure.sql
MULTI.usp_op_SiteScorecard.StoredProcedure.sql		MULTI.usp_op_SiteScorecard.StoredProcedure.sql
MULTI.v_op_CombinedPTVisitTracker.View.sql		MULTI.v_op_CombinedPTVisitTracker.View.sql
MULTI.v_op_FollowUpBreakdown.View.sql		MULTI.v_op_FollowUpBreakdown.View.sql
MULTI.v_op_RCCSpecs.View.sql		MULTI.v_op_RCCSpecs.View.sql
NMO750.t_DataEntryLag.Table.sql		NMO750.t_DataEntryLag.Table.sql
NMO750.t_op_AllDrugs.Table.sql		NMO750.t_op_AllDrugs.Table.sql
NMO750.t_op_DECompletion.Table.sql		NMO750.t_op_DECompletion.Table.sql
NMO750.t_op_DrugListing.Table.sql		NMO750.t_op_DrugListing.Table.sql
NMO750.t_op_PatientVisitTracker.Table.sql		NMO750.t_op_PatientVisitTracker.Table.sql
NMO750.t_op_SubjectLog.Table.sql		NMO750.t_op_SubjectLog.Table.sql
NMO750.t_op_VisitLog.Table.sql		NMO750.t_op_VisitLog.Table.sql
NMO750.t_op_VisitLog_wTestSubjects.Table.sql		NMO750.t_op_VisitLog_wTestSubjects.Table.sql
NMO750.t_pv_NonSeriousEvents.Table.sql		NMO750.t_pv_NonSeriousEvents.Table.sql
NMO750.t_pv_TAEQCListing.Table.sql		NMO750.t_pv_TAEQCListing.Table.sql
NMO750.usp_op_AllDrugs.StoredProcedure.sql		NMO750.usp_op_AllDrugs.StoredProcedure.sql
NMO750.usp_op_DECompletion.StoredProcedure.sql		NMO750.usp_op_DECompletion.StoredProcedure.sql
NMO750.usp_op_DataEntryLag.StoredProcedure.sql		NMO750.usp_op_DataEntryLag.StoredProcedure.sql
NMO750.usp_op_PatientVisitTracker.StoredProcedure.sql		NMO750.usp_op_PatientVisitTracker.StoredProcedure.sql
NMO750.usp_op_SubjectLog.StoredProcedure.sql		NMO750.usp_op_SubjectLog.StoredProcedure.sql
NMO750.usp_op_VisitLog.StoredProcedure.sql		NMO750.usp_op_VisitLog.StoredProcedure.sql
NMO750.usp_pv_NonSeriousEvents.StoredProcedure.sql		NMO750.usp_pv_NonSeriousEvents.StoredProcedure.sql
NMO750.usp_pv_TAEQCListing.StoredProcedure.sql		NMO750.usp_pv_TAEQCListing.StoredProcedure.sql
NMO750.v_SiteParameter.View.sql		NMO750.v_SiteParameter.View.sql
NMO750.v_SiteStatus.View.sql		NMO750.v_SiteStatus.View.sql
NMO750.v_eventcrfs.View.sql		NMO750.v_eventcrfs.View.sql
NMO750.v_op_Comorbidities.View.sql		NMO750.v_op_Comorbidities.View.sql
NMO750.v_op_CorronaDB_Logs.View.sql		NMO750.v_op_CorronaDB_Logs.View.sql
NMO750.v_op_EarlyFU.View.sql		NMO750.v_op_EarlyFU.View.sql
NMO750.v_op_Missingness.View.sql		NMO750.v_op_Missingness.View.sql
NMO750.v_op_RecruitmentReport.View.sql		NMO750.v_op_RecruitmentReport.View.sql
NMO750.v_op_SiteScorecard.View.sql		NMO750.v_op_SiteScorecard.View.sql
NMO750.v_op_subjects.View.sql		NMO750.v_op_subjects.View.sql
NMO750.v_pv_PregnancyTracking.View.sql		NMO750.v_pv_PregnancyTracking.View.sql
POWER.AssessmentWeek.Table.sql		POWER.AssessmentWeek.Table.sql
POWER.t_op_CaseMgmtCompliance.Table.sql		POWER.t_op_CaseMgmtCompliance.Table.sql
POWER.t_op_IneligibleSubjects.Table.sql		POWER.t_op_IneligibleSubjects.Table.sql
POWER.t_op_POWERPaymentReport.Table.sql		POWER.t_op_POWERPaymentReport.Table.sql
POWER.t_op_PaymentHistory.Table.sql		POWER.t_op_PaymentHistory.Table.sql
POWER.t_op_UAT_CaseMgmtCompliance.Table.sql		POWER.t_op_UAT_CaseMgmtCompliance.Table.sql
POWER.usp_op_CaseMgmtCompliance.StoredProcedure.sql		POWER.usp_op_CaseMgmtCompliance.StoredProcedure.sql
POWER.usp_op_PaymentReport.StoredProcedure.sql		POWER.usp_op_PaymentReport.StoredProcedure.sql
POWER.usp_op_UAT_CaseMgmtCompliance.StoredProcedure.sql		POWER.usp_op_UAT_CaseMgmtCompliance.StoredProcedure.sql
POWER.v_op_AssessmentWeek.View.sql		POWER.v_op_AssessmentWeek.View.sql
POWER.v_op_CaseManagementLookup.View.sql		POWER.v_op_CaseManagementLookup.View.sql
POWER.v_op_EnrollmentAndPatientStatus.View.sql		POWER.v_op_EnrollmentAndPatientStatus.View.sql
POWER.v_op_EnrollmentAndPatientStatus_payments.View.sql		POWER.v_op_EnrollmentAndPatientStatus_payments.View.sql
POWER.v_op_uat_CaseManagementLookup.View.sql		POWER.v_op_uat_CaseManagementLookup.View.sql
PSA400.EventType.Table.sql		PSA400.EventType.Table.sql
PSA400.EventTypeBU.Table.sql		PSA400.EventTypeBU.Table.sql
PSA400.t_DataEntryCompletion.Table.sql		PSA400.t_DataEntryCompletion.Table.sql
PSA400.t_DataEntryLag.Table.sql		PSA400.t_DataEntryLag.Table.sql
PSA400.t_HB.Table.sql		PSA400.t_HB.Table.sql
PSA400.t_HBCompareVisitLog.Table.sql		PSA400.t_HBCompareVisitLog.Table.sql
PSA400.t_PV_SAE_DetectionReport.Table.sql		PSA400.t_PV_SAE_DetectionReport.Table.sql
PSA400.t_PV_SAE_DetectionReport_UAT.Table.sql		PSA400.t_PV_SAE_DetectionReport_UAT.Table.sql
PSA400.t_PV_TAEQC.Table.sql		PSA400.t_PV_TAEQC.Table.sql
PSA400.t_op_CAT_Enrollment.Table.sql		PSA400.t_op_CAT_Enrollment.Table.sql
PSA400.t_op_DOI_CAT.Table.sql		PSA400.t_op_DOI_CAT.Table.sql
PSA400.t_op_DOI_Enroll_FirstFU.Table.sql		PSA400.t_op_DOI_Enroll_FirstFU.Table.sql

Uh oh!

Folders and files

Latest commit

History

About

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Packages