Table Numbers

The Millennium Data Tables Index topic provides a list of Millennium data tables, a short description of each data table, and a link to more information about the data table.

The following tables list the Millennium data and pending table names and numbers. The first table orders this information by table number. The second table orders this information by table name.

Data and Pending Tables ordered by Table Number

Table Number	Table Name
00	corebio
01	name
02	address
03	attribute
04	relation
05	gifts
06	jobs
07	school
08	dues
09	comments
10	donor
11	actions
12	tasks
13	media
14	screener
15	rating
16	plannedgifts
17	death
18	memories
19	finance
20	demogrph
21	event
22	correspondence
23	coverage
24	receipts
25	national
26	phone
27	research_source
28	membership
29	quidpro
30	pgrating
31	securities
32	giftinkind
33	solicitor
34	honoree
37	creditcard
38	payments
39	subscription
40	benefits
41	attachments
42	proposal
43	serialreceipt
44	serialreceipt_payment
51	expenses
52	activity
53	attendance
54	event_guest
55	items
56	registration
57	guest_items
58	organizer
59	event_solicitor
60	event_income
61	registration_level
62	other_info
63	benefitlevel
64	subscriptionlevel
65	membershipcards
66	event_actions
67	speaker
68	seating_layout
69	custombio
70	customprospect
71	sustainerpayments
79	contactinfo
81	internetaddress
82	circles
119	account_services_log
6900	corebio_pending
6901	name_pending
6902	address_pending
6903	attribute_pending
6904	relation_pending
6905	ecommerce_pending
6906	jobs_pending
6907	school_pending
6909	comments_pending
6910	donor_pending
6913	media_pending
6915	rating_pending
6919	finance_pending
6920	demogrph_pending
6922	correspondence_pending
6926	phone_pending
6927	research_source_pending
6953	attendance_pending
6954	event_guest_pending
6956	registration_pending
6957	guest_items_pending
6960	event_income_pending
6969	custombio_pending
6970	customprospect_pending
6981	internetaddress_pending

 

Data and Pending Tables ordered by Table Name

Table Name	Table Number
account_services_log	119
actions	11
activity	52
address	02
address_pending	6902
attachments	41
attendance	53
attendance_pending	6953
attribute	03
attribute_pending	6903
benefitlevel	63
benefits	40
circles	82
comments	09
comments_pending	6909
contactinfo	79
corebio	00
corebio_pending	6900
correspondence	22
correspondence_pending	6922
coverage	23
creditcard	37
custombio	69
custombio_pending	6969
customprospect	70
customprospect_pending	6970
death	17
demogrph	20
demogrph_pending	6920
donor	10
donor_pending	6910
dues	08
ecommerce_pending	6905
event	21
event_actions	66
event_guest	54
event_guest_pending	6954
event_income	60
event_income_pending	6960
event_solicitor	59
expenses	51
finance	19
finance_pending	6919
giftinkind	32
gifts	05
guest_items	57
guest_items_pending	6957
honoree	34
internetaddress	81
internetaddress_pending	6981
items	55
jobs	06
jobs_pending	6906
media	13
media_pending	6913
membership	28
membershipcards	65
memories	18
name	01
name_pending	6901
national	25
organizer	58
other_info	62
payments	38
pgrating	30
phone	26
phone_pending	6926
plannedgifts	16
proposal	42
quidpro	29
rating	15
rating_pending	6915
receipts	24
registration	56
registration_pending	6956
registration_level	61
relation	04
relation_pending	6904
research_source	27
research_source_pending	6927
school	07
school_pending	6907
screener	14
seating_layout	68
securities	31
serialreceipt	43
serialreceipt_payment	44
solicitor	33
speaker	67
subscription	39
subscriptionlevel	64
sustainerpayments	71
tasks	12