Model Campaign

Model Label : BANNER Advancement Campaign Processing
Path : BANNER DEV/Advancement/Advancement_ERD/Campaign_ERD

List of Objects

Object Name	Object Type	Layer Name
AFBCAMP	TABLE	Default
AFRCOMT	TABLE	Default
AFRCORG	TABLE	Default
AFRCSOL	TABLE	Default
AFRCTYP	TABLE	Default
AFRDESG	TABLE	Default
AFREXPN	TABLE	Default
AFRMAIL	TABLE	Default
AGRGCAM	TABLE	Default
AGRGDES	TABLE	Default
AGRGHDE	TABLE	Default
AGRGSOL	TABLE	Default
AGRPDES	TABLE	Default
AGRPSOL	TABLE	Default
APRCHIS	TABLE	Default
ATVCMTP	TABLE	Default
AXRMDES	TABLE	Default

Comments

Model View

Table AFBCAMP

Schema Name ALUMNI
Label AFBCAMP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AFBCAMP_CAMPAIGN	AFBCAMP_CAMPAIGN	VARCHAR2(5)	No	*	*
AFBCAMP_NAME	AFBCAMP_NAME	VARCHAR2(30)	No
AFBCAMP_CMTP_CODE	AFBCAMP_CMTP_CODE	VARCHAR2(2)	No		*
AFBCAMP_EST_DATE	AFBCAMP_EST_DATE	DATE	Yes
AFBCAMP_END_DATE	AFBCAMP_END_DATE	DATE	Yes
AFBCAMP_GOAL	AFBCAMP_GOAL	NUMBER(13,2)	Yes
AFBCAMP_DEFAULT_DESG	AFBCAMP_DEFAULT_DESG	VARCHAR2(10)	Yes
AFBCAMP_ASSOC_IND	AFBCAMP_ASSOC_IND	VARCHAR2(1)	Yes
AFBCAMP_PURGED_IND	AFBCAMP_PURGED_IND	VARCHAR2(1)	Yes
AFBCAMP_ACTIVITY_DATE	AFBCAMP_ACTIVITY_DATE	DATE	No
AFBCAMP_WEB_GIFT_IND	AFBCAMP_WEB_GIFT_IND	VARCHAR2(1)	Yes
AFBCAMP_WEB_PLDG_IND	AFBCAMP_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFBCAMP_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
AFBCAMP_CAMPAIGN	AGRGDES_CAMPAIGN	AGRGDES

Index

Index Name	Index Type	Column Name
AFBCAMP_CMTP_INDEX		AFBCAMP_CMTP_CODE
PK_AFBCAMP	Unique	AFBCAMP_CAMPAIGN

Comments

Source Code Comments

Campaign Base Table

Columns Comments for AFBCAMP_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code. When a new campaign code is added, the Campaign List Form is automatically updated.

Columns Comments for AFBCAMP_NAME (2)

Source Code Comments

This field specifies contains the name of the campaign.

Columns Comments for AFBCAMP_CMTP_CODE (3)

Source Code Comments

This field specifies the campaign type for a specific campaign.

Columns Comments for AFBCAMP_EST_DATE (4)

Source Code Comments

This field specifies the start date of the campaign.

Columns Comments for AFBCAMP_END_DATE (5)

Source Code Comments

This field specifies the end date of the campaign.

Columns Comments for AFBCAMP_GOAL (6)

Source Code Comments

This field specifies the dollar amount of the campaign goal.

Columns Comments for AFBCAMP_DEFAULT_DESG (7)

Source Code Comments

This field specifies the default designation to be used when pledges for the campaign are created.

Columns Comments for AFBCAMP_ASSOC_IND (8)

Source Code Comments

This field specifies whether the monies received for this campaign are used in the calculation of a constituents giving level.

Columns Comments for AFBCAMP_PURGED_IND (9)

Source Code Comments

This field no longer used as of release 1.7.

Columns Comments for AFBCAMP_ACTIVITY_DATE (10)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AFBCAMP_WEB_GIFT_IND (11)

Source Code Comments

Web Gift Indicator, Y indicates that gifts for this Campaign will be accepted from the Web.

Columns Comments for AFBCAMP_WEB_PLDG_IND (12)

Source Code Comments

Web Pledge Indicator, Y indicates that pledges for this Campaign will be accepted from the Web.

Table AFRCOMT

Schema Name ALUMNI
Label AFRCOMT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCOMT_CAMPAIGN	AFRCOMT_CAMPAIGN	VARCHAR2(5)	No	*
AFRCOMT_SEQ_NO	AFRCOMT_SEQ_NO	NUMBER(23,20)	No
AFRCOMT_COMMENT	AFRCOMT_COMMENT	VARCHAR2(60)	No
AFRCOMT_ACTIVITY_DATE	AFRCOMT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCOMT_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
AFRCOMT_KEY_INDEX		AFRCOMT_CAMPAIGN

Comments

Source Code Comments

Campaign Comment Repeating Table

Columns Comments for AFRCOMT_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCOMT_SEQ_NO (2)

Source Code Comments

This field specifies the internal campaign comment sequence number.

Columns Comments for AFRCOMT_COMMENT (3)

Source Code Comments

This field specifies the free-form campaign comments.

Columns Comments for AFRCOMT_ACTIVITY_DATE (4)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AFRCORG

Schema Name ALUMNI
Label AFRCORG
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCORG_CAMPAIGN	AFRCORG_CAMPAIGN	VARCHAR2(5)	No	*
AFRCORG_SOLC_CODE	AFRCORG_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCORG_SOL_ORG	AFRCORG_SOL_ORG	VARCHAR2(5)	No	*
AFRCORG_INDEX	AFRCORG_INDEX	VARCHAR2(5)	Yes
AFRCORG_SEQ_NO	AFRCORG_SEQ_NO	VARCHAR2(5)	No
AFRCORG_LEVEL	AFRCORG_LEVEL	VARCHAR2(2)	No
AFRCORG_GOAL	AFRCORG_GOAL	NUMBER(11,2)	Yes
AFRCORG_ACTIVITY_DATE	AFRCORG_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCORG_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCORG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRCORG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
AFRCORG_KEY_INDEX	Unique	AFRCORG_CAMPAIGN
AFRCORG_KEY_INDEX	Unique	AFRCORG_SOLC_CODE
AFRCORG_KEY_INDEX	Unique	AFRCORG_SOL_ORG

Comments

Source Code Comments

Campaign Organization Repeating Table

Columns Comments for AFRCORG_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCORG_SOLC_CODE (2)

Source Code Comments

This field specifies the type of solicitation(s) being performed for a specific campaign.

Columns Comments for AFRCORG_SOL_ORG (3)

Source Code Comments

This field specifies the five character solicitor organization code associated with the fund raising efforts of a specific campaign.

Columns Comments for AFRCORG_INDEX (4)

Source Code Comments

This field specifies the hierarchical level of the solicitor organization.

Columns Comments for AFRCORG_SEQ_NO (5)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for AFRCORG_LEVEL (6)

Source Code Comments

This field specifies the code used to define a hierarchical level within the solicitor organization.

Columns Comments for AFRCORG_GOAL (7)

Source Code Comments

This field specifies the dollar amount goal of the solicitor organization for a specific campaign.

Columns Comments for AFRCORG_ACTIVITY_DATE (8)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AFRCSOL

Schema Name ALUMNI
Label AFRCSOL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AFRCSOL_CAMPAIGN	AFRCSOL_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRCSOL_SOLC_CODE	AFRCSOL_SOLC_CODE	VARCHAR2(8)	No	*	*
AFRCSOL_GOAL	AFRCSOL_GOAL	NUMBER(13,2)	Yes
AFRCSOL_ACTIVITY_DATE	AFRCSOL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCSOL_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCSOL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP

Index

Index Name	Index Type	Column Name
PK_AFRCSOL	Unique	AFRCSOL_CAMPAIGN
PK_AFRCSOL	Unique	AFRCSOL_SOLC_CODE

Comments

Source Code Comments

Campaign Solicitation Type Repeating Table

Columns Comments for AFRCSOL_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCSOL_SOLC_CODE (2)

Source Code Comments

This field specifies the type of solicitation used in a specific campaign.

Columns Comments for AFRCSOL_GOAL (3)

Source Code Comments

This field specifies the campaign goal for each individual campaign solicitation type.

Columns Comments for AFRCSOL_ACTIVITY_DATE (4)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AFRCTYP

Schema Name ALUMNI
Label AFRCTYP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCTYP_CAMPAIGN	AFRCTYP_CAMPAIGN	VARCHAR2(5)	Yes	*
AFRCTYP_SOLC_CODE	AFRCTYP_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCTYP_SOLC_CODE	AFRCTYP_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCTYP_SOL_ORG	AFRCTYP_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCTYP_SOL_ORG	AFRCTYP_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCTYP_SOL_ORG	AFRCTYP_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_SEQ_NO	AFRCTYP_SEQ_NO	NUMBER(5,0)	No	*
AFRCTYP_CONSTITUENT_PIDM	AFRCTYP_CONSTITUENT_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_ACTIVITY_DATE	AFRCTYP_ACTIVITY_DATE	DATE	No
AFRCTYP_USER	AFRCTYP_USER	VARCHAR2(30)	No
AFRCTYP_RATE_CODE	AFRCTYP_RATE_CODE	VARCHAR2(2)	Yes	*
AFRCTYP_RSCR_CODE	AFRCTYP_RSCR_CODE	VARCHAR2(5)	Yes	*
AFRCTYP_RATER_PIDM	AFRCTYP_RATER_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_ASK_AMOUNT	AFRCTYP_ASK_AMOUNT	NUMBER(11,2)	Yes
AFRCTYP_ASK_DATE	AFRCTYP_ASK_DATE	DATE	Yes
AFRCTYP_COMMENT	AFRCTYP_COMMENT	VARCHAR2(2000)	Yes
AFRCTYP_ASSIGN_DATE	AFRCTYP_ASSIGN_DATE	DATE	Yes
AFRCTYP_DCYR_CODE	AFRCTYP_DCYR_CODE	NUMBER(4,0)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCTYP_RATE_CODE	ATVRATE_CODE	ATVRATE
AFRCTYP_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCTYP_PIDM	ASRSORG_PIDM	ASRSORG
AFRCTYP_SOL_ORG	ASRSORG_SOL_ORG	ASRSORG
AFRCTYP_PIDM	AFRCRES_PIDM	AFRCRES
AFRCTYP_SEQ_NO	AFRCRES_CTYP_SEQ_NO	AFRCRES
AFRCTYP_RSCR_CODE	ATVRSCR_CODE	ATVRSCR
AFRCTYP_SOLC_CODE	AFRCSLT_SOLC_CODE	AFRCSLT
AFRCTYP_SOL_ORG	AFRCSLT_SOL_ORG	AFRCSLT
AFRCTYP_PIDM	AFRCSLT_PIDM	AFRCSLT
AFRCTYP_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRCTYP_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AFRCTYP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AFRCTYP_PIDM	SPRIDEN_PIDM	SPRIDEN
AFRCTYP_CONSTITUENT_PIDM	SPRIDEN_PIDM	SPRIDEN
AFRCTYP_RATER_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_CAMPAIGN
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SOLC_CODE
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SOL_ORG
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_PIDM
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SEQ_NO
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_DCYR_CODE
AFRCTYP_KEY_INDEX2		AFRCTYP_PIDM
AFRCTYP_KEY_INDEX3		AFRCTYP_CONSTITUENT_PIDM
AFRCTYP_KEY_INDEX4		AFRCTYP_SOL_ORG
AFRCTYP_KEY_INDEX4		AFRCTYP_DCYR_CODE
AFRCTYP_KEY_INDEX4		AFRCTYP_PIDM
AFRCTYP_KEY_INDEX4		AFRCTYP_SEQ_NO

Comments

Source Code Comments

Campaign Contact Repeating Table

Columns Comments for AFRCTYP_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCTYP_SOLC_CODE (2)

Source Code Comments

This field specifies the type of solicitations used for the campaign.

Columns Comments for AFRCTYP_SOL_ORG (3)

Source Code Comments

This field specifies the type of solicitor organization code.

Columns Comments for AFRCTYP_PIDM (4)

Source Code Comments

This field specifies the internal system generated identification number of the solicitor.

Columns Comments for AFRCTYP_SEQ_NO (5)

Source Code Comments

This field identifies the internal sequence number of the solicitor.

Columns Comments for AFRCTYP_CONSTITUENT_PIDM (6)

Source Code Comments

This field specifies the internal system generated identification number of the constituents assigned to the solicitor.

Columns Comments for AFRCTYP_ACTIVITY_DATE (7)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AFRCTYP_USER (8)

Source Code Comments

User ID of the user that created or last updated the record

Columns Comments for AFRCTYP_RATE_CODE (9)

Source Code Comments

Rating code given the contact by the rater.

Columns Comments for AFRCTYP_RSCR_CODE (10)

Source Code Comments

Rater type code for the person rating the contact.

Columns Comments for AFRCTYP_RATER_PIDM (11)

Source Code Comments

Internal ID of the person rating the contact.

Columns Comments for AFRCTYP_ASK_AMOUNT (12)

Source Code Comments

Amount the solicitor asked the contact to give or pledge

Columns Comments for AFRCTYP_ASK_DATE (13)

Source Code Comments

Date that the solicitor asked the contact to commit to.

Columns Comments for AFRCTYP_COMMENT (14)

Source Code Comments

2000 Character free-form comment associated with the contact.

Columns Comments for AFRCTYP_ASSIGN_DATE (15)

Source Code Comments

Date that the contact was assigned to the solicitor.

Columns Comments for AFRCTYP_DCYR_CODE (16)

Source Code Comments

Year for which the solicitation should be made, may be blank.

Table AFRDESG

Schema Name ALUMNI
Label AFRDESG
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AFRDESG_CAMPAIGN	AFRDESG_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRDESG_CAMPAIGN	AFRDESG_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRDESG_DESG	AFRDESG_DESG	VARCHAR2(10)	No	*	*
AFRDESG_DESG	AFRDESG_DESG	VARCHAR2(10)	No	*	*
AFRDESG_GOAL	AFRDESG_GOAL	NUMBER(13,2)	Yes
AFRDESG_AMT_PLEDGED	AFRDESG_AMT_PLEDGED	NUMBER(13,2)	Yes
AFRDESG_AMT_PLEDGED_PAID	AFRDESG_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
AFRDESG_AMT_GIFT	AFRDESG_AMT_GIFT	NUMBER(13,2)	Yes
AFRDESG_ACTIVITY_DATE	AFRDESG_ACTIVITY_DATE	DATE	No
AFRDESG_DSTA_CODE	AFRDESG_DSTA_CODE	VARCHAR2(1)	Yes		*
AFRDESG_WEB_GIFT_IND	AFRDESG_WEB_GIFT_IND	VARCHAR2(1)	Yes
AFRDESG_WEB_PLDG_IND	AFRDESG_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA
AFRDESG_CAMPAIGN	AGRPDES_CAMPAIGN	AGRPDES
AFRDESG_DESG	AGRPDES_DESG	AGRPDES
AFRDESG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRDESG_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_AFRDESG	Unique	AFRDESG_CAMPAIGN
PK_AFRDESG	Unique	AFRDESG_DESG

Comments

Source Code Comments

Designation In Campaign Repeating Table

Columns Comments for AFRDESG_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRDESG_DESG (2)

Source Code Comments

This field specifies the designations that are associated with a specific campaign.

Columns Comments for AFRDESG_GOAL (3)

Source Code Comments

This field contains the dollar amount goal of the designation associated with a specific campaign.

Columns Comments for AFRDESG_AMT_PLEDGED (4)

Source Code Comments

This field specifies the amount of pledges associated with the designation.

Columns Comments for AFRDESG_AMT_PLEDGED_PAID (5)

Source Code Comments

This field identifies the amount of pledge payments for the designation.

Columns Comments for AFRDESG_AMT_GIFT (6)

Source Code Comments

This field identifies the amount of gifts and pledge payments for the designation.

Columns Comments for AFRDESG_ACTIVITY_DATE (7)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AFRDESG_DSTA_CODE (8)

Source Code Comments

Designation Status Code indicates the status of the designation.

Columns Comments for AFRDESG_WEB_GIFT_IND (9)

Source Code Comments

Web Gift Indicator, Y indicates that gifts for this Campaign and Designation will be accepted from the Web.

Columns Comments for AFRDESG_WEB_PLDG_IND (10)

Source Code Comments

Web Pledge Indicator, Y indicates that pledges for this Campaign and Desgination will be accepted from the Web.

Table AFREXPN

Schema Name ALUMNI
Label AFREXPN
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AFREXPN_CAMPAIGN	AFREXPN_CAMPAIGN	VARCHAR2(5)	No	*	*
AFREXPN_SEQ_NO	AFREXPN_SEQ_NO	NUMBER(5,0)	No	*
AFREXPN_EXPN_CODE	AFREXPN_EXPN_CODE	VARCHAR2(2)	No		*
AFREXPN_REASON	AFREXPN_REASON	VARCHAR2(30)	No
AFREXPN_EXPN_DATE	AFREXPN_EXPN_DATE	DATE	Yes
AFREXPN_AMT	AFREXPN_AMT	NUMBER(11,2)	Yes
AFREXPN_CHECK_NO	AFREXPN_CHECK_NO	VARCHAR2(10)	Yes
AFREXPN_FISC_CODE	AFREXPN_FISC_CODE	NUMBER(4,0)	Yes		*
AFREXPN_ACTIVITY_DATE	AFREXPN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFREXPN_FISC_CODE	ATVFISC_CODE	ATVFISC
AFREXPN_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFREXPN_EXPN_CODE	GTVEXPN_CODE	GTVEXPN

Index

Index Name	Index Type	Column Name
PK_AFREXPN	Unique	AFREXPN_CAMPAIGN
PK_AFREXPN	Unique	AFREXPN_SEQ_NO

Comments

Source Code Comments

Campaign Expense Repeating Table

Columns Comments for AFREXPN_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFREXPN_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number for campaign expenses.

Columns Comments for AFREXPN_EXPN_CODE (3)

Source Code Comments

This field specifies the expense code of the campaign expense.

Columns Comments for AFREXPN_REASON (4)

Source Code Comments

This field specifies the expense code description of the campaign expense.

Columns Comments for AFREXPN_EXPN_DATE (5)

Source Code Comments

This field specifies the date of the campaign expense.

Columns Comments for AFREXPN_AMT (6)

Source Code Comments

This field specifies the amount of the campaign expense.

Columns Comments for AFREXPN_CHECK_NO (7)

Source Code Comments

This field specifies the check number of the campaign expense.

Columns Comments for AFREXPN_FISC_CODE (8)

Source Code Comments

This field specifies the fiscal year of the campaign expense.

Columns Comments for AFREXPN_ACTIVITY_DATE (9)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AFRMAIL

Schema Name ALUMNI
Label AFRMAIL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AFRMAIL_CAMPAIGN	AFRMAIL_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRMAIL_MAIL_CODE	AFRMAIL_MAIL_CODE	VARCHAR2(3)	No	*	*
AFRMAIL_ACTIVITY_DATE	AFRMAIL_ACTIVITY_DATE	DATE	No
AFRMAIL_MAIL_DATE	AFRMAIL_MAIL_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRMAIL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRMAIL_MAIL_CODE	GTVMAIL_CODE	GTVMAIL

Index

Index Name	Index Type	Column Name
PK_AFRMAIL	Unique	AFRMAIL_CAMPAIGN
PK_AFRMAIL	Unique	AFRMAIL_MAIL_CODE

Comments

Source Code Comments

Campaign Mail Code Repeating Table

Columns Comments for AFRMAIL_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRMAIL_MAIL_CODE (2)

Source Code Comments

This field specifies the type of mailings to be used with the associated campaign.

Columns Comments for AFRMAIL_ACTIVITY_DATE (3)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for AFRMAIL_MAIL_DATE (4)

Source Code Comments

This field indicates the date the item was mailed.

Table AGRGCAM

Schema Name ALUMNI
Label AGRGCAM
Server name MALDEV8_B60
Creation Date 12/20/2002 10:42:36:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRGCAM_PIDM	AGRGCAM_PIDM	NUMBER(8,0)	No	*	*
AGRGCAM_PIDM	AGRGCAM_PIDM	NUMBER(8,0)	No	*	*
AGRGCAM_PIDM	AGRGCAM_PIDM	NUMBER(8,0)	No	*	*
AGRGCAM_PIDM	AGRGCAM_PIDM	NUMBER(8,0)	No	*	*
AGRGCAM_PIDM	AGRGCAM_PIDM	NUMBER(8,0)	No	*	*
AGRGCAM_GIFT_NO	AGRGCAM_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGCAM_GIFT_NO	AGRGCAM_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGCAM_GIFT_NO	AGRGCAM_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGCAM_PLEDGE_NO	AGRGCAM_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGCAM_CAMPAIGN	AGRGCAM_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGCAM_CAMPAIGN	AGRGCAM_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGCAM_AMT	AGRGCAM_AMT	NUMBER(11,2)	No
AGRGCAM_ACTIVITY_DATE	AGRGCAM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGCAM_CAMPAIGN	AGRMCAM_CAMPAIGN	AGRMCAM
AGRGCAM_GIFT_NO	AGRMCAM_GIFT_NO	AGRMCAM
AGRGCAM_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
AGRGCAM_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRGCAM_PIDM	AXBMGID_EMPR_PIDM	AXBMGID
AGRGCAM_PLEDGE_NO	AXBMGID_PLEDGE_NO	AXBMGID
AGRGCAM_PIDM	AXBMGID_PIDM	AXBMGID
AGRGCAM_GIFT_NO	AGRMGIF_EMPR_GIFT_NO	AGRMGIF
AGRGCAM_PIDM	AGRMGIF_EMPR_PIDM	AGRMGIF
AGRGCAM_GIFT_NO	AGRMGIF_GIFT_NO	AGRMGIF
AGRGCAM_PIDM	AGRMGIF_PIDM	AGRMGIF

Index

Index Name	Index Type	Column Name
AGRGCAM_KEY_INDEX2		AGRGCAM_CAMPAIGN
AGRGCAM_KEY_INDEX2		AGRGCAM_GIFT_NO
AGRGCAM_KEY_INDEX2		AGRGCAM_AMT
PK_AGRGCAM	Unique	AGRGCAM_PIDM
PK_AGRGCAM	Unique	AGRGCAM_GIFT_NO
PK_AGRGCAM	Unique	AGRGCAM_PLEDGE_NO
PK_AGRGCAM	Unique	AGRGCAM_CAMPAIGN

Comments

Source Code Comments

Gift Campaign Repeating Table

Columns Comments for AGRGCAM_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGCAM_GIFT_NO (2)

Source Code Comments

This field specifies the number of the gift.

Columns Comments for AGRGCAM_PLEDGE_NO (3)

Source Code Comments

This field specifies the number of the pledge.

Columns Comments for AGRGCAM_CAMPAIGN (4)

Source Code Comments

This field specifies the campaign associated with the gift.

Columns Comments for AGRGCAM_AMT (5)

Source Code Comments

This field specifies the amount of the gift.

Columns Comments for AGRGCAM_ACTIVITY_DATE (6)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AGRGDES

Schema Name ALUMNI
Label AGRGDES
Server name MALDEV8_B60
Creation Date 12/20/2002 10:42:35:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_PIDM	AGRGDES_PIDM	NUMBER(8,0)	No	*	*
AGRGDES_GIFT_NO	AGRGDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGDES_GIFT_NO	AGRGDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGDES_GIFT_NO	AGRGDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGDES_GIFT_NO	AGRGDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGDES_GIFT_NO	AGRGDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGDES_GIFT_NO	AGRGDES_GIFT_NO	VARCHAR2(7)	No	*	*
AGRGDES_PLEDGE_NO	AGRGDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGDES_PLEDGE_NO	AGRGDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGDES_PLEDGE_NO	AGRGDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGDES_PLEDGE_NO	AGRGDES_PLEDGE_NO	VARCHAR2(7)	No	*	*
AGRGDES_CAMPAIGN	AGRGDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGDES_CAMPAIGN	AGRGDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGDES_CAMPAIGN	AGRGDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGDES_CAMPAIGN	AGRGDES_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGDES_DESG	AGRGDES_DESG	VARCHAR2(10)	No	*	*
AGRGDES_DESG	AGRGDES_DESG	VARCHAR2(10)	No	*	*
AGRGDES_DESG	AGRGDES_DESG	VARCHAR2(10)	No	*	*
AGRGDES_AMT	AGRGDES_AMT	NUMBER(11,2)	No
AGRGDES_ACTIVITY_DATE	AGRGDES_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGDES_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
AGRGDES_PIDM	AGRGMLT_PIDM	AGRGMLT
AGRGDES_PLEDGE_NO	AGRGMLT_PLEDGE_NO	AGRGMLT
AGRGDES_GIFT_NO	AGRGMLT_GIFT_NO	AGRGMLT
AGRGDES_CAMPAIGN	AGRGMLT_CAMPAIGN	AGRGMLT
AGRGDES_DESG	AGRGMLT_DESG	AGRGMLT
AGRGDES_PIDM	AGRGMMO_PIDM	AGRGMMO
AGRGDES_PLEDGE_NO	AGRGMMO_PLEDGE_NO	AGRGMMO
AGRGDES_GIFT_NO	AGRGMMO_GIFT_NO	AGRGMMO
AGRGDES_CAMPAIGN	AGRGMMO_CAMPAIGN	AGRGMMO
AGRGDES_DESG	AGRGMMO_DESG	AGRGMMO
AGRGDES_DESG	AGRMDES_DESG	AGRMDES
AGRGDES_GIFT_NO	AGRMDES_GIFT_NO	AGRMDES
AGRGDES_CAMPAIGN	AGRMDES_CAMPAIGN	AGRMDES
AGRGDES_PIDM	AXBMGID_EMPR_PIDM	AXBMGID
AGRGDES_PLEDGE_NO	AXBMGID_PLEDGE_NO	AXBMGID
AGRGDES_PIDM	AXBMGID_PIDM	AXBMGID
AGRGDES_GIFT_NO	AGRMGIF_EMPR_GIFT_NO	AGRMGIF
AGRGDES_PIDM	AGRMGIF_EMPR_PIDM	AGRMGIF
AGRGDES_GIFT_NO	AGRMGIF_GIFT_NO	AGRMGIF
AGRGDES_PIDM	AGRMGIF_PIDM	AGRMGIF
AGRGDES_PIDM	AGRGCAM_PIDM	AGRGCAM
AGRGDES_GIFT_NO	AGRGCAM_GIFT_NO	AGRGCAM
AGRGDES_PLEDGE_NO	AGRGCAM_PLEDGE_NO	AGRGCAM
AGRGDES_CAMPAIGN	AGRGCAM_CAMPAIGN	AGRGCAM

Index

Index Name	Index Type	Column Name
AGRGDES_KEY_INDEX2		AGRGDES_DESG
AGRGDES_KEY_INDEX2		AGRGDES_GIFT_NO
AGRGDES_KEY_INDEX2		AGRGDES_AMT
AGRGDES_KEY_INDEX3		AGRGDES_PIDM
AGRGDES_KEY_INDEX3		AGRGDES_PLEDGE_NO
AGRGDES_KEY_INDEX4		AGRGDES_CAMPAIGN
AGRGDES_KEY_INDEX4		AGRGDES_DESG
PK_AGRGDES	Unique	AGRGDES_PIDM
PK_AGRGDES	Unique	AGRGDES_GIFT_NO
PK_AGRGDES	Unique	AGRGDES_PLEDGE_NO
PK_AGRGDES	Unique	AGRGDES_CAMPAIGN
PK_AGRGDES	Unique	AGRGDES_DESG

Comments

Source Code Comments

Gift Designation Repeating Table

Columns Comments for AGRGDES_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AGRGDES_GIFT_NO (2)

Source Code Comments

This field specifies the number of the gift.

Columns Comments for AGRGDES_PLEDGE_NO (3)

Source Code Comments

This field specifies the number of the pledge.

Columns Comments for AGRGDES_CAMPAIGN (4)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_DESG (5)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AGRGDES_AMT (6)

Source Code Comments

This field specifies the amount of the gift designation.

Columns Comments for AGRGDES_ACTIVITY_DATE (7)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table AGRGHDE

Schema Name ALUMNI
Label AGRGHDE
Server name MALDEV8_B60
Creation Date 05/08/2003 12:46:02:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGRGHDE_ID	AGRGHDE_ID	VARCHAR2(9)	No	*
AGRGHDE_GIFT_NO	AGRGHDE_GIFT_NO	VARCHAR2(7)	No	*
AGRGHDE_PLEDGE_NO	AGRGHDE_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGHDE_CAMPAIGN	AGRGHDE_CAMPAIGN	VARCHAR2(5)	No	*	*
AGRGHDE_DESG	AGRGHDE_DESG	VARCHAR2(10)	No	*	*
AGRGHDE_AMT	AGRGHDE_AMT	NUMBER(11,2)	No
AGRGHDE_ACTIVITY_DATE	AGRGHDE_ACTIVITY_DATE	DATE	No
AGRGHDE_USER	AGRGHDE_USER	VARCHAR2(30)	No
AGRGHDE_PIDM	AGRGHDE_PIDM	NUMBER(8,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table