Assessment Details
The Assessment Details view object contains details about assessments based on a qualification model for the supplier or supplier site.
Data Store Key : FscmTopModelAM.PrcExtractAM.PoqBiccExtractAM.AssessmentExtractPVO
Primary Keys : AssessmentId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AssessmentComments | Indicates the text value of manually added assessment comments. |
| AssessmentId | Value that uniquely identifies the assessment. |
| AssessmentName | Indicates the assessment name associated with the qualification model name. |
| AssessmentNumber | Indicates the assessment number assigned to the assessment. |
| AssessmentOutcome | Indicates the outcome assigned to the assessment. |
| AssessmentScore | Indicates the calculated score of the assessment. |
| Attribute1 | A segment for the assessment descriptive flexfield |
| Attribute10 | A segment for the assessment descriptive flexfield |
| Attribute11 | A segment for the assessment descriptive flexfield |
| Attribute12 | A segment for the assessment descriptive flexfield |
| Attribute13 | A segment for the assessment descriptive flexfield |
| Attribute14 | A segment for the assessment descriptive flexfield |
| Attribute15 | A segment for the assessment descriptive flexfield |
| Attribute16 | A segment for the assessment descriptive flexfield |
| Attribute17 | A segment for the assessment descriptive flexfield |
| Attribute18 | A segment for the assessment descriptive flexfield |
| Attribute19 | A segment for the assessment descriptive flexfield |
| Attribute2 | A segment for the assessment descriptive flexfield |
| Attribute20 | A segment for the assessment descriptive flexfield |
| Attribute3 | A segment for the assessment descriptive flexfield |
| Attribute4 | A segment for the assessment descriptive flexfield |
| Attribute5 | A segment for the assessment descriptive flexfield |
| Attribute6 | A segment for the assessment descriptive flexfield |
| Attribute7 | A segment for the assessment descriptive flexfield |
| Attribute8 | A segment for the assessment descriptive flexfield |
| Attribute9 | A segment for the assessment descriptive flexfield |
| AttributeCategory | The structure definition of the user descriptive flexfield. |
| AttributeDate1 | Date segment for the assessment descriptive flexfield. |
| AttributeDate10 | Date segment for the assessment descriptive flexfield. |
| AttributeDate2 | Date segment for the assessment descriptive flexfield. |
| AttributeDate3 | Date segment for the assessment descriptive flexfield. |
| AttributeDate4 | Date segment for the assessment descriptive flexfield. |
| AttributeDate5 | Date segment for the assessment descriptive flexfield. |
| AttributeDate6 | Date segment for the assessment descriptive flexfield. |
| AttributeDate7 | Date segment for the assessment descriptive flexfield. |
| AttributeDate8 | Date segment for the assessment descriptive flexfield. |
| AttributeDate9 | Date segment for the assessment descriptive flexfield. |
| AttributeNumber1 | Number segment for the assessment descriptive flexfield |
| AttributeNumber10 | Number segment for the assessment descriptive flexfield |
| AttributeNumber2 | Number segment for the assessment descriptive flexfield |
| AttributeNumber3 | Number segment for the assessment descriptive flexfield |
| AttributeNumber4 | Number segment for the assessment descriptive flexfield |
| AttributeNumber5 | Number segment for the assessment descriptive flexfield |
| AttributeNumber6 | Number segment for the assessment descriptive flexfield |
| AttributeNumber7 | Number segment for the assessment descriptive flexfield |
| AttributeNumber8 | Number segment for the assessment descriptive flexfield |
| AttributeNumber9 | Number segment for the assessment descriptive flexfield |
| AttributeTimestamp1 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp10 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp6 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp7 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp8 | Date and time segment for the assessment descriptive flexfield. |
| AttributeTimestamp9 | Date and time segment for the assessment descriptive flexfield. |
| AutoEvaluatedFlag | Indicates whether the assessment was automatically evaluated. |
| CanceledBy | Value that identifies the user who canceled the assessment. |
| CanceledDate | Indicates the date on which the assessment is canceled. |
| CanceledReasonCode | Indicates the reason for cancellation of the assessment. |
| CompletedDate | Indicates the date on which the assessment is finalized. |
| CreatedBy | User who created the assessment record. |
| CreationDate | Date and time when the application created the assessment record. |
| CreationSource | Indicates the creation source of the assessment. |
| EffectiveEndDate | Indicates the date at the end of the date range within which the assessment row is effective. |
| EffectiveStartDate | Indicates the date at the beginning of the date range within which the assessment row is effective. |
| EvalReadyDate | Indicates the date on which the assessment goes into ready for evaluation status. |
| EvaluatedBy | Value that identifies the evaluator. |
| EvaluationDate | Indicates the date on which the evaluation for the assessment took place. |
| EvaluationDueDate | Indicates the assessment evaluation due date. |
| ExpirationReminderPeriod | Indicates the value of the expiration reminder duration. |
| ExpirationReminderType | Indicates the type of expiration reminder duration. |
| InitiativeId | Value that uniquely identifies an initiative corresponding to the assessment. |
| JobDefinitionName | Indicates the name of the job that created or last updated the row. |
| JobDefinitionPackage | Indicates the package name of the job that created or last updated the row. |
| LastUpdateDate | Date when the assessment was last updated. |
| LastUpdateLogin | Session login associated with the user who last updated the assessment. |
| LastUpdatedBy | User who last updated the assessment. |
| LatestFlag | Indicates if the assessment is the latest one for a given supplier, site, procurement business unit and qualification area across revision. |
| MergeRequestId | Value that uniquely identifies the merge request from supplier merge requests table. |
| NoteToSupplier | Indicates the note to supplier. |
| ObjectVersionNumber | Number of times the assessment has been updated. |
| OrigAssessmentOutcome | Indicates the original calculated outcome of the assessment. |
| OrigAssessmentScore | Indicates the original calculated score of the assessment. |
| OverrideDate | Indicates the time when the assessment score was overridden. |
| OverrideReason | Indicates the reason behind overriding a assessment outcome. |
| OverridenBy | Value that uniquely identifies the user who has overridden the assessment score. |
| OwnerId | Value that uniquely identifies the assessment owner. |
| PrcBuId | Value that uniquely identifies the procurement business unit in which the assessment is created. |
| QualModelId | Value that uniquely identifies the qualification model. |
| ReassessExecutedFlag | Indicates whether or not the assessment has started the reassessment process. |
| ReassessQualificationFlag | Indicates whether or not to reassess the assessment based upon a new active qualification. |
| ReassessRequestId | Value that uniquely identifies the request of the job that created the assessment. |
| RequestId | Indicates the request ID of the job that created or last updated the assessment row. |
| SendIntQnnaireFlag | Indicates whether the questionnaire is sent to the internal responder or not. |
| SendSuppQnnaireFlag | Indicating whether the questionnaire is sent to the supplier contact or not. |
| ShowAssessmentQualFlag | Indicates whether or not to display the qualifications on the assessment to the supplier. |
| ShowAssessmtToSuppFlag | Indicates whether or not to display the assessment to the supplier. |
| SourcingEligibilityCode | Indicates the sourcing eligibility value for the assessment. |
| Status | Indicates the status assigned to the assessment. |
| SuppContactPartyId | Value that uniquely identifies the supplier contact on assessment. |
| SupplierId | Value that uniquely identifies the Supplier who's being assessed. |
| SupplierSiteId | Value that uniquely identifies the supplier site associated with the assessment. |