Model Membership_Dues_Payment

Model Label :

List of Objects

Object Name	Object Type	Layer Name
AABDUES	SQL Table	Default
AARDUES	SQL Table	Default
AARMEMB	SQL Table	Default
AARMINT	SQL Table	Default
ATVAMCT	SQL Table	Default
ATVFISC	SQL Table	Default
ATVGIFT	SQL Table	Default

Model View

Table AABDUES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AARDUES	SQL Table	S10B80.ALUMNI	Refer (no action)
AAVDUES	SQL View	S10B80.BANINST1	Use (select)
AABDUES	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDUES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AABDUES_KEY_INDEX3	SQL Index	S10B80.ALUMNI	Rely On
PK_AABDUES	SQL Index	S10B80.ALUMNI	Rely On
ATVFISC	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AABDUES

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:35:000	04/02/2008 13:49:19:000

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 AARDUES

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARDUES_PAYOR_PIDM	AABDUES_PAYOR_PIDM	AABDUES
AARDUES_TRANS_NO	AABDUES_TRANS_NO	AABDUES
AARDUES_AMCT_CODE	ATVAMCT_CODE	ATVAMCT
AARDUES_AMPM_CODE	ATVAMPM_CODE	ATVAMPM
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AAVDUES	SQL View	S10B80.BANINST1	Use (select)
AARDUES	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AARDUES_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
AARDUES_PAYOR_INDEX	SQL Index	S10B80.ALUMNI	Rely On
PK_AARDUES	SQL Index	S10B80.ALUMNI	Rely On
AABDUES	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMINT	SQL Table	S10B80.ALUMNI	Join
ATVAMCT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVAMPM	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARDUES

Object Dates

Creation Date	Analysis Date
04/02/2008 13:47:15:000	04/02/2008 13:49:23:000

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 AARMEMB

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARMEMB_PIDM	NUMBER(8,0)	No	*
AARMEMB_MEMBERSHIP	VARCHAR2(5)	No	*
AARMEMB_MEMB_NO	VARCHAR2(7)	No	*
AARMEMB_LETR_CODE	VARCHAR2(15)	Yes		*
AARMEMB_AMCT_CODE	VARCHAR2(5)	No		*
AARMEMB_AMTP_CODE	VARCHAR2(3)	No		*
AARMEMB_ENTRY_DATE	DATE	No
AARMEMB_AMST_CODE	VARCHAR2(1)	No		*
AARMEMB_AMST_DATE	DATE	No
AARMEMB_ACTIVITY_DATE	DATE	No
AARMEMB_REMINDER_PIDM	NUMBER(8,0)	Yes
AARMEMB_ATYP_CODE_REM	VARCHAR2(2)	Yes		*
AARMEMB_RENEWAL_PIDM	NUMBER(8,0)	Yes
AARMEMB_RENEWAL_DATE	DATE	Yes
AARMEMB_ATYP_CODE_REN	VARCHAR2(2)	Yes		*
AARMEMB_DCAM_CODE	VARCHAR2(2)	Yes		*
AARMEMB_DURATION	NUMBER(3,0)	Yes
AARMEMB_RULE_NO	NUMBER(4,0)	Yes
AARMEMB_CARD_IND	VARCHAR2(1)	Yes
AARMEMB_CARD_DATE	DATE	Yes
AARMEMB_GRACE_PERIOD	NUMBER(2,0)	Yes
AARMEMB_AMT_QUALIFY	NUMBER(11,2)	Yes
AARMEMB_EXP_DATE	DATE	Yes
AARMEMB_MEMB_NAME	VARCHAR2(120)	Yes
AARMEMB_LETR_CODE_RENEW	VARCHAR2(15)	Yes		*
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_LETR_CODE	GTVLETR_CODE	GTVLETR
AARMEMB_LETR_CODE_RENEW	GTVLETR_CODE	GTVLETR
AARMEMB_DCAM_CODE	ATVDCAM_CODE	ATVDCAM
AARMEMB_ATYP_CODE_REN	STVATYP_CODE	STVATYP
AARMEMB_ATYP_CODE_REM	STVATYP_CODE	STVATYP

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARCMEM	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMCMT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMINT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMPRE	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
AARMEMB_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
AARMEMBVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
AARMEMB	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AARMEMB_KEY_INDEX2	SQL Index	S10B80.ALUMNI	Rely On
PK_AARMEMB	SQL Index	S10B80.ALUMNI	Rely On
ATVAMCT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVAMST	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVAMTP	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDCAM	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMEMB

Object Dates

Creation Date	Analysis Date
04/02/2008 13:43:01:000	04/02/2008 13:49:18:000

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

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARMINT_PIDM	NUMBER(8,0)	No	*	*
AARMINT_MEMBERSHIP	VARCHAR2(5)	No	*	*
AARMINT_MEMB_NO	VARCHAR2(7)	No	*	*
AARMINT_INTEREST	VARCHAR2(5)	No	*
AARMINT_TRANS_NO	VARCHAR2(7)	No	*
AARMINT_AMOUNT	NUMBER(11,2)	No
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AARDUES	SQL Table	S10B80.ALUMNI	Join
AAVDUES	SQL View	S10B80.BANINST1	Use (select)
AARMINT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARMINT	SQL Index	S10B80.ALUMNI	Rely On
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMINT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:46:44:000	04/02/2008 13:49:22:000

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 ATVAMCT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVAMCT	Unique	ATVAMCT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AARAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARDUES	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMBDP	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMBRL	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVAMCTC	Oracle Package Cursor	S10B80.BANINST1.ATKAMCT	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVAMCT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_ATVAMCT	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVAMCT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:41:07:000	04/02/2008 13:49:16:000

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 ATVFISC

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVFISC_CODE	NUMBER(4,0)	No	*
ATVFISC_DESC	VARCHAR2(30)	No
ATVFISC_START_DATE	DATE	No
ATVFISC_END_DATE	DATE	No
ATVFISC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVFISC	Unique	ATVFISC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDUES	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAJBD	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAJIN	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRADAJ	SQL Table	S10B80.ALUMNI	Refer (no action)
ADRSUMM	SQL Table	S10B80.ALUMNI	Refer (no action)
AFREXPN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBPLDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGDS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
APBGHIS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRCHIS	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCTM	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDHIS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVPINS	SQL View	S10B80.BANINST1	Use (select)
F_FISC_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
F_HIGH_GIFT_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_HIGH_PLEDGE_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_GIFT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_NUMBER_PLEDGE_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_ANT_MAT_GIFT_ONE_PAY	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_ANT_MAT_GIFT_PAY	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_GIVING_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_NON_MAT_GIFT_MEMO	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_PLEDGED_AMOUNT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_PLEDGE_PAYMENT_YEAR	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_RLZ_MAT_GIFT_ONE_PAY	SQL Function	S10B80.BANINST1	Use (select)
F_TOTAL_RLZ_MAT_GIFT_PAY	SQL Function	S10B80.BANINST1	Use (select)
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWDKGHIS	Rely On
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWAKNHIS	Rely On
ATVFISC_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPLDG	Rely On
ATVFISCVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
ATVFISCVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKGHIS	Use (select)Rely On
ATVFISCVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNHIS	Use (select)Rely On
GETCURRFISCCODEC	Oracle Package Cursor	S10B80.BANINST1.AGKGIFT	Use (select)
GETCURRFISCCODEC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
FISC_CODE	Oracle Package Variable	S10B80.BANINST1.AGKGIFT	Rely On
FISC_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
FISC_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
ATVFISCC	Oracle Package Cursor	S10B80.BANINST1.ATKFISC	Use (select)Rely On
P_CALC_CURR_DATE	Oracle Package Procedure	S10B80.BANINST1.AGKPINS	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
ATVFISC	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_ATVFISC	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVFISC

Object Dates

Creation Date	Analysis Date
04/02/2008 13:44:19:000	04/02/2008 13:49:20:000

Source Code Comments

Fiscal Year Validation Table

Columns Comments for ATVFISC_CODE (# 1)

Source Code Comments

This field specifies the code for the fiscal year.

Columns Comments for ATVFISC_DESC (# 2)

Source Code Comments

This field specifies the description of the fiscal year code.

Columns Comments for ATVFISC_START_DATE (# 3)

Source Code Comments

This field specifies the start date for the fiscal year.

Columns Comments for ATVFISC_END_DATE (# 4)

Source Code Comments

This field specifies the end date for the fiscal year.

Columns Comments for ATVFISC_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table ATVGIFT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
ATVGIFT_CODE	VARCHAR2(2)	No	*
ATVGIFT_DESC	VARCHAR2(30)	No
ATVGIFT_CREDIT_CARD_IND	VARCHAR2(1)	Yes
ATVGIFT_MATCH_IND	VARCHAR2(1)	Yes
ATVGIFT_CFAE_GIFT_CATG	VARCHAR2(1)	Yes
ATVGIFT_GIFT_GROUP	VARCHAR2(1)	Yes
ATVGIFT_GIFT_GROUP_DESC	VARCHAR2(10)	Yes
ATVGIFT_ACTIVITY_DATE	DATE	No
ATVGIFT_RUCL_CODE	VARCHAR2(4)	Yes
ATVGIFT_DB_GL_ACCT	VARCHAR2(60)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_ATVGIFT	Unique	ATVGIFT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDUES	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAJBD	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAJIN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBGIFT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGDS	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAGIF	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRDCGT	SQL Table	S10B80.ALUMNI	Refer (no action)
APRTCFA	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVSRCE	SQL Table	S10B80.ALUMNI	Refer (no action)
AGVGFD1	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Join
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ATVGIFTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKCHIS	Use (select)Rely On
GETGIFTDESCC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Rely On
P_INSERT_AGBGIFT	Oracle Package Procedure	S10B80.BANINST1.AGKGIFT	Use (select)
ATVGIFT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKCHIS	Rely On
GIFT_DESC	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
ATVGIFTC	Oracle Package Cursor	S10B80.BANINST1.ATKGIFT	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
F_PLANNED_GIFT	Oracle Package Function	S10B80.BANINST1.AOKWEVN	Use (select)
ATVGIFT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_ATVGIFT	SQL Index	S10B80.ALUMNI	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVGIFT

Object Dates

Creation Date	Analysis Date
04/02/2008 13:46:39:000	04/02/2008 13:49:22:000

Source Code Comments

Gift Type Validation Table

Columns Comments for ATVGIFT_CODE (# 1)

Source Code Comments

This field specifies the code for the instrument of payment for a gift.

Columns Comments for ATVGIFT_DESC (# 2)

Source Code Comments

This field specifies the description of the gift type code.

Columns Comments for ATVGIFT_CREDIT_CARD_IND (# 3)

Source Code Comments

This field specifies whether a gift type is associated with credit card payment.

Columns Comments for ATVGIFT_MATCH_IND (# 4)

Source Code Comments

This field specifies whether a gift type is associated with a matching payment.

Columns Comments for ATVGIFT_CFAE_GIFT_CATG (# 5)

Source Code Comments

This field specifies the Council for Financial Aid to Education category associated with the gift type which is used for reporting purposes.

Columns Comments for ATVGIFT_GIFT_GROUP (# 6)

Source Code Comments

This field specifies the gift category associated with the gift type which is used for reporting purposes.

Columns Comments for ATVGIFT_GIFT_GROUP_DESC (# 7)

Source Code Comments

This field specifies the description of the gift category associated with the gift type.

Columns Comments for ATVGIFT_ACTIVITY_DATE (# 8)

Source Code Comments

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

Columns Comments for ATVGIFT_RUCL_CODE (# 9)

Source Code Comments

This is the rule class code used for the finance interface to the BANNER finance system.

Columns Comments for ATVGIFT_DB_GL_ACCT (# 10)

Source Code Comments

This is a debit account number for non-Banner Finance users.

Link between AARDUES and AARMINT

Join Information

Objects list
schema-view : S10B80.BANINST1.AAVDUES

Link List

Link Type	Link	Project
Join	Link Between AARDUES and AARMINT	ALUMNI

List of Real links

Link type	Between	And
Join	AARDUES	AARMINT

Link between AARMEMB and ATVAMCT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARMEMB and ATVAMCT (FK1_AARMEMB_INV_ATVAMCT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARMEMB	AARMEMB_AMCT_CODE	ATVAMCT_CODE	ATVAMCT	(1,1)-(0,n)

Link between AABDUES and ATVFISC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AABDUES and ATVFISC (FK1_AABDUES_INV_ATVFISC_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AABDUES	AABDUES_FISC_CODE	ATVFISC_CODE	ATVFISC	(1,1)-(0,n)

Link between AABDUES and ATVGIFT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AABDUES and ATVGIFT (FK1_AABDUES_INV_ATVGIFT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AABDUES	AABDUES_GIFT_CODE	ATVGIFT_CODE	ATVGIFT	(1,1)-(0,n)

Link between AARMINT and AARMEMB

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARMINT and AARMEMB (FK1_AARMINT_INV_AARMEMB_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARMINT	AARMINT_PIDM	AARMEMB_PIDM	AARMEMB	(1,1)-(0,n)
AARMINT	AARMINT_MEMBERSHIP	AARMEMB_MEMBERSHIP	AARMEMB	(1,1)-(0,n)
AARMINT	AARMINT_MEMB_NO	AARMEMB_MEMB_NO	AARMEMB	(1,1)-(0,n)

Link between AARDUES and AABDUES

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARDUES and AABDUES (FK1_AARDUES_INV_AABDUES_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARDUES	AARDUES_PAYOR_PIDM	AABDUES_PAYOR_PIDM	AABDUES	(1,1)-(0,n)
AARDUES	AARDUES_TRANS_NO	AABDUES_TRANS_NO	AABDUES	(1,1)-(0,n)

Link between AARDUES and ATVAMCT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARDUES and ATVAMCT (FK1_AARDUES_INV_ATVAMCT_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARDUES	AARDUES_AMCT_CODE	ATVAMCT_CODE	ATVAMCT	(1,1)-(0,n)