AV_MBR_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: AV_SESSION_TBL.BUSINESS_UNIT Prompt Table: AV_INST_BU_VW
2	SESSION_NO	Character(11)	VARCHAR2(11) NOT NULL	Session Nbr Prompt Table: AV_SESSION_TBL
3	MBR_PMT_NO	Character(11)	VARCHAR2(11) NOT NULL	Member Payment Number Prompt Table: %EDITTABLE2
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: AV_PEOPLE_SRCH
5	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: AV_EXT_ORG_SRCH
6	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person Default Value: P
7	DUES_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Dues Amt
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
9	AV_DUES_PERIOD	Number(2,0)	SMALLINT NOT NULL	Dues Periods Default Value: 1
10	AV_TTL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total Amt
11	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
12	DATA_ENTRY_DT	Date(10)	DATE	Data Entry Date Default Value: %date
13	TENDER_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Tender Type Default Value: AV_BUS_UNIT_TBL.TENDER_TYPE Prompt Table: AV_TNDR_TYPE_VW
14	CHECK_NO	Character(10)	VARCHAR2(10) NOT NULL	Check Number
15	CREDIT_CARD_NO	Character(20)	VARCHAR2(20) NOT NULL	Credit Card Number
16	CREDIT_CARD_HOLDER	Character(30)	VARCHAR2(30) NOT NULL	Credit Card Holder
17	CREDIT_CARD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Credit Card Type AE=American Express DC=Diners' Club DI=Diners Club MC=MasterCard VI=VISA
18	CREDIT_CARD_EXP_DT	Date(10)	DATE	Expiration Date
19	TENDER_TYPE_NOTE	Character(50)	VARCHAR2(50) NOT NULL	Tender Type Notes
20	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
21	ADJUSTMENT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Adjusted Flag N=No Y=Yes Default Value: N
22	CHARITABLE_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Charitable Amount
23	MOTIVATION_CD	Character(9)	VARCHAR2(9) NOT NULL	Appeal Code Prompt Table: AV_MTVTN_MBR_VW
24	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code Prompt Table: AV_MBR_ORG_TBL
25	AV_DUES_LVL	Character(5)	VARCHAR2(5) NOT NULL	Dues Level Prompt Table: AV_MBR_DUES_TBL
26	EXPIRATION_DT	Date(10)	DATE	Expiration Date
27	AV_MBR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Membership Status A=Reactivated L=Lapsed N=New R=Renewed Default Value: N
28	START_DT	Date(10)	DATE	Start Date
29	GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Gift Nbr
30	AV_TTL_AMT_ENTRY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total Amt
31	CURRENCY_CD_ENTRY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY
32	CHARITAB_AMT_ENTRY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Charitable Amount
33	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
34	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
35	AV_COMP_CHK	Character(1)	VARCHAR2(1) NOT NULL	Complimentary Y/N Table Edit Default Value: N
36	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_SESSION_TBL.INSTITUTION
37	AV_TNDR_GIFT_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Gift Description used for Gift in Kind and Security Tender Types
38	AV_TNDR_GIFT_PURP	Character(254)	VARCHAR2(254) NOT NULL	Gift Purpose used for Gift in Kind Tender Type
39	AV_EST_VAL	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Estimated Value
40	AV_APPRAISAL	Character(1)	VARCHAR2(1) NOT NULL	Written Appraisal used for Gift in Kind Tender Type Y/N Table Edit
41	AV_APPRAISE_VAL	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Appraised Value used in Gift in Kind Tender type
42	AV_APPRAISAL_DATE	Date(10)	DATE	Appraisal Date used in Gift i n Kind Tender Type