AV_BEQUEST_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	PG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Planned Giving Type B=Bequest G=Gift Annuity P=Pooled Income T=Trust Default Value: B
4	PGIVING_NBR	Character(9)	VARCHAR2(9) NOT NULL	Planned Giving Number
5	BQST_NAME	Character(60)	VARCHAR2(60) NOT NULL	Bequest Name
6	BEQUEST_DT	Date(10)	DATE NOT NULL	Bequest Date Default Value: %date
7	BEQUEST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Bequest Status A=Advised - Verbal I=In Probate M=Matured W=Advised - Written Default Value: A
8	BEQUEST_STAT_DT	Date(10)	DATE	Bequest Status Dt Default Value: %date
9	BEQUEST_EST_MAT	Date(10)	DATE	Estimated Maturity
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_INSTALL_INST.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
11	BEQUEST_EST_EST	Number(16,2)	DECIMAL(15,2) NOT NULL	Estimated Estate
12	BEQUEST_ACT_MAT	Date(10)	DATE	Actual Maturity
13	BEQUEST_ACT_EST	Number(16,2)	DECIMAL(15,2) NOT NULL	Actual Estate
14	BEQUEST_PRES_VAL	Number(16,2)	DECIMAL(15,2) NOT NULL	Present Value
15	BEQUEST_I_EST_VAL	Number(16,2)	DECIMAL(15,2) NOT NULL	Estimated Value
16	BEQUEST_I_PCT	Number(3,0)	SMALLINT NOT NULL	Percent
17	BEQUEST_I_ACT_VAL	Number(16,2)	DECIMAL(15,2) NOT NULL	Actual Value
18	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code Prompt Table: AV_INTV_CMP_VW
19	DESCRLONG	Long Character	CLOB	Long Description