Survey of Income and Program Participation 2004 Panel Wave 3 
Assets and Liabilities Recode Edit Specifications

Revised 12/12/06


1)	These recodes should be on the household record of the Real Estate, Vehicles, and Dependent 
Care Topical Module).

2)	Where applicable, the current specifications are shown first, followed by the pre 1996 
specifications.  The pre 1996 specifications are italicized and prefaced with the following 
statement: "Note:  Pre 1996 Specifications."

3)  	Ordering is necessary from the top down.































 Survey of Income and Program Participation 2004 Panel Wave 3 
Assets and Liabilities Recode Edit Specifications

Table of Contents

SUBROUTINE								            PAGE
					
RHHTNW	   	. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	1
RHHTWLTH              . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	2
RHHTHEQ		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	4
RHHMORTG		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	6
RHHVEHCL		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	8
RHHBEQ		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	10
RHHINTBK		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	13
RHHINTOT		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	15
RHHSTK		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	17
RHHORE		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	19
RHHOTAST		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	22
RHHIRA		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	24
RHHTHRIF                . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	26
RHHDEBT		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	28
RHHSCDBT		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	29
RHHUSCBT		. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 	35










	











MACRO/
SUBROUTINE NAME:	RHHTNW

VARIABLE:
{
RHHTNW
--C Real Estate - Household level data
--S HRE:  Total net worth 
--Y E
--:L:
--     Total net worth recode
--:L:
--V	0 None or Not in universe
--V	-999999999:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

RHHTWLTH		Household level recode variable indicating total wealth. 
			
RHHUSCBT 		Household level recode variable indicating total unsecured debt.

OUTPUT VARIABLES:	
		
RHHTNW		Household level recode variable indicating total net worth.

DETAILED SPECIFICATIONS: 

The total net worth recode (RHHTNW) is equal to the total wealth recode (RHHTWLTH) minus the 
total unsecured debt recode (RHHUSCBT).

RHHTNW = RHHTWLTH - RHHUSCBT

IMPUTATION MATRIX:  Not applicable


MACRO/
SUBROUTINE NAME:	RHHTWLTH

VARIABLE:
{
RHHTWLTH		
--C  Real Estate - Household level data
--S HRE:  Total wealth
--Y E
--:L:
--   Total wealth recode
--:L
--V	0 None or Not in universe
--V	-999999999:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:

RHHTHEQ     	Home equity recode						
RHHVEHCL	Net equity in vehicles recode
RHHBEQ	Business equity recode	
RHHINTBK	Interest earning assets held at banking institutions recode 
RHHINTOT	Interest earning assets held at other institutions recode 
RHHSTK	Equity in stock and mutual funds shares recode
RHHORE	Real estate recode 
RHHOTAST	Other assets recode
RHHIRA	IRA and KEOGH accounts recode
RHHTHRIF	Equity in 401k and Thrift savings accounts


OUTPUT VARIABLES:

RHHTWLTH	Household level recode variable indicating total wealth.




DETAILED SPECIFICATIONS:
The total wealth recode (RHHTWLTH) is equal to the home equity recode (RHHTHEQ) plus
Net equity in vehicles recode  (RHHVEHCL) plus
Business equity recode  (RHHBEQ) plus
Interest earning assets held at banking institutions recode  (RHHINTBK) plus
Interest earning assets held at other institutions recode (RHHINTOT) plus
Equity in stock and mutual funds shares recode  (RHHSTK) plus
Real estate recode (RHHORE) plus
Other assets recode  (RHHOTAST) plus
IRA and KEOGH accounts recode (RHHIRA) plus
Equity in 401k and Thrift Savings accounts.

RHHTWLTH = RHHTHEQ + RHHVEHCL + RHHBEQ + RHHINTBK + RHHINTOT +
               RHHSTK + RHHORE + RHHOTAST + RHHIRA+RHHTHRIF

IMPUTATION MATRIX:  Not applicable



























MACRO/
SUBROUTINE NAME:	RHHTHEQ

VARIABLE:
{
RHHTHEQ
--C  Real Estate - Household level data
--S HRE:  Home equity 
--Y E
--:L:
--  Home equity recode
--:L
--V	0 None or Not in universe
--V	-999999999:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members, 
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

EPROPVAL	Edited variable of current value of the property.
		
EMHVAL	Edited variable of amount the mobile home and site would sell for.

RHHMORTG	Household level recode variable of total debt owed on home.


OUTPUT VARIABLES:	

RHHTHEQ	Household level recode variable of home equity.

DETAILED SPECIFICATIONS:

The home equity recode (RHHTHEQ) is equal to the market value (EPROPVAL or EMHVAL for 
mobile homes) minus the total debt owed on home recode (RHHMORTG).

RHHTHEQ = EPROPVAL or EMHVAL - RHHMORTG.

Note:  Pre 1996 Specifications:
RHHTHEQ = Market value (TM8598 or TM8630 for mobile homes) minus total debt owed on 
home (HMORTG)

IMPUTATION MATRIX:  Not applicable






































MACRO/
SUBROUTINE NAME:	RHHMORTG

VARIABLE:
{
RHHMORTG
--C  Real Estate - Household level data
--S HRE: Total debt on home
--Y E
--:L:
--   Total debt on home recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U 	This variable was calculated using information provided for all adults 15 or older in the
--U  	household, but the final value was written to the record of all household members,
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

REMOBHO				Recode variable indicating whether or not the 
residence is a mobile home.
				
EMOR1PR, EMOR2PR, EMOR3PR	Edited variable of the sum of first or second mortgage or the 
sum of all other mortgages or equity loans.
										
	EMHPR 				Edited variable of the total amount of the principal owed on the mobile home.

OUTPUT VARIABLES: 		

RHHMORTG				Household level recode variable indicating total 
debt owed on home.	





DETAILED SPECIFICATIONS:

The total debt on home recode (RHHMORTG) is determined as follows:

If the residence is not a mobile home (REMOBHO = 2) then
	Sum the first mortgage (EMOR1PR) plus
		the second mortgage (EMOR2PR) plus
		All other mortgages or equity loans (EMOR3PR)
If residence is a mobile home (REMOBHO = 1)
	then the household level recode variable indicating total debt owed on home is equal to the edited 
total amount of the principal owed on the mobile home (RHHMORTG = EMHPR).  


If residence is not a mobile home:
RHHMORTG = EMOR1PR + EMOR2PR + EMOR3PR

If residence is a mobile home:
RHHMORTG = EMHPR

Note:  Pre 1996 Specifications:

RHHMORTG = If not a mobile home (TM8528 = 2) then
	Sum first mortgage (TM8564) plus
		second mortgage (TM8566) plus
		All other mortgages or equity loans (TM8596)
If a mobile home (TM8528 = 1)
	HHMORTG =TM8624

IMPUTATION MATRIX:  Not applicable













MACRO/
SUBROUTINE NAME:	RHHVEHCL

VARIABLE:
{
RHHVEHCL
--C  Real Estate - Household level data
--S HRE: Net equity in vehicles
--Y E
--:L:
--   Net equity in vehicles recode
--:L
--V	0 None or Not in universe
--V	-999999999:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

RCARVAL1,  RCARVAL2, RCARVAL3 	Edited car value for the first, second, or third 
vehicle.

EA1AMT, EA2AMT2, EA3AMT		Edited variable of the amount owed for the first, second or third 
vehicle.		

EOV1VAL,  EOV2VAL				Edited variable of the value of the first or 
second other vehicle.

EOV1AMT,  EOV2AMT				Edited variable of the amount owed for the first 
or second other vehicle.

OUTPUT VARIABLES: 		

RHHVEHCL				Household level recode variable indicating net 
equity in vehicles.


DETAILED SPECIFICATIONS:
The net equity in vehicles recode (RHHVEHCL) is equal to the sum of the edited car value for the first 
vehicle minus  the edited amount owed for the first vehicle (RCARVAL1 minus EA1AMT) plus the 
edited car value for the second vehicle minus the edited amount owed for the second vehicle 
(RCARVAL2 minus EA2AMT ) plus the edited car value for the third vehicle minus the edited amount 
owed for the third vehicle (RCARVAL3 minus EA3AMT) plus the edited value of the first other vehicle 
minus the edited amount owed for the first other vehicle (EOV1VAL minus EOV1AMT) plus the edited 
value of the second other vehicle minus the edited amount owed for the second other vehicle 
(EOV2VAL minus EOV2AMT).

RHHVEHCL = (RCARVAL1 - EA1AMT) + (RCARVAL2 -EA2AMT) +
		              (RCARVAL3 - EA3AMT) + (EOV1VAL - EOV1AMT) +
		              (EOV2VAL - EOV2AMT)

Note:  Pre 1996 Specifications:

RHHVEHCL = Sum of (TMCARVAL1  minus TM8760) + (TMCARVAL2 minus TM8761 or 
TM8762) + (TMCARVAL3 minus TM8762) + (TM8788 minus TM8796) +
(TM8790 minus TM9798)

IMPUTATION MATRIX:  Not applicable










MACRO/
SUBROUTINE NAME:	RHHBEQ

VARIABLE:
{
RHHBEQ
--C  Real Estate - Household level data
--S HRE: Business equity 
--Y E
--:L:
--   Business equity recode
--:L
--V	0 None or Not in universe
--V	-999999999:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,    
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	No  		

INPUT VARIABLES:	

EPROPB		Edited variable of whether the respondent owns the business alone 
or in a partnership.	 

EVBOW1, EVBOW2		Edited variable of the percentage of the first business, or second 
business owned by the respondent.

EVBVA1, EVBVA2		Edited variable of the value of the first or second business before 
figuring in any debts owed against it.

EVBDE1, EVBDE2		Edited variable of the total debt owed against the first or second 
business.

UVBHM1, UVBHM2		Internal variable called UVBHM which asks whether the 
information about the business has already been obtained from 
another household member.

OUTPUT VARIABLES:

RHHBEQ		Business equity recode variable.
DETAILED SPECIFICATIONS:

NOTE:  The following specifications were applied to the Census Bureau's internal file.  They cannot be 
replicated using the public use files due to recoding of the variables pertaining to the second business.

The business equity recode (RHHBEQ) is determined as follows:

For business #1:

The equity equals the edited variable of the percentage of the first business owned by the respondent -- 
dividing the percent by 100 gives the proportion of the business owned , then multiply this proportion by 
the value of the business as a whole minus the amount of debt owed on the business. 
(EVBOW1)/100*(EVBVA1-EVBDE1)

If there are no debts held against the first business (EVBDE1=0), or the person does not have a 
business, then the value of this calculation should be 0.

For business #2:

The equity equals the edited variable of the percentage of the second business owned by the respondent  
--dividing the percent by 100 gives the proportion of the business owned, then multiply this proportion 
by the value of the business as a whole minus the amount of debt owed on the business. 
(EVBOW2)/100 *(EVBVA2-EVBDE2)

If there are no debts held against the second business (EVBDE2=0), or the person does not have a 
second business, then the value of this calculation should be 0.

Sum up business #1 equity and business #2 equity  for each adult 15+ on the last day of the reference 
period for total household business equity recode amount.

RHHBEQ = (EVBOW1)/100*(EVBVA1-EVBDE1) + (EVBOW2)/100*(EVBVA2-EVBDE2)










Note:  Pre 1996 Specifications:

Business #1

(Note: for calculations only:  If TM8002 = 1, then TM8004 = 100)

To compute RHHBEQ:   If TM8006 = 1 then (TM8004 / 100)  X  (TM8008* minus TM8012*)
*NOTE: from another household members record

If TM8006 = 2 then (TM8004 / 100)  X  (TM8008 minus TM8012)	
*NOTE: from another household members record

Business #2

(Note: for calculations only:  If TM8018 = 1, then TM8020 = 100)

To compute RHHBEQ:  If TM8022 = 1 then (TM8020 / 100)  X  (TM8024* minus TM8028*)
*NOTE: from another household members record

If TM8022 = 2 then (TM8020 / 100)  X  (TM8024 minus TM8028)	
*NOTE: from another household members record
Sum all the above for all adults 15+ in the last month of the reference period, month 4.

IMPUTATION MATRIX:  Not applicable















		


MACRO/
SUBROUTINE NAME:	RHHINTBK

VARIABLE:
{
RHHINTBK
--C  Real Estate - Household level data
--S HRE:  Interest earning assets held in banking institutions
--Y E
--:L:
--   Interest earning assets held in banking institutions recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members, 
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

EIAJTA	Edited variable of the amount of money the respondent had in jointly 
held interest earning accounts with spouse.  (Savings account, Interest 
earning checking accounts, money market deposit accounts, Certificates 
of Deposits)

EIAITA	Edited variable of the amount of money the respondent had in their 
interest earning accounts owned in own name.

OUTPUT VARIABLES: 

RHHINTBK	Household level recode variable indicating amount in Interest Earning 
assets held in banking institutions.







DETAILED SPECIFICATIONS:

The interest earning assets held in banking institutions recode (RHHINTBK) is equal to the
edited amount in the respondents jointly held interest earning accounts with spouse plus the edited 
amount respondent held in interest earning assets in own name.

RHHINTBK = EIAJTA + EIAITA

Sum all the above for all adults 15+ in the household on the last day of the reference period of month 4.

Note:  Pre 1996 Specifications:

RHHINTBK = SC4314 + SC4322

Sum all the above for all adults 15+ in the household on the last day of the reference period of 
month 4.

IMPUTATION MATRIX:  Not applicable























MACRO/
SUBROUTINE NAME:	RHHINTOT

VARIABLE:
{
RHHINTOT
--C  Real Estate - Household level data
--S HRE:  Interest earning assets held in other institutions
--Y E
--:L:
--   Interest earning assets held in other (nonfinancial) institutions recode 
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U	 regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:		

EIMJA		Edited variable of the of the amount of money the respondent held in 
their joint municipal bonds, corporate bonds or U.S. Securities 
accounts with spouse.

EIMIA 		Edited variable of the amount of the money held in municipal or 
corporate bonds or U.S. Government securities held in own name.

OUTPUT VARIABLES: 	

RHHINTOT		Household level recode variable indicating amount in 
interest earning assets held in other institutions.






DETAILED SPECIFICATIONS:
The interest earning assets held in other (nonfinancial) institutions recode (RHHINTOT) 
is equal to the amount in US Government securities (EIMJA) plus the amount in municipal or corporate 
bonds plus (EIMIA).

RHHINTOT = EIMJA + EIMIA

Sum all the above for all adults 15+ in the household on the last day of the reference period of month 4.

Note:  Pre 1996 Specifications:

RHHINTOT = SC4414 + SC4422

Sum all the above for all adults 15+ in the household on the last day of the reference period of 
month 4.

IMPUTATION MATRIX:  Not applicable






MACRO/
SUBROUTINE NAME:	RHHSTK

VARIABLE:
{
RHHSTK
--C  Real Estate - Household level data
--S HRE:   Equity in stocks and mutual fund shares
--Y E
--:L:
--    Equity in stocks and mutual fund shares recode
--:L
--V	0 None or Not in universe
--V	-999999999:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U 	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

ESMJV	Edited variable of the market value of jointly held stocks and mutual 
funds with spouse.

ESMJMAV	Edited variable of the amount of the debt or margin account on the 
respondents jointly owned stocks and mutual funds with spouse.

ESMIV 	Edited variable of the market value of the mutual funds or stocks owned 
in own name.

ESMIMAV	Edited variable of the amount of the debt or margin account on the 
respondent?s stocks and mutual funds owned in own name.

OUTPUT VARIABLES:

RHHSTK	Household level recode variable indicating amount of equity in 			stocks and mutual fund shares.


DETAILED SPECIFICATIONS:
The equity in stocks and mutual fund shares recode (RHHSTK) is equal to the edited market value of 
stocks and mutual fund shares held with spouse, minus the edited amount of the debt or margin account 
held against this account.

To the above amount add the edited market value of the mutual funds or stocks owned in own name 
minus the edited amount of the debt or margin against account.  

RHHSTK =  (ESMJV - ESMJMAV) + (ESMIV - ESMIMAV)

Sum all the above for all adults 15+ in the household on the last day of the reference period of month 4.

Note:  Pre 1996 Specifications:

RHHSTK = (TM8034 minus TM8040) + (TM8044 minus TM8050)

Sum all the above for all adults 15+ in the household on the last day of the reference period 
of month 4.

IMPUTATION MATRIX:  Not applicable













										








MACRO/
SUBROUTINE NAME:	RHHORE

VARIABLE:
{
RHHORE
--C  Real Estate - Household level data
--S HRE:   Equity in real estate that is not your own home.
--Y E
--:L:
--   Recode equity in real estate that is not your own home, such as rental properties and other real
estate
--:L
--V	0 None or Not in universe
--V	-999999999:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members, 
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:		

EOTHREVA  	Edited variable of the equity in other real estate.

ERTSHA 	Edited variable of the total value of respondent's share of equity (or 
loss) in the rental property owned jointly with other than spouse, not 
attached or located on own residence as of the last day of the reference 
period.

ERJAT	Edited variable indicating whether or not any of the rental properties owned jointly with spouse 
is attached to or located on the same land as residence.
		
ERJATA	Edited variable indicating whether or not all of the rental properties 
owned jointly with spouse is attached to or located on the same land as 
residence.

ERJMV	Edited variable of the total market value of the joint rental properties 
held with spouse as of the last day of the reference period, excluding 
rental properties attached to or located on his/her own residence.

EPROPVAL	Edited variable of the current market value of the property.

ERJPRI	Edited variable of the amount of principal respondent owed on a 
mortgage for joint rental properties held with spouse that weren't 
attached or located on the residence.


ERIAT	Edited variable indicating whether or not any rental property in respondent's own name is 
attached to or located on the same land as own residence.

ERIATA	Edited variable indicating whether or not all rental property in 
respondent's own name is attached to or located on the same land as 
own residence.

ERIMV 	Edited variable of the total market value of the rental property owned in 
own name.

ERIPRI	Edited variable of the estimated amount of principal owed on the rental 
property in own name as of the last day of the reference period.

OUTPUT VARIABLES: 	

RHHORE	Household level recode variable indicating amount of equity in real
estate that is not your own home.

DETAILED SPECIFICATIONS:

To find equity in rental properties and other real estate that is not respondents? own home (RHHORE) 
apply the following instructions:

Instruction One:

Add the edited equity in other real estate (EOTHREVA) to the edited total value of respondent?s share 
of equity (or loss) in rental properties owned jointly with someone other than spouse (not attached or 
located on own residence {ERTSHA}) plus

(Note:  For all cases not meeting the above criteria, the result of Instruction One is 0.)

Instruction Two:

The calculation of equity for joint rental properties not on the same land as one?s residence equals the 
total market value of these joint rental properties held with spouse (excluding rental properties attached 
to or located on own residence {ERJMV}), minus the edited amount of principal owed on mortgages 
held jointly with spouse for these properties (ERJPRI). 

(Note:  For all cases not meeting the above criteria, the result of Instruction Two is 0.)

Instruction Three: 

The equity calculation for rental properties owned in own name is equal to the edited total market value 
of the rental properties owned in own name (ERIMV), minus the edited estimated amount of principal 
owed on the rental properties in own name (ERIPRI).
											
(Note:  For all cases not meeting the above criteria, the result of Instruction Three is 0.)

RHHORE = (EOTHREVA + ERTSHA) + (ERJMV -  ERJPRI) + (ERIMV - ERIPRI).

Sum all the above for all adults 15+ in the household on the last day of the reference period of month 4.

Note:  Pre 1996 Specifications:

RHHORE = TM8666 (Other)  plus TM8122 (rental) plus
[If TM8067 (attached) equals ?some? or ?no? and TM8068 (market value) ne TM8598 (market 
value), 
then add (TM8068 (market value) minus TM8074 (principal)] plus
[If TM8091 (properties) equals ?some? or ?no? and 
If TM8092 (market value)  ne TM8598 (market value),
	then add (TM8092 (market value)  minus TM8098 (principal)]

Sum all the above for all adults 15+ in the household on the last day of the reference period of 
month 4.

IMPUTATION MATRIX:  Not applicable






MACRO/
SUBROUTINE NAME:	RHHOTAST

VARIABLE:
{
RHHOTAST
--C  Real Estate - Household level data
--S HRE:   Equity in other assets
--Y E
--:L:
--    Equity in other assets recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members, 
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

EMJP		Edited variable of the principal amount owed to the respondent on a 
mortgage held jointly with his/her spouse.   

EMIP		Edited variable of the principal amount owed to the respondent on a 
mortgage held in own name.	

EOAEQ 	Edited variable of the amount of equity owned in other financial 
investments.

EALOWA 	Edited variable of the amount of money owed to ... as the result of the 
sale of a business or property.
 			
EALSBV	Edited variable of the FACE VALUE of the U.S. Savings Bonds that ... 
owned.

EALJCHA	Edited variable of the amount of money respondent owned in joint non-
interest earning checking account with spouse.


EALICHA	Edited variable of best estimate of the amount of money the respondent 
had in the non-interest earning checking accounts held in own name  as 
of the last day of the reference period.
 
OUTPUT VARIABLES: 	

RHHOTAST	Household level recode variable indicating amount of equity in other 
assets.
											
DETAILED SPECIFICATIONS:

The equity in other assets recode (RHHOTAST) is equal to the edited principal amount owed to the 
respondent on a mortgage held jointly with his/her spouse (EMJP) plus the edited principal amount 
owed to the respondent on a mortgage held in own name (EMIP) plus the edited amount of equity 
owned in other financial investments (EOAEQ) plus the edited amount of money owed as the result of 
the sale of a business or property (EALOWA) plus the edited face value of the U.S. Savings Bonds 
owned (EALSBV) plus the edited amount of money respondent owned in joint non-interest earning 
checking account held with spouse (EALJCHA) plus the edited best estimate of money the respondent 
had in the non-interest earning checking accounts held in own name as of the last day of the reference 
period (EALICHA).

RHHOTAST = EMJP + EMIP + EOAEQ + EALOWA + EALSBV + EALJCHA + EALICHA

Sum all the above for all adults 15+ on the last day of the reference period of month 4.

Note:  Pre 1996 Specifications:

RHHOTAST = TM8126 + TM8128 + TM8132 + TM8202 + TM8206 + TM8210 + TM8233

Sum all the above for all adults 15+ on the last day of the reference period of month 4.

IMPUTATION MATRIX:  Not applicable










MACRO/
SUBROUTINE NAME:	RHHIRA

VARIABLE:
{
RHHIRA
--C  Real Estate - Household level data
--S HRE:   Equity in IRA and KEOGH accounts
--Y E
--:L:
--    Equity in IRA and KEOGH accounts recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

EALRB	Edited variable of the total balance or market value (including interest 
earned) of the respondents IRA accounts in own name.

EALKB	Edited variable of the total balance or market value of assets in the
respondents KEOGH account(s) in own name.

OUTPUT VARIABLES:						

RHHIRA	Household level recode variable indicating amount of equity in 			IRA and KEOGH accounts.

DETAILED SPECIFICATIONS:

The equity in IRA and KEOGH accounts recode (RHHIRA) is equal to the balances or market value 
(including interest earned) of respondents IRA accounts (EALRB) and KEOGH accounts (EALKB) 
held in own name.

RHHIRA = EALRB + EALKB

Sum all the above for all adults 15 + on the last day of the reference period of month 4.

Note:  Pre 1996 Specifications: 

RHHIRA = TM8264 + TM8288

Sum all the above for all adults 15+ on the last day of the reference period of month 4.

IMPUTATION MATRIX:  Not applicable


 






 MACRO/
SUBROUTINE NAME:	RHHTHRIF

VARIABLE:
{
RHHTHRIF
--C  Real Estate - Household level data
--S HRE:   Equity in 401K and Thrift savings accounts
--Y E
--:L:
--    Equity in 401k and Thrift savings accounts recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

EALTB	Edited variable of the total balance or market value (including interest 
earned) of the respondents 401k and Thrift savings accounts in own 
name.

OUTPUT VARIABLES:

RHHTHRIF	Household level recode variable indicating amount of equity in 			401K and Thrift savings accounts.

DETAILED SPECIFICATIONS:

The equity in 401k and Thrift savings accounts recode (RHHTHRIF) is equal to the balances or market 
value (including interest earned) of respondents 401k and Thrift savings accounts (EALTB) held in own 
name.

RHHTHRIF = EALTB

Sum all the above for all adults 15 + on the last day of the reference period of month 4.

Note:  Pre 1996 Specifications: 

None


IMPUTATION MATRIX:  Not applicable


 























						









MACRO/
SUBROUTINE NAME:	RHHDEBT

VARIABLE:
{
RHHDEBT
--C  Real Estate - Household level data
--S HRE:  Total debt 
--Y E
--:L:
--   Total debt recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members, 
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

RHHSCDBT     Household level recode variable indicating amount of secured debt.

RHHUSCBT     Household level recode variable indicating amount of unsecured debts.

OUTPUT VARIABLES: 	

RHHDEBT       Household level recode variable indicating amount of total debt.

DETAILED SPECIFICATIONS:

The total debt recode (RHHDEBT) is equal to the recode amount of secured debt (RHHSCDBT) plus 
unsecured debt (RHHUSCBT).

RHHDEBT = RHHSCDBT + RHHUSCBT

IMPUTATION MATRIX:  Not applicable



MACRO/
SUBROUTINE NAME:	RHHSCDBT

VARIABLE:
{
RHHSCDBT
--C  Real Estate - Household level data
--S HRE:  Total secured debt recode
--Y E
--:L:
--   Total secured debt recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members,
--U	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:		
				
EMOR1PR, EMOR2PR, EMOR3PR   Edited variable of the sum of first or second mortgage or
  the sum of all other mortgages or equity loans.

EA1AMT,  EA2AMT, EA3AMT	Edited variable of the amount owed for the first, second and third 
vehicle.	

EOV1AMT,  EOV2AMT			Edited variable of the amount owed for the first and second 
other vehicle.

ERJAT			Edited variable indicating whether or not any of the rental properties 
owned jointly with spouse is attached to or located on the same 
land as residence.
		
ERJATA			Edited variable indicating whether or not all of the rental 
properties owned jointly with spouse is attached to or located 
on the same land as residence.



ESMJMAV			Edited variable of the amount of the debt or margin account on 
the respondents jointly owned stocks and mutual funds with 
spouse.

ESMIMAV			Edited variable of the amount of the debt or margin account on 
the respondent?s stocks and mutual funds owned in own name.

ERTSHA 			Edited variable of the total value of respondent's share of equity 
(or loss) in the 
rental property 
owned jointly 
with other than 
spouse, not 
attached or 
located on own 
residence as of 
the last day of 
the reference 
period.	

ERTMV			Edited variable of the total market value of the rental property 
respondent held jointly with others besides spouse not attached 
to or located on own residence as of the last day of the 
reference period.

ERTPRI			Edited variable of the amount of principal respondent owed on 
a mortgage on rental property owned jointly with other than 
spouse not attached to or located on own residence as of the 
last day of the reference period. 

ERJMV			Edited variable of the total market value of the joint rental 
properties held with spouse as of the last day of the reference 
period, excluding rental properties attached to or located on 
his/her own residence.

EPROPVAL			Edited variable of the current value of the property.

ERJPRI	  		Edited variable of the amount of principal respondent owed on 
a mortgage for joint rental properties held with spouse that 
weren't attached or located on the residence.

ERIMV			Edited variable of the total market value of the rental property 
owned in own name.

ERIPRI			Edited variable indicating the amount of principal owed on 
rental property in own name and property not all located on or 
attached to land of residence.

UVBHM1, UVBHM2			Internal variable called UVBHM which asks whether the 
information about the business has already been obtained from 
another household member.

EVBDE1, EVBDE2			Edited variable of the total debt owed against the first or second 
business.

EVBOW1, EVBOW2			Edited variable of the percentage of the first business or second 
business owned by the respondent

OUTPUT VARIABLES: 		

RHHSCDBT			Household level recode variable indicating amount of secured 
debt.

DETAILED SPECIFICATIONS:

The total secured debt recode (RHHSCDBT) is equal to the sum of the following instructions:

Instruction One:

Add the sum of the first or second mortgage or the sum of all other mortgages or equity loans  
(EMOR1PR+EMOR2PR+EMOR3PR) to the edited amount of debt owed for the first, second and 
third motor vehicle (EA1AMT+EA2AMT+EA3AMT), add this sum to the edited amount owed for the 
first and second other vehicle (EOV1AMT+EOV2AMT), then add this sum to any debt on stock and 
mutual funds held with spouse and in own name (ESMJMAV +ESMIMAV).

Instruction Two:

To get the share of secured debt owed on rental property owned with another person other than a 
spouse, enter the numbers into the following equation:

The total value of respondent?s share of equity, (or loss) in rental property owned jointly with others 
(ERTSHA), divided by the total market value of the rental property the respondent held jointly with 
others besides spouse (ERTMV) minus the amount of principal the respondent owed on a mortgage on 
rental property owned jointly with others besides spouse (ERTPRI), multiply this figure by the amount 
of principal respondent owed on a mortgage or rental property owned jointly with someone besides 
spouse (ERTPRI).  [ERTSHA/ |(ERTMV-ERTPRI)|] * ERTPRI.  Add the resulting figure to the sum 
obtained in Instruction One. 


If the person does not own rental property with another person other than a spouse, then the value of 
Instruction Two should be 0.
Note: If the result of  ERTMV-ERTPRI is negative, use the absolute value so that the response to 
Instruction Two (the share of secured debt owed on rental property owned with another person other 
than a spouse), is a positive value (> or = 0).  

Instruction Three:

The debt calculation for joint rental property owned that is not on the same land as residence is equal to 
the edited amount of principal the respondent owed on a mortgage held jointly with spouse (ERJPRI). 

This amount should be added to the result obtained in Instruction Two.  This amount is equal to 0 if the 
respondent does not own rental property jointly with his/her spouse.
	
Instruction Four:

The debt calculation for rental property owned in own name that is not on the same land as residence is 
equal to the edited estimated amount of principal owed on the rental property in own name (ERIPRI).

This amount should be added to the result obtained in Instruction Three.  This amount is equal to 0 if the 
respondent is not a sole owner of any rental property.

NOTE: (applicable to Instructions Five and Six) 

If someone in the house already answered these question about the first business debt, or someone in 
the house has already answered the questions about the second business debt, then the values for total 
amount of debt owed on business one (EVBDE1) and total amount owed on business two (EVBDE2) 
must be copied from the answering household members record.

Instruction Five:

To prepare the amount of debt from the first business owned to add to the current sum of Instructions 
One through Four:

Obtain the edited variable of the percentage of the first business owned by the respondent -- dividing 
the percent by 100 gives the proportion of the business owned , then multiply this proportion by the 
amount of debt owed on the business as a whole. (EVBOW1/100)*EVBDE1

If there are no debts held against the first business (EVBDE1=0), or the person does not have a 
business, then the value of this calculation should be 0.


Instruction Six:

To prepare the amount of debt from the second business owned add to the current sum of Instructions 
One through Five:

Obtain the edited variable of the percentage of the second business owned by the respondent  --
dividing the percent by 100 gives the proportion of the business owned, then multiply this proportion by 
the amount of debt owed on the business as a whole. 
(EVBOW2/100) *EVBDE2

If there are no debts held against the second business (EVBDE2=0), or the person does not have a 
second business, then the value of this calculation should be 0.

Instruction Seven:  

Sum up Instructions One through Six for each adult 15+ on the last day of the reference period.  Then 
sum up each adult?s 15+ amount within the household for total household secured debt.
		

RHHSCDBT = Mortgage on Own Home, motor vehicle debt, and debt on stock and mutual
		  funds (Instruction One) + debt on rental property (Instructions Two, Three and 		  Four) +  debt on business (Instructions five and six) + Instruction Seven	 

Note:  Pre 1996 Specifications:

RHHSCDBT = Mortgage on Own Home (TM8564 + TM8566 + TM8596) plus

Motor vehicle debt (TM8760 + TM8762 + TM8764 + TM8796 + TM8798) plus

Debt on stock and mutual fund shares (TM8040 + TM8050) plus

Debt on Rental property [TM8122 / (TM8116 minus TM8120)] X TM8120

If TM8068 ne TM8598 then Add TM8074 plus
If TM8092 ne TM8598 then Add TM8098 plus

Debt on Business

Note:	For calculations only:  If TM8002 = 1 then TM8004 = 100
	For calculations only:  If TM8018 = 1 then TM8020 = 100


Business #1

If TM8012* is  greater than zero then (TM8004 / 100) X TM8012

* Note: If TM8006 = 1 then TM8012 must be found on another household member's record.
 If TM8006 = 2, then TM8012 equals the value on this person's record.

Business #2

If TM8028* is  greater than zero then (TM8020 / 100) X TM8028

* Note: If TM8022 = 1 then TM8028 must be found on another household member's record. 
 If TM8022 = 2, then TM8028 equals the value on this person's record.

Sum all the above for all adults 15+ on the last day of the reference period of month 4.

IMPUTATION MATRIX:  Not applicable





MACRO/
SUBROUTINE NAME:	RHHUSCBT

VARIABLE:
{												
RHHUSCBT
--C  Real Estate - Household level data
--S HRE:  Total unsecured debt
--Y E
--:L:
--   Total unsecured debt recode
--:L
--V	0 None or Not in universe
--V	1:999999999 Amount in dollars
--U	This variable was calculated using information provided for all adults 15 or older in the
--U	household, but the final value was written to the record of all household members, 
--U 	regardless of age.  This is H.H. level data.
}	

PUBLIC USE:	Yes  		

INPUT VARIABLES:	

EALJDAB	Edited variable of the amount jointly owed with spouse for store bills or
credit card bills as of the last day of the reference period.

EALIDAB	Edited variable of the amount of money the respondent owed for store bills or credit 
card bills in own name as of the last day of the reference period.

EALJDAL	Edited variable of the amount jointly owed with spouse for other debt as of the last day 
of the reference period.

EALIDAL	Edited variable of the amount of money the respondent owed for loans obtained through 
a bank or credit union, other than car loans or home equity loans in own name as of the 
last day of the reference period.

EALJDAO	Edited variable of the amount jointly owed with spouse for other debt as
of the last day of the reference period.
		
EALIDAO	Edited variable of the amount of money the respondent owed for any other debt we 
have not yet mentioned (include medical bills not covered by insurance, money owed to 
private individuals, and any other debt not covered; exclude  mortgages, home equity 
loans, and car loans) in own name as of the last day of the reference period.

OUTPUT VARIABLES: 	

RHHUSCBT	Household level recode variable indicating total unsecured debt.

DETAILED SPECIFICATIONS:

The total unsecured debt recode (RHHUSCBT) is equal to the edited amount of store bills/credit card 
debts owed jointly with spouse plus the edited amount of store bills/credit card debts in own name 
(EALJDAB + EALIDAB).

Add to the above the edited amount of money the respondent owed with spouse for other debt plus the 
edited amount of money the respondent owed for loans obtained through a bank or credit union, 
excluding car and home equity loans (EALJDAL + EALIDAL)

Then add the edited amount of money jointly owed with spouse for other debt plus the edited variable 
of the amount of money the respondent owed for any other debt not yet mentioned that was held in 
one?s own name as of the last day of the reference period.  (EALJDAO + EALIDAO)

Sum all the above for all adults 15+ on the last day of the reference period of month 4.

RHHUSCBT = (EALJDAB + EALIDAB) + (EALJDAL + EALIDAL) + 
                          (EALJDAO + EALIDAO)
	
Note:  Pre 1996 Specifications:

RHHUSCBT = Credit card debts (TM8214 + TM8238) plus
Loans through a bank or credit union
(exclude car and home equity loans) (TM8218 + TM8242) plus
Other debts (TM8222 + TM8246)

Sum all the above for all adults 15+ on the last day of the reference period of month 4.

IMPUTATION MATRIX:  Not applicable						

									
												
									






	SIPP 2004 Panel Wave 3
								Assets and Liabilities Recode Edit Specifications
	Page   of 36
								12/12/06
	SIPP 2004 Panel Wave 3
								Assets and Liabilities Recode Edit Specifications
	Page   of 36
								12/12/06