Tables and Views for ALUMNI as of 21-JUN-2004 08:23am
Date: 21-JUN-2004 Page: 1
TABLE: AABDINS
CREATOR: ALUMNI
Membership Dues Installment Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AABDINS_PIDM NUMBER 8 NO Internal system generated identification number of the
constituent.
AABDINS_MEMBERSHIP VARCHAR2 5 NO Membership code for the association.
AABDINS_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
membership.
AABDINS_FREQ_CODE VARCHAR2 2 NO Frequency for installmemt reminders for the dues
payments.
AABDINS_BILL_DATE DATE 7 NO First billing date for the dues.
AABDINS_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AABDINS_PDUR_CODE VARCHAR2 1 YES Specifies the duration of the dues.
AABDINS_LETR_CODE VARCHAR2 15 YES Specifies the letter to be generated for the renewal.
AABDINS_RENEWAL_PIDM NUMBER 8 YES Internal system identification number of the renewal
party.
AABDINS_ATYP_CODE VARCHAR2 2 YES Address type code for the renewal party.
Date: 21-JUN-2004 Page: 2
TABLE: AABDUES
CREATOR: ALUMNI
Dues Entry Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AABDUES_PAYOR_PIDM NUMBER 8 NO System generated number used to identify
person/organization that is the third party that will
pay the dues.
AABDUES_TRANS_NO VARCHAR2 7 NO System generated unique number that identifies the
transaction number for ID.
AABDUES_MEMBERSHIP VARCHAR2 5 NO Membership code for payor id.
AABDUES_AMOUNT_TOT NUMBER 11 2 NO Amount of the dues for the Payor ID specified.
AABDUES_GIFT_CODE VARCHAR2 2 NO Payment type code for dues.
AABDUES_DUES_DATE DATE 7 NO The date the payment was made for dues.
AABDUES_FISC_CODE NUMBER 4 NO The fiscal year the membership dues is valid for.
AABDUES_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AABDUES_ENTRY_DATE DATE 7 NO The date this dues was entered into the system.
AABDUES_USER VARCHAR2 30 NO The user ID that entered this record.
AABDUES_FINAL_IND VARCHAR2 1 YES Finalized indicator indicates that the dues has been
finalized.
AABDUES_ADJ_IND VARCHAR2 1 YES The adjustment indicator indicates if this transaction
has been adjusted.
AABDUES_GIFT_DESC VARCHAR2 30 YES The description of the payment code, will default but
is updateable.
AABDUES_ACKN_IND VARCHAR2 1 YES The acknowledgement field indicates if dues has been
acknowledged or not.
AABDUES_ACKN_DATE DATE 7 YES The date the dues has been acknowledged.
AABDUES_RECPT_IND VARCHAR2 1 YES Receipt indicator to acknowledge a receipt has been
issued.
AABDUES_RECPT_DATE DATE 7 YES Receipt date that the receipt was issued.
AABDUES_CARD_NO VARCHAR2 20 YES The credit card number of the person paying the dues.
AABDUES_CARD_EXP_DATE DATE 7 YES The expiration date of the credit card of the person
paying the dues.
AABDUES_SESSION_NUMBER NUMBER 6 YES This field is updated with the session number of the
cashiering session when that is run.
AABDUES_FEED_IND VARCHAR2 1 YES The feed indicator if set indicates a feed to finance.
AABDUES_FEED_DATE DATE 7 YES The date the feed was fed to finance.
AABDUES_FEED_DOC_CODE VARCHAR2 8 YES The feed documentation code for the feed to finance.
Date: 21-JUN-2004 Page: 3
TABLE: AABMINT
CREATOR: ALUMNI
Membership Interest Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AABMINT_INTEREST VARCHAR2 5 NO Membership interest code.
AABMINT_NAME VARCHAR2 60 NO Interest description of the name for the interest.
AABMINT_AMIN_CODE VARCHAR2 2 NO Interest type code associated with the interest.
AABMINT_RESTR_IND VARCHAR2 1 NO Indicates whether the interest is restricted to
transfer of memberships over fiscal years.
AABMINT_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AABMINT_DUES_SUB_IND VARCHAR2 1 YES Dues or subscription indicator for interest code.
AABMINT_GL_NO_CREDIT VARCHAR2 60 YES General ledger account number associated with
interest.
AABMINT_AMGP_CODE VARCHAR2 5 YES Group code associated with the interest.
AABMINT_COLL_CODE VARCHAR2 2 YES College code associated with the interest.
AABMINT_COAS_CODE VARCHAR2 1 YES Banner Finance Chart of Accounts.
AABMINT_ACCI_CODE VARCHAR2 6 YES Banner Finance Account Index Code.
AABMINT_FUND_CODE VARCHAR2 6 YES Banner Finance Fund Code.
AABMINT_ORGN_CODE VARCHAR2 6 YES Banner Finance Organization Code.
AABMINT_ACCT_CODE VARCHAR2 6 YES Banner Finance Account Code.
AABMINT_PROG_CODE VARCHAR2 6 YES Banner Finance Program Code.
AABMINT_ACTV_CODE VARCHAR2 6 YES Banner Finance Activity Code.
AABMINT_LOCN_CODE VARCHAR2 6 YES Banner Finance Location Code.
Date: 21-JUN-2004 Page: 4
TABLE: AABMSHP
CREATOR: ALUMNI
Membership Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AABMSHP_MEMBERSHIP VARCHAR2 5 NO Membership code for association.
AABMSHP_LETR_CODE_CARD VARCHAR2 15 YES Default letter code for membership card when
membership is created.
AABMSHP_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AABMSHP_DEFAULT_INTEREST VARCHAR2 5 YES Default interest code for membership.
AABMSHP_AMTP_CODE_DFLT VARCHAR2 3 YES Membership type that is the default value for the
membership.
AABMSHP_NAME VARCHAR2 60 YES Membership name is the description of the membership
code.
AABMSHP_AMST_CODE VARCHAR2 1 YES Status indicator that is for the membership.
AABMSHP_AMST_DATE DATE 7 YES Status date of the indicator.
AABMSHP_GRACE_PERIOD NUMBER 2 YES The number of months a grace period is allowed for the
membership.
AABMSHP_DURATION NUMBER 3 YES Default duration of membership.
AABMSHP_ENDING_DATE_MO VARCHAR2 2 YES The numeric value of the month that is used instead of
duration.
AABMSHP_ENDING_DATE_DAY VARCHAR2 2 YES The numeric value of the day that is used instead of
duration.
AABMSHP_LETR_CODE_RENEW VARCHAR2 15 YES Letter code defaulting to membership for renewal
letter code.
Date: 21-JUN-2004 Page: 5
TABLE: AARACKN
CREATOR: ALUMNI
Membership Ackowledgement Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARACKN_PIDM NUMBER 8 NO System generated unique number that identifies the
person/organization.
AARACKN_TRANS_NO VARCHAR2 7 NO System generated transaction number that was created
for the person when dues wer paid.
AARACKN_AMOUNT NUMBER 11 2 NO The amount of the dues that were paid.
AARACKN_ACKN_DATE DATE 7 NO The date the process was run for which this
transaction was acknowledged.
AARACKN_ACTIVITY_DATE DATE 7 NO System generated date that indicates when the
transaction was last updated or inserted.
AARACKN_MEMB_NO VARCHAR2 7 YES System generated number that dues were paid for this
membership number.
AARACKN_LETR_CODE VARCHAR2 15 YES The letter that a person is to receive in
acknowledgement for the dues that have been paid.
AARACKN_LETR_CODE_RECPT VARCHAR2 15 YES Letter code that is to be used as a receipt.
AARACKN_RECPT_IND VARCHAR2 1 YES Receipt indicator acknowledges that a receipt is to be
sent/given.
Date: 21-JUN-2004 Page: 6
TABLE: AARACKR
CREATOR: ALUMNI
Membership Ackowledgement Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARACKR_RULE_NO NUMBER 2 NO System generated unique number that identifies the
rule.
AARACKR_RULE_PRTY NUMBER 2 NO Number that specifies the priority order for the
membership rule.
AARACKR_LETR_CODE VARCHAR2 15 NO The letter code of the letter a member is to receive
if dues qualify for this rule.
AARACKR_DOLLAR_FROM NUMBER 13 2 YES Dollar from amount is the first part of the range for
membership dues to qualify for rule.
AARACKR_DOLLAR_TO NUMBER 13 2 YES Dollar to amount is the last part of the range for
membership dues to qualify for the rule.
AARACKR_ACTIVITY_DATE DATE 7 NO System generated date that indicates when the
transaction was last updated or inserted.
AARACKR_LETR_IND VARCHAR2 1 YES Letter indicator acknowledges that a letter is to be
sent.
AARACKR_LETR_CODE_RECPT VARCHAR2 15 YES Letter code that is to be used as a receipt.
AARACKR_RECPT_IND VARCHAR2 1 YES Receipt indicator acknowledges that a receipt is to be
sent/given.
AARACKR_RULE_STATUS VARCHAR2 1 YES Status of the membership rule.
AARACKR_RULE_DATE DATE 7 YES The date the rule status became inactive.
AARACKR_LETR_CODE_MEMB VARCHAR2 15 YES The letter code the member is to receive for the
acknowledgement.
Date: 21-JUN-2004 Page: 7
TABLE: AARAJBD
CREATOR: ALUMNI
Base Dues Adjustment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAJBD_PAYOR_PIDM NUMBER 8 NO System generated number used to identify
person/organization that will pay the dues.
AARAJBD_TRANS_NO VARCHAR2 7 NO System generated unique number that identifies the
transation number for ID.
AARAJBD_MEMBERSHIP VARCHAR2 5 NO Membership code for payor id.
AARAJBD_SEQNO NUMBER 3 NO System generated number the identifies the sequence
number of adjustment entered.
AARAJBD_AMOUNT_TOT NUMBER 11 2 NO Amount of the dues for the Payor ID specified.
AARAJBD_GIFT_CODE VARCHAR2 2 NO Payment type code for dues.
AARAJBD_DUES_DATE DATE 7 NO The date of the dues payment.
AARAJBD_FISC_CODE NUMBER 4 NO The original fiscal year of the membership dues.
AARAJBD_USER VARCHAR2 30 NO The original user ID that entered the dues
transaction.
AARAJBD_ENTRY_DATE DATE 7 NO The original entry date of the dues record.
AARAJBD_USER_ADJ VARCHAR2 30 NO The user ID that has made this adjustment.
AARAJBD_ENTRY_DATE_ADJ DATE 7 NO The adjusted entry date for the dues record.
AARAJBD_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARAJBD_GIFT_DESC VARCHAR2 30 YES The original description of the payment code, will
default but is updateable.
AARAJBD_CARD_NO VARCHAR2 20 YES The original credit card number of the person paying
the dues.
AARAJBD_CARD_EXP_DATE DATE 7 YES The original expiration date of the credit card of the
person paying the dues.
AARAJBD_ACKN_IND VARCHAR2 1 YES The original Acknowledgement Indicator for the dues
record.
AARAJBD_FINAL_IND VARCHAR2 1 YES The original session status of the cashier session
associated with the transaction number.
AARAJBD_FEED_IND VARCHAR2 1 YES The original Dues feed indicator updated when a dues
record being adjusted was fed to Finance.
AARAJBD_FEED_DATE DATE 7 YES The original Dues feed date is the date the dues being
adjusted were fed to the Finance system.
AARAJBD_FEED_DOC_CODE VARCHAR2 8 YES The original Dues feed document code for dues being
fed to finance.
AARAJBD_AMOUNT_TOT_ADJ NUMBER 11 2 YES The adjusted Amount of the dues for the Payor ID
specified.
AARAJBD_GIFT_CODE_ADJ VARCHAR2 2 YES The adjusted Payment type code for dues.
AARAJBD_DUES_DATE_ADJ DATE 7 YES The adjusted date the payment was made for dues.
AARAJBD_FISC_CODE_ADJ NUMBER 4 YES The adjusted fiscal year for which the membership dues
are valid.
AARAJBD_GIFT_DESC_ADJ VARCHAR2 30 YES The adjusted description of the payment code, will
default but is updateable.
AARAJBD_CARD_NO_ADJ VARCHAR2 20 YES The adjusted credit card number of the person paying
the dues.
AARAJBD_CARD_EXP_DATE_ADJ DATE 7 YES The adjusted expiration date of the credit card of the
person paying the dues.
Date: 21-JUN-2004 Page: 8
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAJBD_ACKN_IND_ADJ VARCHAR2 1 YES This is the new dues acknowledgement indicator
associated with the adjusted dues.
AARAJBD_FINAL_IND_ADJ VARCHAR2 1 YES The cashier session status for the dues adjustment.
AARAJBD_SESSION_NUMBER NUMBER 6 YES The cashier session number of the dues adjustment.
AARAJBD_SEND_TO_CASH_IND VARCHAR2 1 YES Indicates that this dues adjustment affects
cashiering.
AARAJBD_ENTRY_DATE_CASH DATE 7 YES The entry date and time of this adjustment for
cashiering purposes.
AARAJBD_USER_CASH VARCHAR2 30 YES This is the cashier who is associated with this
adjustment.
AARAJBD_NEED_TO_FEED_IND VARCHAR2 1 YES This indicates that the dues have been fed to finance
and if the adjustments affect finance, they must also
be fed.
AARAJBD_FEED_IND_ADJ VARCHAR2 1 YES This indicates that the adjustment records have been
fed to finance.
AARAJBD_FEED_DOC_CODE_ADJ VARCHAR2 8 YES The feed document code that includes this adjustment.
AARAJBD_FEED_DATE_ADJ DATE 7 YES The Adjusted feed date.
AARAJBD_COMMENT_ADJ VARCHAR2 180 YES Comment on adjusted dues.
Date: 21-JUN-2004 Page: 9
TABLE: AARAJIN
CREATOR: ALUMNI
Individual Membership Interest Adjustment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAJIN_PAYOR_PIDM NUMBER 8 NO Internal system generated identification number for
the payor of the membership.
AARAJIN_PIDM NUMBER 8 NO Internal system generated identification number for
the member.
AARAJIN_TRANS_NO VARCHAR2 7 NO Transaction number for the membership payment.
AARAJIN_SEQNO NUMBER 3 NO The system generated number identifying the interest
adjustment.
AARAJIN_AJBD_SEQNO NUMBER 3 NO System generated number that is associated with the
dues adjustment.
AARAJIN_AJRD_SEQNO NUMBER 3 NO System generated number that is associated with the
repeating dues adjustment info.
AARAJIN_MEMBERSHIP VARCHAR2 5 NO Original Membership code for the interest.
AARAJIN_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
membership.
AARAJIN_INTEREST VARCHAR2 5 NO Original Interest code.
AARAJIN_AMOUNT NUMBER 11 2 NO Original Amount of the membership payment.
AARAJIN_USER VARCHAR2 30 NO Identifies the user that entered the original dues.
AARAJIN_ENTRY_DATE DATE 7 NO The original entry date of the dues.
AARAJIN_DUES_DATE DATE 7 NO The original due date of the dues.
AARAJIN_FISC_CODE NUMBER 4 NO The original fiscal year of the dues being adjusted.
AARAJIN_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARAJIN_GIFT_CODE VARCHAR2 2 YES The gift code of the dues being adjusted.
AARAJIN_FINAL_IND VARCHAR2 1 YES This field specifies the original session status of
the cashier session associated with the transaction
number.
AARAJIN_FEED_IND VARCHAR2 1 YES Original dues feed indicator updated when a dues
record is being adjusted was fed to Finance.
AARAJIN_FEED_DATE DATE 7 YES Original dues feed date of the due being adjusted was
fed to Finance.
AARAJIN_FEED_DOC_CODE VARCHAR2 8 YES Original dues feed document code for a due that was
fed to Finance.
AARAJIN_NEED_TO_FEED_IND VARCHAR2 1 YES This indicates that the dues has been fed to finance
and if the adjustments affect finance they must also
be fed.
AARAJIN_SESSION_NUMBER NUMBER 6 YES This field specifies the cashier session number for
the dues adjustment.
AARAJIN_GIFT_CODE_ADJ VARCHAR2 2 YES The new gift code of dues that were adjusted.
AARAJIN_FINAL_IND_ADJ VARCHAR2 1 YES The adjusted cashier session status for the dues.
AARAJIN_ENTRY_DATE_ADJ DATE 7 YES The adjusted entry date of the dues.
AARAJIN_USER_ADJ VARCHAR2 30 YES This is the user that entered the adjusted dues entry.
AARAJIN_ENTRY_DATE_CASH DATE 7 YES The entry date and time of the adjustment for
cashiering purposes.
AARAJIN_USER_CASH VARCHAR2 30 YES This is the cashier who is associated with the
adjustment cashier session.
Date: 21-JUN-2004 Page: 10
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAJIN_INTEREST_ADJ VARCHAR2 5 YES The adjusted interest code.
AARAJIN_AMOUNT_ADJ NUMBER 11 2 YES The dues amount which was adjusted as a result of the
change.
AARAJIN_DUES_DATE_ADJ DATE 7 YES The adjusted due date of the dues entered.
AARAJIN_FISC_CODE_ADJ NUMBER 4 YES The adjusted fiscal year of the dues, which was
generated as a result of a change to the due date.
AARAJIN_FEED_IND_ADJ VARCHAR2 1 YES This indicates that the adjustment records have been
fed to finance.
AARAJIN_FEED_DATE_ADJ DATE 7 YES The adjusted dues feed date that was fed to Finance.
AARAJIN_FEED_DOC_CODE_ADJ VARCHAR2 8 YES This field specifies the feed document code that
includes this adjustment.
Date: 21-JUN-2004 Page: 11
TABLE: AARAJRD
CREATOR: ALUMNI
Dues Adjustment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAJRD_PAYOR_PIDM NUMBER 8 NO System generated number used to identify
person/organization that will pay the dues.
AARAJRD_PIDM NUMBER 8 NO System generated number used to identify member
person/organization.
AARAJRD_TRANS_NO VARCHAR2 7 NO System generated unique number that identifies the
transaction number for ID.
AARAJRD_SEQNO NUMBER 3 NO System generated unique number that indicates the
sequence number of this adjustment.
AARAJRD_AJBD_SEQNO NUMBER 3 NO This specifes the sequence number of the base dues
adjustment records.
AARAJRD_MEMBERSHIP VARCHAR2 5 NO The original Membership code for association.
AARAJRD_MEMB_NO VARCHAR2 7 NO System generated unique number that identifies the
membership number for ID.
AARAJRD_AMOUNT NUMBER 11 2 NO The original Amount of the dues for the ID specified.
AARAJRD_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARAJRD_AMPM_CODE VARCHAR2 5 YES The original Promotion code for the membership code.
AARAJRD_COMMENT VARCHAR2 180 YES The original Dues comment line for the ID specified.
AARAJRD_AMOUNT_ADJ NUMBER 11 2 YES The adjusted Amount of the dues for the ID specified.
AARAJRD_AMPM_CODE_ADJ VARCHAR2 5 YES The adjusted Promotion code adjusted for the
membership code.
AARAJRD_COMMENT_ADJ VARCHAR2 180 YES The adjusted Dues comment line adjusted for ID
specified.
Date: 21-JUN-2004 Page: 12
TABLE: AARAKCT
CREATOR: ALUMNI
Membership Category Type Include/Exclude Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAKCT_RULE_NO NUMBER 2 NO System generated unique number that identifies the
rule.
AARAKCT_LETR_CODE VARCHAR2 15 NO The letter code of the letter a member is to receive
if dues qualify for this rule.
AARAKCT_AMCT_CODE VARCHAR2 5 NO Category type code for the include/exclude rule.
AARAKCT_INCL_EXCL_IND VARCHAR2 1 NO Include/Exclude indicator for rule.
AARAKCT_ACTIVITY_DATE DATE 7 NO System generated date that indicates when the
transaction was last updated or inserted.
Date: 21-JUN-2004 Page: 13
TABLE: AARAKDN
CREATOR: ALUMNI
Membership Donor Categories Include/Exclude Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAKDN_RULE_NO NUMBER 2 NO System generated unique number that identifies the
rule.
AARAKDN_LETR_CODE VARCHAR2 15 NO The letter code of the letter a member is to receive
if dues qualify for this rule.
AARAKDN_DONR_CODE VARCHAR2 4 NO Donor code for the include/exclude rule for letter
code.
AARAKDN_INCL_EXCL_IND VARCHAR2 1 NO Include/Exclude indicator for rule.
AARAKDN_ACTIVITY_DATE DATE 7 NO System generated date that indicates when the
transaction was last updated or inserted.
Date: 21-JUN-2004 Page: 14
TABLE: AARAKEX
CREATOR: ALUMNI
Membership Category Type Include/Exclude Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAKEX_RULE_NO NUMBER 2 NO System generated unique number that identifies the
rule.
AARAKEX_LETR_CODE VARCHAR2 15 NO The letter code of the letter a member is to receive
if dues qualify for this rule.
AARAKEX_EXCL_CODE VARCHAR2 3 NO Exclusion code for the include/exclude rule.
AARAKEX_INCL_EXCL_IND VARCHAR2 1 NO Include/Exclude indicator for rule.
AARAKEX_ACTIVITY_DATE DATE 7 NO System generated date that indicates when the
transaction was last updated or inserted.
Date: 21-JUN-2004 Page: 15
TABLE: AARAKIN
CREATOR: ALUMNI
Interest Include/Exclude Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAKIN_RULE_NO NUMBER 2 NO System generated unique number that identifies the
rule.
AARAKIN_LETR_CODE VARCHAR2 15 NO The letter code of the letter a member is to receive
if dues qualify for this rule.
AARAKIN_INTEREST VARCHAR2 5 NO Interest code for the include/exclude rule.
AARAKIN_INCL_EXCL_IND VARCHAR2 1 NO Include/Exclude indicator for rule.
AARAKIN_ACTIVITY_DATE DATE 7 NO System generated date that indicates when the
transaction was last updated or inserted.
Date: 21-JUN-2004 Page: 16
TABLE: AARAKMB
CREATOR: ALUMNI
Membership Include/Exclude Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARAKMB_RULE_NO NUMBER 2 NO System generated unique number that identifies the
rule.
AARAKMB_LETR_CODE VARCHAR2 15 NO The letter code of the letter a member is to receive
if dues qualify for this rule.
AARAKMB_MEMBERSHIP VARCHAR2 5 NO Membership code for the include/exclude rule.
AARAKMB_INCL_EXCL_IND VARCHAR2 1 NO Include/Exclude indicator for rule.
AARAKMB_ACTIVITY_DATE DATE 7 NO System generated date that indicates when the
transaction was last updated or inserted.
Date: 21-JUN-2004 Page: 17
TABLE: AARCMEM
CREATOR: ALUMNI
Co-Membership Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARCMEM_PIDM NUMBER 8 NO Internal system generated identification number for
the member.
AARCMEM_MEMBERSHIP VARCHAR2 5 NO Membership code for the member.
AARCMEM_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
membership.
AARCMEM_LINK_PIDM NUMBER 8 NO Internal system generated identification number for
the co-member.
AARCMEM_LINK_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
co-member membership.
AARCMEM_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARCMEM_LINK_IND VARCHAR2 1 YES Indicator to link memberships.
AARCMEM_REN_REM_IND VARCHAR2 1 YES Indicator representing which id is used for
renewal/reminder.
Date: 21-JUN-2004 Page: 18
TABLE: AARDINS
CREATOR: ALUMNI
Dues Installment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARDINS_PIDM NUMBER 8 NO System generated number used to identify
person/organization.
AARDINS_MEMBERSHIP VARCHAR2 5 NO Membership code for association.
AARDINS_MEMB_NO VARCHAR2 7 NO System generated unique number that identifies the
membership number for ID.
AARDINS_INSTALLMENT_NO NUMBER 3 NO System generated unique number that identifies the
installment number for dues.
AARDINS_INSTALLMENT_DATE DATE 7 NO The date the installment is due.
AARDINS_AMOUNT NUMBER 11 2 NO Amount of the dues for the ID specified.
AARDINS_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARDINS_REMINDER_DATE DATE 7 YES The date the dues reminder is to be sent.
AARDINS_REMINDER_COUNT NUMBER 2 YES The number of the reminder for the dues.
AARDINS_LETR_CODE VARCHAR2 15 YES The letter to be generated for the dues reminder.
Date: 21-JUN-2004 Page: 19
TABLE: AARDUES
CREATOR: ALUMNI
Dues Entry Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARDUES_PIDM NUMBER 8 NO System generated number used to identify member
person/organization.
AARDUES_PAYOR_PIDM NUMBER 8 NO System generated number used to identify
person/organization that is the third party that will
pay the dues.
AARDUES_TRANS_NO VARCHAR2 7 NO System generated unique number that identifies the
transaction number for ID.
AARDUES_MEMBERSHIP VARCHAR2 5 NO Membership code for association.
AARDUES_MEMB_NO VARCHAR2 7 NO System generated unique number that identifies the
membership number for ID.
AARDUES_AMCT_CODE VARCHAR2 5 NO Category code for the dues record created for the ID.
AARDUES_AMOUNT NUMBER 11 2 NO Amount of the dues for the ID specified.
AARDUES_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARDUES_AMPM_CODE VARCHAR2 5 YES Promotion code for the membership code.
AARDUES_COMMENT VARCHAR2 180 YES Dues comment line for ID specified.
Date: 21-JUN-2004 Page: 20
TABLE: AARINCM
CREATOR: ALUMNI
Membership Header Interests Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARINCM_INTEREST VARCHAR2 5 NO Membership Interest codes for association.
AARINCM_SEQNO NUMBER 9 2 NO Comment sequence number.
AARINCM_COMMENT VARCHAR2 60 NO Comment text.
AARINCM_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
Date: 21-JUN-2004 Page: 21
TABLE: AARMBCM
CREATOR: ALUMNI
Membership Header Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMBCM_MEMBERSHIP VARCHAR2 5 NO Membership code for association.
AARMBCM_SEQNO NUMBER 9 2 NO Membership comment sequence number system generated.
AARMBCM_COMMENT VARCHAR2 60 NO Membership comment line.
AARMBCM_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
Date: 21-JUN-2004 Page: 22
TABLE: AARMBDP
CREATOR: ALUMNI
Membership Default Premium/Benefits Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMBDP_BEGIN_DATE DATE 7 NO The begin date for the default premium/benefits.
AARMBDP_DCPR_CODE VARCHAR2 4 NO Membership premium/benefits code.
AARMBDP_ACTIVITY_DATE DATE 7 NO This is the system generated date of the transactions
last insert or update.
AARMBDP_MEMBERSHIP VARCHAR2 5 YES Membership for default premium/benefits.
AARMBDP_INTEREST VARCHAR2 5 YES Interest for default premium/benefits.
AARMBDP_AMCT_CODE VARCHAR2 5 YES Membership category code for default premium/benefits.
AARMBDP_AMST_CODE VARCHAR2 1 YES Membership status code for default premium/benefits.
AARMBDP_END_DATE DATE 7 YES The end date for the default premium/benefits.
Date: 21-JUN-2004 Page: 23
TABLE: AARMBIN
CREATOR: ALUMNI
Membership Header Interest Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMBIN_MEMBERSHIP VARCHAR2 5 NO Membership code for association.
AARMBIN_INTEREST VARCHAR2 5 NO Membership interest code.
AARMBIN_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
Date: 21-JUN-2004 Page: 24
TABLE: AARMBRL
CREATOR: ALUMNI
Membership Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMBRL_MEMBERSHIP VARCHAR2 5 NO Membership program code for membership rules.
AARMBRL_RULE_NO NUMBER 4 NO Rule number for membership program code, this field is
system generated.
AARMBRL_PRIORITY_NO NUMBER 5 2 NO Priority number of the rule for membership code.
AARMBRL_AMCT_CODE VARCHAR2 5 NO Category Code for the membership code.
AARMBRL_AMST_CODE_1 VARCHAR2 1 NO Status indicator for the dues if amount is greater
than or equal to qualifying amount.
AARMBRL_AMST_CODE_2 VARCHAR2 1 NO Status indicator for the dues if amount is less than
the qualifying amount.
AARMBRL_ACTIVITY_DATE DATE 7 NO System generated field that sets the activity date on
an insert/update.
AARMBRL_AMT_QUALIFY NUMBER 11 2 NO Amount to qualify for this rule for membership code.
AARMBRL_NO_DAYS NUMBER 3 NO The number of days that establish a time period where,
if money is paid within
would go towards next years
membership.
AARMBRL_DURATION_MONTHS NUMBER 3 YES The number of duration months for this rule for the
membership code.
AARMBRL_QUALIFY_DATE_MO VARCHAR2 2 NO The Number associated with qualifying month for this
rule for the membership code.
AARMBRL_QUALIFY_DATE_DAY VARCHAR2 2 NO The Number associated with qualifying day for the
qualifing month for this rule for membership code.
AARMBRL_QUALIFY_MONTHS NUMBER 3 NO Length of months this rule qualifies for the
membership code specified.
Date: 21-JUN-2004 Page: 25
TABLE: AARMCMT
CREATOR: ALUMNI
Individual Membership Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMCMT_PIDM NUMBER 8 NO Internal system generated identification number for
the person.
AARMCMT_MEMBERSHIP VARCHAR2 5 NO Membership codes for person.
AARMCMT_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
membership.
AARMCMT_SEQNO NUMBER 9 2 NO Comment sequence number.
AARMCMT_COMMENT VARCHAR2 60 NO Comment text.
AARMCMT_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
Date: 21-JUN-2004 Page: 26
TABLE: AARMEMB
CREATOR: ALUMNI
Membership Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMEMB_PIDM NUMBER 8 NO Internal system identification number for the person.
AARMEMB_MEMBERSHIP VARCHAR2 5 NO Membership code for association.
AARMEMB_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
membership.
AARMEMB_LETR_CODE VARCHAR2 15 YES Letter that gets sent out with the membership card.
AARMEMB_AMCT_CODE VARCHAR2 5 NO Membership category code.
AARMEMB_AMTP_CODE VARCHAR2 3 NO Membership type code.
AARMEMB_ENTRY_DATE DATE 7 NO Date of entry of membership.
AARMEMB_AMST_CODE VARCHAR2 1 NO Status code for individual membership.
AARMEMB_AMST_DATE DATE 7 NO Date of membership status.
AARMEMB_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARMEMB_REMINDER_PIDM NUMBER 8 YES Internal system identification number of the reminder
party.
AARMEMB_ATYP_CODE_REM VARCHAR2 2 YES Address type code for the reminder party.
AARMEMB_RENEWAL_PIDM NUMBER 8 YES Internal system identification number of the renewal
party.
AARMEMB_RENEWAL_DATE DATE 7 YES Date of renewal for future memberships.
AARMEMB_ATYP_CODE_REN VARCHAR2 2 YES Address type code for renewal party.
AARMEMB_DCAM_CODE VARCHAR2 2 YES Assignment method for membership.
AARMEMB_DURATION NUMBER 3 YES Length of duration for membership.
AARMEMB_RULE_NO NUMBER 4 YES Rule number pertaining to membership.
AARMEMB_CARD_IND VARCHAR2 1 YES Indicator showing whether membership card was sent.
AARMEMB_CARD_DATE DATE 7 YES Date card was sent.
AARMEMB_GRACE_PERIOD NUMBER 2 YES Grace period allowed for the membership.
AARMEMB_AMT_QUALIFY NUMBER 11 2 YES Amount qualify which is taken from the membership rule
form, that this person has to meet for the membership.
AARMEMB_EXP_DATE DATE 7 YES Expiration date of the membership.
AARMEMB_MEMB_NAME VARCHAR2 60 YES Default membership name for membership card and other
references to the member.
AARMEMB_LETR_CODE_RENEW VARCHAR2 15 YES Letter code that will be received by the person
getting the renewal.
AARMEMB_STATUS_OVERRIDE_IND VARCHAR2 1 YES Status override indicator. If N, status will not be
automatically overriden by incoming dues prior to the
renewal and expiration dates.
Date: 21-JUN-2004 Page: 27
TABLE: AARMINT
CREATOR: ALUMNI
Individual Membership Interest Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMINT_PIDM NUMBER 8 NO Internal system generated identification number for
the person.
AARMINT_MEMBERSHIP VARCHAR2 5 NO Membership code for the interest.
AARMINT_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
membership.
AARMINT_INTEREST VARCHAR2 5 NO Interest code.
AARMINT_TRANS_NO VARCHAR2 7 NO Transaction number for the membership payment.
AARMINT_AMOUNT NUMBER 11 2 NO Amount of the membership payment.
AARMINT_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
Date: 21-JUN-2004 Page: 28
TABLE: AARMPRE
CREATOR: ALUMNI
Individual Premium Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARMPRE_PIDM NUMBER 8 NO Internal system identification number for person.
AARMPRE_MEMBERSHIP VARCHAR2 5 NO Code for the membership.
AARMPRE_MEMB_NO VARCHAR2 7 NO System generated number that uniquely identifies a
membership.
AARMPRE_DCPR_CODE VARCHAR2 4 NO Code for the membership premium.
AARMPRE_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
AARMPRE_PREM_IND VARCHAR2 1 YES Indicator to show whether premium has been sent.
AARMPRE_PREM_DATE DATE 7 YES Date the premium was sent.
Date: 21-JUN-2004 Page: 29
TABLE: AARRLET
CREATOR: ALUMNI
Membership Reminder/Renewal Letter Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AARRLET_SESSION_NO VARCHAR2 30 NO Internal number generated for the session.
AARRLET_LETR_CODE VARCHAR2 15 NO This field specifies the membership letter code.
AARRLET_PAYOR_PIDM NUMBER 8 NO This field specifies the internal system generated
number of the payor.
AARRLET_MEMBERSHIP VARCHAR2 5 NO Membership program.
AARRLET_MEMB_PIDM NUMBER 8 NO Internal Id no for the person/organization associated
with the membership.
AARRLET_ID VARCHAR2 9 NO Id no used to access a person/organization on-line.
AARRLET_SORT_FIELD VARCHAR2 25 NO Name used in the sort process.
AARRLET_NAME VARCHAR2 80 NO Name to be printed on the reminder/renewal letter.
AARRLET_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AARRLET_MEMBERSHIP_NO VARCHAR2 7 YES This field specifies the membership number.
AARRLET_INSTALL_NO NUMBER 3 YES Installment no. of the payment due.
AARRLET_QUALIFY_AMOUNT NUMBER 11 5 YES Amount needed to qualify for the membership.
AARRLET_AMOUNT NUMBER 11 5 YES Amount due for the installment.
AARRLET_CURR_PAST_IND VARCHAR2 1 YES This field indicates if the membership number is a
current or past due dues.
AARRLET_INSTALL_DATE DATE 7 YES Due date of the installment.
AARRLET_EXPIRE_DATE DATE 7 YES Expiration date of the membership.
Date: 21-JUN-2004 Page: 30
TABLE: ADBCTRL
CREATOR: ALUMNI
Designation Supervisor Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADBCTRL_USER_ID VARCHAR2 30 NO Designation Supervisor ID.
ADBCTRL_USER VARCHAR2 30 NO User that inserted or last modified the Designation
Supervisor ID.
ADBCTRL_ACTIVITY_DATE DATE 7 NO Date the Designation SUpervisor was inserted or last
modified.
ADBCTRL_DSTA_OVERRIDE VARCHAR2 1 YES Designation Status Override Indicator.
Date: 21-JUN-2004 Page: 31
TABLE: ADBDESG
CREATOR: ALUMNI
Designation Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADBDESG_DESG VARCHAR2 10 NO This field specifies the five character alphanumeric
designation code. Upon entry of this code, the
Designation List Form is automatically updated.
ADBDESG_NAME VARCHAR2 60 NO This field specifies the name of the designation. The
name automatically defaults to this field.
ADBDESG_GL_NO_CREDIT VARCHAR2 60 YES This field specifies the general ledger credit account
number associated with the designation.
ADBDESG_GL_NO_DEBIT VARCHAR2 60 YES General ledger debit account number is entered on
ATVGIFT-Gift Type Validation Form. Not Used.
ADBDESG_RESTR_IND VARCHAR2 1 NO This field indicates if the designation is retricted
to transfer of pledges and/or gifts across fiscal
years.
ADBDESG_COLL_CODE VARCHAR2 2 YES This field specifies the college code associated with
the designation.
ADBDESG_CMTP_CODE VARCHAR2 2 YES This field specifies the type of campaign to which the
designation is associated.
ADBDESG_CFAE_CODE VARCHAR2 5 NO 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.
ADBDESG_AMT_PLEDGED NUMBER 13 2 YES This system maintained field specifies the total
amount pledged for a specific designation.
ADBDESG_AMT_PLEDGED_PAID NUMBER 13 2 YES This system maintained field specifies the total
amount of pledge payments for a specific designation.
ADBDESG_AMT_GIFT NUMBER 13 2 YES This system maintained field specifies the amount of
gifts and pledge payments for a specific designation.
ADBDESG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
ADBDESG_COAS_CODE VARCHAR2 1 YES Banner Finance Chart of Accounts Code.
ADBDESG_ACCI_CODE VARCHAR2 6 YES Banner Finance Account Index Code.
ADBDESG_FUND_CODE VARCHAR2 6 YES Banner Finance Fund Code.
ADBDESG_ORGN_CODE VARCHAR2 6 YES Banner Finance Organization Code.
ADBDESG_ACCT_CODE VARCHAR2 6 YES Banner Finance Account Code.
ADBDESG_PROG_CODE VARCHAR2 6 YES Banner Finance Program Code.
ADBDESG_ACTV_CODE VARCHAR2 6 YES Banner Finance Activity Code.
ADBDESG_LOCN_CODE VARCHAR2 6 YES Banner Finance Location Code.
ADBDESG_DSTP_CODE VARCHAR2 5 NO This field indicates the designation type.
ADBDESG_COAS_CODE_PLDG VARCHAR2 1 YES BANNER Finance Chart of Accounts Code for the Pledge.
ADBDESG_ACCI_CODE_PLDG VARCHAR2 6 YES BANNER Finance Account Index Code for the Pledge.
ADBDESG_FUND_CODE_PLDG VARCHAR2 6 YES BANNER Finance Fund Code for the Pledge.
ADBDESG_ORGN_CODE_PLDG VARCHAR2 6 YES BANNER Finance Organization Code for the Pledge.
ADBDESG_ACCT_CODE_PLDG VARCHAR2 6 YES BANNER Finance Account Code for the Pledge.
ADBDESG_PROG_CODE_PLDG VARCHAR2 6 YES BANNER Finance Program Code for the Pledge.
ADBDESG_ACTV_CODE_PLDG VARCHAR2 6 YES BANNER Finance Activity Code for the Pledge.
ADBDESG_LOCN_CODE_PLDG VARCHAR2 6 YES BANNER Finance Location Code for the Pledge.
Date: 21-JUN-2004 Page: 32
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADBDESG_GL_NO_CREDIT_PLDG VARCHAR2 60 YES Non-BANNER Finance General Ledge Credit Number for the
Pledge.
ADBDESG_USER VARCHAR2 30 NO User code of person adding or changing the record.
ADBDESG_START_DATE DATE 7 YES Designation Start Date indicates the date which the
designation becomes active.
ADBDESG_END_DATE DATE 7 YES Designation End Date indicates the date which the
designation is no longer active.
ADBDESG_DSTA_CODE VARCHAR2 1 YES Designation Status Code indicates the status of the
designation.
ADBDESG_DGRP_CODE VARCHAR2 5 YES Designation Group Code is used to indicate
designations which have a similar purpose of function.
ADBDESG_DEPT_CODE VARCHAR2 4 YES Designation Department Code indicates the department
associated with the designation.
ADBDESG_COAS_CODE_EXPND VARCHAR2 1 YES Banner Finance Chart of Accounts Code for the
Expenditure.
ADBDESG_ACCI_CODE_EXPND VARCHAR2 6 YES Banner Finance Account Index Code for the Expenditure.
ADBDESG_FUND_CODE_EXPND VARCHAR2 6 YES Banner Finance Fund Code for the Expenditure.
ADBDESG_ORGN_CODE_EXPND VARCHAR2 6 YES Banner Finance Organization Code for the Expenditure.
ADBDESG_ACCT_CODE_EXPND VARCHAR2 6 YES Banner Finance Account Code for the Expenditure.
ADBDESG_PROG_CODE_EXPND VARCHAR2 6 YES Banner Finance Program Code for the Expenditure.
ADBDESG_ACTV_CODE_EXPND VARCHAR2 6 YES Banner Finance Activity Code for the Expenditure.
ADBDESG_LOCN_CODE_EXPND VARCHAR2 6 YES Banner Finance Location Code for the Expenditure.
ADBDESG_GL_NO_CREDIT_EXPND VARCHAR2 60 YES This field specifies the General Ledger Credit account
number associated with the Designation for the
Expenditure.
ADBDESG_COAS_CODE_PYMNT VARCHAR2 1 YES Banner Finance Chart of Accounts Code for the Payment.
ADBDESG_ACCI_CODE_PYMNT VARCHAR2 6 YES Banner Finance Account Index Code for the Payment.
ADBDESG_FUND_CODE_PYMNT VARCHAR2 6 YES Banner Finance Fund Code for the Payment.
ADBDESG_ORGN_CODE_PYMNT VARCHAR2 6 YES Banner Finance Organization Code for the Payment.
ADBDESG_ACCT_CODE_PYMNT VARCHAR2 6 YES Banner Finance Account Code for the Payment.
ADBDESG_PROG_CODE_PYMNT VARCHAR2 6 YES Banner Finance Program Code for the Payment.
ADBDESG_ACTV_CODE_PYMNT VARCHAR2 6 YES Banner Finance Activity Code for the Payment.
ADBDESG_LOCN_CODE_PYMNT VARCHAR2 6 YES Banner Finance Location Code for the Payment.
ADBDESG_GL_NO_CREDIT_PYMNT VARCHAR2 60 YES This field specifies the General Ledger Credit account
number associated with the Designation for the
Payment.
ADBDESG_WEB_GIFT_IND VARCHAR2 1 YES Web Gift Indicator, Y indicates the gifts will be
accepted via the Web.
ADBDESG_WEB_PLDG_IND VARCHAR2 1 YES Web Pledge Indicator, Y indicates the pledges will be
accepted via the Web.
Date: 21-JUN-2004 Page: 33
TABLE: ADRADAJ
CREATOR: ALUMNI
Designation Adjustment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRADAJ_DESG VARCHAR2 10 NO This field specifies the five character alphanumeric
designation code.
ADRADAJ_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number for
designation adjustments.
ADRADAJ_ADJT_CODE VARCHAR2 2 NO This field specifies the type of adjustment that is
associated with a specific designaton.
ADRADAJ_REASON VARCHAR2 60 YES This field specifies the description of the adjustment
type code. This description defaults from the
Designation Adjustment Code Validation Form.
ADRADAJ_DATE DATE 7 NO This field specifies the date associated with the
posting of the adjustment to the designation.
ADRADAJ_AMT NUMBER 11 2 NO This field specifies the amount of the designation
adjustment.
ADRADAJ_FISC_CODE NUMBER 4 NO This field specifies the fiscal year of the
designation adjustment.
ADRADAJ_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 34
TABLE: ADRATTR
CREATOR: ALUMNI
Designation Attributes Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRATTR_DESG VARCHAR2 10 NO Designation Attribute Designation.
ADRATTR_DATR_CODE VARCHAR2 4 NO Designation Attribute Code.
ADRATTR_ACTIVITY_DATE DATE 7 NO Date the Designation Attribute Code was inserted or
last modified.
ADRATTR_USER VARCHAR2 30 NO User that inserted or last modified the Designation
Attribute Code.
Date: 21-JUN-2004 Page: 35
TABLE: ADRCOMT
CREATOR: ALUMNI
Designation Comment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRCOMT_DESG VARCHAR2 5 NO This field specifies the five character alphanumeric
designation code.
ADRCOMT_SEQ_NO NUMBER 23 20 NO This field specifies the internal designation comment
sequence number.
ADRCOMT_COMMENT VARCHAR2 60 NO This field specifies the free-form designation
comments.
ADRCOMT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 36
TABLE: ADRCONF
CREATOR: ALUMNI
Designation Comment Confidentiality Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRCONF_DESG VARCHAR2 10 NO Designation Comment Confidentiality Designation.
ADRCONF_IDEN_CODE VARCHAR2 5 NO User ID of the Creator/Owner of the Comment
Confideniality Record.
ADRCONF_USER_ID VARCHAR2 30 NO User that inserted or last modified the Comment
Confidentiality Record.
ADRCONF_GRP_SEQ_NO NUMBER 15 NO Designation Comment Confidentiality Group Sequence
Number.
ADRCONF_ACTIVITY_DATE DATE 7 NO Date the Comment Confidentiality Record was inserted
or last modified.
ADRCONF_ENTRY_DATE DATE 7 NO Date the Comment Confidentiality Record was inserted.
ADRCONF_CONFID_IND VARCHAR2 1 YES Confidential Indicator, Y indicates that the comments
are confidential.
ADRCONF_USER VARCHAR2 30 NO The User ID of the person who created or last modified
the comment record.
ADRCONF_COMMENT LONG YES Free form text comment.
Date: 21-JUN-2004 Page: 37
TABLE: ADRDIDS
CREATOR: ALUMNI
Designation IDs Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRDIDS_DESG VARCHAR2 10 NO Designation ID Designation.
ADRDIDS_PIDM NUMBER 8 NO Designation ID PIDM.
ADRDIDS_DITP_CODE VARCHAR2 4 NO Designation ID Type code.
ADRDIDS_ACTIVITY_DATE DATE 7 NO Date the Designation ID was inserted or last modified.
ADRDIDS_USER VARCHAR2 30 NO User that inserted or last modified the Designation
ID.
ADRDIDS_START_DATE DATE 7 YES Start Date the Designation ID is effective for the
designation.
ADRDIDS_END_DATE DATE 7 YES End Date the Designation ID is effective for the
designation.
ADRDIDS_DIST_CODE VARCHAR2 1 YES Designation ID Status code.
ADRDIDS_ATYP_CODE VARCHAR2 2 YES Designation ID Address Type code.
ADRDIDS_COMMENT VARCHAR2 2000 YES Comment Text for the Designation ID.
Date: 21-JUN-2004 Page: 38
TABLE: ADRFUND
CREATOR: ALUMNI
Designation Financial Aid Funds Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRFUND_DESG VARCHAR2 10 NO Designation FA Fund Code Designation.
ADRFUND_FA_FUND_CODE VARCHAR2 6 NO Designation Financial Aid Fund Code.
ADRFUND_ACTIVITY_DATE DATE 7 NO Date the Designation FA Fund Code was inserted or last
modified.
ADRFUND_USER VARCHAR2 30 NO User that inserted or last modified the Designation FA
Fund Code.
Date: 21-JUN-2004 Page: 39
TABLE: ADRPCMT
CREATOR: ALUMNI
Designation Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRPCMT_DESG VARCHAR2 10 NO Designation Comment Designation.
ADRPCMT_IDEN_CODE VARCHAR2 5 NO User ID of the Creator/Owner of the Designation
Comment.
ADRPCMT_GRP_SEQ_NO NUMBER 15 NO Designation Comment Group Sequence Number.
ADRPCMT_LNE_SEQ_NO NUMBER 23 20 NO Designation Comment Line Sequence Number.
ADRPCMT_ACTIVITY_DATE DATE 7 NO Date the Designation Comment was inserted or last
modified.
ADRPCMT_USER VARCHAR2 30 NO User that inserted or last modified the Designation
Comment.
ADRPCMT_COMMENT VARCHAR2 60 NO Text of the Designation Comment.
Date: 21-JUN-2004 Page: 40
TABLE: ADRSUBJ
CREATOR: ALUMNI
Designation Comments Subject Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRSUBJ_DESG VARCHAR2 10 NO Designation Comment Subject Designation.
ADRSUBJ_IDEN_CODE VARCHAR2 5 NO User ID of the Creator/Owner of the Designation
Comment Subject Code.
ADRSUBJ_SUBJ_CODE VARCHAR2 6 NO Designation Comment Subject Code.
ADRSUBJ_GRP_SEQ_NO NUMBER 15 NO Designation Comment Subject Group Sequence Number.
ADRSUBJ_ACTIVITY_DATE DATE 7 NO Date the Designation Comment Subject Code was inserted
or last modified.
ADRSUBJ_USER VARCHAR2 30 NO User that inserted or last modified the Designation
Comment Subject Code.
Date: 21-JUN-2004 Page: 41
TABLE: ADRSUMM
CREATOR: ALUMNI
Designation Summary Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRSUMM_DESG VARCHAR2 10 NO This field specifies the five character alphanumeric
designation code.
ADRSUMM_FISC_CODE NUMBER 4 NO This field specifies the fiscal year associated with
the summary information for a specific designation.
ADRSUMM_AMT_PLEDGED NUMBER 13 2 YES This field specifies the amount of pledges associated
with a designation for a specific fiscal year.
ADRSUMM_AMT_PLEDGED_PAID NUMBER 13 2 YES This field specifies the amount of pledge payments
associated with a designation for a specific fiscal
year.
ADRSUMM_AMT_GIFT NUMBER 13 2 YES This field specifies the amount of gifts and pledge
payments associated with a designation for a specific
fiscal year.
ADRSUMM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 42
TABLE: ADRYEAR
CREATOR: ALUMNI
Designation Year Table. This tables defines the years which are valid for a designation.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADRYEAR_DESG VARCHAR2 10 NO Designation Code for which the year is valid.
ADRYEAR_YEAR VARCHAR2 4 NO Year which is valid for the Designation.
ADRYEAR_ACTIVITY_DATE DATE 7 NO Date the record was added or last modified.
ADRYEAR_USER VARCHAR2 30 NO User who added or last modified the record.
Date: 21-JUN-2004 Page: 43
TABLE: AERCPDG
CREATOR: ALUMNI
Function Campaign/Designation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AERCPDG_EVNT_CRN VARCHAR2 5 NO Function Campaign/Designation Event CRN
AERCPDG_FUNC_CODE VARCHAR2 12 NO Function Campaign/Designation Function Code
AERCPDG_CAMPAIGN VARCHAR2 5 YES Function Campaign/Designation Campaign Code
AERCPDG_DESG VARCHAR2 10 YES Function Campaign/Designation Designation Code
AERCPDG_ACTIVITY_DATE DATE 7 NO Function Campaign/Designation Activity Date
Date: 21-JUN-2004 Page: 44
TABLE: AERPROJ
CREATOR: ALUMNI
Function Projects Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AERPROJ_EVNT_CRN VARCHAR2 5 NO Function Projects Event CRN
AERPROJ_FUNC_CODE VARCHAR2 12 NO Function Projects Function Code
AERPROJ_PROJ_CODE VARCHAR2 6 NO Function Projects Project Code
AERPROJ_ACTIVITY_DATE DATE 7 NO Function Projects Activity Date
Date: 21-JUN-2004 Page: 45
TABLE: AFBCAMP
CREATOR: ALUMNI
Campaign Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFBCAMP_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code. When a new campaign code is added, the
Campaign List Form is automatically updated.
AFBCAMP_NAME VARCHAR2 30 NO This field specifies contains the name of the
campaign.
AFBCAMP_CMTP_CODE VARCHAR2 2 NO This field specifies the campaign type for a specific
campaign.
AFBCAMP_EST_DATE DATE 7 YES This field specifies the start date of the campaign.
AFBCAMP_END_DATE DATE 7 YES This field specifies the end date of the campaign.
AFBCAMP_GOAL NUMBER 13 2 YES This field specifies the dollar amount of the campaign
goal.
AFBCAMP_DEFAULT_DESG VARCHAR2 10 YES This field specifies the default designation to be
used when pledges for the campaign are created.
AFBCAMP_ASSOC_IND VARCHAR2 1 YES This field specifies whether the monies received for
this campaign are used in the calculation of a
constituents giving level.
AFBCAMP_PURGED_IND VARCHAR2 1 YES This field no longer used as of release 1.7.
AFBCAMP_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AFBCAMP_WEB_GIFT_IND VARCHAR2 1 YES Web Gift Indicator, Y indicates that gifts for this
Campaign will be accepted from the Web.
AFBCAMP_WEB_PLDG_IND VARCHAR2 1 YES Web Pledge Indicator, Y indicates that pledges for
this Campaign will be accepted from the Web.
Date: 21-JUN-2004 Page: 46
TABLE: AFRCOMT
CREATOR: ALUMNI
Campaign Comment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRCOMT_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AFRCOMT_SEQ_NO NUMBER 23 20 NO This field specifies the internal campaign comment
sequence number.
AFRCOMT_COMMENT VARCHAR2 60 NO This field specifies the free-form campaign comments.
AFRCOMT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 47
TABLE: AFRCORG
CREATOR: ALUMNI
Campaign Organization Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRCORG_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AFRCORG_SOLC_CODE VARCHAR2 8 YES This field specifies the type of solicitation(s) being
performed for a specific campaign.
AFRCORG_SOL_ORG VARCHAR2 5 NO This field specifies the five character solicitor
organization code associated with the fund raising
efforts of a specific campaign.
AFRCORG_INDEX VARCHAR2 5 YES This field specifies the hierarchical level of the
solicitor organization.
AFRCORG_SEQ_NO VARCHAR2 5 NO This field specifies the internal sequence number.
AFRCORG_LEVEL VARCHAR2 2 NO This field specifies the code used to define a
hierarchical level within the solicitor organization.
AFRCORG_GOAL NUMBER 11 2 YES This field specifies the dollar amount goal of the
solicitor organization for a specific campaign.
AFRCORG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 48
TABLE: AFRCRES
CREATOR: ALUMNI
Campaign Result Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRCRES_CAMPAIGN VARCHAR2 5 YES This field specifies the five character alphanumeric
campaign code.
AFRCRES_SOLC_CODE VARCHAR2 8 YES This field specifies the type of solicitation used for
a specific campaign.
AFRCRES_SOL_ORG VARCHAR2 5 YES This field specifies the solicitor organization.
AFRCRES_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of a specific solicitor.
AFRCRES_CTYP_SEQ_NO NUMBER 5 NO This field specifies the internal sequence for
solicitors.
AFRCRES_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number for
constituent respondents.
AFRCRES_SCNT_CODE VARCHAR2 3 YES This field specifies the type of solicitation contact
used to contact a specific constituent.
AFRCRES_SCRS_CODE VARCHAR2 3 YES This field specifies the type of response from the
constituent for a specific solicitation.
AFRCRES_PLEDGE_NO VARCHAR2 7 YES This field specifies the number of the pledge received
from the constituent for a specific solicitation.
AFRCRES_DATE DATE 7 YES This field specifies the date the constituent was
contacted for a solicitation.
AFRCRES_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AFRCRES_USER VARCHAR2 30 NO User ID of the user that created or last updated the
record
AFRCRES_GIFT_NO VARCHAR2 7 YES Gift Number associated with the result of the contact
AFRCRES_COMMENT VARCHAR2 2000 YES 2000 Character free-form comment associated with the
result.
AFRCRES_DCYR_CODE NUMBER 4 YES Year for which the solicitation as made, may be blank.
AFRCRES_ASK_AMOUNT NUMBER 11 2 YES The amount that the contact was asked to contribute
during this contact.
Date: 21-JUN-2004 Page: 49
TABLE: AFRCSLT
CREATOR: ALUMNI
Campaign Solicitor Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRCSLT_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AFRCSLT_SOLC_CODE VARCHAR2 8 YES This field specifies the type of campaign
solicitations a specific solicitor organization is
using for the campaign.
AFRCSLT_SOL_ORG VARCHAR2 5 YES This field specifies a particular solicitor
organization.
AFRCSLT_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number for a specific solicitor.
AFRCSLT_GOAL NUMBER 13 2 YES This field identifies the dollar amount goal for each
solicitor.
AFRCSLT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AFRCSLT_REPORT_TO_PIDM NUMBER 8 YES The Internal ID of the Solicitor at the next level up
to which this Solicitor must report.
AFRCSLT_MAX_CONTACTS NUMBER 3 YES The maximum number of contacts that a solicitor may
have for the combination of Campaign, Solicitor Code
and Solicitor Organization.
AFRCSLT_SSTA_CODE VARCHAR2 1 YES The status of the solicitor for the combination of
Campaign, Solicitor Code and Solicitor Organization.
AFRCSLT_SSTA_DATE DATE 7 YES The date the Solicitor Status was changed.
AFRCSLT_UPD_WEB_IND VARCHAR2 1 YES Update Web Indicator, Indicates that the solicitor can
enter Contact information through the Web
Date: 21-JUN-2004 Page: 50
TABLE: AFRCSOL
CREATOR: ALUMNI
Campaign Solicitation Type Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRCSOL_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AFRCSOL_SOLC_CODE VARCHAR2 8 NO This field specifies the type of solicitation used in
a specific campaign.
AFRCSOL_GOAL NUMBER 13 2 YES This field specifies the campaign goal for each
individual campaign solicitation type.
AFRCSOL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 51
TABLE: AFRCTYP
CREATOR: ALUMNI
Campaign Contact Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRCTYP_CAMPAIGN VARCHAR2 5 YES This field specifies the five character alphanumeric
campaign code.
AFRCTYP_SOLC_CODE VARCHAR2 8 YES This field specifies the type of solicitations used
for the campaign.
AFRCTYP_SOL_ORG VARCHAR2 5 YES This field specifies the type of solicitor
organization code.
AFRCTYP_PIDM NUMBER 8 YES This field specifies the internal system generated
identification number of the solicitor.
AFRCTYP_SEQ_NO NUMBER 5 NO This field identifies the internal sequence number of
the solicitor.
AFRCTYP_CONSTITUENT_PIDM NUMBER 8 YES This field specifies the internal system generated
identification number of the constituents assigned to
the solicitor.
AFRCTYP_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AFRCTYP_USER VARCHAR2 30 NO User ID of the user that created or last updated the
record
AFRCTYP_RATE_CODE VARCHAR2 2 YES Rating code given the contact by the rater.
AFRCTYP_RSCR_CODE VARCHAR2 5 YES Rater type code for the person rating the contact.
AFRCTYP_RATER_PIDM NUMBER 8 YES Internal ID of the person rating the contact.
AFRCTYP_ASK_AMOUNT NUMBER 11 2 YES Amount the solicitor asked the contact to give or
pledge
AFRCTYP_ASK_DATE DATE 7 YES Date that the solicitor asked the contact to commit
to.
AFRCTYP_COMMENT VARCHAR2 2000 YES 2000 Character free-form comment associated with the
contact.
AFRCTYP_ASSIGN_DATE DATE 7 YES Date that the contact was assigned to the solicitor.
AFRCTYP_DCYR_CODE NUMBER 4 YES Year for which the solicitation should be made, may be
blank.
Date: 21-JUN-2004 Page: 52
TABLE: AFRDESG
CREATOR: ALUMNI
Designation In Campaign Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRDESG_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AFRDESG_DESG VARCHAR2 10 NO This field specifies the designations that are
associated with a specific campaign.
AFRDESG_GOAL NUMBER 13 2 YES This field contains the dollar amount goal of the
designation associated with a specific campaign.
AFRDESG_AMT_PLEDGED NUMBER 13 2 YES This field specifies the amount of pledges associated
with the designation.
AFRDESG_AMT_PLEDGED_PAID NUMBER 13 2 YES This field identifies the amount of pledge payments
for the designation.
AFRDESG_AMT_GIFT NUMBER 13 2 YES This field identifies the amount of gifts and pledge
payments for the designation.
AFRDESG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AFRDESG_DSTA_CODE VARCHAR2 1 YES Designation Status Code indicates the status of the
designation.
AFRDESG_WEB_GIFT_IND VARCHAR2 1 YES Web Gift Indicator, Y indicates that gifts for this
Campaign and Designation will be accepted from the
Web.
AFRDESG_WEB_PLDG_IND VARCHAR2 1 YES Web Pledge Indicator, Y indicates that pledges for
this Campaign and Desgination will be accepted from
the Web.
Date: 21-JUN-2004 Page: 53
TABLE: AFREXPN
CREATOR: ALUMNI
Campaign Expense Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFREXPN_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AFREXPN_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number for
campaign expenses.
AFREXPN_EXPN_CODE VARCHAR2 2 NO This field specifies the expense code of the campaign
expense.
AFREXPN_REASON VARCHAR2 30 NO This field specifies the expense code description of
the campaign expense.
AFREXPN_EXPN_DATE DATE 7 YES This field specifies the date of the campaign expense.
AFREXPN_AMT NUMBER 11 2 YES This field specifies the amount of the campaign
expense.
AFREXPN_CHECK_NO VARCHAR2 10 YES This field specifies the check number of the campaign
expense.
AFREXPN_FISC_CODE NUMBER 4 YES This field specifies the fiscal year of the campaign
expense.
AFREXPN_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 54
TABLE: AFRMAIL
CREATOR: ALUMNI
Campaign Mail Code Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AFRMAIL_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AFRMAIL_MAIL_CODE VARCHAR2 3 NO This field specifies the type of mailings to be used
with the associated campaign.
AFRMAIL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AFRMAIL_MAIL_DATE DATE 7 YES This field indicates the date the item was mailed.
Date: 21-JUN-2004 Page: 55
TABLE: AGBCSHR
CREATOR: ALUMNI
Advancement Cashier Session Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBCSHR_USER VARCHAR2 30 NO This system maintained field specifies the user name
of the cashier.
AGBCSHR_SESSION_NUMBER NUMBER 6 NO This system assigned field identifies the number of
the cashier session.
AGBCSHR_START_DATE DATE 7 YES This field specifies the date and time the cashier
session begins.
AGBCSHR_END_DATE DATE 7 YES This field specifies the date and time the cashier
session ends.
AGBCSHR_SESSION_IND VARCHAR2 1 NO This field indicates the status of the cashier review
session: closed, finalized, or ready to delete.
AGBCSHR_DRAWER_TOTAL NUMBER 13 2 YES This field specifies the total amount received by the
cashier against which gifts and pledges are entered.
AGBCSHR_SESSION_TOTAL NUMBER 13 2 YES This field specifies the total amount entered by the
cashier and maintained by the system.
AGBCSHR_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGBCSHR_ADJUST_TOTAL NUMBER 13 2 YES This field contains the total adjustment amount for
the cashier session.
Date: 21-JUN-2004 Page: 56
TABLE: AGBCTRL
CREATOR: ALUMNI
Control Defaults Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBCTRL_USER VARCHAR2 30 NO This field specifies the user id for the cashiering
supervisor.
AGBCTRL_ACTIVITY_DATE DATE 7 NO This field specifies the date of last change.
Date: 21-JUN-2004 Page: 57
TABLE: AGBGHLD
CREATOR: ALUMNI
Web Gift Detail Hold Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBGHLD_ID VARCHAR2 9 NO Web ID created by a user not found in Banner.
AGBGHLD_GIFT_NO VARCHAR2 7 NO Gift number of gift created for a user with no Banner
PIDM.
AGBGHLD_AMT_TOT NUMBER 11 2 NO Amount of gift created for a user with no Banner PIDM.
AGBGHLD_GIFT_DATE DATE 7 NO Date of gift created for a user with no Banner PIDM.
AGBGHLD_FISC_CODE NUMBER 4 NO Fiscal Year of gift created for a user with no Banner
PIDM.
AGBGHLD_GIFT_CODE VARCHAR2 2 NO Gift Code of gift created for a user with no Banner
PIDM.
AGBGHLD_GIFT_DESC VARCHAR2 60 NO Description of gift created for a user with no Banner
PIDM.
AGBGHLD_ENTRY_DATE DATE 7 NO Entry date of gift created for a user with no Banner
PIDM.
AGBGHLD_USER VARCHAR2 30 NO Oracle User who created the gift for a user with no
Banner PIDM.
AGBGHLD_ACTIVITY_DATE DATE 7 NO Date the gift was created or changed.
AGBGHLD_ACCEPTED_IND VARCHAR2 1 NO Accepted Indicator, Y = Accepted, N = not Accepted.
AGBGHLD_CASHIER VARCHAR2 30 NO
AGBGHLD_PIDM NUMBER 8 YES Intenal ID of user who created the gift, once user id
given an ID in Banner.
AGBGHLD_CARD_NO VARCHAR2 20 YES Credit Card Number of gift created for a user with no
Banner PIDM.
AGBGHLD_CARD_EXP_DATE DATE 7 YES Credit Card Expiration Date of gift created for a user
with no Banner PIDM.
AGBGHLD_MATCH_RECEIVED VARCHAR2 1 YES Matching Gift Form Received indicator for the gift.
AGBGHLD_PGVE_CODE VARCHAR2 5 YES Giving Vehicle Code of gift created for a user with no
Banner PIDM.
AGBGHLD_GCLS_CODE VARCHAR2 4 YES First Gift Class Code of gift created for a user with
no Banner PIDM.
AGBGHLD_GCLS_CODE_2 VARCHAR2 4 YES Second Gift Class Code of gift created for a user with
no Banner PIDM.
AGBGHLD_GCLS_CODE_3 VARCHAR2 4 YES Third Gift Class Code of gift created for a user with
no Banner PIDM.
AGBGHLD_COMMENT VARCHAR2 300 YES Comment on gift created for a user with no Banner
PIDM.
Date: 21-JUN-2004 Page: 58
TABLE: AGBGIFT
CREATOR: ALUMNI
Gift/Pledge Payment Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBGIFT_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AGBGIFT_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of the
gift.
AGBGIFT_AMT_TOT NUMBER 11 2 NO This field specifies the total amount of the gift or
pledge payment.
AGBGIFT_FINAL_IND VARCHAR2 1 YES This field specifies whether a gift has been finalized
in the Cashier Review Session.
AGBGIFT_GIFT_DATE DATE 7 NO This field specifies the date a gift is received. The
date defaults to the system date if no date is
entered.
AGBGIFT_FISC_CODE NUMBER 4 NO This field specifies the code for the fiscal year.
AGBGIFT_GACK_CODE VARCHAR2 2 YES Gift Range Code associated with the gift amount.
AGBGIFT_GCLS_CODE VARCHAR2 4 YES This field specifies the category of the gift -
anonymous, memorial, etc.
AGBGIFT_GIFT_CODE VARCHAR2 2 NO This field specifies the type of gift or method of
payment, i.e., check, credit card, bequest, property.
AGBGIFT_CARD_NO VARCHAR2 20 YES This field specifies the credit card number of the
donor.
AGBGIFT_CARD_EXP_DATE DATE 7 YES This field specifies the credit card expiration date.
AGBGIFT_COMMENT VARCHAR2 300 YES This field specifies the comment related to the gift.
AGBGIFT_MATCH_RECEIVED VARCHAR2 1 YES This field specifies whether a matching gift form has
been received for a gift.
AGBGIFT_MATCH_PROCESSED VARCHAR2 1 NO This field specifies whether a matching gift has been
processed for a gift.
AGBGIFT_ENTRY_DATE DATE 7 NO This system maintained field specifies the date the
gift is entered.
AGBGIFT_USER VARCHAR2 30 NO This system maintained field specifies the user name.
AGBGIFT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGBGIFT_GACK_IND VARCHAR2 1 YES Gift acknowledgment indicator updated when gift is
acknowledged.
AGBGIFT_FEED_IND VARCHAR2 1 YES Gift feed indicator is updated when gift has been fed
to Finance.
AGBGIFT_FEED_DATE DATE 7 YES Gift feed date is the date the gift was fed to
Finance.
AGBGIFT_FEED_DOC_CODE VARCHAR2 8 YES Gift feed document code.
AGBGIFT_ADJ_IND VARCHAR2 1 YES This field indicates that adjustments have been made
to this gift via the gift/pledge adjustment form.
AGBGIFT_RECEIPT_IND VARCHAR2 1 YES This field specifies if a receipt is required for this
gift record.
AGBGIFT_RECEIPT_DATE DATE 7 YES Date a receipt was processed through AGPACKN -
Gift/Pledge Acknowledgement Process.
AGBGIFT_GIFT_DESC VARCHAR2 60 NO Description for the gift.
Date: 21-JUN-2004 Page: 59
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBGIFT_MG_FORMSENT_IND VARCHAR2 1 YES (Y) - Yes, The MG Form has been sent to the Employer.
(N) - No, The MG Form has NOT been sent to the
Employer. Null - No, The MG Form has NOT been sent to
the Employer.
AGBGIFT_PGVE_CODE VARCHAR2 5 YES The Pledge Gift Vehicle Code associated with this
gift.
AGBGIFT_GCLS_CODE_2 VARCHAR2 4 YES This field specifies the second category of the gift -
anonymous, memorial, etc.
AGBGIFT_GCLS_CODE_3 VARCHAR2 4 YES This field specifies the third category of the gift -
anonymous, memorial, etc.
Date: 21-JUN-2004 Page: 60
TABLE: AGBIDRL
CREATOR: ALUMNI
Split Pledge/Gift Rule for ID Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBIDRL_PIDM NUMBER 8 NO Internal system generated identification number.
AGBIDRL_XREF_CODE VARCHAR2 3 NO Cross reference code of ID for rule for multiple or
memo information.
AGBIDRL_XREF_PRIORITY NUMBER 5 2 NO Cross reference priority number of ID for multiple or
memo.
AGBIDRL_NO_SPLIT_IND VARCHAR2 1 NO No split indicator if set to yes will not allow splits
for the individual specified.
AGBIDRL_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
AGBIDRL_PERCENT_DFLT NUMBER 5 2 NO Cross reference percentage of pledge/gift for ID that
is multipled or memoed.
AGBIDRL_MULT_MEM_IND VARCHAR2 1 YES Multiple (H) Memo (S) indicator to assign hard or soft
credit to the split.
Date: 21-JUN-2004 Page: 61
TABLE: AGBMGID
CREATOR: ALUMNI
Matching Gift Waiting Id Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBMGID_EMPR_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the employer.
AGBMGID_EMPL_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number for the employee.
AGBMGID_EMPL_GIFT_NO VARCHAR2 7 NO This field specifies the gift number of the gift to be
matched.
AGBMGID_AMT NUMBER 11 2 NO This field specifies the amount of the gift to be
matched.
AGBMGID_AMT_PAID NUMBER 11 2 NO This field specifies the amount paid toward the match.
AGBMGID_STATUS VARCHAR2 1 YES This system maintained field specifies whether a gift
has been matched.
AGBMGID_DELETE_IND VARCHAR2 1 YES This field specifies whether a matching gift is
deleted or restored.
AGBMGID_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGBMGID_MG_FORMSENT_IND VARCHAR2 1 YES (Y) - Yes, The MG Form has been sent to the Employer.
(N) - No, The MG Form has NOT been sent to the
Employer. Null - No, The MG Form has NOT been sent to
the Employer.
AGBMGID_SPOUSE_PIDM NUMBER 8 YES The Internal ID of the spouse of the person making the
gift that will be matched.
AGBMGID_QUALIFY_AMT NUMBER 11 2 YES The amount of the gift that qualifies to be matched.
AGBMGID_PGVE_CODE VARCHAR2 5 YES
Date: 21-JUN-2004 Page: 62
TABLE: AGBPDEF
CREATOR: ALUMNI
Pledge/Gift Default Camp/Desg
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBPDEF_USER VARCHAR2 30 NO This system maintained field specifies the user name.
AGBPDEF_CAMPAIGN VARCHAR2 5 YES This field specifies the campaign to which a
designation is defaulted.
AGBPDEF_DESG VARCHAR2 10 YES This field specifies the designation which is
defaulted to an associated campaign.
AGBPDEF_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGBPDEF_GIFT_CODE VARCHAR2 2 YES Default gift type.
AGBPDEF_GCLS_CODE VARCHAR2 4 YES Default gift class on the gift form.
AGBPDEF_GIFT_PLDG_IND VARCHAR2 1 YES Default value for gift/pledge indicator. Used to
determine defaults for gift form.
AGBPDEF_MATCH_RECEIVED VARCHAR2 1 YES Default matching gift form received indicator.
AGBPDEF_PSTA_CODE VARCHAR2 1 YES Default pledge status when creating a new pledge on
the gift form.
AGBPDEF_PLDG_CODE VARCHAR2 2 YES Default pledge type on the gift form.
AGBPDEF_PCLS_CODE VARCHAR2 4 YES Default pledge class on the gift form when a pledge is
created.
AGBPDEF_PDUR_CODE VARCHAR2 1 YES Default pledge installment duration on the gift form
when installments are being created.
AGBPDEF_FREQ_CODE VARCHAR2 2 YES Default pledge installment frequency code on gift form
when pledge installment are created.
AGBPDEF_PRMD_CODE VARCHAR2 2 YES Default pledge installment reminder code on the gift
form when pledge installments are created.
AGBPDEF_DEFAULT_DATE DATE 7 YES Default date for pledge/gift on gift form.
AGBPDEF_SOLC_CODE VARCHAR2 8 YES Default solicitaion type on the gift form for pledges
and gifts that are created.
AGBPDEF_SOL_ORG VARCHAR2 5 YES Default solicitation organization for pledges and
gifts created on the gift form.
AGBPDEF_SOL_PIDM NUMBER 8 YES Default solicitor pidm for pledge and gift solicitaion
created on the gift form.
AGBPDEF_PCAT_CODE VARCHAR2 5 YES Default Pledge Category Code.
AGBPDEF_CTYP_CODE VARCHAR2 5 YES Default Condition Type Code.
AGBPDEF_SCNT_CODE VARCHAR2 3 YES Default Solicitor Contact Code
AGBPDEF_SCRS_CODE VARCHAR2 3 YES Default Solicitor Contact Result Code
AGBPDEF_PGVE_CODE VARCHAR2 5 YES The default Pledge Gift Vehicle Code for the User ID.
AGBPDEF_DNAM_CODE VARCHAR2 10 YES The Default Name Code associated with this users
Pledge defaults.
Date: 21-JUN-2004 Page: 63
TABLE: AGBPINS
CREATOR: ALUMNI
Pledge Installment Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBPINS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGBPINS_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGBPINS_PDUR_CODE VARCHAR2 1 YES This field specifies the duration of the pledge.
AGBPINS_FREQ_CODE VARCHAR2 2 NO This field specifies the frequency for installment
reminders for the pledge.
AGBPINS_BILL_DATE DATE 7 NO This field specifies the first billing date for the
pledge.
AGBPINS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 64
TABLE: AGBPLDG
CREATOR: ALUMNI
Pledge Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBPLDG_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGBPLDG_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGBPLDG_PLEDGE_DATE DATE 7 NO This field specifies the date of the pledge.
AGBPLDG_AMT_PLEDGED NUMBER 11 2 NO This field specifies the amount of the pledge.
AGBPLDG_FISC_CODE NUMBER 4 NO This field specifies the fiscal year associated with
the pledge.
AGBPLDG_PSTA_CODE VARCHAR2 1 NO This field specifies the status of the pledge.
AGBPLDG_PACK_CODE VARCHAR2 2 YES Pledge Range Code associated with the pledge amount.
AGBPLDG_PRMD_CODE VARCHAR2 2 YES This field specifies the reminder type for the pledge.
AGBPLDG_REM_COUNT NUMBER 2 YES This system maintained field specifies the number of
reminders produced by the system to date.
AGBPLDG_REM_DATE DATE 7 YES This field specifies the date of the last reminder.
AGBPLDG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGBPLDG_ADJ_IND VARCHAR2 1 YES This field indicates a pledge has been adjusted via
the Gift Pledge Adjustment Form.
AGBPLDG_PACK_IND VARCHAR2 1 YES Pledge Acknowledgement indicator updated when a pledge
is acknowledged.
AGBPLDG_RECEIPT_IND VARCHAR2 1 YES Pledge Acknowledgement indicator updated when a
receipt is to be sent.
AGBPLDG_RECEIPT_DATE DATE 7 YES Pledge Acknowledgement receipt date.
AGBPLDG_PLDG_CODE VARCHAR2 2 YES Code for the pledge type.
AGBPLDG_PCLS_CODE VARCHAR2 4 YES Class for the pledge.
AGBPLDG_COMMENT VARCHAR2 300 YES Comments pertaining to the pledge.
AGBPLDG_PCAT_CODE VARCHAR2 5 YES Pledge Category Code.
AGBPLDG_ENTRY_DATE DATE 7 NO Date the Pledge was entered into the system.
AGBPLDG_USER VARCHAR2 30 NO User ID of the person who created/updated the record.
AGBPLDG_MATCH_PROCESSED VARCHAR2 1 YES (Y) = Yes, this pledge has had the MG evaluation
processed. (N) = No, this pledge has NOT had the MG
eval process done. Null = No, this pledge has NOT had
the MG eval process done. (D) = This means that at
one time the AXBMGID row existed, but was (D)
AGBPLDG_MATCH_FORM_IND VARCHAR2 1 YES (P) = per Payment. MG form required for each Payment.
(F) = when Fulfilled. MG form required when pledge
Fulfilled. (I) = Intermittant. Send MG form based on
column AXBMGID_COMMENT. Null = UNKNOWN.
AGBPLDG_MGFORM_READYTOSEND VARCHAR2 1 YES (Y) = Yes, the MG Form is Ready To Send to the
Employer. (N) = No, the MG Form is NOT Ready To Send
to the Employer. Null = No, the MG Form is NOT Ready
To Send to the Employer.
AGBPLDG_FEED_IND VARCHAR2 1 YES Gift feed indicator updated when a pledge is fed to
Finance.
Date: 21-JUN-2004 Page: 65
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBPLDG_FEED_DATE DATE 7 YES This field specifies the date this pledge record has
been fed to finance.
AGBPLDG_FEED_DOC_CODE VARCHAR2 8 YES Pledge feed document code for the pledge being
adjusted, updated when the pledge was fed to Finance.
AGBPLDG_PGVE_CODE VARCHAR2 5 YES The Pledge Gift Vehicle Code associated with this
pledge.
AGBPLDG_PCLS_CODE_2 VARCHAR2 4 YES Class Code two for the Pledge.
AGBPLDG_PCLS_CODE_3 VARCHAR2 4 YES Class Code three for the Pledge.
Date: 21-JUN-2004 Page: 66
TABLE: AGBSPRL
CREATOR: ALUMNI
Split Pledge/GifT Rule Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBSPRL_XREF_CODE VARCHAR2 3 NO Cross reference code of rule for multiple or memo
information.
AGBSPRL_XREF_PRIORITY NUMBER 5 2 NO Cross reference priority number for multiple or memo.
AGBSPRL_PERCENT_DFLT NUMBER 5 2 NO Cross reference percentage of pledge/gift that is
multipled or memoed.
AGBSPRL_MULT_MEM_IND VARCHAR2 1 NO Multiple (H) Memo (S) indicator to assign hard or soft
credit to the split.
AGBSPRL_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
Date: 21-JUN-2004 Page: 67
TABLE: AGBWPLG
CREATOR: ALUMNI
Web Pledge Header Table. Collects information for pledges from the Web.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBWPLG_PIDM NUMBER 8 NO Internal ID of the Web user making the pledge.
AGBWPLG_AMOUNT NUMBER 11 2 NO Amount of the pledge.
AGBWPLG_PLDG_DATE DATE 7 NO Date the pledge was entered via the Web.
AGBWPLG_CAMPAIGN VARCHAR2 5 NO The first Campaign to which the pledge was made.
AGBWPLG_DESG VARCHAR2 10 NO The first Designation to which the pledge was made.
AGBWPLG_ACTIVITY_DATE DATE 7 NO The date this record was added or last modified.
AGBWPLG_USER VARCHAR2 30 NO The user who added or last modified this record.
AGBWPLG_ACCEPTED_IND VARCHAR2 1 NO Accepted Indicator, Y indicates the pledge has been
reviewed and accepted.
AGBWPLG_PLDG_CODE VARCHAR2 2 YES The pledge code to be associated with the pledge.
AGBWPLG_PGVE_CODE VARCHAR2 5 YES The Pledge Giving Vehicle Code to be associated eith
the pledge.
AGBWPLG_SOLC_CODE VARCHAR2 8 YES The Solicitation Code to be associated with the
pledge.
AGBWPLG_SOL_ORG VARCHAR2 5 YES The SOlicitor Organization to be associated with the
pledge.
AGBWPLG_DCYR_CODE NUMBER 4 YES The Gift Society Year to be associated with the
pledge.
AGBWPLG_SOLICITOR_PIDM NUMBER 8 YES The Internal ID of the Solicitor to be associated with
the pledge.
AGBWPLG_SPS_SPLIT_IND VARCHAR2 1 YES Spouse Split Indicator, Y indicates that the pledge
should be split with the spouse
AGBWPLG_PDUR_CODE VARCHAR2 1 YES The Pledge Duration code to be associated with the
pledge.
AGBWPLG_FREQ_CODE VARCHAR2 2 YES The Frequency Code to be associated with the pledge.
AGBWPLG_BILL_DATE DATE 7 YES The date the first installment will be due.
AGBWPLG_COMMENT VARCHAR2 300 YES Free-form text containing information abnout the
pledge.
AGBWPLG_CAMPAIGN_2 VARCHAR2 5 YES The second Campaign to which the pledge was made.
AGBWPLG_DESIGNATION_2 VARCHAR2 10 YES The second Designation to which the pledge was made.
AGBWPLG_CAMPAIGN_3 VARCHAR2 5 YES The third Campaign to which the pledge was made.
AGBWPLG_DESIGNATION_3 VARCHAR2 10 YES The third Designation to which the pledge was made.
AGBWPLG_AMOUNT_2 NUMBER 11 2 YES
AGBWPLG_AMOUNT_3 NUMBER 11 2 YES
AGBWPLG_SCNT_CODE VARCHAR2 3 YES Type of solicitation contact used to contact a
specific constituent.
AGBWPLG_SCRS_CODE VARCHAR2 3 YES Type of response from the constituent for a specific
solicitation.
AGBWPLG_ASK_AMOUNT NUMBER 11 2 YES Amount that the contact was asked to contribute during
this contact.
AGBWPLG_ASK_DATE DATE 7 YES Date to which the solicitor asked the contact to
commit.
AGBWPLG_LETR_CODE VARCHAR2 15 YES Letter sent to the contact
AGBWPLG_PLDG_PRMD_CODE VARCHAR2 2 YES Pledge Header pledge reminder code; this field will be
stored on the agbpldg record when a pledge is created
via the AGAWPLG form.
Date: 21-JUN-2004 Page: 68
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGBWPLG_PINS_PRMD_CODE VARCHAR2 2 YES 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.
Date: 21-JUN-2004 Page: 69
TABLE: AGRACKN
CREATOR: ALUMNI
Gift Acknowledgement Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRACKN_PIDM NUMBER 8 NO This field specifies the internal system generated
number.
AGRACKN_GIFT_NO VARCHAR2 7 YES This field specifies the gift number.
AGRACKN_GIFT_AMT NUMBER 11 2 YES This field specifies the amount of the gift.
AGRACKN_PLEDGE_NO VARCHAR2 7 YES This field specifies the pledge number.
AGRACKN_PLEDGE_AMT NUMBER 11 2 YES This field specifies the amount of the pledge.
AGRACKN_LETR_CODE VARCHAR2 15 YES This field specifies the letter code.
AGRACKN_LETR_CODE_RECPT VARCHAR2 15 YES This field specifies which letter code is to be used
if a receipt is to be sent.
AGRACKN_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRACKN_ACKN_DATE DATE 7 NO This field specifies the date on which the
acknowledgment is to be sent.
Date: 21-JUN-2004 Page: 70
TABLE: AGRACKR
CREATOR: ALUMNI
Gift Acknowledgement Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRACKR_RULE_NO NUMBER 2 NO This field specifies the internal system generated
rule number.
AGRACKR_RULE_PRTY NUMBER 2 NO This field specifies the priority order of rule
number.
AGRACKR_LETR_CODE VARCHAR2 15 NO This field specifies the letter code.
AGRACKR_DOLLAR_FROM NUMBER 13 2 YES This field specifies begin range of dollar amounts for
gift acknowledgement.
AGRACKR_DOLLAR_TO NUMBER 13 2 YES This field specifies the end range of dollar amounts
for gift acknowledgement.
AGRACKR_GIFT_PLDG_IND VARCHAR2 1 YES This field specifies a gift, pledge payment, or both
for gift acknowledgment.
AGRACKR_PLEDGE_IND VARCHAR2 1 YES This field specifies a pledge for gift
acknowledgement.
AGRACKR_MTCH_GIFT_IND VARCHAR2 1 YES This field specifies if employee matching gift
qualified for gift acknowledgement.
AGRACKR_LETR_CODE_EMPL VARCHAR2 15 YES This field specifies which letter an employee gets if
there is a matching gift.
AGRACKR_LETR_IND VARCHAR2 1 YES This field specifies if a letter is associated with
rule.
AGRACKR_RECPT_IND VARCHAR2 1 YES This field specifies if a receipt is associated with
rule.
AGRACKR_LETR_CODE_RECPT VARCHAR2 15 YES This field specifies which receipt is associated with
rule.
AGRACKR_RULE_STATUS VARCHAR2 1 YES This field specifies if a rule is active or inactive.
AGRACKR_RULE_DATE DATE 7 YES This field specifies the date the rule is inactive.
AGRACKR_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 71
TABLE: AGRADJR
CREATOR: ALUMNI
Prior Years Adjustment Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRADJR_FIELD_NAME VARCHAR2 20 NO Gift/Pledge Adjustment field name to be adjusted.
AGRADJR_DESC VARCHAR2 30 NO This field is the decription of the adjustment field.
AGRADJR_ADJ_PLDG_IND VARCHAR2 1 NO Adjust pledge fields indicator.
AGRADJR_ADJ_GIFT_IND VARCHAR2 1 NO Adjust gift fields indicator.
AGRADJR_ACTIVITY_DATE DATE 7 NO Date of last change.
AGRADJR_ADJ_DUES_IND VARCHAR2 1 NO Adjust dues fields indicator.
Date: 21-JUN-2004 Page: 72
TABLE: AGRAGDS
CREATOR: ALUMNI
Gift/Pledge Payment Adjustment Designation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAGDS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AGRAGDS_GIFT_NO VARCHAR2 7 NO This field specifies the number of the gift being
adjusted.
AGRAGDS_AGIF_SEQ_NO NUMBER 3 NO This field specifies the corresponding gift
agdjustment sequence number from the Gift/Pledge
Payment Adjustment Table, AGRAGIF.
AGRAGDS_SEQ_NO NUMBER 3 NO This field specifies the sequence of adjustments to
the gift.
AGRAGDS_PLEDGE_NO VARCHAR2 7 NO This field specifies the number of the pledge
associated with the payment.
AGRAGDS_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign code.
AGRAGDS_DESG VARCHAR2 10 NO This field specifies the designation code.
AGRAGDS_AMT NUMBER 11 2 NO This field specifies the amount of the gift for the
campaign/designation.
AGRAGDS_USER VARCHAR2 30 YES This field specifies the user that entered the
original gift.
AGRAGDS_GIFT_DATE DATE 7 YES This field specifies the date of the gift being
adjusted.
AGRAGDS_FISC_CODE NUMBER 4 YES This field specifies the fiscal year of the gift being
adjusted.
AGRAGDS_GIFT_CODE VARCHAR2 2 YES This field specifies the gift code of the gift being
adjusted.
AGRAGDS_PLEDGE_NO_ADJ VARCHAR2 7 YES This field specifies the new pledge number associated
with the gift.
AGRAGDS_CAMPAIGN_ADJ VARCHAR2 5 YES This field specifies the new campaign associated with
the gift.
AGRAGDS_DESG_ADJ VARCHAR2 10 YES This field specifies the new designation associated
with the gift.
AGRAGDS_AMT_ADJ NUMBER 11 2 YES This field specifies the new amount associated with
the campaign/designation of the gift.
AGRAGDS_USER_ADJ VARCHAR2 30 NO This field specifies the user that entered the
adjusted gift entry.
AGRAGDS_ENTRY_DATE_ADJ DATE 7 NO This field specifies the date and time of the gift
adjustment.
AGRAGDS_GIFT_DATE_ADJ DATE 7 YES This field specifies the new date of the gift entered
as an adjustment.
AGRAGDS_FISC_CODE_ADJ NUMBER 4 YES This field specifies the new fiscal year of the gift
which was generated as a result of a change to the
gift date.
AGRAGDS_GIFT_CODE_ADJ VARCHAR2 2 YES This field specifies the new gift code associated with
the adjusted gift.
AGRAGDS_NEED_TO_FEED_IND VARCHAR2 1 YES This field indicates that the gift being adjusted was
fed to finance and the adjustments must also be fed to
finance.
Date: 21-JUN-2004 Page: 73
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAGDS_FEED_IND_ADJ VARCHAR2 1 YES This field indicates if the gift adjustments have been
fed to finance.
AGRAGDS_FEED_DATE_ADJ DATE 7 YES This field specifies the date the gift adjustments
have been fed to finance.
AGRAGDS_FEED_DOC_CODE_ADJ VARCHAR2 8 YES This field specifies the document number of the feed
program that included this gift adjustment.
AGRAGDS_FINAL_IND_ADJ VARCHAR2 1 YES This field specifies the cashier session status
associated with this gift adjustment.
AGRAGDS_USER_CASH VARCHAR2 30 YES This field specifies the cashier associated with this
gift adjustment.
AGRAGDS_ENTRY_DATE_CASH DATE 7 YES This field specifies the date and time of the
adjustment associated with a cashier session.
AGRAGDS_SESSION_NUMBER NUMBER 6 YES This field specifies the cashier session number for
the adjustment.
AGRAGDS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 74
TABLE: AGRAGIF
CREATOR: ALUMNI
Gift/Pledge Payment Adjustment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAGIF_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number for the gift being adjusted.
AGRAGIF_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of the
gift.
AGRAGIF_SEQ_NO NUMBER 3 NO This field specifies the system assigned sequence
number of the gift adjustment.
AGRAGIF_AMT_TOT NUMBER 11 2 NO This field specifies the total amount of the gift or
pledge payment being adjusted.
AGRAGIF_GIFT_DATE DATE 7 NO This field specifies the gift date of the gift being
adjusted.
AGRAGIF_FISC_CODE NUMBER 4 NO This field specifies the fiscal year of the gift being
adjusted.
AGRAGIF_GIFT_CODE VARCHAR2 2 NO This field specifies the type of gift or method of
payment of the gift being adjusted, i.e., check,
credit card, bequest, property.
AGRAGIF_GACK_CODE VARCHAR2 2 YES This field specifies the code for the acknowledgement
type associated with the gift being adjusted.
AGRAGIF_GACK_IND VARCHAR2 1 YES This field specifies the acknowledgement indicator
associated with the gift being adjusted.
AGRAGIF_GCLS_CODE VARCHAR2 4 YES This field specifies the category of the gift being
adjusted- anonymous, memorial, etc.
AGRAGIF_CARD_NO VARCHAR2 20 YES This field specifies the credit card number used to
pay the gift being adjusted.
AGRAGIF_CARD_EXP_DATE DATE 7 YES This field specifies the credit card expiration date
of the card used to pay the gift that is being
adjusted.
AGRAGIF_COMMENT VARCHAR2 300 YES This field specifies the comment related to the gift
being adjusted.
AGRAGIF_ENTRY_DATE DATE 7 NO This system maintained field specifies the date the
gift being adjusted was entered.
AGRAGIF_USER VARCHAR2 30 NO This system maintained field specifies the user name
that entered the gift being adjusted.
AGRAGIF_FINAL_IND VARCHAR2 1 YES This field specifies the session status of the cashier
session associated with the gift being adjusted.
AGRAGIF_FEED_IND VARCHAR2 1 YES Gift feed indicator updated when a gift being adjusted
was fed to Finance.
AGRAGIF_FEED_DATE DATE 7 YES Gift feed date is the date the gift being adjusted was
fed to the finance system
AGRAGIF_FEED_DOC_CODE VARCHAR2 8 YES Gift feed document code for the gift being adjusted,
updated when the gift was fed to Finance.
AGRAGIF_AMT_TOT_ADJ NUMBER 11 2 YES This field specifies the total amount of the adjusted
gift or pledge payment.
AGRAGIF_GIFT_DATE_ADJ DATE 7 YES This field specifies the adjusted date of the gift.
AGRAGIF_FISC_CODE_ADJ NUMBER 4 YES This field specifies the new fiscal year associated
with the adjusted gift updated as a result of a change
to the gift date.
Date: 21-JUN-2004 Page: 75
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAGIF_GIFT_CODE_ADJ VARCHAR2 2 YES This field specifies the new gift code associated with
the adjusted gift.
AGRAGIF_GACK_CODE_ADJ VARCHAR2 2 YES This field specifies the new gift acknowledgement code
associated with the adjusted gift.
AGRAGIF_GACK_IND_ADJ VARCHAR2 1 YES This field specifies the new gift acknowledgement
indicator associated with the adjusted gift.
AGRAGIF_GCLS_CODE_ADJ VARCHAR2 4 YES This field specifies the new gift class code
associated with the adjusted gift.
AGRAGIF_CARD_NO_ADJ VARCHAR2 20 YES This field specifies the new credit card number
associated with the adjusted gift.
AGRAGIF_CARD_EXP_DATE_ADJ DATE 7 YES This field specifies the new credit card expiration
date associated with the adjusted gift.
AGRAGIF_COMMENT_ADJ VARCHAR2 300 YES This field specifies the new comment associated with
the adjusted gift.
AGRAGIF_ENTRY_DATE_ADJ DATE 7 NO This field specifies the date and time this gift
adjustment was made.
AGRAGIF_USER_ADJ VARCHAR2 30 NO This field specifies the user id that made this gift
adjustment.
AGRAGIF_FINAL_IND_ADJ VARCHAR2 1 YES This field specifies the cashier session status for
this gift adjustment.
AGRAGIF_SESSION_NUMBER NUMBER 6 YES This field specifies the cashier session number of the
gift adjustment.
AGRAGIF_SEND_TO_CASH_IND VARCHAR2 1 YES This field specifies that this gift adjustment affects
cashiering.
AGRAGIF_ENTRY_DATE_CASH DATE 7 YES This field specifies the entry date and time of this
adjustment for cashiering purposes.
AGRAGIF_USER_CASH VARCHAR2 30 YES This field specifies which cashier is associated with
this adjustment.
AGRAGIF_NEED_TO_FEED_IND VARCHAR2 1 YES This field indicates that the gift has been fed to
Finance and if the adjustments affect Finance, they
must also be fed.
AGRAGIF_FEED_IND_ADJ VARCHAR2 1 YES This field incidates that the adjustment records have
been fed to finance.
AGRAGIF_FEED_DATE_ADJ DATE 7 YES This field specifies the date this adjustment record
has been fed to finance.
AGRAGIF_FEED_DOC_CODE_ADJ VARCHAR2 8 YES This field specifies the feed document code that
includes this adjustment.
AGRAGIF_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRAGIF_GIFT_DESC VARCHAR2 60 YES The previous description of the gift type.
AGRAGIF_GIFT_DESC_ADJ VARCHAR2 60 YES The new description of the gift type.
AGRAGIF_PGVE_CODE VARCHAR2 5 YES The original Pledge Gift Vehicle Code associated with
this gift.
AGRAGIF_PGVE_CODE_ADJ VARCHAR2 5 YES The adjusted Pledge Gift Vehicle Code associated with
this gift.
AGRAGIF_GCLS_CODE_2 VARCHAR2 4 YES Second Gift class code on gift before the adjustment.
AGRAGIF_GCLS_CODE_3 VARCHAR2 4 YES Third Gift class code on gift before the adjustment.
AGRAGIF_GCLS_CODE_2_ADJ VARCHAR2 4 YES Second Gift class code on adjusted gift.
AGRAGIF_GCLS_CODE_3_ADJ VARCHAR2 4 YES Third Gift class code on adjusted gift.
Date: 21-JUN-2004 Page: 76
TABLE: AGRAKCP
CREATOR: ALUMNI
Gift Acknowledgement Campaign Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKCP_RULE_NO NUMBER 2 NO This field specifies an internal system genenerated
number for rule number.
AGRAKCP_LETR_CODE VARCHAR2 15 NO This field specifies letter code associated with rule
number.
AGRAKCP_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign associated with rule
and letter code.
AGRAKCP_INCL_EXCL_IND VARCHAR2 1 NO This field specifies whether to include or exclude the
campaign.
AGRAKCP_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 77
TABLE: AGRAKCT
CREATOR: ALUMNI
Gift Acknowledgement Campaign Types Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKCT_RULE_NO NUMBER 2 NO This field specifies the internal generated number for
rule number.
AGRAKCT_LETR_CODE VARCHAR2 15 NO This field specifies the letter code.
AGRAKCT_CMTP_CODE VARCHAR2 2 NO This field specifies the campaign type associated with
rule and letter code.
AGRAKCT_INCL_EXCL_IND VARCHAR2 1 NO This field specifies whether to include or exclude
campaign type for rule and letter code.
AGRAKCT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 78
TABLE: AGRAKDC
CREATOR: ALUMNI
Gift Acknowledgement Donor Club Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKDC_RULE_NO NUMBER 2 NO This field specifies the internal generated rule
number.
AGRAKDC_LETR_CODE VARCHAR2 15 NO This field specifies the letter code for the rule
number.
AGRAKDC_DCNP_CODE VARCHAR2 4 NO This field specifies the donor club associated with
rule and letter code.
AGRAKDC_INCL_EXCL_IND VARCHAR2 1 NO This field specifies to include or exclude donor club
for rule and letter code.
AGRAKDC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 79
TABLE: AGRAKDG
CREATOR: ALUMNI
Gift Acknowledgement Designation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKDG_RULE_NO NUMBER 2 NO This field specifies the internal generated rule
number.
AGRAKDG_LETR_CODE VARCHAR2 15 NO This field specifies the letter code associated with
rule number.
AGRAKDG_DESG VARCHAR2 10 NO This field specifies the designation associated with
the rule and letter code.
AGRAKDG_INCL_EXCL_IND VARCHAR2 1 NO This field specifies to include or exclude designation
for rule and letter code.
AGRAKDG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 80
TABLE: AGRAKDN
CREATOR: ALUMNI
Gift Acknowledgement Donor Categories Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKDN_RULE_NO NUMBER 2 NO This field specifies the internal generated number for
rule number.
AGRAKDN_LETR_CODE VARCHAR2 15 NO This field specifies the letter code associated with
rule number.
AGRAKDN_DONR_CODE VARCHAR2 4 NO This field specifies the donor code associated with
rule and letter code.
AGRAKDN_INCL_EXCL_IND VARCHAR2 1 NO This field specifies to include or exclude donor code
for rule and letter code.
AGRAKDN_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 81
TABLE: AGRAKEX
CREATOR: ALUMNI
Gift Acknowledgement Exclusion Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKEX_RULE_NO NUMBER 2 NO This field specifies the internal generated number for
rule number.
AGRAKEX_LETR_CODE VARCHAR2 15 NO This field specifies the letter code associated with
rule number.
AGRAKEX_EXCL_CODE VARCHAR2 3 NO This field specifies the exclusion code associated
with rule and letter code.
AGRAKEX_INCL_EXCL_IND VARCHAR2 1 NO This field specifies to include or exclude exclusion
code for rule and letter code.
AGRAKEX_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 82
TABLE: AGRAKGC
CREATOR: ALUMNI
Gift Acknowledgement Gift Class Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKGC_RULE_NO NUMBER 2 NO This field specifies the internal generated number for
rule number.
AGRAKGC_LETR_CODE VARCHAR2 15 NO This field specifies the letter code associated with
the rule number.
AGRAKGC_GCLS_CODE VARCHAR2 4 NO This field specifies the gift class associated with
rule and letter code.
AGRAKGC_INCL_EXCL_IND VARCHAR2 1 NO This field specifies to include or exclude gift class
for rule and letter code.
AGRAKGC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 83
TABLE: AGRAKGT
CREATOR: ALUMNI
Gift Acknowledgement Gift Type Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKGT_RULE_NO NUMBER 2 NO This field specifies the internal generated number for
rule number.
AGRAKGT_LETR_CODE VARCHAR2 15 NO This field specifies the letter code associated with
the rule number.
AGRAKGT_GIFT_CODE VARCHAR2 2 NO This field specifies the gift type associated with the
rule and letter code.
AGRAKGT_INCL_EXCL_IND VARCHAR2 1 NO This field specifies to include or exclude gift type
for rule and letter code.
AGRAKGT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 84
TABLE: AGRAKPC
CREATOR: ALUMNI
Gift Acknowledgement Preferred Class Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAKPC_RULE_NO NUMBER 2 NO This field specifies the internal generated number for
rule number.
AGRAKPC_LETR_CODE VARCHAR2 15 NO This field specifies the letter code associated with
the rule number.
AGRAKPC_PREF_CLAS_FROM VARCHAR2 4 NO This field specifies the begin range for preferred
class for rule and letter code.
AGRAKPC_PREF_CLAS_TO VARCHAR2 4 NO This field specifies the end range for preferred class
for rule and letter code.
AGRAKPC_INCL_EXCL_IND VARCHAR2 1 NO This field specifies to include or exclude range of
preferred class year for rule and letter code.
AGRAKPC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 85
TABLE: AGRALET
CREATOR: ALUMNI
Gift Acknowledgement Advancement Letter Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRALET_LETR_CODE VARCHAR2 15 NO This field specifies the letter code.
AGRALET_PIDM NUMBER 8 NO This field specifies the internal system generated
number.
AGRALET_ITEM_NO VARCHAR2 7 NO This field specifies the gift number.
AGRALET_GIFT_PLDG_IND VARCHAR2 1 NO This field indicates if the item number is a gift or
pledge number.
AGRALET_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRALET_USER VARCHAR2 30 YES User: this field indicates the user who created the
record.
Date: 21-JUN-2004 Page: 86
TABLE: AGRAPDS
CREATOR: ALUMNI
Adjustment Pledge Designation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAPDS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGRAPDS_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRAPDS_APLG_SEQ_NO NUMBER 3 NO This field specifies the corresponding pledge
adjustment sequence number from the AGRAPLG table.
AGRAPDS_SEQ_NO NUMBER 3 NO This field specifies the sequence number of the pledge
adjustment.
AGRAPDS_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign code associated with
the pledge.
AGRAPDS_DESG VARCHAR2 10 NO This field specifies the designation code associated
with the campaign.
AGRAPDS_AMT NUMBER 11 2 NO This field specifies the amount of the pledge
designation. This field defaults to the campaign
amount.
AGRAPDS_USER_ADJ VARCHAR2 30 NO This field specifies the user id associated with the
pledge designation adjustment.
AGRAPDS_CAMPAIGN_ADJ VARCHAR2 5 YES This field specifies the new campaign code associated
with the pledge.
AGRAPDS_DESG_ADJ VARCHAR2 10 YES This field specifies the new designation code
associated with the campaign.
AGRAPDS_AMT_ADJ NUMBER 11 2 YES This field specifies the new amount of the pledge
designation.
AGRAPDS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRAPDS_NEED_TO_FEED_IND VARCHAR2 1 YES This field indicates that the gift being adjusted was
fed to finance and the adjustments must also be fed to
finance.
AGRAPDS_FEED_IND_ADJ VARCHAR2 1 YES This field indicates if the gift adjustments have been
fed to finance.
AGRAPDS_FEED_DATE_ADJ DATE 7 YES This field specifies the date the gift adjustments
have been fed to finance.
AGRAPDS_FEED_DOC_CODE_ADJ VARCHAR2 8 YES This field specifies the document number of the feed
program that included this gift adjustment.
AGRAPDS_ENTRY_DATE DATE 7 NO The original date the pledge was entered.
AGRAPDS_ENTRY_DATE_ADJ DATE 7 NO The adjusted date the pledge was entered.
Date: 21-JUN-2004 Page: 87
TABLE: AGRAPLG
CREATOR: ALUMNI
Adjustment Pledge Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAPLG_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGRAPLG_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRAPLG_SEQ_NO NUMBER 3 NO Peldge adjustment sequence number.
AGRAPLG_PLEDGE_DATE DATE 7 NO This field specifies the date of the pledge.
AGRAPLG_AMT_PLEDGED NUMBER 11 2 NO This field specifies the amount of the pledge.
AGRAPLG_FISC_CODE NUMBER 4 NO This field specifies the fiscal year associated with
the pledge.
AGRAPLG_PSTA_CODE VARCHAR2 1 NO This field specifies the status of the pledge.
AGRAPLG_PACK_CODE VARCHAR2 2 YES This field specifies the type of acknowledgement
associated with the pledge.
AGRAPLG_PRMD_CODE VARCHAR2 2 YES This field specifies the reminder type for the pledge.
AGRAPLG_REM_DATE DATE 7 YES This field specifies the date of the last reminder.
AGRAPLG_USER_ADJ VARCHAR2 30 NO This field specifies the user that entered the pledge
adjustment.
AGRAPLG_PLEDGE_DATE_ADJ DATE 7 YES This field specifies the new date of the adjusted
pledge.
AGRAPLG_AMT_PLEDGED_ADJ NUMBER 11 2 YES This field specifies the new amount of the adjusted
pledge.
AGRAPLG_FISC_CODE_ADJ NUMBER 4 YES This field specifies the new fiscal year associated
with the pledge updated when the pledge date was
adjusted.
AGRAPLG_PSTA_CODE_ADJ VARCHAR2 1 YES This field specifies the new status of the pledge as
adjusted on the adjustment form.
AGRAPLG_PACK_CODE_ADJ VARCHAR2 2 YES This field specifies the new type of acknowledgement
associated with the pledge.
AGRAPLG_PRMD_CODE_ADJ VARCHAR2 2 YES This field specifies the new reminder type for the
pledge.
AGRAPLG_REM_DATE_ADJ DATE 7 YES This field specifies the new date of the last
reminder.
AGRAPLG_COMMENT_ADJ VARCHAR2 300 YES This field specifies a comment for the adjusted
pledge.
AGRAPLG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRAPLG_PLDG_CODE VARCHAR2 2 YES Code for the pledge type.
AGRAPLG_PCLS_CODE VARCHAR2 4 YES Class for the pledge.
AGRAPLG_COMMENT VARCHAR2 300 YES Comments pertaining to the pledge.
AGRAPLG_PLDG_CODE_ADJ VARCHAR2 2 YES Code for the adjusted pledge type.
AGRAPLG_PCLS_CODE_ADJ VARCHAR2 4 YES Adjusted class for the pledge.
AGRAPLG_PCAT_CODE VARCHAR2 5 YES Pledge Category Code.
AGRAPLG_PCAT_CODE_ADJ VARCHAR2 5 YES Adjusted Pledge Category Code.
AGRAPLG_ENTRY_DATE DATE 7 NO Entry Date of the Adjustment.
AGRAPLG_NEED_TO_FEED_IND VARCHAR2 1 YES This field indicates that the gift has been fed to
Finance and if the adjustments affect Finance, they
must also be fed.
AGRAPLG_FEED_IND VARCHAR2 1 YES Gift feed indicator updated when a gift being adjusted
was fed to Finance.
Date: 21-JUN-2004 Page: 88
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRAPLG_FEED_DATE DATE 7 YES Gift feed date is the date the gift being adjusted was
fed to the finance system
AGRAPLG_FEED_DOC_CODE VARCHAR2 8 YES Gift feed document code for the gift being adjusted,
updated when the gift was fed to Finance.
AGRAPLG_FEED_IND_ADJ VARCHAR2 1 YES This field incidates that the adjustment records have
been fed to finance.
AGRAPLG_FEED_DATE_ADJ DATE 7 YES This field specifies the date this adjustment record
has been fed to finance.
AGRAPLG_FEED_DOC_CODE_ADJ VARCHAR2 8 YES This field specifies the feed document code that
includes this adjustment.
AGRAPLG_ENTRY_DATE_ADJ DATE 7 NO The adjusted entry date associated with this pledge.
AGRAPLG_PGVE_CODE VARCHAR2 5 YES The original Pledge Gift Vehicle Code associated with
this pledge.
AGRAPLG_PGVE_CODE_ADJ VARCHAR2 5 YES The adjusted Pledge Gift Vehicle Code associated with
this pledge.
AGRAPLG_PCLS_CODE_2 VARCHAR2 4 YES Second pledge class code on pledge before the
adjustment.
AGRAPLG_PCLS_CODE_3 VARCHAR2 4 YES Third pledge class code on pledge before the
adjustment.
AGRAPLG_PCLS_CODE_2_ADJ VARCHAR2 4 YES Second pledge class code on adjusted pledge.
AGRAPLG_PCLS_CODE_3_ADJ VARCHAR2 4 YES Third pledge class code on adjusted pledge.
Date: 21-JUN-2004 Page: 89
TABLE: AGRGASC
CREATOR: ALUMNI
Associated ID Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGASC_PIDM NUMBER 8 NO Internal identification number for person/organization
of the gift number.
AGRGASC_GIFT_NO VARCHAR2 7 NO Gift number associated with the appraisal.
AGRGASC_ASSC_PIDM NUMBER 8 NO Internal identification number for person/organization
associated with the appraisal.
AGRGASC_ASSC_CODE VARCHAR2 5 NO Appraiser type code for the appraiser.
AGRGASC_ACTIVITY_DATE DATE 7 NO Date appraisal was created or last modified.
AGRGASC_ASSC_DATE DATE 7 NO Date the appraisal was made.
AGRGASC_ATYP_CODE VARCHAR2 2 YES Address type code for the appraiser.
AGRGASC_COMMENT VARCHAR2 240 YES Comment for the appraisal.
Date: 21-JUN-2004 Page: 90
TABLE: AGRGAUX
CREATOR: ALUMNI
Gift Auxiliary Amount Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGAUX_PIDM NUMBER 8 NO Internal system generated identification number.
AGRGAUX_GIFT_NO VARCHAR2 7 NO The system assigned number for the gift.
AGRGAUX_AUXL_CODE VARCHAR2 5 NO Auxiliary code associated with the gift.
AGRGAUX_AUXL_DESC VARCHAR2 60 NO Description for the auxiliary code for the gift.
AGRGAUX_DCPR_COST NUMBER 11 2 NO Actual cost to institution of benefit/premium.
AGRGAUX_ACTIVITY_DATE DATE 7 NO System maintained field specifying the date the record
was created or updated.
AGRGAUX_DCPR_CODE VARCHAR2 4 YES Benefit/premium associated with the gift.
AGRGAUX_ISSUE_DATE DATE 7 YES Date the benefit/premium was issued.
AGRGAUX_DCPR_VALUE NUMBER 11 2 YES Market value of benefit/premium.
AGRGAUX_DESC VARCHAR2 60 YES Brief description.
AGRGAUX_ACC_REJ_IND VARCHAR2 1 YES Indicator for whether benefit/premium was
accepted/rejected.
AGRGAUX_ACC_REJ_DATE DATE 7 YES Date benefit/premium was accepted/rejected.
AGRGAUX_GIFT_ADJ_VOID_IND VARCHAR2 1 YES Indicator for whether gift was adjusted/voided.
AGRGAUX_DONR_CODE VARCHAR2 4 YES Donor category code for ID associated with gift.
AGRGAUX_PREF_CLAS VARCHAR2 4 YES Preferred class year for ID.
AGRGAUX_USER VARCHAR2 30 YES System maintained field specifying user name.
AGRGAUX_DEDUCT_FOR_TAXES VARCHAR2 1 YES Indicator for whether premium is to be deducted for
taxes.
AGRGAUX_COMMENT LONG YES Free format comment for associated
amount/benefit/premium.
AGRGAUX_AUXL_VALUE_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 91
TABLE: AGRGCAM
CREATOR: ALUMNI
Gift Campaign Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGCAM_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AGRGCAM_GIFT_NO VARCHAR2 7 NO This field specifies the number of the gift.
AGRGCAM_PLEDGE_NO VARCHAR2 7 NO This field specifies the number of the pledge.
AGRGCAM_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign associated with the
gift.
AGRGCAM_AMT NUMBER 11 2 NO This field specifies the amount of the gift.
AGRGCAM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 92
TABLE: AGRGDES
CREATOR: ALUMNI
Gift Designation Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGDES_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AGRGDES_GIFT_NO VARCHAR2 7 NO This field specifies the number of the gift.
AGRGDES_PLEDGE_NO VARCHAR2 7 NO This field specifies the number of the pledge.
AGRGDES_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AGRGDES_DESG VARCHAR2 10 NO This field specifies the five character alphanumeric
campaign code.
AGRGDES_AMT NUMBER 11 2 NO This field specifies the amount of the gift
designation.
AGRGDES_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 93
TABLE: AGRGHDE
CREATOR: ALUMNI
Web Gift Detail Hold Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGHDE_ID VARCHAR2 9 NO Web ID created by a user not found in Banner.
AGRGHDE_GIFT_NO VARCHAR2 7 NO Gift number of gift created for a user with no Banner
PIDM.
AGRGHDE_PLEDGE_NO VARCHAR2 7 NO Pledge Number associated with gift created for a user
with no Banner PIDM.
AGRGHDE_CAMPAIGN VARCHAR2 5 NO Campaign Code of gift created for a user with no
Banner PIDM.
AGRGHDE_DESG VARCHAR2 10 NO Designation Code of gift created for a user with no
Banner PIDM.
AGRGHDE_AMT NUMBER 11 2 NO Designation amount of gift created for a user with no
Banner PIDM.
AGRGHDE_ACTIVITY_DATE DATE 7 NO Date the gift was created or changed.
AGRGHDE_USER VARCHAR2 30 NO User who created or changed the gift information.
AGRGHDE_PIDM NUMBER 8 YES Intenal ID of user who created the gift, once user id
given an ID in Banner.
Date: 21-JUN-2004 Page: 94
TABLE: AGRGIDS
CREATOR: ALUMNI
Gift Multiple Id Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGIDS_PIDM NUMBER 8 NO This field is the internal system generated
identification number.
AGRGIDS_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of the
gift.
AGRGIDS_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRGIDS_XREF_PIDM NUMBER 8 NO This field specifies the internal system generated
number of the cross reference.
AGRGIDS_AMT NUMBER 11 2 NO Amount of the gift associated with the cross reference
pidm. Amount must be less than or equal to the total
gift amount.
AGRGIDS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRGIDS_3PP_AMT NUMBER 11 2 NO The amount of the payment that is going to a third
party.
AGRGIDS_3PP_PLEDGE_NO VARCHAR2 7 YES The pledge number to which the third party payment
will be applied.
Date: 21-JUN-2004 Page: 95
TABLE: AGRGMEM
CREATOR: ALUMNI
Gift Memo Id Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGMEM_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AGRGMEM_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of
gift.
AGRGMEM_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRGMEM_MEMO_PIDM NUMBER 8 NO This field specifies the identification number of the
person or organization to whom a memo gift is
credited.
AGRGMEM_AMT NUMBER 11 2 NO This field specifies the amount of the memo gift.
AGRGMEM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRGMEM_3PP_AMT NUMBER 11 2 NO The amount of the payment that is going to a third
party.
AGRGMEM_3PP_PLEDGE_NO VARCHAR2 7 YES The pledge number to which the third party payment
will be applied.
Date: 21-JUN-2004 Page: 96
TABLE: AGRGMLT
CREATOR: ALUMNI
Detail Gift Multiple Credit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGMLT_PIDM NUMBER 8 NO Internal identification number for person/organization
associated with the gift.
AGRGMLT_XREF_PIDM NUMBER 8 NO Internal identification number for person/organization
receiving the multiple credit.
AGRGMLT_GIFT_NO VARCHAR2 7 NO Gift number from which multiple credit is being
disbursed.
AGRGMLT_PLEDGE_NO VARCHAR2 7 NO Pledge no associated with the gift from which multiple
credit is being disbursed.
AGRGMLT_CAMPAIGN VARCHAR2 5 NO Campaign associated with the gift from which multiple
credit is being disbursed.
AGRGMLT_DESG VARCHAR2 10 NO Designation associated with the gift from which
multiple credit is being disbursed.
AGRGMLT_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
AGRGMLT_CREDIT NUMBER 11 2 YES Dollar amount of the gift being disbursed to the xref
pidm from the pledge for the designation.
AGRGMLT_3PP_AMT NUMBER 11 2 NO The amount of the payment that is going to a third
party.
AGRGMLT_3PP_PLEDGE_NO VARCHAR2 7 YES The pledge number to which the third party payment
will be applied.
Date: 21-JUN-2004 Page: 97
TABLE: AGRGMMO
CREATOR: ALUMNI
Detail Gift Memo Credit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGMMO_PIDM NUMBER 8 NO Internal identification number for person/organization
associated with the gift.
AGRGMMO_XREF_PIDM NUMBER 8 NO Internal identification number for person/organization
receiving the memo credit.
AGRGMMO_GIFT_NO VARCHAR2 7 NO Gift number from which memo credit is being disbursed.
AGRGMMO_PLEDGE_NO VARCHAR2 7 NO Pledge no associated with the gift from which memo
credit is being disbursed.
AGRGMMO_CAMPAIGN VARCHAR2 5 NO Campaign associated with the gift from which memo
credit is being disbursed.
AGRGMMO_DESG VARCHAR2 10 NO Designation associated with the gift from which memo
credit is being disbursed.
AGRGMMO_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
AGRGMMO_CREDIT NUMBER 11 2 YES Percentage of the gift being disbursed to the xref
pidm from the pledge for the designation.
AGRGMMO_3PP_AMT NUMBER 11 2 NO The amount of the payment that is going to a third
party.
AGRGMMO_3PP_PLEDGE_NO VARCHAR2 7 YES The pledge number to which the third party payment
will be applied.
Date: 21-JUN-2004 Page: 98
TABLE: AGRGPAY
CREATOR: ALUMNI
Gift/Pledge Payment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGPAY_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the donor.
AGRGPAY_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of the
gift.
AGRGPAY_PLEDGE_NO VARCHAR2 7 NO This field specifies the number of the pledge. For a
one time gift, entering zero in this field will assign
a pledge number of 0000000.
AGRGPAY_AMT NUMBER 11 2 NO This field indicates the total amount of the gift for
the pledge.
AGRGPAY_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 99
TABLE: AGRGSOL
CREATOR: ALUMNI
Gift Solicitor Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRGSOL_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the donor.
AGRGSOL_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned gift number.
AGRGSOL_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned pledge
number.
AGRGSOL_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AGRGSOL_SOLC_CODE VARCHAR2 8 YES This field specifies the type of solicitation.
AGRGSOL_SOL_ORG VARCHAR2 5 YES This field specifies the solicitor organization to
which a solicitor is assigned.
AGRGSOL_SOL_PIDM NUMBER 8 YES This field specifies the internal system generated
identification number of the solicitor.
AGRGSOL_AMT NUMBER 11 2 NO This field specifies the amount of the gift.
AGRGSOL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRGSOL_CREDIT_PIDM NUMBER 8 NO The Internal ID of the person receiving the third
party credit.
AGRGSOL_3PP_PLEDGE_NO VARCHAR2 7 YES The pledge number to which the third party payment
will be applied.
Date: 21-JUN-2004 Page: 100
TABLE: AGRIDRL
CREATOR: ALUMNI
Split Pledges/Gifts for ID Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRIDRL_PIDM NUMBER 8 NO Internal system generated id no for the
person/organization.
AGRIDRL_XREF_CODE VARCHAR2 3 NO Cross reference code of ID for rule of multiple or
memo.
AGRIDRL_RULE_PRIORITY NUMBER 5 2 NO Priority number associated with the rule for a cross
reference code of an ID.
AGRIDRL_XREF_PRIORITY NUMBER 5 2 NO Cross reference priority number of ID for multiple or
memo.
AGRIDRL_XREF_PERCENT NUMBER 5 2 NO Percent of the pledge/gift of ID that is to be
multipled or memoed for the cross refence.
AGRIDRL_MULT_MEM_IND VARCHAR2 1 NO Multiple (H) or memo (S) indicator to distinguish
which the rule is for.
AGRIDRL_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
AGRIDRL_CMTP_CODE VARCHAR2 2 YES Campaign type code of ID for the multiple or memo
rule.
AGRIDRL_CAMPAIGN VARCHAR2 5 YES Campaign code of ID for the multiple or memo rule.
AGRIDRL_DSTP_CODE VARCHAR2 5 YES Designation type code of ID for the multiple or memo
rule.
AGRIDRL_DESG VARCHAR2 10 YES Designation code of ID for the multiple or memo rule.
Date: 21-JUN-2004 Page: 101
TABLE: AGRMCAM
CREATOR: ALUMNI
Matching Gift Campaign Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRMCAM_EMPR_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the employer.
AGRMCAM_EMPL_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the employee.
AGRMCAM_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of the
gift.
AGRMCAM_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AGRMCAM_AMT NUMBER 11 2 NO This field specifies the amount of the gift to be
matched.
AGRMCAM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 102
TABLE: AGRMDES
CREATOR: ALUMNI
Matching Gift Designation Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRMDES_EMPR_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the employer.
AGRMDES_EMPL_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of of the employee.
AGRMDES_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of the
gift.
AGRMDES_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AGRMDES_DESG VARCHAR2 10 NO This field specifies the five character alphanumeric
designation code.
AGRMDES_AMT NUMBER 11 2 NO This field specifies the amount of the designation.
AGRMDES_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 103
TABLE: AGRMGIF
CREATOR: ALUMNI
Matching Gift Ident Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRMGIF_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the donor.
AGRMGIF_GIFT_NO VARCHAR2 7 NO This field specifies the number of the gift to be
matched.
AGRMGIF_EMPR_GIFT_NO VARCHAR2 7 NO This field specifies the number of the employers
matching gift.
AGRMGIF_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRMGIF_GIFT_AMT NUMBER 11 2 NO This field identifies the amount of the corporate gift
applied to the employee gift.
AGRMGIF_EMPR_PIDM NUMBER 8 NO This field identifies the employers pidm that matched
the employee gift.
Date: 21-JUN-2004 Page: 104
TABLE: AGRMSOL
CREATOR: ALUMNI
Matching Gift Solicitor Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRMSOL_EMPR_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the employer.
AGRMSOL_EMPL_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the employee.
AGRMSOL_GIFT_NO VARCHAR2 7 NO This field specifies the system assigned number of the
gift.
AGRMSOL_CAMPAIGN VARCHAR2 5 NO This field specifies the five character alphanumeric
campaign code.
AGRMSOL_SOLC_CODE VARCHAR2 8 YES This field specifies the solicitor code.
AGRMSOL_SOL_ORG VARCHAR2 5 YES This field specifies the solicitor organization code.
AGRMSOL_SOL_PIDM NUMBER 8 YES This field specifies the internal system generated
identification number of the solicitor.
AGRMSOL_AMT NUMBER 11 2 NO This field specifies the amount of the gift.
AGRMSOL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 105
TABLE: AGRPASC
CREATOR: ALUMNI
Associated ID Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPASC_PIDM NUMBER 8 NO The Internal ID of the person making the pledge.
AGRPASC_PLEDGE_NO VARCHAR2 7 NO The Pledge Number being associated with another
person.
AGRPASC_ASSC_PIDM NUMBER 8 NO The Internal ID of the person with who the pledge is
being associated.
AGRPASC_ASSC_CODE VARCHAR2 5 NO The Associated Type Code for the pledge.
AGRPASC_ACTIVITY_DATE DATE 7 NO The date this association was created or last
modified.
AGRPASC_USER VARCHAR2 30 NO The User ID of the person who created or last modified
this association.
AGRPASC_ASSC_DATE DATE 7 NO The date the Associated Type Code was added or changed
for this association.
AGRPASC_ATYP_CODE VARCHAR2 2 YES The Address Type Code associated with this
association.
AGRPASC_COMMENT VARCHAR2 240 YES Free form text comments about this assosciation.
Date: 21-JUN-2004 Page: 106
TABLE: AGRPAUX
CREATOR: ALUMNI
Pledge Auxiliary Data Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPAUX_PIDM NUMBER 8 NO Unique identifying number of person making Pledge.
AGRPAUX_PLEDGE_NO VARCHAR2 7 NO Pledge identifying number.
AGRPAUX_AUXL_CODE VARCHAR2 5 NO Pledge Auxiliary Code.
AGRPAUX_AUXL_DESC VARCHAR2 60 NO Description of the Pledge Auxiliary code.
AGRPAUX_AUXL_AMOUNT NUMBER 11 2 NO Pledge Auxiliary Amount.
AGRPAUX_ACTIVITY_DATE DATE 7 NO Date the Pledge Auxiliary Data was inserted or last
modified.
AGRPAUX_USER VARCHAR2 30 NO User ID of the person who created/updated the record.
AGRPAUX_ISSUE_DATE DATE 7 YES Date the Pledge Auxiliary data was issued.
AGRPAUX_PLDG_ADJ_VOID_IND VARCHAR2 1 YES Indication of whether the Pledge was Adjusted or
Voided.
AGRPAUX_DONR_CODE VARCHAR2 4 YES Pledge Donor Code.
AGRPAUX_PREF_CLAS VARCHAR2 4 YES Pledge Prefered Class.
AGRPAUX_COMMENT LONG YES Free format comment field.
Date: 21-JUN-2004 Page: 107
TABLE: AGRPCAM
CREATOR: ALUMNI
Pledge Campaign Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPCAM_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGRPCAM_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRPCAM_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign code associated with
the pledge.
AGRPCAM_AMT NUMBER 11 2 NO This field specifies the amount pledged to the
campaign. This amount defaults to the pledge amount.
AGRPCAM_AMT_PAID NUMBER 11 2 NO This field specifies the amount paid toward the
pledge.
AGRPCAM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 108
TABLE: AGRPCON
CREATOR: ALUMNI
Pledge Condition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPCON_PIDM NUMBER 8 NO Unique identifying number of person making Pledge.
AGRPCON_PLEDGE_NO VARCHAR2 7 NO Pledge identifying number.
AGRPCON_SEQ NUMBER 5 NO Sequence number of the condition of the Pledge.
AGRPCON_CTYP_CODE VARCHAR2 5 NO Pledge Condition Type Code.
AGRPCON_MET_IND VARCHAR2 1 NO An indication of whether the Pledge Condition has been
met.
AGRPCON_ACTIVITY_DATE DATE 7 NO Date the Pledge Condition was inserted or last
modified.
AGRPCON_USER VARCHAR2 30 NO User ID of the person who created/updated the record.
AGRPCON_EXPECTED_DATE DATE 7 YES Date the Pledge Condition is expected to be met or
complied with.
AGRPCON_MET_DATE DATE 7 YES Date the Pledge Condition was met or complied with.
AGRPCON_TEXT LONG YES Free format text of the actual pledge condition.
Date: 21-JUN-2004 Page: 109
TABLE: AGRPDES
CREATOR: ALUMNI
Pledge Designation Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPDES_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGRPDES_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRPDES_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign code associated with
the pledge.
AGRPDES_DESG VARCHAR2 10 NO This field specifies the designation code associated
with the campaign.
AGRPDES_AMT NUMBER 11 2 NO This field specifies the amount of the pledge
designation. This field defaults to the campaign
amount.
AGRPDES_AMT_PAID NUMBER 11 2 NO This field specifies the amount paid toward the pledge
designation.
AGRPDES_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 110
TABLE: AGRPIDS
CREATOR: ALUMNI
Pledge Multiple Id Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPIDS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGRPIDS_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRPIDS_XREF_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the cross reference.
AGRPIDS_AMT NUMBER 11 2 NO This field specifies the amount of the pledge
associated with the cross reference. This amount must
be less than or equal to the pledge amount.
AGRPIDS_AMT_PAID NUMBER 11 2 NO This field specifies the amount paid toward the
pledge.
AGRPIDS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRPIDS_3PP_AMT NUMBER 11 2 NO The amount of the payment that is used for Third Party
Credit
Date: 21-JUN-2004 Page: 111
TABLE: AGRPINS
CREATOR: ALUMNI
Pledge Installment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPINS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGRPINS_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRPINS_INSTALLMENT_NO NUMBER 3 NO This field specifies the number of the pledge
installment.
AGRPINS_INSTALLMENT_DATE DATE 7 NO This field specifies the pledge installment date.
AGRPINS_AMT NUMBER 11 2 NO This field specifies the amount of the pledge
installment.
AGRPINS_REM_DATE DATE 7 YES This field specifies the date of the last installment
reminder.
AGRPINS_PRMD_CODE VARCHAR2 2 YES This field specifies the pledge reminder code.
AGRPINS_REM_COUNT NUMBER 2 YES This field specifies the number of pledge reminders
produced by the system to date.
AGRPINS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 112
TABLE: AGRPMEM
CREATOR: ALUMNI
Pledge Memo Id Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPMEM_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the pledger.
AGRPMEM_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned number of the
pledge.
AGRPMEM_MEMO_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the person receiving credit
for the memo pledge.
AGRPMEM_AMT NUMBER 11 2 NO This field specifies the amount of the memo pledge.
AGRPMEM_AMT_PAID NUMBER 11 2 NO This field specifies the amount paid toward the memo
pledge.
AGRPMEM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRPMEM_3PP_AMT NUMBER 11 2 NO The amount of the payment that is used for Third Party
Credit
Date: 21-JUN-2004 Page: 113
TABLE: AGRPMLT
CREATOR: ALUMNI
Detail Pledge Multiple Credit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPMLT_PIDM NUMBER 8 NO Internal identification number for person/organization
associated with the pledge.
AGRPMLT_XREF_PIDM NUMBER 8 NO Internal identification number for person/organization
receiving the multiple credit.
AGRPMLT_PLEDGE_NO VARCHAR2 7 NO Pledge no associated with the pledge from which
multiple credit is being disbursed.
AGRPMLT_CAMPAIGN VARCHAR2 5 NO Campaign associated with the pledge from which
multiple credit is being disbursed.
AGRPMLT_DESG VARCHAR2 10 NO Designation associated with the pledge from which
multiple credit is being disbursed.
AGRPMLT_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
AGRPMLT_CREDIT NUMBER 11 2 YES Percentage of the pledge being disbursed to the xref
pidm from the pledge for the designation.
AGRPMLT_3PP_AMT NUMBER 11 2 NO The amount of the payment that is used for Third Party
Credit
Date: 21-JUN-2004 Page: 114
TABLE: AGRPMMO
CREATOR: ALUMNI
Detail Pledge Memo Credit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPMMO_PIDM NUMBER 8 NO Internal identification number for person/organization
associated with the pledge.
AGRPMMO_XREF_PIDM NUMBER 8 NO Internal identification number for person/organization
receiving the memo credit.
AGRPMMO_PLEDGE_NO VARCHAR2 7 NO Pledge no associated with the pledge from which memo
credit is being disbursed.
AGRPMMO_CAMPAIGN VARCHAR2 5 NO Campaign associated with the pledge from which memo
credit is being disbursed.
AGRPMMO_DESG VARCHAR2 10 NO Designation associated with the pledge from which memo
credit is being disbursed.
AGRPMMO_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
AGRPMMO_CREDIT NUMBER 11 2 YES Percentage of the pledge being disbursed to the xref
pidm from the pledge for the designation.
AGRPMMO_3PP_AMT NUMBER 11 2 NO The amount of the payment that is used for Third Party
Credit
Date: 21-JUN-2004 Page: 115
TABLE: AGRPSOL
CREATOR: ALUMNI
Pledge Solicitor Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRPSOL_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AGRPSOL_PLEDGE_NO VARCHAR2 7 NO This field specifies the system assigned pledge
number.
AGRPSOL_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign code associated with
the pledge.
AGRPSOL_SOLC_CODE VARCHAR2 8 YES This field specifies the solicitation code.
AGRPSOL_SOL_ORG VARCHAR2 5 YES This field specifies the solicitor organization code.
AGRPSOL_SOL_PIDM NUMBER 8 YES This field specifies the internal system generated
identification number of the solicitor.
AGRPSOL_AMT NUMBER 11 2 NO This field specifies the amount of the pledge.
AGRPSOL_AMT_PAID NUMBER 11 2 NO This field specifies the amount paid toward the
pledge.
AGRPSOL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AGRPSOL_CREDIT_PIDM NUMBER 8 NO The Internal ID of the Solicitor who is receiving
credit for the pledge.
Date: 21-JUN-2004 Page: 116
TABLE: AGRRCPT
CREATOR: ALUMNI
Tax Receipt Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRRCPT_PIDM NUMBER 8 NO Internal identification number for person/organization
associated with the receipt.
AGRRCPT_RECEIPT_NO VARCHAR2 8 NO Receipt number associated with the gift.
AGRRCPT_GIFT_NO VARCHAR2 7 NO Number for the gift associated with the receipt.
AGRRCPT_USERID VARCHAR2 30 NO User ID that created receipt.
AGRRCPT_ACTIVITY_DATE DATE 7 NO Date receipt was last created or modified.
AGRRCPT_RECEIPT_DATE DATE 7 YES Date receipt was created.
AGRRCPT_ALTERNATE_NO VARCHAR2 15 YES Alternate number associated with receipt.
AGRRCPT_GIFT_VOID_IND VARCHAR2 1 YES Indicator of whether gift has been voided.
AGRRCPT_RSTA_CODE VARCHAR2 1 YES Receipt status code.
AGRRCPT_MULTIPLE_GIFT_IND VARCHAR2 1 YES Indicator of whether multiple gifts have been
receipted.
AGRRCPT_DUPL_REISSUE_IND VARCHAR2 1 YES Indicator of whether gifts have been duplicated or
reissued.
Date: 21-JUN-2004 Page: 117
TABLE: AGRSPRL
CREATOR: ALUMNI
Split Pledges/Gifts Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRSPRL_XREF_CODE VARCHAR2 3 NO Cross reference code of rule for multiple or memo.
AGRSPRL_XREF_PRIORITY NUMBER 5 2 NO Cross reference priority number for multiple or memo.
AGRSPRL_RULE_PRIORITY NUMBER 5 2 NO Priority number associated with the rule for a cross
reference code.
AGRSPRL_XREF_PERCENT NUMBER 5 2 NO Percent of the pledge/gift that is to be multipled or
memoed for the cross reference.
AGRSPRL_MULT_MEM_IND VARCHAR2 1 NO Multiple (H) or memo (S) indicator to distinguish
which the rule is for.
AGRSPRL_ACTIVITY_DATE DATE 7 NO Date this record was inserted or last updated.
AGRSPRL_CMTP_CODE VARCHAR2 2 YES Campaign type code for the multiple or memo rule.
AGRSPRL_CAMPAIGN VARCHAR2 5 YES Campaign code for the multiple or memo rule.
AGRSPRL_DSTP_CODE VARCHAR2 5 YES Designation type code for the multiple or memo rule.
AGRSPRL_DESG VARCHAR2 10 YES Designation code for the multiple or memo rule.
Date: 21-JUN-2004 Page: 118
TABLE: AGRTEMP
CREATOR: ALUMNI
Temporary table to be used for internal processing within processes
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRTEMP_NAME VARCHAR2 3 YES
AGRTEMP_PIDM NUMBER YES
AGRTEMP_CREDIT NUMBER YES
Date: 21-JUN-2004 Page: 119
TABLE: AGRTFED
CREATOR: ALUMNI
Feed to Finance Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRTFED_PIDM NUMBER 8 NO
AGRTFED_GIFT_NO VARCHAR2 7 NO
AGRTFED_SEQ NUMBER 3 NO
AGRTFED_PLEDGE_NO VARCHAR2 7 NO
AGRTFED_CAMPAIGN VARCHAR2 5 NO
AGRTFED_DESG VARCHAR2 10 NO
AGRTFED_AMT NUMBER 11 2 NO
AGRTFED_GIFT_DATE DATE 7 NO
AGRTFED_GIFT_CODE VARCHAR2 2 NO
AGRTFED_ENTRY_DATE DATE 7 NO
AGRTFED_GIFT_USER VARCHAR2 30 NO
AGRTFED_ACTIVITY_DATE DATE 7 NO
AGRTFED_ID VARCHAR2 9 YES
AGRTFED_LAST_NAME VARCHAR2 60 YES
AGRTFED_FIRST_NAME VARCHAR2 25 YES
AGRTFED_USER VARCHAR2 30 YES
AGRTFED_SESSIONID VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 120
TABLE: AGRTMP2
CREATOR: ALUMNI
Temporary table to be used for internal processing from within processes
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRTMP2_LEVEL_NAME NUMBER YES
AGRTMP2_LEVEL VARCHAR2 20 YES
AGRTMP2_DONORS_1 NUMBER YES
AGRTMP2_DOLLARS_1 NUMBER YES
AGRTMP2_ACCUM_DONORS_1 NUMBER YES
AGRTMP2_ACCUM_DOLLARS_1 NUMBER YES
AGRTMP2_DONORS_2 NUMBER YES
AGRTMP2_DOLLARS_2 NUMBER YES
AGRTMP2_ACCUM_DONORS_2 NUMBER YES
AGRTMP2_ACCUM_DOLLARS_2 NUMBER YES
Date: 21-JUN-2004 Page: 121
TABLE: AGRTPFD
CREATOR: ALUMNI
Data Field Position Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRTPFD_TAPE_CODE VARCHAR2 10 NO Data file name.
AGRTPFD_REC_NUMBER NUMBER 2 NO Data file record number.
AGRTPFD_TPFD_CODE VARCHAR2 40 NO Data file field name.
AGRTPFD_START_POS NUMBER 5 NO Start position of data file field.
AGRTPFD_END_POS NUMBER 5 NO End position of data file field.
AGRTPFD_ACTIVITY_DATE DATE 7 NO Date on which the record was added or last changed.
AGRTPFD_USER VARCHAR2 30 NO User Id of the person who added or last changed the
record.
AGRTPFD_OCC NUMBER 3 YES Number of times the data field repeats.
Date: 21-JUN-2004 Page: 122
TABLE: AGRWPRM
CREATOR: ALUMNI
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AGRWPRM_ID VARCHAR2 9 NO
AGRWPRM_PARAM_NAME VARCHAR2 10 NO
AGRWPRM_PARAM_VALUE VARCHAR2 30 YES
AGRWPRM_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 123
TABLE: AMBMAIL
CREATOR: ALUMNI
Mailing Address Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMBMAIL_LABEL_ID VARCHAR2 10 NO User defined label identifier
AMBMAIL_USER VARCHAR2 30 NO User id initiating the labels
AMBMAIL_PIDM NUMBER 8 NO Internal person/org identifiation number
AMBMAIL_NAME VARCHAR2 60 YES Name selected for mailing label
AMBMAIL_ATYP_CODE VARCHAR2 2 YES This field is the mailing address type selected if
combined mailing is not used when running mailing
labels.
AMBMAIL_ZIP VARCHAR2 10 YES Zip code for selected address
AMBMAIL_ADDR_SEL VARCHAR2 2 YES Address selection indicator
AMBMAIL_CON_ORG VARCHAR2 1 YES Constituent or Organization indicator
AMBMAIL_OCON_CODE VARCHAR2 3 YES This field is the Organization contact code for the
contact selected.
AMBMAIL_OCON_SEQ NUMBER 23 20 YES Org. contact sequence number
AMBMAIL_XREF_PIDM NUMBER 8 YES Cross ref pidm for combined mailing
AMBMAIL_CM_NAME VARCHAR2 60 YES Combined mailing name
AMBMAIL_ATYP_CODE_CM VARCHAR2 2 YES Combined mailing address type
AMBMAIL_ZIP_CM VARCHAR2 10 YES Combined mailing address zip code
AMBMAIL_CM_PRI_IND VARCHAR2 1 YES Combined mailing relationship indicator
AMBMAIL_ACTIVITY_DATE DATE 7 NO Date of add or last change
Date: 21-JUN-2004 Page: 124
TABLE: AMBPLAN
CREATOR: ALUMNI
Prospect Management Strategy Plan Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMBPLAN_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AMBPLAN_STGY_PLAN VARCHAR2 15 NO This field specifies the strategy plan name.
AMBPLAN_PROJ_CODE VARCHAR2 6 NO This field specifies the Project code associated with
the Strategy plan.
AMBPLAN_IDEN_CODE VARCHAR2 5 NO This field specifies the staff identification code.
AMBPLAN_START_DATE DATE 7 NO This field specifies the start date of the strategy
plan.
AMBPLAN_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 125
TABLE: AMBPROP
CREATOR: ALUMNI
Prospects Proposals Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMBPROP_PIDM NUMBER 8 NO This column specifies the internal system generated ID
number of a Propspect.
AMBPROP_PROP_CODE VARCHAR2 6 NO The Proposal code which is being associated to the
Prospect.
AMBPROP_USER VARCHAR2 30 NO User ID of the person who created/updated the record.
AMBPROP_ACTIVITY_DATE DATE 7 NO Date the record was inserted or last modified.
AMBPROP_PRST_CODE VARCHAR2 1 YES The Status Code of the Proposal for the Prospect.
AMBPROP_PRST_DATE DATE 7 YES The Date of the Proposal Status for the Prospect.
AMBPROP_COMMENT LONG YES Free Format column for entry of Proposal Comments.
AMBPROP_STAFF_PIDM NUMBER 8 YES This column is the internal system generated ID number
of the Staff.
AMBPROP_STAFF_IDEN_CODE VARCHAR2 5 YES This column specifies the identification code of the
Staff.
AMBPROP_DUE_DATE DATE 7 YES This column specifies the Due Date of the Proposal.
AMBPROP_FINANCE_CODE VARCHAR2 9 YES Grant code associated from Banner Finance, not yet
implemented.
AMBPROP_ASK_AMOUNT NUMBER 13 2 YES The Ask Amount for the Proposal for this prospect.
Date: 21-JUN-2004 Page: 126
TABLE: AMBSTGY
CREATOR: ALUMNI
Prospect Management Strategy Assignment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMBSTGY_STGY_PLAN VARCHAR2 15 NO This field specifie the Strategy Plan name.
AMBSTGY_ACTIVITY_DATE DATE 7 NO This system maintained field represents the date the
record was updated or created.
AMBSTGY_PROJ_CODE VARCHAR2 6 YES This field specifies the Project code associated with
the Strategy plan.
Date: 21-JUN-2004 Page: 127
TABLE: AMRCONF
CREATOR: ALUMNI
Prospect Confidentiality Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRCONF_PIDM NUMBER 8 NO Internal person/org identification number.
AMRCONF_IDEN_CODE VARCHAR2 5 NO This field specifies identification code.
AMRCONF_USER_ID VARCHAR2 30 NO This field specifies the identification code user id.
AMRCONF_GRP_SEQ_NO NUMBER 15 NO This field specifies internal generated number for
group.
AMRCONF_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRCONF_ENTRY_DATE DATE 7 NO This field specifies the entry date the
confidentiality information was entered.
AMRCONF_CONFID_IND VARCHAR2 1 YES This field specifies if confidentiality is set.
AMRCONF_USER VARCHAR2 30 NO The User ID of the person who created or last modified
this comment.
AMRCONF_COMMENT LONG YES Free form text comment for this prospect.
Date: 21-JUN-2004 Page: 128
TABLE: AMRCONT
CREATOR: ALUMNI
Prospect Contact Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRCONT_PIDM NUMBER 8 NO Internal person/org identification number.
AMRCONT_IDEN_CODE VARCHAR2 5 NO This field specifies identification code.
AMRCONT_PROJ_CODE VARCHAR2 6 YES This field specifies the project/interest code.
AMRCONT_SCNT_CODE VARCHAR2 3 NO This field specifies the contact code.
AMRCONT_ITEM_REFNO NUMBER 15 NO This field specifies internal generated number for
each contact.
AMRCONT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRCONT_IDEN_CODE_ASGN VARCHAR2 5 YES This field specifies the identification code assigned
to contact.
AMRCONT_CONTACT VARCHAR2 2000 NO This field specifies the contact that was made.
AMRCONT_CONTACT_DATE DATE 7 NO This field specifies the date the contact was made.
AMRCONT_CREATE_TICKLER VARCHAR2 1 YES This field specifies if a tickler is to be created.
AMRCONT_TICKLER VARCHAR2 180 YES This field specifies the message.
AMRCONT_TICK_DATE DATE 7 YES This field specifies the message date.
AMRCONT_TICK_STATUS VARCHAR2 1 YES This field specifies the message status.
AMRCONT_CONFID_IND VARCHAR2 1 YES This field specifies if the message is confidential.
AMRCONT_MOVE_CODE VARCHAR2 4 YES This field specifies the move code.
AMRCONT_ASK_AMT NUMBER 11 2 YES This field specifies the asking amount for the
contact/project.
AMRCONT_PROJ_CODE_2 VARCHAR2 6 YES This field specifies the second project/interest code.
AMRCONT_PROJ_CODE_3 VARCHAR2 6 YES This field specifies the third project/interest code.
AMRCONT_PROJ_CODE_4 VARCHAR2 6 YES This field specifies the forth project/interest code.
AMRCONT_ASK_AMT_2 NUMBER 11 2 YES This field specifies the asking amount for the second
contact/project.
AMRCONT_ASK_AMT_3 NUMBER 11 2 YES This field specifies the asking amount for the third
contact/project.
AMRCONT_ASK_AMT_4 NUMBER 11 2 YES This field specifies the asking amount for the forth
contact/project.
AMRCONT_PROP_CODE VARCHAR2 6 YES The Proposal code which is being associated to the
Contact.
AMRCONT_CALL_REPORT LONG YES Free form text comments about the call to this
prospect.
AMRCONT_USER_ID VARCHAR2 30 NO
AMRCONT_GEN_CONTACT_IND VARCHAR2 1 NO Prospect contact or General Contact indicator: this
field indicates whether record is a Prospect contact
or General contact, "N" indicates a Prospect contact,
"Y" indicates a General contact.
AMRCONT_STGY_PLAN VARCHAR2 15 YES
AMRCONT_MOVE_SEQNO NUMBER 15 YES
Date: 21-JUN-2004 Page: 129
TABLE: AMRDESG
CREATOR: ALUMNI
Pledge Condition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRDESG_PROJ_CODE VARCHAR2 6 NO The Project code to which Designations are being
associated.
AMRDESG_DESG VARCHAR2 10 NO The Designation that is being associated to a Project
Code.
AMRDESG_USER VARCHAR2 30 NO User ID of the person who created/updated the record.
AMRDESG_ACTIVITY_DATE DATE 7 NO Date the Pledge Condition was inserted or last
modified.
Date: 21-JUN-2004 Page: 130
TABLE: AMREXRT
CREATOR: ALUMNI
Prospect External Ratings Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMREXRT_PIDM NUMBER 8 NO Internal person/org identification number.
AMREXRT_EXRS_CODE VARCHAR2 5 NO This field specifies external source code.
AMREXRT_EXT_VALUE VARCHAR2 4 YES This field specifies external source value.
AMREXRT_EXT_SCORE VARCHAR2 4 YES This field specifies the score of external rating.
AMREXRT_EXT_LEVEL VARCHAR2 4 YES This field specifies matching level of external source
code.
AMREXRT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 131
TABLE: AMRINFO
CREATOR: ALUMNI
Prospect Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRINFO_PIDM NUMBER 8 NO Internal person/org identification number.
AMRINFO_REFR_CODE VARCHAR2 2 NO This field specifies the reference code.
AMRINFO_SYS_IND VARCHAR2 1 NO This field specifies system indicator.
AMRINFO_STATUS VARCHAR2 1 NO This field specifies status.
AMRINFO_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date the
record was created or updated.
AMRINFO_RATE_ENTRY_DATE DATE 7 YES This field specifies the date rate was entered.
AMRINFO_REFERENCE VARCHAR2 30 YES This field specifies reference.
AMRINFO_PROSP_RATE NUMBER 11 2 YES This field specifies manually entered or system
calculated prospect amount.
AMRINFO_TARGET_ASK_DATE DATE 7 YES This field specifies manually entered target asking
date.
AMRINFO_WEB_GIFT_IND VARCHAR2 1 YES Web Gift Indicator, Y indicates that gifts from this
prospect will be accepted from the Web.
AMRINFO_WEB_PLDG_IND VARCHAR2 1 YES Web Pledge Indicator, Y indicates that pledges from
this prospect will be accepted from the Web.
Date: 21-JUN-2004 Page: 132
TABLE: AMRPCCM
CREATOR: ALUMNI
Prospect Contact Comment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPCCM_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPCCM_GRP_SEQ_NO NUMBER 15 NO Internally generated group sequence number.
AMRPCCM_LINE_SEQ_NO NUMBER 23 20 NO Internally generated line sequence number.
AMRPCCM_IDEN_CODE VARCHAR2 5 NO This field specifies identification code.
AMRPCCM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRPCCM_COMMENT VARCHAR2 60 NO This field specifies the contact comment.
Date: 21-JUN-2004 Page: 133
TABLE: AMRPCMT
CREATOR: ALUMNI
Prospect Comment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPCMT_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPCMT_IDEN_CODE VARCHAR2 5 NO This field specifies identification code.
AMRPCMT_GRP_SEQ_NO NUMBER 15 NO Internally generated group sequence number.
AMRPCMT_LNE_SEQ_NO NUMBER 23 20 NO Internallly generated line sequence number.
AMRPCMT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRPCMT_COMMENT VARCHAR2 60 NO This field specifies comment.
Date: 21-JUN-2004 Page: 134
TABLE: AMRPEXP
CREATOR: ALUMNI
Prospect Expense Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPEXP_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPEXP_IDEN_CODE VARCHAR2 5 NO This field specifies identification code.
AMRPEXP_EXPN_CODE VARCHAR2 2 NO This field specifies expense code.
AMRPEXP_GRP_SEQ_NO NUMBER 15 NO Internally generated group sequence number.
AMRPEXP_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRPEXP_EXPN_AMT NUMBER 11 2 YES This field specifies the expense amount for the
expense code.
Date: 21-JUN-2004 Page: 135
TABLE: AMRPLAN
CREATOR: ALUMNI
Prospect Management Strategy Planning Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPLAN_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AMRPLAN_STGY_PLAN VARCHAR2 15 NO This field specifies the strategy plan name.
AMRPLAN_PROJ_CODE VARCHAR2 6 NO This field specifies the project code associated with
the strategy plan.
AMRPLAN_IDEN_CODE VARCHAR2 5 NO This field specifies the staff identification code for
the strategy plan.
AMRPLAN_MOVE_CODE VARCHAR2 4 NO This field specifies the move code for the strategy.
AMRPLAN_WAIT_DAYS NUMBER 3 NO This field specifies the number of wait days for the
move code.
AMRPLAN_PLAN_DATE DATE 7 NO This field specifies the planned date for the move
code to occur.
AMRPLAN_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRPLAN_COMMENT VARCHAR2 180 YES This field specifies the comment and or action on the
move code.
AMRPLAN_MESSAGE_IND VARCHAR2 1 YES This field specifies if a message is to be or was
created on the GUAMESG form.
AMRPLAN_ACTION_DATE DATE 7 YES This field specifies the date then message is to
occur.
AMRPLAN_SYS_IND VARCHAR2 1 YES This field specifies if the move code was defaulted in
or unexpected.
AMRPLAN_MOVE_SEQNO NUMBER 15 NO
Date: 21-JUN-2004 Page: 136
SEQUENCE: AMRPLAN_SEQUENCE
CREATOR: ALUMNI
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999999999999999
Increment: 1
Last Number: 1
Cache Size: 0
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 137
TABLE: AMRPRIN
CREATOR: ALUMNI
Prospect Project/Interest Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPRIN_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPRIN_PROJ_CODE VARCHAR2 6 NO This field specifies project/interest code.
AMRPRIN_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRPRIN_GIVH_CODE VARCHAR2 2 YES This field specifies giving vehicle code.
AMRPRIN_TARGET_ASK_AMT NUMBER 10 2 YES Target ask amount for the constituent for the project.
AMRPRIN_TARGET_ASK_DATE DATE 7 YES Target ask date for the constituent for the project.
AMRPRIN_USER VARCHAR2 30 NO This system maintained field specifies the user that
created or updated the record.
AMRPRIN_PRST_CODE VARCHAR2 1 YES This field specifies the Status of the project for the
prospect.
AMRPRIN_PRST_DATE DATE 7 YES This field specifies the Date of the project status
for the prospect.
AMRPRIN_PROJ_EFF_FROM_DATE DATE 7 YES This field specifies the Begin date that the project
is effective.
AMRPRIN_PROJ_EFF_TO_DATE DATE 7 YES This field specifies the End date that the project is
effective.
AMRPRIN_PROJ_TEXT VARCHAR2 2000 YES This field specifies free format Text about the
project.
Date: 21-JUN-2004 Page: 138
TABLE: AMRPROP
CREATOR: ALUMNI
Prospects Proposals Projects repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPROP_PIDM NUMBER 8 NO This column specifies the internal system generated ID
number of a Propspect.
AMRPROP_PROP_CODE VARCHAR2 6 NO The Proposal code which is associated to the Prospect.
AMRPROP_PROJ_CODE VARCHAR2 6 NO The Project code which is being associated to the
Proposal.
AMRPROP_USER VARCHAR2 30 NO User ID of the person who created/updated the record.
AMRPROP_ACTIVITY_DATE DATE 7 NO Date the record was inserted or last modified.
AMRPROP_GIVH_CODE VARCHAR2 2 YES This field specifies the Giving Vehicle Code for the
Proposal/Project.
AMRPROP_TARGET_ASK_AMOUNT NUMBER 11 2 YES This field specifies the desired Asking Amount for the
Proposal/Project.
AMRPROP_TARGET_ASK_DATE DATE 7 YES This field specifies the Date the desired Amount was
asked.
AMRPROP_PRST_CODE VARCHAR2 1 YES This field specifies the Status of the project for the
prospect.
AMRPROP_PRST_DATE DATE 7 YES This field specifies the Date of the project status
for the prospect.
AMRPROP_PROJ_EFF_FROM_DATE DATE 7 YES This field specifies the Begin date that the project
is effective.
AMRPROP_PROJ_EFF_TO_DATE DATE 7 YES This field specifies the End date that the project is
effective.
AMRPROP_PROJ_TEXT VARCHAR2 2000 YES This field specifies free format Text about the
project.
Date: 21-JUN-2004 Page: 139
TABLE: AMRPRRT
CREATOR: ALUMNI
Prospect Rating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPRRT_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPRRT_RTGT_CODE VARCHAR2 1 NO This field specifies rating type code.
AMRPRRT_RATE_CODE VARCHAR2 2 NO This field specifies rate code.
AMRPRRT_RSCR_CODE VARCHAR2 5 NO This field specifies screening code.
AMRPRRT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRPRRT_PRIMARY_IND VARCHAR2 1 YES This field specifies which rate code is primary.
AMRPRRT_IDEN_CODE VARCHAR2 5 YES Person identification code.
AMRPRRT_RATING_PIDM NUMBER 8 YES The Internal ID of the person associated with the
rating.
AMRPRRT_USER VARCHAR2 30 NO This system maintained field specifies the user that
created or updated the record.
Date: 21-JUN-2004 Page: 140
TABLE: AMRPRSC
CREATOR: ALUMNI
Prospect Research Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPRSC_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPRSC_IDEN_CODE_RSCH VARCHAR2 5 NO This field specifies researcher identification code.
AMRPRSC_PREPARED_DATE DATE 7 NO This field specifies the date the research was
prepared.
AMRPRSC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 141
TABLE: AMRPSRC
CREATOR: ALUMNI
Prospect Source Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPSRC_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPSRC_SORC_CODE VARCHAR2 6 NO This field specifies source code.
AMRPSRC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 142
TABLE: AMRPUSR
CREATOR: ALUMNI
Prospect User Defined Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRPUSR_PIDM NUMBER 8 NO Internal person/org identification number.
AMRPUSR_USRC_CODE VARCHAR2 20 NO This field specifies user defined code.
AMRPUSR_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRPUSR_SEQNO NUMBER 23 20 NO Internally generated sequence number.
AMRPUSR_VALUE LONG NO This field specifies the value of the user defined
code.
AMRPUSR_EFFECT_DATE DATE 7 NO Effective date of the prospect research data entry.
Date: 21-JUN-2004 Page: 143
TABLE: AMRSTAF
CREATOR: ALUMNI
Prospect Staff Assignment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRSTAF_PIDM NUMBER 8 NO Internal person/org identification number.
AMRSTAF_STFT_CODE VARCHAR2 4 NO This field specifies staff type code.
AMRSTAF_IDEN_CODE VARCHAR2 5 YES This field specifies staff identification code.
AMRSTAF_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRSTAF_SOLICIT_IND VARCHAR2 1 YES This field specifies staff person is solicitor.
AMRSTAF_PRIMARY_IND VARCHAR2 1 YES This field specifies staff person as primary.
AMRSTAF_STAFF_PIDM NUMBER 8 YES Internal staff person identification number.
AMRSTAF_USER VARCHAR2 30 NO This system maintained field specifies the user that
created or updated the record.
Date: 21-JUN-2004 Page: 144
TABLE: AMRSTGY
CREATOR: ALUMNI
Prospect Management Strategy Plan Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRSTGY_STGY_PLAN VARCHAR2 15 NO This field specifies the Strategy Plan name.
AMRSTGY_MOVE_CODE VARCHAR2 4 NO This field specifies the Move Code for the Plan.
AMRSTGY_STGY_SEQNO NUMBER 23 20 NO This field specifies the internal sequence number
generated for the move code.
AMRSTGY_WAIT_DAYS NUMBER 3 NO This field specifies the number of days from one move
code to another.
AMRSTGY_ACTIVITY_DATE DATE 7 NO This system maintained field represents the date the
record was updated or created.
AMRSTGY_PROJ_CODE VARCHAR2 6 YES This field specifies the Project code associated with
the Strategy plan.
Date: 21-JUN-2004 Page: 145
TABLE: AMRSUBJ
CREATOR: ALUMNI
Prospect Subject Comment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AMRSUBJ_PIDM NUMBER 8 NO Internal person/org identification number.
AMRSUBJ_IDEN_CODE VARCHAR2 5 NO This field specifies identification code for person of
subject comment.
AMRSUBJ_SUBJ_CODE VARCHAR2 6 NO This field specifies subject code.
AMRSUBJ_GRP_SEQ_NO NUMBER 15 NO This field specifies internally generated group
sequence number.
AMRSUBJ_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AMRSUBJ_USER VARCHAR2 30 NO The User ID of the person who created or last modified
the prospect comment subject.
Date: 21-JUN-2004 Page: 146
TABLE: AOBDOWP
CREATOR: ALUMNI
Development Officer Profile Preference Header Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AOBDOWP_PIDM NUMBER 8 NO Internal Identification Number of the Development
Officer.
AOBDOWP_USER VARCHAR2 30 NO Oracle Userid of the person who created or last
updated this record.
AOBDOWP_ACTIVITY_DATE DATE 7 NO Date this record was created or last updated.
AOBDOWP_ADDR_PREF VARCHAR2 2 YES Type of address to display in profiles - AL = All, AA
= Active, PR = Preferred.
AOBDOWP_EMPL_PREF VARCHAR2 2 YES Employment type to display in profiles - AL = All, AA
= Active, PR = Primary.
AOBDOWP_CONTACT_MONTHS NUMBER 3 YES Number of months of contct history to display in
profiles.
AOBDOWP_GIV_HIST_PREF VARCHAR2 1 YES Default giving history display format.
Date: 21-JUN-2004 Page: 147
TABLE: AOBORGN
CREATOR: ALUMNI
Organization Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AOBORGN_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
AOBORGN_EIN VARCHAR2 9 YES This field specifies the organizations federal
identification number.
AOBORGN_BUSINESS VARCHAR2 30 NO This field specifies the organizations general
category of business.
AOBORGN_SICC_CODE VARCHAR2 4 YES This field specifies the organizations standard
industry code.
AOBORGN_MATCH_PCT NUMBER 3 YES This field specifies the organizations matching gift
percentage.
AOBORGN_MATCH_ORG_MAX NUMBER 11 2 YES Amount the organization will donate to an institution
per year.
AOBORGN_MATCH_PERSON_MAX NUMBER 11 2 YES Amount an employee can be matched per year.
AOBORGN_ATYP_CODE VARCHAR2 2 YES This field specifies the address to use for the
organizational contact.
AOBORGN_JOBC_CODE VARCHAR2 3 YES This field specifies the job category associated with
the organizational contacts title.
AOBORGN_TITLE_CONTACT VARCHAR2 60 YES This field specifies the job title of the
organizational contact.
AOBORGN_LAST_NAME_CONTACT VARCHAR2 25 YES This field specifies the last name of the
organizational contact.
AOBORGN_FIRST_NAME_CONTACT VARCHAR2 15 YES This field specifies the first name of the
organizational contact.
AOBORGN_MI_CONTACT VARCHAR2 1 YES This field specifies the organizational contacts
middle initial.
AOBORGN_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AOBORGN_MG_PIDM NUMBER 8 YES Internal Id number for the matching gift company
associated with the organization. The pidm may be the
same pidm or the parent pidm.
AOBORGN_EMPL_CNT NUMBER 9 YES Total number of employees.
AOBORGN_EMPL_PT_PROF NUMBER 9 YES Total number of parttime professional employees.
AOBORGN_EMPL_FT_PROF NUMBER 9 YES Total number of fulltime professional employees.
AOBORGN_TOT_REVENUE NUMBER 12 YES Total revenue for organization.
AOBORGN_TOT_ASSETS NUMBER 12 YES Total assets for organization.
AOBORGN_TOT_EARNINGS NUMBER 12 YES Total earnings for organization.
AOBORGN_PRE_TAX_PROFIT NUMBER 12 YES Pre-tax profit for organization.
AOBORGN_GRANT_LOW NUMBER 12 YES Grant dollars low range.
AOBORGN_GRANT_HIGH NUMBER 12 YES Grant dollars high range.
AOBORGN_PROP_DEADLINE_MM VARCHAR2 2 YES Proposal deadline month.
AOBORGN_PROP_DEADLINE_DD VARCHAR2 2 YES Proposal deadline date of month.
AOBORGN_YEAR_INC NUMBER 4 YES Organization date of incorporation (Format YYYY).
AOBORGN_BEG_FY_MM VARCHAR2 2 YES Beginning month of organizations fiscal year.
AOBORGN_BEG_FY_DD VARCHAR2 2 YES Beginning date of month for organizations fiscal year.
Date: 21-JUN-2004 Page: 148
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AOBORGN_END_FY_MM VARCHAR2 2 YES Ending month of organizations fiscal year.
AOBORGN_END_FY_DD VARCHAR2 2 YES Ending day of month for organizations fiscal year.
AOBORGN_OTH_ED_MG_IND VARCHAR2 1 YES Other aid-to-education program in addition to matching
gift program. Values Y or N.
AOBORGN_STATE_ASSOC_MG_IND VARCHAR2 1 YES Organization matches gifts to state or regional
associations of private colleges. Values Y or N.
AOBORGN_DESG_MG_IND VARCHAR2 1 YES Designation of matching gifts indicator. Values
S=Same as employee gift, U=Unrestriced,X=designated
for general operating budget. Used in MG batch
process.
AOBORGN_MDIS_CODE VARCHAR2 1 YES Matching gift distribution code.
AOBORGN_MDIS_MM VARCHAR2 2 YES Month of Matching gift distribution.
AOBORGN_MDIS_DD VARCHAR2 2 YES Date of month for Matching gift distribution.
AOBORGN_MDIS_DEADLINE_MM VARCHAR2 2 YES Month of Matching gift distribution deadline date.
AOBORGN_MDIS_DEADLINE_DD VARCHAR2 2 YES Date of month for Matching gift distribution deadline
date.
AOBORGN_DUPL_MG_IND VARCHAR2 1 YES MG duplicate match indicator. Company will (Y) or
will not (N) match gifts eligible to be matched by
other companies. Used in the MG batch process.
AOBORGN_MG_ACK_IND VARCHAR2 1 YES Company required acknowledgment of MG, Y or N. An A
indicates acknowledgments may be combined and sent
periodically.
AOBORGN_MGMT_MG_IND VARCHAR2 1 YES Management indicator C=Corp administers
MG,F=Foundation administers companies MG.
AOBORGN_MATCH_PERS_INST_YR NUMBER 11 2 YES Amount an employee can be matched per insitition per
year.
AOBORGN_MATCH_ORG_CEILING_YR NUMBER 11 2 YES Overall ceiling amount the organization will match
each year.
AOBORGN_MATCH_ORG_EMPL_YR NUMBER 11 2 YES Maximum corporate matching gift payout per employee
per year.
AOBORGN_MATCH_MINIMUM NUMBER 11 2 YES Minimum amount organization will match.
AOBORGN_SOCIETY_NAME VARCHAR2 60 YES Gift Society name. This name will default to gift
societies when they memberships are created. The name
may be modified on the society form.
AOBORGN_YEAR_MG NUMBER 4 YES The year the matching gift program was started within
the organization.
AOBORGN_FINANCIALS_DATE DATE 7 YES The date associated with the financial total fields.
AOBORGN_MG_LOAD_UPDATE_DATE DATE 7 YES The date that Matching Gift information was last
loaded from an external source.
AOBORGN_MG_LOAD_SOURCE VARCHAR2 1 YES The source of the last external Matching Gift
information load.
AOBORGN_MG_RECEIPT_IND VARCHAR2 1 YES Matching Gift Receipt Indicator, Y indicates that a
receipt is required.
AOBORGN_MATCH_MAXIMUM NUMBER 11 2 YES The maximum matching gift amount allowed.
AOBORGN_PREFIX_CONTACT VARCHAR2 20 YES The prefix associated with the name of the Primary
Contact.
AOBORGN_SUFFIX_CONTACT VARCHAR2 20 YES The suffix associated with the name of the Primary
Contact.
AOBORGN_MG_LOAD_ID VARCHAR2 9 YES This field specifies the supplying agencies ID Number
for the company being loaded
Date: 21-JUN-2004 Page: 149
TABLE: AOBSTMP
CREATOR: ALUMNI
Development Officer Search Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AOBSTMP_PIDM NUMBER 8 NO Internal Identification Number of the Development
Officer.
AOBSTMP_SRCH_PIDM NUMBER 8 NO Internal Identification Number of the person returned
by the search.
AOBSTMP_SORT_ID VARCHAR2 9 NO External Identification Number of the person returned
by the search.
AOBSTMP_SORT_NAME VARCHAR2 95 NO Upper case name in Last Name, First Name Middle Name
format.
AOBSTMP_FULL_NAME VARCHAR2 95 NO Mixed case name in Last Name, First Name Middle Name
format.
AOBSTMP_USER VARCHAR2 30 NO Oracle Userid of the person who created or last
updated this record.
AOBSTMP_ACTIVITY_DATE DATE 7 NO Date this record was created or last updated.
Date: 21-JUN-2004 Page: 150
TABLE: AOBWRUL
CREATOR: ALUMNI
Advancement Self-Service Rules Header Table, defines rules for Web processing.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AOBWRUL_ACTIVITY_DATE DATE 7 NO The date this record was added or last modified.
AOBWRUL_USER VARCHAR2 30 NO The User who added or last modified thhis record.
AOBWRUL_REQ_EMPL_STATUS_IND VARCHAR2 1 NO Require Employment Status Indicator, Y indicates that
Employment Status is required.
AOBWRUL_JOB_POST_REVIEW_IND VARCHAR2 1 NO Job Posting Reviewed Indicator, Y indicates that job
posting must be reviewed.
AOBWRUL_SOLC_CODE_DFLT VARCHAR2 8 YES Default Solicitation Code for pledge and gifts.
AOBWRUL_CTYP_ASSIGN_START DATE 7 YES The earliest assignment date that contacts should show
on the Web
AOBWRUL_CTYP_ASSIGN_END DATE 7 YES The latest assignment date that contacts should show
on the Web
AOBWRUL_PGVE_CODE_DFLT VARCHAR2 5 YES Default Pledge Gift Vehichle Code for pledges and
gifts.
AOBWRUL_PSTA_CODE_DFLT VARCHAR2 1 YES Default Pledge Status code for pledges.
AOBWRUL_XREF_CODE_DFLT VARCHAR2 3 YES The default cross reference code.
AOBWRUL_ATYP_CODE_HOME VARCHAR2 2 YES The Address Type which indicates Home addresses.
AOBWRUL_ATYP_CODE_SEAS VARCHAR2 2 YES The Address Type which indicates seasonal addresses.
AOBWRUL_IDEN_CODE_CONF VARCHAR2 5 YES The User ID of the person creating comments
AOBWRUL_SUBJ_CODE_CONF VARCHAR2 6 YES The Subject Code for comments entered via the Web.
AOBWRUL_ACTP_CODE_ADVS VARCHAR2 5 YES The default Activity Type code for career advisors.
AOBWRUL_PLDG_PAY_IND VARCHAR2 1 NO Require Online Pledge Payment Indicator, Y indicates
that it allows Online Payment.
AOBWRUL_GIFT_SPLIT_IND VARCHAR2 1 NO Require Gift Split Indicator, Y indicates that it
allows split gifts according to the split rule table.
AOBWRUL_EMPL_MATCH_IND VARCHAR2 1 NO Employer Match Indicator, Y indicates that the
Employer Match Information will show on the web page.
AOBWRUL_COMP_PLDG_IND VARCHAR2 1 NO Allow Web to satify (or complete) active pledges.
AOBWRUL_RECEIPT_IND VARCHAR2 1 NO Allow Web to display an on-line receipt.
AOBWRUL_PGVE_CODE_DFLT_GIFT VARCHAR2 5 YES Default Gift Vehicle Code.
AOBWRUL_GCLS_CODE_DFLT VARCHAR2 4 YES Default Gift Class Code.
AOBWRUL_EXP_MG_IND VARCHAR2 1 NO Allow Online Expexted Matching Gift Processing
Indicator, Y indicates that it allows Online Expexted
Matching Gift Processing.
AOBWRUL_GH_ALLOW_GIFTS VARCHAR2 1 YES giving history allow gifts display: this field
indicates that self-service Alumni users may view
their gift detail on the web.
AOBWRUL_GH_ALLOW_PLEDGES VARCHAR2 1 YES giving history allow pledges display: this field
indicates that self-service Alumni users may view
their pledge detail on the web.
AOBWRUL_GH_ALLOW_GIFT_PLEDGE VARCHAR2 1 YES giving history allow gifts and pledges display: this
field indicates that self-service Alumni users may
view their gift and pledge detail on the web.
AOBWRUL_GH_ALLOW_FISC VARCHAR2 1 YES giving history allow fiscal year display: this field
indicates that self-service Alumni users may view
their giving history by fiscal year on the web.
Date: 21-JUN-2004 Page: 151
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AOBWRUL_GH_ALLOW_CAMP_FISC VARCHAR2 1 YES giving history allow campaign and fiscal year display:
this field indicates that self-service Alumni users
may view their giving history by campaign and fiscal
year on the web.
AOBWRUL_GH_ALLOW_DESG_FISC VARCHAR2 1 YES giving history allow designation and fiscal year
display: this field indicates that self-service Alumni
users may view their giving history by designation and
fiscal year on the web.
AOBWRUL_GH_ALLOW_COMBINED VARCHAR2 1 YES giving history allow combined giving display: this
field indicates that self-service Alumni users may
view their combined giving history on the web.
AOBWRUL_GH_ALLOW_OVERALL VARCHAR2 1 YES giving history allow overall giving display: this
field indicates that self-service Alumni users may
view their overall giving history on the web.
AOBWRUL_GIFT_SOLC_CODE_DFLT VARCHAR2 8 YES default gift solicitation code: this field indicates
the solicitation code to be used for gifts received
via the web.
AOBWRUL_MOVES_DELETE_IND VARCHAR2 1 NO Prospect moves allow delete indcator: this field
indicates whether Prospect moves may be delete on the
web, Y=Yes, N=No.
AOBWRUL_PLDG_PRMD_CODE VARCHAR2 2 YES Default Pledge Header pledge reminder code; this field
will be stored on the agbwplg record when a pledge is
created via the web.
AOBWRUL_PINS_PRMD_CODE VARCHAR2 2 YES Default Pledge Installment pledge reminder code; this
field will be stored on the agrpins record when a
pledge with installments is created via the web.
AOBWRUL_GIFT_NOTIFY_USER_ID VARCHAR2 30 YES
AOBWRUL_FAX_TELE_CODE VARCHAR2 4 YES
Date: 21-JUN-2004 Page: 152
TABLE: AORCONT
CREATOR: ALUMNI
Organization Contact Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORCONT_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the organization.
AORCONT_SEQ_NO NUMBER 23 20 NO This field specifies the internal sequence number.
AORCONT_CONTACT_PIDM NUMBER 8 YES This field specifies the internal system generated
identification number for the secondary organizational
contact(s).
AORCONT_LAST_NAME VARCHAR2 25 YES This field specifies the organizational contacts last
name.
AORCONT_FIRST_NAME VARCHAR2 15 YES This field specifies the organizational contacts first
name.
AORCONT_MI VARCHAR2 1 YES This field specifies the organizational contacts
middle initial.
AORCONT_OCON_CODE VARCHAR2 3 YES This field specifies the type of organizational
contact.
AORCONT_JOBC_CODE VARCHAR2 3 YES This field specifies the job category of the
organizational contacts job title.
AORCONT_TITLE VARCHAR2 60 YES This field specifies the organizational contacts job
title.
AORCONT_ATYP_CODE VARCHAR2 2 YES This field specifies a particular address type for
each of the organizational contacts addresses.
AORCONT_ADDR_LINE1 VARCHAR2 30 YES This field specifies the first line of the
organizational contacts address.
AORCONT_ADDR_LINE2 VARCHAR2 30 YES This field specifies the second line of the
organizational contacts address.
AORCONT_ADDR_LINE3 VARCHAR2 30 YES This field specifies the third line of the
organizational contacts address.
AORCONT_ADDR_LINE4 VARCHAR2 30 YES This field specifies the fourth line of the
organizational contacts address.
AORCONT_ADDR_CITY VARCHAR2 20 YES This field specifies the city of the organizational
contacts address.
AORCONT_STAT_CODE_ADDR VARCHAR2 3 YES This field specifies the state of the organizational
contacts address.
AORCONT_ZIPC_CODE_ADDR VARCHAR2 10 YES This field specifies the zip code of the
organizational contacts address.
AORCONT_CNTY_CODE_ADDR VARCHAR2 5 YES This field specifies the county of the organizational
contacts address.
AORCONT_NATN_CODE_ADDR VARCHAR2 5 YES This field specifies the country of the organizational
contacts address.
AORCONT_PHONE_AREA VARCHAR2 3 YES This field specifies the area code of the
organizational contacts telephone number.
AORCONT_PHONE_NUMBER VARCHAR2 7 YES This field specifies the telephone number of the
organizational contact.
AORCONT_PHONE_EXT VARCHAR2 4 YES This field specifies the telephone extension of the
organizational contact.
Date: 21-JUN-2004 Page: 153
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORCONT_DATE DATE 7 YES This field specifies the date organizational contact
information was added or changed.
AORCONT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AORCONT_DELIVERY_POINT NUMBER 2 YES This field indicates the delivery point associated
with the address.
AORCONT_CORRECTION_DIGIT NUMBER 2 YES This field indicates the correction digit associated
with the address.
AORCONT_CARRIER_ROUTE VARCHAR2 4 YES This field indicates the carrier route associated with
the address.
AORCONT_CONT_ORG_IND VARCHAR2 1 YES This fields indicates whether the address type belongs
to the constitiuent or the organization.
AORCONT_NAME_PREFIX VARCHAR2 20 YES The prefix associated with the name of the Secondary
Contact.
AORCONT_NAME_SUFFIX VARCHAR2 20 YES The suffix associated with the name of the Secondary
Contact.
Date: 21-JUN-2004 Page: 154
TABLE: AORDOWP
CREATOR: ALUMNI
Development Officer Profile Preference Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORDOWP_PIDM NUMBER 8 NO Internal Identification Number of the Development
Officer.
AORDOWP_PROF_TYPE VARCHAR2 1 NO Profile type - C = Constituent, O = Organization, P =
Prospect.
AORDOWP_DOWP_CODE VARCHAR2 4 NO Development Officer Web Profile Preference Code - see
ATVDOWP.
AORDOWP_DISP_SEQ_NO NUMBER 2 NO Sequence number used to determine the display order of
the profile elements.
AORDOWP_LONG_IND VARCHAR2 1 NO Long Profile Indicator - Y (checked) indicates that
the item should appear.
AORDOWP_SHORT_IND VARCHAR2 1 NO Short Profile Indicator - Y (checked) indicates that
the item should appear.
AORDOWP_USER VARCHAR2 30 NO Oracle Userid of the person who created or last
updated this record.
AORDOWP_ACTIVITY_DATE DATE 7 NO Date this record was created or last updated.
Date: 21-JUN-2004 Page: 155
TABLE: AORFUND
CREATOR: ALUMNI
Organization Fund Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORFUND_PIDM NUMBER 8 NO Internal person/org identification number.
AORFUND_FUND_CODE VARCHAR2 6 NO This field specifies fund code.
AORFUND_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AORFUND_COMMENT VARCHAR2 60 YES This field specifies fund comment.
Date: 21-JUN-2004 Page: 156
TABLE: AORJPST
CREATOR: ALUMNI
Job Posting Repeating Table, stores job postings from Web users.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORJPST_EMPR_PIDM NUMBER 8 NO The Internal ID of the Employer.
AORJPST_TITLE VARCHAR2 60 NO The title of the job being posted.
AORJPST_USER VARCHAR2 30 NO The User ID of the person who created or last modified
the job posting record.
AORJPST_ACTIVITY_DATE DATE 7 NO The date the job posting was created or last modified.
AORJPST_SUBMIT_DATE DATE 7 NO The date the job posting was submitted.
AORJPST_ACPT_APPL_UNTIL DATE 7 NO The date until which applications will be accepted for
the job posting.
AORJPST_CONTACT_NAME VARCHAR2 60 NO Then name of the person to contact for the job
posting.
AORJPST_DESC VARCHAR2 2000 NO A description of the job offered by the job posting.
AORJPST_LOCATION VARCHAR2 30 NO The location of the job, city, state, etc.
AORJPST_DISP_WEB_IND VARCHAR2 1 NO Display on the Web Indicator, Y indicates this posting
can be displayed.
AORJPST_CONTACT_EMAIL VARCHAR2 60 YES The E-mail address of the contact person for the job
posting.
AORJPST_REVIEWED_IND VARCHAR2 1 YES Reviewed Indicator, Y indicates that the job posting
has been reviewed and approved.
AORJPST_REVIEWED_USER VARCHAR2 30 YES The User who reviewed and approved the job posting.
AORJPST_EMPL_PIDM NUMBER 8 YES The Internal ID of the Web User who posted the job.
AORJPST_EMPR_URL VARCHAR2 120 YES The URL for the Web site of the Employer.
AORJPST_STREET_LINE1 VARCHAR2 30 YES The first line of the street address of the Employer.
AORJPST_STREET_LINE2 VARCHAR2 30 YES The second line of the street address of the Employer.
AORJPST_STREET_LINE3 VARCHAR2 30 YES The third line of the street address of the Employer.
AORJPST_CITY VARCHAR2 20 YES The city of the addess of the Employer.
AORJPST_STAT_CODE VARCHAR2 3 YES The state or province of the addess of the Employer.
AORJPST_ZIP VARCHAR2 10 YES The zip or postal code of the addess of the Employer.
AORJPST_NATN_CODE VARCHAR2 5 YES The nation of the addess of the Employer.
AORJPST_PHONE_AREA VARCHAR2 3 YES The area code of the phone number of the Employer.
AORJPST_PHONE_NUMBER VARCHAR2 7 YES The Phone number of the Employer.
AORJPST_PHONE_EXT VARCHAR2 4 YES The extension of the phone number of the Employer.
AORJPST_FAX_AREA VARCHAR2 3 YES The area code of the FAX number of the Employer.
AORJPST_FAX_NUMBER VARCHAR2 7 YES The FAX number of the Employer.
AORJPST_JOBC_CODE_1 VARCHAR2 3 YES The first SICC job code associated with the job
posting.
AORJPST_JOBC_CODE_2 VARCHAR2 3 YES The second SICC job code associated with the job
posting.
AORJPST_JOBC_CODE_3 VARCHAR2 3 YES The third SICC job code associated with the job
posting.
AORJPST_REQMNT CLOB 4000 NO Free form comments about the job posting.
Date: 21-JUN-2004 Page: 157
TABLE: AORMACC
CREATOR: ALUMNI
Matching Gift Institution Accreditation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMACC_PIDM NUMBER 8 NO Organization internal identification number.
AORMACC_MACC_CODE VARCHAR2 1 NO Organization institution accreditation code.
AORMACC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 158
TABLE: AORMAST
CREATOR: ALUMNI
Matching Gift Advancement Status Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMAST_PIDM NUMBER 8 NO Organization internal identification number.
AORMAST_MAST_CODE VARCHAR2 1 NO MG Alumni status code.
AORMAST_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AORMAST_ATTEND_YEARS NUMBER 2 YES Required number of years in attendance.
Date: 21-JUN-2004 Page: 159
TABLE: AORMCTL
CREATOR: ALUMNI
Matching Gift Institution Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMCTL_PIDM NUMBER 8 NO Organization internal identification number.
AORMCTL_MCTL_CODE VARCHAR2 1 NO Organization institution control code.
AORMCTL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 160
TABLE: AORMDEF
CREATOR: ALUMNI
Matching Gift Deferred Gift Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMDEF_PIDM NUMBER 8 NO Organization internal identification number.
AORMDEF_MDEF_CODE VARCHAR2 1 NO MG deferred gift code.
AORMDEF_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 161
TABLE: AORMEDU
CREATOR: ALUMNI
Matching Gift Education Institute Types for an Orgainzation.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMEDU_PIDM NUMBER 8 NO The Internal ID of the Organization.
AORMEDU_MEDU_CODE VARCHAR2 1 NO The Matching Gift Education Institute Type assigned to
this Organization
AORMEDU_USER VARCHAR2 30 NO The User ID of the person who created or last modified
this record.
AORMEDU_ACTIVITY_DATE DATE 7 NO The date this record was created or last modified.
Date: 21-JUN-2004 Page: 162
TABLE: AORMERQ
CREATOR: ALUMNI
Matching Gift Employment Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMERQ_PIDM NUMBER 8 NO Organization internal identification number.
AORMERQ_MERQ_CODE VARCHAR2 1 NO Employment matching gift requirement code.
AORMERQ_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AORMERQ_TIME_REQ NUMBER 5 2 YES Time requirement for matching gift quailifcation.
Hours for parttime, months for consecutive service.
Date: 21-JUN-2004 Page: 163
TABLE: AORMGCD
CREATOR: ALUMNI
Matching Gift Campaign/Designation Ratio Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMGCD_PIDM NUMBER 8 NO Organization internal identification number.
AORMGCD_CAMPAIGN VARCHAR2 5 NO Campaign to which the matching gift and employee memo
credit will be credited.
AORMGCD_DESG VARCHAR2 10 NO Designation to which the matching gift and employee
memo credit will be credited.
AORMGCD_PERCENT NUMBER 5 2 NO Percent of match amount for the corresponding campaign
and designation.
AORMGCD_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 164
TABLE: AORMGCM
CREATOR: ALUMNI
Matching Gift Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMGCM_PIDM NUMBER 8 NO Internal Identification number for organization.
AORMGCM_SEQ_NO NUMBER 9 2 NO Comment sequence number.
AORMGCM_COMMENT VARCHAR2 2000 NO Comment text.
AORMGCM_ACTIVITY_DATE DATE 7 NO System generated date that is updated on insert or
update.
Date: 21-JUN-2004 Page: 165
TABLE: AORMIND
CREATOR: ALUMNI
Matching Gift Industry Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMIND_PIDM NUMBER 8 NO Organization internal identification number.
AORMIND_MIND_CODE VARCHAR2 1 NO MG industry code.
AORMIND_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 166
TABLE: AORMLOC
CREATOR: ALUMNI
Matching Gift Institution Location Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMLOC_PIDM NUMBER 8 NO Organization internal identification number.
AORMLOC_MLOC_CODE VARCHAR2 1 NO Organization institution location code.
AORMLOC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 167
TABLE: AORMLVL
CREATOR: ALUMNI
Matching Gift Level of Institution Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMLVL_PIDM NUMBER 8 NO Organization internal identification number.
AORMLVL_MLVL_CODE VARCHAR2 1 NO Organization level of institution code.
AORMLVL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 168
TABLE: AORMNAT
CREATOR: ALUMNI
Matching Gift National Associations Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMNAT_PIDM NUMBER 8 NO Organization internal identification number.
AORMNAT_MNAT_CODE VARCHAR2 1 NO MG National association code.
AORMNAT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 169
TABLE: AORMNED
CREATOR: ALUMNI
Matching Gift Non-educational Institution Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMNED_PIDM NUMBER 8 NO Organization internal identification number.
AORMNED_MNED_CODE VARCHAR2 3 NO Organization non-educational institution code.
AORMNED_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 170
TABLE: AORMPRO
CREATOR: ALUMNI
Matching Gift Procedure Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMPRO_PIDM NUMBER 8 NO Organization internal identification number.
AORMPRO_MPRO_CODE VARCHAR2 1 NO Matching gift related procedure code.
AORMPRO_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 171
TABLE: AORMPUR
CREATOR: ALUMNI
Matching Gift Related Purpose Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMPUR_PIDM NUMBER 8 NO Organization internal identification number.
AORMPUR_MPUR_CODE VARCHAR2 1 NO MG related purpose code.
AORMPUR_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 172
TABLE: AORMRTO
CREATOR: ALUMNI
Matching Gift Campaign/Designation Ratio Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
AORMRTO_PIDM NUMBER 8 NO Organization internal identification number.
AORMRTO_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
AORMRTO_PERCENT NUMBER 5 2 YES Percent of the qualifying amount of the gift that
falls in between the range specified.
AORMRTO_BEG_AMT NUMBER 13 2 YES Beginning range amount for specified percentage.
AORMRTO_END_AMT NUMBER 13 2 YES Ending range amount for percentage.
Date: 21-JUN-2004 Page: 173
TABLE: APBCONS
CREATOR: ALUMNI
Constituent Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APBCONS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number of the constituent.
APBCONS_PREF_LAST_NAME VARCHAR2 25 YES This field specifies the preferred last name of the
constituent.
APBCONS_PREF_FIRST_NAME VARCHAR2 15 YES This field specifies the preferred first name of the
constituent.
APBCONS_PREF_MI VARCHAR2 1 YES This field specifies the preferred middle initial of
the constituent.
APBCONS_NICKNAME VARCHAR2 40 YES This field specifies the nickname used by the
constituent.
APBCONS_GRAD_NAME VARCHAR2 60 YES This field specifies the constituents name at the time
of college graduation.
APBCONS_PARENTS_NAME VARCHAR2 50 YES This field specifies the name of the constituents
parents.
APBCONS_MAIDEN_LAST_NAME VARCHAR2 25 YES This field specifies the constituents maiden name.
APBCONS_PREF_CLAS VARCHAR2 4 NO This field specifies the year in which the constituent
received the first degree or the year of expected
graduation if the first degree has not yet been
earned.
APBCONS_COLL_CODE_PREF VARCHAR2 2 YES This field specifies the college within the
institution with which the constituent prefers to be
associated.
APBCONS_HOME_CITY VARCHAR2 20 YES This field specifies the constituents hometown.
APBCONS_STAT_CODE_HOME VARCHAR2 3 YES This field specifies the state of the constituents
hometown.
APBCONS_NATN_CODE_HOME VARCHAR2 5 YES This field specifies the country of the constituents
hometown.
APBCONS_CM_NAME VARCHAR2 50 YES This field specifies the combined mailing name for the
constituent.
APBCONS_ATYP_CODE_CM VARCHAR2 2 YES This field specifies the address type to be used for
the combined mailing.
APBCONS_DOTT_CODE VARCHAR2 4 YES This field specifies the constituents occupational
title.
APBCONS_INCM_CODE VARCHAR2 2 YES This field specifies the constituents income level.
APBCONS_ATYP_CODE_PREF VARCHAR2 2 YES This field specifies the constituents preferred
address for solicitations and acknowledgements.
APBCONS_ADDR_NAME VARCHAR2 35 YES This field specifies the name to be used with the
preferred address type.
APBCONS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or last updated.
APBCONS_ATYP_CODE_GEOR VARCHAR2 2 YES This field specifes the address type of the address to
be used as the preferred geographic region address.
APBCONS_SOCIETY_NAME VARCHAR2 60 YES Gift Society name. This name will default to gift
societies when they memberships are created. The name
may be modified on the society form.
Date: 21-JUN-2004 Page: 174
TABLE: APBCTRL
CREATOR: ALUMNI
Constituent Comment Supervisor Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APBCTRL_USER_ID VARCHAR2 30 NO Constituent Comment Supervisor User ID.
APBCTRL_USER VARCHAR2 30 NO This system maintained field specifies the user that
created or updated the record.
APBCTRL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 175
TABLE: APBGHIS
CREATOR: ALUMNI
Giving History Summary Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APBGHIS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APBGHIS_LAST_GIFT_NO VARCHAR2 7 YES This field specifies the gift number of the
constituents most recent gift.
APBGHIS_LAST_GIFT_AMT NUMBER 11 2 YES This field specifies the amount of the constituents
most recent gift.
APBGHIS_LAST_GIFT_DATE DATE 7 YES This field specifies the date of the constituents most
recent gift.
APBGHIS_FISC_CODE_LAST_GIFT NUMBER 4 YES This field specifies the fiscal year of the
constituents most recent gift.
APBGHIS_LAST_GIFT_CAMPAIGN VARCHAR2 5 YES As of Rel 1.6 (Jan. 92), this field is no longer
used.
APBGHIS_LAST_GIFT_DESG VARCHAR2 10 YES As of Rel 1.6 (Jan. 92), this field is no longer
used.
APBGHIS_HIGH_GIFT_NO VARCHAR2 7 YES This field specifies the gift number of the largest
single gift ever received from the constituent.
APBGHIS_HIGH_GIFT_AMT NUMBER 11 2 YES This field specifies the amount of the largest single
gift ever received from the constituent.
APBGHIS_HIGH_GIFT_DATE DATE 7 YES This field specifies the date of the largest single
gift ever received from the constituent.
APBGHIS_FISC_CODE_HIGH_GIFT NUMBER 4 YES This field specifies the fiscal year of the largest
single gift ever received from the constituent.
APBGHIS_HIGH_GIFT_CAMPAIGN VARCHAR2 5 YES As of Rel 1.6 (Jan. 92), this field is no longer
used.
APBGHIS_HIGH_GIFT_DESG VARCHAR2 10 YES As of Rel 1.6 (Jan. 92), this field is no longer
used.
APBGHIS_TOTAL_NO_GIFTS NUMBER 5 YES This field specifies the total number of gifts and
pledge payments received in the constituents entire
giving history.
APBGHIS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or last updated.
Date: 21-JUN-2004 Page: 176
TABLE: APBWIDN
CREATOR: ALUMNI
Web Access Base Record Hold Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APBWIDN_ID VARCHAR2 9 NO Web ID created by a user not found in Banner.
APBWIDN_PIN VARCHAR2 6 NO Personal Identification Number selected by the Web
user.
APBWIDN_ACTIVITY_DATE DATE 7 NO Date record created or updated.
APBWIDN_USER VARCHAR2 30 NO User who created or changed the record.
APBWIDN_ACCEPTED_IND VARCHAR2 1 NO Accepted Indicator, Y = Accepted, N = not Accepted.
APBWIDN_QUESTION VARCHAR2 90 YES Security Question created by user with no Banner PIDM.
APBWIDN_ANSWER VARCHAR2 30 YES Answer to Security Question created by user with no
Banner PIDM.
APBWIDN_PIDM NUMBER 8 YES Internal ID of person in Banner.
APBWIDN_LAST_NAME VARCHAR2 60 YES Last Name of user with no Banner PIDM.
APBWIDN_FIRST_NAME VARCHAR2 15 YES First Name of user with no Banner PIDM.
APBWIDN_MI VARCHAR2 15 YES Middle Name of user with no Banner PIDM.
APBWIDN_MAIDEN_NAME VARCHAR2 60 YES Maiden Name of user with no Banner PIDM.
APBWIDN_NAME_PREFIX VARCHAR2 20 YES Name prefix of user with no Banner PIDM.
APBWIDN_NAME_SUFFIX VARCHAR2 20 YES Name suffix of user with no Banner PIDM.
APBWIDN_BIRTH_DATE DATE 7 YES Birth Date of user with no Banner PIDM.
APBWIDN_SEX VARCHAR2 1 YES Gender of user with no Banner PIDM.
APBWIDN_ATYP_CODE VARCHAR2 2 YES Address Type of user with no Banner PIDM.
APBWIDN_STREET_LINE1 VARCHAR2 30 YES Street Line 1 of user with no Banner PIDM.
APBWIDN_STREET_LINE2 VARCHAR2 30 YES Street Line 2 of user with no Banner PIDM.
APBWIDN_STREET_LINE3 VARCHAR2 30 YES Street Line 3 of user with no Banner PIDM.
APBWIDN_CITY VARCHAR2 20 YES Address City of user with no Banner PIDM.
APBWIDN_STAT_CODE VARCHAR2 3 YES Address State of user with no Banner PIDM.
APBWIDN_ZIP VARCHAR2 10 YES Address Zip/Postal Code of user with no Banner PIDM.
APBWIDN_CNTY_CODE VARCHAR2 5 YES Address County of user with no Banner PIDM.
APBWIDN_NATN_CODE VARCHAR2 5 YES Address Nation of user with no Banner PIDM.
APBWIDN_TELE_CODE VARCHAR2 4 YES Telephone Type of user with no Banner PIDM.
APBWIDN_PHONE_AREA VARCHAR2 3 YES Phone Number Area Code of user with no Banner PIDM.
APBWIDN_PHONE_NUMBER VARCHAR2 7 YES Phone Number of user with no Banner PIDM.
APBWIDN_PHONE_EXT VARCHAR2 4 YES Phone Number Extension of user with no Banner PIDM.
APBWIDN_INTL_ACCESS VARCHAR2 16 YES Internation Access Code of Phone Number of user with
no Banner PIDM.
APBWIDN_UNLIST_IND VARCHAR2 1 YES Unlisted Indicator of Phone Number of user with no
Banner PIDM.
APBWIDN_FAX_TELE_CODE VARCHAR2 4 YES FAX Telephone Type of user with no Banner PIDM.
APBWIDN_FAX_AREA VARCHAR2 3 YES FAX Area Code of user with no Banner PIDM.
APBWIDN_FAX_NUMBER VARCHAR2 7 YES FAX Phone Number of user with no Banner PIDM.
APBWIDN_FAX_INTL_ACCESS VARCHAR2 16 YES Internation Access Code of Fax Number of user with no
Banner PIDM.
APBWIDN_FAX_UNLIST_IND VARCHAR2 1 YES Unlisted Indicator of Fax Number of user with no
Banner PIDM.
APBWIDN_EMAIL_ADDRESS VARCHAR2 90 YES Email Address of user with no Banner PIDM.
APBWIDN_EMAL_CODE VARCHAR2 4 YES Email Code of user with no Banner PIDM.
Date: 21-JUN-2004 Page: 177
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APBWIDN_SPS_LAST_NAME VARCHAR2 60 YES Spouse Last Name of user with no Banner PIDM.
APBWIDN_SPS_FIRST_NAME VARCHAR2 15 YES Spouse First Name of user with no Banner PIDM.
APBWIDN_SPS_MI VARCHAR2 15 YES Spouse Middle Name of user with no Banner PIDM.
APBWIDN_PREF_CLAS VARCHAR2 4 YES Preferred class of user with no Banner PIDM.
APBWIDN_PREF_COLL VARCHAR2 2 YES
APBWIDN_DONR_CODE VARCHAR2 4 YES Donor Code of user with no Banner PIDM.
APBWIDN_LAST_LOGIN_DATE DATE 7 YES Date user with no Banner PIDM last logged into the
web.
Date: 21-JUN-2004 Page: 178
TABLE: APBWSES
CREATOR: ALUMNI
Advancement Self-Service Session Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APBWSES_PIDM NUMBER 8 NO The internal ID of the Web User.
APBWSES_ACTIVITY_DATE DATE 7 NO The date the record was created or last modified.
APBWSES_USER VARCHAR2 30 NO The User Id of the person who created or last modified
the record.
APBWSES_INTERESTS_VIEWED DATE 7 YES The date and time that Areas of Interest were last
viewed.
Date: 21-JUN-2004 Page: 179
TABLE: APRACLD
CREATOR: ALUMNI
Activity Leadership Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRACLD_PIDM NUMBER 8 NO This field specifies the internal generated
identification number.
APRACLD_LEAD_CODE VARCHAR2 5 NO This field specifies the leadership code.
APRACLD_ACTC_CODE VARCHAR2 8 NO This field specifies the special activity code.
APRACLD_SEQNO NUMBER 23 20 NO This field specifies the unique sequence number for
activity code.
APRACLD_ACTIVITY_DATE DATE 7 NO This field specifies the system default date for
inserting and updating records.
APRACLD_BEGIN_DATE DATE 7 YES This field specifies the begin date of the leadership
code.
APRACLD_END_DATE DATE 7 YES This field specifies the end date of the leadership
code.
APRACLD_LEAD_DESC VARCHAR2 30 NO This field is used to change or update leadership
description that has been created on the validation
table.
APRACLD_COMMENT VARCHAR2 60 YES This field is used to store unformatted text for the
leadership code.
Date: 21-JUN-2004 Page: 180
TABLE: APRACTY
CREATOR: ALUMNI
Special Activity Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRACTY_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRACTY_SACT_CODE VARCHAR2 3 YES This column is no longer used Rel 1.2
APRACTY_COMMENT VARCHAR2 60 YES This field specifies free-form comments which further
defines the constituents activities.
APRACTY_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRACTY_ACTC_CODE VARCHAR2 8 NO The ACTC code replaced the SACT code in Rel 1.2 using
the STVACTC Student Activity Validation Form.
Date: 21-JUN-2004 Page: 181
TABLE: APRACYR
CREATOR: ALUMNI
Special Activity Year Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRACYR_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRACYR_SACT_CODE VARCHAR2 3 YES This column is no longer used Rel 1.2
APRACYR_YEAR NUMBER 4 NO This field specifies the year(s) associated with a
particular special activity.
APRACYR_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRACYR_ACTC_CODE VARCHAR2 8 NO The ACTC code replaced the SACT code in Rel 1.2 using
the STVACTC student validation form.
Date: 21-JUN-2004 Page: 182
TABLE: APRADEG
CREATOR: ALUMNI
Academic Degree Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRADEG_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRADEG_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number.
APRADEG_SBGI_CODE VARCHAR2 6 YES This field specifies the institution at which the
constituent earned the degree.
APRADEG_DEGC_CODE VARCHAR2 6 YES This field spsecifies the type of degree earned by the
constituent.
APRADEG_DATE DATE 7 YES This field specifies the date the degree was awarded
to the constituent.
APRADEG_HONR_CODE VARCHAR2 6 YES This field specifies the honors the constituent
received with the associated degree.
APRADEG_COLL_CODE VARCHAR2 2 YES This field specifies the college that awarded the
associated degree to the constituent.
APRADEG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
file was created or updated.
APRADEG_ACYR_CODE VARCHAR2 4 YES The Academic Year Code associated with this degree.
APRADEG_ACYR_CODE_BULLETIN VARCHAR2 4 YES The Academic Year Bulletin Code associated with this
degree.
APRADEG_CAMP_CODE VARCHAR2 3 YES The campus associated with this degree.
APRADEG_DEPT_CODE VARCHAR2 4 YES The first department associated with this degree.
APRADEG_COMMENTS VARCHAR2 2000 YES Free form text comments about this degree.
APRADEG_MAJR_CODE_MINR_1 VARCHAR2 4 YES The first Minor code associated with this degree.
APRADEG_MAJR_CODE_MINR_2 VARCHAR2 4 YES The second Minor code associated with this degree.
APRADEG_MAJR_CODE_CONC_1 VARCHAR2 4 YES The first Concentration Code assosiated with this
degree.
APRADEG_MAJR_CODE_CONC_2 VARCHAR2 4 YES The second Concentration Code assosiated with this
degree.
APRADEG_MAJR_CODE_CONC_3 VARCHAR2 4 YES The third Concentration Code assosiated with this
degree.
APRADEG_MAJR_CODE_CONC_4 VARCHAR2 4 YES The fourth Concentration Code assosiated with this
degree.
APRADEG_MAJR_CODE_CONC_5 VARCHAR2 4 YES The fifth Concentration Code assosiated with this
degree.
APRADEG_MAJR_CODE_CONC_6 VARCHAR2 4 YES The sixth Concentration Code assosiated with this
degree.
APRADEG_DEPT_CODE_2 VARCHAR2 4 YES The second department associated with this degree.
APRADEG_HONR_CODE_2 VARCHAR2 6 YES This field specifies the honors the constituent
received with the associated degree.
APRADEG_HONR_CODE_3 VARCHAR2 6 YES This field specifies the honors the constituent
received with the associated degree.
APRADEG_HONR_CODE_4 VARCHAR2 6 YES This field specifies the honors the constituent
received with the associated degree.
APRADEG_HONR_CODE_5 VARCHAR2 6 YES This field specifies the honors the constituent
received with the associated degree.
Date: 21-JUN-2004 Page: 183
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRADEG_HOND_CODE_1 VARCHAR2 6 YES This field specifies the departmental honors the
constituent received with the associated degree.
APRADEG_HOND_CODE_2 VARCHAR2 6 YES This field specifies the departmental honors the
constituent received with the associated degree.
APRADEG_HOND_CODE_3 VARCHAR2 6 YES This field specifies the departmental honors the
constituent received with the associated degree.
APRADEG_HOND_CODE_4 VARCHAR2 6 YES This field specifies the departmental honors the
constituent received with the associated degree.
APRADEG_HOND_CODE_5 VARCHAR2 6 YES This field specifies the departmental honors the
constituent received with the associated degree.
APRADEG_OK_FOR_NOTES_IND VARCHAR2 1 YES OK for Notes Indicator, Y indicates that this degree
can be used in Class Notes.
APRADEG_DISP_NOTES_IND VARCHAR2 1 YES Displayed in Notes Indicator, Y indicates that this
degree was displaeyd in Class Notes.
APRADEG_DISP_NOTES_DATE DATE 7 YES The date that this degree was displayed in Class
Notes.
APRADEG_USER VARCHAR2 30 NO The User ID of the person who created or last modified
this degree record.
APRADEG_REVIEWED_IND VARCHAR2 1 YES Reviewed Indicator, Y indicates that this degree has
been reviewed and accepted.
APRADEG_REVIEWED_USER VARCHAR2 30 YES The User ID of the person who reviewed and accepted
this degree.
APRADEG_MAJOR_COMMENT VARCHAR2 60 YES Free form text comments about this degree.
Date: 21-JUN-2004 Page: 184
TABLE: APRAMAJ
CREATOR: ALUMNI
Academic Major Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRAMAJ_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRAMAJ_ADEG_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number.
APRAMAJ_MAJR_CODE VARCHAR2 4 NO This field specifies the constituents major area(s) of
study.
APRAMAJ_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 185
TABLE: APRCATG
CREATOR: ALUMNI
Alumni Category Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCATG_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRCATG_DONR_CODE VARCHAR2 4 NO This field specifies the constituents donor
classification(s). This field allows the institution
to classify a constituent in multiple categories.
APRCATG_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the dates this
record was created or updated.
Date: 21-JUN-2004 Page: 186
TABLE: APRCCMT
CREATOR: ALUMNI
Children Comment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCCMT_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRCCMT_CHLD_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number for
the constituents children.
APRCCMT_SEQ_NO NUMBER 23 20 NO This field specifies the internal sequence number for
the comments associated with a constituents child.
APRCCMT_COMMENT VARCHAR2 60 NO This field specifies the free-form comments associated
with a constituents child.
APRCCMT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 187
TABLE: APRCHIS
CREATOR: ALUMNI
Giving History By Campaign Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCHIS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRCHIS_CAMPAIGN VARCHAR2 5 NO This field specifies the campaign(s) the constituent
has responded to with a gift or pledge payment.
APRCHIS_FISC_CODE NUMBER 4 NO This field specifies the fiscal year associated with
the campaign.
APRCHIS_AMT_PLEDGED NUMBER 13 2 YES This field specifies the amount the constituent
pledged to a specific campaign.
APRCHIS_AMT_PLEDGED_PAID NUMBER 13 2 YES This field specifies the amount of pledge payments
received from the constituent for a specific campaign.
APRCHIS_AMT_GIFT NUMBER 13 2 YES This field specifies the amount of gift money received
from the constituent for a specific campaign.
APRCHIS_AMT_MEMO NUMBER 13 2 YES This field specifies the dollar amount of memo credit
(soft dollars) the constituent has been credited with
for a specific campaign.
APRCHIS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 188
TABLE: APRCHLD
CREATOR: ALUMNI
Children Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCHLD_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRCHLD_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number.
APRCHLD_LAST_NAME VARCHAR2 25 YES This field specifies the last name of the constituents
child.
APRCHLD_FIRST_NAME VARCHAR2 15 YES This field specifies the first name of the
constituents child.
APRCHLD_MI VARCHAR2 1 YES This field specifies the middle initial of the
constituents child.
APRCHLD_SEX VARCHAR2 1 YES This field specifies the gender of the constituents
child.
APRCHLD_BIRTH_DATE DATE 7 YES This field specifies the date of birth of the
constituents child.
APRCHLD_SSN VARCHAR2 9 YES This field specifies the social security number of the
constituents child.
APRCHLD_ATYP_CODE VARCHAR2 2 YES This field specifies the constituent address type to
used when corresponding with the constituents child.
APRCHLD_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRCHLD_XREF_CODE VARCHAR2 3 YES This field is used to identify the cross reference
record created for the constituent and child
relationship.
APRCHLD_CHLD_PIDM NUMBER 8 YES This field is internal identification number for the
child. This is an optional field and is only used for
children that have id on the system.
APRCHLD_DISP_WEB_IND VARCHAR2 1 YES Display on the Web Indicator, Y indicates that this
child may be displayed on the Web.
APRCHLD_DECEASED_IND VARCHAR2 1 YES Deceased Indicator, Y indicates the this child is
deceased.
APRCHLD_DECEASED_DATE DATE 7 YES This id the date the child became deceased.
APRCHLD_OK_FOR_NOTES_IND VARCHAR2 1 YES OK for Note Indicator, Y indicates that it is OK to
use this child in Class Notes.
APRCHLD_DISP_NOTES_IND VARCHAR2 1 YES Displayed in Notes Indicator, Y indicates that this
child has been used in Class Notes.
APRCHLD_DISP_NOTES_DATE DATE 7 YES The date that this child was used in Class Notes.
APRCHLD_USER VARCHAR2 30 NO The User ID of the person who created or last modified
the child record.
APRCHLD_REVIEWED_IND VARCHAR2 1 YES Reviewed Indicator, Y indicates that this child has
been reviewed and accepted.
APRCHLD_REVIEWED_USER VARCHAR2 30 YES The User ID of the person who reviewed and accepted
this child.
APRCHLD_COMMENT LONG YES Free form text comment for this child.
Date: 21-JUN-2004 Page: 189
TABLE: APRCOMT
CREATOR: ALUMNI
Constituent Comment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCOMT_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRCOMT_SEQ_NO NUMBER 23 20 NO This field specifies the internal sequence number.
APRCOMT_COMMENT VARCHAR2 60 NO This field specifies the free-form comments associated
with the constituent.
APRCOMT_CONF_IND VARCHAR2 1 YES This field specifies that the constituents name and
address data will not be released.
APRCOMT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 190
TABLE: APRCONF
CREATOR: ALUMNI
Solicitor Contacts Results repeating table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCONF_PIDM NUMBER 8 NO Internal person/org identification number.
APRCONF_IDEN_CODE VARCHAR2 5 NO This field specifies identification code.
APRCONF_USER_ID VARCHAR2 30 NO This system maintained field specifies the user that
created or updated the record.
APRCONF_GRP_SEQ_NO NUMBER 15 NO This field specifies internal generated number for
group.
APRCONF_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRCONF_ENTRY_DATE DATE 7 NO This field specifies the entry date the
confidentiality information was entered.
APRCONF_CONFID_IND VARCHAR2 1 YES This field specifies if confidentiality is set.
APRCONF_USER VARCHAR2 30 NO The User ID of the person who created or last modified
the comment record.
APRCONF_COMMENT LONG YES Free form text comment.
APRCONF_OK_FOR_NOTES_IND VARCHAR2 1 YES OK for Note Indicator, Y indicates that it is OK to
use this comment in Class Notes.
APRCONF_DISP_NOTES_IND VARCHAR2 1 YES Displayed in Notes Indicator, Y indicates that this
comment has been used in Class Notes.
APRCONF_DISP_NOTES_DATE DATE 7 YES The date that this comment was used in Class Notes.
APRCONF_REVIEWED_IND VARCHAR2 1 YES Reviewed Indicator, Y indicates that this comment has
been reviewed and accepted.
APRCONF_REVIEWED_USER VARCHAR2 30 YES The User ID of the person who reviewed and accepted
this comment.
Date: 21-JUN-2004 Page: 191
TABLE: APRCRVW
CREATOR: ALUMNI
Child data load table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCRVW_PIDM NUMBER 8 NO
APRCRVW_DSRC_CODE VARCHAR2 10 NO
APRCRVW_LOAD_DATE DATE 7 NO
APRCRVW_ACCEPTED_IND VARCHAR2 1 NO
APRCRVW_ACTIVITY_DATE DATE 7 NO
APRCRVW_USER VARCHAR2 30 NO
APRCRVW_SEQ_NO NUMBER 2 NO
APRCRVW_SOURCE_DATE DATE 7 NO
APRCRVW_LAST_NAME VARCHAR2 25 YES
APRCRVW_FIRST_NAME VARCHAR2 15 YES
APRCRVW_MI VARCHAR2 1 YES
APRCRVW_SEX VARCHAR2 1 YES
APRCRVW_BIRTH_DATE DATE 7 YES
APRCRVW_SSN VARCHAR2 9 YES
APRCRVW_ATYP_CODE VARCHAR2 2 YES
APRCRVW_XREF_CODE VARCHAR2 3 YES
APRCRVW_CHLD_PIDM NUMBER 8 YES
APRCRVW_DISP_WEB_IND VARCHAR2 1 YES
APRCRVW_DECEASED_IND VARCHAR2 1 YES
APRCRVW_DECEASED_DATE DATE 7 YES
APRCRVW_OK_FOR_NOTES_IND VARCHAR2 1 YES
APRCRVW_OTHR_PIDM NUMBER 8 YES
APRCRVW_OTHR_XREF_CODE VARCHAR2 3 YES
APRCRVW_COMMENT LONG YES
Date: 21-JUN-2004 Page: 192
TABLE: APRCSPS
CREATOR: ALUMNI
Constituent Spouse Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCSPS_PIDM NUMBER 8 NO This is the internal identification number of the
constituent who is associated with the spouse.
APRCSPS_MARS_IND VARCHAR2 1 NO This field is the marriage status indicator. Valid
values are A for active and I for inactive. Each
constituent is allowed only one spouse record with a
marriage status of A.
APRCSPS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRCSPS_SPS_PIDM NUMBER 8 YES This field is the internal identification number of
the spouse of the constituent. This field is optional
and is populated only if the spouse has an id in
BANNER.
APRCSPS_LAST_NAME VARCHAR2 60 YES This field is the last name of the spouse. It will be
stored only if the spouse does not have a BANNER id
number. If the spouse does have an id, the name will
display from the identification form, SPAIDEN or
APAIDEN.
APRCSPS_FIRST_NAME VARCHAR2 15 YES This field is the first name of the spouse. It will
be stored only if the spouse does not have a BANNER id
number. If the spouse does have an id, the name will
display from the identification form, SPAIDEN or
APAIDEN.
APRCSPS_MAIDEN_NAME VARCHAR2 60 YES This field is the maiden name of the spouse. It will
be stored only if the spouse does not have a BANNER id
number. If the spouse does have an id, the name will
display from the person form, SPAPERS or APAPERS.
APRCSPS_NAME_PREFIX VARCHAR2 20 YES This field is the spouses prefix. It will be stored
only if the spouse does not have a BANNER id number.
If the spouse does have an id, the data will display
from the person form, SPAPERS or APAPERS.
APRCSPS_NAME_SUFFIX VARCHAR2 20 YES This field is the spouses suffix. It will be stored
only if the spouse does not have a BANNER id number.
If the spouse does have an id, the data will display
from the person form, SPAPERS or APAPERS.
APRCSPS_BIRTH_DATE DATE 7 YES This field is the spouses birth date. It will be
stored only if the spouse does not have a BANNER id
number. If the spouse does have an id, the data will
display from the person form, SPAPERS or APAPERS.
APRCSPS_SPS_COMMENT VARCHAR2 60 YES This field contains comments about the spouse.
APRCSPS_MRTL_CODE VARCHAR2 1 YES This field is the spouses marital status. It will be
stored only if the spouse does not have a BANNER id
number. If the spouse does have an id, the data will
display from the person form, SPAPERS or APAPERS.
APRCSPS_MRTL_START_DATE DATE 7 YES This field is the start date of the marriage.
APRCSPS_MRTL_END_DATE DATE 7 YES This field is the end date of the marriage. It will
default to the current date when an inactive status is
entered. It is blank for active marriages.
Date: 21-JUN-2004 Page: 193
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRCSPS_DEAD_IND VARCHAR2 1 YES This field is the deceased indicator of the spouse.
It will be stored only if the spouse does not have a
BANNER id number. If the spouse does have an id, the
data will display from the person form, SPAPERS or
APAPERS.
APRCSPS_DEAD_DATE DATE 7 YES This field is the deceased date of the spouse. It
will be stored only if the spouse does not have a
BANNER id number. If the spouse does have an id, the
data will display from the person form, SPAPERS or
APAPERS.
APRCSPS_XREF_CODE VARCHAR2 3 YES Code used to create cross reference for the spouse on
the APAXREF form. Spouse indiciator on ATVXREF table
must by Y for marriage status of A, and N for marriage
status of I.
APRCSPS_MI VARCHAR2 15 YES Spouse middle name. It will be stored on aprcsps if
the spouse does not have a BANNER Id. If the spouse
does have an Id, the name be stored on spriden.
Date: 21-JUN-2004 Page: 194
TABLE: APRDCCM
CREATOR: ALUMNI
Gift Society Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCCM_PIDM NUMBER 8 NO This field specifies the internal identification
number.
APRDCCM_DCYR_CODE NUMBER 4 NO This field specifies the year for the gift society
membership.
APRDCCM_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCCM_SEQ_NO NUMBER 23 20 NO This field specifies the sequence number of the
comment.
APRDCCM_COMMENT VARCHAR2 60 NO This field is the comment text.
APRDCCM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 195
TABLE: APRDCCP
CREATOR: ALUMNI
Gift Society Campaign Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCCP_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCCP_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCCP_CAMPAIGN VARCHAR2 5 NO This field specifies the campaigns to be included or
excluded with the society rule.
APRDCCP_INCL_EXCL_IND VARCHAR2 1 NO This field indicates if contributions to the campaign
are to be included or excluded in the amount totalled
for the society rule.
APRDCCP_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 196
TABLE: APRDCCT
CREATOR: ALUMNI
Gift Society Campaign Type Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCCT_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCCT_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society name for the
campaign type of the society rule.
APRDCCT_CMTP_CODE VARCHAR2 2 NO This field specifies the campaign types for the
society rule.
APRDCCT_INCL_EXCL_IND VARCHAR2 1 NO This field indicates if campaign types specified are
to be included or excluded when calculating totals for
gift society rule.
APRDCCT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 197
TABLE: APRDCDC
CREATOR: ALUMNI
Gift Society Donor Code Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCDC_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCDC_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCDC_DONR_CODE VARCHAR2 4 NO This field specifies the donor codes to be associated
with the society rule.
APRDCDC_INCL_EXCL_IND VARCHAR2 1 NO This field indicates if the donor codes are to be
included or excluded when summing amounts for the
society rule.
APRDCDC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 198
TABLE: APRDCDP
CREATOR: ALUMNI
Gift Society Donor Club Default Premiums Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCDP_DCYR_CODE NUMBER 4 NO This field specifies the beginning effective society
year code.
APRDCDP_DCPR_CODE VARCHAR2 4 NO This field specifies the premium code to be
automatically associated with the gift society based
on the society type, effective society year and the
gift society name.
APRDCDP_DCST_CODE VARCHAR2 2 YES This field specifies the society type code.
APRDCDP_DCNP_CODE VARCHAR2 4 YES This field specifies the gift society code.
APRDCDP_DCYR_CODE_INACT NUMBER 4 YES This field specifies the society year code in which
the premium rule becomes inactive and will no longer
be automatically assigned.
APRDCDP_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 199
TABLE: APRDCDS
CREATOR: ALUMNI
Gift Society Designation Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCDS_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCDS_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCDS_DESG VARCHAR2 10 NO This field specifies the designation associated with
the society rule.
APRDCDS_INCL_EXCL_IND VARCHAR2 1 NO This field indicates if the designation is to be
included or excluded when calculating the total for
the society rule.
APRDCDS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 200
TABLE: APRDCGL
CREATOR: ALUMNI
Gift Society Member Goal repeating table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCGL_DCYR_CODE NUMBER 4 NO Gift society year for the rule being defined. Created
on ATVDCYR.
APRDCGL_DCST_CODE VARCHAR2 2 NO Gift society type code for the rule being defined.
Created on ATVDCST.
APRDCGL_DCNP_CODE VARCHAR2 4 NO Gift society code for the rule being defined. Created
on ATVDCNP.
APRDCGL_CFAE_TYPE_1 VARCHAR2 1 NO CFAE Code 1 for the rule being defined. Codes found
on ATVDONR in the CFAE column.
APRDCGL_CFAE_TYPE_2 VARCHAR2 1 YES CFAE Code 2 for the rule being defined. Codes found
on ATVDONR in the CFAE 2 column.
APRDCGL_GOAL_NEW NUMBER 13 2 YES Goal for new members of the gift society in the
society year for the identifiedconstituency group.
APRDCGL_GOAL_RENEWED NUMBER 13 2 YES Goal for renewed members of the gift society in the
society year for the identified constituency group.
APRDCGL_USER VARCHAR2 30 NO User ID that created the rule.
APRDCGL_ACTIVITY_DATE DATE 7 NO Date that the rule was either added or last updated.
Date: 21-JUN-2004 Page: 201
TABLE: APRDCGT
CREATOR: ALUMNI
Gift Society Gift Code Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCGT_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCGT_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCGT_GIFT_CODE VARCHAR2 2 NO This field specifies the gift code associated with the
society rule.
APRDCGT_INCL_EXCL_IND VARCHAR2 1 NO This field indicates if the gift code is to be
included or excluded from the society rule.
APRDCGT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 202
TABLE: APRDCLB
CREATOR: ALUMNI
Gift Society Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCLB_PIDM NUMBER 8 NO This field specifies the system generated internal
identification number.
APRDCLB_DCYR_CODE NUMBER 4 NO This field specifies the gift society year for which
the constituent/organization is a member.
APRDCLB_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCLB_DCAM_CODE VARCHAR2 2 NO This field specifies if the member was added by the
system via a batch job or manually by a user.
APRDCLB_QUALIFY_DATE DATE 7 NO This field specifies the date on which the member
qualified for the society.
APRDCLB_USER VARCHAR2 30 YES This field specifies the user id that added or last
changed the membership record.
APRDCLB_RULE_NO NUMBER 2 YES This field specifies the rule number by which the
member qualified for the gift society.
APRDCLB_PAYMENT_IND VARCHAR2 1 YES This field specifies if the gift/pledge payment was
included in the sum qualifying the member for the
minimum giving level.
APRDCLB_PLEDGE_IND VARCHAR2 1 YES This field specifies if the pledge amount was included
in the sum qualifying the member for the minimum
giving level.
APRDCLB_MEMO_IND VARCHAR2 1 YES This field specifies if the memo amount was included
in the sum qualifying the member for the society based
on the dollar range.
APRDCLB_MULT_IND VARCHAR2 1 YES This field specifies if the multiple id amount was
included in the sum qualifying the member for the
society based on the dollar range.
APRDCLB_MG_IND VARCHAR2 1 YES This field specifies if the matching gift amount was
included in the sum qualifying the member for the
society based on the dollar range.
APRDCLB_WAIT_MG_IND VARCHAR2 1 YES This field specifies if the anticipated matching gift
amount was included in the sum qualifying the member
for the society based on the dollar range.
APRDCLB_SPS_IND VARCHAR2 1 YES This field specifies if the spouses pledges and/or
gifts are included in the sum qualifying the member
for the society based on the dollar range.
APRDCLB_SPS_MG_IND VARCHAR2 1 YES This field specifies if the spouse matching gift
amount was included in the sum qualifying the member
for the society based on the dollar range.
APRDCLB_SPS_WAIT_MG_IND VARCHAR2 1 YES This field specifies if the spouse anticipated
matching gift amount was included in the sum
qualifying the member for the society based on the
dollar range.
APRDCLB_OTH_XREF_IND VARCHAR2 1 YES This field specifies if cross references, other than
spouses, pledges and/or gifts are included in the sum
qualifying the member for the society based on the
dollar range.
Date: 21-JUN-2004 Page: 203
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCLB_OTH_XREF_MG_IND VARCHAR2 1 YES This field specifies if the other xref matching gift
amount was included in the sum qualifying the member
for the society based on the dollar range.
APRDCLB_OTH_XREF_WAIT_MG_IND VARCHAR2 1 YES This field specifies if the other xref anticipated
matching gift amount was included in the sum
qualifying the member for the society based on the
dollar range.
APRDCLB_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRDCLB_PAY_MEMO_IND VARCHAR2 1 YES This field indicates that memo credited to the society
member has been included in meeting the minimum
society amount.
APRDCLB_PAY_MULT_IND VARCHAR2 1 YES This field indicates that multiple payments credited
to the society member has been included in meeting the
minimum society amount.
APRDCLB_SOCIETY_NAME VARCHAR2 60 YES Gift Society name. The name will default from the
constituent or organization record when a membership
is created. The name may be changed for each
membership created.
Date: 21-JUN-2004 Page: 204
TABLE: APRDCPC
CREATOR: ALUMNI
Gift Society Preferred Year Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCPC_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCPC_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCPC_PREF_CLASS_START VARCHAR2 4 NO This field specifies the starting class year in a
range to be associated with the society rule.
APRDCPC_PREF_CLASS_END VARCHAR2 4 NO This field specifies the ending class year in a range
to be associated with the society rule.
APRDCPC_INCL_EXCL_IND VARCHAR2 1 NO This field indicates if constituents within the range
of class years are to be included or excluded from the
society rule.
APRDCPC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 205
TABLE: APRDCPR
CREATOR: ALUMNI
Gift Society Benefits/Premiums Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCPR_PIDM NUMBER 8 NO This field specifies the system generated internal
identification number.
APRDCPR_DCYR_CODE NUMBER 4 NO This field specifies the year for the society
membership.
APRDCPR_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCPR_DCPR_CODE VARCHAR2 4 NO This field specifies the benefit/premium code
associated with a society member for a particular
year.
APRDCPR_USER VARCHAR2 30 NO This field specifies the user that entered the benefit
code.
APRDCPR_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRDCPR_ISSUE_DATE DATE 7 YES Date the premium was issued by the institution.
Date: 21-JUN-2004 Page: 206
TABLE: APRDCRL
CREATOR: ALUMNI
Gift Society Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCRL_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCRL_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCRL_PRIORITY_IND NUMBER 2 NO This field specifies the rule priority. The lower the
number, the higher the priority. The highest priority
rule will be processed first.
APRDCRL_MEMBER_DURATION NUMBER 2 NO This field specifies the number of years for which
membership is created.
APRDCRL_MIN_GIVING NUMBER 13 2 YES This field specifies the minimum amount required to
achieve membership.
APRDCRL_MAX_GIVING NUMBER 13 2 YES This field specifies the maximum amount for the gift
society. This amount is no functional in the
automated gift society process.
APRDCRL_MIN_SINGLE_AMT NUMBER 13 2 YES This field specifies the minimum amount required for
each item added to the total giving amount.
APRDCRL_QUALIFY_YEARS VARCHAR2 2 YES This field specifies the number of years of giving
that will be counted to qualify for the membership.
APRDCRL_DCYR_CODE_QUALIFY NUMBER 4 YES This field specifies the society year in which the
giving will start being counted to qualify for the
membership. This is optional.
APRDCRL_INACT_IND VARCHAR2 1 YES This field indicates if a rule is inactive.
APRDCRL_INACT_DATE DATE 7 YES This field indicates the date the rule became
inactive.
APRDCRL_PAYMENT_IND VARCHAR2 1 YES This field specifies if the gift/pledge payment was
included in the sum qualifying the member for the
minimum giving level.
APRDCRL_PAYMENT_MEMO_IND VARCHAR2 1 YES This field specifies if the payment memo amount was
included in the sum qualifying the member for the
society based on the dollar range.
APRDCRL_PAYMENT_MULT_IND VARCHAR2 1 YES This field specifies if the payment multiple id amount
was included in the sum qualifying the member for the
society based on the dollar range.
APRDCRL_PLEDGE_IND VARCHAR2 1 YES This field specifies if the pledge amount was included
in the sum qualifying the member for the minimum
giving level.
APRDCRL_PLEDGE_MEMO_IND VARCHAR2 1 YES This field specifies if the pledge memo amount was
included in the sum qualifying the member for the
society based on the dollar range.
APRDCRL_PLEDGE_MULT_IND VARCHAR2 1 YES This field specifies if the pledge multiple id amount
was included in the sum qualifying the member for the
society based on the dollar range.
APRDCRL_MG_IND VARCHAR2 1 YES This field specifies if the matching gift amount was
included in the sum qualifying the member for the
society based on the dollar range.
APRDCRL_WAIT_MG_IND VARCHAR2 1 YES This field specifies if the anticipated matching gift
amount was included in the sum qualifying the member
for the society based on the dollar range.
Date: 21-JUN-2004 Page: 207
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCRL_SPS_IND VARCHAR2 1 YES This field specifies if the spouses pledges and/or
gifts are included in the sum qualifying the member
for the society based on the dollar range.
APRDCRL_SPS_MG_IND VARCHAR2 1 YES This field specifies if the spouse matching gift
amount was included in the sum qualifying the member
for the society based on the dollar range.
APRDCRL_SPS_WAIT_MG_IND VARCHAR2 1 YES This field specifies if the spouse anticipated
matching gift amount was included in the sum
qualifying the member for the society based on the
dollar range.
APRDCRL_OTH_XREF_IND VARCHAR2 1 YES This field specifies if cross references, other than
spouses, pledges and/or gifts are included in the sum
qualifying the member for the society based on the
dollar range.
APRDCRL_OTH_XREF_MG_IND VARCHAR2 1 YES This field specifies if the other xref matching gift
amount was included in the sum qualifying the member
for the society based on the dollar range.
APRDCRL_OTH_XREF_WAIT_MG_IND VARCHAR2 1 YES This field specifies if the other xref anticipated
matching gift amount was included in the sum
qualifying the member for the society based on the
dollar range.
APRDCRL_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APRDCRL_INCL_EXP_MG_IND VARCHAR2 1 YES (Y) - Yes, include expected matching gifts based on
pledges. (N) - No, do not include expected matching
gifts based on pledges. Null - No, do not include
expected matching gifts based on pledges.
Date: 21-JUN-2004 Page: 208
TABLE: APRDCTM
CREATOR: ALUMNI
Gift Society Temporary Processing Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCTM_USER VARCHAR2 30 NO This field specifies the ORACLE user running the gift
society process.
APRDCTM_SESSIONID VARCHAR2 30 NO This field specifies the ORACLE session id of the gift
society process.
APRDCTM_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCTM_RULE_NO NUMBER 2 NO This field specifies the rule number of the rule being
processed.
APRDCTM_RULE_PRI_IND NUMBER 2 NO This field specifies the rule priority of the rule
being processed.
APRDCTM_DCST_CODE VARCHAR2 2 NO This field specifies the society type code of the rule
be processed.
APRDCTM_SOC_PRI_IND NUMBER 2 NO This field specifies the priority of the society being
processed.
APRDCTM_DCYR_START_DATE DATE 7 NO This field specifies the start date of the society
year being being processed.
APRDCTM_DCYR_END_DATE DATE 7 NO This field specifies the end date of the society year
being being processed.
APRDCTM_FISC_CODE NUMBER 4 NO This field specifies the fiscal year code.
APRDCTM_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 209
TABLE: APRDCXR
CREATOR: ALUMNI
Gift Society Cross Reference Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDCXR_RULE_NO NUMBER 2 NO This field specifies the rule number by which the
member qualified for the gift society.
APRDCXR_DCNP_CODE VARCHAR2 4 NO This field specifies the gift society code.
APRDCXR_XREF_CODE VARCHAR2 3 NO This field specifies the cross reference codes to be
included or excluded in the society rule.
APRDCXR_CREATE_MEMBER_IND VARCHAR2 1 YES This field indicates if memberships should be created
for the xref codes.
APRDCXR_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 210
TABLE: APRDHIS
CREATOR: ALUMNI
Giving History By Desg Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDHIS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRDHIS_DESG VARCHAR2 10 NO This field specifies the designation(s) associated
with the constituents gifts and/or pledge payments.
APRDHIS_FISC_CODE NUMBER 4 NO This field specifies the fiscal year of the campaign
the associated with the designation.
APRDHIS_AMT_PLEDGED NUMBER 13 2 YES This field specifies the amount the constituent
pledged for a specific designation.
APRDHIS_AMT_PLEDGED_PAID NUMBER 13 2 YES This field specifies the amount of pledge payments for
a specific designation.
APRDHIS_AMT_GIFT NUMBER 13 2 YES This field specifies the dollar amount of gifts
received from a constituent for a specific
designation.
APRDHIS_AMT_MEMO NUMBER 13 2 YES This field specifies the amount of memo credit (soft
dollars) credited to the constituent for a specific
designation.
APRDHIS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 211
TABLE: APRDRVW
CREATOR: ALUMNI
Degree data load table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRDRVW_PIDM NUMBER 8 NO
APRDRVW_DSRC_CODE VARCHAR2 10 NO
APRDRVW_LOAD_DATE DATE 7 NO
APRDRVW_ACCEPTED_IND VARCHAR2 1 NO
APRDRVW_ACTIVITY_DATE DATE 7 NO
APRDRVW_USER VARCHAR2 30 NO
APRDRVW_SEQ_NO NUMBER 2 NO
APRDRVW_SOURCE_DATE DATE 7 NO
APRDRVW_SBGI_CODE VARCHAR2 6 YES
APRDRVW_INST_NAME VARCHAR2 60 YES
APRDRVW_DEG_NAME VARCHAR2 15 YES
APRDRVW_MAJOR_NAME VARCHAR2 60 YES
APRDRVW_MAJOR_NAME2 VARCHAR2 60 YES
APRDRVW_MAJOR_NAME3 VARCHAR2 60 YES
APRDRVW_DEGC_CODE VARCHAR2 6 YES
APRDRVW_DATE DATE 7 YES
APRDRVW_ACYR_CODE VARCHAR2 4 YES
APRDRVW_MAJR_CODE VARCHAR2 4 YES
APRDRVW_MAJR_CODE2 VARCHAR2 4 YES
APRDRVW_MAJR_CODE3 VARCHAR2 4 YES
APRDRVW_COLL_CODE VARCHAR2 2 YES
Date: 21-JUN-2004 Page: 212
TABLE: APRECMT
CREATOR: ALUMNI
Employment Comment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRECMT_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APRECMT_EHIS_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number.
APRECMT_SEQ_NO NUMBER 23 20 NO This field specifies the internal sequence number.
APRECMT_COMMENT VARCHAR2 60 NO This field specifies free-form comments about the
constituents employment.
APRECMT_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
Date: 21-JUN-2004 Page: 213
TABLE: APREHIS
CREATOR: ALUMNI
Employment History Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APREHIS_PIDM NUMBER 8 NO This field specifies the internal system generated
identification number.
APREHIS_SEQ_NO NUMBER 5 NO This field specifies the internal sequence number.
APREHIS_EMPR_NAME VARCHAR2 60 YES This field identifies the name of the constituents
employer(s).
APREHIS_JOBC_CODE VARCHAR2 3 YES This field identifies the job category of the
constituent.
APREHIS_EMPL_POSITION VARCHAR2 60 YES This field identifies the position the constituent
holds with the employer.
APREHIS_FROM_DATE DATE 7 YES This field identifies the date the constituent started
their employment with the associated employer.
APREHIS_TO_DATE DATE 7 YES This field identifies the date the constituent ended
their employment with the associated employer.
APREHIS_EMPR_PIDM NUMBER 8 YES Internal id number for employer. This number should
be null if the employer has no id.
APREHIS_EMPR_ID VARCHAR2 9 YES This field is no longer used.
APREHIS_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or updated.
APREHIS_SICC_CODE VARCHAR2 4 YES This field identifies the Standard Industrial Code of
the employer. This field will default from the
Organization Form (AOAORGN) online when the employer
is a valid Alumni/Development Organization.
APREHIS_XREF_CODE VARCHAR2 3 YES This field is used to identify the cross reference
record created for the employee and employer relation.
APREHIS_EMPS_CODE VARCHAR2 1 YES Employment Status Code.
APREHIS_WKLY_HOURS NUMBER 5 2 YES Hours per week for parttime employee used for matching
gift qualification.
APREHIS_USER VARCHAR2 30 NO This system maintained field specifies the user that
created or updated the record.
APREHIS_PRIMARY_IND VARCHAR2 1 YES This field indicates that the record is the Primary
Employment record.
APREHIS_ATYP_CODE VARCHAR2 2 YES This field indicates the address type associated with
the Employment record.
APREHIS_ATYP_SEQNO NUMBER 2 YES This field indicates the address type sequence number
associated with the Employment record.
APREHIS_JOBC_CODE2 VARCHAR2 3 YES This field identifies the second job category of the
constituent.
APREHIS_JOBC_CODE3 VARCHAR2 3 YES This field identifies the third job category of the
constituent.
APREHIS_JOBC_CODE4 VARCHAR2 3 YES This field identifies the fourth job category of the
constituent.
APREHIS_OK_FOR_NOTES_IND VARCHAR2 1 YES OK for Note Indicator, Y indicates that it is OK to
use this employer in Class Notes.
APREHIS_DISP_NOTES_IND VARCHAR2 1 YES Displayed in Notes Indicator, Y indicates that this
employer has been used in Class Notes.
Date: 21-JUN-2004 Page: 214
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APREHIS_DISP_NOTES_DATE DATE 7 YES The date that this employer was used in Class Notes.
APREHIS_MG_IND VARCHAR2 1 YES Matching Gift Indicator, Y indicates that this
Employer will match gifts.
APREHIS_REVIEWED_IND VARCHAR2 1 YES Reviewed Indicator, Y indicates that this employer has
been reviewed and accepted.
APREHIS_REVIEWED_USER VARCHAR2 30 YES The User ID of the person who reviewed and accepted
this employer.
APREHIS_COMMENT LONG YES Free form text comment for this employer.
Date: 21-JUN-2004 Page: 215
TABLE: APRERVW
CREATOR: ALUMNI
Employer data load table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
APRERVW_PIDM NUMBER 8 NO
APRERVW_DSRC_CODE VARCHAR2 10 NO
APRERVW_LOAD_DATE DATE 7 NO
APRERVW_ACCEPTED_IND VARCHAR2 1 NO
APRERVW_ACTIVITY_DATE DATE 7 NO
APRERVW_USER VARCHAR2 30 NO
APRERVW_SEQ_NO NUMBER 2 NO
APRERVW_SOURCE_DATE DATE 7 NO
APRERVW_EMPR_NAME VARCHAR2 60 YES
APRERVW_JOBC_CODE VARCHAR2 3 YES
APRERVW_EMPL_POSITION VARCHAR2 60 YES
APRERVW_FROM_DATE DATE 7 YES
APRERVW_TO_DATE