TrackMaster Data Dictionary

TrackMaster SharePoint-Lists data-dictionary

Summary

This article describes the fields available in TrackMaster, what they are, and where the data comes from.

Lists and Libraries

Display Name	Type	Description
Appointing Departments and Schools	Custom List	A list of standardized, top-level departments, colleges, and schools, used for reporting and filtering purposes. The values in this list are used throughout TrackMaster, in particular the People list, as drop-down menu options.
Automation Requests	Custom List	Backend for bulk uploads and automated tasks. This list is used to trigger, track, and notify users of different automations. For system use only. Important: Do not add items to this list directly. Doing so may break things and corrupt data. Only use via the Bulk Uploads and Automations section.
Automations List	Custom List	List of automations in Power Automate and TDX iPaaS. This list is updated automatically every night. Administrators can run flow manually as needed, and can use this list as a reference to see dependencies so they can now which SharePoint lists or which other flows would be affected by a change to a flow.
Event Summary	Custom List	Tracks events hosted by the center. Includes public details such as a summary, description, and event recording link, as well as private information for reporting purposes such as number of registrants and attendees.
EFDC Calendar (Shared Calendar)	Built-In List	Center and Team events and activities.
Groups List	Custom List	Configuration for groups of people, MCommunity sync settings, and definitions of "communities" (larger collection of people, typically those served by a specific team or core). Groups with the "Sync" box checked, and marked as "Active", have their members automatically synced from MCommunity. Note that a center membership group is required for TrackMaster to function properly. Its name and internal ID must be entered into Power Automate environment variables.
People	Custom List	The People list is at the heart of TrackMaster. It contains contact information for members, prospective members, and others. Internal (U-M) contacts are automatically updated using MCommunity and Office 365.
Programs and Offerings	Custom List	A list of top-level programs and primary offerings at this center. All services, events, and many other activities are reported under a specific program from this list. This is a primary field for reporting.
Publicity	Custom List	Tracks any promotions and publicity done on behalf of members, such as news articles about a study, or social media posts regarding key findings on a publication.
Referrals	Custom List	Tracks internal referrals (between teams) when a member or customer could be better served by a different team.
Service Types	Custom List	Specific services offered by the center, its cores, and its teams, to members and customers. Each service type is linked to a specific program and team. This list is used as drop-down menu options in the Service (Engagement) History list.
Services and Activities	Custom List	Tracks services provided, consultations, and other miscellaneous activities. This facilitates reporting on the reach and impact of the center.
Shared Digital Assets Tracker	Custom List	Helps keep track of digital assets used by the center, such as U-M MCommunity groups, Google / Dropbox shared drives, etc.
Teams	Custom List	Internal teams (at this center), their team members, and their faculty leads. This list is used as drop-down menu options in Programs, Services, Events, and other lists throughout TrackMaster, and is a primary field for reporting.
EFDC-TrackMaster Terms (Taxonomy)	Term Sset	Standardized taxonomy used by this center to categorize publications, events, research specialties, etc. The values in this list are used throughout TrackMaster and in reports.
Automation Files	Document Library	Backend document library used by Power Automate and iPaaS. It includes temporary files used for syncing MCommunity group membership, and copies of all files submitted by end users via automation requests.
Shared Documents	Document Library	Shared drive for department-wide file storage. This library can be synced to Windows Explorer and Mac Finder to edit files locally.
Site Pages	Page Library	Contains custom web pages and announcements.
Site Assets	Document Library	Contains logos, images, and other files used by web pages, as well as attachments from individual list items.

Fields

List	Field Name	Description	Required?	Data Type	Choices	Data Source(s) / Lookup Field
Appointing Departments and Schools	Attachments	Relevant attachments (any file type).	No	Attachments
Appointing Departments and Schools	Campus	The university campus for this school or college.	No	Single line of text
Appointing Departments and Schools	Created	The date when this record was created.	No	Date and Time
Appointing Departments and Schools	Created By	The person or account who created this record (author).	No	Person or Group
Appointing Departments and Schools	Department	The standardized name of this appointing department. Typically, this is a top-level department (one level below a school or college), without prefixes or abbreviations. This value is not always the official department name in the system, but rather a shorter, manually-entered name used for reporting purposes.	Yes	Single line of text
Appointing Departments and Schools	Department Display Name	Auto-calculated, concatenated column to show in other lists. Do not update manually.	No	Single line of text
Appointing Departments and Schools	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Appointing Departments and Schools	Modified	The date when this record was last updated.	No	Date and Time
Appointing Departments and Schools	Modified By	The last person or account who updated this record.	No	Person or Group
Appointing Departments and Schools	School	The University of Michigan school, college, or appointing institute to which this department belongs. Currently, only two specific institutes have the same full faculty appointing power as colleges and institutes.	No	Single line of text
Automation Requests	Attachments	Relevant attachments (any file type).	No	Attachments
Automation Requests	Automation Type	Select the type of automation you would like to run.	No	Choice	Add People in bulk by copying and pasting UniqNames Add or update People in bulk using a spreadsheet Assign a Primary Investigator to multiple people Update multiple People using MCommunity and Office 365 Add event registrants to existing event Add event attendees to existing event Add event speakers to existing event Add event summaries in bulk using a spreadsheet Sync Group members for a specific group Sync Programs to Events Calendar
Automation Requests	ConfirmEventAttendanceUpload	Checkbox used to identify that a specific automation is being selected, without actually selecting it from the drop-down. This is needed for automations that are linked to from within the navigation menu.	Yes	Yes/No
Automation Requests	ConfirmEventRegistrationUpload	Checkbox used to identify that a specific automation is being selected, without actually selecting it from the drop-down. This is needed for automations that are linked to from within the navigation menu.	Yes	Yes/No
Automation Requests	ConfirmPeopleUpload	Checkbox used to identify that a specific automation is being selected, without actually selecting it from the drop-down. This is needed for automations that are linked to from within the navigation menu.	Yes	Yes/No
Automation Requests	ConfirmPIAssignment	Checkbox used to identify that a specific automation is being selected, without actually selecting it from the drop-down. This is needed for automations that are linked to from within the navigation menu.	Yes	Yes/No
Automation Requests	Created	The date when this record was created.	No	Date and Time
Automation Requests	Created By	The person or account who created this record (author).	No	Person or Group
Automation Requests	Default Contact Type	If a contact is not already in the People list, it will be created automatically using this contact type as needed.	No	Choice	Member Prospective Member Alumni Community Partner EFDC Leadership EFDC Staff Peer-to-Peer Partner U-M Communication Contact U-M External Partner U-M Partner U-M Staff Undergraduate Student Vendor Other
Automation Requests	Event	The Event Summary to use in this automation, if applicable.	No	Lookup		TrackMaster - Event Summary - Department
Automation Requests	Flow Environment	The hosting environment or server instance used for running this automation.	No	Lookup		TrackMaster - Automations List - Flow Environment
Automation Requests	Flow ID	The internal ID of this automation.	No	Lookup		TrackMaster - Automations List - Flow ID
Automation Requests	Flow Instance Link	Link to the log of this flow in the automation system (e.g. PowerAutomate or iPaaS).	No	Hyperlink or Picture		Power Automate
Automation Requests	Flow Name	The name of the flow used.	No	Lookup		TrackMaster - Automations List - Department
Automation Requests	Group	Select a group.	No	Lookup		TrackMaster - Groups List - Department
Automation Requests	Group:MCommunity Group	The MCommunity group e-mail address associated with the Group that was selected for this automation.	No	Lookup		TrackMaster - Groups List - MCommunity Group
Automation Requests	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Automation Requests	List of Users	Enter a list of UniqNames or e-mail addresses separated by commas, or one per line.	No	Multiple lines of text
Automation Requests	Modified	The date when this record was last updated.	No	Date and Time
Automation Requests	Modified By	The last person or account who updated this record.	No	Person or Group
Automation Requests	Override Participants	For events and services only: when checked, existing participants are overridden (recipients, attendees, registrants, etc., depending on the automation selected).	No	Yes/No
Automation Requests	PI	The Primary Investigator to use in this automation, if applicable.	No	Lookup		TrackMaster - People - Department
Automation Requests	Status	The current status of this automation request. Do not edit manually.	Yes	Choice	Submitted Running Finished Canceled
Automation Requests	Submission	The title of this submission. This value is auto-generated after submitting the automation request form.	Yes	Single line of text
Automation Requests	Submission Form	The custom form that was submitted. This field is based on Confirmation checkboxes, and is used to determine what flow to run.	No	Calculated
Automation Requests	Template	Paste your document or email here to use as a template. Available fields: [FIRSTNAME], [LASTNAME], [FULLNAME], [PI], [CENTERNAME].	No	Multiple lines of text
Automations List	Active	Indicates whether this flow is active (turned on).	No	Yes/No
Automations List	Attachments	Relevant attachments (any file type).	No	Attachments
Automations List	Automation System	The system used to create this flow.	Yes	Choice	PowerAutomate TDX iPaaS PHP Other
Automations List	Code	Code for this flow, if available. This is typically formatted as JSON.	No	Multiple lines of text		Power Automate
Automations List	Created	The date when this record was created.	No	Date and Time
Automations List	Created By	The person or account who created this record (author).	No	Person or Group
Automations List	Flow Description	A short description of what this automation does.	No	Multiple lines of text		Power Automate
Automations List	Flow Environment	The ID of the environment to be used in URLs.	No	Single line of text		Power Automate
Automations List	Flow ID	The ID of the flow.	Yes	Single line of text		Power Automate
Automations List	Flow Type	The type of flow, usually the same as the type of trigger.	Yes	Choice	Event-based Manual Scheduled Subroutine Webhook Other	Power Automate
Automations List	Flow URL	The URL that can be used for launching this flow.	No	Hyperlink or Picture
Automations List	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Automations List	Modified	The date when this record was last updated.	No	Date and Time
Automations List	Modified By	The last person or account who updated this record.	No	Person or Group
Automations List	Notes	Additional notes, comments, links, or important remarks.	No	Multiple lines of text
Automations List	SharePoint Lists Used	List of SharePoint Lists that this flow uses.	No	Single line of text		Power Automate
Automations List	Sub Flows Used	Child flows used by this flow.	No	Multiple lines of text		Power Automate
Automations List	Title	The name or title of this automation.	No	Single line of text
Event Summary	# Attendees	The approximate number of attendees, including walk-ins, guests, and those joining by phone.	No	Number
Event Summary	# Registrants	The approximate number of pre-registered participants, excluding walk-ins.	No	Number
Event Summary	Attachments	Relevant attachments (any file type).	No	Attachments
Event Summary	Attendees	List of even attendees, if available.	No	Lookup		TrackMaster - People - Department
Event Summary	Calculate Totals Automatically?	If checked, the # of registrants and # of attendees will be auto-calculated using their corresponding columns. If unchecked, you can specify a value manually and it will not get overridden.	No	Yes/No
Event Summary	Center Expenses	The total internal cost (expenses that come from the center's budget). This excludes any portions paid by others.	No	Currency
Event Summary	Created	The date when this record was created.	No	Date and Time
Event Summary	Created By	The person or account who created this record (author).	No	Person or Group
Event Summary	Event Date	The date when the event occurred.	Yes	Date and Time
Event Summary	Event Description	The public description or summary for this event.	No	Multiple lines of text
Event Summary	Event Location	The physical location of the event, if applicable.	No	Multiple lines of text
Event Summary	Event Recording	Link to video recording (or playlist), if available. For individual videos, use the video's "Share" button to get the link. For playlists, right-click "Play All" and copy the link.	No	Hyperlink or Picture
Event Summary	Event Title	(Required) The title of the event. This value must be unique. For repeating events, use the title of the event series followed by the date to make this value unique.	Yes	Single line of text
Event Summary	Event Webpage	The URL to the webpage or announcement for the event.	No	Hyperlink or Picture
Event Summary	Event Year-Month	The event date formatted as "yyyy-mm mmmm" (e.g. 2025-01 January, 2026-12 December). This field can be used to facilitate sorting.	No	Calculated
Event Summary	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Event Summary	Modified	The date when this record was last updated.	No	Date and Time
Event Summary	Modified By	The last person or account who updated this record.	No	Person or Group
Event Summary	Notes	Additional notes, comments, links, or important remarks.	No	Multiple lines of text
Event Summary	Populations	The population focus for this event, from the center's pre-defined taxonomy.	No	Managed Metadata	Adolescents - Teens American Indian - Native American - Alaska Native Asian - Asian American Athletes Black - African American Children - Infants College Students Hispanic - Latinx Immigrants - Refugees - Undocumented Migrants Low Income - Socioeconomically Disadvantaged Low Literacy - Numeracy Maternal - Perinatal - Postpartum Men Menopausal - Postmenopausal Middle Eastern Middle Eastern - North African - Arab American Military Service Members and Veterans Non-Human Animal Studies Older Adults Pacific Islander Persons with Disabilities Rural Populations Schools - Students - K-12 Sexual and Gender Minorities - LGBTQIA+ Underserved Urban Populations Veterans Women Workforce / Behavioral Health Professionals Workforce / Employees Workforce / Healthcare Professionals Workforce / Interns Workforce / Migrant Farm Workers Workforce / Shift Workers
Event Summary	Program	The program to which this event belongs, for reporting purposes.	No	Lookup		TrackMaster - Programs and Offerings - Department
Event Summary	Registrants	List of people who pre-registered for the event, excluding walk-ins.	No	Lookup		TrackMaster - People - Department
Event Summary	Research Areas	The research area focus for this event, from the center's pre-defined taxonomy.	No	Managed Metadata	Aging and Life Course Alzheimer's Disease - Dementia - Neurocognitive Disorders Anxiety Disorders Artificial Intelligence - Machine Learning Attention Deficit Hyperactivity Disorder - Attention Deficit Disorder Behavioral Health Integration - Collaborative Care Bioinformatics Biomarkers Bipolar Disorders Circadian Biology Computational Psychiatry Digital Health Eating Disorders Emotion Epidemiology Genomics Grief and Bereavement Health Informatics Learning Disabilities - Developmental Delays Mental Health Disparities and Equity Mental Health Implementation Science Mental Health Program Evaluation Natural Language Processing Obsessive Compulsive Disorders Other Pain Personality and Personality Disorders Postpartum Depression Precision Health Quality Improvement Resilience - Psychological Well-Being Schizophrenia - Psychosis - Psychotic Disorders School Mental Health Sleep - Sleep Disorders Social Determinants of Health Substance Abuse - Substance Misuse - Addiction Suicide and Suicide Prevention Telehealth Trauma and Stress-Related Disorders Treatment-Resistant Depression Workplace Mental Health - Burnout Medical Comorbodities / Cancer - Psycho-Oncology Medical Comorbodities / Cardiovascular Conditions Medical Comorbodities / Diabetes Medical Comorbodities / Stroke Mental Health Policy / Access to Care Mental Health Policy / Delivery and Utilization of Care Mental Health Policy / Equity and Disparities in Health and Healthcare Mental Health Policy / Health Insurance and Payment - Financing Mental Health Policy / Integrative Care and Treatment Mental Health Policy / Prevention Mental Health Policy / Promotion Mental Health Policy / Quality Mental Health Treatments - Interventions / Adaptive Interventions Mental Health Treatments - Interventions / Brain Stimulation Therapies - Neuromodulation Mental Health Treatments - Interventions / Chronic Disease Management Mental Health Treatments - Interventions / Cognitive Behavioral Therapy Mental Health Treatments - Interventions / Community-Based Interventions Mental Health Treatments - Interventions / Exposure-Based Behavioral Therapies Mental Health Treatments - Interventions / Mindfulness Mental Health Treatments - Interventions / Peer-Based Interventions Mental Health Treatments - Interventions / Pharmacology Mental Health Treatments - Interventions / Psychosocial Intervention Mental Health Treatments - Interventions / Public Health Campaigns Mental Health Treatments - Interventions / Self-Management - Self-Help Mental Health Treatments - Interventions / Training Mental Health Treatments - Interventions / Treatment Development Mental Health Treatments - Interventions / Treatment Response Neurobiology - Neuroscience / Behavioral and Systems Neurobiology - Neuroscience / Clinical Neurobiology - Neuroscience / Cognitive Neurobiology - Neuroscience / Computational Neurobiology - Neuroscience / Developmental Neurobiology - Neuroscience / Molecular and Cellular Neurobiology - Neuroscience / Sensory Prevention - Early Detection / Screening and Assessments
Event Summary	Research Methodologies and Applications	The research methodology and applications focus for this event, from the center's pre-defined taxonomy.	No	Managed Metadata	Causal Inference Community-Based Participatory Research (CBPR) Computational Biology Ecological Momentary Assessment Ethnography Just-in-time Adaptive Interventions (JITAI) Magnetic Resonance Imaging (MRI) / Other Imaging Mixed Methods Research Mobile Technologies and Other Digital Health Other Research Methodologies Program Evaluation Artificial Intelligence and Machine Learning / Natural Language Processing Artificial Intelligence and Machine Learning / Neural Networks Qualitative Research Methods / Day Reconstruction Qualitative Research Methods / Diary Studies Qualitative Research Methods / Dyad Interviewing Qualitative Research Methods / Focus Groups Qualitative Research Methods / Individual Interviewing Qualitative Research Methods / Micro-Randomized Trials (MRT) Qualitative Research Methods / Observational Studies Qualitative Research Methods / Quantitative Research Methods Qualitative Research Methods / Randomized Control Trials (RCT) Qualitative Research Methods / Randomized Trial Designs Qualitative Research Methods / Secondary Data Qualitative Research Methods / Sequential Multiple Assignment Randomized Trials (SMART) Qualitative Research Methods / Survey Measurement Qualitative Research Methods / Survey Tool Design
Event Summary	Shared Folder	Link to the shared folder or shared drive where event files are stored (e.g. agenda, program, slides, etc.)	No	Hyperlink or Picture
Event Summary	Speakers or Presenters	List of presenters / speakers.	No	Lookup		TrackMaster - People - Department
Event Summary	Total Cost	The total cost incurred to host this event, including the center's and other's portions.	No	Currency
Event Summary	Vendors	List of vendors used in this event. Must exist in the People list first.	No	Lookup		TrackMaster - People - Department
Groups List	Active	Indicates whether this record is active (enabled). Inactive records are hidden by default, and are not used in any automations.	No	Yes/No
Groups List	Attachments	Relevant attachments (any file type).	No	Attachments
Groups List	Auto-Add Program Participants and Recipients	If set, recipients of this program, including services and events, will be automatically added to this group.	No	Lookup		TrackMaster - Programs and Offerings - Department
Groups List	Auto-Add Service Recipients by Team	If set, it will automatically add people who have received services from the teams specified.	No	Lookup		TrackMaster - Teams - Department
Groups List	Calendar	A link to this group's events calendar.	No	Hyperlink or Picture
Groups List	Created	The date when this record was created.	No	Date and Time
Groups List	Created By	The person or account who created this record (author).	No	Person or Group
Groups List	Description	A short description of this group and its purpose.	No	Multiple lines of text
Groups List	GitHub	A link to this group's GitHub or GitLab repo. You can enter the full URL (e.g. https://github.com/DepressionCenter) or just the @ name (e.g. @DepressionCenter).	No	Hyperlink or Picture
Groups List	Group Drive	The shared drive used by this group, if applicable.	No	Hyperlink or Picture
Groups List	Group Leader	Primary team member who leads or facilitates this group.	No	Lookup		TrackMaster - People - Department
Groups List	Group Leader Email	The email address of the primary contact for this group. This value is used for notifications about certain group sync events and/or errors.	No	Lookup		TrackMaster - People - Email
Groups List	Group Members	Link to view all members of this group in the People list.	No	Calculated
Groups List	Group Name	The name or title of this group. This value is used in drop-downs in other lists. It does not necessarily have to be the same as the group name in MCommunity, MS Teams or Office 365.	Yes	Single line of text
Groups List	Group WebPage	The web page for this group, if applicable.	No	Hyperlink or Picture
Groups List	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Groups List	MCommunity Group	The MCommunity group email address, if applicable (e.g. mycenter.members@umich.edu). This email address is used to keep MCommunity group members in sync with the People list, as long as the Sync flag is checked.	No	Single line of text
Groups List	Meeting Schedule	On what days does this group regularly meet?	No	Single line of text
Groups List	Modified	The date when this record was last updated.	No	Date and Time
Groups List	Modified By	The last person or account who updated this record.	No	Person or Group
Groups List	Notes	Additional notes, comments, links, or important remarks.	No	Multiple lines of text
Groups List	Program	For affiliate groups, the primary program that runs them.	No	Lookup		TrackMaster - Programs and Offerings - Department
Groups List	Slack	A link to this gorup's Slack workspace.	No	Hyperlink or Picture
Groups List	Sync	If checked, this item will be kept in sync with MCommunity and/or MS Teams automatically.	Yes	Yes/No
Groups List	Teams Account	The MS Teams account for this group, if applicable. Only accounts on the same environment as TrackMaster can be used (e.g. Michigan Medicine).	No	Person or Group
People	Active	Indicates whether this record is active (enabled). Inactive records are hidden by default, and are not used in any automations.	No	Yes/No		MCommunity - Affiliations; Active Directory - Enabled; Office 365 - MS Teams - Enabled; Office 365 - SharePoint - Enabled
People	Appointing Department	Appointing or primary department, used for center-wide reporting.	No	Lookup		TrackMaster - Appointing Departments and Schools - Department
People	Appointing Department (Full)	Appointing or primary department, used for center-wide reporting.	No	Lookup		TrackMaster - Appointing Departments and Schools - Department Display Name
People	Attachments	Relevant attachments (any file type).	No	Attachments
People	Bluesky	Bluesky profile handle or URL.	No	Single line of text		MCommunity - Web Links
People	Business Phone	Business or main office phone number.	No	Single line of text		MCommunity - Phones (1st)
People	Center Member	Is this person a member of this Center or Institute?	No	Calculated		MCommunity - Groups - Member Of
People	Center Membership Join Date	The date when this person became a member. This field is set manually or when a person is added to the membership group.	No	Date and Time
People	City	City, district or municipality.	No	Single line of text
People	Company	Company or organization. For P2P, this is typically the school district.	No	Choice	Michigan Medicine University of Michigan Akron-Fairgrove Schools Anchor Bay School District Ann Arbor Public Schools Barb Smith Suicide Resource & Response Network Bedford Public Schools Byram Hills Central School District Caro Community Schools Cass City Public Schools Chariho Regional School District Chelsea School District Chicago Public Schools Chris Collins Foundation Cranbrook Schools Dearborn Public Schools Dexter Community Schools Eastern Michigan University Grosse Pointe Public School System Lincoln Consolidated Schools Mercy High School Michigan Islamic Academy Milan Area Schools Narragansett School System Okemos Public Schools Ossining Communities That Care Plymouth-Canton Community Schools Rahma Worldwide Reese Public Schools Rye Youth Council Saline Area Schools Shaker Heights City School District South Kingstown Public Schools The Kinkaid School Traverse City Area Public Schools Tuscola Intermediate School District Unionville-Sebewaing Area School District University of Detroit Jesuit High School and Academy University of Michigan Washtenaw Community College Washtenaw Educational Options Consortium Wayne-Westland Community Schools Ypsilanti Community Schools Other
People	Contact Type	Type of contact (e.g. member, prospective member, staff, student).	Yes	Choice	Member Prospective Member Alumni Community Partner EFDC Leadership EFDC Staff Peer-to-Peer Partner U-M Communication Contact U-M External Partner U-M Partner U-M Staff Undergraduate Student Vendor Other	MCommunity - Job Title; Mcommunity - Groups - Member Of; MCommunity - Departments (1st); MCommunity - Affiliations
People	Country/Region	Country or region.	No	Choice
People	Created	The date when this record was created.	No	Date and Time
People	Created By	The person or account who created this record (author).	No	Person or Group
People	Credentials	Professional credentials (e.g. M.D., Ph.D.), separated by commas.	No	Single line of text
People	Department (MCommunity)	Primary department. For internal contacts, this value is updated automatically from MCommunity.	No	Choice		MCommunity - Departments (1st)
People	Depression Center Profile	For members only, this is the URL to their profile page on the center's website.	No	Hyperlink or Picture
People	Earned Media?	Indicates whether this person has ever earned media coverage for their professional work.	No	Yes/No
People	Email	Email address, which defaults to the user's U-M level 1 email (@umich.edu) unless overridden by the Preferred Email field.	No	Calculated		MCommunity - UniqName; Office 365 - MS Teams - Email
People	External Profile	External profile page. For members, use the profile page from the appointing department.	No	Hyperlink or Picture		MCommunity - Web Links
People	External Speaker?	Indicates whether this person can be or has been considered for a speaking engagement or presentation outside of University of Michigan. For external contacts, it indicates whether they can be or have been speakers at U-M events.	No	Yes/No
People	Facebook	Facebook profile.	No	Single line of text		MCommunity - Web Links
People	Fax Number	Office fax number.	No	Single line of text
People	First Name	First name(s) (surname). If not entered manually, the system will extract this value from the Full Name field or from MCommunity.	No	Single line of text		MCommunity - Name; Office 365 - MS Teams - Surname; Office 365 - SharePoint - Surname
People	Full Name	Full name, required only for non-UM contacts. For UM contacts, leave blank to auto-populate.	No	Single line of text		MCommunity - Name; Office 365 - MS Teams - Given Name; Office 365 - SharePoint - Given Name
People	GitHub	A link to this person's GitHub or GitLab profile. You can enter the full URL (e.g. https://github.com/gabrielmongefranco) or just the @ name (e.g. @GabrielMongefranco).	No	Single line of text		MCommunity - Web Links
People	Group Membership	List of groups in which this user is a member. Groups can be configured in the Groups List.	No	Lookup		TrackMaster - Groups List - Department
People	Has Attended Events	Indicates whether this person has ever attended events hosted by this center. This value can be set manually, or if empty, it is set when an Event Summary is added that includes this person as a registrant, attendee or speaker.	No	Yes/No
People	Has Received Services	Indicates whether this person has ever received services from this center. This value can be set manually, or if empty, it is set when Service History is added for this person as the recipient.	No	Yes/No
People	Home Phone	Home phone number.	No	Single line of text
People	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
People	Internal speaker?	Indicates whether this person can be or has been considered for a speaking engagement or presentation at a University of Michigan event.	No	Yes/No
People	Job Rank	For members and prospective members, the condensed job title to use for reporting purposes.	No	Choice	Learner Research Fellow Assistant Professor Assistant Research Investigator Assistant Research Scientist Clinical Assistant Professor Collegiate Assistant Professor Research Assistant Professor Associate Professor Associate Research Investigator Associate Research Scientist Clinical Associate Professor Collegiate Associate Professor Research Associate Professor Clinical Professor Collegiate Professor Research Investigator Research Professor Research Scientist Emerita Emeritus Professor	MCommunity - Job Title; Office 365 - MS Teams - Job Title; Office 365 - SharePoint - Job Title
People	Job Title	The person's current job title. For internal contacts, this is set automatically from MCommunity whenever possible.	No	Single line of text		MCommunity - Job Title; Office 365 - MS Teams - Job Title; Office 365 - SharePoint - Job Title
People	Last Event Attendance Date	The date when this person last attended an event hosted by this center. It can be set manually, or if left blank, it is auto-calculated based on Event Summary entries that include this person as a registrant, attendee or speaker.	No	Date and Time		TrackMaster - Event Summary - Event Date
People	Last Name	Last name(s) (family or given name). If not entered manually, the system will extract this value from the Full Name field or from MCommunity.	No	Single line of text		MCommunity - Name; Office 365 - MS Teams - Given Name; Office 365 - SharePoint - Given Name
People	Last Service Date	The date when this person last received a service. It can be set manually, or if left blank, it is auto-calculated based on service (engagement) history.	No	Date and Time		TrackMaster - Services and Activities - Date
People	LinkedIn	LinkedIn profile.	No	Single line of text		MCommunity - Web Links
People	Mailing Address	Full mailing address.	No	Single line of text		MCommunity - Addresses (1st); Active Directory; Office 365 - SharePoint
People	MCommunity Role	The type of record in MCommunity, if any.	No	Choice	Alumni Faculty and Staff Retiree Sponsored Affiliate Student Graduate Student None	MCommunity - Affiliations
People	Michigan Experts	Michigan Experts Profile ID or URL.	No	Single line of text		MCommunity - Web Links; Medical School Data Warehouse - Michigan Research Experts
People	Mobile Phone	Mobile phone number.	No	Single line of text		MCommunity - Phones (2nd)
People	Modified	The date when this record was last updated.	No	Date and Time
People	Modified By	The last person or account who updated this record.	No	Person or Group
People	Notes	Additional notes, comments, links, or important remarks.	No	Multiple lines of text
People	ORCiD	Open Researcher and Contributor ID (ORCiD) or URL.	No	Single line of text		MCommunity - Web Links; Medical School Data Warehouse - Michigan Research Experts
People	Population Focus	The population focus for this investigator, from the center's pre-defined taxonomy.	No	Managed Metadata	Adolescents - Teens American Indian - Native American - Alaska Native Asian - Asian American Athletes Black - African American Children - Infants College Students Hispanic - Latinx Immigrants - Refugees - Undocumented Migrants Low Income - Socioeconomically Disadvantaged Low Literacy - Numeracy Maternal - Perinatal - Postpartum Men Menopausal - Postmenopausal Middle Eastern Middle Eastern - North African - Arab American Military Service Members and Veterans Non-Human Animal Studies Older Adults Pacific Islander Persons with Disabilities Rural Populations Schools - Students - K-12 Sexual and Gender Minorities - LGBTQIA+ Underserved Urban Populations Veterans Women Workforce / Behavioral Health Professionals Workforce / Employees Workforce / Healthcare Professionals Workforce / Interns Workforce / Migrant Farm Workers Workforce / Shift Workers
People	Preferred Email (Override)	Preferred email address. Only needed for External Contacts or to manually override an @umich.edu address.	No	Single line of text
People	Primary PI	The primary principal investigator that this study team member works under. For PIs, leave this field blank.	No	Lookup		TrackMaster - People - Department
People	Primary Team Engagement	For team members, this is their primary team. For all other contacts, this is the team that maintains the relationship with this person, if applicable.	No	Lookup		TrackMaster - Teams - Department
People	Referral Source	The person, core, team, vendor or website that referred this person to the center. Typically this would be the first core or team that provided a service to this person.	No	Single line of text
People	Research Area Focus	The research area focus for this investigator, from the center's pre-defined taxonomy.	No	Managed Metadata	Aging and Life Course Alzheimer's Disease - Dementia - Neurocognitive Disorders Anxiety Disorders Artificial Intelligence - Machine Learning Attention Deficit Hyperactivity Disorder - Attention Deficit Disorder Behavioral Health Integration - Collaborative Care Bioinformatics Biomarkers Bipolar Disorders Circadian Biology Computational Psychiatry Digital Health Eating Disorders Emotion Epidemiology Genomics Grief and Bereavement Health Informatics Learning Disabilities - Developmental Delays Mental Health Disparities and Equity Mental Health Implementation Science Mental Health Program Evaluation Natural Language Processing Obsessive Compulsive Disorders Other Pain Personality and Personality Disorders Postpartum Depression Precision Health Quality Improvement Resilience - Psychological Well-Being Schizophrenia - Psychosis - Psychotic Disorders School Mental Health Sleep - Sleep Disorders Social Determinants of Health Substance Abuse - Substance Misuse - Addiction Suicide and Suicide Prevention Telehealth Trauma and Stress-Related Disorders Treatment-Resistant Depression Workplace Mental Health - Burnout Medical Comorbodities / Cancer - Psycho-Oncology Medical Comorbodities / Cardiovascular Conditions Medical Comorbodities / Diabetes Medical Comorbodities / Stroke Mental Health Policy / Access to Care Mental Health Policy / Delivery and Utilization of Care Mental Health Policy / Equity and Disparities in Health and Healthcare Mental Health Policy / Health Insurance and Payment - Financing Mental Health Policy / Integrative Care and Treatment Mental Health Policy / Prevention Mental Health Policy / Promotion Mental Health Policy / Quality Mental Health Treatments - Interventions / Adaptive Interventions Mental Health Treatments - Interventions / Brain Stimulation Therapies - Neuromodulation Mental Health Treatments - Interventions / Chronic Disease Management Mental Health Treatments - Interventions / Cognitive Behavioral Therapy Mental Health Treatments - Interventions / Community-Based Interventions Mental Health Treatments - Interventions / Exposure-Based Behavioral Therapies Mental Health Treatments - Interventions / Mindfulness Mental Health Treatments - Interventions / Peer-Based Interventions Mental Health Treatments - Interventions / Pharmacology Mental Health Treatments - Interventions / Psychosocial Intervention Mental Health Treatments - Interventions / Public Health Campaigns Mental Health Treatments - Interventions / Self-Management - Self-Help Mental Health Treatments - Interventions / Training Mental Health Treatments - Interventions / Treatment Development Mental Health Treatments - Interventions / Treatment Response Neurobiology - Neuroscience / Behavioral and Systems Neurobiology - Neuroscience / Clinical Neurobiology - Neuroscience / Cognitive Neurobiology - Neuroscience / Computational Neurobiology - Neuroscience / Developmental Neurobiology - Neuroscience / Molecular and Cellular Neurobiology - Neuroscience / Sensory Prevention - Early Detection / Screening and Assessments
People	Research Methodologies and Applications	The research methodology and applications focus for this investigator, from the center's pre-defined taxonomy.	No	Managed Metadata	Causal Inference Community-Based Participatory Research (CBPR) Computational Biology Ecological Momentary Assessment Ethnography Just-in-time Adaptive Interventions (JITAI) Magnetic Resonance Imaging (MRI) / Other Imaging Mixed Methods Research Mobile Technologies and Other Digital Health Other Research Methodologies Program Evaluation Artificial Intelligence and Machine Learning / Natural Language Processing Artificial Intelligence and Machine Learning / Neural Networks Qualitative Research Methods / Day Reconstruction Qualitative Research Methods / Diary Studies Qualitative Research Methods / Dyad Interviewing Qualitative Research Methods / Focus Groups Qualitative Research Methods / Individual Interviewing Qualitative Research Methods / Micro-Randomized Trials (MRT) Qualitative Research Methods / Observational Studies Qualitative Research Methods / Quantitative Research Methods Qualitative Research Methods / Randomized Control Trials (RCT) Qualitative Research Methods / Randomized Trial Designs Qualitative Research Methods / Secondary Data Qualitative Research Methods / Sequential Multiple Assignment Randomized Trials (SMART) Qualitative Research Methods / Survey Measurement Qualitative Research Methods / Survey Tool Design
People	School Affiliation	Primary U-M School affiliation, or P2P school, if applicable.	No	Choice	Ann Arbor Open A2 Virtual+ Academy Akron-Fairgrove Jr & Sr High School Architecture and Urban Planning Art and Design Beach Middle School Bedford High School Cardiovascular Center Caro High School Cass City High School Center for Health Communications Research Chariho High School Chariho Middle School Chelsea High School Clague Middle School College for Business - Dearborn College of Arts, Sciences and Education - Flint College of Arts, Sciences, and Letters - Dearborn College of Education, Health, and Human Services - Dearborn College of Engineering College of Engineering and Computer Science - Dearborn College of Health Sciences - Flint College of Innovation and Technology - Flint College of Pharmacy Community High School Cranbrook Upper School Creekside Intermediate School Dearborn High School Dexter High School Dexter International Academy Early College Alliance (ECA) Edsel Ford High School Fordson High School Forsythe Middle School Gerald R. Ford School of Public Policy Grosse Pointe North Harvest Elementary School Heritage School Huron High School Institute for Healthcare Policy and Innovation Institute for Research on Women and Gender Institute for Social Research Law School Life Sciences Institute Lincoln High School Lincoln Middle School Literature, Sciences, and the Arts Marsal Family School of Education Medical School Mercy High School Michigan Islamic Academy Milan High School Milan Middle School Mill Creek Middle School Millcreek Middle School Narragansett High School Office of Research - Innovation Partnerships Okemos High School Ossining Communities That Care Pioneer High School Rackham School of Graduate Studies Reese High School Rye High School Saline High School Scarlett Middle School School for Environment and Sustainability School of Business School of Dentistry School of Information School of Kinesiology School of Management - Flint School of Music Theatre and Dance School of Nursing School of Nursing - Flint School of Public Health School of Social Work Skyline High School Slauson Middle School South Kingstown High School Stout Middle School Tappan Middle School TC East Middle School The Kinkaid School Unionville-Sebewaing Area High School University of Detroit Jesuit High School and Academy Washtenaw Alliance for Virtual Education (WAVE) Washtenaw International High School (WIHI) Washtenaw International High School (WIHS) Washtenaw International Middle Academy (WIMA) Washtenaw Technical Middle College Woodworth Middle School Ypsilanti Achieving College & Career Education Program (Ypsilanti ACCE) Ypsilanti Community High School Ypsilanti Community Middle School Other	MCommunity - Departments (1st college/school)
People	Scopus	Scopus ID (for researchers).	No	Single line of text		MCommunity - Web Links; Medical School Data Warehouse - Michigan Research Experts
People	State/Province	State, province, or district.	No	Choice	Alabama Alaska Alberta American Samoa Arizona Arkansas British Columbia California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Manitoba Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada Newfoundland and Labrador New Brunswick New Hampshire New Jersey New Mexico New York North Carolina North Dakota Northwest Territories Nova Scotia Nunavut Ohio Oklahoma Ontario Oregon Pennsylvania Puerto Rico Prince Edward Island Rhode Island Quebec Saskatchewan South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Yukon
People	Teams Account	The MS Teams account for this person, if applicable. Only accounts on the same environment as TrackMaster can be used (e.g. Michigan Medicine).	No	Person or Group		Active Directory; Office 365 - MS Teams; Office 365 - SharePoint
People	UniqName	U-M UniqName (user id), or email address for non-UM contacts.	Yes	Single line of text
People	Website	Link to this person's professional website or lab website. For members, this value is typically displayed in member profile pages.	No	Hyperlink or Picture		MCommunity - Web Links
People	X (Twitter)	A link to this person's X (Twitter) profile. You can enter the full URL (e.g. https://twitter.com/catygo_sleep) or just the @ name (e.g. @cathygo_sleep).	No	Single line of text		MCommunity - Web Links
People	📷	URL to profile picture, either from a file attached to this item or from an allowed domain (dc.org, umich.edu, AWS). When set, this picture takes prescedence over MS Teams and MCommunity profile pictures in certain places, such as the Full Name field (which is formatted to display a picture next to the name).	No	Single line of text		MCommunity - Custom Photo; Office 365 - MS Teams - User Photo
Programs and Offerings	Attachments	Relevant attachments (any file type).	No	Attachments
Programs and Offerings	Created	The date when this record was created.	No	Date and Time
Programs and Offerings	Created By	The person or account who created this record (author).	No	Person or Group
Programs and Offerings	Description	A short description of the program or offering.	No	Multiple lines of text
Programs and Offerings	Documents	Link to the document library or shared drive for this program or offering.	No	Hyperlink or Picture
Programs and Offerings	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Programs and Offerings	Modified	The date when this record was last updated.	No	Date and Time
Programs and Offerings	Modified By	The last person or account who updated this record.	No	Person or Group
Programs and Offerings	Primary Team	The team that is primarily responsible for executing the program.	No	Lookup		TrackMaster - Teams - Department
Programs and Offerings	Program Manager	The person responsible for the success of this program.	No	Lookup		TrackMaster - People - Department
Programs and Offerings	Title	Program name or title of the offering.	Yes	Single line of text
Programs and Offerings	Webpage	A link to the program's public webpage.	No	Hyperlink or Picture
Publicity	Attachments	Relevant attachments (any file type).	No	Attachments
Publicity	Created	The date when this record was created.	No	Date and Time
Publicity	Created By	The person or account who created this record (author).	No	Person or Group
Publicity	Date of Promotion	The date when this work was first promoted by the center.	No	Date and Time
Publicity	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Publicity	Modified	The date when this record was last updated.	No	Date and Time
Publicity	Modified By	The last person or account who updated this record.	No	Person or Group
Publicity	Notes	Additional notes, comments, links, or important remarks.	No	Multiple lines of text
Publicity	Program	If applicable, the program or offering related to this promotion.	No	Lookup		TrackMaster - Programs and Offerings - Department
Publicity	Promotion Channel	The channel(s) used for promoting this piece.	No	Choice	De-Brief In Focus Facebook LinkedIn Michigan IT News Michigan Medicine Headlines X (Twitter) Other
Publicity	Researcher	The primary investigator or co-investigators of the study, publication or project that is being promoted. If there are several co-investigators, create this entry with the one PI first, then right click on this item and run the automation to duplicate it for the other co-investigators.	Yes	Lookup		TrackMaster - People - Department
Publicity	Researcher Email	The e-mail address of the investigator (automatic).	No	Lookup		TrackMaster - People - Email
Publicity	Researcher Job Title	The job title of the investigator (automatic).	No	Lookup		TrackMaster - People - Job Title
Publicity	Researcher UniqName	The UniqName of the investigator (automatic).	No	Lookup		TrackMaster - People - UniqName
Publicity	Short Link	The short link used during promotions and campaigns.	No	Hyperlink or Picture
Publicity	Title	The title of the study, publication, funding, grant, event, innovation or other accomplishment that is being promoted.	Yes	Single line of text
Referrals	Assignee	The person in the referred-to team who has been assigned to follow up on this referral.	No	Person or Group
Referrals	Attachments	Relevant attachments (any file type).	No	Attachments
Referrals	Client	The person who is being referred from one team/core to another.	Yes	Lookup		TrackMaster - People - Department
Referrals	Client Job Title	The job title of the person who is being referred (automatic).	No	Lookup		TrackMaster - People - Job Title
Referrals	Created	The date when this record was created.	No	Date and Time
Referrals	Created By	The person or account who created this record (author).	No	Person or Group
Referrals	External Referral To	Person to whom this external referral was sent (use only for external referrals outside the center).	No	Lookup		TrackMaster - People - Department
Referrals	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Referrals	Modified	The date when this record was last updated.	No	Date and Time
Referrals	Modified By	The last person or account who updated this record.	No	Person or Group
Referrals	Notes	Enter a detailed description of the referral, or notes for the team who is receiving the referral.	No	Multiple lines of text
Referrals	Referral Purpose	Enter a one-sentence summary of the referral.	Yes	Single line of text
Referrals	Referral Status	The current status of this referral.	Yes	Choice	Open In Progress Consultation Scheduled Completed Cancelled
Referrals	Referred By	The team who made the referral.	No	Lookup		TrackMaster - Teams - Department
Referrals	Referred To	The team to whom the referral was made.	No	Lookup		TrackMaster - Teams - Department
Service Types	Attachments	Relevant attachments (any file type).	No	Attachments
Service Types	Created	The date when this record was created.	No	Date and Time
Service Types	Created By	The person or account who created this record (author).	No	Person or Group
Service Types	Description	A short summary or description of this service.	No	Multiple lines of text
Service Types	hiddenProgram	System field used for propagating information to other lists through backend automations. Do not edit manually.	No	Single line of text		TrackMaster - Programs and Offerings
Service Types	hiddenProvidedBy	System field used for propagating information to other lists through backend automations. Do not edit manually.	No	Single line of text		TrackMaster - Programs and Offerings
Service Types	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Service Types	Modified	The date when this record was last updated.	No	Date and Time
Service Types	Modified By	The last person or account who updated this record.	No	Person or Group
Service Types	Program	The program or offering to which this service type belongs, for reporting purposes. The team responsible for the implementation of that program will be used as the team who provides this type of service.	No	Lookup		TrackMaster - Programs and Offerings - Department
Service Types	Provided By	The Team or Core who normally provides this service.	Yes	Lookup		TrackMaster - Teams - Department
Service Types	Service Name	The name of the service provided to members or other stakeholders.	Yes	Single line of text
Services and Activities	Attachments	Relevant attachments (any file type).	No	Attachments
Services and Activities	Calendar Year	The year when this service was provided.	No	Calculated
Services and Activities	Created	The date when this record was created.	No	Date and Time
Services and Activities	Created By	The person or account who created this record (author).	No	Person or Group
Services and Activities	Date	The date when either: a service was provided; a consultation meeting was held; email was received; or long-running activity started.	Yes	Date and Time
Services and Activities	Fiscal Year	The fiscal year when this service was provided (7/1 - 6/30).	No	Calculated
Services and Activities	Follow Up Deadline	If a follow up is required, this date is a reminder of when to follow up.	No	Date and Time
Services and Activities	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Services and Activities	Modified	The date when this record was last updated.	No	Date and Time
Services and Activities	Modified By	The last person or account who updated this record.	No	Person or Group
Services and Activities	Notebook Link	Link to OneNote Notebook, Google Docs, etc.	No	Multiple lines of text
Services and Activities	Notes	Additional notes, comments, links, or important remarks.	No	Multiple lines of text
Services and Activities	Program	The program to which this service belongs, for reporting purposes.	No	Lookup		TrackMaster - Service Types - hiddenProgram
Services and Activities	Project PI	The Primary Investigator or Co-Investigators of the study or project. Investigators do not need to be present at the time of service.	No	Lookup		TrackMaster - People - Department
Services and Activities	Recipients	The persons who received this service or consultation.	Yes	Lookup		TrackMaster - People - Department
Services and Activities	Recipients:Last Service Date	The date when the recipient of this service last received any services (automatic). Used for automation purposes only. Do not update manually.	No	Lookup		TrackMaster - People - Last Service Date
Services and Activities	Service Type	The type of service that the client/member received.	Yes	Lookup		TrackMaster - Service Types - Department
Services and Activities	Team	The team who provided this service.	No	Lookup		TrackMaster - Service Types - hiddenProvidedBy
Services and Activities	Title (Optional)	(Optional) A quick one-line summary of how the member or customer engaged with us. If left empty, this field is auto-populated with the service type and recipients after saving. This field is only used for making search results more readable.	No	Single line of text
Shared Digital Assets Tracker	Attachments	Relevant attachments (any file type).	No	Attachments
Shared Digital Assets Tracker	Created	The date when this record was created.	No	Date and Time
Shared Digital Assets Tracker	Created By	The person or account who created this record (author).	No	Person or Group
Shared Digital Assets Tracker	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Shared Digital Assets Tracker	Location	The URL, email, or network path.	No	Hyperlink or Picture
Shared Digital Assets Tracker	Modified	The date when this record was last updated.	No	Date and Time
Shared Digital Assets Tracker	Modified By	The last person or account who updated this record.	No	Person or Group
Shared Digital Assets Tracker	Next Renewal Date	The date when this asset or subscription must be renewed, if applicable.	No	Date and Time
Shared Digital Assets Tracker	Notes	Additional notes, comments, links, or important remarks.	No	Multiple lines of text
Shared Digital Assets Tracker	Owner	The team who owns or maintains this digital asset.	Yes	Lookup		TrackMaster - Teams - Department
Shared Digital Assets Tracker	Renewal Link	Link that can be used for renewing this digital asset, if applicable.	No	Hyperlink or Picture
Shared Digital Assets Tracker	Title	Name or short description of this digital asset.	Yes	Single line of text
Teams	Active	Indicates whether this record is active (enabled). Inactive records are hidden by default, and are not used in any automations.	No	Yes/No
Teams	Attachments	Relevant attachments (any file type).	No	Attachments
Teams	Created	The date when this record was created.	No	Date and Time
Teams	Created By	The person or account who created this record (author).	No	Person or Group
Teams	Description	A short description of the team.	No	Single line of text
Teams	Faculty Leads	The faculty lead (or co-leads) for this team, if applicable.	No	Lookup		TrackMaster - People - Department
Teams	GitHub	A link to this team's GitHub or GitLab repo. You can enter the full URL (e.g. https://github.com/DepressionCenter) or just the @ name (e.g. @DepressionCenter).	No	Hyperlink or Picture
Teams	ID	Numeric identifier for this item. The ID field is a system-generated primary key that cannot be changed.	No	Counter
Teams	MCommunity Group	The MCommunity group email address, if applicable (e.g. efdc-mtc@umich.edu).	No	Single line of text
Teams	Modified	The date when this record was last updated.	No	Date and Time
Teams	Modified By	The last person or account who updated this record.	No	Person or Group
Teams	Shared Drive	Link to this team's shared drive (e.g. Google Drive, OneDrive, Dropbox, SharePoint Library).	No	Hyperlink or Picture
Teams	Slack	A link to this team's Slack workspace.	No	Hyperlink or Picture
Teams	Team Calendar	A link to this team's calendar.	No	Hyperlink or Picture
Teams	Team Leader	The primary lead for this team or core (required). Used for some email notifications and automations.	Yes	Lookup		TrackMaster - People - Department
Teams	Team Leader Email	The email address of the primary lead for this team or core. Used for automations.	No	Lookup		TrackMaster - People - Email
Teams	Team Member Accounts	MS Teams accounts of the members of this team, if available. This field is kept separate from the Team Members field because not all team members may have a Michigan Medicine (U-M level-2) login.	No	Person or Group
Teams	Team Members	List of team members (must be in People list as well). This field is kept separate from the Team Member Accounts field because not all team members may have a Michigan Medicine (U-M level-2) login.	No	Lookup		TrackMaster - People - Department
Teams	Team Name	The name of this team. This field is shown in referrals and reports.	Yes	Single line of text
Teams	Teams Account	The Microsoft Teams account for this team.	No	Person or Group
Teams	Web Page	Link to the team's web page.	No	Hyperlink or Picture

Notes

The complete TrackMaster Data Dictionary is available in Excel format. This spreadsheet contains more detailed information about each field, and can be used in scripts to automate the creation of SharePoint lists.

TrackMaster-Data-Dictionary.xlsx

Resources

Navigating TrackMaster: Menus and Main Components

About the Author

Gabriel Mongefranco is a Mobile Data Architect at the University of Michigan's Eisenberg Family Depression Center. Gabriel has over a decade of experience with automation, data analytics, database architecture, dashboard design, software development, and technical writing. He supports U-M researchers with data cleaning, data pipelines, automation and enterprise architecture for wearables and other mobile technologies.

| | |

0 reviews

Print Article

Updating...