Model Membership Dues Payment

Model Label : BANNER Advancement Membership Dues Payment Processing
Path : BANNER DEV/Advancement/Advancement_ERD/MembershipDuesPayment_ERD

List of Objects

Object Name	Object Type	Layer Name
AABDINS	TABLE	Default
AABDUES	TABLE	Default
AARCMEM	TABLE	Default
AARDUES	TABLE	Default
AARMCMT	TABLE	Default
AARMEMB	TABLE	Default
AARMINT	TABLE	Default
AARMPRE	TABLE	Default
ATVAMCT	TABLE	Default
ATVAMPM	TABLE	Default
ATVAMST	TABLE	Default
ATVAMTP	TABLE	Default
ATVDCAM	TABLE	Default
ATVFISC	TABLE	Default
ATVGIFT	TABLE	Default

Comments

Model View

Table AABDINS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AABDINS_PIDM	AABDINS_PIDM	NUMBER(8,0)	No	*	*
AABDINS_MEMBERSHIP	AABDINS_MEMBERSHIP	VARCHAR2(5)	No	*	*
AABDINS_MEMB_NO	AABDINS_MEMB_NO	VARCHAR2(7)	No	*	*
AABDINS_FREQ_CODE	AABDINS_FREQ_CODE	VARCHAR2(2)	No		*
AABDINS_BILL_DATE	AABDINS_BILL_DATE	DATE	No
AABDINS_ACTIVITY_DATE	AABDINS_ACTIVITY_DATE	DATE	No
AABDINS_PDUR_CODE	AABDINS_PDUR_CODE	VARCHAR2(1)	Yes		*
AABDINS_LETR_CODE	AABDINS_LETR_CODE	VARCHAR2(15)	Yes		*
AABDINS_RENEWAL_PIDM	AABDINS_RENEWAL_PIDM	NUMBER(8,0)	Yes
AABDINS_ATYP_CODE	AABDINS_ATYP_CODE	VARCHAR2(2)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AABDINS_PIDM	AARMEMB_PIDM	AARMEMB
AABDINS_MEMBERSHIP	AARMEMB_MEMBERSHIP	AARMEMB
AABDINS_MEMB_NO	AARMEMB_MEMB_NO	AARMEMB
AABDINS_FREQ_CODE	ATVFREQ_CODE	ATVFREQ
AABDINS_PDUR_CODE	ATVPDUR_CODE	ATVPDUR
AABDINS_LETR_CODE	GTVLETR_CODE	GTVLETR
AABDINS_ATYP_CODE	STVATYP_CODE	STVATYP

Index

Index Name	Index Type	Column Name
PK_AABDINS	Unique	AABDINS_PIDM
PK_AABDINS	Unique	AABDINS_MEMBERSHIP
PK_AABDINS	Unique	AABDINS_MEMB_NO

Comments

Source Code Comments

Membership Dues Installment Base Table

Columns Comments for AABDINS_PIDM (1)

Source Code Comments

Internal system generated identification number of the constituent.

Columns Comments for AABDINS_MEMBERSHIP (2)

Source Code Comments

Membership code for the association.

Columns Comments for AABDINS_MEMB_NO (3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AABDINS_FREQ_CODE (4)

Source Code Comments

Frequency for installmemt reminders for the dues payments.

Columns Comments for AABDINS_BILL_DATE (5)

Source Code Comments

First billing date for the dues.

Columns Comments for AABDINS_ACTIVITY_DATE (6)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AABDINS_PDUR_CODE (7)

Source Code Comments

Specifies the duration of the dues.

Columns Comments for AABDINS_LETR_CODE (8)

Source Code Comments

Specifies the letter to be generated for the renewal.

Columns Comments for AABDINS_RENEWAL_PIDM (9)

Source Code Comments

Internal system identification number of the renewal party.

Columns Comments for AABDINS_ATYP_CODE (10)

Source Code Comments

Address type code for the renewal party.

Table AABDUES

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AABDUES_PAYOR_PIDM	AABDUES_PAYOR_PIDM	NUMBER(8,0)	No	*
AABDUES_TRANS_NO	AABDUES_TRANS_NO	VARCHAR2(7)	No	*
AABDUES_MEMBERSHIP	AABDUES_MEMBERSHIP	VARCHAR2(5)	No
AABDUES_AMOUNT_TOT	AABDUES_AMOUNT_TOT	NUMBER(11,2)	No
AABDUES_GIFT_CODE	AABDUES_GIFT_CODE	VARCHAR2(2)	No		*
AABDUES_DUES_DATE	AABDUES_DUES_DATE	DATE	No
AABDUES_FISC_CODE	AABDUES_FISC_CODE	NUMBER(4,0)	No		*
AABDUES_ACTIVITY_DATE	AABDUES_ACTIVITY_DATE	DATE	No
AABDUES_ENTRY_DATE	AABDUES_ENTRY_DATE	DATE	No
AABDUES_USER	AABDUES_USER	VARCHAR2(30)	No
AABDUES_FINAL_IND	AABDUES_FINAL_IND	VARCHAR2(1)	Yes
AABDUES_ADJ_IND	AABDUES_ADJ_IND	VARCHAR2(1)	Yes
AABDUES_GIFT_DESC	AABDUES_GIFT_DESC	VARCHAR2(30)	Yes
AABDUES_ACKN_IND	AABDUES_ACKN_IND	VARCHAR2(1)	Yes
AABDUES_ACKN_DATE	AABDUES_ACKN_DATE	DATE	Yes
AABDUES_RECPT_IND	AABDUES_RECPT_IND	VARCHAR2(1)	Yes
AABDUES_RECPT_DATE	AABDUES_RECPT_DATE	DATE	Yes
AABDUES_CARD_NO	AABDUES_CARD_NO	VARCHAR2(20)	Yes
AABDUES_CARD_EXP_DATE	AABDUES_CARD_EXP_DATE	DATE	Yes
AABDUES_SESSION_NUMBER	AABDUES_SESSION_NUMBER	NUMBER(6,0)	Yes
AABDUES_FEED_IND	AABDUES_FEED_IND	VARCHAR2(1)	Yes
AABDUES_FEED_DATE	AABDUES_FEED_DATE	DATE	Yes
AABDUES_FEED_DOC_CODE	AABDUES_FEED_DOC_CODE	VARCHAR2(8)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AABDUES_FISC_CODE	ATVFISC_CODE	ATVFISC
AABDUES_GIFT_CODE	ATVGIFT_CODE	ATVGIFT

Index

Index Name	Index Type	Column Name
AABDUES_KEY_INDEX2		AABDUES_ENTRY_DATE
AABDUES_KEY_INDEX2		AABDUES_USER
AABDUES_KEY_INDEX3		AABDUES_DUES_DATE
PK_AABDUES	Unique	AABDUES_PAYOR_PIDM
PK_AABDUES	Unique	AABDUES_TRANS_NO

Comments

Source Code Comments

Dues Entry Base Table

Columns Comments for AABDUES_PAYOR_PIDM (1)

Source Code Comments

System generated number used to identify person/organization that is the third party that will pay the dues.

Columns Comments for AABDUES_TRANS_NO (2)

Source Code Comments

System generated unique number that identifies the transaction number for ID.

Columns Comments for AABDUES_MEMBERSHIP (3)

Source Code Comments

Membership code for payor id.

Columns Comments for AABDUES_AMOUNT_TOT (4)

Source Code Comments

Amount of the dues for the Payor ID specified.

Columns Comments for AABDUES_GIFT_CODE (5)

Source Code Comments

Payment type code for dues.

Columns Comments for AABDUES_DUES_DATE (6)

Source Code Comments

The date the payment was made for dues.

Columns Comments for AABDUES_FISC_CODE (7)

Source Code Comments

The fiscal year the membership dues is valid for.

Columns Comments for AABDUES_ACTIVITY_DATE (8)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AABDUES_ENTRY_DATE (9)

Source Code Comments

The date this dues was entered into the system.

Columns Comments for AABDUES_USER (10)

Source Code Comments

The user ID that entered this record.

Columns Comments for AABDUES_FINAL_IND (11)

Source Code Comments

Finalized indicator indicates that the dues has been finalized.

Columns Comments for AABDUES_ADJ_IND (12)

Source Code Comments

The adjustment indicator indicates if this transaction has been adjusted.

Columns Comments for AABDUES_GIFT_DESC (13)

Source Code Comments

The description of the payment code, will default but is updateable.

Columns Comments for AABDUES_ACKN_IND (14)

Source Code Comments

The acknowledgement field indicates if dues has been acknowledged or not.

Columns Comments for AABDUES_ACKN_DATE (15)

Source Code Comments

The date the dues has been acknowledged.

Columns Comments for AABDUES_RECPT_IND (16)

Source Code Comments

Receipt indicator to acknowledge a receipt has been issued.

Columns Comments for AABDUES_RECPT_DATE (17)

Source Code Comments

Receipt date that the receipt was issued.

Columns Comments for AABDUES_CARD_NO (18)

Source Code Comments

The credit card number of the person paying the dues.

Columns Comments for AABDUES_CARD_EXP_DATE (19)

Source Code Comments

The expiration date of the credit card of the person paying the dues.

Columns Comments for AABDUES_SESSION_NUMBER (20)

Source Code Comments

This field is updated with the session number of the cashiering session when that is run.

Columns Comments for AABDUES_FEED_IND (21)

Source Code Comments

The feed indicator if set indicates a feed to finance.

Columns Comments for AABDUES_FEED_DATE (22)

Source Code Comments

The date the feed was fed to finance.

Columns Comments for AABDUES_FEED_DOC_CODE (23)

Source Code Comments

The feed documentation code for the feed to finance.

Table AARCMEM

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AARCMEM_PIDM	AARCMEM_PIDM	NUMBER(8,0)	No	*
AARCMEM_MEMBERSHIP	AARCMEM_MEMBERSHIP	VARCHAR2(5)	No	*
AARCMEM_MEMB_NO	AARCMEM_MEMB_NO	VARCHAR2(7)	No	*
AARCMEM_LINK_PIDM	AARCMEM_LINK_PIDM	NUMBER(8,0)	No
AARCMEM_LINK_MEMB_NO	AARCMEM_LINK_MEMB_NO	VARCHAR2(7)	No
AARCMEM_ACTIVITY_DATE	AARCMEM_ACTIVITY_DATE	DATE	No
AARCMEM_LINK_IND	AARCMEM_LINK_IND	VARCHAR2(1)	Yes
AARCMEM_REN_REM_IND	AARCMEM_REN_REM_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARCMEM_PIDM	AARMEMB_PIDM	AARMEMB
AARCMEM_MEMBERSHIP	AARMEMB_MEMBERSHIP	AARMEMB
AARCMEM_MEMB_NO	AARMEMB_MEMB_NO	AARMEMB

Index

Index Name	Index Type	Column Name
AARCMEM_KEY_INDEX	Unique	AARCMEM_PIDM
AARCMEM_KEY_INDEX	Unique	AARCMEM_MEMBERSHIP
AARCMEM_KEY_INDEX	Unique	AARCMEM_MEMB_NO
AARCMEM_KEY_INDEX	Unique	AARCMEM_LINK_PIDM
AARCMEM_KEY_INDEX2	Unique	AARCMEM_LINK_PIDM
AARCMEM_KEY_INDEX2	Unique	AARCMEM_LINK_MEMB_NO

Comments

Source Code Comments

Co-Membership Repeating Table

Columns Comments for AARCMEM_PIDM (1)

Source Code Comments

Internal system generated identification number for the member.

Columns Comments for AARCMEM_MEMBERSHIP (2)

Source Code Comments

Membership code for the member.

Columns Comments for AARCMEM_MEMB_NO (3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARCMEM_LINK_PIDM (4)

Source Code Comments

Internal system generated identification number for the co-member.

Columns Comments for AARCMEM_LINK_MEMB_NO (5)

Source Code Comments

System generated number that uniquely identifies a co-member membership.

Columns Comments for AARCMEM_ACTIVITY_DATE (6)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AARCMEM_LINK_IND (7)

Source Code Comments

Indicator to link memberships.

Columns Comments for AARCMEM_REN_REM_IND (8)

Source Code Comments

Indicator representing which id is used for renewal/reminder.

Table AARDUES

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AARDUES_PIDM	AARDUES_PIDM	NUMBER(8,0)	No	*	*
AARDUES_PAYOR_PIDM	AARDUES_PAYOR_PIDM	NUMBER(8,0)	No		*
AARDUES_TRANS_NO	AARDUES_TRANS_NO	VARCHAR2(7)	No	*	*
AARDUES_TRANS_NO	AARDUES_TRANS_NO	VARCHAR2(7)	No	*	*
AARDUES_MEMBERSHIP	AARDUES_MEMBERSHIP	VARCHAR2(5)	No
AARDUES_MEMB_NO	AARDUES_MEMB_NO	VARCHAR2(7)	No	*	*
AARDUES_AMCT_CODE	AARDUES_AMCT_CODE	VARCHAR2(5)	No		*
AARDUES_AMOUNT	AARDUES_AMOUNT	NUMBER(11,2)	No
AARDUES_ACTIVITY_DATE	AARDUES_ACTIVITY_DATE	DATE	No
AARDUES_AMPM_CODE	AARDUES_AMPM_CODE	VARCHAR2(5)	Yes		*
AARDUES_COMMENT	AARDUES_COMMENT	VARCHAR2(180)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARDUES_AMCT_CODE	ATVAMCT_CODE	ATVAMCT
AARDUES_AMPM_CODE	ATVAMPM_CODE	ATVAMPM
AARDUES_PAYOR_PIDM	AABDUES_PAYOR_PIDM	AABDUES
AARDUES_TRANS_NO	AABDUES_TRANS_NO	AABDUES
AARDUES_PIDM	AARMINT_PIDM	AARMINT
AARDUES_TRANS_NO	AARMINT_TRANS_NO	AARMINT
AARDUES_MEMB_NO	AARMINT_MEMB_NO	AARMINT

Index

Index Name	Index Type	Column Name
AARDUES_KEY_INDEX2		AARDUES_MEMB_NO
AARDUES_KEY_INDEX2		AARDUES_MEMBERSHIP
AARDUES_PAYOR_INDEX		AARDUES_PAYOR_PIDM
PK_AARDUES	Unique	AARDUES_PIDM
PK_AARDUES	Unique	AARDUES_TRANS_NO
PK_AARDUES	Unique	AARDUES_MEMB_NO

Comments

Source Code Comments

Dues Entry Table

Columns Comments for AARDUES_PIDM (1)

Source Code Comments

System generated number used to identify member person/organization.

Columns Comments for AARDUES_PAYOR_PIDM (2)

Source Code Comments

System generated number used to identify person/organization that is the third party that will pay the dues.

Columns Comments for AARDUES_TRANS_NO (3)

Source Code Comments

System generated unique number that identifies the transaction number for ID.

Columns Comments for AARDUES_MEMBERSHIP (4)

Source Code Comments

Membership code for association.

Columns Comments for AARDUES_MEMB_NO (5)

Source Code Comments

System generated unique number that identifies the membership number for ID.

Columns Comments for AARDUES_AMCT_CODE (6)

Source Code Comments

Category code for the dues record created for the ID.

Columns Comments for AARDUES_AMOUNT (7)

Source Code Comments

Amount of the dues for the ID specified.

Columns Comments for AARDUES_ACTIVITY_DATE (8)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AARDUES_AMPM_CODE (9)

Source Code Comments

Promotion code for the membership code.

Columns Comments for AARDUES_COMMENT (10)

Source Code Comments

Dues comment line for ID specified.

Table AARMCMT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AARMCMT_PIDM	AARMCMT_PIDM	NUMBER(8,0)	No	*	*
AARMCMT_MEMBERSHIP	AARMCMT_MEMBERSHIP	VARCHAR2(5)	No	*	*
AARMCMT_MEMB_NO	AARMCMT_MEMB_NO	VARCHAR2(7)	No	*	*
AARMCMT_SEQNO	AARMCMT_SEQNO	NUMBER(9,2)	No	*
AARMCMT_COMMENT	AARMCMT_COMMENT	VARCHAR2(60)	No
AARMCMT_ACTIVITY_DATE	AARMCMT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARMCMT_PIDM	AARMEMB_PIDM	AARMEMB
AARMCMT_MEMBERSHIP	AARMEMB_MEMBERSHIP	AARMEMB
AARMCMT_MEMB_NO	AARMEMB_MEMB_NO	AARMEMB

Index

Index Name	Index Type	Column Name
PK_AARMCMT	Unique	AARMCMT_PIDM
PK_AARMCMT	Unique	AARMCMT_MEMBERSHIP
PK_AARMCMT	Unique	AARMCMT_MEMB_NO
PK_AARMCMT	Unique	AARMCMT_SEQNO

Comments

Source Code Comments

Individual Membership Comments Table

Columns Comments for AARMCMT_PIDM (1)

Source Code Comments

Internal system generated identification number for the person.

Columns Comments for AARMCMT_MEMBERSHIP (2)

Source Code Comments

Membership codes for person.

Columns Comments for AARMCMT_MEMB_NO (3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMCMT_SEQNO (4)

Source Code Comments

Comment sequence number.

Columns Comments for AARMCMT_COMMENT (5)

Source Code Comments

Comment text.

Columns Comments for AARMCMT_ACTIVITY_DATE (6)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMEMB

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AARMEMB_PIDM	AARMEMB_PIDM	NUMBER(8,0)	No	*
AARMEMB_MEMBERSHIP	AARMEMB_MEMBERSHIP	VARCHAR2(5)	No	*
AARMEMB_MEMB_NO	AARMEMB_MEMB_NO	VARCHAR2(7)	No	*
AARMEMB_LETR_CODE	AARMEMB_LETR_CODE	VARCHAR2(15)	Yes		*
AARMEMB_AMCT_CODE	AARMEMB_AMCT_CODE	VARCHAR2(5)	No		*
AARMEMB_AMTP_CODE	AARMEMB_AMTP_CODE	VARCHAR2(3)	No		*
AARMEMB_ENTRY_DATE	AARMEMB_ENTRY_DATE	DATE	No
AARMEMB_AMST_CODE	AARMEMB_AMST_CODE	VARCHAR2(1)	No		*
AARMEMB_AMST_DATE	AARMEMB_AMST_DATE	DATE	No
AARMEMB_ACTIVITY_DATE	AARMEMB_ACTIVITY_DATE	DATE	No
AARMEMB_REMINDER_PIDM	AARMEMB_REMINDER_PIDM	NUMBER(8,0)	Yes
AARMEMB_ATYP_CODE_REM	AARMEMB_ATYP_CODE_REM	VARCHAR2(2)	Yes		*
AARMEMB_RENEWAL_PIDM	AARMEMB_RENEWAL_PIDM	NUMBER(8,0)	Yes
AARMEMB_RENEWAL_DATE	AARMEMB_RENEWAL_DATE	DATE	Yes
AARMEMB_ATYP_CODE_REN	AARMEMB_ATYP_CODE_REN	VARCHAR2(2)	Yes		*
AARMEMB_DCAM_CODE	AARMEMB_DCAM_CODE	VARCHAR2(2)	Yes		*
AARMEMB_DURATION	AARMEMB_DURATION	NUMBER(3,0)	Yes
AARMEMB_RULE_NO	AARMEMB_RULE_NO	NUMBER(4,0)	Yes
AARMEMB_CARD_IND	AARMEMB_CARD_IND	VARCHAR2(1)	Yes
AARMEMB_CARD_DATE	AARMEMB_CARD_DATE	DATE	Yes
AARMEMB_GRACE_PERIOD	AARMEMB_GRACE_PERIOD	NUMBER(2,0)	Yes
AARMEMB_AMT_QUALIFY	AARMEMB_AMT_QUALIFY	NUMBER(11,2)	Yes
AARMEMB_EXP_DATE	AARMEMB_EXP_DATE	DATE	Yes
AARMEMB_MEMB_NAME	AARMEMB_MEMB_NAME	VARCHAR2(60)	Yes
AARMEMB_LETR_CODE_RENEW	AARMEMB_LETR_CODE_RENEW	VARCHAR2(15)	Yes		*
AARMEMB_STATUS_OVERRIDE_IND	AARMEMB_STATUS_OVERRIDE_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARMEMB_AMCT_CODE	ATVAMCT_CODE	ATVAMCT
AARMEMB_AMST_CODE	ATVAMST_CODE	ATVAMST
AARMEMB_AMTP_CODE	ATVAMTP_CODE	ATVAMTP
AARMEMB_DCAM_CODE	ATVDCAM_CODE	ATVDCAM

Index

Index Name	Index Type	Column Name
AARMEMB_KEY_INDEX2		AARMEMB_AMCT_CODE
PK_AARMEMB	Unique	AARMEMB_PIDM
PK_AARMEMB	Unique	AARMEMB_MEMBERSHIP
PK_AARMEMB	Unique	AARMEMB_MEMB_NO

Comments

Source Code Comments

Membership Repeating Table

Columns Comments for AARMEMB_PIDM (1)

Source Code Comments

Internal system identification number for the person.

Columns Comments for AARMEMB_MEMBERSHIP (2)

Source Code Comments

Membership code for association.

Columns Comments for AARMEMB_MEMB_NO (3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMEMB_LETR_CODE (4)

Source Code Comments

Letter that gets sent out with the membership card.

Columns Comments for AARMEMB_AMCT_CODE (5)

Source Code Comments

Membership category code.

Columns Comments for AARMEMB_AMTP_CODE (6)

Source Code Comments

Membership type code.

Columns Comments for AARMEMB_ENTRY_DATE (7)

Source Code Comments

Date of entry of membership.

Columns Comments for AARMEMB_AMST_CODE (8)

Source Code Comments

Status code for individual membership.

Columns Comments for AARMEMB_AMST_DATE (9)

Source Code Comments

Date of membership status.

Columns Comments for AARMEMB_ACTIVITY_DATE (10)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AARMEMB_REMINDER_PIDM (11)

Source Code Comments

Internal system identification number of the reminder party.

Columns Comments for AARMEMB_ATYP_CODE_REM (12)

Source Code Comments

Address type code for the reminder party.

Columns Comments for AARMEMB_RENEWAL_PIDM (13)

Source Code Comments

Internal system identification number of the renewal party.

Columns Comments for AARMEMB_RENEWAL_DATE (14)

Source Code Comments

Date of renewal for future memberships.

Columns Comments for AARMEMB_ATYP_CODE_REN (15)

Source Code Comments

Address type code for renewal party.

Columns Comments for AARMEMB_DCAM_CODE (16)

Source Code Comments

Assignment method for membership.

Columns Comments for AARMEMB_DURATION (17)

Source Code Comments

Length of duration for membership.

Columns Comments for AARMEMB_RULE_NO (18)

Source Code Comments

Rule number pertaining to membership.

Columns Comments for AARMEMB_CARD_IND (19)

Source Code Comments

Indicator showing whether membership card was sent.

Columns Comments for AARMEMB_CARD_DATE (20)

Source Code Comments

Date card was sent.

Columns Comments for AARMEMB_GRACE_PERIOD (21)

Source Code Comments

Grace period allowed for the membership.

Columns Comments for AARMEMB_AMT_QUALIFY (22)

Source Code Comments

Amount qualify which is taken from the membership rule form, that this person has to meet for the membership.

Columns Comments for AARMEMB_EXP_DATE (23)

Source Code Comments

Expiration date of the membership.

Columns Comments for AARMEMB_MEMB_NAME (24)

Source Code Comments

Default membership name for membership card and other references to the member.

Columns Comments for AARMEMB_LETR_CODE_RENEW (25)

Source Code Comments

Letter code that will be received by the person getting the renewal.

Columns Comments for AARMEMB_STATUS_OVERRIDE_IND (26)

Source Code Comments

Status override indicator. If N, status will not be automatically overriden by incoming dues prior to the renewal and expiration dates.

Table AARMINT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AARMINT_PIDM	AARMINT_PIDM	NUMBER(8,0)	No	*	*
AARMINT_MEMBERSHIP	AARMINT_MEMBERSHIP	VARCHAR2(5)	No	*	*
AARMINT_MEMB_NO	AARMINT_MEMB_NO	VARCHAR2(7)	No	*	*
AARMINT_INTEREST	AARMINT_INTEREST	VARCHAR2(5)	No	*
AARMINT_TRANS_NO	AARMINT_TRANS_NO	VARCHAR2(7)	No	*
AARMINT_AMOUNT	AARMINT_AMOUNT	NUMBER(11,2)	No
AARMINT_ACTIVITY_DATE	AARMINT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARMINT_PIDM	AARMEMB_PIDM	AARMEMB
AARMINT_MEMBERSHIP	AARMEMB_MEMBERSHIP	AARMEMB
AARMINT_MEMB_NO	AARMEMB_MEMB_NO	AARMEMB

Index

Index Name	Index Type	Column Name
PK_AARMINT	Unique	AARMINT_PIDM
PK_AARMINT	Unique	AARMINT_MEMBERSHIP
PK_AARMINT	Unique	AARMINT_MEMB_NO
PK_AARMINT	Unique	AARMINT_INTEREST
PK_AARMINT	Unique	AARMINT_TRANS_NO

Comments

Source Code Comments

Individual Membership Interest Table

Columns Comments for AARMINT_PIDM (1)

Source Code Comments

Internal system generated identification number for the person.

Columns Comments for AARMINT_MEMBERSHIP (2)

Source Code Comments

Membership code for the interest.

Columns Comments for AARMINT_MEMB_NO (3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMINT_INTEREST (4)

Source Code Comments

Interest code.

Columns Comments for AARMINT_TRANS_NO (5)

Source Code Comments

Transaction number for the membership payment.

Columns Comments for AARMINT_AMOUNT (6)

Source Code Comments

Amount of the membership payment.

Columns Comments for AARMINT_ACTIVITY_DATE (7)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMPRE

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AARMPRE_PIDM	AARMPRE_PIDM	NUMBER(8,0)	No	*	*
AARMPRE_MEMBERSHIP	AARMPRE_MEMBERSHIP	VARCHAR2(5)	No	*	*
AARMPRE_MEMB_NO	AARMPRE_MEMB_NO	VARCHAR2(7)	No	*	*
AARMPRE_DCPR_CODE	AARMPRE_DCPR_CODE	VARCHAR2(4)	No	*	*
AARMPRE_ACTIVITY_DATE	AARMPRE_ACTIVITY_DATE	DATE	No
AARMPRE_PREM_IND	AARMPRE_PREM_IND	VARCHAR2(1)	Yes
AARMPRE_PREM_DATE	AARMPRE_PREM_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARMPRE_PIDM	AARMEMB_PIDM	AARMEMB
AARMPRE_MEMBERSHIP	AARMEMB_MEMBERSHIP	AARMEMB
AARMPRE_MEMB_NO	AARMEMB_MEMB_NO	AARMEMB
AARMPRE_DCPR_CODE	ATVDCPR_CODE	ATVDCPR

Index

Index Name	Index Type	Column Name
PK_AARMPRE	Unique	AARMPRE_PIDM
PK_AARMPRE	Unique	AARMPRE_MEMBERSHIP
PK_AARMPRE	Unique	AARMPRE_MEMB_NO
PK_AARMPRE	Unique	AARMPRE_DCPR_CODE

Comments

Source Code Comments

Individual Premium Repeating Table

Columns Comments for AARMPRE_PIDM (1)

Source Code Comments

Internal system identification number for person.

Columns Comments for AARMPRE_MEMBERSHIP (2)

Source Code Comments

Code for the membership.

Columns Comments for AARMPRE_MEMB_NO (3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMPRE_DCPR_CODE (4)

Source Code Comments

Code for the membership premium.

Columns Comments for AARMPRE_ACTIVITY_DATE (5)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AARMPRE_PREM_IND (6)

Source Code Comments

Indicator to show whether premium has been sent.

Columns Comments for AARMPRE_PREM_DATE (7)

Source Code Comments

Date the premium was sent.

Table ATVAMCT

Schema Name ALUMNI
Label ATVAMCT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
ATVAMCT_CODE	ATVAMCT_CODE	VARCHAR2(5)	No	*
ATVAMCT_DESC	ATVAMCT_DESC	VARCHAR2(30)	No
ATVAMCT_ACTIVITY_DATE	ATVAMCT_ACTIVITY_DATE	DATE	No
ATVAMCT_LIFETIME_IND	ATVAMCT_LIFETIME_IND	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVAMCT	Unique	ATVAMCT_CODE

Comments

Source Code Comments

Membership Category Code Validation Table

Columns Comments for ATVAMCT_CODE (1)

Source Code Comments

Membership category code.

Columns Comments for ATVAMCT_DESC (2)

Source Code Comments

Membership category code description.

Columns Comments for ATVAMCT_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for ATVAMCT_LIFETIME_IND (4)

Source Code Comments

Indicator for lifetime categories.

Table ATVAMPM

Schema Name ALUMNI
Label ATVAMPM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
ATVAMPM_CODE	ATVAMPM_CODE	VARCHAR2(5)	No	*
ATVAMPM_DESC	ATVAMPM_DESC	VARCHAR2(30)	No
ATVAMPM_ACTIVITY_DATE	ATVAMPM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVAMPM	Unique	ATVAMPM_CODE

Comments

Source Code Comments

Membership Promotion Code Validation Table

Columns Comments for ATVAMPM_CODE (1)

Source Code Comments

Membership promotion code.

Columns Comments for ATVAMPM_DESC (2)

Source Code Comments

Membership promotion code description.

Columns Comments for ATVAMPM_ACTIVITY_DATE (3)

Source Code Comments

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

Table ATVAMST

Schema Name ALUMNI
Label ATVAMST
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
ATVAMST_CODE	ATVAMST_CODE	VARCHAR2(1)	No	*
ATVAMST_DESC	ATVAMST_DESC	VARCHAR2(30)	No
ATVAMST_ACTIVE_IND	ATVAMST_ACTIVE_IND	VARCHAR2(1)	No
ATVAMST_ACTIVITY_DATE	ATVAMST_ACTIVITY_DATE	DATE	No
ATVAMST_GRACE_IND	ATVAMST_GRACE_IND	VARCHAR2(1)	Yes
ATVAMST_EXPIRED_IND	ATVAMST_EXPIRED_IND	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVAMST	Unique	ATVAMST_CODE

Comments

Source Code Comments

Membership Status Code Validation Table

Columns Comments for ATVAMST_CODE (1)

Source Code Comments

Membership status code.

Columns Comments for ATVAMST_DESC (2)

Source Code Comments

Membership status code description.

Columns Comments for ATVAMST_ACTIVE_IND (3)

Source Code Comments

Membership status active indicator.

Columns Comments for ATVAMST_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for ATVAMST_GRACE_IND (5)

Source Code Comments

Grace period indicator.

Columns Comments for ATVAMST_EXPIRED_IND (6)

Source Code Comments

Expired indicator.

Table ATVAMTP

Schema Name ALUMNI
Label ATVAMTP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
ATVAMTP_CODE	ATVAMTP_CODE	VARCHAR2(3)	No	*
ATVAMTP_DESC	ATVAMTP_DESC	VARCHAR2(30)	No
ATVAMTP_ACTIVITY_DATE	ATVAMTP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVAMTP	Unique	ATVAMTP_CODE

Comments

Source Code Comments

Membership Type Validation Table

Columns Comments for ATVAMTP_CODE (1)

Source Code Comments

Membership type code.

Columns Comments for ATVAMTP_DESC (2)

Source Code Comments

Membership type code description.

Columns Comments for ATVAMTP_ACTIVITY_DATE (3)

Source Code Comments

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

Table ATVDCAM

Schema Name ALUMNI
Label ATVDCAM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
ATVDCAM_CODE	ATVDCAM_CODE	VARCHAR2(2)	No	*
ATVDCAM_DESC	ATVDCAM_DESC	VARCHAR2(30)	No
ATVDCAM_MAN_SYS_IND	ATVDCAM_MAN_SYS_IND	VARCHAR2(1)	No
ATVDCAM_ACTIVITY_DATE	ATVDCAM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVDCAM	Unique	ATVDCAM_CODE

Comments

Source Code Comments

Gift Society Assignment Validation Table

Columns Comments for ATVDCAM_CODE (1)

Source Code Comments

This field specifies the gift society assignment code.

Columns Comments for ATVDCAM_DESC (2)

Source Code Comments

This field specifies the description of the gift society assignment code.

Columns Comments for ATVDCAM_MAN_SYS_IND (3)

Source Code Comments

This field indicates how a gift society may be assigned, system calculated or manual assignment.

Columns Comments for ATVDCAM_ACTIVITY_DATE (4)

Source Code Comments

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

Table ATVFISC

Schema Name ALUMNI
Label ATVFISC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:11:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK