SRS - Data Dictionary

Modified on Wed, 8 Mar, 2023 at 9:36 AM

TABLE OF CONTENTS

SRS_Membership_History
SRS_Indv_Demographics
SRS_Indv_Membership

SRS_Membership_History

Name	Data Type	Description
Amount	Numeric	Amount they spent for membership
Dual_Member	Boolean	Was part of a dual member join/renew
ID	VarChar	iMIS ID of related Contact
Member_Status	NVarChar	Status of the member at the time of join/renewal
Member_Type	NVarChar	Type of membership at the time of join/renewal
Membership_Year	Integer	Membership year at the time of join/renewal
Membership_Year_End	DBTimeStamp	Full date of the membership year at the time of join/renewal
Multi_Year_Number	Integer	If they purchase a 2 year subscription this will be populated the term under for that years membership
Paid_Date	DBTimeStamp	Date that the membership was purchased on
Product_Code	NVarChar	Identifier used to determine what type of membership was purchased

SRS_Indv_Demographics

Name	Data Type	Description
ID	VarChar	iMIS ID of related Contact
Events_Suggestions	NVarChar	Suggestions for the SRS
Gender_Identity	NVarChar	Gender
Gender_Write_In	NVarChar	Additional field for Gender where they write it in
Race_Ethnicity	NVarChar	Race
Race_Write_In	NVarChar	Additional field for Race where they write it in
Sexual_Orientation	NVarChar	Sexual Orientation
Sexual_Orientation_Write_In	NVarChar	Additional field for Sexual Orientation where they write it in

SRS_Indv_Membership

Name	Data Type	Description
ID	VarChar	iMIS ID of related Contact
Dual_Eligible	Boolean	Are they eligible for dual membership
Emeritus_Verification_Date	DBTimeStamp	Date that contact was confirmed for Emeritus status
Emeritus_Verification_Status	NVarChar	Status that contact was confirmed for Emeritus status
Membership_Documentation	NVarChar	Documentation that contact was confirmed for Membership status
SRS_Member_Status	NVarChar	Current Member status, New/Renewed
Student_Verification_Date	DBTimeStamp	Date that contact was confirmed for Student status
Student_Verification_Status	NVarChar	Status that contact was confirmed for Student status
Student_Verification_Upload	VarBinary	File uploaded for Student Verification