Model Self Service Pledge & Gift

Model Label : BANNER Advancement Self-Service Pledge and GIft Processing
Path : BANNER DEV/Advancement/Advancement_ERD/SelfServicePledgeGift_ERD

List of Objects

Object Name	Object Type	Layer Name
ADBDESG	TABLE	Default
AFBCAMP	TABLE	Default
AGBGHLD	TABLE	Default
AGBWPLG	TABLE	Default
AGRGHDE	TABLE	Default
APBWIDN	TABLE	Default
ASBSORG	TABLE	Default
ATVDCYR	TABLE	Default
ATVDONR	TABLE	Default
ATVFISC	TABLE	Default
ATVFREQ	TABLE	Default
ATVGIFT	TABLE	Default
ATVPDUR	TABLE	Default
ATVPGVE	TABLE	Default
ATVPLDG	TABLE	Default
ATVSCNT	TABLE	Default
ATVSCRS	TABLE	Default
ATVSOLC	TABLE	Default
GTVEMAL	TABLE	Default
GTVLETR	TABLE	Default
STVATYP	TABLE	Default
STVCNTY	TABLE	Default
STVNATN	TABLE	Default
STVSTAT	TABLE	Default

Comments

Model View

Table ADBDESG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADBDESG_DESG	ADBDESG_DESG	VARCHAR2(10)	No	*	*
ADBDESG_DESG	ADBDESG_DESG	VARCHAR2(10)	No	*	*
ADBDESG_NAME	ADBDESG_NAME	VARCHAR2(60)	No
ADBDESG_GL_NO_CREDIT	ADBDESG_GL_NO_CREDIT	VARCHAR2(60)	Yes
ADBDESG_GL_NO_DEBIT	ADBDESG_GL_NO_DEBIT	VARCHAR2(60)	Yes
ADBDESG_RESTR_IND	ADBDESG_RESTR_IND	VARCHAR2(1)	No
ADBDESG_COLL_CODE	ADBDESG_COLL_CODE	VARCHAR2(2)	Yes		*
ADBDESG_CMTP_CODE	ADBDESG_CMTP_CODE	VARCHAR2(2)	Yes		*
ADBDESG_CFAE_CODE	ADBDESG_CFAE_CODE	VARCHAR2(5)	No		*
ADBDESG_AMT_PLEDGED	ADBDESG_AMT_PLEDGED	NUMBER(13,2)	Yes
ADBDESG_AMT_PLEDGED_PAID	ADBDESG_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
ADBDESG_AMT_GIFT	ADBDESG_AMT_GIFT	NUMBER(13,2)	Yes
ADBDESG_ACTIVITY_DATE	ADBDESG_ACTIVITY_DATE	DATE	No
ADBDESG_COAS_CODE	ADBDESG_COAS_CODE	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE	ADBDESG_ACCI_CODE	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE	ADBDESG_FUND_CODE	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE	ADBDESG_ORGN_CODE	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE	ADBDESG_ACCT_CODE	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE	ADBDESG_PROG_CODE	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE	ADBDESG_ACTV_CODE	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE	ADBDESG_LOCN_CODE	VARCHAR2(6)	Yes
ADBDESG_DSTP_CODE	ADBDESG_DSTP_CODE	VARCHAR2(5)	No		*
ADBDESG_COAS_CODE_PLDG	ADBDESG_COAS_CODE_PLDG	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_PLDG	ADBDESG_ACCI_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_PLDG	ADBDESG_FUND_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_PLDG	ADBDESG_ORGN_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_PLDG	ADBDESG_ACCT_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_PLDG	ADBDESG_PROG_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_PLDG	ADBDESG_ACTV_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_PLDG	ADBDESG_LOCN_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_PLDG	ADBDESG_GL_NO_CREDIT_PLDG	VARCHAR2(60)	Yes
ADBDESG_USER	ADBDESG_USER	VARCHAR2(30)	No
ADBDESG_START_DATE	ADBDESG_START_DATE	DATE	Yes
ADBDESG_END_DATE	ADBDESG_END_DATE	DATE	Yes
ADBDESG_DSTA_CODE	ADBDESG_DSTA_CODE	VARCHAR2(1)	Yes		*
ADBDESG_DGRP_CODE	ADBDESG_DGRP_CODE	VARCHAR2(5)	Yes		*
ADBDESG_DEPT_CODE	ADBDESG_DEPT_CODE	VARCHAR2(4)	Yes		*
ADBDESG_COAS_CODE_EXPND	ADBDESG_COAS_CODE_EXPND	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_EXPND	ADBDESG_ACCI_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_EXPND	ADBDESG_FUND_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_EXPND	ADBDESG_ORGN_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_EXPND	ADBDESG_ACCT_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_EXPND	ADBDESG_PROG_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_EXPND	ADBDESG_ACTV_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_EXPND	ADBDESG_LOCN_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_EXPND	ADBDESG_GL_NO_CREDIT_EXPND	VARCHAR2(60)	Yes
ADBDESG_COAS_CODE_PYMNT	ADBDESG_COAS_CODE_PYMNT	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_PYMNT	ADBDESG_ACCI_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_PYMNT	ADBDESG_FUND_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_PYMNT	ADBDESG_ORGN_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_PYMNT	ADBDESG_ACCT_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_PYMNT	ADBDESG_PROG_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_PYMNT	ADBDESG_ACTV_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_PYMNT	ADBDESG_LOCN_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_PYMNT	ADBDESG_GL_NO_CREDIT_PYMNT	VARCHAR2(60)	Yes
ADBDESG_WEB_GIFT_IND	ADBDESG_WEB_GIFT_IND	VARCHAR2(1)	Yes
ADBDESG_WEB_PLDG_IND	ADBDESG_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADBDESG_DESG	APRDHIS_DESG	APRDHIS
ADBDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA
ADBDESG_DSTP_CODE	ATVDSTP_CODE	ATVDSTP
ADBDESG_DGRP_CODE	ATVDGRP_CODE	ATVDGRP
ADBDESG_CFAE_CODE	ATVCFAE_CODE	ATVCFAE
ADBDESG_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
ADBDESG_DESG	AGRGDES_DESG	AGRGDES
ADBDESG_COLL_CODE	STVCOLL_CODE	STVCOLL
ADBDESG_DEPT_CODE	STVDEPT_CODE	STVDEPT

Index

Index Name	Index Type	Column Name
PK_ADBDESG	Unique	ADBDESG_DESG

Comments

Source Code Comments

Designation Base Table

Columns Comments for ADBDESG_DESG (1)

Source Code Comments

This field specifies the five character alphanumeric designation code. Upon entry of this code, the Designation List Form is automatically updated.

Columns Comments for ADBDESG_NAME (2)

Source Code Comments

This field specifies the name of the designation. The name automatically defaults to this field.

Columns Comments for ADBDESG_GL_NO_CREDIT (3)

Source Code Comments

This field specifies the general ledger credit account number associated with the designation.

Columns Comments for ADBDESG_GL_NO_DEBIT (4)

Source Code Comments

General ledger debit account number is entered on ATVGIFT-Gift Type Validation Form. Not Used.

Columns Comments for ADBDESG_RESTR_IND (5)

Source Code Comments

This field indicates if the designation is retricted to transfer of pledges and/or gifts across fiscal years.

Columns Comments for ADBDESG_COLL_CODE (6)

Source Code Comments

This field specifies the college code associated with the designation.

Columns Comments for ADBDESG_CMTP_CODE (7)

Source Code Comments

This field specifies the type of campaign to which the designation is associated.

Columns Comments for ADBDESG_CFAE_CODE (8)

Source Code Comments

This field specifies the Council for Financial Aid to Education code associated with the designation. This code specifies the purpose for which gifts and grants have been made for CFAE reporting.

Columns Comments for ADBDESG_AMT_PLEDGED (9)

Source Code Comments

This system maintained field specifies the total amount pledged for a specific designation.

Columns Comments for ADBDESG_AMT_PLEDGED_PAID (10)

Source Code Comments

This system maintained field specifies the total amount of pledge payments for a specific designation.

Columns Comments for ADBDESG_AMT_GIFT (11)

Source Code Comments

This system maintained field specifies the amount of gifts and pledge payments for a specific designation.

Columns Comments for ADBDESG_ACTIVITY_DATE (12)

Source Code Comments

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

Columns Comments for ADBDESG_COAS_CODE (13)

Source Code Comments

Banner Finance Chart of Accounts Code.

Columns Comments for ADBDESG_ACCI_CODE (14)

Source Code Comments

Banner Finance Account Index Code.

Columns Comments for ADBDESG_FUND_CODE (15)

Source Code Comments

Banner Finance Fund Code.

Columns Comments for ADBDESG_ORGN_CODE (16)

Source Code Comments

Banner Finance Organization Code.

Columns Comments for ADBDESG_ACCT_CODE (17)

Source Code Comments

Banner Finance Account Code.

Columns Comments for ADBDESG_PROG_CODE (18)

Source Code Comments

Banner Finance Program Code.

Columns Comments for ADBDESG_ACTV_CODE (19)

Source Code Comments

Banner Finance Activity Code.

Columns Comments for ADBDESG_LOCN_CODE (20)

Source Code Comments

Banner Finance Location Code.

Columns Comments for ADBDESG_DSTP_CODE (21)

Source Code Comments

This field indicates the designation type.

Columns Comments for ADBDESG_COAS_CODE_PLDG (22)

Source Code Comments

BANNER Finance Chart of Accounts Code for the Pledge.

Columns Comments for ADBDESG_ACCI_CODE_PLDG (23)

Source Code Comments

BANNER Finance Account Index Code for the Pledge.

Columns Comments for ADBDESG_FUND_CODE_PLDG (24)

Source Code Comments

BANNER Finance Fund Code for the Pledge.

Columns Comments for ADBDESG_ORGN_CODE_PLDG (25)

Source Code Comments

BANNER Finance Organization Code for the Pledge.

Columns Comments for ADBDESG_ACCT_CODE_PLDG (26)

Source Code Comments

BANNER Finance Account Code for the Pledge.

Columns Comments for ADBDESG_PROG_CODE_PLDG (27)

Source Code Comments

BANNER Finance Program Code for the Pledge.

Columns Comments for ADBDESG_ACTV_CODE_PLDG (28)

Source Code Comments

BANNER Finance Activity Code for the Pledge.

Columns Comments for ADBDESG_LOCN_CODE_PLDG (29)

Source Code Comments

BANNER Finance Location Code for the Pledge.

Columns Comments for ADBDESG_GL_NO_CREDIT_PLDG (30)

Source Code Comments

Non-BANNER Finance General Ledge Credit Number for the Pledge.

Columns Comments for ADBDESG_USER (31)

Source Code Comments

User code of person adding or changing the record.

Columns Comments for ADBDESG_START_DATE (32)

Source Code Comments

Designation Start Date indicates the date which the designation becomes active.

Columns Comments for ADBDESG_END_DATE (33)

Source Code Comments

Designation End Date indicates the date which the designation is no longer active.

Columns Comments for ADBDESG_DSTA_CODE (34)

Source Code Comments

Designation Status Code indicates the status of the designation.

Columns Comments for ADBDESG_DGRP_CODE (35)

Source Code Comments

Designation Group Code is used to indicate designations which have a similar purpose of function.

Columns Comments for ADBDESG_DEPT_CODE (36)

Source Code Comments

Designation Department Code indicates the department associated with the designation.

Columns Comments for ADBDESG_COAS_CODE_EXPND (37)

Source Code Comments

Banner Finance Chart of Accounts Code for the Expenditure.

Columns Comments for ADBDESG_ACCI_CODE_EXPND (38)

Source Code Comments

Banner Finance Account Index Code for the Expenditure.

Columns Comments for ADBDESG_FUND_CODE_EXPND (39)

Source Code Comments

Banner Finance Fund Code for the Expenditure.

Columns Comments for ADBDESG_ORGN_CODE_EXPND (40)

Source Code Comments

Banner Finance Organization Code for the Expenditure.

Columns Comments for ADBDESG_ACCT_CODE_EXPND (41)

Source Code Comments

Banner Finance Account Code for the Expenditure.

Columns Comments for ADBDESG_PROG_CODE_EXPND (42)

Source Code Comments

Banner Finance Program Code for the Expenditure.

Columns Comments for ADBDESG_ACTV_CODE_EXPND (43)

Source Code Comments

Banner Finance Activity Code for the Expenditure.

Columns Comments for ADBDESG_LOCN_CODE_EXPND (44)

Source Code Comments

Banner Finance Location Code for the Expenditure.

Columns Comments for ADBDESG_GL_NO_CREDIT_EXPND (45)

Source Code Comments

This field specifies the General Ledger Credit account number associated with the Designation for the Expenditure.

Columns Comments for ADBDESG_COAS_CODE_PYMNT (46)

Source Code Comments

Banner Finance Chart of Accounts Code for the Payment.

Columns Comments for ADBDESG_ACCI_CODE_PYMNT (47)

Source Code Comments

Banner Finance Account Index Code for the Payment.

Columns Comments for ADBDESG_FUND_CODE_PYMNT (48)

Source Code Comments

Banner Finance Fund Code for the Payment.

Columns Comments for ADBDESG_ORGN_CODE_PYMNT (49)

Source Code Comments

Banner Finance Organization Code for the Payment.

Columns Comments for ADBDESG_ACCT_CODE_PYMNT (50)

Source Code Comments

Banner Finance Account Code for the Payment.

Columns Comments for ADBDESG_PROG_CODE_PYMNT (51)

Source Code Comments

Banner Finance Program Code for the Payment.

Columns Comments for ADBDESG_ACTV_CODE_PYMNT (52)

Source Code Comments

Banner Finance Activity Code for the Payment.

Columns Comments for ADBDESG_LOCN_CODE_PYMNT (53)

Source Code Comments

Banner Finance Location Code for the Payment.

Columns Comments for ADBDESG_GL_NO_CREDIT_PYMNT (54)

Source Code Comments

This field specifies the General Ledger Credit account number associated with the Designation for the Payment.

Columns Comments for ADBDESG_WEB_GIFT_IND (55)

Source Code Comments

Web Gift Indicator, Y indicates the gifts will be accepted via the Web.

Columns Comments for ADBDESG_WEB_PLDG_IND (56)

Source Code Comments

Web Pledge Indicator, Y indicates the pledges will be accepted via the Web.

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 AGBGHLD

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AGBGHLD_ID	AGBGHLD_ID	VARCHAR2(9)	No	*
AGBGHLD_GIFT_NO	AGBGHLD_GIFT_NO	VARCHAR2(7)	No	*
AGBGHLD_AMT_TOT	AGBGHLD_AMT_TOT	NUMBER(11,2)	No
AGBGHLD_GIFT_DATE	AGBGHLD_GIFT_DATE	DATE	No
AGBGHLD_FISC_CODE	AGBGHLD_FISC_CODE	NUMBER(4,0)	No		*
AGBGHLD_GIFT_CODE	AGBGHLD_GIFT_CODE	VARCHAR2(2)	No		*
AGBGHLD_GIFT_DESC	AGBGHLD_GIFT_DESC	VARCHAR2(60)	No
AGBGHLD_ENTRY_DATE	AGBGHLD_ENTRY_DATE	DATE	No
AGBGHLD_USER	AGBGHLD_USER	VARCHAR2(30)	No
AGBGHLD_ACTIVITY_DATE	AGBGHLD_ACTIVITY_DATE	DATE	No
AGBGHLD_ACCEPTED_IND	AGBGHLD_ACCEPTED_IND	VARCHAR2(1)	No
AGBGHLD_CASHIER	AGBGHLD_CASHIER	VARCHAR2(30)	No
AGBGHLD_PIDM	AGBGHLD_PIDM	NUMBER(8,0)	Yes
AGBGHLD_CARD_NO	AGBGHLD_CARD_NO	VARCHAR2(20)	Yes
AGBGHLD_CARD_EXP_DATE	AGBGHLD_CARD_EXP_DATE	DATE	Yes
AGBGHLD_MATCH_RECEIVED	AGBGHLD_MATCH_RECEIVED	VARCHAR2(1)	Yes
AGBGHLD_PGVE_CODE	AGBGHLD_PGVE_CODE	VARCHAR2(5)	Yes		*
AGBGHLD_GCLS_CODE	AGBGHLD_GCLS_CODE	VARCHAR2(4)	Yes		*
AGBGHLD_GCLS_CODE_2	AGBGHLD_GCLS_CODE_2	VARCHAR2(4)	Yes		*
AGBGHLD_GCLS_CODE_3	AGBGHLD_GCLS_CODE_3	VARCHAR2(4)	Yes		*
AGBGHLD_COMMENT	AGBGHLD_COMMENT	VARCHAR2(300)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBGHLD_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBGHLD_FISC_CODE	ATVFISC_CODE	ATVFISC
AGBGHLD_GIFT_CODE	ATVGIFT_CODE	ATVGIFT

Index

Index Name	Index Type	Column Name
PK_AGBGHLD	Unique	AGBGHLD_ID
PK_AGBGHLD	Unique	AGBGHLD_GIFT_NO

Comments

Source Code Comments

Web Gift Detail Hold Table.

Columns Comments for AGBGHLD_ID (1)

Source Code Comments

Web ID created by a user not found in Banner.

Columns Comments for AGBGHLD_GIFT_NO (2)

Source Code Comments

Gift number of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_AMT_TOT (3)

Source Code Comments

Amount of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_GIFT_DATE (4)

Source Code Comments

Date of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_FISC_CODE (5)

Source Code Comments

Fiscal Year of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_GIFT_CODE (6)

Source Code Comments

Gift Code of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_GIFT_DESC (7)

Source Code Comments

Description of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_ENTRY_DATE (8)

Source Code Comments

Entry date of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_USER (9)

Source Code Comments

Oracle User who created the gift for a user with no Banner PIDM.

Columns Comments for AGBGHLD_ACTIVITY_DATE (10)

Source Code Comments

Date the gift was created or changed.

Columns Comments for AGBGHLD_ACCEPTED_IND (11)

Source Code Comments

Accepted Indicator, Y = Accepted, N = not Accepted.

Columns Comments for AGBGHLD_PIDM (13)

Source Code Comments

Intenal ID of user who created the gift, once user id given an ID in Banner.

Columns Comments for AGBGHLD_CARD_NO (14)

Source Code Comments

Credit Card Number of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_CARD_EXP_DATE (15)

Source Code Comments

Credit Card Expiration Date of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_MATCH_RECEIVED (16)

Source Code Comments

Matching Gift Form Received indicator for the gift.

Columns Comments for AGBGHLD_PGVE_CODE (17)

Source Code Comments

Giving Vehicle Code of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_GCLS_CODE (18)

Source Code Comments

First Gift Class Code of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_GCLS_CODE_2 (19)

Source Code Comments

Second Gift Class Code of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_GCLS_CODE_3 (20)

Source Code Comments

Third Gift Class Code of gift created for a user with no Banner PIDM.

Columns Comments for AGBGHLD_COMMENT (21)

Source Code Comments

Comment on gift created for a user with no Banner PIDM.

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 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
AGRGHDE_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGRGHDE_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_AGRGHDE	Unique	AGRGHDE_ID
PK_AGRGHDE	Unique	AGRGHDE_GIFT_NO
PK_AGRGHDE	Unique	AGRGHDE_PLEDGE_NO
PK_AGRGHDE	Unique	AGRGHDE_CAMPAIGN
PK_AGRGHDE	Unique	AGRGHDE_DESG

Comments

Source Code Comments

Web Gift Detail Hold Table.

Columns Comments for AGRGHDE_ID (1)

Source Code Comments

Web ID created by a user not found in Banner.

Columns Comments for AGRGHDE_GIFT_NO (2)

Source Code Comments

Gift number of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_PLEDGE_NO (3)

Source Code Comments

Pledge Number associated with gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_CAMPAIGN (4)

Source Code Comments

Campaign Code of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_DESG (5)

Source Code Comments

Designation Code of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_AMT (6)

Source Code Comments

Designation amount of gift created for a user with no Banner PIDM.

Columns Comments for AGRGHDE_ACTIVITY_DATE (7)

Source Code Comments

Date the gift was created or changed.

Columns Comments for AGRGHDE_USER (8)

Source Code Comments

User who created or changed the gift information.

Columns Comments for AGRGHDE_PIDM (9)

Source Code Comments

Intenal ID of user who created the gift, once user id given an ID in Banner.

Table APBWIDN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
APBWIDN_ID	APBWIDN_ID	VARCHAR2(9)	No	*
APBWIDN_PIN	APBWIDN_PIN	VARCHAR2(6)	No
APBWIDN_ACTIVITY_DATE	APBWIDN_ACTIVITY_DATE	DATE	No
APBWIDN_USER	APBWIDN_USER	VARCHAR2(30)	No
APBWIDN_ACCEPTED_IND	APBWIDN_ACCEPTED_IND	VARCHAR2(1)	No
APBWIDN_QUESTION	APBWIDN_QUESTION	VARCHAR2(90)	Yes
APBWIDN_ANSWER	APBWIDN_ANSWER	VARCHAR2(30)	Yes
APBWIDN_PIDM	APBWIDN_PIDM	NUMBER(8,0)	Yes
APBWIDN_LAST_NAME	APBWIDN_LAST_NAME	VARCHAR2(60)	Yes
APBWIDN_FIRST_NAME	APBWIDN_FIRST_NAME	VARCHAR2(15)	Yes
APBWIDN_MI	APBWIDN_MI	VARCHAR2(15)	Yes
APBWIDN_MAIDEN_NAME	APBWIDN_MAIDEN_NAME	VARCHAR2(60)	Yes
APBWIDN_NAME_PREFIX	APBWIDN_NAME_PREFIX	VARCHAR2(20)	Yes
APBWIDN_NAME_SUFFIX	APBWIDN_NAME_SUFFIX	VARCHAR2(20)	Yes
APBWIDN_BIRTH_DATE	APBWIDN_BIRTH_DATE	DATE	Yes
APBWIDN_SEX	APBWIDN_SEX	VARCHAR2(1)	Yes
APBWIDN_ATYP_CODE	APBWIDN_ATYP_CODE	VARCHAR2(2)