Variables
This is a complete list of variables and identifying codes that are used in the data base.
Each variable is linked to an individual variable page that provides a definition and important additional information about the variable.
- LifeCycle Deficit (100,000 LCD)
- Consumption (110,000 C)
- Public Consumption (111,000 CG)
- Public Consumption, Education (111,100 CGE)
- Public Consumption, Health (111,200 CGH)
- Public Consumption, Other than health and education (111,500 CGX)
- Public Consumption, Education (111,100 CGE)
- Private Consumption (112,000 CF)
- Private Consumption, Education (112,100 CFE)
- Private Consumption, Health (112,200 CFH)
- Private Consumption, Other than health and education (112,500 CFX)
- Private Consumption, Education (112,100 CFE)
- Public Consumption (111,000 CG)
- Labor Income (120,000 YL)
- Earnings (121,000 YLE)
- Self-employment labor income (123,000 YLS)
- Earnings (121,000 YLE)
- Consumption (110,000 C)
- Reallocations (200,000 R)
- Asset-based Reallocations (210,000 RA)
- Asset Income (210,100 YA)
- Capital Income (210,110 YK)
- Property Income (210,150 YP)
- Interest (210,151 YM)
- Other Property Income (210,153 YPX)
- Interest (210,151 YM)
- Capital Income (210,110 YK)
- Saving (210,200 S)
- Private Asset-based Reallocations (211,000 RAF)
- Private Asset Income (211,100 YAF)
- Private Capital Income (211,110 YKF)
- Operating surplus of households (211,111 YKFH)
- Income, Consumer durables (211,113 YKFD)
- Income, Unincorporated enterprise (211,115 YKFB)
- Income, Corporate (211,117 YKFC)
- Operating surplus of households (211,111 YKFH)
- Private Rent (211,130 YLR)
- Private Rent, Inflows (211,130.1 YLRI)
- Private Rent, Outflows (211,130.2 YLRO)
- Private Rent, Inflows (211,130.1 YLRI)
- Property Income, Private (211,150 YPF)
- Private Interest (211,151 YMF)
- Private Interest Inflows (211,151.1 YMFI)
- Private Interest Outflows (211,151.2 YMFO)
- Private Interest Inflows (211,151.1 YMFI)
- Other Property Income, Private (211,153 YPFX)
- Private Interest (211,151 YMF)
- Private Capital Income (211,110 YKF)
- Private Saving (211,500 SF)
- Private Investment (211,510 SKF)
- Private Investment, Owner-occupied housing (211,511 SKFH)
- Private Investment, Consumer durables (211,513 SKFD)
- Private Investment, Unincorporated enterprise (211,515 SKFB)
- Private Investment, Corporate (211,517 SKFC)
- Private Investment, Public Property and Enterprises (211,519 SKFSOE)
- Private Investment, Owner-occupied housing (211,511 SKFH)
- Private Accumulation of Land (211,540 SLF)
- Private Accumulation of Credit (211,570 SMF)
- Private Investment (211,510 SKF)
- Private Asset Income (211,100 YAF)
- Public Asset-based Reallocations (212,000 RAG)
- Public Asset Income (212,100 YAG)
- Public Capital Income (212,110 YKG)
- Income, Education (212,111 YKGE)
- Income, Health (212,114 YKGH)
- Income, Other (212,117 YKGX)
- Income, Education (212,111 YKGE)
- Property Income, Public (212,150 YPG)
- Public Interest (212,151 YMG)
- Public Interest, Inflows (212,151.1 YMGI)
- Public Interest, Outflows (212,151.2 YMGO)
- Public Interest, Inflows (212,151.1 YMGI)
- Other Property Income, Public (212,153 YPGX)
- Public Interest (212,151 YMG)
- Public Credit Income (212,510 YCG)
- Credit Income, General (212,511 YCGG)
- General Credit Income Inflows (212,511.1 YCGGI)
- General Credit Income Outflows (212,511.2 YCGGO)
- General Credit Income Inflows (212,511.1 YCGGI)
- Credit Income, Special (212,515 YCGS)
- Special Credit Income Inflows (212,515.1 YCGSI)
- Special Credit Income Outflows (212,515.2 YCGSO)
- Special Credit Income Inflows (212,515.1 YCGSI)
- Credit Income, General (212,511 YCGG)
- Public Capital Income (212,110 YKG)
- Public Saving (212,200 SG)
- Public Investment (212,210 SKG)
- Public Investment, Education (212,211 SKGE)
- Public Investment, Health (212,214 SKGF)
- Public Investment, Other (212,217 SKGX)
- Public Investment, Education (212,211 SKGE)
- Public Accumulation of Credit (212,220 SMG)
- Public Investment (212,210 SKG)
- Public Asset Income (212,100 YAG)
- Asset Income (210,100 YA)
- Transfers (220,000 T)
- Public Transfers (221,000 TG)
- Public Transfers, Inflows (221,000.1 TGI)
- Public Transfers, Outflows (221,000.2 TGO)
- Public Education (221,100 TGE)
- Public Education, Inflows (221,100.1 TGEI)
- Public Education, Outflows (221,100.2 TGEO)
- Public Education, Inflows (221,100.1 TGEI)
- Public Health Care (221,200 TGH)
- Public Health Care, Inflows (221,200.1 TGHI)
- Public Health Care, Outflows (221,200.2 TGHO)
- Public Health Care, Inflows (221,200.1 TGHI)
- Public Pensions (221,300 TGSOA)
- Public Pensions, Inflows (221,300.1 TGSOAI)
- Public Pensions, Outflows (221,300.2 TGSOAO)
- Public Pensions, Inflows (221,300.1 TGSOAI)
- Public Transfers, Other In-Kind (221,400 TGXI)
- Public Transfers, Other In-Kind, Inflows (221,400.1 TGXII)
- Public Transfers, Other In-Kind, Outflows (221,400.2 TGXIO)
- Public Transfers, Other In-Kind, Inflows (221,400.1 TGXII)
- Public Transfers, Other Cash (221,500 TGXC)
- Public Transfers, Other Cash, Inflows (221,500.1 TGXCI)
- Public Transfers, Other Cash, Outflows (221,500.2 TGXCO)
- Public Transfers, Other Cash, Inflows (221,500.1 TGXCI)
- Public Transfers, Net Foreign (221,600 TGNF)
- Social Protection, Other (221,700 TGS)
- Social Protection, Other, Inflows (221,700.1 TGSI)
- Social Protection, Other, Outflows (221,700.2 TGSO)
- Social Protection, Sickness and disability (221,710 TGSD)
- Sickness and disability, Inflows (221,710.1 TGSDI)
- Sickness and disability, Outflows (221,710.2 TGSDO)
- Sickness and disability, Inflows (221,710.1 TGSDI)
- Social Protection, Survivors (221,720 TGSS)
- Survivors, Inflows (221,720.1 TGSSI)
- Survivors, Outflows (221,720.2 TGSSO)
- Survivors, Inflows (221,720.1 TGSSI)
- Social Protection, Family and children (221,730 TGSF)
- Family and Children, Inflows (221,730.1 TGSFI)
- Family and Children, Outflows (221,730.2 TGSFO)
- Family and Children, Inflows (221,730.1 TGSFI)
- Social Protection, Unemployment (221,740 TGSU)
- Unemployment, Inflows (221,740.1 TGSUI)
- Unemployment, Outflows (221,740.2 TGSUO)
- Unemployment, Inflows (221,740.1 TGSUI)
- Social Protection, Housing (221,750 TGSH)
- Housing, Inflows (221,750.1 TGSHI)
- Housing, Outflows (221,750.2 TGSHO)
- Housing, Inflows (221,750.1 TGSHI)
- Social Protection, Miscellaneous (221,760 TGSX)
- Social Protection, Miscellaneous, Inflows (221,760.1 TGSXI)
- Social Protection, Miscellaneous, Outflows (221,760.2 TGSXO)
- Social Protection, Miscellaneous, Inflows (221,760.1 TGSXI)
- Social Protection, Other, Inflows (221,700.1 TGSI)
- Collective Goods and Services (221,900 TGC)
- Collective, Inflows (221,900.1 TGCI)
- Collective, Outflows (221,900.2 TGCO)
- Collective, Non-congestible (221,910 TGCN)
- Collective, Congestible (221,920 TGCC)
- Collective, Inflows (221,900.1 TGCI)
- Taxes (221,930 TGF )
- Taxes on income, profits, and capital gains (221,931 TGFK)
- Taxes on payroll and workforce (221,932 TGFW)
- Taxes on property (221,933 TGFP)
- Taxes on goods and services (221,934 TGFG)
- Taxes on international trade and transactions (221,935 TGFF)
- Other taxes (221,936 TGFX)
- Taxes on income, profits, and capital gains (221,931 TGFK)
- Social Contributions (221,940 TGP)
- Social security contributions (221,941 TGPS)
- Other social contributions (221,942 TGPX)
- Social security contributions (221,941 TGPS)
- Grants (221,950 TGG)
- Grants from foreign governments (221,951 TGGG)
- Grants from international organizations (221,952 TGGF)
- Grants from other general government units (221,957 TGX)
- Grants from foreign governments (221,951 TGGG)
- Public Transfers, Inflows (221,000.1 TGI)
- Private Transfers (222,000 TF)
- Private Transfers, Inflows (222,000.1 TFI)
- Private Transfers, Outflows (222,000.2 TFO)
- Interhousehold Transfers (222,100 TFB)
- Interhousehold Transfers, Inflows (222,100.1 TFBI)
- Interhousehold Transfers, Outflows (222,100.2 TFBO)
- Interhousehold Transfers, Inflows (222,100.1 TFBI)
- Intrahousehold Transfers (222,200 TFW)
- Intrahousehold Transfers, Inflows (222,200.1 TFWI)
- Intrahousehold Transfers, Outflows (222,200.2 TFWO)
- Intrahousehold Transfers, Consumption (222,230 TFC)
- Intrahousehold Transfers, Consumption, Inflows (222,230.1 TFCI )
- Intrahousehold Transfers, Consumption, Outflows (222,230.2 TFCO )
- Intrahousehold Transfers, Education (222,231 TFWE)
- Intrahousehold Transfers, Education, Inflows (222,231.1 TFWEI)
- Intrahousehold Transfers, Education, Outflows (222,231.2 TFWEO)
- Intrahousehold Transfers, Education, Inflows (222,231.1 TFWEI)
- Intrahousehold Transfers, Health (222,232 TFWH)
- Intrahousehold Transfers, Health, Inflows (222,232.1 TFWHI)
- Intrahousehold Transfers, Health, Outflows (222,232.2 TFWHO)
- Intrahousehold Transfers, Health, Inflows (222,232.1 TFWHI)
- Intrahousehold Transfers, Consumption other than health and education (222,237 TFWX)
- Intrahousehold Transfers, Consumption, Inflows (222,230.1 TFCI )
- Intrahousehold Transfers, Saving (TFWS 222,250)
- Intrahousehold Transfers, Saving, Inflows (TFWSI 222,250.1)
- Intrahousehold Transfers, Saving, Outflows (TFWSO 222,250.2)
- Intrahousehold Transfers, Saving, Inflows (TFWSI 222,250.1)
- Intrahousehold Transfers, Inflows (222,200.1 TFWI)
- Private Transfers, Inflows (222,000.1 TFI)
- Private Capital Transfers (223,000 TK)
- Private Capital Transfers, Bequests (223,100 TKB)
- Bequests, Inflows (223,100.1 TKBI)
- Bequests, Outflows (223,100.2 TKBO)
- Bequests, Inflows (223,100.1 TKBI)
- Private Capital Transfers, Other (223,200 TKX)
- Private Capital Transfers, Bequests (223,100 TKB)
- LifeCycle Wealth (300,000 W)
- Assets (310,000 WK)
- Assets, Owner-occupied housing (311,100 WKH)
- Assets, Consumer durables (311,200 WKD)
- Assets, Business, unincorporated enterprise (311,300 WKU)
- Assets, Corporate profits (311,400 WKC)
- Assets, State owned enterprise (311,500 WKSOE)
- Assets, Other (311,600 WKX)
- Assets, Owner-occupied housing (311,100 WKH)
- Transfer Wealth (320,000 WT)
- Public Transfer Wealth (321,000 WTG)
- Public Transfer Wealth, Non Market (321,100 WTGNM)
- Public Transfer Wealth, Collective Services (321,150 WTGC)
- Public Transfer Wealth, Public Goods and Services (321,200 WTGCN)
- Public Transfer Wealth, Congestible Goods and Services (321,250 WTGCC)
- Public Transfer Wealth, Public Goods and Services (321,200 WTGCN)
- Public Transfer Wealth, Health (321,300 WTGH)
- Public Transfer Wealth, Education (321,350 WTGE)
- Public Transfer Wealth, Social Protection (321,400 WTGS)
- Public Transfer Wealth, Sickness and disability (321,450 WTGSD)
- Public Transfer Wealth, Old age (321,500 WTGSOA)
- Public Transfer Wealth, Survivors (321,550 WTGSS)
- Public Transfer Wealth, Family and children (321,600 WTGSF)
- Public Transfer Wealth, Unemployment (321,650 WTGSU)
- Public Transfer Wealth, Housing (321,700 WTGSH)
- Public Transfer Wealth, Other Social Protection (321,750 WTGSX)
- Public Transfer Wealth, Sickness and disability (321,450 WTGSD)
- Public Transfer Wealth, Collective Services (321,150 WTGC)
- Public Transfer Wealth, National Debt (321,900 WTGD)
- Public Transfer Wealth, Non Market (321,100 WTGNM)
- Private Transfer Wealth (322,000 WTF)
- Private Transfer Wealth, Non-market (322,100 WTFNM)
- Intra-household Transfer Wealth (322,110 WTFW)
- Intra-household Transfer Wealth, Education (322,111 WTFWE)
- Intra-household Transfer Wealth, Health (322,112 WTFWH)
- Intra-household Transfer Wealth, Other (322,113 WTFWX)
- Intra-household Transfer Wealth, Education (322,111 WTFWE)
- Inter-household Transfer Wealth (322,120 WTFB)
- Inter-household Transfer Wealth, Inter-vivos transfers (322,121 WTFBV)
- Inter-household Transfer Wealth, Bequests (322,122 WTFBB)
- Inter-household Transfer Wealth, Household Transitions (322,123 WTFBH)
- Inter-household Transfer Wealth, Charitable and religious organizations (322,130 WTFCR)
- Inter-household Transfer Wealth, Inter-vivos transfers (322,121 WTFBV)
- Intra-household Transfer Wealth (322,110 WTFW)
- Private Transfer Wealth, Market (322,200 WTFM)
- Private Transfer Wealth, Consumer credit (322,210 WTFC)
- Private Transfer Wealth, Land (322,220 WTFR)
- Private Transfer Wealth, Consumer credit (322,210 WTFC)
- Private Transfer Wealth, Non-market (322,100 WTFNM)
- Public Transfer Wealth (321,000 WTG)
- Assets (310,000 WK)
- Public Transfers (221,000 TG)
- Asset-based Reallocations (210,000 RA)
- Demographics (499999 XX)
- Population, Total (500,000 DN)
- Population, Male (501,000 DNM)
- Population, Female (502,000 DNF)
- Population, Male (501,000 DNM)
- Population growth rate (505,000 DNUN_gr)
- Survival Rate (510,000 DS)
- Survival Rate, Male (511,000 DSM)
- Survival Rate, Female (512,000 DSF)
- Survival Rate, Male (511,000 DSM)
- Migration Rate (520,000 DM)
- Migration Rate, Male (521,000 DMM)
- Migration Rate, Female (522,000 DMF)
- Migration Rate, Male (521,000 DMM)
- Headship Rate (540,000 H)
- UN Population, Total (550,000 DNUN)
- UN Population, Male (551,000 DNMUN)
- UN Population, Female (552,000 DNFUN)
- UN Population, Male (551,000 DNMUN)
- UN Life expectancy at birth (555,000 DE0UN)
- UN Total Fertility Rate (560,000 DTFRUN)
- Population, Total (500,000 DN)
- Indicators (599,999 XXX)
- Consumer Price Index (600,000 FCPI)
- GDP Deflator (605,000 GDPD)
- GDP per capita (current USD) (606,000 GDPPC)
- GDP per capita (current USD, PPP) (607,000 GDPPC_ppp)
- Exchange Rate, Official (610,000 FX)
- Exchange Rate PPP (611,000 FXPPP)
- Interest Rate, Real (620,000 FR)
- Support Ratio (630,000 SR)
- Fiscal Support Ratio (640,000 SRG)
- Currency (650,000 CUR)
- Consumer Price Index (600,000 FCPI)
Numeric code
Each variable is attributed a 7 digit numeric code (xxx,xxx.y). Inflows are xxx,xxx.1 ; outflows are xxx,xxx.2 , and net inflows are xxx,xxx.0.
The wealth variables are coded as 3xx,xxx where 2xx,xxx is the corresponding flow variable.
Alpha code
Each variable is assigned an alpha code using the following conventions (note that the meaning of a letter can vary with its place):
- C - consumption
- YL - labor income
- K - capital
- R - reallocations
- I - investment
- T - transfers
- W - wealth
- G - public (government)
- F - private (familial)
- I - inflows when placed at the end of the name
- O - outflows when placed at the end of the name
- X - other when placed at the end of the name
- D - demographic variables
Scraps

What about the work of charitable and religious organizations? How are these treated in the NTA?
I think so. I've added it to the above as
Why are we tracking "outflows" separately for each public sector program? Aren't most of these drawn from general revenue?
I believe we want a complete description of every transfer sub-system. Hence, we do need the NTA variable for each public sector program, both inflows and outflows. I'm not sure whether we need the mean age-profile for every program. Perhaps we should add a set of variables (at the bottom, something like we will have with the population) for taxes by type of tax. [am]
Sounds good. We'll also need some way of indicating the distribution of taxes used for each program. For example, in the US I guess that public education is funded something like 75% property tax and 25% income tax. Also, are these tax rates or age profiles? I think we want age profiles. [tm]