HUD User Home Page | HUD USER



PD&R REQUEST FORMNameLongitudinal FileDescriptionHousehold and household member descriptors from PIC and TRACSMetadata Version1Metadata Last ModifiedJuly 20, 2017Frequency of data generationAnnualSystem OwnerPD&RContact Email Lydia.B.Taghavi@Business Requirements:Generate the following 2 datasets – Household and Household Member - with the following variables from both the PIC and TRACS quarterly extracts: hshld_longitudinal_YYYYHousehold VariablesVariable NameDescriptionfrm_type_cdDetermines the data source 58: Form HUD-50058MTW: Moving to WorkTRACS: TRACSefctv_dtDate certification is effectivepgm_type_cdPIC – Rental housing assistance program in which the family participates:- P: Public Housing; CE: Section 8 Certificates; VO: Section 8 Vouchers; MR: Mod RehabT: MTW Tenant Based VoucherPR: MTW Project Based VoucherB: Indian HousingBlank: No Program Information availableTRACS – H1: Project-based Section 8H2: Rent SupplementH3: RAPH4: Section 236H5: BMIRH7: Section 202 PRACH8: Section 811 PRACH9: Section 202/162 PACactn_type_cdCurrent activity being reported58 & MTW 1 = new admission, 2 = annual reexamination, 3 = interim reexamination, 4 = portability move in (vouchers only), 5 = portability move out (vouchers only), 6 = end of participation, 7 = other change of unit, 8 = FSS/WtW addendum only, 9 = Annual reexamination searching (vouchers only), 10 = issuance of voucher, 11 = expiration of voucher, 12 = flat rent annual update (public housing only), 13 = annual HQS inspection only (Section 8 only), 14 = historical adjustment, 15 = voidTRACS IC = initial certification, AR = annual certification, IR = interim certification, MI = move in certification, MO = move out, TM = termination, CR = RAP to Section 8, CS = rent supplement to Section 8, CF = conversion fromWhen transaction type = MO or TM, actn_type_cd = transaction type. Otherwise, actn_type_cd = certification type.admsn_dtDate of initial admission to programwait_list_entry_dtDate the family was placed on the waiting list for the program under which they currently receive housing assistancepha_cdPublic Housing Authority (PHA) codedvlpt_numCode that uniquely identifies a project or a development to which a public housing unit belongsdvlpt_num_newNOTE: For 1995-2007 files ONLY. This column has the new 11-char code that uniquely identifies a project or a development to which a public housing unit belongs, that maps to the 8-char code (dvlpt_num)unit_bldg_numbuilding_number (Public Housing Only)unit_bldg_num_newNOTE: For 1995-2007 files ONLY. This column has the new Public Housing building number that maps to the old building number (unit_bldg_num). Until 2008, the Public Housing buildings in PIC were associated with the 8-char development numbers. After 2008, due to “Asset Management”, the 11-char development numbers were generated and buildings were regrouped and associated with these 11-char development numbers. The combination of “dvlpt_num_new” and “unit_bldg_num_new” maps to the pre-2008 combination of “dvlpt_num” and “unit_bldg_num”. unit_bldg_entrn_numbuilding_number_entrance (Public Housing Only)unit_numunit_number (Public Housing Only)cntrt_numMultifamily contract number (TRACS Only)proj_nameName of project if applicable (TRACS Only)proj_numFHA number (TRACS Only)srvcg_site_cdHUD field office code (TRACS only)hshd_head_ssn_idHead of Household SSN. hshd_mbr_total_cntTotal number of people in the householdnum_bedrm_cntTotal number of bedrooms in the unit occupiedtotal_dpndnt_cntTotal Number of Dependentsenhnc_vchr_ttp_amntTotal tenant payment if household has an enhanced voucheracsblty_rqstd_indrDid the family request accessibility features?acsblty_rcvd_indrDid the family receive the requested accessibility features?acsbl_unit_indrHas the PHA identified the unit as accessible?fss_prttn_indrDoes the family participate in any Family Self Sufficiency programs?hmls_indrHousehold classified as homeless at time of admissionhrdshp_indrIndicates the household qualifies for various additional subsidiesminm_rent_exmpt_cdIndicates household does not need to pay minimum rent (TRACS only)vchr_spcl_pgm_cdEV = enhanced voucher, WT = welfare to workvchr_type_cdTBV = Tenant Based Voucher, PBV = Project Based Voucher, HV = Homeownership Vouchersbsdy_stts_cdWhether the household qualifies for subsidytrmn_reasn_cdReason for household leaving program – MF onlyvery_low_incm_excptn_indrDoes family qualify over very low income limit?total_annl_incm_amntFamily’s total annual income from all sources, including assetstotal_antcptd_incm_amnt Total anticipated income amounttotal_mnthy_incm_amntAnnual Income amount divided by 12adj_annl_incm_amntTotal income less multiple deductionsadj_mnthy_incm_amntAnnual Adjusted Income amount divided by 12total_incm_after_exltn_amntTotal income minus amounts excluded from incometotal_asst_incm_amntIncome from assetsmnthy_wlfr_rent_amntIf the family receives welfare assistance, amount that the welfare assistance agency specifically designates for shelter and utilities.ttp_amntDepends on income and rent – see 50058minm_ttp_amntThe minimum rent amount that require the tenant to pay.total_asst_cash_vlueCash value of all assets if greater than $5000imptd_asst_incm_amntCash value of assets times passbook rateallwbl_dsblty_asstn_amntAmount of disability assistance the family is allowed to claimper_dpndnt_allwn_amntStandard allowance per dependentannl_child_care_cost_amntAmount allowed for child caremed_dsblty_asstn_allwn_amntThe family’s allowance for medical expenses and disability assistance expensesdsblty_asstn_earnng_amntOf a family’s dollars per year, the amount of earned income received by a family member (which can include the working disabled family member) who is 18 or older and who is enabled to work as a result of attendant care or apparatus for a family member with disabilitieseldly_dsblty_allwn_amntThe allowance for elderly/disabledmax_dsblty_allwn_amntAmount the PHA can potentially deduct for the family’s disability allowance.med_dsblty_trhld_amntThe product of the medical percent and the total annual incometotal_allwn_amntTotal allowed deductionstotal_dpndnt_allwn_amntTotal allowed deductions for dependentstotal_dsblty_med_amntThe sum of the family’s allowable disability assistance and total out of pocket medical expensestotal_med_expns_amntTotal allowed deductions for medical expensestotal_prmsbl_ddcn_amntTotal permissible deductionstotal_unreimb_dsblty_amntTotal unreimbursed medical expensestrvl_cost_work_schl_amntAmount deducted shall reflect reasonable charges necessary to attend school or to permit employmentmed_prcnt?Medical Percentagecc_schl_allwn_amntAllowed amount necessary to attend school or to permit employment (TRACS only)chld_care_work_amntAmount deducted shall reflect reasonable charges for child care. In the case of child care necessary to permit employment (TRACS only)cntnly_asstd_indrIndicate whether or not the family is continuously assisted under or currently enrolled in any 1937 Housing Act program at the time of admissionmdfd_dtDate the record was modifiedfmly_sbsdy_effctv_dtEffective dateoptnl_ernd_incm_ddctn_amntEarned income deduction – optionaldsstr_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘DHAPK’ ‘DVIKE’ ‘KATHU’NOTE: This information is not available for 2007 fup_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘FUP’ ‘FUPF’ ‘FUPY’NOTE: This information is not available for 2007hope6_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘HOPE’NOTE: This information is not available for 2007ms5_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘MS5’NOTE: This information is not available for 2007ned_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘MFDES’ ‘MS1’ ‘NED’ ‘NHT’ ‘PA’ ‘PHDES’ ‘PHDEP’NOTE: This information is not available for 2007phrr_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘PHRR’NOTE: This information is not available for 2007tcu_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘TCU’NOTE: This information is not available for 2007vash_spcl_pgm_indrIndicates if the household participates in any one of the following special program type code: ‘VASH’NOTE: This information is not available for 2007vacant_indrIndicates if a Public Housing unit is vacant?Income VariablesVariable NameDescriptiontotal_wage_incm_amntIncome sources B = own business, F = Federal wage, HA = PHA wage, M = military pay, W = other wages total_wlfr_incm_amntIncome sources G = general assistance, IW = annual imputed welfare income, T = TANF total_pnsn_incm_amntIncome sources P = pension, S = SSI, SS = Social Security total_other_incm_amntIncome sources C = child support, E = medical reimbursement, I = Indian trust / per capita, N = other non-wage source, U = unemployment benefits total_unknwn_incm_amntIncome sources = everything else total_earngs_amntSum of all income for members >= 18 years of agetotal_ddctns_amntif available?Family VariablesVariable NameDescriptionhead_gndr_cdHead Genderspse_gndr_cdSpouse genderchd_gndr_cdCo-head genderhead_age_yr_cntHead agespse_age_yr_cntSpouse agechd_age_yr_cntCo-head agedob_headHead of Household date of birthhead_eldly_indrIndicates if Head is elderly (>=62)spse_eldly_indrIndicates if Spouse is elderly (>=62)chd_eldly_indrIndicates if Co-head is elderly (>=62)head_dsblty_indrIndicates if head is disabled spse_dsblty_indrIndicates if spouse is disabledchd_dsblty_indrIndicates if co-head is disabledeldly_indrIndicates Elderly Household where Head(H), Spouse(S), or Co-Head (K) >= 62dsblty_indrIndicates Disabled Household where H, S, or K disabledhead_race_cdHead of Household’s Race Race 1 = white, 2 = black, 3 = native American, 4 = sian, 5 = Hawaiian or Pacific islander, 6 = more than one racehead_ethncy_cdHead of Household’s Ethnicity 1= Hispanic, 2 = non-Hispanicmtpl_race_indrIndicates if the Head of Household (H), Spouse (S), or Co-Head (K) for the family reported more than one raceh6_cd1=elderly, no children, 2=disabled (not elderly) no children, 3=not elderly or disabled, no children; 4=elderly with children, 5=disabled (not elderly) with children, 6=not elderly or disabled with childrendsbld_chldrn_cntNumber of disabled childrenchldrn_mbr_indrIndicates if the household has children chldrn_mbr_cntNumber of Childrenchldrn_age_0_3_cntNumber of children ages 0 to 3chldrn_age_4_5_cntNumber of children ages 4 to 5chldrn_age_6_12_cntNumber of children ages 6 to 12chldrn_age_13_17_cntNumber of children ages 13 to 17adlt_age_18_21_cntNumber of Adults ages 18 to 21adlt_age_22_25_cntNumber of Adults ages 22 to 25adlt_age_26_35_cntNumber of Adults ages 26 to 35adlt_age_36_49_cntNumber of Adults ages 36 to 49adlt_age_50_61_cntNumber of Adults ages 50 to 61adlt_age_62_85_cntNumber of Adults ages 62 to 85adlt_age_above85_cntNumber of Adults ages Over 85??Program VariablesVariable NameDescriptionclng_rent_indrMTW PH onlyclng_rent_amntRegular PH onlyadj_amrtztn_amntmanufactured home onlyfmly_clng_share_indrMTW homeownership onlycurr_base_rent_amntmod rehab onlymrkt_rent_amntTRACS onlybasic_236_rent_amntTRACS onlycost_bld_per_mnth_amntAmount billed to the original PHA if moved into current PHA via portabilityfmly_mvng_indrIs household moving into PHA under portability?fmly_rent_to_ownr_amntHousehold portion of rentflat_sbsdy_amntDollar amountflat_rent_amntAmount of rent charged the tenant that elects the Flat rent option – Public Housing Onlylwr_rent_amntLower of TTP or Ceiling Rent rent_type_cdF = flat, I = income basedfmr_excptn_rent_amntRental payment is authorized to not conform to FMR requirementsddctn_amntTotal of all deductionsfrntr_incl_indrfurniture included in rentgross_rent_amntContract rent plus utility allowance for most programs, gross home expense for Homeownershiphap_to_ownr_amntHousing assistance payment to the owner of the propertyhard_to_house_indrfamily qualifies as Hard to House if there are three or more minors or if there is a disabled family member and the family is moving to a different unitmnfctrd_hmwnr_spc_indrmanufactured homemr_indrmoderate rehabilitationmnthy_amrtztn_amntMonthly amoritizations8_bedrm_cnt Number of bedrooms that qualify for subsidymnthy_coop_condo_amntCo-op and condo fees paymentmnthy_hmown_pymnt_amntHomeownership expensemnthy_mntnc_allwn_amntMaintenance allowancemnthy_othr_allwn_amntOther deductions allowedmnthy_prncpl_intrs_amntPrincipal and interest paymentmnthy_repr_rpmt_allwn_amntAllowance for repairsasstn_pymnt_amntHUD’s full payment determined as follows: HCV: Lower of the gross rent or the payment standard minus the ttp; regular project based certificates and voucher: gross rent minus ttp; mod rehab: gross rent minus ttp; homeownership vouchers: lower of gross homeownership expenses or payment standard minus ttp; mtw homeownership: gross homeownership expenses minus tot_family_contribution; manufactured home: Gross rent minus tenant rentIncludes the assistance payment amount for “mixed families” – families where not all the members qualify for benefits. bld_pha_cdPublic housing authority billedps_amntStandard payment for housing assistanceport_indrIndicates household moved from initial location where qualified for benefitsproj_basd_indrVouchers that are for units within existing projects or housing developmentscntrt_rent_amntgross_home_exp minus utility allowancesro_hmls_pgm_indrSRO program for homeless individualssro_unit_indrSingle room occupancystrctr_type_cd1 = Single family detached, 2 = Semi-detached, 3 = Rowhouse/townhouse, 4 = Low-rise, 5 = High-rise, 6 = Manufactured hometnnt_rent_amntThis variable represents the tenant payment exclusive of the utility allowance for all the programs. Includes the tenant rent for “mixed families” – families where not all the members qualify for benefits. total_elgb_mbr_cnttotal number of household members who qualify for benefitstotal_fmly_crbtn_amntTotal amount family contributes to housing including the utility allowance. Generally gross rent minus Housing Assistance Payment (HAP). Includes the contribution for “mixed families” – families where not all the members qualify for benefits.total_mbr_cntTotal household memberstotal_vchr_sbsdy_amntHCV – the lesser of the gross rent or the payment standard.utlt_allwn_amntUtility Allowanceutlt_reimb_amntUtility Reimbursementunit_const_yryear the unit was builtprortn_prcntproportional percentage for households where not all members qualify for benefitsmxd_fmly_indrIndicates households where not all members qualify for benefits?Geographic VariablesVariable NameDescriptionunit_addr1_textStreet address of the unit – Line 1 (Input)unit_addr2_textStreet address of the unit – Line 2 (Input)unit_apt_numUnit Apartment Number (Input)unit_city_nameCity (Input)unit_state_cdState postal code (Input)unit_cnty_nameCounty nameunit_cnty_sbdvsn_cdCounty subdivision codeunit_blck_cdCensus blockunit_census_tract_cdCensus tractunit_fips_state_cdFIPS state codeunit_fips_cnty_cdFIPS county codeunit_state_cnty_trct_cdFIPS state+county+tractunit_place_cdPlace codeunit_zip_cdZIP code (Input)unit_old_zip_cdOld ZIP codeunit_cgsnl_dstrc_cdCongressional District (113th Congress)unit_lvl_cdLevel codeunit_lat_deg_msreLatitudeunit_lgt_deg_msreLongitudefmr_vluefair market rentext_low_inc_lmt_amntValue of 30% of the Median Income effective in the area (state/county/msa) the household is residing, the household’s effective date and size very_low_inc_lmt_amntValue of 50% of the Median Income effective in the area (state/count/msa) the household is residing, the household’s effective date and sizelow_inc_lmt_amntValue of 80% of the Median Income effective in the area (state/county/msa) the household is residing, the household’s effective date and sizestd_addrStandard address for Public Housing units based on “clean” Public Housing Unit addresses filestd_cityStandard city for Public Housing units based on “clean” Public Housing Unit addresses filestd_stStandard state for Public Housing units based on “clean” Public Housing Unit addresses filestd_zip9x9 char Standard zip code for Public Housing units based on “clean” Public Housing Unit addresses fileExternal VariablesVariable NameDescriptionpvrty_prcntPercent of the population below poverty level, in census tract where HUD assisted households reside (2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)mnrty_prcntMinorities as a % of total population in the census tract where HUD assisted families reside (2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)black_prcntPercent black as a % of total population in the census tract where HUD assisted families reside (2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)hispanic_prcntPercent Hispanic as a % of total population in the census tract where HUD assisted families reside(2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)white_prcntPercent non-Hispanic white as a % of total population in the census tract where HUD assisted families reside(2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)sfd_prcnt% of households who are owner-occupants of single-family detached homes in the census tract that surrounds the project(2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)tract_total_occpd_unit_cntTotal Occupied Units at the Census Tract Level(2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)tract_rntr_occpd_unit_cntTotal Renter-Occupied Units at the Census Tract Level(2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)cntrl_city_cdcentral city = '1', suburb = '0', neither = '2' (2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)pha_frml_nameFormal participant namepha_acc_unit_cntTotal ACC Unit Count at the PHA Level (Public Housing Only)pha_low_rent_unit_cntTotal Number of Low Rent Unit Count at the PHA Level (Public Housing Only)pha_sec8_unit_cntTotal Section 8 Unit Count at the PHA Leveldvlpmnt_acc_unit_cntTotal Number of ACC Units at the development level (Public Housing Only)bldg_acc_unit_cntTotal Number of ACC Units at the building level (Public Housing Only)prop_total_unit_cnttotal units in property (multifamily programs only)prop_asstd_unit_cnttotal assisted units in property (multifamily program only)cntrt_asstd_unit_cnttotal assisted units in contract (multifamily program only)dofa_actual_dtDate of Full Availability (DOFA) for Public Housing Developmentsext_low_inc_lmt_indrDetermines if the Total Annual Income of the family is less than 30% of median incomevery_low_inc_lmt_indr Determines if the Total Annual Income of the family is less than 50% of median incomemetro_populationMetro population(2012 and later files use Census 2010 designation)(2011 and earlier files use Census 2000 designation)cbsa_cdCBSA codedivn_cd CBSA division codemember_longitudinal_YYYYVariable NameDescriptionfrm_type_cdDetermines the data source 58: Form HUD-50058MTW: Moving to WorkTRACS: TRACSmbr_race_asian_indrMember specified as racembr_race_amrcn_indian_indrMember specified as racembr_race_black_indrMember specified as racembr_ctznshp_cdCitizenship statusPIC values EC = eligible citizen, EN = eligible non-citizen, IN = ineligible non-citizen, PV = pending verificationTRACS values EC = eligible citizen, EN = eligible non-citizen, IC = ineligible child, IN = ineligible non-citizen, IP = ineligible parent, PV = pending verification, XX = persons not counted under non-citizen rule mbr_dsblty_indrMember disabilitymbr_race_hwn_pacific_indrMember specified as racembr_cso_met_indrMeeting Community Service Requirementmbr_age_yr_cntMember agembr_dobMember date of birthmbr_ethncy_cdMember Ethnicity mbr_numUnique specifier for each household membermbr_gndr_cdMember gendermbr_rltn_cdRelationship to head-of-household H = head of household, S = spouse, K = co-head, F = foster child or adult, Y = youth under 18, D = dependent or other child, E = full time student 18+, L = live-in aid, A= other adult, O = other family member, N or X = none of the abovehshd_head_ssn_idHead of Household SSN. ssn_mbrMember SSN.mbr_race_white_indrMember specified as racembr_race_dclnd_indrMember declined to specify any racembr_other_incm_amntIncome sources C,CS = child support, E = medical reimbursement, I = Indian trust / per capita, N = other non-wage source, U = unemployment benefitsmbr_pnsn_incm_amntIncome sources P, PE, SSP = pension, S,SI = SSI, SS = Social Securitymbr_ddctns_amntEarnings deductions PIC onlymbr_unknwn_incm_amntIncome sources - everything else mbr_wage_incm_amntIncome sources B, EB = own business, F = Federal wage, HA = PHA wage, M = military pay, W = other wagesmbr_wlfr_incm_amntIncome sources G = general assistance, IW = annual imputed welfare income, T = TANFmbr_race_othr_indrMember specified some other racess_incm_amntIncome source SS=Social Securitytanf_incm_amntIncome source T = TANFother_wg_incm_amntIncome source W = other wagesgnrl_asstn_incm_amntIncome source G = general assistancechild_spprt_incm_amntIncome source C, CS = child supportfed_wg_incm_amnt Income source F = Federal wageother_nwg_source_incm_amntIncome source N = other non-wage sourcessi_incm_amnt Income source S, SI = SSI unemploy_bnft_incm_amntIncome source U = unemployment benefitsown_bsns_incm_amntIncome source B, EB = own businesspnsn_incm_amnt Income source P, PE, SSP = pensionmed_reimb_incm_amnt Income source E = medical reimbursementpha_wg_incm_amntIncome source HA = PHA wagemltry_pay_incm_amntIncome source M = military payannl_imptd_wlfr_incm_amntIncome source IW = annual imputed welfare incomeIndian_trust_incm_amnt Income source I = Indian trust / per capitaunknown_incm_amntIncome sources everything elseTime Period: The longitudinal data files (household and household member) are generated using the December quarterly extracts for PIC and TRACS. Data Source:PIC and TRACS December Quarterly Extractscensus_2010_data: 2010 percent poverty, percent minority, percent black, percent hispanic, percent nonhispanic white, percent single family, percent households or percent occupied, percent renter householdsCensus_2000_data: 2000 percent poverty, percent minority, percent black, percent hispanic, percent nonhispanic white, percent single family, percent households or percent occupied, percent renter households, Central City, Metro Populationprincipal_city_2010: 2010 Central City cbsa_metro_micro_pop_hu_sf1_2010: 2010 Metro PopulationCBSA_DIVISIONS_BY_COUNTY_2013: cbsa, divisionProcess: run_longitudinal – This is the main program which includes calls to other modules listed below. get_household_info – extract from the PIC database the household tables and create two household-level datasets: one dataset containing regular, PIC non-MTW household records (household_0) andsecond dataset containing the PIC MTW household records (household_1).get_mf_household_info – extract from the TRACS database the head table and create the TRACS household-level dataset with the TRACS multifamily household records (tracs_head).get_member_info – extract from the PIC & TRACS databases the member tables and create three member-level datasets: one dataset containing regular, PIC non-MTW member records (member), a second dataset containing MTW member records (mtw_member), and a third dataset containing the TRACS multifamily member records (multifam_members) from the TRACS FAMILY table.process_member_info – combine the three member-level datasets to create a family-level dataset (family_detail) containing summary variables describing the members of all the households.process_program_info – extract from the PIC database all the HUD program tables associated with the regular, non-MTW programs, MTW programs, and MultiFamily TRACS program. Combine all of these program-level records along with their respective geographic data elements and Fair Market Rent or FMR variables into a single dataset. get_income_info – extract from the PIC database the income records for regular, non-MTW members, the income records for MTW members, and the income records of the MultiFamily or TRACS progams members.output_member_file – combine the income datasets to create a summary of income at the household-level and then combine all income datasets to create member-level dataset of income amounts. Output the complete member-level dataset including individual demographic variables plus combined income amounts to an external folder (member_longitudinal_yyyy).get_external_data – add external data from sources specified output_household_file – combine all datasets into a household-level dataset including the complete dataset of household-level plus family-level plus family income plus program-level variables to an external folder (household_longitudinal_yyyy).Response Format:2 ea. SAS datasets: Household (hshld_longitudinal_yyyy) and Household Member (member_longitudinal_yyyy) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download