Cdw.HomeEducationRegistration_v

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;

Business Objects Returned