Response Repository Business Classification Details

The Response Repository Business Classification Details view object stores the response details to a question mapped to suppliers' business classification.

Data Store Key : FscmTopModelAM.PrcExtractAM.PoqBiccExtractAM.ResponseReposBusClassExtractPVO

Primary Keys : RespReposBusClassId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
CertificateNumber Certificate number of the certificate granted to the supplier for the classification.
CertifyingAgencyId Value that uniquely Identifies the certifying agency that granted the business classification certificate to the supplier.
ClassificationCode Indicates the lookup code for the business classification type.
ClassificationId Indicates the classification identifier on the POZ_BUS_CLASSIFICATIONS table.
ConfirmedOn Indicates the date on which the classification row is last updated.
CreatedBy User who created the response for business classification information.
CreationDate Date and time when the application created the response for business classification information.
ExpirationDate Indicates the Expiration date of the certificate.
ExtAttr1 This attribute is used to store some relevant information related to the row. For example, this column is used to store the minority type for the minority owned business classification.
LastUpdateDate Date when the business classification response was last updated.
LastUpdateLogin Session login associated with the user who last updated the business classification response value.
LastUpdatedBy User who last updated the business classification response value.
Notes Indicates any additional information regarding the classification.
ObjectVersionNumber Value that identifies the number of times the business classification response value has been updated.
OtherCertifyingAgency Field to capture other certifying agencies apart from those in the list.
PozVersionNumber Indicates the value of the object version number on the corresponding POZ_BUS_CLASSIFICATIONS row.
ProvidedByContactId Value that uniquely Identifies the supplier contact who has provided the classification information.
RespReposBusClassId Value that uniquely identifies response repository business classification.
ResponseRepositoryId Value that uniquely Identifies the response repository row.
StartDate Indicates the start date of the business classification certificate.