The following sql will create the cdw view from PASI tables dbo.HomeEducationRegistration.
-- ============================================================================================= -- Last Update By: Jared Eberhardt -- Last Update Date: 2022-03-14 -- ============================================================================================= CREATE OR ALTER VIEW Cdw.HomeEducationRegistration_v AS SELECT HomeEducationRegistrationID , ReferenceID , StudentID , SchoolYear , ResidentSchoolBoardOrganizationID , NotificationDocumentRefID , RegistrationStartDate , RegistrationExitDate , RegistrationExitType , ExitDateTypeCodeID , IsDeleted , LastUpdateUtcTime , AuditUserID , CdwRowVersion = LastUpdateRowVersion FROM dbo.HomeEducationRegistration;