Model Solicitor Organization

Model Label : BANNER Advancement Solicitior Organization Processing
Path : BANNER DEV/Advancement/Advancement_ERD/SolicitorOrganization_ERD

List of Objects

Object Name	Object Type	Layer Name
AFRCORG	TABLE	Default
AFRCRES	TABLE	Default
AFRCSLT	TABLE	Default
AFRCTYP	TABLE	Default
AGBPDEF	TABLE	Default
AGBWPLG	TABLE	Default
AGRGSOL	TABLE	Default
AGRMSOL	TABLE	Default
AGRPSOL	TABLE	Default
ASBSORG	TABLE	Default
ASRCOMT	TABLE	Default
ASRCONT	TABLE	Default
ASRSOAG	TABLE	Default
ASRSORG	TABLE	Default
ASRSSAG	TABLE	Default
ATVDCYR	TABLE	Default
ATVSOTP	TABLE	Default
ATVSSTA	TABLE	Default
AXRMSOL	TABLE	Default
STVATYP	TABLE	Default
STVCOLL	TABLE	Default

Comments

Model View

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 AFRCRES

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCRES_CAMPAIGN	AFRCRES_CAMPAIGN	VARCHAR2(5)	Yes
AFRCRES_SOLC_CODE	AFRCRES_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCRES_SOL_ORG	AFRCRES_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCRES_PIDM	AFRCRES_PIDM	NUMBER(8,0)	No
AFRCRES_CTYP_SEQ_NO	AFRCRES_CTYP_SEQ_NO	NUMBER(5,0)	No
AFRCRES_SEQ_NO	AFRCRES_SEQ_NO	NUMBER(5,0)	No
AFRCRES_SCNT_CODE	AFRCRES_SCNT_CODE	VARCHAR2(3)	Yes	*
AFRCRES_SCRS_CODE	AFRCRES_SCRS_CODE	VARCHAR2(3)	Yes	*
AFRCRES_PLEDGE_NO	AFRCRES_PLEDGE_NO	VARCHAR2(7)	Yes
AFRCRES_DATE	AFRCRES_DATE	DATE	Yes
AFRCRES_ACTIVITY_DATE	AFRCRES_ACTIVITY_DATE	DATE	No
AFRCRES_USER	AFRCRES_USER	VARCHAR2(30)	No
AFRCRES_GIFT_NO	AFRCRES_GIFT_NO	VARCHAR2(7)	Yes
AFRCRES_COMMENT	AFRCRES_COMMENT	VARCHAR2(2000)	Yes
AFRCRES_DCYR_CODE	AFRCRES_DCYR_CODE	NUMBER(4,0)	Yes	*
AFRCRES_ASK_AMOUNT	AFRCRES_ASK_AMOUNT	NUMBER(11,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCRES_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCRES_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AFRCRES_SCRS_CODE	ATVSCRS_CODE	ATVSCRS
AFRCRES_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AFRCRES_DCYR_CODE	ATVDCYR_CODE	ATVDCYR

Index

Index Name	Index Type	Column Name
AFRCRES_KEY_INDEX	Unique	AFRCRES_CAMPAIGN
AFRCRES_KEY_INDEX	Unique	AFRCRES_SOLC_CODE
AFRCRES_KEY_INDEX	Unique	AFRCRES_SOL_ORG
AFRCRES_KEY_INDEX	Unique	AFRCRES_DCYR_CODE
AFRCRES_KEY_INDEX	Unique	AFRCRES_PIDM
AFRCRES_KEY_INDEX	Unique	AFRCRES_CTYP_SEQ_NO
AFRCRES_KEY_INDEX	Unique	AFRCRES_SEQ_NO
AFRCRES_KEY_INDEX2		AFRCRES_SOL_ORG
AFRCRES_KEY_INDEX2		AFRCRES_DCYR_CODE
AFRCRES_KEY_INDEX2		AFRCRES_PIDM
AFRCRES_KEY_INDEX2		AFRCRES_CTYP_SEQ_NO
AFRCRES_KEY_INDEX2		AFRCRES_SEQ_NO

Comments

Source Code Comments

Campaign Result Repeating Table

Columns Comments for AFRCRES_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCRES_SOLC_CODE (2)

Source Code Comments

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

Columns Comments for AFRCRES_SOL_ORG (3)

Source Code Comments

This field specifies the solicitor organization.

Columns Comments for AFRCRES_PIDM (4)

Source Code Comments

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

Columns Comments for AFRCRES_CTYP_SEQ_NO (5)

Source Code Comments

This field specifies the internal sequence for solicitors.

Columns Comments for AFRCRES_SEQ_NO (6)

Source Code Comments

This field specifies the internal sequence number for constituent respondents.

Columns Comments for AFRCRES_SCNT_CODE (7)

Source Code Comments

This field specifies the type of solicitation contact used to contact a specific constituent.

Columns Comments for AFRCRES_SCRS_CODE (8)

Source Code Comments

This field specifies the type of response from the constituent for a specific solicitation.

Columns Comments for AFRCRES_PLEDGE_NO (9)

Source Code Comments

This field specifies the number of the pledge received from the constituent for a specific solicitation.

Columns Comments for AFRCRES_DATE (10)

Source Code Comments

This field specifies the date the constituent was contacted for a solicitation.

Columns Comments for AFRCRES_ACTIVITY_DATE (11)

Source Code Comments

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

Columns Comments for AFRCRES_USER (12)

Source Code Comments

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

Columns Comments for AFRCRES_GIFT_NO (13)

Source Code Comments

Gift Number associated with the result of the contact

Columns Comments for AFRCRES_COMMENT (14)

Source Code Comments

2000 Character free-form comment associated with the result.

Columns Comments for AFRCRES_DCYR_CODE (15)

Source Code Comments

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

Columns Comments for AFRCRES_ASK_AMOUNT (16)

Source Code Comments

The amount that the contact was asked to contribute during this contact.

Table AFRCSLT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCSLT_CAMPAIGN	AFRCSLT_CAMPAIGN	VARCHAR2(5)	No
AFRCSLT_SOLC_CODE	AFRCSLT_SOLC_CODE	VARCHAR2(8)	Yes
AFRCSLT_SOL_ORG	AFRCSLT_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCSLT_PIDM	AFRCSLT_PIDM	NUMBER(8,0)	No	*
AFRCSLT_GOAL	AFRCSLT_GOAL	NUMBER(13,2)	Yes
AFRCSLT_ACTIVITY_DATE	AFRCSLT_ACTIVITY_DATE	DATE	No
AFRCSLT_REPORT_TO_PIDM	AFRCSLT_REPORT_TO_PIDM	NUMBER(8,0)	Yes
AFRCSLT_MAX_CONTACTS	AFRCSLT_MAX_CONTACTS	NUMBER(3,0)	Yes
AFRCSLT_SSTA_CODE	AFRCSLT_SSTA_CODE	VARCHAR2(1)	Yes	*
AFRCSLT_SSTA_DATE	AFRCSLT_SSTA_DATE	DATE	Yes
AFRCSLT_UPD_WEB_IND	AFRCSLT_UPD_WEB_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCSLT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AFRCSLT_SSTA_CODE	ATVSSTA_CODE	ATVSSTA
AFRCSLT_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_CAMPAIGN
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_SOLC_CODE
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_SOL_ORG
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_PIDM
AFRCSLT_KEY_INDEX2		AFRCSLT_PIDM

Comments

Source Code Comments

Campaign Solicitor Repeating Table

Columns Comments for AFRCSLT_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCSLT_SOLC_CODE (2)

Source Code Comments

This field specifies the type of campaign solicitations a specific solicitor organization is using for the campaign.

Columns Comments for AFRCSLT_SOL_ORG (3)

Source Code Comments

This field specifies a particular solicitor organization.

Columns Comments for AFRCSLT_PIDM (4)

Source Code Comments

This field specifies the internal system generated identification number for a specific solicitor.

Columns Comments for AFRCSLT_GOAL (5)

Source Code Comments

This field identifies the dollar amount goal for each solicitor.

Columns Comments for AFRCSLT_ACTIVITY_DATE (6)

Source Code Comments

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

Columns Comments for AFRCSLT_REPORT_TO_PIDM (7)

Source Code Comments

The Internal ID of the Solicitor at the next level up to which this Solicitor must report.

Columns Comments for AFRCSLT_MAX_CONTACTS (8)

Source Code Comments

The maximum number of contacts that a solicitor may have for the combination of Campaign, Solicitor Code and Solicitor Organization.

Columns Comments for AFRCSLT_SSTA_CODE (9)

Source Code Comments

The status of the solicitor for the combination of Campaign, Solicitor Code and Solicitor Organization.

Columns Comments for AFRCSLT_SSTA_DATE (10)

Source Code Comments

The date the Solicitor Status was changed.

Columns Comments for AFRCSLT_UPD_WEB_IND (11)

Source Code Comments

Update Web Indicator, Indicates that the solicitor can enter Contact information through the Web

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 AGBPDEF

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AGBPDEF_USER	AGBPDEF_USER	VARCHAR2(30)	No
AGBPDEF_CAMPAIGN	AGBPDEF_CAMPAIGN	VARCHAR2(5)	Yes
AGBPDEF_DESG	AGBPDEF_DESG	VARCHAR2(10)	Yes
AGBPDEF_ACTIVITY_DATE	AGBPDEF_ACTIVITY_DATE	DATE	No
AGBPDEF_GIFT_CODE	AGBPDEF_GIFT_CODE	VARCHAR2(2)	Yes
AGBPDEF_GCLS_CODE	AGBPDEF_GCLS_CODE	VARCHAR2(4)	Yes
AGBPDEF_GIFT_PLDG_IND	AGBPDEF_GIFT_PLDG_IND	VARCHAR2(1)	Yes
AGBPDEF_MATCH_RECEIVED	AGBPDEF_MATCH_RECEIVED	VARCHAR2(1)	Yes
AGBPDEF_PSTA_CODE	AGBPDEF_PSTA_CODE	VARCHAR2(1)	Yes
AGBPDEF_PLDG_CODE	AGBPDEF_PLDG_CODE	VARCHAR2(2)	Yes
AGBPDEF_PCLS_CODE	AGBPDEF_PCLS_CODE	VARCHAR2(4)	Yes
AGBPDEF_PDUR_CODE	AGBPDEF_PDUR_CODE	VARCHAR2(1)	Yes
AGBPDEF_FREQ_CODE	AGBPDEF_FREQ_CODE	VARCHAR2(2)	Yes
AGBPDEF_PRMD_CODE	AGBPDEF_PRMD_CODE	VARCHAR2(2)	Yes
AGBPDEF_DEFAULT_DATE	AGBPDEF_DEFAULT_DATE	DATE	Yes
AGBPDEF_SOLC_CODE	AGBPDEF_SOLC_CODE	VARCHAR2(8)	Yes
AGBPDEF_SOL_ORG	AGBPDEF_SOL_ORG	VARCHAR2(5)	Yes	*
AGBPDEF_SOL_PIDM	AGBPDEF_SOL_PIDM	NUMBER(8,0)	Yes
AGBPDEF_PCAT_CODE	AGBPDEF_PCAT_CODE	VARCHAR2(5)	Yes	*
AGBPDEF_CTYP_CODE	AGBPDEF_CTYP_CODE	VARCHAR2(5)	Yes	*
AGBPDEF_SCNT_CODE	AGBPDEF_SCNT_CODE	VARCHAR2(3)	Yes	*
AGBPDEF_SCRS_CODE	AGBPDEF_SCRS_CODE	VARCHAR2(3)	Yes	*
AGBPDEF_PGVE_CODE	AGBPDEF_PGVE_CODE	VARCHAR2(5)	Yes	*
AGBPDEF_DNAM_CODE	AGBPDEF_DNAM_CODE	VARCHAR2(10)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBPDEF_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBPDEF_DNAM_CODE	ATVDNAM_CODE	ATVDNAM
AGBPDEF_PCAT_CODE	ATVPCAT_CODE	ATVPCAT
AGBPDEF_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AGBPDEF_SCRS_CODE	ATVSCRS_CODE	ATVSCRS
AGBPDEF_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGBPDEF_CTYP_CODE	ATVCTYP_CODE	ATVCTYP

Index

No Result

Comments

Source Code Comments

Pledge/Gift Default Camp/Desg

Columns Comments for AGBPDEF_USER (1)

Source Code Comments

This system maintained field specifies the user name.

Columns Comments for AGBPDEF_CAMPAIGN (2)

Source Code Comments

This field specifies the campaign to which a designation is defaulted.

Columns Comments for AGBPDEF_DESG (3)

Source Code Comments

This field specifies the designation which is defaulted to an associated campaign.

Columns Comments for AGBPDEF_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for AGBPDEF_GIFT_CODE (5)

Source Code Comments

Default gift type.

Columns Comments for AGBPDEF_GCLS_CODE (6)

Source Code Comments

Default gift class on the gift form.

Columns Comments for AGBPDEF_GIFT_PLDG_IND (7)

Source Code Comments

Default value for gift/pledge indicator. Used to determine defaults for gift form.

Columns Comments for AGBPDEF_MATCH_RECEIVED (8)

Source Code Comments

Default matching gift form received indicator.

Columns Comments for AGBPDEF_PSTA_CODE (9)

Source Code Comments

Default pledge status when creating a new pledge on the gift form.

Columns Comments for AGBPDEF_PLDG_CODE (10)

Source Code Comments

Default pledge type on the gift form.

Columns Comments for AGBPDEF_PCLS_CODE (11)

Source Code Comments

Default pledge class on the gift form when a pledge is created.

Columns Comments for AGBPDEF_PDUR_CODE (12)

Source Code Comments

Default pledge installment duration on the gift form when installments are being created.

Columns Comments for AGBPDEF_FREQ_CODE (13)

Source Code Comments

Default pledge installment frequency code on gift form when pledge installment are created.

Columns Comments for AGBPDEF_PRMD_CODE (14)

Source Code Comments

Default pledge installment reminder code on the gift form when pledge installments are created.

Columns Comments for AGBPDEF_DEFAULT_DATE (15)

Source Code Comments

Default date for pledge/gift on gift form.

Columns Comments for AGBPDEF_SOLC_CODE (16)

Source Code Comments

Default solicitaion type on the gift form for pledges and gifts that are created.

Columns Comments for AGBPDEF_SOL_ORG (17)

Source Code Comments

Default solicitation organization for pledges and gifts created on the gift form.

Columns Comments for AGBPDEF_SOL_PIDM (18)

Source Code Comments

Default solicitor pidm for pledge and gift solicitaion created on the gift form.

Columns Comments for AGBPDEF_PCAT_CODE (19)

Source Code Comments

Default Pledge Category Code.

Columns Comments for AGBPDEF_CTYP_CODE (20)

Source Code Comments

Default Condition Type Code.

Columns Comments for AGBPDEF_SCNT_CODE (21)

Source Code Comments

Default Solicitor Contact Code

Columns Comments for AGBPDEF_SCRS_CODE (22)

Source Code Comments

Default Solicitor Contact Result Code

Columns Comments for AGBPDEF_PGVE_CODE (23)

Source Code Comments

The default Pledge Gift Vehicle Code for the User ID.

Columns Comments for AGBPDEF_DNAM_CODE (24)

Source Code Comments

The Default Name Code associated with this users Pledge defaults.

Table AGBWPLG

Schema Name ALUMNI
Label AGBWPLG
Server name MALDEV8_B60
Creation Date 08/15/2002 09:15:47:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AGBWPLG_PIDM	AGBWPLG_PIDM	NUMBER(8,0)	No
AGBWPLG_AMOUNT	AGBWPLG_AMOUNT	NUMBER(11,2)	No
AGBWPLG_PLDG_DATE	AGBWPLG_PLDG_DATE	DATE	No
AGBWPLG_CAMPAIGN	AGBWPLG_CAMPAIGN	VARCHAR2(5)	No	*
AGBWPLG_DESG	AGBWPLG_DESG	VARCHAR2(10)	No	*
AGBWPLG_ACTIVITY_DATE	AGBWPLG_ACTIVITY_DATE	DATE	No
AGBWPLG_USER	AGBWPLG_USER	VARCHAR2(30)	No
AGBWPLG_ACCEPTED_IND	AGBWPLG_ACCEPTED_IND	VARCHAR2(1)	No
AGBWPLG_PLDG_CODE	AGBWPLG_PLDG_CODE	VARCHAR2(2)	Yes	*
AGBWPLG_PGVE_CODE	AGBWPLG_PGVE_CODE	VARCHAR2(5)	Yes	*
AGBWPLG_SOLC_CODE	AGBWPLG_SOLC_CODE	VARCHAR2(8)	Yes	*
AGBWPLG_SOL_ORG	AGBWPLG_SOL_ORG	VARCHAR2(5)	Yes	*
AGBWPLG_DCYR_CODE	AGBWPLG_DCYR_CODE	NUMBER(4,0)	Yes	*
AGBWPLG_SOLICITOR_PIDM	AGBWPLG_SOLICITOR_PIDM	NUMBER(8,0)	Yes
AGBWPLG_SPS_SPLIT_IND	AGBWPLG_SPS_SPLIT_IND	VARCHAR2(1)	Yes
AGBWPLG_PDUR_CODE	AGBWPLG_PDUR_CODE	VARCHAR2(1)	Yes	*
AGBWPLG_FREQ_CODE	AGBWPLG_FREQ_CODE	VARCHAR2(2)	Yes	*
AGBWPLG_BILL_DATE	AGBWPLG_BILL_DATE	DATE	Yes
AGBWPLG_COMMENT	AGBWPLG_COMMENT	VARCHAR2(300)	Yes
AGBWPLG_CAMPAIGN_2	AGBWPLG_CAMPAIGN_2	VARCHAR2(5)	Yes	*
AGBWPLG_DESIGNATION_2	AGBWPLG_DESIGNATION_2	VARCHAR2(10)	Yes	*
AGBWPLG_CAMPAIGN_3	AGBWPLG_CAMPAIGN_3	VARCHAR2(5)	Yes	*
AGBWPLG_DESIGNATION_3	AGBWPLG_DESIGNATION_3	VARCHAR2(10)	Yes	*
AGBWPLG_AMOUNT_2	AGBWPLG_AMOUNT_2	NUMBER(11,2)	Yes
AGBWPLG_AMOUNT_3	AGBWPLG_AMOUNT_3	NUMBER(11,2)	Yes
AGBWPLG_SCNT_CODE	AGBWPLG_SCNT_CODE	VARCHAR2(3)	Yes	*
AGBWPLG_SCRS_CODE	AGBWPLG_SCRS_CODE	VARCHAR2(3)	Yes	*
AGBWPLG_ASK_AMOUNT	AGBWPLG_ASK_AMOUNT	NUMBER(11,2)	Yes
AGBWPLG_ASK_DATE	AGBWPLG_ASK_DATE	DATE	Yes
AGBWPLG_LETR_CODE	AGBWPLG_LETR_CODE	VARCHAR2(15)	Yes	*
AGBWPLG_PLDG_PRMD_CODE	AGBWPLG_PLDG_PRMD_CODE	VARCHAR2(2)	Yes
AGBWPLG_PINS_PRMD_CODE	AGBWPLG_PINS_PRMD_CODE	VARCHAR2(2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBWPLG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBWPLG_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AGBWPLG_FREQ_CODE	ATVFREQ_CODE	ATVFREQ
AGBWPLG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG
AGBWPLG_PDUR_CODE	ATVPDUR_CODE	ATVPDUR
AGBWPLG_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AGBWPLG_SCRS_CODE	ATVSCRS_CODE	ATVSCRS
AGBWPLG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGBWPLG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AGBWPLG_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

No Result

Comments

Source Code Comments

Web Pledge Header Table. Collects information for pledges from the Web.

Columns Comments for AGBWPLG_PIDM (1)

Source Code Comments

Internal ID of the Web user making the pledge.

Columns Comments for AGBWPLG_AMOUNT (2)

Source Code Comments

Amount of the pledge.

Columns Comments for AGBWPLG_PLDG_DATE (3)

Source Code Comments

Date the pledge was entered via the Web.

Columns Comments for AGBWPLG_CAMPAIGN (4)

Source Code Comments

The first Campaign to which the pledge was made.

Columns Comments for AGBWPLG_DESG (5)

Source Code Comments

The first Designation to which the pledge was made.

Columns Comments for AGBWPLG_ACTIVITY_DATE (6)

Source Code Comments

The date this record was added or last modified.

Columns Comments for AGBWPLG_USER (7)

Source Code Comments

The user who added or last modified this record.

Columns Comments for AGBWPLG_ACCEPTED_IND (8)

Source Code Comments

Accepted Indicator, Y indicates the pledge has been reviewed and accepted.

Columns Comments for AGBWPLG_PLDG_CODE (9)

Source Code Comments

The pledge code to be associated with the pledge.

Columns Comments for AGBWPLG_PGVE_CODE (10)

Source Code Comments

The Pledge Giving Vehicle Code to be associated eith the pledge.

Columns Comments for AGBWPLG_SOLC_CODE (11)

Source Code Comments

The Solicitation Code to be associated with the pledge.

Columns Comments for AGBWPLG_SOL_ORG (12)

Source Code Comments

The SOlicitor Organization to be associated with the pledge.

Columns Comments for AGBWPLG_DCYR_CODE (13)

Source Code Comments

The Gift Society Year to be associated with the pledge.

Columns Comments for AGBWPLG_SOLICITOR_PIDM (14)

Source Code Comments

The Internal ID of the Solicitor to be associated with the pledge.

Columns Comments for AGBWPLG_SPS_SPLIT_IND (15)

Source Code Comments

Spouse Split Indicator, Y indicates that the pledge should be split with the spouse

Columns Comments for AGBWPLG_PDUR_CODE (16)

Source Code Comments

The Pledge Duration code to be associated with the pledge.

Columns Comments for AGBWPLG_FREQ_CODE (17)

Source Code Comments

The Frequency Code to be associated with the pledge.

Columns Comments for AGBWPLG_BILL_DATE (18)

Source Code Comments

The date the first installment will be due.

Columns Comments for AGBWPLG_COMMENT (19)

Source Code Comments

Free-form text containing information abnout the pledge.

Columns Comments for AGBWPLG_CAMPAIGN_2 (20)

Source Code Comments

The second Campaign to which the pledge was made.

Columns Comments for AGBWPLG_DESIGNATION_2 (21)

Source Code Comments

The second Designation to which the pledge was made.

Columns Comments for AGBWPLG_CAMPAIGN_3 (22)

Source Code Comments

The third Campaign to which the pledge was made.

Columns Comments for AGBWPLG_DESIGNATION_3 (23)

Source Code Comments

The third Designation to which the pledge was made.

Columns Comments for AGBWPLG_SCNT_CODE (26)

Source Code Comments

Type of solicitation contact used to contact a specific constituent.

Columns Comments for AGBWPLG_SCRS_CODE (27)

Source Code Comments

Type of response from the constituent for a specific solicitation.

Columns Comments for AGBWPLG_ASK_AMOUNT (28)

Source Code Comments

Amount that the contact was asked to contribute during this contact.

Columns Comments for AGBWPLG_ASK_DATE (29)

Source Code Comments

Date to which the solicitor asked the contact to commit.

Columns Comments for AGBWPLG_LETR_CODE (30)

Source Code Comments

Letter sent to the contact

Columns Comments for AGBWPLG_PLDG_PRMD_CODE (31)

Source Code Comments

Pledge Header pledge reminder code; this field will be stored on the agbpldg record when a pledge is created via the AGAWPLG form.

Columns Comments for AGBWPLG_PINS_PRMD_CODE (32)

Source Code Comments

Pledge Installment pledge reminder code; this field will be stored on the agrpins record when a pledge with installments is created via the AGAWPLG form.

Table AGRGSOL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AGRGSOL_PIDM	AGRGSOL_PIDM	NUMBER(8,0)	No	*
AGRGSOL_GIFT_NO	AGRGSOL_GIFT_NO	VARCHAR2(7)	No	*
AGRGSOL_PLEDGE_NO	AGRGSOL_PLEDGE_NO	VARCHAR2(7)	No	*
AGRGSOL_CAMPAIGN	AGRGSOL_CAMPAIGN	VARCHAR2(5)	No	*
AGRGSOL_CAMPAIGN	AGRGSOL_CAMPAIGN	VARCHAR2(5)	No	*
AGRGSOL_SOLC_CODE	AGRGSOL_SOLC_CODE	VARCHAR2(8)	Yes	*
AGRGSOL_SOL_ORG	AGRGSOL_SOL_ORG	VARCHAR2(5)	Yes	*
AGRGSOL_SOL_PIDM	AGRGSOL_SOL_PIDM	NUMBER(8,0)	Yes
AGRGSOL_AMT	AGRGSOL_AMT	NUMBER(11,2)	No
AGRGSOL_ACTIVITY_DATE	AGRGSOL_ACTIVITY_DATE	DATE	No
AGRGSOL_CREDIT_PIDM	AGRGSOL_CREDIT_PIDM	NUMBER(8,0)	No
AGRGSOL_3PP_PLEDGE_NO	AGRGSOL_3PP_PLEDGE_NO	VARCHAR2(7)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGRGSOL_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AGRGSOL_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRGSOL_PIDM	AGRGCAM_PIDM	AGRGCAM
AGRGSOL_GIFT_NO	AGRGCAM_GIFT_NO	AGRGCAM
AGRGSOL_PLEDGE_NO	AGRGCAM_PLEDGE_NO	AGRGCAM
AGRGSOL_CAMPAIGN	AGRGCAM_CAMPAIGN	AGRGCAM
AGRGSOL_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG

Index

Index Name	Index Type	Column Name
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_PIDM
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_GIFT_NO
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_PLEDGE_NO
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_CAMPAIGN
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_SOLC_CODE
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_SOL_ORG
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_SOL_PIDM
AGRGSOL_KEY_INDEX	Unique	AGRGSOL_CREDIT_PIDM
AGRGSOL_KEY_INDEX2		AGRGSOL_CAMPAIGN
AGRGSOL_KEY_INDEX2		AGRGSOL_SOLC_CODE