AV_ADJ_PLDG_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SESSION_NO	Character(11)	VARCHAR2(11) NOT NULL	Session Nbr Prompt Table: AV_SESSION_TBL
3	GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Gift Nbr Default Value: NEW
4	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: AV_PEOPLE_SRCH
6	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: AV_EXT_ORG_SRCH
7	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person Default Value: P
8	GIFT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Gift Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
10	PLDG_EFFDT	Date(10)	DATE	Effective Date
11	PLEDGE_DT	Date(10)	DATE NOT NULL	First Payment Date Default Value: %date
12	FULF_DT	Date(10)	DATE NOT NULL	Fulfillment Date Default Value: %date
13	PMT_SCHD	Character(2)	VARCHAR2(2) NOT NULL	Payment Schedule A=Annual BM=Bi-Monthly I=Irregular M=Monthly Q=Quarterly SA=Semi-Annually W=Weekly
14	DATA_ENTRY_DT	Date(10)	DATE NOT NULL	Data Entry Date Default Value: %date
15	PLEDGE_PMT_RCVD	Number(16,2)	DECIMAL(15,2) NOT NULL	Payments Received
16	LAST_PMT_DT	Date(10)	DATE	Last Payment Date
17	ADJ_REASON_CD	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
18	CP_PLEDGE_NO	Character(11)	VARCHAR2(11) NOT NULL	Conditional Pledge Nbr
19	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
20	FEED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Feed Pledge N=No Y=Yes
21	PMT_DTL_CHG	Character(1)	VARCHAR2(1) NOT NULL	Payments Dtl Changed N=No Y=Yes
22	AV_PLDG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Pledge Status A=Active C=Closed W=Written Off
23	PLEDGE_PG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Planned Giving Type AT=Annuity Trust BQ=Bequest
24	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTN_SCRTY
25	DESCRLONG	Long Character	CLOB	Long Description