ABCDEFGHIJKLMNOPQRSTU
1
Field NameDescriptionValues
2
 CONTACT DETAIL
3
NameFirst Name = MDM Primary Name (grabs primary name that was last updated, whether from HCM or CS) > Advance Preferred/Primary Name > CS Preferred Name > HR Preferred Name-Adv = Advance
4
Middle Name-CS = Campus Solutions
5
Contact Record TypeIndividual - comes from MDM. Standard - manually uploaded, no record in source systemIndividual, Standard
6
CAN-SPAM INFORMATION
7
Is Private?Displays "Privacy" flag if contact is FERPA ProtectedPrivacy Flag, "Not Privacy Enabled"
8
Email Present?YES if any email field is populated (Email, UCB, UCCS, UCD, SYS, Hospital)Yes, No
9
FERPA FlagY, N
10
Meets eComm Contact CriteriaTRUE if Deceased, Do Not Contact, FERPA Flag, Email Opt Out, and Email Pilot Opt Out are all false-
11
Email Opt Out- Comes from Adv for all populations if Adv receives preference. This also opts out anyone who does want any communication from CU (phone, mail and email)
- Marketing Cloud: After receiving an email via Marketing Cloud, this is checked if someone unsubcribes from all		-
12
Do Not ContactComes from Advance. Manually updated once a week-
13
 BIO/DEMO INFORMATION
14
GenderF, Male, Female, Transgender, X, M
15
PronounsShe/Her/Hers, He/Him/His, They/Them/Theirs, Ze/Zir/Zirs, Xe/Xer/Xers, Prefer not to say, Unknown, Other
16
DeceasedComes from Advance-
17
Miliary Affiliation-
18
Birthdate -
19
Age-
20
Deceased Date-
21
 EMAIL INFORMATION
22
EmailPopulated by Adv for all populations. Alumni, donors, parent and friend records are updated in Adv in real time. Employee records are updated in Advance from HRMS monthly. Student records are updated from CS twice per year.-
23
UCB EmailPopulated for faculty, staff and students with their email of record-
24
UCCS EmailPopulated for faculty, staff and students with their email of record-
25
UCD EmailPopulated for faculty, staff and students with their email of record-
26
SYS Email Populated for faculty, staff and students with their email of record-
27
Identikey Email-
28
Hospital EmailTo be used by AMC only-
29
Work Email-
30
 ADDRESS INFORMATION
33
Home AddressComes from Adv for all contacts. Equivalent of Advance's "Home" type address. Alumni, donors, parent and friend records are updated in real time. Employee records are updated from HRMS to Advance 1x/mo. Student records are updated from CS to Advance 2x/yr. -
34
Mailing AddressComes from CS and/or HCM. Populated from Residence Hall address type if one exists, Local if not. Source system with the most recent update "wins".-
35
Business AddressComes from Adv for all contacts. Alumni, donors, parent and friend records are updated in real time. Employee records are updated from HRMS to Advance 1x/mo. Student records are updated from CS to Advance 2x/yr.-
36
Other AddressComes from CS and/or HCM. Populated from Home if exists, Billing if not.-
37
 PHONE INFORMATION
38
Phone-
39
Work Phone-
40
Mobile-
41
Preferred PhoneComes from Advance-
42
Home Phone-
43
Other Phone-
44
OTHER INFORMATION
45
Advance Constituent TypeSee values
46
Active Enrolled CountIndicates if contact has one or more enrollment records where active enrolled = Y0 - contact has no current enrollment records | 1+ - contact has at least one enrollment record
47
 SYSTEM INFORMATION
48
Advance ID-
49
Employee ID-
50
SIDFrom Campus Solutions-
51
Constituent IDEnables integration with MDM-
52
Contact 18 ID-
53
CRM01 Contact ID-
54
IdentiKeyCommon login value provided by CU Identity Management System-
55
UCB UUID-
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102