delete from subfunction_ite_code
last buff
replace subfunction_ite_code values
("X04","r","Employee Retirement - From Parent Local Government"),
("X05","r","Employee Retirement - From Other Governments"),
("X06","r","Employee Retirement - State to Own System"),
("X08","r","Employee Retirement - Earnings on Investments (calculated (Disc. 2005)"),
("X11","s","Employee Retirement - Benefit Payments"),
("S11","s","Employee Retirement"),
("X12","s","Employee Retirement - Withdrawals"),
("X14","s","Employee Retirement - Other Payments (Disc. 2005)"),
("X21","s","Employee Retirement - Total Cash and Deposits"),
("X30","s","Employee Retirement - Total Federal Securities"),
("X40","s","Employee Retirement - Securities - Corporate Bonds (Disc. 2005)"),
("X41","s","Employee Retirement - Securities - Corporate Stocks (Disc. 2005)"),
("X42","s","Employee Retirement - Securities - Mortgages"),
("X44","s","Employee Retirement - Total Other Securities"),
("X47","s","Employee Retirement - Other Investments - Other"),
("XED","s","Education intergovernmental"),
("XHH","s","Hospital Intergov"),
("XHI","s","Highways intergov."),
("XHO","s","Housing Intergov"),
("XME","s","Grants to States for Medicaid intergov"),
("XOT","s","Other intergov"),
("XRS","s","Revenue Sharing intergov"),
("XUN","s","Employment security intergov"),
("XWE","s","Public welfare intergov"),
("Y01","r","Unemployment Compensation - Contribution"),
("Y02","r","Unemployment Compensation - Interest Revenue"),
("Y04","r","Unemployment Compensation - Federal Advances"),
("Y05","s","Unemployment Compensation - Benefit Payments"),
("S05","s","Unemployment Compensation"),
("Y06","s","Unemployment Compensation - Extended and Special Payments"),
("S06","s","Unemployment Compensation – Special"),
("Y07","s","Unemployment Compensation - Balance In US Treasury"),
("Y08","s","Unemployment Compensation - Other Balance (+ or - (Disc. 2005)"),
("Y10","r","Workers Compensation - Own Contribution"),
("Y11","r","Workers Compensation - Other Contributions"),
("Y12","r","Workers Compensation - Interest Earnings"),
("Y14","s","Workers Compensation - Benefit Payments"),
("S14","s","Workers Compensation"),
("Y15","s","Workers Compensation - Other Payments"),
("Y21","s","Workers Compensation - Cash and Assets"),
("Y50","r","Other In Trust - Own Contributions"),
("Y51","r","Other In Trust - Other Contributions"),
("Y52","r","Other In Trust - Interest Revenue"),
("Y53","s","Other In Trust - Benefit Payment"),
("S53","s","Other Insurance Trust Benefits"),
("Y54","s","Other In Trust - Other Payments"),
("S54","s","Other Insurance Trust Payments"),
("Y61","s","Other In Trust - Cash and Deposits"),
("Z00","s","Total Salaries and Wages"),
("Z18","s","Higher Education Salaries"),
("Z41","r","Liquor Stores - Net Sales"),
("Z42","s","Liquor Stores - Cost of Goods"),
("Z43","s","Liquor Stores - Operating Expenditures"),
("Z44","r","Liquor Stores - Other Income"),
("Z45","s","Liquor Stores - Nonoperating Expenditures"),
("Z46","r","Liquor Stores - Transfer to General Funds"),
("Z47","r","Liquor Stores - License and Enforcement"),
("Z48","r","Liquor Stores - Liquor Taxes"),
("Z51","r","Lotteries Exhibit - Ticket Sales"),
("Z52","s","Lotteries Exhibit - Prizes"),
("Z53","s","Lotteries Exhibit - Administration in Expenditures"),
("Z54","r","Lotteries Exhibit - Proceeds"),
("Z62","r","Corporate Bonds, Federally-Sponsored Agencies"),
("Z63","r","Corporate Bonds, Other"),
("Z70","r","Foreign and International Securities"),
("Z71","r","Employee Retirement - Interest Earnings"),
("Z77","s","Employee Retirement - Corporate Bonds"),
("Z78","s","Employee Retirement - Corporate Stocks"),
("B43","s","Intergovernmental Revenue from Federal - Environmental Health (NEW for 2007)"),
("D50","s","Intergovernmental Revenue from Local - Housing and Community Development (NEW in 2007)"),
("E27","s","Current Operations - Environmental Health (NEW for 2007)"),
("S27","s","Current Operations - Environmental Health (NEW for 2007)"),
("E73","s","Current Operations - Welfare, Payments to Medicare Trust Fund (NEW for 2007; previously S74)"),
("F27","s","Construction - Environmental Health (NEW for 2007)"),
("G27","s","Other Capital Outlay - Environmental Health (NEW for 2007)"),
("K27","s","Equipment Only - Environmental Health (NEW for 2007)"),
("M27","s","Intergovernmental to Local NEC - Environmental Health (NEW for 2007)")
Done