AV_MTVTN_TBL (SQL Table)	Index Back
Motivation TBL Contains all valid motivations for the GP module

AV_MTVTN_TBL

(SQL Table)

Motivation TBL

Contains all valid motivations for the GP module

Related Language Record: AV_MTVTN_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: AV_OPR_DEF_TBL.SETID
Prompt Table: SETID_TBL

2 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: AV_MTVTN_TBL.DESCR

7 APPEAL_TYPE Character(6) VARCHAR2(6) NOT NULL Indicates the type of Appeal.
Prompt Table: AV_APPEAL_TYPE

8 APPEAL_MBRSHIP Character(1) VARCHAR2(1) NOT NULL Flag that indicates the appeal code should appear in prompt lists for membership campaign initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in membership campaign initiative prompt lists.
Y/N Table Edit

9 APPEAL_CMPGN Character(1) VARCHAR2(1) NOT NULL Flag that indicates the appeal code should appear in prompt lists for campaign initiatives without a Phase of Annual Fund. A state of YES with no other flags set indicates this appeal code should appear ONLY in campaign initiative prompt lists.
Y/N Table Edit

10 APPEAL_VOLNTR Character(1) VARCHAR2(1) NOT NULL Flag that indicates the appeal code should appear in prompt lists for volunteer initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in volunteer initiative prompt lists.
Y/N Table Edit

11 APPEAL_EVENT Character(1) VARCHAR2(1) NOT NULL Flag that indicates the appeal code should appear in prompt lists for event initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in event initiative prompt lists.
Y/N Table Edit

12 APPEAL_OTHER Character(1) VARCHAR2(1) NOT NULL Flag that indicates the appeal code should appear in prompt lists for other initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in other initiative prompt lists.
Y/N Table Edit

13 START_DT Date(10) DATE Start Date
Default Value: %date

14 END_DT Date(10) DATE end date

15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

16 APPEAL_GOAL_AMT Number(16,2) DECIMAL(15,2) NOT NULL The amount of revenue expected to be generated by the appeal.

17 APPEAL_BUDGET_AMT Number(16,2) DECIMAL(15,2) NOT NULL The total expense budget for this particular appeal.

18 APPEAL_PIECE_CNT Number(9,0) DECIMAL(9) NOT NULL The total number of contacts (mail, phone contacts, e-mails, etc...) that will be attempted with the appeal

19 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code
Prompt Table: AV_MBR_ORG_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: AV_OPR_DEF_TBL.SETID Prompt Table: SETID_TBL
2	MOTIVATION_CD	Character(9)	VARCHAR2(9) NOT NULL	Appeal Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: AV_MTVTN_TBL.DESCR
7	APPEAL_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Indicates the type of Appeal. Prompt Table: AV_APPEAL_TYPE
8	APPEAL_MBRSHIP	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates the appeal code should appear in prompt lists for membership campaign initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in membership campaign initiative prompt lists. Y/N Table Edit
9	APPEAL_CMPGN	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates the appeal code should appear in prompt lists for campaign initiatives without a Phase of Annual Fund. A state of YES with no other flags set indicates this appeal code should appear ONLY in campaign initiative prompt lists. Y/N Table Edit
10	APPEAL_VOLNTR	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates the appeal code should appear in prompt lists for volunteer initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in volunteer initiative prompt lists. Y/N Table Edit
11	APPEAL_EVENT	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates the appeal code should appear in prompt lists for event initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in event initiative prompt lists. Y/N Table Edit
12	APPEAL_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates the appeal code should appear in prompt lists for other initiatives. A state of YES with no other flags set indicates this appeal code should appear ONLY in other initiative prompt lists. Y/N Table Edit
13	START_DT	Date(10)	DATE	Start Date Default Value: %date
14	END_DT	Date(10)	DATE	end date
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
16	APPEAL_GOAL_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	The amount of revenue expected to be generated by the appeal.
17	APPEAL_BUDGET_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	The total expense budget for this particular appeal.
18	APPEAL_PIECE_CNT	Number(9,0)	DECIMAL(9) NOT NULL	The total number of contacts (mail, phone contacts, e-mails, etc...) that will be attempted with the appeal
19	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code Prompt Table: AV_MBR_ORG_TBL