Repository Response Details

The Repository Response Details view object stores the response details to questions from the question library.

Data Store Key : FscmTopModelAM.PrcExtractAM.PoqBiccExtractAM.RepositoryResponseExtractPVO

Primary Keys : ResponseRepositoryId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AcceptanceDate Indicates the date when the response to the question was accepted.
AcceptanceNote Indicates the note entered by acceptor at the time of acceptance.
AcceptedBy Indicates the person who accepted the qualification response.
BatchId Indicates the batch from the response repository interface row.
CreatedBy User who created the response to question.
CreationDate Date and time when the application created the response to question.
DataSourceId Stores the identifier of document from the source system such as Bid Number, Questionnaire Response ID, Profile Identifier driving profile change, and Supplier Registration Identifier.
DataSourceType Indicates the source system that captured the response from supplier.
FirstSubmissionDate Indicates the first time the response got submitted by responder.
InternalRespondentId Value that uniquely identifies the internal responder.
LastUpdateDate Date when the question response was last updated.
LastUpdateLogin Session login associated with the user who last updated the repository response value.
LastUpdatedBy User who last updated the question response value.
MergeRequestId Value that uniquely identifies the merge request ID.
ObjectVersionNumber Value that identifies the number of times the question response has been updated.
OriginalQuestionId Indicates the original question for the question revision for which this is a response.
QuestionId Value that uniquely identifies the question in question library.
RequestId Indicates the request ID of the job that created or last updated the response repository row.
ResponderType Indicates whether the response responder is a supplier or an internal user.
ResponseArchiveDate Date when this response got archived because a new response got entered in the repository.
ResponseComments Indicates the text of a manually entered response comments value.
ResponseRepositoryId Value that uniquely identifies the question response.
ResponseStatus Indicates the status of the response to a question.
ResponseSubmissionDate Date response to a question is submitted by responder.
SupplierContactPartyId Value that uniquely identifies the contact person for a supplier or supplier site.
SupplierId Value that uniquely identifies the supplier responding to a question.
SupplierSiteId Value that uniquely identifies the supplier site on the response.
SurrogEnteredBy Indicates the person entering a response on behalf of a supplier or an internal responder.
SurrogEntryDate Indicates the date on which qualification manager submitted the response. The date will be left empty for the nonsurrogate response.
SurrogResponseFlag Indicates if a response is a surrogate response entered by qualification manager on behalf of a supplier or an internal responder.