Model SPRADDR

Model Label : ERD for Banner Student SPRADDR Table.
Path : BANNER DEV/Student/Common/SPRADDR/SPRADDR_ERD

List of Objects

Object Name	Object Type	Layer Name
AMRINFO	TABLE	Default
AOBORGN	TABLE	Default
APBCONS	TABLE	Default
FTVVEND	TABLE	Default
GOBSEVS	TABLE	Default
GORADRL	TABLE	Default
GORSVAS	TABLE	Default
GORSVEI	TABLE	Default
SARADAP	TABLE	Default
SARERUL	TABLE	Default
SFBETRM	TABLE	Default
SORFOLK	TABLE	Default
SORGEOR	TABLE	Default
SORMSTA	TABLE	Default
SPRADDR	TABLE	Default
SPRIDEN	TABLE	Default
SPRTELE	TABLE	Default
SRBRECR	TABLE	Default
STVASRC	TABLE	Default
STVATYP	TABLE	Default
STVCNTY	TABLE	Default
STVNATN	TABLE	Default
STVSTAT	TABLE	Default

Comments

Model View

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 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_SICC_CODE	ATVSICC_CODE	ATVSICC
AOBORGN_MDIS_CODE	ATVMDIS_CODE	ATVMDIS
AOBORGN_JOBC_CODE	ATVJOBC_CODE	ATVJOBC
AOBORGN_ATYP_CODE	STVATYP_CODE	STVATYP
AOBORGN_PIDM	APREHIS_EMPR_PIDM	APREHIS

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 APBCONS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APBCONS_PIDM	APBCONS_PIDM	NUMBER(8,0)	No	*	*
APBCONS_PIDM	APBCONS_PIDM	NUMBER(8,0)	No	*	*
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

Foreign Key information

Column name	is Foreign Key For Column	on Table
APBCONS_INCM_CODE	ATVINCM_CODE	ATVINCM
APBCONS_DOTT_CODE	ATVDOTT_CODE	ATVDOTT
APBCONS_STAT_CODE_HOME	STVSTAT_CODE	STVSTAT
APBCONS_COLL_CODE_PREF	STVCOLL_CODE	STVCOLL
APBCONS_NATN_CODE_HOME	STVNATN_CODE	STVNATN
APBCONS_PIDM	APRCHIS_PIDM	APRCHIS
APBCONS_PIDM	APRACYR_PIDM	APRACYR
APBCONS_PIDM	APRDHIS_PIDM	APRDHIS

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.

Table FTVVEND

Schema Name FIMSMGR
Label FTVVEND
Server name MALDEV8_B60
Creation Date 02/13/2003 12:20:50:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
FTVVEND_PIDM	FTVVEND_PIDM	NUMBER(8,0)	Yes	*
FTVVEND_PIDM	FTVVEND_PIDM	NUMBER(8,0)	Yes	*
FTVVEND_EFF_DATE	FTVVEND_EFF_DATE	DATE	No
FTVVEND_TERM_DATE	FTVVEND_TERM_DATE	DATE	Yes
FTVVEND_ACTIVITY_DATE	FTVVEND_ACTIVITY_DATE	DATE	No
FTVVEND_USER_ID	FTVVEND_USER_ID	VARCHAR2(30)	No
FTVVEND_ITYP_SEQ_CODE	FTVVEND_ITYP_SEQ_CODE	NUMBER(2,0)	Yes
FTVVEND_DISC_CODE	FTVVEND_DISC_CODE	VARCHAR2(2)	Yes
FTVVEND_1099_RPT_ID	FTVVEND_1099_RPT_ID	VARCHAR2(9)	Yes
FTVVEND_TRAT_CODE	FTVVEND_TRAT_CODE	VARCHAR2(3)	Yes
FTVVEND_IN_ST_IND	FTVVEND_IN_ST_IND	VARCHAR2(1)	Yes
FTVVEND_GROUPING_IND	FTVVEND_GROUPING_IND	VARCHAR2(1)	Yes	*
FTVVEND_CARRIER_IND	FTVVEND_CARRIER_IND	VARCHAR2(1)	Yes
FTVVEND_CONTACT	FTVVEND_CONTACT	VARCHAR2(35)	Yes
FTVVEND_PHONE_AREA	FTVVEND_PHONE_AREA	VARCHAR2(3)	Yes
FTVVEND_PHONE_NUMBER	FTVVEND_PHONE_NUMBER	VARCHAR2(7)	Yes
FTVVEND_PHONE_EXT	FTVVEND_PHONE_EXT	VARCHAR2(4)	Yes
FTVVEND_ATYP_CODE	FTVVEND_ATYP_CODE	VARCHAR2(2)	Yes
FTVVEND_ADDR_SEQNO	FTVVEND_ADDR_SEQNO	NUMBER(2,0)	Yes
FTVVEND_FED_WHOLD_PCT	FTVVEND_FED_WHOLD_PCT	NUMBER(6,3)	Yes
FTVVEND_ST_WHOLD_PCT	FTVVEND_ST_WHOLD_PCT	NUMBER(6,3)	Yes
FTVVEND_COMBINED_FED_ST_FILER	FTVVEND_COMBINED_FED_ST_FILER	VARCHAR2(1)	Yes
FTVVEND_COLLECT_TAX	FTVVEND_COLLECT_TAX	VARCHAR2(1)	No
FTVVEND_VEND_CHECK_PIDM	FTVVEND_VEND_CHECK_PIDM	NUMBER(8,0)	Yes
FTVVEND_VEND_CHECK_ATYP_CODE	FTVVEND_VEND_CHECK_ATYP_CODE	VARCHAR2(2)	Yes
FTVVEND_VEND_CHECK_ADDR_SEQNO	FTVVEND_VEND_CHECK_ADDR_SEQNO	NUMBER(2,0)	Yes
FTVVEND_CURR_CODE	FTVVEND_CURR_CODE	VARCHAR2(4)	Yes
FTVVEND_ENTITY_IND	FTVVEND_ENTITY_IND	VARCHAR2(1)	Yes
FTVVEND_PIDM_OWNER	FTVVEND_PIDM_OWNER	NUMBER(8,0)	Yes
FTVVEND_EPROC_IND	FTVVEND_EPROC_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
FTVVEND_GROUPING_IND	FABINVH_GROUPING_IND	FABINVH
FTVVEND_PIDM	FABINVH_VEND_PIDM	FABINVH
FTVVEND_PIDM	FPBPOHD_VEND_PIDM	FPBPOHD

Index

Index Name	Index Type	Column Name
FTVVEND_KEY_INDEX	Unique	FTVVEND_PIDM

Comments

Source Code Comments

Vendor Validation Table

Columns Comments for FTVVEND_PIDM (1)

Source Code Comments

Personal identification number for the vendor record. This number exists on SATURN.SPRIDEN.

Columns Comments for FTVVEND_EFF_DATE (2)

Source Code Comments

EFFECTIVE DATE: The effective date for this particular record.

Columns Comments for FTVVEND_TERM_DATE (3)

Source Code Comments

TERMINATION DATE: The date when this particular record is no longer in effect.

Columns Comments for FTVVEND_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date when the information for this record on the table was entered or last updated.

Columns Comments for FTVVEND_USER_ID (5)

Source Code Comments

USER IDENTIFICATION: The unique identification code of the user.

Columns Comments for FTVVEND_ITYP_SEQ_CODE (6)

Source Code Comments

INTERNAL SEQUENCE CODES: The predefined internal codes which represent transaction types such as permanent budget and YTD actual which direct these data values to specific accumulatorsin the operating account ledger (OPAL).

Columns Comments for FTVVEND_DISC_CODE (7)

Source Code Comments

DISCOUNT CODE: The value of the discount code established on form FTVDISC.

Columns Comments for FTVVEND_1099_RPT_ID (8)

Source Code Comments

1099 REPORT IDENTIFCATION: The vendor's taxpayer identification number (TIN).

Columns Comments for FTVVEND_TRAT_CODE (9)

Source Code Comments

TAX RATE CODE: A user-defined value that corresponds to a specific tax rate.

Columns Comments for FTVVEND_IN_ST_IND (10)

Source Code Comments

IN-STATE INDICATOR: This indicator is to designate whether a vendor is 'I' for in-state or 'O' for out of state.

Columns Comments for FTVVEND_GROUPING_IND (11)

Source Code Comments

GROUPING INDICATOR: Indicates the relationship between the number of invoices processed and the number of checks. A value of '1' will create one check per invoice whereas a value of 'M' will combine many invoices on one check.

Columns Comments for FTVVEND_CARRIER_IND (12)

Source Code Comments

CARRIER INDICATOR: This indicator is used to designate vendors who are also carriers.

Columns Comments for FTVVEND_CONTACT (13)

Source Code Comments

AGENCY CONTACT: The name or title of the primary contact at the agency.

Columns Comments for FTVVEND_PHONE_AREA (14)

Source Code Comments

ADDRESS PHONE AREA CODE: The telephone area code for this particular record.

Columns Comments for FTVVEND_PHONE_NUMBER (15)

Source Code Comments

Phone number for the vendor.

Columns Comments for FTVVEND_PHONE_EXT (16)

Source Code Comments

ADDRESS PHONE EXTENSION: The telephone extension number for this particular record.

Columns Comments for FTVVEND_ATYP_CODE (17)

Source Code Comments

ADDRESS TYPE CODE: The user-defined code that describes the type of address, i.e. Purchase Order, Remit To, Mailing, etc. Must exist on SATURN.STVATYP.

Columns Comments for FTVVEND_ADDR_SEQNO (18)

Source Code Comments

ADDRESS SEQUENCE NUMBER: The user-defined sequence number associated with the address.

Columns Comments for FTVVEND_FED_WHOLD_PCT (19)

Source Code Comments

FEDERAL WITHHOLDING PERCENTAGE: The backup withholding percentage used for federal income tax reporting purposes.

Columns Comments for FTVVEND_ST_WHOLD_PCT (20)

Source Code Comments

STATE WITHHOLDING PERCENTAGE: The backup withholding percentage used for state/income tax reporting purposes.

Columns Comments for FTVVEND_COLLECT_TAX (22)

Source Code Comments

This required field designates which compensating or use taxes should be collected. Values are: 'N' for no taxes, 'S' for selected taxes and 'A' for all taxes.

Columns Comments for FTVVEND_VEND_CHECK_PIDM (23)

Source Code Comments

CHECK VENDOR PIDM: Personal identification number of check vendor in the case of third party billings. Must exist on SATURN.SPRIDEN.

Columns Comments for FTVVEND_VEND_CHECK_ATYP_CODE (24)

Source Code Comments

CHECK VENDOR CHECK ADDRESS TYPE CODE: Address type for the vendor to whom checks are to be mailed in the case of third party billings. This value must exist on SATURN.STVATYP.

Columns Comments for FTVVEND_VEND_CHECK_ADDR_SEQNO (25)

Source Code Comments

CHECK VENDOR CHECK ADDRESS SEQUENCE NUMBER: Address sequence number for the vendor to whom checks are to be addressed in the case of third party billings.

Columns Comments for FTVVEND_CURR_CODE (26)

Source Code Comments

CURRENCY CODE: Used as a default currency code for vendor.

Columns Comments for FTVVEND_ENTITY_IND (27)

Source Code Comments

ENTITY_IND: Set by form FTMVEND to distinguish between corporation and person vendors.

Columns Comments for FTVVEND_PIDM_OWNER (28)

Source Code Comments

DOING BUSINESS AS PIDM OWNER: Purpose is to provide cross-reference from Doing Business As vendor record to the ftvvend_pidm record.

Columns Comments for FTVVEND_EPROC_IND (29)

Source Code Comments

EPROCUREMENT INDICATOR: A value of Y indicates that this vendor exists in an eprocurement system at the institution. If the value is Y and the vendor record changes, a message will be sent to the eprocurement system.

Table GOBSEVS

Schema Name GENERAL
Label GOBSEVS
Server name MALDEV8_B60
Creation Date 05/23/2003 13:35:50:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBSEVS_PIDM	GOBSEVS_PIDM	NUMBER(8,0)	No	*	*
GOBSEVS_ENG_PROF_REQ_IND	GOBSEVS_ENG_PROF_REQ_IND	VARCHAR2(1)	No
GOBSEVS_ENG_PROF_MET_IND	GOBSEVS_ENG_PROF_MET_IND	VARCHAR2(1)	No
GOBSEVS_CRIMINAL_CONVICT_IND	GOBSEVS_CRIMINAL_CONVICT_IND	VARCHAR2(1)	No
GOBSEVS_TERMINATE_STUDENT_IND	GOBSEVS_TERMINATE_STUDENT_IND	VARCHAR2(1)	No
GOBSEVS_EXTEND_FAILURE_IND	GOBSEVS_EXTEND_FAILURE_IND	VARCHAR2(1)	No
GOBSEVS_TRANSFER_FAIL_IND	GOBSEVS_TRANSFER_FAIL_IND	VARCHAR2(1)	No
GOBSEVS_APPROVAL_FAIL_IND	GOBSEVS_APPROVAL_FAIL_IND	VARCHAR2(1)	No
GOBSEVS_OTHER_INFRACT_IND	GOBSEVS_OTHER_INFRACT_IND	VARCHAR2(1)	No
GOBSEVS_ACTIVITY_DATE	GOBSEVS_ACTIVITY_DATE	DATE	No
GOBSEVS_USER_ID	GOBSEVS_USER_ID	VARCHAR2(30)	No
GOBSEVS_BIRTH_NATN_CODE	GOBSEVS_BIRTH_NATN_CODE	VARCHAR2(5)	Yes		*
GOBSEVS_LEGAL_NATN_CODE	GOBSEVS_LEGAL_NATN_CODE	VARCHAR2(5)	Yes		*
GOBSEVS_PROGRAM_BEGIN_DATE	GOBSEVS_PROGRAM_BEGIN_DATE	DATE	Yes
GOBSEVS_PROGRAM_END_DATE	GOBSEVS_PROGRAM_END_DATE	DATE	Yes
GOBSEVS_PROGRAM_ENROLL_DATE	GOBSEVS_PROGRAM_ENROLL_DATE	DATE	Yes
GOBSEVS_ENG_PROF_REASON	GOBSEVS_ENG_PROF_REASON	VARCHAR2(500)	Yes
GOBSEVS_ACADEMIC_TERM_MONTHS	GOBSEVS_ACADEMIC_TERM_MONTHS	NUMBER(3,0)	Yes
GOBSEVS_TUITION_EXPENSE	GOBSEVS_TUITION_EXPENSE	NUMBER(12,2)	Yes
GOBSEVS_PERSONAL_FUNDS	GOBSEVS_PERSONAL_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_TRANS_CDE	GOBSEVS_TRANS_CDE	VARCHAR2(10)	Yes
GOBSEVS_SEVIS_ID	GOBSEVS_SEVIS_ID	VARCHAR2(11)	Yes
GOBSEVS_VTYP_CODE	GOBSEVS_VTYP_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_SVCR_CODE	GOBSEVS_SVCR_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_SESSION_START_DATE	GOBSEVS_SESSION_START_DATE	DATE	Yes
GOBSEVS_SESSION_END_DATE	GOBSEVS_SESSION_END_DATE	DATE	Yes
GOBSEVS_TRANSFER_COMMENT	GOBSEVS_TRANSFER_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_ISSUE_COMMENT	GOBSEVS_ISSUE_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVEL_CODE	GOBSEVS_SVEL_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_MAJR_CODE	GOBSEVS_MAJR_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_STUDY_LENGTH	GOBSEVS_STUDY_LENGTH	NUMBER(3,0)	Yes
GOBSEVS_LIVING_EXPENSES	GOBSEVS_LIVING_EXPENSES	NUMBER(12,2)	Yes
GOBSEVS_SVFT_CODE	GOBSEVS_SVFT_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_AUTH_START_DATE	GOBSEVS_AUTH_START_DATE	DATE	Yes
GOBSEVS_COMPLETION_REMARKS	GOBSEVS_COMPLETION_REMARKS	VARCHAR2(500)	Yes
GOBSEVS_NEW_PROGRAM_END_DATE	GOBSEVS_NEW_PROGRAM_END_DATE	DATE