Model STVCOLL

Model Label : ERD for Banner Student STVCOLL Table
Path : BANNER DEV/Student/Common/STVCOLL/STVCOLL_ERD

List of Objects

Object Name	Object Type	Layer Name
AABMINT	TABLE	Default
ADBDESG	TABLE	Default
APBCONS	TABLE	Default
APRADEG	TABLE	Default
ASBSORG	TABLE	Default
GTVEMPH	TABLE	Default
PEBEMPL	TABLE	Default
SARCHKB	TABLE	Default
SARQKER	TABLE	Default
SARRRFT	TABLE	Default
SARWAAD	TABLE	Default
SCBCDEP	TABLE	Default
SCBCDTL	TABLE	Default
SCBCRSE	TABLE	Default
SCRCDTX	TABLE	Default
SCRRCOL	TABLE	Default
SDBPROG	TABLE	Default
SFRRGFE	TABLE	Default
SFRTMSL	TABLE	Default
SFRTMST	TABLE	Default
SGRASSI	TABLE	Default
SHBCOMI	TABLE	Default
SHBGSCH	TABLE	Default
SHRASDL	TABLE	Default
SHRASGE	TABLE	Default
SHRASTR	TABLE	Default
SHRCAST	TABLE	Default
SHRCOMM	TABLE	Default
SHRPREV	TABLE	Default
SHRPRGE	TABLE	Default
SHRTCKN	TABLE	Default
SIRDPCL	TABLE	Default
SIRNIST	TABLE	Default
SIRNLVA	TABLE	Default
SMRACAA	TABLE	Default
SMRAQUA	TABLE	Default
SMRAREX	TABLE	Default
SMRARSA	TABLE	Default
SMRARUL	TABLE	Default
SMRGCAA	TABLE	Default
SMRGREX	TABLE	Default
SMRGRSA	TABLE	Default
SMRGRUL	TABLE	Default
SMRIECO	TABLE	Default
SMRPCRS	TABLE	Default
SMRPRLE	TABLE	Default
SMRPRRQ	TABLE	Default
SMRPRSA	TABLE	Default
SMRRQCM	TABLE	Default
SMRSACA	TABLE	Default
SMRSARE	TABLE	Default
SMRSARS	TABLE	Default
SMRSARU	TABLE	Default
SMRSGCA	TABLE	Default
SMRSGRE	TABLE	Default
SMRSGRS	TABLE	Default
SMRSGRU	TABLE	Default
SMRSPRS	TABLE	Default
SMTPRRQ	TABLE	Default
SOBCURR	TABLE	Default
SOBODTE	TABLE	Default
SORCCOL	TABLE	Default
SORCOMM	TABLE	Default
SORDEGR	TABLE	Default
SOREXTN	TABLE	Default
SORRFND	TABLE	Default
SORRSTS	TABLE	Default
SORWDSP	TABLE	Default
SRBPRED	TABLE	Default
SRBRECR	TABLE	Default
SRTPREL	TABLE	Default
SSBDFEE	TABLE	Default
SSBOVRR	TABLE	Default
SSRRCOL	TABLE	Default
STVCOLL	TABLE	Default
TBRIACL	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 ADBDESG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADBDESG_DESG	ADBDESG_DESG	VARCHAR2(10)	No	*	*
ADBDESG_DESG	ADBDESG_DESG	VARCHAR2(10)	No	*	*
ADBDESG_NAME	ADBDESG_NAME	VARCHAR2(60)	No
ADBDESG_GL_NO_CREDIT	ADBDESG_GL_NO_CREDIT	VARCHAR2(60)	Yes
ADBDESG_GL_NO_DEBIT	ADBDESG_GL_NO_DEBIT	VARCHAR2(60)	Yes
ADBDESG_RESTR_IND	ADBDESG_RESTR_IND	VARCHAR2(1)	No
ADBDESG_COLL_CODE	ADBDESG_COLL_CODE	VARCHAR2(2)	Yes		*
ADBDESG_CMTP_CODE	ADBDESG_CMTP_CODE	VARCHAR2(2)	Yes		*
ADBDESG_CFAE_CODE	ADBDESG_CFAE_CODE	VARCHAR2(5)	No		*
ADBDESG_AMT_PLEDGED	ADBDESG_AMT_PLEDGED	NUMBER(13,2)	Yes
ADBDESG_AMT_PLEDGED_PAID	ADBDESG_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
ADBDESG_AMT_GIFT	ADBDESG_AMT_GIFT	NUMBER(13,2)	Yes
ADBDESG_ACTIVITY_DATE	ADBDESG_ACTIVITY_DATE	DATE	No
ADBDESG_COAS_CODE	ADBDESG_COAS_CODE	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE	ADBDESG_ACCI_CODE	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE	ADBDESG_FUND_CODE	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE	ADBDESG_ORGN_CODE	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE	ADBDESG_ACCT_CODE	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE	ADBDESG_PROG_CODE	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE	ADBDESG_ACTV_CODE	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE	ADBDESG_LOCN_CODE	VARCHAR2(6)	Yes
ADBDESG_DSTP_CODE	ADBDESG_DSTP_CODE	VARCHAR2(5)	No		*
ADBDESG_COAS_CODE_PLDG	ADBDESG_COAS_CODE_PLDG	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_PLDG	ADBDESG_ACCI_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_PLDG	ADBDESG_FUND_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_PLDG	ADBDESG_ORGN_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_PLDG	ADBDESG_ACCT_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_PLDG	ADBDESG_PROG_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_PLDG	ADBDESG_ACTV_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_PLDG	ADBDESG_LOCN_CODE_PLDG	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_PLDG	ADBDESG_GL_NO_CREDIT_PLDG	VARCHAR2(60)	Yes
ADBDESG_USER	ADBDESG_USER	VARCHAR2(30)	No
ADBDESG_START_DATE	ADBDESG_START_DATE	DATE	Yes
ADBDESG_END_DATE	ADBDESG_END_DATE	DATE	Yes
ADBDESG_DSTA_CODE	ADBDESG_DSTA_CODE	VARCHAR2(1)	Yes		*
ADBDESG_DGRP_CODE	ADBDESG_DGRP_CODE	VARCHAR2(5)	Yes		*
ADBDESG_DEPT_CODE	ADBDESG_DEPT_CODE	VARCHAR2(4)	Yes		*
ADBDESG_COAS_CODE_EXPND	ADBDESG_COAS_CODE_EXPND	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_EXPND	ADBDESG_ACCI_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_EXPND	ADBDESG_FUND_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_EXPND	ADBDESG_ORGN_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_EXPND	ADBDESG_ACCT_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_EXPND	ADBDESG_PROG_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_EXPND	ADBDESG_ACTV_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_EXPND	ADBDESG_LOCN_CODE_EXPND	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_EXPND	ADBDESG_GL_NO_CREDIT_EXPND	VARCHAR2(60)	Yes
ADBDESG_COAS_CODE_PYMNT	ADBDESG_COAS_CODE_PYMNT	VARCHAR2(1)	Yes
ADBDESG_ACCI_CODE_PYMNT	ADBDESG_ACCI_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_FUND_CODE_PYMNT	ADBDESG_FUND_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ORGN_CODE_PYMNT	ADBDESG_ORGN_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ACCT_CODE_PYMNT	ADBDESG_ACCT_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_PROG_CODE_PYMNT	ADBDESG_PROG_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_ACTV_CODE_PYMNT	ADBDESG_ACTV_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_LOCN_CODE_PYMNT	ADBDESG_LOCN_CODE_PYMNT	VARCHAR2(6)	Yes
ADBDESG_GL_NO_CREDIT_PYMNT	ADBDESG_GL_NO_CREDIT_PYMNT	VARCHAR2(60)	Yes
ADBDESG_WEB_GIFT_IND	ADBDESG_WEB_GIFT_IND	VARCHAR2(1)	Yes
ADBDESG_WEB_PLDG_IND	ADBDESG_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADBDESG_CFAE_CODE	ATVCFAE_CODE	ATVCFAE
ADBDESG_CMTP_CODE	ATVCMTP_CODE	ATVCMTP
ADBDESG_DGRP_CODE	ATVDGRP_CODE	ATVDGRP
ADBDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA
ADBDESG_DSTP_CODE	ATVDSTP_CODE	ATVDSTP
ADBDESG_COLL_CODE	STVCOLL_CODE	STVCOLL
ADBDESG_DEPT_CODE	STVDEPT_CODE	STVDEPT
ADBDESG_DESG	AGRGDES_DESG	AGRGDES
ADBDESG_DESG	APRDHIS_DESG	APRDHIS

Index

Index Name	Index Type	Column Name
PK_ADBDESG	Unique	ADBDESG_DESG

Comments

Source Code Comments

Designation Base Table

Columns Comments for ADBDESG_DESG (1)

Source Code Comments

This field specifies the five character alphanumeric designation code. Upon entry of this code, the Designation List Form is automatically updated.

Columns Comments for ADBDESG_NAME (2)

Source Code Comments

This field specifies the name of the designation. The name automatically defaults to this field.

Columns Comments for ADBDESG_GL_NO_CREDIT (3)

Source Code Comments

This field specifies the general ledger credit account number associated with the designation.

Columns Comments for ADBDESG_GL_NO_DEBIT (4)

Source Code Comments

General ledger debit account number is entered on ATVGIFT-Gift Type Validation Form. Not Used.

Columns Comments for ADBDESG_RESTR_IND (5)

Source Code Comments

This field indicates if the designation is retricted to transfer of pledges and/or gifts across fiscal years.

Columns Comments for ADBDESG_COLL_CODE (6)

Source Code Comments

This field specifies the college code associated with the designation.

Columns Comments for ADBDESG_CMTP_CODE (7)

Source Code Comments

This field specifies the type of campaign to which the designation is associated.

Columns Comments for ADBDESG_CFAE_CODE (8)

Source Code Comments

This field specifies the Council for Financial Aid to Education code associated with the designation. This code specifies the purpose for which gifts and grants have been made for CFAE reporting.

Columns Comments for ADBDESG_AMT_PLEDGED (9)

Source Code Comments

This system maintained field specifies the total amount pledged for a specific designation.

Columns Comments for ADBDESG_AMT_PLEDGED_PAID (10)

Source Code Comments

This system maintained field specifies the total amount of pledge payments for a specific designation.

Columns Comments for ADBDESG_AMT_GIFT (11)

Source Code Comments

This system maintained field specifies the amount of gifts and pledge payments for a specific designation.

Columns Comments for ADBDESG_ACTIVITY_DATE (12)

Source Code Comments

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

Columns Comments for ADBDESG_COAS_CODE (13)

Source Code Comments

Banner Finance Chart of Accounts Code.

Columns Comments for ADBDESG_ACCI_CODE (14)

Source Code Comments

Banner Finance Account Index Code.

Columns Comments for ADBDESG_FUND_CODE (15)

Source Code Comments

Banner Finance Fund Code.

Columns Comments for ADBDESG_ORGN_CODE (16)

Source Code Comments

Banner Finance Organization Code.

Columns Comments for ADBDESG_ACCT_CODE (17)

Source Code Comments

Banner Finance Account Code.

Columns Comments for ADBDESG_PROG_CODE (18)

Source Code Comments

Banner Finance Program Code.

Columns Comments for ADBDESG_ACTV_CODE (19)

Source Code Comments

Banner Finance Activity Code.

Columns Comments for ADBDESG_LOCN_CODE (20)

Source Code Comments

Banner Finance Location Code.

Columns Comments for ADBDESG_DSTP_CODE (21)

Source Code Comments

This field indicates the designation type.

Columns Comments for ADBDESG_COAS_CODE_PLDG (22)

Source Code Comments

BANNER Finance Chart of Accounts Code for the Pledge.

Columns Comments for ADBDESG_ACCI_CODE_PLDG (23)

Source Code Comments

BANNER Finance Account Index Code for the Pledge.

Columns Comments for ADBDESG_FUND_CODE_PLDG (24)

Source Code Comments

BANNER Finance Fund Code for the Pledge.

Columns Comments for ADBDESG_ORGN_CODE_PLDG (25)

Source Code Comments

BANNER Finance Organization Code for the Pledge.

Columns Comments for ADBDESG_ACCT_CODE_PLDG (26)

Source Code Comments

BANNER Finance Account Code for the Pledge.

Columns Comments for ADBDESG_PROG_CODE_PLDG (27)

Source Code Comments

BANNER Finance Program Code for the Pledge.

Columns Comments for ADBDESG_ACTV_CODE_PLDG (28)

Source Code Comments

BANNER Finance Activity Code for the Pledge.

Columns Comments for ADBDESG_LOCN_CODE_PLDG (29)

Source Code Comments

BANNER Finance Location Code for the Pledge.

Columns Comments for ADBDESG_GL_NO_CREDIT_PLDG (30)

Source Code Comments

Non-BANNER Finance General Ledge Credit Number for the Pledge.

Columns Comments for ADBDESG_USER (31)

Source Code Comments

User code of person adding or changing the record.

Columns Comments for ADBDESG_START_DATE (32)

Source Code Comments

Designation Start Date indicates the date which the designation becomes active.

Columns Comments for ADBDESG_END_DATE (33)

Source Code Comments

Designation End Date indicates the date which the designation is no longer active.

Columns Comments for ADBDESG_DSTA_CODE (34)

Source Code Comments

Designation Status Code indicates the status of the designation.

Columns Comments for ADBDESG_DGRP_CODE (35)

Source Code Comments

Designation Group Code is used to indicate designations which have a similar purpose of function.

Columns Comments for ADBDESG_DEPT_CODE (36)

Source Code Comments

Designation Department Code indicates the department associated with the designation.

Columns Comments for ADBDESG_COAS_CODE_EXPND (37)

Source Code Comments

Banner Finance Chart of Accounts Code for the Expenditure.

Columns Comments for ADBDESG_ACCI_CODE_EXPND (38)

Source Code Comments

Banner Finance Account Index Code for the Expenditure.

Columns Comments for ADBDESG_FUND_CODE_EXPND (39)

Source Code Comments

Banner Finance Fund Code for the Expenditure.

Columns Comments for ADBDESG_ORGN_CODE_EXPND (40)

Source Code Comments

Banner Finance Organization Code for the Expenditure.

Columns Comments for ADBDESG_ACCT_CODE_EXPND (41)

Source Code Comments

Banner Finance Account Code for the Expenditure.

Columns Comments for ADBDESG_PROG_CODE_EXPND (42)

Source Code Comments

Banner Finance Program Code for the Expenditure.

Columns Comments for ADBDESG_ACTV_CODE_EXPND (43)

Source Code Comments

Banner Finance Activity Code for the Expenditure.

Columns Comments for ADBDESG_LOCN_CODE_EXPND (44)

Source Code Comments

Banner Finance Location Code for the Expenditure.

Columns Comments for ADBDESG_GL_NO_CREDIT_EXPND (45)

Source Code Comments

This field specifies the General Ledger Credit account number associated with the Designation for the Expenditure.

Columns Comments for ADBDESG_COAS_CODE_PYMNT (46)

Source Code Comments

Banner Finance Chart of Accounts Code for the Payment.

Columns Comments for ADBDESG_ACCI_CODE_PYMNT (47)

Source Code Comments

Banner Finance Account Index Code for the Payment.

Columns Comments for ADBDESG_FUND_CODE_PYMNT (48)

Source Code Comments

Banner Finance Fund Code for the Payment.

Columns Comments for ADBDESG_ORGN_CODE_PYMNT (49)

Source Code Comments

Banner Finance Organization Code for the Payment.

Columns Comments for ADBDESG_ACCT_CODE_PYMNT (50)

Source Code Comments

Banner Finance Account Code for the Payment.

Columns Comments for ADBDESG_PROG_CODE_PYMNT (51)

Source Code Comments

Banner Finance Program Code for the Payment.

Columns Comments for ADBDESG_ACTV_CODE_PYMNT (52)

Source Code Comments

Banner Finance Activity Code for the Payment.

Columns Comments for ADBDESG_LOCN_CODE_PYMNT (53)

Source Code Comments

Banner Finance Location Code for the Payment.

Columns Comments for ADBDESG_GL_NO_CREDIT_PYMNT (54)

Source Code Comments

This field specifies the General Ledger Credit account number associated with the Designation for the Payment.

Columns Comments for ADBDESG_WEB_GIFT_IND (55)

Source Code Comments

Web Gift Indicator, Y indicates the gifts will be accepted via the Web.

Columns Comments for ADBDESG_WEB_PLDG_IND (56)

Source Code Comments

Web Pledge Indicator, Y indicates the pledges will be accepted via the Web.

Table APBCONS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APBCONS_PIDM	APBCONS_PIDM	NUMBER(8,0)	No	*	*
APBCONS_PIDM	APBCONS_PIDM	NUMBER(8,0)	No	*	*
APBCONS_PIDM	APBCONS_PIDM	NUMBER(8,0)	No	*	*
APBCONS_PREF_LAST_NAME	APBCONS_PREF_LAST_NAME	VARCHAR2(25)	Yes
APBCONS_PREF_FIRST_NAME	APBCONS_PREF_FIRST_NAME	VARCHAR2(15)	Yes
APBCONS_PREF_MI	APBCONS_PREF_MI	VARCHAR2(1)	Yes
APBCONS_NICKNAME	APBCONS_NICKNAME	VARCHAR2(40)	Yes
APBCONS_GRAD_NAME	APBCONS_GRAD_NAME	VARCHAR2(60)	Yes
APBCONS_PARENTS_NAME	APBCONS_PARENTS_NAME	VARCHAR2(50)	Yes
APBCONS_MAIDEN_LAST_NAME	APBCONS_MAIDEN_LAST_NAME	VARCHAR2(25)	Yes
APBCONS_PREF_CLAS	APBCONS_PREF_CLAS	VARCHAR2(4)	No
APBCONS_COLL_CODE_PREF	APBCONS_COLL_CODE_PREF	VARCHAR2(2)	Yes		*
APBCONS_HOME_CITY	APBCONS_HOME_CITY	VARCHAR2(20)	Yes
APBCONS_STAT_CODE_HOME	APBCONS_STAT_CODE_HOME	VARCHAR2(3)	Yes		*
APBCONS_NATN_CODE_HOME	APBCONS_NATN_CODE_HOME	VARCHAR2(5)	Yes		*
APBCONS_CM_NAME	APBCONS_CM_NAME	VARCHAR2(50)	Yes
APBCONS_ATYP_CODE_CM	APBCONS_ATYP_CODE_CM	VARCHAR2(2)	Yes		*
APBCONS_DOTT_CODE	APBCONS_DOTT_CODE	VARCHAR2(4)	Yes		*
APBCONS_INCM_CODE	APBCONS_INCM_CODE	VARCHAR2(2)	Yes		*
APBCONS_ATYP_CODE_PREF	APBCONS_ATYP_CODE_PREF	VARCHAR2(2)	Yes		*
APBCONS_ADDR_NAME	APBCONS_ADDR_NAME	VARCHAR2(35)	Yes
APBCONS_ACTIVITY_DATE	APBCONS_ACTIVITY_DATE	DATE	No
APBCONS_ATYP_CODE_GEOR	APBCONS_ATYP_CODE_GEOR	VARCHAR2(2)	Yes		*
APBCONS_SOCIETY_NAME	APBCONS_SOCIETY_NAME	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APBCONS_INCM_CODE	ATVINCM_CODE	ATVINCM
APBCONS_DOTT_CODE	ATVDOTT_CODE	ATVDOTT
APBCONS_STAT_CODE_HOME	STVSTAT_CODE	STVSTAT
APBCONS_COLL_CODE_PREF	STVCOLL_CODE	STVCOLL
APBCONS_NATN_CODE_HOME	STVNATN_CODE	STVNATN
APBCONS_PIDM	APRCHIS_PIDM	APRCHIS
APBCONS_PIDM	APRACYR_PIDM	APRACYR
APBCONS_PIDM	APRDHIS_PIDM	APRDHIS

Index

Index Name	Index Type	Column Name
APBCONS_KEY_INDEX2		APBCONS_PREF_CLAS
APBCONS_KEY_INDEX3		APBCONS_COLL_CODE_PREF
PK_APBCONS	Unique	APBCONS_PIDM

Comments

Source Code Comments

Constituent Base Table

Columns Comments for APBCONS_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number of the constituent.

Columns Comments for APBCONS_PREF_LAST_NAME (2)

Source Code Comments

This field specifies the preferred last name of the constituent.

Columns Comments for APBCONS_PREF_FIRST_NAME (3)

Source Code Comments

This field specifies the preferred first name of the constituent.

Columns Comments for APBCONS_PREF_MI (4)

Source Code Comments

This field specifies the preferred middle initial of the constituent.

Columns Comments for APBCONS_NICKNAME (5)

Source Code Comments

This field specifies the nickname used by the constituent.

Columns Comments for APBCONS_GRAD_NAME (6)

Source Code Comments

This field specifies the constituents name at the time of college graduation.

Columns Comments for APBCONS_PARENTS_NAME (7)

Source Code Comments

This field specifies the name of the constituents parents.

Columns Comments for APBCONS_MAIDEN_LAST_NAME (8)

Source Code Comments

This field specifies the constituents maiden name.

Columns Comments for APBCONS_PREF_CLAS (9)

Source Code Comments

This field specifies the year in which the constituent received the first degree or the year of expected graduation if the first degree has not yet been earned.

Columns Comments for APBCONS_COLL_CODE_PREF (10)

Source Code Comments

This field specifies the college within the institution with which the constituent prefers to be associated.

Columns Comments for APBCONS_HOME_CITY (11)

Source Code Comments

This field specifies the constituents hometown.

Columns Comments for APBCONS_STAT_CODE_HOME (12)

Source Code Comments

This field specifies the state of the constituents hometown.

Columns Comments for APBCONS_NATN_CODE_HOME (13)

Source Code Comments

This field specifies the country of the constituents hometown.

Columns Comments for APBCONS_CM_NAME (14)

Source Code Comments

This field specifies the combined mailing name for the constituent.

Columns Comments for APBCONS_ATYP_CODE_CM (15)

Source Code Comments

This field specifies the address type to be used for the combined mailing.

Columns Comments for APBCONS_DOTT_CODE (16)

Source Code Comments

This field specifies the constituents occupational title.

Columns Comments for APBCONS_INCM_CODE (17)

Source Code Comments

This field specifies the constituents income level.

Columns Comments for APBCONS_ATYP_CODE_PREF (18)

Source Code Comments

This field specifies the constituents preferred address for solicitations and acknowledgements.

Columns Comments for APBCONS_ADDR_NAME (19)

Source Code Comments

This field specifies the name to be used with the preferred address type.

Columns Comments for APBCONS_ACTIVITY_DATE (20)

Source Code Comments

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

Columns Comments for APBCONS_ATYP_CODE_GEOR (21)

Source Code Comments

This field specifes the address type of the address to be used as the preferred geographic region address.

Columns Comments for APBCONS_SOCIETY_NAME (22)

Source Code Comments

Gift Society name. This name will default to gift societies when they memberships are created. The name may be modified on the society form.

Table APRADEG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRADEG_PIDM	APRADEG_PIDM	NUMBER(8,0)	No	*	*
APRADEG_PIDM	APRADEG_PIDM	NUMBER(8,0)	No	*	*
APRADEG_SEQ_NO	APRADEG_SEQ_NO	NUMBER(5,0)	No	*
APRADEG_SBGI_CODE	APRADEG_SBGI_CODE	VARCHAR2(6)	Yes		*
APRADEG_DEGC_CODE	APRADEG_DEGC_CODE	VARCHAR2(6)	Yes		*
APRADEG_DATE	APRADEG_DATE	DATE	Yes
APRADEG_HONR_CODE	APRADEG_HONR_CODE	VARCHAR2(6)	Yes		*
APRADEG_COLL_CODE	APRADEG_COLL_CODE	VARCHAR2(2)	Yes		*
APRADEG_ACTIVITY_DATE	APRADEG_ACTIVITY_DATE	DATE	No
APRADEG_ACYR_CODE	APRADEG_ACYR_CODE	VARCHAR2(4)	Yes		*
APRADEG_ACYR_CODE_BULLETIN	APRADEG_ACYR_CODE_BULLETIN	VARCHAR2(4)	Yes		*
APRADEG_CAMP_CODE	APRADEG_CAMP_CODE	VARCHAR2(3)	Yes		*
APRADEG_DEPT_CODE	APRADEG_DEPT_CODE	VARCHAR2(4)	Yes		*
APRADEG_COMMENTS	APRADEG_COMMENTS	VARCHAR2(2000)	Yes
APRADEG_MAJR_CODE_MINR_1	APRADEG_MAJR_CODE_MINR_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_MINR_2	APRADEG_MAJR_CODE_MINR_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_1	APRADEG_MAJR_CODE_CONC_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_2	APRADEG_MAJR_CODE_CONC_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_3	APRADEG_MAJR_CODE_CONC_3	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_4	APRADEG_MAJR_CODE_CONC_4	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_5	APRADEG_MAJR_CODE_CONC_5	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_6	APRADEG_MAJR_CODE_CONC_6	VARCHAR2(4)	Yes		*
APRADEG_DEPT_CODE_2	APRADEG_DEPT_CODE_2	VARCHAR2(4)	Yes		*
APRADEG_HONR_CODE_2	APRADEG_HONR_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_3	APRADEG_HONR_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_4	APRADEG_HONR_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_5	APRADEG_HONR_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_1	APRADEG_HOND_CODE_1	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_2	APRADEG_HOND_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_3	APRADEG_HOND_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_4	APRADEG_HOND_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_5	APRADEG_HOND_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_OK_FOR_NOTES_IND	APRADEG_OK_FOR_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_IND	APRADEG_DISP_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_DATE	APRADEG_DISP_NOTES_DATE	DATE	Yes
APRADEG_USER	APRADEG_USER	VARCHAR2(30)	No