AARACKR AARAKCT AARAKDN AARAKEX AARAKIN AARAKMB AARMBDP AARMBRL AGRADJR GTVLETR

Model Membership Dues Rules


Model Label : BANNER Advancement Membership Dues Rules
Path : Default Folder/B70/Advancement/Membership Dues Rules

List of Objects

Object Name Object Type Layer Name
AARACKR TABLE Default
AARAKCT TABLE Default
AARAKDN TABLE Default
AARAKEX TABLE Default
AARAKIN TABLE Default
AARAKMB TABLE Default
AARMBDP TABLE Default
AARMBRL TABLE Default
AGRADJR TABLE Default
GTVLETR TABLE Default

Comments

Model View

''

Table AARACKR

Schema Name ALUMNI
Label AARACKR
Server name S4B70
Creation Date 09/29/2003 12:12:41:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

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

Schema Name ALUMNI
Label AARAKCT
Server name S4B70
Creation Date 09/29/2003 12:12:41:000

Table Columns information

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

Foreign Key information

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

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

Comments

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

Schema Name ALUMNI
Label AARAKDN
Server name S4B70
Creation Date 09/29/2003 12:12:42:000

Table Columns information

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

Foreign Key information

Column name is Foreign Key For Column on Table
AARAKDN_LETR_CODE GTVLETR_CODE GTVLETR
AARAKDN_LETR_CODE AARACKR_LETR_CODE AARACKR
AARAKDN_RULE_NO AARACKR_RULE_NO AARACKR
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

Comments

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

Schema Name ALUMNI
Label AARAKEX
Server name S4B70
Creation Date 09/29/2003 12:12:42:000

Table Columns information

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

Foreign Key information

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

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

Comments

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

Schema Name ALUMNI
Label AARAKIN
Server name S4B70
Creation Date 09/29/2003 12:12:42:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

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

Schema Name ALUMNI
Label AARAKMB
Server name S4B70
Creation Date 09/29/2003 12:12:42:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

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 AARMBDP

Schema Name ALUMNI
Label AARMBDP
Server name S4B70
Creation Date 09/29/2003 12:12:42:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARMBDP_BEGIN_DATE AARMBDP_BEGIN_DATE DATE No
AARMBDP_DCPR_CODE AARMBDP_DCPR_CODE VARCHAR2(4) No *
AARMBDP_ACTIVITY_DATE AARMBDP_ACTIVITY_DATE DATE No
AARMBDP_MEMBERSHIP AARMBDP_MEMBERSHIP VARCHAR2(5) Yes
AARMBDP_INTEREST AARMBDP_INTEREST VARCHAR2(5) Yes
AARMBDP_AMCT_CODE AARMBDP_AMCT_CODE VARCHAR2(5) Yes *
AARMBDP_AMST_CODE AARMBDP_AMST_CODE VARCHAR2(1) Yes *
AARMBDP_END_DATE AARMBDP_END_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
AARMBDP_AMCT_CODE ATVAMCT_CODE ATVAMCT
AARMBDP_AMST_CODE ATVAMST_CODE ATVAMST
AARMBDP_DCPR_CODE ATVDCPR_CODE ATVDCPR

Index

Index Name Index Type Column Name
AARMBDP_KEY_INDEX AARMBDP_DCPR_CODE
AARMBDP_KEY_INDEX2 AARMBDP_MEMBERSHIP

Comments

Source Code Comments

Membership Default Premium/Benefits Rule Table

Columns Comments for AARMBDP_BEGIN_DATE (1)

Source Code Comments

The begin date for the default premium/benefits.

Columns Comments for AARMBDP_DCPR_CODE (2)

Source Code Comments

Membership premium/benefits code.

Columns Comments for AARMBDP_ACTIVITY_DATE (3)

Source Code Comments

This is the system generated date of the transactions last insert or update.

Columns Comments for AARMBDP_MEMBERSHIP (4)

Source Code Comments

Membership for default premium/benefits.

Columns Comments for AARMBDP_INTEREST (5)

Source Code Comments

Interest for default premium/benefits.

Columns Comments for AARMBDP_AMCT_CODE (6)

Source Code Comments

Membership category code for default premium/benefits.

Columns Comments for AARMBDP_AMST_CODE (7)

Source Code Comments

Membership status code for default premium/benefits.

Columns Comments for AARMBDP_END_DATE (8)

Source Code Comments

The end date for the default premium/benefits.

Table AARMBRL

Schema Name ALUMNI
Label AARMBRL
Server name S4B70
Creation Date 09/29/2003 12:12:42:000

Table Columns information

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

Index

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

Comments

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

Schema Name ALUMNI
Label AGRADJR
Server name S4B70
Creation Date 09/29/2003 12:12:45:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AGRADJR_FIELD_NAME AGRADJR_FIELD_NAME VARCHAR2(20) No *
AGRADJR_DESC AGRADJR_DESC VARCHAR2(30) No
AGRADJR_ADJ_PLDG_IND AGRADJR_ADJ_PLDG_IND VARCHAR2(1) No
AGRADJR_ADJ_GIFT_IND AGRADJR_ADJ_GIFT_IND VARCHAR2(1) No
AGRADJR_ACTIVITY_DATE AGRADJR_ACTIVITY_DATE DATE No
AGRADJR_ADJ_DUES_IND 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

Comments

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

Schema Name GENERAL
Label GTVLETR
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVLETR_CODE GTVLETR_CODE VARCHAR2(15) No *
GTVLETR_ACTIVITY_DATE GTVLETR_ACTIVITY_DATE DATE No
GTVLETR_DUPL_IND GTVLETR_DUPL_IND VARCHAR2(1) No
GTVLETR_DESC GTVLETR_DESC VARCHAR2(30) Yes
GTVLETR_PRINT_COMMAND GTVLETR_PRINT_COMMAND VARCHAR2(10) Yes
GTVLETR_LETR_CODE_ALT 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

Comments

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 AARAKCT and AARACKR

Caller : AARAKCT
Called : AARACKR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKCT and AARACKR ALUMNI

Link Foreign Key Between AARAKCT and AARACKR

Caller : AARAKCT
Called : AARACKR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKCT and AARACKR

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)

Comments

Link between AARAKDN and AARACKR

Caller : AARAKDN
Called : AARACKR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKDN and AARACKR ALUMNI

Link Foreign Key Between AARAKDN and AARACKR

Caller : AARAKDN
Called : AARACKR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKDN and AARACKR

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)

Comments

Link between AARAKEX and AARACKR

Caller : AARAKEX
Called : AARACKR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKEX and AARACKR ALUMNI

Link Foreign Key Between AARAKEX and AARACKR

Caller : AARAKEX
Called : AARACKR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKEX and AARACKR

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)

Comments

Link between AARAKIN and AARACKR

Caller : AARAKIN
Called : AARACKR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKIN and AARACKR ALUMNI

Link Foreign Key Between AARAKIN and AARACKR

Caller : AARAKIN
Called : AARACKR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKIN and AARACKR

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)

Comments

Link between AARAKMB and AARACKR

Caller : AARAKMB
Called : AARACKR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKMB and AARACKR ALUMNI

Link Foreign Key Between AARAKMB and AARACKR

Caller : AARAKMB
Called : AARACKR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKMB and AARACKR

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)

Comments

Link between AARACKR and GTVLETR

Caller : AARACKR
Called : GTVLETR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARACKR and GTVLETR ALUMNI

Link Foreign Key Between AARACKR and GTVLETR

Caller : AARACKR
Called : GTVLETR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARACKR and GTVLETR

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)
AARACKR AARACKR_LETR_CODE_RECPT GTVLETR_CODE GTVLETR (0,1)-(0,n)
AARACKR AARACKR_LETR_CODE_MEMB GTVLETR_CODE GTVLETR (0,1)-(0,n)

Comments

Link between AARAKCT and GTVLETR

Caller : AARAKCT
Called : GTVLETR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKCT and GTVLETR ALUMNI

Link Foreign Key Between AARAKCT and GTVLETR

Caller : AARAKCT
Called : GTVLETR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKCT and GTVLETR

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)

Comments

Link between AARAKDN and GTVLETR

Caller : AARAKDN
Called : GTVLETR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKDN and GTVLETR ALUMNI

Link Foreign Key Between AARAKDN and GTVLETR

Caller : AARAKDN
Called : GTVLETR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKDN and GTVLETR

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)

Comments

Link between AARAKEX and GTVLETR

Caller : AARAKEX
Called : GTVLETR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKEX and GTVLETR ALUMNI

Link Foreign Key Between AARAKEX and GTVLETR

Caller : AARAKEX
Called : GTVLETR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKEX and GTVLETR

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)

Comments

Link between AARAKIN and GTVLETR

Caller : AARAKIN
Called : GTVLETR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKIN and GTVLETR ALUMNI

Link Foreign Key Between AARAKIN and GTVLETR

Caller : AARAKIN
Called : GTVLETR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKIN and GTVLETR

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)

Comments

Link between AARAKMB and GTVLETR

Caller : AARAKMB
Called : GTVLETR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARAKMB and GTVLETR ALUMNI

Link Foreign Key Between AARAKMB and GTVLETR

Caller : AARAKMB
Called : GTVLETR
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARAKMB and GTVLETR

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)

Comments