AV_GIFTAN_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: G
4	PGIVING_NBR	Character(9)	VARCHAR2(9) NOT NULL	Planned Giving Number
5	GFTAN_NAME	Character(60)	VARCHAR2(60) NOT NULL	Gift Annuity Name
6	GIFTAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Gift Annuity Type CH=Charitable DE=Deferred
7	GIFTAN_PERIOD	Number(2,0)	SMALLINT NOT NULL	Deferral Period
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_INSTALL_INST.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
9	GIFTAN_RATE	Number(6,2)	DECIMAL(5,2) NOT NULL	Rate
10	GIFTAN_IDATE	Date(10)	DATE	Inception Date
11	START_DT	Date(10)	DATE	Start Date
12	GIFTAN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Gift Annuity Status A=Active I=Inactive Default Value: A
13	ASSET_CD	Character(6)	VARCHAR2(6) NOT NULL	Asset Category Prompt Table: AV_ASSET_TBL
14	PG_IRREVOCABLE	Character(1)	VARCHAR2(1) NOT NULL	Irrevocable N=No Y=Yes Default Value: N
15	GIFTAN_GIFT_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Gift Amount
16	GIFTAN_RESERVE	Number(16,2)	DECIMAL(15,2) NOT NULL	Reserve
17	GIFTAN_LIABILITY	Number(16,2)	DECIMAL(15,2) NOT NULL	Liability
18	GIFTAN_DT	Date(10)	DATE	Gift Annuity Date
19	INST_ACT_VAL	Number(16,2)	DECIMAL(15,2) NOT NULL	Inst Actual Value
20	INST_EST_VAL	Number(16,2)	DECIMAL(15,2) NOT NULL	Inst Est Value
21	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code Prompt Table: AV_INTV_CMP_VW
22	DESCRLONG	Long Character	CLOB	Long Description