Model Organization

Model Label : BANNER Advancement Organization Processing
Path : BANNER DEV/Advancement/Advancement_ERD/Organization_ERD

List of Objects

Object Name	Object Type	Layer Name
AOBORGN	TABLE	Default
AORCONT	TABLE	Default
AORFUND	TABLE	Default
AORJPST	TABLE	Default
AORMACC	TABLE	Default
AORMAST	TABLE	Default
AORMCTL	TABLE	Default
AORMDEF	TABLE	Default
AORMEDU	TABLE	Default
AORMERQ	TABLE	Default
AORMGCD	TABLE	Default
AORMGCM	TABLE	Default
AORMIND	TABLE	Default
AORMLOC	TABLE	Default
AORMLVL	TABLE	Default
AORMNAT	TABLE	Default
AORMNED	TABLE	Default
AORMPRO	TABLE	Default
AORMPUR	TABLE	Default
AORMRTO	TABLE	Default
APREHIS	TABLE	Default
ATVJOBC	TABLE	Default
ATVMDIS	TABLE	Default
ATVSICC	TABLE	Default
SPRADDR	TABLE	Default
SPRIDEN	TABLE	Default
STVATYP	TABLE	Default

Comments

Model View

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.

Columns Comments for AOBORGN_MATCH_ORG_CEILING_YR (44)

Source Code Comments

Overall ceiling amount the organization will match each year.

Columns Comments for AOBORGN_MATCH_ORG_EMPL_YR (45)

Source Code Comments

Maximum corporate matching gift payout per employee per year.

Columns Comments for AOBORGN_MATCH_MINIMUM (46)

Source Code Comments

Minimum amount organization will match.

Columns Comments for AOBORGN_SOCIETY_NAME (47)

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 AOBORGN_YEAR_MG (48)

Source Code Comments

The year the matching gift program was started within the organization.

Columns Comments for AOBORGN_FINANCIALS_DATE (49)

Source Code Comments

The date associated with the financial total fields.

Columns Comments for AOBORGN_MG_LOAD_UPDATE_DATE (50)

Source Code Comments

The date that Matching Gift information was last loaded from an external source.

Columns Comments for AOBORGN_MG_LOAD_SOURCE (51)

Source Code Comments

The source of the last external Matching Gift information load.

Columns Comments for AOBORGN_MG_RECEIPT_IND (52)

Source Code Comments

Matching Gift Receipt Indicator, Y indicates that a receipt is required.

Columns Comments for AOBORGN_MATCH_MAXIMUM (53)

Source Code Comments

The maximum matching gift amount allowed.

Columns Comments for AOBORGN_PREFIX_CONTACT (54)

Source Code Comments

The prefix associated with the name of the Primary Contact.

Columns Comments for AOBORGN_SUFFIX_CONTACT (55)

Source Code Comments

The suffix associated with the name of the Primary Contact.

Columns Comments for AOBORGN_MG_LOAD_ID (56)

Source Code Comments

This field specifies the supplying agencies ID Number for the company being loaded

Table AORCONT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AORCONT_PIDM	AORCONT_PIDM	NUMBER(8,0)	No	*
AORCONT_SEQ_NO	AORCONT_SEQ_NO	NUMBER(23,20)	No
AORCONT_CONTACT_PIDM	AORCONT_CONTACT_PIDM	NUMBER(8,0)	Yes	*
AORCONT_LAST_NAME	AORCONT_LAST_NAME	VARCHAR2(25)	Yes
AORCONT_FIRST_NAME	AORCONT_FIRST_NAME	VARCHAR2(15)	Yes
AORCONT_MI	AORCONT_MI	VARCHAR2(1)	Yes
AORCONT_OCON_CODE	AORCONT_OCON_CODE	VARCHAR2(3)	Yes	*
AORCONT_JOBC_CODE	AORCONT_JOBC_CODE	VARCHAR2(3)	Yes	*
AORCONT_TITLE	AORCONT_TITLE	VARCHAR2(60)	Yes
AORCONT_ATYP_CODE	AORCONT_ATYP_CODE	VARCHAR2(2)	Yes	*
AORCONT_ADDR_LINE1	AORCONT_ADDR_LINE1	VARCHAR2(30)	Yes
AORCONT_ADDR_LINE2	AORCONT_ADDR_LINE2	VARCHAR2(30)	Yes
AORCONT_ADDR_LINE3	AORCONT_ADDR_LINE3	VARCHAR2(30)	Yes
AORCONT_ADDR_LINE4	AORCONT_ADDR_LINE4	VARCHAR2(30)	Yes
AORCONT_ADDR_CITY	AORCONT_ADDR_CITY	VARCHAR2(20)	Yes
AORCONT_STAT_CODE_ADDR	AORCONT_STAT_CODE_ADDR	VARCHAR2(3)	Yes	*
AORCONT_ZIPC_CODE_ADDR	AORCONT_ZIPC_CODE_ADDR	VARCHAR2(10)	Yes
AORCONT_CNTY_CODE_ADDR	AORCONT_CNTY_CODE_ADDR	VARCHAR2(5)	Yes	*
AORCONT_NATN_CODE_ADDR	AORCONT_NATN_CODE_ADDR	VARCHAR2(5)	Yes	*
AORCONT_PHONE_AREA	AORCONT_PHONE_AREA	VARCHAR2(3)	Yes
AORCONT_PHONE_NUMBER	AORCONT_PHONE_NUMBER	VARCHAR2(7)	Yes
AORCONT_PHONE_EXT	AORCONT_PHONE_EXT	VARCHAR2(4)	Yes
AORCONT_DATE	AORCONT_DATE	DATE	Yes
AORCONT_ACTIVITY_DATE	AORCONT_ACTIVITY_DATE	DATE	No
AORCONT_DELIVERY_POINT	AORCONT_DELIVERY_POINT	NUMBER(2,0)	Yes
AORCONT_CORRECTION_DIGIT	AORCONT_CORRECTION_DIGIT	NUMBER(2,0)	Yes
AORCONT_CARRIER_ROUTE	AORCONT_CARRIER_ROUTE	VARCHAR2(4)	Yes
AORCONT_CONT_ORG_IND	AORCONT_CONT_ORG_IND	VARCHAR2(1)	Yes
AORCONT_NAME_PREFIX	AORCONT_NAME_PREFIX	VARCHAR2(20)	Yes
AORCONT_NAME_SUFFIX	AORCONT_NAME_SUFFIX	VARCHAR2(20)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AORCONT_OCON_CODE	ATVOCON_CODE	ATVOCON
AORCONT_PIDM	AOBORGN_PIDM	AOBORGN
AORCONT_JOBC_CODE	ATVJOBC_CODE	ATVJOBC
AORCONT_STAT_CODE_ADDR	STVSTAT_CODE	STVSTAT
AORCONT_CNTY_CODE_ADDR	STVCNTY_CODE	STVCNTY
AORCONT_ATYP_CODE	STVATYP_CODE	STVATYP
AORCONT_CONTACT_PIDM	SPRIDEN_PIDM	SPRIDEN
AORCONT_NATN_CODE_ADDR	STVNATN_CODE	STVNATN

Index

Index Name	Index Type	Column Name
AORCONT_KEY_INDEX		AORCONT_PIDM

Comments

Source Code Comments

Organization Contact Repeating Table

Columns Comments for AORCONT_PIDM (1)

Source Code Comments

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

Columns Comments for AORCONT_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for AORCONT_CONTACT_PIDM (3)

Source Code Comments

This field specifies the internal system generated identification number for the secondary organizational contact(s).

Columns Comments for AORCONT_LAST_NAME (4)

Source Code Comments

This field specifies the organizational contacts last name.

Columns Comments for AORCONT_FIRST_NAME (5)

Source Code Comments

This field specifies the organizational contacts first name.

Columns Comments for AORCONT_MI (6)

Source Code Comments

This field specifies the organizational contacts middle initial.

Columns Comments for AORCONT_OCON_CODE (7)

Source Code Comments

This field specifies the type of organizational contact.

Columns Comments for AORCONT_JOBC_CODE (8)

Source Code Comments

This field specifies the job category of the organizational contacts job title.

Columns Comments for AORCONT_TITLE (9)

Source Code Comments

This field specifies the organizational contacts job title.

Columns Comments for AORCONT_ATYP_CODE (10)

Source Code Comments

This field specifies a particular address type for each of the organizational contacts addresses.

Columns Comments for AORCONT_ADDR_LINE1 (11)

Source Code Comments

This field specifies the first line of the organizational contacts address.

Columns Comments for AORCONT_ADDR_LINE2 (12)

Source Code Comments

This field specifies the second line of the organizational contacts address.

Columns Comments for AORCONT_ADDR_LINE3 (13)

Source Code Comments

This field specifies the third line of the organizational contacts address.

Columns Comments for AORCONT_ADDR_LINE4 (14)

Source Code Comments

This field specifies the fourth line of the organizational contacts address.

Columns Comments for AORCONT_ADDR_CITY (15)

Source Code Comments

This field specifies the city of the organizational contacts address.

Columns Comments for AORCONT_STAT_CODE_ADDR (16)

Source Code Comments

This field specifies the state of the organizational contacts address.

Columns Comments for AORCONT_ZIPC_CODE_ADDR (17)

Source Code Comments

This field specifies the zip code of the organizational contacts address.

Columns Comments for AORCONT_CNTY_CODE_ADDR (18)

Source Code Comments

This field specifies the county of the organizational contacts address.

Columns Comments for AORCONT_NATN_CODE_ADDR (19)

Source Code Comments

This field specifies the country of the organizational contacts address.

Columns Comments for AORCONT_PHONE_AREA (20)

Source Code Comments

This field specifies the area code of the organizational contacts telephone number.

Columns Comments for AORCONT_PHONE_NUMBER (21)

Source Code Comments

This field specifies the telephone number of the organizational contact.

Columns Comments for AORCONT_PHONE_EXT (22)

Source Code Comments

This field specifies the telephone extension of the organizational contact.

Columns Comments for AORCONT_DATE (23)

Source Code Comments

This field specifies the date organizational contact information was added or changed.

Columns Comments for AORCONT_ACTIVITY_DATE (24)

Source Code Comments

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

Columns Comments for AORCONT_DELIVERY_POINT (25)

Source Code Comments

This field indicates the delivery point associated with the address.

Columns Comments for AORCONT_CORRECTION_DIGIT (26)

Source Code Comments

This field indicates the correction digit associated with the address.

Columns Comments for AORCONT_CARRIER_ROUTE (27)

Source Code Comments

This field indicates the carrier route associated with the address.

Columns Comments for AORCONT_CONT_ORG_IND (28)

Source Code Comments

This fields indicates whether the address type belongs to the constitiuent or the organization.

Columns Comments for AORCONT_NAME_PREFIX (29)

Source Code Comments

The prefix associated with the name of the Secondary Contact.

Columns Comments for AORCONT_NAME_SUFFIX (30)

Source Code Comments

The suffix associated with the name of the Secondary Contact.

Table AORFUND

Schema Name ALUMNI
Label AORFUND
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
AORFUND_PIDM	AORFUND_PIDM	NUMBER(8,0)	No	*	*
AORFUND_FUND_CODE	AORFUND_FUND_CODE	VARCHAR2(6)	No	*	*
AORFUND_ACTIVITY_DATE	AORFUND_ACTIVITY_DATE	DATE	No
AORFUND_COMMENT	AORFUND_COMMENT	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AORFUND_FUND_CODE	ATVFUND_CODE	ATVFUND
AORFUND_PIDM	AOBORGN_PIDM	AOBORGN

Index

Index Name	Index Type	Column Name
PK_AORFUND	Unique	AORFUND_PIDM
PK_AORFUND	Unique	AORFUND_FUND_CODE

Comments

Source Code Comments

Organization Fund Table

Columns Comments for AORFUND_PIDM (1)

Source Code Comments

Internal person/org identification number.

Columns Comments for AORFUND_FUND_CODE (2)

Source Code Comments

This field specifies fund code.

Columns Comments for AORFUND_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for AORFUND_COMMENT (4)

Source Code Comments

This field specifies fund comment.

Table AORJPST

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
AORJPST_EMPR_PIDM	AORJPST_EMPR_PIDM	NUMBER(8,0)	No	*
AORJPST_TITLE	AORJPST_TITLE	VARCHAR2(60)	No
AORJPST_USER	AORJPST_USER	VARCHAR2(30)	No
AORJPST_ACTIVITY_DATE	AORJPST_ACTIVITY_DATE	DATE	No
AORJPST_SUBMIT_DATE	AORJPST_SUBMIT_DATE	DATE	No
AORJPST_ACPT_APPL_UNTIL	AORJPST_ACPT_APPL_UNTIL	DATE	No
AORJPST_CONTACT_NAME	AORJPST_CONTACT_NAME	VARCHAR2(60)	No
AORJPST_DESC	AORJPST_DESC	VARCHAR2(2000)	No
AORJPST_LOCATION	AORJPST_LOCATION	VARCHAR2(30)	No
AORJPST_DISP_WEB_IND	AORJPST_DISP_WEB_IND	VARCHAR2(1)	No
AORJPST_CONTACT_EMAIL	AORJPST_CONTACT_EMAIL	VARCHAR2(60)	Yes
AORJPST_REVIEWED_IND	AORJPST_REVIEWED_IND	VARCHAR2(1)	Yes
AORJPST_REVIEWED_USER	AORJPST_REVIEWED_USER	VARCHAR2(30)	Yes
AORJPST_EMPL_PIDM	AORJPST_EMPL_PIDM	NUMBER(8,0)	Yes
AORJPST_EMPR_URL	AORJPST_EMPR_URL	VARCHAR2(120)	Yes
AORJPST_STREET_LINE1	AORJPST_STREET_LINE1	VARCHAR2(30)	Yes
AORJPST_STREET_LINE2	AORJPST_STREET_LINE2	VARCHAR2(30)	Yes
AORJPST_STREET_LINE3	AORJPST_STREET_LINE3	VARCHAR2(30)	Yes
AORJPST_CITY	AORJPST_CITY	VARCHAR2(20)	Yes
AORJPST_STAT_CODE	AORJPST_STAT_CODE	VARCHAR2(3)	Yes	*
AORJPST_ZIP	AORJPST_ZIP	VARCHAR2(10)	Yes
AORJPST_NATN_CODE	AORJPST_NATN_CODE	VARCHAR2(5)	Yes
AORJPST_PHONE_AREA	AORJPST_PHONE_AREA	VARCHAR2(3)	Yes
AORJPST_PHONE_NUMBER	AORJPST_PHONE_NUMBER	VARCHAR2(7)	Yes
AORJPST_PHONE_EXT	AORJPST_PHONE_EXT	VARCHAR2(4)	Yes
AORJPST_FAX_AREA	AORJPST_FAX_AREA	VARCHAR2(3)	Yes
AORJPST_FAX_NUMBER	AORJPST_FAX_NUMBER	VARCHAR2(7)	Yes
AORJPST_JOBC_CODE_1	AORJPST_JOBC_CODE_1	VARCHAR2(3)	Yes	*
AORJPST_JOBC_CODE_2	AORJPST_JOBC_CODE_2	VARCHAR2(3)	Yes	*
AORJPST_JOBC_CODE_3	AORJPST_JOBC_CODE_3	VARCHAR2(3)	Yes	*
AORJPST_REQMNT	AORJPST_REQMNT	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AORJPST_EMPR_PIDM	AOBORGN_PIDM	AOBORGN
AORJPST_JOBC_CODE_1	ATVJOBC_CODE	ATVJOBC
AORJPST_JOBC_CODE_2	ATVJOBC_CODE	ATVJOBC
AORJPST_JOBC_CODE_3	ATVJOBC_CODE	ATVJOBC
AORJPST_STAT_CODE	STVSTAT_CODE	STVSTAT

Index

Index Name	Index Type	Column Name
AORJPST_EMPL_INDEX		AORJPST_EMPL_PIDM
AORJPST_EMPL_INDEX		AORJPST_TITLE
AORJPST_EMPR_INDEX		AORJPST_EMPR_PIDM
AORJPST_EMPR_INDEX		AORJPST_TITLE

Comments

Source Code Comments

Job Posting Repeating Table, stores job postings from Web users.

Columns Comments for AORJPST_EMPR_PIDM (1)

Source Code Comments

The Internal ID of the Employer.

Columns Comments for AORJPST_TITLE (2)

Source Code Comments

The title of the job being posted.

Columns Comments for AORJPST_USER (3)

Source Code Comments

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

Columns Comments for AORJPST_ACTIVITY_DATE (4)

Source Code Comments

The date the job posting was created or last modified.

Columns Comments for AORJPST_SUBMIT_DATE (5)

Source Code Comments

The date the job posting was submitted.

Columns Comments for AORJPST_ACPT_APPL_UNTIL (6)

Source Code Comments

The date until which applications will be accepted for the job posting.

Columns Comments for AORJPST_CONTACT_NAME (7)

Source Code Comments

Then name of the person to contact for the job posting.

Columns Comments for AORJPST_DESC (8)

Source Code Comments

A description of the job offered by the job posting.

Columns Comments for AORJPST_LOCATION (9)

Source Code Comments

The location of the job, city, state, etc.

Columns Comments for AORJPST_DISP_WEB_IND (10)

Source Code Comments

Display on the Web Indicator, Y indicates this posting can be displayed.

Columns Comments for AORJPST_CONTACT_EMAIL (11)

Source Code Comments

The E-mail address of the contact person for the job posting.

Columns Comments for AORJPST_REVIEWED_IND (12)

Source Code Comments

Reviewed Indicator, Y indicates that the job posting has been reviewed and approved.

Columns Comments for AORJPST_REVIEWED_USER (13)

Source Code Comments

The User who reviewed and approved the job posting.

Columns Comments for AORJPST_EMPL_PIDM (14)

Source Code Comments

The Internal ID of the Web User who posted the job.

Columns Comments for AORJPST_EMPR_URL (15)

Source Code Comments

The URL for the Web site of the Employer.

Columns Comments for AORJPST_STREET_LINE1 (16)

Source Code Comments

The first line of the street address of the Employer.

Columns Comments for AORJPST_STREET_LINE2 (17)

Source Code Comments

The second line of the street address of the Employer.

Columns Comments for AORJPST_STREET_LINE3 (18)

Source Code Comments

The third line of the street address of the Employer.

Columns Comments for AORJPST_CITY (19)

Source Code Comments

The city of the addess of the Employer.

Columns Comments for AORJPST_STAT_CODE (20)

Source Code Comments

The state or province of the addess of the Employer.

Columns Comments for AORJPST_ZIP (21)

Source Code Comments

The zip or postal code of the addess of the Employer.

Columns Comments for AORJPST_NATN_CODE (22)

Source Code Comments

The nation of the addess of the Employer.

Columns Comments for AORJPST_PHONE_AREA (23)

Source Code Comments

The area code of the phone number of the Employer.

Columns Comments for AORJPST_PHONE_NUMBER (24)

Source Code Comments

The Phone number of the Employer.

Columns Comments for AORJPST_PHONE_EXT (25)

Source Code Comments

The extension of the phone number of the Employer.

Columns Comments for AORJPST_FAX_AREA (26)

Source Code Comments

The area code of the FAX number of the Employer.

Columns Comments for AORJPST_FAX_NUMBER (27)

Source Code Comments

The FAX number of the Employer.

Columns Comments for AORJPST_JOBC_CODE_1 (28)

Source Code Comments

The first SICC job code associated with the job posting.

Columns Comments for AORJPST_JOBC_CODE_2 (29)

Source Code Comments

The second SICC job code associated with the job posting.

Columns Comments for AORJPST_JOBC_CODE_3 (30)

Source Code Comments

The third SICC job code associated with the job posting.

Columns Comments for AORJPST_REQMNT (31)

Source Code Comments

Free form comments about the job posting.

Table AORMACC

Schema Name ALUMNI
Label AORMACC
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
AORMACC_PIDM	AORMACC_PIDM	NUMBER(8,0)	No	*	*
AORMACC_MACC_CODE	AORMACC_MACC_CODE	VARCHAR2(1)	No	*	*
AORMACC_ACTIVITY_DATE	AORMACC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AORMACC_MACC_CODE	ATVMACC_CODE	ATVMACC
AORMACC_PIDM	AOBORGN_PIDM	AOBORGN

Index

Index Name	Index Type	Column Name
PK_AORMACC	Unique	AORMACC_PIDM
PK_AORMACC	Unique	AORMACC_MACC_CODE

Comments

Source Code Comments

Matching Gift Institution Accreditation Table

Columns Comments for AORMACC_PIDM (1)

Source Code Comments

Organization internal identification number.

Columns Comments for AORMACC_MACC_CODE (2)

Source Code Comments

Organization institution accreditation code.

Columns Comments for AORMACC_ACTIVITY_DATE (3)

Source Code Comments

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

Table AORMAST

Schema Name ALUMNI
Label AORMAST
Server name MALDEV8_B60
Creation Date 04/11/2003 13:18:16:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
AORMAST_PIDM	AORMAST_PIDM	NUMBER(8,0)	No	*	*
AORMAST_MAST_CODE	AORMAST_MAST_CODE	VARCHAR2(1)	No	*	*
AORMAST_ACTIVITY_DATE	AORMAST_ACTIVITY_DATE	DATE	No
AORMAST_ATTEND_YEARS	AORMAST_ATTEND_YEARS	NUMBER(2,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
AORMAST_MAST_CODE	ATVMAST_CODE	ATVMAST
AORMAST_PIDM	AOBORGN_PIDM	AOBORGN

Index

Index Name	Index Type	Column Name
PK_AORMAST	Unique	AORMAST_PIDM
PK_AORMAST	Unique	AORMAST_MAST_CODE

Comments

Source Code Comments

Matching Gift Advancement Status Table

Columns Comments for AORMAST_PIDM (1)

Source Code Comments

Organization internal identification number.

Columns Comments for AORMAST_MAST_CODE (2)

Source Code Comments

MG Alumni status code.

Columns Comments for AORMAST_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for AORMAST_ATTEND_YEARS (4)

Source Code Comments

Required number of years in attendance.

Table AORMCTL

Schema Name ALUMNI
Label AORMCTL
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
AORMCTL_PIDM	AORMCTL_PIDM	NUMBER(8,0)	No	*	*
AORMCTL_MCTL_CODE	AORMCTL_MCTL_CODE	VARCHAR2(1)	No	*	*
AORMCTL_ACTIVITY_DATE	AORMCTL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
AORMCTL_PIDM	AOBORGN_PIDM	AOBORGN
AORMCTL_MCTL_CODE	ATVMCTL_CODE	ATVMCTL

Index

Index Name	Index Type	Column Name
PK_AORMCTL	Unique	AORMCTL_PIDM
PK_AORMCTL	Unique	AORMCTL_MCTL_CODE