More information

Pending Tables

The pending tables hold data that is either imported with the Advanced Data Examiner Import Tool, entered by constituents from the On-Line Constituent Directory, or entered by Soft Edit Millennium users. This data can then be reviewed for validity and checked against existing records prior to committing to the Millennium database tables via the Advanced Data Examiner.

If your institution uses the optional Millennium component for conducting Online Constituent Directory, the institution has the option of allowing your constituency to submit data changes for certain of the Millennium data tables. When they do so via your website, the information they submit is automatically stored in a set of pending tables, awaiting approval by your staff before it is integrated into the Millennium data tables. If constituents view their own information via the website in the interim, they will be shown the pending information. If a previously submitted data row, which is still in pending, is edited by the constituent and updated, the most recent data information will be sent to the pending tables, overwriting the existing pending data. This allows the most recent data to be reviewed and relieves the issue of having duplicate pending rows to approve. Not all pending tables are populated from the Online Constituent Directory. Tables that can be updated from the directory are: address_pending, attribute_pending, comments_pending, corebio_pending, internetaddress_pending, jobs_pending, name_pending, phone_pending, relation_pending (non-constituent only) and school_pending.

The following pending tables are exact copies of the layout and structure of the primary data tables with which they are associated.

address_pending		guest_items_pending
attendance_pending		internetaddress_pending
attribute_pending		jobs_pending
comments_pending		media_pending
correspondence_pending		name_pending
custombio_pending		phone_pending
customprospect_pending		rating_pending
demogrph_pending		registration_pending
donor_pending		relation_pending
event_guest_pending		research_source_pending
event_income_pending		school_pending
finance_pending

When you use the Advanced Data Examiner to process data in the pending tables, the pending data is incorporated into the primary data tables and the corresponding row in the pending table is automatically deleted. Pending data rows can be skipped during the Data Examiner review process. The skipped data will be held in the pending tables for future review.

The ECommerce Pending Table

Giving, dues, credit card, and bank draft pending information is stored in the ecommerce_pending table. The name of the table is ecommerce_pending. Information in this table will also populate the Honoree table if non-constituent honor/memory gift information is entered. Payment schedules for pledges can be created if the necessary information is imported into the ecommerce_pending table. Several fields will be for use by the system only.

The following table describes the ecommerce_pending table columns, and includes the pending data destination.

Column Name	Destination Table	Destination Column Name	Description
ecomkey	gift/dues	giftkey/dueskey	Unique key to identify this row
ecomid	gifts/dues	giftid/duesid	ID of constituent owner of this row
ecomdoc	gift/dues	giftdoc/duesdoc	Indicator if there is an attachment to this gift or dues row
ecomdate	gifts /dues	giftdate/duesdate	Date row is entered or last updated
ecomuserid	gifts /dues	giftuserid/duesuserid	User id of user who entered or last updated row
ecomugroup	gifts/dues	giftugroup/duesugroup	MUG of user who entered or last updated row
ecomgtype	gifts/dues	gifttype/duestype	Code of gift or dues type
ecomamount	gifts/dues	giftamount/duesamount	Gift or dues amount
ecomgrest	gifts/dues	giftrest/duesrest	Code of gift or dues purpose
ecomgcamp	gifts/dues	giftcamp/duescamp	Code of gift or dues campaign
ecomgeffdt	gifts/dues	gifteffdat/dueseffdat	Effective date of gift or dues row
ecomplgkey	gifts/dues	giftplgkey/duesplgkey	Key of gift or dues pledge that this gift or dues payment row links to
ecomgcmpyr	gifts/dues	giftcampyr/duescampyr	Campaign year of gift or dues row
ecomtender	gifts/dues	gifttender/duestender	Code of gift or dues tender
ecomallkey	gifts/dues	giftallkey/duesallkey	Key of gift or dues row that is the parent row of this gift or dues allocation row.
ecomallflg	gift/dues	giftallflg/duesallflg	Indicates multiple allocations exist for this gift or dues row
ecomfirst6	gift/dues	credfirst6	Field holds the first six digits of the credit card number.
ecommasked	gift/dues	credmasked	Field holds the first six digits,a masked placeholder, and the last four digits of the credit card number.
ecomspsid	gift/dues	credspsid	Field holds the SPS ID.
ecomtamnt		None	Not used at this time
ecomallrst		None	Not used at this time
ecomallamt		None	Not used at this time
ecomplgdt	Used for linking	none	Date of gift or dues pledge used by the data examiner to find possible pledge payment links
ecomplgamt	Used for linking	none	Amount of gift or dues pledge to be used by the Advanced Data Examiner to find possible pledge payment links
ecomplgrst	Used for linking	none	Code or purpose of gift or dues pledge to be used by the data examiner to find possible pledge payment links
ecomsusamt	sustainerpayments	susdueamt	For sustainer pledges, the payment amount due for each month as indicated by the 'susXX' indicators, below. This must contain a value in order for the Advanced Data Examiner to create sustainer information in Millennium.
ecombill	sustainerpayments	susbilling	Indication to bill for sustainer pledge
ecomsus01	sustainerpayments	susduemnth	Indication of sustainer payment due for January
ecomsus02	sustainerpayments	susduemnth	Indication of sustainer payment due for February
ecomsus03	sustainerpayments	susduemnth	Indication of sustainer payment due for March
ecomsus04	sustainerpayments	susduemnth	Indication of sustainer payment due for April
ecomsus05	sustainerpayments	susduemnth	Indication of sustainer payment due for May
ecomsus06	sustainerpayments	susduemnth	Indication of sustainer payment due for June
ecomsus07	sustainerpayments	susduemnth	Indication of sustainer payment due for July
ecomsus08	sustainerpayments	susduemnth	Indication of sustainer payment due for August
ecomsus09	sustainerpayments	susduemnth	Indication of sustainer payment due for September
ecomsus10	sustainerpayments	susduemnth	Indication of sustainer payment due for October
ecomsus11	sustainerpayments	susduemnth	Indication of sustainer payment due for November
ecomsus12	sustainerpayments	susduemnth	Indication of sustainer payment due for December
ecomvouchr		None	Not used at this time
ecommtchco	gifts/dues	giftmtchid/duesmtchid	Name of the Corporation or Foundation that is matching funds for this gift or dues row. The Advanced Data Examiner will look for the Millennium ID for the Corporation or Foundation name entered here.
ecomjoint	gift/dues	giftjntid/duesjntid	A flag field to indicate that transaction will be joint with spouse. The Advanced Data Examiner will look for the Millennium ID of the spouse.
ecomhtitle	honoree	hontitle	Title of non-constituent for whom this gift or dues row is in honor of.
ecomhlast	honoree	honlast	Last name of non-constituent for whom this gift or dues row is in honor of.
ecomhfirst	honoree	honfirst	First name of non-constituent for whom this gift or dues row is in honor of.
ecomhmiddl	honoree	honmiddle	Middle name of non-constituent for whom this gift or dues row is in honor of.
ecomhsuffx	honoree	honsuffix	Suffix of non-constituent for whom this gift or dues row is in honor of.
ecommtitle	honoree	hontitle	Title of non-constituent for whom this gift or dues row is in memory of.
ecommlast	honoree	hontitle	Last name of non-constituent for whom this gift or dues row is in memory of.
ecommfirst	honoree	honfirst	First name of non-constituent for whom this gift or dues row is in memory of.
ecommmiddl	honoree	honmiddle	Middle name of non-constituent for whom this gift or dues row is in memory of.
ecommsuffx	honoree	honsuffix	Suffix of non-constituent for whom this gift or dues row is in memory of.
ecomgcomm	gifts/dues	giftcomm/duescomm	Comment for this gift or dues row
ecomccnm	creditcard	credccnm	If the tender of the transaction is 'bank', the constituent's name as it appears on the bank account. If the tender of the transaction is 'cc', the constituent's name as it appears on the credit card.
ecomcctype	creditcard	credcctype	The type of credit card (for example, disc, mc, amex)
ecomccnum	creditcard	credccnum	Bank account number if tender is 'bank'.
ecomverif	creditcard	credverif	Field is not used at this time.
ecomexpyr	creditcard	credexpyr	Credit card expiration year
ecomexpmn	creditcard	credexpmn	Credit card expiration month
ecomapprov	creditcard	credapprov	Credit card approval
ecomcccomm	creditcard	credcomm	Credit card comment
ecomsource	creditcard	credsource	Credit card source
ecomcrdate	gifts/dues	giftcrdate/duescrdate	Date this gift or dues row was originally created
ecomlnkfil	used by Data Examiner for linking		'05' if a gift row imported into pending, '08' if a dues row imported into pending, '60' if an event_income row, with tender of 'cc' or 'bank' is imported into pending.
ecomdiscod	Dues	duesdiscod	Code of type of discount for this dues row
ecomdiscnt	Dues	duesdiscnt	Amount of discount for this dues row
ecomsol	giftsol/duessolic	Code of solicitation for this gift or dues row
ecomsolnam	giftsolnam/duessolnam	Name of solicitation for this gift or dues row
ecomacctnm	gifts/dues	giftacctnm/duesacctnm	Copy of the name of the account from the Chart of Accounts for this gift or dues row
ecomchckno	creditcard	credchckno	Number of the check for associated with this draft
ecomlnkkey	used by Data Examiner for linking		Key of event_income_pending row if event_income_pending row has a tender of 'cc' or 'bank'.
ecomroute	creditcard	credroute	If tender = 'bank', ABA routing number for this draft
ecombnktyp	creditcard	credbnktyp	If tender = 'bank', Account Type (Commercial Checking, Commercial Savings, Personal Checking, Personal Savings)
ecombanknm	creditcard	credbanknm	If tender = 'bank', then name of the banking institution
ecomaddrl1	creditcard	credaddrl1	Billing address line 1 for this draft.
ecomaddrl2	creditcard	credaddrl2	Billing address line 2 for this draft
ecomcity	creditcard	credcity	Billing address city for this draft
ecomstate	creditcard	creddstate	Billing address state for this draft
ecomcntry	creditcard	credcntry	Billing address country for this draft
ecomzip	creditcard	credzip	Billing address ZIP code for this draft
ecombaddr1	creditcard	credaddrl1	Billing address line 1 for this credit card
ecombaddr2	creditcard	credaddrl2	Billing address line 2 for this credit card
ecombcity	creditcard	credcity	Billing address city for this credit card
ecombstate	creditcard	credstate	Billing address state for this credit card
ecombcntry	creditcard	credcntry	Billing address country for this credit card
ecombzip	creditcard	credzip	Billing address ZIP code for this credit card
ecomemail	creditcard	credemail	email associated with this draft/credit card
ecomstatus	creditcard	credstatus	Process status - Processed (P) or Not Processed (N) - use with Paya Payment Solutions
ecomccsave	creditcard	credsave	Indicator of whether to save this card or account payment information for future use (use with Paya Payment Solutions)
ecomacctty	creditcard	credacctty	Type of account for this draft - SAV (savings) or DDA (demand deposit account - checking) or blank
ecomcustty	creditcard	credcustty	If tender is 'bank', the type of debit from the customer's account (ARC, CCD, PPD, RCK, TEL, WEB)
ecomssnum	creditcard	credssnum	Social Security Number of constituent associated with this draft/credit card
ecomdstate	creditcard	creddstate	State of drivers license of constituent associated with this draft/credit card
ecomdlnum	creditcard	creddlnum	Number of drivers license of constituent associated with this draft/credit card
ecombdate	creditcard	credbdate	Birthday of constituent associated with this draft/credit card
ecomhphone	creditcard	credhphone	Home phone number of constituent associated with this draft/credit card
ecomein	creditcard	credein	Fed Tax ID associated with this draft/credit card
ecomccamt	creditcard	credamount	Amount billed to credit card (if tender = 'cc') or withdrawn from bank account (if tender = 'bank')
ecomplgtyp	gifts/dues	giftplgtyp/duesplgtyp	Type of gift or dues pledge (used to generate payment schedule)
ecompaycnt	gifts/dues	giftpaycnt/duespaycnt	Number of payments for gift or dues pledge (used to generate payment schedule)
ecompstrty	gifts/dues	giftpstrty/duespstrty	Start year of payments for gift or dues pledge (used to generate payment schedule). This is a four-digit year between 1600 and 2200.
ecompstrtm	gifts/dues	giftpstrtm/duespstrtm	Start month of payments for gift or dues pledge (used to generate payment schedule)
ecompstrtd	gifts/dues	giftpstrtd/duespstrtd	Start day of payments for gift or dues pledge (used to generate payment schedule)
ecomlast4	creditcard	credlast4	Last four digits of the credit card or bank account number associated with this row
ecomclass1	gifts/dues	giftclass1/duesclass1	Column to further classify a gift/dues transaction for any site specific purpose
ecomclass2	gifts/dues	giftclass2/duesclass2	Column to further classify a gift/dues transaction for any site specific purpose
ecomlook1	gifts/dues	giftlook1/dueslook1	Custom lookup field
ecomlook2	gifts/dues	giftlook2/dueslook2	Custom lookup field
ecomlook3	gifts/dues	giftlook3/dueslook3	Custom lookup field
ecomdepost	gifts/dues	giftdepost/duesdepost	The bank deposit number in which this transaction was included
ecomyesno	gifts/dues	giftyesno/duesyesno	Custom flag field
ecomnlast			For system use only
ecomnfirst			For system use only
ecomnmiddl			For system use only
ecomguid	creditcard	credguid	For system use only
ecomref	creditcard	credref	For system use only
ecommerid	merchant_account	merid	For system use only
ecommerkey	merchant_account	merkey	For system use only
ecomisrcpt	gifts/dues	giftisrcpt/duesisrcpt	Issue Serialized Receipt. Set to E (External) if an external receipt was issued for the transaction.

Top of Page