Requester Colums Headings IMS.xlsx

	A	B	C
1	Column Heading RQS requester IMS	Description	How used/entered

2	Additional Note	Additional comment when changing status on RQS	When changing status on a RQS record, this note is optional.
3	Alternative Email	Secondary email	Added by hand if desired by the coordinator
4	Assignee	Coordinator that the RQS record is assigned to	System-assigned upon seeker/registrant zipcode
5	Baha’i ID	Baha'I ID of member who filled out the on-line forms	System or hand entered by coordinator
6	Cell Phone	cell phone of seeker or registrant	System
7	City (Residential)	the city where the seeker resides	System
8	City of Birth	City of Birth for requester	Hand entered by coordinator
9	Cluster	Cluster code	System
10	Cluster Name	Cluster name	System
11	Community Type (Locality) (Business Unit)	LSA or RGP Registered Baha'i group	System
12	Confirmation Message	When deleting this is a Comment box message that pops up to confirm	hand entered by coordinator
13	Countersign Person IDN	Countersign for Registrations BID number	System
14	Country of Birth	Country of birth for seeker or registrant	Hand entered for seeker, but system entered for registrant (mandatory on registration form).
15	Created By	System name or name of the coordinator who created the RQS# record	System or coordinator
16	Created On	When the RQS record was created	System
17	Date of Birth	Date of birth for seeker or registrant	Entered by coordinator or system when registrant: Mandatory for registration form
18	Date of Permission Given	Date permission given by parent registering their child	System
19	Declaration Date	Date of declaration for registrant	System
20	Estimated Age Range	Junior Youth (12-14), Youth (15-30), Adult (31+)	Hand entered by coordinator
21	Ethnicity	Ethnicity	Hand entered by coordinator. Optional on Registration form.
22	First Name	Seeker or registrant first name only	System or hand entered if coordinator is creating a new Requester
23	Full Address (Residential)	Includes the mailing address if available, or just city, state, and zip.	System
24	Full Name	Name of requester along with the RQS# I.D. number	System
25	Gender	gender of registrant	System: Mandatory on registration form
26	Historical Seeker Response System Data	Historical SRS data if requester record was mapped over from SRS	System
27	Home Phone	Home phone number of requester	System or hand entered by coordinator
28	IDN	RQS# I.D. number	System
29	Important Note	Comment field on RQS record	Hand entered by the coordinator
30	Is Draft	Is this RQS record a draft? Yes or no.	When a coordinator hand enters a requester you have an option to save the form as a draft until completed.
31	Last Interaction	Date and time of the last interaction	hand entered by coordinator and System updated
32	Last Name	Seeker or registrant last name only	System or hand entered if coordinator is creating a new Requester
33	Locality	BLC code for the locality	System
34	Locality Name	Spelled out locality name	System
35	Mailing City	Mailing address CITY spelled out	System
36	Mailing Full Address	Mailing FULL ADDRESS: either full mailing address or just city, state, zip code. This is the same as the resdential address if a different mailing address is not specified.	System
37	Mailing State	Mailing address STATE initials	System
38	Mailing Zip Code	Mailing address ZIP CODE	System
39	Merged Date/Time	Date and time records wwere merged	System
40	Merged With	Hyperlinked records that were merged with this record.	System
41	Middle Name	Middle name of requester	System adds or hand entered by coordinator
42	Modified On	Date the RQS record was last modified/changed	System updates this
43	Most Recent Inquiry Comment	Displays the most recent inquiry comment by the requester	System updates this when the requester fills out a contact form and leaves a comment
44	Nickname	Nick Name of requester	System adds or hand entered by coordinator
45	Origination Date	When the first inquiry record came into the database	System
46	Other Ethnicity	Other ethnicity of requester	System or hand entered by coordinator. This is optional on the registration form
47	Other Language	Other language of seeker or registrant	Hand entered by coordinator
48	Parent Member	BID of parent member who is registering their child	System
49	Parent Requester	Name of parent who is registering their child	System
50	Permission Note	Permission note for child registration	System
51	Preferred Contact Method	Email or phone: Preferred contact method for seeker or registrant	System or hand entered by coordinator
52	Preferred Language	Preferred laguage of seeker or registrant	Hand entered by coordinator
53	Primary Email	Primary email of seker or registrant	System: can be edited by coordinator
54	Race	Race of seeker or registrant	Hand entered by coordinator. Optional on Registration form.
55	Region	Region where seeker or registrant resides.	System
56	Reminder Date/Time (Current Reminder) (Reminder)	Future reminder to take action on this requester record	Hand created by the coordinator
57	Requester Type	Seeker or registrant	System
58	Seeker ID	SRS Old database seeker ID	System
59	Social Media Link	Social media link for the Requester	Hand entered by the coordinator
60	Source	Bahai.us, Bahaiteachings.org, Mobile App, 1-800-22-UNITE: Source where the seeker filled out the contact form, or if hand entered by IQS memeber for the 800-UNITE calls.	System or National Inquiry Services member.
61	Source Details	Source Details	Hand entered by coordinator: 800-UNITE, or Mobile App, name of local responder
62	Stage of Growth (Cluster) (Business Unit)	Milestone	System
63	State	Active or Inactive-state of the RQS record	System- when RQS records are Archived, they become 'Inactive'
64	State (Residential)	State where the requester resides	System
65	State of Birth	State of birth of requester	Entered by hand by coordinator
66	Status	Status of the RQS# record: New, One-Off, Unreachable, Do Not Contact, Approached, In Conversation, Paused, Needs Verification, Verified, Enrolled, On Hold, Archive, For Review, One-off Request, Still Seeking, Declared, Possible Member	Some are assigned by the system, some are automated changes when an interaction is added to the inquiry for this requester, some are changed by hand by the coordinator. Some apply to only seeker, and some only for registrant records.
67	Status Details	Bad Address, Burial/End of Life, Busy Right Now, Completed, Conversation Scheduled, Currently Enrolled, Data Entry Error, Disconnected Phone, Do Not Enroll, Duplicate, Email, Hate Call, Home Visit, House of Worship, In Conversation, In-Person Meeting, Interfaith, Lost Interest, Making Resource Uncomfortable, Media, Minor Requires Parental Permission, Missing Required Data, Moving Out Of Area, Needs Time, New, No Further Follow-up Required, Not In USA, Other, Passed to Department Selection, Pending Enrollment with LSA, Pending Enrollment with Membership, Phone Call, Possible Transfer, Prank, Sensitive Country Relationship, Test Data, Text Message, Unresponsive, Withdrawn, Wrong Email, Wrong Phone Number, Participated in Activity, Hosting Activity, Virtual Meeting, Teaching Campaign, Mail, Comment Only, Scheduling Conflicts, School, Property, Removed from LSA, Removed by LSA	Hand assigned by the coordinator.
68	Suffix	Jr, Sr, I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII, XIII, XIV	System or hand entered by coordinator
69	Title	Mr, Ms, Miss, Mrs, Dr, Hon	System or hand entered by coordinator
70	Type of Permission	Type of permission for child registration: Relative	System
71	Website Link	Website of requester	Hand entered by coordinator
72	Work Phone	Work phone of the requester	System or hand entered
73	Zip Code (Residential)	Zip code for where the requester resides	System
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