Model Constituent

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

List of Objects

Object Name	Object Type	Layer Name
APBCONS	TABLE	Default
APRACYR	TABLE	Default
APRADEG	TABLE	Default
APRCHIS	TABLE	Default
APRCHLD	TABLE	Default
APRCSPS	TABLE	Default
APRDHIS	TABLE	Default
APREHIS	TABLE	Default
ASRSSAG	TABLE	Default
ATVDOTT	TABLE	Default
ATVINCM	TABLE	Default
SPRADDR	TABLE	Default
SPRIDEN	TABLE	Default
STVATYP	TABLE	Default
STVCOLL	TABLE	Default
STVNATN	TABLE	Default
STVSTAT	TABLE	Default

Comments

Model View

Table APBCONS

Schema Name ALUMNI
Label APBCONS
Server name S4B70
Creation Date 07/14/2004 11:35:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
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
APBCONS_DATA_ORIGIN	APBCONS_DATA_ORIGIN	VARCHAR2(30)	Yes
APBCONS_USER_ID	APBCONS_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APBCONS_ATYP_CODE_PREF	STVATYP_CODE	STVATYP
APBCONS_ATYP_CODE_CM	STVATYP_CODE	STVATYP
APBCONS_ATYP_CODE_GEOR	STVATYP_CODE	STVATYP
APBCONS_COLL_CODE_PREF	STVCOLL_CODE	STVCOLL
APBCONS_NATN_CODE_HOME	STVNATN_CODE	STVNATN
APBCONS_STAT_CODE_HOME	STVSTAT_CODE	STVSTAT
APBCONS_INCM_CODE	ATVINCM_CODE	ATVINCM
APBCONS_DOTT_CODE	ATVDOTT_CODE	ATVDOTT

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.

Columns Comments for APBCONS_DATA_ORIGIN (23)

Source Code Comments

DATA SOURCE: Source system that generated or updated the data.

Table APRACYR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRACYR_PIDM	APRACYR_PIDM	NUMBER(8,0)	No	*	*
APRACYR_SACT_CODE	APRACYR_SACT_CODE	VARCHAR2(3)	Yes
APRACYR_YEAR	APRACYR_YEAR	NUMBER(4,0)	No	*	*
APRACYR_ACTIVITY_DATE	APRACYR_ACTIVITY_DATE	DATE	No
APRACYR_ACTC_CODE	APRACYR_ACTC_CODE	VARCHAR2(8)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRACYR_PIDM	APRACTY_PIDM	APRACTY
APRACYR_ACTC_CODE	APRACTY_ACTC_CODE	APRACTY
APRACYR_ACTC_CODE	STVACTC_CODE	STVACTC
APRACYR_PIDM	APRADEG_PIDM	APRADEG
APRACYR_YEAR	APRADEG_ACYR_CODE	APRADEG

Index

Index Name	Index Type	Column Name
PK_APRACYR	Unique	APRACYR_PIDM
PK_APRACYR	Unique	APRACYR_ACTC_CODE
PK_APRACYR	Unique	APRACYR_YEAR

Comments

Source Code Comments

Special Activity Year Repeating Table

Columns Comments for APRACYR_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRACYR_SACT_CODE (2)

Source Code Comments

This column is no longer used Rel 1.2

Columns Comments for APRACYR_YEAR (3)

Source Code Comments

This field specifies the year(s) associated with a particular special activity.

Columns Comments for APRACYR_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for APRACYR_ACTC_CODE (5)

Source Code Comments

The ACTC code replaced the SACT code in Rel 1.2 using the STVACTC student validation form.

Table APRADEG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
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
APRADEG_REVIEWED_IND	APRADEG_REVIEWED_IND	VARCHAR2(1)	Yes
APRADEG_REVIEWED_USER	APRADEG_REVIEWED_USER	VARCHAR2(30)	Yes
APRADEG_MAJOR_COMMENT	APRADEG_MAJOR_COMMENT	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRADEG_PIDM	APBCONS_PIDM	APBCONS
APRADEG_ACYR_CODE	STVACYR_CODE	STVACYR
APRADEG_ACYR_CODE_BULLETIN	STVACYR_CODE	STVACYR
APRADEG_CAMP_CODE	STVCAMP_CODE	STVCAMP
APRADEG_COLL_CODE	STVCOLL_CODE	STVCOLL
APRADEG_DEGC_CODE	STVDEGC_CODE	STVDEGC
APRADEG_DEPT_CODE	STVDEPT_CODE	STVDEPT
APRADEG_DEPT_CODE_2	STVDEPT_CODE	STVDEPT
APRADEG_HOND_CODE_1	STVHOND_CODE	STVHOND
APRADEG_HOND_CODE_2	STVHOND_CODE	STVHOND
APRADEG_HOND_CODE_3	STVHOND_CODE	STVHOND
APRADEG_HOND_CODE_4	STVHOND_CODE	STVHOND
APRADEG_HOND_CODE_5	STVHOND_CODE	STVHOND
APRADEG_HONR_CODE	STVHONR_CODE	STVHONR
APRADEG_HONR_CODE_2	STVHONR_CODE	STVHONR
APRADEG_HONR_CODE_3	STVHONR_CODE	STVHONR
APRADEG_HONR_CODE_4	STVHONR_CODE	STVHONR
APRADEG_HONR_CODE_5	STVHONR_CODE	STVHONR
APRADEG_MAJR_CODE_MINR_1	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_MINR_2	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_1	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_2	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_3	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_4	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_5	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_6	STVMAJR_CODE	STVMAJR
APRADEG_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_APRADEG	Unique	APRADEG_PIDM
PK_APRADEG	Unique	APRADEG_SEQ_NO

Comments

Source Code Comments

Academic Degree Repeating Table

Columns Comments for APRADEG_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRADEG_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRADEG_SBGI_CODE (3)

Source Code Comments

This field specifies the institution at which the constituent earned the degree.

Columns Comments for APRADEG_DEGC_CODE (4)

Source Code Comments

This field spsecifies the type of degree earned by the constituent.

Columns Comments for APRADEG_DATE (5)

Source Code Comments

This field specifies the date the degree was awarded to the constituent.

Columns Comments for APRADEG_HONR_CODE (6)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_COLL_CODE (7)

Source Code Comments

This field specifies the college that awarded the associated degree to the constituent.

Columns Comments for APRADEG_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for APRADEG_ACYR_CODE (9)

Source Code Comments

The Academic Year Code associated with this degree.

Columns Comments for APRADEG_ACYR_CODE_BULLETIN (10)

Source Code Comments

The Academic Year Bulletin Code associated with this degree.

Columns Comments for APRADEG_CAMP_CODE (11)

Source Code Comments

The campus associated with this degree.

Columns Comments for APRADEG_DEPT_CODE (12)

Source Code Comments

The first department associated with this degree.

Columns Comments for APRADEG_COMMENTS (13)

Source Code Comments

Free form text comments about this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_1 (14)

Source Code Comments

The first Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_2 (15)

Source Code Comments

The second Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_1 (16)

Source Code Comments

The first Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_2 (17)

Source Code Comments

The second Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_3 (18)

Source Code Comments

The third Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_4 (19)

Source Code Comments

The fourth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_5 (20)

Source Code Comments

The fifth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_6 (21)

Source Code Comments

The sixth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_DEPT_CODE_2 (22)

Source Code Comments

The second department associated with this degree.

Columns Comments for APRADEG_HONR_CODE_2 (23)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_3 (24)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_4 (25)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_5 (26)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_1 (27)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_2 (28)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_3 (29)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_4 (30)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_5 (31)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_OK_FOR_NOTES_IND (32)

Source Code Comments

OK for Notes Indicator, Y indicates that this degree can be used in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_IND (33)

Source Code Comments

Displayed in Notes Indicator, Y indicates that this degree was displaeyd in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_DATE (34)

Source Code Comments

The date that this degree was displayed in Class Notes.

Columns Comments for APRADEG_USER (35)

Source Code Comments

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

Columns Comments for APRADEG_REVIEWED_IND (36)

Source Code Comments

Reviewed Indicator, Y indicates that this degree has been reviewed and accepted.

Columns Comments for APRADEG_REVIEWED_USER (37)

Source Code Comments

The User ID of the person who reviewed and accepted this degree.

Columns Comments for APRADEG_MAJOR_COMMENT (38)

Source Code Comments

Free form text comments about this degree.

Table APRCHIS

Schema Name ALUMNI
Label APRCHIS
Server name S4B70
Creation Date 10/28/2003 11:22:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRCHIS_PIDM	APRCHIS_PIDM	NUMBER(8,0)	No	*
APRCHIS_CAMPAIGN	APRCHIS_CAMPAIGN	VARCHAR2(5)	No	*
APRCHIS_FISC_CODE	APRCHIS_FISC_CODE	NUMBER(4,0)	No	*	*
APRCHIS_AMT_PLEDGED	APRCHIS_AMT_PLEDGED	NUMBER(13,2)	Yes
APRCHIS_AMT_PLEDGED_PAID	APRCHIS_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
APRCHIS_AMT_GIFT	APRCHIS_AMT_GIFT	NUMBER(13,2)	Yes
APRCHIS_AMT_MEMO	APRCHIS_AMT_MEMO	NUMBER(13,2)	Yes
APRCHIS_ACTIVITY_DATE	APRCHIS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRCHIS_FISC_CODE	ATVFISC_CODE	ATVFISC

Index

Index Name	Index Type	Column Name
APRCHIS_KEY_INDEX2		APRCHIS_FISC_CODE
APRCHIS_KEY_INDEX2		APRCHIS_PIDM
APRCHIS_KEY_INDEX3		APRCHIS_CAMPAIGN
PK_APRCHIS	Unique	APRCHIS_PIDM
PK_APRCHIS	Unique	APRCHIS_CAMPAIGN
PK_APRCHIS	Unique	APRCHIS_FISC_CODE

Comments

Source Code Comments

Giving History By Campaign Repeating Table

Columns Comments for APRCHIS_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRCHIS_CAMPAIGN (2)

Source Code Comments

This field specifies the campaign(s) the constituent has responded to with a gift or pledge payment.

Columns Comments for APRCHIS_FISC_CODE (3)

Source Code Comments

This field specifies the fiscal year associated with the campaign.

Columns Comments for APRCHIS_AMT_PLEDGED (4)

Source Code Comments

This field specifies the amount the constituent pledged to a specific campaign.

Columns Comments for APRCHIS_AMT_PLEDGED_PAID (5)

Source Code Comments

This field specifies the amount of pledge payments received from the constituent for a specific campaign.

Columns Comments for APRCHIS_AMT_GIFT (6)

Source Code Comments

This field specifies the amount of gift money received from the constituent for a specific campaign.

Columns Comments for APRCHIS_AMT_MEMO (7)

Source Code Comments

This field specifies the dollar amount of memo credit (soft dollars) the constituent has been credited with for a specific campaign.

Columns Comments for APRCHIS_ACTIVITY_DATE (8)

Source Code Comments

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

Table APRCHLD

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRCHLD_PIDM	APRCHLD_PIDM	NUMBER(8,0)	No	*	*
APRCHLD_SEQ_NO	APRCHLD_SEQ_NO	NUMBER(5,0)	No	*
APRCHLD_LAST_NAME	APRCHLD_LAST_NAME	VARCHAR2(25)	Yes
APRCHLD_FIRST_NAME	APRCHLD_FIRST_NAME	VARCHAR2(15)	Yes
APRCHLD_MI	APRCHLD_MI	VARCHAR2(1)	Yes
APRCHLD_SEX	APRCHLD_SEX	VARCHAR2(1)	Yes
APRCHLD_BIRTH_DATE	APRCHLD_BIRTH_DATE	DATE	Yes
APRCHLD_SSN	APRCHLD_SSN	VARCHAR2(9)	Yes
APRCHLD_ATYP_CODE	APRCHLD_ATYP_CODE	VARCHAR2(2)	Yes		*
APRCHLD_ACTIVITY_DATE	APRCHLD_ACTIVITY_DATE	DATE	No
APRCHLD_XREF_CODE	APRCHLD_XREF_CODE	VARCHAR2(3)	Yes		*
APRCHLD_CHLD_PIDM	APRCHLD_CHLD_PIDM	NUMBER(8,0)	Yes
APRCHLD_DISP_WEB_IND	APRCHLD_DISP_WEB_IND	VARCHAR2(1)	Yes
APRCHLD_DECEASED_IND	APRCHLD_DECEASED_IND	VARCHAR2(1)	Yes
APRCHLD_DECEASED_DATE	APRCHLD_DECEASED_DATE	DATE	Yes
APRCHLD_OK_FOR_NOTES_IND	APRCHLD_OK_FOR_NOTES_IND	VARCHAR2(1)	Yes
APRCHLD_DISP_NOTES_IND	APRCHLD_DISP_NOTES_IND	VARCHAR2(1)	Yes
APRCHLD_DISP_NOTES_DATE	APRCHLD_DISP_NOTES_DATE	DATE	Yes
APRCHLD_USER	APRCHLD_USER	VARCHAR2(30)	No
APRCHLD_REVIEWED_IND	APRCHLD_REVIEWED_IND	VARCHAR2(1)	Yes
APRCHLD_REVIEWED_USER	APRCHLD_REVIEWED_USER	VARCHAR2(30)	Yes
APRCHLD_COMMENT	APRCHLD_COMMENT	LONG	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRCHLD_PIDM	APBCONS_PIDM	APBCONS
APRCHLD_XREF_CODE	ATVXREF_CODE	ATVXREF
APRCHLD_ATYP_CODE	STVATYP_CODE	STVATYP

Index

Index Name	Index Type	Column Name
PK_APRCHLD	Unique	APRCHLD_PIDM
PK_APRCHLD	Unique	APRCHLD_SEQ_NO

Comments

Source Code Comments

Children Repeating Table

Columns Comments for APRCHLD_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRCHLD_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRCHLD_LAST_NAME (3)

Source Code Comments

This field specifies the last name of the constituents child.

Columns Comments for APRCHLD_FIRST_NAME (4)

Source Code Comments

This field specifies the first name of the constituents child.

Columns Comments for APRCHLD_MI (5)

Source Code Comments

This field specifies the middle initial of the constituents child.

Columns Comments for APRCHLD_SEX (6)

Source Code Comments

This field specifies the gender of the constituents child.

Columns Comments for APRCHLD_BIRTH_DATE (7)

Source Code Comments

This field specifies the date of birth of the constituents child.

Columns Comments for APRCHLD_SSN (8)

Source Code Comments

This field specifies the social security number of the constituents child.

Columns Comments for APRCHLD_ATYP_CODE (9)

Source Code Comments

This field specifies the constituent address type to used when corresponding with the constituents child.

Columns Comments for APRCHLD_ACTIVITY_DATE (10)

Source Code Comments

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

Columns Comments for APRCHLD_XREF_CODE (11)

Source Code Comments

This field is used to identify the cross reference record created for the constituent and child relationship.

Columns Comments for APRCHLD_CHLD_PIDM (12)

Source Code Comments

This field is internal identification number for the child. This is an optional field and is only used for children that have id on the system.

Columns Comments for APRCHLD_DISP_WEB_IND (13)

Source Code Comments

Display on the Web Indicator, Y indicates that this child may be displayed on the Web.

Columns Comments for APRCHLD_DECEASED_IND (14)

Source Code Comments

Deceased Indicator, Y indicates the this child is deceased.

Columns Comments for APRCHLD_DECEASED_DATE (15)

Source Code Comments

This id the date the child became deceased.

Columns Comments for APRCHLD_OK_FOR_NOTES_IND (16)

Source Code Comments

OK for Note Indicator, Y indicates that it is OK to use this child in Class Notes.

Columns Comments for APRCHLD_DISP_NOTES_IND (17)

Source Code Comments

Displayed in Notes Indicator, Y indicates that this child has been used in Class Notes.

Columns Comments for APRCHLD_DISP_NOTES_DATE (18)

Source Code Comments

The date that this child was used in Class Notes.

Columns Comments for APRCHLD_USER (19)

Source Code Comments

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

Columns Comments for APRCHLD_REVIEWED_IND (20)

Source Code Comments

Reviewed Indicator, Y indicates that this child has been reviewed and accepted.

Columns Comments for APRCHLD_REVIEWED_USER (21)

Source Code Comments

The User ID of the person who reviewed and accepted this child.

Columns Comments for APRCHLD_COMMENT (22)

Source Code Comments

Free form text comment for this child.

Table APRCSPS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
APRCSPS_PIDM	APRCSPS_PIDM	NUMBER(8,0)	No	*
APRCSPS_MARS_IND	APRCSPS_MARS_IND	VARCHAR2(1)	No
APRCSPS_ACTIVITY_DATE	APRCSPS_ACTIVITY_DATE	DATE	No
APRCSPS_SPS_PIDM	APRCSPS_SPS_PIDM	NUMBER(8,0)	Yes	*
APRCSPS_LAST_NAME	APRCSPS_LAST_NAME	VARCHAR2(60)	Yes
APRCSPS_FIRST_NAME	APRCSPS_FIRST_NAME	VARCHAR2(15)	Yes
APRCSPS_MAIDEN_NAME	APRCSPS_MAIDEN_NAME	VARCHAR2(60)	Yes
APRCSPS_NAME_PREFIX	APRCSPS_NAME_PREFIX	VARCHAR2(20)	Yes
APRCSPS_NAME_SUFFIX	APRCSPS_NAME_SUFFIX	VARCHAR2(20)	Yes
APRCSPS_BIRTH_DATE	APRCSPS_BIRTH_DATE	DATE	Yes
APRCSPS_SPS_COMMENT	APRCSPS_SPS_COMMENT	VARCHAR2(60)	Yes
APRCSPS_MRTL_CODE	APRCSPS_MRTL_CODE	VARCHAR2(1)	Yes	*
APRCSPS_MRTL_START_DATE	APRCSPS_MRTL_START_DATE	DATE	Yes
APRCSPS_MRTL_END_DATE	APRCSPS_MRTL_END_DATE	DATE	Yes
APRCSPS_DEAD_IND	APRCSPS_DEAD_IND	VARCHAR2(1)	Yes
APRCSPS_DEAD_DATE	APRCSPS_DEAD_DATE	DATE	Yes
APRCSPS_XREF_CODE	APRCSPS_XREF_CODE	VARCHAR2(3)	Yes	*
APRCSPS_MI	APRCSPS_MI	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRCSPS_XREF_CODE	ATVXREF_CODE	ATVXREF
APRCSPS_PIDM	APBCONS_PIDM	APBCONS
APRCSPS_MRTL_CODE	STVMRTL_CODE	STVMRTL
APRCSPS_SPS_PIDM	SPRIDEN_PIDM	SPRIDEN
APRCSPS_SPS_PIDM	SPBPERS_PIDM	SPBPERS

Index

Index Name	Index Type	Column Name
APRCSPS_KEY_INDEX		APRCSPS_PIDM

Comments

Source Code Comments

Constituent Spouse Table

Columns Comments for APRCSPS_PIDM (1)

Source Code Comments

This is the internal identification number of the constituent who is associated with the spouse.

Columns Comments for APRCSPS_MARS_IND (2)

Source Code Comments

This field is the marriage status indicator. Valid values are A for active and I for inactive. Each constituent is allowed only one spouse record with a marriage status of A.

Columns Comments for APRCSPS_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for APRCSPS_SPS_PIDM (4)

Source Code Comments

This field is the internal identification number of the spouse of the constituent. This field is optional and is populated only if the spouse has an id in BANNER.

Columns Comments for APRCSPS_LAST_NAME (5)

Source Code Comments

This field is the last name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the identification form, SPAIDEN or APAIDEN.

Columns Comments for APRCSPS_FIRST_NAME (6)

Source Code Comments

This field is the first name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the identification form, SPAIDEN or APAIDEN.

Columns Comments for APRCSPS_MAIDEN_NAME (7)

Source Code Comments

This field is the maiden name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_NAME_PREFIX (8)

Source Code Comments

This field is the spouses prefix. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_NAME_SUFFIX (9)

Source Code Comments

This field is the spouses suffix. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_BIRTH_DATE (10)

Source Code Comments

This field is the spouses birth date. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_SPS_COMMENT (11)

Source Code Comments

This field contains comments about the spouse.

Columns Comments for APRCSPS_MRTL_CODE (12)

Source Code Comments

This field is the spouses marital status. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_MRTL_START_DATE (13)

Source Code Comments

This field is the start date of the marriage.

Columns Comments for APRCSPS_MRTL_END_DATE (14)

Source Code Comments

This field is the end date of the marriage. It will default to the current date when an inactive status is entered. It is blank for active marriages.

Columns Comments for APRCSPS_DEAD_IND (15)

Source Code Comments

This field is the deceased indicator of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_DEAD_DATE (16)

Source Code Comments

This field is the deceased date of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_XREF_CODE (17)

Source Code Comments

Code used to create cross reference for the spouse on the APAXREF form. Spouse indiciator on ATVXREF table must by Y for marriage status of A, and N for marriage status of I.

Columns Comments for APRCSPS_MI (18)

Source Code Comments

Spouse middle name. It will be stored on aprcsps if the spouse does not have a BANNER Id. If the spouse does have an Id, the name be stored on spriden.

Table APRDHIS

Schema Name ALUMNI
Label APRDHIS
Server name S4B70
Creation Date 10/28/2003 11:22:42:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRDHIS_PIDM	APRDHIS_PIDM	NUMBER(8,0)	No	*
APRDHIS_DESG	APRDHIS_DESG	VARCHAR2(10)	No	*	*
APRDHIS_FISC_CODE	APRDHIS_FISC_CODE	NUMBER(4,0)	No	*	*
APRDHIS_AMT_PLEDGED	APRDHIS_AMT_PLEDGED	NUMBER(13,2)	Yes
APRDHIS_AMT_PLEDGED_PAID	APRDHIS_AMT_PLEDGED_PAID	NUMBER(13,2)	Yes
APRDHIS_AMT_GIFT	APRDHIS_AMT_GIFT	NUMBER(13,2)	Yes
APRDHIS_AMT_MEMO	APRDHIS_AMT_MEMO	NUMBER(13,2)	Yes
APRDHIS_ACTIVITY_DATE	APRDHIS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRDHIS_FISC_CODE	ATVFISC_CODE	ATVFISC
APRDHIS_DESG	ADBDESG_DESG	ADBDESG

Index

Index Name	Index Type	Column Name
APRDHIS_KEY_INDEX2		APRDHIS_FISC_CODE
APRDHIS_KEY_INDEX2		APRDHIS_PIDM
APRDHIS_KEY_INDEX3		APRDHIS_DESG
PK_APRDHIS	Unique	APRDHIS_PIDM
PK_APRDHIS	Unique	APRDHIS_DESG
PK_APRDHIS	Unique	APRDHIS_FISC_CODE

Comments

Source Code Comments

Giving History By Desg Repeating Table

Columns Comments for APRDHIS_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRDHIS_DESG (2)

Source Code Comments

This field specifies the designation(s) associated with the constituents gifts and/or pledge payments.

Columns Comments for APRDHIS_FISC_CODE (3)

Source Code Comments

This field specifies the fiscal year of the campaign the associated with the designation.