R/hud_export_2022.R

In COHHIO/hud.export: A package for retrieve HMIS data and HUD Export items from the BitFocus Clarity Looker API

list(Export = list(look = c(year2 = 65961, since2019 = 66543, 
daily = 65963, parity = 66677), col_types = c(ExportID = "c", 
SourceType = "i", SourceID = "c", SourceName = "c", SourceContactFirst = "c", 
SourceContactLast = "c", SourceContactPhone = "c", SourceContactExtension = "c", 
SourceContactEmail = "c", ExportDate = "T", ExportStartDate = "D", 
ExportEndDate = "D", SoftwareName = "c", SoftwareVersion = "c", 
CSVVersion = "c", ExportPeriodType = "i", ExportDirective = "i", 
HashStatus = "i"), fields = c(ExportDate = "csv_export.export_date", 
ExportDirective = "csv_export.export_directive", ExportEndDate = "csv_export.export_end_date", 
ExportID = "csv_export.export_id", ExportPeriodType = "csv_export.export_period_type", 
ExportStartDate = "csv_export.export_start_date", HashStatus = "csv_export.hash_status", 
SoftwareName = "csv_export.software_name", SoftwareVersion = "csv_export.software_version", 
SourceContactEmail = "csv_export.source_contact_email", SouceContactExtension = "csv_export.souce_contact_extension", 
SourceContactFirst = "csv_export.source_contact_first", SourceContactLast = "csv_export.source_contact_last", 
SourceContactPhone = "csv_export.source_contact_phone", SourceID = "csv_export.source_id", 
SourceName = "csv_export.source_name", SourceType = "csv_export.source_type"
)), Organization = list(look = c(year2 = 65525, since2019 = 66548, 
daily = 65930, parity = 66681), col_types = c(OrganizationID = "c", 
OrganizationName = "c", VictimServiceProvider = "i", OrganizationCommonName = "c", 
DateCreated = "T", DateUpdated = "T", UserID = "c", DateDeleted = "T", 
ExportID = "c"), fields = c(Added = "csv_organization.added", 
Deleted = "csv_organization.deleted", LastUpdated = "csv_organization.last_updated", 
ExportID = "csv_organization.export_id", CommonName = "csv_organization.common_name", 
ID = "csv_organization.id", Name = "csv_organization.name", RefUserUpdated = "csv_organization.ref_user_updated", 
VictimServiceProvider = "csv_organization.victim_service_provider"
)), User = list(look = c(year2 = 65529, since2019 = 66552, daily = 65934, 
parity = 66685), col_types = c(UserID = "c", UserFirstName = "c", 
UserLastName = "c", UserPhone = "c", UserExtension = "c", UserEmail = "c", 
DateCreated = "T", DateUpdated = "T", DateDeleted = "T", ExportID = "c"
), fields = c(DateCreated = "csv_user.date_created", DateDeleted = "csv_user.date_deleted", 
DateUpdated = "csv_user.date_updated", ExportID = "csv_user.export_id", 
RefAgency = "csv_user.ref_agency", UserEmail = "csv_user.user_email", 
UserExtension = "csv_user.user_extension", UserFirstName = "csv_user.user_first_name", 
UserID = "csv_user.user_id", UserLastName = "csv_user.user_last_name", 
UserPhone = "csv_user.user_phone")), Project = list(look = c(year2 = 65526, 
since2019 = 66549, daily = 65931, parity = 66682), col_types = c(ProjectID = "c", 
OrganizationID = "c", ProjectName = "c", ProjectCommonName = "c", 
OperatingStartDate = "D", OperatingEndDate = "D", ContinuumProject = "i", 
ProjectType = "i", HousingType = "i", ResidentialAffiliation = "i", 
TrackingMethod = "i", HMISParticipatingProject = "i", TargetPopulation = "i", 
HOPWAMedAssistedLivingFac = "i", PITCount = "i", DateCreated = "T", 
DateUpdated = "T", UserID = "c", DateDeleted = "T", ExportID = "c"
), fields = c(ContinuumProject = "csv_project.continuum_project", 
DateCreated = "csv_project.date_created", DateDeleted = "csv_project.date_deleted", 
DateUpdated = "csv_project.date_updated", ExportID = "csv_project.export_id", 
HmisParticipatingProject = "csv_project.hmis_participating_project", 
HousingType = "csv_project.housing_type", OperatingEndDate = "csv_project.operating_end_date", 
OperatingStartDate = "csv_project.operating_start_date", OrganizationID = "csv_project.organization_id", 
PitCount = "csv_project.pit_count", ProjectCommonName = "csv_project.project_common_name", 
ProjectID = "csv_project.project_id", ProjectName = "csv_project.project_name", 
ProjectType = "csv_project.project_type", ResidentialAffiliation = "csv_project.residential_affiliation", 
RefTargetB = "csv_project.ref_target_b", TrackingMethod = "csv_project.tracking_method", 
UserID = "csv_project.user_id")), Funder = list(look = c(year2 = 65949, 
since2019 = 66544, daily = 65925, parity = 66678), col_types = c(FunderID = "c", 
ProjectID = "c", Funder = "i", OtherFunder = "c", GrantID = "c", 
StartDate = "D", EndDate = "D", DateCreated = "T", DateUpdated = "T", 
UserID = "c", DateDeleted = "T", ExportID = "c"), fields = c(DateCreated = "csv_funder.date_created", 
DateDeleted = "csv_funder.DateDeleted", LastUpdated = "csv_funder.last_updated", 
End = "csv_funder.end", ExportID = "csv_funder.ExportId", FundingSource = "csv_funder.funding_source", 
ID = "csv_funder.id", Identifier = "csv_funder.identifier", NonFederalFundingSource = "csv_funder.non_federal_funding_source", 
RefProgram = "csv_funder.ref_program", RawID = "csv_funder.raw_id", 
Added = "csv_funder.added", RefUser = "csv_funder.ref_user")), 
    ProjectCoC = list(look = c(year2 = "65527", since2019 = "66550", 
    daily = "65932", api_nm = "Project CoC", parity = "66683"
    ), api_nm = "Project CoC", col_types = c(ProjectCoCID = "c", 
    ProjectID = "c", CoCCode = "c", Geocode = "c", Address1 = "c", 
    Address2 = "c", City = "c", State = "c", ZIP = "c", GeographyType = "i", 
    DateCreated = "T", DateUpdated = "T", UserID = "c", DateDeleted = "T", 
    ExportID = "c"), fields = c(Address = "csv_project_coc.address", 
    Address2 = "csv_project_coc.address2", City = "csv_project_coc.city", 
    CoC = "csv_project_coc.coc", AddedDate = "csv_project_coc.added_date", 
    DateDeleted = "csv_project_coc.date_deleted", LastUpdated = "csv_project_coc.last_updated", 
    ExportID = "csv_project_coc.export_id", RefGeolocation = "csv_project_coc.ref_geolocation", 
    RefGeographyType = "csv_project_coc.ref_geography_type", 
    ID = "csv_project_coc.id", RefProgram = "csv_project_coc.ref_program", 
    State = "csv_project_coc.state", RefUserUpdated = "csv_project_coc.ref_user_updated", 
    Zipcode = "csv_project_coc.zipcode")), Inventory = list(look = c(year2 = 65519, 
    since2019 = 66547, daily = 65928, parity = 66680), col_types = c(InventoryID = "c", 
    ProjectID = "c", CoCCode = "c", HouseholdType = "i", Availability = "i", 
    UnitInventory = "i", BedInventory = "i", CHVetBedInventory = "i", 
    YouthVetBedInventory = "i", VetBedInventory = "i", CHYouthBedInventory = "i", 
    YouthBedInventory = "i", CHBedInventory = "i", OtherBedInventory = "i", 
    ESBedType = "i", InventoryStartDate = "D", InventoryEndDate = "D", 
    DateCreated = "T", DateUpdated = "T", UserID = "c", DateDeleted = "T", 
    ExportID = "c"), fields = c(Availability = "csv_inventory.availability", 
    BedInventory = "csv_inventory.bed_inventory", ChronicInventory = "csv_inventory.chronic_inventory", 
    BedChVeteran = "csv_inventory.bed_ch_veteran", BedChYouth = "csv_inventory.bed_ch_youth", 
    CoC = "csv_inventory.coc", AddedDate = "csv_inventory.added_date", 
    DateDeleted = "csv_inventory.date_deleted", LastUpdated = "csv_inventory.last_updated", 
    RefBedType = "csv_inventory.ref_bed_type", ExportID = "csv_inventory.export_id", 
    RefHouseholdType = "csv_inventory.ref_household_type", EndDate = "csv_inventory.end_date", 
    ID = "csv_inventory.id", StartDate = "csv_inventory.start_date", 
    BedNonDedicated = "csv_inventory.bed_non_dedicated", RefProgram = "csv_inventory.ref_program", 
    UnitInventory = "csv_inventory.unit_inventory", RefUserUpdated = "csv_inventory.ref_user_updated", 
    VeteranInventory = "csv_inventory.veteran_inventory", YouthInventory = "csv_inventory.youth_inventory", 
    BedYouthVeteran = "csv_inventory.bed_youth_veteran")), Affiliation = list(
        look = c(year2 = 65501, since2019 = 66534, daily = 65914, 
        parity = 66668), col_types = c(AffiliationID = "c", ProjectID = "c", 
        ResProjectID = "c", DateCreated = "T", DateUpdated = "T", 
        UserID = "c", DateDeleted = "T", ExportID = "c"), fields = c(AffiliationID = "csv_affiliation.affiliation_id", 
        DateCreated = "csv_affiliation.added_date", DateDeleted = "csv_affiliation.date_deleted", 
        DateUpdated = "csv_affiliation.last_updated", ExportID = "csv_affiliation.export_id", 
        ProjectID = "csv_affiliation.id", ResProjectID = "csv_affiliation.aff_res_proj_id", 
        UserID = "csv_affiliation.ref_user")), Client = list(
        look = c(year2 = 65504, since2019 = 66535, daily = 65915, 
        parity = 66669), col_types = c(PersonalID = "c", FirstName = "c", 
        MiddleName = "c", LastName = "c", NameSuffix = "c", NameDataQuality = "i", 
        SSN = "c", SSNDataQuality = "i", DOB = "D", DOBDataQuality = "i", 
        AmIndAKNative = "i", Asian = "i", BlackAfAmerican = "i", 
        NativeHIPacific = "i", White = "i", RaceNone = "i", Ethnicity = "i", 
        Female = "i", Male = "i", NoSingleGender = "i", Transgender = "i", 
        Questioning = "i", GenderNone = "c", VeteranStatus = "i", 
        YearEnteredService = "i", YearSeparated = "i", WorldWarII = "i", 
        KoreanWar = "i", VietnamWar = "i", DesertStorm = "i", 
        AfghanistanOEF = "i", IraqOIF = "i", IraqOND = "i", OtherTheater = "i", 
        MilitaryBranch = "i", DischargeStatus = "i", DateCreated = "T", 
        DateUpdated = "T", UserID = "c", DateDeleted = "T", ExportID = "c"
        ), fields = c(DOB = "csv_client.birth_date", DOBDataQuality = "csv_client.dob_quality", 
        DateCreated = "csv_client.added_date", DateDeleted = "csv_client.date_deleted", 
        DateUpdated = "csv_client.last_updated", ExportID = "csv_client.export_id", 
        FirstName = "csv_client.first_name", LastName = "csv_client.last_name", 
        NameDataQuality = "csv_client.name_quality", ID = "csv_client.id", 
        SSN = "csv_client.ssn", SSNDataQuality = "csv_client.ssn_quality", 
        RefUserUpdated = "csv_client.ref_user_updated")), Enrollment = list(
        look = c(year2 = 65514, since2019 = 66539, daily = 65921, 
        parity = 66673), col_types = c(EnrollmentID = "c", PersonalID = "c", 
        ProjectID = "c", EntryDate = "D", HouseholdID = "c", 
        RelationshipToHoH = "i", LivingSituation = "i", LengthOfStay = "i", 
        LOSUnderThreshold = "i", PreviousStreetESSH = "i", DateToStreetESSH = "D", 
        TimesHomelessPastThreeYears = "i", MonthsHomelessPastThreeYears = "i", 
        DisablingCondition = "i", DateOfEngagement = "D", MoveInDate = "D", 
        DateOfPATHStatus = "D", ClientEnrolledInPATH = "i", ReasonNotEnrolled = "i", 
        WorstHousingSituation = "i", PercentAMI = "i", LastPermanentStreet = "c", 
        LastPermanentCity = "c", LastPermanentState = "c", LastPermanentZIP = "c", 
        AddressDataQuality = "i", ReferralSource = "i", CountOutreachReferralApproaches = "i", 
        DateOfBCPStatus = "D", EligibleForRHY = "i", ReasonNoServices = "i", 
        RunawayYouth = "i", SexualOrientation = "i", SexualOrientationOther = "c", 
        FormerWardChildWelfare = "i", ChildWelfareYears = "i", 
        ChildWelfareMonths = "i", FormerWardJuvenileJustice = "i", 
        JuvenileJusticeYears = "i", JuvenileJusticeMonths = "i", 
        UnemploymentFam = "i", MentalHealthDisorderFam = "i", 
        PhysicalDisabilityFam = "i", AlcoholDrugUseDisorderFam = "i", 
        InsufficientIncome = "i", IncarceratedParent = "i", VAMCStation = "c", 
        TargetScreenReqd = "i", TimeToHousingLoss = "i", AnnualPercentAMI = "i", 
        LiteralHomelessHistory = "i", ClientLeaseholder = "i", 
        HOHLeaseholder = "i", SubsidyAtRisk = "i", EvictionHistory = "i", 
        CriminalRecord = "i", IncarceratedAdult = "i", PrisonDischarge = "i", 
        SexOffender = "i", DisabledHoH = "i", CurrentPregnant = "i", 
        SingleParent = "i", DependentUnder6 = "i", HH5Plus = "i", 
        CoCPrioritized = "i", HPScreeningScore = "i", ThresholdScore = "i", 
        DateCreated = "T", DateUpdated = "T", UserID = "c", DateDeleted = "T", 
        ExportID = "c")), EnrollmentCoC = list(look = c(year2 = 65515, 
    since2019 = 66540, daily = 65922, parity = 66674), api_nm = "Enrollment CoC", 
        col_types = c(EnrollmentCoCID = "c", EnrollmentID = "c", 
        HouseholdID = "c", ProjectID = "c", PersonalID = "c", 
        InformationDate = "D", CoCCode = "c", DataCollectionStage = "i", 
        DateCreated = "T", DateUpdated = "T", UserID = "c", DateDeleted = "T", 
        ExportID = "c"), fields = c(CoC = "csv_enrollment_coc.coc", 
        DataCollectionStage = "csv_enrollment_coc.data_collection_stage", 
        AddedDate = "csv_enrollment_coc.added_date", Datedeleted = "csv_enrollment_coc.datedeleted", 
        LastUpdated = "csv_enrollment_coc.last_updated", EnrollmentCoCID = "csv_enrollment_coc.enrollment_coc_id", 
        EnrollmentID = "csv_enrollment_coc.enrollment_id", ExportID = "csv_enrollment_coc.exportid", 
        RefHousehold = "csv_enrollment_coc.ref_household", StartDate = "csv_enrollment_coc.start_date", 
        RefClient = "csv_enrollment_coc.ref_client", ID = "csv_enrollment_coc.id", 
        RefUser = "csv_enrollment_coc.ref_user")), Exit = list(
        look = c(year2 = 65512, since2019 = 66613, daily = 65924, 
        parity = 66686), col_types = c(ExitID = "c", EnrollmentID = "c", 
        PersonalID = "c", ExitDate = "D", Destination = "i", 
        OtherDestination = "c", HousingAssessment = "i", SubsidyInformation = "i", 
        ProjectCompletionStatus = "i", EarlyExitReason = "i", 
        ExchangeForSex = "i", ExchangeForSexPastThreeMonths = "i", 
        CountOfExchangeForSex = "i", AskedOrForcedToExchangeForSex = "i", 
        AskedOrForcedToExchangeForSexPastThreeMonths = "i", WorkplaceViolenceThreats = "i", 
        WorkplacePromiseDifference = "i", CoercedToContinueWork = "i", 
        LaborExploitPastThreeMonths = "i", CounselingReceived = "i", 
        IndividualCounseling = "i", FamilyCounseling = "i", GroupCounseling = "i", 
        SessionCountAtExit = "i", PostExitCounselingPlan = "i", 
        SessionsInPlan = "i", DestinationSafeClient = "i", DestinationSafeWorker = "i", 
        PosAdultConnections = "i", PosPeerConnections = "i", 
        PosCommunityConnections = "i", AftercareDate = "D", AftercareProvided = "i", 
        EmailSocialMedia = "i", Telephone = "i", InPersonIndividual = "i", 
        InPersonGroup = "i", CMExitReason = "i", DateCreated = "T", 
        DateUpdated = "T", UserID = "c", DateDeleted = "T", ExportID = "c"
        ), fields = c(Aftercaredate = "csv_exit.aftercaredate", 
        RhyAftercareYn = "csv_exit.rhy_aftercare_yn", RhyExploitationAsk = "csv_exit.rhy_exploitation_ask", 
        RhyExploitationAskTimes = "csv_exit.rhy_exploitation_ask_times", 
        VashCaseMgtExitReason = "csv_exit.vash_case_mgt_exit_reason", 
        RhyLaborExploitationForcedTricked = "csv_exit.rhy_labor_exploitation_forced_tricked", 
        RhyCounseling = "csv_exit.rhy_counseling", RhyExploitationFrequency = "csv_exit.rhy_exploitation_frequency", 
        AddedDate = "csv_exit.added_date", Datedeleted = "csv_exit.datedeleted", 
        LastUpdated = "csv_exit.last_updated", ExitDestination = "csv_exit.exit_destination", 
        RhyDestSafeClient = "csv_exit.rhy_dest_safe_client", 
        RhyDestSafeCaseworker = "csv_exit.rhy_dest_safe_caseworker", 
        RhyCompletionInvoluntaryReason = "csv_exit.rhy_completion_involuntary_reason", 
        RhyAftercareEmailsocialmedia = "csv_exit.rhy_aftercare_emailsocialmedia", 
        EnrollmentID = "csv_exit.enrollment_id", RhyExploitation = "csv_exit.rhy_exploitation", 
        RhyExploitationTimes = "csv_exit.rhy_exploitation_times", 
        EndDate = "csv_exit.end_date", ID = "csv_exit.id", ExportID = "csv_exit.exportid", 
        RhyCounselingFamily = "csv_exit.rhy_counseling_family", 
        RhyCounselingGroup = "csv_exit.rhy_counseling_group", 
        HousingAssExit = "csv_exit.housing_ass_exit", RhyAftercareInpersongroup = "csv_exit.rhy_aftercare_inpersongroup", 
        RhyAftercareInpersonindividual = "csv_exit.rhy_aftercare_inpersonindividual", 
        RhyCounselingIndividual = "csv_exit.rhy_counseling_individual", 
        RhyLaborExploitationTimes = "csv_exit.rhy_labor_exploitation_times", 
        ExitDestinationOther = "csv_exit.exit_destination_other", 
        RefClient = "csv_exit.ref_client", RhyAdultConnect = "csv_exit.rhy_adult_connect", 
        RhyCommunityConnect = "csv_exit.rhy_community_connect", 
        RhyPeerConnect = "csv_exit.rhy_peer_connect", RhyCounselingPostExitPlan = "csv_exit.rhy_counseling_post_exit_plan", 
        RhyCompletionStatus = "csv_exit.rhy_completion_status", 
        RhyCounselingNumSessions = "csv_exit.rhy_counseling_num_sessions", 
        RhyCounselingNumPlanned = "csv_exit.rhy_counseling_num_planned", 
        SubsidyInformation = "csv_exit.subsidy_information", 
        RhyAftercareTelephone = "csv_exit.rhy_aftercare_telephone", 
        RefUser = "csv_exit.ref_user", RhyLaborExploitationThreats = "csv_exit.rhy_labor_exploitation_threats", 
        RhyLaborExploitationPayment = "csv_exit.rhy_labor_exploitation_payment"
        )), IncomeBenefits = list(look = c(year2 = 65518, since2019 = 66545, 
    daily = 65927, parity = 66679), api_nm = "Income Benefits", 
        col_types = c(IncomeBenefitsID = "c", EnrollmentID = "c", 
        PersonalID = "c", InformationDate = "D", IncomeFromAnySource = "i", 
        TotalMonthlyIncome = "c", Earned = "i", EarnedAmount = "c", 
        Unemployment = "i", UnemploymentAmount = "c", SSI = "i", 
        SSIAmount = "c", SSDI = "i", SSDIAmount = "c", VADisabilityService = "i", 
        VADisabilityServiceAmount = "c", VADisabilityNonService = "i", 
        VADisabilityNonServiceAmount = "c", PrivateDisability = "i", 
        PrivateDisabilityAmount = "c", WorkersComp = "i", WorkersCompAmount = "c", 
        TANF = "i", TANFAmount = "c", GA = "i", GAAmount = "c", 
        SocSecRetirement = "i", SocSecRetirementAmount = "c", 
        Pension = "i", PensionAmount = "c", ChildSupport = "i", 
        ChildSupportAmount = "c", Alimony = "i", AlimonyAmount = "c", 
        OtherIncomeSource = "i", OtherIncomeAmount = "c", OtherIncomeSourceIdentify = "c", 
        BenefitsFromAnySource = "i", SNAP = "i", WIC = "i", TANFChildCare = "i", 
        TANFTransportation = "i", OtherTANF = "i", OtherBenefitsSource = "i", 
        OtherBenefitsSourceIdentify = "c", InsuranceFromAnySource = "i", 
        Medicaid = "i", NoMedicaidReason = "i", Medicare = "i", 
        NoMedicareReason = "i", SCHIP = "i", NoSCHIPReason = "i", 
        VAMedicalServices = "i", NoVAMedReason = "i", EmployerProvided = "i", 
        NoEmployerProvidedReason = "i", COBRA = "i", NoCOBRAReason = "i", 
        PrivatePay = "i", NoPrivatePayReason = "i", StateHealthIns = "i", 
        NoStateHealthInsReason = "i", IndianHealthServices = "i", 
        NoIndianHealthServicesReason = "i", OtherInsurance = "i", 
        OtherInsuranceIdentify = "c", HIVAIDSAssistance = "i", 
        NoHIVAIDSAssistanceReason = "i", ADAP = "i", NoADAPReason = "i", 
        RyanWhiteMedDent = "i", NoRyanWhiteReason = "c", ConnectionWithSOAR = "i", 
        DataCollectionStage = "i", DateCreated = "T", DateUpdated = "T", 
        UserID = "c", DateDeleted = "T", ExportID = "c"), fields = c(HealthHivAdap = "csv_income_benefits.health_hiv_adap", 
        IncomeSpousalSupportIs = "csv_income_benefits.income_spousal_support_is", 
        IncomeSpousalSupport = "csv_income_benefits.income_spousal_support", 
        BenefitsNoncash = "csv_income_benefits.benefits_noncash", 
        HealthInsCobra = "csv_income_benefits.health_ins_cobra", 
        IncomeChildsupportIs = "csv_income_benefits.income_childsupport_is", 
        IncomeChildsupport = "csv_income_benefits.income_childsupport", 
        SoarConnected = "csv_income_benefits.soar_connected", 
        ScreenType = "csv_income_benefits.screen_type", AddedDate = "csv_income_benefits.added_date", 
        DateDeleted = "csv_income_benefits.date_deleted", LastUpdated = "csv_income_benefits.last_updated", 
        IncomeEarnedIs = "csv_income_benefits.income_earned_is", 
        IncomeEarned = "csv_income_benefits.income_earned", HealthInsEmp = "csv_income_benefits.health_ins_emp", 
        RefProgram = "csv_income_benefits.ref_program", ExportID = "csv_income_benefits.export_id", 
        IncomeGaIs = "csv_income_benefits.income_ga_is", IncomeGa = "csv_income_benefits.income_ga", 
        HealthHiv = "csv_income_benefits.health_hiv", ID = "csv_income_benefits.id", 
        IncomeCash = "csv_income_benefits.income_cash", CIndianHealthServiceProgram = "csv_income_benefits.c_indian_health_service_program", 
        Program = "csv_income_benefits.program", HealthInsurance = "csv_income_benefits.health_insurance", 
        BenefitsMedicaid = "csv_income_benefits.benefits_medicaid", 
        BenefitsMedicare = "csv_income_benefits.benefits_medicare", 
        HopwaHivAdapReason = "csv_income_benefits.hopwa_hiv_adap_reason", 
        HopwaCobraReason = "csv_income_benefits.hopwa_cobra_reason", 
        HopwaEmpReason = "csv_income_benefits.hopwa_emp_reason", 
        HopwaHivServicesReason = "csv_income_benefits.hopwa_hiv_services_reason", 
        IndianHealthReason = "csv_income_benefits.indian_health_reason", 
        HopwaMedicaidReason = "csv_income_benefits.hopwa_medicaid_reason", 
        HopwaMedicareReason = "csv_income_benefits.hopwa_medicare_reason", 
        HopwaPpayReason = "csv_income_benefits.hopwa_ppay_reason", 
        HopwaSchipReason = "csv_income_benefits.hopwa_schip_reason", 
        HopwaStateReason = "csv_income_benefits.hopwa_state_reason", 
        HopwaVaMedicalReason = "csv_income_benefits.hopwa_va_medical_reason", 
        BenefitsOther = "csv_income_benefits.benefits_other", 
        BenefitsOtherSource = "csv_income_benefits.benefits_other_source", 
        IncomeOther = "csv_income_benefits.income_other", IncomeOtherIs = "csv_income_benefits.income_other_is", 
        IncomeOtherSource = "csv_income_benefits.income_other_source", 
        OtherHealthInsurance = "csv_income_benefits.other_health_insurance", 
        OtherHealthInsuranceSpecify = "csv_income_benefits.other_health_insurance_specify", 
        BenefitsTanfOther = "csv_income_benefits.benefits_tanf_other", 
        IncomePrivatePensionIs = "csv_income_benefits.income_private_pension_is", 
        IncomePrivatePension = "csv_income_benefits.income_private_pension", 
        RefClient = "csv_income_benefits.ref_client", IncomePrivateDisabilityIs = "csv_income_benefits.income_private_disability_is", 
        IncomePrivateDisability = "csv_income_benefits.income_private_disability", 
        HealthInsPpay = "csv_income_benefits.health_ins_ppay", 
        BenefitsSchip = "csv_income_benefits.benefits_schip", 
        BenefitSnap = "csv_income_benefits.benefit_snap", IncomeSsdiIs = "csv_income_benefits.income_ssdi_is", 
        IncomeSsdi = "csv_income_benefits.income_ssdi", IncomeSsiIs = "csv_income_benefits.income_ssi_is", 
        IncomeSsi = "csv_income_benefits.income_ssi", IncomeSsRetirementIs = "csv_income_benefits.income_ss_retirement_is", 
        IncomeSsRetirement = "csv_income_benefits.income_ss_retirement", 
        HealthInsState = "csv_income_benefits.health_ins_state", 
        IncomeTanfIs = "csv_income_benefits.income_tanf_is", 
        IncomeTanf = "csv_income_benefits.income_tanf", BenefitsTanfChildcare = "csv_income_benefits.benefits_tanf_childcare", 
        BenefitsTanfTransportation = "csv_income_benefits.benefits_tanf_transportation", 
        IncomeIndividual = "csv_income_benefits.income_individual", 
        IncomeUnemploymentIs = "csv_income_benefits.income_unemployment_is", 
        IncomeUnemployment = "csv_income_benefits.income_unemployment", 
        RefUser = "csv_income_benefits.ref_user", IncomeVetPensionIs = "csv_income_benefits.income_vet_pension_is", 
        IncomeVetPension = "csv_income_benefits.income_vet_pension", 
        IncomeVetDisabilityIs = "csv_income_benefits.income_vet_disability_is", 
        IncomeVetDisability = "csv_income_benefits.income_vet_disability", 
        BenefitsVaMedical = "csv_income_benefits.benefits_va_medical", 
        BenefitsWic = "csv_income_benefits.benefits_wic", IncomeWorkersCompIs = "csv_income_benefits.income_workers_comp_is", 
        IncomeWorkersComp = "csv_income_benefits.income_workers_comp"
        )), HealthAndDV = list(look = c(year2 = 65517, since2019 = 66542, 
    daily = 65926, parity = 66676), api_nm = "Health DV", col_types = c(HealthAndDVID = "c", 
    EnrollmentID = "c", PersonalID = "c", InformationDate = "D", 
    DomesticViolenceVictim = "i", WhenOccurred = "i", CurrentlyFleeing = "i", 
    GeneralHealthStatus = "i", DentalHealthStatus = "i", MentalHealthStatus = "i", 
    PregnancyStatus = "i", DueDate = "D", LifeValue = "i", SupportFromOthers = "i", 
    BounceBack = "i", FeelingFrequency = "i", DataCollectionStage = "i", 
    DateCreated = "T", DateUpdated = "T", UserID = "c", DateDeleted = "T", 
    ExportID = "c"), fields = c(HealthDvFleeing = "csv_health_dv.health_dv_fleeing", 
    ScreenType = "csv_health_dv.screen_type", AddedDate = "csv_health_dv.added_date", 
    DateDeleted = "csv_health_dv.date_deleted", LastUpdated = "csv_health_dv.last_updated", 
    RhyDentalHealth = "csv_health_dv.rhy_dental_health", HealthDv = "csv_health_dv.health_dv", 
    HealthPregnancyDate = "csv_health_dv.health_pregnancy_date", 
    RefProgram = "csv_health_dv.ref_program", ExportID = "csv_health_dv.ExportID", 
    HealthGeneral = "csv_health_dv.health_general", ID = "csv_health_dv.id", 
    ProgramDate = "csv_health_dv.program_date", HealthMental = "csv_health_dv.health_mental", 
    RefClient = "csv_health_dv.ref_client", HealthPregnancy = "csv_health_dv.health_pregnancy", 
    RefUser = "csv_health_dv.ref_user", HealthDvOccurred = "csv_health_dv.health_dv_occurred"
    )), EmploymentEducation = list(look = c(year2 = 65509, since2019 = 66538, 
    daily = 65920, parity = 66672), api_nm = "Employment Education", 
        col_types = c(EmploymentEducationID = "c", EnrollmentID = "c", 
        PersonalID = "c", InformationDate = "D", LastGradeCompleted = "i", 
        SchoolStatus = "i", Employed = "i", EmploymentType = "i", 
        NotEmployedReason = "i", DataCollectionStage = "i", DateCreated = "T", 
        DateUpdated = "T", UserID = "c", DateDeleted = "T", ExportID = "c"
        ), fields = c(ScreenType = "csv_employment_education.screen_type", 
        AddedDate = "csv_employment_education.added_date", DateDeleted = "csv_employment_education.date_deleted", 
        LastUpdated = "csv_employment_education.last_updated", 
        EmploymentIs = "csv_employment_education.employment_is", 
        ID = "csv_employment_education.id", RhyEmploymentType = "csv_employment_education.rhy_employment_type", 
        RefProgram = "csv_employment_education.ref_program", 
        ExportID = "csv_employment_education.ExportID", ProgramDate = "csv_employment_education.program_date", 
        RhyEducationLevel = "csv_employment_education.rhy_education_level", 
        RhyReasonNotEmployed = "csv_employment_education.rhy_reason_not_employed", 
        RefClient = "csv_employment_education.ref_client", RhySchoolStatus = "csv_employment_education.rhy_school_status", 
        RefUser = "csv_employment_education.ref_user")), Disabilities = list(
        look = c(year2 = 65508, since2019 = 66537, daily = 65919, 
        parity = 66671), col_types = c(DisabilitiesID = "c", 
        EnrollmentID = "c", PersonalID = "c", InformationDate = "D", 
        DisabilityType = "i", DisabilityResponse = "i", IndefiniteAndImpairs = "i", 
        TCellCountAvailable = "i", TCellCount = "i", TCellSource = "i", 
        ViralLoadAvailable = "i", ViralLoad = "i", ViralLoadSource = "i", 
        AntiRetroviral = "i", DataCollectionStage = "i", DateCreated = "T", 
        DateUpdated = "T", UserID = "c", DateDeleted = "T", ExportID = "c"
        ), fields = c(ScreenType = "csv_disabilities.screen_type", 
        AddedDate = "csv_disabilities.added_date", DateDeleted = "csv_disabilities.date_deleted", 
        LastUpdated = "csv_disabilities.last_updated", ID = "csv_disabilities.id", 
        DisabilityResponse = "csv_disabilities.disability_response", 
        DisabilityType = "csv_disabilities.disability_type", 
        RefProgram = "csv_disabilities.ref_program", ExportID = "csv_disabilities.ExportID", 
        DisablingCondition = "csv_disabilities.disabling_condition", 
        ProgramDate = "csv_disabilities.program_date", RefClient = "csv_disabilities.ref_client", 
        TcellCountNumber = "csv_disabilities.tcell_count_number", 
        TcellCountAvailable = "csv_disabilities.tcell_count_available", 
        TcellDataObtained = "csv_disabilities.tcell_data_obtained", 
        RefUser = "csv_disabilities.ref_user", ViralLoadNumber = "csv_disabilities.viral_load_number", 
        ViralLoadAvailable = "csv_disabilities.viral_load_available", 
        ViralLoadObtained = "csv_disabilities.viral_load_obtained"
        )), Services = list(look = c(year2 = 65528, since2019 = 66551, 
    daily = 65933, parity = 66684), col_types = c(ServicesID = "c", 
    EnrollmentID = "c", PersonalID = "c", DateProvided = "D", 
    RecordType = "i", TypeProvided = "i", OtherTypeProvided = "c", 
    MovingOnOtherType = "c", SubTypeProvided = "i", FAAmount = "c", 
    ReferralOutcome = "i", DateCreated = "T", DateUpdated = "T", 
    UserID = "c", DateDeleted = "T", ExportID = "c"), fields = c(DateCreated = "csv_client_services.date_created", 
    DateDeleted = "csv_client_services.date_deleted", DateProvided = "csv_client_services.date_provided", 
    DateProvidedRaw = "csv_client_services.date_provided_raw", 
    DateUpdated = "csv_client_services.date_updated", EnrollmentID = "csv_client_services.enrollment_id", 
    ExportID = "csv_client_services.export_id", FaAmount = "csv_client_services.fa_amount", 
    OtherTypeProvided = "csv_client_services.other_type_provided", 
    PersonalID = "csv_client_services.personal_id", RecordType = "csv_client_services.record_type", 
    RefServiceItem = "csv_client_services.ref_service_item", 
    ReferralOutcome = "csv_client_services.referral_outcome", 
    ServicesIdRaw = "csv_client_services.services_id_raw", ServicesID = "csv_client_services.services_id", 
    SubTypeProvided = "csv_client_services.sub_type_provided", 
    TypeProvided = "csv_client_services.type_provided", UserID = "csv_client_services.user_id"
    )), CurrentLivingSituation = list(look = c(year2 = 65506, 
    since2019 = 66536, daily = 65918, parity = 66670), api_nm = "Current Living Situation", 
        col_types = c(CurrentLivingSitID = "c", EnrollmentID = "c", 
        PersonalID = "c", InformationDate = "D", CurrentLivingSituation = "i", 
        VerifiedBy = "c", LeaveSituation14Days = "i", SubsequentResidence = "i", 
        ResourcesToObtain = "i", LeaseOwn60Day = "i", MovedTwoOrMore = "i", 
        LocationDetails = "c", DateCreated = "T", DateUpdated = "T", 
        UserID = "c", DateDeleted = "T", ExportID = "c"), fields = c(ID = "csv_current_living_situation.id", 
        CurrentLivingSituation = "csv_current_living_situation.current_living_situation", 
        AddedDate = "csv_current_living_situation.added_date", 
        DateDeleted = "csv_current_living_situation.date_deleted", 
        LastUpdated = "csv_current_living_situation.last_updated", 
        RefProgram = "csv_current_living_situation.ref_program", 
        ExportID = "csv_current_living_situation.ExportID", ProgramDate = "csv_current_living_situation.program_date", 
        Ph60Days = "csv_current_living_situation.ph_60_days", 
        LivingSituation14Days = "csv_current_living_situation.living_situation_14_days", 
        LocationDetails = "csv_current_living_situation.location_details", 
        Moved60Days = "csv_current_living_situation.moved_60_days", 
        RefClient = "csv_current_living_situation.ref_client", 
        ResourceNetworksPh = "csv_current_living_situation.resource_networks_ph", 
        ScreenType = "csv_current_living_situation.screen_type", 
        StatusScreenType = "csv_current_living_situation.status_screen_type", 
        SubswquentResidence = "csv_current_living_situation.subswquent_residence", 
        RefUser = "csv_current_living_situation.ref_user", VerifiedBy = "csv_current_living_situation.verified_by"
        )), Assessment = list(col_types = c(AssessmentID = "c", 
    EnrollmentID = "c", PersonalID = "c", AssessmentDate = "D", 
    AssessmentLocation = "c", AssessmentType = "i", AssessmentLevel = "i", 
    PrioritizationStatus = "i", DateCreated = "T", DateUpdated = "T", 
    UserID = "c", DateDeleted = "T", ExportID = "c")), AssessmentQuestions = list(
        col_types = c(AssessmentQuestionID = "c", AssessmentID = "c", 
        EnrollmentID = "c", PersonalID = "c", AssessmentQuestionGroup = "c", 
        AssessmentQuestionOrder = "i", AssessmentQuestion = "c", 
        AssessmentAnswer = "c", DateCreated = "T", DateUpdated = "T", 
        UserID = "c", DateDeleted = "T", ExportID = "c")), AssessmentResults = list(
        col_types = c(AssessmentResultID = "c", AssessmentID = "c", 
        EnrollmentID = "c", PersonalID = "c", AssessmentResultType = "c", 
        AssessmentResult = "c", DateCreated = "T", DateUpdated = "T", 
        UserID = "c", DateDeleted = "T", ExportID = "c")), Event = list(
        look = c(year2 = 65516, since2019 = 66541, daily = 65923, 
        parity = 66675), col_types = c(EventID = "c", EnrollmentID = "c", 
        PersonalID = "c", EventDate = "D", Event = "i", ProbSolDivRRResult = "i", 
        ReferralCaseManageAfter = "i", LocationCrisisOrPHHousing = "c", 
        ReferralResult = "i", ResultDate = "D", DateCreated = "T", 
        DateUpdated = "T", UserID = "c", DateDeleted = "T", ExportID = "c"
        ), fields = c(DateCreated = "csv_event.date_created", 
        DateDeleted = "csv_event.date_deleted", DateUpdated = "csv_event.date_updated", 
        EnrollmentID = "csv_event.enrollment_id", Event = "csv_event.event", 
        EventDate = "csv_event.event_date", EventID = "csv_event.event_id", 
        ExportID = "csv_event.export_id", LocationCrisisOrPhHousing = "csv_event.location_crisis_or_ph_housing", 
        PersonalID = "csv_event.personal_id", ProbSolDivRrResult = "csv_event.prob_sol_div_rr_result", 
        ReferralCaseManageAfter = "csv_event.referral_case_manage_after", 
        ReferralResult = "csv_event.referral_result", ResultDate = "csv_event.result_date", 
        UserID = "csv_event.user_id")), YouthEducationStatus = list(
        col_types = c(YouthEducationStatusID = "c", EnrollmentID = "c", 
        PersonalID = "c", InformationDate = "D", CurrentSchoolAttend = "i", 
        MostRecentEdStatus = "i", CurrentEdStatus = "i", DataCollectionStage = "i", 
        DateCreated = "T", DateUpdated = "T", UserID = "c", DateDeleted = "T", 
        ExportID = "c")))