SCF Combined Extract Data


RATIOS



PIRMORT
ratio of monthly mortgage payments to monthly income
Total Cases: 1,091,330,394 (Range of valid codes: 0.0000000000000-1087.2857587999999)
Properties
Data type: numeric
Decimals: 13
Record/columns: 1/1863-1874


PIRCONS
ratio of monthly non-mortgage non-revolving consumer debt payments to monthly income
Total Cases: 1,091,330,394 (Range of valid codes: 0.000000000000000-2138.197674399999869)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1876-1887


PIRREV
ratio of monthly revolving debt payments to monthly income
Total Cases: 1,091,330,394 (Range of valid codes: 0.000000000000000-917.910865220000005)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1889-1900


PIRTOTAL
Ratio of monthly debt payments to monthly income
Text of this Question or Item
See definition of TPAY for types of debt payments included in PIRTOTAL
Total Cases: 1,091,330,394 (Range of valid codes: 0.000000000000000-2151.355814000000009)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1850-1861


PIR40
Household has a PIR higher than 40%
Percent
N
Value
Label
91.0
993,095,966
0
no
9.0
98,234,428
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/1902


DEBT2INC
Ratio of total debt to total income
Text of this Question or Item
If no income, an arbitraty value of 10 is assigned
Total Cases: 1,091,330,394 (Range of valid codes: 0.00000000000000-64008.37297799999942)
Properties
Data type: numeric
Decimals: 14
Record/columns: 1/1283-1294


LEVRATIO
Ratio of total debt to total assets
Text of this Question or Item
See definition of DEBT and ASSET for more information
Total Cases: 1,091,330,394 (Range of valid codes: 0.0000000000000000-4166.6666666999999507)
Properties
Data type: numeric
Decimals: 16
Record/columns: 1/1270-1281

DEBT PAYMENTS



PAYMORT1
payments on first mortgage, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-203227.65)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1379-1387


PAYMORT2
payments on second mortgage, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-100000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1389-1397


PAYMORT3
payments on third mortgage, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-510661.89)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1399-1407


PAYMORTO
payments on other loans, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-40426.97)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1409-1416


PAYLOC1
payments on first line of credit, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-586974.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1418-1426


PAYLOC2
payments on second line of credit, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-147582.03)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1428-1436


PAYLOC3
payments on third line of credit, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-195750.55)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1438-1446


PAYLOCO
payments on other lines of credit, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-3217608.46)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1448-1457


PAYHI1
payments on first home improvement loan, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-43240.59)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1459-1466


PAYHI2
payments on second home improvement loan, 2016 dollars
Percent
N
Value
Label
99.9
1,090,654,992
0.00

0.0
52,613
16.77

0.0
17,860
50.00

0.0
23,874
55.27

0.0
11,724
140.00

0.0
17,610
150.00

0.0
69,785
167.93

0.0
35,327
200.00

0.0
11,881
203.49

0.0
31,943
203.58

0.0
20,134
205.24

0.0
20,446
206.22

0.0
18,882
216.20

0.0
34,801
223.90

0.0
21,466
266.22

0.0
25,709
279.88

0.0
16,068
280.34

0.0
24,887
295.09

0.0
45,214
381.53

0.0
3,141
466.47

0.0
19,886
497.40

0.0
32,680
516.41

0.0
8,406
531.16

0.0
25,556
548.10

0.0
25,954
1378.08

0.0
21,288
1621.22

0.0
14,042
1737.02

0.0
3,239
2035.81

0.0
20,988
2268.43


100.0
1,091,330,394


Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1468-1474


PAYLC1
payments on first land contract, 2016 dollars
Text of this Question or Item
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-72030.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1476-1483


PAYLC2
payments on second land contract, 2016 dollars
Text of this Question or Item
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-64741.86)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1485-1492


PAYLCO
payments on other land contracts, 2016 dollars
Text of this Question or Item
Assumed to be interest payments on amount outstanding, at 8 percent APR
Percent
N
Value
Label
100.0
1,091,301,127
0.00

0.0
21
0.12

0.0
1,515
70.53

0.0
605
75.53

0.0
35
88.48

0.0
17,366
442.40

0.0
700
583.81

0.0
1,396
590.44

0.0
1,336
597.07

0.0
37
690.58

0.0
31
766.11

0.0
39
1219.30

0.0
155
1286.81

0.0
5,835
1672.85

0.0
38
1866.72

0.0
10
4381.82

0.0
15
4633.93

0.0
11
6230.59

0.0
16
7503.12

0.0
24
9003.75

0.0
22
9541.71

0.0
22
12896.92

0.0
18
20960.73

0.0
4
387008.39

0.0
5
387915.20

0.0
4
392348.52

0.0
5
395270.48

0.0
4
397084.11


100.0
1,091,330,394


Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1494-1502


PAYORE1
payments on first other resdential property, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-327551.58)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1504-1512


PAYORE2
payments on second other resdential property, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-215000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1514-1522


PAYORE3
payments on third other resdential property, 2016 dollars
Text of this Question or Item
Only available for 1989, 1992, 1995, 1998, 2001, 2004, and 2007.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-186951.95)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1534-1542


PAYOREV
payments on remaining other resdential properties, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-548870.22)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1524-1532


PAYVEH1
payments on first vehicle, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-6367.80)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1544-1550


PAYVEH2
payments on second vehicle, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-5800.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1552-1558


PAYVEH3
payments on third vehicle, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-4400.46)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1560-1566


PAYVEH4
payments on fourth vehicle, 2016 dollars
Text of this Question or Item
Not available for 1989 and 1992.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-3387.13)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1568-1574


PAYVEHM
payments on remaining vehicles, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-3731.72)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1576-1582


PAYVEO1
payment on first other vehicle, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-921844.19)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1584-1592


PAYVEO2
payment on second other vehicle, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-155174.01)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1594-1602


PAYVEOM
payment on remaining other vehicles, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-78000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1604-1611


PAYEDU1
payments on first education loan, 2016 dollars
Text of this Question or Item
Not available for 1989.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-13416.55)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1613-1620


PAYEDU2
payments on second education loan, 2016 dollars
Text of this Question or Item
Not available for 1989.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-4228.21)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1622-1628


PAYEDU3
payments on third education loan, 2016 dollars
Text of this Question or Item
Not available for 1989.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-2515.60)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1630-1636


PAYEDU4
payments on fourth education loan, 2016 dollars
Text of this Question or Item
Not available for 1989.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-1475.46)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1638-1644


PAYEDU5
payments on fifth education loan, 2016 dollars
Text of this Question or Item
Not available for 1989.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-2192.41)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1646-1652


PAYEDU6
payments on sixth education loan, 2016 dollars
Text of this Question or Item
Not available for 1989.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-2474.65)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1654-1660


PAYEDU7
payments on seventh education loan, 2016 dollars
Text of this Question or Item
Not available for 1989 and 1992.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-3093.31)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1662-1668


PAYILN1
payments on first installment loan, 2016 dollars
Text of this Question or Item
Loans for nonresidential property not included.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-529636.70)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1670-1678


PAYILN2
payments on second installment loan, 2016 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-1154837.21)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1680-1689


PAYILN3
payments on third installment loan, 2016 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-429972.89)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1691-1699


PAYILN4
payments on fourth installment loan, 2016 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-71807.10)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1701-1708


PAYILN5
payments on fifth installment loan, 2016 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-59613.45)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1710-1717


PAYILN6
payments on sixth installment loan, 2016 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-105678.38)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1719-1727


PAYILN7
payments on seventh installment loan, 2016 dollars
Text of this Question or Item
Loans for nonresidential property not included. Not available for 1989, and 1992.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-44263.73)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1729-1736


PAYMARG
payments on margin loans, 2016 dollars
Text of this Question or Item
Assumed to be interest payments on balance outstanding, paid at 8 percent APR
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-372535.17)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1738-1746


PAYINS
payments on loans against insurance policies, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-27083.33)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1748-1755


PAYPEN1
payments on loan against first pension plan not previously reported, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-16000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1757-1764


PAYPEN2
payments on loan against second pension plan not previously reported, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-19076.73)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1766-1773


PAYPEN3
payments on loan against third pension plan not previously reported, 2016 dollars
Text of this Question or Item
Not available for 2010.
Percent
N
Value
Label
100.0
1,091,192,166
0.00

0.0
20,015
0.97

0.0
7,845
1.40

0.0
6,805
1.76

0.0
699
8.24

0.0
14,605
14.75

0.0
14,678
29.51

0.0
18,324
44.26

0.0
7,112
81.29

0.0
6,891
98.88

0.0
7,201
104.22

0.0
6,943
135.49

0.0
9,338
177.05

0.0
15
220.61

0.0
3,471
648.49

0.0
1,588
787.45

0.0
3,378
1053.79

0.0
3,564
1088.53

0.0
1,574
1181.18

0.0
1,620
1505.42

0.0
163
1625.82

0.0
328
2200.23

0.0
501
2759.94

0.0
1,571
3010.84


100.0
1,091,330,394


Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1775-1781


PAYPEN4
payments on loan against fourth pension plan not previously reported, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-8106.11)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1783-1789


PAYPEN5
payments on loan against fifth pension plan not previously reported, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-1235.22)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1791-1797


PAYPEN6
payments on loan against sixth pension plan not previously reported, 2016 dollars
Text of this Question or Item
Not available for 2010.
Percent
N
Value
Label
100.0
1,091,262,846
0.00

0.0
15,502
17.65

0.0
7,036
25.09

0.0
3,068
89.02

0.0
1,223
110.22

0.0
5,121
152.61

0.0
5,167
178.05

0.0
5,122
190.77

0.0
1,376
203.49

0.0
5,082
216.20

0.0
6,812
231.60

0.0
5,096
305.23

0.0
6,942
1389.62


100.0
1,091,330,394


Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1799-1805


REVPAY
total monthly revolving debt payments, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-3273585.95)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1839-1848


MORTPAY
total monthly mortgage payments, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-551526.04)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1818-1826


CONSPAY
total monthly consumer debt payments, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-1317751.74)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1828-1837


TPAY
Total value of monthly debt payments, 2016 dollars
Text of this Question or Item
Includes payments on credit cards, mortgages, home equity loans, 
home equity lines of credit, other home improvement loans, loans 
for other residential real estate, vehicle loans, education loans, 
installment loans, margin loans, loans against the cash value of 
life insurance, pension loans and other miscellaneous loans.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-3273585.95)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1807-1816