currency

curr_id	description
USD	United States Dollar

(1 row)

bank

bank_id	description
YB	Your Bank

(1 row)

summary_fund_cv

Fund ID	Bank ID	curr_id	abbrev	name	wht	s_adj	derived	date	Total Number of Shares	Total Cost Basis	Average Cost Basis per Share	Total Market Value
2	YB	USD	Ex. 1	Fund, 2001 IRS Pub 564, Ex. 1, p.7	0.00	f		2001-05-16	150	2400.00	16.0000	4500.00
3	YB	USD	Ex. 2	Fund, 2001 IRS Pub 564, Example 2, p.8	0.00	f	2	2001-12-15	100	1600.00	16.0000	2800.00
4	YB	USD	Ex. 3	Fund, 2001 IRS Pub 564, Example 3, p.8	0.00	f	2	2001-12-15	250	3750.00	15.0000	7000.00
5	YB	USD	Fund S	Fund S, 2001 IRS Pub 564, Comp Ex., p.11	0.00	f		2001-10-06	0	0.00	9.9800	0.00
1	YB	USD	Table 3	Fund, 2001 IRS Pub 564, Table 3, p.7	0.00	f		2001-09-29	200	4439.02	22.1951	6400.00

(5 rows)

share_purchase_cjv

curr_id	abbrev	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share (fees?)
USD	Ex. 1	2	1998-01-01	10	100	0
USD	Ex. 1	2	1999-01-01	12	100	0
USD	Ex. 1	2	2000-01-01	26	100	0
USD	Ex. 2	3	1998-01-01	10	100	0
USD	Ex. 2	3	1999-01-01	12	100	0
USD	Ex. 2	3	2000-01-01	26	100	0
USD	Ex. 3	4	1998-01-01	10	100	0
USD	Ex. 3	4	1999-01-01	12	100	0
USD	Ex. 3	4	2000-01-01	26	100	0
USD	Ex. 3	4	2001-09-19	14	150	0
USD	Fund S	5	1987-07-10	10	200	0
USD	Table 3	1	2000-02-04	25	160	0
USD	Table 3	1	2000-08-05	20	240	0
USD	Table 3	1	2000-12-16	30	10	0

(14 rows)

share_redemption_cjv

curr_id	abbrev	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share (fees?)
USD	Ex. 1	2	2001-05-16	30	150	0
USD	Ex. 2	3	2001-05-16	30	150	0
USD	Ex. 2	3	2001-12-15	28	50	0
USD	Ex. 3	4	2001-05-16	30	150	0
USD	Ex. 3	4	2001-12-15	28	50	0
USD	Fund S	5	2001-10-06	16	200	0
USD	Table 3	1	2001-09-29	32	210	0

(7 rows)

fund_income_cjv

curr_id	abbrev	Fund ID	Revenue Type	Distributed by Fund Manager?	Record Date	Income per Share	Pay Date
USD	Fund S	5	ROC	t	1989-01-01	0.05
USD	Fund S	5	ROC	t	1990-01-01	0.02
USD	Fund S	5	ROC	t	1998-01-01	0.04
USD	Fund S	5	CG	f	1999-01-01	0.03
USD	Fund S	5	CG	f	2000-01-01	0.06
USD	Table 3	1	DIV	t

(6 rows)

reinvested_fund_income_cjv

curr_id	abbrev	Fund ID	date	price_ps	Number of Shares	Basis Adj. per Share (fees?)	Revenue Type	Distributed by Fund Manager?	Record Date	Income per Share	Pay Date
USD	Table 3	1	2000-12-16	30	10	0	DIV	t

(1 row)

summary_cjv

curr_id	abbrev	row_id	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share	action	Sale Date	Other Basis Adj. per Share	Simple Cost Basis per Share	price	Simple Cost Basis	Total Number of Shares	Sale Price	Capital Gain, FIFO Method	Total Cost Basis	Average Cost Basis per Share	Average Basis of These Shares	Capital Gain, ACB Method	Long Term / Short Term
USD	Ex. 1	1771325	2	1998-01-01	10	100	0	BUY	2001-05-16	0	10	1000.00	1000.00	100	3000.00	2000.00	1000.00	10.0000	1600.00	1400.00	LTCG
USD	Ex. 1	1771326	2	1999-01-01	12	50	0	BUY	2001-05-16	0	12	600.00	600.00	150	1500.00	900.00	1600.00	10.6667	800.00	700.00	LTCG
USD	Ex. 1	1771327	2	1999-01-01	12	50	0	BUY		0	12	600.00	600.00	200			2200.00	11.0000
USD	Ex. 1	1771328	2	2000-01-01	26	100	0	BUY		0	26	2600.00	2600.00	300			4800.00	16.0000
USD	Ex. 1	1771329	2	2001-05-16	30	150	0	SELL						150	4500.00		2400.00	16.0000	2400.00	2100.00
USD	Ex. 2	1771330	3	1998-01-01	10	100	0	BUY	2001-05-16	0	10	1000.00	1000.00	100	3000.00	2000.00	1000.00	10.0000	1600.00	1400.00	LTCG
USD	Ex. 2	1771331	3	1999-01-01	12	50	0	BUY	2001-05-16	0	12	600.00	600.00	150	1500.00	900.00	1600.00	10.6667	800.00	700.00	LTCG
USD	Ex. 2	1771332	3	1999-01-01	12	50	0	BUY	2001-12-15	0	12	600.00	600.00	200	1400.00	800.00	2200.00	11.0000	800.00	600.00	LTCG
USD	Ex. 2	1771333	3	2000-01-01	26	100	0	BUY		0	26	2600.00	2600.00	300			4800.00	16.0000
USD	Ex. 2	1771334	3	2001-05-16	30	150	0	SELL						150	4500.00		2400.00	16.0000	2400.00	2100.00
USD	Ex. 2	1771335	3	2001-12-15	28	50	0	SELL						100	1400.00		1600.00	16.0000	800.00	600.00
USD	Ex. 3	1771336	4	1998-01-01	10	100	0	BUY	2001-05-16	0	10	1000.00	1000.00	100	3000.00	2000.00	1000.00	10.0000	1600.00	1400.00	LTCG
USD	Ex. 3	1771337	4	1999-01-01	12	50	0	BUY	2001-05-16	0	12	600.00	600.00	150	1500.00	900.00	1600.00	10.6667	800.00	700.00	LTCG
USD	Ex. 3	1771338	4	1999-01-01	12	50	0	BUY	2001-12-15	0	12	600.00	600.00	200	1400.00	800.00	2200.00	11.0000	750.00	650.00	LTCG
USD	Ex. 3	1771339	4	2000-01-01	26	100	0	BUY		0	26	2600.00	2600.00	300			4800.00	16.0000
USD	Ex. 3	1771340	4	2001-05-16	30	150	0	SELL						150	4500.00		2400.00	16.0000	2400.00	2100.00
USD	Ex. 3	1771341	4	2001-09-19	14	150	0	BUY		0	14	2100.00	2100.00	300			4500.00	15.0000
USD	Ex. 3	1771342	4	2001-12-15	28	50	0	SELL						250	1400.00		3750.00	15.0000	750.00	650.00
USD	Fund S	1771343	5	1987-07-10	10	200	0	BUY	2001-10-06	-0.02	9.98	2000.00	1996.00	200	3200.00	1204.00	1996.00	9.9800	1996.00	1204.00	5YCG
USD	Fund S	1771344	5	2001-10-06	16	200	0	SELL						0	3200.00		0.00	9.9800	1996.00	1204.00
USD	Table 3	1771320	1	2000-02-04	25	160	0	BUY	2001-09-29	0	25	4000.00	4000.00	160	5120.00	1120.00	4000.00	25.0000	3551.22	1568.78	LTCG
USD	Table 3	1771321	1	2000-08-05	20	50	0	BUY	2001-09-29	0	20	1000.00	1000.00	210	1600.00	600.00	5000.00	23.8095	1109.76	490.24	LTCG
USD	Table 3	1771322	1	2000-08-05	20	190	0	BUY		0	20	3800.00	3800.00	400			8800.00	22.0000
USD	Table 3	1771323	1	2000-12-16	30	10	0	BUY		0	30	300.00	300.00	410			9100.00	22.1951
USD	Table 3	1771324	1	2001-09-29	32	210	0	SELL						200	6720.00		4439.02	22.1951	4660.97	2059.03

(25 rows)

summary_cg_fifo_cjv

curr_id	abbrev	Fund ID	date	Number of Shares	Sale Date	Sale Price	Simple Cost Basis	Capital Gain, FIFO Method	Long Term / Short Term
USD	Table 3	1	2000-02-04	160	2001-09-29	5120.00	4000.00	1120.00	LTCG
USD	Table 3	1	2000-08-05	50	2001-09-29	1600.00	1000.00	600.00	LTCG
USD	Ex. 1	2	1998-01-01	100	2001-05-16	3000.00	1000.00	2000.00	LTCG
USD	Ex. 1	2	1999-01-01	50	2001-05-16	1500.00	600.00	900.00	LTCG
USD	Ex. 2	3	1998-01-01	100	2001-05-16	3000.00	1000.00	2000.00	LTCG
USD	Ex. 2	3	1999-01-01	50	2001-05-16	1500.00	600.00	900.00	LTCG
USD	Ex. 2	3	1999-01-01	50	2001-12-15	1400.00	600.00	800.00	LTCG
USD	Ex. 3	4	1998-01-01	100	2001-05-16	3000.00	1000.00	2000.00	LTCG
USD	Ex. 3	4	1999-01-01	50	2001-05-16	1500.00	600.00	900.00	LTCG
USD	Ex. 3	4	1999-01-01	50	2001-12-15	1400.00	600.00	800.00	LTCG
USD	Fund S	5	1987-07-10	200	2001-10-06	3200.00	1996.00	1204.00	5YCG

(11 rows)

summary_cg_acb_cjv

curr_id	abbrev	Fund ID	date	Number of Shares	Sale Date	Sale Price	Average Basis of These Shares	Capital Gain, ACB Method	Long Term / Short Term
USD	Table 3	1	2000-02-04	160	2001-09-29	5120.00	3551.22	1568.78	LTCG
USD	Table 3	1	2000-08-05	50	2001-09-29	1600.00	1109.76	490.24	LTCG
USD	Ex. 1	2	1998-01-01	100	2001-05-16	3000.00	1600.00	1400.00	LTCG
USD	Ex. 1	2	1999-01-01	50	2001-05-16	1500.00	800.00	700.00	LTCG
USD	Ex. 2	3	1998-01-01	100	2001-05-16	3000.00	1600.00	1400.00	LTCG
USD	Ex. 2	3	1999-01-01	50	2001-05-16	1500.00	800.00	700.00	LTCG
USD	Ex. 2	3	1999-01-01	50	2001-12-15	1400.00	800.00	600.00	LTCG
USD	Ex. 3	4	1998-01-01	100	2001-05-16	3000.00	1600.00	1400.00	LTCG
USD	Ex. 3	4	1999-01-01	50	2001-05-16	1500.00	800.00	700.00	LTCG
USD	Ex. 3	4	1999-01-01	50	2001-12-15	1400.00	750.00	650.00	LTCG
USD	Fund S	5	1987-07-10	200	2001-10-06	3200.00	1996.00	1204.00	5YCG

(11 rows)
DROP CREATE

summary_fund_income_pcjv

curr_id	year	abbrev	sum(Net Income)
USD	1989	Fund S	10.00
USD	1989		10.00
USD	1990	Fund S	4.00
USD	1990		4.00
USD	1998	Fund S	8.00
USD	1998		8.00
USD	1999	Fund S	6.00
USD	1999		6.00
USD	2000	Fund S	12.00
USD	2000		12.00
USD		Table 3
USD			40.00
USD

(13 rows)
DROP CREATE

summary_cg_fifo_pcjv

curr_id	year	abbrev	Sale Date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Simple Cost Basis)	sum(Capital Gain, FIFO Method)
USD	2001	Ex. 1	2001-05-16	LTCG	150	4500.00	1600.00	2900.00
USD	2001	Ex. 1			150	4500.00	1600.00	2900.00
USD	2001	Ex. 2	2001-05-16	LTCG	150	4500.00	1600.00	2900.00
USD	2001	Ex. 2	2001-12-15	LTCG	50	1400.00	600.00	800.00
USD	2001	Ex. 2			200	5900.00	2200.00	3700.00
USD	2001	Ex. 3	2001-05-16	LTCG	150	4500.00	1600.00	2900.00
USD	2001	Ex. 3	2001-12-15	LTCG	50	1400.00	600.00	800.00
USD	2001	Ex. 3			200	5900.00	2200.00	3700.00
USD	2001	Fund S	2001-10-06	5YCG	200	3200.00	1996.00	1204.00
USD	2001	Fund S			200	3200.00	1996.00	1204.00
USD	2001	Table 3	2001-09-29	LTCG	210	6720.00	5000.00	1720.00
USD	2001	Table 3			210	6720.00	5000.00	1720.00
USD	2001				960	26220.00	12996.00	13224.00
USD					960	26220.00	12996.00	13224.00

(14 rows)
DROP CREATE

summary_cg_acb_pcjv

curr_id	year	abbrev	Sale Date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Average Basis of These Shar	sum(Capital Gain, ACB Method)
USD	2001	Ex. 1	2001-05-16	LTCG	150	4500.00	2400.00	2100.00
USD	2001	Ex. 1			150	4500.00	2400.00	2100.00
USD	2001	Ex. 2	2001-05-16	LTCG	150	4500.00	2400.00	2100.00
USD	2001	Ex. 2	2001-12-15	LTCG	50	1400.00	800.00	600.00
USD	2001	Ex. 2			200	5900.00	3200.00	2700.00
USD	2001	Ex. 3	2001-05-16	LTCG	150	4500.00	2400.00	2100.00
USD	2001	Ex. 3	2001-12-15	LTCG	50	1400.00	750.00	650.00
USD	2001	Ex. 3			200	5900.00	3150.00	2750.00
USD	2001	Fund S	2001-10-06	5YCG	200	3200.00	1996.00	1204.00
USD	2001	Fund S			200	3200.00	1996.00	1204.00
USD	2001	Table 3	2001-09-29	LTCG	210	6720.00	4660.98	2059.02
USD	2001	Table 3			210	6720.00	4660.98	2059.02
USD	2001				960	26220.00	15406.98	10813.02
USD					960	26220.00	15406.98	10813.02

(14 rows)
DROP CREATE

detailed_summary_cg_acb_pcjv

curr_id	year	abbrev	Sale Date	date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Average Basis of These Shar	sum(Capital Gain, ACB Method)
USD	2001	Ex. 1	2001-05-16	1998-01-01	LTCG	100	3000.00	1600.00	1400.00
USD	2001	Ex. 1	2001-05-16	1999-01-01	LTCG	50	1500.00	800.00	700.00
USD	2001	Ex. 1	2001-05-16			150	4500.00	2400.00	2100.00
USD	2001	Ex. 1				150	4500.00	2400.00	2100.00
USD	2001	Ex. 2	2001-05-16	1998-01-01	LTCG	100	3000.00	1600.00	1400.00
USD	2001	Ex. 2	2001-05-16	1999-01-01	LTCG	50	1500.00	800.00	700.00
USD	2001	Ex. 2	2001-05-16			150	4500.00	2400.00	2100.00
USD	2001	Ex. 2	2001-12-15	1999-01-01	LTCG	50	1400.00	800.00	600.00
USD	2001	Ex. 2	2001-12-15			50	1400.00	800.00	600.00
USD	2001	Ex. 2				200	5900.00	3200.00	2700.00
USD	2001	Ex. 3	2001-05-16	1998-01-01	LTCG	100	3000.00	1600.00	1400.00
USD	2001	Ex. 3	2001-05-16	1999-01-01	LTCG	50	1500.00	800.00	700.00
USD	2001	Ex. 3	2001-05-16			150	4500.00	2400.00	2100.00
USD	2001	Ex. 3	2001-12-15	1999-01-01	LTCG	50	1400.00	750.00	650.00
USD	2001	Ex. 3	2001-12-15			50	1400.00	750.00	650.00
USD	2001	Ex. 3				200	5900.00	3150.00	2750.00
USD	2001	Fund S	2001-10-06	1987-07-10	5YCG	200	3200.00	1996.00	1204.00
USD	2001	Fund S	2001-10-06			200	3200.00	1996.00	1204.00
USD	2001	Fund S				200	3200.00	1996.00	1204.00
USD	2001	Table 3	2001-09-29	2000-02-04	LTCG	160	5120.00	3551.22	1568.78
USD	2001	Table 3	2001-09-29	2000-08-05	LTCG	50	1600.00	1109.76	490.24
USD	2001	Table 3	2001-09-29			210	6720.00	4660.98	2059.02
USD	2001	Table 3				210	6720.00	4660.98	2059.02
USD	2001					960	26220.00	15406.98	10813.02
USD						960	26220.00	15406.98	10813.02

(25 rows)