Model Prospect Management

Model Label : BANNER Advancement Prospect Management Processing
Path : Default Folder/B70/Advancement/Prospect Management

List of Objects

Object Name	Object Type	Layer Name
AMBPLAN	TABLE	Default
AMBPROP	TABLE	Default
AMBSTGY	TABLE	Default
AMRCONF	TABLE	Default
AMRCONT	TABLE	Default
AMREXRT	TABLE	Default
AMRINFO	TABLE	Default
AMRPCMT	TABLE	Default
AMRPLAN	TABLE	Default
AMRPRIN	TABLE	Default
AMRPROP	TABLE	Default
AMRPRRT	TABLE	Default
AMRPRSC	TABLE	Default
AMRPSRC	TABLE	Default
AMRPUSR	TABLE	Default
AMRSTAF	TABLE	Default
AMRSTGY	TABLE	Default
AMRSUBJ	TABLE	Default
ATVEXRS	TABLE	Default
ATVGIVH	TABLE	Default
ATVMOVE	TABLE	Default
ATVPROJ	TABLE	Default
ATVPROP	TABLE	Default
ATVPRST	TABLE	Default
ATVREFR	TABLE	Default
ATVSCNT	TABLE	Default
ATVSORC	TABLE	Default
ATVSTFT	TABLE	Default
ATVUSRC	TABLE	Default
SPRADDR	TABLE	Default
SPRIDEN	TABLE	Default

Comments

Model View

Table AMBPLAN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMBPLAN_PIDM	AMBPLAN_PIDM	NUMBER(8,0)	No	*	*
AMBPLAN_STGY_PLAN	AMBPLAN_STGY_PLAN	VARCHAR2(15)	No	*	*
AMBPLAN_PROJ_CODE	AMBPLAN_PROJ_CODE	VARCHAR2(6)	No	*	*
AMBPLAN_IDEN_CODE	AMBPLAN_IDEN_CODE	VARCHAR2(5)	No
AMBPLAN_START_DATE	AMBPLAN_START_DATE	DATE	No
AMBPLAN_ACTIVITY_DATE	AMBPLAN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMBPLAN_PROJ_CODE	ATVPROJ_CODE	ATVPROJ
AMBPLAN_PIDM	AMRPLAN_PIDM	AMRPLAN
AMBPLAN_PROJ_CODE	AMRPLAN_STGY_PLAN	AMRPLAN
AMBPLAN_STGY_PLAN	AMRPLAN_PROJ_CODE	AMRPLAN

Index

Index Name	Index Type	Column Name
AMBPLAN_KEY_INDEX2		AMBPLAN_STGY_PLAN
AMBPLAN_KEY_INDEX3		AMBPLAN_PROJ_CODE
AMBPLAN_KEY_INDEX4		AMBPLAN_IDEN_CODE
PK_AMBPLAN	Unique	AMBPLAN_PIDM
PK_AMBPLAN	Unique	AMBPLAN_STGY_PLAN
PK_AMBPLAN	Unique	AMBPLAN_PROJ_CODE

Comments

Source Code Comments

Prospect Management Strategy Plan Base Table

Columns Comments for AMBPLAN_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for AMBPLAN_STGY_PLAN (2)

Source Code Comments

This field specifies the strategy plan name.

Columns Comments for AMBPLAN_PROJ_CODE (3)

Source Code Comments

This field specifies the Project code associated with the Strategy plan.

Columns Comments for AMBPLAN_IDEN_CODE (4)

Source Code Comments

This field specifies the staff identification code.

Columns Comments for AMBPLAN_START_DATE (5)

Source Code Comments

This field specifies the start date of the strategy plan.

Columns Comments for AMBPLAN_ACTIVITY_DATE (6)

Source Code Comments

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

Table AMBPROP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMBPROP_PIDM	AMBPROP_PIDM	NUMBER(8,0)	No	*
AMBPROP_PROP_CODE	AMBPROP_PROP_CODE	VARCHAR2(6)	No	*	*
AMBPROP_USER	AMBPROP_USER	VARCHAR2(30)	No
AMBPROP_ACTIVITY_DATE	AMBPROP_ACTIVITY_DATE	DATE	No
AMBPROP_PRST_CODE	AMBPROP_PRST_CODE	VARCHAR2(1)	Yes		*
AMBPROP_PRST_DATE	AMBPROP_PRST_DATE	DATE	Yes
AMBPROP_COMMENT	AMBPROP_COMMENT	LONG	Yes
AMBPROP_STAFF_PIDM	AMBPROP_STAFF_PIDM	NUMBER(8,0)	Yes
AMBPROP_STAFF_IDEN_CODE	AMBPROP_STAFF_IDEN_CODE	VARCHAR2(5)	Yes
AMBPROP_DUE_DATE	AMBPROP_DUE_DATE	DATE	Yes
AMBPROP_FINANCE_CODE	AMBPROP_FINANCE_CODE	VARCHAR2(9)	Yes
AMBPROP_ASK_AMOUNT	AMBPROP_ASK_AMOUNT	NUMBER(13,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMBPROP_PROP_CODE	ATVPROP_CODE	ATVPROP
AMBPROP_PRST_CODE	ATVPRST_CODE	ATVPRST

Index

Index Name	Index Type	Column Name
PK_AMBPROP	Unique	AMBPROP_PIDM
PK_AMBPROP	Unique	AMBPROP_PROP_CODE

Comments

Source Code Comments

Prospects Proposals Base Table

Columns Comments for AMBPROP_PIDM (1)

Source Code Comments

This column specifies the internal system generated ID number of a Propspect.

Columns Comments for AMBPROP_PROP_CODE (2)

Source Code Comments

The Proposal code which is being associated to the Prospect.

Columns Comments for AMBPROP_USER (3)

Source Code Comments

User ID of the person who created/updated the record.

Columns Comments for AMBPROP_ACTIVITY_DATE (4)

Source Code Comments

Date the record was inserted or last modified.

Columns Comments for AMBPROP_PRST_CODE (5)

Source Code Comments

The Status Code of the Proposal for the Prospect.

Columns Comments for AMBPROP_PRST_DATE (6)

Source Code Comments

The Date of the Proposal Status for the Prospect.

Columns Comments for AMBPROP_COMMENT (7)

Source Code Comments

The Ask Amount for the Proposal for this prospect.

Columns Comments for AMBPROP_STAFF_PIDM (8)

Source Code Comments

This column is the internal system generated ID number of the Staff.

Columns Comments for AMBPROP_STAFF_IDEN_CODE (9)

Source Code Comments

This column specifies the identification code of the Staff.

Columns Comments for AMBPROP_DUE_DATE (10)

Source Code Comments

This column specifies the Due Date of the Proposal.

Columns Comments for AMBPROP_FINANCE_CODE (11)

Source Code Comments

Grant code associated from Banner Finance, not yet implemented.

Columns Comments for AMBPROP_ASK_AMOUNT (12)

Source Code Comments

Free Format column for entry of Proposal Comments.

Table AMBSTGY

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AMBSTGY_STGY_PLAN	AMBSTGY_STGY_PLAN	VARCHAR2(15)	No	*
AMBSTGY_ACTIVITY_DATE	AMBSTGY_ACTIVITY_DATE	DATE	No
AMBSTGY_PROJ_CODE	AMBSTGY_PROJ_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMBSTGY_PROJ_CODE	ATVPROJ_CODE	ATVPROJ
AMBSTGY_STGY_PLAN	AMRSTGY_STGY_PLAN	AMRSTGY
AMBSTGY_PROJ_CODE	AMRSTGY_PROJ_CODE	AMRSTGY

Index

Index Name	Index Type	Column Name
AMBSTGY_KEY_INDEX		AMBSTGY_STGY_PLAN

Comments

Source Code Comments

Prospect Management Strategy Assignment Table

Columns Comments for AMBSTGY_STGY_PLAN (1)

Source Code Comments

This field specifie the Strategy Plan name.

Columns Comments for AMBSTGY_ACTIVITY_DATE (2)

Source Code Comments

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

Columns Comments for AMBSTGY_PROJ_CODE (3)

Source Code Comments

This field specifies the Project code associated with the Strategy plan.

Table AMRCONF

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMRCONF_PIDM	AMRCONF_PIDM	NUMBER(8,0)	No	*
AMRCONF_IDEN_CODE	AMRCONF_IDEN_CODE	VARCHAR2(5)	No	*	*
AMRCONF_USER_ID	AMRCONF_USER_ID	VARCHAR2(30)	No	*
AMRCONF_GRP_SEQ_NO	AMRCONF_GRP_SEQ_NO	NUMBER(15,0)	No	*
AMRCONF_ACTIVITY_DATE	AMRCONF_ACTIVITY_DATE	DATE	No
AMRCONF_ENTRY_DATE	AMRCONF_ENTRY_DATE	DATE	No
AMRCONF_CONFID_IND	AMRCONF_CONFID_IND	VARCHAR2(1)	Yes
AMRCONF_USER	AMRCONF_USER	VARCHAR2(30)	No
AMRCONF_COMMENT	AMRCONF_COMMENT	LONG	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRCONF_IDEN_CODE	GURIDEN_IDEN_CODE	GURIDEN

Index

Index Name	Index Type	Column Name
PK_AMRCONF	Unique	AMRCONF_PIDM
PK_AMRCONF	Unique	AMRCONF_GRP_SEQ_NO
PK_AMRCONF	Unique	AMRCONF_IDEN_CODE
PK_AMRCONF	Unique	AMRCONF_USER_ID

Comments

Source Code Comments

Prospect Confidentiality Table

Columns Comments for AMRCONF_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMRCONF_IDEN_CODE (2)

Source Code Comments

This field specifies identification code.

Columns Comments for AMRCONF_USER_ID (3)

Source Code Comments

This field specifies the identification code user id.

Columns Comments for AMRCONF_GRP_SEQ_NO (4)

Source Code Comments

This field specifies internal generated number for group.

Columns Comments for AMRCONF_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for AMRCONF_ENTRY_DATE (6)

Source Code Comments

This field specifies the entry date the confidentiality information was entered.

Columns Comments for AMRCONF_CONFID_IND (7)

Source Code Comments

This field specifies if confidentiality is set.

Columns Comments for AMRCONF_USER (8)

Source Code Comments

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

Columns Comments for AMRCONF_COMMENT (9)

Source Code Comments

Free form text comment for this prospect.

Table AMRCONT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMRCONT_PIDM	AMRCONT_PIDM	NUMBER(8,0)	No	*
AMRCONT_IDEN_CODE	AMRCONT_IDEN_CODE	VARCHAR2(5)	No		*
AMRCONT_PROJ_CODE	AMRCONT_PROJ_CODE	VARCHAR2(6)	Yes		*
AMRCONT_SCNT_CODE	AMRCONT_SCNT_CODE	VARCHAR2(3)	No		*
AMRCONT_ITEM_REFNO	AMRCONT_ITEM_REFNO	NUMBER(15,0)	No	*
AMRCONT_ACTIVITY_DATE	AMRCONT_ACTIVITY_DATE	DATE	No
AMRCONT_IDEN_CODE_ASGN	AMRCONT_IDEN_CODE_ASGN	VARCHAR2(5)	Yes		*
AMRCONT_CONTACT	AMRCONT_CONTACT	VARCHAR2(2000)	No
AMRCONT_CONTACT_DATE	AMRCONT_CONTACT_DATE	DATE	No
AMRCONT_CREATE_TICKLER	AMRCONT_CREATE_TICKLER	VARCHAR2(1)	Yes
AMRCONT_TICKLER	AMRCONT_TICKLER	VARCHAR2(180)	Yes
AMRCONT_TICK_DATE	AMRCONT_TICK_DATE	DATE	Yes
AMRCONT_TICK_STATUS	AMRCONT_TICK_STATUS	VARCHAR2(1)	Yes
AMRCONT_CONFID_IND	AMRCONT_CONFID_IND	VARCHAR2(1)	Yes
AMRCONT_MOVE_CODE	AMRCONT_MOVE_CODE	VARCHAR2(4)	Yes		*
AMRCONT_ASK_AMT	AMRCONT_ASK_AMT	NUMBER(11,2)	Yes
AMRCONT_PROJ_CODE_2	AMRCONT_PROJ_CODE_2	VARCHAR2(6)	Yes		*
AMRCONT_PROJ_CODE_3	AMRCONT_PROJ_CODE_3	VARCHAR2(6)	Yes		*
AMRCONT_PROJ_CODE_4	AMRCONT_PROJ_CODE_4	VARCHAR2(6)	Yes		*
AMRCONT_ASK_AMT_2	AMRCONT_ASK_AMT_2	NUMBER(11,2)	Yes
AMRCONT_ASK_AMT_3	AMRCONT_ASK_AMT_3	NUMBER(11,2)	Yes
AMRCONT_ASK_AMT_4	AMRCONT_ASK_AMT_4	NUMBER(11,2)	Yes
AMRCONT_PROP_CODE	AMRCONT_PROP_CODE	VARCHAR2(6)	Yes		*
AMRCONT_CALL_REPORT	AMRCONT_CALL_REPORT	LONG	Yes
AMRCONT_USER_ID	AMRCONT_USER_ID	VARCHAR2(30)	No
AMRCONT_GEN_CONTACT_IND	AMRCONT_GEN_CONTACT_IND	VARCHAR2(1)	No
AMRCONT_STGY_PLAN	AMRCONT_STGY_PLAN	VARCHAR2(15)	Yes
AMRCONT_MOVE_SEQNO	AMRCONT_MOVE_SEQNO	NUMBER(15,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRCONT_SCNT_CODE	ATVSCNT_CODE	ATVSCNT
AMRCONT_MOVE_CODE	ATVMOVE_CODE	ATVMOVE
AMRCONT_PROJ_CODE	ATVPROJ_CODE	ATVPROJ
AMRCONT_PROJ_CODE_2	ATVPROJ_CODE	ATVPROJ
AMRCONT_PROJ_CODE_3	ATVPROJ_CODE	ATVPROJ
AMRCONT_PROJ_CODE_4	ATVPROJ_CODE	ATVPROJ
AMRCONT_PROP_CODE	ATVPROP_CODE	ATVPROP
AMRCONT_IDEN_CODE	GURIDEN_IDEN_CODE	GURIDEN
AMRCONT_IDEN_CODE_ASGN	GURIDEN_IDEN_CODE	GURIDEN

Index

Index Name	Index Type	Column Name
PK_AMRCONT	Unique	AMRCONT_PIDM
PK_AMRCONT	Unique	AMRCONT_ITEM_REFNO

Comments

Source Code Comments

Prospect Contact Table

Columns Comments for AMRCONT_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMRCONT_IDEN_CODE (2)

Source Code Comments

This field specifies identification code.

Columns Comments for AMRCONT_PROJ_CODE (3)

Source Code Comments

This field specifies the project/interest code.

Columns Comments for AMRCONT_SCNT_CODE (4)

Source Code Comments

This field specifies the contact code.

Columns Comments for AMRCONT_ITEM_REFNO (5)

Source Code Comments

This field specifies internal generated number for each contact.

Columns Comments for AMRCONT_ACTIVITY_DATE (6)

Source Code Comments

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

Columns Comments for AMRCONT_IDEN_CODE_ASGN (7)

Source Code Comments

This field specifies the identification code assigned to contact.

Columns Comments for AMRCONT_CONTACT (8)

Source Code Comments

This field specifies the contact that was made.

Columns Comments for AMRCONT_CONTACT_DATE (9)

Source Code Comments

This field specifies the date the contact was made.

Columns Comments for AMRCONT_CREATE_TICKLER (10)

Source Code Comments

This field specifies if a tickler is to be created.

Columns Comments for AMRCONT_TICKLER (11)

Source Code Comments

This field specifies the message.

Columns Comments for AMRCONT_TICK_DATE (12)

Source Code Comments

This field specifies the message date.

Columns Comments for AMRCONT_TICK_STATUS (13)

Source Code Comments

This field specifies the message status.

Columns Comments for AMRCONT_CONFID_IND (14)

Source Code Comments

This field specifies if the message is confidential.

Columns Comments for AMRCONT_MOVE_CODE (15)

Source Code Comments

This field specifies the move code.

Columns Comments for AMRCONT_ASK_AMT (16)

Source Code Comments

This field specifies the asking amount for the contact/project.

Columns Comments for AMRCONT_PROJ_CODE_2 (17)

Source Code Comments

This field specifies the second project/interest code.

Columns Comments for AMRCONT_PROJ_CODE_3 (18)

Source Code Comments

This field specifies the third project/interest code.

Columns Comments for AMRCONT_PROJ_CODE_4 (19)

Source Code Comments

This field specifies the forth project/interest code.

Columns Comments for AMRCONT_ASK_AMT_2 (20)

Source Code Comments

This field specifies the asking amount for the second contact/project.

Columns Comments for AMRCONT_ASK_AMT_3 (21)

Source Code Comments

This field specifies the asking amount for the third contact/project.

Columns Comments for AMRCONT_ASK_AMT_4 (22)

Source Code Comments

This field specifies the asking amount for the forth contact/project.

Columns Comments for AMRCONT_PROP_CODE (23)

Source Code Comments

The Proposal code which is being associated to the Contact.

Columns Comments for AMRCONT_GEN_CONTACT_IND (26)

Source Code Comments

Prospect contact or General Contact indicator: this field indicates whether record is a Prospect contact or General contact, "N" indicates a Prospect contact, "Y" indicates a General contact.

Columns Comments for AMRCONT_MOVE_SEQNO (28)

Source Code Comments

Free form text comments about the call to this prospect.

Table AMREXRT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AMREXRT_PIDM	AMREXRT_PIDM	NUMBER(8,0)	No
AMREXRT_EXRS_CODE	AMREXRT_EXRS_CODE	VARCHAR2(5)	No	*
AMREXRT_EXT_VALUE	AMREXRT_EXT_VALUE	VARCHAR2(4)	Yes
AMREXRT_EXT_SCORE	AMREXRT_EXT_SCORE	VARCHAR2(4)	Yes
AMREXRT_EXT_LEVEL	AMREXRT_EXT_LEVEL	VARCHAR2(4)	Yes
AMREXRT_ACTIVITY_DATE	AMREXRT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMREXRT_EXRS_CODE	ATVEXRS_CODE	ATVEXRS

Index

Index Name	Index Type	Column Name
AMREXRT_KEY_INDEX	Unique	AMREXRT_PIDM
AMREXRT_KEY_INDEX	Unique	AMREXRT_EXRS_CODE
AMREXRT_KEY_INDEX	Unique	AMREXRT_EXT_VALUE

Comments

Source Code Comments

Prospect External Ratings Table

Columns Comments for AMREXRT_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMREXRT_EXRS_CODE (2)

Source Code Comments

This field specifies external source code.

Columns Comments for AMREXRT_EXT_VALUE (3)

Source Code Comments

This field specifies external source value.

Columns Comments for AMREXRT_EXT_SCORE (4)

Source Code Comments

This field specifies the score of external rating.

Columns Comments for AMREXRT_EXT_LEVEL (5)

Source Code Comments

This field specifies matching level of external source code.

Columns Comments for AMREXRT_ACTIVITY_DATE (6)

Source Code Comments

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

Table AMRINFO

Schema Name ALUMNI
Label AMRINFO
Server name S4B70
Creation Date 09/29/2003 12:12:49: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 AMRPCMT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
AMRPCMT_PIDM	AMRPCMT_PIDM	NUMBER(8,0)	No	*
AMRPCMT_IDEN_CODE	AMRPCMT_IDEN_CODE	VARCHAR2(5)	No
AMRPCMT_GRP_SEQ_NO	AMRPCMT_GRP_SEQ_NO	NUMBER(15,0)	No	*
AMRPCMT_LNE_SEQ_NO	AMRPCMT_LNE_SEQ_NO	NUMBER(23,20)	No	*
AMRPCMT_ACTIVITY_DATE	AMRPCMT_ACTIVITY_DATE	DATE	No
AMRPCMT_COMMENT	AMRPCMT_COMMENT	VARCHAR2(60)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_AMRPCMT	Unique	AMRPCMT_PIDM
PK_AMRPCMT	Unique	AMRPCMT_GRP_SEQ_NO
PK_AMRPCMT	Unique	AMRPCMT_LNE_SEQ_NO

Comments

Source Code Comments

Prospect Comment Table

Columns Comments for AMRPCMT_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMRPCMT_IDEN_CODE (2)

Source Code Comments

This field specifies identification code.

Columns Comments for AMRPCMT_GRP_SEQ_NO (3)

Source Code Comments

Internally generated group sequence number.

Columns Comments for AMRPCMT_LNE_SEQ_NO (4)

Source Code Comments

Internallly generated line sequence number.

Columns Comments for AMRPCMT_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for AMRPCMT_COMMENT (6)

Source Code Comments

This field specifies comment.

Table AMRPLAN

Schema Name ALUMNI
Label AMRPLAN
Server name S4B70
Creation Date 09/29/2003 12:12:49: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_PROJ_CODE	ATVPROJ_CODE	ATVPROJ
AMRPLAN_MOVE_CODE	ATVMOVE_CODE	ATVMOVE
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 AMRPRIN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMRPRIN_PIDM	AMRPRIN_PIDM	NUMBER(8,0)	No	*	*
AMRPRIN_PROJ_CODE	AMRPRIN_PROJ_CODE	VARCHAR2(6)	No	*	*
AMRPRIN_ACTIVITY_DATE	AMRPRIN_ACTIVITY_DATE	DATE	No
AMRPRIN_GIVH_CODE	AMRPRIN_GIVH_CODE	VARCHAR2(2)	Yes		*
AMRPRIN_TARGET_ASK_AMT	AMRPRIN_TARGET_ASK_AMT	NUMBER(10,2)	Yes
AMRPRIN_TARGET_ASK_DATE	AMRPRIN_TARGET_ASK_DATE	DATE	Yes
AMRPRIN_USER	AMRPRIN_USER	VARCHAR2(30)	No
AMRPRIN_PRST_CODE	AMRPRIN_PRST_CODE	VARCHAR2(1)	Yes		*
AMRPRIN_PRST_DATE	AMRPRIN_PRST_DATE	DATE	Yes
AMRPRIN_PROJ_EFF_FROM_DATE	AMRPRIN_PROJ_EFF_FROM_DATE	DATE	Yes
AMRPRIN_PROJ_EFF_TO_DATE	AMRPRIN_PROJ_EFF_TO_DATE	DATE	Yes
AMRPRIN_PROJ_TEXT	AMRPRIN_PROJ_TEXT	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRPRIN_GIVH_CODE	ATVGIVH_CODE	ATVGIVH
AMRPRIN_PIDM	AMRINFO_PIDM	AMRINFO
AMRPRIN_PROJ_CODE	ATVPROJ_CODE	ATVPROJ
AMRPRIN_PRST_CODE	ATVPRST_CODE	ATVPRST

Index

Index Name	Index Type	Column Name
PK_AMRPRIN	Unique	AMRPRIN_PIDM
PK_AMRPRIN	Unique	AMRPRIN_PROJ_CODE

Comments

Source Code Comments

Prospect Project/Interest Table

Columns Comments for AMRPRIN_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AMRPRIN_PROJ_CODE (2)

Source Code Comments

This field specifies project/interest code.

Columns Comments for AMRPRIN_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for AMRPRIN_GIVH_CODE (4)

Source Code Comments

This field specifies giving vehicle code.

Columns Comments for AMRPRIN_TARGET_ASK_AMT (5)

Source Code Comments

Target ask amount for the constituent for the project.

Columns Comments for AMRPRIN_TARGET_ASK_DATE (6)

Source Code Comments

Target ask date for the constituent for the project.

Columns Comments for AMRPRIN_USER (7)

Source Code Comments

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

Columns Comments for AMRPRIN_PRST_CODE (8)

Source Code Comments

This field specifies the Status of the project for the prospect.

Columns Comments for AMRPRIN_PRST_DATE (9)

Source Code Comments

This field specifies the Date of the project status for the prospect.

Columns Comments for AMRPRIN_PROJ_EFF_FROM_DATE (10)

Source Code Comments

This field specifies the Begin date that the project is effective.

Columns Comments for AMRPRIN_PROJ_EFF_TO_DATE (11)

Source Code Comments

This field specifies the End date that the project is effective.

Columns Comments for AMRPRIN_PROJ_TEXT (12)

Source Code Comments

This field specifies free format Text about the project.

Table AMRPROP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AMRPROP_PIDM	AMRPROP_PIDM	NUMBER(8,0)	No	*	*
AMRPROP_PROP_CODE	AMRPROP_PROP_CODE	VARCHAR2(6)	No	*	*
AMRPROP_PROJ_CODE	AMRPROP_PROJ_CODE	VARCHAR2(6)	No	*	*
AMRPROP_USER	AMRPROP_USER	VARCHAR2(30)	No
AMRPROP_ACTIVITY_DATE	AMRPROP_ACTIVITY_DATE	DATE	No
AMRPROP_GIVH_CODE	AMRPROP_GIVH_CODE	VARCHAR2(2)	Yes		*
AMRPROP_TARGET_ASK_AMOUNT	AMRPROP_TARGET_ASK_AMOUNT	NUMBER(11,2)	Yes
AMRPROP_TARGET_ASK_DATE	AMRPROP_TARGET_ASK_DATE	DATE	Yes
AMRPROP_PRST_CODE	AMRPROP_PRST_CODE	VARCHAR2(1)	Yes		*
AMRPROP_PRST_DATE	AMRPROP_PRST_DATE	DATE	Yes
AMRPROP_PROJ_EFF_FROM_DATE	AMRPROP_PROJ_EFF_FROM_DATE	DATE	Yes
AMRPROP_PROJ_EFF_TO_DATE	AMRPROP_PROJ_EFF_TO_DATE	DATE	Yes
AMRPROP_PROJ_TEXT	AMRPROP_PROJ_TEXT	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AMRPROP_GIVH_CODE	ATVGIVH_CODE	ATVGIVH
AMRPROP_PIDM	AMBPROP_PIDM	AMBPROP
AMRPROP_PROP_CODE	AMBPROP_PROP_CODE	AMBPROP
AMRPROP_PRST_CODE	ATVPRST_CODE	ATVPRST
AMRPROP_PROJ_CODE	ATVPROJ_CODE	ATVPROJ

Index

Index Name	Index Type	Column Name
PK_AMRPROP	Unique	AMRPROP_PIDM
PK_AMRPROP	Unique	AMRPROP_PROP_CODE
PK_AMRPROP	Unique	AMRPROP_PROJ_CODE