AABMINT AABMSHP AARINCM AARMBCM AARMBIN ATVAMGP ATVAMIN ATVAMST ATVAMTP STVCOLL

Model Membership


Model Label : BANNER Advancement Membership Processing
Path : BANNER DEV/Advancement/Advancement_ERD/Membership_ERD

List of Objects

Object Name Object Type Layer Name
AABMINT TABLE Default
AABMSHP TABLE Default
AARINCM TABLE Default
AARMBCM TABLE Default
AARMBIN TABLE Default
ATVAMGP TABLE Default
ATVAMIN TABLE Default
ATVAMST TABLE Default
ATVAMTP TABLE Default
STVCOLL TABLE Default

Comments

Model View

''

Table AABMINT

Schema Name ALUMNI
Label AABMINT
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
AABMINT_INTEREST AABMINT_INTEREST VARCHAR2(5) No *
AABMINT_NAME AABMINT_NAME VARCHAR2(60) No
AABMINT_AMIN_CODE AABMINT_AMIN_CODE VARCHAR2(2) No *
AABMINT_RESTR_IND AABMINT_RESTR_IND VARCHAR2(1) No
AABMINT_ACTIVITY_DATE AABMINT_ACTIVITY_DATE DATE No
AABMINT_DUES_SUB_IND AABMINT_DUES_SUB_IND VARCHAR2(1) Yes
AABMINT_GL_NO_CREDIT AABMINT_GL_NO_CREDIT VARCHAR2(60) Yes
AABMINT_AMGP_CODE AABMINT_AMGP_CODE VARCHAR2(5) Yes *
AABMINT_COLL_CODE AABMINT_COLL_CODE VARCHAR2(2) Yes *
AABMINT_COAS_CODE AABMINT_COAS_CODE VARCHAR2(1) Yes
AABMINT_ACCI_CODE AABMINT_ACCI_CODE VARCHAR2(6) Yes
AABMINT_FUND_CODE AABMINT_FUND_CODE VARCHAR2(6) Yes
AABMINT_ORGN_CODE AABMINT_ORGN_CODE VARCHAR2(6) Yes
AABMINT_ACCT_CODE AABMINT_ACCT_CODE VARCHAR2(6) Yes
AABMINT_PROG_CODE AABMINT_PROG_CODE VARCHAR2(6) Yes
AABMINT_ACTV_CODE AABMINT_ACTV_CODE VARCHAR2(6) Yes
AABMINT_LOCN_CODE AABMINT_LOCN_CODE VARCHAR2(6) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
AABMINT_AMGP_CODE ATVAMGP_CODE ATVAMGP
AABMINT_AMIN_CODE ATVAMIN_CODE ATVAMIN
AABMINT_COLL_CODE STVCOLL_CODE STVCOLL

Index

Index Name Index Type Column Name
PK_AABMINT Unique AABMINT_INTEREST

Comments

Source Code Comments

Membership Interest Header Table

Columns Comments for AABMINT_INTEREST (1)

Source Code Comments

Membership interest code.

Columns Comments for AABMINT_NAME (2)

Source Code Comments

Interest description of the name for the interest.

Columns Comments for AABMINT_AMIN_CODE (3)

Source Code Comments

Interest type code associated with the interest.

Columns Comments for AABMINT_RESTR_IND (4)

Source Code Comments

Indicates whether the interest is restricted to transfer of memberships over fiscal years.

Columns Comments for AABMINT_ACTIVITY_DATE (5)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AABMINT_DUES_SUB_IND (6)

Source Code Comments

Dues or subscription indicator for interest code.

Columns Comments for AABMINT_GL_NO_CREDIT (7)

Source Code Comments

General ledger account number associated with interest.

Columns Comments for AABMINT_AMGP_CODE (8)

Source Code Comments

Group code associated with the interest.

Columns Comments for AABMINT_COLL_CODE (9)

Source Code Comments

College code associated with the interest.

Columns Comments for AABMINT_COAS_CODE (10)

Source Code Comments

Banner Finance Chart of Accounts.

Columns Comments for AABMINT_ACCI_CODE (11)

Source Code Comments

Banner Finance Account Index Code.

Columns Comments for AABMINT_FUND_CODE (12)

Source Code Comments

Banner Finance Fund Code.

Columns Comments for AABMINT_ORGN_CODE (13)

Source Code Comments

Banner Finance Organization Code.

Columns Comments for AABMINT_ACCT_CODE (14)

Source Code Comments

Banner Finance Account Code.

Columns Comments for AABMINT_PROG_CODE (15)

Source Code Comments

Banner Finance Program Code.

Columns Comments for AABMINT_ACTV_CODE (16)

Source Code Comments

Banner Finance Activity Code.

Columns Comments for AABMINT_LOCN_CODE (17)

Source Code Comments

Banner Finance Location Code.

Table AABMSHP

Schema Name ALUMNI
Label AABMSHP
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
AABMSHP_MEMBERSHIP AABMSHP_MEMBERSHIP VARCHAR2(5) No *
AABMSHP_LETR_CODE_CARD AABMSHP_LETR_CODE_CARD VARCHAR2(15) Yes *
AABMSHP_ACTIVITY_DATE AABMSHP_ACTIVITY_DATE DATE No
AABMSHP_DEFAULT_INTEREST AABMSHP_DEFAULT_INTEREST VARCHAR2(5) Yes
AABMSHP_AMTP_CODE_DFLT AABMSHP_AMTP_CODE_DFLT VARCHAR2(3) Yes *
AABMSHP_NAME AABMSHP_NAME VARCHAR2(60) Yes
AABMSHP_AMST_CODE AABMSHP_AMST_CODE VARCHAR2(1) Yes *
AABMSHP_AMST_DATE AABMSHP_AMST_DATE DATE Yes
AABMSHP_GRACE_PERIOD AABMSHP_GRACE_PERIOD NUMBER(2,0) Yes
AABMSHP_DURATION AABMSHP_DURATION NUMBER(3,0) Yes
AABMSHP_ENDING_DATE_MO AABMSHP_ENDING_DATE_MO VARCHAR2(2) Yes
AABMSHP_ENDING_DATE_DAY AABMSHP_ENDING_DATE_DAY VARCHAR2(2) Yes
AABMSHP_LETR_CODE_RENEW AABMSHP_LETR_CODE_RENEW VARCHAR2(15) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
AABMSHP_AMST_CODE ATVAMST_CODE ATVAMST
AABMSHP_AMTP_CODE_DFLT ATVAMTP_CODE ATVAMTP

Index

Index Name Index Type Column Name
PK_AABMSHP Unique AABMSHP_MEMBERSHIP

Comments

Source Code Comments

Membership Header Table

Columns Comments for AABMSHP_MEMBERSHIP (1)

Source Code Comments

Membership code for association.

Columns Comments for AABMSHP_LETR_CODE_CARD (2)

Source Code Comments

Default letter code for membership card when membership is created.

Columns Comments for AABMSHP_ACTIVITY_DATE (3)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AABMSHP_DEFAULT_INTEREST (4)

Source Code Comments

Default interest code for membership.

Columns Comments for AABMSHP_AMTP_CODE_DFLT (5)

Source Code Comments

Membership type that is the default value for the membership.

Columns Comments for AABMSHP_NAME (6)

Source Code Comments

Membership name is the description of the membership code.

Columns Comments for AABMSHP_AMST_CODE (7)

Source Code Comments

Status indicator that is for the membership.

Columns Comments for AABMSHP_AMST_DATE (8)

Source Code Comments

Status date of the indicator.

Columns Comments for AABMSHP_GRACE_PERIOD (9)

Source Code Comments

The number of months a grace period is allowed for the membership.

Columns Comments for AABMSHP_DURATION (10)

Source Code Comments

Default duration of membership.

Columns Comments for AABMSHP_ENDING_DATE_MO (11)

Source Code Comments

The numeric value of the month that is used instead of duration.

Columns Comments for AABMSHP_ENDING_DATE_DAY (12)

Source Code Comments

The numeric value of the day that is used instead of duration.

Columns Comments for AABMSHP_LETR_CODE_RENEW (13)

Source Code Comments

Letter code defaulting to membership for renewal letter code.

Table AARINCM

Schema Name ALUMNI
Label AARINCM
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
AARINCM_INTEREST AARINCM_INTEREST VARCHAR2(5) No * *
AARINCM_SEQNO AARINCM_SEQNO NUMBER(9,2) No *
AARINCM_COMMENT AARINCM_COMMENT VARCHAR2(60) No
AARINCM_ACTIVITY_DATE AARINCM_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AARINCM_INTEREST AABMINT_INTEREST AABMINT

Index

Index Name Index Type Column Name
PK_AARINCM Unique AARINCM_INTEREST
PK_AARINCM Unique AARINCM_SEQNO

Comments

Source Code Comments

Membership Header Interests Comments Table

Columns Comments for AARINCM_INTEREST (1)

Source Code Comments

Membership Interest codes for association.

Columns Comments for AARINCM_SEQNO (2)

Source Code Comments

Comment sequence number.

Columns Comments for AARINCM_COMMENT (3)

Source Code Comments

Comment text.

Columns Comments for AARINCM_ACTIVITY_DATE (4)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMBCM

Schema Name ALUMNI
Label AARMBCM
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
AARMBCM_MEMBERSHIP AARMBCM_MEMBERSHIP VARCHAR2(5) No * *
AARMBCM_SEQNO AARMBCM_SEQNO NUMBER(9,2) No *
AARMBCM_COMMENT AARMBCM_COMMENT VARCHAR2(60) No
AARMBCM_ACTIVITY_DATE AARMBCM_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AARMBCM_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP

Index

Index Name Index Type Column Name
PK_AARMBCM Unique AARMBCM_MEMBERSHIP
PK_AARMBCM Unique AARMBCM_SEQNO

Comments

Source Code Comments

Membership Header Comments Table

Columns Comments for AARMBCM_MEMBERSHIP (1)

Source Code Comments

Membership code for association.

Columns Comments for AARMBCM_SEQNO (2)

Source Code Comments

Membership comment sequence number system generated.

Columns Comments for AARMBCM_COMMENT (3)

Source Code Comments

Membership comment line.

Columns Comments for AARMBCM_ACTIVITY_DATE (4)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMBIN

Schema Name ALUMNI
Label AARMBIN
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
AARMBIN_MEMBERSHIP AARMBIN_MEMBERSHIP VARCHAR2(5) No * *
AARMBIN_INTEREST AARMBIN_INTEREST VARCHAR2(5) No *
AARMBIN_ACTIVITY_DATE AARMBIN_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
AARMBIN_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP

Index

Index Name Index Type Column Name
PK_AARMBIN Unique AARMBIN_MEMBERSHIP
PK_AARMBIN Unique AARMBIN_INTEREST

Comments

Source Code Comments

Membership Header Interest Table

Columns Comments for AARMBIN_MEMBERSHIP (1)

Source Code Comments

Membership code for association.

Columns Comments for AARMBIN_INTEREST (2)

Source Code Comments

Membership interest code.

Columns Comments for AARMBIN_ACTIVITY_DATE (3)

Source Code Comments

System generated date that is updated on insert or update.

Table ATVAMGP

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVAMGP_CODE ATVAMGP_CODE VARCHAR2(5) No *
ATVAMGP_DESC ATVAMGP_DESC VARCHAR2(30) No
ATVAMGP_ACTIVITY_DATE ATVAMGP_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVAMGP Unique ATVAMGP_CODE

Comments

Source Code Comments

Membership Group Code Validation Table

Columns Comments for ATVAMGP_CODE (1)

Source Code Comments

Membership group code.

Columns Comments for ATVAMGP_DESC (2)

Source Code Comments

Membership group code description.

Columns Comments for ATVAMGP_ACTIVITY_DATE (3)

Source Code Comments

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

Table ATVAMIN

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVAMIN_CODE ATVAMIN_CODE VARCHAR2(2) No *
ATVAMIN_DESC ATVAMIN_DESC VARCHAR2(30) No
ATVAMIN_ACTIVITY_DATE ATVAMIN_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVAMIN Unique ATVAMIN_CODE

Comments

Source Code Comments

Membership Interest Type Validation Table

Columns Comments for ATVAMIN_CODE (1)

Source Code Comments

Membership Interest type code.

Columns Comments for ATVAMIN_DESC (2)

Source Code Comments

Membership Interest type code description.

Columns Comments for ATVAMIN_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 FK
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 FK
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 STVCOLL

Schema Name SATURN
Label STVCOLL
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:59:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
STVCOLL_CODE STVCOLL_CODE VARCHAR2(2) No *
STVCOLL_DESC STVCOLL_DESC VARCHAR2(30) No
STVCOLL_ADDR_STREET_LINE1 STVCOLL_ADDR_STREET_LINE1 VARCHAR2(30) Yes
STVCOLL_ADDR_STREET_LINE2 STVCOLL_ADDR_STREET_LINE2 VARCHAR2(30) Yes
STVCOLL_ADDR_STREET_LINE3 STVCOLL_ADDR_STREET_LINE3 VARCHAR2(30) Yes
STVCOLL_ADDR_CITY STVCOLL_ADDR_CITY VARCHAR2(20) Yes
STVCOLL_ADDR_STATE STVCOLL_ADDR_STATE VARCHAR2(2) Yes
STVCOLL_ADDR_COUNTRY STVCOLL_ADDR_COUNTRY VARCHAR2(28) Yes
STVCOLL_ADDR_ZIP_CODE STVCOLL_ADDR_ZIP_CODE VARCHAR2(10) Yes
STVCOLL_ACTIVITY_DATE STVCOLL_ACTIVITY_DATE DATE Yes
STVCOLL_SYSTEM_REQ_IND STVCOLL_SYSTEM_REQ_IND VARCHAR2(1) Yes
STVCOLL_VR_MSG_NO STVCOLL_VR_MSG_NO NUMBER(6,0) Yes
STVCOLL_STATSCAN_CDE3 STVCOLL_STATSCAN_CDE3 VARCHAR2(6) Yes
STVCOLL_DICD_CODE STVCOLL_DICD_CODE VARCHAR2(3) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_STVCOLL Unique STVCOLL_CODE

Comments

Source Code Comments

College Validation Table

Columns Comments for STVCOLL_CODE (1)

Source Code Comments

This field identifies the college code referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, Academic History and Degree Audit Modules. Reqd value: 00 - No College Designated.

Columns Comments for STVCOLL_DESC (2)

Source Code Comments

This field specifies the college or school (i.e. **Banner"s** highest administrative unit) associated with the college code.

Columns Comments for STVCOLL_ADDR_STREET_LINE1 (3)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE2 (4)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE3 (5)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_CITY (6)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STATE (7)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_COUNTRY (8)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_ZIP_CODE (9)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ACTIVITY_DATE (10)

Source Code Comments

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

Columns Comments for STVCOLL_SYSTEM_REQ_IND (11)

Source Code Comments

System Required Indicator

Columns Comments for STVCOLL_VR_MSG_NO (12)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the college code.

Columns Comments for STVCOLL_STATSCAN_CDE3 (13)

Source Code Comments

Statistics Canadian reporting institution specific code.

Columns Comments for STVCOLL_DICD_CODE (14)

Source Code Comments

MIS DISTRICT/DIVISION CODE: This field indicates equivalent district or division associated with an Institution.

Link between AARMBCM and AABMSHP

Caller : AARMBCM
Called : AABMSHP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARMBCM and AABMSHP ALUMNI

Link Foreign Key Between AARMBCM and AABMSHP

Caller : AARMBCM
Called : AABMSHP
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARMBCM and AABMSHP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMBCM AARMBCM_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP (1,1)-(0,n)

Comments

Link between AARMBIN and AABMSHP

Caller : AARMBIN
Called : AABMSHP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARMBIN and AABMSHP ALUMNI

Link Foreign Key Between AARMBIN and AABMSHP

Caller : AARMBIN
Called : AABMSHP
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARMBIN and AABMSHP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMBIN AARMBIN_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP (1,1)-(0,n)

Comments

Link between AARINCM and AABMINT

Caller : AARINCM
Called : AABMINT

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AARINCM and AABMINT ALUMNI

Link Foreign Key Between AARINCM and AABMINT

Caller : AARINCM
Called : AABMINT
Link Type : Refer(No Action )
Link : Link Foreign Key Between AARINCM and AABMINT

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARINCM AARINCM_INTEREST AABMINT_INTEREST AABMINT (1,1)-(0,n)

Comments

Link between AABMINT and ATVAMGP

Caller : AABMINT
Called : ATVAMGP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AABMINT and ATVAMGP ALUMNI

Link Foreign Key Between AABMINT and ATVAMGP

Caller : AABMINT
Called : ATVAMGP
Link Type : Refer(No Action )
Link : Link Foreign Key Between AABMINT and ATVAMGP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMINT AABMINT_AMGP_CODE ATVAMGP_CODE ATVAMGP (0,1)-(0,n)

Comments

Link between AABMINT and ATVAMIN

Caller : AABMINT
Called : ATVAMIN

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AABMINT and ATVAMIN ALUMNI

Link Foreign Key Between AABMINT and ATVAMIN

Caller : AABMINT
Called : ATVAMIN
Link Type : Refer(No Action )
Link : Link Foreign Key Between AABMINT and ATVAMIN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMINT AABMINT_AMIN_CODE ATVAMIN_CODE ATVAMIN (1,1)-(0,n)

Comments

Link between AABMINT and STVCOLL

Caller : AABMINT
Called : STVCOLL

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AABMINT and STVCOLL ALUMNI

Link Foreign Key Between AABMINT and STVCOLL

Caller : AABMINT
Called : STVCOLL
Link Type : Refer(No Action )
Link : Link Foreign Key Between AABMINT and STVCOLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMINT AABMINT_COLL_CODE STVCOLL_CODE STVCOLL (0,1)-(0,n)

Comments

Link between AABMSHP and ATVAMST

Caller : AABMSHP
Called : ATVAMST

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AABMSHP and ATVAMST ALUMNI

Link Foreign Key Between AABMSHP and ATVAMST

Caller : AABMSHP
Called : ATVAMST
Link Type : Refer(No Action )
Link : Link Foreign Key Between AABMSHP and ATVAMST

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMSHP AABMSHP_AMST_CODE ATVAMST_CODE ATVAMST (0,1)-(0,n)

Comments

Link between AABMSHP and ATVAMTP

Caller : AABMSHP
Called : ATVAMTP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between AABMSHP and ATVAMTP ALUMNI

Link Foreign Key Between AABMSHP and ATVAMTP

Caller : AABMSHP
Called : ATVAMTP
Link Type : Refer(No Action )
Link : Link Foreign Key Between AABMSHP and ATVAMTP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMSHP AABMSHP_AMTP_CODE_DFLT ATVAMTP_CODE ATVAMTP (0,1)-(0,n)

Comments