bi_SurveyResults

Updated May 21, 2026 14:14

Field Name	Field Description	Data Type	FK Join
Id	Id	int
Respondent	Respondent	nvarchar
RespondentPhone	Respondent Phone	nvarchar
RespondentEmail	Respondent Email	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
SurveyResponseDate	Survey Response Date	datetime
TransactionId	Transaction Id	int
TransType	Transaction Type	int
Transac	Transaction	nvarchar
WONumber	WONumber	nvarchar
ProjectNumber	Project Number	nvarchar
ClassID	Class ID	nvarchar
IsProject	Indicates if the survery results record is from a project	int
Question	Question	nvarchar
QuestionType	Question Type	varchar
QuestionTypeNumeric	Question Type Numeric	int
YesNo	Indicates if the answer is yes or no	smallint
PassFail	Indicates if the result passed or failed	smallint
Comment	Comment	nvarchar
Value	Value	int
Answer	Answer	nvarchar
NumericAnswer	Numeric Answer	int
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterCode	Repair Center Code	nvarchar
RequestorName	Requestor Name	nvarchar
QuestionId	Question Id	int
QuestionPageFieldId	Question Page Field Id	int