20Q2- Add fields from Furman Center Core

[AmandaDoyle]

Join on BBL after using DOF file to convert condo base lot to billing lot

Field	Alias	Description
SubsidyExp	Subsidy Expiration Date	When the last subsidy is set to expire
TaxIncntv	Tax Incentives	Tax incentives (value is filled with concatenated list of programs)
Financing	Financing and Land Subsidies	Financing (value is filled with concatenated list of programs)

Need HED input on how to populate fields

Is this the correct dataset?

[levysamu]

Yes it is the right dataset. Outstanding issues are:

• logic for when to make joins
• logic for how to populate fields in DevDB

[levysamu]

This should be the new schema for the Furman Center Data. It follows what is in the schema excel document.

Field name (13 char max)	Field name (10 char max)	Field name alias	Description
SubsidyExpire	SubsidyExp	Subsidy Expiration Date	When the last subsidy is set to expire
SubsidyName	SubsidyNm	Subsidy Name	Subsidy program names (value is filled with concatenated list of programs)
RegultryCond	RegCond	Regulatory Conditions of Subsidy	Whether the property contains units that are subject to income restrictions or rent regulations as a result of the subsidies associated with the construction