QuestionnaireResponses
Manages supplier or compliance questionnaire responses, collecting details for audits, qualifications, and due diligence.
Columns
| Name | Type | Description |
| QuestionnaireRespHeaderId [KEY] | Long | The unique identifier for the questionnaire response header, linking the response to a specific questionnaire. Example: 1001 for Questionnaire Response Header 1001. |
| InitiativeId | Long | The unique identifier for the initiative associated with the questionnaire response, linking the response to a specific initiative. Example: 2001 for Initiative 2001. |
| QuestnaireId | Long | The unique identifier for the questionnaire to which the response belongs. Example: 3001 for Questionnaire ID 3001. |
| QuestionnaireTypeCode | String | The code representing the type of the questionnaire, categorizing the nature of the questionnaire. Example: 'SURVEY' for a survey type questionnaire. |
| QuestionnaireType | String | The full name or description of the questionnaire type, helping to identify its purpose. Example: 'Supplier Feedback' or 'Internal Assessment'. |
| QuestionnaireUsageCode | String | The code representing how the questionnaire is used within the organization, such as for feedback or evaluation. Example: 'FEEDBACK' for a feedback questionnaire. |
| QuestionnaireUsage | String | The description of how the questionnaire is used within the organization. Example: 'For supplier performance evaluation'. |
| ProcurementBUId | Long | The unique identifier for the procurement business unit (BU) associated with the questionnaire response, linking the response to a specific business unit. Example: 4001 for 'Procurement Unit A'. |
| ProcurementBU | String | The name of the procurement business unit associated with the questionnaire response. Example: 'Global Procurement'. |
| ResponseStatusCode | String | The code representing the status of the questionnaire response, indicating its current stage or condition. Example: 'COMPLETED' for a fully submitted response. |
| ResponseStatus | String | The description of the response status, providing more detail on the stage or state of the response. Example: 'Completed' or 'Pending'. |
| Introduction | String | The introductory text or instructions provided at the beginning of the questionnaire. Example: 'Please fill out the following feedback survey'. |
| SupplierId | Long | The unique identifier for the supplier associated with the questionnaire response, linking the response to a specific supplier. Example: 5001 for 'Supplier ABC'. |
| SupplierName | String | The name of the supplier associated with the questionnaire response. Example: 'ABC Supplies'. |
| SupplierSiteId | Long | The unique identifier for the supplier site related to the questionnaire response, indicating the specific location of the supplier. Example: 6001 for 'Main Warehouse'. |
| SupplierSiteName | String | The name of the supplier site associated with the questionnaire response. Example: 'Warehouse 1'. |
| SupplierContactPartyId | Long | The unique identifier for the supplier contact party, linking the response to the specific person or entity. Example: 7001 for 'John Doe'. |
| SupplierContactPartyName | String | The name of the supplier contact party associated with the questionnaire response. Example: 'John Doe'. |
| InternalRespondentId | Long | The unique identifier for the internal respondent who filled out the questionnaire. Example: 8001 for 'Jane Smith'. |
| InternalResponderName | String | The name of the internal respondent who completed the questionnaire. Example: 'Jane Smith'. |
| InitiativeSuppContactId | Long | The unique identifier for the contact party for the initiative, linking the response to the specific person responsible for the initiative. Example: 9001 for 'Robert Brown'. |
| InitiativeSupplierContactName | String | The name of the contact person for the initiative supplier. Example: 'Robert Brown'. |
| SubmissionDate | Datetime | The date and time when the questionnaire response was submitted. Example: '2023-06-01 10:00:00' for a response submitted on June 1, 2023. |
| SubmittedBy | Long | The unique identifier for the user who submitted the questionnaire response. Example: 1002 for 'Alice Johnson'. |
| SubmittedByName | String | The name of the user who submitted the questionnaire response. Example: 'Alice Johnson'. |
| SurrogResponseFlag | Bool | Indicates whether the response was submitted on behalf of someone else (surrogate response). Example: True if submitted by a proxy. |
| SurrogEntryDate | Datetime | The date when the surrogate response was entered. Example: '2023-06-01 10:30:00' for the entry time of the surrogate response. |
| SurrogEnteredBy | Long | The unique identifier for the person who entered the surrogate response. Example: 1010 for 'Michael Scott'. |
| SurrogateEnteredByName | String | The name of the person who entered the surrogate response. Example: 'Michael Scott'. |
| AcceptanceDate | Datetime | The date when the questionnaire response was accepted. Example: '2023-06-02 11:00:00' for when the response was formally accepted. |
| AcceptedBy | Long | The unique identifier for the person who accepted the questionnaire response. Example: 1020 for 'Sarah Lee'. |
| AcceptedByName | String | The name of the person who accepted the questionnaire response. Example: 'Sarah Lee'. |
| AcceptanceNote | String | Any additional notes or comments provided when accepting the response. Example: 'Response validated and accepted.' |
| CanceledDate | Datetime | The date when the questionnaire response was canceled. Example: '2023-06-03 14:00:00' for when the cancellation was recorded. |
| CanceledBy | Long | The unique identifier for the person who canceled the questionnaire response. Example: 1030 for 'David Green'. |
| CanceledByName | String | The name of the person who canceled the questionnaire response. Example: 'David Green'. |
| CanceledReasonCode | String | The code representing the reason for canceling the response. Example: 'INVALID' for an invalid response. |
| CanceledReasonUserText | String | The user-provided reason for canceling the response. Example: 'Response data was corrupted'. |
| ReturnedDate | Datetime | The date when the questionnaire response was returned. Example: '2023-06-04 15:00:00' for when the response was returned by the respondent. |
| ReturnedBy | Long | The unique identifier for the person who returned the questionnaire response. Example: 1040 for 'Emma White'. |
| ReturnedByName | String | The name of the person who returned the questionnaire response. Example: 'Emma White'. |
| ReturnMessageContent | String | The content of the message provided when returning the questionnaire response. Example: 'Please revise and resubmit the response'. |
| RequestErrorReason | String | The reason for any error encountered during the request process for the questionnaire. Example: 'System Timeout' or 'Invalid Input'. |
| RecentNotificationFlag | Bool | Indicates whether the questionnaire response has been recently notified. Example: True if the response was recently notified to the relevant stakeholders. |
| MergeRequestId | Long | The unique identifier for the merge request associated with the questionnaire response, if the response is part of a merge process. Example: 1050 for Merge Request 1050. |
| CloseDate | Datetime | The date when the questionnaire response was closed. Example: '2023-06-05 16:00:00' for when the response was closed. |
| ClosedBy | Long | The unique identifier for the person who closed the questionnaire response. Example: 1060 for 'James Clark'. |
| ClosedByName | String | The name of the person who closed the questionnaire response. Example: 'James Clark'. |
| AcceptanceProcessedStage | String | The stage at which the acceptance of the questionnaire response was processed. Example: 'INITIAL_REVIEW' for the initial review stage. |
| AcceptanceRecoveredCode | String | The code indicating the recovery status of the acceptance. Example: 'RECOVERED' if the acceptance process was completed after initial failure. |
| AcceptanceInstanceId | Long | The unique identifier for the instance of acceptance for the questionnaire response. Example: 1070 for 'Acceptance Instance 1070'. |
| RecoveredBy | Long | The unique identifier for the person who recovered or resolved the questionnaire response acceptance issue. Example: 1080 for 'Laura Adams'. |
| RecoveredDate | Datetime | The date when the questionnaire response acceptance was successfully recovered. Example: '2023-06-06 17:00:00' for the recovery date. |
| Finder | String | A reference or placeholder used for searching and locating specific questionnaire response records within the system. Example: 'Search by Response Status'. |