R/hud_export_2020.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",
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", VictimServicesProvider = "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",
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", Geocode3 = "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",
NativeHIOtherPacific = "i", White = "i", RaceNone = "i",
Ethnicity = "i", Gender = "i", 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", LastPermanentZIP8 = "c",
AddressDataQuality = "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", MentalHealthIssuesFam = "i", PhysicalDisabilityFam = "i",
AlcoholDrugAbuseFam = "i", InsufficientIncome = "i",
IncarceratedParent = "i", ReferralSource = "i", CountOutreachReferralApproaches = "i",
UrgentReferral = "i", TimeToHousingLoss = "i", ZeroIncome = "i",
AnnualPercentAMI = "i", FinancialChange = "i", HouseholdChange = "i",
EvictionHistory = "i", SubsidyAtRisk = "i", LiteralHomelessHistory = "i",
DisabledHoH = "i", CriminalRecord = "i", SexOffender = "i",
DependentUnder6 = "i", SingleParent = "i", HH5Plus = "i",
IraqAfghanistan = "i", FemVet = "i", HPScreeningScore = "i",
ThresholdScore = "i", VAMCStation = "c", 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", ExchangeForSexPastThreeMo = "c",
I = "c", CountOfExchangeForSex = "i", AskedOrForcedToExchangeFor = "c",
I = "c", AskedOrForcedToExchangeFor = "c", I = "c", 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",
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", 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",
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",
SubTypeProvided = "i", Y = "c", 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(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")), 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",
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")), 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")), `Custom*` = c(CustomQuestionID = "c",
EnrollmentID = "c", PersonalID = "c", CustomQuestionGroup = "c",
CustomQuestionOrder = "i", CustomQuestion = "c", CustomAnswer = "c",
CustomDetailAnswer = "c", DateCreated = "T", DateUpdated = "T",
UserID = "c", DateDeleted = "T", ExportID = "c"))
COHHIO/hud.export documentation built on Sept. 6, 2024, 1:48 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
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",
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", VictimServicesProvider = "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",
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", Geocode3 = "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",
NativeHIOtherPacific = "i", White = "i", RaceNone = "i",
Ethnicity = "i", Gender = "i", 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", LastPermanentZIP8 = "c",
AddressDataQuality = "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", MentalHealthIssuesFam = "i", PhysicalDisabilityFam = "i",
AlcoholDrugAbuseFam = "i", InsufficientIncome = "i",
IncarceratedParent = "i", ReferralSource = "i", CountOutreachReferralApproaches = "i",
UrgentReferral = "i", TimeToHousingLoss = "i", ZeroIncome = "i",
AnnualPercentAMI = "i", FinancialChange = "i", HouseholdChange = "i",
EvictionHistory = "i", SubsidyAtRisk = "i", LiteralHomelessHistory = "i",
DisabledHoH = "i", CriminalRecord = "i", SexOffender = "i",
DependentUnder6 = "i", SingleParent = "i", HH5Plus = "i",
IraqAfghanistan = "i", FemVet = "i", HPScreeningScore = "i",
ThresholdScore = "i", VAMCStation = "c", 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", ExchangeForSexPastThreeMo = "c",
I = "c", CountOfExchangeForSex = "i", AskedOrForcedToExchangeFor = "c",
I = "c", AskedOrForcedToExchangeFor = "c", I = "c", 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",
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", 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",
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",
SubTypeProvided = "i", Y = "c", 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(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")), 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",
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")), 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")), `Custom*` = c(CustomQuestionID = "c",
EnrollmentID = "c", PersonalID = "c", CustomQuestionGroup = "c",
CustomQuestionOrder = "i", CustomQuestion = "c", CustomAnswer = "c",
CustomDetailAnswer = "c", DateCreated = "T", DateUpdated = "T",
UserID = "c", DateDeleted = "T", ExportID = "c"))
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.