select dr.UserId as sourcedId
, dr.Status as status
, dr.DateLastModified as dateLastModified
, dr.BirthDate as birthDate
, dr.sex as sex
, dr.AmericanIndianOrAlaskaNative as americanIndianOrAlaskaNative
, dr.Asian as asian
, dr.BlackOrAfricanAmerican as blackOrAfricanAmerican
, dr.NativeHawaiianOrOtherPacificIslander as nativeHawaiianOrOtherPacificIslander
, dr.White as white
, dr.HispanicOrLatinoEthnicity as hispanicOrLatinoEthnicity
, dr.CountryOfBirthCode as countryOfBirthCode
, dr.StateOfBirthAbbreviation as stateOfBirthAbbreviation
, dr.CityOfBirth as cityOfBirth
from oneroster.Demographic dr