Model Designation

Model Label : BANNER Advancement Designation Processing
Path : Default Folder/B70/Advancement/Designation

List of Objects

Object Name	Object Type	Layer Name
ADBDESG	TABLE	Default
ADRADAJ	TABLE	Default
ADRATTR	TABLE	Default
ADRCONF	TABLE	Default
ADRDIDS	TABLE	Default
ADRFUND	TABLE	Default
ADRSUMM	TABLE	Default
AFRDESG	TABLE	Default
AGBWPLG	TABLE	Default
AGRGDES	TABLE	Default
AGRGHDE	TABLE	Default
AGRPDES	TABLE	Default
AMRDESG	TABLE	Default
APRDHIS	TABLE	Default
ATVCFAE	TABLE	Default
ATVCMTP	TABLE	Default
ATVDGRP	TABLE	Default
ATVDSTA	TABLE	Default
ATVDSTP	TABLE	Default
AXRMDES	TABLE	Default
STVCOLL	TABLE	Default
STVDEPT	TABLE	Default

Comments

Model View

Table ADBDESG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
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

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 ADRADAJ

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADRADAJ_DESG	ADRADAJ_DESG	VARCHAR2(10)	No	*	*
ADRADAJ_SEQ_NO	ADRADAJ_SEQ_NO	NUMBER(5,0)	No	*
ADRADAJ_ADJT_CODE	ADRADAJ_ADJT_CODE	VARCHAR2(2)	No		*
ADRADAJ_REASON	ADRADAJ_REASON	VARCHAR2(60)	Yes
ADRADAJ_DATE	ADRADAJ_DATE	DATE	No
ADRADAJ_AMT	ADRADAJ_AMT	NUMBER(11,2)	No
ADRADAJ_FISC_CODE	ADRADAJ_FISC_CODE	NUMBER(4,0)	No		*
ADRADAJ_ACTIVITY_DATE	ADRADAJ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRADAJ_ADJT_CODE	ATVADJT_CODE	ATVADJT
ADRADAJ_DESG	ADBDESG_DESG	ADBDESG
ADRADAJ_FISC_CODE	ATVFISC_CODE	ATVFISC

Index

Index Name	Index Type	Column Name
PK_ADRADAJ	Unique	ADRADAJ_DESG
PK_ADRADAJ	Unique	ADRADAJ_SEQ_NO

Comments

Source Code Comments

Designation Adjustment Repeating Table

Columns Comments for ADRADAJ_DESG (1)

Source Code Comments

This field specifies the five character alphanumeric designation code.

Columns Comments for ADRADAJ_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number for designation adjustments.

Columns Comments for ADRADAJ_ADJT_CODE (3)

Source Code Comments

This field specifies the type of adjustment that is associated with a specific designaton.

Columns Comments for ADRADAJ_REASON (4)

Source Code Comments

This field specifies the description of the adjustment type code. This description defaults from the Designation Adjustment Code Validation Form.

Columns Comments for ADRADAJ_DATE (5)

Source Code Comments

This field specifies the date associated with the posting of the adjustment to the designation.

Columns Comments for ADRADAJ_AMT (6)

Source Code Comments

This field specifies the amount of the designation adjustment.

Columns Comments for ADRADAJ_FISC_CODE (7)

Source Code Comments

This field specifies the fiscal year of the designation adjustment.

Columns Comments for ADRADAJ_ACTIVITY_DATE (8)

Source Code Comments

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

Table ADRATTR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADRATTR_DESG	ADRATTR_DESG	VARCHAR2(10)	No	*	*
ADRATTR_DATR_CODE	ADRATTR_DATR_CODE	VARCHAR2(4)	No	*	*
ADRATTR_ACTIVITY_DATE	ADRATTR_ACTIVITY_DATE	DATE	No
ADRATTR_USER	ADRATTR_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRATTR_DATR_CODE	ATVDATR_CODE	ATVDATR
ADRATTR_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_ADRATTR	Unique	ADRATTR_DESG
PK_ADRATTR	Unique	ADRATTR_DATR_CODE

Comments

Source Code Comments

Designation Attributes Table

Columns Comments for ADRATTR_DESG (1)

Source Code Comments

Designation Attribute Designation.

Columns Comments for ADRATTR_DATR_CODE (2)

Source Code Comments

Designation Attribute Code.

Columns Comments for ADRATTR_ACTIVITY_DATE (3)

Source Code Comments

Date the Designation Attribute Code was inserted or last modified.

Columns Comments for ADRATTR_USER (4)

Source Code Comments

User that inserted or last modified the Designation Attribute Code.

Table ADRCONF

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADRCONF_DESG	ADRCONF_DESG	VARCHAR2(10)	No	*	*
ADRCONF_IDEN_CODE	ADRCONF_IDEN_CODE	VARCHAR2(5)	No	*	*
ADRCONF_USER_ID	ADRCONF_USER_ID	VARCHAR2(30)	No
ADRCONF_GRP_SEQ_NO	ADRCONF_GRP_SEQ_NO	NUMBER(15,0)	No	*
ADRCONF_ACTIVITY_DATE	ADRCONF_ACTIVITY_DATE	DATE	No
ADRCONF_ENTRY_DATE	ADRCONF_ENTRY_DATE	DATE	No
ADRCONF_CONFID_IND	ADRCONF_CONFID_IND	VARCHAR2(1)	Yes
ADRCONF_USER	ADRCONF_USER	VARCHAR2(30)	No
ADRCONF_COMMENT	ADRCONF_COMMENT	LONG	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRCONF_DESG	ADBDESG_DESG	ADBDESG
ADRCONF_IDEN_CODE	GURIDEN_IDEN_CODE	GURIDEN

Index

Index Name	Index Type	Column Name
PK_ADRCONF	Unique	ADRCONF_DESG
PK_ADRCONF	Unique	ADRCONF_GRP_SEQ_NO
PK_ADRCONF	Unique	ADRCONF_IDEN_CODE

Comments

Source Code Comments

Designation Comment Confidentiality Table

Columns Comments for ADRCONF_DESG (1)

Source Code Comments

Designation Comment Confidentiality Designation.

Columns Comments for ADRCONF_IDEN_CODE (2)

Source Code Comments

User ID of the Creator/Owner of the Comment Confideniality Record.

Columns Comments for ADRCONF_USER_ID (3)

Source Code Comments

User that inserted or last modified the Comment Confidentiality Record.

Columns Comments for ADRCONF_GRP_SEQ_NO (4)

Source Code Comments

Designation Comment Confidentiality Group Sequence Number.

Columns Comments for ADRCONF_ACTIVITY_DATE (5)

Source Code Comments

Date the Comment Confidentiality Record was inserted or last modified.

Columns Comments for ADRCONF_ENTRY_DATE (6)

Source Code Comments

Date the Comment Confidentiality Record was inserted.

Columns Comments for ADRCONF_CONFID_IND (7)

Source Code Comments

Confidential Indicator, Y indicates that the comments are confidential.

Columns Comments for ADRCONF_USER (8)

Source Code Comments

The User ID of the person who created or last modified the comment record.

Columns Comments for ADRCONF_COMMENT (9)

Source Code Comments

Free form text comment.

Table ADRDIDS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADRDIDS_DESG	ADRDIDS_DESG	VARCHAR2(10)	No	*	*
ADRDIDS_PIDM	ADRDIDS_PIDM	NUMBER(8,0)	No	*
ADRDIDS_DITP_CODE	ADRDIDS_DITP_CODE	VARCHAR2(4)	No	*	*
ADRDIDS_ACTIVITY_DATE	ADRDIDS_ACTIVITY_DATE	DATE	No
ADRDIDS_USER	ADRDIDS_USER	VARCHAR2(30)	No
ADRDIDS_START_DATE	ADRDIDS_START_DATE	DATE	Yes
ADRDIDS_END_DATE	ADRDIDS_END_DATE	DATE	Yes
ADRDIDS_DIST_CODE	ADRDIDS_DIST_CODE	VARCHAR2(1)	Yes		*
ADRDIDS_ATYP_CODE	ADRDIDS_ATYP_CODE	VARCHAR2(2)	Yes
ADRDIDS_COMMENT	ADRDIDS_COMMENT	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRDIDS_DESG	ADBDESG_DESG	ADBDESG
ADRDIDS_DIST_CODE	ATVDIST_CODE	ATVDIST
ADRDIDS_DITP_CODE	ATVDITP_CODE	ATVDITP

Index

Index Name	Index Type	Column Name
PK_ADRDIDS	Unique	ADRDIDS_DESG
PK_ADRDIDS	Unique	ADRDIDS_PIDM
PK_ADRDIDS	Unique	ADRDIDS_DITP_CODE

Comments

Source Code Comments

Designation IDs Table

Columns Comments for ADRDIDS_DESG (1)

Source Code Comments

Designation ID Designation.

Columns Comments for ADRDIDS_PIDM (2)

Source Code Comments

Designation ID PIDM.

Columns Comments for ADRDIDS_DITP_CODE (3)

Source Code Comments

Designation ID Type code.

Columns Comments for ADRDIDS_ACTIVITY_DATE (4)

Source Code Comments

Date the Designation ID was inserted or last modified.

Columns Comments for ADRDIDS_USER (5)

Source Code Comments

User that inserted or last modified the Designation ID.

Columns Comments for ADRDIDS_START_DATE (6)

Source Code Comments

Start Date the Designation ID is effective for the designation.

Columns Comments for ADRDIDS_END_DATE (7)

Source Code Comments

End Date the Designation ID is effective for the designation.

Columns Comments for ADRDIDS_DIST_CODE (8)

Source Code Comments

Designation ID Status code.

Columns Comments for ADRDIDS_ATYP_CODE (9)

Source Code Comments

Designation ID Address Type code.

Columns Comments for ADRDIDS_COMMENT (10)

Source Code Comments

Comment Text for the Designation ID.

Table ADRFUND

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADRFUND_DESG	ADRFUND_DESG	VARCHAR2(10)	No	*	*
ADRFUND_FA_FUND_CODE	ADRFUND_FA_FUND_CODE	VARCHAR2(6)	No	*
ADRFUND_ACTIVITY_DATE	ADRFUND_ACTIVITY_DATE	DATE	No
ADRFUND_USER	ADRFUND_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRFUND_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
PK_ADRFUND	Unique	ADRFUND_DESG
PK_ADRFUND	Unique	ADRFUND_FA_FUND_CODE

Comments

Source Code Comments

Designation Financial Aid Funds Table

Columns Comments for ADRFUND_DESG (1)

Source Code Comments

Designation FA Fund Code Designation.

Columns Comments for ADRFUND_FA_FUND_CODE (2)

Source Code Comments

Designation Financial Aid Fund Code.

Columns Comments for ADRFUND_ACTIVITY_DATE (3)

Source Code Comments

Date the Designation FA Fund Code was inserted or last modified.

Columns Comments for ADRFUND_USER (4)

Source Code Comments

User that inserted or last modified the Designation FA Fund Code.

Table ADRSUMM

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ADRSUMM_DESG	ADRSUMM_DESG	VARCHAR2(10)	No	*	*
ADRSUMM_FISC_CODE	ADRSUMM_FISC_CODE	NUMBER(4,0)	No	*	*
ADRSUMM_AMT_PLEDGED	ADRSUMM_AMT_PLEDGED	NUMBER(13,2)	Yes
ADRSUMM_AMT_PLEDGED_PAID	ADRSUMM_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
ADRSUMM_AMT_GIFT	ADRSUMM_AMT_GIFT	NUMBER(13,2)	Yes
ADRSUMM_ACTIVITY_DATE	ADRSUMM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ADRSUMM_DESG	ADBDESG_DESG	ADBDESG
ADRSUMM_FISC_CODE	ATVFISC_CODE	ATVFISC

Index

Index Name	Index Type	Column Name
PK_ADRSUMM	Unique	ADRSUMM_DESG
PK_ADRSUMM	Unique	ADRSUMM_FISC_CODE

Comments

Source Code Comments

Designation Summary Repeating Table

Columns Comments for ADRSUMM_DESG (1)

Source Code Comments

This field specifies the five character alphanumeric designation code.

Columns Comments for ADRSUMM_FISC_CODE (2)

Source Code Comments

This field specifies the fiscal year associated with the summary information for a specific designation.

Columns Comments for ADRSUMM_AMT_PLEDGED (3)

Source Code Comments

This field specifies the amount of pledges associated with a designation for a specific fiscal year.

Columns Comments for ADRSUMM_AMT_PLEDGED_PAID (4)

Source Code Comments

This field specifies the amount of pledge payments associated with a designation for a specific fiscal year.

Columns Comments for ADRSUMM_AMT_GIFT (5)

Source Code Comments

This field specifies the amount of gifts and pledge payments associated with a designation for a specific fiscal year.

Columns Comments for ADRSUMM_ACTIVITY_DATE (6)

Source Code Comments

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

Table AFRDESG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AFRDESG_CAMPAIGN	AFRDESG_CAMPAIGN	VARCHAR2(5)	No	*	*
AFRDESG_DESG	AFRDESG_DESG	VARCHAR2(10)	No	*	*
AFRDESG_GOAL	AFRDESG_GOAL	NUMBER(13,2)	Yes
AFRDESG_AMT_PLEDGED	AFRDESG_AMT_PLEDGED	NUMBER(13,2)	Yes
AFRDESG_AMT_PLEDGED_PAID	AFRDESG_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
AFRDESG_AMT_GIFT	AFRDESG_AMT_GIFT	NUMBER(13,2)	Yes
AFRDESG_ACTIVITY_DATE	AFRDESG_ACTIVITY_DATE	DATE	No
AFRDESG_DSTA_CODE	AFRDESG_DSTA_CODE	VARCHAR2(1)	Yes		*
AFRDESG_WEB_GIFT_IND	AFRDESG_WEB_GIFT_IND	VARCHAR2(1)	Yes
AFRDESG_WEB_PLDG_IND	AFRDESG_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRDESG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRDESG_DESG	ADBDESG_DESG	ADBDESG
AFRDESG_DSTA_CODE	ATVDSTA_CODE	ATVDSTA

Index

Index Name	Index Type	Column Name
PK_AFRDESG	Unique	AFRDESG_CAMPAIGN
PK_AFRDESG	Unique	AFRDESG_DESG

Comments

Source Code Comments

Designation In Campaign Repeating Table

Columns Comments for AFRDESG_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRDESG_DESG (2)

Source Code Comments

This field specifies the designations that are associated with a specific campaign.

Columns Comments for AFRDESG_GOAL (3)

Source Code Comments

This field contains the dollar amount goal of the designation associated with a specific campaign.

Columns Comments for AFRDESG_AMT_PLEDGED (4)

Source Code Comments

This field specifies the amount of pledges associated with the designation.

Columns Comments for AFRDESG_AMT_PLEDGED_PAID (5)

Source Code Comments

This field identifies the amount of pledge payments for the designation.

Columns Comments for AFRDESG_AMT_GIFT (6)

Source Code Comments

This field identifies the amount of gifts and pledge payments for the designation.

Columns Comments for AFRDESG_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for AFRDESG_DSTA_CODE (8)

Source Code Comments

Designation Status Code indicates the status of the designation.

Columns Comments for AFRDESG_WEB_GIFT_IND (9)

Source Code Comments

Web Gift Indicator, Y indicates that gifts for this Campaign and Designation will be accepted from the Web.

Columns Comments for AFRDESG_WEB_PLDG_IND (10)

Source Code Comments

Web Pledge Indicator, Y indicates that pledges for this Campaign and Desgination will be accepted from the Web.

Table AGBWPLG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AGBWPLG_PIDM	AGBWPLG_PIDM	NUMBER(8,0)	No
AGBWPLG_AMOUNT	AGBWPLG_AMOUNT	NUMBER(11,2)	No
AGBWPLG_PLDG_DATE	AGBWPLG_PLDG_DATE	DATE	No
AGBWPLG_CAMPAIGN	AGBWPLG_CAMPAIGN	VARCHAR2(5)	No	*
AGBWPLG_DESG	AGBWPLG_DESG	VARCHAR2(10)	No	*
AGBWPLG_ACTIVITY_DATE	AGBWPLG_ACTIVITY_DATE	DATE	No
AGBWPLG_USER	AGBWPLG_USER	VARCHAR2(30)	No
AGBWPLG_ACCEPTED_IND	AGBWPLG_ACCEPTED_IND	VARCHAR2(1)	No
AGBWPLG_PLDG_CODE	AGBWPLG_PLDG_CODE	VARCHAR2(2)	Yes	*
AGBWPLG_PGVE_CODE	AGBWPLG_PGVE_CODE	VARCHAR2(5)	Yes	*
AGBWPLG_SOLC_CODE	AGBWPLG_SOLC_CODE	VARCHAR2(8)	Yes	*
AGBWPLG_SOL_ORG	AGBWPLG_SOL_ORG	VARCHAR2(5)	Yes	*
AGBWPLG_DCYR_CODE	AGBWPLG_DCYR_CODE	NUMBER(4,0)	Yes	*
AGBWPLG_SOLICITOR_PIDM	AGBWPLG_SOLICITOR_PIDM	NUMBER(8,0)	Yes
AGBWPLG_SPS_SPLIT_IND	AGBWPLG_SPS_SPLIT_IND	VARCHAR2(1)	Yes
AGBWPLG_PDUR_CODE	AGBWPLG_PDUR_CODE	VARCHAR2(1)	Yes	*
AGBWPLG_FREQ_CODE	AGBWPLG_FREQ_CODE	VARCHAR2(2)	Yes	*
AGBWPLG_BILL_DATE	AGBWPLG_BILL_DATE	DATE	Yes
AGBWPLG_COMMENT	AGBWPLG_COMMENT	VARCHAR2(300)	Yes
AGBWPLG_CAMPAIGN_2	AGBWPLG_CAMPAIGN_2	VARCHAR2(5)	Yes	*
AGBWPLG_DESIGNATION_2	AGBWPLG_DESIGNATION_2	VARCHAR2(10)	Yes	*
AGBWPLG_CAMPAIGN_3	AGBWPLG_CAMPAIGN_3	VARCHAR2(5)	Yes	*
AGBWPLG_DESIGNATION_3	AGBWPLG_DESIGNATION_3	VARCHAR2(10)	Yes	*
AGBWPLG_AMOUNT_2	AGBWPLG_AMOUNT_2	NUMBER(11,2)	Yes
AGBWPLG_AMOUNT_3	AGBWPLG_AMOUNT_3	NUMBER(11,2)	Yes
AGBWPLG_SCNT_CODE	AGBWPLG_SCNT_CODE	VARCHAR2(3)	Yes	*
AGBWPLG_SCRS_CODE	AGBWPLG_SCRS_CODE	VARCHAR2(3)	Yes	*
AGBWPLG_ASK_AMOUNT	AGBWPLG_ASK_AMOUNT	NUMBER(11,2)	Yes
AGBWPLG_ASK_DATE	AGBWPLG_ASK_DATE	DATE	Yes
AGBWPLG_LETR_CODE	AGBWPLG_LETR_CODE	VARCHAR2(15)	Yes	*
AGBWPLG_PLDG_PRMD_CODE	AGBWPLG_PLDG_PRMD_CODE	VARCHAR2(2)	Yes
AGBWPLG_PINS_PRMD_CODE	AGBWPLG_PINS_PRMD_CODE	VARCHAR2(2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AGBWPLG_FREQ_CODE	ATVFREQ_CODE	ATVFREQ
AGBWPLG_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AGBWPLG_CAMPAIGN_3	AFBCAMP_CAMPAIGN	AFBCAMP
AGBWPLG_CAMPAIGN_2	AFBCAMP_CAMPAIGN	AFBCAMP
AGBWPLG_PLDG_CODE	ATVPLDG_CODE	ATVPLDG
AGBWPLG_PDUR_CODE	ATVPDUR_CODE	ATVPDUR
AGBWPLG_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AGBWPLG_SCRS_CODE	ATVSCRS_CODE	ATVSCRS
AGBWPLG_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AGBWPLG_DESG	ADBDESG_DESG	ADBDESG
AGBWPLG_DESIGNATION_3	ADBDESG_DESG	ADBDESG
AGBWPLG_DESIGNATION_2	ADBDESG_DESG	ADBDESG
AGBWPLG_PGVE_CODE	ATVPGVE_CODE	ATVPGVE
AGBWPLG_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AGBWPLG_SOLC_CODE	ATVSOLC_CODE	ATVSOLC