Model SPRIDEN

Model Label : Banner SPRIDEN Table with Linked Tables
Path : BANNER DEV/COMMON/SPRIDEN

List of Objects

Object Name	Object Type	Layer Name
AFRCSLT	TABLE	Advancement
AFRCTYP	TABLE	Advancement
AGBMGID	TABLE	Advancement
AMRINFO	TABLE	Advancement
AMRPLAN	TABLE	Advancement
AMRSTAF	TABLE	Advancement
AOBORGN	TABLE	Advancement
AORCONT	TABLE	Advancement
AORJPST	TABLE	Advancement
APBCONS	TABLE	Advancement
APRACYR	TABLE	Advancement
APRCATG	TABLE	Advancement
APRCHIS	TABLE	Advancement
APRCHLD	TABLE	Advancement
APRCSPS	TABLE	Advancement
APRDHIS	TABLE	Advancement
APREHIS	TABLE	Advancement
APRXREF	TABLE	Advancement
ASRSORG	TABLE	Advancement
ASRSSAG	TABLE	Advancement
SPRIDEN	TABLE	Default

Comments

Model View

Table AFRCSLT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCSLT_CAMPAIGN	AFRCSLT_CAMPAIGN	VARCHAR2(5)	No
AFRCSLT_SOLC_CODE	AFRCSLT_SOLC_CODE	VARCHAR2(8)	Yes
AFRCSLT_SOL_ORG	AFRCSLT_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCSLT_PIDM	AFRCSLT_PIDM	NUMBER(8,0)	No	*
AFRCSLT_GOAL	AFRCSLT_GOAL	NUMBER(13,2)	Yes
AFRCSLT_ACTIVITY_DATE	AFRCSLT_ACTIVITY_DATE	DATE	No
AFRCSLT_REPORT_TO_PIDM	AFRCSLT_REPORT_TO_PIDM	NUMBER(8,0)	Yes
AFRCSLT_MAX_CONTACTS	AFRCSLT_MAX_CONTACTS	NUMBER(3,0)	Yes
AFRCSLT_SSTA_CODE	AFRCSLT_SSTA_CODE	VARCHAR2(1)	Yes	*
AFRCSLT_SSTA_DATE	AFRCSLT_SSTA_DATE	DATE	Yes
AFRCSLT_UPD_WEB_IND	AFRCSLT_UPD_WEB_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCSLT_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AFRCSLT_SSTA_CODE	ATVSSTA_CODE	ATVSSTA
AFRCSLT_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_CAMPAIGN
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_SOLC_CODE
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_SOL_ORG
AFRCSLT_KEY_INDEX	Unique	AFRCSLT_PIDM
AFRCSLT_KEY_INDEX2		AFRCSLT_PIDM

Comments

Source Code Comments

Campaign Solicitor Repeating Table

Columns Comments for AFRCSLT_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCSLT_SOLC_CODE (2)

Source Code Comments

This field specifies the type of campaign solicitations a specific solicitor organization is using for the campaign.

Columns Comments for AFRCSLT_SOL_ORG (3)

Source Code Comments

This field specifies a particular solicitor organization.

Columns Comments for AFRCSLT_PIDM (4)

Source Code Comments

This field specifies the internal system generated identification number for a specific solicitor.

Columns Comments for AFRCSLT_GOAL (5)

Source Code Comments

This field identifies the dollar amount goal for each solicitor.

Columns Comments for AFRCSLT_ACTIVITY_DATE (6)

Source Code Comments

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

Columns Comments for AFRCSLT_REPORT_TO_PIDM (7)

Source Code Comments

The Internal ID of the Solicitor at the next level up to which this Solicitor must report.

Columns Comments for AFRCSLT_MAX_CONTACTS (8)

Source Code Comments

The maximum number of contacts that a solicitor may have for the combination of Campaign, Solicitor Code and Solicitor Organization.

Columns Comments for AFRCSLT_SSTA_CODE (9)

Source Code Comments

The status of the solicitor for the combination of Campaign, Solicitor Code and Solicitor Organization.

Columns Comments for AFRCSLT_SSTA_DATE (10)

Source Code Comments

The date the Solicitor Status was changed.

Columns Comments for AFRCSLT_UPD_WEB_IND (11)

Source Code Comments

Update Web Indicator, Indicates that the solicitor can enter Contact information through the Web

Table AFRCTYP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AFRCTYP_CAMPAIGN	AFRCTYP_CAMPAIGN	VARCHAR2(5)	Yes	*
AFRCTYP_SOLC_CODE	AFRCTYP_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCTYP_SOLC_CODE	AFRCTYP_SOLC_CODE	VARCHAR2(8)	Yes	*
AFRCTYP_SOL_ORG	AFRCTYP_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCTYP_SOL_ORG	AFRCTYP_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCTYP_SOL_ORG	AFRCTYP_SOL_ORG	VARCHAR2(5)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_PIDM	AFRCTYP_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_SEQ_NO	AFRCTYP_SEQ_NO	NUMBER(5,0)	No	*
AFRCTYP_CONSTITUENT_PIDM	AFRCTYP_CONSTITUENT_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_ACTIVITY_DATE	AFRCTYP_ACTIVITY_DATE	DATE	No
AFRCTYP_USER	AFRCTYP_USER	VARCHAR2(30)	No
AFRCTYP_RATE_CODE	AFRCTYP_RATE_CODE	VARCHAR2(2)	Yes	*
AFRCTYP_RSCR_CODE	AFRCTYP_RSCR_CODE	VARCHAR2(5)	Yes	*
AFRCTYP_RATER_PIDM	AFRCTYP_RATER_PIDM	NUMBER(8,0)	Yes	*
AFRCTYP_ASK_AMOUNT	AFRCTYP_ASK_AMOUNT	NUMBER(11,2)	Yes
AFRCTYP_ASK_DATE	AFRCTYP_ASK_DATE	DATE	Yes
AFRCTYP_COMMENT	AFRCTYP_COMMENT	VARCHAR2(2000)	Yes
AFRCTYP_ASSIGN_DATE	AFRCTYP_ASSIGN_DATE	DATE	Yes
AFRCTYP_DCYR_CODE	AFRCTYP_DCYR_CODE	NUMBER(4,0)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AFRCTYP_RATE_CODE	ATVRATE_CODE	ATVRATE
AFRCTYP_SOLC_CODE	ATVSOLC_CODE	ATVSOLC
AFRCTYP_PIDM	ASRSORG_PIDM	ASRSORG
AFRCTYP_SOL_ORG	ASRSORG_SOL_ORG	ASRSORG
AFRCTYP_PIDM	AFRCRES_PIDM	AFRCRES
AFRCTYP_SEQ_NO	AFRCRES_CTYP_SEQ_NO	AFRCRES
AFRCTYP_RSCR_CODE	ATVRSCR_CODE	ATVRSCR
AFRCTYP_SOLC_CODE	AFRCSLT_SOLC_CODE	AFRCSLT
AFRCTYP_SOL_ORG	AFRCSLT_SOL_ORG	AFRCSLT
AFRCTYP_PIDM	AFRCSLT_PIDM	AFRCSLT
AFRCTYP_CAMPAIGN	AFBCAMP_CAMPAIGN	AFBCAMP
AFRCTYP_SOL_ORG	ASBSORG_SOL_ORG	ASBSORG
AFRCTYP_DCYR_CODE	ATVDCYR_CODE	ATVDCYR
AFRCTYP_PIDM	SPRIDEN_PIDM	SPRIDEN
AFRCTYP_CONSTITUENT_PIDM	SPRIDEN_PIDM	SPRIDEN
AFRCTYP_RATER_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_CAMPAIGN
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SOLC_CODE
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SOL_ORG
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_PIDM
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_SEQ_NO
AFRCTYP_KEY_INDEX	Unique	AFRCTYP_DCYR_CODE
AFRCTYP_KEY_INDEX2		AFRCTYP_PIDM
AFRCTYP_KEY_INDEX3		AFRCTYP_CONSTITUENT_PIDM
AFRCTYP_KEY_INDEX4		AFRCTYP_SOL_ORG
AFRCTYP_KEY_INDEX4		AFRCTYP_DCYR_CODE
AFRCTYP_KEY_INDEX4		AFRCTYP_PIDM
AFRCTYP_KEY_INDEX4		AFRCTYP_SEQ_NO

Comments

Source Code Comments

Campaign Contact Repeating Table

Columns Comments for AFRCTYP_CAMPAIGN (1)

Source Code Comments

This field specifies the five character alphanumeric campaign code.

Columns Comments for AFRCTYP_SOLC_CODE (2)

Source Code Comments

This field specifies the type of solicitations used for the campaign.

Columns Comments for AFRCTYP_SOL_ORG (3)

Source Code Comments

This field specifies the type of solicitor organization code.

Columns Comments for AFRCTYP_PIDM (4)

Source Code Comments

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

Columns Comments for AFRCTYP_SEQ_NO (5)

Source Code Comments

This field identifies the internal sequence number of the solicitor.

Columns Comments for AFRCTYP_CONSTITUENT_PIDM (6)

Source Code Comments

This field specifies the internal system generated identification number of the constituents assigned to the solicitor.

Columns Comments for AFRCTYP_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for AFRCTYP_USER (8)

Source Code Comments

User ID of the user that created or last updated the record

Columns Comments for AFRCTYP_RATE_CODE (9)

Source Code Comments

Rating code given the contact by the rater.

Columns Comments for AFRCTYP_RSCR_CODE (10)

Source Code Comments

Rater type code for the person rating the contact.

Columns Comments for AFRCTYP_RATER_PIDM (11)

Source Code Comments

Internal ID of the person rating the contact.

Columns Comments for AFRCTYP_ASK_AMOUNT (12)

Source Code Comments

Amount the solicitor asked the contact to give or pledge

Columns Comments for AFRCTYP_ASK_DATE (13)

Source Code Comments

Date that the solicitor asked the contact to commit to.

Columns Comments for AFRCTYP_COMMENT (14)

Source Code Comments

2000 Character free-form comment associated with the contact.

Columns Comments for AFRCTYP_ASSIGN_DATE (15)

Source Code Comments

Date that the contact was assigned to the solicitor.

Columns Comments for AFRCTYP_DCYR_CODE (16)

Source Code Comments

Year for which the solicitation should be made, may be blank.

Table AGBMGID

Schema Name ALUMNI
Label AGBMGID
Server name MALDEV8_B60
Creation Date 08/15/2002 09:15:52:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
AGBMGID_EMPR_PIDM	AGBMGID_EMPR_PIDM	NUMBER(8,0)	No	*
AGBMGID_EMPL_PIDM	AGBMGID_EMPL_PIDM	NUMBER(8,0)	No	*
AGBMGID_EMPL_GIFT_NO	AGBMGID_EMPL_GIFT_NO	VARCHAR2(7)	No	*
AGBMGID_AMT	AGBMGID_AMT	NUMBER(11,2)	No
AGBMGID_AMT_PAID	AGBMGID_AMT_PAID	NUMBER(11,2)	No
AGBMGID_STATUS	AGBMGID_STATUS	VARCHAR2(1)	Yes
AGBMGID_DELETE_IND	AGBMGID_DELETE_IND	VARCHAR2(1)	Yes
AGBMGID_ACTIVITY_DATE	AGBMGID_ACTIVITY_DATE	DATE	No
AGBMGID_MG_FORMSENT_IND	AGBMGID_MG_FORMSENT_IND	VARCHAR2(1)	Yes
AGBMGID_SPOUSE_PIDM	AGBMGID_SPOUSE_PIDM	NUMBER(8,0)	Yes
AGBMGID_QUALIFY_AMT	AGBMGID_QUALIFY_AMT	NUMBER(11,2)	Yes
AGBMGID_PGVE_CODE	AGBMGID_PGVE_CODE	VARCHAR2(5)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
AGBMGID_KEY_INDEX2		AGBMGID_EMPL_PIDM
AGBMGID_KEY_INDEX2		AGBMGID_EMPL_GIFT_NO
AGBMGID_KEY_INDEX3		AGBMGID_EMPR_PIDM
AGBMGID_KEY_INDEX3		AGBMGID_ACTIVITY_DATE
AGBMGID_KEY_INDEX3		AGBMGID_STATUS
PK_AGBMGID	Unique	AGBMGID_EMPR_PIDM
PK_AGBMGID	Unique	AGBMGID_EMPL_GIFT_NO
PK_AGBMGID	Unique	AGBMGID_EMPL_PIDM

Comments

Source Code Comments

Matching Gift Waiting Id Base Table

Columns Comments for AGBMGID_EMPR_PIDM (1)

Source Code Comments

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

Columns Comments for AGBMGID_EMPL_PIDM (2)

Source Code Comments

This field specifies the internal system generated identification number for the employee.

Columns Comments for AGBMGID_EMPL_GIFT_NO (3)

Source Code Comments

This field specifies the gift number of the gift to be matched.

Columns Comments for AGBMGID_AMT (4)

Source Code Comments

This field specifies the amount of the gift to be matched.

Columns Comments for AGBMGID_AMT_PAID (5)

Source Code Comments

This field specifies the amount paid toward the match.

Columns Comments for AGBMGID_STATUS (6)

Source Code Comments

This system maintained field specifies whether a gift has been matched.

Columns Comments for AGBMGID_DELETE_IND (7)

Source Code Comments

This field specifies whether a matching gift is deleted or restored.

Columns Comments for AGBMGID_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for AGBMGID_MG_FORMSENT_IND (9)

Source Code Comments

(Y) - Yes, The MG Form has been sent to the Employer. (N) - No, The MG Form has NOT been sent to the Employer. Null - No, The MG Form has NOT been sent to the Employer.

Columns Comments for AGBMGID_SPOUSE_PIDM (10)

Source Code Comments

The Internal ID of the spouse of the person making the gift that will be matched.

Columns Comments for AGBMGID_QUALIFY_AMT (11)

Source Code Comments

The amount of the gift that qualifies to be matched.

Table AMRINFO

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMRINFO_PIDM	AMRINFO_PIDM	NUMBER(8,0)	No	*
AMRINFO_REFR_CODE	AMRINFO_REFR_CODE	VARCHAR2(2)	No		*
AMRINFO_SYS_IND	AMRINFO_SYS_IND	VARCHAR2(1)	No
AMRINFO_STATUS	AMRINFO_STATUS	VARCHAR2(1)	No
AMRINFO_ACTIVITY_DATE	AMRINFO_ACTIVITY_DATE	DATE	No
AMRINFO_RATE_ENTRY_DATE	AMRINFO_RATE_ENTRY_DATE	DATE	Yes
AMRINFO_REFERENCE	AMRINFO_REFERENCE	VARCHAR2(30)	Yes
AMRINFO_PROSP_RATE	AMRINFO_PROSP_RATE	NUMBER(11,2)	Yes
AMRINFO_TARGET_ASK_DATE	AMRINFO_TARGET_ASK_DATE	DATE	Yes
AMRINFO_WEB_GIFT_IND	AMRINFO_WEB_GIFT_IND	VARCHAR2(1)	Yes
AMRINFO_WEB_PLDG_IND	AMRINFO_WEB_PLDG_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRINFO_REFR_CODE	ATVREFR_CODE	ATVREFR

Index

Index Name	Index Type	Column Name
PK_AMRINFO	Unique	AMRINFO_PIDM

Comments

Source Code Comments

Prospect Information Table

Columns Comments for AMRINFO_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMRINFO_REFR_CODE (2)

Source Code Comments

This field specifies the reference code.

Columns Comments for AMRINFO_SYS_IND (3)

Source Code Comments

This field specifies system indicator.

Columns Comments for AMRINFO_STATUS (4)

Source Code Comments

This field specifies status.

Columns Comments for AMRINFO_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for AMRINFO_RATE_ENTRY_DATE (6)

Source Code Comments

This field specifies the date rate was entered.

Columns Comments for AMRINFO_REFERENCE (7)

Source Code Comments

This field specifies reference.

Columns Comments for AMRINFO_PROSP_RATE (8)

Source Code Comments

This field specifies manually entered or system calculated prospect amount.

Columns Comments for AMRINFO_TARGET_ASK_DATE (9)

Source Code Comments

This field specifies manually entered target asking date.

Columns Comments for AMRINFO_WEB_GIFT_IND (10)

Source Code Comments

Web Gift Indicator, Y indicates that gifts from this prospect will be accepted from the Web.

Columns Comments for AMRINFO_WEB_PLDG_IND (11)

Source Code Comments

Web Pledge Indicator, Y indicates that pledges from this prospect will be accepted from the Web.

Table AMRPLAN

Schema Name ALUMNI
Label AMRPLAN
Server name MALDEV8_B60
Creation Date 08/15/2002 09:15:51:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AMRPLAN_PIDM	AMRPLAN_PIDM	NUMBER(8,0)	No	*
AMRPLAN_STGY_PLAN	AMRPLAN_STGY_PLAN	VARCHAR2(15)	No
AMRPLAN_PROJ_CODE	AMRPLAN_PROJ_CODE	VARCHAR2(6)	No	*
AMRPLAN_IDEN_CODE	AMRPLAN_IDEN_CODE	VARCHAR2(5)	No
AMRPLAN_MOVE_CODE	AMRPLAN_MOVE_CODE	VARCHAR2(4)	No	*
AMRPLAN_WAIT_DAYS	AMRPLAN_WAIT_DAYS	NUMBER(3,0)	No
AMRPLAN_PLAN_DATE	AMRPLAN_PLAN_DATE	DATE	No
AMRPLAN_ACTIVITY_DATE	AMRPLAN_ACTIVITY_DATE	DATE	No
AMRPLAN_COMMENT	AMRPLAN_COMMENT	VARCHAR2(180)	Yes
AMRPLAN_MESSAGE_IND	AMRPLAN_MESSAGE_IND	VARCHAR2(1)	Yes
AMRPLAN_ACTION_DATE	AMRPLAN_ACTION_DATE	DATE	Yes
AMRPLAN_SYS_IND	AMRPLAN_SYS_IND	VARCHAR2(1)	Yes
AMRPLAN_MOVE_SEQNO	AMRPLAN_MOVE_SEQNO	NUMBER(15,0)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRPLAN_MOVE_CODE	ATVMOVE_CODE	ATVMOVE
AMRPLAN_PROJ_CODE	ATVPROJ_CODE	ATVPROJ
AMRPLAN_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
AMRPLAN_KEY_INDEX		AMRPLAN_PIDM
AMRPLAN_KEY_INDEX		AMRPLAN_STGY_PLAN
AMRPLAN_KEY_INDEX		AMRPLAN_PROJ_CODE
AMRPLAN_KEY_INDEX2		AMRPLAN_STGY_PLAN
AMRPLAN_KEY_INDEX3		AMRPLAN_PROJ_CODE
AMRPLAN_KEY_INDEX4		AMRPLAN_IDEN_CODE

Comments

Source Code Comments

Prospect Management Strategy Planning Table

Columns Comments for AMRPLAN_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AMRPLAN_STGY_PLAN (2)

Source Code Comments

This field specifies the strategy plan name.

Columns Comments for AMRPLAN_PROJ_CODE (3)

Source Code Comments

This field specifies the project code associated with the strategy plan.

Columns Comments for AMRPLAN_IDEN_CODE (4)

Source Code Comments

This field specifies the staff identification code for the strategy plan.

Columns Comments for AMRPLAN_MOVE_CODE (5)

Source Code Comments

This field specifies the move code for the strategy.

Columns Comments for AMRPLAN_WAIT_DAYS (6)

Source Code Comments

This field specifies the number of wait days for the move code.

Columns Comments for AMRPLAN_PLAN_DATE (7)

Source Code Comments

This field specifies the planned date for the move code to occur.

Columns Comments for AMRPLAN_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for AMRPLAN_COMMENT (9)

Source Code Comments

This field specifies the comment and or action on the move code.

Columns Comments for AMRPLAN_MESSAGE_IND (10)

Source Code Comments

This field specifies if a message is to be or was created on the GUAMESG form.

Columns Comments for AMRPLAN_ACTION_DATE (11)

Source Code Comments

This field specifies the date then message is to occur.

Columns Comments for AMRPLAN_SYS_IND (12)

Source Code Comments

This field specifies if the move code was defaulted in or unexpected.

Table AMRSTAF

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AMRSTAF_PIDM	AMRSTAF_PIDM	NUMBER(8,0)	No	*
AMRSTAF_PIDM	AMRSTAF_PIDM	NUMBER(8,0)	No	*
AMRSTAF_STFT_CODE	AMRSTAF_STFT_CODE	VARCHAR2(4)	No	*
AMRSTAF_IDEN_CODE	AMRSTAF_IDEN_CODE	VARCHAR2(5)	Yes	*
AMRSTAF_ACTIVITY_DATE	AMRSTAF_ACTIVITY_DATE	DATE	No
AMRSTAF_SOLICIT_IND	AMRSTAF_SOLICIT_IND	VARCHAR2(1)	Yes
AMRSTAF_PRIMARY_IND	AMRSTAF_PRIMARY_IND	VARCHAR2(1)	Yes
AMRSTAF_STAFF_PIDM	AMRSTAF_STAFF_PIDM	NUMBER(8,0)	Yes
AMRSTAF_USER	AMRSTAF_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRSTAF_PIDM	AMRINFO_PIDM	AMRINFO
AMRSTAF_STFT_CODE	ATVSTFT_CODE	ATVSTFT
AMRSTAF_IDEN_CODE	GURIDEN_IDEN_CODE	GURIDEN
AMRSTAF_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
AMRSTAF_KEY_INDEX1		AMRSTAF_PIDM
AMRSTAF_KEY_INDEX1		AMRSTAF_STFT_CODE

Comments

Source Code Comments

Prospect Staff Assignment Table

Columns Comments for AMRSTAF_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMRSTAF_STFT_CODE (2)

Source Code Comments

This field specifies staff type code.

Columns Comments for AMRSTAF_IDEN_CODE (3)

Source Code Comments

This field specifies staff identification code.

Columns Comments for AMRSTAF_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for AMRSTAF_SOLICIT_IND (5)

Source Code Comments

This field specifies staff person is solicitor.

Columns Comments for AMRSTAF_PRIMARY_IND (6)

Source Code Comments

This field specifies staff person as primary.

Columns Comments for AMRSTAF_STAFF_PIDM (7)

Source Code Comments

Internal staff person identification number.

Columns Comments for AMRSTAF_USER (8)

Source Code Comments

This system maintained field specifies the user that created or updated the record.

Table AOBORGN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AOBORGN_PIDM	AOBORGN_PIDM	NUMBER(8,0)	No	*	*
AOBORGN_EIN	AOBORGN_EIN	VARCHAR2(9)	Yes
AOBORGN_BUSINESS	AOBORGN_BUSINESS	VARCHAR2(30)	No
AOBORGN_SICC_CODE	AOBORGN_SICC_CODE	VARCHAR2(4)	Yes		*
AOBORGN_MATCH_PCT	AOBORGN_MATCH_PCT	NUMBER(3,0)	Yes
AOBORGN_MATCH_ORG_MAX	AOBORGN_MATCH_ORG_MAX	NUMBER(11,2)	Yes
AOBORGN_MATCH_PERSON_MAX	AOBORGN_MATCH_PERSON_MAX	NUMBER(11,2)	Yes
AOBORGN_ATYP_CODE	AOBORGN_ATYP_CODE	VARCHAR2(2)	Yes		*
AOBORGN_JOBC_CODE	AOBORGN_JOBC_CODE	VARCHAR2(3)	Yes		*
AOBORGN_TITLE_CONTACT	AOBORGN_TITLE_CONTACT	VARCHAR2(60)	Yes
AOBORGN_LAST_NAME_CONTACT	AOBORGN_LAST_NAME_CONTACT	VARCHAR2(25)	Yes
AOBORGN_FIRST_NAME_CONTACT	AOBORGN_FIRST_NAME_CONTACT	VARCHAR2(15)	Yes
AOBORGN_MI_CONTACT	AOBORGN_MI_CONTACT	VARCHAR2(1)	Yes
AOBORGN_ACTIVITY_DATE	AOBORGN_ACTIVITY_DATE	DATE	No
AOBORGN_MG_PIDM	AOBORGN_MG_PIDM	NUMBER(8,0)	Yes
AOBORGN_EMPL_CNT	AOBORGN_EMPL_CNT	NUMBER(9,0)	Yes
AOBORGN_EMPL_PT_PROF	AOBORGN_EMPL_PT_PROF	NUMBER(9,0)	Yes
AOBORGN_EMPL_FT_PROF	AOBORGN_EMPL_FT_PROF	NUMBER(9,0)	Yes
AOBORGN_TOT_REVENUE	AOBORGN_TOT_REVENUE	NUMBER(12,0)	Yes
AOBORGN_TOT_ASSETS	AOBORGN_TOT_ASSETS	NUMBER(12,0)	Yes
AOBORGN_TOT_EARNINGS	AOBORGN_TOT_EARNINGS	NUMBER(12,0)	Yes
AOBORGN_PRE_TAX_PROFIT	AOBORGN_PRE_TAX_PROFIT	NUMBER(12,0)	Yes
AOBORGN_GRANT_LOW	AOBORGN_GRANT_LOW	NUMBER(12,0)	Yes
AOBORGN_GRANT_HIGH	AOBORGN_GRANT_HIGH	NUMBER(12,0)	Yes
AOBORGN_PROP_DEADLINE_MM	AOBORGN_PROP_DEADLINE_MM	VARCHAR2(2)	Yes
AOBORGN_PROP_DEADLINE_DD	AOBORGN_PROP_DEADLINE_DD	VARCHAR2(2)	Yes
AOBORGN_YEAR_INC	AOBORGN_YEAR_INC	NUMBER(4,0)	Yes
AOBORGN_BEG_FY_MM	AOBORGN_BEG_FY_MM	VARCHAR2(2)	Yes
AOBORGN_BEG_FY_DD	AOBORGN_BEG_FY_DD	VARCHAR2(2)	Yes
AOBORGN_END_FY_MM	AOBORGN_END_FY_MM	VARCHAR2(2)	Yes
AOBORGN_END_FY_DD	AOBORGN_END_FY_DD	VARCHAR2(2)	Yes
AOBORGN_OTH_ED_MG_IND	AOBORGN_OTH_ED_MG_IND	VARCHAR2(1)	Yes
AOBORGN_STATE_ASSOC_MG_IND	AOBORGN_STATE_ASSOC_MG_IND	VARCHAR2(1)	Yes
AOBORGN_DESG_MG_IND	AOBORGN_DESG_MG_IND	VARCHAR2(1)	Yes
AOBORGN_MDIS_CODE	AOBORGN_MDIS_CODE	VARCHAR2(1)	Yes		*
AOBORGN_MDIS_MM	AOBORGN_MDIS_MM	VARCHAR2(2)	Yes
AOBORGN_MDIS_DD	AOBORGN_MDIS_DD	VARCHAR2(2)	Yes
AOBORGN_MDIS_DEADLINE_MM	AOBORGN_MDIS_DEADLINE_MM	VARCHAR2(2)	Yes
AOBORGN_MDIS_DEADLINE_DD	AOBORGN_MDIS_DEADLINE_DD	VARCHAR2(2)	Yes
AOBORGN_DUPL_MG_IND	AOBORGN_DUPL_MG_IND	VARCHAR2(1)	Yes
AOBORGN_MG_ACK_IND	AOBORGN_MG_ACK_IND	VARCHAR2(1)	Yes
AOBORGN_MGMT_MG_IND	AOBORGN_MGMT_MG_IND	VARCHAR2(1)	Yes
AOBORGN_MATCH_PERS_INST_YR	AOBORGN_MATCH_PERS_INST_YR	NUMBER(11,2)	Yes
AOBORGN_MATCH_ORG_CEILING_YR	AOBORGN_MATCH_ORG_CEILING_YR	NUMBER(11,2)	Yes
AOBORGN_MATCH_ORG_EMPL_YR	AOBORGN_MATCH_ORG_EMPL_YR	NUMBER(11,2)	Yes
AOBORGN_MATCH_MINIMUM	AOBORGN_MATCH_MINIMUM	NUMBER(11,2)	Yes
AOBORGN_SOCIETY_NAME	AOBORGN_SOCIETY_NAME	VARCHAR2(60)	Yes
AOBORGN_YEAR_MG	AOBORGN_YEAR_MG	NUMBER(4,0)	Yes
AOBORGN_FINANCIALS_DATE	AOBORGN_FINANCIALS_DATE	DATE	Yes
AOBORGN_MG_LOAD_UPDATE_DATE	AOBORGN_MG_LOAD_UPDATE_DATE	DATE	Yes
AOBORGN_MG_LOAD_SOURCE	AOBORGN_MG_LOAD_SOURCE	VARCHAR2(1)	Yes
AOBORGN_MG_RECEIPT_IND	AOBORGN_MG_RECEIPT_IND	VARCHAR2(1)	Yes
AOBORGN_MATCH_MAXIMUM	AOBORGN_MATCH_MAXIMUM	NUMBER(11,2)	Yes
AOBORGN_PREFIX_CONTACT	AOBORGN_PREFIX_CONTACT	VARCHAR2(20)	Yes
AOBORGN_SUFFIX_CONTACT	AOBORGN_SUFFIX_CONTACT	VARCHAR2(20)	Yes
AOBORGN_MG_LOAD_ID	AOBORGN_MG_LOAD_ID	VARCHAR2(9)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AOBORGN_PIDM	APREHIS_EMPR_PIDM	APREHIS
AOBORGN_SICC_CODE	ATVSICC_CODE	ATVSICC
AOBORGN_MDIS_CODE	ATVMDIS_CODE	ATVMDIS
AOBORGN_JOBC_CODE	ATVJOBC_CODE	ATVJOBC
AOBORGN_ATYP_CODE	STVATYP_CODE	STVATYP

Index

Index Name	Index Type	Column Name
PK_AOBORGN	Unique	AOBORGN_PIDM

Comments

Source Code Comments

Organization Base Table

Columns Comments for AOBORGN_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AOBORGN_EIN (2)

Source Code Comments

This field specifies the organizations federal identification number.

Columns Comments for AOBORGN_BUSINESS (3)

Source Code Comments

This field specifies the organizations general category of business.

Columns Comments for AOBORGN_SICC_CODE (4)

Source Code Comments

This field specifies the organizations standard industry code.

Columns Comments for AOBORGN_MATCH_PCT (5)

Source Code Comments

This field specifies the organizations matching gift percentage.

Columns Comments for AOBORGN_MATCH_ORG_MAX (6)

Source Code Comments

Amount the organization will donate to an institution per year.

Columns Comments for AOBORGN_MATCH_PERSON_MAX (7)

Source Code Comments

Amount an employee can be matched per year.

Columns Comments for AOBORGN_ATYP_CODE (8)

Source Code Comments

This field specifies the address to use for the organizational contact.

Columns Comments for AOBORGN_JOBC_CODE (9)

Source Code Comments

This field specifies the job category associated with the organizational contacts title.

Columns Comments for AOBORGN_TITLE_CONTACT (10)

Source Code Comments

This field specifies the job title of the organizational contact.

Columns Comments for AOBORGN_LAST_NAME_CONTACT (11)

Source Code Comments

This field specifies the last name of the organizational contact.

Columns Comments for AOBORGN_FIRST_NAME_CONTACT (12)

Source Code Comments

This field specifies the first name of the organizational contact.

Columns Comments for AOBORGN_MI_CONTACT (13)

Source Code Comments

This field specifies the organizational contacts middle initial.

Columns Comments for AOBORGN_ACTIVITY_DATE (14)

Source Code Comments

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

Columns Comments for AOBORGN_MG_PIDM (15)

Source Code Comments

Internal Id number for the matching gift company associated with the organization. The pidm may be the same pidm or the parent pidm.

Columns Comments for AOBORGN_EMPL_CNT (16)

Source Code Comments

Total number of employees.

Columns Comments for AOBORGN_EMPL_PT_PROF (17)

Source Code Comments

Total number of parttime professional employees.

Columns Comments for AOBORGN_EMPL_FT_PROF (18)

Source Code Comments

Total number of fulltime professional employees.

Columns Comments for AOBORGN_TOT_REVENUE (19)

Source Code Comments

Total revenue for organization.

Columns Comments for AOBORGN_TOT_ASSETS (20)

Source Code Comments

Total assets for organization.

Columns Comments for AOBORGN_TOT_EARNINGS (21)

Source Code Comments

Total earnings for organization.

Columns Comments for AOBORGN_PRE_TAX_PROFIT (22)

Source Code Comments

Pre-tax profit for organization.

Columns Comments for AOBORGN_GRANT_LOW (23)

Source Code Comments

Grant dollars low range.

Columns Comments for AOBORGN_GRANT_HIGH (24)

Source Code Comments

Grant dollars high range.

Columns Comments for AOBORGN_PROP_DEADLINE_MM (25)

Source Code Comments

Proposal deadline month.

Columns Comments for AOBORGN_PROP_DEADLINE_DD (26)

Source Code Comments

Proposal deadline date of month.

Columns Comments for AOBORGN_YEAR_INC (27)

Source Code Comments

Organization date of incorporation (Format YYYY).

Columns Comments for AOBORGN_BEG_FY_MM (28)

Source Code Comments

Beginning month of organizations fiscal year.

Columns Comments for AOBORGN_BEG_FY_DD (29)

Source Code Comments

Beginning date of month for organizations fiscal year.

Columns Comments for AOBORGN_END_FY_MM (30)

Source Code Comments

Ending month of organizations fiscal year.

Columns Comments for AOBORGN_END_FY_DD (31)

Source Code Comments

Ending day of month for organizations fiscal year.

Columns Comments for AOBORGN_OTH_ED_MG_IND (32)

Source Code Comments

Other aid-to-education program in addition to matching gift program. Values Y or N.

Columns Comments for AOBORGN_STATE_ASSOC_MG_IND (33)

Source Code Comments

Organization matches gifts to state or regional associations of private colleges. Values Y or N.

Columns Comments for AOBORGN_DESG_MG_IND (34)

Source Code Comments

Designation of matching gifts indicator. Values S=Same as employee gift, U=Unrestriced,X=designated for general operating budget. Used in MG batch process.

Columns Comments for AOBORGN_MDIS_CODE (35)

Source Code Comments

Matching gift distribution code.

Columns Comments for AOBORGN_MDIS_MM (36)

Source Code Comments

Month of Matching gift distribution.

Columns Comments for AOBORGN_MDIS_DD (37)

Source Code Comments

Date of month for Matching gift distribution.

Columns Comments for AOBORGN_MDIS_DEADLINE_MM (38)

Source Code Comments

Month of Matching gift distribution deadline date.

Columns Comments for AOBORGN_MDIS_DEADLINE_DD (39)

Source Code Comments

Date of month for Matching gift distribution deadline date.

Columns Comments for AOBORGN_DUPL_MG_IND (40)

Source Code Comments

MG duplicate match indicator. Company will (Y) or will not (N) match gifts eligible to be matched by other companies. Used in the MG batch process.

Columns Comments for AOBORGN_MG_ACK_IND (41)

Source Code Comments

Company required acknowledgment of MG, Y or N. An A indicates acknowledgments may be combined and sent periodically.

Columns Comments for AOBORGN_MGMT_MG_IND (42)

Source Code Comments

Management indicator C=Corp administers MG,F=Foundation administers companies MG.

Columns Comments for AOBORGN_MATCH_PERS_INST_YR (43)

Source Code Comments

Amount an employee can be matched per insitition per year.