Model Membership_Dues_Rules*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
AARACKR	SQL Table	Default
AARAKCT	SQL Table	Default
AARAKDN	SQL Table	Default
AARAKEX	SQL Table	Default
AARAKIN	SQL Table	Default
AARAKMB	SQL Table	Default
AARMBRL	SQL Table	Default
AGRADJR	SQL Table	Default
GTVLETR	SQL Table	Default

Model View

Table AARACKR

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARACKR_RULE_NO	NUMBER(2,0)	No	*
AARACKR_RULE_PRTY	NUMBER(2,0)	No
AARACKR_LETR_CODE	VARCHAR2(15)	No	*	*
AARACKR_DOLLAR_FROM	NUMBER(13,2)	Yes
AARACKR_DOLLAR_TO	NUMBER(13,2)	Yes
AARACKR_ACTIVITY_DATE	DATE	No
AARACKR_LETR_IND	VARCHAR2(1)	Yes
AARACKR_LETR_CODE_RECPT	VARCHAR2(15)	Yes		*
AARACKR_RECPT_IND	VARCHAR2(1)	Yes
AARACKR_RULE_STATUS	VARCHAR2(1)	Yes
AARACKR_RULE_DATE	DATE	Yes
AARACKR_LETR_CODE_MEMB	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARACKR_LETR_CODE	GTVLETR_CODE	GTVLETR
AARACKR_LETR_CODE_RECPT	GTVLETR_CODE	GTVLETR
AARACKR_LETR_CODE_MEMB	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_AARACKR	Unique	AARACKR_LETR_CODE
PK_AARACKR	Unique	AARACKR_RULE_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AARAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKIN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMBRL	SQL Table	S10B80.ALUMNI	Join

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARACKR	SQL Index	S10B80.ALUMNI	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARACKR

Object Dates

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

Source Code Comments

Membership Ackowledgement Rules Table

Columns Comments for AARACKR_RULE_NO (# 1)

Source Code Comments

System generated unique number that identifies the rule.

Columns Comments for AARACKR_RULE_PRTY (# 2)

Source Code Comments

Number that specifies the priority order for the membership rule.

Columns Comments for AARACKR_LETR_CODE (# 3)

Source Code Comments

The letter code of the letter a member is to receive if dues qualify for this rule.

Columns Comments for AARACKR_DOLLAR_FROM (# 4)

Source Code Comments

Dollar from amount is the first part of the range for membership dues to qualify for rule.

Columns Comments for AARACKR_DOLLAR_TO (# 5)

Source Code Comments

Dollar to amount is the last part of the range for membership dues to qualify for the rule.

Columns Comments for AARACKR_ACTIVITY_DATE (# 6)

Source Code Comments

System generated date that indicates when the transaction was last updated or inserted.

Columns Comments for AARACKR_LETR_IND (# 7)

Source Code Comments

Letter indicator acknowledges that a letter is to be sent.

Columns Comments for AARACKR_LETR_CODE_RECPT (# 8)

Source Code Comments

Letter code that is to be used as a receipt.

Columns Comments for AARACKR_RECPT_IND (# 9)

Source Code Comments

Receipt indicator acknowledges that a receipt is to be sent/given.

Columns Comments for AARACKR_RULE_STATUS (# 10)

Source Code Comments

Status of the membership rule.

Columns Comments for AARACKR_RULE_DATE (# 11)

Source Code Comments

The date the rule status became inactive.

Columns Comments for AARACKR_LETR_CODE_MEMB (# 12)

Source Code Comments

The letter code the member is to receive for the acknowledgement.

Table AARAKCT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARAKCT_RULE_NO	NUMBER(2,0)	No	*	*
AARAKCT_LETR_CODE	VARCHAR2(15)	No	*	*
AARAKCT_AMCT_CODE	VARCHAR2(5)	No	*	*
AARAKCT_INCL_EXCL_IND	VARCHAR2(1)	No
AARAKCT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARAKCT_LETR_CODE	AARACKR_LETR_CODE	AARACKR
AARAKCT_RULE_NO	AARACKR_RULE_NO	AARACKR
AARAKCT_AMCT_CODE	ATVAMCT_CODE	ATVAMCT
AARAKCT_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_AARAKCT	Unique	AARAKCT_RULE_NO
PK_AARAKCT	Unique	AARAKCT_LETR_CODE
PK_AARAKCT	Unique	AARAKCT_AMCT_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARAKCT	SQL Index	S10B80.ALUMNI	Rely On
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVAMCT	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARAKCT

Object Dates

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

Source Code Comments

Membership Category Type Include/Exclude Rules Table

Columns Comments for AARAKCT_RULE_NO (# 1)

Source Code Comments

System generated unique number that identifies the rule.

Columns Comments for AARAKCT_LETR_CODE (# 2)

Source Code Comments

The letter code of the letter a member is to receive if dues qualify for this rule.

Columns Comments for AARAKCT_AMCT_CODE (# 3)

Source Code Comments

Category type code for the include/exclude rule.

Columns Comments for AARAKCT_INCL_EXCL_IND (# 4)

Source Code Comments

Include/Exclude indicator for rule.

Columns Comments for AARAKCT_ACTIVITY_DATE (# 5)

Source Code Comments

System generated date that indicates when the transaction was last updated or inserted.

Table AARAKDN

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARAKDN_RULE_NO	NUMBER(2,0)	No	*	*
AARAKDN_LETR_CODE	VARCHAR2(15)	No	*	*
AARAKDN_DONR_CODE	VARCHAR2(4)	No	*	*
AARAKDN_INCL_EXCL_IND	VARCHAR2(1)	No
AARAKDN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARAKDN_LETR_CODE	AARACKR_LETR_CODE	AARACKR
AARAKDN_RULE_NO	AARACKR_RULE_NO	AARACKR
AARAKDN_LETR_CODE	GTVLETR_CODE	GTVLETR
AARAKDN_DONR_CODE	ATVDONR_CODE	ATVDONR

Index

Index Name	Index Type	Column Name
PK_AARAKDN	Unique	AARAKDN_LETR_CODE
PK_AARAKDN	Unique	AARAKDN_RULE_NO
PK_AARAKDN	Unique	AARAKDN_DONR_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARAKDN	SQL Index	S10B80.ALUMNI	Rely On
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVDONR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARAKDN

Object Dates

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

Source Code Comments

Membership Donor Categories Include/Exclude Table

Columns Comments for AARAKDN_RULE_NO (# 1)

Source Code Comments

System generated unique number that identifies the rule.

Columns Comments for AARAKDN_LETR_CODE (# 2)

Source Code Comments

The letter code of the letter a member is to receive if dues qualify for this rule.

Columns Comments for AARAKDN_DONR_CODE (# 3)

Source Code Comments

Donor code for the include/exclude rule for letter code.

Columns Comments for AARAKDN_INCL_EXCL_IND (# 4)

Source Code Comments

Include/Exclude indicator for rule.

Columns Comments for AARAKDN_ACTIVITY_DATE (# 5)

Source Code Comments

System generated date that indicates when the transaction was last updated or inserted.

Table AARAKEX

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARAKEX_RULE_NO	NUMBER(2,0)	No	*	*
AARAKEX_LETR_CODE	VARCHAR2(15)	No	*	*
AARAKEX_EXCL_CODE	VARCHAR2(3)	No	*	*
AARAKEX_INCL_EXCL_IND	VARCHAR2(1)	No
AARAKEX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARAKEX_LETR_CODE	AARACKR_LETR_CODE	AARACKR
AARAKEX_RULE_NO	AARACKR_RULE_NO	AARACKR
AARAKEX_EXCL_CODE	ATVEXCL_CODE	ATVEXCL
AARAKEX_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_AARAKEX	Unique	AARAKEX_RULE_NO
PK_AARAKEX	Unique	AARAKEX_LETR_CODE
PK_AARAKEX	Unique	AARAKEX_EXCL_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARAKEX	SQL Index	S10B80.ALUMNI	Rely On
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVEXCL	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARAKEX

Object Dates

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

Source Code Comments

Membership Category Type Include/Exclude Rules Table

Columns Comments for AARAKEX_RULE_NO (# 1)

Source Code Comments

System generated unique number that identifies the rule.

Columns Comments for AARAKEX_LETR_CODE (# 2)

Source Code Comments

The letter code of the letter a member is to receive if dues qualify for this rule.

Columns Comments for AARAKEX_EXCL_CODE (# 3)

Source Code Comments

Exclusion code for the include/exclude rule.

Columns Comments for AARAKEX_INCL_EXCL_IND (# 4)

Source Code Comments

Include/Exclude indicator for rule.

Columns Comments for AARAKEX_ACTIVITY_DATE (# 5)

Source Code Comments

System generated date that indicates when the transaction was last updated or inserted.

Table AARAKIN

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARAKIN_RULE_NO	NUMBER(2,0)	No	*	*
AARAKIN_LETR_CODE	VARCHAR2(15)	No	*	*
AARAKIN_INTEREST	VARCHAR2(5)	No	*
AARAKIN_INCL_EXCL_IND	VARCHAR2(1)	No
AARAKIN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARAKIN_LETR_CODE	AARACKR_LETR_CODE	AARACKR
AARAKIN_RULE_NO	AARACKR_RULE_NO	AARACKR
AARAKIN_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_AARAKIN	Unique	AARAKIN_RULE_NO
PK_AARAKIN	Unique	AARAKIN_LETR_CODE
PK_AARAKIN	Unique	AARAKIN_INTEREST

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARAKIN	SQL Index	S10B80.ALUMNI	Rely On
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARAKIN

Object Dates

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

Source Code Comments

Interest Include/Exclude Rules Table

Columns Comments for AARAKIN_RULE_NO (# 1)

Source Code Comments

System generated unique number that identifies the rule.

Columns Comments for AARAKIN_LETR_CODE (# 2)

Source Code Comments

The letter code of the letter a member is to receive if dues qualify for this rule.

Columns Comments for AARAKIN_INTEREST (# 3)

Source Code Comments

Interest code for the include/exclude rule.

Columns Comments for AARAKIN_INCL_EXCL_IND (# 4)

Source Code Comments

Include/Exclude indicator for rule.

Columns Comments for AARAKIN_ACTIVITY_DATE (# 5)

Source Code Comments

System generated date that indicates when the transaction was last updated or inserted.

Table AARAKMB

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARAKMB_RULE_NO	NUMBER(2,0)	No	*	*
AARAKMB_LETR_CODE	VARCHAR2(15)	No	*	*
AARAKMB_MEMBERSHIP	VARCHAR2(5)	No	*
AARAKMB_INCL_EXCL_IND	VARCHAR2(1)	No
AARAKMB_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARAKMB_LETR_CODE	AARACKR_LETR_CODE	AARACKR
AARAKMB_RULE_NO	AARACKR_RULE_NO	AARACKR
AARAKMB_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_AARAKMB	Unique	AARAKMB_RULE_NO
PK_AARAKMB	Unique	AARAKMB_LETR_CODE
PK_AARAKMB	Unique	AARAKMB_MEMBERSHIP

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARAKMB	SQL Index	S10B80.ALUMNI	Rely On
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARAKMB

Object Dates

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

Source Code Comments

Membership Include/Exclude Rules Table

Columns Comments for AARAKMB_RULE_NO (# 1)

Source Code Comments

System generated unique number that identifies the rule.

Columns Comments for AARAKMB_LETR_CODE (# 2)

Source Code Comments

The letter code of the letter a member is to receive if dues qualify for this rule.

Columns Comments for AARAKMB_MEMBERSHIP (# 3)

Source Code Comments

Membership code for the include/exclude rule.

Columns Comments for AARAKMB_INCL_EXCL_IND (# 4)

Source Code Comments

Include/Exclude indicator for rule.

Columns Comments for AARAKMB_ACTIVITY_DATE (# 5)

Source Code Comments

System generated date that indicates when the transaction was last updated or inserted.

Table AARMBRL

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
AARMBRL_MEMBERSHIP	VARCHAR2(5)	No	*
AARMBRL_RULE_NO	NUMBER(4,0)	No	*	*
AARMBRL_PRIORITY_NO	NUMBER(5,2)	No
AARMBRL_AMCT_CODE	VARCHAR2(5)	No		*
AARMBRL_AMST_CODE_1	VARCHAR2(1)	No		*
AARMBRL_AMST_CODE_2	VARCHAR2(1)	No		*
AARMBRL_ACTIVITY_DATE	DATE	No
AARMBRL_AMT_QUALIFY	NUMBER(11,2)	No
AARMBRL_NO_DAYS	NUMBER(3,0)	No
AARMBRL_DURATION_MONTHS	NUMBER(3,0)	Yes
AARMBRL_QUALIFY_DATE_MO	VARCHAR2(2)	No
AARMBRL_QUALIFY_DATE_DAY	VARCHAR2(2)	No
AARMBRL_QUALIFY_MONTHS	NUMBER(3,0)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AARMBRL_AMCT_CODE	ATVAMCT_CODE	ATVAMCT
AARMBRL_AMST_CODE_1	ATVAMST_CODE	ATVAMST
AARMBRL_AMST_CODE_2	ATVAMST_CODE	ATVAMST
AARMBRL_RULE_NO	AARACKR_RULE_NO	AARACKR

Index

Index Name	Index Type	Column Name
PK_AARMBRL	Unique	AARMBRL_MEMBERSHIP
PK_AARMBRL	Unique	AARMBRL_RULE_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_AARMBRL	SQL Index	S10B80.ALUMNI	Rely On
AARACKR	SQL Table	S10B80.ALUMNI	Join
ATVAMCT	SQL Table	S10B80.ALUMNI	Refer (no action)
ATVAMST	SQL Table	S10B80.ALUMNI	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMBRL

Object Dates

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

Source Code Comments

Membership Rules Table

Columns Comments for AARMBRL_MEMBERSHIP (# 1)

Source Code Comments

Membership program code for membership rules.

Columns Comments for AARMBRL_RULE_NO (# 2)

Source Code Comments

Rule number for membership program code, this field is system generated.

Columns Comments for AARMBRL_PRIORITY_NO (# 3)

Source Code Comments

Priority number of the rule for membership code.

Columns Comments for AARMBRL_AMCT_CODE (# 4)

Source Code Comments

Category Code for the membership code.

Columns Comments for AARMBRL_AMST_CODE_1 (# 5)

Source Code Comments

Status indicator for the dues if amount is greater than or equal to qualifying amount.

Columns Comments for AARMBRL_AMST_CODE_2 (# 6)

Source Code Comments

Status indicator for the dues if amount is less than the qualifying amount.

Columns Comments for AARMBRL_ACTIVITY_DATE (# 7)

Source Code Comments

System generated field that sets the activity date on an insert/update.

Columns Comments for AARMBRL_AMT_QUALIFY (# 8)

Source Code Comments

Amount to qualify for this rule for membership code.

Columns Comments for AARMBRL_NO_DAYS (# 9)

Source Code Comments

The number of days that establish a time period where, if money is paid within
would go towards next years membership.

Columns Comments for AARMBRL_DURATION_MONTHS (# 10)

Source Code Comments

The number of duration months for this rule for the membership code.

Columns Comments for AARMBRL_QUALIFY_DATE_MO (# 11)

Source Code Comments

The Number associated with qualifying month for this rule for the membership code.

Columns Comments for AARMBRL_QUALIFY_DATE_DAY (# 12)

Source Code Comments

The Number associated with qualifying day for the qualifing month for this rule for membership code.

Columns Comments for AARMBRL_QUALIFY_MONTHS (# 13)

Source Code Comments

Length of months this rule qualifies for the membership code specified.

Table AGRADJR

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
AGRADJR_FIELD_NAME	VARCHAR2(20)	No	*
AGRADJR_DESC	VARCHAR2(30)	No
AGRADJR_ADJ_PLDG_IND	VARCHAR2(1)	No
AGRADJR_ADJ_GIFT_IND	VARCHAR2(1)	No
AGRADJR_ACTIVITY_DATE	DATE	No
AGRADJR_ADJ_DUES_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_AGRADJR	Unique	AGRADJR_FIELD_NAME

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AGRADJR

Object Dates

Creation Date	Analysis Date
04/02/2008 13:45:40:000	04/02/2008 13:49:21:000

Source Code Comments

Prior Years Adjustment Rule Table

Columns Comments for AGRADJR_FIELD_NAME (# 1)

Source Code Comments

Gift/Pledge Adjustment field name to be adjusted.

Columns Comments for AGRADJR_DESC (# 2)

Source Code Comments

This field is the decription of the adjustment field.

Columns Comments for AGRADJR_ADJ_PLDG_IND (# 3)

Source Code Comments

Adjust pledge fields indicator.

Columns Comments for AGRADJR_ADJ_GIFT_IND (# 4)

Source Code Comments

Adjust gift fields indicator.

Columns Comments for AGRADJR_ACTIVITY_DATE (# 5)

Source Code Comments

Date of last change.

Columns Comments for AGRADJR_ADJ_DUES_IND (# 6)

Source Code Comments

Adjust dues fields indicator.

Table GTVLETR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GTVLETR_CODE	VARCHAR2(15)	No	*
GTVLETR_ACTIVITY_DATE	DATE	No
GTVLETR_DUPL_IND	VARCHAR2(1)	No
GTVLETR_DESC	VARCHAR2(30)	Yes
GTVLETR_PRINT_COMMAND	VARCHAR2(10)	Yes
GTVLETR_LETR_CODE_ALT	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVLETR_LETR_CODE_ALT	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_GTVLETR	Unique	GTVLETR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVLETR	Oracle Synonym	S10B80.FAISMGR	Rely On
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AABMSHP	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKIN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARRLET	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKPC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRALET	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
GEBFUNC	SQL Table	S10B80.GENERAL	Refer (no action)
GERFCOR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCALC	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCOLR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRORDR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBPPRF	SQL Table	S10B80.GENERAL	Refer (no action)
GURMAIL	SQL Table	S10B80.GENERAL	Refer (no action)
RBRGMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRMESG	SQL Table	S10B80.FAISMGR	Refer (no action)
RORSTRF	SQL Table	S10B80.FAISMGR	Refer (no action)
RRRTMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWALT	SQL Table	S10B80.SATURN	Refer (no action)
SFREPRT	SQL Table	S10B80.SATURN	Refer (no action)
SHBGADR	SQL Table	S10B80.SATURN	Refer (no action)
SHRTPRT	SQL Table	S10B80.SATURN	Refer (no action)
SOBMATL	SQL Table	S10B80.SATURN	Refer (no action)
SORELTL	SQL Table	S10B80.SATURN	Refer (no action)
F_STUDENT_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
CHK_GURMAIL_DUPS_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
CHK_GURMAIL_DUPS_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
GTVLETRC	Oracle Package Cursor	S10B80.BANINST1.GTKLETR	Use (select)Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Use (select)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)
P_PA_GTVLETR_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_REORDERING	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP_DISPLAYRULE	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GTVLETR_LIKE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
GTVLETR	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_GTVLETR	SQL Index	S10B80.GENERAL	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVLETR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:09:000	04/02/2008 21:17:50:000

Source Code Comments

Letter Process Letter Validation Table

Columns Comments for GTVLETR_CODE (# 1)

Source Code Comments

This field identifies the letter code referenced on the Recruiting Material Control Form (SRAMATL) and the Letter Process Form (GUALETR).

Columns Comments for GTVLETR_ACTIVITY_DATE (# 2)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for GTVLETR_DUPL_IND (# 3)

Source Code Comments

Y = Duplicates may be printed for this letter code, N = no dups.

Columns Comments for GTVLETR_DESC (# 4)

Source Code Comments

This field specifies the recruiting letter/material associated with the letter code.

Columns Comments for GTVLETR_PRINT_COMMAND (# 5)

Source Code Comments

This field identifies alternate print command code (e.g. PL - Print Landscape) for associated letter/material.

Columns Comments for GTVLETR_LETR_CODE_ALT (# 6)

Source Code Comments

Alternate Letter code for letter codes that do not allow duplicates.

Link between AARMBRL and AARACKR

Join Information

Objects list
User link

Link List

Link Type	Link	Project
Join	Link Between AARMBRL and AARACKR	ALUMNI

List of Real links

Link type	Between	And
Join	AARMBRL	AARACKR

Link between AARACKR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARACKR and GTVLETR (FK1_AARACKR_INV_GTVLETR_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AARACKR and GTVLETR (FK2_AARACKR_INV_GTVLETR_CODE)	ALUMNI
Refer (no action)	Link Informative Foreign Key Between AARACKR and GTVLETR (FK3_AARACKR_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARACKR	AARACKR_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARACKR	AARACKR_LETR_CODE_RECPT	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARACKR	AARACKR_LETR_CODE_MEMB	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Link between AARAKCT and AARACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKCT and AARACKR (FK1_AARAKCT_INV_AARACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKCT	AARAKCT_RULE_NO	AARACKR_RULE_NO	AARACKR	(1,1)-(0,n)
AARAKCT	AARAKCT_LETR_CODE	AARACKR_LETR_CODE	AARACKR	(1,1)-(0,n)

Link between AARAKCT and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKCT and GTVLETR (FK1_AARAKCT_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKCT	AARAKCT_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AARAKDN and AARACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKDN and AARACKR (FK1_AARAKDN_INV_AARACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKDN	AARAKDN_RULE_NO	AARACKR_RULE_NO	AARACKR	(1,1)-(0,n)
AARAKDN	AARAKDN_LETR_CODE	AARACKR_LETR_CODE	AARACKR	(1,1)-(0,n)

Link between AARAKDN and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKDN and GTVLETR (FK1_AARAKDN_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKDN	AARAKDN_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AARAKEX and AARACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKEX and AARACKR (FK1_AARAKEX_INV_AARACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKEX	AARAKEX_RULE_NO	AARACKR_RULE_NO	AARACKR	(1,1)-(0,n)
AARAKEX	AARAKEX_LETR_CODE	AARACKR_LETR_CODE	AARACKR	(1,1)-(0,n)

Link between AARAKEX and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKEX and GTVLETR (FK1_AARAKEX_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKEX	AARAKEX_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AARAKIN and AARACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKIN and AARACKR (FK1_AARAKIN_INV_AARACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKIN	AARAKIN_RULE_NO	AARACKR_RULE_NO	AARACKR	(1,1)-(0,n)
AARAKIN	AARAKIN_LETR_CODE	AARACKR_LETR_CODE	AARACKR	(1,1)-(0,n)

Link between AARAKIN and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKIN and GTVLETR (FK1_AARAKIN_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKIN	AARAKIN_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between AARAKMB and AARACKR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKMB and AARACKR (FK1_AARAKMB_INV_AARACKR_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKMB	AARAKMB_RULE_NO	AARACKR_RULE_NO	AARACKR	(1,1)-(0,n)
AARAKMB	AARAKMB_LETR_CODE	AARACKR_LETR_CODE	AARACKR	(1,1)-(0,n)

Link between AARAKMB and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between AARAKMB and GTVLETR (FK1_AARAKMB_INV_GTVLETR_CODE)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
AARAKMB	AARAKMB_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between GTVLETR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GTVLETR and GTVLETR (FK1_GTVLETR_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GTVLETR	GTVLETR_LETR_CODE_ALT	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)